/// <summary> /// PIU08_2報表(匯出鈕)-依儲位排序 /// </summary> /// <param name="ParameterList">變數清單</param> /// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param> /// <param name="EOT">匯出Excel方式</param> /// <returns>回傳查詢結果</returns> public DataTable PUR08_2(ArrayList ParameterList, string ReportOutputFormat, ref ReportList.ExcelOtherType EOT ) { #region PURModel.PUR08_BCO BCO = new PURModel.PUR08_BCO(ConntionDB); DataTable Dt = BCO.GetPurchaseDetailData(ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } //設定使用第三方元件匯出EXCEL if (ReportOutputFormat == "EXCEL") { #region 表頭 #endregion EOT = ReportList.ExcelOtherType.None; } return Dt; #endregion }
/// <summary> /// PIU08_1報表(列印鈕) /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataTable PUR08_1(ArrayList ParameterList) { #region PURModel.PUR08_BCO BCO = new PURModel.PUR08_BCO(ConntionDB); DataTable Dt = BCO.GetPurchaseDetailData(ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } else { return Dt; } #endregion }