/// <summary> /// VGR05報表 /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataTable VGR05_1(ArrayList ParameterList, string ReportOutputFormat, ref ReportList.ExcelOtherType EOT ) { VGRModel.PrintChanReturnDetl bco = new VGRModel.PrintChanReturnDetl(ConntionDB); DataTable Dt = bco.GetChanReturnDetl(ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } //設定使用第三方元件匯出EXCEL if (ReportOutputFormat == "EXCEL") { EOT = ReportList.ExcelOtherType.None; } return Dt; }
public DataTable queryData() { ResultMsgLabel.Text = ""; BCO.PrintChanReturnDetl bco = new PrintChanReturnDetl(ConntionDB); DataTable Dt = null; ArrayList aList = this.getParameterList(); Dt = bco.GetChanReturnDetl(aList); return Dt; }