Exemplo n.º 1
0
    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
Exemplo n.º 2
0
    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
    }