示例#1
0
    }//btn_Save_Click

    protected void btn_Delete_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);
                BCO.DEL_UN_TAG_STORE(GetQueryParams(), null);
                ErrorMsgLabel.Text = "刪除成功";
                SLP_StoreChain1.Text = "";
                SLP_Store1.Text = "";

                string strJS = string.Format("alert('刪除成功');location.replace('MKT211.aspx?Code=MKT21&PageTimeStamp={0}');", PageTimeStamp.Value);
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DELETE_OK", strJS, true);

            }
            else 
            {
                ErrorMsgLabel.Text = "請輸入通路、門市";
            }
            #endregion
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        #endregion
    }//btn_Delete_Click
示例#2
0
    /// <summary>
    /// 繫結資料到控制項
    /// </summary>
    /// <param name="vdb"></param>
    private void QueryData()
    {
        #region

        string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
        MKTModel.VDS_MKT21_BCO BCO = new MKTModel.VDS_MKT21_BCO(ConnectionDB);

        DataTable dt = null;

        dt = BCO.QUERY_UN_TAG_STORE(GetQueryParams());

        Session[SessionIDName] = dt;
        Int32 iRowCount = 0;
        aryParamsPKey.Clear();


        GridView1.DataSource = dt;
        GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) <= 0) ? 10 : int.Parse(TextBoxPagesize.Text);
        GridView1.PageIndex = 0;
        GridView1.DataBind();

        if (dt != null && dt.Rows.Count > 0)
        {
            iRowCount = dt.Rows.Count;

            foreach (DataRow dr in dt.Rows)
            {
                #region
                aryParamsPKey.Add(dr["ID"].ToString());
                #endregion
            }
        }
        else
        {
            ErrorMsgLabel.Text = "查無資料";
        }


        Session[string.Format("{0}_{1}", strPreFixed, PageTimeStamp.Value)] = aryParamsPKey;

        LabelQueryRecordCount.Text = string.Format(" {0} Rows ", iRowCount);

        #endregion
    }
示例#3
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
示例#4
0
    /// <summary>
    /// 繫結資料到控制項
    /// </summary>
    /// <param name="vdb"></param>
    private void QueryData()
    {
        #region
        try
        {
            SLP_StoreChain1.Text = "";
            SLP_Store1.Text = "";

            MKTModel.VDS_MKT21_BCO BCO = new MKTModel.VDS_MKT21_BCO(ConnectionDB);
            DataTable dt = null;
            ArrayList ParameterList = new ArrayList();
            ParameterList.Add(s_ID);
            dt = BCO.QUERY_UN_TAG_STORE_BY_ID(ParameterList);

            if (dt != null && dt.Rows.Count > 0)
            {
                SLP_StoreChain1.Text = dt.Rows[0]["CHAN_NO"].ToString().Trim();
                SLP_Store1.Text = dt.Rows[0]["STORE"].ToString().Trim();
            }
            else
            {
                ErrorMsgLabel.Text = "查無資料或原始資料已被刪除";
            }
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        #endregion
    }
示例#5
0
    protected void btn_StoreSelect_Click(object sender, EventArgs e)
    {
        #region
        try
        {

            dtMultiSaveMKT21 = dtMKT21_POP_SelectStore;
            //(加入之前尚未存檔的選擇項目)
            if (dtMKT21_POP_SelectStore_old != null && dtMKT21_POP_SelectStore == null)
            { dtMultiSaveMKT21 = dtMKT21_POP_SelectStore_old; }

            if (dtMultiSaveMKT21.Rows.Count > 0)
            {
                //STEP 1.扣除已存在前次新增之資料
                #region
                if (dtMKT21_POP_SelectStore_old != null && dtMKT21_POP_SelectStore_old.Rows.Count > 0)
                {
                    for (Int32 i = dtMultiSaveMKT21.Rows.Count - 1; i >= 0; i--)
                    {
                        for (Int32 k = 0; k <= dtMKT21_POP_SelectStore_old.Rows.Count - 1; k++)
                        {
                            if (dtMultiSaveMKT21.Rows[i]["code"].ToString().Trim() == dtMKT21_POP_SelectStore_old.Rows[k]["code"].ToString().Trim())
                            {
                                dtMultiSaveMKT21.Rows.RemoveAt(i);
                                break;
                            }
                        }
                    }
                }
                #endregion

                //STEP 2.與前次新增之DATATABLE合併
                #region
                if (dtMKT21_POP_SelectStore_old != null && dtMKT21_POP_SelectStore_old.Rows.Count > 0)
                {
                    dtMultiSaveMKT21.Merge(dtMKT21_POP_SelectStore_old);
                }
                #endregion

                //STEP 3.扣除已存在DB之資料
                #region
                MKTModel.VDS_MKT21_BCO BCO = new MKTModel.VDS_MKT21_BCO(ConnectionDB);
                ArrayList ParameterList = new ArrayList();
                ParameterList.Clear();
                ParameterList.Add(null);
                ParameterList.Add(null);
                ParameterList.Add(null);
                ParameterList.Add(null);
                ParameterList.Add(null);
                ParameterList.Add(null);
                ParameterList.Add(9999);

                DataTable Dt = BCO.QUERY_UN_TAG_STORE(ParameterList);

                if (Dt.Rows.Count > 0)
                {
                    for (Int32 i = dtMultiSaveMKT21.Rows.Count - 1; i >= 0; i--)
                    {
                        for (Int32 k = 0; k <= Dt.Rows.Count - 1; k++)
                        {
                            if (dtMultiSaveMKT21.Rows[i]["code"].ToString().Trim() == Dt.Rows[k]["code"].ToString().Trim())
                            {
                                dtMultiSaveMKT21.Rows.RemoveAt(i);
                                break;
                            }
                        }
                    }
                }
                #endregion
            }

            //將舊資料存到old
            dtMKT21_POP_SelectStore_old = dtMultiSaveMKT21;
            //Binding 到GridView
            GridView1.DataSource = dtMultiSaveMKT21;
            GridView1.DataBind();
            UpdatePanel1.Update();
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }
        #endregion
    }
示例#6
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
    }
    private void QueryData()
    {
        #region

        string SessionIDName = string.Format("{0}_{1}", strPrefixed, PageTimeStamp.Value);

        DataTable dt = new DataTable();
        MKTModel.VDS_MKT21_BCO BCO = new MKTModel.VDS_MKT21_BCO(ConnectionDB);
        dt = BCO.QUERY_UN_TAG_STORE_POP(GetQueryParams());

        bAfterQueryDataBinding = true;

        if (!dt.Columns.Contains("CHECKED"))//增加欄位以方便判別是否可
            dt.Columns.Add("CHECKED");

        if (!dt.Columns.Contains("ROWID"))//增加欄位以判別勾選與否
            dt.Columns.Add("ROWID");

        if (!dt.Columns.Contains("CODE"))//增加欄位以判別勾選與否
            dt.Columns.Add("CODE");

        if (!dt.Columns.Contains("ROWNUM"))//增加欄位以判別勾選與否
            dt.Columns.Add("ROWNUM");


        hidden_RowID_MaxID.Value = dt == null ? "-1" : (dt.Rows.Count - 1).ToString();//記錄最大ROWID
        hidden_RowID_Selected.Value = "";//清空已選ROWID

        Session[SessionIDName] = dt;


        SetRowIDToDataTable(true);//設定ROWID

        GridView1.DataSource = dt;
        GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) <= 0) ? 10 : int.Parse(TextBoxPagesize.Text);
        GridView1.PageIndex = 0;
        GridView1.DataBind();
        GridView1.SelectedIndex = -1;
        
        bAfterQueryDataBinding = false;

        if (dt == null || (dt != null && dt.Rows.Count <= 0))
        {
            ResultMsgLabel.Text = "查無資料";
            ButtonConfirm.Enabled = false;
            UpdatePanel2.Update();
        }
        else 
        {
            ButtonConfirm.Enabled = true;
            UpdatePanel2.Update();
        }

        #endregion
    }