protected void Btn_Query_Click(object sender, EventArgs e)
{
try
{
#region 檢查Between欄位結束欄位一定要大於或等於開始欄位
if (this.SLP_ROOT_NO_E.Text.Trim() != "" && ((String.Compare(this.SLP_ROOT_NO_S.Text, this.SLP_ROOT_NO_E.Text)) == 1))
{
ErrorMsgLabel.Text = "群分類迄要大於等於群分類起";
return;
}
else if (this.SLP_PMA_E.Text.Trim() != "" && ((String.Compare(this.SLP_PMA_S.Text, this.SLP_PMA_E.Text)) == 1))
{
ErrorMsgLabel.Text = "大分類迄要大於等於大分類起";
return;
}
else if (this.SLP_Category_E.Text.Trim() != "" && ((String.Compare(this.SLP_Category_S.Text, this.SLP_Category_E.Text)) == 1))
{
ErrorMsgLabel.Text = "中分類迄要大於等於中分類起";
return;
}
#endregion
ErrorMsgLabel.Text = "";
DataTable Dt = new DataTable();
Session["PUR101_" + PageTimeStamp.Value] = null;
#region 處理查詢
BCO.PUR10_BCO bco = new PUR10_BCO(ConntionDB);
Dt = bco.QueryByFind(this.getParameterList());
#endregion
if (Dt == null || (Dt != null && Dt.Rows.Count <= 0))
{
ErrorMsgLabel.Text = "查無資料";
Session["PUR101_" + PageTimeStamp.Value] = null;
}
else
{
Session["PUR101_" + PageTimeStamp.Value] = Dt;
}
//}
#region 設定查詢結果
this.GridView1.DataSource = Dt;
if (TextBoxPagesize.Text == "0")
{
GridView1.PageSize = 1;
}
else
{
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
}
this.GridView1.PageIndex = 0;
this.GridView1.DataBind();
ViewState["SortField"] = null;
ViewState["SortDirect"] = null;
#endregion
// }
}
catch (Exception ex)
{ this.ErrorMsgLabel.Text = ex.ToString(); }
finally { }
}
