public bool AddNew(Models.ACL_Role model) { string sqlText = @"INSERT INTO [dbo].[ACL_Role] ([Id] ,[RoleName] ,[SimpleCode] ,[SortCode] ,[ParentId] ,[CreateTime] ,[IsRemoved]) VALUES (@Id ,@RoleName ,@SimpleCode ,@SortCode ,@ParentId ,@CreateTime ,@IsRemoved)"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@ParentId", model.ParentId); SqlParameter s3 = new SqlParameter("@SimpleCode", model.SimpleCode); SqlParameter s4 = new SqlParameter("@RoleName", model.RoleName); SqlParameter s5 = new SqlParameter("@SortCode", model.SortCode); SqlParameter s6 = new SqlParameter("@CreateTime", model.CreateTime); SqlParameter s7 = new SqlParameter("@IsRemoved", model.IsRemoved); SqlParameter[] cmdParm = new SqlParameter[] { s1, s2, s3, s4, s5, s6, s7 }; return(Models.SqlHelper.ExecuteNoQuery(sqlText, cmdParm) > 0 ?true : false); }
public override void AddNew() { txtID.Text = "新ID"; txtSortCode.Text = ""; txtName.Text = ""; sbtnSave.Enabled = true; model = new Models.ACL_Role(); }
public bool Modify(Models.ACL_Role model) { string sqlText = @"UPDATE [dbo].[ACL_Role] SET [RoleName] = @RoleName ,[SimpleCode] = @SimpleCode ,[SortCode] = @SortCode ,[ParentId] = @ParentId ,[CreateTime] = @CreateTime ,[IsRemoved] = @IsRemoved WHERE [Id] = @Id"; SqlParameter s1 = new SqlParameter("@Id", model.Id); SqlParameter s2 = new SqlParameter("@ParentId", model.ParentId); SqlParameter s3 = new SqlParameter("@SimpleCode", model.SimpleCode); SqlParameter s4 = new SqlParameter("@RoleName", model.RoleName); SqlParameter s5 = new SqlParameter("@SortCode", model.SortCode); SqlParameter s6 = new SqlParameter("@CreateTime", model.CreateTime); SqlParameter s7 = new SqlParameter("@IsRemoved", model.IsRemoved); SqlParameter[] cmdParm = new SqlParameter[] { s1, s2, s3, s4, s5, s6, s7 }; return(Models.SqlHelper.ExecuteNoQuery(sqlText, cmdParm) > 0 ? true : false); }
private void gvRole_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (RightIsChange && clsPublic.GetMessageBoxYesNoResult("授权信息改变是否保存?", "提示")) { sbtnSaveFunc_Click(null, null); } RightIsChange = false; if (gvRole.FocusedRowHandle >= 0) { RoleId = (Guid)gvRole.GetFocusedRowCellValue("Id"); model = RoleList.FirstOrDefault(s => s.Id == RoleId); gcUser.DataSource = roleMg.GetTbUsersByRoleId(RoleId); gcOU.DataSource = roleMg.GetTbDepartmentsByRoleId(RoleId); BuiderFuncTree(RoleId); sbtnSaveFunc.Enabled = sbtnReLoadFunc.Enabled = true; tlFunc.Caption = string.Format("当前选择的角色为:{0}", gvRole.GetFocusedRowCellValue("RoleName")); txtID.Text = model.Id.ToString(); txtName.Text = model.RoleName; txtSortCode.Text = model.SortCode; } }
public bool Modify(Models.ACL_Role model) { return(Sev.Modify(model)); }
public bool AddNew(Models.ACL_Role model) { return(Sev.AddNew(model)); }