/// <summary>
/// 分页获取用户列表
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="realName">真名</param>
/// <param name="pageStar">开始条数</param>
/// <param name="pageSize">每页条数</param>
/// <param name="sortCol">排序字段</param>
/// <param name="sortDir">排序方式</param>
/// <param name="total">总共用户条数</param>
/// <returns>用户列表</returns>
public List <User> GetPageUsers(string realName, string userName, int pageStar, int pageSize, int sortCol, string sortDir, out int total)
{
using (AuthentContext db = new AuthentContext())
{
IQueryable <User> users = db.User;
if (!string.IsNullOrEmpty(realName))
{
users = users.Where(user => user.RealName.Contains(realName));
}
if (!string.IsNullOrEmpty(userName))
{
users = users.Where(user => user.UserName.Contains(userName));
}
total = db.User.Count();
if (sortCol == 1)
{
if (sortDir == "asc")
{
users = users.OrderBy(u => u.RealName);
}
else
{
users = users.OrderByDescending(u => u.RealName);
}
}
else
{
users = users.OrderByDescending(u => u.Id);
}
return(users.Skip(pageStar).Take(pageSize).ToList());
}
}
/// <summary>
/// 保存用户
/// </summary>
/// <param name="userIn">用户实体</param>
public void SaveUser(User userIn)
{
userIn.PassWord = Base64(userIn.PassWord);
using (AuthentContext db = new AuthentContext())
{
if (userIn.Id == 0)
{
db.User.Add(userIn);
}
else
{
User user = new User();
user = db.User.Where(u => u.Id == userIn.Id).FirstOrDefault();
user.UserName = userIn.UserName;
user.Id = userIn.Id;
user.PassWord = userIn.PassWord;
user.Phone = userIn.Phone;
user.Age = userIn.Age;
user.Email = userIn.Email;
user.MobilePhone = userIn.MobilePhone;
user.RealName = userIn.RealName;
user.Sex = userIn.Sex;
user.LastChangeTime = userIn.LastChangeTime;
user.LastChangeUser = userIn.LastChangeUser;
user.Status = userIn.Status;
user.UserName = userIn.UserName;
user.UserName = userIn.UserName;
}
db.SaveChanges();
}
}
/// <summary>
/// 通过id获取一条数据字典主表信息
/// </summary>
/// <param name="id">数据字典主表ID</param>
/// <returns></returns>
public MainDictionary GetMainDictioById(int id)
{
using (AuthentContext db = new AuthentContext())
{
return(db.MainDictionary.Where(m => m.Id == id).FirstOrDefault());
}
}
/// <summary>
/// 登录验证
/// </summary>
/// <param name="userLogin">登陆的用户</param>
/// <returns></returns>
public User IsValid(User userLogin)
{
if (string.IsNullOrEmpty(userLogin.UserName) || string.IsNullOrEmpty(userLogin.PassWord))
{
return(null);
}
else
{
using (AuthentContext db = new AuthentContext())
{
int userCount = db.User.Count();
//如果用户表没有用户，则新增一名用户
if (userCount == 0)
{
db.User.Add(new User
{
UserName = "******",
PassWord = Base64("admin"),
RealName = "admin",
MobilePhone = "13243211111",
Email = "*****@*****.**",
LastChangeUser = 0,
LastChangeTime = DateTime.Now,
});
db.SaveChanges();
}
string base64Pass = Base64(userLogin.PassWord);
User user = db.User.Where(u => u.UserName == userLogin.UserName && u.PassWord == base64Pass)
.FirstOrDefault();
return(user);
}
}
}
/// <summary>
/// 返回数据字典主表数据
/// </summary>
/// <returns>数据字典主表List</returns>
public List <MainDictionary> GetAllDiction()
{
using (AuthentContext db = new AuthentContext())
{
return(db.MainDictionary.ToList());
}
}
/// <summary>
/// 通过Id获取用户
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public User GetUserById(int id)
{
using (AuthentContext db = new AuthentContext())
{
return(db.User.Where(u => u.Id == id).FirstOrDefault());
}
}
/// <summary>
/// 返回子模块
/// </summary>
/// <param name="parentId">模块父ID</param>
/// <returns>模块列表</returns>
public List <Module> GetSonModule(int parentId)
{
using (AuthentContext db = new AuthentContext())
{
return(db.Module.Where(m => m.ParentId == parentId).ToList());
}
}
/// <summary>
/// 返回模块数据
/// </summary>
/// <returns>模块List</returns>
public List <Module> GetAllModule()
{
using (AuthentContext db = new AuthentContext())
{
return(db.Module.ToList());
}
}
/// <summary>
/// 保存模块
/// </summary>
/// <param name="module">模块实体</param>
public void SaveModule(Module module)
{
using (AuthentContext db = new AuthentContext())
{
if (module.Id == 0)
{
db.Module.Add(module);
}
else
{
Module mod;
mod = db.Module.Where(m => m.Id == module.Id).FirstOrDefault();
if (mod != null)
{
mod.ChineseName = module.ChineseName;
mod.Description = module.Description;
mod.EnglishName = module.EnglishName;
mod.LastChangeTime = module.LastChangeTime;
mod.LastChangeUser = module.LastChangeUser;
mod.NavigatePicture = module.NavigatePicture;
mod.IsDisplay = module.IsDisplay;
mod.Status = module.Status;
mod.Icon = module.Icon;
mod.Order = module.Order;
mod.Url = module.Url;
mod.ParentId = module.ParentId;
}
}
db.SaveChanges();
}
}
/// <summary>
/// 通过id获取一条模块信息
/// </summary>
/// <param name="id">模块ID</param>
/// <returns></returns>
public Module GetModuleById(int id)
{
using (AuthentContext db = new AuthentContext())
{
return(db.Module.Where(m => m.Id == id).FirstOrDefault());
}
}
/// <summary>
/// 返回所有的角色
/// </summary>
/// <returns>角色列表</returns>
public List <Role> GetAllRole()
{
using (AuthentContext db = new AuthentContext())
{
return(db.Role.ToList());
}
}
/// <summary>
/// 返回所有的用户
/// </summary>
/// <returns>用户列表</returns>
public List <User> GetAllUser()
{
using (AuthentContext db = new AuthentContext())
{
return(db.User.ToList());
}
}
/// <summary>
/// 通过Id获取角色
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Role GetRoleById(int id)
{
using (AuthentContext db = new AuthentContext())
{
return(db.Role.Where(u => u.Id == id).FirstOrDefault());
}
}
/// <summary>
/// 删除一个数据字典项
/// </summary>
/// <param name="id">数据字典主表ID</param>
public void DeleteDic(int id)
{
using (AuthentContext db = new AuthentContext())
{
Dictionary dic = db.Dictionary.Where(m => m.Id == id).FirstOrDefault();
db.Dictionary.Remove(dic);
db.SaveChanges();
}
}
/// <summary>
/// 删除一个模块信息
/// </summary>
/// <param name="id">模块ID</param>
public void DeleteMain(int id)
{
using (AuthentContext db = new AuthentContext())
{
Module mainDic = db.Module.Where(m => m.Id == id).FirstOrDefault();
db.Module.Remove(mainDic);
db.SaveChanges();
}
}
/// <summary>
/// 检查角色名是否可(true:是，false:否)
/// </summary>
/// <param name="roleName">角色名</param>
/// <param name="id">角色ID</param>
/// <returns></returns>
public bool CheckRoleName(string roleName, int id)
{
using (AuthentContext db = new AuthentContext())
{
var role = db.Role.FirstOrDefault(u => u.RoleName == roleName);
if (role != null)
{
return(role.Id == id);
}
return(true);
}
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="id">用户ID</param>
/// <returns></returns>
public void Delete(int id)
{
using (AuthentContext db = new AuthentContext())
{
User user = db.User.Where(u => u.Id == id).FirstOrDefault();
if (user != null)
{
db.User.Remove(user);
db.SaveChanges();
}
}
}
/// <summary>
/// 检查模块名是否可用
/// </summary>
/// <param name="moduleName">模块名字</param>
/// <param name="id">当前模块的ID</param>
/// <returns></returns>
public bool CheckModuleName(string moduleName, int id)
{
using (AuthentContext db = new AuthentContext())
{
var module = db.Module.FirstOrDefault(mod => mod.ChineseName == moduleName);
if (module != null)
{
return(module.Id == id);
}
return(true);
}
}
/// <summary>
/// 检查用户名是否可(true:是，false:否)
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="id">用户ID</param>
/// <returns></returns>
public bool CheckUserName(string userName, int id)
{
using (AuthentContext db = new AuthentContext())
{
var user = db.User.FirstOrDefault(u => u.UserName == userName);
if (user != null)
{
return(user.Id == id);
}
return(true);
}
}
/// <summary>
/// 删除角色
/// </summary>
/// <param name="id">角色ID</param>
/// <returns></returns>
public void Delete(int id)
{
using (AuthentContext db = new AuthentContext())
{
Role role = db.Role.Where(u => u.Id == id).FirstOrDefault();
if (role != null)
{
db.Role.Remove(role);
db.SaveChanges();
}
}
}
/// <summary>
/// 获取一个角色的所有用户Id
/// </summary>
/// <param name="id">角色ID</param>
/// <returns>角色的用户Id列表</returns>
public List <int> GetRoleUser(int id)
{
using (AuthentContext db = new AuthentContext())
{
var roleUsers = db.UserRole.Where(ur => ur.RoleId == id).ToList();
List <int> users = new List <int>();
foreach (var roleUser in roleUsers)
{
users.Add(roleUser.UserId);
}
return(users);
}
}
/// <summary>
/// 获取一个模块的所有角色Id
/// </summary>
/// <param name="id">模块ID</param>
/// <returns>模块角色Id列表</returns>
public List <int> GetModuleRole(int id)
{
using (AuthentContext db = new AuthentContext())
{
var moduleRoles = db.RoleModule.Where(ur => ur.ModuleId == id).ToList();
List <int> roles = new List <int>();
foreach (var moduleRole in moduleRoles)
{
roles.Add(moduleRole.RoleId);
}
return(roles);
}
}
/// <summary>
/// 获取一个用户的所有角色Id
/// </summary>
/// <param name="id">用户ID</param>
/// <returns>用户的角色Id列表</returns>
public List <int> GetUserRole(int id)
{
using (AuthentContext db = new AuthentContext())
{
var userRoles = db.UserRole.Where(ur => ur.UserId == id).ToList();
List <int> roles = new List <int>();
foreach (var userRole in userRoles)
{
roles.Add(userRole.RoleId);
}
return(roles);
}
}
/// <summary>
/// 分页获取角色列表
/// </summary>
/// <param name="name">角色名</param>
/// <param name="pageStar">开始条数</param>
/// <param name="pageSize">每页条数</param>
/// <param name="sortCol">排序字段</param>
/// <param name="sortDir">排序方式</param>
/// <param name="total">总共角色条数</param>
/// <returns>角色列表</returns>
public List <Role> GetPageRoles(string name, int pageStar, int pageSize, int sortCol, string sortDir, out int total)
{
using (AuthentContext db = new AuthentContext())
{
IQueryable <Role> roles = db.Role;
if (!string.IsNullOrEmpty(name))
{
roles = roles.Where(role => role.RoleName.Contains(name));
}
total = db.Role.Count();
if (sortCol == 0)
{
roles = sortDir == "asc" ? roles.OrderBy(u => u.RoleName) : roles.OrderByDescending(u => u.RoleName);
}
else
{
roles = roles.OrderByDescending(u => u.Id);
}
return(roles.Skip(pageStar).Take(pageSize).ToList());
}
}
/// <summary>
/// 获取数据字典项列表
/// </summary>
/// <param name="id">所属数据字典ID</param>
/// <param name="pageStart">开始条数</param>
/// <param name="pageSize">每页条数</param>
/// <param name="sortCol">排序字段</param>
/// <param name="sortDir">排序方式</param>
/// <param name="total">总共用户条数</param>
/// <returns></returns>
public List <Dictionary> GetPageDictions(int id, int pageStart, int pageSize, int sortCol, string sortDir, out int total)
{
using (AuthentContext db = new AuthentContext())
{
IQueryable <Dictionary> dictionaries = db.Dictionary.Where(d => d.MainDictionaryId == id);
total = dictionaries.Count();
if (total != 0)
{
if (sortCol == 2 && sortDir == "desc")
{
dictionaries = dictionaries.OrderByDescending(d => d.Order);
}
else
{
dictionaries = dictionaries.OrderBy(d => d.Order);
}
return(dictionaries.Skip(pageStart).Take(pageSize).ToList());
}
return(dictionaries.OrderBy(d => d.Order).Skip(pageStart).Take(pageSize).ToList());
}
}
/// <summary>
/// 保存数据字典主表
/// </summary>
/// <param name="mainDic">数据字典主表实体</param>
public void SaveMainDiction(MainDictionary mainDic)
{
using (AuthentContext db = new AuthentContext())
{
if (mainDic.Id == 0)
{
db.MainDictionary.Add(mainDic);
}
else
{
MainDictionary mainDiction = new MainDictionary();
mainDiction = db.MainDictionary.Where(m => m.Id == mainDic.Id).FirstOrDefault();
mainDiction.ChineseName = mainDic.ChineseName;
mainDiction.Description = mainDic.Description;
mainDiction.EnglishName = mainDic.EnglishName;
mainDiction.LastChangeTime = mainDic.LastChangeTime;
mainDiction.LastChangeUser = mainDic.LastChangeUser;
mainDiction.ReadOnly = mainDic.ReadOnly;
}
db.SaveChanges();
}
}
/// <summary>
/// 保存数据字典项
/// </summary>
/// <param name="diction">数据字典主表实体</param>
public void SaveDiction(Dictionary diction)
{
using (AuthentContext db = new AuthentContext())
{
if (diction.Id == 0)
{
db.Dictionary.Add(diction);
}
else
{
Dictionary dictionary = db.Dictionary.Where(d => d.Id == diction.Id).FirstOrDefault();
dictionary.ChineseName = diction.ChineseName;
dictionary.Description = diction.Description;
dictionary.EnglishName = diction.EnglishName;
dictionary.LastChangeTime = diction.LastChangeTime;
dictionary.LastChangeUser = diction.LastChangeUser;
dictionary.Order = diction.Order;
dictionary.Status = diction.Status;
dictionary.MainDictionaryId = diction.MainDictionaryId;
}
db.SaveChanges();
}
}
/// <summary>
/// 保存角色
/// </summary>
/// <param name="roleIn">角色实体</param>
public void SaveRole(Role roleIn)
{
using (AuthentContext db = new AuthentContext())
{
if (roleIn.Id == 0)
{
db.Role.Add(roleIn);
}
else
{
Role role = new Role();
role = db.Role.Where(u => u.Id == roleIn.Id).FirstOrDefault();
if (role != null)
{
role.RoleName = roleIn.RoleName;
role.Description = roleIn.Description;
role.Code = roleIn.Code;
role.LastChangeTime = roleIn.LastChangeTime;
role.LastChangeUser = roleIn.LastChangeUser;
}
}
db.SaveChanges();
}
}
/// <summary>
/// 保存选择的角色
/// </summary>
/// <param name="roleIds">角色数组</param>
/// <param name="moduleId">当前模块ID</param>
/// <param name="changeUser">修改人ID</param>
public void SaveModuleRoles(List <int> roleIds, int moduleId, int changeUser)
{
using (AuthentContext db = new AuthentContext())
{
//先要删除这个模块的角色
var roles = db.RoleModule.Where(rm => rm.ModuleId == moduleId);
db.RoleModule.RemoveRange(roles);
//再重新保存
List <RoleModule> roleModels = new List <RoleModule>();
foreach (var roleId in roleIds)
{
RoleModule roleModel = new RoleModule();
roleModel.ModuleId = moduleId;
roleModel.RoleId = roleId;
roleModel.LastChangeTime = DateTime.Now;
roleModel.LastChangeUser = changeUser;
roleModels.Add(roleModel);
}
db.RoleModule.AddRange(roleModels);
db.SaveChanges();
}
}
/// <summary>
/// 保存选择的角色
/// </summary>
/// <param name="roleIds">角色数组</param>
/// <param name="userId">用户ID</param>
/// <param name="changeUser">修改人ID</param>
public void SaveUserRoles(List <int> roleIds, int userId, int changeUser)
{
using (AuthentContext db = new AuthentContext())
{
//先要删除这个用户的角色
var roles = db.UserRole.Where(ur => ur.UserId == userId);
db.UserRole.RemoveRange(roles);
//再重新保存
List <UserRole> userRoles = new List <UserRole>();
foreach (var roleId in roleIds)
{
UserRole userRole = new UserRole();
userRole.UserId = userId;
userRole.RoleId = roleId;
userRole.LastChangeTime = DateTime.Now;
userRole.LastChangeUser = changeUser;
userRoles.Add(userRole);
}
db.UserRole.AddRange(userRoles);
db.SaveChanges();
}
}