/// <summary>
/// PC端系统角色集合分页查询
/// 请勿删除
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public List <SysRoleModel> GetSysRoleList(int?pageIndex, int?pageSize, string RoleName, ref int recordCount)
{
SysRoleDal dal = new SysRoleDal();
recordCount = dal.GetCount(RoleName);
return(dal.GetSysRoleList(pageIndex, pageSize, RoleName));
}
public MsgResult InitData(List <T_SysOperations> list)
{
MsgResult result = new MsgResult();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//1 , 清除数据，先删关系表
int count = 0;
count = AdminUserDal.Clear(typeof(T_UserRoles).Name);
count = AdminUserDal.Clear(typeof(T_RolePermissions).Name);
count = AdminUserDal.Clear(typeof(T_OperatePermissions).Name);
count = AdminUserDal.Clear(typeof(T_MenuPermissions).Name);
count = AdminUserDal.Clear(typeof(T_AdminUsers).Name);
count = AdminUserDal.Clear(typeof(T_SysRoles).Name);
count = AdminUserDal.Clear(typeof(T_SysPermissions).Name);
count = AdminUserDal.Clear(typeof(T_SysOperations).Name);
//count = AdminUserDal.Clear(typeof(T_SysMenus).Name);
//2 , 初始化数据
//用户
T_AdminUsers adminUser = new T_AdminUsers();
adminUser.Phone = "17512039375";
adminUser.CreateTime = DateTime.Now;
adminUser.CreateUser = 1;
adminUser.Salt = "123456";
adminUser.PwdHush = EncryptHelper.GetMd5("n5187698" + adminUser.Salt);
adminUser.Guid = Guid.NewGuid().ToString("N");
var addUser = AdminUserDal.Add(adminUser);
AdminUserDal.SaveChanges();
//角色
T_SysRoles role = new T_SysRoles();
role.Guid = Guid.NewGuid().ToString("N");
role.Name = "超级管理员";
role.Description = "拥有所有的权限";
role.CreateUser = adminUser.Id;
role.CreateTime = DateTime.Now;
//操作权限
T_SysPermissions permission = new T_SysPermissions();
permission.Guid = Guid.NewGuid().ToString("N");
permission.Type = 1;
permission.Description = "操作权限";
permission.CreateUser = adminUser.Id;
permission.CreateTime = DateTime.Now;
//菜单权限
T_SysPermissions permissionNew = new T_SysPermissions();
permissionNew.Guid = Guid.NewGuid().ToString("N");
permissionNew.Type = 2;
permissionNew.Description = "菜单权限";
permissionNew.CreateUser = adminUser.Id;
permissionNew.CreateTime = DateTime.Now;
var addRole = SysRoleDal.Add(role);
var addPermission = SysPermissionDal.Add(permission);
var addPermissionNew = SysPermissionDal.Add(permissionNew);
//操作权限
SysOperationDal.BatchInsert(list);
var newList = SysOperationDal.GetModels(x => x.Id >= 0).ToList();
AdminUserDal.SaveChanges();
// 3 , 初始化关系
T_UserRoles userRole = new T_UserRoles();
userRole.UserId = addUser.Id;
userRole.RoleId = addRole.Id;
//用户角色
adminUser.T_UserRoles.Add(userRole);
AdminUserDal.SaveChanges();
//操作权限
T_RolePermissions permissions = new T_RolePermissions();
permissions.RoleId = addRole.Id;
permissions.PermissionId = addPermission.Id;
//菜单权限
T_RolePermissions permissionsNew = new T_RolePermissions();
permissionsNew.RoleId = addRole.Id;
permissionsNew.PermissionId = addPermissionNew.Id;
//角色权限
role.T_RolePermissions.Add(permissions);
role.T_RolePermissions.Add(permissionsNew);
List <T_OperatePermissions> addOperatelist = new List <T_OperatePermissions>();
for (int i = 0; i < newList.Count; i++)
{
T_OperatePermissions operate = new T_OperatePermissions();
operate.PermissionId = addPermission.Id;
operate.OperationId = newList[i].Id;
addOperatelist.Add(operate);
}
//权限操作
permission.T_OperatePermissions = addOperatelist;
List <T_MenuPermissions> addMenuOperate = new List <T_MenuPermissions>();
List <T_SysMenus> menuList = new List <T_SysMenus>();
menuList = SysMenuDal.GetModels(X => X.Id >= 0).ToList();
for (int i = 0; i < menuList.Count; i++)
{
T_MenuPermissions menuPermission = new T_MenuPermissions();
menuPermission.MenuId = menuList[i].Id;
menuPermission.PermissionId = addPermissionNew.Id;
addMenuOperate.Add(menuPermission);
}
permission.T_MenuPermissions = addMenuOperate;
AdminUserDal.SaveChanges();
scope.Complete();
}
}
catch (Exception ex)
{
throw;
}
return(null);
}
public int DelData(int rowid)
{
SysRoleDal dal = new SysRoleDal();
return(dal.DelData(rowid));
}
/// <summary>
/// 修改记录
/// 请勿删除
/// </summary>
/// <returns></returns>
public bool UpData(SysRoleModel newModel)
{
SysRoleDal dal = new SysRoleDal();
return(dal.UpData(newModel));
}
public bool InsertData(SysRoleModel newModel)
{
SysRoleDal dal = new SysRoleDal();
return(dal.InsertData(newModel));
}
/// <summary>
/// 删除角色信息
/// </summary>
/// <param name="roleno">角色编号</param>
/// <returns></returns>
public OperateResultModel DeleteRole(string roleno)
{
SysRoleDal dal = new SysRoleDal();
return dal.Delete(roleno);
}
/// <summary>
/// 更新角色信息
/// </summary>
/// <param name="role">角色实体</param>
/// <returns></returns>
public OperateResultModel UpdateRole(sysrole role)
{
SysRoleDal dal = new SysRoleDal();
return dal.Update(role);
}
/// <summary>
/// 插入角色信息
/// </summary>
/// <param name="role">角色实体</param>
/// <returns></returns>
public OperateResultModel InsertRole(sysrole role)
{
SysRoleDal dal = new SysRoleDal();
return dal.Insert(role);
}
/// <summary>
/// 查询角色信息
/// </summary>
/// <returns></returns>
public OperateResultModel QueryRoles()
{
SysRoleDal dal = new SysRoleDal();
return dal.Query();
}
/// <summary>
/// 查询角色信息
/// </summary>
/// <param name="roleno">角色编号</param>
/// <returns></returns>
public sysrole QueryRole(string roleno)
{
SysRoleDal dal = new SysRoleDal();
return dal.Query(roleno);
}
