public AjaxMsgModel Edit(VIEW_SYS_USER data)
{
AjaxMsgModel amm = new Message().NewAmm;
try
{
SYS_USER member = oc.BllSession.ISYS_USERService.Entities.Where(m => m.USER_NAME == data.USER_NAME).OrderBy(m => m.USER_NAME).FirstOrDefault();
if (member != null)
{
Mapper.CreateMap <SYS_USER, VIEW_SYS_USER>();
VIEW_SYS_USER vm = Mapper.Map <SYS_USER, VIEW_SYS_USER>(member);
vm.ISUP_FLAG_EXT = "edit";
List <string> listRoleId = oc.BllSession.ISYS_USER_ROLE_MAPService.Entities.Where(u => u.USER_NAME == data.USER_NAME).Select(u => u.ROLE_ID).ToList();
vm.ROLE_EXT = listRoleId;
amm.Statu = AjaxStatu.ok;
amm.Data = vm;
return(amm);
}
else
{
amm.Msg = string.Format(Message.NotFound, "用户");
return(amm);
}
}
catch (Exception)
{
return(amm);
}
}
[HttpPost]//查询
public ViewModel List(VIEW_SYS_USER data)
{
int pageSize = int.Parse(data.rows);
int pageIndex = int.Parse(data.page);
string sort = data.sort;
string order = data.order;
//查询条件
Expression <Func <SYS_USER, bool> > slamda = u => u.DEPT_CODE.StartsWith(oc.CurrentUser.SYS_DEPT.DEPT_CODE);
if (data.DEPT_CODE != null && data.DEPT_CODE != "")
{
slamda = u => u.DEPT_CODE.StartsWith(data.DEPT_CODE);
}
int total = 0;
total = oc.BllSession.ISYS_USERService.Entities.Where(slamda).Count();
var listMenus = oc.BllSession.ISYS_USERService.Entities.Include("SYS_USER_ROLE_MAP").Where(slamda).OrderBy(u => u.DEPT_CODE)
.Skip(pageSize * (pageIndex - 1)).Take(pageSize).Select(mb =>
new
{
deptcode = mb.DEPT_CODE,
deptname = mb.SYS_DEPT.DEPT_NAME,
depticon = mb.SYS_DEPT.C_ICO,
username = mb.USER_NAME,
zsname = mb.ZSNAME,
uptime = mb.UPDATE_DATE,
upuser = mb.UPDATE_USER,
mb.SYS_USER_ROLE_MAP
}
).ToList();
List <UserRoleModel> listMenu = new List <UserRoleModel>();
foreach (var item in listMenus)
{
string rolename = string.Empty;
foreach (var itemx in item.SYS_USER_ROLE_MAP)
{
if (rolename != "")
{
rolename += ",";
}
rolename += itemx.SYS_ROLE.NAME;
}
listMenu.Add(new UserRoleModel
{
deptcode = item.deptcode,
deptname = item.deptname,
USER_NAME = item.username,
ZSNAME = item.zsname,
uptime = item.uptime,
upuser = item.upuser,
rolename = rolename,
depticon = item.depticon
});
}
return(ObjToJson.ViewModelToJson(listMenu, total));
}
public AjaxMsgModel Del(VIEW_SYS_USER data)
{
return(Model_SYS_USER.Del(data.USER_NAME));
}
public AjaxMsgModel Save(VIEW_SYS_USER data)
{
try
{
if (!string.IsNullOrEmpty(data.MANAGE_DEPT_CODE) && data.MANAGE_DEPT_CODE != "null")
{
if (oc.BllSession.ISYS_DEPTService.Entities.Where(o => o.DEPT_CODE == data.MANAGE_DEPT_CODE && o.DEPT_FLAG == 1).Count() == 0)
{
AjaxMsgModel amm = new Message().NewAmm;
amm.Statu = AjaxStatu.err;
amm.Msg = "用户所在部门选择不正确！";
return(amm);
}
}
Mapper.CreateMap <VIEW_SYS_USER, SYS_USER>();
SYS_USER u = Mapper.Map <VIEW_SYS_USER, SYS_USER>(data);
string role_id = "";
if (data.ROLE_EXT.Count > 0)
{
role_id = data.ROLE_EXT[0];
}
List <SYS_USER_ROLE_MAP> listRole = new List <SYS_USER_ROLE_MAP>();
if (!string.IsNullOrEmpty(role_id) && role_id != "null")
{
string[] roleid = role_id.Split(',');
for (int i = 0; i < roleid.Length; i++)
{
listRole.Add(
new SYS_USER_ROLE_MAP()
{
ROLE_ID = roleid[i],
USER_NAME = data.USER_NAME,
USER_ROLE_ID = DateTime.Now.ToString("yyyyMMddHHmmssfff") + i.ToString()
}
);
}
}
if (u.PASSWORD != null)
{
u.PASSWORD = DataHelper.TOMD5(u.PASSWORD);
}
else
{
u.PASSWORD = "";
}
u.UPDATE_DATE = DateTime.Now;
u.UPDATE_USER = oc.CurrentUser.USER_NAME;
u.SYS_USER_ROLE_MAP = listRole;
if (data.ISUP_FLAG_EXT == null || data.ISUP_FLAG_EXT == "")
{
return(Model_SYS_USER.Add(u));
}
else
{
return(Model_SYS_USER.Edit(u, u.PASSWORD));
}
}
catch (Exception)
{
return(new Message().NewAmm);
}
}
