protected override ResultStatus Open()
{
base.Open();
//1. 設定時間初始值
txtStartDate.DateTimeValue = GlobalInfo.OCF_DATE;
txtEndDate.DateTimeValue = GlobalInfo.OCF_DATE;
txtStartTime.EditValue = "08:45";
txtEndTime.EditValue = "13:45";
//2. 設定下拉選單
//造市者
DataTable dtFcmAcc = new ABRK().ListFcmAccNo();//第一行空白+ampd_fcm_no/abrk_name/cp_display
dw_sbrkno.SetDataTable(dtFcmAcc, "AMPD_FCM_NO", "CP_DISPLAY", TextEditStyles.DisableTextEditor, " ");
//商品
DataTable dtProd = new APDK().ListAll3();//第一行空白+apdk_prod_type/pdk_kind_id/market_code
dw_prod_kd.SetDataTable(dtProd, "PDK_KIND_ID", "PDK_KIND_ID", TextEditStyles.DisableTextEditor, " ");
//買賣權
DataTable dtCP = new CODW().ListLookUpEdit("50060", "50060_DDLB_1");
foreach (DataRow dr in dtCP.Rows)
{
if (dr["CODW_ID"].AsString() == "N")
{
dr["CODW_ID"] = " ";
}
}
ddlb_1.SetDataTable(dtCP, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
return(ResultStatus.Success);
}
public W40041(string programID, string programName) : base(programID, programName)
{
dao40041 = new D40041();
InitializeComponent();
this.Text = _ProgramID + "─" + _ProgramName;
txtDate.DateTimeValue = DateTime.Now;
oswGrpLookItem.SetDataTable(new OCFG().ListAll(), "OSW_GRP", "OSW_GRP_NAME", TextEditStyles.DisableTextEditor, null);
oswGrpLookItem.ItemIndex = 0;
//設定 下拉選單
//List<LookupItem> prodGrp = new List<LookupItem>(){
// new LookupItem() { ValueMember = "Y", DisplayMember = "1-當日達得調整標準之契約"},
// new LookupItem() { ValueMember = "%", DisplayMember = "%-全部契約" }};
DataTable dtProd = new CODW().ListLookUpEdit("40041", "DATA_TYPE");
prodLookItem.SetDataTable(dtProd, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
prodLookItem.ItemIndex = 0; // Y
#if DEBUG
txtDate.DateTimeValue = ("2018/11/01").AsDateTime();
oswGrpLookItem.EditValue = "%";
#endif
radioGroup1.EditValue = "ALL";
ExportShow.Hide();
GridHelper.SetCommonGrid(gvMain);
gcMain.Visible = false;
reCountBtn.Click += reCountBtn_Click;
}
protected override ResultStatus Open()
{
base.Open();
//設定 商品單複式 下拉選單
DataTable lstScCode = new CODW().ListLookUpEdit("30681", "DDLB_SC");
Extension.SetDataTable(ddlScCode, lstScCode, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
Extension.SetDataTable(ddlScCode_new, lstScCode, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
ddlScCode.ItemIndex =
ddlScCode_new.ItemIndex = 0;
//設定 委託單方式 下拉選單
DataTable dtOsfOrderType = new CODW().ListLookUpEdit("30681", "OSF_ORDER_TYPE");
Extension.SetDataTable(ddlOsfOrderType, dtOsfOrderType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
Extension.SetDataTable(ddlOsfOrderType_new, dtOsfOrderType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
ddlOsfOrderType.ItemIndex =
ddlOsfOrderType_new.ItemIndex = 0;
//設定 委託單條件 下拉選單
DataTable dtOsfOrderCond = new CODW().ListLookUpEdit("30681", "OSF_ORDER_COND");
Extension.SetDataTable(ddlOsfOrderCond, dtOsfOrderCond, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
Extension.SetDataTable(ddlOsfOrderCond_new, dtOsfOrderCond, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
ddlOsfOrderCond.ItemIndex =
ddlOsfOrderCond_new.ItemIndex = 0;
return(ResultStatus.Success);
}
protected override ResultStatus Open()
{
base.Open();
try {
lupOswGrp = new RepositoryItemLookUpEdit();
lupDataType = new RepositoryItemLookUpEdit();
//收盤群組
//List<LookupItem> dtOswGrp = new List<LookupItem>(){
// new LookupItem() { ValueMember = " ", DisplayMember = " "},
// new LookupItem() { ValueMember = "1", DisplayMember = "Group 1"},
// new LookupItem() { ValueMember = "5", DisplayMember = "Group 2"}};
DataTable dtOswGrp = new CODW().ListLookUpEdit("49070", "OSW_GRP");
lupOswGrp.SetColumnLookUp(dtOswGrp, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
gcMain.RepositoryItems.Add(lupOswGrp);
//商品狀態
//List<LookupItem> dtDataType = new List<LookupItem>(){
// new LookupItem() { ValueMember = " ", DisplayMember = " "},
// new LookupItem() { ValueMember = "E", DisplayMember = "下市"}};
DataTable dtDataType = new CODW().ListLookUpEdit("49070", "DATA_TYPE");
lupDataType.SetColumnLookUp(dtDataType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
gcMain.RepositoryItems.Add(lupDataType);
Retrieve();
return(ResultStatus.Success);
} catch (Exception ex) {
WriteLog(ex);
return(ResultStatus.Fail);
}
}
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();
}
protected override ResultStatus Open()
{
base.Open();
//1. 設定時間初始值
txtStartDate.DateTimeValue = GlobalInfo.OCF_DATE;
txtEndDate.DateTimeValue = GlobalInfo.OCF_DATE;
txtStartTime.EditValue = "08:45";
txtEndTime.EditValue = "13:45";
//2. 設定下拉選單
//造市者
DataTable dtFcmAcc = new ABRK().ListFcmAccNo();//第一行空白+ampd_fcm_no/abrk_name/cp_display
dw_sbrkno.SetDataTable(dtFcmAcc, "AMPD_FCM_NO", "CP_DISPLAY", TextEditStyles.DisableTextEditor, " ");
//商品
DataTable dtProd = new APDK().ListAll3();//第一行空白+apdk_prod_type/pdk_kind_id/market_code
dw_prod_kd.SetDataTable(dtProd, "PDK_KIND_ID", "PDK_KIND_ID", TextEditStyles.DisableTextEditor, " ");
//買賣權
DataTable dtCP = new CODW().ListLookUpEdit("AMMD", "AMMD_PC_CODE");
ddlb_1.SetDataTable(dtCP, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
ddlb_1.ItemIndex = 0;
return(ResultStatus.Success);
}
protected override ResultStatus Open()
{
base.Open();
//設定 商品單複式 下拉選單
//List<LookupItem> lstScCode = new List<LookupItem>(){
// new LookupItem() { ValueMember = "%", DisplayMember = "% (全部)"},
// new LookupItem() { ValueMember = "S%", DisplayMember = "S (單式)" },
// new LookupItem() { ValueMember = "C%", DisplayMember = "C (複式)" }};
DataTable lstScCode = new CODW().ListLookUpEdit("30681", "30681_DDLB_SC");
Extension.SetDataTable(ddlScCode, lstScCode, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
ddlScCode.ItemIndex = 0;
//設定 委託單方式 下拉選單
//DataTable dtOsfOrderType = new COD().ListByCol3("OSF" , "OSF_ORDER_TYPE" , "全部" , "%");
DataTable dtOsfOrderType = new CODW().ListLookUpEdit("30681", "OSF_ORDER_TYPE");
Extension.SetDataTable(ddlOsfOrderType, dtOsfOrderType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
ddlOsfOrderType.ItemIndex = 0;
//設定 委託單條件 下拉選單
//DataTable dtOsfOrderCond = new COD().ListByCol3("OSF" , "OSF_ORDER_COND" , "全部" , "%");
DataTable dtOsfOrderCond = new CODW().ListLookUpEdit("30681", "OSF_ORDER_COND");
Extension.SetDataTable(ddlOsfOrderCond, dtOsfOrderCond, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
ddlOsfOrderCond.ItemIndex = 0;
return(ResultStatus.Success);
}
protected override ResultStatus Open()
{
base.Open();
RepositoryItemLookUpEdit _RepLookUpEdit = new RepositoryItemLookUpEdit();
lupType = new RepositoryItemLookUpEdit();
//dropdownlist
//DataTable dtDropType = new DataTable();
//dtDropType.Columns.Add("PARAM_KEY" , typeof(string));
//dtDropType.Columns.Add("CP_DISPLAY" , typeof(string));
//DataRow row1 = dtDropType.NewRow();
//row1["PARAM_KEY"] = "-";
//row1["CP_DISPLAY"] = "無";
//dtDropType.Rows.Add(row1);
//DataRow row2 = dtDropType.NewRow();
//row2["PARAM_KEY"] = "A";
//row2["CP_DISPLAY"] = "A值";
//dtDropType.Rows.Add(row2);
//DataRow row3 = dtDropType.NewRow();
//row3["PARAM_KEY"] = "B";
//row3["CP_DISPLAY"] = "B值";
//dtDropType.Rows.Add(row3);
DataTable dtDropType = new CODW().ListLookUpEdit("49040", "MGT4_TYPE");
Extension.SetColumnLookUp(lupType, dtDropType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
gcMain.RepositoryItems.Add(lupType);
Retrieve();
return(ResultStatus.Success);
}
public W49061(string programID, string programName) : base(programID, programName)
{
InitializeComponent();
this.Text = _ProgramID + "─" + _ProgramName;
GridHelper.SetCommonGrid(gvMain);
daoCodw = new CODW();
}
public WS0070(string programID, string programName) : base(programID, programName)
{
InitializeComponent();
daoS0070 = new DS0070();
daoCodw = new CODW();
_IsProcessRunAsync = true;//非同步執行
Retrieve();
}
protected override ResultStatus Open()
{
base.Open();
try {
lupProdSubtype = new RepositoryItemLookUpEdit();
lupKindId = new RepositoryItemLookUpEdit();
dao49010 = new D49010();
//契約類別
//DataTable dtProdSubtype = dao49010.GetDdlProdSubtype();
DataTable dtProdSubtype = new CODW().ListLookUpEdit("49010", "49010_PDK_SUBTYPE");
Extension.SetColumnLookUp(lupProdSubtype, dtProdSubtype, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
gcMain.RepositoryItems.Add(lupProdSubtype);
//契約代號
DataTable dtProdKindId = dao49010.GetDdlKindId();
Extension.SetColumnLookUp(lupKindId, dtProdKindId, "MGT2_KIND_ID", "MGT2_KIND_ID", TextEditStyles.DisableTextEditor);
gcMain.RepositoryItems.Add(lupKindId);
DataTable dtAll = dao49010.GetDataList();
DataTable dt = dtAll.Clone();
//1. 設定gvMain
gcMain.DataSource = dt;
gvMain.AppearancePrint.BandPanel.Options.UseTextOptions = true;
gvMain.AppearancePrint.BandPanel.TextOptions.WordWrap = WordWrap.Wrap;
gvMain.AppearancePrint.BandPanel.Font = new Font("Microsoft YaHei", 10);
gvMain.AppearancePrint.Row.Font = new Font("Microsoft YaHei", 10);
gvMain.OptionsPrint.AllowMultilineHeaders = true;
gvMain.AppearancePrint.GroupRow.Font = new Font("Microsoft YaHei", 10);
gvMain.BestFitColumns();
GridHelper.SetCommonGrid(gvMain);
gridBand9.AppearanceHeader.TextOptions.WordWrap = WordWrap.Wrap;
gridBand9.Caption = "(輸入方式：如3.5%，則輸入0.035)";
gvMain.Columns["CPR_PROD_SUBTYPE"].ColumnEdit = lupProdSubtype;
gvMain.Columns["CPR_KIND_ID"].ColumnEdit = lupKindId;
//製作連動下拉選單(觸發事件)
gvMain.ShownEditor += gvMain_ShownEditor;
lupProdSubtype.EditValueChanged += lupProdSubtype_EditValueChanged;
//gcMain.Visible = true;
gcMain.Focus();
InsertRow();
return(ResultStatus.Success);
} catch (Exception ex) {
WriteLog(ex);
}
return(ResultStatus.Fail);
}
/// <summary>
/// 商品對照類別欄位
/// </summary>
//private void ApdkParamKey() {
// List<LookupItem> pkList = new List<LookupItem>(){
// new LookupItem() { ValueMember = " ", DisplayMember = " " }};
// ApdkParamKeyLookUpEdit.SetColumnLookUp(pkList , "ValueMember" , "DisplayMember" , TextEditStyles.Standard , null);
// APDK_PARAM_KEY.ColumnEdit = ApdkParamKeyLookUpEdit;
//}
/// <summary>
/// 商品子類別欄位
/// </summary>
private void ApdkProdSubtype()
{
//DataTable apdkListCol = new COD().ListByCol("APDK" , "APDK_PROD_SUBTYPE");
//apdkListCol.Rows.RemoveAt(0);
DataTable apdkListCol = new CODW().ListLookUpEdit("APDK", "APDK_PROD_SUBTYPE");
ApdkProdSubtypeLookUpEdit.SetColumnLookUp(apdkListCol, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
APDK_PROD_SUBTYPE.ColumnEdit = ApdkProdSubtypeLookUpEdit;
}
protected override ResultStatus Open()
{
try {
base.Open();
txtDate.DateTimeValue = GlobalInfo.OCF_DATE;
txtEffDate.EditValue = "1901/01/01";
txtEffDateLower.EditValue = "1901/01/01";
#if DEBUG
txtDate.EditValue = "2018/12/28";
#endif
//「本次擬調整狀態」欄位的下拉選單
//dic = new Dictionary<string, string>() { { " ", "不變" }, { "+", "調高" }, { "-", "降低" } };
//DataTable dtStatus = setColItem(dic);
DataTable dtStatus = new CODW().ListLookUpEdit("30203", "PL1B_ADJ");
foreach (DataRow dr in dtStatus.Rows)
{
if (dr["CODW_ID"].AsString() == "S")
{
dr["CODW_ID"] = " ";
}
}
statusLookUpEdit = new RepositoryItemLookUpEdit();
statusLookUpEdit.SetColumnLookUp(dtStatus, "CODW_ID", "CODW_DESC");
PL1B_ADJ.ColumnEdit = statusLookUpEdit;
PL1_NATURE_ADJ.ColumnEdit = statusLookUpEdit;
PL1_LEGAL_ADJ.ColumnEdit = statusLookUpEdit;
#region BandedColumnCaption換行
//gvGBF
PL1B_PREV_NATURE_LEGAL_MTH.Caption = "單一" + Environment.NewLine + "月份";
PL1B_PREV_NATURE_LEGAL_TOT.Caption = "各月份" + Environment.NewLine + "合計";
PL1B_PREV_999_MTH.Caption = "單一" + Environment.NewLine + "月份";
PL1B_PREV_999_NEARBY_MTH.Caption = "最近到期" + Environment.NewLine + "月份";
PL1B_PREV_999_TOT.Caption = "各月份" + Environment.NewLine + "合計";
PL1B_NATURE_LEGAL_MTH.Caption = "單一" + Environment.NewLine + "月份";
PL1B_NATURE_LEGAL_TOT.Caption = "各月份" + Environment.NewLine + "年月";
PL1B_999_MTH.Caption = "單一" + Environment.NewLine + "月份";
PL1B_999_NEARBY_MTH.Caption = "單一" + Environment.NewLine + "月份";
PL1B_999_TOT.Caption = "最近到期" + Environment.NewLine + "合計";
PL1B_ADJ.Caption = "本次" + Environment.NewLine + "擬調整" + Environment.NewLine + "狀態";
//gvMain
bandCur.Caption = "現行" + Environment.NewLine + "部位限制數";
bandCP.Caption = "按交易規則檢視後" + Environment.NewLine + "之部位限制數";
bandCompute1.Caption = "近1~6月" + Environment.NewLine + "日均交易量與未沖銷量" + Environment.NewLine + "數值取大者";
bandPL1_NATURE_LEGAL.Caption = "針對須調降之商品" + Environment.NewLine + "再增加檢視標準後";
bandPL1B_ADJ.Caption = Environment.NewLine + "本次擬調整狀態";
#endregion
} catch (Exception ex) {
throw ex;
}
return(ResultStatus.Success);
}
protected override ResultStatus Open()
{
base.Open();
txtSDate.EditValue = GlobalInfo.OCF_DATE;
lupSubType = new RepositoryItemLookUpEdit();
#if DEBUG
//txtSDate.DateTimeValue = DateTime.ParseExact("2018/06/15", "yyyy/MM/dd", null);
//this.Text += "(開啟測試模式),ocfDate=2018/06/15";
#endif
//1.契約類別 下拉選單(ken,用48010帶入才可以...)
//DataTable dtSubType = new COD().ListByCol("48010" , "PDK_SUBTYPE " , "全選" , "%"); //第一行全選 + COD_ID / COD_DESC / COD_SEQ_NO
//ken,特殊,再往上新增一筆
//DataRow drTemp = dtSubType.NewRow();
//drTemp["COD_ID"] = " ";
//drTemp["COD_DESC"] = ChooseSingleKind;
//drTemp["COD_SEQ_NO"] = -1;
//dtSubType.Rows.InsertAt(drTemp , 0);
//Extension.SetDataTable(ddlSubType , dtSubType , "COD_ID" , "COD_DESC" , TextEditStyles.DisableTextEditor , "");
DataTable dtSubType = new CODW().ListLookUpEdit("48020", "48020_PDK_SUBTYPE");
Extension.SetDataTable(ddlSubType, dtSubType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
lupSubType.SetColumnLookUp(dtSubType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
gcMain.RepositoryItems.Add(lupSubType);
//ken,設定選單事件
this.ddlSubType.EditValueChanged += new System.EventHandler(this.ddlSubType_EditValueChanged);
//2.契約代號 下拉選單
DataTable dtKind = dao48020.ListKind(); //MGT2_SEQ_NO/MGT2_KIND_ID/MGT2_PROD_SUBTYPE
Extension.SetDataTable(ddlKind, dtKind, "MGT2_KIND_ID", "MGT2_KIND_ID", TextEditStyles.DisableTextEditor, "");
//3.資料內容 下拉選單
//List<LookupItem> lstData = new List<LookupItem>(){
// new LookupItem() { ValueMember = "KeyInfo", DisplayMember = "1.重點資料"},
// new LookupItem() { ValueMember = "Detail", DisplayMember = "2.明細資料" }};
DataTable dtData = new CODW().ListLookUpEdit("48020", "48020_DATA_TYPE");
Extension.SetDataTable(ddlData, dtData, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
//ken,設定選單事件
this.ddlData.EditValueChanged += new System.EventHandler(this.ddlData_EditValueChanged);
//4.排序方式 下拉選單
//List<LookupItem> lstSort = new List<LookupItem>(){
// new LookupItem() { ValueMember = "DATE", DisplayMember = "1.依系統生效日期排序"},
// new LookupItem() { ValueMember = "KIND", DisplayMember = "2.依契約類別排序" }};
DataTable dtSort = new CODW().ListLookUpEdit("48020", "48020_SORT_TYPE");
Extension.SetDataTable(ddlSort, dtSort, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
return(ResultStatus.Success);
}
protected override ResultStatus Open()
{
base.Open();
try {
lupKind = new RepositoryItemLookUpEdit();
lupForeign = new RepositoryItemLookUpEdit();
lupCurrency = new RepositoryItemLookUpEdit();
lupAmt = new RepositoryItemLookUpEdit();
COD cod = new COD();
//商品類別
//DataTable dtKind = cod.ListByCol("MGT8" , "MGT8_KIND_TYPE" , " " , " ");
DataTable dtKind = new CODW().ListLookUpEdit("49061", "49061_MGT8_KIND_TYPE");
Extension.SetColumnLookUp(lupKind, dtKind, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
gcMain.RepositoryItems.Add(lupKind);
//國內外 CI.CODW參數為(國內 : "N" 國外: "Y")
//List<LookupItem> dtForeign = new List<LookupItem>(){
// new LookupItem() { ValueMember = " ", DisplayMember = "國內"},
// new LookupItem() { ValueMember = "Y", DisplayMember = "國外"}};
//lupForeign = new RepositoryItemLookUpEdit();
DataTable dtForeign = new CODW().ListLookUpEdit("49061", "49061_MGT2_ABROAD");
foreach (DataRow dr in dtForeign.Rows)
{
if (dr["CODW_ID"].AsString() == "N")
{
dr["CODW_ID"] = " ";
}
}
lupForeign.SetColumnLookUp(dtForeign, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
gcMain.RepositoryItems.Add(lupForeign);
//幣別
//DataTable dtCurrency = cod.ListByCol2("EXRT" , "EXRT_CURRENCY_TYPE");
DataTable dtCurrency = new CODW().ListLookUpEdit("49061", "49061_CURRENCY_TYPE");
Extension.SetColumnLookUp(lupCurrency, dtCurrency, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
gcMain.RepositoryItems.Add(lupCurrency);
//金額類型
//List<LookupItem> dtAmt = new List<LookupItem>(){
// new LookupItem() { ValueMember = "P", DisplayMember = "比例"},
// new LookupItem() { ValueMember = "A", DisplayMember = "金額"}};
//lupForeign = new RepositoryItemLookUpEdit();
DataTable dtAmt = new CODW().ListLookUpEdit("49061", "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);
}
}
/// <summary>
/// 系統欄位
/// </summary>
private void ApdkProdType()
{
//List<LookupItem> typelist = new List<LookupItem>(){
// new LookupItem() { ValueMember = "F", DisplayMember = "期貨" },
// new LookupItem() { ValueMember = "O", DisplayMember = "選擇權"}};
DataTable dtTypelist = new CODW().ListLookUpEdit("APDK", "APDK_PROD_TYPE");
ApdkProdTypeLookUpEdit.SetColumnLookUp(dtTypelist, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
APDK_PROD_TYPE.ColumnEdit = ApdkProdTypeLookUpEdit;
}
/// <summary>
/// 上市/上櫃欄位
/// </summary>
private void UnderlyingMarket()
{
//List<LookupItem> UnderlyingMarketList = new List<LookupItem>(){
// new LookupItem() { ValueMember = "1", DisplayMember = "上市"},
// new LookupItem() { ValueMember = "2", DisplayMember = "上櫃"},
// new LookupItem() { ValueMember = " ", DisplayMember = " " }};
DataTable dtUnderlyingMarketList = new CODW().ListLookUpEdit("APDK", "UNDERLYING_MARKET");
ApdkUnderlyingMarketLookUpEdit.SetColumnLookUp(dtUnderlyingMarketList, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
APDK_UNDERLYING_MARKET.ColumnEdit = ApdkUnderlyingMarketLookUpEdit;
}
/// <summary>
/// 一般/小型 欄位
/// </summary>
private void ApdkRemark()
{
//List<LookupItem> remarkList = new List<LookupItem>(){
// new LookupItem() { ValueMember = " ", DisplayMember = "一般"},
// new LookupItem() { ValueMember = "M", DisplayMember = "小型"},
// new LookupItem() { ValueMember = " ", DisplayMember = " " }};
DataTable dtRemarkList = new CODW().ListLookUpEdit("20231_2", "APDK_REMARK");
ApdkRemarkLookUpEdit.SetColumnLookUp(dtRemarkList, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor);
APDK_REMARK.ColumnEdit = ApdkRemarkLookUpEdit;
}
protected override ResultStatus Open()
{
base.Open();
try
{
#region 拉選單設定
//商品別
lupProdType = new RepositoryItemLookUpEdit();
DataTable dtProdType = new CODW().ListLookUpEdit("APDK", "APDK_PROD_TYPE");
lupProdType.SetColumnLookUp(dtProdType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
gcMain.RepositoryItems.Add(lupProdType);
//契約類別
lupProdSubtypeCod = new RepositoryItemLookUpEdit();
DataTable dtProdSubtypeCod = new CODW().ListLookUpEdit("APDK", "APDK_PROD_SUBTYPE");
Extension.SetColumnLookUp(lupProdSubtypeCod, dtProdSubtypeCod, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
gcMain.RepositoryItems.Add(lupProdSubtypeCod);
//商品狀態
lupDataType = new RepositoryItemLookUpEdit();
DataTable dataTypeList = new CODW().ListLookUpEdit("49020", "DATA_TYPE");
Extension.SetColumnLookUp(lupDataType, dataTypeList, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
gcMain.RepositoryItems.Add(lupDataType);
//風險價格係數計算方式
lupCpKind = new RepositoryItemLookUpEdit();
DataTable dtCpKind = new CODW().ListLookUpEdit("49020", "MGT2_CP_KIND");
Extension.SetColumnLookUp(lupCpKind, dtCpKind, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
gcMain.RepositoryItems.Add(lupCpKind);
//國內/國外類別
lupAbroad = new RepositoryItemLookUpEdit();
DataTable dtAbroad = new CODW().ListLookUpEdit("MGT2", "MGT2_ABROAD");
Extension.SetColumnLookUp(lupAbroad, dtAbroad, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
gcMain.RepositoryItems.Add(lupAbroad);
//交易所+商品清單
lupTradekindId = new RepositoryItemLookUpEdit();
DataTable dtTradekindId = new MGT8().ListDataByMGT8_TrimID();
Extension.SetColumnLookUp(lupTradekindId, dtTradekindId, "MGT8_F_ID", "CP_DISPLAY", TextEditStyles.DisableTextEditor, "");
gcMain.RepositoryItems.Add(lupTradekindId);
#endregion
Retrieve();
return(ResultStatus.Success);
}
catch (Exception ex)
{
WriteLog(ex);
return(ResultStatus.Fail);
}
}
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;
}
public W20231(string programID, string programName) : base(programID, programName)
{
InitializeComponent();
this.Text = _ProgramID + "─" + _ProgramName;
GridHelper.SetCommonGrid(gvMain);
PrintableComponent = gcMain;
dao20231 = new D20231();
//統一設定下拉選單TextEditStyles
TextEditStyles textEditStyles = TextEditStyles.DisableTextEditor;
//期貨
//List<LookupItem> futList = new List<LookupItem>(){
// new LookupItem() { ValueMember = " ", DisplayMember = " "},
// new LookupItem() { ValueMember = "F", DisplayMember = "○" }};
DataTable dtFut = new CODW().ListLookUpEdit("20231", "PLS4_FUT");
Pls4FutLookUpEdit.SetColumnLookUp(dtFut, "CODW_ID", "CODW_DESC", textEditStyles, null);
PLS4_FUT.ColumnEdit = Pls4FutLookUpEdit;
//選擇權
//List<LookupItem> optList = new List<LookupItem>(){
// new LookupItem() { ValueMember = " ", DisplayMember = " "},
// new LookupItem() { ValueMember = "O", DisplayMember = "○" }};
DataTable dtOpt = new CODW().ListLookUpEdit("20231", "PLS4_OPT");
Pls4OptLookUpEdit.SetColumnLookUp(dtOpt, "CODW_ID", "CODW_DESC", textEditStyles, null);
PLS4_OPT.ColumnEdit = Pls4OptLookUpEdit;
//商品類別
//List<LookupItem> codeList = new List<LookupItem>(){
// new LookupItem() { ValueMember = "I", DisplayMember = "新增"},
// new LookupItem() { ValueMember = "M", DisplayMember = "小型"},
// new LookupItem() { ValueMember = "N", DisplayMember = " " }};
DataTable dtCode = new CODW().ListLookUpEdit("20231", "PLS4_STATUS_CODE");
Pls4StatusCodeLookUpEdit.SetColumnLookUp(dtCode, "CODW_ID", "CODW_DESC", textEditStyles, null);
PLS4_STATUS_CODE.ColumnEdit = Pls4StatusCodeLookUpEdit;
//上市/上櫃
//Pls4PidLookUpEdit.SetColumnLookUp(new COD().ListByCol("TFXM", "TFXM_PID"), "COD_ID", "COD_DESC", textEditStyles, null);
DataTable dtTFXM = new CODW().ListLookUpEdit("APDK", "UNDERLYING_MARKET");
Pls4PidLookUpEdit.SetColumnLookUp(dtTFXM, "CODW_ID", "CODW_DESC", textEditStyles, null);
PLS4_PID.ColumnEdit = Pls4PidLookUpEdit;
//預設隱藏DataGridView
gcMain.Visible = false;
}
protected override ResultStatus Open()
{
base.Open();
//設定日期和全域變數
txtSDate.DateTimeValue = DateTime.Now;
txtEffectiveSDate.Text = "1901/01/01";
#if DEBUG
txtSDate.EditValue = "2019/02/27";
#endif
ymd = txtSDate.DateTimeValue.ToString("yyyyMMdd");
isAdjType = "3";
//取得table的schema，因為程式開啟會預設插入一筆空資料列
DataTable dtMGD2 = dao40071.d_40073();
gcMain.DataSource = dtMGD2;
#region 拉選單設定
//調整原因下拉選單
//List<LookupItem> causeList = new List<LookupItem>(){
// new LookupItem() { ValueMember = "1", DisplayMember = "季評估"},
// new LookupItem() { ValueMember = "2", DisplayMember = "機動評估"}};
DataTable dtCauseList = new CODW().ListLookUpEdit("40073", "40073_ADJ_RSN");
causeLookUpEdit = new RepositoryItemLookUpEdit();
causeLookUpEdit.SetColumnLookUp(dtCauseList, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
gcMain.RepositoryItems.Add(causeLookUpEdit);
ADJ_RSN_INPUT.ColumnEdit = causeLookUpEdit;
gcDetail.RepositoryItems.Add(causeLookUpEdit);
ADJ_RSN.ColumnEdit = causeLookUpEdit;
//級距下拉選單
//期貨
prodTypeLookUpEdit1 = new RepositoryItemLookUpEdit();
prodTypeLookUpEdit1.SetColumnLookUp(dtFLevel, "MGRT1_LEVEL", "MGRT1_LEVEL_NAME", TextEditStyles.DisableTextEditor, null);
gcMain.RepositoryItems.Add(prodTypeLookUpEdit1);
M_LEVEL_INPUT.ColumnEdit = prodTypeLookUpEdit1;
gcDetail.RepositoryItems.Add(prodTypeLookUpEdit1);
M_CUR_LEVEL.ColumnEdit = prodTypeLookUpEdit1;
//選擇權
prodTypeLookUpEdit2 = new RepositoryItemLookUpEdit();
prodTypeLookUpEdit2.SetColumnLookUp(dtOLevel, "MGRT1_LEVEL", "MGRT1_LEVEL_NAME", TextEditStyles.DisableTextEditor, null);
gcMain.RepositoryItems.Add(prodTypeLookUpEdit2);
gcDetail.RepositoryItems.Add(prodTypeLookUpEdit2);
#endregion
//預設新增一筆設定資料
InsertRow();
return(ResultStatus.Success);
}
protected override ResultStatus Open()
{
try {
base.Open();
#region 處理下拉選單
_RepLookUpEdit_Type = new RepositoryItemLookUpEdit();
//DataTable dtProd_Type = new DataTable();
//dtProd_Type.Columns.Add("ID");
//dtProd_Type.Columns.Add("DESC");
//DataRow ptRow1 = dtProd_Type.NewRow();
//ptRow1["ID"] = "F";
//ptRow1["DESC"] = "期貨";
//dtProd_Type.Rows.Add(ptRow1);
//DataRow ptRow2 = dtProd_Type.NewRow();
//ptRow2["ID"] = "O";
//ptRow2["DESC"] = "選擇權";
//dtProd_Type.Rows.Add(ptRow2);
DataTable dtProd_Type = new CODW().ListLookUpEdit("APDK", "APDK_PROD_TYPE");
Extension.SetColumnLookUp(_RepLookUpEdit_Type, dtProd_Type, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
gcMain.RepositoryItems.Add(_RepLookUpEdit_Type);
PLT1_PROD_TYPE.ColumnEdit = _RepLookUpEdit_Type;
_RepLookUpEdit_SubType = new RepositoryItemLookUpEdit();
//DataTable dtProd_SubType = new DataTable();
//dtProd_SubType.Columns.Add("ID");
//dtProd_SubType.Columns.Add("DESC");
//DataRow pstRow1 = dtProd_SubType.NewRow();
//pstRow1["ID"] = "C";
//pstRow1["DESC"] = "黃金類";
//dtProd_SubType.Rows.Add(pstRow1);
//DataRow pstRow2 = dtProd_SubType.NewRow();
//pstRow2["ID"] = "E";
//pstRow2["DESC"] = "匯率類";
//dtProd_SubType.Rows.Add(pstRow2);
//DataRow pstRow3 = dtProd_SubType.NewRow();
//pstRow3["ID"] = "I";
//pstRow3["DESC"] = "指數類";
//dtProd_SubType.Rows.Add(pstRow3);
DataTable dtProd_SubType = new CODW().ListLookUpEdit("20220", "PLT1_PROD_SUBTYPE");
Extension.SetColumnLookUp(_RepLookUpEdit_SubType, dtProd_SubType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
gcMain.RepositoryItems.Add(_RepLookUpEdit_SubType);
PLT1_PROD_SUBTYPE.ColumnEdit = _RepLookUpEdit_SubType;
#endregion
} catch (Exception ex) {
throw ex;
}
return(ResultStatus.Success);
}
/// <summary>
/// 幣別欄位
/// </summary>
private void ApdkCurrencyType()
{
DataTable dtCurrency = new CODW().ListLookUpEdit("APDK", "APDK_CURRENCY_TYPE");
//ApdkCurrencyTypeLookUpEdit.SetColumnLookUp(new COD().ListByCurrency() , "CURRENCY_TYPE" , "CURRENCY_NAME" , TextEditStyles.DisableTextEditor , null);
foreach (DataRow dr in dtCurrency.Rows)
{
if (dr["CODW_ID"].AsString() == "1")
{
dr["CODW_DESC"] = "新臺幣元";
}
}
ApdkCurrencyTypeLookUpEdit.SetColumnLookUp(dtCurrency, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
APDK_CURRENCY_TYPE.ColumnEdit = ApdkCurrencyTypeLookUpEdit;
}
protected override ResultStatus Open()
{
base.Open();
//設定 營業時間 下拉選單
//List<LookupItem> lstType = new List<LookupItem>(){
// new LookupItem() { ValueMember = "5%", DisplayMember = "13:45 - 16:15"},
// new LookupItem() { ValueMember = "%", DisplayMember = "13:45 - 18:15" },
// new LookupItem() { ValueMember = "7%", DisplayMember = "16:15 - 18:15" }};
DataTable dtType = new CODW().ListLookUpEdit("30770", "30770_DDLB_OSW_GRP");
Extension.SetDataTable(ddlOswGrp, dtType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
return(ResultStatus.Success);
}
protected override ResultStatus AfterOpen()
{
base.AfterOpen();
txtStartDate.EditValue = GlobalInfo.OCF_DATE.Year + "/01/01";
txtEndDate.DateTimeValue = GlobalInfo.OCF_DATE;
//設定 dw_index
//DataTable dwSource = daoCOD.ListByCol(_ProgramID , "PID-IDSTK" , "全部" , "%");
DataTable dwSource = new CODW().ListLookUpEdit("60420", "PID_IDSTK");
Extension.SetDataTable(dw_index, dwSource, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
dw_index.ItemIndex = 0;
return(ResultStatus.Success);
}
public W50010(string programID, string programName) : base(programID, programName)
{
InitializeComponent();
this.Text = _ProgramID + "─" + _ProgramName;
dao50010 = new D50010();
TxtDate.DateTimeValue = GlobalInfo.OCF_DATE;
daoAPDK = new APDK();
//設定下拉選單
Fcm_SNo.SetDataTable(new AMPD().ListByFcmAccNo(), "AMPD_FCM_NO", "CP_DISPLAY", TextEditStyles.DisableTextEditor, "");
Fcm_SNo.EditValue = "";
Fcm_ENo.SetDataTable(new AMPD().ListByFcmAccNo(), "AMPD_FCM_NO", "CP_DISPLAY", TextEditStyles.DisableTextEditor, "");
Fcm_ENo.EditValue = "";
Prod_ct.SetDataTable(daoAPDK.ListParamKey(), "APDK_PARAM_KEY", "APDK_PARAM_KEY", TextEditStyles.DisableTextEditor, null);
Prod_ct.EditValue = " ";
Kind_id_st.SetDataTable(daoAPDK.ListKind2(), "APDK_KIND_ID_STO", "APDK_KIND_ID_STO", TextEditStyles.DisableTextEditor, null);
Kind_id_st.EditValue = " ";
Kind_id_O.SetDataTable(daoAPDK.ListAll3(), "MARKET_CODE", "PDK_KIND_ID", TextEditStyles.DisableTextEditor, null);
Kind_id_O.EditValue = " ";
//排序方式 下拉選單
//List<LookupItem> markret = new List<LookupItem>(){
// new LookupItem() { ValueMember = "O", DisplayMember = "一般"},
// new LookupItem() { ValueMember = "AH", DisplayMember = "盤後" }};
DataTable dtMarket = new CODW().ListLookUpEdit("50010", "50010_MARKET_CODE");
Extension.SetDataTable(MarketTime, dtMarket, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
MarketTime.ItemIndex = 0; // 一般
//List<LookupItem> printSort = new List<LookupItem>(){
// new LookupItem() { ValueMember = "M", DisplayMember = "造市者"},
// new LookupItem() { ValueMember = "P", DisplayMember = "商品" }};
DataTable dtPrintSort = new CODW().ListLookUpEdit("50010", "50010_PRINT_SORT");
Extension.SetDataTable(PrintSort, dtPrintSort, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
PrintSort.ItemIndex = 0; // 一般 // 造市者
//加入事件
MarketTime.EditValueChanged += MarketTime_EditValueChanged;
Fcm_SNo.EditValueChanged += EditValueChanged;
Fcm_ENo.EditValueChanged += EditValueChanged;
Prod_ct.EditValueChanged += EditValueChanged;
Kind_id_st.EditValueChanged += EditValueChanged;
Kind_id_O.EditValueChanged += EditValueChanged;
PrintSort.EditValueChanged += EditValueChanged;
Txt_prod_sort.EditValueChanged += EditValueChanged;
TxtDate.EditValueChanged += EditValueChanged;
}
protected override ResultStatus Open()
{
base.Open();
txtSDate.DateTimeValue = GlobalInfo.OCF_DATE;
//盤別下拉選單
//List<LookupItem> lstType = new List<LookupItem>(){
// new LookupItem() { ValueMember = "1", DisplayMember = "16:15收盤"},
// new LookupItem() { ValueMember = "2", DisplayMember = "全部收盤" }};
DataTable lstType = new CODW().ListLookUpEdit("30055", "30055_DDLB_GRP");
Extension.SetDataTable(ddlType, lstType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
ddlType.ItemIndex = 1;
return(ResultStatus.Success);
}
protected override ResultStatus Open()
{
base.Open();
nullYmd = null;
//日期
txtTradeDate.DateTimeValue = DateTime.Now;
txtDate1.Text = "1900/01/01";
txtDate2.Text = "1900/01/01";
//觀察/調整 RadioGroup
RadioGroupItem item1 = new RadioGroupItem();
item1.Description = "";
item1.Value = " ";
RadioGroupItem item2 = new RadioGroupItem();
item2.Description = "";
item2.Value = "Y";
RepositoryItemRadioGroup repositoryItemRadioGroup = new RepositoryItemRadioGroup();
repositoryItemRadioGroup.Items.Add(item1);
repositoryItemRadioGroup.Items.Add(item2);
repositoryItemRadioGroup.Columns = 2;
//repositoryItemRadioGroup.BestFitWidth = 40;
repositoryItemRadioGroup.GlyphAlignment = HorzAlignment.Center;
SP2_ADJ_CODE.ColumnEdit = repositoryItemRadioGroup;
SP2_ADJ_CODE.ColumnEdit.Appearance.TextOptions.HAlignment = HorzAlignment.Center;
//設定依條件選擇狀態的下拉選單
//List<LookupItem> adjustType = new List<LookupItem>(){
// new LookupItem() { ValueMember = "none", DisplayMember = "全取消"},
// new LookupItem() { ValueMember = "indes", DisplayMember = "全選指數類" },
// new LookupItem() { ValueMember = "all", DisplayMember = "全選"},
// new LookupItem() { ValueMember = "StcEtc", DisplayMember = "全選STC,ETC" },
// new LookupItem() { ValueMember = "1", DisplayMember = "全選Group1"},
// new LookupItem() { ValueMember = "2", DisplayMember = "全選Group2" }};
DataTable dtAdjustType = new CODW().ListLookUpEdit("40080", "DDL_ADJUST");
Extension.SetDataTable(ddlAdjust, dtAdjustType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
ddlAdjust.ItemIndex = 0; // none
return(ResultStatus.Success);
}
protected override ResultStatus Open()
{
base.Open();
try {
txtStartYMD.DateTimeValue = GlobalInfo.OCF_DATE.AddDays(-GlobalInfo.OCF_DATE.Day + 1); //取得當月第1天
txtEndYMD.DateTimeValue = GlobalInfo.OCF_DATE;
DataTable dtProd = new CODW().ListLookUpEdit("30593", "KIND_ID");
Extension.SetDataTable(ddlProd, dtProd, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
ddlProd.ItemIndex = 0;
return(ResultStatus.Success);
} catch (Exception ex) {
WriteLog(ex);
return(ResultStatus.Fail);
}
}
