/// <summary> /// CGR07_2報表(列印鈕) /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataTable CGR07_2(ArrayList ParameterList, out int Cnt) { #region CGRModel.PrintSorterException BCO = new CGRModel.PrintSorterException(ConntionDB); DataTable Dt = BCO.GetSorterExceptionRptData(ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } else { string[] fileds ={ "STORE" }; DataTable Dt_1 = SelectDistinct(Dt, fileds); Cnt = Dt_1.Rows.Count; return Dt; } #endregion }
public DataTable queryData() { ResultMsgLabel.Text = ""; BCO.PrintSorterException bco = new BCO.PrintSorterException(ConntionDB); DataTable Dt = null; ArrayList aList = this.getParameterList(); Dt = bco.GetSorterExceptionRptData(aList); return Dt; }
/// <summary> /// CGR07_1報表(匯出鈕) /// </summary> /// <param name="ParameterList">變數清單</param> /// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param> /// <param name="EOT">匯出Excel方式</param> /// <returns>回傳查詢結果</returns> public DataTable CGR07_1(ArrayList ParameterList, string ReportOutputFormat, ref ReportList.ExcelOtherType EOT, out int Cnt ) { #region CGRModel.PrintSorterException BCO = new CGRModel.PrintSorterException(ConntionDB); ////todo要判別模式 DataTable Dt = BCO.GetSorterExceptionRptData(ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } //設定使用第三方元件匯出EXCEL if (ReportOutputFormat == "EXCEL") { #region 表頭 //Dt.Columns[0].ColumnName = "群分類"; //Dt.Columns[1].ColumnName = "群分類名稱"; //Dt.Columns[2].ColumnName = "大分類"; //Dt.Columns[3].ColumnName = "大分類名稱"; //Dt.Columns[4].ColumnName = "中分類"; //Dt.Columns[5].ColumnName = "中分類名稱"; //Dt.Columns[6].ColumnName = "小分類"; //Dt.Columns[7].ColumnName = "小分類名稱"; //Dt.Columns[8].ColumnName = "商品"; //Dt.Columns[9].ColumnName = "商品名稱"; //Dt.Columns[10].ColumnName = "刊別"; //Dt.Columns[11].ColumnName = "進貨數量 "; //Dt.Columns[12].ColumnName = "退貨數量"; //Dt.Columns[13].ColumnName = "實銷數量"; //Dt.Columns[14].ColumnName = "進貨牌價"; //Dt.Columns[15].ColumnName = "退貨牌價"; //Dt.Columns[16].ColumnName = "時銷牌價"; //Dt.Columns[17].ColumnName = "進貨成本"; //Dt.Columns[18].ColumnName = "退貨成本"; //Dt.Columns[19].ColumnName = "時銷成本"; //Dt.Columns[20].ColumnName = "進貨零售價"; //Dt.Columns[21].ColumnName = "退貨零售價"; //Dt.Columns[22].ColumnName = "時銷零售價"; #endregion EOT = ReportList.ExcelOtherType.None; } string[] fileds ={ "STORE" }; DataTable Dt_1 = SelectDistinct(Dt, fileds); Cnt = Dt_1.Rows.Count; return Dt; #endregion }