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();
}
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;
}
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);
}
}
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);
}
}
/// <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;
}
}
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();
}
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);
}
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;
}