/// <summary> /// COM17_1報表_列印鈕 /// </summary> /// <param name="ParameterList">變數清單</param> /// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param> /// <param name="EOT">匯出Excel方式</param> /// <returns>回傳查詢結果</returns> public DataTable COM17_1(ArrayList ParameterList, string ReportOutputFormat, ref ReportList.ExcelOtherType EOT ) { #region COMModel.COM17_BCO BCO = new COMModel.COM17_BCO(ConntionDB); DataTable Dt = null; Int32 i32TotalItem = 0; Dt = BCO.QueryItemSale(ParameterList, out i32TotalItem); if (Dt == null || Dt.Rows.Count == 0) { throw new Exception("查無資料"); } return Dt; #endregion }
/// <summary> /// 繫結資料到控制項 /// </summary> /// <param name="vdb"></param> private void QueryData() { #region try { string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); COMModel.COM17_BCO BCO = new COMModel.COM17_BCO(ConnectionDB); Int32 i32_TOTAL_ITEM; DataTable dt = BCO.QueryItemSale(GetQueryParams(), out i32_TOTAL_ITEM); Session[SessionIDName] = dt; htSubTotal.Clear();//clear HashTable GridView1.DataSource = GetPivotTable(dt, i32_TOTAL_ITEM); GridView1.PageIndex = 0; GridView1.DataBind(); if (dt == null || dt.Rows.Count <= 0) { ErrorMsgLabel.Text = "查無資料"; } } catch (Exception ex) { throw ex; } //LabelQueryRecordCount.Text = string.Format(" {0} Rows ", iRowCount); #endregion }//QueryData