//架貨查詢
protected void btnQ2_Click(object sender, EventArgs e)
{
if (SLP_SHELT_CM3_S.Text.Trim() == "" && SLP_SHELT_CM3_E.Text.Trim() == "" && SLP_SHELT_NO.Text.Trim() == "")
{
lblErrorQ2.Text = "請至少需輸入一項查詢條件";
return;
}
else if (SLP_SHELT_CM3_S.Text.Trim().Length > 0 && SLP_SHELT_CM3_E.Text.Trim().Length == 0)
{
lblErrorQ2.Text = "請輸入貨架尺寸迄";
return;
}
else if (SLP_SHELT_CM3_S.Text.Trim().Length == 0 && SLP_SHELT_CM3_E.Text.Trim().Length > 0)
{
lblErrorQ2.Text = "請輸入貨架尺寸起";
return;
}
else if (SLP_SHELT_NO.TextBox_Name.Text == "查無資料")
{
lblErrorQ2.Text = "請輸入正確之貨架代號";
return;
}
else if (SLP_SHELT_CM3_S.Text.Trim().Length > 0 && SLP_SHELT_CM3_E.Text.Trim().Length > 0)
{
if (int.Parse(SLP_SHELT_CM3_S.Text) > int.Parse(SLP_SHELT_CM3_E.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); //配本商品期別
if (SLP_SHELT_CM3_S.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_SHELT_CM3_S.Text); //貨架尺寸起
if (SLP_SHELT_CM3_E.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_SHELT_CM3_E.Text); //貨架尺寸迄
ParameterList.Add(SLP_SHELT_NO.Text); //貨架代號
ParameterList.Add(Session["UID"].ToString()); //登入者
BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
DataTable dt = new DataTable();
dt = bco.QureryDisStoreForShelf(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; }
}
