using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using GThinking.N_MISPRO;
using GThinking.N_MISPRO.Data;
using GThinking.N_MODEL.Page;
using GThinking.N_MODEL.Dialog;
using GThinking.N_MISPRO.Utility;
using GThinking.N_PUBLIC2;
using System.Collections.Generic;
using GThinking.N_MISPRO.Caching;
using GThinking.N_MISPRO.TableCache;

namespace GThinking.N_XLXSBJ
{
    public partial class XSBJYWPZInfo : SingleCardBase
    {
        XSBJYWPZ entity = new XSBJYWPZ();

        #region Page类事件继承
        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860062;
            this.UMName = "销售报价业务配置";
            this.CurMaster = Master;
            this.CurEntity = entity;
            this.PageHeight = 500;
            this.PageWidth = 700;
            this.Master.EnableAttachBtn = false;
            this.Master.EnableInsertBtn = false;
            this.Master.EnableCopyBtn = false;
            this.Master.EnableDeleteBtn = false;
            if (!IsPostBack)
            {
                InitControl();
            }
            if (PageParam.GetRTrimString("XLXSBJPZ_MDID").Trim().Equals("100860068"))
            {
                this.Page.Title = "撞单分析";
                this.PageHeight = 550;
                this.PageWidth = 700;
            }
            base.InitPage();


        }
        #endregion

        #region 模板事件继承

        protected override void LoadRecord()
        {
            if (!IsPostBack)
            {
                this.CurEntity.Param.Add("XLXSBJPZ_MDID", PageParam.GetRTrimString("XLXSBJPZ_MDID").Trim());
            }
            else
            {
                this.CurEntity.Param.Add("XLXSBJPZ_MDID", txtOLDMDID.Value);
            }

            base.LoadRecord();
            diyWHR.Text = txtWHR.Text;
            diyWHSJ.Text = datWHSJ.Text;
            SetMXKXX();
            SetPLTJKXX();
            if (cbxMDID.SelectedValue.Equals("102373000"))
                cbxSYBJFL.SelectedValue = cbxBJFLIDS.SelectedValue;
        }

        protected override void OnNewRecorder()
        {
            base.OnNewRecorder();

            txtWHR.Text = tSession.UserName;
            txtWHRID.Value = tSession.UserId;
            datWHSJ.Value = CMISproConvert.ConvertTime(DateTime.Now);
            chkKHBT.Checked = false;
            chkXMBT.Checked = false;
            chkQYBJCPFZJS.Checked = false;
            cbxXMJSLY.SelectedValue = "";
        }

        protected override void OnCopyRecorder()
        {
            base.OnCopyRecorder();            
         
            txtWHR.Text = tSession.UserName;
            txtWHRID.Value = tSession.UserId;
            datWHSJ.Value = CMISproConvert.ConvertTime(DateTime.Now);
        
        }

        protected override bool DataLogicValid()
        {
            //询价员、审价员、核价员角色不能相同
            if (!cbxSJY.SelectedValue.ToString().Trim().Equals(""))
            {
                string[] sXJY = cbxXJY.SelectedValue.ToString().Trim().Split(',');
                string[] sSJY = cbxSJY.SelectedValue.ToString().Trim().Split(',');
                List<string> sSJYList = new List<string>(sSJY);
                for (int i = 0; i < sXJY.Length; i++)
                {
                    if (sSJYList.Contains(sXJY[i]))
                    {
                        ShowMessage("询价员和审价员包含同一角色，不允许保存！");
                        return false;
                    }
                }
                if (!cbxHJY.SelectedValue.ToString().Trim().Equals(""))
                {
                    List<string> sXJYList = new List<string>(sXJY);
                    string [] sHJY = cbxHJY.SelectedValue.ToString().Trim().Split(',');
                    for (int i = 0; i < sHJY.Length; i++)
                    {
                        if (sXJYList.Contains(sHJY[i]))
                        {
                            ShowMessage("询价员和核价员包含同一角色，不允许保存！");
                            return false;
                        }
                        if (sSJYList.Contains(sHJY[i]))
                        {
                            ShowMessage("审价员和核价员包含同一角色，不允许保存！");
                            return false;
                        }
                    }

                }
            }
            else if (!cbxHJY.SelectedValue.ToString().Trim().Equals(""))
            {
                string[] sXJY = cbxXJY.SelectedValue.ToString().Trim().Split(',');
                string[] sHJY = cbxHJY.SelectedValue.ToString().Trim().Split(',');
                List<string> sHJYList = new List<string>(sHJY);
                for (int i = 0; i < sXJY.Length; i++)
                {
                    if (sHJYList.Contains(sXJY[i]))
                    {
                        ShowMessage("询价员和核价员包含同一角色，不允许保存！");
                        return false;
                    }
                }

            }

            if (cbxMDID.SelectedValue.Trim().ToString().Trim().Equals(""))
            {
                ShowMessage("模块不允许为空！");
                return false;
            }

            //cbxMDID.Items.Add(new ListItem("线缆销售报价单", "100860000"));
            if (cbxMDID.SelectedValue.Trim().Equals("100860000"))
            {
                //if (cbxJCJLDWS.SelectedValue.Trim().Equals(""))
                //{
                //    ShowMessage("计量单位不允许为空！");
                //    return false;
                //}

                //if (cbxJCJLDWS.SelectedValue.Trim().IndexOf("M") < 0
                //    || cbxJCJLDWS.SelectedValue.Trim().IndexOf("Km") < 0
                //    || cbxJCJLDWS.SelectedValue.Trim().IndexOf("米") < 0
                //    || cbxJCJLDWS.SelectedValue.Trim().IndexOf("千米") < 0)
                //{
                //    ShowMessage("计量单位必须包含M、Km、米、千米！");
                //    return false;
                //}
            }

            //cbxMDID.Items.Add(new ListItem("材料用量制定申请", "100860064"));
            if (cbxMDID.SelectedValue.Trim().Equals("100860064"))
            {

            }
            else
            {
                if (cbxCLYLZJFS.SelectedValue.Trim().Contains("2") && (cbxCLYLZJFS.SelectedValue.Trim().Contains("0") || cbxCLYLZJFS.SelectedValue.Trim().Contains("1")))
                {
                    ShowMessage("材料用量追加方式2不能和0、1同时存在！");
                    return false;
                }
                if (cbxCLYLZJFS.SelectedValue.Trim().Contains("3") && (cbxCLYLZJFS.SelectedValue.Trim().Contains("0") || cbxCLYLZJFS.SelectedValue.Trim().Contains("1")))
                {
                    ShowMessage("材料用量追加方式3不能和0、1同时存在！");
                    return false;
                }
            }

            if (cbxMDID.SelectedValue.Trim().Equals("100452001"))
            {
                if (cbxBJFLIDS.SelectedValue.Trim().Equals(""))
                {
                    ShowMessage("适用报价分类不允许为空！");
                    return false;
                }
            }

            if (!cbxTBJCLID.SelectedValue.Equals("") && !cbxLBJCLID.SelectedValue.Trim().Equals(""))
            {
                if (cbxTBJCLID.SelectedValue.Trim().Equals(cbxLBJCLID.SelectedValue.Trim()))
                {
                    ShowMessage("铜报价材料和铝报价材料不允许一致！");
                    return false;
                }
            }

            Dictionary<string, string> dicUnCheckedLX = new Dictionary<string, string>();
            if (!chkKHXSY.Checked)
                dicUnCheckedLX.Add("1", "客户+销售员相撞");
            if (!chkKHMCCF.Checked)
                dicUnCheckedLX.Add("2", "客户名称重复");
            if (!chkXMMCCF.Checked)
                dicUnCheckedLX.Add("3", "项目名称重复");
            if (!chkXMMCCZCF.Checked)
                dicUnCheckedLX.Add("4", "项目名称词组重复");
            if (!chkCPCF.Checked)
                dicUnCheckedLX.Add("5", "产品重复");
            if (!chkCPSLCF.Checked)
                dicUnCheckedLX.Add("6", "产品+数量重复");
            if (!chkJXHGGCF.Checked)
                dicUnCheckedLX.Add("7", "仅型号规格重复");
            if (!chkBAXMKHMC.Checked)
                dicUnCheckedLX.Add("8", "备案项目客户名称重复");
            if (!chkBAXMMC.Checked)
                dicUnCheckedLX.Add("9", "备案项目名称重复");
            if (!chkBAXMXSY.Checked)
                dicUnCheckedLX.Add("A", "备案项目名称+销售员重复");
            if (!chkXMKHMCXZ.Checked)
                dicUnCheckedLX.Add("B", "项目与客户名称相撞");
            if (!chkXMMCCF.Checked)
                dicUnCheckedLX.Add("C", "客户联系人重复");
            if (!chkLXDHCF.Checked)
                dicUnCheckedLX.Add("D", "客户电话重复");
            if (!chkCPFDCF.Checked)
                dicUnCheckedLX.Add("E", "按产品个数区间+分段重复率查产品重复");

            string sMSg=string.Empty;
            foreach (string sKey in dicUnCheckedLX.Keys)
            {
                string sZDZDLX=","+cbxZDZDLX.SelectedValue.Trim()+",";
                if (sZDZDLX.Contains("," + sKey + ","))
                    sMSg += dicUnCheckedLX[sKey] + "、";
            }
            if (!sMSg.Equals(""))
            {
                ShowMessage("自动撞单类型不允许选择未勾选的" + sMSg.TrimEnd('、') + "!");
                return false;
            }

            return base.DataLogicValid();
        }

        protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
        {
            return base.Master_BeforeDeleteAction(sender, e);
        }

        protected override bool Master_BeforeSaveAction(object sender, EventArgs e)
        {
            txtWHR.Text = tSession.UserName;
            txtWHRID.Value = tSession.UserId;
            datWHSJ.Value = CMISproConvert.ConvertTime(DateTime.Now);
            if (cbxMDID.SelectedValue.Equals("102373000"))
                cbxBJFLIDS.SelectedValue = cbxSYBJFL.SelectedValue;
            return base.Master_BeforeSaveAction(sender, e);
        }

        protected override void SetControlState()
        {
            base.SetControlState();

            cbxMDID.Enabled = false;
            txtWHR.Enabled = false;
            datWHSJ.Enabled = false;
            diyWHR.Enabled = false;
            diyWHSJ.Enabled = false;
            
            if (ControlState == TControlState.ctsInsert || ControlState == TControlState.ctsCopy || ControlState == TControlState.ctsEdit)
            {
                cbxBJFLIDS.Enabled = true;
                cbxKHJSLY.Enabled = true;
                chkKHBT.Enabled = true;
                cbxXZKHYQ.Enabled = true;

                cbxXMJSLY.Enabled = true;
                chkXMBT.Enabled = true;
                cbxXZXMYQ.Enabled = true;

                cbxCLYLZJFS.Enabled = true;
                chkALMXZBJCL.Enabled = true;

                cbxZDBMIDS.Enabled = true;
                cbxZDRGHS.Enabled = true;

                btnTSCZ.Enabled = false;
                btnBJYXMSZ.Enabled = false;

                btnBZTXS.Enabled = false;
                //自定义计量单位
                if (cbxJCJLDWS.SelectedValue.Trim().Contains("自定义"))
                {
                    txtZDYJLDWS.Enabled = true;
                }
                else
                {
                    txtZDYJLDWS.Text = "";
                    txtZDYJLDWS.Enabled = false;
                }
            }
            else
            {
                cbxBJFLIDS.Enabled = false;
                cbxKHJSLY.Enabled = false;
                chkKHBT.Enabled = false;
                cbxXZKHYQ.Enabled = false;

                cbxXMJSLY.Enabled = false;
                chkXMBT.Enabled = false;
                cbxXZXMYQ.Enabled = false;

                cbxCLYLZJFS.Enabled = false;
                chkALMXZBJCL.Enabled = false;


                cbxZDBMIDS.Enabled = false;
                cbxZDRGHS.Enabled = false;

                btnTSCZ.Enabled = true;
                btnBJYXMSZ.Enabled = true;

                btnBZTXS.Enabled = true;
            }

            //100860000|线缆销售报价单
            if (cbxMDID.SelectedValue.Equals("100860000"))
            {
                lblZCFJGS.Visible = false;
                txtZCFJGS.Visible = false;
                trHG6.Visible = false;
                //审价员、询价员、核价员
                trHG19.Visible = true;
                //trHG20.Visible = true;
                trHG21.Visible = true;
                //是否注册102591003|国网产品导入模块
                if (DSActiveModule.IsActiveModule(102591003))
                {
                    chkGWCP.Visible = true;
                }
                else
                {
                    chkGWCP.Visible = false;
                }
                //是否注册102591004|比亚迪产品导入模块
                if (DSActiveModule.IsActiveModule(102591004))
                {
                    chkBYDCP.Visible = true;
                }
                else
                {
                    chkBYDCP.Visible = false;
                }
            }

            //100860061|销售员报价申请
            if (cbxMDID.SelectedValue.Equals("100860061"))
            {
                chkSQXMBAGL.Visible = false;
                txttr1.Visible = false;
                chkSJJLYBJCP.Visible = false;
                lblFZCZYZ.Visible = false;
                cbxFZCHYZZ.Visible = false;
                chkXSCPML.Visible = false;
                chkBQKTZZDXJ.Visible = false;
                chkBQKTZBJ.Visible = false;
                lblAJGBLR.Visible = false;
                chkXHJQSX.Visible = false;
                chkGGJQSX.Visible = false;
                chkMRGXLR.Visible = false;
                cbxBJXFTJFS.Enabled = false;
                cbxBJSFTJFS.Enabled = false;
                lblMRXLBZ.Visible = false;
                cbxMRXLBZID.Visible = false;
                lblMRDYDJ.Visible = false;
                cbxMRDYDJ.Visible = false;
                chkZJBJ.Visible = false;
                chkWJDR.Visible = false;
                chkFZDR.Visible = false;
                chkQDDR.Visible = false;
                chkWLDR.Visible = false;
                chkWBBJD.Visible = false;
                chkWXCJD.Visible = false;
                chkGWCP.Visible = false;
                chkBYDCP.Visible = false;
                chkWBPIC.Visible = false;
                chkGSDR.Visible = false;
                chkHTDR.Visible = false;
                lblMXKXX.Visible = false;
                chkBJSSWR.Visible = false;
                chkBJXF.Visible = false;
                chkBJSF.Visible = false;
                lblPLTJKXX.Visible = false;
                trHG1.Visible = false;
                trHG2.Visible = false;
                trHG3.Visible = false;
                trHG4.Visible = false;
                trHG5.Visible = false;
                trHG7.Visible = false;
                trHG8.Visible = false;
                //审价员、询价员、核价员
                trHG19.Visible = false;
                trHG21.Visible = false;
                lblXJY.Visible = false;
                lblSJY.Visible = false;
                lblHJY.Visible = false;
                cbxXJY.Visible = false;
                cbxSJY.Visible = false;
                cbxHJY.Visible = false;
            }

            if (cbxXSFS.SelectedValue.Trim().Equals("1"))
            {
                cbxCPML.Enabled = false;
            }

            //调整竖向偏移差
            if (cbxMDID.SelectedValue.Equals("100860000"))
            {
                tdWid.Style["width"] = "150px";
                tdWHR.Style["width"] = "312px";
                cbxMDID.Width = 281;
            }
            else if (cbxMDID.SelectedValue.Equals("100860061"))
            {
                tdWid.Style["width"] = "110px";
                tdWHR.Style["width"] = "286px";
                cbxMDID.Width = 254;
            }
            else
            {
                tdWHR.Style["width"] = "224px";
                cbxMDID.Width = 190;
            }
        }

        protected override void AfterSave(TDatabase db, ref bool ActionIsDone)
        {
            base.AfterSave(db, ref ActionIsDone);
            txtOLDMDID.Value = cbxMDID.SelectedValue.Trim();
        }

        protected override void AfterDelete(TDatabase db, ref bool ActionIsDone)
        {
            base.AfterDelete(db, ref ActionIsDone);
        }

        protected override void SetComboxItems()
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sql = new TSQL(dberp);

            cbxMRZDR.ClearItems();
            cbxMRZDR.Items.Add(new ListItem("", ""));
            cbxMRZDR.Items.Add(new ListItem("尺重表负责人", "1"));
            cbxMRZDR.Items.Add(new ListItem("产品目录负责人", "2"));


            cbxKHJSLY.ClearItems();
            cbxKHJSLY.Items.Add(new ListItem("", ""));
            cbxKHJSLY.Items.Add(new ListItem("客户", "KH"));
            cbxKHJSLY.Items.Add(new ListItem("售前客户", "KHXX"));

            cbxXZKHYQ.ClearItems();
            cbxXZKHYQ.Items.Add(new ListItem("报价前维护", "Q"));
            cbxXZKHYQ.Items.Add(new ListItem("报价后维护", "H"));


            cbxXMJSLY.ClearItems();
            cbxXMJSLY.Items.Add(new ListItem("", ""));
            cbxXMJSLY.Items.Add(new ListItem("售前项目", "YXXM"));

            cbxXZXMYQ.ClearItems();
            cbxXZXMYQ.Items.Add(new ListItem("报价前维护", "Q"));
            cbxXZXMYQ.Items.Add(new ListItem("报价后维护", "H"));

            if (cbxMDID.SelectedValue.Trim().Equals("100860000") || cbxMDID.SelectedValue.Trim().Equals("100860061"))
            {
                cbxBMYSLIST.ClearItems();
                cbxBMYSLIST.Items.Add(new ListItem("项目所在地简称", "XZQHID"));
                cbxBMYSLIST.Items.Add(new ListItem("报价分类特征码", "BJFLTZM"));
                cbxBMYSLIST.Items.Add(new ListItem("销售单位编码", "SYDWID"));
            }

            cbxZDZDLX.ClearItems();
            cbxZDZDLX.Items.Add(new ListItem("客户+销售员相撞", "1"));
            cbxZDZDLX.Items.Add(new ListItem("客户名称重复", "2"));
            cbxZDZDLX.Items.Add(new ListItem("项目名称重复", "3"));
            cbxZDZDLX.Items.Add(new ListItem("项目名称词组重复", "4"));
            cbxZDZDLX.Items.Add(new ListItem("产品重复", "5"));
            cbxZDZDLX.Items.Add(new ListItem("产品+数量重复", "6"));
            cbxZDZDLX.Items.Add(new ListItem("仅型号规格重复", "7"));
            cbxZDZDLX.Items.Add(new ListItem("备案项目客户名称重复", "8"));
            cbxZDZDLX.Items.Add(new ListItem("备案项目名称重复", "9"));
            cbxZDZDLX.Items.Add(new ListItem("备案项目名称+销售员重复", "A"));
            cbxZDZDLX.Items.Add(new ListItem("项目与客户名称相撞", "B"));
            cbxZDZDLX.Items.Add(new ListItem("客户联系人重复", "C"));
            cbxZDZDLX.Items.Add(new ListItem("客户电话重复", "D"));
            cbxZDZDLX.Items.Add(new ListItem("按产品个数区间+分段重复率查产品重复", "E"));
            cbxZDZDLX.Items.Add(new ListItem("客户名称、项目名称重复", "F"));

            cbxBJY.ClearItems();
            cbxBJY.Items.Add(new ListItem("客户+销售员相同", "1"));
            cbxBJY.Items.Add(new ListItem("销售员相同", "2"));
            cbxBJY.ShowValue = false;

            WorkFlowUtils.SetCheckedDropDownList_WFPROC("XLXSBJ_BJD", cbxZDQRHJ);

            cbxJCJLDWS.ClearItems();
            cbxJCJLDWS.Items.Add(new ListItem("M", "M"));
            cbxJCJLDWS.Items.Add(new ListItem("Km", "Km"));
            cbxJCJLDWS.Items.Add(new ListItem("米", "米"));
            cbxJCJLDWS.Items.Add(new ListItem("千米", "千米"));
            cbxJCJLDWS.Items.Add(new ListItem("百米", "百米"));
            cbxJCJLDWS.Items.Add(new ListItem("卷(百米)", "卷"));
            cbxJCJLDWS.Items.Add(new ListItem("Kg", "Kg"));
            cbxJCJLDWS.Items.Add(new ListItem("T", "T"));
            cbxJCJLDWS.Items.Add(new ListItem("千克", "千克"));
            cbxJCJLDWS.Items.Add(new ListItem("公斤", "公斤"));
            cbxJCJLDWS.Items.Add(new ListItem("吨", "吨"));
            cbxJCJLDWS.Items.Add(new ListItem("自定义", "自定义"));

            cbxCLYLZJFS.ClearItems();
            cbxCLYLZJFS.Items.Add(new ListItem("销售报价单明细无清单触发", "0"));
            cbxCLYLZJFS.Items.Add(new ListItem("销售价格表明细无清单触发", "1"));
            cbxCLYLZJFS.Items.Add(new ListItem("销售报价单明细无清单人为挑选触发", "2"));
            cbxCLYLZJFS.Items.Add(new ListItem("销售报价单明细无表价人为挑选触发", "3"));

            cbxWBPPZXSX.ClearItems();
            cbxWBPPZXSX.Items.Add(new ListItem("线缆销售材料清单", "A"));
            cbxWBPPZXSX.Items.Add(new ListItem("线缆销售价格表", "B"));
            cbxWBPPZXSX.Items.Add(new ListItem("先材料清单再价格表", "C"));
            cbxWBPPZXSX.Items.Add(new ListItem("先价格表再材料清单", "D"));

            cbxKSDREJCD.ClearItems();
            cbxKSDREJCD.Items.Add(new ListItem("", ""));
            cbxKSDREJCD.Items.Add(new ListItem("型号 规格/型号-电压等级 规格", "1"));

            cbxMRDYDJ.ClearItems();
            cbxMRDYDJ.Items.Add(new ListItem("", ""));
            cbxMRDYDJ.Items.Add(new ListItem("按型号规格标准匹配到的最小电压", "minDY"));

            cbxFZCHYZZ.ClearItems();
            cbxFZCHYZZ.Items.Add(new ListItem("", ""));
            cbxFZCHYZZ.Items.Add(new ListItem("复制仅重置有因素因子值", "Y"));
            cbxFZCHYZZ.Items.Add(new ListItem("复制重置所有因子值", "Z"));

            sql.Clear();
            sql.Add(" select ID,NAME  ");
            sql.Add(" from ( ");
            sql.Add(" select 'FirstBZ' as ID,'按型号规格匹配到的第一个标准' as NAME,1 as PX ");
            sql.Add(" union all ");
            sql.Add(" select XLBZ_XLBZID as ID,XLBZ_XLBZLXMC as NAME,2 as PX ");
            sql.Add(" from XLBZ ");
            sql.Add(" where 1=1 ");
            sql.Add(" ) a ");
            sql.Add(" order by PX,ID ");
            DataSet dsXLBZID = dberp.OpenDataSet(sql);
            cbxMRXLBZID.ClearItems();
            cbxMRXLBZID.Items.Add(new ListItem("", ""));
            for (int i = 0; i < dsXLBZID.Tables[0].Rows.Count; i++)
            {
                cbxMRXLBZID.Items.Add(new ListItem(dsXLBZID.Tables[0].Rows[i]["NAME"].ToString().Trim(), dsXLBZID.Tables[0].Rows[i]["ID"].ToString().Trim()));
            }

            sql.Clear();
            sql.Add("select XLXSBJCL_BJCLID as CODE,XLXSBJCL_BJCLMC as MESSAGE   ");
            sql.Add("   from XLXSBJCL   ");
            sql.Add("   where XLXSBJCL_BJHQ='1' and isnull(XLXSBJCL_JGYBJCLID,' ') = ' ' and isnull(XLXSBJCL_TYBZ,'N') <> 'Y' ");
            sql.Add("order by XLXSBJCL_BJCLID  ");
            DataSet dsBJCLID = dberp.OpenDataSet(sql);
            cbxTBJCLID.ClearItems();
            cbxLBJCLID.ClearItems();
            cbxTBJCLID.Items.Add(new ListItem("", ""));
            cbxLBJCLID.Items.Add(new ListItem("", ""));
            for (int i = 0; i < dsBJCLID.Tables[0].Rows.Count; i++)
            {
                cbxTBJCLID.Items.Add(new ListItem(dsBJCLID.Tables[0].Rows[i]["MESSAGE"].ToString().Trim(), dsBJCLID.Tables[0].Rows[i]["CODE"].ToString().Trim()));
                cbxLBJCLID.Items.Add(new ListItem(dsBJCLID.Tables[0].Rows[i]["MESSAGE"].ToString().Trim(), dsBJCLID.Tables[0].Rows[i]["CODE"].ToString().Trim()));
            }

            //铜铝导体归属配置
            sql.Clear();
            sql.Add("select XLDTCLB_DTCLID as CODE,XLDTCLB_WLMC as MESSAGE   ");
            sql.Add("   from XLDTCLB   ");
            sql.Add("   where 1=1 and XLDTCLB_WLID =' ' ");
            sql.Add("order by XLDTCLB_DTCLID  ");
            DataSet dsDTGSCLID = dberp.OpenDataSet(sql);
            cbxTDTGSCLID.ClearItems();
            cbxLDTGSCLID.ClearItems();
            for (int i = 0; i < dsDTGSCLID.Tables[0].Rows.Count; i++)
            {
                cbxTDTGSCLID.Items.Add(new ListItem(dsDTGSCLID.Tables[0].Rows[i]["MESSAGE"].ToString().Trim(), dsDTGSCLID.Tables[0].Rows[i]["CODE"].ToString().Trim()));
                cbxLDTGSCLID.Items.Add(new ListItem(dsDTGSCLID.Tables[0].Rows[i]["MESSAGE"].ToString().Trim(), dsDTGSCLID.Tables[0].Rows[i]["CODE"].ToString().Trim()));
            }

            cbxZBLRGS.ClearItems();
            cbxZBLRGS.Items.Add(new ListItem("", ""));
            cbxZBLRGS.Items.Add(new ListItem("中标金额-最低限价金额", "1"));

            if (ControlState == TControlState.ctsBrowse)
            {
                sql.Clear();
                sql.Add(" select XLXSBJFL_BJFLID,XLXSBJFL_BJFLMC from XLXSBJFL where 1=1 ");
                if (cbxMDID.SelectedValue.Equals("102373000"))
                    sql.Add(" and XLXSBJFL_MXBH = 'JGB' ");
                else if (cbxMDID.SelectedValue.Equals("100860087") || cbxMDID.SelectedValue.Equals("100860088"))
                    sql.Add(" and isnull(XLXSBJFL_TYBZ,'N') <> 'Y' ");
                else
                    sql.Add(" and XLXSBJFL_MXBH = 'JGE' ");
                
                sql.Add(" order by XLXSBJFL_XSXH,XLXSBJFL_BJFLID");
                DataSet ds = dberp.OpenDataSet(sql);
                cbxBJFLIDS.ClearItems();
                cbxSYBJFL.ClearItems();
                cbxSYBJFL.Items.Add(new ListItem("", ""));
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxBJFLIDS.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLXSBJFL_BJFLMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXSBJFL_BJFLID"].ToString().Trim()));
                    cbxSYBJFL.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLXSBJFL_BJFLMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXSBJFL_BJFLID"].ToString().Trim()));
                }
                sql.Clear();
                sql.Add("select BM_BMID,BM_MC from BM where 1=1  order by BM_BMID");
                ds = dberp.OpenDataSet(sql);
                cbxZDBMIDS.ClearItems();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxZDBMIDS.Items.Add(new ListItem(ds.Tables[0].Rows[i]["BM_MC"].ToString().Trim(), ds.Tables[0].Rows[i]["BM_BMID"].ToString().Trim()));
                }

                sql.Clear();
                sql.Add(" select RSRYJBXX_GH as ID ,");
                sql.Add(" rtrim(isNull(RSRYJBXX_PYBM,' '))||'|'||rtrim(isNULL(RSRYJBXX_RYMC,' '))||'|'||rtrim(isNUll(RSRYJBXX_GH,' '))||(case isnull(RSRYJBXX_TYBZ,'N') when 'Y' then '(停用)' else '' end) as NAME ");
                sql.Add(" from RSRYJBXX where 1= 1 ");
                if (!cbxZDBMIDS.SelectedValue.Trim().Equals(""))
                    sql.Add(" and " + CMISproDataBase.GetWhereEqual("RSRYJBXX_RZBM", cbxZDBMIDS.SelectedValue.Trim()));
                sql.Add(" order by isNull(RSRYJBXX_PYBM,' '),isnull(RSRYJBXX_TYBZ,'N'),RSRYJBXX_GH  ");
                ds = dberp.OpenDataSet(sql);
                cbxZDRGHS.ClearItems();
                cbxYJTZRYLIST.ClearItems();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxZDRGHS.Items.Add(new ListItem(ds.Tables[0].Rows[i]["NAME"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
                    cbxYJTZRYLIST.Items.Add(new ListItem(ds.Tables[0].Rows[i]["NAME"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
                }
            }
            else
            {
                sql.Clear();
                sql.Add(" select XLXSBJFL_BJFLID,XLXSBJFL_BJFLMC from XLXSBJFL where 1=1 and isnull(XLXSBJFL_TYBZ,'N')<>'Y' ");
                if (cbxMDID.SelectedValue.Equals("102373000"))
                    sql.Add(" and XLXSBJFL_MXBH = 'JGB' ");
                else if (cbxMDID.SelectedValue.Equals("100860087") || cbxMDID.SelectedValue.Equals("100860088"))
                    sql.Add(" and isnull(XLXSBJFL_TYBZ,'N') <> 'Y' ");
                else
                    sql.Add(" and XLXSBJFL_MXBH = 'JGE' ");
                sql.Add(" order by XLXSBJFL_XSXH,XLXSBJFL_BJFLID");
                DataSet ds = dberp.OpenDataSet(sql);
                cbxBJFLIDS.ClearItems();
                cbxSYBJFL.ClearItems();
                cbxSYBJFL.Items.Add(new ListItem("", ""));
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxBJFLIDS.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLXSBJFL_BJFLMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXSBJFL_BJFLID"].ToString().Trim()));
                    cbxSYBJFL.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLXSBJFL_BJFLMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XLXSBJFL_BJFLID"].ToString().Trim()));
                }

                sql.Clear();
                sql.Add("select BM_BMID,BM_MC from BM where 1=1 and isnull(BM_TYBZ,' ')<>'Y' order by BM_BMID");
                ds = dberp.OpenDataSet(sql);
                cbxZDBMIDS.ClearItems();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxZDBMIDS.Items.Add(new ListItem(ds.Tables[0].Rows[i]["BM_MC"].ToString().Trim(), ds.Tables[0].Rows[i]["BM_BMID"].ToString().Trim()));
                }

                sql.Clear();
                sql.Add(" select RSRYJBXX_GH as ID ,");
                sql.Add(" rtrim(isNull(RSRYJBXX_PYBM,' '))||'|'||rtrim(isNULL(RSRYJBXX_RYMC,' '))||'|'||rtrim(isNUll(RSRYJBXX_GH,' ')) as NAME ");
                sql.Add(" from RSRYJBXX where 1= 1 and isnull(RSRYJBXX_TYBZ,' ')<>'Y' and isnull(RSRYJBXX_USER, 'N') = 'Y' ");
                if (!cbxZDBMIDS.SelectedValue.Trim().Equals(""))
                    sql.Add(" and " + CMISproDataBase.GetWhereEqual("RSRYJBXX_RZBM", cbxZDBMIDS.SelectedValue.Trim()));
                sql.Add(" order by isNull(RSRYJBXX_PYBM,' '),RSRYJBXX_GH  ");
                ds = dberp.OpenDataSet(sql);
                cbxZDRGHS.ClearItems();
                cbxYJTZRYLIST.ClearItems();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxZDRGHS.Items.Add(new ListItem(ds.Tables[0].Rows[i]["NAME"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
                    cbxYJTZRYLIST.Items.Add(new ListItem(ds.Tables[0].Rows[i]["NAME"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
                }
            }

            sql.Clear();
            sql.Add("SELECT XLXSJGB_JGBID,XLXSJGB_YXQS,XLXSJGB_YXQZ,XLXSJGB_JGBMC from XLXSJGB ");
            sql.Add("where XLXSJGB_MXBH='JGB' ");
            sql.Add("order by XLXSJGB_JGBID");
            DataSet dsJGB = dberp.OpenDataSet(sql);
            cbxSYJGB.ClearItems();
            cbxWXHYJGBID.ClearItems();
            cbxSYJGB.Items.Add(new ListItem("", ""));
            cbxWXHYJGBID.Items.Add(new ListItem("", ""));
            for (int i = 0; i < dsJGB.Tables[0].Rows.Count; i++)
            {
                string sJGBID = dsJGB.Tables[0].Rows[i]["XLXSJGB_JGBID"].ToString().Trim();
                string sYXQS = dsJGB.Tables[0].Rows[i]["XLXSJGB_YXQS"].ToString().Trim();
                string sYXQZ = dsJGB.Tables[0].Rows[i]["XLXSJGB_YXQZ"].ToString().Trim();
                string sJGBMC = dsJGB.Tables[0].Rows[i]["XLXSJGB_JGBMC"].ToString().Trim();
                if (sYXQS.Equals(""))
                    sYXQS = "--";
                else
                    sYXQS = CMISproConvert.ConvertDate(sYXQS);
                if (sYXQZ.Equals(""))
                    sYXQZ = "--";
                else
                    sYXQZ = CMISproConvert.ConvertDate(sYXQZ);
                if (sJGBMC.Equals(""))
                    cbxSYJGB.Items.Add(new ListItem(sJGBID + "|" + sYXQS + "至" + sYXQZ, sJGBID));
                else
                    cbxSYJGB.Items.Add(new ListItem(sJGBID + "|" + sYXQS + "至" + sYXQZ + "|" + sJGBMC, sJGBID));
                if (sJGBMC.Equals(""))
                    cbxWXHYJGBID.Items.Add(new ListItem(sJGBID + "|" + sYXQS + "至" + sYXQZ, sJGBID));
                else
                    cbxWXHYJGBID.Items.Add(new ListItem(sJGBID + "|" + sYXQS + "至" + sYXQZ + "|" + sJGBMC, sJGBID));
            }

            cbxCPML.ClearItems();
            sql.Clear();
            sql.Add(" select XLXSCPML_CPMLID,XLXSCPML_CPMLMC from XLXSCPML where ISNULL(XLXSCPML_CPMLLX,'N') = 'N' and XLXSCPML_BJY = 'Y' ");
            DataSet dsCPML = dberp.OpenDataSet(sql);
            if (dsCPML.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow rowCPML in dsCPML.Tables[0].Rows)
                {
                    cbxCPML.Items.Add(new ListItem(rowCPML["XLXSCPML_CPMLMC"].ToString().Trim(), rowCPML["XLXSCPML_CPMLID"].ToString().Trim()));
                }
            }

            sql.Clear();
            sql.Add(" select BBYS_XH,BBYS_SM from BBYS where BBYS_UMID = 100860000 and BBYS_FORMID = 'XLBJDInfo' order by BBYS_XH ");
            DataSet dsBBYSXH = dberp.OpenDataSet(sql);
            cbxBBYSXH.ClearItems();
            cbxBBYSXH.Items.Add(new ListItem("", "0"));
            for (int i = 0; i < dsBBYSXH.Tables[0].Rows.Count; i++)
            {
                cbxBBYSXH.Items.Add(new ListItem(dsBBYSXH.Tables[0].Rows[i]["BBYS_SM"].ToString().Trim(), dsBBYSXH.Tables[0].Rows[i]["BBYS_XH"].ToString().Trim()));
            }


            cbxXSFS.ClearItems();
            cbxXSFS.Items.Add(new ListItem("产品用途", "1"));
            cbxXSFS.Items.Add(new ListItem("产品目录", "2"));
            cbxXSFS.ShowValue = false;

            cbxBJSFTJFS.ClearItems();
            cbxBJSFTJFS.Items.Add(new ListItem("乘以(1+点数(%))", "UM"));
            cbxBJSFTJFS.Items.Add(new ListItem("除以(1-点数(%))", "UD"));
            cbxBJSFTJFS.ShowValue = false;

            cbxBJXFTJFS.ClearItems();
            cbxBJXFTJFS.Items.Add(new ListItem("乘以(1-点数(%))", "DM"));
            cbxBJXFTJFS.Items.Add(new ListItem("除以(1+点数(%))", "DD"));
            cbxBJXFTJFS.ShowValue = false;

            cbxTJBXYGHJGML.ClearItems();
            cbxTJBXYGHJGML.Items.Add(new ListItem("1|表价(出厂价)=基价(材料价)&调价", "1"));
            cbxTJBXYGHJGML.Items.Add(new ListItem("2|表价(区域价)=基价(出厂价)&调价", "2"));
            cbxTJBXYGHJGML.Items.Add(new ListItem("3|表价(现行价)=基价(出厂价+材料价价差)&调价", "3"));
            cbxTJBXYGHJGML.ShowValue = false;

            cbxCPLJGS.ClearItems();
            cbxCPLJGS.Items.Add(new ListItem("1|所依产品料价", "1"));
            cbxCPLJGS.Items.Add(new ListItem("2|所依产品料价*综合加点", "2"));
            cbxCPLJGS.Items.Add(new ListItem("3|按报价单料价加点对照表计算", "3"));


            cbxMRJSFS.ClearItems();
            cbxMRJSFS.Items.Add(new ListItem("乘以(1+加点(%))", "JD"));
            cbxMRJSFS.Items.Add(new ListItem("除以(1-扣点(%))", "KD"));
            cbxMRJSFS.Items.Add(new ListItem("1+加点之和(%)", "01"));
            cbxMRJSFS.ShowValue = false;

            if (cbxMDID.SelectedValue.Trim().Equals("100860000"))
            {
                //询价员、审价员、核价员下拉框设置
                sql.Clear();
                sql.Add("select ROID,RONAME from ROLE where ROTYBZ ='N' and ROZYJS ='N' order by ROID");
                DataSet dsJS = dberp.OpenDataSet(sql);
                cbxXJY.ClearItems();
                cbxSJY.ClearItems();
                cbxHJY.ClearItems();
                for (int i = 0; i < dsJS.Tables[0].Rows.Count; i++)
                {
                    cbxXJY.Items.Add(new ListItem(dsJS.Tables[0].Rows[i]["RONAME"].ToString().Trim(), dsJS.Tables[0].Rows[i]["ROID"].ToString().Trim()));
                    cbxSJY.Items.Add(new ListItem(dsJS.Tables[0].Rows[i]["RONAME"].ToString().Trim(), dsJS.Tables[0].Rows[i]["ROID"].ToString().Trim()));
                    cbxHJY.Items.Add(new ListItem(dsJS.Tables[0].Rows[i]["RONAME"].ToString().Trim(), dsJS.Tables[0].Rows[i]["ROID"].ToString().Trim()));
                }

            }


            if (cbxMDID.SelectedValue.Trim().Equals("100860046"))
            {
                sql.Clear();
                sql.Add("select BM_BMID,BM_MC from BM where 1=1 and isnull(BM_TYBZ,' ')<>'Y' order by BM_BMID");
                DataSet ds = dberp.OpenDataSet(sql);
                cbxWLQSTZBM.ClearItems();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxWLQSTZBM.Items.Add(new ListItem(ds.Tables[0].Rows[i]["BM_MC"].ToString().Trim(), ds.Tables[0].Rows[i]["BM_BMID"].ToString().Trim()));
                }

                //物料缺失通知人、结构派生通知人下拉框设置
                sql.Clear();
                sql.Add(" select RSRYJBXX_GH as ID ,");
                sql.Add(" rtrim(isNull(RSRYJBXX_PYBM,' '))||'|'||rtrim(isNULL(RSRYJBXX_RYMC,' '))||'|'||rtrim(isNUll(RSRYJBXX_GH,' ')) as NAME ");
                sql.Add(" from RSRYJBXX where 1= 1 and isnull(RSRYJBXX_TYBZ,' ')<>'Y' and isnull(RSRYJBXX_USER, 'N') = 'Y' ");
                if (!cbxWLQSTZBM.SelectedValue.Trim().Equals(""))
                    sql.Add(" and " + CMISproDataBase.GetWhereEqual("RSRYJBXX_RZBM", cbxWLQSTZBM.SelectedValue.Trim()));
                sql.Add(" order by isNull(RSRYJBXX_PYBM,' '),RSRYJBXX_GH  ");
                ds = dberp.OpenDataSet(sql);
                cbxWLQSTZR.ClearItems();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxWLQSTZR.Items.Add(new ListItem(ds.Tables[0].Rows[i]["NAME"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
                }


                sql.Clear();
                sql.Add("select BM_BMID,BM_MC from BM where 1=1 and isnull(BM_TYBZ,' ')<>'Y' order by BM_BMID");
                ds = dberp.OpenDataSet(sql);
                cbxJGPSTZBM.ClearItems();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxJGPSTZBM.Items.Add(new ListItem(ds.Tables[0].Rows[i]["BM_MC"].ToString().Trim(), ds.Tables[0].Rows[i]["BM_BMID"].ToString().Trim()));
                }

                sql.Clear();
                sql.Add(" select RSRYJBXX_GH as ID ,");
                sql.Add(" rtrim(isNull(RSRYJBXX_PYBM,' '))||'|'||rtrim(isNULL(RSRYJBXX_RYMC,' '))||'|'||rtrim(isNUll(RSRYJBXX_GH,' ')) as NAME ");
                sql.Add(" from RSRYJBXX where 1= 1 and isnull(RSRYJBXX_TYBZ,' ')<>'Y' and isnull(RSRYJBXX_USER, 'N') = 'Y' ");
                if (!cbxJGPSTZBM.SelectedValue.Trim().Equals(""))
                    sql.Add(" and " + CMISproDataBase.GetWhereEqual("RSRYJBXX_RZBM", cbxJGPSTZBM.SelectedValue.Trim()));
                sql.Add(" order by isNull(RSRYJBXX_PYBM,' '),RSRYJBXX_GH  ");
                ds = dberp.OpenDataSet(sql);
                cbxJGPSTZR.ClearItems();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cbxJGPSTZR.Items.Add(new ListItem(ds.Tables[0].Rows[i]["NAME"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
                }

            }


            cbxTZBLYZZLX.Items.Add(new ListItem("相等", "相等"));
            cbxTZBLYZZLX.Items.Add(new ListItem("相反数", "相反数"));

            cbxKSDYZZLX.Items.Add(new ListItem("相等", "相等"));
            cbxKSDYZZLX.Items.Add(new ListItem("相反数", "相反数"));

            base.SetComboxItems();
        }

        protected override void OnPreRender(EventArgs e)
        {
            string run = "function Run()"
                     + "{";
            run += "	document.getElementById('trYXFQFX').style.display = 'none';";
            run += "	document.getElementById('divXSHTKHJJS').style.display = 'none';";
            run += "	document.getElementById('div46').style.display = 'none';";
            if (cbxMDID.SelectedValue.Trim().Equals("100860014"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860018"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860020"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860064"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860068"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('divMK').style.display = 'none';";
                run += "	document.getElementById('divWHXX').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860043"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860033") || cbxMDID.SelectedValue.Trim().Equals("100860027"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860063"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100452001"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'block';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860087"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'block';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("102373000"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860060"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860038"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860088"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'block';";
                run += "	document.getElementById('divXSHTKHJJS').style.display = 'block';";
            }
            else if (cbxMDID.SelectedValue.Trim().Equals("100860046"))
            {
                run += "	document.getElementById('div00').style.display = 'none';";
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
                run += "	document.getElementById('div46').style.display = 'block';";
            }
            else
            {
                run += "	document.getElementById('div14').style.display = 'none';";
                run += "	document.getElementById('div18').style.display = 'none';";
                run += "	document.getElementById('div20').style.display = 'none';";
                run += "	document.getElementById('div43').style.display = 'none';";
                run += "	document.getElementById('div64').style.display = 'none';";
                run += "	document.getElementById('div68').style.display = 'none';";
                run += "	document.getElementById('div33').style.display = 'none';";
                run += "	document.getElementById('div63').style.display = 'none';";
                run += "	document.getElementById('div01').style.display = 'none';";
                run += "	document.getElementById('divS_00').style.display = 'none';";
                run += "	document.getElementById('div60').style.display = 'none';";
                run += "	document.getElementById('div38').style.display = 'none';";
            }
            run += "}";
            AJAXRunScript(null, "JC", run + "Run();");
            base.OnPreRender(e);
        }

        protected override bool Master_AfterSaveAction(object sender, EventArgs e)
        {
            CacheNotify.TableIsUpdated("DBERP", "XLXSBJPZ");
            return base.Master_AfterSaveAction(sender, e);
        }

        protected override bool Master_AfterDeleteAction(object sender, EventArgs e)
        {
            CacheNotify.TableIsUpdated("DBERP", "XLXSBJPZ");
            return base.Master_AfterDeleteAction(sender, e);
        }

        #endregion

        #region 私有函数
        private void InitControl()
        {
            cbxMDID.ClearItems();
            cbxMDID.Items.Add(new ListItem("线缆销售报价单", "100860000"));
            cbxMDID.Items.Add(new ListItem("销售员报价申请", "100860061"));
            cbxMDID.Items.Add(new ListItem("线缆销售报价材料用量", "100860014"));
            cbxMDID.Items.Add(new ListItem("线缆销售报价结构尺重表", "100860020"));
            cbxMDID.Items.Add(new ListItem("材料用量制定申请", "100860064"));
            cbxMDID.Items.Add(new ListItem("撞单分析", "100860068"));
            cbxMDID.Items.Add(new ListItem("按外部报价单导入", "100860043"));
            cbxMDID.Items.Add(new ListItem("线缆销售报价价格目录", "100860018"));
            cbxMDID.Items.Add(new ListItem("销售报价价格表查询手机服务", "100860027"));
            cbxMDID.Items.Add(new ListItem("销售报价价格表报价手机服务", "100860033"));
            cbxMDID.Items.Add(new ListItem("线缆销售报价单统计", "100860063"));
            cbxMDID.Items.Add(new ListItem("销售订单维护", "100452001"));
            cbxMDID.Items.Add(new ListItem("线缆销售报价微信服务", "102373000"));
            cbxMDID.Items.Add(new ListItem("销售员报价审批服务", "100860060"));
            cbxMDID.Items.Add(new ListItem("报价单型号加点对照表", "100860038"));
            cbxMDID.Items.Add(new ListItem("销售合同生成报价单服务", "100860087"));
            cbxMDID.Items.Add(new ListItem("销售合同考核价计算服务", "100860088"));
            cbxMDID.Items.Add(new ListItem("线缆销售报价反馈", "100860046"));

            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSql = new TSQL(dberp);
            sSql.Add("select XLBZ_XLBZID,XLBZ_XLBZLXMC  ");
            sSql.Add(" FROM XLBZ ");
            sSql.Add(" where 1=1 ORDER BY XLBZ_PX");
            DataSet ds = dberp.OpenDataSet(sSql);
            cbxCPCFXLBZ.ClearItems();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                cbxCPCFXLBZ.Items.Add(new ListItem(ds.Tables[0].Rows[i]["XLBZ_XLBZLXMC"].ToString().Trim(), ds.Tables[0].Rows[i]["XLBZ_XLBZID"].ToString().Trim()));
            }
        }

        private void SetMXKXX()
        {
            if (!txtXZMXKXX.Value.Trim().Equals(""))
            {
                Dictionary<string, int> dicMXKXX = new Dictionary<string, int>();
                int i = 1;
                foreach (string sKXX in txtXZMXKXX.Value.Trim().Split(','))
                {
                    dicMXKXX.Add(sKXX, i);
                    i++;
                }

                if (dicMXKXX.ContainsKey("ZJBJ"))
                {
                    chkZJBJ.Text = "按价格表录入" + SpecialS(dicMXKXX["ZJBJ"]);
                    chkZJBJ.Checked = true;
                }
                else
                {
                    chkZJBJ.Text = "按价格表录入";
                    chkZJBJ.Checked = false;
                }

                if (dicMXKXX.ContainsKey("WJDR"))
                {
                    chkWJDR.Text = "按内置格式导入" + SpecialS(dicMXKXX["WJDR"]);
                    chkWJDR.Checked = true;
                }
                else
                {
                    chkWJDR.Text = "按内置格式导入";
                    chkWJDR.Checked = false;
                }

                if (dicMXKXX.ContainsKey("FZDR"))
                {
                    chkFZDR.Text = "按复制内容导入" + SpecialS(dicMXKXX["FZDR"]);
                    chkFZDR.Checked = true;
                }
                else
                {
                    chkFZDR.Text = "按复制内容导入";
                    chkFZDR.Checked = false;
                }

                if (dicMXKXX.ContainsKey("QDDR"))
                {
                    chkQDDR.Text = "按材料清单导入" + SpecialS(dicMXKXX["QDDR"]);
                    chkQDDR.Checked = true;
                }
                else
                {
                    chkQDDR.Text = "按材料清单导入";
                    chkQDDR.Checked = false;
                }

                if (dicMXKXX.ContainsKey("WLDR"))
                {
                    chkWLDR.Text = "按线缆物料导入" + SpecialS(dicMXKXX["WLDR"]);
                    chkWLDR.Checked = true;
                }
                else
                {
                    chkWLDR.Text = "按线缆物料导入";
                    chkWLDR.Checked = false;
                }

                if (dicMXKXX.ContainsKey("WBBJD"))
                {
                    chkWBBJD.Text = "按外部报价单导入" + SpecialS(dicMXKXX["WBBJD"]);
                    chkWBBJD.Checked = true;
                }
                else
                {
                    chkWBBJD.Text = "按外部报价单导入";
                    chkWBBJD.Checked = false;
                }

                if (dicMXKXX.ContainsKey("WXCJD"))
                {
                    chkWXCJD.Text = "按微信查价单导入" + SpecialS(dicMXKXX["WXCJD"]);
                    chkWXCJD.Checked = true;
                }
                else
                {
                    chkWXCJD.Text = "按微信查价单导入";
                    chkWXCJD.Checked = false;
                }

                if (dicMXKXX.ContainsKey("GWCP"))
                {
                    chkGWCP.Text = "按国网产品导入" + SpecialS(dicMXKXX["GWCP"]);
                    chkGWCP.Checked = true;
                }
                else
                {
                    chkGWCP.Text = "按国网产品导入";
                    chkGWCP.Checked = false;
                }

                if (dicMXKXX.ContainsKey("BYDCP"))
                {
                    chkBYDCP.Text = "按比亚迪产品导入" + SpecialS(dicMXKXX["BYDCP"]);
                    chkBYDCP.Checked = true;
                }
                else
                {
                    chkBYDCP.Text = "按比亚迪产品导入";
                    chkBYDCP.Checked = false;
                }

                if (dicMXKXX.ContainsKey("WBPIC"))
                {
                    chkWBPIC.Text = "按外部报价单图片导入" + SpecialS(dicMXKXX["WBPIC"]);
                    chkWBPIC.Checked = true;
                }
                else
                {
                    chkWBPIC.Text = "按外部报价单图片导入";
                    chkWBPIC.Checked = false;
                }

                if (dicMXKXX.ContainsKey("GSDR"))
                {
                    chkGSDR.Text = "按配置格式导入" + SpecialS(dicMXKXX["GSDR"]);
                    chkGSDR.Checked = true;
                }
                else
                {
                    chkGSDR.Text = "按配置格式导入";
                    chkGSDR.Checked = false;
                }

                if (dicMXKXX.ContainsKey("HTDR"))
                {
                    chkHTDR.Text = "按合同标的价格导入" + SpecialS(dicMXKXX["HTDR"]);
                    chkHTDR.Checked = true;
                }
                else
                {
                    chkHTDR.Text = "按合同标的价格导入";
                    chkHTDR.Checked = false;
                }
            }
        }

        private void SetPLTJKXX()
        {
            if (!txtPLTJKXX.Value.Trim().Equals(""))
            {
                string sPLTJKXX = "," + txtPLTJKXX.Value.Trim() + ",";
                if (sPLTJKXX.Contains(",BJSSWR,"))
                    chkBJSSWR.Checked = true;
                else
                    chkBJSSWR.Checked = false;

                if (sPLTJKXX.Contains(",BJXF,"))
                    chkBJXF.Checked = true;
                else
                    chkBJXF.Checked = false;

                if (sPLTJKXX.Contains(",BJSF,"))
                    chkBJSF.Checked = true;
                else
                    chkBJSF.Checked = false;
            }
        }

        private string SpecialS(int i)
        {
            string sRs = "";
            switch (i)
            {
                case 1:
                    sRs = "①";
                    break;
                case 2:
                    sRs = "②";
                    break;
                case 3:
                    sRs = "③";
                    break;
                case 4:
                    sRs = "④";
                    break;
                case 5:
                    sRs = "⑤";
                    break;
                case 6:
                    sRs = "⑥";
                    break;
                case 7:
                    sRs = "⑦";
                    break;
                case 8:
                    sRs = "⑧";
                    break;
                case 9:
                    sRs = "⑨";
                    break;
                case 10:
                    sRs = "⑩";
                    break;
            }
            return sRs;
        }
        #endregion

        #region 控件事件


        protected void btnBZTXS_Click(object sender, EventArgs e)
        {
            TPageParams param = new TPageParams();
            param.UrlPath = "XSBJYWPZ_BZYSList.aspx";
            OpenDialog(param);
        }

        protected void btnTSCZ_Click(object sender, EventArgs e)
        {
            TPageParams tpp = new TPageParams();
            tpp.UrlPath = "XSBJYWPZ_TSCZInfo.aspx";
            tpp.CallAction = TPageCallAction.pcaEdit;
            tpp.AddString("XLXSBJPZ_MDID", cbxMDID.SelectedValue.Trim());
            OpenDialog(tpp);
        }

        protected void btnBJYXMSZ_Click(object sender, EventArgs e)
        {
            TPageParams param = new TPageParams();
            param.UrlPath = "XSBJYWPZ_BJYXXList.aspx";
            param.AddString("XLXSBJPZ_MDID", cbxMDID.SelectedValue.Trim());
            OpenDialog(param);
        }


        //
        protected void cbxJCJLDWS_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cbxJCJLDWS.SelectedValue.Trim().Contains("自定义"))
            {
                txtZDYJLDWS.Enabled = true;
            }
            else
            {
                txtZDYJLDWS.Text = "";
                txtZDYJLDWS.Enabled = false;
            }
        }

        protected void OncbxXSFS_SelectChanged(object sender, EventArgs e)
        {
            if (cbxXSFS.SelectedValue.Trim().Equals("1"))
            {
                cbxCPML.SelectedValue = "";
                cbxCPML.Enabled = false;
            }
            else
                cbxCPML.Enabled = true;
        }

        protected void OncbxZDBMIDS_SelectChanged(object sender, EventArgs e)
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sql = new TSQL(dberp);
            sql.Clear();
            sql.Add(" select RSRYJBXX_GH as ID ,");
            sql.Add(" rtrim(isNull(RSRYJBXX_PYBM,' '))||'|'||rtrim(isNULL(RSRYJBXX_RYMC,' '))||'|'||rtrim(isNUll(RSRYJBXX_GH,' ')) as NAME ");
            sql.Add(" from RSRYJBXX where 1= 1 and isnull(RSRYJBXX_TYBZ,' ')<>'Y' and isnull(RSRYJBXX_USER, 'N') = 'Y' ");
            if (!cbxZDBMIDS.SelectedValue.Trim().Equals(""))
                sql.Add(" and " + CMISproDataBase.GetWhereEqual("RSRYJBXX_RZBM", cbxZDBMIDS.SelectedValue.Trim()));
            sql.Add(" order by isNull(RSRYJBXX_PYBM,' '),RSRYJBXX_GH  ");
            DataSet ds = dberp.OpenDataSet(sql);
            cbxZDRGHS.ClearItems();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                cbxZDRGHS.Items.Add(new ListItem(ds.Tables[0].Rows[i]["NAME"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
            }
        }


        protected void OncbxWLQSTZBM_SelectChanged(object sender, EventArgs e)
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sql = new TSQL(dberp);
            sql.Clear();
            sql.Add(" select RSRYJBXX_GH as ID ,");
            sql.Add(" rtrim(isNull(RSRYJBXX_PYBM,' '))||'|'||rtrim(isNULL(RSRYJBXX_RYMC,' '))||'|'||rtrim(isNUll(RSRYJBXX_GH,' ')) as NAME ");
            sql.Add(" from RSRYJBXX where 1= 1 and isnull(RSRYJBXX_TYBZ,' ')<>'Y' and isnull(RSRYJBXX_USER, 'N') = 'Y' ");
            if (!cbxWLQSTZBM.SelectedValue.Trim().Equals(""))
                sql.Add(" and " + CMISproDataBase.GetWhereEqual("RSRYJBXX_RZBM", cbxWLQSTZBM.SelectedValue.Trim()));
            sql.Add(" order by isNull(RSRYJBXX_PYBM,' '),RSRYJBXX_GH  ");
            DataSet ds = dberp.OpenDataSet(sql);
            cbxWLQSTZR.ClearItems();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                cbxWLQSTZR.Items.Add(new ListItem(ds.Tables[0].Rows[i]["NAME"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
            }
        }

        protected void OncbxJGPSTZBM_SelectChanged(object sender, EventArgs e)
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sql = new TSQL(dberp);
            sql.Clear();
            sql.Add(" select RSRYJBXX_GH as ID ,");
            sql.Add(" rtrim(isNull(RSRYJBXX_PYBM,' '))||'|'||rtrim(isNULL(RSRYJBXX_RYMC,' '))||'|'||rtrim(isNUll(RSRYJBXX_GH,' ')) as NAME ");
            sql.Add(" from RSRYJBXX where 1= 1 and isnull(RSRYJBXX_TYBZ,' ')<>'Y' and isnull(RSRYJBXX_USER, 'N') = 'Y' ");
            if (!cbxJGPSTZBM.SelectedValue.Trim().Equals(""))
                sql.Add(" and " + CMISproDataBase.GetWhereEqual("RSRYJBXX_RZBM", cbxJGPSTZBM.SelectedValue.Trim()));
            sql.Add(" order by isNull(RSRYJBXX_PYBM,' '),RSRYJBXX_GH  ");
            DataSet ds = dberp.OpenDataSet(sql);
            cbxJGPSTZR.ClearItems();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                cbxJGPSTZR.Items.Add(new ListItem(ds.Tables[0].Rows[i]["NAME"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
            }
        }


        protected void chkZJBJ_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkZJBJ.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "ZJBJ";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("ZJBJ,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkWJDR_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkWJDR.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "WJDR";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("WJDR,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkFZDR_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkFZDR.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "FZDR";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("FZDR,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkQDDR_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkQDDR.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "QDDR";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("QDDR,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkWLDR_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkWLDR.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "WLDR";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("WLDR,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkWBBJD_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkWBBJD.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "WBBJD";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("WBBJD,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkWXCJD_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkWXCJD.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "WXCJD";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("WXCJD,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkGWCP_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkGWCP.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "GWCP";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("GWCP,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkBYDCP_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkBYDCP.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "BYDCP";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("BYDCP,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkWBPIC_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkWBPIC.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "WBPIC";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("WBPIC,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkGSDR_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkGSDR.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "GSDR";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("GSDR,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkHTDR_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sXZMXKXX = txtXZMXKXX.Value.Trim();
                if (chkHTDR.Checked)
                {
                    if (!sXZMXKXX.Equals(""))
                        sXZMXKXX += ",";
                    sXZMXKXX += "HTDR";
                }
                else
                {
                    sXZMXKXX += ",";
                    sXZMXKXX = sXZMXKXX.Replace("HTDR,", "");
                    sXZMXKXX = sXZMXKXX.TrimEnd(',');
                }
                txtXZMXKXX.Value = sXZMXKXX;
                SetMXKXX();
            }
        }

        protected void chkBJSSWR_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sPLTJKXX = txtPLTJKXX.Value.Trim();
                if (chkBJSSWR.Checked)
                {
                    if (!sPLTJKXX.Equals(""))
                        sPLTJKXX += ",";
                    sPLTJKXX += "BJSSWR";
                }
                else
                {
                    sPLTJKXX += ",";
                    sPLTJKXX = sPLTJKXX.Replace("BJSSWR,", "");
                    sPLTJKXX = sPLTJKXX.TrimEnd(',');
                }
                txtPLTJKXX.Value = sPLTJKXX;
                SetPLTJKXX();
            }
        }

        protected void chkBJXF_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sPLTJKXX = txtPLTJKXX.Value.Trim();
                if (chkBJXF.Checked)
                {
                    if (!sPLTJKXX.Equals(""))
                        sPLTJKXX += ",";
                    sPLTJKXX += "BJXF";
                }
                else
                {
                    sPLTJKXX += ",";
                    sPLTJKXX = sPLTJKXX.Replace("BJXF,", "");
                    sPLTJKXX = sPLTJKXX.TrimEnd(',');
                }
                txtPLTJKXX.Value = sPLTJKXX;
                SetPLTJKXX();
            }
        }

        protected void chkBJSF_Changed(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                string sPLTJKXX = txtPLTJKXX.Value.Trim();
                if (chkBJSF.Checked)
                {
                    if (!sPLTJKXX.Equals(""))
                        sPLTJKXX += ",";
                    sPLTJKXX += "BJSF";
                }
                else
                {
                    sPLTJKXX += ",";
                    sPLTJKXX = sPLTJKXX.Replace("BJSF,", "");
                    sPLTJKXX = sPLTJKXX.TrimEnd(',');
                }
                txtPLTJKXX.Value = sPLTJKXX;
                SetPLTJKXX();
            }
        }

        protected void cbxBJFLIDS_SelectedIndexChanged(object sender, EventArgs e)
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sql = new TSQL(dberp);
            sql.Clear();
            sql.Add("SELECT XLXSBJFLYZ_YZID,XLXSTZYZ_YZMC FROM XLXSBJFLYZ");
            sql.Add("LEFT JOIN XLXSTZYZ ON XLXSBJFLYZ_YZID=XLXSTZYZ_YZID AND XLXSTZYZ_MXBH='BJD' ");
            sql.Add("WHERE ISNULL(XLXSTZYZ_TJYS,' ')=' ' AND XLXSBJFLYZ_BJFLID=:pBJFLID ");
            sql.ParamByName("pBJFLID").Value = cbxBJFLIDS.SelectedValue.ToString().Trim();
            DataSet dsXLXSBJFLYZ = dberp.OpenDataSet(sql);
            cbxTZBLYZ.ClearItems();
            cbxKSDYZ.ClearItems();
            for (int i = 0; i < dsXLXSBJFLYZ.Tables[0].Rows.Count; i++)
            {
                cbxTZBLYZ.Items.Add(new ListItem(dsXLXSBJFLYZ.Tables[0].Rows[i]["XLXSTZYZ_YZMC"].ToString().Trim(), dsXLXSBJFLYZ.Tables[0].Rows[i]["XLXSBJFLYZ_YZID"].ToString().Trim()));
                cbxKSDYZ.Items.Add(new ListItem(dsXLXSBJFLYZ.Tables[0].Rows[i]["XLXSTZYZ_YZMC"].ToString().Trim(), dsXLXSBJFLYZ.Tables[0].Rows[i]["XLXSBJFLYZ_YZID"].ToString().Trim()));
            }

        }

        
        #endregion
    }
}