public void Update(RoleDb model, List <RoleModuleRelationDb> roleModuleRelations) { using (var db = PermissionDal.DbContext) { using (var dbContextTransaction = PermissionDal.DbContext.Database.BeginTransaction()) //起一个事务 { try { RoleDb tempModel = PermissionDal.GetModel(c => c.role_id == model.role_id); ModelCopier.CopyModel(model, tempModel, "creator_name", "creator_full_name", "creator_time"); PermissionDal.EditData(tempModel); PermissionDal.DbContext.Database.ExecuteSqlCommand(" delete from role_module_relation where role_id=@p0 ", model.role_id); PermissionDal.AddList(roleModuleRelations); PermissionDal.DbContext.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); } finally { PermissionDal.DbContextDispose(); } } } }
public int Add(RoleDb model, List <RoleModuleRelationDb> roleModuleRelations) { using (var dbContextTransaction = PermissionDal.DbContext.Database.BeginTransaction()) //起一个事务 { try { PermissionDal.Add(model); PermissionDal.DbContext.SaveChanges(); if (roleModuleRelations != null) { foreach (var r in roleModuleRelations) { r.creator_name = model.creator_name; r.creator_date = model.creator_date; r.role_id = model.role_id; PermissionDal.Set <RoleModuleRelationDb>().Add(r); } } PermissionDal.DbContext.SaveChanges(); dbContextTransaction.Commit(); return(model.role_id); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } }
public void Update(AdminUserDb model, string roleIds) { //AdminUserDb dbModel = PermissionDal.GetModel(c => c.user_name == model.user_name); //ModelCopier.CopyModel(model, dbModel); List <AdminUserRoleRelationDb> aurrList = GetAdminUserRoleRelationList(roleIds, model.user_name); using (var db = PermissionDal.DbContext) { using (var dbContextTransaction = db.Database.BeginTransaction()) //起一个事务 { try { PermissionDal.EditData(model); PermissionDal.DbContext.Database.ExecuteSqlCommand(" delete from admin_user_role_relation where user_name=@p0;", model.user_name); // PermissionDal.Set<AdminUserRoleRelationDb>().RemoveRange(aurrList); if (aurrList != null && aurrList.Count > 0) { PermissionDal.AddList(aurrList); } db.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); } } } PermissionDal.DbContextDispose(); }
public void Update(DictionaryTypeTableDb model) { DictionaryTypeTableDb tempModel = PermissionDal.GetModel(c => c.dt_type_key == model.dt_type_key); ModelCopier.CopyModel(model, tempModel, "creator_name", "creator_date"); PermissionDal.SaveChanges(); }
/// <summary> /// 获取用户对应的角色列表 /// </summary> /// <param name="userName">用户名</param> /// <returns></returns> public IQueryable <RoleDb> GetRoleDbList(string userName) { IQueryable <int> roleIds = PermissionDal.Set <AdminUserRoleRelationDb>().Where(c => c.user_name == userName).Select(c => c.role_id); return(PermissionDal.Where(c => roleIds.Contains(c.role_id))); }
public void Update(ModuleDb model) { ModuleDb tempModel = PermissionDal.GetModel(c => c.module_code == model.module_code); ModelCopier.CopyModel(model, tempModel, "parent_code", "module_level", "creator_name", "creator_date"); PermissionDal.SaveChanges(); }
/// <summary> /// 角色管理页面 /// </summary> /// <returns></returns> public ActionResult RoleManage() { //删除角色 //接收角色id if (Request["num"] != null) { int id = Convert.ToInt32(Request["num"]); //根据角色id查询“员工角色表”此角色有无员工担当 Employee_RoleInfo er = dal.GetEmployee_RoleInfoByRoleID(id); if (er != null) { return(Content("0")); } else { //根据角色id删除角色 bool isDel = dal.DelRoleByRoleID(id); if (isDel) { return(Content("1")); } } } //查询所有员工 EmployeeDal emdal = new EmployeeDal(); List <EmployeeInfo> emlist = emdal.GetAllEmployeer(); //查询所有权限(查询菜单栏) PermissionDal pd = new PermissionDal(); List <PermissionInfo> perslist = pd.GetAll(); //查询所有角色 List <RoleInfo> roles = dal.GetRoles(); ViewBag.emlist = emlist; ViewBag.roles = roles; int? RoleID = Convert.ToInt32(Request["RoleID"]); string RoleName = Request["RoleName"]; if (RoleName != null) { Session["RoleName"] = RoleName; } if (RoleID != 0) { Session["RoleID"] = RoleID; List <RoleInfo_PermissionInfo> persByRoID = dal.GetPerByRoleID(RoleID); List <PermissionInfo> NotPerByRoId = dal.GetNotPerByRoId(RoleID); ViewBag.persByRoID = persByRoID; ViewBag.NotPerByRoId = NotPerByRoId; ViewBag.perslist = perslist; } return(View()); }
/// <summary> /// 用户登录后,修改其因登录而产生的变化 /// </summary> /// <param name="user"></param> public void UpdateUserLogin(AdminUserDb user) { AdminUserDb model = PermissionDal.GetModel(c => c.user_name == user.user_name); model.last_lgoin_date = user.last_lgoin_date; model.last_login_ip = user.last_login_ip; PermissionDal.DbContext.SaveChanges(); }
public void UpdateUserPassWord(string userName, string passWord) { AdminUserDb user = PermissionDal.GetModel(c => c.user_name == userName); user.user_name = userName; user.pass_word = Library.Tools.Text.StringMd5.Md5Hash32Salt(passWord); PermissionDal.DbContext.SaveChanges(); }
public void Add(AdminUserDb model, string roleIds) { model.AdminUserRoleRelations = GetAdminUserRoleRelationList(roleIds, model.user_name); model.pass_word = Library.Tools.Text.StringMd5.Md5Hash32Salt(model.pass_word); model.creator_name = GetLoginUser().user_name; model.creator_date = DateTime.Now; PermissionDal.Add(model); }
/// <summary> /// 获取用户对应的有权限的活动的模块 /// </summary> /// <param name="userName">用户名</param> /// <returns></returns> public IQueryable <ModuleDb> GetModuleList(string userName) { IQueryable <int> roleIds = RoleBll.Instance.GetRoleDbList(userName).Select(c => c.role_id); IQueryable <string> moduleCodes = PermissionDal.Set <RoleModuleRelationDb>() .Where(c => roleIds.Contains(c.role_id)).Select(c => c.module_code); return(PermissionDal.Where(c => moduleCodes.Contains(c.module_code) && c.module_status == (int)Model.Common.GlobalCode.CommonStatus.Active) .OrderBy(c => c.order_by)); }
/// <summary> /// 权限管理页面 /// </summary> /// <returns></returns> public ActionResult PermissionManage() { //查询所有员工 EmployeeDal emdal = new EmployeeDal(); List <EmployeeInfo> emlist = emdal.GetAllEmployeer(); ViewBag.emlist = emlist; //查询所有权限(查询菜单栏) PermissionDal pd = new PermissionDal(); List <PermissionInfo> all = pd.GetAll(); ViewBag.all = all; return(View()); }
/// <summary> ///获取所有的模块,以Ztree可以识别的Ztree格式返回,并且根据角色权限设置对应模块为选中状态 /// <param name="id">角色id</param> /// <returns></returns> public string GetModuleMacheRoleTree(int id) { List <LevelModuleViewModel> moduleList = GetLevelMudleListIsArrayAll().Where(c => c.module_status == 1).ToList(); List <JsonZtree> jsonZtreeList = ZtreeManage.IniJsonZtreeList(moduleList, moduleList); if (id > 0) { List <RoleModuleRelationDb> list = PermissionDal.Set <RoleModuleRelationDb>() .Where(c => c.role_id == id).ToList(); foreach (var m in jsonZtreeList) { if (list.FirstOrDefault(c => c.module_code == m.id) != null) { m.Checked = "true"; m.open = "true"; } } } return(ZtreeManage.GetZtreeJson(jsonZtreeList)); }
/// <summary> /// 根据员工Id查询角色Id /// </summary> /// <returns>返回查询到的角色ID</returns> /// public void GetPerId() { //获取员工Id //接收被授权员工的id int?emerid = Convert.ToInt32(Request["Id"]); //实例员工角色对象 PermissionDal dal = new PermissionDal(); //获取对象 Employee_RoleInfo emr = dal.GetRoleByID(emerid); //获取角色Id int?RoleID = Convert.ToInt32(emr.RoleID); //返回查询到的角色id Response.Write(RoleID); Response.End(); }
/// <summary> /// 获取制定code的模块 /// </summary> /// <param name="code"></param> /// <returns></returns> public ModuleDb GetModule(string code) { return(PermissionDal.GetModel(c => c.module_code == code)); }
/// <summary> /// 构造 /// </summary> public BasePermissionBll() { //创建权限dal _PermissionDal = new PermissionDal <T>(); }
public void Add(DictionaryTypeTableDb model) { PermissionDal.Add(model); }
/// <summary> /// 分页方法 /// </summary> /// <param name="m">搜索模型</param> /// <returns></returns> public PagedList <RoleDb> GetRoleDbPageList(SearchModel m) { return(PermissionDal.Set <RoleDb>().Where(m).Pager(m)); }
public List <DictionaryTypeTableDb> GetAllList() { return(PermissionDal.GetAllList().ToList());; }
/// <summary> /// 分页方法 /// </summary> /// <param name="m">搜索模型</param> /// <returns></returns> public PagedList <DictionaryTypeTableDb> GetPageList(SearchModel m) { return(PermissionDal.Set <DictionaryTypeTableDb>().Where(m).Pager(m)); }
/// <summary> /// 获取指定用户名的用户 /// </summary> /// <param name="userName"></param> /// <returns></returns> public DictionaryTypeTableDb GetModel(string key) { return(PermissionDal.GetModel(c => c.dt_type_key == key)); }
/// <summary> /// 分页方法 /// </summary> /// <param name="m">搜索模型</param> /// <returns></returns> public PagedList <AdminUserDb> GetPageList(SearchModel m) { return(PermissionDal.Set <AdminUserDb>().Where(m).Pager(m)); }
public RoleDb GetModel(int id) { return(PermissionDal.GetById(id)); }
public void Add(ModuleDb model) { PermissionDal.Add(model); }
/// <summary> /// 获取指定用户名的用户 /// </summary> /// <param name="userName"></param> /// <returns></returns> public AdminUserDb GetModel(string userName) { return(PermissionDal.GetModel(c => c.user_name == userName)); }
/// <summary> /// 获取所有的模块 /// </summary> /// <returns></returns> public IQueryable <ModuleDb> GetMouduleListAll() { return(PermissionDal.Set <ModuleDb>().OrderBy(c => c.order_by)); }
/// <summary> /// 获取指定类别key下面的有效字典 /// </summary> /// <param name="dtTypeKey"></param> /// <returns></returns> public List <DictionaryTableDb> GetListInDtType(string dtTypeKey) { return(PermissionDal.Where(c => c.dt_type_key == dtTypeKey && c.dt_status == (int)CommonStatus.Active).OrderBy(c => c.dt_orderby).ToList()); }
/// <summary> /// 获取对应url的模块 /// </summary> /// <param name="url"></param> /// <returns></returns> public ModuleDb GetModuleOnUrl(string url) { return(PermissionDal.GetModel(c => c.action_url.ToUpper() == url.ToUpper())); }
public List <RoleDb> GetRoleListAll() { return(PermissionDal.Where(c => true).ToList()); }