Exemplo n.º 1
0
    }//end InsertCancelButton_Click


    /// <summary>
    /// 由新增模式,確認新增
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void InsertButton_Click(object sender, EventArgs e)
    {
        int AddRecord = 0;
        try
        {
            #region 取得畫面元件的值

            string v_Code = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
            string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim();
            string v_Description = ((TextBox)FormView1.FindControl("TextBoxDescription")).Text.Trim();
            DateTime processtime = DateTime.Now;
            string v_SystemCode = ((TextBox)FormView1.FindControl("TextBoxSystemCode")).Text.Trim();
            string v_ParentCode = ((WUI.SLP.Program)this.FormView1.FindControl("TextBoxParentCode")).Text;
            string v_LinkUrl = ((TextBox)FormView1.FindControl("TextBoxLinkURL")).Text.Trim();
            string v_DisplayOrder = ((WUI.SLP.SLPQuantity)this.FormView1.FindControl("TextBoxDisplayOrder")).Text;
            string v_ProgramType = ((WUI.SLP.SLPENVProgramType)this.FormView1.FindControl("TextBoxProgramType")).Text;

            ParameterList.Clear();
            SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB);
            ParameterList.Add(v_Code);
            ParameterList.Add("SYS_PROGRAM");
            ParameterList.Add("CODE");
            ParameterList.Add("");
            DataTable Dup = Uniq.QuerySwitch(SYSModel.MaintainProgram.QueryType.Duplicate,
                                         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(v_Description);
            ParameterList.Add(processtime);               //vCreateDate
            ParameterList.Add(Session["UID"].ToString()); //vCreateUID
            ParameterList.Add(processtime);               //vUpdateDate
            ParameterList.Add(Session["UID"].ToString()); //vUpdateUID
            ParameterList.Add(v_SystemCode);
            ParameterList.Add(v_ParentCode);
            ParameterList.Add(v_LinkUrl);
            if (v_DisplayOrder != "")
            { ParameterList.Add(int.Parse(v_DisplayOrder));}
            else
            { ParameterList.Add(0);}

            if (v_ProgramType != "")
            { ParameterList.Add(int.Parse(v_ProgramType));}
            else
            { ParameterList.Add(0);}

            #endregion

            SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConnectionDB);
            AddRecord = BCO.CreateProgram(ParameterList, null);

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

    }