/// <summary> /// COM07報表 /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataTable COM15_1(ArrayList ParameterList, string ReportOutputFormat, ref ReportList.ExcelOtherType EOT ) { COMModel.COM15_BCO bco = new COMModel.COM15_BCO(ConntionDB); DataTable Dt = bco.QuerySalesReport(ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } else { return Dt; } }
private DataTable QuerySum_Accept_Qty() { BCO.COM15_BCO bco = new BCO.COM15_BCO(ConntionDB); #region 前置檢查與參數過濾 string strSLP_StoreChain = this.SLP_StoreChain.Text; string strSLP_SKU = this.SLP_SKU.Text; string strSLP_ItemPeriod = this.SLP_ItemPeriod.Text; #endregion #region 組合查詢條件至ArrayList ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(strSLP_StoreChain, "string")); ParameterList.Add(GetValueSetParameter(strSLP_SKU, "string")); ParameterList.Add(GetValueSetParameter(strSLP_ItemPeriod, "string")); #endregion DataTable dt = bco.QuerySum_Accept_Qty(ParameterList); return dt; }
private DataTable QueryZ_O() { BCO.COM15_BCO bco = new BCO.COM15_BCO(ConntionDB); DataTable dt = bco.QueryZ_O(); return dt; }