public WP0050(string programID, string programName) : base(programID, programName)
{
try {
InitializeComponent();
daoP00xx = new DP00xx();
this.Text = _ProgramID + "─" + _ProgramName;
gvMain.OptionsBehavior.Editable = false;
txtStartDate.Text = "%";
txtEndDate.Text = "%";
} catch (Exception ex) {
WriteLog(ex);
}
}
public WP0030(string programID, string programName) : base(programID, programName)
{
try {
InitializeComponent();
daoP00xx = new DP00xx();
this.Text = _ProgramID + "─" + _ProgramName;
gvMain.OptionsBehavior.Editable = false;
txtStartDate.Text = "%";
txtEndDate.Text = "%";
//下拉選單(系統別)
//List<LookupItem> ddlbSystem = new List<LookupItem>(){
// new LookupItem() { ValueMember = "W", DisplayMember = "W：網際網路"},
// new LookupItem() { ValueMember = "V", DisplayMember = "V：語音查詢" }};
DataTable dtType = new CODW().ListLookUpEdit("P0030", "P0030_DDLB_1");
Extension.SetDataTable(ddlbType, dtType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
ddlbType.EditValue = "W";
//下拉選單(類別)
List <LookupItem> ddlbCatagroy = new List <LookupItem>()
{
new LookupItem()
{
ValueMember = "I", DisplayMember = "I：依交易人查明細"
},
new LookupItem()
{
ValueMember = "F", DisplayMember = "F：依期貨商合計"
}
};
dtType = new CODW().ListLookUpEdit("P0030", "P0030_DDLB_3");
//Extension.SetDataTable(ddlbCate, ddlbCatagroy, "ValueMember", "DisplayMember", TextEditStyles.DisableTextEditor, null);
Extension.SetDataTable(ddlbCate, dtType, "CODW_ID", "CODW_DESC", TextEditStyles.DisableTextEditor, null);
ddlbCate.EditValue = "I";
} catch (Exception ex) {
WriteLog(ex);
}
}
public WP0020(string programID, string programName) : base(programID, programName)
{
try {
InitializeComponent();
//daoP0020 = new DP0020();
daoP00xx = new DP00xx();
this.Text = _ProgramID + "─" + _ProgramName;
gvMain.OptionsBehavior.Editable = false;
txtStartDate.Text = "%";
txtEndDate.Text = "%";
//下拉選單(系統別)
List <LookupItem> ddlbSystem = new List <LookupItem>()
{
new LookupItem()
{
ValueMember = "W", DisplayMember = "W：網際網路"
},
new LookupItem()
{
ValueMember = "V", DisplayMember = "V：語音查詢"
}
};
Extension.SetDataTable(ddlbType, ddlbSystem, "ValueMember", "DisplayMember", TextEditStyles.DisableTextEditor, null);
ddlbType.EditValue = "W";
//下拉選單(審查結果)
List <LookupItem> ddlbApplyResult = new List <LookupItem>()
{
new LookupItem()
{
ValueMember = "S", DisplayMember = "S：審核成功"
},
new LookupItem()
{
ValueMember = "F", DisplayMember = "F：審核失敗"
},
new LookupItem()
{
ValueMember = "A", DisplayMember = "A：全部"
}
};
Extension.SetDataTable(ddlbItem, ddlbApplyResult, "ValueMember", "DisplayMember", TextEditStyles.DisableTextEditor, null);
ddlbItem.EditValue = "S";
//下拉選單(類別)
List <LookupItem> ddlbCatagroy = new List <LookupItem>()
{
new LookupItem()
{
ValueMember = "I", DisplayMember = "I：依交易人查明細"
},
new LookupItem()
{
ValueMember = "F", DisplayMember = "F：依期貨商合計"
}
};
Extension.SetDataTable(ddlbCate, ddlbCatagroy, "ValueMember", "DisplayMember", TextEditStyles.DisableTextEditor, null);
ddlbCate.EditValue = "I";
} catch (Exception ex) {
WriteLog(ex);
}
}
/// <summary>
/// 按下[讀取/預覽]按鈕時,去資料庫撈資料
/// </summary>
/// <returns></returns>
protected override ResultStatus Retrieve()
{
base.Retrieve();
try {
DP00xx daoP00xx = new DP00xx();
DataTable dt = new DataTable();
DataTable dtTXFP = new DataTable();
dtTXFP = new TXFP().ListDataByKey("POS");
IGridDataP00xx gridData = daoP00xx.CreateGridData(daoP00xx.GetType(), GetType(), MethodBase.GetCurrentMethod().Name);
QP00xx qP00xx = new QP00xx(txtFcmNo.Text, txtAccNo.Text, dtTXFP);
dt = gridData.GetData(qP00xx);
// dt = new DP0040().SP_QUERY_USER_STATUS(txtFcmNo.Text , txtAccNo.Text , "POS" , dtTXFP);
//將datatable的Title換掉
dt.Columns[0].ColumnName = "FCM_NAME";
dt.Columns[1].ColumnName = "FCM_NO";
dt.Columns[2].ColumnName = "SEQ_ACC_NO";
dt.Columns[3].ColumnName = "SYS_TYPE";
dt.Columns[4].ColumnName = "W_STATUS";
dt.Columns[5].ColumnName = "APPLY_DATE";
dt.Columns[6].ColumnName = "LOCK_CNT";
//dddw_pos_sys_id
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][3].AsString() == "W")
{
dt.Rows[i][3] = "網際網路";
}
else if (dt.Rows[i][3].AsString() == "V")
{
dt.Rows[i][3] = "電話語音";
}
}
gcMain.DataSource = null;
gvMain.GroupSummary.Clear();
gvMain.Columns.Clear();//清除grid
gcMain.DataSource = dt;
gcMain.Visible = true;
gcMain.Focus();
//David 將第一筆以外的三個欄位都設為空值(仿PB產出結果)
for (int i = 1; i <= gvMain.RowCount; i++)
{
gvMain.SetRowCellValue(i, "FCM_NAME", "");
gvMain.SetRowCellValue(i, "FCM_NO", "");
gvMain.SetRowCellValue(i, "SEQ_ACC_NO", "");
}
//可測資料
//S653010 0014735 (W V)
//F002000 0875493
//F002000 1003688
//F002000 1121612
//F002000 9101809
} catch (Exception ex) {
WriteLog(ex);
return(ResultStatus.Fail);
}
return(ResultStatus.Success);
}
