示例#1
0
        public W51020(string programID, string programName) : base(programID, programName)
        {
            InitializeComponent();
            dao51020 = new D51020();
            daoCODW  = new CODW();
            GridHelper.SetCommonGrid(gvMain);

            this.Text = _ProgramID + "─" + _ProgramName;

            #region Set Drop Down Lsit
            //交易時段 價平月份 兩個欄位要換成LookUpEdit
            _RepLookUpEdit = new RepositoryItemLookUpEdit();
            DataTable dtCPKindSource = daoCODW.ListLookUpEdit("51020", "CP_KIND");
            //cbxCPKindSource.Rows.Add("" , "");
            _RepLookUpEdit.SetColumnLookUp(dtCPKindSource, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
            gcMain.RepositoryItems.Add(_RepLookUpEdit);
            MMFT_CP_KIND.ColumnEdit = _RepLookUpEdit;

            _RepLookUpEdit2 = new RepositoryItemLookUpEdit();
            DataTable dtMarketCodeSource = daoCODW.ListLookUpEdit("MMF", "MMF_MARKET_CODE");
            _RepLookUpEdit2.SetColumnLookUp(dtMarketCodeSource, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
            gcMain.RepositoryItems.Add(_RepLookUpEdit2);
            MMFT_MARKET_CODE.ColumnEdit = _RepLookUpEdit2;
            #endregion

            Retrieve();
        }
示例#2
0
        public W51030(string programID, string programName) : base(programID, programName)
        {
            InitializeComponent();
            this.Text = _ProgramID + "─" + _ProgramName;
            dao51030  = new D51030();
            daoCODW   = new CODW();

            //gvMain基本設定
            GridHelper.SetCommonGrid(gvMain);
            //設定BandGrid字體,預設字體中文字只會顯示方塊
            gvMain.AppearancePrint.BandPanel.Font = new Font("Microsoft YaHei", 10);
            gvMain.AppearancePrint.Row.Font       = new Font("Microsoft YaHei", 9);
            //設定要列印的Grid
            PrintableComponent = gcMain;

            //交易時段
            //dic = new Dictionary<string, string>() { { "0", "一般" }, { "1", "夜盤" } };
            //DataTable mk_code = SetcolItem(dic);
            MARKET_CODE_LookUpEdit = new RepositoryItemLookUpEdit();
            DataTable mk_code = daoCODW.ListLookUpEdit("MMF", "MMF_MARKET_CODE");

            MARKET_CODE_LookUpEdit.SetColumnLookUp(mk_code, "CODW_ID", "CODW_DESC");
            MMF_MARKET_CODE.ColumnEdit = MARKET_CODE_LookUpEdit;
            //期貨/選擇權
            PROD_TYPE_LookUpEdit = new RepositoryItemLookUpEdit();
            DataTable mmfType = daoCODW.ListLookUpEdit("APDK", "APDK_PROD_TYPE");

            PROD_TYPE_LookUpEdit.SetColumnLookUp(mmfType, "CODW_ID", "CODW_DESC");
            MMF_PROD_TYPE.ColumnEdit = PROD_TYPE_LookUpEdit;
            //商品類別
            daoAPDK = new APDK();
            PARAM_KEY_LookUpEdit = new RepositoryItemLookUpEdit();
            PARAM_KEY_LookUpEdit.SetColumnLookUp(daoAPDK.ListParamKey(), "APDK_PARAM_KEY", "APDK_PARAM_KEY");
            MMF_PARAM_KEY.ColumnEdit = PARAM_KEY_LookUpEdit;

            //-週六豁免造市-此功能移除

            /*dic = new Dictionary<string, string>() { { "", "" }, { "N", "豁免" } };
             * DataTable CP_FLAG = setcolItem(dic);
             * CP_FLAG_LookUpEdit = new RepositoryItemLookUpEdit();
             * CP_FLAG_LookUpEdit.SetColumnLookUp(CP_FLAG, "ID", "Desc");
             * MMF_SAT_CP_FLAG.ColumnEdit = CP_FLAG_LookUpEdit;*/

            //報價規定判斷方式
            CP_KIND_LookUpEdit = new RepositoryItemLookUpEdit();
            DataTable mmfKIND = daoCODW.ListLookUpEdit("51030", "CP_KIND");

            CP_KIND_LookUpEdit.SetColumnLookUp(mmfKIND, "CODW_ID", "CODW_DESC");
            MMF_CP_KIND.ColumnEdit = CP_KIND_LookUpEdit;
        }
示例#3
0
        protected override ResultStatus Open()
        {
            base.Open();
            try {
                lupKind     = new RepositoryItemLookUpEdit();
                lupForeign  = new RepositoryItemLookUpEdit();
                lupCurrency = new RepositoryItemLookUpEdit();
                lupAmt      = new RepositoryItemLookUpEdit();

                //商品類別
                //DataTable dtKind = cod.ListByCol("MGT8" , "MGT8_KIND_TYPE" , " " , "  ");
                DataTable dtKind = daoCodw.ListLookUpEdit("MGT8", "MGT8_KIND_TYPE");
                Extension.SetColumnLookUp(lupKind, dtKind, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
                gcMain.RepositoryItems.Add(lupKind);

                //國內外
                DataTable dtForeign = daoCodw.ListLookUpEdit("MGT2", "MGT2_ABROAD");
                lupForeign.SetColumnLookUp(dtForeign, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
                gcMain.RepositoryItems.Add(lupForeign);

                //幣別
                //DataTable dtCurrency = cod.ListByCol2("EXRT" , "EXRT_CURRENCY_TYPE");
                DataTable dtCurrency = daoCodw.ListLookUpEdit("APDK", "APDK_CURRENCY_TYPE");
                Extension.SetColumnLookUp(lupCurrency, dtCurrency, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
                gcMain.RepositoryItems.Add(lupCurrency);

                //金額類型
                DataTable dtAmt = daoCodw.ListLookUpEdit("49061", "AMT_TYPE");
                lupAmt.SetColumnLookUp(dtAmt, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
                gcMain.RepositoryItems.Add(lupAmt);

                Retrieve();
                return(ResultStatus.Success);
            } catch (Exception ex) {
                WriteLog(ex);
                return(ResultStatus.Fail);
            }
        }
示例#4
0
        protected override ResultStatus Open()
        {
            base.Open();
            try {
                lupSpnt1 = new RepositoryItemLookUpEdit();
                dao49072 = new D49072();

                //商品
                CODW codw = new CODW();
                //DataTable dtSpnt1 = cod.ListByTxn("SPNT1");
                DataTable dtSpnt1 = codw.ListLookUpEdit("49072", "SPNT1_TYPE");
                Extension.SetColumnLookUp(lupSpnt1, dtSpnt1, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
                gcMain.RepositoryItems.Add(lupSpnt1);

                Retrieve();
                return(ResultStatus.Success);
            } catch (Exception ex) {
                WriteLog(ex);
                return(ResultStatus.Fail);
            }
        }
示例#5
0
        /// <summary>
        /// Tab 頁籤改變時, 動態設定下拉選單
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void SpanTabControl_SelectedPageChanged(object sender, DevExpress.XtraTab.TabPageChangedEventArgs e)
        {
            if (e.Page.Name != "C")
            {
                string module = e.Page.Name;
                ////IMS DB 存 INTERMONTH
                //if (module == "IMS") module = "INTERMONTH";

                string cod_col_id = "SPAN_CONTENT_TYPE_" + module;

                //取得資料
                DataTable dtContentType = daoCodw.ListLookUpEdit("S0072" + module, cod_col_id);
                RepositoryItemLookUpEdit cbxContentType = new RepositoryItemLookUpEdit();
                cbxContentType.SetColumnLookUp(dtContentType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);

                GridView   gv     = GetGridView(module);
                GridColumn column = gv.Columns[3]; //設定方式欄位
                gv.GridControl.RepositoryItems.Add(cbxContentType);
                column.ColumnEdit = cbxContentType;
            }
        }
示例#6
0
        public WS0071(string programID, string programName) : base(programID, programName)
        {
            InitializeComponent();
            this.Text = _ProgramID + "─" + _ProgramName;
            daoS0071  = new DS0071();
            daoCodw   = new CODW();
            GridHelper.SetCommonGrid(gvMain);
            _IsProcessRunAsync = true;//非同步執行

            #region Set Date Period
            //設定初始年月yyyy/MM/dd
            DataTable dtSPN = daoS0071.GetPeriodByUserId("PL", GlobalInfo.USER_ID);
            if (dtSPN.Rows.Count <= 0)
            {
                fmYmd  = DateTime.Now.AddDays(-60).ToString("yyyyMMdd");
                toYmd  = DateTime.Now.ToString("yyyyMMdd");
                maxYmd = new AOCF().GetMaxDate(fmYmd, toYmd);

                txtEndDate.DateTimeValue   = DateTime.ParseExact(maxYmd.ToString("yyyy/MM/dd"), "yyyy/MM/dd", null);
                txtStartDate.DateTimeValue = DateTime.ParseExact(maxYmd.ToString("yyyy/MM/dd"), "yyyy/MM/dd", null);
                startDateOldValue          = txtStartDate.DateTimeValue;
                endDateOldValue            = txtEndDate.DateTimeValue;
            }
            else
            {
                txtEndDate.DateTimeValue   = DateTime.ParseExact(dtSPN.Rows[0]["SPAN_PERIOD_END_DATE"].AsString(), "yyyyMMdd", null);
                txtStartDate.DateTimeValue = DateTime.ParseExact(dtSPN.Rows[0]["SPAN_PERIOD_START_DATE"].AsString(), "yyyyMMdd", null);
                startDateOldValue          = txtStartDate.DateTimeValue;
                endDateOldValue            = txtEndDate.DateTimeValue;
            }
            #endregion

            #region Set Drop Down Lsit
            //設定方式
            RepositoryItemLookUpEdit cbxParamType = new RepositoryItemLookUpEdit();
            DataTable cbxParamTypeSource          = daoCodw.ListLookUpEdit("SPAN_PAR", "SPAN_PARAM_TYPE");
            cbxParamType.SetColumnLookUp(cbxParamTypeSource, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
            gcMain.RepositoryItems.Add(cbxParamType);
            SPAN_PARAM_TYPE.ColumnEdit = cbxParamType;

            //設定值 要顯示user自己輸入的值
            RepositoryItemLookUpEdit cbxParamValue = new RepositoryItemLookUpEdit();
            DataTable cbxParamValueSource          = daoCodw.ListLookUpEdit("SPAN_PAR", "SPAN_PARAM_VALUE");
            //DataTable dtParamValueData = daoS0071.GetParamData("PL", GlobalInfo.USER_ID);//DB現有資料
            //DataTable dtTempParamValue = cbxParamValueSource.Clone();
            //for (int i = 0; i < dtParamValueData.Rows.Count; i++) {
            //   //參數檔案
            //   dtTempParamValue.Rows.Add();
            //   dtTempParamValue.Rows[i].SetField("CODW_ID", dtParamValueData.Rows[i]["span_param_value"]);
            //   dtTempParamValue.Rows[i].SetField("CODW_DESC", dtParamValueData.Rows[i]["span_param_value"]);
            //   dtTempParamValue.Rows[i].SetField("CP_DISPLAY", dtParamValueData.Rows[i]["span_param_value"]);

            //   //CODID = 4 時 顯示 "最大漲跌停"
            //   if (dtTempParamValue.Rows[i]["CODW_ID"].AsString() == "4") {
            //      dtTempParamValue.Rows[i].SetField("CODW_DESC", "最大漲跌停");
            //   }
            //}
            //DataView dtDistinc = new DataView(dtTempParamValue);
            //dtTempParamValue = dtDistinc.ToTable(true);
            //dtTempParamValue.PrimaryKey = new DataColumn[] { dtTempParamValue.Columns["CODW_ID"] };
            //cbxParamValueSource.PrimaryKey = new DataColumn[] { cbxParamValueSource.Columns["CODW_ID"] };
            //cbxParamValueSource.Merge(dtTempParamValue, false);
            cbxParamValue.SetColumnLookUp(cbxParamValueSource, "CODW_ID", "CODW_DESC", TextEditStyles.Standard, "");
            cbxParamValue.ProcessNewValue += new ProcessNewValueEventHandler(cbxParamValue_ProcessNewValue);
            gcMain.RepositoryItems.Add(cbxParamValue);
            SPAN_PARAM_VALUE.ColumnEdit = cbxParamValue;

            //波動度設定
            RepositoryItemLookUpEdit cbxParamVolType = new RepositoryItemLookUpEdit();
            DataTable cbxParamVolTypeSource          = daoCodw.ListLookUpEdit("SPAN_PAR", "SPAN_PARAM_VOL_TYPE");
            cbxParamVolType.SetColumnLookUp(cbxParamVolTypeSource, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
            gcMain.RepositoryItems.Add(cbxParamVolType);
            SPAN_PARAM_VOL_TYPE.ColumnEdit = cbxParamVolType;

            //商品類別
            DataTable dtProdType = daoS0071.dddw_zparm_comb_prod(txtEndDate.DateTimeValue.ToString("yyyyMMdd"));
            RepositoryItemLookUpEdit cbxProdType = new RepositoryItemLookUpEdit();
            cbxProdType.SetColumnLookUp(dtProdType, "PROD_GROUP_VALUE", "PROD_GROUP", TextEditStyles.DisableTextEditor, "");
            gcMain.RepositoryItems.Add(cbxProdType);
            SPAN_PARAM_CLASS.ColumnEdit = cbxProdType;

            //商品組合
            DataTable dtProd = daoS0071.dddw_zparm_comb_prod_by_group(txtEndDate.DateTimeValue.ToString("yyyyMMdd"), "%%", "%%");
            RepositoryItemLookUpEdit cbxProd = new RepositoryItemLookUpEdit();
            cbxProd.SetColumnLookUp(dtProd, "COMB_PROD_VALUE", "COMB_PROD", TextEditStyles.DisableTextEditor, "");
            gcMain.RepositoryItems.Add(cbxProd);
            SPAN_PARAM_CC.ColumnEdit = cbxProd;

            //製作連動下拉選單(觸發事件)
            gvMain.ShownEditor           += GridView_ShownEditor;
            cbxProdType.EditValueChanged += cbxProdType_EditValueChanged;
            #endregion

            Retrieve();
        }
示例#7
0
        protected override ResultStatus Retrieve()
        {
            base.Retrieve(gcPresTest);
            GridHelper.SetCommonGrid(gvPresTest);
            GridHelper.SetCommonGrid(gvExAccount);

            #region Set Date Period
            //save 後替換新值 不指定userId DB中都只存在一筆 ST Period
            DataTable dtSPN = daoS0070.GetPeriodByUserId("ST", "%");

            //若無 ST Period 則用現在日期前60天取 AOCF
            if (dtSPN.Rows.Count <= 0)
            {
                fmYmd  = DateTime.Now.AddDays(-60).ToString("yyyyMMdd");
                toYmd  = DateTime.Now.ToString("yyyyMMdd");
                maxYmd = new AOCF().GetMaxDate(fmYmd, toYmd);

                txtStartDate.DateTimeValue = DateTime.ParseExact(maxYmd.ToString("yyyy/MM/dd"), "yyyy/MM/dd", null);
                txtEndDate.DateTimeValue   = DateTime.ParseExact(maxYmd.ToString("yyyy/MM/dd"), "yyyy/MM/dd", null);
                startDateOldValue          = txtStartDate.DateTimeValue;
                endDateOldValue            = txtEndDate.DateTimeValue;
            }
            else
            {
                txtStartDate.DateTimeValue = DateTime.ParseExact(dtSPN.Rows[0]["SPAN_PERIOD_START_DATE"].AsString(), "yyyyMMdd", null);
                txtEndDate.DateTimeValue   = DateTime.ParseExact(dtSPN.Rows[0]["SPAN_PERIOD_END_DATE"].AsString(), "yyyyMMdd", null);
                startDateOldValue          = txtStartDate.DateTimeValue;
                endDateOldValue            = txtEndDate.DateTimeValue;
            }
            #endregion

            #region Set Drop Down Lsit
            //保證金類別
            DataTable cbxSpanReqTypeSource = daoCodw.ListLookUpEdit("S0070", "SPAN_REQ_TYPE");
            SPAN_REQ_TYPE.SetDataTable(cbxSpanReqTypeSource, "CODW_ID", "CODW_DESC");

            //設定方式
            RepositoryItemLookUpEdit cbxParamType = new RepositoryItemLookUpEdit();
            DataTable cbxParamTypeSource          = daoCodw.ListLookUpEdit("SPAN_PAR", "SPAN_PARAM_TYPE");
            cbxParamType.SetColumnLookUp(cbxParamTypeSource, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
            gcPresTest.RepositoryItems.Add(cbxParamType);
            SPAN_PARAM_TYPE.ColumnEdit = cbxParamType;

            //設定值
            RepositoryItemLookUpEdit cbxParamValue = new RepositoryItemLookUpEdit();
            DataTable cbxParamValueSource          = daoCodw.ListLookUpEdit("SPAN_PAR", "SPAN_PARAM_VALUE");
            //DataTable dtParamValueData = daoS0070.GetParamData("ST", "%");//DB現有資料
            //DataTable dtTempParamValue = cbxParamValueSource.Clone();
            //for (int i = 0; i < dtParamValueData.Rows.Count; i++) {
            //   //參數檔案
            //   dtTempParamValue.Rows.Add();
            //   dtTempParamValue.Rows[i].SetField("CODW_ID", dtParamValueData.Rows[i]["span_param_value"]);
            //   dtTempParamValue.Rows[i].SetField("CODW_DESC", dtParamValueData.Rows[i]["span_param_value"]);
            //   dtTempParamValue.Rows[i].SetField("CP_DISPLAY", dtParamValueData.Rows[i]["span_param_value"]);

            //   //CODID = 4 時 顯示 "最大漲跌停"
            //   if (dtTempParamValue.Rows[i]["CODW_ID"].AsString() == "4") {
            //      dtTempParamValue.Rows[i].SetField("CODW_DESC", "最大漲跌停");
            //   }
            //}
            //DataView dtDistinc = new DataView(dtTempParamValue);
            //dtTempParamValue = dtDistinc.ToTable(true);
            //dtTempParamValue.PrimaryKey = new DataColumn[] { dtTempParamValue.Columns["COD_ID"] };
            //cbxParamValueSource.PrimaryKey = new DataColumn[] { cbxParamValueSource.Columns["COD_ID"] };
            //cbxParamValueSource.Merge(dtTempParamValue, false);
            cbxParamValue.SetColumnLookUp(cbxParamValueSource, "CODW_ID", "CODW_DESC", TextEditStyles.Standard, "");
            cbxParamValue.ProcessNewValue += new ProcessNewValueEventHandler(cbxParamValue_ProcessNewValue);
            gcPresTest.RepositoryItems.Add(cbxParamValue);
            SPAN_PARAM_VALUE.ColumnEdit = cbxParamValue;

            //波動度設定
            RepositoryItemLookUpEdit cbxParamVolType = new RepositoryItemLookUpEdit();
            DataTable cbxParamVolTypeSource          = daoCodw.ListLookUpEdit("SPAN_PAR", "SPAN_PARAM_VOL_TYPE");
            cbxParamVolType.SetColumnLookUp(cbxParamVolTypeSource, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
            gcPresTest.RepositoryItems.Add(cbxParamVolType);
            SPAN_PARAM_VOL_TYPE.ColumnEdit = cbxParamVolType;

            //商品類別
            DataTable dtProdType = daoS0070.dddw_zparm_comb_prod(txtEndDate.DateTimeValue.ToString("yyyyMMdd"));
            RepositoryItemLookUpEdit cbxProdType = new RepositoryItemLookUpEdit();
            cbxProdType.SetColumnLookUp(dtProdType, "PROD_GROUP_VALUE", "PROD_GROUP", TextEditStyles.DisableTextEditor, "");
            gcPresTest.RepositoryItems.Add(cbxProdType);
            SPAN_PARAM_CLASS.ColumnEdit = cbxProdType;

            //商品組合
            DataTable dtProd = daoS0070.dddw_zparm_comb_prod_by_group(txtEndDate.DateTimeValue.ToString("yyyyMMdd"), "%%", "%%");
            RepositoryItemLookUpEdit cbxProd = new RepositoryItemLookUpEdit();
            cbxProd.SetColumnLookUp(dtProd, "COMB_PROD_VALUE", "COMB_PROD", TextEditStyles.DisableTextEditor, "");
            gcPresTest.RepositoryItems.Add(cbxProd);
            SPAN_PARAM_CC.ColumnEdit = cbxProd;

            //製作連動下拉選單(觸發事件)
            gvPresTest.ShownEditor       += GridView_ShownEditor;
            cbxProdType.EditValueChanged += cbxProdType_EditValueChanged;
            #endregion

            #region Set REQ Value
            //不指定userId DB中都只存在一筆 ST REQ
            DataTable dtREQ = daoS0070.GetREQDataByUser("ST", "%");
            if (dtREQ.Rows.Count > 0)
            {
                SPAN_REQ_TYPE.EditValue = dtREQ.Rows[0]["SPAN_REQ_TYPE"].AsString();
                txtREQValue.Text        = dtREQ.Rows[0]["SPAN_REQ_VALUE"].AsString();
                oldREQValue             = txtREQValue.EditValue.ToString();
                oldREQType = dtREQ.Rows[0]["SPAN_REQ_TYPE"].AsString();
            }
            #endregion

            #region Retrieve grid
            //抓取資料不限 現在登入之userId
            DataTable exAccountTable = daoS0070.GetExAccountData("ST");
            DataTable presTestTable  = daoS0070.GetParamData("ST", "%");
            if (exAccountTable.Rows.Count == 0)
            {
                MessageBox.Show("移除帳號無任何資料", "訊息", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            if (exAccountTable.Rows.Count == 0)
            {
                MessageBox.Show("壓力測試設定無任何資料", "訊息", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            gcExAccount.DataSource = exAccountTable;
            gcPresTest.DataSource  = presTestTable;

            #endregion
            return(ResultStatus.Success);
        }
示例#8
0
        public WS0072(string programID, string programName) : base(programID, programName)
        {
            InitializeComponent();
            this.Text = _ProgramID + "─" + _ProgramName;
            txtStartDate.EnterMoveNextControl = true;
            txtEndDate.EnterMoveNextControl   = true;
            GridHelper.SetCommonGrid(gv_ZISP);
            _IsProcessRunAsync = true;//非同步執行

            for (int i = 0; i < modules1.Length; i++)
            {
                GridView gv = GetGridView(modules1[i]);

                GridHelper.SetCommonGrid(gv);
            }
            daoS0072 = new DS0072();
            daoCodw  = new CODW();

            //設定初始年月
            setDatePeriod();

            ////2.設定下拉選單
            DataTable dtProdType = daoS0072.dddw_zparm_comb_prod(txtEndDate.DateTimeValue.ToString("yyyyMMdd"));
            RepositoryItemLookUpEdit cbxProdType = new RepositoryItemLookUpEdit();

            cbxProdType.SetColumnLookUp(dtProdType, "PROD_GROUP_VALUE", "PROD_GROUP", TextEditStyles.DisableTextEditor);
            gc_ZISP.RepositoryItems.Add(cbxProdType);
            SPAN_ZISP_PROD_ID.ColumnEdit = cbxProdType;

            DataTable dtProd = daoS0072.dddw_zparm_comb_prod_by_group(txtEndDate.DateTimeValue.ToString("yyyyMMdd"), "%%", "%%");
            RepositoryItemLookUpEdit cbxProd = new RepositoryItemLookUpEdit();

            cbxProd.SetColumnLookUp(dtProd, "COMB_PROD_VALUE", "COMB_PROD", TextEditStyles.DisableTextEditor);
            gc_ZISP.RepositoryItems.Add(cbxProd);
            SPAN_ZISP_COM_PROD1.ColumnEdit = cbxProd;
            SPAN_ZISP_COM_PROD2.ColumnEdit = cbxProd;

            //PSR_SPAN_CONTENT_TYPE.ColumnEdit = cbxContentType;

            //grid 細部設定
            foreach (GridColumn col in gv_ZISP.Columns)
            {
                col.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
            }

            Retrieve();

            //製作連動下拉選單(加入觸發事件)
            for (int i = 0; i < modules1.Length; i++)
            {
                Control[]   gridControls = this.Controls.Find("gc_" + modules1[i], true);
                GridControl gc           = (GridControl)gridControls[0];
                GridView    gv           = gc.MainView as GridView;

                gc.RepositoryItems.Add(cbxProdType);
                gc.RepositoryItems.Add(cbxProd);
                gv.Columns["SPAN_CONTENT_CLASS"].ColumnEdit = cbxProdType;
                gv.Columns["SPAN_CONTENT_CC"].ColumnEdit    = cbxProd;

                //DataTable dtContentType = daoCodw.ListByCol2("S0072", $"{modules1[i]}_CONTENT_TYPE");
                DataTable dtContentType = daoCodw.ListLookUpEdit("S0072A", $"SPAN_CONTENT_TYPE_A");
                RepositoryItemLookUpEdit cbxContentType = new RepositoryItemLookUpEdit();
                cbxContentType.SetColumnLookUp(dtContentType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
                gc_PSR.RepositoryItems.Add(cbxContentType);
                gv.Columns["SPAN_CONTENT_TYPE"].ColumnEdit = cbxContentType;

                gv.ShownEditor += GridView_ShownEditor;
            }
            gv_ZISP.ShownEditor          += ZISP_gridView_ShownEditor;
            cbxProdType.EditValueChanged += cbxProdType_EditValueChanged;
        }