protected void btn_Save_Click(object sender, EventArgs e) { #region try { #region if (SLP_StoreChain1.Text != "" && SLP_Store1.Text != "") { MKTModel.VDS_MKT21_BCO BCO = new MKTModel.VDS_MKT21_BCO(ConnectionDB); string strID = "", strErrMsg = ""; bool bResult = false; bResult = BCO.ADD_UN_TAG_STORE(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 = "新增成功"; //string strJS = string.Format("alert('新增成功');location.replace('MKT212.aspx?Code=MKT21&Mode=Readonly&ID={0}&PageTimeStamp={1}');", strID, PageTimeStamp.Value); //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ADD_OK", strJS, true); } else { ErrorMsgLabel.Text = strErrMsg; } } else { ErrorMsgLabel.Text = "請輸入通路、門市"; } #endregion } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; UpdatePanel1.Update(); } #endregion }//btn_Save_Click
protected void btn_Save_Click(object sender, EventArgs e) { #region try { if (dtMultiSaveMKT21 != null && dtMultiSaveMKT21.Rows.Count > 0) { bool bResult = false; string strID = "", strErrMsg = ""; ArrayList ParameterList = new ArrayList(); //------------------------- ALOModel.ALOCommon BCOCommon = new ALOModel.ALOCommon(); System.Data.Common.DbTransaction DBT = BCOCommon.OpenAndGetConnection(ConnectionDB).BeginTransaction(); MKTModel.VDS_MKT21_BCO BCO = new MKTModel.VDS_MKT21_BCO(ConnectionDB); try { for (Int32 i = 0; i <= dtMultiSaveMKT21.Rows.Count - 1; i++) { ParameterList.Clear(); ParameterList.Add(dtMultiSaveMKT21.Rows[i]["CHAN_NO"].ToString().Trim()); ParameterList.Add(dtMultiSaveMKT21.Rows[i]["STORE"].ToString().Trim()); ParameterList.Add(Session["UID"].ToString()); bResult = BCO.ADD_UN_TAG_STORE(ParameterList, DBT, out strID, out strErrMsg); if (!bResult || strErrMsg != "") { throw new Exception(strErrMsg); } } DBT.Commit();//交易成功 ErrorMsgLabel.Text = "新增完成"; btn_StoreSelect.Enabled = false; btn_Save.Enabled = false; btn_InsertAgain.Visible = true; btn_InsertAgain.Attributes.Add("onclick", "ReloadMKT213();return false;"); GridView1.Columns[6].Visible = false; } catch (Exception ex) { DBT.Rollback();//交易失敗 throw ex; } //------------------------- } else { ErrorMsgLabel.Text = "請先加入門市"; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { UpdatePanel1.Update(); UpdatePanel2.Update(); } #endregion }