Beispiel #1
0
    }//end InsertCancelButton_Click


    /// <summary>
    /// 由新增模式,確認新增
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void InsertButton_Click(object sender, EventArgs e)
    {
        try
        {
            ErrorMsgLabel.Text = "";
            int AddRecord = 0;

            #region 取得畫面元件的值

            string v_Code = "";// ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
            string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim();
            DateTime processtime = DateTime.Now;
            string v_UserCode = ((WUI.SLP.User)this.FormView1.FindControl("SLP_UserCode")).Text;
            string v_SystemCode = "VDS2G";//((TextBox)FormView1.FindControl("TextBoxSystemCode")).Text;
            string v_ProgramCode = ((WUI.SLP.Program)this.FormView1.FindControl("SLP_ProgramCode")).Text;
            string v_CanCreate = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanCreate")).Text.Trim();
            string v_CanRead = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanRead")).Text.Trim();
            string v_CanUpdate = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanUpdate")).Text.Trim();
            string v_CanDelete = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanDelete")).Text.Trim();

            //SYSModel.MaintainUser BCO1 = new SYSModel.MaintainUser(ConnectionDB);
            //ParameterList.Clear();
            //ParameterList.Add(v_UserCode);
            //DataTable Chkuser = BCO1.QueryUserByCode(ParameterList);
            //if (Chkuser.Rows.Count != 1)
            //{
            //    ErrorMsgLabel.Text = "請輸入正確人員代號";
            //    return;
            //}

            SYSModel.MaintainUserprogauthrel Uniq = new SYSModel.MaintainUserprogauthrel(ConnectionDB);
            ParameterList.Clear();    
            ParameterList.Add(v_UserCode);
            ParameterList.Add(v_ProgramCode);            
            DataTable Dup = Uniq.QueryDup(ParameterList);

            if (Dup.Rows.Count > 0)
            {
                if (Dup.Rows[0]["ENABLE"].ToString() == "1")
                {
                    throw new Exception("資料重覆!");
                }
            }
            #endregion

            #region 加入輸入條件

            ParameterList.Clear();

            ParameterList.Add(v_Code);
            ParameterList.Add(v_Name);
            ParameterList.Add(processtime);               //vCreateDate
            ParameterList.Add(Session["UID"].ToString()); //vCreateUID
            ParameterList.Add(processtime);               //vUpdateDate
            ParameterList.Add(Session["UID"].ToString()); //vUpdateUID
            ParameterList.Add(v_UserCode);
            ParameterList.Add(v_SystemCode);
            ParameterList.Add(v_ProgramCode);
            ParameterList.Add(1);
            ParameterList.Add(v_CanCreate);
            ParameterList.Add(v_CanRead);
            ParameterList.Add(v_CanUpdate);
            ParameterList.Add(v_CanDelete);

            #endregion

            SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConnectionDB);
            AddRecord = BCO.CreateUserprogauthrel(ParameterList, null);

            if (AddRecord == 0)
            {
                throw new Exception("新增0筆資料!");
            }
            else
            {
                Response.Write("<script>alert('新增完成');location.replace('SYS162.aspx?mode=readonly&ID=" + AddRecord + "');</script>");
            }
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
        }

    }