/// <summary> /// 產生CAM08報表 /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataTable CAM08_1(ArrayList ParameterList) { CAMModel.ReportMonthSumSummary BCO = new CAMModel.ReportMonthSumSummary(ConntionDB); DataTable Dt; if (ParameterList[10].ToString() == "0")//彙總 { if (ParameterList[11].ToString() == "0")//金額(牌價) { Dt = BCO.GetCAM08R01Data(ParameterList); } else if (ParameterList[11].ToString() == "2")//金額(成本) { Dt = BCO.GetCAM08R13Data(ParameterList); } else//數量 { Dt = BCO.GetCAM08R07Data(ParameterList); } } else//明細 { if (ParameterList[11].ToString() == "0")//金額(牌價) { Dt = BCO.GetCAM08R02Data(ParameterList); } else if (ParameterList[11].ToString() == "2")//金額(成本) { Dt = BCO.GetCAM08R14Data(ParameterList); } else//數量 { Dt = BCO.GetCAM08R08Data(ParameterList); } } if (Dt.Rows.Count > 0) { return Dt; } else { throw new Exception("查無資料!!"); } }
/// <summary> /// 產生CAM08報表 /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataTable CAM08_2(ArrayList ParameterList) { CAMModel.ReportMonthSumSummary BCO = new CAMModel.ReportMonthSumSummary(ConntionDB); DataTable Dt; if (ParameterList[12].ToString() == "0")//彙總 { if (ParameterList[13].ToString() == "0")//金額 { Dt = BCO.GetCAM08R06Data(ParameterList); } else//數量 { Dt = BCO.GetCAM08R12Data(ParameterList); } } else//明細 { if (ParameterList[13].ToString() == "0")//金額 { Dt = BCO.GetCAM08R05Data(ParameterList); } else//數量 { Dt = BCO.GetCAM08R11Data(ParameterList); } } if (Dt.Rows.Count > 0) { return Dt; } else { throw new Exception("查無資料!!"); } }
protected void but_Print1_Click(object sender, EventArgs e) { try { string strRptName = ""; DataTable dt = new DataTable(); BCO.ReportMonthSumSummary bco = new BCO.ReportMonthSumSummary(ConntionDB); ParameterList.Clear(); if (((Button)sender).CommandName == "SALE_PDF" || ((Button)sender).CommandName == "SALE_EXEC") { ParameterList.Add(slp_Z_O.Text); ParameterList.Add(slp_SAL_ID.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_STORE.Text); ParameterList.Add(slp_ROOTNO.Text); ParameterList.Add(slp_BUS_DATE.StartDate); ParameterList.Add(slp_BUS_DATE.EndDate); if (rdoREPORT_KIND1_1.SelectedValue == "0")//彙總 { if (rdoREPORT_KIND2_1.SelectedValue == "0")//金額 { dt = bco.GetCAM08R01Data(ParameterList); strRptName = "01"; } else//數量 { dt = bco.GetCAM08R07Data(ParameterList); strRptName = "07"; } } else//明細 { if (rdoREPORT_KIND2_1.SelectedValue == "0")//金額 { dt = bco.GetCAM08R02Data(ParameterList); strRptName = "02"; } else//數量 { dt = bco.GetCAM08R08Data(ParameterList); strRptName = "08"; } } } else { ParameterList.Add(slp_Z_O1.Text); ParameterList.Add(slp_SAL_ID1.Text); ParameterList.Add(slp_GROUP_NO_S1.Text); ParameterList.Add(slp_GROUP_NO_E1.Text); ParameterList.Add(txtPAY_RFNO1.Text); ParameterList.Add(txtRFNO1.Text); ParameterList.Add(slp_STORE1.Text); ParameterList.Add(slp_ROOTNO1.Text); ParameterList.Add(slp_BUS_YM_S.Text); ParameterList.Add(slp_BUS_YM_E.Text); ParameterList.Add(slp_ROLE.Text); ParameterList.Add(rdoAC_CLOSE.SelectedValue); if (rdoREPORT_KIND1_2.SelectedValue == "0")//彙總 { if (rdoREPORT_KIND2_2.SelectedValue == "0")//金額 { dt = bco.GetCAM08R06Data(ParameterList); strRptName = "06"; } else//數量 { dt = bco.GetCAM08R12Data(ParameterList); strRptName = "12"; } } else//明細 { if (rdoREPORT_KIND2_2.SelectedValue == "0")//金額 { dt = bco.GetCAM08R05Data(ParameterList); strRptName = "05"; } else//數量 { dt = bco.GetCAM08R11Data(ParameterList); strRptName = "11"; } } } if (dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; return; } else { if (((Button)sender).CommandName == "SALE_PDF" || ((Button)sender).CommandName == "SETTLE_PDF") { ShowReport(dt, strRptName, "PDF"); } else { ShowReport(dt, strRptName, "XLS"); } } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message.Split(Environment.NewLine.Replace(Environment.NewLine, "~").ToCharArray())[0]; //直接取第一個 } finally { Finally_Function(); } }