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 { }
}
protected void Btn_Create_Click(object sender, EventArgs e)
{
GV_WriteCache();
string strResult = string.Empty;
ErrorMsgLabel.Text = "";
if (Session["PUR101_" + PageTimeStamp.Value] == null)
{
ErrorMsgLabel.Text = "無資料可供建立，請重新查詢";
return;
}
DataTable dtData = (DataTable)Session["PUR101_" + PageTimeStamp.Value];
if (dtData.Rows.Count == 0)
{
ErrorMsgLabel.Text = "無資料可供建立，請重新查詢";
return;
}
DataTable dtTemp = DT_Filter(dtData, "Sel='1'");
if (dtTemp.Rows.Count > 0)
{
BCO.PUR10_BCO bco = new PUR10_BCO(ConntionDB);
strResult = bco.CreateData(Session["UID"].ToString(), DateTime.Now.ToString("yyyy/MM/dd"), dtTemp);
ErrorMsgLabel.Text = "採購單建立完成";
Session["PUR101_" + PageTimeStamp.Value] = null;
GridView1.DataSource = null;
GridView1.DataBind();
}
else
{
ErrorMsgLabel.Text = "[選取]欄位，至少需勾選一筆";
}
}
