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