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