protected void btnExportDel_Click(object sender, EventArgs e) { try { #region 傳入參數 BCO.CAACommon CAACommon = new BCO.CAACommon(); ParameterList.Clear(); ParameterList.Add(this.slp_Date_TAB1.StartDate); ParameterList.Add(this.slp_Date_TAB1.EndDate); #endregion #region 連結資料庫 DataTable dt = new DataTable(); BCO.ProcessAccountRecord BCO = new BCO.ProcessAccountRecord(ConntionDB); dt = BCO.QueryDetail(ParameterList); #endregion #region 檢查回傳資料 if (dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; } #endregion else { Export_Excel_D(dt); } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } }
/// <summary> /// CAA13 立沖帳彙總表 /// </summary> /// <param name="ParameterList"></param> /// <returns></returns> public DataTable CAA13_1(ArrayList ParameterList) { #region 宣告變數 BCO.CAACommon CAAComm = new BCO.CAACommon(); ArrayList arl_ReportService = new ArrayList(); DataTable dt_Return = new DataTable(); string s_Type = string.Empty; #endregion #region 傳入參數 #region 設定列印類別 if (ParameterList[2].ToString() == string.Empty && ParameterList[3].ToString() == string.Empty) { s_Type = "Summary"; } else { s_Type = "Detail"; } #endregion arl_ReportService.Clear(); arl_ReportService.Add(CAAComm.GetValueSetParameter(s_Type, "string", false));//[列印類別] arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[0].ToString(), "date", false));//[結帳年月]起(0) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[1].ToString(), "date", false));//[結帳年月]迄(1) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[2].ToString(), "string", false));//[利潤中心]起(2) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[3].ToString(), "string", false));//[利潤中心]迄(3) arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[4].ToString(), "string", false));//登入人員(4) #endregion #region 連結資料庫 BCO.ProcessAccountRecord BCO = new BCO.ProcessAccountRecord(ConntionDB); dt_Return = BCO.QueryAccountSumReport(arl_ReportService); #endregion #region 檢查回傳資料 #region 檢查每一筆資料是否每一個欄位都為0,若是,則刪除該筆資料。 foreach (DataRow dr in dt_Return.Rows) { bool b_Is_All_Zero = true; for (int i = 0; i < dr.Table.Columns.Count; i++) { if (dr.Table.Columns[i].ToString() != "NAME") { if (dr[i].ToString() != "0") { b_Is_All_Zero = false; } } } //這一筆資料全部欄位都為0,則該筆資料要刪除 if (b_Is_All_Zero == true) { dr.Delete(); } } dt_Return.AcceptChanges(); #endregion if (dt_Return.Rows.Count == 0) { throw new Exception("查無資料"); } #endregion return dt_Return; }
protected void btnExport1_Click(object sender, EventArgs e) { try { #region 傳入參數 BCO.CAACommon CAACommon = new BCO.CAACommon(); ParameterList.Clear(); ParameterList.Add(this.slp_Date_TAB1.StartDate); ParameterList.Add(this.slp_Date_TAB1.EndDate); ParameterList.Add(this.slp_ProfitCenter1.Text); ParameterList.Add(this.slp_ProfitCenter2.Text); ParameterList.Add(HttpContext.Current.Session["UID"].ToString()); #endregion #region 連結資料庫 DataTable dt = new DataTable(); BCO.ProcessAccountRecord BCO = new BCO.ProcessAccountRecord(ConntionDB); dt = BCO.QueryData(ParameterList); #endregion #region 檢查回傳資料 if (dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; } #endregion else { DataRow dr = dt.NewRow(); dr["PROFIT_NO"] = "合計"; dr["INV_AMT"] = dt.Compute("Sum(INV_AMT)", string.Empty); dr["CAN_INV_AMT"] = dt.Compute("Sum(CAN_INV_AMT)", string.Empty); dr["DISC_AMT_W"] = dt.Compute("Sum(DISC_AMT_W)", string.Empty); dr["DISC_AMT_Z"] = dt.Compute("Sum(DISC_AMT_Z)", string.Empty); dr["CAN_DISC_AMT"] = dt.Compute("Sum(CAN_DISC_AMT)", string.Empty); dt.Rows.Add(dr); Export_Excel(dt); } } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } }