/// <summary> /// 为用户分配角色 /// </summary> /// <param name="roleid">角色id</param> /// <param name="userid">用户id</param> /// <param name="type">类型:1添加;0删除</param> /// <returns></returns> public ActionResult SetSysUserRole(int roleid, int userid, int type) { using (EFContext db = new Repositories.EFContext()) { if (type == 1) { Model.SysUserRole userRole = new Model.SysUserRole() { UserID = userid, RoleID = roleid, UserRoleCreate = DateTime.Now, UserRoleModified = DateTime.Now }; db.SysUserRole.Add(userRole); db.SaveChanges(); } else { var userRole = db.SysUserRole.Where(m => m.UserID == userid && m.RoleID == roleid).FirstOrDefault(); db.SysUserRole.Remove(userRole); db.SaveChanges(); } } return(SuccessResult("修改成功")); }
public ActionResult LoginUser(string username, string userpwd) { using (EFContext db = new Repositories.EFContext()) { var user = db.SysUser.Where(m => m.UserCode == username).FirstOrDefault(); if (user == null) { return(FailResult(1, "系统不存在此用户")); } if (user.UserPwd != Cryptography.MD5Encrypt64(userpwd)) { return(FailResult(1, "密码输入错误")); } } LoggerHelper.Info("登陆系统", username); Response.Cookies.Add(new CookUser(username).Cookies); FormsAuthentication.SetAuthCookie("admin", false); string RefUrl; try { RefUrl = Request.QueryString["ReturnUrl"].Trim().ToLower(); } catch { RefUrl = ""; } if (!string.IsNullOrEmpty(Request.Form["referurl"])) { RefUrl = Request.Form["referurl"].ToLower(); } else { RefUrl = "/"; } return(SuccessResult(RefUrl)); }
/// <summary> /// 编辑菜单功能 /// </summary> /// <returns></returns> public ActionResult SysMenuBarsEdit() { string[] codes = Request.Form["MenuLimitCode"].Split(','); string[] names = Request.Form["MenuLimitName"].Split(','); string[] sorts = Request.Form["MenuLimitSort"].Split(','); string id = Request.Form["id"]; if (codes.Length != names.Length) { return(FailResult(1, "功能代码和功能名称数量不匹配!")); } if (codes.Length != sorts.Length) { return(FailResult(1, "功能代码和排序数量不匹配!")); } int sort = 0; for (int i = 0; i < sorts.Length; i++) { if (!Int32.TryParse(sorts[i], out sort)) { return(FailResult(1, "排序自动只能是数字")); } } using (EFContext db = new Repositories.EFContext()) { var dbContextTransaction = db.Database.BeginTransaction(); try { // 删除菜单权限 db.Database.ExecuteSqlCommand("delete SysRoleMenuLimit where MenuLimitID in (select MenuLimitID from SysMenuLimit where MenuLimitCode <> 'view' and MenuID = {0})", id); db.Database.ExecuteSqlCommand("delete SysMenuLimit where MenuLimitCode <> 'view' and MenuID = {0}", id); for (int i = 0; i < codes.Length; i++) { Model.SysMenuLimit mlModel = new Model.SysMenuLimit() { MenuID = Int32.Parse(id), MenuLimitModified = DateTime.Now, MenuLimitCreate = DateTime.Now, MenuLimitCode = codes[i], MenuLimitName = names[i], MenuLimitSort = Int32.Parse(sorts[i]) }; db.SysMenuLimit.Add(mlModel); } db.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); return(FailResult(1, ex.Message)); } finally { dbContextTransaction.Dispose(); } return(SuccessResult("保存成功")); } }
// GET: Home public ActionResult Index() { using (EFContext db = new Repositories.EFContext()) { var SysRole = db.SysRole.Take(3).ToList(); Json(SysRole, JsonRequestBehavior.AllowGet); return(View()); } }
public ActionResult ChangePwd(int id, string npwd) { using (EFContext db = new Repositories.EFContext()) { var user = db.SysUser.Where(m => m.UserID == id).FirstOrDefault(); user.UserPwd = Cryptography.MD5Encrypt64(npwd); db.SaveChanges(); } return(SuccessResult("密码修改成功")); }
/// <summary> /// 用户角色分配页面 /// </summary> /// <param name="id">用户id</param> /// <returns></returns> public ActionResult SysUserRole(int id) { using (EFContext db = new Repositories.EFContext()) { var Roles = db.SysRole.ToList(); var userRoles = db.SysUserRole.Where(m => m.UserID == id).ToList(); ViewBag.Roles = Roles; ViewBag.userRoles = userRoles; ViewBag.id = id; } return(View()); }
/// <summary> /// 菜单功能页面 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult SysMenuBars(int id) { using (EFContext db = new Repositories.EFContext()) { bool hasBar = db.SysMenuLimit.Where(m => m.MenuID == id && "view".Equals(m.MenuLimitCode)).Any(); if (!hasBar) { AddMenuViewBar(id); } db.Configuration.LazyLoadingEnabled = false;//禁用懒加载 var mlModels = db.SysMenuLimit.Where(m => m.MenuID == id && !"view".Equals(m.MenuLimitCode)).OrderBy(m => m.MenuLimitSort).ToList(); ViewBag.model = mlModels; } ViewBag.id = id; return(View()); }
public ActionResult ChangThisPwd(string npwd, string oldpwd) { string usercode = new cuser().usercode; using (EFContext db = new Repositories.EFContext()) { var user = db.SysUser.Where(m => m.UserCode == usercode).FirstOrDefault(); if (user.UserPwd != Cryptography.MD5Encrypt64(oldpwd)) { return(FailResult(1, "原始密码输入错误")); } user.UserPwd = Cryptography.MD5Encrypt64(npwd); db.SaveChanges(); } return(SuccessResult("密码修改成功,请重新登陆")); }
/// <summary> /// 给菜单添加查看权限的bar /// 当新增一个菜单的时候,给菜单添加一个查询的功能。 /// </summary> /// <param name="id"></param> protected void AddMenuViewBar(int id) { using (EFContext db = new Repositories.EFContext()) { Model.SysMenuLimit limit = new Model.SysMenuLimit() { MenuID = id, MenuLimitModified = DateTime.Now, MenuLimitCreate = DateTime.Now, MenuLimitCode = "view", MenuLimitName = "查看", MenuLimitSort = 0 }; db.SysMenuLimit.Add(limit); db.SaveChanges(); } }