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