protected void btn_Save_Click(object sender, EventArgs e)
{
#region
try
{
#region 取得畫面元件的值
string v_DIS_USER = SLP_User1.Text.Trim();
string v_ROOT_no = SLP_ROOT1.Text.Trim();
string v_PMA = SLP_PMA1.Text.Trim();
string v_Pattern = SLP_Pattern1.Text.Trim() == "" ? null : SLP_Pattern1.Text.Trim();
string v_Item = SLP_SKU1.Text.Trim() == "" ? null : SLP_SKU1.Text.Trim();
#endregion
ArrayList ParameterList = new ArrayList();//20091111
#region 存檔前檢查分類正確性
ParameterList.Clear();
ParameterList.Add(v_ROOT_no);
ParameterList.Add(v_PMA);
ParameterList.Add(null); //category
ParameterList.Add(null); //sort_out
ParameterList.Add(v_Pattern);
ParameterList.Add(v_Item);
string vLevel = "1";
if (v_Pattern != null)
{
vLevel = "P";
}
if (v_Item != null)
{
vLevel = "I";
}
ParameterList.Add(vLevel);
ALOModel.QueryALOCommon alo_comm = new ALOModel.QueryALOCommon(ConnectionDB);
bool bCheck = alo_comm.CheckItemClassValid(ParameterList);
if (!bCheck)
{
throw new Exception("所輸入的品號/Pattern/大分類/群分類有誤,請確認後重新輸入");
}
#endregion
#region 加入輸入條件
#region Master
ParameterList.Clear();
ParameterList.Add(v_DIS_USER);
ParameterList.Add(v_ROOT_no);
ParameterList.Add(v_PMA);
ParameterList.Add(v_Pattern);
ParameterList.Add(v_Item);
#endregion
#endregion
ALOModel.MaintinDisPattern BCO = new ALOModel.MaintinDisPattern(ConnectionDB);
bool bResult = false;
bResult = BCO.CreateDisPattern(ParameterList, null);
if (!bResult)
{
throw new Exception("新增0筆資料!");
}
else
{
ResultMsgLabel.Text = "新增完成";
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", string.Format("location.replace('ALO011.aspx?dis_user={0}&Code=ALO01');", Session["UID"].ToString().Trim()), true);//alert('新增完成');
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
protected void btn_UpdateRecord_Click(object sender, EventArgs e)
{
#region
try
{
string v_ROOT_no = SLP_ROOT.Text.Trim() == "" ? null : SLP_ROOT.Text.Trim();
string v_PMA = SLP_PMA.Text.Trim() == "" ? null : SLP_PMA.Text.Trim();
string v_Pattern = SLP_Pattern.Text.Trim() == "" ? null : SLP_Pattern.Text.Trim();
string v_Item = SLP_Item.Text.Trim() == "" ? null : SLP_Item.Text.Trim();
#region 存檔前檢查分類正確性
ArrayList ParameterList = new ArrayList();//20091112
ParameterList.Clear();
ParameterList.Add(v_ROOT_no);
ParameterList.Add(v_PMA);
ParameterList.Add(null); //category
ParameterList.Add(null); //sort_out
ParameterList.Add(v_Pattern);
ParameterList.Add(v_Item);
string vLevel = "1";
if (v_Pattern != null)
{
vLevel = "P";
}
if (v_Item != null)
{
vLevel = "I";
}
ParameterList.Add(vLevel);
ALOModel.QueryALOCommon alo_comm = new ALOModel.QueryALOCommon(ConnectionDB);
bool bCheck = alo_comm.CheckItemClassValid(ParameterList);
if (!bCheck)
{
throw new Exception("所輸入的品號/Pattern/大分類/群分類有誤,請確認後重新輸入");
}
#endregion
DataTable dtTemp = null;
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
ALOModel.MaintainStoreAssignItem BCO = new ALOModel.MaintainStoreAssignItem(ConnectionDB);
STM_SLP_StoreChain SLP_StoreChain1 = (STM_SLP_StoreChain)FormView1.FindControl("SLP_StoreChain1");
PIC.VDS2G.WebUI.SLP.SLP_Store SLP_Store1 = (PIC.VDS2G.WebUI.SLP.SLP_Store)FormView1.FindControl("SLP_Store1");
dtTemp = GetTempDataTableByCurrentMode();
if (dtTemp != null)
{
for (Int32 i = 0; i <= dtTemp.Rows.Count - 1; i++)
{
if (dtTemp.Rows[i].RowState != DataRowState.Deleted)
{
if (dtTemp.Rows[i]["ROOT_NO"].ToString().Trim() == SLP_ROOT.Text.Trim() && //20120813 rika insert
dtTemp.Rows[i]["PMA"].ToString().Trim() == SLP_PMA.Text.Trim() &&
dtTemp.Rows[i]["PATTERN"].ToString().Trim() == SLP_Pattern.Text.Trim() &&
dtTemp.Rows[i]["ITEM"].ToString().Trim() == SLP_Item.Text.Trim())
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "ClientScript", "alert('此資料存在於該門市');", true);
return;
}
}
}
DataRow dr = dtTemp.NewRow();
dr["rownum"] = dtTemp.Rows.Count + 1;
dr["ROOT_NO"] = SLP_ROOT.Text.Trim();
dr["pma"] = SLP_PMA.Text.Trim();
dr["pattern"] = SLP_Pattern.Text.Trim();
dr["item"] = SLP_Item.Text.Trim();
dr["CHAIN_CODE"] = SLP_StoreChain1.Text.Trim();
dr["STORE_CODE"] = SLP_Store1.Text.Trim();
#region
DataTable dtTempForNewRecord = GetInfoForNewRecord(SLP_StoreChain1.Text.Trim(), SLP_Store1.Text.Trim(),
SLP_ROOT.Text.Trim(), SLP_PMA.Text.Trim(), SLP_Pattern.Text.Trim(), SLP_Item.Text.Trim());
if (dtTempForNewRecord != null && dtTempForNewRecord.Rows.Count > 0)
{
dr["ROOT_NAME"] = dtTempForNewRecord.Rows[0]["ROOT_NAME"];
dr["PMA_NAME"] = dtTempForNewRecord.Rows[0]["PMA_NAME"];
dr["Pattern_Name"] = dtTempForNewRecord.Rows[0]["Pattern_Name"];
dr["item_name"] = dtTempForNewRecord.Rows[0]["item_name"];
dr["period"] = dtTempForNewRecord.Rows[0]["period"];
dr["st_accept_qty"] = dtTempForNewRecord.Rows[0]["st_accept_qty"];
dr["backward_qty"] = dtTempForNewRecord.Rows[0]["backward_qty"];
dr["realsale_qty"] = dtTempForNewRecord.Rows[0]["realsale_qty"];
}
#endregion
SetCommonDataForDataRow(dtTemp, dr);
SetMasterInfoData(dtTemp);
GridView2.DataSource = dtTemp;
GridView2.DataBind();
Session[SessionIDName] = dtTemp;
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
finally
{
Panel_AddSingle.Visible = false;
}
#endregion
}
}//btn_Save_Click
protected void btn_Delete_Click(object sender, EventArgs e)
{
#region
try
{
#region
if (SLP_RootNo1.Text != "" && SLP_PMA1.Text != "")
{
#region 存檔前檢查分類正確性
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(SLP_RootNo1.Text.Trim());
ParameterList.Add(SLP_PMA1.Text.Trim());
ParameterList.Add(null);//category
ParameterList.Add(null);//sort_out
ParameterList.Add(null);//pattern
ParameterList.Add(null);//item
string vLevel = "1";
ParameterList.Add(vLevel);
ALOModel.QueryALOCommon alo_comm = new ALOModel.QueryALOCommon(ConnectionDB);
bool bCheck = alo_comm.CheckItemClassValid(ParameterList);
if (!bCheck)
{
throw new Exception("所輸入的群分類、大分類有誤,請確認後重新輸入");
}
#endregion
#region
MKTModel.VDS_MKT22_BCO BCO = new MKTModel.VDS_MKT22_BCO(ConnectionDB);
BCO.DEL_UN_TAG_PMA(GetQueryParams(), null);
ErrorMsgLabel.Text = "刪除成功";
SLP_RootNo1.Text = "";
SLP_PMA1.Text = "";
string strJS = string.Format("alert('刪除成功');location.replace('MKT221.aspx?Code=MKT22&PageTimeStamp={0}');", PageTimeStamp.Value);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DELETE_OK", strJS, true);
#endregion
}
else
{
ErrorMsgLabel.Text = "請輸入通路、門市";
}
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}//btn_Delete_Click
protected void btn_Save_Click(object sender, EventArgs e)
{
#region
try
{
#region
if (SLP_RootNo1.Text != "" && SLP_PMA1.Text != "")
{
#region 存檔前檢查分類正確性
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(SLP_RootNo1.Text.Trim());
ParameterList.Add(SLP_PMA1.Text.Trim());
ParameterList.Add(null);//category
ParameterList.Add(null);//sort_out
ParameterList.Add(null);//pattern
ParameterList.Add(null);//item
string vLevel = "1";
ParameterList.Add(vLevel);
ALOModel.QueryALOCommon alo_comm = new ALOModel.QueryALOCommon(ConnectionDB);
bool bCheck = alo_comm.CheckItemClassValid(ParameterList);
if (!bCheck)
{
throw new Exception("所輸入的群分類、大分類有誤,請確認後重新輸入");
}
#endregion
#region
MKTModel.VDS_MKT22_BCO BCO = new MKTModel.VDS_MKT22_BCO(ConnectionDB);
string strID = "", strErrMsg = "";
bool bResult = false;
bResult = BCO.ADD_UN_TAG_PMA(GetQueryParams(), null, out strID, out strErrMsg);
if (bResult && strErrMsg == "")
{
ArrayList aryTmp = new ArrayList();
aryTmp.Clear();
aryTmp.Add(strID);
aryParamsPKey = aryTmp;
CurrentPageMode = PageCurrentMode.Readonly;
SetControlsByCurrentPageMode();
ErrorMsgLabel.Text = "新增成功";
}
else
{
ErrorMsgLabel.Text = strErrMsg;
}
#endregion
}
else
{
ErrorMsgLabel.Text = "請輸入通路、門市";
}
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
UpdatePanel1.Update();
}
#endregion
}//btn_Save_Click
private bool CheckItemClassValid()
{
#region
bool bResult=false;
try
{
ALOModel.QueryALOCommon BCO = new ALOModel.QueryALOCommon(ConnectionDB);
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
ParameterList.Add(SLP_RootNo1.Text.Trim());
ParameterList.Add(SLP_PMA1.Text.Trim());
ParameterList.Add(null);
ParameterList.Add(null);
if (SLP_Pattern1.Text.Trim() != "")
{
ParameterList.Add(SLP_Pattern1.Text.Trim());
ParameterList.Add(null);
ParameterList.Add("P");//0,1,2,3,P,I
bResult = BCO.CheckItemClassValid(ParameterList);
}
else
{
ParameterList.Add(null);
ParameterList.Add(null);
ParameterList.Add("1");//0,1,2,3,P,I
bResult = BCO.CheckItemClassValid(ParameterList);
}
if (!bResult)
{
throw new Exception("所輸入的原Pattern/原大分類/原群分類有誤,請確認後重新輸入");
//throw new Exception(string.Format("{0}_{1}_{2}:商品分類關連錯誤,請確認後重新輸入", SLP_RootNo1.Text.Trim(), SLP_PMA1.Text.Trim(), SLP_Pattern1.Text.Trim()));
}
if (bResult)
{
ParameterList.Clear();
ParameterList.Add(SLP_RootNo2.Text.Trim());
ParameterList.Add(SLP_PMA2.Text.Trim());
ParameterList.Add(null);
ParameterList.Add(null);
if (SLP_Pattern2.Text.Trim() != "")
{
ParameterList.Add(SLP_Pattern2.Text.Trim());
ParameterList.Add(null);
ParameterList.Add("P");//0,1,2,3,P,I
bResult = BCO.CheckItemClassValid(ParameterList);
}
else
{
ParameterList.Add(null);
ParameterList.Add(null);
ParameterList.Add("1");//0,1,2,3,P,I
bResult = BCO.CheckItemClassValid(ParameterList);
}
if (!bResult)
{
throw new Exception("所輸入的新Pattern/新大分類/新群分類有誤,請確認後重新輸入");
//throw new Exception(string.Format("{0}_{1}_{2}:商品分類關連錯誤,請確認後重新輸入", SLP_RootNo2.Text.Trim(), SLP_PMA2.Text.Trim(), SLP_Pattern2.Text.Trim()));
}
}
}
catch (Exception ex)
{
throw ex;
}
return bResult;
#endregion
}
private bool CheckItemClassValid()
{
#region
bool bResult = false;
try
{
#region
ALOModel.QueryALOCommon BCO = new ALOModel.QueryALOCommon(ConnectionDB);
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
ParameterList.Add(SLP_RootNo2.Text.Trim());
ParameterList.Add(SLP_PMA3.Text.Trim());
ParameterList.Add(null);
ParameterList.Add(null);
if (SLP_Pattern2.Text.Trim() != "")
{
ParameterList.Add(SLP_Pattern3.Text.Trim());
ParameterList.Add(null);
ParameterList.Add("P");//0,1,2,3,P,I
bResult = BCO.CheckItemClassValid(ParameterList);
}
else
{
ParameterList.Add(null);
ParameterList.Add(null);
ParameterList.Add("1");//0,1,2,3,P,I
bResult = BCO.CheckItemClassValid(ParameterList);
}
if (!bResult)
{
throw new Exception("所輸入的Pattern/大分類/群分類有誤,請確認後重新輸入");
}
#endregion
}
catch (Exception ex)
{
throw ex;
}
return bResult;
#endregion
}
