//畫面估算
protected void btnCalculate_Click(object sender, EventArgs e)
{
try
{
if (!chkField()) return;
DateTime Dt = DateTime.Now;
BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
ArrayList ParameterList = new ArrayList();//20091113
if (radCHANGE_TYPE1.Checked)//比例調整及查詢
{
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(SLP_CHANGE_VALUE1.Text); //調整幅度
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(Dt);
DataTable dt = bco.PreCalculteRatioFor123(ParameterList);
if (dt.Rows.Count > 0)
{
SLP_N_PRE_STO_QTY1.Text = dt.Rows[0]["STORE_CNT"].ToString();
SLP_N_DIFF_DIS_QTY1.Text = dt.Rows[0]["DIFF_DIS_QTY"].ToString();
}
else
{
SLP_N_PRE_STO_QTY1.Text = "";
SLP_N_DIFF_DIS_QTY1.Text = "";
}
if (SLP_N_DIFF_DIS_QTY1.Text == "")
{
btnConfirm.Enabled = false;
btnSave.Enabled = false;
}
else
{
btnConfirm.Enabled = true;
btnSave.Enabled = true;
}
}
else if (radCHANGE_TYPE2.Checked)//數量調整及查詢
{
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(SLP_START_RANKQTY2.Text); //原配本數起
ParameterList.Add(SLP_END_RANKQTY2.Text); //原配本數迄
ParameterList.Add(SLP_ADJ_QTY2.Text); //調整幅度
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(Dt);
DataTable dt = bco.PreCalculteChangeQtyFor123(ParameterList);
if (dt.Rows.Count > 0)
{
SLP_N_PRE_STO_QTY2.Text = dt.Rows[0]["STORE_CNT"].ToString();
SLP_N_DIFF_DIS_QTY2.Text = dt.Rows[0]["DIFF_DIS_QTY"].ToString();
}
else
{
SLP_N_PRE_STO_QTY2.Text = "";
SLP_N_DIFF_DIS_QTY2.Text = "";
}
if (SLP_N_DIFF_DIS_QTY2.Text == "")
{
btnConfirm.Enabled = false;
btnSave.Enabled = false;
}
else
{
btnConfirm.Enabled = true;
btnSave.Enabled = true;
}
}
else if (radCHANGE_TYPE3.Checked)
{
//儲存加減本數設定
string SessionIDName = "ALO123_dt" + PageTimeStamp.Value;
DataTable dt = (DataTable)Session[SessionIDName];
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(System.DBNull.Value); //V_CHAN_NO
ParameterList.Add(Session["UID"].ToString());
bco.SaveRankFo123(ParameterList, null, dt, Dt);
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(Session["UID"].ToString());
ParameterList.Add(Dt);
DataTable dt1 = bco.PreCalculteRankFor123(ParameterList);
if (dt1.Rows.Count > 0)
{
SLP_N_DIFF_DIS_QTY3.Text = dt1.Rows[0]["DIFF_DIS_QTY"].ToString();
}
else
{
SLP_N_DIFF_DIS_QTY3.Text = "";
}
if (SLP_N_DIFF_DIS_QTY3.Text == "")
{
btnConfirm.Enabled = false;
btnSave.Enabled = false;
}
else
{
btnConfirm.Enabled = true;
btnSave.Enabled = true;
}
}
}
catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; }
}
