//畫面估算 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; } }