MES_Client/TGMES/Core.StlMes.Client.SaleBase/Form/FrmCustomerReborn.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.SaleBase.model;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
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 Core.StlMes.Client.SaleBase.Form
{
    /// <summary>
    /// 客户信息 重生版
    /// </summary>
    public partial class FrmCustomerReborn : FrmBase
    {
        public FrmCustomerReborn()
        {
            InitializeComponent();
            this.ComBelongsCity.AfterExpand += new TreeViewEventHandler(ComBelongsCity_AfterExpand);
            this.ComBelongsCity.AfterCollapse += new TreeViewEventHandler(ComBelongsCity_AfterCollapse);
            this.IsLoadUserView = true;
        }

        /// <summary>
        /// 省市区域代码
        /// </summary>
        string combelonCity = "";
        /// <summary>
        /// 州或国
        /// </summary>
        string combleTo = "";
        private void FrmCustomerReborn_Load(object sender, EventArgs e)
        {
            //修改GRID列的列名
            EntityHelper.ShowGridCaption<SlmBaseCustomerEntity>(gdCustomer.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<SlmBaseOrderUnitEntity>(gdOrderUnit.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<SlmBaseReceivUnitEntity>(gdReceiveUnit.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<SlmBaseCustomerListEntity>(gdCustomerList.DisplayLayout.Bands[0]);
            //加载界面所需数据
            LoadFormData();
        }

        private void LoadFormData()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.base.CoreCustomerReborn.queryBaseInfo", new Object[] { "1006" }, this.ob);
            cmbMarketSys.DataSource = dt;
            cmbMarketSys.DisplayMember = "BASENAME";
            cmbMarketSys.ValueMember = "BASECODE";
            DataTable dt1 = ServerHelper.GetData("com.steering.pss.sale.base.CoreCustomerReborn.queryBaseInfo", new Object[] { "1007" }, this.ob);
            cmbRegion.DataSource = dt1;
            cmbRegion.DisplayMember = "BASENAME";
            cmbRegion.ValueMember = "BASECODE";
            ClsBaseInfo.SetComboItemHeight(cmbMarketSys);
            ClsBaseInfo.SetComboItemHeight(cmbRegion);
            QueryTree();

            //初始化订结单位Tab页的内容
            //客户类别
            DataTable dt2 = ServerHelper.GetData("com.steering.pss.sale.base.CoreCustomerReborn.queryBaseInfo", new Object[] { "1003" }, this.ob);
            cmbCustomerType.DataSource = dt2;
            cmbCustomerType.DisplayMember = "BASENAME";
            cmbCustomerType.ValueMember = "BASECODE";
            //客户等级
            DataTable dt3 = ServerHelper.GetData("com.steering.pss.sale.base.CoreCustomerReborn.queryBaseInfo", new Object[] { "1005" }, this.ob);
            cmbCustoRating.DataSource = dt3;
            cmbCustoRating.DisplayMember = "BASENAME";
            cmbCustoRating.ValueMember = "BASECODE";
            //客户性质
            DataTable dt4 = ServerHelper.GetData("com.steering.pss.sale.base.CoreCustomerReborn.queryBaseInfo", new Object[] { "1004" }, this.ob);
            cmbCustoNature.DataSource = dt4;
            cmbCustoNature.DisplayMember = "BASENAME";
            cmbCustoNature.ValueMember = "BASECODE";
        }

        public void QueryTree()
        {
            this.ComBelongsCity.Nodes.Clear();
            DataTable dt = new DataTable();
            dt = ServerHelper.GetData("com.steering.pss.sale.base.CoreCustomerReborn.queryTivCode", new Object[] { }, this.ob);
            //树控件递归绑定方法。
            Bind_Tv(dt, ComBelongsCity.Nodes, null, "REGION_NO", "P_REGION_NO", "REGION_NM");
        }
        private void Bind_Tv(DataTable dt, TreeNodeCollection tnc, string pid_val, string id, string pid, string text)
        {
            DataView dv = new DataView(dt);//将DataTable存到DataView中，以便于筛选数据
            TreeNode tn;//建立TreeView的节点（TreeNode），以便将取出的数据添加到节点中
            //以下为三元运算符，如果父id为空，则为构建“父id字段 is null”的查询条件，否则构建“父id字段=父id字段值”的查询条件
            string filter = string.IsNullOrEmpty(pid_val) ? pid + " is null" : string.Format(pid + "='{0}'", pid_val);
            dv.RowFilter = filter;//利用DataView将数据进行筛选，选出相同 父id值 的数据
            foreach (DataRowView drv in dv)
            {
                tn = new TreeNode();//建立一个新节点
                tn.Tag = drv[id].ToString();//节点的Value值，一般为数据库的id值
                tn.Text = drv[text].ToString();//节点的Text，节点的文本显示 
                tn.Name = drv["REGION_LVL_NO"].ToString();//区域属性代码
                tn.ImageKey = drv["REGION_LVL_NM"].ToString();
                tn.StateImageKey = drv["BIGAREA"].ToString();
                if (!string.IsNullOrEmpty(drv["P_REGION_NO"].ToString()))
                {
                    tn.ToolTipText = drv["P_REGION_NO"].ToString();
                }
                else
                {
                    tn.ImageIndex = 0;
                }
                tnc.Add(tn);//将该节点加入到TreeNodeCollection（节点集合）中 
                Bind_Tv(dt, tn.Nodes, tn.Tag.ToString(), id, pid, text);//递归（反复调用这个方法，直到把数据取完为止）
            }
        }

        private void ComBelongsCity_DropDownClosed(object sender, EventArgs e)
        {
            this.cmbRegion.Value = this.ComBelongsCity.SelectedNode.StateImageKey;
        }

        private void txtCustomNm_ValueChanged(object sender, EventArgs e)
        {
            txtCustomPY.Text = ChineseWord.GetChineseSpell(txtCustomNm.Text.Trim());
        }

        void ComBelongsCity_AfterCollapse(object sender, TreeViewEventArgs e)
        {
            if (e.Node.ImageIndex == 1)
                e.Node.ImageIndex = e.Node.SelectedImageIndex = 0;
        }

        void ComBelongsCity_AfterExpand(object sender, TreeViewEventArgs e)
        {
            if (e.Node.ImageIndex == 0)
                e.Node.ImageIndex = e.Node.SelectedImageIndex = 1;
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    if (ultraTabControl1.ActiveTab.Key.Equals("Add"))
                    {
                        QueryCustomerInfo();
                    }
                    else if (ultraTabControl1.ActiveTab.Key.Equals("Query"))
                    {
                        QueryCustomerList();
                    }
                    break;
                case "Add":
                    AddCustomer();
                    break;
                case "Update":
                    UpdateCustomer();
                    break;
                case "Delete":
                    DeleteCustomer();
                    break;
                case "Export":
                    GridHelper.ulGridToExcel(gdCustomerList, "客户信息");
                    break;
                case "Close":
                    this.Close();
                    break;
                default:
                    break;
            }
        }
        /// <summary>
        /// 查询客户主信息
        /// </summary>
        private void QueryCustomerInfo()
        {
            string customerNm = txtCutormNm.Text.Trim();
            string saleOrg = ClsBaseInfo.GetListByValid(this.ValidDataPurviewIds)[0];
            if (UserInfo.GetUserName() == "admin")
                saleOrg = "100101";
            customerNm = customerNm.ToUpper();
            List<SlmBaseCustomerEntity> list = EntityHelper.GetData<SlmBaseCustomerEntity>(
                "com.steering.pss.sale.base.CoreCustomerReborn.queryCustomerInfo", new object[] { customerNm, saleOrg }, this.ob);
            slmBaseCustomerEntityBindingSource.DataSource = list;
        }

        private void AddCustomer()
        {
            switch (ultraTabControl2.ActiveTab.Key)
            {
                case "BI":
                    AddCustomerBaseInfo();
                    break;
                case "DJ":
                    AddCustomerOrderUnit();
                    break;
                case "SH":
                    AddCustomerReceiveUnit();
                    break;
                default:
                    break;
            }
        }

        private void UpdateCustomer()
        {
            switch (ultraTabControl2.ActiveTab.Key)
            {
                case "BI":
                    UpdateCustomerBaseInfo();
                    break;
                case "DJ":
                    UpdateCustomerOrderUnit();
                    break;
                case "SH":
                    UpdateCustomerReceiveUnit();
                    break;
                default:
                    break;
            }
        }

        private void DeleteCustomer()
        {
            switch (ultraTabControl2.ActiveTab.Key)
            {
                case "BI":
                    DeleteCustomerBaseInfo();
                    break;
                case "DJ":
                    DeleteCustomerOrderUnit();
                    break;
                case "SH":
                    DeleteCustomerReceiveUnit();
                    break;
                default:
                    break;
            }
        }


        /// <summary>
        /// 获取客户信息（新增或修改）
        /// </summary>
        /// <param name="custNm">客户名称</param>
        /// <returns></returns>
        private SlmBaseCustomerEntity GetCustomerData(string custNm)
        {
            SlmBaseCustomerEntity sbc = new SlmBaseCustomerEntity();
            string customerNm = txtCustomNm.Text.Trim();   //客户名称
            string abrvition = txtCustomAbbr.Text.Trim();       //客户简称
            string orgCode = txtOrgCode.Text.Trim();          //组织机构代码
            treeSelect(ComBelongsCity.Text);//加载省市
            string combelname = ComBelongsCity.Text;//省市区域名称 
            treeSelect(combelname);
            string py = txtCustomPY.Text.Trim();
            if (combelonCity == "")
            {
                MessageUtil.ShowWarning("请选择正确的省市！");
                return null;
            }

            if (customerNm == "")
            {
                MessageUtil.ShowWarning("请输入客户名称！");
                return null;
            }

            if (abrvition == "")
            {
                MessageUtil.ShowWarning("请输入客户简称！");
                return null;
            }

            if (combelname.Trim().Equals(""))
            {
                MessageUtil.ShowTips("请选择[省市/区域]！");
                return null;
            }

            if (cmbMarketSys.Text.Trim().Equals(""))
            {
                MessageUtil.ShowTips("请选择[市场系统]！");
                return null;
            }
            else if (cmbMarketSys.IsItemInList(cmbMarketSys.Text.Trim()) == false)
            {
                MessageUtil.ShowTips("输入的[市场系统]不在，请选择[市场系统]！");
                cmbMarketSys.Focus();
                return null;
            }

            string saleOrg = ClsBaseInfo.GetListByValid(this.ValidDataPurviewIds)[0];
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.base.CoreCustomerReborn.validateCustomerNmAndOrg", new object[] { customerNm, saleOrg }, this.ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                if (custNm != "")  //修改客户信息
                {
                    if (custNm != customerNm)
                    {
                        MessageUtil.ShowWarning("客户名称已存在！");
                        return null;
                    }
                }
                else
                {
                    MessageUtil.ShowWarning("客户名称已存在！");
                    return null;
                }
            }
            sbc.CustomerNm = customerNm;
            sbc.Bigarea = cmbRegion.Value == null ? "100710" : cmbRegion.Value.ToString();
            sbc.RegionNo = combelonCity;
            sbc.UserGrp = txtUserGrp.Text.Trim();
            sbc.MarketSys = cmbMarketSys.Text.Trim();     //本应该存代码  历史原因一开始就存了名称 后来重做 为了不影响大量的数据
            sbc.Abrvition = abrvition;
            sbc.Org = orgCode;
            sbc.Py = py;

            return sbc;
        }

        /// <summary>
        /// 新增客户基础信息
        /// </summary>
        private void AddCustomerBaseInfo()
        {
            SlmBaseCustomerEntity sbc = GetCustomerData("");
            if (sbc != null)
            {
                if (MessageUtil.ShowYesNoAndQuestion("是否新增用户？") == DialogResult.No) return;
                sbc.CreateName = UserInfo.GetUserName();
                string saleOrg = ClsBaseInfo.GetListByValid(this.ValidDataPurviewIds)[0];
                if (UserInfo.GetUserName() == "admin")
                    saleOrg = "100101";
                CoreClientParam ccp = new CoreClientParam();
                ccp.IfShowErrMsg = false;
                ccp.ServerName = "com.steering.pss.sale.base.CoreCustomerReborn";
                ccp.MethodName = "addCustomer";
                ccp.ServerParams = new object[] { JSONFormat.Format(sbc), saleOrg };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp != null)
                {
                    if (ccp.ReturnCode == -1)
                    {
                        MessageUtil.ShowWarning(ccp.ReturnInfo);
                        return;
                    }
                    MessageUtil.ShowTips("客户新增成功！");
                    string userCode = ccp.ReturnObject.ToString();    //将生成的客户代码从服务端返回
                    QueryCustomerInfo();
                    foreach (UltraGridRow uRow in gdCustomer.Rows)
                    {
                        if (uRow.Cells["CUSTOMERNO"].Value.ToString().Equals(userCode))
                        {
                            uRow.Activate();
                            break;
                        }
                    }
                }
            }
        }

        /// <summary>
        /// 修改客户主信息
        /// </summary>
        private void UpdateCustomerBaseInfo()
        {
            if (gdCustomer.ActiveRow == null)
            {
                MessageUtil.ShowWarning("请选择一行需要修改的客户信息记录！");
                return;
            }

            SlmBaseCustomerEntity sbc = GetCustomerData(gdCustomer.ActiveRow.Cells["CustomerNm"].Value.ToString());
            if (sbc != null)
            {
                if (MessageUtil.ShowYesNoAndQuestion("是否修改选择的用户记录？") == DialogResult.No) return;
                sbc.UpdateName = UserInfo.GetUserName();
                sbc.CustomerNo = gdCustomer.ActiveRow.Cells["CustomerNo"].Value.ToString();
                string saleOrg = ClsBaseInfo.GetListByValid(this.ValidDataPurviewIds)[0];
                if (UserInfo.GetUserName() == "admin")
                    saleOrg = "100101";
                CoreClientParam ccp = new CoreClientParam();
                ccp.IfShowErrMsg = false;
                ccp.ServerName = "com.steering.pss.sale.base.CoreCustomerReborn";
                ccp.MethodName = "updateCustomer";
                ccp.ServerParams = new object[] { JSONFormat.Format(sbc), saleOrg };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp != null)
                {
                    if (ccp.ReturnCode == -1)
                    {
                        MessageUtil.ShowWarning(ccp.ReturnInfo);
                        return;
                    }
                    MessageUtil.ShowTips("客户信息修改成功！");
                    QueryCustomerInfo();
                }
            }
        }

        /// <summary>
        /// 获取订结单位信息（新增+修改）
        /// </summary>
        /// <returns></returns>
        private SlmBaseOrderUnitEntity GetCustomerOrderUnit()
        {
            if (cmbCustomerType.SelectedItem == null)
            {
                MessageUtil.ShowWarning("请选择客户类别！");
                return null;
            }
            if (cmbCustoRating.SelectedItem == null)
            {
                MessageUtil.ShowWarning("请选择客户等级！");
                return null;
            }
            if (cmbCustoNature.SelectedItem == null)
            {
                MessageUtil.ShowWarning("请选择客户性质！");
                return null;
            }
            if (txtLEGAL_PSN.Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请输入法人！");
                txtLEGAL_PSN.Focus();
                return null;
            }
            if (txtPHONE.Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请输入电话！");
                txtPHONE.Focus();
                return null;
            }
            if (txtACCOUNT.Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请输入账号！");
                txtACCOUNT.Focus();
                return null;
            }
            if (txtFAX.Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请输入传真！");
                txtFAX.Focus();
                return null;
            }
            if (txtZIP_CODE.Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请输入邮编！");
                txtZIP_CODE.Focus();
                return null;
            }
            if (txtTAX_ID.Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请输入税号！");
                txtTAX_ID.Focus();
                return null;
            }
            if (txtAGENT.Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请输入代理人！");
                txtAGENT.Focus();
                return null;
            }

            if (txtADDRESS.Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请输入地址！");
                txtADDRESS.Focus();
                return null;
            }

            if (txtBANK.Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请输入开户银行！");
                txtBANK.Focus();
                return null;
            }

            SlmBaseOrderUnitEntity sbo = new SlmBaseOrderUnitEntity();
            sbo.CustmCtgry = cmbCustomerType.Value.ToString();
            sbo.CustmLvl = cmbCustoRating.Value.ToString();
            sbo.CustmPrpty = cmbCustoNature.Value.ToString();
            sbo.LegalPsn = txtLEGAL_PSN.Text.Trim();
            sbo.Phone = txtPHONE.Text.Trim();
            sbo.Account = txtACCOUNT.Text.Trim();
            sbo.Fax = txtFAX.Text.Trim();
            sbo.ZipCode = txtZIP_CODE.Text.Trim();
            sbo.TaxId = txtTAX_ID.Text.Trim();
            sbo.Agent = txtAGENT.Text.Trim();
            sbo.Address = txtADDRESS.Text.Trim();
            sbo.Bank = txtBANK.Text.Trim();
            sbo.Memo = txtMEMO.Text.Trim();
            sbo.CustmData = ultraText.Text.Trim();
            return sbo;
        }

        /// <summary>
        /// 新增客户信息的订结信息
        /// </summary>
        private void AddCustomerOrderUnit()
        {
            gdCustomer.UpdateData();
            UltraGridRow ugr = gdCustomer.ActiveRow;
            if (ugr == null)
            {
                MessageUtil.ShowWarning("请选择一条客户信息主记录！");
                return;
            }
            string custNo = ugr.Cells["CustomerNo"].Value.ToString();
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.base.CoreCustomerReborn.queryCustomerOrderCount", new object[] { custNo }, this.ob);
            if (dt != null && dt.Rows.Count >= 1)
            {
                MessageUtil.ShowWarning("一个客户只能维护一条订结信息！");
                return;
            }

            SlmBaseOrderUnitEntity sbo = GetCustomerOrderUnit();
            if (sbo != null)
            {
                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增客户的订结信息？") == DialogResult.No) return;
                if (ugr.Cells["BIGAREA"].Value.ToString() == "/" || ugr.Cells["BIGAREA"].Value.ToString() == "100710")
                {
                    sbo.ChnFl = "0";
                }
                else
                {
                    sbo.ChnFl = "1";
                }
                sbo.CreateName = UserInfo.GetUserName();
                sbo.CustomerNo = custNo;
                string saleOrg = ClsBaseInfo.GetListByValid(this.ValidDataPurviewIds)[0];
                if (UserInfo.GetUserName() == "admin")
                    saleOrg = "100101";
                CoreClientParam ccp = new CoreClientParam();
                ccp.IfShowErrMsg = false;
                ccp.ServerName = "com.steering.pss.sale.base.CoreCustomerReborn";
                ccp.MethodName = "addCustomerOrderUnit";
                ccp.ServerParams = new object[] { JSONFormat.Format(sbo), saleOrg };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp != null)
                {
                    if (ccp.ReturnCode == -1)
                    {
                        MessageUtil.ShowWarning(ccp.ReturnInfo);
                        return;
                    }
                    MessageUtil.ShowTips("订结信息新增成功！");
                    QueryCustomerInfo();
                    ultraTabControl2.Tabs[1].Selected = true;
                }
            }
        }

        /// <summary>
        /// 修改客户订结信息
        /// </summary>
        private void UpdateCustomerOrderUnit()
        {
            if (gdCustomer.ActiveRow == null)
            {
                MessageUtil.ShowWarning("请选择一行需要修改的客户信息记录！");
                return;
            }

            if (gdOrderUnit.ActiveRow == null)
            {
                MessageUtil.ShowWarning("请选择一行订结信息！");
                return;
            }

            SlmBaseOrderUnitEntity sbo = GetCustomerOrderUnit();
            if (sbo != null)
            {
                if (MessageUtil.ShowYesNoAndQuestion("是否修改选择的订结信息？") == DialogResult.No) return;
                sbo.UpdateName = UserInfo.GetUserName();
                sbo.CustomerNo = gdOrderUnit.ActiveRow.Cells["CustomerNo"].Value.ToString();
                string saleOrg = ClsBaseInfo.GetListByValid(this.ValidDataPurviewIds)[0];
                if (UserInfo.GetUserName() == "admin")
                    saleOrg = "100101";
                CoreClientParam ccp = new CoreClientParam();
                ccp.IfShowErrMsg = false;
                ccp.ServerName = "com.steering.pss.sale.base.CoreCustomerReborn";
                ccp.MethodName = "updateCustomerOrderUnit";
                ccp.ServerParams = new object[] { JSONFormat.Format(sbo), saleOrg };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp != null)
                {
                    if (ccp.ReturnCode == -1)
                    {
                        MessageUtil.ShowWarning(ccp.ReturnInfo);
                        return;
                    }
                    MessageUtil.ShowTips("客户信息修改成功！");
                    QueryCustomerInfo();
                    ultraTabControl2.Tabs[1].Selected = true;
                }
            }
        }

        /// <summary>
        /// 获取客户的收货信息（新增+修改）
        /// </summary>
        /// <returns></returns>
        private SlmBaseReceivUnitEntity GetCustomerReceiveUnit()
        {
            if (txtReceivePerson.Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请输入收货人！");
                txtReceivePerson.Focus();
                return null;
            }
            if (txtReceiveAddress.Text.Trim() == "")
            {
                MessageUtil.ShowWarning("请输入收货地址！");
                txtReceivePerson.Focus();
                return null;
            }
            SlmBaseReceivUnitEntity sbr = new SlmBaseReceivUnitEntity();
            sbr.Consignee = txtReceivePerson.Text.Trim();
            sbr.Address = txtReceiveAddress.Text.Trim();
            sbr.Phone = txtReceivePhone.Text.Trim();
            sbr.ZipCode = txtReceiveZipcode.Text.Trim();
            sbr.Fax = txtReceiveFax.Text.Trim();
            sbr.Memo = txtReceiveMemo.Text.Trim();
            return sbr;
        }

        /// <summary>
        /// 新增客户收货信息
        /// </summary>
        private void AddCustomerReceiveUnit()
        {
            gdCustomer.UpdateData();
            UltraGridRow ugr = gdCustomer.ActiveRow;
            if (ugr == null)
            {
                MessageUtil.ShowWarning("请选择一条客户信息主记录！");
                return;
            }
            string custNo = ugr.Cells["CustomerNo"].Value.ToString();
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.base.CoreCustomerReborn.queryCustomerReceiveCount", new object[] { custNo }, this.ob);
            if (dt != null && dt.Rows.Count >= 1)
            {
                MessageUtil.ShowWarning("一个客户只能维护一条收货记录！");
                return;
            }

            SlmBaseReceivUnitEntity sbr = GetCustomerReceiveUnit();
            if (sbr != null)
            {
                if (MessageUtil.ShowYesNoAndQuestion("是否新增客户收货信息？") == DialogResult.No) return;
                sbr.CreateName = UserInfo.GetUserName();
                sbr.CustomerNo = custNo;
                sbr.RegionNo = ugr.Cells["RegionNo"].Value.ToString();
                string saleOrg = ClsBaseInfo.GetListByValid(this.ValidDataPurviewIds)[0];
                if (UserInfo.GetUserName() == "admin")
                    saleOrg = "100101";
                CoreClientParam ccp = new CoreClientParam();
                ccp.IfShowErrMsg = false;
                ccp.ServerName = "com.steering.pss.sale.base.CoreCustomerReborn";
                ccp.MethodName = "addCustomerReceiveUnit";
                ccp.ServerParams = new object[] { JSONFormat.Format(sbr), saleOrg };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp != null)
                {
                    if (ccp.ReturnCode == -1)
                    {
                        MessageUtil.ShowWarning(ccp.ReturnInfo);
                        return;
                    }
                    MessageUtil.ShowTips("收货信息新增成功！");
                    QueryCustomerInfo();
                    ultraTabControl2.Tabs[2].Selected = true;
                }
            }
        }

        /// <summary>
        /// 修改客户收货信息
        /// </summary>
        private void UpdateCustomerReceiveUnit()
        {
            if (gdCustomer.ActiveRow == null)
            {
                MessageUtil.ShowWarning("请选择一行需要修改的客户信息记录！");
                return;
            }

            if (gdReceiveUnit.ActiveRow == null)
            {
                MessageUtil.ShowWarning("请选择一行收货信息！");
                return;
            }

            SlmBaseReceivUnitEntity sbr = GetCustomerReceiveUnit();
            if (sbr != null)
            {
                if (MessageUtil.ShowYesNoAndQuestion("是否修改选择的收货信息？") == DialogResult.No) return;
                sbr.UpdateName = UserInfo.GetUserName();
                sbr.CustomerNo = gdReceiveUnit.ActiveRow.Cells["CustomerNo"].Value.ToString();
                string saleOrg = ClsBaseInfo.GetListByValid(this.ValidDataPurviewIds)[0];
                if (UserInfo.GetUserName() == "admin")
                    saleOrg = "100101";
                CoreClientParam ccp = new CoreClientParam();
                ccp.IfShowErrMsg = false;
                ccp.ServerName = "com.steering.pss.sale.base.CoreCustomerReborn";
                ccp.MethodName = "updateCustomerReceiveUnit";
                ccp.ServerParams = new object[] { JSONFormat.Format(sbr), saleOrg };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp != null)
                {
                    if (ccp.ReturnCode == -1)
                    {
                        MessageUtil.ShowWarning(ccp.ReturnInfo);
                        return;
                    }
                    MessageUtil.ShowTips("客户收货信息修改成功！");
                    QueryCustomerInfo();
                    ultraTabControl2.Tabs[2].Selected = true;
                }
            }
        }

        /// <summary>
        /// 删除客户信息(后台删掉订结、收货信息)
        /// </summary>
        private void DeleteCustomerBaseInfo()
        {
            gdCustomer.UpdateData();
            UltraGridRow ugr = gdCustomer.ActiveRow;
            if (ugr == null)
            {
                MessageUtil.ShowWarning("请选择一条要删除的客户信息！");
                return;
            }

            string custNo = ugr.Cells["CUSTOMERNO"].Value.ToString();
            if (MessageUtil.ShowYesNoAndQuestion("是否删除选择的客户信息？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.IfShowErrMsg = false;
            ccp.ServerName = "com.steering.pss.sale.base.CoreCustomerReborn";
            ccp.MethodName = "deleteCustomerBaseInfo";
            ccp.ServerParams = new object[] { custNo, UserInfo.GetUserName() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
                MessageUtil.ShowTips("客户信息删除成功！");
                QueryCustomerInfo();
            }
        }

        /// <summary>
        ///  删除客户订结信息
        /// </summary>
        private void DeleteCustomerOrderUnit()
        {
            gdCustomer.UpdateData();
            UltraGridRow ugr = gdCustomer.ActiveRow;
            if (ugr == null)
            {
                MessageUtil.ShowWarning("请选择一条客户信息！");
                return;
            }
            if (gdOrderUnit.ActiveRow == null)
            {
                MessageUtil.ShowWarning("请选择您要删除的订结信息！");
                return;
            }
            string custNo = ugr.Cells["CUSTOMERNO"].Value.ToString();
            if (MessageUtil.ShowYesNoAndQuestion("是否删除选择的客户订结信息？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.IfShowErrMsg = false;
            ccp.ServerName = "com.steering.pss.sale.base.CoreCustomerReborn";
            ccp.MethodName = "deleteCustomerOrderUnit";
            ccp.ServerParams = new object[] { custNo };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
                MessageUtil.ShowTips("客户订结信息删除成功！");
                QueryCustomerInfo();
                ultraTabControl2.Tabs[1].Selected = true;
            }
        }

        /// <summary>
        ///  删除客户订结信息
        /// </summary>
        private void DeleteCustomerReceiveUnit()
        {
            gdCustomer.UpdateData();
            UltraGridRow ugr = gdCustomer.ActiveRow;
            if (ugr == null)
            {
                MessageUtil.ShowWarning("请选择一条客户信息！");
                return;
            }
            if (gdReceiveUnit.ActiveRow == null)
            {
                MessageUtil.ShowWarning("请选择您要删除的收货信息！");
                return;
            }
            string custNo = ugr.Cells["CUSTOMERNO"].Value.ToString();
            if (MessageUtil.ShowYesNoAndQuestion("是否删除选择的客户收货信息？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.IfShowErrMsg = false;
            ccp.ServerName = "com.steering.pss.sale.base.CoreCustomerReborn";
            ccp.MethodName = "deleteCustomerReveciveUnit";
            ccp.ServerParams = new object[] { custNo };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
                MessageUtil.ShowTips("客户订结信息删除成功！");
                QueryCustomerInfo();
                ultraTabControl2.Tabs[2].Selected = true;
            }
        }



        /// <summary>
        /// 展开下拉列表树节点
        /// </summary>
        /// <param name="Name">节点名字</param>
        public void treeSelect(string Name)
        {
            if (!string.IsNullOrEmpty(Name))
            {

                for (int e = 0; e < this.ComBelongsCity.Nodes.Count; e++)
                {
                    ComBelongsCity.Nodes[e].Collapse();
                    combelonCity = "";
                    //展开一级节点  LX 修改
                    if (this.ComBelongsCity.Nodes[e].Text.Equals(Name) || this.ComBelongsCity.Nodes[e].Tag.Equals(Name))
                    {
                        this.ComBelongsCity.Nodes[e].Expand();
                        this.ComBelongsCity.Nodes[e].ExpandAll();
                        ComBelongsCity.Text = this.ComBelongsCity.Nodes[e].Text.ToString();
                        combelonCity = this.ComBelongsCity.Nodes[e].Tag.ToString();
                        combleTo = this.ComBelongsCity.Nodes[e].ToolTipText;
                        return;
                    }

                    //展开二级节点
                    for (int w = 0; w < this.ComBelongsCity.Nodes[e].Nodes.Count; w++)
                    {
                        if (this.ComBelongsCity.Nodes[e].Nodes[w].Text.Equals(Name) || this.ComBelongsCity.Nodes[e].Nodes[w].Tag.Equals(Name))
                        {
                            this.ComBelongsCity.Nodes[e].Expand();
                            this.ComBelongsCity.Nodes[e].Nodes[w].ExpandAll();
                            ComBelongsCity.Text = this.ComBelongsCity.Nodes[e].Nodes[w].Text.ToString();
                            combelonCity = this.ComBelongsCity.Nodes[e].Nodes[w].Tag.ToString();
                            combleTo = this.ComBelongsCity.Nodes[e].Nodes[w].ToolTipText;
                            return;
                        }
                    }
                    //展开三级子节点
                    for (int w = 0; w < this.ComBelongsCity.Nodes[e].Nodes.Count; w++)
                    {
                        for (int r = 0; r < this.ComBelongsCity.Nodes[e].Nodes[w].Nodes.Count; r++)
                        {
                            if (this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Text.Equals(Name) || this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Tag.Equals(Name))
                            {
                                this.ComBelongsCity.Nodes[e].Expand();
                                this.ComBelongsCity.Nodes[e].Nodes[w].Expand();
                                this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].ExpandAll();
                                ComBelongsCity.Text = this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Text.ToString();
                                combelonCity = this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Tag.ToString();
                                combleTo = this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].ToolTipText;
                                return;
                            }
                        }
                    }
                    //展开四级子节点
                    for (int w = 0; w < this.ComBelongsCity.Nodes[e].Nodes.Count; w++)
                    {
                        for (int r = 0; r < this.ComBelongsCity.Nodes[e].Nodes[w].Nodes.Count; r++)
                        {
                            for (int x = 0; x < this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Nodes.Count; x++)
                            {
                                if (this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Nodes[x].Text.Equals(Name) || this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Nodes[x].Tag.Equals(Name))
                                {
                                    this.ComBelongsCity.Nodes[e].Expand();
                                    this.ComBelongsCity.Nodes[e].Nodes[w].Expand();
                                    this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Expand();
                                    this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Nodes[x].ExpandAll();
                                    ComBelongsCity.Text = this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Nodes[x].Text.ToString();
                                    combelonCity = this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Nodes[x].Tag.ToString();
                                    combleTo = this.ComBelongsCity.Nodes[e].Nodes[w].Nodes[r].Nodes[x].ToolTipText;
                                    return;
                                }
                            }
                        }
                    }
                }
            }
        }

        private void gdCustomer_AfterRowActivate(object sender, EventArgs e)
        {
            gdCustomer.UpdateData();
            UltraGridRow ugr = gdCustomer.ActiveRow;
            if (ugr != null)
            {
                ultraTabControl2.Tabs[0].Selected = true;
                SlmBaseCustomerEntity sbc = (SlmBaseCustomerEntity)ugr.ListObject;
                txtCustomNm.Text = sbc.CustomerNm;
                txtCustomAbbr.Text = sbc.Abrvition;
                txtUserGrp.Text = sbc.UserGrp;
                txtOrgCode.Text = sbc.Org;
                cmbRegion.Value = sbc.Bigarea;
                txtCustomPY.Text = sbc.Py;
                cmbMarketSys.Text = sbc.MarketSys;
                treeSelect(sbc.RegionNo);
                customer_nm.Text = sbc.CustomerNm;
                //订结信息
                QueryCustomerOrderUnit(sbc.CustomerNo);
                //收货信息
                QueryCustomerReceiveUnit(sbc.CustomerNo);
            }
        }

        /// <summary>
        /// 查询客户的订结信息
        /// </summary>
        /// <param name="customerNo"></param>
        private void QueryCustomerOrderUnit(string customerNo)
        {
            List<SlmBaseOrderUnitEntity> list = EntityHelper.GetData<SlmBaseOrderUnitEntity>(
                "com.steering.pss.sale.base.CoreCustomerReborn.queryCustomerOrderUnit", new object[] { customerNo }, this.ob);
            slmBaseOrderUnitEntityBindingSource.DataSource = list;
            if(list==null || list.Count<1)
            {
                ClearCustomerOrderUnit();
            }

        }

        /// <summary>
        /// 查询客户的收货信息
        /// </summary>
        /// <param name="customerNo"></param>
        private void QueryCustomerReceiveUnit(string customerNo)
        {
            List<SlmBaseReceivUnitEntity> list = EntityHelper.GetData<SlmBaseReceivUnitEntity>(
                "com.steering.pss.sale.base.CoreCustomerReborn.queryCustomerReceiveUnit", new object[] { customerNo }, this.ob);
            slmBaseReceivUnitEntityBindingSource.DataSource = list;

            if (list == null || list.Count < 1)
            {
                ClearCustomerReceiveUnit();
            }
        }

        private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (this.toolMenu == null)
                return;
            if (e.Tab.Key.Equals("BI"))
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.True;
            }
            else if (e.Tab.Key.Equals("DJ"))
            {
                if (gdCustomer.ActiveRow != null)
                {
                    SlmBaseCustomerEntity sbc = (SlmBaseCustomerEntity)gdCustomer.ActiveRow.ListObject;
                    customer_nm.Text = sbc.CustomerNm;
                    if (gdOrderUnit.Rows.Count < 1)
                    {
                        if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                            toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.True;
                       // ClearCustomerOrderUnit();
                    }
                    else
                    {
                        if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                            toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.False;
                    }
                }
                else
                {
                    MessageUtil.ShowWarning("请选择一条客户信息主记录！");
                    ultraTabControl2.Tabs[0].Selected = true;
                    return;
                }
            }
            else if (e.Tab.Key.Equals("SH"))
            {
                if (gdCustomer.ActiveRow == null)
                {
                    MessageUtil.ShowWarning("请选择一条客户信息主记录！");
                    ultraTabControl2.Tabs[0].Selected = true;
                    return;
                }
                if (gdReceiveUnit.Rows.Count < 1)
                {
                    if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                        toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.True;
                    //ClearCustomerReceiveUnit();
                }
                else
                {
                    if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                        toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.False;
                }
            }
        }

        private void gdOrderUnit_AfterRowActivate(object sender, EventArgs e)
        {
            if (gdCustomer.ActiveRow == null)
                return;
            if (gdOrderUnit.Rows.Count<1)
            {
                ClearCustomerOrderUnit();
                return;
            }
            SlmBaseOrderUnitEntity sbo = (SlmBaseOrderUnitEntity)gdOrderUnit.ActiveRow.ListObject;
            cmbCustomerType.Text = sbo.CustmCtgry;
            cmbCustoRating.Text = sbo.CustmLvl;
            cmbCustoNature.Text = sbo.CustmPrpty;
            txtLEGAL_PSN.Text = sbo.LegalPsn;
            txtPHONE.Text = sbo.Phone;
            txtACCOUNT.Text = sbo.Account;
            txtFAX.Text = sbo.Fax;
            txtZIP_CODE.Text = sbo.ZipCode;
            txtTAX_ID.Text = sbo.TaxId;
            txtAGENT.Text = sbo.Agent;
            txtADDRESS.Text = sbo.Address;
            txtBANK.Text = sbo.Bank;
            txtMEMO.Text = sbo.Memo;
            ultraTabControl2.Tabs[1].Selected = true;
        }

        private void gdReceiveUnit_AfterRowActivate(object sender, EventArgs e)
        {
            if (gdCustomer.ActiveRow == null)
                return;
            if (gdReceiveUnit.Rows.Count<1)
            {
                ClearCustomerReceiveUnit();
                return;
            }
            SlmBaseReceivUnitEntity sbr = (SlmBaseReceivUnitEntity)gdReceiveUnit.ActiveRow.ListObject;
            txtReceivePerson.Text = sbr.Consignee;
            txtReceiveAddress.Text = sbr.Address;
            txtReceivePhone.Text = sbr.Phone;
            txtReceiveZipcode.Text = sbr.ZipCode;
            txtReceiveFax.Text = sbr.Fax;
            txtReceiveMemo.Text = sbr.Memo;
            ultraTabControl2.Tabs[2].Selected = true;
        }

        private void txtCutormNm_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)     //回车
                QueryCustomerInfo();
        }

        /// <summary>
        /// 点击客户信息GRID
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gdCustomer_MouseClick(object sender, MouseEventArgs e)
        {
            ultraTabControl2.Tabs[0].Selected = true;
        }

        /// <summary>
        ///  点击客户订结信息GRID
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gdOrderUnit_MouseClick(object sender, MouseEventArgs e)
        {
            if (gdCustomer.ActiveRow == null)
            {
                return;
            }
            ultraTabControl2.Tabs[1].Selected = true;
            if (gdOrderUnit.Rows.Count < 1)
            {
                ClearCustomerOrderUnit();
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.True;
            }
            else
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.False;
            }
        }

        /// <summary>
        ///  点击客户收货信息GRID
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gdReceiveUnit_MouseClick(object sender, MouseEventArgs e)
        {
            if (gdCustomer.ActiveRow == null)
            {
                return;
            }
            ultraTabControl2.Tabs[2].Selected = true;
            if (gdReceiveUnit.Rows.Count < 1)
            {
                ClearCustomerReceiveUnit();
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.True;
            }
            else
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.False;
            }
        }

        private void FrmCustomerReborn_Shown(object sender, EventArgs e)
        {
            ultraTabControl1.Tabs[0].Selected = true;
            if (toolMenu.Toolbars[0].Tools.Exists("Export"))
                toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.False;
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            //平台首次加载 最后加载平台的工具栏
            if (toolMenu == null)
                return;
            if (e.Tab.Key.Equals("Add"))
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Export"))
                    toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.False;
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.True;
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                    toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.True;
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.True;

            }
            else if (e.Tab.Key.Equals("Query"))
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Export"))
                    toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.True;
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.False;
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                    toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.False;
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = Infragistics.Win.DefaultableBoolean.False;

            }
        }

        /// <summary>
        /// 客户信息查询
        /// </summary>
        private void QueryCustomerList()
        {
            string customerNm = txtCutormNm.Text.Trim();
            string saleOrg = ClsBaseInfo.GetListByValid(this.ValidDataPurviewIds)[0];
            if (UserInfo.GetUserName() == "admin")
                saleOrg = "admin";
            customerNm = customerNm.ToUpper();
            List<SlmBaseCustomerListEntity> list = EntityHelper.GetData<SlmBaseCustomerListEntity>(
                "com.steering.pss.sale.base.CoreCustomerReborn.queryCustomerList", new object[] { customerNm, saleOrg }, this.ob);
            slmBaseCustomerListEntityBindingSource.DataSource = list;
        }

        /// <summary>
        /// 清空订结信息编辑区
        /// </summary>
        private void ClearCustomerOrderUnit()
        {
            cmbCustomerType.Text = "";
            cmbCustoRating.Text = "";
            cmbCustoNature.Text = "";
            txtLEGAL_PSN.Text = "";
            txtPHONE.Text = "";
            txtACCOUNT.Text = "";
            txtFAX.Text = "";
            txtZIP_CODE.Text = "";
            txtTAX_ID.Text = "";
            txtAGENT.Text = "";
            txtADDRESS.Text = "";
            txtBANK.Text = "";
            txtMEMO.Text = "";
        }

        /// <summary>
        /// 清空收货信息编辑区
        /// </summary>
        /// 
        private void ClearCustomerReceiveUnit()
        {
            txtReceivePerson.Text = "";
            txtReceiveAddress.Text = "";
            txtReceivePhone.Text = "";
            txtReceiveZipcode.Text = "";
            txtReceiveFax.Text = "";
            txtReceiveMemo.Text = "";
        }

    }
}