private void databind()
{
#region
string SessionIDName = "CRM20" + PageTimeStamp.Value;
ParameterList.Clear();
ParameterList.Add("%" + txtItemName.Text.Trim() + "%");
ParameterList.Add(SLP_Item.Text.Trim());
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(SLP_ItemPeriod1.Text.Trim());
ParameterList.Add(txt_Barcode.Text.Trim());
BCO.QueryCRMCommon bco = new BCO.QueryCRMCommon(ConntionDB);
DataTable dt = bco.QueryItemAndStock(ParameterList);
if (dt == null || (dt != null && dt.Rows.Count <= 0))
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('查無資料');", true);
}
Session[SessionIDName] = dt;
GridView1.DataSource = dt;
GridView1.PageIndex = 0;
GridView1.DataBind();
#endregion
}
private void QueryData()
{
#region
string SessionIDName = "CRM20" + PageTimeStamp.Value;
ParameterList.Clear();
ParameterList.Add("%" + txtItemName.Text.Trim() + "%");
ParameterList.Add(SLP_Item.Text.Trim());
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(SLP_ItemPeriod1.Text.Trim());
ParameterList.Add(txt_Barcode.Text.Trim());
BCO.QueryCRMCommon bco = new BCO.QueryCRMCommon(ConntionDB);
DataTable dt = bco.QueryItemAndStock(ParameterList);
if (dt.Rows.Count == 0)
{
ErrorMsgLabel.Text = "查無資料";
Session[SessionIDName] = null;
GridView1.DataBind();
Panel_DetailQuery.Visible = false;
}
else
{
Session[SessionIDName] = dt;
GridView1.DataSource = dt;
GridView1.DataBind();
Panel_DetailQuery.Visible = true;
}
#endregion
}
