using LYFZ.BLL;
using LYFZ.ComponentLibrary;
using LYFZ.DAL;
using LYFZ.Model;
using LYFZ.Software.MainBusiness.Customers.OldCustomer;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace LYFZ.Software.MainBusiness.Customers
{
    public partial class FrmOldCustomerEditBaby : LYFZ.Software.UI.Customers.FrmOldCustomerEditBaby
    {
        Boolean bl = false;
        public FrmOldCustomerEditBaby()
        {
            this.Load += FrmOldCustomerEditBaby_Load;
            this.FormClosed += FrmOldCustomerEditBaby_FormClosed;
            this.dgvData.CellDoubleClick += dgv2_CellDoubleClick;
            this.chkLKH.Click += chkLKH_Click;
            this.chkPYJS.Click += chkPYJS_Click;
            this.chkQT.Click += chkQT_Click;
            this.btnCustomerSource.Click += btnCustomerSource_Click;
            this.btnRegion.Click += btnRegion_Click;
            this.txtBaby_Birthday.Leave += txtBaby_Birthday_Leave;
            this.btnSave.Click += btnSave_Click;
            this.btnlevel.Click += btnlevel_Click;
            this.btnAdding.Click += btnAdding_Click;
            this.btnDelete.Click += btnDelete_Click;
            this.btnClose.Click += btnClose_Click;
            this.btnQQCall.Click += btnQQCall_Click;
            this.btnDial.Click += btnDial_Click;
            this.txtCus_FixedPhone.KeyPress += txtCus_FixedPhone_KeyPress;
            this.txtHistory_Money.KeyPress += txtHistory_Money_KeyPress;
            this.btnUnbind.Click += btnUnbind_Click;
            this.chkBaby_Lunar.Click += chkBaby_Lunar_Click;
        }

        void chkBaby_Lunar_Click(object sender, EventArgs e)
        {
            txtBaby_Birthday_Leave(this, null);
        }

        /// <summary>
        /// 客户类型  1老客户 2意向客户
        /// </summary>
        public int type;
        /// <summary>
        /// 拨打电话
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnDial_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.PhoneCall(this.txtCus_Telephone);
        }
        /// <summary>
        /// QQ呼叫
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnQQCall_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.QQCall(txtCus_QQ.Text.Trim());
        }
        /// <summary>
        /// 客户组编号
        /// </summary>
        public string GM;
        /// <summary>
        /// 主联系人ID
        /// </summary>
        string BabyID = "";
        /// <summary>
        /// 主联系人编号
        /// </summary>
        string SerialnumberID = "";
        /// <summary>
        /// 页面联系人ID
        /// </summary>
        string aincontactID = "";
        /// <summary>
        /// 客户组ID
        /// </summary>
        string GMID = "";
        LYFZ.BLL.BLL_ErpCustomer ctbll = new BLL.BLL_ErpCustomer();
        LYFZ.BLL.BLL_ErpCustomerGroupMembers gmbll = new BLL_ErpCustomerGroupMembers();
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL_ErpOrder();

        BLL.BLL_OldOrderHistory Bll_ooh = new BLL_OldOrderHistory();
        Model.Model_OldOrderHistory model_ooh = null;
        /// <summary>
        /// 窗体关闭事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void FrmOldCustomerEditBaby_FormClosed(object sender, FormClosedEventArgs e)
        {
            if (bl)
            {
                this.DialogResult = DialogResult.OK;
            }
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void FrmOldCustomerEditBaby_Load(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.HidePhoneControls(this.txtCus_Telephone);
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.HidePhoneControls(this.txtCus_FixedPhone);
            this.Text = "修改儿童版老客户";
            this.dgvData.Rows.Clear();
            if (type != 2)
            {
                if (Bll_ooh.Exists("History_ID", GM))
                { model_ooh = Bll_ooh.GetModel("History_ID", GM); }
            }

            this.btnUnbind.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.MicroInfo, CustomAttributes.OperatingAuthority.MicroInfo_Unbind);
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BFADBIBEFCFCIDCDG", this.cmbtreevlevel, 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.BindComboBoxTreeView_SystemCategory("BFABDBAJBJCEBDJCJ", this.cmbtreevRelations);
            LYFZ.BLL.BLL_OrderCustomer bll = new BLL_OrderCustomer();
            LYFZ.BLL.BLL_ErpCustomerGroup GPbll = new BLL_ErpCustomerGroup();
            LYFZ.Model.Model_ErpCustomerGroup ModelGP = GPbll.GetModel("GP_CustomerGroupID", GM);
            if (ModelGP.ID > 0)
            {
                switch (ModelGP.GP_CustomerSource.Trim())
                {
                    case "老客户":
                        this.chkLKH.Checked = true;
                        this.chkLKH_Click(null, null);
                        break;
                    case "朋友介绍":
                        this.chkPYJS.Checked = true;
                        this.chkPYJS_Click(null, null);
                        break;
                    default:
                        this.chkQT.Checked = true;
                        this.chkQT_Click(null, null);
                        cmbCus_CustomerSource.TextFindTag(ModelGP.GP_CustomerSource);
                        break;
                }
                DataTable dt = orbll.GetView_Custom("tb_ErpCustomerGroupMembers Left Join tb_ErpCustomer on GM_CustomerID = Cus_CustomerNumber", StrWhere: "GM_CustomerGroupID = '" + GM + "'", ShowColumnName: "tb_ErpCustomer.ID,Cus_Name,Cus_Sex,Cus_Birthday,Cus_BirthdayLunar,Cus_QQ,Cus_MicroSignal,Cus_Zodiac,Cus_DayForMarriage,Cus_DayForMarriageLunar,Cus_Telephone,Cus_FixedPhone,Cus_Region,Cus_Address,Cus_WorkUnit,Cus_CustomerNumber,Cus_Grade,Cus_Type,Cus_OpenID,GM_CustomerGroupID,GM_CustomerID,GM_RelatedPersonID,GM_Relation,tb_ErpCustomerGroupMembers.ID as GMID", filedOrder: "tb_ErpCustomer.ID").Tables[0];
                if (dt.Rows.Count > 0)
                {
                    bool IsTrue = false;
                    for (int t = 0; t < dt.Rows.Count; t++)
                    {
                        if (dt.Rows[t]["Cus_Type"].ToString().Trim() != "儿童")
                        {
                            if (!IsTrue)
                            {
                                //性别
                                if (!Convert.ToBoolean(dt.Rows[t]["Cus_Sex"]))
                                { this.radCus_Nan.Checked = true; }
                                else
                                { radCus_Nv.Checked = true; }
                                //公历
                                if (dt.Rows[t]["Cus_BirthdayLunar"].ToString().Trim() == "1")
                                { this.chkCus_Lunar.Checked = true; }
                                //客户组ID
                                this.GMID = dt.Rows[t]["GMID"].ToString().Trim();
                                //ID
                                this.aincontactID = dt.Rows[t]["ID"].ToString().Trim();
                                //获取姓名
                                this.txtCus_Name.Text = dt.Rows[t]["Cus_Name"].ToString().Trim();
                                //生日 
                                this.txtCus_Birthday.StrValue = dt.Rows[t]["Cus_Birthday"].ToString().Trim();
                                //区域
                                this.cmbCus_Region.Text = dt.Rows[t]["Cus_Region"].ToString().Trim();
                                //手机
                                this.txtCus_Telephone.Text = dt.Rows[t]["Cus_Telephone"].ToString().Trim();
                                //固话
                                this.txtCus_FixedPhone.Text = dt.Rows[t]["Cus_FixedPhone"].ToString().Trim();
                                //QQ
                                this.txtCus_QQ.Text = dt.Rows[t]["Cus_QQ"].ToString().Trim();
                                //微信
                                this.txtCus_MicroSignal.Text = dt.Rows[t]["Cus_MicroSignal"].ToString().Trim();
                                //单位
                                this.txtCus_WorkUnit.Text = dt.Rows[t]["Cus_WorkUnit"].ToString().Trim();
                                //地址
                                this.txtCus_Address.Text = dt.Rows[t]["Cus_Address"].ToString().Trim();
                                //关系
                                this.cmbtreevRelations.TextFindTag(dt.Rows[t]["GM_Relation"].ToString());

                                BindMicroData(dt.Rows[t]["Cus_CustomerNumber"].ToString().Trim());
                                /*if (!string.IsNullOrEmpty(dt.Rows[t]["Cus_OpenID"].ToString().Trim()))
                                { this.txtMicroID.Text = "已绑定"; }
                                else
                                { this.txtMicroID.Text = "未绑定"; }*/
                                IsTrue = true;
                            }
                            else
                            {
                                DataGridViewRow dgvr = new DataGridViewRow();
                                DataGridViewCell cell = null;
                                //姓名  0
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_Name"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //性别    1
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_Sex"].ToString().Trim() == "False" ? "男" : "女";
                                dgvr.Cells.Add(cell);
                                //生日    2
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_Birthday"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //生日历类  3
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = Lunar(dt.Rows[t]["Cus_BirthdayLunar"].ToString().Trim());
                                dgvr.Cells.Add(cell);
                                //QQ    4
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_QQ"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //微信    5
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_MicroSignal"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //手机    6
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_Telephone"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //固定电话  7
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_FixedPhone"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //地区    8
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_Region"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //地址    9
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_Address"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //工作单位  10
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_WorkUnit"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //ID  11
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["ID"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //联系人  12
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["GM_Relation"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //客户编号 14
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_CustomerNumber"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //GMID  13
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["GMID"].ToString().Trim();
                                dgvr.Cells.Add(cell);
                                //等级
                                cell = new DataGridViewTextBoxCell();
                                cell.Value = dt.Rows[t]["Cus_Grade"].ToString().Trim();
                                dgvr.Cells.Add(cell);

                                dgvData.Rows.Add(dgvr);
                            }
                        }
                        else
                        {
                            if (model_ooh != null)
                            {
                                this.txtHistory_Type.Text = model_ooh.History_Type;
                                this.txtHistory_Money.Text = model_ooh.History_Money.ToString();
                                DateTime ti1 = Convert.ToDateTime("1900-01-01");
                                if (DateTime.Compare(model_ooh.History_OrderTime, ti1) < 0)
                                { this.txtHistory_OrderTime.StrValue = ""; }
                                else
                                { this.txtHistory_OrderTime.StrValue = model_ooh.History_OrderTime.ToString("yyyy-MM-dd"); }
                            }
                            //宝宝ID
                            this.BabyID = dt.Rows[t]["ID"].ToString().Trim();
                            //宝贝姓名
                            this.txtBaby_name.Text = dt.Rows[t]["Cus_Name"].ToString();
                            //宝贝性别
                            if (!Convert.ToBoolean(dt.Rows[t]["Cus_Sex"]))
                            { this.radCus_Nan.Checked = true; }
                            else
                            { this.radioBaby_nv.Checked = true; }
                            //农历新历
                            string i = dt.Rows[t]["Cus_BirthdayLunar"].ToString();
                            if (dt.Rows[t]["Cus_BirthdayLunar"].ToString().Trim() == "1")
                            { this.chkBaby_Lunar.Checked = true; }
                            //宝贝生日
                            this.txtBaby_Birthday.StrValue = dt.Rows[t]["Cus_Birthday"].ToString();
                            //宝宝生肖
                            this.cmbBaby.Text = dt.Rows[t]["Cus_Zodiac"].ToString();
                            //等级
                            this.cmbtreevlevel.TextFindTag(dt.Rows[t]["Cus_Grade"].ToString());
                        }
                    }
                }
            }
        }
        /// <summary>
        /// 客户微信绑定
        /// </summary>
        void BindMicroData(string customerID)
        {
            BLL_CustomerAndWxOpen bllWxOpen = new BLL_CustomerAndWxOpen();
            DataTable dt = bllWxOpen.GetCustomerDataByCustomerID(customerID);

            BLL.BLL_ErpMicroInterface bllInterface = new BLL.BLL_ErpMicroInterface();
            LYFZ.Model.Model_ErpMicroInterface modInterFace = new Model.Model_ErpMicroInterface();
            modInterFace = bllInterface.GetModelMicroInterface(LYFZ.BLL.BLL_ErpCompanyInfo.CurrentCompanyInfoID);
            if (string.IsNullOrEmpty(modInterFace.AppID))
            {
                modInterFace.AppID = "";
            }
            DataRow[] drList = dt.Select(" APPID = '" + modInterFace.AppID + "' ");

            if (drList.Length > 0)
            { this.txtMicroID.Text = "已绑定"; }
            else
            { this.txtMicroID.Text = "未绑定"; }
        }

        /// <summary>
        /// 解除客户微信绑定
        /// </summary>
        /// <param name="customerID"></param>
        bool UnBindMicroData(string customerID)
        {
            BLL_CustomerAndWxOpen bllWxOpen = new BLL_CustomerAndWxOpen();
            DataTable dt = bllWxOpen.GetCustomerDataByCustomerID(customerID);

            BLL.BLL_ErpMicroInterface bllInterface = new BLL.BLL_ErpMicroInterface();
            LYFZ.Model.Model_ErpMicroInterface modInterFace = new Model.Model_ErpMicroInterface();
            modInterFace = bllInterface.GetModelMicroInterface(LYFZ.BLL.BLL_ErpCompanyInfo.CurrentCompanyInfoID);
            if (string.IsNullOrEmpty(modInterFace.AppID))
            {
                modInterFace.AppID = "";
            }
            DataRow[] drList = dt.Select(" APPID = '" + modInterFace.AppID + "' ");

            if (drList.Length > 0)
            {
                bllWxOpen.Delete(drList[0]["ID"]);

                dt = bllWxOpen.GetCustomerDataByCustomerID(customerID);
                string strOpenID = "";
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (!string.IsNullOrEmpty(strOpenID))
                    {
                        strOpenID += "/";
                    }
                    strOpenID += dt.Rows[i]["APPID"] + ":" + dt.Rows[i]["WxOpenId"];
                }

                Model_ErpCustomer model = ctbll.GetModel(Convert.ToInt32(this.aincontactID));
                model.Cus_OpenID = strOpenID;
                ctbll.Update(model);

                return true;
                //this.txtMicroID.Text = "已绑定"; 
            }
            else
            {
                return 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 model = ctbll.GetModel(Convert.ToInt32(this.aincontactID));
                model.Cus_OpenID = "";
                model.Cus_UpdateDateTime = SDateTime.Now;
                model.Cus_UpdateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                ctbll.Update(model);
                if (UnBindMicroData(model.Cus_CustomerNumber))
                {
                    MessageBoxCustom.Show("解绑成功！");
                    this.txtMicroID.Text = "未绑定";
                }
                else
                { MessageBoxCustom.Show("解绑失败"); }
            }
        }
        /// <summary>
        /// 获取生肖 
        /// </summary>
        void txtBaby_Birthday_Leave(object sender, EventArgs e)
        {
            int intMasse = this.txtBaby_Birthday.CheckDateValue(this.txtBaby_Birthday, chkBaby_Lunar);
            if (intMasse == 1) { MessageBoxCustom.Show("宝贝生日日期格式输入错误"); return; }
            else if (intMasse == 2)
            { MessageBoxCustom.Show("宝贝生日：" + this.txtBaby_Birthday.StrValue.Trim() + "不是公历日期，若要保存请勾上农历"); return; }
            if (this.txtBaby_Birthday.StrValue.Trim().Length > 0)
            {
                string[] StrArrayList = this.txtBaby_Birthday.StrValue.Trim().Split('-');
                if (SDateTime.Now.Year < Convert.ToInt32(StrArrayList[0]))
                { MessageBoxCustom.Show("您输入的宝贝生日不能大于今年！"); return; }
                this.cmbBaby.Text = LYFZ.Command.Command_CalendarTurnLunar.GetZodiac(this.txtBaby_Birthday.StrValue.Trim(), this.chkBaby_Lunar.Checked);
            }
            else
            { this.cmbBaby.Text = ""; }

            //this.cmbBaby.Text = LYFZ.Command.Command_CalendarTurnLunar.GetZodiac(this.txtBaby_Birthday.StrValue.Trim(), this.chkBaby_Lunar.Checked);
        }
        /// <summary>
        /// 双击dgv事件
        /// </summary>
        void dgv2_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (dgvData.SelectedRows.Count > 0)
            {
                FrmAddContacts from = new FrmAddContacts();
                from.YouID = dgvData.CurrentRow.Cells["ID"].Value.ToString().Trim();
                from.GP = GM;
                from.GMID = dgvData.CurrentRow.Cells["GMID"].Value.ToString().Trim();
                from.Zhuangtai = "编辑";
                if (from.ShowDialog() == DialogResult.OK)
                {
                    if (dgvData.Rows.Count > 0)
                    { dgvData.Rows.Clear(); }
                    FrmOldCustomerEditBaby_Load(null, null);
                    bl = true;
                }
            }
        }
        /// <summary>
        /// 添加联系人
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnAdding_Click(object sender, EventArgs e)
        {
            FrmAddContacts frm = new FrmAddContacts();
            //状态
            frm.Zhuangtai = "添加";
            if (frm.ShowDialog() == DialogResult.OK)
            {
                if (frm.model != null)
                {
                    List<Helper.CommandInfo> clist = new List<Helper.CommandInfo>();
                    Model_ErpCustomer model = frm.model;
                    Model_ErpCustomerGroupMembers modelGMitem = new Model_ErpCustomerGroupMembers();
                    modelGMitem.GM_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetLocalCompanyInfoID();
                    modelGMitem.GM_CustomerGroupID = GM;
                    modelGMitem.GM_CustomerID = model.Cus_CustomerNumber;
                    modelGMitem.GM_Master = 0;
                    modelGMitem.GM_ProtagonistCustomer = 0;
                    modelGMitem.GM_RelatedPersonID = SerialnumberID;
                    modelGMitem.GM_Relation = model.Cus_Relations;
                    modelGMitem.GM_IsOrder = 0;
                    modelGMitem.GM_IsOrderNumber = "";
                    clist.Add(ctbll.GetAddCommandInfo(model));
                    clist.Add(gmbll.GetAddCommandInfo(modelGMitem));
                    if (clist.Count > 0)
                    {
                        if (LYFZ.BLL.BaseBllOperate.ExecuteSqlTran(clist) >= 0)
                        {
                            DAL_ErpCustomer.UpdateAggregationCustomer(GM);
                            bl = true;
                            //日志
                            LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(LYFZ.EnumPublic.SystemLogsType.添加客户资料, "联系人：" + frm.model.Cus_Name + "，添加联系人资料客户组：" + modelGMitem.GM_CustomerGroupID + ",时间：" + SDateTime.Now, LYFZ.BLL.BLL_ErpUser.UsersModel.User_EmployeeID, LYFZ.BLL.BLL_ErpUser.UsersModel.User_Name);
                            MessageBoxCustom.Show("添加成功");
                            if (dgvData.Rows.Count > 0)
                            { dgvData.Rows.Clear(); }
                            FrmOldCustomerEditBaby_Load(null, null);
                        }
                        else { MessageBoxCustom.Show("添加失败"); }
                        return;
                    }
                }
            }
        }
        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param> 
        void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(this.txtCus_Name.Text))
                { 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; }
                    DataTable tblClient = orbll.GetView_Custom("tb_ErpCustomer", StrWhere: "Cus_Telephone = '" + StrPhone + "' and ID <> '" + aincontactID + "' ", ShowColumnName: "ID").Tables[0];
                    if (tblClient.Rows.Count > 0)
                    { MessageBoxCustom.Show("手机号已存在"); return; }
                }
                if (txtBaby_Birthday.StrValue.ToString() != "")
                {
                    int intMasse1 = this.txtBaby_Birthday.CheckDateValue(this.txtBaby_Birthday, this.chkBaby_Lunar);
                    if (intMasse1 == 1) { MessageBoxCustom.Show("宝宝生日日期格式输入错误！"); return; }
                    else if (intMasse1 == 2)
                    { MessageBoxCustom.Show("宝宝生日：" + this.txtBaby_Birthday.StrValue.Trim() + "不是公历日期，若要保存请勾上农历！"); return; }
                }
                int intMasse = this.txtCus_Birthday.CheckDateValue(this.txtCus_Birthday, chkCus_Lunar);
                if (intMasse == 1) { MessageBoxCustom.Show("客户日期日期格式输入错误"); return; }
                else if (intMasse == 2)
                { MessageBoxCustom.Show("客户日期：" + this.txtCus_Birthday.StrValue.Trim() + "不是公历日期，若要保存请勾上农历"); return; }

                List<Helper.CommandInfo> clist = new List<Helper.CommandInfo>();
                //儿童
                Model_ErpCustomer model = ctbll.GetModel(Convert.ToInt32(BabyID.Trim()));
                model.Cus_Name = LYFZ.BLL.OtherCommonModel.ClearSpecialCharacter(this.txtBaby_name.Text);
                model.Cus_NamePinyin = LYFZ.Command.Command_ChineseToPinyin.GetChineseSpellPinyin(model.Cus_Name).ToLower();
                if (this.radioBaby_nan.Checked == true)
                { model.Cus_Sex = false; }
                else
                { model.Cus_Sex = true; }
                model.Cus_Birthday = txtBaby_Birthday.StrValue.ToString();
                if (model.Cus_Birthday != "")
                {
                    model.Cus_Zodiac = cmbBaby.Text;
                    if (chkBaby_Lunar.Checked == true)
                    { model.Cus_BirthdayLunar = "1"; }
                    else { model.Cus_BirthdayLunar = "0"; }
                }
                else
                {
                    model.Cus_Zodiac = "";
                    model.Cus_BirthdayLunar = "";
                }
                model.Cus_Grade = this.cmbtreevlevel.Text.Trim();
                model.Cus_Type = "儿童";
                model.Cus_UpdateDateTime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
                model.Cus_UpdateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                clist.Add(ctbll.GetUpdateCommandInfo(model));
                //客户
                model = ctbll.GetModel(Convert.ToInt32(aincontactID));
                model.Cus_Type = "";
                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.radCus_Nan.Checked)
                { model.Cus_Sex = false; }
                else { model.Cus_Sex = true; }
                model.Cus_Birthday = 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_Zodiac = "";
                    model.Cus_BirthdayLunar = "";
                }
                model.Cus_QQ = this.txtCus_QQ.Text.ToString();
                model.Cus_MicroSignal = this.txtCus_MicroSignal.Text.ToString();
                model.Cus_Telephone = StrPhone;
                model.Cus_FixedPhone = this.txtCus_FixedPhone.Text.ToString();
                model.Cus_Region = this.cmbCus_Region.Text.ToString();
                model.Cus_Address = this.txtCus_Address.Text.ToString();
                model.Cus_WorkUnit = this.txtCus_WorkUnit.Text.ToString();
                model.Cus_Grade = "";
                model.Cus_UpdateDateTime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime();
                model.Cus_UpdateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                //客人信息放入集合 
                clist.Add(ctbll.GetUpdateCommandInfo(model));
                string laiyuan = "";
                if (this.chkLKH.Checked == true)
                { laiyuan = "老客户"; }
                if (this.chkPYJS.Checked == true)
                { laiyuan = "朋友介绍"; }
                if (chkQT.Checked == true)
                { laiyuan = cmbCus_CustomerSource.Text; }

                //修改客户关系
                Model.Model_ErpCustomerGroupMembers modelGM = gmbll.GetModel(Convert.ToInt32(GMID));
                modelGM.GM_Relation = this.cmbtreevRelations.Text.Trim();
                clist.Add(gmbll.GetUpdateCommandInfo(modelGM));
                //修改客户来源
                BLL_ErpCustomerGroup GPbll = new BLL_ErpCustomerGroup();
                Model.Model_ErpCustomerGroup modelGP = GPbll.GetModel("GP_CustomerGroupID", GM);
                modelGP.GP_CustomerSource = laiyuan;
                clist.Add(GPbll.GetUpdateCommandInfo(modelGP));
                //新增  老客户历史记录表
                if (model_ooh != null)
                {
                    model_ooh.History_Type = txtHistory_Type.Text;
                    if (txtHistory_Money.Text != "")
                    { model_ooh.History_Money = Convert.ToInt32(txtHistory_Money.Text); }
                    else { model_ooh.History_Money = 0; }
                    if (txtHistory_OrderTime.StrValue != "")
                    {
                        if (txtHistory_OrderTime.CheckDateValue(this.txtHistory_OrderTime) != 1)
                        { model_ooh.History_OrderTime = Convert.ToDateTime(txtHistory_OrderTime.Text); }
                        else
                        { model_ooh.History_OrderTime = LYFZ.WinAPI.CustomPublicMethod.GetNullDateTime(); }
                    }
                    else
                    { model_ooh.History_OrderTime = LYFZ.WinAPI.CustomPublicMethod.GetNullDateTime(); }
                    clist.Add(Bll_ooh.GetUpdateCommandInfo(model_ooh));
                }//如果等于空 判断是否新建
                else if (txtHistory_Type.Text != "" && txtHistory_Money.Text != "")
                {
                    model_ooh = new Model_OldOrderHistory();
                    model_ooh.History_ID = GM;
                    model_ooh.History_Type = txtHistory_Type.Text;
                    model_ooh.History_Money = Convert.ToInt32(txtHistory_Money.Text);
                    if (txtHistory_OrderTime.StrValue != "")
                    {
                        if (txtHistory_OrderTime.CheckDateValue(this.txtHistory_OrderTime) != 1)
                        { model_ooh.History_OrderTime = Convert.ToDateTime(txtHistory_OrderTime.Text); }
                        else { model_ooh.History_OrderTime = LYFZ.WinAPI.CustomPublicMethod.GetNullDateTime(); }
                    }
                    else { model_ooh.History_OrderTime = LYFZ.WinAPI.CustomPublicMethod.GetNullDateTime(); }
                    model_ooh.History_CurrentTime = SDateTime.Now;
                    model_ooh.History_CurrentID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                    clist.Add(Bll_ooh.GetAddCommandInfo(model_ooh));
                }

                if (clist.Count > 0)
                {
                    if (MessageBoxCustom.Show("您确定要保存吗？", "温馨提示", MessageBoxButtons.YesNo) == DialogResult.No)
                    { return; }
                    if (LYFZ.BLL.BaseBllOperate.ExecuteSqlTran(clist) > 0)
                    {
                        DAL_ErpCustomer.UpdateAggregationCustomer(GM);
                        bl = true;
                        //日志
                        LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(LYFZ.EnumPublic.SystemLogsType.修改客户资料, "主联系人：" + model.Cus_Name + "，修改联系人资料客户组：" + modelGP.GP_CustomerGroupID + ",时间：" + SDateTime.Now, LYFZ.BLL.BLL_ErpUser.UsersModel.User_EmployeeID, LYFZ.BLL.BLL_ErpUser.UsersModel.User_Name);

                        MessageBoxCustom.Show("保存成功");
                        clist.Clear();
                    }
                    else
                    { MessageBoxCustom.Show("保存失败"); }
                }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnDelete_Click(object sender, EventArgs e)
        {
            if (this.dgvData.SelectedRows.Count > 0)
            {
                if (MessageBoxCustom.Show("是否删除?", "删除", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    if (gmbll.Delete(Convert.ToInt32(this.dgvData.CurrentRow.Cells["GMID"].Value.ToString().Trim())) && ctbll.Delete(Convert.ToInt32(this.dgvData.CurrentRow.Cells["ID"].Value.ToString().Trim())))
                    {
                        DAL_ErpCustomer.UpdateAggregationCustomer(GM);
                        //日志
                        LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(LYFZ.EnumPublic.SystemLogsType.删除客户资料, "联系人：" + this.dgvData.CurrentRow.Cells["CusName"].Value.ToString() + "，删除联系人资料的客户组：" + this.dgvData.CurrentRow.Cells["GMID"].Value.ToString() + ",时间：" + SDateTime.Now, LYFZ.BLL.BLL_ErpUser.UsersModel.User_EmployeeID, LYFZ.BLL.BLL_ErpUser.UsersModel.User_Name);
                        MessageBoxCustom.Show("删除成功！");
                        bl = true;
                        this.FrmOldCustomerEditBaby_Load(null, null);
                    }
                }
            }
            else { MessageBoxCustom.Show("请选择删除内容"); }
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        /// <summary>
        /// 设置客户等级
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnlevel_Click(object sender, EventArgs e)
        {
            LYFZ.Software.MainBusiness.InitialSet.FrmSystemSet set = new InitialSet.FrmSystemSet();
            set.TypeName = "BFADBIBEFCFCIDCDG";
            set.Version = "Version";
            if (set.ShowDialog() == DialogResult.OK)
            { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BFADBIBEFCFCIDCDG", this.cmbtreevlevel, IsFirstNodeNull: true); }
        }
        /// <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="lun"></param>
        /// <returns></returns>
        string Lunar(string lun)
        {
            string luns = "";
            switch (lun)
            {
                case "0":
                    luns = "公历";
                    break;
                case "1":
                    luns = "农历";
                    break;
                case "2":
                    luns = "农历润月";
                    break;
            }
            return luns;
        }
        /// <summary>
        /// 文本框输入
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtHistory_Money_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
        }
        /// <summary>
        /// 文本框输入
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtCus_FixedPhone_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
        }
        /// <summary>
        /// 文本框输入
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtCus_Telephone_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
        }
        /// <summary>
        /// 文本框输入
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtCus_QQ_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar))
            { e.Handled = true; }
        }
        /// <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;
        }
        /// <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;
        }
    }
}