lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/Customers/OldCustomer/FrmAddInterestedBuyers.cs

using LYFZ.DAL;
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;
using System.Web.UI.WebControls;

namespace LYFZ.Software.MainBusiness.Customers.OldCustomer
{
    public partial class FrmAddInterestedBuyers : LYFZ.Software.UI.Customers.OldCustomer.FrmAddInterestedBuyers
    {
        public FrmAddInterestedBuyers()
        {
            this.btnSave.Click += btnSave_Click;
            this.btnClear.Click += btnClear_Click;
            this.Shown += FrmAddInterestedBuyers_Shown;
            this.btnRegion.Click += btnRegion_Click;
            this.btnCustomerSource.Click += btnCustomerSource_Click;
            this.chkLKH.Click += chkLKH_Click;
            this.chkPYJS.Click += chkPYJS_Click;
            this.chkQT.Click += chkQT_Click;
            this.btnAddcommunication.Click += btnAddcommunication_Click;
            this.dgvData.RefreshTheme();
            this.txtCus_Name.EventTextBoxEx_TextChanged += txtCus_Name_EventTextBoxEx_TextChanged;
            this.txtCus_Telephone.TextChanged += txtCus_Telephone_TextChanged;
            this.btnXiangXi.Click += btnXiangXi_Click;
            this.btnDelete.Click += btnDelete_Click;
            this.btnClose.Click += btnClose_Click;
            this.FormClosing += FrmAddInterestedBuyers_FormClosing;
            this.btnQQCall.Click += btnQQCall_Click;
            this.btnDial.Click += btnDial_Click;
            this.dgvData.CellMouseDoubleClick += dgvData_CellMouseDoubleClick;
            this.btnUnbind.Click += btnUnbind_Click;
            this.cmbtreevClientStatus.ComboBoxTree_NodeMouseClick += cmbtreevClientStatus_ComboBoxTree_NodeMouseClick;
            this.btnClientStatusTypeSet.Click += btnClientStatusTypeSet_Click;
            this.btnIntentLevel.Click += btnIntentLevel_Click;
        }

        public void EditOnlyRead()
        {
            chkLKH.Enabled = false;
            chkPYJS.Enabled = false;
            chkQT.Enabled = false;
            cmbCus_CustomerSource.Enabled = false;
            btnCustomerSource.Enabled = false;
            txtCus_Name.Enabled = false;
            txtCus_Telephone.Enabled = false;
            rdoCus_Sex1_1.Enabled = false;
            rdoCus_Sex1_2.Enabled = false;
            txtCus_Birthday.Enabled = false;
            chkCus_Lunar.Enabled = false;
            txtCus_FixedPhone.Enabled = false;
            txtCus_QQ.Enabled = false;
            txtCus_MicroSignal.Enabled = false;
            cmbDegree.Enabled = false;
            btnIntentLevel.Enabled = false;
            cmbCus_Region.Enabled = false;
            btnRegion.Enabled = false;
            txtCus_Address.Enabled = false;
            comType.Enabled = false;
            cmbtreevClientStatus.Enabled = false;
            btnUnbind.Enabled = false;
            btnUnbind.Visible = false;
            txtCus_WorkUnit.Enabled = false;
            cmbtreevClientStatusType.Enabled = false;
            btnClientStatusTypeSet.Enabled = false;
            txtClientStatusReason.Enabled = false;
            cmbtreevBelongsPerson.Enabled = false;
            txtXiangxi.Enabled = false;
            btnXiangXi.Enabled = false;
            btnClear.Enabled = false;
            txtMicroID.Enabled = false;
            
        }

        /// <summary>
        /// 意向程度设置
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnIntentLevel_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.InitialSet.FrmSystemSet frm = new InitialSet.FrmSystemSet();
            frm.TypeName = "BEBABEAGFDDAHIHJD";
            frm.Version = "Version";
            if (frm.ShowDialog() == DialogResult.OK)
            { this.GetIntentLevel(); }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnClientStatusTypeSet_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.InitialSet.FrmSystemSet frm = new InitialSet.FrmSystemSet();
            frm.TypeName = "AAAAABX";
            frm.Version = "Version";
            if (frm.ShowDialog() == DialogResult.OK)
            { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("AAAAABX", this.cmbtreevClientStatusType, IsFirstNodeNull: true); }
        }
        /// <summary>
        /// 是否添加操作
        /// </summary>
        bool IsAdd = false;
        /// <summary>
        /// 判断上一个焦点是姓名还是电话 false为姓名
        /// </summary>
        bool Is = false;
        /// <summary>
        /// 是否被选中出来的数据
        /// </summary>
        bool selected = false;
        /// <summary>
        /// 客户组 编号
        /// </summary>
        public string GMID = "";
        /// <summary>
        /// 选出来的ID
        /// </summary>
        int UsertID;
        BLL.BLL_ErpCustomer ctbll = new BLL.BLL_ErpCustomer();
        BLL.BLL_ErpCustomerGroup GPbll = new BLL.BLL_ErpCustomerGroup();
        BLL.BLL_ErpCustomerGroupMembers GMbll = new BLL.BLL_ErpCustomerGroupMembers();
        Model.Model_ErpCustomer model = null;
        Model.Model_ErpCustomerGroup modelGP = null;
        Model.Model_ErpCustomerGroupMembers modelGM = null;
        List<Model.Model_ErpCustomerGroupMembers> modellist = new List<Model.Model_ErpCustomerGroupMembers>();
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        List<Helper.CommandInfo> clist = null;
        string userID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;

        void GetIntentLevel()
        {
            DataTable dt = new DataTable();
            DataTable dt2 = new DataTable();
            cmbDegree.Items.Clear();
            cmbDegree.Items.Add(new ListItem("", ""));
            LYFZ.BLL.BLL_ErpSystemCategory SystemCategorybll = new LYFZ.BLL.BLL_ErpSystemCategory();
            dt2 = SystemCategorybll.GetList("Sc_ClassCode='BEBABEAGFDDAHIHJD'").Tables[0];
            dt = SystemCategorybll.GetList("Sc_ClassParentID=" + dt2.Rows[0]["ID"] + "").Tables[0];
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                { cmbDegree.Items.Add(new ListItem(dt.Rows[i]["Sc_ClassName"].ToString(), dt.Rows[i]["Sc_ClassName"].ToString())); }
            }
        }
        ListItem item;
        /// <summary>
        /// 窗体加载
        /// </summary>
        void FrmAddInterestedBuyers_Shown(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.HidePhoneControls(this.txtCus_Telephone);
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.HidePhoneControls(this.txtCus_FixedPhone);
            //获取客户意向程度
            this.GetIntentLevel();

            #region 绑定客户类型
            item = new ListItem();
            item.Text = "婚纱";
            item.Value = "0";
            this.comType.Items.Add(item);

            item = new ListItem();
            item.Text = "儿童";
            item.Value = "1";
            this.comType.Items.Add(item);

            item = new ListItem();
            item.Text = "写真";
            this.item.Value = "2";
            this.comType.Items.Add(item);

            item = new ListItem();
            item.Text = "服务套系";
            item.Value = "3";
            this.comType.Items.Add(item);

            item = new ListItem();
            item.Text = "婚庆套系";
            item.Value = "4";
            this.comType.Items.Add(item);
            #endregion
            //跟进人
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_DepartmentAndEmployee(this.cmbtreevBelongsPerson, IsFirstNodeNull: true);
            //流失类型
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("AAAAABX", this.cmbtreevClientStatusType, IsFirstNodeNull: true);
            //获取客户区域
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_ClientSourec("AAAAAAC", this.cmbCus_Region, strHideFiled: "");
            //获取客户来源
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_ClientSourec("AAAAAAF", this.cmbCus_CustomerSource, strHideFiled: "BFACBABGBGBJGDHIE,BFAFBCBADBDCABFDD");
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbtreevClientStatus, StrBindData: "跟进中,流失", IsFirstNodeNull: false);
            //GMID不等于空的时候 修改状态
            if (this.GMID != "" && this.GMID != null)
            {
                this.btnUnbind.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.MicroInfo, CustomAttributes.OperatingAuthority.MicroInfo_Unbind);
                modelGP = GPbll.GetModel("GP_CustomerGroupID", this.GMID);
                modellist = GMbll.GetModelList("GM_CustomerGroupID='" + this.GMID + "' and GM_Master=1 ");
                model = ctbll.GetModel("Cus_CustomerNumber", modellist[0].GM_CustomerID);
                this.txtCus_Name.Text = model.Cus_Name;
                this.txtCus_Telephone.Text = model.Cus_Telephone;
                this.txtCus_Birthday.Text = model.Cus_Birthday;
                this.chkCus_Lunar.Checked = model.Cus_BirthdayLunar == "1" ? true : false;
                this.txtCus_Address.Text = model.Cus_Address;
                if (model.Cus_Sex == false)
                {
                    this.rdoCus_Sex1_1.Checked = true;
                }
                else
                {
                    this.rdoCus_Sex1_2.Checked = true;
                }
                this.txtCus_FixedPhone.Text = model.Cus_FixedPhone;
                this.txtCus_MicroSignal.Text = model.Cus_MicroSignal;
                this.txtCus_QQ.Text = model.Cus_QQ;
                this.txtCus_WorkUnit.Text = model.Cus_WorkUnit;
                this.cmbCus_Region.Text = model.Cus_Region;
                this.cmbDegree.Text = modelGP.GP_DegreeOfIntent;
                this.cmbtreevClientStatus.TextFindTag(modelGP.GP_CustomerStatus == "意向" ? "跟进中" : modelGP.GP_CustomerStatus);
                this.lblClientStatusReason.Text = modelGP.GP_CustomerStatus.Trim() + "原因：";
                this.txtClientStatusReason.Text = modelGP.GP_LossReason;
                this.cmbtreevClientStatusType.TextFindTag(modelGP.GP_LossType);
                if (!string.IsNullOrEmpty(model.Cus_OpenID.Trim()))
                {
                    this.txtMicroID.Text = "已绑定";
                }
                else
                {
                    this.txtMicroID.Text = "未绑定";
                }
                if (modelGP.GP_CustomerSource != "")
                {
                    if (modelGP.GP_CustomerSource == "老客户")
                    { this.chkLKH.Checked = true; chkLKH_Click(null, null); }
                    else if (modelGP.GP_CustomerSource == "朋友介绍")
                    { this.chkPYJS.Checked = true; chkPYJS_Click(null, null); }
                    else
                    {
                        this.cmbCus_CustomerSource.Text = modelGP.GP_CustomerSource;
                        this.chkQT.Checked = true;
                        this.chkQT_Click(null, null);
                    }
                }
                //选中客户类型
                switch (modelGP.GP_CustomerType)
                {
                    case 0: this.comType.SelectedIndex = 0; break;
                    case 1: this.comType.SelectedIndex = 1; break;
                    case 2: this.comType.SelectedIndex = 2; break;
                    case 3: this.comType.SelectedIndex = 3; break;
                }
                //获取沟通记录
                this.BindDgvTaskView();
                if (modelGP.GP_CustomerStatus.Trim() == "流失")
                {
                    this.panelClientStatusReason.Visible = true;
                    this.panelBelongsPerson.Visible = false;
                }
                else if (modelGP.GP_CustomerStatus.Trim() == "意向")
                {
                    this.panelClientStatusReason.Visible = false;
                    this.panelBelongsPerson.Visible = true;
                    this.panelBelongsPerson.Location = this.panelClientStatusReason.Location;
                    if (!String.IsNullOrEmpty(modelGP.GP_BelongsPersonID))
                    {
                        this.cmbtreevBelongsPerson.TagFindText(modelGP.GP_BelongsPersonID);
                    }
                }
                else
                {
                    this.cmbtreevClientStatus.Enabled = false;
                }
            }
            else
            {
                this.panelBelongsPerson.Visible = true;
                this.panelBelongsPerson.Location = this.panelClientStatusReason.Location;
                this.cmbtreevBelongsPerson.TagFindText(userID);
            }
            cmbCus_CustomerSource.Enabled = false;
        }
        /// <summary>
        /// 解绑
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnUnbind_Click(object sender, EventArgs e)
        {
            if (this.txtMicroID.Text.Trim() == "已绑定")
            {
                if (MessageBoxCustom.Show("是否要解除绑定？", "温馨提示！", MessageBoxButtons.YesNo) == DialogResult.No)
                { return; }
                LYFZ.Model.Model_ErpCustomer modelA = ctbll.GetModel(model.ID);
                modelA.Cus_OpenID = "";
                modelA.Cus_UpdateDateTime = SDateTime.Now;
                modelA.Cus_UpdateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                if (ctbll.Update(modelA))
                {
                    MessageBoxCustom.Show("解绑成功！");
                    this.txtMicroID.Text = "未绑定";
                }
                else
                { MessageBoxCustom.Show("解绑失败"); }
            }
        }
        /// <summary>
        /// 窗体关闭时
        /// </summary>
        void FrmAddInterestedBuyers_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (IsAdd)
            { this.DialogResult = DialogResult.OK; }
        }
        /// <summary>
        /// 添加沟通记录
        /// </summary>
        void btnAddcommunication_Click(object sender, EventArgs e)
        {
            //如果GMID等于空就是没人客户存在
            if (this.GMID != "")
            {
                LYFZ.Software.MainBusiness.CameraControlBook.SuperSmallForm.A_AddCommunicateRecords addfrm = new CameraControlBook.SuperSmallForm.A_AddCommunicateRecords();
                addfrm.StrClientNumber = this.GMID;
                addfrm.EnumClientServiceTaskType = LYFZ.EnumPublic.ClientServiceTaskType.意向跟踪;
                addfrm.EnumClientServiceTaskItem = LYFZ.EnumPublic.ClientServiceTaskItem.意向客户;
                addfrm.Areminderdate = true;
                addfrm.ShowDialog();
                if (addfrm.IsSaveed)
                { this.BindDgvTaskView(); }
            }
            else
            { MessageBoxCustom.Show("请先添加信息！"); }
        }
        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                clist = new List<Helper.CommandInfo>();
                #region 手机存在
                if (string.IsNullOrEmpty(this.txtCus_Name.Text.Trim()))
                { MessageBoxCustom.Show("客户姓名不能为空"); return; }
                string StrPhone = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.MaskedTextBoxExGetText(this.txtCus_Telephone);
                if (!string.IsNullOrEmpty(StrPhone))
                {
                    if (StrPhone.Length != 11)
                    { MessageBoxCustom.Show("手机号码必须为11位数！"); return; }
                }
                if (this.chkQT.Checked == true && string.IsNullOrEmpty(this.cmbCus_CustomerSource.Text.Trim()))
                { MessageBoxCustom.Show("请选择客户来源"); return; }
                int intMasse = this.txtCus_Birthday.CheckDateValue(this.txtCus_Birthday, this.chkCus_Lunar);
                if (intMasse == 1) { MessageBoxCustom.Show("客户生日日期格式输入错误！"); return; }
                else if (intMasse == 2)
                { MessageBoxCustom.Show("客户生日：" + this.txtCus_Birthday.StrValue.Trim() + "不是公历日期，若要保存请勾上农历！"); return; }
                if (comType.Text == "")
                { MessageBoxCustom.Show("请选择客户类型"); return; }
                if (string.IsNullOrEmpty(this.cmbtreevClientStatus.Text.Trim()))
                { MessageBoxCustom.Show("请选择客户状态！"); return; }
                else
                {
                    switch (this.cmbtreevClientStatus.Text.Trim())
                    {
                        case "流失":
                            if (string.IsNullOrEmpty(this.cmbtreevClientStatusType.Text.Trim()))
                            { MessageBoxCustom.Show("请选择 或 输入流失类型！"); return; }
                            break;
                        default: break;
                    }
                }

                if (this.GMID == "" && selected == false)
                {
                    if (!string.IsNullOrEmpty(StrPhone))
                    {
                        DataTable tblClient = orbll.GetView_Custom("tb_ErpCustomer", StrWhere: "Cus_Telephone = '" + StrPhone + "'", ShowColumnName: "ID").Tables[0];
                        if (tblClient.Rows.Count > 0)
                        { MessageBoxCustom.Show("手机号已存在"); return; }
                    }
                }
                else
                {
                    if (!string.IsNullOrEmpty(StrPhone))
                    {
                        DataTable tblClient = orbll.GetView_Custom("tb_ErpCustomer cus left join tb_ErpCustomerGroupMembers gm on gm.GM_CustomerID=cus.Cus_CustomerNumber left join tb_ErpCustomerGroup gp on gm.GM_CustomerGroupID=gp.GP_CustomerGroupID",
                            StrWhere: "Cus_Telephone = '" + StrPhone + "' and GP_CustomerGroupID!='" + this.GMID + "'", ShowColumnName: "cus.ID").Tables[0];
                        if (tblClient.Rows.Count > 0)
                        { MessageBoxCustom.Show("手机号已存在"); return; }
                    }
                }

                if (!string.IsNullOrEmpty(txtCus_MicroSignal.Text.Trim()))
                {
                    string sql = " ";
                    if (model != null)
                    {
                        sql = " select * from tb_erpcustomer where Cus_MicroSignal = '" + txtCus_MicroSignal.Text + "' and  Cus_CustomerNumber != '" + model.Cus_CustomerNumber + "' ";
                    }
                    else
                    {
                        sql = " select * from tb_erpcustomer where Cus_MicroSignal = '" + txtCus_MicroSignal.Text + "' ";
                    }
                    DataTable tblClient = orbll.GetView_Custom(sql).Tables[0];
                    if (tblClient.Rows.Count > 0)
                    { MessageBoxCustom.Show("当前微信号重复，请核实数据！"); return; }
                }

                if (string.IsNullOrEmpty(txtCus_MicroSignal.Text.Trim()) && string.IsNullOrEmpty(txtCus_Telephone.Text.Trim()))
                {
                    MessageBoxCustom.Show("客户电话和微信号至少填写一个！"); return;
                }

                #endregion
                //新建
                if (this.GMID == "")
                {
                    model = new Model.Model_ErpCustomer();
                    modelGP = new Model.Model_ErpCustomerGroup();
                    modelGM = new Model.Model_ErpCustomerGroupMembers();

                    #region Model 添加
                    if (this.cmbtreevBelongsPerson.Tag == null)
                    {
                        MessageBoxCustom.Show("请选择跟进人！"); return;
                    }
                    DateTime strTime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
                    string Kehuzu = LYFZ.BLL.BLL_ErpCustomer.GetNewClientGroupNumber();
                    //客户组表
                    modelGP.GP_CustomerGroupID = Kehuzu;
                    modelGP.GP_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetLocalCompanyInfoID();
                    modelGP.GP_GroupType = 2;
                    item = comType.SelectedItem as ListItem;
                    modelGP.GP_CustomerType = Convert.ToInt32(item.Value);
                    modelGP.GP_DegreeOfIntent = this.cmbDegree.Text;
                    modelGP.GP_CustomerStatus = this.cmbtreevClientStatus.Text.Trim() == "跟进中" ? "意向" : this.cmbtreevClientStatus.Text.Trim();
                    modelGP.GP_LossReason = this.txtClientStatusReason.Text.Trim();
                    modelGP.GP_LossType = this.cmbtreevClientStatusType.Text.Trim();
                    modelGP.GP_CreateDatetime = strTime;
                    modelGP.GP_CreateName = userID;
                    if (this.chkLKH.Checked == false && this.chkPYJS.Checked == false && this.chkQT.Checked == false)
                    { modelGP.GP_CustomerSource = ""; }
                    if (this.chkLKH.Checked == true)
                    { modelGP.GP_CustomerSource = "老客户"; }
                    if (this.chkPYJS.Checked == true)
                    { modelGP.GP_CustomerSource = "朋友介绍"; }
                    if (this.chkQT.Checked == true && this.cmbCus_CustomerSource.Text != "")
                    { modelGP.GP_CustomerSource = this.cmbCus_CustomerSource.Text; }
                    modelGP.GP_Remark = "";
                    modelGP.GP_OrderNumber = "";
                    modelGP.GP_LossReason = "";
                    modelGP.GP_IntroducerCustomerID = "";
                    modelGP.GP_BelongsPersonID = this.cmbtreevBelongsPerson.Tag.ToString().Trim();
                    modelGP.GP_ISIntentionCustomer = 1;
                    clist.Add(GPbll.GetAddCommandInfo(modelGP));

                    //用户信息表
                    //是否选出来的数据  是则修改
                    if (this.selected)
                    {
                        model = ctbll.GetModel(this.UsertID);
                        model.Cus_Name = LYFZ.BLL.OtherCommonModel.ClearSpecialCharacter(this.txtCus_Name.Text);
                        model.Cus_NamePinyin = LYFZ.Command.Command_ChineseToPinyin.GetChineseSpellPinyin(model.Cus_Name).ToLower();
                        if (this.rdoCus_Sex1_1.Checked == true)
                        { model.Cus_Sex = false; }
                        else { model.Cus_Sex = true; }
                        //判断生日是否有填
                        model.Cus_Birthday = this.txtCus_Birthday.StrValue.Trim();
                        if (model.Cus_Birthday != "")
                        {
                            model.Cus_Zodiac = LYFZ.Command.Command_CalendarTurnLunar.GetZodiac(this.txtCus_Birthday.StrValue.Trim(), this.chkCus_Lunar.Checked);
                            if (chkCus_Lunar.Checked == true)
                            { model.Cus_BirthdayLunar = "1"; }
                            else { model.Cus_BirthdayLunar = "0"; }
                        }
                        model.Cus_QQ = this.txtCus_QQ.Text.ToString().Trim();
                        model.Cus_MicroSignal = this.txtCus_MicroSignal.Text.ToString().Trim();
                        model.Cus_Telephone = StrPhone;
                        model.Cus_FixedPhone = this.txtCus_FixedPhone.Text.ToString().Trim();
                        model.Cus_Region = this.cmbCus_Region.Text.ToString().Trim();
                        model.Cus_Address = this.txtCus_Address.Text.ToString().Trim();
                        model.Cus_WorkUnit = this.txtCus_WorkUnit.Text.ToString().Trim();
                        clist.Add(ctbll.GetUpdateCommandInfo(model));
                    }
                    else
                    {
                        model.Cus_CustomerNumber = LYFZ.BLL.BLL_ErpCustomer.GetClientNumber();
                        model.Cus_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetLocalCompanyInfoID();
                        //model.Cus_Type = "";
                        //model.Cus_ServiceType = "other";
                        model.Cus_Name = LYFZ.BLL.OtherCommonModel.ClearSpecialCharacter(this.txtCus_Name.Text);
                        model.Cus_NamePinyin = LYFZ.Command.Command_ChineseToPinyin.GetChineseSpellPinyin(model.Cus_Name).ToLower();
                        if (this.rdoCus_Sex1_1.Checked == true)
                        { model.Cus_Sex = false; }
                        else
                        { model.Cus_Sex = true; }
                        //判断生日是否有填
                        model.Cus_Birthday = this.txtCus_Birthday.StrValue.Trim();
                        if (model.Cus_Birthday != "")
                        {
                            model.Cus_Zodiac = LYFZ.Command.Command_CalendarTurnLunar.GetZodiac(this.txtCus_Birthday.StrValue.Trim(), this.chkCus_Lunar.Checked);
                            if (chkCus_Lunar.Checked == true)
                            { model.Cus_BirthdayLunar = "1"; }
                            else { model.Cus_BirthdayLunar = "0"; }
                        }
                        else
                        {
                            model.Cus_Birthday = "";
                            model.Cus_BirthdayLunar = "";
                            model.Cus_Zodiac = "";
                        }
                        model.Cus_DayForMarriage = "";
                        model.Cus_DayForMarriageLunar = "";
                        model.Cus_Relations = "";
                        model.Cus_QQ = this.txtCus_QQ.Text.ToString().Trim();
                        model.Cus_MicroSignal = this.txtCus_MicroSignal.Text.ToString().Trim();
                        model.Cus_Telephone = StrPhone;
                        model.Cus_FixedPhone = this.txtCus_FixedPhone.Text.ToString().Trim();
                        model.Cus_Region = this.cmbCus_Region.Text.ToString().Trim();
                        model.Cus_Address = this.txtCus_Address.Text.ToString().Trim();
                        model.Cus_WorkUnit = this.txtCus_WorkUnit.Text.ToString().Trim();
                        model.Cus_BabyWeight = "";
                        model.Cus_BornHospital = "";
                        model.Cus_CustomerSource = "";
                        model.Cus_Status = "";
                        model.Cus_LossReason = "";
                        model.Cus_DegreeOfIntent = "";
                        model.Cus_TrackName = "";
                        model.Cus_Remark = "";
                        model.Cus_CreateDateTime = strTime;
                        model.Cus_Grade = "";
                        model.Cus_CreateName = userID;
                        clist.Add(ctbll.GetAddCommandInfo(model));
                    }
                    //成员表
                    //如果选中的是儿童  关系处不是本人
                    if (comType.Text == "儿童")
                    {
                        modelGM.GM_CustomerGroupID = Kehuzu;
                        modelGM.GM_CustomerID = model.Cus_CustomerNumber;
                        modelGM.GM_Master = 1;
                        modelGM.GM_ProtagonistCustomer = 0;
                        modelGM.GM_RelatedPersonID = model.Cus_CustomerNumber;
                        modelGM.GM_Relation = "亲人";
                        modelGM.GM_IsOrder = 0;
                        modelGM.GM_IsOrderNumber = "";
                    }
                    else
                    {
                        modelGM.GM_CustomerGroupID = Kehuzu;
                        modelGM.GM_CustomerID = model.Cus_CustomerNumber;
                        modelGM.GM_Master = 1;
                        modelGM.GM_ProtagonistCustomer = 0;
                        modelGM.GM_RelatedPersonID = model.Cus_CustomerNumber;
                        modelGM.GM_Relation = "本人";
                        modelGM.GM_IsOrder = 0;
                        modelGM.GM_IsOrderNumber = "";
                    }
                    modelGM.GM_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetLocalCompanyInfoID();
                    clist.Add(GMbll.GetAddCommandInfo(modelGM));
                    #endregion
                    if (clist.Count > 0)
                    {
                        if (LYFZ.BLL.BaseBllOperate.ExecuteSqlTran(clist) >= 0)
                        {
                            DAL_ErpCustomer.UpdateAggregationCustomer(modelGP.GP_CustomerGroupID);
                            this.GMID = Kehuzu;
                            this.IsAdd = true;
                            //日志
                            LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(LYFZ.EnumPublic.SystemLogsType.添加客户资料, "添加儿童版客户资料:'" + model.Cus_Name + "'；客户组=" + modelGM.GM_CustomerGroupID + ",时间：" + SDateTime.Now, LYFZ.BLL.BLL_ErpUser.UsersModel.User_EmployeeID, LYFZ.BLL.BLL_ErpUser.UsersModel.User_Name);
                            MessageBoxCustom.Show("保存成功");
                        }
                        else
                        { MessageBoxCustom.Show("保存失败！"); }
                        return;
                    }
                }
                //修改
                else
                {
                    clist = new List<Helper.CommandInfo>();
                    modelGP = GPbll.GetModel("GP_CustomerGroupID", this.GMID);
                    modellist = GMbll.GetModelList("GM_CustomerGroupID='" + this.GMID + "' and GM_Master=1 ");
                    modelGM = modellist[0];
                    model = ctbll.GetModel("Cus_CustomerNumber", modellist[0].GM_CustomerID);
                    model.Cus_Name = this.txtCus_Name.Text;
                    model.Cus_Sex = this.rdoCus_Sex1_1.Checked == true ? false : true;
                    model.Cus_Telephone = StrPhone;
                    model.Cus_Birthday = this.txtCus_Birthday.StrValue;
                    model.Cus_BirthdayLunar = this.chkCus_Lunar.Checked == true ? "1" : "0";
                    model.Cus_Address = this.txtCus_Address.Text;
                    model.Cus_FixedPhone = this.txtCus_FixedPhone.Text;
                    model.Cus_MicroSignal = this.txtCus_MicroSignal.Text;
                    model.Cus_QQ = this.txtCus_QQ.Text;
                    model.Cus_WorkUnit = this.txtCus_WorkUnit.Text;
                    model.Cus_Region = this.cmbCus_Region.Text;
                    clist.Add(ctbll.GetUpdateCommandInfo(model));

                    item = comType.SelectedItem as ListItem;
                    modelGP.GP_CustomerType = Convert.ToInt32(item.Value);
                    modelGP.GP_DegreeOfIntent = cmbDegree.Text;
                    modelGP.GP_CustomerStatus = this.cmbtreevClientStatus.Text.Trim() == "跟进中" ? "意向" : this.cmbtreevClientStatus.Text.Trim();
                    modelGP.GP_LossType = this.cmbtreevClientStatusType.Text.Trim();
                    modelGP.GP_LossReason = this.txtClientStatusReason.Text.Trim();
                    if (this.chkLKH.Checked == false && this.chkPYJS.Checked == false && this.chkQT.Checked == false)
                    {
                        modelGP.GP_CustomerSource = "";
                    }
                    if (this.chkLKH.Checked == true)
                    {
                        modelGP.GP_CustomerSource = "老客户";
                    }
                    if (this.chkPYJS.Checked == true)
                    {
                        modelGP.GP_CustomerSource = "朋友介绍";
                    }
                    if (this.chkQT.Checked == true && this.cmbCus_CustomerSource.Text != "")
                    {
                        modelGP.GP_CustomerSource = this.cmbCus_CustomerSource.Text;
                    }
                    if (this.cmbtreevBelongsPerson.Tag != null && this.cmbtreevBelongsPerson.Visible)
                    {
                        modelGP.GP_BelongsPersonID = this.cmbtreevBelongsPerson.Tag.ToString().Trim();
                    }
                    clist.Add(GPbll.GetUpdateCommandInfo(modelGP));

                    if (item.Value == "1")
                    {
                        modelGM.GM_Master = 1;
                        modelGM.GM_ProtagonistCustomer = 0;
                        modelGM.GM_Relation = "亲人";
                        clist.Add(GMbll.GetUpdateCommandInfo(modelGM));
                    }
                    else
                    {
                        modelGM.GM_Master = 1;
                        modelGM.GM_ProtagonistCustomer = 0;
                        modelGM.GM_Relation = "本人";
                        clist.Add(GMbll.GetUpdateCommandInfo(modelGM));
                    }
                    if (clist.Count > 0)
                    {
                        if (LYFZ.BLL.BaseBllOperate.ExecuteSqlTran(clist) >= 0)
                        {
                            DAL_ErpCustomer.UpdateAggregationCustomer(modelGP.GP_CustomerGroupID);
                            this.IsAdd = true;
                            //日志
                            LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(LYFZ.EnumPublic.SystemLogsType.修改客户资料, "修改儿童版客户资料:'" + model.Cus_Name + "',客户组：" + modelGM.GM_CustomerGroupID + ",时间：" + SDateTime.Now, LYFZ.BLL.BLL_ErpUser.UsersModel.User_EmployeeID, LYFZ.BLL.BLL_ErpUser.UsersModel.User_Name);
                            MessageBoxCustom.Show("保存成功");
                        }
                        else { MessageBoxCustom.Show("保存失败！"); }
                        return;
                    }
                }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 手机号匹配
        /// </summary>
        void txtCus_Telephone_TextChanged(object sender, EventArgs e)
        {
            try
            {
                if (this.GMID == "")
                {
                    string StrPhone = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.MaskedTextBoxExGetText(this.txtCus_Telephone);
                    if (StrPhone != "")
                    {
                        Is = true;
                        DataTable tblClient = orbll.GetView_Custom("tb_ErpCustomer", StrWhere: "Cus_Telephone Like '" + StrPhone.Trim() + "%'", ShowColumnName: "ID,Cus_Name,Cus_Telephone,Cus_Birthday,Cus_BirthdayLunar,Cus_Address,Cus_Sex,Cus_FixedPhone,Cus_MicroSignal,Cus_QQ,Cus_WorkUnit,Cus_Region").Tables[0];
                        if (tblClient.Rows.Count > 0)
                        {
                            if (StrPhone.Length == 11 && tblClient.Rows.Count == 1)
                            {
                                if (MessageBoxCustom.Show("有一条与客户相关的数据，是否加载！", "提示消息！", MessageBoxButtons.YesNo) == DialogResult.Yes)
                                {
                                    this.UsertID = Convert.ToInt32(tblClient.Rows[0]["ID"].ToString());
                                    this.txtCus_Name.Text = tblClient.Rows[0]["Cus_Name"].ToString();
                                    this.txtCus_Telephone.Text = tblClient.Rows[0]["Cus_Telephone"].ToString();
                                    this.txtCus_Birthday.Text = tblClient.Rows[0]["Cus_Birthday"].ToString();
                                    this.chkCus_Lunar.Checked = tblClient.Rows[0]["Cus_BirthdayLunar"].ToString() == "1" ? true : false;
                                    this.txtCus_Address.Text = tblClient.Rows[0]["Cus_Address"].ToString();
                                    if (Convert.ToBoolean(tblClient.Rows[0]["Cus_Sex"].ToString()) == false)
                                    { this.rdoCus_Sex1_1.Checked = true; }
                                    else
                                    { this.rdoCus_Sex1_2.Checked = true; }
                                    this.txtCus_FixedPhone.Text = tblClient.Rows[0]["Cus_FixedPhone"].ToString();
                                    this.txtCus_MicroSignal.Text = tblClient.Rows[0]["Cus_MicroSignal"].ToString();
                                    this.txtCus_QQ.Text = tblClient.Rows[0]["Cus_QQ"].ToString();
                                    this.txtCus_WorkUnit.Text = tblClient.Rows[0]["Cus_WorkUnit"].ToString();
                                    this.cmbCus_Region.Text = tblClient.Rows[0]["Cus_Region"].ToString();
                                    this.selected = true;
                                    this.txtCus_Name.Enabled = false;
                                    this.txtCus_Telephone.Enabled = false;
                                    this.panXiangxi.Visible = false;
                                    return;
                                }
                            }
                            this.panXiangxi.Visible = true;
                            this.txtXiangxi.Text = "查找到 " + tblClient.Rows.Count + "条，相关客户数据";
                        }
                        else
                        { this.panXiangxi.Visible = false; }
                    }
                    else
                    { this.panXiangxi.Visible = false; }
                }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 姓名匹配
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtCus_Name_EventTextBoxEx_TextChanged(object sender, EventArgs e)
        {
            try
            {
                if (this.GMID == "")
                {
                    if (this.txtCus_Name.Text != "")
                    {
                        Is = false;
                        DataTable tblClient = orbll.GetView_Custom("tb_ErpCustomer", StrWhere: " Cus_Name like '%" + this.txtCus_Name.Text.Trim() + "%' and  Cus_Type != '儿童'", ShowColumnName: "ID").Tables[0];
                        if (tblClient.Rows.Count > 0)
                        {
                            this.panXiangxi.Visible = true;
                            this.txtXiangxi.Text = "查找到 " + tblClient.Rows.Count + "条，相关客户数据";
                        }
                        else
                        { this.panXiangxi.Visible = false; }
                    }
                    else { this.panXiangxi.Visible = false; }
                }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 选择详情
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnXiangXi_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.GMID == "")
                {
                    string StrPhone = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.MaskedTextBoxExGetText(this.txtCus_Telephone);
                    LYFZ.Software.MainBusiness.DoorCityProcess.SuperSmallForm.OrderHistoryCustomerSuperSmallForm frm = new DoorCityProcess.SuperSmallForm.OrderHistoryCustomerSuperSmallForm();
                    if (Is)
                    { frm.StrWhere = "Cus_Telephone Like '" + StrPhone.Trim() + "%'"; }
                    else
                    { frm.StrWhere = " Cus_Name like '%" + this.txtCus_Name.Text.Trim() + "%' and  Cus_Type != '儿童'"; }
                    frm.ShowDialog();
                    if (frm.IsSaveed)
                    {
                        //判断是否有相同客户存在
                        if (frm.model != null)
                        {
                            UsertID = frm.model.ID;
                            //移除事件
                            this.txtCus_Name.EventTextBoxEx_TextChanged -= txtCus_Name_EventTextBoxEx_TextChanged;
                            this.txtCus_Telephone.TextChanged -= txtCus_Telephone_TextChanged;

                            this.txtCus_Name.Text = frm.model.Cus_Name;
                            this.txtCus_Telephone.Text = frm.model.Cus_Telephone;
                            //添加回来
                            this.txtCus_Name.EventTextBoxEx_TextChanged += txtCus_Name_EventTextBoxEx_TextChanged;
                            this.txtCus_Telephone.TextChanged += txtCus_Telephone_TextChanged;

                            this.txtCus_Birthday.Text = frm.model.Cus_Birthday;
                            this.chkCus_Lunar.Checked = frm.model.Cus_BirthdayLunar == "1" ? true : false;
                            this.txtCus_Address.Text = frm.model.Cus_Address;
                            if (frm.model.Cus_Sex == false)
                            { this.rdoCus_Sex1_1.Checked = true; }
                            else
                            { this.rdoCus_Sex1_2.Checked = true; }
                            this.txtCus_FixedPhone.Text = frm.model.Cus_FixedPhone;
                            this.txtCus_MicroSignal.Text = frm.model.Cus_MicroSignal;
                            this.txtCus_QQ.Text = frm.model.Cus_QQ;
                            this.txtCus_WorkUnit.Text = frm.model.Cus_WorkUnit;
                            this.cmbCus_Region.Text = frm.model.Cus_Region;
                            this.txtCus_Name.Enabled = false;
                            this.txtCus_Telephone.Enabled = false;
                            this.selected = true;
                        }
                        this.panXiangxi.Visible = false;
                    }
                }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 打电话按钮
        /// </summary>
        void btnDial_Click(object sender, EventArgs e)
        { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.PhoneCall(this.txtCus_Telephone); }
        /// <summary>
        /// QQ按钮
        /// </summary>
        void btnQQCall_Click(object sender, EventArgs e)
        { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.QQCall(txtCus_QQ.Text.Trim()); }
        /// <summary>
        /// 重置按钮
        /// </summary>
        void btnClear_Click(object sender, EventArgs e)
        {
            this.txtCus_Name.Text = "";
            this.txtCus_Telephone.Text = "";
            this.txtCus_Birthday.Text = "";
            this.chkCus_Lunar.Checked = false;
            this.txtCus_Address.Text = "";
            this.rdoCus_Sex1_1.Checked = true;
            this.txtCus_FixedPhone.Text = "";
            this.txtCus_MicroSignal.Text = "";
            this.txtCus_QQ.Text = "";
            this.txtCus_WorkUnit.Text = "";
            this.cmbCus_Region.Text = "";
            this.comType.Text = "";
            this.chkLKH.Checked = false;
            this.chkQT.Checked = false;
            this.chkPYJS.Checked = false;
            this.cmbCus_CustomerSource.Text = "";
            this.txtCus_Name.Enabled = true;
            this.txtCus_Telephone.Enabled = true;
            this.selected = false;
        }
        /// <summary>
        /// 关闭
        /// </summary>
        void btnClose_Click(object sender, EventArgs e)
        { this.Close(); }
        /// <summary>
        /// 删除沟通记录
        /// </summary>
        void btnDelete_Click(object sender, EventArgs e)
        {
            try
            {
                BLL.BLL_ErpCustomersTrackRecord bll = new BLL.BLL_ErpCustomersTrackRecord();
                if (MessageBoxCustom.Show("确定删除！", "提示消息！", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    if (bll.Delete(Convert.ToInt32(dgvData.CurrentRow.Cells["ID"].Value.ToString().Trim())))
                    { BindDgvTaskView(); MessageBoxCustom.Show("删除成功！"); }
                    else
                    { MessageBoxCustom.Show("删除失败！"); }
                }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 设置客户来源
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnCustomerSource_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.InitialSet.FrmSystemSet set = new InitialSet.FrmSystemSet();
            set.TypeName = "AAAAAAF";
            set.Version = "Version";
            if (set.ShowDialog() == DialogResult.OK)
            { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_ClientSourec("AAAAAAF", this.cmbCus_CustomerSource, strHideFiled: "BFACBABGBGBJGDHIE,BFAFBCBADBDCABFDD"); }
        }
        /// <summary>
        /// 设置客户区域
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        void btnRegion_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.InitialSet.FrmSystemSet set = new InitialSet.FrmSystemSet();
            set.TypeName = "AAAAAAC";
            set.Version = "Version";
            if (set.ShowDialog() == DialogResult.OK)
            { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_ClientSourec("AAAAAAC", this.cmbCus_Region, strHideFiled: ""); }
        }
        /// <summary>
        /// 客户状态
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void cmbtreevClientStatus_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            switch (this.cmbtreevClientStatus.Text.Trim())
            {
                case "流失":
                    this.panelClientStatusReason.Visible = true;
                    this.panelBelongsPerson.Visible = false;
                    this.lblClientStatusReason.Text = this.cmbtreevClientStatus.Text.Trim() + "原因：";
                    break;
                case "跟进中":
                    this.panelClientStatusReason.Visible = false;
                    this.panelBelongsPerson.Visible = true;
                    this.panelBelongsPerson.Location = this.panelClientStatusReason.Location;
                    break;
                default: this.panelClientStatusReason.Visible = false; break;
            }
        }
        /// <summary>
        /// 其他
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkQT_Click(object sender, EventArgs e)
        {
            this.chkLKH.Checked = false;
            this.chkPYJS.Checked = false;
            this.cmbCus_CustomerSource.Enabled = true;
        }
        /// <summary>
        /// 朋友介绍
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkPYJS_Click(object sender, EventArgs e)
        {
            this.cmbCus_CustomerSource.Enabled = false;
            this.chkLKH.Checked = false;
            this.chkQT.Checked = false;
            this.cmbCus_CustomerSource.Text = "";
        }
        /// <summary>
        /// 老客户
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkLKH_Click(object sender, EventArgs e)
        {
            this.chkPYJS.Checked = false;
            this.chkQT.Checked = false;
            this.cmbCus_CustomerSource.Enabled = false;
            this.cmbCus_CustomerSource.Text = "";
        }
        /// <summary>
        /// 列表双击查看备注信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgvData_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (this.dgvData.Columns[e.ColumnIndex].Name.Trim() == "沟通备注")
            {
                if(e.RowIndex==-1)
                {
                    return;
                }
                LYFZ.Software.MainBusiness.CameraControlBook.SuperSmallForm.GetTextRemarkSuperSmallForm frm = new CameraControlBook.SuperSmallForm.GetTextRemarkSuperSmallForm();
                frm.Text = "沟通备注";
                frm.StrValue = this.dgvData.Rows[e.RowIndex].Cells["沟通备注"].Value.ToString();
                frm.ShowDialog();
            }
        }
        /// <summary>
        /// 绑定数据
        /// </summary>
        void BindDgvTaskView()
        {
            try
            {
                DataTable tbl = orbll.GetView_Custom("tb_ErpCustomersTrackRecord left join tb_ErpUser on User_EmployeeID = TR_TracePersonID", StrWhere: "TR_CustomerGroupID='" + this.GMID + "'", filedOrder: "TR_CustomerGroupID DESC", ShowColumnName: "tb_ErpCustomersTrackRecord.ID, TR_CustomerGroupID, User_Name as 客服人员, TR_Communicationstatus as 沟通状态, TR_TraceDateTime as 沟通时间, TR_TraceTimeLength as 沟通时长, TR_TraceType as 沟通类型, TR_TraceWay as 沟通方式, TR_SpecificMatters as 具体事项, TR_Remark as 沟通备注").Tables[0];
                if (tbl.Rows.Count > 0)
                {
                    if (dgvData.Rows.Count > 0)
                    { this.dgvData.Rows.Clear(); }
                    for (int i = 0; i < tbl.Rows.Count; i++)
                    {
                        DataGridViewRow row = new DataGridViewRow();
                        DataGridViewCell cell = null;

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = tbl.Rows[i]["客服人员"].ToString().ToString().Trim();
                        row.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = tbl.Rows[i]["沟通状态"].ToString();
                        row.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(tbl.Rows[i]["沟通时间"], "yyyy-MM-dd");
                        row.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = tbl.Rows[i]["沟通时长"].ToString();
                        row.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = tbl.Rows[i]["沟通类型"].ToString();
                        row.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = tbl.Rows[i]["沟通方式"].ToString();
                        row.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = tbl.Rows[i]["具体事项"].ToString();
                        row.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = tbl.Rows[i]["沟通备注"].ToString();
                        row.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = tbl.Rows[i]["ID"].ToString();
                        row.Cells.Add(cell);

                        this.dgvData.Rows.Add(row);
                    }
                }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }

        private void InitializeComponent()
        {
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FrmAddInterestedBuyers));
            this.panelClientStatusReason.SuspendLayout();
            this.panXiangxi.SuspendLayout();
            this.panelBelongsPerson.SuspendLayout();
            this.plFormMainContent.SuspendLayout();
            this.SuspendLayout();
            // 
            // btnClientStatusTypeSet
            // 
            this.btnClientStatusTypeSet.BackImg = ((System.Drawing.Bitmap)(resources.GetObject("btnClientStatusTypeSet.BackImg")));
            // 
            // txtClientStatusReason
            // 
            this.txtClientStatusReason.Lines = new string[0];
            // 
            // txtMicroID
            // 
            this.txtMicroID.Lines = new string[] {
        "未绑定"};
            // 
            // btnUnbind
            // 
            this.btnUnbind.BackImg = ((System.Drawing.Bitmap)(resources.GetObject("btnUnbind.BackImg")));
            this.btnUnbind.Enabled = false;
            // 
            // txtCus_Address
            // 
            this.txtCus_Address.Lines = new string[0];
            // 
            // txtXiangxi
            // 
            this.txtXiangxi.Lines = new string[0];
            // 
            // btnXiangXi
            // 
            this.btnXiangXi.BackImg = ((System.Drawing.Bitmap)(resources.GetObject("btnXiangXi.BackImg")));
            // 
            // txtCus_MicroSignal
            // 
            this.txtCus_MicroSignal.Lines = new string[0];
            // 
            // btnClear
            // 
            this.btnClear.BackImg = ((System.Drawing.Bitmap)(resources.GetObject("btnClear.BackImg")));
            // 
            // btnClose
            // 
            this.btnClose.BackImg = ((System.Drawing.Bitmap)(resources.GetObject("btnClose.BackImg")));
            // 
            // btnSave
            // 
            this.btnSave.BackImg = ((System.Drawing.Bitmap)(resources.GetObject("btnSave.BackImg")));
            // 
            // btnRegion
            // 
            this.btnRegion.BackImg = ((System.Drawing.Bitmap)(resources.GetObject("btnRegion.BackImg")));
            // 
            // btnCustomerSource
            // 
            this.btnCustomerSource.BackImg = ((System.Drawing.Bitmap)(resources.GetObject("btnCustomerSource.BackImg")));
            // 
            // btnQQCall
            // 
            this.btnQQCall.BackImg = ((System.Drawing.Bitmap)(resources.GetObject("btnQQCall.BackImg")));
            // 
            // btnDial
            // 
            this.btnDial.BackImg = ((System.Drawing.Bitmap)(resources.GetObject("btnDial.BackImg")));
            // 
            // txtCus_FixedPhone
            // 
            this.txtCus_FixedPhone.Lines = new string[0];
            // 
            // txtCus_Name
            // 
            this.txtCus_Name.Lines = new string[0];
            // 
            // txtCus_QQ
            // 
            this.txtCus_QQ.Lines = new string[0];
            // 
            // txtCus_WorkUnit
            // 
            this.txtCus_WorkUnit.Lines = new string[0];
            // 
            // FrmAddInterestedBuyers
            // 
            this.BottomBgImage = ((System.Drawing.Bitmap)(resources.GetObject("$this.BottomBgImage")));
            this.ClientSize = new System.Drawing.Size(930, 610);
            this.CustomBorderStyles.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(63)))), ((int)(((byte)(109)))), ((int)(((byte)(139)))));
            this.Name = "FrmAddInterestedBuyers";
            this.TitleBgImage = ((System.Drawing.Bitmap)(resources.GetObject("$this.TitleBgImage")));
            this.Controls.SetChildIndex(this.btnAppFormMaximize, 0);
            this.Controls.SetChildIndex(this.btnAppFormExit, 0);
            this.Controls.SetChildIndex(this.btnAppFormMinimize, 0);
            this.Controls.SetChildIndex(this.btnAppFormMenu, 0);
            this.Controls.SetChildIndex(this.btnAppFormSkin, 0);
            this.Controls.SetChildIndex(this.plFormMainContent, 0);
            this.panelClientStatusReason.ResumeLayout(false);
            this.panelClientStatusReason.PerformLayout();
            this.panXiangxi.ResumeLayout(false);
            this.panelBelongsPerson.ResumeLayout(false);
            this.panelBelongsPerson.PerformLayout();
            this.plFormMainContent.ResumeLayout(false);
            this.ResumeLayout(false);

        }
    }
}