/// <summary>
/// 分页获取AppUserList
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="name"></param>
/// <param name="count"></param>
/// <returns></returns>
public List <SYS_USERINFO> GetAppUserList(int pageIndex, int pageSize, string name, ref int count)
{
try
{
//查询数据
using (HISDataEntities appEntities = new HISDataEntities())
{
var queryResult = (from a in appEntities.SYS_USERINFO
join b in appEntities.SYS_Department on a.DepartmentID equals b.ID into temp
from b in temp.DefaultIfEmpty()
select new { a, b });
if (!String.IsNullOrEmpty(name))
{
queryResult = queryResult.Where(p => p.a.NAME.Contains(name) || p.a.LoginName.Contains(name));
}
count = queryResult.Count();
if (count < 1)
{
return(new List <SYS_USERINFO>());
}
//分页
queryResult = queryResult.OrderByDescending(p => p.a.ID).Skip((pageIndex - 1) * pageSize).Take(pageSize);
//转换
List <SYS_USERINFO> result = new List <SYS_USERINFO>();
foreach (var item in queryResult)
{
SYS_USERINFO user = new SYS_USERINFO();
user.ID = item.a.ID;
user.NAME = item.a.NAME;
user.Tel = item.a.Tel;
user.Email = item.a.Email;
user.CreateTime = item.a.CreateTime;
user.HeadImg = item.a.HeadImg;
user.LoginName = item.a.LoginName;
user.QQ = item.a.QQ;
user.Position = item.a.Position;
if (item.b == null)
{
user.DepartmentID = 0;
user.DepartmentName = "无部门";
}
else
{
user.DepartmentID = item.b.ID;
user.DepartmentName = item.b.Department;
}
result.Add(user);
}
return(result);
}
}
catch (Exception e)
{
return(null);
}
}
/// <summary>
/// 编辑User
/// </summary>
/// <param name="user"></param>
/// <param name="errMsg"></param>
public void EditUser(SYS_USERINFO user, ref string errMsg)
{
try
{
using (HISDataEntities appEntity = new HISDataEntities())
{
var item = appEntity.SYS_USERINFO.Where(o => o.ID == user.ID).FirstOrDefault();
if (item == null)
{
errMsg = "无此数据";
return;
}
item.NAME = user.NAME;
item.LoginName = user.LoginName;
item.Position = user.Position;
item.QQ = user.QQ;
item.Tel = user.Tel;
item.Email = user.Email;
item.DepartmentID = user.DepartmentID;
item.HeadImg = user.HeadImg;
appEntity.SaveChanges();
}
}
catch (Exception e)
{
errMsg = e.Message;
}
}
/// <summary>
/// 新增用户
/// </summary>
/// <param name="user"></param>
public void AddUser(SYS_USERINFO user, ref string errMsg)
{
try
{
using (HISDataEntities appEntity = new HISDataEntities())
{
//检查重复用户名
IQueryable <SYS_USERINFO> appList = appEntity.SYS_USERINFO.Where(o => o.LoginName == user.LoginName);
if (appList.Count() > 0)
{
errMsg = "用户名已经存在";
return;
}
user.GUID = Guid.NewGuid();
user.PASSWORD = Common.MD5Helper.MD5Encrypt32bit(user.PASSWORD);
appEntity.SYS_USERINFO.Add(user);
//为用户设置默认角色
appEntity.SaveChanges();
}
}
catch (Exception e)
{
errMsg = e.Message;
}
}
public JsonResult SaveUser(SYS_USERINFO user)
{
if (user == null)
{
return(Json(new { result = "error", mesage = "用户数据为空" }));
}
string errMsg = "";
if (user.ID == 0)
{
user.CreateTime = DateTime.Now;
//add
appUserBll.AddUser(user, ref errMsg);
//Common.LogHelper.InsertLog(String.Format("新增用户,ID-{0}", user.ID.ToString()), 43, "后台用户");
}
else
{
//edit
appUserBll.EditUser(user, ref errMsg);
//Common.LogHelper.InsertLog(String.Format("编辑用户,ID-{0}", user.ID.ToString()), 43, "后台用户");
}
var result = new { result = "ok", message = "操作成功" };
if (!string.IsNullOrEmpty(errMsg))
{
result = new { result = "error", message = errMsg };
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public SYS_USERINFO ValidateLogin(SYS_USERINFO info)
{
using (HISDataEntities appEntitys = new HISDataEntities())
{
var pwd = Common.MD5Helper.MD5Encrypt32bit(info.PASSWORD);
var item = appEntitys.SYS_USERINFO.Where(p => p.LoginName == info.LoginName && p.PASSWORD == pwd).FirstOrDefault();
return(item);
}
}
public ActionResult ChangePasswordDlg(int Id)
{
if (Id > 0)
{
SYS_USERINFO user = appUserBll.GetAllAppUserById(Id);
if (user == null)
{
user = new SYS_USERINFO();
}
return(View(user));
}
return(View(new SYS_USERINFO()));
}
public ActionResult LoginUser(SYS_USERINFO info)
{
JsonResult ret = new JsonResult();
SYS_USERINFO findUser = userBLL.ValidateLogin(info);
if (findUser != null)
{
AdminSystemInfo.CurrentUser = findUser;
FormsAuthentication.SetAuthCookie(findUser.LoginName, false);
string url = FormsAuthentication.GetRedirectUrl(findUser.LoginName, false);
ret.Data = new { ifOk = true, url = url };
//获取用户的所有按钮权限列表存放到Session
LoginSuccess(findUser.ID);
//Common.LogHelper.InsertLog("登录成功！");
}
return(ret);
}
/// <summary>
/// 获取所有用户
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public SYS_USERINFO GetAllAppUserById(int id)
{
using (HISDataEntities AppStoreEntity = new HISDataEntities())
{
SYS_USERINFO model = null;
var query = (from a in AppStoreEntity.SYS_USERINFO
join d in AppStoreEntity.SYS_Department on a.DepartmentID equals d.ID into temp
from d in temp.DefaultIfEmpty()
where a.ID == id
select new { a, d }).FirstOrDefault();
if (query == null)
{
return(new SYS_USERINFO());
}
model = new SYS_USERINFO();
model.DepartmentID = query.a.DepartmentID;
model.CreateTime = query.a.CreateTime;
model.Email = query.a.Email;
model.ID = query.a.ID;
model.LoginName = query.a.LoginName;
model.PASSWORD = query.a.PASSWORD;
model.NAME = query.a.NAME;
model.QQ = query.a.QQ;
model.Tel = query.a.Tel;
model.Position = query.a.Position;
model.HeadImg = query.a.HeadImg;
if (query.d != null)
{
model.DepartmentName = query.d.Department;
model.DepartmentNum = query.d.DepartmentNum;
}
else
{
model.DepartmentName = "无部门";
}
return(model);
}
}
