protected void but_Print_Click(object sender, EventArgs e) { try { ParameterList.Clear(); ParameterList.Add(slp_ACCT_MONTH_S.Text); ParameterList.Add(slp_ACCT_MONTH_E.Text); ParameterList.Add(slp_GROUP_NO_S.Text); ParameterList.Add(slp_GROUP_NO_E.Text); ParameterList.Add(txtPAY_RFNO.Text); ParameterList.Add(txtRFNO.Text); ParameterList.Add(slp_PROFIT_CENTER_S.Text); ParameterList.Add(slp_PROFIT_CENTER_E.Text); ParameterList.Add(slp_STORE.Text); ParameterList.Add(slp_ROOT_NO.Text); ParameterList.Add(slp_TAX_TYPE.Text); DataTable dt = new DataTable(); ReportChainAcctDiff bco = new ReportChainAcctDiff(ConntionDB); if (this.rdoRPT_TYPE.SelectedIndex == 1) { dt = bco.GetCAM30R01Data(ParameterList); } else { dt = bco.GetCAM30R02Data(ParameterList); } if (dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; return; } else { ShowReport(dt, ((Button)sender).CommandName); } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } finally { Finally_Function(); } }
protected void but_Print2_Click(object sender, EventArgs e) { try { if (slpTAB3_CloseYM_E.Text == "") slpTAB3_CloseYM_E.Text = slpTAB3_CloseYM_B.Text; if (slpTAB3_PayDate.EndDate == "") slpTAB3_PayDate.EndDate = slpTAB3_PayDate.StartDate; if (slpTAB3_SignDate.EndDate == "") slpTAB3_SignDate.EndDate = slpTAB3_SignDate.StartDate; if (slpTAB3_StoreGroup_E.Text == "") slpTAB3_StoreGroup_E.Text = slpTAB3_StoreGroup_B.Text; if (slpTAB3_CHAN_NO_E.Text == "") slpTAB3_CHAN_NO_E.Text = slpTAB3_CHAN_NO_B.Text; if (slpTAB3_STORE_E.Text == "") slpTAB3_STORE_E.Text = slpTAB3_STORE_B.Text; if (txtTAB3_RFNO_E.Text == "") txtTAB3_RFNO_E.Text = txtTAB3_RFNO_B.Text; if (slpTAB3_ITEM_E.Text == "") slpTAB3_ITEM_E.Text = slpTAB3_ITEM_B.Text; if (txtTAB3_PERIOD_E.Text == "") txtTAB3_PERIOD_E.Text = txtTAB3_PERIOD_B.Text; if ((slpTAB3_CloseYM_B.Text == "") && (slpTAB3_PayDate.StartDate == "") && (slpTAB3_SignDate.StartDate == "")) { this.ErrorMsgLabel.Text = "結帳年月/入帳日期/簽收日期至少要輸入一個條件"; return; } string V_CLOSE_MONTH_S = slpTAB3_CloseYM_B.Text; string V_CLOSE_MONTH_E = slpTAB3_CloseYM_E.Text; string D_PAY_DATE_S = slpTAB3_PayDate.StartDate; string D_PAY_DATE_E = slpTAB3_PayDate.EndDate; string D_SIGN_DATE_S = slpTAB3_SignDate.StartDate; string D_SIGN_DATE_E = slpTAB3_SignDate.EndDate; string V_GROUP_NO_S = slpTAB3_StoreGroup_B.Text; string V_GROUP_NO_E = slpTAB3_StoreGroup_E.Text; string V_CHAN_NO_S = slpTAB3_CHAN_NO_B.Text; string V_CHAN_NO_E = slpTAB3_CHAN_NO_E.Text; string V_STORE_S = slpTAB3_STORE_B.Text; string V_STORE_E = slpTAB3_STORE_E.Text; string V_PAY_RFNO_S = txtTAB3_RFNO_B.Text.Trim(); string V_PAY_RFNO_E = txtTAB3_RFNO_E.Text.Trim(); string V_ROOT_NO = rbtTAB3_Root.SelectedValue; string V_STAKIND = string.Empty; if (chkTAB3_STAKIND.Items[0].Selected == true) V_STAKIND = "1"; else V_STAKIND = "0"; if (chkTAB3_STAKIND.Items[1].Selected == true) V_STAKIND += "1"; else V_STAKIND += "0"; if (chkTAB3_STAKIND.Items[2].Selected == true) V_STAKIND += "1"; else V_STAKIND += "0"; if (chkTAB3_STAKIND.Items[3].Selected == true) V_STAKIND += "1"; else V_STAKIND += "0"; if(V_STAKIND=="0000") { this.ErrorMsgLabel.Text = "單別至少要勾選一種類型"; return; } string V_TAX_TYPE = rbtTAB3_TAX_TYPE.SelectedValue; string V_ITEM_S = slpTAB3_ITEM_B.Text; string V_ITEM_E = slpTAB3_ITEM_E.Text; string V_PERIOD_S = txtTAB3_PERIOD_B.Text; string V_PERIOD_E = txtTAB3_PERIOD_E.Text; string V_RPT_DATA = rbtTAB3_RPT_DATA.SelectedValue; DataTable dtResult = new DataTable(); ReportChainAcctDiff bco = new ReportChainAcctDiff(ConntionDB); //0.V_CLOSE_MONTH_S VDS_CAM_PAY_ITEM.CLOSE_MONTH%TYPE, --結帳年月起 //1.V_CLOSE_MONTH_E VDS_CAM_PAY_ITEM.CLOSE_MONTH%TYPE, --結帳年月迄 //2.D_PAY_DATE_S DATE, --入帳日起 //3.D_PAY_DATE_E DATE, --入帳日迄 //4.D_SIGN_DATE_S DATE, --簽收日起 //5.D_SIGN_DATE_E DATE, --簽收日迄 //6.V_GROUP_NO_S VDS_STM_STOREGROUP.CODE%TYPE, --店群起 //7.V_GROUP_NO_E VDS_STM_STOREGROUP.CODE%TYPE, --店群迄 //8.V_CHAN_NO_S VDS_CAM_PAY_ITEM.CHAN_NO%TYPE, --通路起 //9.V_CHAN_NO_E VDS_CAM_PAY_ITEM.CHAN_NO%TYPE, --通路迄 //10.V_STORE_S VDS_CAM_PAY_ITEM.STORE%TYPE, --店號起 //11.V_STORE_E VDS_CAM_PAY_ITEM.STORE%TYPE, --店號迄 //12.V_PAY_RFNO_S VDS_STM_ACCOUNT_PROPERTY.PAY_RFNO%TYPE, --結帳統編起 //13.V_PAY_RFNO_E VDS_STM_ACCOUNT_PROPERTY.PAY_RFNO%TYPE, --結帳統編迄 //14.V_ROOT_NO VDS_CAM_PAY_ITEM.ROOT_NO%TYPE, --群分類 (1:雜誌 2:圖書) //15.V_STAKIND VARCHAR2, --來源區分 (1:進貨,2:退貨,3:補帳,4:調撥) //16.V_TAX_TYPE VDS_CAM_PAY_ITEM.TAX_TYPE%TYPE, --稅別(0:應稅 1:免稅) //17.V_ITEM_S VDS_CAM_PAY_ITEM.ITEM%TYPE, --品號起 //18.V_ITEM_E VDS_CAM_PAY_ITEM.ITEM%TYPE, --品號迄 //19.V_PERIOD_S VDS_CAM_PAY_ITEM.PERIOD%TYPE, --期別起 //20.V_PERIOD_E VDS_CAM_PAY_ITEM.PERIOD%TYPE, --期別迄 //21.V_RPT_DATA VARCHAR2, --報表資料 (1:取全部,0:只有差異才取) ParameterList.Clear(); ParameterList.Add(V_CLOSE_MONTH_S); ParameterList.Add(V_CLOSE_MONTH_E); ParameterList.Add(D_PAY_DATE_S); ParameterList.Add(D_PAY_DATE_E); ParameterList.Add(D_SIGN_DATE_S); ParameterList.Add(D_SIGN_DATE_E); ParameterList.Add(V_GROUP_NO_S); ParameterList.Add(V_GROUP_NO_E); ParameterList.Add(V_CHAN_NO_S); ParameterList.Add(V_CHAN_NO_E); ParameterList.Add(V_STORE_S); ParameterList.Add(V_STORE_E); ParameterList.Add(V_PAY_RFNO_S); ParameterList.Add(V_PAY_RFNO_E); ParameterList.Add(V_ROOT_NO); ParameterList.Add(V_STAKIND); ParameterList.Add(V_TAX_TYPE); ParameterList.Add(V_ITEM_S); ParameterList.Add(V_ITEM_E); ParameterList.Add(V_PERIOD_S); ParameterList.Add(V_PERIOD_E); ParameterList.Add(V_RPT_DATA); if (this.rdoRPT_TYPE.SelectedValue == "0") { dtResult = bco.GetCAM30R08Data(ParameterList); } if (dtResult.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; return; } else { ShowReport2(dtResult, ((Button)sender).CommandName); } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } finally { Finally_Function(); } }
protected void but_Print1_Click(object sender, EventArgs e) { try { if (slp_BUS_DATE.StartDate == "" && slp_BUS_DATE.EndDate == "" && SLP_PAY_MONTH_S.Text == "" && SLP_PAY_MONTH_E.Text == "") { this.ErrorMsgLabel.Text = "【銷貨日期】與【PAY結帳年月】請擇一輸入"; return; } if (slp_BUS_DATE.StartDate != "" && slp_BUS_DATE.EndDate == "") { this.ErrorMsgLabel.Text = "銷貨日期_起 如有輸入 迄 也要有"; return; } if (slp_BUS_DATE.StartDate == "" && slp_BUS_DATE.EndDate != "") { this.ErrorMsgLabel.Text = "銷貨日期_迄 如有輸入 起 也要有"; return; } if (SLP_PAY_MONTH_S.Text != "" && SLP_PAY_MONTH_E.Text == "") { this.ErrorMsgLabel.Text = "PAY 結帳年月_起 如有輸入 迄 也要有"; return; } if (SLP_PAY_MONTH_S.Text == "" && SLP_PAY_MONTH_E.Text != "") { this.ErrorMsgLabel.Text = "PAY 結帳年月_迄 如有輸入 起 也要有"; return; } CAMCommon bco1 = new CAMCommon(); ParameterList.Clear(); ParameterList.Add(bco1.GetValueSetParameter(slp_BUS_DATE.StartDate, "date", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_BUS_DATE.EndDate, "date", false)); ParameterList.Add(bco1.GetValueSetParameter(SLP_PAY_MONTH_S.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(SLP_PAY_MONTH_E.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_BUS_YM.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_GROUP_NO_S1.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_GROUP_NO_E1.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(slp_STORE1.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(txtCHAN_SOURCE_NO.Text, "string", false)); ParameterList.Add(bco1.GetValueSetParameter(chkSTAKind.Items[0].Selected && chkSTAKind.Items[1].Selected ? "0" : (chkSTAKind.Items[0].Selected ? "1" : chkSTAKind.Items[1].Selected ? "2" : "3"), "string", false)); ParameterList.Add(bco1.GetValueSetParameter(rdoRPT_DATA.SelectedValue, "string", false)); DataTable dt = new DataTable(); ReportChainAcctDiff bco = new ReportChainAcctDiff(ConntionDB); if (rdoRPT_TYPE1.SelectedIndex == 0) { dt = bco.GetCAM30R06Data(ParameterList); } else if (rdoRPT_TYPE1.SelectedIndex == 1) { dt = bco.GetCAM30R07Data(ParameterList); } else if (rdoRPT_TYPE1.SelectedIndex == 2) { dt = bco.GetCAM30R05Data(ParameterList); } else if (rdoRPT_TYPE1.SelectedIndex == 3) { dt = bco.GetCAM30R09Data(ParameterList); } else { this.ErrorMsgLabel.Text = "X"; return; } if (dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; return; } else { ShowReport1(dt, ((Button)sender).CommandName); } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } finally { Finally_Function(); } }