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 }