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 }