//查詢鈕
protected void btnQuery_Click(object sender, EventArgs e)
{
btnSave.Enabled = false;
GridView2.DataSource = null;
GridView2.DataBind();
UpdatePanel1.Update();
if(txtPeriod.Text=="")
{
lblMsg.Text = "請輸入欲查期數";
ScriptManager.RegisterStartupScript(this, this.GetType(), "ALO125_Focus", "document.all['" + txtPeriod.ClientID + "'].focus(); document.all['" + txtPeriod.ClientID + "'].select();", true);
return;
}
if (txtPeriod.Text == "0")
{
lblMsg.Text = "欲查期數需大於0";
ScriptManager.RegisterStartupScript(this, this.GetType(), "ALO125_Focus", "document.all['" + txtPeriod.ClientID + "'].focus(); document.all['" + txtPeriod.ClientID + "'].select();", true);
return;
}
if (txtReturnRate.Text == "")
{
lblMsg.Text = "請輸入退貨率";
ScriptManager.RegisterStartupScript(this, this.GetType(), "ALO125_Focus", "document.all['" + txtReturnRate.ClientID + "'].focus(); document.all['" + txtReturnRate.ClientID + "'].select();", true);
return;
}
try
{
DataTable dt = new DataTable();
string SessionIDName = "ALO125_dt5" + PageTimeStamp.Value;
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
ParameterList.Add(Request.QueryString["pPG_ID"]);
ParameterList.Add(PageTimeStamp.Value + Session["UID"].ToString());
ParameterList.Add(Request.QueryString["pDisNo"]);
ParameterList.Add(Request.QueryString["pItem"]);
ParameterList.Add(Request.QueryString["pPeriod"]);
ParameterList.Add(txtPeriod.Text);//V_PERIOD_CNT
ParameterList.Add(radGreater.Checked ? "1" : "0");
ParameterList.Add(txtReturnRate.Text);
ParameterList.Add(Session["UID"].ToString());
BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
dt = bco.QueryDisStoreByReturnRate(ParameterList);
Session[SessionIDName] = dt;
GridView2.DataSource = dt;
GridView2.PageSize = int.Parse(TextBoxPagesize.Text.Length == 0 ? "20" : TextBoxPagesize.Text);
GridView2.DataBind();
GridView2.Visible = true;
UpdatePanel1.Update();
if (dt.Rows.Count > 0) { txtTune.Enabled = true; btnConfirm.Enabled = true; txtPeriod.Enabled = true; UpdatePanel6.Update(); UpdatePanel7.Update(); } else btnConfirm.Enabled = false;
}
catch (Exception ex) { lblMsg.Text = ex.Message; }
}
