/// <summary> /// TRN07_1報表(匯出鈕) /// </summary> /// <param name="ParameterList">變數清單</param> /// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param> /// <param name="EOT">匯出Excel方式</param> /// <returns>回傳查詢結果</returns> public DataTable TRN07_1(ArrayList ParameterList, string ReportOutputFormat, ref ReportList.ExcelOtherType EOT ) { TRNModel.PrintTransAndDriver BCO = new PIC.VDS2G.LGT.TRN.PrintTransAndDriver(ConntionDB); DataTable Dt = BCO.PrintTrans(ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } EOT = ReportList.ExcelOtherType.None; return Dt; }
/// <summary> /// 抓取資料 /// </summary> public DataTable queryData() { BCO.PrintTransAndDriver bco = new BCO.PrintTransAndDriver(ConntionDB); DataTable Dt = null; ParameterList.Clear(); ParameterList.Add(SLP_SLPDate.Text.Trim()); ParameterList.Add(SLP_Trans_No_S.Text.Trim()); ParameterList.Add(SLP_Trans_No_E.Text.Trim()); ParameterList.Add(SLP_Trans_Vendor_S.Text.Trim()); ParameterList.Add(SLP_Trans_Vendor_E.Text.Trim()); ParameterList.Add(SLP_Route_S.Text.Trim()); ParameterList.Add(SLP_Route_E.Text.Trim()); ParameterList.Add(SLP_StoreChain_S.Text.Trim()); ParameterList.Add(SLP_StoreChain_E.Text.Trim()); switch (rblPrintType.SelectedValue) { case "1": Dt = bco.PrintTrans(ParameterList); break; case "2": Dt = bco.PrintDriver(ParameterList); break; default: break; } return Dt; }