}//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 = ""; //string v_Code = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim(); //string v_Name = ((TextBox)FormView1.FindControl("SLP_RoleCode")).Text.Trim(); DateTime processtime = DateTime.Now; string v_RoleCode = ((WUI.SLP.Role)this.FormView1.FindControl("SLP_RoleCode")).Text; string v_SystemCode = "VDS2G"; //string v_SystemCode = ((TextBox)FormView1.FindControl("SLP_SystemCode")).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.MaintainRole BCO2 = new SYSModel.MaintainRole(ConnectionDB); ParameterList.Clear(); ParameterList.Add(v_RoleCode); DataTable Chkrole = BCO2.QueryRoleByCode(ParameterList); if (Chkrole.Rows.Count != 1) { ErrorMsgLabel.Text = "請輸入正確角色代號"; return; } SYSModel.MaintainRoleprogauthrel Uniq = new SYSModel.MaintainRoleprogauthrel(ConnectionDB); ParameterList.Clear(); ParameterList.Add(v_RoleCode); ParameterList.Add(v_ProgramCode); DataTable Dup = Uniq.QueryDup(ParameterList); if (Dup.Rows.Count > 0) { if (Dup.Rows[0]["ENABLE"].ToString() == "1") { throw new Exception("資料重覆!"); } } ParameterList.Clear(); ParameterList.Add(v_RoleCode); DataTable role_name = BCO2.QueryRoleByCode(ParameterList); string v_Name = role_name.Rows[0]["NAME"].ToString(); #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_RoleCode); ParameterList.Add(v_SystemCode); ParameterList.Add(v_ProgramCode); ParameterList.Add(v_CanCreate); ParameterList.Add(v_CanRead); ParameterList.Add(v_CanUpdate); ParameterList.Add(v_CanDelete); #endregion SYSModel.MaintainRoleprogauthrel BCO = new SYSModel.MaintainRoleprogauthrel(ConnectionDB); AddRecord = BCO.CreateRoleprogauthrel(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { Response.Write("<script>alert('新增完成');location.replace('SYS172.aspx?ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
}//end InsertCancelButton_Click /// <summary> /// 由新增模式,確認新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertButton_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; int AddRecord = 0; try { #region 取得畫面元件的值 DateTime processtime = DateTime.Now; string v_UserCode = ((WUI.SLP.User)this.FormView1.FindControl("TextBoxUserCode")).Text; string v_RoleCode = ((WUI.SLP.Role)this.FormView1.FindControl("TextBoxRoleCode")).Text; //TextBox rolename = ((TextBox)this.FormView1.FindControl("TextBoxRoleCode").FindControl("TextBoxName")); string v_RoleName = ""; 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.MaintainRole BCO2 = new SYSModel.MaintainRole(ConnectionDB); ParameterList.Clear(); ParameterList.Add(v_RoleCode); DataTable Chkrole = BCO2.QueryRoleByCode(ParameterList); if (Chkrole.Rows.Count != 1) { ErrorMsgLabel.Text = "請輸入正確角色代號"; return; } else { v_RoleName = Chkrole.Rows[0]["NAME"].ToString(); } ParameterList.Clear(); SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Add(v_UserCode); ParameterList.Add("SYS_USERROLEREL"); ParameterList.Add("USERCODE"); 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("");//ParameterList.Add(v_Code); ParameterList.Add(v_RoleName);//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_RoleCode); #endregion SYSModel.MaintainUserRoleRel BCO = new SYSModel.MaintainUserRoleRel(ConnectionDB); AddRecord = BCO.CreateUserRoleRel(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { Response.Write("<script>alert('新增完成');location.replace('SYS052.aspx?mode=readonly&ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }