//查詢 protected void ButtonQuery_Click(object sender, EventArgs e) { #region try { this.gv_ErrorData.Visible = false; this.gv_OKData.Visible = false; #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(); VGRModel.VDS_VGR08_BCO bco = new VGRModel.VDS_VGR08_BCO(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; if (this.TextBoxRowCountLimit.Text.Trim() == "") { this.TextBoxRowCountLimit.Text = "500"; } if (this.rdoTypeQ1.Checked) { hid_Query_Type.Value = "1"; } else if (this.rdoTypeQ2.Checked) { hid_Query_Type.Value = "2"; } else { hid_Query_Type.Value = "3"; } dtA = bco.QueryErrorByFind(hid_Query_Type.Value, GetValueSetParameter(this.txt_User.Text.Trim(), "string", false).ToString(), dateB, dateE, Convert.ToInt32(this.TextBoxRowCountLimit.Text.Trim())); #region 資料與GridView繫結 //抓取本頁初次登記的時間 if (dtA.Rows.Count == 0) { ErrorMsgLabel.Text = "查無資料!"; } else { string SessionIDName = "VGR081_" + 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 } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion }
//檢視異常報表 protected void but_Unusual_Report_Click(object sender, EventArgs e) { #region try { DataTable dtA = new DataTable(); this.gv_ErrorData.Visible = false; this.gv_OKData.Visible = false; if (this.TextBoxRowCountLimit.Text.Trim() == "") { this.TextBoxRowCountLimit.Text = "500"; } VGRModel.VDS_VGR08_BCO bco = new VGRModel.VDS_VGR08_BCO(ConnectionDB); if (this.rdoType1.Checked == true) { hid_Query_Type.Value = "1"; } else if (this.rdoType2.Checked) { hid_Query_Type.Value = "2"; } else { hid_Query_Type.Value = "3"; } dtA = bco.QueryErrorByFind(hid_Query_Type.Value, 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 = "VGR081_" + 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 } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.Message; } finally { } #endregion }