/// <summary> /// COM07報表 /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataTable COM08_1(ArrayList ParameterList, string ReportOutputFormat, ref ReportList.ExcelOtherType EOT ) { COMModel.QuerySalesSumByStore bco = new COMModel.QuerySalesSumByStore(ConntionDB); DataTable Dt = bco.QueryItemSaleByPos(ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } else { return Dt; } }
public DataTable queryData() { ResultMsgLabel.Text = ""; BCO.QuerySalesSumByStore bco = new BCO.QuerySalesSumByStore(ConntionDB); ArrayList aList = this.getParameterList(); DataTable Dt = null; if (this.RadioType2.Checked == true) { Dt = bco.QueryByALO(aList); } else if (this.RadioType1.Checked == true) { Dt = bco.QueryByTemplate(aList); } return Dt; }