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));
}
