//數量查詢
protected void btnQ5_Click(object sender, EventArgs e)
{
if (SLP_DIS_NO.Text.Trim() == "" && SLP_BUY_FLAG.Text.Trim() == "" && txtN_RANK_LEVEL.Text.Trim() == "" && SLP_B1_ST_ACCEPT_QTY.Text.Trim() == "" && SLP_B1_POS_QTY.Text.Trim() == "" && SLP_B1_SALES_QTY.Text.Trim() == "" && SLP_POS_RATE.Text.Trim() == "" && SLP_SALES_QTY.Text.Trim() == "" && SLP_SALES_RATE.Text.Trim() == "" && SLP_B2_ST_ACCEPT_QTY.Text.Trim() == "" && SLP_B2_SALES_QTY.Text.Trim() == "" && SLP_B3_ST_ACCEPT_QT.Text.Trim() == "" && SLP_B3_SALES_QTY.Text.Trim() == "" && SLP_IR1_ST_ACCEPT_QTY.Text.Trim() == "" && SLP_IR1_SALES_QTY.Text.Trim() == "" && SLP_IR2_ST_ACCEPT_QTY.Text.Trim() == "" && SLP_IR2_SALES_QTY.Text.Trim() == "" && SLP_IR3_ST_ACCEPT_QTY.Text.Trim() == "" && SLP_IR3_SALES_QTY.Text.Trim() == "" && SLP_IR4_ST_ACCEPT_QTY.Text.Trim() == "" && SLP_IR4_SALES_QTY.Text.Trim() == "")
{
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(Session["UID"].ToString()); //登入者
if (SLP_BUY_FLAG.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_BUY_FLAG.Text); //買斷判斷
ParameterList.Add(txtN_RANK_LEVEL.Text); //門市等級
ParameterList.Add(Resolve_Op(SLP_DIS_NO.Operator)); //配本數量運算子
if (SLP_DIS_NO.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_DIS_NO.Text); //配本數量
ParameterList.Add(Resolve_Op(SLP_POS_RATE.Operator)); //POS銷％運算子
if (SLP_POS_RATE.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_POS_RATE.Text); //POS銷％
ParameterList.Add(Resolve_Op(SLP_SALES_QTY.Operator)); //平均實銷(實銷數量運算子)
if (SLP_SALES_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_SALES_QTY.Text); //平均實銷(實銷數量)
ParameterList.Add(Resolve_Op(SLP_SALES_RATE.Operator)); //平均銷％(實銷率%運算子)
if (SLP_SALES_RATE.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_SALES_RATE.Text); //平均銷％(實銷率%)
ParameterList.Add(Resolve_Op(SLP_B1_ST_ACCEPT_QTY.Operator)); //前期進貨
if (SLP_B1_ST_ACCEPT_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_B1_ST_ACCEPT_QTY.Text); //前期進貨
ParameterList.Add(Resolve_Op(SLP_B1_SALES_QTY.Operator)); //前期實銷運算子
if (SLP_B1_SALES_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_B1_SALES_QTY.Text); //前期實銷
ParameterList.Add(Resolve_Op(SLP_B1_POS_QTY.Operator)); //前期POS運算子
if (SLP_B1_POS_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_B1_POS_QTY.Text); //前期POS
ParameterList.Add(Resolve_Op(SLP_B2_ST_ACCEPT_QTY.Operator)); //前2期進貨運算子
if (SLP_B2_ST_ACCEPT_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_B2_ST_ACCEPT_QTY.Text); //前2期進貨
ParameterList.Add(Resolve_Op(SLP_B2_SALES_QTY.Operator)); //前2期實銷運算子
if (SLP_B2_SALES_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_B2_SALES_QTY.Text); //前2期實銷
ParameterList.Add(Resolve_Op(SLP_B3_ST_ACCEPT_QT.Operator)); //前3期進貨運算子
if (SLP_B3_ST_ACCEPT_QT.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_B3_ST_ACCEPT_QT.Text); //前3期進貨
ParameterList.Add(Resolve_Op(SLP_B3_SALES_QTY.Operator)); //前3期實銷運算子
if (SLP_B3_SALES_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_B3_SALES_QTY.Text); //前3期實銷
ParameterList.Add(Resolve_Op(SLP_IR1_ST_ACCEPT_QTY.Operator)); //參照1進貨運算子
if (SLP_IR1_ST_ACCEPT_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_IR1_ST_ACCEPT_QTY.Text); //參照1進貨
ParameterList.Add(Resolve_Op(SLP_IR2_ST_ACCEPT_QTY.Operator)); //參照2進貨運算子
if (SLP_IR2_ST_ACCEPT_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_IR2_ST_ACCEPT_QTY.Text); //參照2進貨
ParameterList.Add(Resolve_Op(SLP_IR3_ST_ACCEPT_QTY.Operator)); //參照3進貨運算子
if (SLP_IR3_ST_ACCEPT_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_IR3_ST_ACCEPT_QTY.Text); //參照3進貨
ParameterList.Add(Resolve_Op(SLP_IR4_ST_ACCEPT_QTY.Operator)); //參照4進貨運算子
if (SLP_IR4_ST_ACCEPT_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_IR4_ST_ACCEPT_QTY.Text); //參照4進貨
ParameterList.Add(Resolve_Op(SLP_IR1_SALES_QTY.Operator)); //參照1實銷運算子
if (SLP_IR1_SALES_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_IR1_SALES_QTY.Text); //參照1實銷
ParameterList.Add(Resolve_Op(SLP_IR2_SALES_QTY.Operator)); //參照2實銷運算子
if (SLP_IR2_SALES_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_IR2_SALES_QTY.Text); //參照2實銷
ParameterList.Add(Resolve_Op(SLP_IR3_SALES_QTY.Operator)); //參照3實銷運算子
if (SLP_IR3_SALES_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_IR3_SALES_QTY.Text); //參照3實銷
ParameterList.Add(Resolve_Op(SLP_IR4_SALES_QTY.Operator)); //參照4實銷運算子
if (SLP_IR4_SALES_QTY.Text.Trim().Length == 0) ParameterList.Add(System.DBNull.Value); else ParameterList.Add(SLP_IR4_SALES_QTY.Text); //參照4實銷
BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
DataTable dt = new DataTable();
dt = bco.QureryDisStoreForQty(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; }
}
