//查詢 protected void ButtonQuery_Click(object sender, EventArgs e) { #region try { #region 檢查條件 this.ErrorMsgLabel.Text = ""; string s_CheckPage = CheckPage(sender); if (s_CheckPage != string.Empty) { this.ErrorMsgLabel.Text = s_CheckPage; return; } #endregion ErrorMsgLabel.Text = ""; DataTable dtA = new DataTable(); VDMModel.ProcessImportVCMSLevel bcoA = new VDMModel.ProcessImportVCMSLevel(ConnectionDB); VDMModel.ProcessImportVCMSFee bcoB = new VDMModel.ProcessImportVCMSFee(ConnectionDB); DateTime dateB, dateE; DateTime.TryParse(this.SLP_SLPDateRange1.StartDate.ToString(), out dateB); if (DateTime.TryParse(this.SLP_SLPDateRange1.EndDate.ToString(), out dateE) == false) dateE = Convert.ToDateTime("3000/01/01"); else DateTime.TryParse(this.SLP_SLPDateRange1.EndDate.ToString(), out dateE); this.gv_ErrorData.Visible = false; this.gv_ErrorDataB.Visible = false; if (this.TextBoxRowCountLimit.Text.Trim() == "") { this.TextBoxRowCountLimit.Text = "500"; } if (this.rdoTypeQ1.Checked == true) { //因為把"關鍵字搜尋"拿掉,所以沒有CheckBoxLikeSearch //dtA = bcoA.QueryErrorByFind(GetValueSetParameter(this.txt_User.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked).ToString(), dateB, dateE, Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim())); dtA = bcoA.QueryErrorByFind(GetValueSetParameter(this.txt_User.Text.Trim(), "string", false).ToString(), dateB, dateE,Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim())); #region 資料與GridView繫結 //抓取本頁初次登記的時間 if (dtA.Rows.Count == 0) { this.gv_ErrorData.Visible = false; ErrorMsgLabel.Text = "查無資料!"; } else { string SessionIDName = "VDM051A_gv_ItemInfo" + PageTimeStamp.Value; this.gv_ErrorData.Visible = true; Session["SessionID"] = SessionIDName; Session[SessionIDName] = dtA; this.gv_ErrorData.DataSource = dtA; if (this.TextBoxPagesize.Text == "") this.gv_ErrorData.PageSize = 10; else this.gv_ErrorData.PageSize = Convert.ToInt32(this.TextBoxPagesize.Text); this.gv_ErrorData.PageIndex = 0; this.gv_ErrorData.DataBind(); } #endregion } else { //因為把"關鍵字搜尋"拿掉,所以沒有CheckBoxLikeSearch //dtA = bcoB.QueryErrorByFind(GetValueSetParameter(this.txt_User.Text.Trim(), "string", this.CheckBoxLikeSearch.Checked).ToString(), dateB, dateE, Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim())); dtA = bcoB.QueryErrorByFind(GetValueSetParameter(this.txt_User.Text.Trim(), "string", false).ToString(), dateB, dateE, Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim())); string SessionIDName = "VDM051B_gv_ItemInfo" + PageTimeStamp.Value; if (dtA.Rows.Count == 0) { this.gv_ErrorData.Visible = false; ErrorMsgLabel.Text = "查無資料!"; } else { this.gv_ErrorDataB.Visible = true; Session["SessionID"] = SessionIDName; Session[SessionIDName] = dtA; this.gv_ErrorDataB.DataSource = dtA; if (this.TextBoxPagesize.Text == "") this.gv_ErrorDataB.PageSize = 10; else this.gv_ErrorDataB.PageSize = Convert.ToInt32(this.TextBoxPagesize.Text); this.gv_ErrorDataB.PageIndex = 0; this.gv_ErrorDataB.DataBind(); } } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion }
//檢視異常報表 protected void but_Unusual_Report_Click(object sender, EventArgs e) { #region try { System.Threading.Thread.Sleep(2000); DataTable dtA = new DataTable(); this.gv_ErrorData.Visible = false; this.gv_ErrorDataB.Visible = false; if (this.TextBoxRowCountLimit.Text.Trim() == "") { this.TextBoxRowCountLimit.Text = "500"; } VDMModel.ProcessImportVCMSLevel bcoA = new VDMModel.ProcessImportVCMSLevel(ConnectionDB); VDMModel.ProcessImportVCMSFee bcoB = new VDMModel.ProcessImportVCMSFee(ConnectionDB); if (this.rdoType1.Checked == true) { dtA = bcoA.QueryErrorByFind(Session["UID"].ToString(), Convert.ToDateTime(System.DateTime.Now.ToShortDateString()), Convert.ToDateTime(System.DateTime.Now.ToShortDateString()), Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim())); #region 資料與GridView繫結 //抓取本頁初次登記的時間 if (dtA.Rows.Count == 0) { ErrorMsgLabel.Text = "查無資料!"; } else { string SessionIDName = "VDM051A_gv_ItemInfo" + PageTimeStamp.Value; this.gv_ErrorData.Visible = true; Session["SessionID"] = SessionIDName; Session[SessionIDName] = dtA; this.gv_ErrorData.DataSource = dtA; if (this.TextBoxPagesize.Text == "") this.gv_ErrorData.PageSize = 10; else this.gv_ErrorData.PageSize = Convert.ToInt32(this.TextBoxPagesize.Text); this.gv_ErrorData.PageIndex = 0; this.gv_ErrorData.DataBind(); } #endregion } else { dtA = bcoB.QueryErrorByFind(Session["UID"].ToString(), Convert.ToDateTime(System.DateTime.Now.ToShortDateString()), Convert.ToDateTime(System.DateTime.Now.ToShortDateString()), Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim())); string SessionIDName = "VDM051B_gv_ItemInfo" + PageTimeStamp.Value; this.gv_ErrorDataB.Visible = true; Session["SessionID"] = SessionIDName; Session[SessionIDName] = dtA; this.gv_ErrorDataB.DataSource = dtA; if (this.TextBoxPagesize.Text == "") this.gv_ErrorDataB.PageSize = 10; else this.gv_ErrorDataB.PageSize = Convert.ToInt32(this.TextBoxPagesize.Text); this.gv_ErrorDataB.PageIndex = 0; this.gv_ErrorDataB.DataBind(); } } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.Message; } finally { } #endregion }