lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/Dresses/DressView/FrmRecord.cs

using LYFZ.ComponentLibrary;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace LYFZ.Software.MainBusiness.Dresses.DressView
{
    public partial class FrmRecord : LYFZ.Software.UI.Dresses.DressView.FrmRecord
    {
        public string Number;
        public FrmRecord()
        {
           
        }

        #region 加载
        protected override void FrmRecord_Shown(object sender, EventArgs e)
        {
            WaitForm wf = new WaitForm();
            wf.ShowForm(this);
           
            try
            {
                bind();
                wf.CloseForm();
                wf = null;
            }
            catch 
            {

                wf.CloseForm();
                wf = null;
            }
        }
        public void bind()
        {
            if (!string.IsNullOrEmpty(Number))
            {
                dgv.Rows.Clear();

                #region 获取租售
                LYFZ.BLL.BLL_ErpDressSaleRentalDetail DressSaleRentalDetailBll = new BLL.BLL_ErpDressSaleRentalDetail();
                DataTable dt = new DataTable();
                if (radAll.Checked)
                {
                    dt = DressSaleRentalDetailBll.View_DressSaleRentalDetail(" and  Dsrd_DressNumber='" + Number + "' and (Dsro_Type='1'  or Dsro_Type='0' )").Tables[0];
                }
                else 
                {
                    dt = DressSaleRentalDetailBll.View_DressSaleRentalDetail(" and  Dsrd_DressNumber='" + Number + "' and (Dsro_Type='1'  or Dsro_Type='0' )  and Dsrd_BackStatus='3'").Tables[0];
                }
                if (dt.Rows.Count > 0)
                {
                    for (int t = 0; t < dt.Rows.Count; t++)
                    {
                        #region
                        DataGridViewRow dgvr = new DataGridViewRow();
                        DataGridViewCell cell = null;

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Dsrd_Number"].ToString().Trim();
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Cus_Name"].ToString().Trim();
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = Convert.ToDateTime(dt.Rows[t]["Dsro_TakeDressTime"].ToString().Trim()).ToString("yyyy-MM-dd");
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        if (dt.Rows[t]["Dsro_Type"].ToString().Trim() == "0")
                        {
                            cell.Value = Convert.ToDateTime(dt.Rows[t]["Dsro_ReservationBackTime"].ToString().Trim()).ToString("yyyy-MM-dd");
                        }
                        else { cell.Value = ""; }
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        if (dt.Rows[t]["Dsro_Type"].ToString().Trim() == "0")
                        {
                            cell.Value = "租";
                        }
                        if (dt.Rows[t]["Dsro_Type"].ToString().Trim() == "1")
                        {
                            cell.Value = "售";
                        }
                        dgvr.Cells.Add(cell);


                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Dsrd_DressName"].ToString().Trim();
                        dgvr.Cells.Add(cell);


                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Dsrd_SaleRentalQuantity"].ToString().Trim();
                        dgvr.Cells.Add(cell);


                        cell = new DataGridViewTextBoxCell();
                        if (dt.Rows[t]["Dsrd_BackStatus"].ToString().Trim() == "1")
                        {
                            cell.Value = "已还";
                        }
                        if (dt.Rows[t]["Dsrd_BackStatus"].ToString().Trim() == "3")
                        {
                            cell.Value = "未还";
                        }
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = Convert.ToDateTime(dt.Rows[t]["Dsrd_CreateDateTime"].ToString().Trim()).ToString("yyyy-MM-dd");
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        LYFZ.BLL.BLL_ErpUser UserBll = new BLL.BLL_ErpUser();
                        cell.Value = UserBll.GetUserName(dt.Rows[t]["Dsrd_CreateName"].ToString().Trim());
                        dgvr.Cells.Add(cell);

                        this.dgv.Rows.Add(dgvr);
                        #endregion
                    }

                    dgv.ClearSelection();
                }
                #endregion

                #region 获取送洗
                LYFZ.BLL.BLL_ErpDressSendWashDetail DressSendWashDetailBll = new BLL.BLL_ErpDressSendWashDetail();
                dt = new DataTable();
                if (radAll.Checked)
                {
                    dt = DressSendWashDetailBll.View_DressSendWashDetail(" and  Dswd_DressNumber='" + Number + "'").Tables[0];
                }
                else 
                {
                    dt = DressSendWashDetailBll.View_DressSendWashDetail(" and  Dswd_DressNumber='" + Number + "' and Dswd_BackStatus='3'").Tables[0];
                }
                if (dt.Rows.Count > 0)
                {
                    for (int t = 0; t < dt.Rows.Count; t++)
                    {
                        #region
                        DataGridViewRow dgvr = new DataGridViewRow();
                        DataGridViewCell cell = null;

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Dswo_Number"].ToString().Trim();
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = "";
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = Convert.ToDateTime(dt.Rows[t]["Dswo_SendWashTime"].ToString().Trim()).ToString("yyyy-MM-dd");
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = Convert.ToDateTime(dt.Rows[t]["Dswo_ReservationBackTime"].ToString().Trim()).ToString("yyyy-MM-dd");
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = "洗";
                        dgvr.Cells.Add(cell);


                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Dswd_DressName"].ToString().Trim();
                        dgvr.Cells.Add(cell);


                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Dswd_SendWashQuantity"].ToString().Trim();
                        dgvr.Cells.Add(cell);


                        cell = new DataGridViewTextBoxCell();
                        if (dt.Rows[t]["Dswd_BackStatus"].ToString().Trim() == "1")
                        {
                            cell.Value = "已还";
                        }
                        if (dt.Rows[t]["Dswd_BackStatus"].ToString().Trim() == "3")
                        {
                            cell.Value = "未还";
                        }
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = Convert.ToDateTime(dt.Rows[t]["Dswd_CreateDatetime"].ToString().Trim()).ToString("yyyy-MM-dd");
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        LYFZ.BLL.BLL_ErpUser UserBll = new BLL.BLL_ErpUser();
                        cell.Value = UserBll.GetUserName(dt.Rows[t]["Dswd_CreateName"].ToString().Trim());
                        dgvr.Cells.Add(cell);

                        this.dgv.Rows.Add(dgvr);
                        #endregion
                    }

                    dgv.ClearSelection();
                }
                #endregion

                lblCount.Text = dgv.Rows.Count.ToString();
            }
        }
        #endregion

        #region 未还
        protected override void radNotyet_Click(object sender, EventArgs e)
        {
            WaitForm wf = new WaitForm();
            wf.ShowForm(this);
            try
            {
                bind();
                wf.CloseForm();
                wf = null;
            }
            catch 
            {

                wf.CloseForm();
                wf = null;
            }
        }
        #endregion

        #region  全部
        protected override void radAll_Click(object sender, EventArgs e)
        {
            WaitForm wf = new WaitForm();
            wf.ShowForm(this);
            try
            {
                bind();
                wf.CloseForm();
                wf = null;
            }
            catch 
            {

                wf.CloseForm();
                wf = null;
            }
        }
        #endregion
    }
}