lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/Dresses/DressManagement/FrmPreselection.cs

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.DressManagement
{
    public partial class FrmPreselection : LYFZ.Software.UI.Dresses.DressManagement.FrmPreselection
    {
        public List<string> list = new List<string>();
        private delegate void UpdateControl();
        bool bl = false;
        public string Dsfm_DressNumber;
        public string PreselectedNumber;
        public FrmPreselection()
        {
            this.FormClosed += FrmPreselection_FormClosed;
            this.ucPagerEx1.EventPaging += ucPagerEx1_EventPaging;
        }

        void FrmPreselection_FormClosed(object sender, FormClosedEventArgs e)
        {
            if (bl)
            {
                this.DialogResult = DialogResult.OK;
            }
        }

        #region 加载
        protected override void FrmPreselection_Shown(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.HidePhoneControls(this.txtCus_Telephone);
            LYFZ.BLL.BLL_ErpDressFrom DressFromBll = new BLL.BLL_ErpDressFrom();
            DataTable dt = new DataTable();
            txtDsro_HandledName.Text = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Name;
            txtDsro_CreateDateTime.Text = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime().ToString("yyyy-MM-dd");

            #region 获取单号
            BindDsro_Number();
            #endregion

            #region 获取礼服资料
            if (!string.IsNullOrEmpty(Dsfm_DressNumber))
            {
                string[] Dsfm_DressNumbers = Dsfm_DressNumber.Split(',');
                for (int t = 0; t < Dsfm_DressNumbers.Length; t++)
                {
                    dt = DressFromBll.View_tb_ErpDressFrom(" and Dsfm_DressNumber='" + Dsfm_DressNumbers[t] + "'").Tables[0];

                    #region
                    DataGridViewRow dgvr = new DataGridViewRow();
                    DataGridViewCell cell = null;

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

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

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

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

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

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

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


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

            #region 部门人员绑定
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_DepartmentAndEmployee(this.txtDsro_CreateName, IsFirstNodeNull: true);
            //LYFZ.BLL.BLL_ErpDepartment BLLerpdepartment = new BLL.BLL_ErpDepartment();
            //DataTable tbl = BLLerpdepartment.GetAllList().Tables[0];
            //if (tbl.Rows.Count > 0)
            //{
            //    TreeNode root = null;

            //    for (int i = 0; i < tbl.Rows.Count; i++)
            //    {
            //        root = new TreeNode(tbl.Rows[i]["Dt_Name"].ToString());
            //        this.CreateTreeViewDepartmentUser(root.Nodes, tbl.Rows[i]["ID"].ToString());
            //        this.txtDsro_CreateName.TreeView.Nodes.Add(root);
            //    }
            //}
            #endregion

            Bind();
        }

        #region 获取礼服订单单号
        /// <summary>
        /// 获取礼服订单单号
        /// </summary>
        public void BindDsro_Number()
        {
            DataTable dt = new DataTable();
            //获取最大编号
            LYFZ.BLL.BLL_ErpDressSaleRentalOrder DressSaleRentalOrderbll = new BLL.BLL_ErpDressSaleRentalOrder();
            dt = DressSaleRentalOrderbll.GetAllList().Tables[0];
            if (dt.Rows.Count > 0)
            {
                int Count = Convert.ToInt32(DressSaleRentalOrderbll.Get_Max_Dsro_Number());
                this.txtDsro_Number.Text = "LFDH00" + Convert.ToInt32(Count + 1);
            }
            else
            {

                this.txtDsro_Number.Text = "LFDH001";
            }
        }
        #endregion

        #region 获取已预选衣服
        /// <summary>
        /// 获取已预选衣服
        /// </summary>
        public void Bind()
        {
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.PageSize = 15;
            this.ucPagerEx1.Bind();
        }
        #endregion

        #endregion

        #region 输入框设置
        protected override void txtCus_Telephone_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            {
                e.Handled = true;
            }
        }

        protected override void txtDsro_MortgageAmount_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsPunctuation(e.KeyChar) && !Char.IsControl(e.KeyChar))
            {
                e.Handled = true;　//获取或设置一个值，指示是否处理过System.Windows.Forms.Control.KeyPress事件
            }
            else if (Char.IsPunctuation(e.KeyChar))
            {
                if (e.KeyChar == '.')
                {
                    if (((System.Windows.Forms.TextBox)sender).Text.LastIndexOf('.') != -1)
                    {
                        e.Handled = true;
                    }
                }
                else
                {
                    e.Handled = true;
                }
            }
        }

        protected override void txtDsro_Amount_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsPunctuation(e.KeyChar) && !Char.IsControl(e.KeyChar))
            {
                e.Handled = true;　//获取或设置一个值，指示是否处理过System.Windows.Forms.Control.KeyPress事件
            }
            else if (Char.IsPunctuation(e.KeyChar))
            {
                if (e.KeyChar == '.')
                {
                    if (((System.Windows.Forms.TextBox)sender).Text.LastIndexOf('.') != -1)
                    {
                        e.Handled = true;
                    }
                }
                else
                {
                    e.Handled = true;
                }
            }
        }
        #endregion

        #region 预选保存
        protected override void btnPreselection_Click(object sender, EventArgs e)
        {
            try
            {
                LYFZ.BLL.BLL_ErpDressSaleRentalOrder DressSaleRentalOrderBll = new BLL.BLL_ErpDressSaleRentalOrder();
                LYFZ.Model.Model_ErpDressSaleRentalOrder DressSaleRentalOrderModel = new Model.Model_ErpDressSaleRentalOrder();
                LYFZ.BLL.BLL_ErpDressSaleRentalDetail DressSaleRentalDetailBll = new BLL.BLL_ErpDressSaleRentalDetail();
                LYFZ.Model.Model_ErpDressSaleRentalDetail DressSaleRentalDetailModel = new Model.Model_ErpDressSaleRentalDetail();
                if (dgv2.SelectedRows.Count == 0)
                {
                    #region 判断输入框不能为空
                    if (string.IsNullOrEmpty(txtDsro_Number.Text))
                    {
                        MessageBoxCustom.Show("单号不能为空！");
                        return;
                    }
                    if (DressSaleRentalOrderBll.Exists("Dsro_Number", this.txtDsro_Number.Text) == true)
                    {
                        MessageBoxCustom.Show("单号已经存在！");
                        BindDsro_Number();
                        return;
                    }
                    if (dgv.Rows.Count == 0)
                    {
                        MessageBoxCustom.Show("礼服资料不能为空！请选择礼服！");
                        return;
                    }
                    if (string.IsNullOrEmpty(txtCus_Name.Text))
                    {
                        MessageBoxCustom.Show("客户名称不能为空！");
                        return;
                    }
                    if (string.IsNullOrEmpty(txtCus_Telephone.Text))
                    {
                        MessageBoxCustom.Show("客户电话不能为空！");
                        return;
                    }
                    if (txtCus_Telephone.Text.Length != 11)
                    {
                        MessageBoxCustom.Show("客户电话号码必须为11位数！");
                        return;
                    }
                    if (string.IsNullOrEmpty(txtDsro_CreateName.Text.Trim()))
                    {
                        MessageBoxCustom.Show("销售人员不能为空！");
                        return;
                    }
                    #endregion

                    #region 增加礼服租售订单表
                    DressSaleRentalOrderModel.Dsro_Number = txtDsro_Number.Text.Trim();
                    DressSaleRentalOrderModel.Dsro_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetLocalCompanyInfoID();
                    DressSaleRentalOrderModel.Dsro_Type = "2";
                    DressSaleRentalOrderModel.Dsro_Amount = 0;
                    DressSaleRentalOrderModel.Dsro_MortgageAmount = 0;
                    DressSaleRentalOrderModel.Dsro_CreateDateTime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
                    DressSaleRentalOrderModel.Dsro_CreateName = txtDsro_CreateName.Tag.ToString();
                    DressSaleRentalOrderModel.Dsro_HandledName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                    #region 增加客户编号
                    if (txtCus_Name.ReadOnly == true)
                    {
                        DressSaleRentalOrderModel.Dsro_CustomerNumber = txtCus_CustomerNumber.Text.Trim();
                    }
                    else
                    {
                        LYFZ.Model.Model_ErpCustomer model = new Model.Model_ErpCustomer();
                        LYFZ.BLL.BLL_ErpCustomer bll = new BLL.BLL_ErpCustomer();

                        #region 增加

                        #region 手机存在
                        if (!string.IsNullOrEmpty(txtCus_Telephone.Text))
                        {
                            if (bll.Exists("Cus_Telephone", txtCus_Telephone.Text) == true)
                            {
                                MessageBoxCustom.Show("客户手机已经存在");
                                return;
                            }
                        }
                        #endregion

                        model.Cus_CustomerNumber = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime().ToString("yyyyMMddHHmmssfff") + "1";//获取新编号
                        model.Cus_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetLocalCompanyInfoID();
                        model.Cus_CustomizeNumber = "";
                        model.Cus_Type = "订单客户";
                        model.Cus_ServiceType = "Clothing";
                        model.Cus_Name = this.txtCus_Name.Text.ToString().Trim();
                        model.Cus_Telephone = this.txtCus_Telephone.Text.ToString().Trim();

                        model.Cus_CreateDateTime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
                        model.Cus_CreateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                        bll.Add(model);
                        #endregion
                        DressSaleRentalOrderModel.Dsro_CustomerNumber = model.Cus_CustomerNumber;
                    }
                    #endregion
                    DressSaleRentalOrderBll.Add(DressSaleRentalOrderModel);
                    #endregion

                    #region 租售礼服详情表
                    if (dgv.Rows.Count > 0)
                    {
                        for (int i = 0; i < dgv.Rows.Count; i++)
                        {
                            DressSaleRentalDetailModel.Dsrd_Number = DressSaleRentalOrderModel.Dsro_Number;
                            DressSaleRentalDetailModel.Dsrd_DressNumber = dgv.Rows[i].Cells["Dsfm_DressNumber"].Value.ToString();
                            DressSaleRentalDetailModel.Dsrd_DressName = dgv.Rows[i].Cells["Dsfm_DressName"].Value.ToString();
                            DressSaleRentalDetailModel.Dsrd_SaleRentalQuantity = Convert.ToInt32(dgv.Rows[i].Cells["Dsfm_DressQuantity"].Value);
                            DressSaleRentalDetailModel.Dsrd_CostPrice = Convert.ToDecimal(dgv.Rows[i].Cells["Dsfm_CostPrice"].Value);
                            DressSaleRentalDetailModel.Dsrd_SalePrice = Convert.ToDecimal(dgv.Rows[i].Cells["Dsfm_SalePrice"].Value);
                            DressSaleRentalDetailModel.Dsrd_CreateDateTime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
                            DressSaleRentalDetailModel.Dsrd_CreateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                            DressSaleRentalDetailModel.Dsrd_BackTime = Convert.ToDateTime(null);
                            DressSaleRentalDetailModel.Dsrd_BackStatus = "3";
                            DressSaleRentalDetailModel.Dsrd_BackRemark = "";
                            DressSaleRentalDetailBll.Add(DressSaleRentalDetailModel);
                        }
                    }
                    #endregion

                    MessageBoxCustom.Show("保存成功！");
                    bl = true;
                    this.Close();
                }
                else
                {
                    MessageBoxCustom.Show("不能修改！");
                }
            }
            catch (Exception ex)
            {
                MessageBoxCustom.Show(ex.Message);
            }
        }
        #endregion

        #region dgv事件
        protected override void dgv_Click(object sender, EventArgs e)
        {
            if (dgv.Rows.Count > 0)
            {
                LYFZ.BLL.BLL_ErpDressFrom DressFromBll = new BLL.BLL_ErpDressFrom();
                DataTable dt = new DataTable();
                string Dsfm_DressNumber = dgv.CurrentRow.Cells["Dsfm_DressNumber"].Value.ToString();
                dt = DressFromBll.View_tb_ErpDressFrom(" and Dsfm_DressNumber='" + Dsfm_DressNumber + "'").Tables[0];
                if (dt.Rows.Count > 0)
                {
                    string dressFromPath = BLL.BLL_ErpDressFrom.GetDressFromPath() + "\\" + dt.Rows[0]["Dsfm_PicturePath"];
                    if (System.IO.File.Exists(dressFromPath))
                    {
                        picDsfm_PicturePath.Image = Image.FromFile(dressFromPath);
                    }
                }


            }
        }
        #endregion

        #region 客户选择
        protected override void btnCusSelect_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.Dresses.DressManagement.FrmCusSelect set = new FrmCusSelect();
            set.ShowDialog();
            if (!string.IsNullOrEmpty(set.StrClientNumber))
            {
                LYFZ.BLL.BLL_ErpCustomer CustomerBll = new BLL.BLL_ErpCustomer();
                DataTable dt = CustomerBll.View_tb_ErpCustomer(" and Cus_CustomerNumber='" + set.StrClientNumber + "'").Tables[0];
                if (dt.Rows.Count > 0)
                {
                    txtCus_Name.Text = "";
                    txtCus_Name.ReadOnly = true;
                    txtCus_Telephone.Text = "";
                    txtCus_Telephone.ReadOnly = true;
                    txtCus_CustomerNumber.Text = "";

                    txtCus_Name.Text = dt.Rows[0]["Cus_Name"].ToString();
                    txtCus_Telephone.Text = dt.Rows[0]["Cus_Telephone"].ToString();
                    txtCus_CustomerNumber.Text = dt.Rows[0]["Cus_CustomerNumber"].ToString();
                }
            }
        }
        #endregion

        #region 清空
        protected override void btnclear_Click(object sender, EventArgs e)
        {
            #region 获取单号
            BindDsro_Number();
            #endregion

            txtDsro_Number.Text = "";
            txtCus_Name.Text = "";
            txtCus_Telephone.Text = "";
            txtDsro_HandledName.Text = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Name;
            txtDsro_CreateDateTime.Text = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime().ToString();
            txtCus_CustomerNumber.Text = "";
            dgv.Rows.Clear();
            dgv2.ClearSelection();
        }
        #endregion

        #region 关闭
        protected override void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        #endregion

        #region 画分页
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx1_EventPaging(UCPager.EventPagingArg e)
        {
            dgv2.Rows.Clear();
            LYFZ.BLL.BLL_ErpDressFrom DressFrombll = new BLL.BLL_ErpDressFrom();
            DataTable dt = new DataTable();
            StringBuilder sql = new StringBuilder();
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            if (!string.IsNullOrEmpty(txtkeyword.Text))
            {

                sql.Append(" 1=1 and (Dsro_Number like '%" + txtkeyword.Text.Trim() + "%' or Cus_Name like '%" + txtkeyword.Text.Trim() + "%' or Cus_Telephone like '%" + txtkeyword.Text.Trim() + "%') and Dsro_Type='2'");
            }
            else
            {
                sql.Append(" 1=1 and Dsro_Type='2'");
            }
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                pageData.TableName = "View_DressSaleRentalOrder";
                pageData.PageIndex = this.ucPagerEx1.PageCurrent;
                pageData.PageSize = this.ucPagerEx1.PageSize;
                pageData.QueryCondition = sql.ToString();
                pageData.QueryFieldName = "ID,Dsro_Number,Dsro_Amount,Dsro_MortgageAmount,Dsro_CustomerNumber,Dsro_CreateDateTime,Dsro_CreateName,Cus_Name,Cus_Telephone,开单人姓名,经手人";
                pageData.OrderStr = "ID desc";
                pageData.OrderType = 1;
                DataSet da = pageData.QueryDataTable();
                dt = da.Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        #region 获取预选衣服
                        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]["ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Dsro_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 = dt.Rows[t]["Cus_Telephone"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["开单人姓名"].ToString().Trim();
                            dgvr.Cells.Add(cell);

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

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

                            this.dgv2.Rows.Add(dgvr);
                            dgv2.ClearSelection();
                            #endregion
                        }
                        #endregion
                    }));
                }

            });
            try
            {
                this.ucPagerEx1.TbDataSource = dt;
            }
            catch { }
            return pageData.TotalCount;

        }

        #endregion

        #region 预选管理

        #region dgv选择事件
        protected override void dgv2_Click(object sender, EventArgs e)
        {
            try
            {

                if (dgv2.Rows.Count > 0)
                {
                    if (dgv2.SelectedRows.Count > 0)
                    {
                        LYFZ.BLL.BLL_ErpDressSaleRentalOrder DressSaleRentalOrderBll = new BLL.BLL_ErpDressSaleRentalOrder();
                        LYFZ.BLL.BLL_ErpDressSaleRentalDetail DressSaleRentalDetailBll = new BLL.BLL_ErpDressSaleRentalDetail();
                        LYFZ.BLL.BLL_ErpUser UserBll = new BLL.BLL_ErpUser();
                        LYFZ.BLL.BLL_ErpDressFrom DressFromBll = new BLL.BLL_ErpDressFrom();
                        DataTable dt = DressSaleRentalOrderBll.View_DressSaleRentalOrder(" and Dsro_Number='" + dgv2.CurrentRow.Cells["Dsro_Number"].Value.ToString() + "'").Tables[0];
                        if (dt.Rows.Count > 0)
                        {
                            #region  获取预选资料
                            txtDsro_Number.Text = dt.Rows[0]["Dsro_Number"].ToString();
                            txtCus_Name.Text = dt.Rows[0]["Cus_Name"].ToString();
                            txtCus_Telephone.Text = dt.Rows[0]["Cus_Telephone"].ToString();
                            txtDsro_CreateName.TagFindText(dt.Rows[0]["Dsro_CreateName"].ToString());
                            txtDsro_HandledName.Text = dt.Rows[0]["经手人"].ToString().Trim();
                            txtDsro_CreateDateTime.Text = Convert.ToDateTime(dt.Rows[0]["Dsro_CreateDateTime"]).ToString("yyyy-MM-dd");
                            txtCus_CustomerNumber.Text = dt.Rows[0]["Cus_CustomerNumber"].ToString();
                            #endregion

                            #region 礼服资料
                            dgv.Rows.Clear();
                            dt = DressSaleRentalDetailBll.View_DressSaleRentalDetail(" and Dsrd_Number='" + dgv2.CurrentRow.Cells["Dsro_Number"].Value.ToString() + "'").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_DressNumber"].ToString().Trim();
                                    dgvr.Cells.Add(cell);

                                    cell = new DataGridViewTextBoxCell();
                                    cell.Value = DressFromBll.GetDressTypeName(dt.Rows[t]["Dsrd_DressNumber"].ToString().Trim());
                                    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();
                                    dgvr.Cells.Add(cell);


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

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

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

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

                    }
                }
            }
            catch (Exception ex)
            {

                MessageBoxCustom.Show(ex.Message);
            }

        }
        #endregion

        #region 查询
        protected override void btnSlect_Click(object sender, EventArgs e)
        {
            try
            {
                txtCus_CustomerNumber.Text = "";
                txtCus_Name.Text = "";
                txtCus_Telephone.Text = "";
                txtDsro_CreateDateTime.Text = "";
                txtDsro_HandledName.Text = "";
                txtDsro_Number.Text = "";
                dgv.Rows.Clear();
                picDsfm_PicturePath.Image = null;
                Bind();
            }
            catch (Exception ex)
            {

                MessageBoxCustom.Show(ex.Message);
            }
        }
        #endregion

        #region 删除

        protected override void btnDelete_Click(object sender, EventArgs e)
        {
            try
            {

                if (this.dgv2.SelectedRows.Count == 0)
                {
                    MessageBoxCustom.Show("请选中你要删除的数据！");
                    return;
                }
                if (MessageBoxCustom.Show("你确定要删除吗？", "删除提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    LYFZ.BLL.BLL_ErpDressSaleRentalOrder bll = new BLL.BLL_ErpDressSaleRentalOrder();
                    string Dsro_Number = this.dgv2.CurrentRow.Cells["Dsro_Number"].Value.ToString();
                    if (bll.DeleteLf(Dsro_Number) == 1)
                    {
                        #region 写入操作日志
                        string logsContent = "删除预选礼服编号：" + Dsro_Number;
                        LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(LYFZ.EnumPublic.SystemLogsType.删除礼服, logsContent, LYFZ.BLL.BLL_ErpUser.UsersModel.User_EmployeeID, LYFZ.BLL.BLL_ErpUser.UsersModel.User_Name);
                        //LYFZ.BLL.BLL_ErpSystemLogs systemLogsBll = new BLL.BLL_ErpSystemLogs();
                        //LYFZ.Model.Model_ErpSystemLogs systemLogsModel = new Model.Model_ErpSystemLogs();
                        //systemLogsModel.Slogs_Type = "user";
                        //systemLogsModel.Slogs_Topic = "删除预选礼服";
                        //systemLogsModel.Slogs_Content = "删除预选礼服编号：" + Dsro_Number;
                        //systemLogsModel.Slogs_UserName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Name;
                        //systemLogsModel.Slogs_IP = "";
                        //systemLogsModel.Slogs_CreateDatetime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
                        //systemLogsModel.Slogs_CreateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                        //systemLogsBll.Add(systemLogsModel);
                        #endregion

                        MessageBoxCustom.Show("删除成功！");
                        txtCus_CustomerNumber.Text = "";
                        txtCus_Name.Text = "";
                        txtCus_Telephone.Text = "";
                        txtDsro_CreateDateTime.Text = "";
                        txtDsro_HandledName.Text = "";
                        txtDsro_Number.Text = "";
                        dgv.Rows.Clear();
                        picDsfm_PicturePath.Image = null;
                        Bind();
                    }
                    else { MessageBoxCustom.Show("删除失败！"); }
                }
            }
            catch (Exception ex)
            {

                MessageBoxCustom.Show(ex.Message);
            }
        }
        #endregion

        #region 选择
        protected override void btnChoose_Click(object sender, EventArgs e)
        {
            if (dgv2.SelectedRows.Count == 0)
            {
                MessageBoxCustom.Show("请选择预选订单！");
                return;
            }
            string Dsro_Number = dgv2.CurrentRow.Cells["Dsro_Number"].Value.ToString();
            LYFZ.BLL.BLL_ErpDressSaleRentalDetail bll = new BLL.BLL_ErpDressSaleRentalDetail();
            DataTable dt = bll.GetList(" Dsrd_Number='" + Dsro_Number + "'").Tables[0];
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    list.Add(dt.Rows[i]["Dsrd_DressNumber"].ToString());
                }

            }
            PreselectedNumber = Dsro_Number;
            this.Close();
        }
        #endregion
        #endregion

        #region 绑定第二级人员
        /// <summary>
        /// 绑定第二级人员
        /// </summary>
        /// <param name="nodes">TreeView的节点集合</param>
        /// <param name="dataSource">数据源</param>
        /// <param name="parentid"></param>
        private void CreateTreeViewDepartmentUser(TreeNodeCollection nodes, string ClassCode)
        {
            if (ClassCode != "")
            {
                LYFZ.BLL.BLL_ErpUser BLLerpuser = new BLL.BLL_ErpUser();
                DataTable tbl = BLLerpuser.GetList("User_Department='" + ClassCode + "' and id!='1' and User_Status='在职'").Tables[0];
                if (tbl.Rows.Count > 0)
                {
                    TreeNode node;
                    for (int i = 0; i < tbl.Rows.Count; i++)
                    {
                        node = new TreeNode();
                        node.Text = tbl.Rows[i]["User_Name"].ToString();
                        node.Tag = tbl.Rows[i]["User_EmployeeID"].ToString();
                        node.Name = tbl.Rows[i]["User_Account"].ToString();
                        nodes.Add(node);
                    }
                }
            }
        }
        #endregion

    }
}