}//end InsertCancelButton_Click /// <summary> /// 由新增模式,確認新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertButton_Click(object sender, EventArgs e) { #region try { #region 取得畫面元件的值 string v_Chain_Code = ((STM_SLP_StoreChain)FormView1.FindControl("SLP_StoreChain1")).Text.Trim(); string v_Store_Code = ((PIC.VDS2G.WebUI.SLP.SLP_Store)FormView1.FindControl("SLP_Store1")).Text.Trim(); DateTime processtime = DateTime.Now; #endregion // 2009-05-04 cyhsu 在Server Site 存檔前,檢查門市與通路關連正確性 ArrayList ParameterList = new ArrayList();//20091113 #region 檢查通路與門市 //檢查門市是否屬於該通路 if ((v_Chain_Code != "") && (v_Store_Code != "")) { ParameterList.Clear(); ParameterList.Add(v_Chain_Code); // 通路 ParameterList.Add(v_Store_Code); // 門市 ParameterList.Add(Session["UID"].ToString()); PIC.VDS2G.BSM.CRM.QueryCRMCommon bco = new PIC.VDS2G.BSM.CRM.QueryCRMCommon(ConnectionDB); bool b_CheckRes; b_CheckRes = bco.CheckChanAndStore(ParameterList); if (!b_CheckRes) { sb.Length = 0; sb.AppendFormat("門市[{1}]不屬於通路[{0}]!", v_Chain_Code, v_Store_Code); throw new Exception(sb.ToString()); } } #endregion #region 加入輸入條件 #region Master ParameterList.Clear(); ParameterList.Add(string.Format("{0}_{1}", v_Chain_Code, v_Store_Code)); ParameterList.Add(string.Format("{0}_{1}", v_Chain_Code, v_Store_Code)); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(v_Chain_Code); ParameterList.Add(v_Store_Code); #endregion #region Detail DataTable dtDetail = new DataTable(); dtDetail.Columns.Add("CREATEDATE"); dtDetail.Columns.Add("CREATEUID"); dtDetail.Columns.Add("UPDATEDATE"); dtDetail.Columns.Add("UPDATEUID"); dtDetail.Columns.Add("PMA"); dtDetail.Columns.Add("IS_DIS_BYPO"); dtDetail.Columns.Add("IS_MULTIPO"); //20090105 added for spec changed dtDetail.Columns.Add("ROOT_NO"); for (Int32 i = 0; i <= GridView2.Rows.Count - 1; i++) { DataRow newRowDETL = dtDetail.NewRow(); CheckBox chk_ISEXISTED_Sgl = (CheckBox)GridView2.Rows[i].FindControl("chk_ISEXISTED_Sgl"); CheckBox chk_single = (CheckBox)GridView2.Rows[i].FindControl("chk_POSingle_Sgl"); CheckBox chk_multi = (CheckBox)GridView2.Rows[i].FindControl("chk_POMulti_Sgl"); Label lbl_PMA = (Label)GridView2.Rows[i].FindControl("lbl_PMA"); Label lbl_root_no = (Label)GridView2.Rows[i].FindControl("lbl_root_no"); if (chk_ISEXISTED_Sgl.Checked) { newRowDETL["CREATEDATE"] = processtime; newRowDETL["CREATEUID"] = Session["UID"].ToString(); newRowDETL["UPDATEDATE"] = processtime; newRowDETL["UPDATEUID"] = Session["UID"].ToString(); newRowDETL["PMA"] = lbl_PMA.Text.Trim(); newRowDETL["IS_DIS_BYPO"] = chk_single.Checked ? 1 : 0; newRowDETL["IS_MULTIPO"] = chk_multi.Checked ? 1 : 0; newRowDETL["ROOT_NO"] = lbl_root_no.Text.Trim(); dtDetail.Rows.Add(newRowDETL); } } #endregion #endregion ALOModel.MaintainChainPOSetting BCO = new ALOModel.MaintainChainPOSetting(ConnectionDB); string v_ID = ""; v_ID = BCO.CreateMasterAndDetail(ParameterList, dtDetail, null).ToString(); if (v_ID == "") { throw new Exception("新增0筆資料!"); } else { b_CopyNew = false; s_ID = v_ID; ResultMsgLabel.Text = "新增完成"; SwitchFormviewMode(FormViewMode.ReadOnly); aryParamsPKey.Clear();//清空ID ArrayList } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion }//end InsertButton_Click
/// <summary> /// 檢查畫面條件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected System.Text.StringBuilder CheckPage() { System.Text.StringBuilder sb = new System.Text.StringBuilder(); TextBox txt_Store = (TextBox)this.slp_Store.FindControl("TextBoxCode"); TextBox txt_StoreChain = (TextBox)this.slp_StoreChain.FindControl("TextBoxCode"); #region 檢查必填欄位 if ((slp_Crm_Date.Text == "" || slp_Crm_Date.Text == "____/__/__") && slp_Store.Text == "" && slp_StoreChain.Text == "") { throw new Exception("請至少輸入一項查詢條件"); } #endregion //if (txt_Store.Text.Trim() == string.Empty) //{ sb.Append("門市欄位不可空白\\r\\n"); } //if (txt_StoreChain.Text.Trim() == string.Empty) //{ sb.Append("通路欄位不可空白\\r\\n"); } //檢查門市是否屬於該通路 if ((this.slp_Store.Text != "") && (this.slp_StoreChain.Text != "")) { ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(this.slp_StoreChain.Text); // 通路 ParameterList.Add(this.slp_Store.Text); // 門市 ParameterList.Add(Session["UID"].ToString()); BCO.QueryCRMCommon bco = new BCO.QueryCRMCommon(ConntionDB); bool b_CheckRes; b_CheckRes = bco.CheckChanAndStore(ParameterList); if (!b_CheckRes) { sb.AppendFormat("門市[{1}]不屬於通路[{0}]! 請重新輸入查詢條件!", this.slp_StoreChain.Text, this.slp_Store.Text); } } return sb; }