//數量查詢 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; } }