//區域查詢
protected void btnQ1_Click(object sender, EventArgs e)
{
if (SLP_CHAN_NO_Q.Text.Trim() == "" && SLP_Z_O.Text.Trim() == "" && SLP_BUSINESS_NO.Text.Trim() == "" && SLP_AREA_CODE.Text.Trim() == "" && SLP_D_O.Text.Trim() == "")
{
lblErrorQ2.Text = "請至少需輸入一項查詢條件";
return;
}
else if (SLP_D_O.Text.Trim() != "" && SLP_Z_O.Text.Trim() == "")
{
lblErrorQ2.Text = "請輸入該區課所屬營業所";
return;
}
else if (SLP_D_O.TextBox_Name.Text == "查無資料")
{
lblErrorQ2.Text = "請輸入正確之營業所下轄區課";
return;
}
try
{
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
ParameterList.Add(PageTimeStamp.Value + Session["UID"].ToString());
ParameterList.Add("ALO121"); //V_PG_ID
ParameterList.Add(txtDIS_NO.Text); //配本序號
ParameterList.Add(hidITEM.Value); //配本商品品號
ParameterList.Add(hidPERIOD.Value); //配本商品期別
ParameterList.Add(SLP_CHAN_NO_Q.Text); //通路
ParameterList.Add(SLP_Z_O.Text); //營業所
ParameterList.Add(SLP_BUSINESS_NO.Text); //商圈
ParameterList.Add(SLP_AREA_CODE.Text); //縣市
ParameterList.Add(SLP_D_O.Text); //區課
ParameterList.Add(Session["UID"].ToString()); //登入者
BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
DataTable dt = new DataTable();
dt = bco.QueryDisStoreForArea(ParameterList);
txtQueryTotRec.Text = dt.Rows.Count.ToString();
ComputeTotQty(dt); //計算查詢總配量
string SessionIDName = "ALO121_dt5" + PageTimeStamp.Value;
Session[SessionIDName] = dt;
if (dt.Rows.Count == 0)
{
lblErrorQ2.Text = "查無資料";
GridView2.DataSource = null;
}
else
GridView2.DataSource = CopyTable(dt);
GridView2.DataBind();
Resize_Div(GridView2.Rows.Count);
UpdatePanel1.Update();
}
catch (Exception ex) { this.lblErrorQ2.Text = ex.Message; }
}