public W51030(string programID, string programName) : base(programID, programName)
{
InitializeComponent();
dao51030 = new D51030();
//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 = new CODW().ListLookUpEdit("51030", "51030_MARKET_CODE");
MARKET_CODE_LookUpEdit.SetColumnLookUp(mk_code, "CODW_ID", "CODW_DESC");
MMF_MARKET_CODE.ColumnEdit = MARKET_CODE_LookUpEdit;
//期貨/選擇權
//dic = new Dictionary<string, string>() { { "F", "F" }, { "O", "O" } };
//DataTable mmfType = SetcolItem(dic);
PROD_TYPE_LookUpEdit = new RepositoryItemLookUpEdit();
DataTable mmfType = new CODW().ListLookUpEdit("51030", "51030_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;*/
//報價規定判斷方式
//daoCOD = new COD();
//dic = new Dictionary<string, string>();
//foreach (DataRow dr in daoCOD.ListByCol("MMF", CP_KIND).Rows) {
// string codid = dr["COD_ID"].AsString();
// if (string.IsNullOrEmpty(codid)) {
// continue;
// }
// dic.Add(codid, string.Format("({0}){1}", codid, dr["COD_DESC"].AsString()));
//}
//DataTable mmfKIND = SetcolItem(dic);
CP_KIND_LookUpEdit = new RepositoryItemLookUpEdit();
DataTable mmfKIND = new CODW().ListLookUpEdit3("51030", "51030_CP_KIND");
CP_KIND_LookUpEdit.SetColumnLookUp(mmfKIND, "CODW_ID", "CP_DISPLAY");
MMF_CP_KIND.ColumnEdit = CP_KIND_LookUpEdit;
}
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();
//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 W500xx(string programID, string programName) : base(programID, programName)
{
InitializeComponent();
this.Text = _ProgramID + "─" + _ProgramName;
daoABRK = new ABRK();
daoAPDK = new APDK();
_D500Xx = new D500xx();
}
public W55030(string programID, string programName) : base(programID, programName)
{
InitializeComponent();
dao55030 = new D55030();
dao55031 = new D55031();
daoAPDK = new APDK();
this.Text = _ProgramID + "─" + _ProgramName;
txtMonth.DateTimeValue = GlobalInfo.OCF_DATE;
}
/// <summary>
/// 列印順序
/// </summary>
//public string printSort {
// get {
// return PrintSort.EditValue.AsString();
// }
//}
/// <summary>
/// 盤別
/// </summary>
//public string matketTime {
// get {
// string str = MarketTime.EditValue.AsString();
// return MarketTime.EditValue.AsString();
// }
//}
#endregion
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 = "商品" }};
//RadioGroup
radioMarketTime1.Checked = true;
radioPrintSort1.Checked = true;
//加入事件
//MarketTime.EditValueChanged += MarketTime_EditValueChanged;
radioMarketTime1.Click += MarketTime_EditValueChanged;
radioMarketTime2.Click += 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;
radioPrintSort1.Click += EditValueChanged;
radioPrintSort2.Click += EditValueChanged;
Txt_prod_sort.EditValueChanged += EditValueChanged;
TxtDate.EditValueChanged += EditValueChanged;
DoMarketTimeDifferentSeting(); //add by tom
}
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 W50120(string programID, string programName) : base(programID, programName)
{
InitializeComponent();
this.Text = _ProgramID + "─" + _ProgramName;
GridHelper.SetCommonGrid(gvMain);
txtMonth.DateTimeValue = GlobalInfo.OCF_DATE;
txtMonth.Focus();
txtMonth.ImeMode = ImeMode.Disable;
dao50120 = new D50120();
daoABRK = new ABRK();
daoAPDK = new APDK();
dtInsertUse = daoAPDK.ListAll2();
dtInsertUse.Columns.Add("TEMP_PROD_TYPE");
_IsPreventFlowPrint = false;
}
/// <summary>
/// 視窗啟動時,設定一些UI元件初始值
/// </summary>
/// <returns></returns>
protected override ResultStatus Open()
{
base.Open();
if (!FlagAdmin)
{
labProdType.Visible = false;
cbxProdType.Visible = false;
}
else
{
labProdType.Visible = true;
cbxProdType.Visible = true;
}
//1.設定初始年月yyyy/MM
txtStartMonth.DateTimeValue = GlobalInfo.OCF_DATE;
txtStartMonth.EnterMoveNextControl = true;
txtStartMonth.Focus();
txtEndMonth.DateTimeValue = GlobalInfo.OCF_DATE;
txtEndMonth.EnterMoveNextControl = true;
//2.設定下拉選單
//2.1先讀取db
DataTable dt = new ABRK().ListAll2();//第一行空白+ABRK_NO/ABRK_NAME/cp_display
cbxFcmStartNo.SetDataTable(dt, "ABRK_NO", "CP_DISPLAY", TextEditStyles.DisableTextEditor, " ");
cbxFcmEndNo.SetDataTable(dt, "ABRK_NO", "CP_DISPLAY", TextEditStyles.DisableTextEditor, " ");
rgpType.SelectedIndex = 0; //直接預設為第一個選項
rgpType_EditValueChanged(rgpType, null); //觸發事件
rgpType.EnterMoveNextControl = true;
DataTable dtProdType = new APDK().dddw_pdk_kind_id();//前面[全部/期貨/選擇權]+apdk_prod_type/pdk_kind_id/cp_display
cbxProdType.SetDataTable(dtProdType, "PDK_KIND_ID", textEditStyles: TextEditStyles.DisableTextEditor);
cbxProdType.ItemIndex = 0;//直接預設為[全部]
return(ResultStatus.Success);
}
protected override ResultStatus Open()
{
base.Open();
//1. 設定時間初始值
txtStartDate.DateTimeValue = GlobalInfo.OCF_DATE;
txtEndDate.DateTimeValue = GlobalInfo.OCF_DATE;
//2. 設定下拉選單
//造市者
DataTable dtFcm = new ABRK().ListFcmNo();//第一行空白+ampd_fcm_no/abrk_abrk_name/cp_display
dw_sbrkno.SetDataTable(dtFcm, "AMPD_FCM_NO", "CP_DISPLAY", TextEditStyles.DisableTextEditor, " ");
//商品
DataTable dtProd = new APDK().ListKind2();//前面空一行+APDK_KIND_ID_STO/MARKET_CODE
dw_prod_kd.SetDataTable(dtProd, "APDK_KIND_ID_STO", "APDK_KIND_ID_STO", TextEditStyles.DisableTextEditor, " ");
gbItem_SelectedIndexChanged(gbItem, null);
return(ResultStatus.Success);
}
protected override ResultStatus Open()
{
base.Open();
try {
//1.設定初始年月yyyy/MM/dd
txtStartDate.DateTimeValue = GlobalInfo.OCF_DATE;
txtStartDate.EnterMoveNextControl = true;
txtStartDate.Focus();
txtEndDate.DateTimeValue = GlobalInfo.OCF_DATE;
txtEndDate.EnterMoveNextControl = true;
//2. 設定dropdownlist(商品)
DataTable dtKindId = new APDK().ListParamKeyAndProd();
dwKindId.SetDataTable(dtKindId, "APDK_PARAM_KEY", "APDK_PARAM_KEY", TextEditStyles.DisableTextEditor, "");
dwKindId.ItemIndex = 0;
return(ResultStatus.Success);
} catch (Exception ex) {
WriteLog(ex);
return(ResultStatus.Fail);
}
}
protected override ResultStatus Open()
{
base.Open();
//1. 設定時間初始值
txtStartDate.DateTimeValue = GlobalInfo.OCF_DATE;
txtEndDate.DateTimeValue = GlobalInfo.OCF_DATE;
txtStartDate.ImeMode = ImeMode.Disable;
txtEndDate.ImeMode = ImeMode.Disable;
txtStartTime.EditValue = "08:45";
txtStartTime.ImeMode = ImeMode.Disable;
txtEndTime.EditValue = "13:45";
txtEndTime.ImeMode = ImeMode.Disable;
//2. 設定下拉選單
//造市者
DataTable dtFcmAcc = new ABRK().ListFcmAccNo();//第一行空白+ abrk_abrk_name/cp_display
dwBrkno.SetDataTable(dtFcmAcc, "AMPD_FCM_NO", "CP_DISPLAY", TextEditStyles.DisableTextEditor, "");
//商品
DataTable dtProd = new APDK().ListAll3();//第一行空白+ abrk_abrk_name/cp_display
dwProd.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;
//檔內外檔數
DataTable dtOI = new CODW().ListLookUpEdit("50050", "DDLB_2");
ddlb_2.SetDataTable(dtOI, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, "");
return(ResultStatus.Success);
}
