public AjaxMsgModel Edit(VIEW_SYS_MEMBER data)
{
AjaxMsgModel amm = new Message().NewAmm;
try
{
SYS_MEMBER member = oc.BllSession.ISYS_MEMBERService.Entities.Where(m => m.DEL_FLAG == "0" && m.MEMBER_ID == data.MEMBER_ID).OrderBy(m => m.UPDATE_DATE).FirstOrDefault();
if (member != null)
{
Mapper.CreateMap <SYS_MEMBER, VIEW_SYS_MEMBER>();
VIEW_SYS_MEMBER vm = Mapper.Map <SYS_MEMBER, VIEW_SYS_MEMBER>(member);
vm.LOCATION_FLAG_EXT = vm.LOCATION_FLAG == "1" ? true : false;
amm.Statu = AjaxStatu.ok;
amm.Data = vm;
return(amm);
}
else
{
amm.Msg = string.Format(Message.NotFound, "人员");
return(amm);
}
}
catch (Exception)
{
return(amm);
}
}
public AjaxMsgModel Save(VIEW_SYS_MEMBER data)
{
try
{
Mapper.CreateMap <VIEW_SYS_MEMBER, SYS_MEMBER>();
SYS_MEMBER u = Mapper.Map <VIEW_SYS_MEMBER, SYS_MEMBER>(data);
u.UPDATE_DATE = DateTime.Now;
u.UPDATE_USER = oc.CurrentUser.USER_NAME;
u.DEL_FLAG = "0";
u.LOCATION_FLAG = data.LOCATION_FLAG_EXT ? "1" : "0";
if (u.MEMBER_ID == null || u.MEMBER_ID == "")
{
u.MEMBER_ID = DateTime.Now.ToString("yyyyMMddHHmmssfff");
u.MOBILE_STATE = "0";//新增手机默认正常状态
return(Model_SYS_MEMBER.Add(u));
}
else
{
return(Model_SYS_MEMBER.Edit(u));
}
}
catch (Exception)
{
return(new Message().NewAmm);
}
}
public AjaxMsgModel WirteExcel(VIEW_SYS_MEMBER data)
{
AjaxMsgModel amm = new Message().NewAmm;
//查询条件
IQueryable <SYS_MEMBER> SYS_MEMBEREntity = oc.BllSession.ISYS_MEMBERService.Entities;
if (data.DEPT_CODE != null && data.DEPT_CODE != "")
{
SYS_MEMBEREntity = SYS_MEMBEREntity.Where(u => u.DEPT_CODE.StartsWith(data.DEPT_CODE) && u.DEL_FLAG == "0");
}
else
{
SYS_MEMBEREntity = SYS_MEMBEREntity.Where(u => u.DEPT_CODE.StartsWith(oc.CurrentUser.SYS_DEPT.DEPT_CODE) && u.DEL_FLAG == "0");
}
if (SYS_MEMBEREntity.Count() > 0)
{
List <VIEW_SYS_MEMBER> list_SYS_MEMBER = SYS_MEMBEREntity.OrderBy(u => u.DEPT_CODE)
.Select(mb => new VIEW_SYS_MEMBER
{
MEMBER_ID = mb.MEMBER_ID,
DEPT_NAME = mb.SYS_DEPT.DEPT_NAME,
C_ICO = mb.SYS_DEPT.C_ICO,
DEPT_CODE = mb.SYS_DEPT.DEPT_CODE,
NAME = mb.NAME,
MOBILE = mb.MOBILE,
UPDATE_DATE = mb.UPDATE_DATE,
UPDATE_USER = mb.UPDATE_USER,
JOB = mb.JOB,
PHONE = mb.PHONE,
LOCATION_FLAG = mb.LOCATION_FLAG == "1"?"是":"否",
DIC_NAME = mb.SYS_INTELLIGENCE_DIC.DIC_NAME
}
).ToList();
string sheetName = "人员";
string path = Path.Combine(HttpContext.Current.Server.MapPath("~/Content/"), "UpLoadExcel");
string fileName = string.Format("{0}_{1}", "ry", DateTime.Now.ToString("yyyyMMddHHmmssfff"));
string savePath = path + "\\" + fileName + ".xls";
if (ExcelHelper.ToExcel(savePath, sheetName, "人员信息", list_SYS_MEMBER, "SYS_MEMBER"))
{
amm.Statu = AjaxStatu.ok;
amm.Msg = "导出成功！";
amm.BackUrl = "/Base/DownloadExcel/" + fileName;
}
}
else
{
amm.Msg = "没有数据，无法导出！";
}
return(amm);
}
[HttpPost]//查询
public ViewModel List(VIEW_SYS_MEMBER data)
{
int pageSize = int.Parse(data.rows);
int pageIndex = int.Parse(data.page);
string sort = data.sort;
string order = data.order;
//查询条件
IQueryable <SYS_MEMBER> SYS_MEMBEREntity = oc.BllSession.ISYS_MEMBERService.Entities;
if (!string.IsNullOrEmpty(data.MOBILE))
{
SYS_MEMBEREntity = SYS_MEMBEREntity.Where(u => u.MOBILE.Contains(data.MOBILE) && u.DEL_FLAG == "0");
}
else
{
if (data.DEPT_CODE != null && data.DEPT_CODE != "")
{
SYS_MEMBEREntity = SYS_MEMBEREntity.Where(u => u.DEPT_CODE.StartsWith(data.DEPT_CODE) && u.DEL_FLAG == "0");
}
else
{
SYS_MEMBEREntity = SYS_MEMBEREntity.Where(u => u.DEPT_CODE.StartsWith(oc.CurrentUser.SYS_DEPT.DEPT_CODE) && u.DEL_FLAG == "0");
}
}
int total = 0;
total = SYS_MEMBEREntity.Count();
var listMEMBER = SYS_MEMBEREntity.OrderBy(u => u.DEPT_CODE)
.Skip(pageSize * (pageIndex - 1)).Take(pageSize).Select(mb =>
new
{
MEMBER_ID = mb.MEMBER_ID,
deptname = mb.SYS_DEPT.DEPT_NAME,
depticon = mb.SYS_DEPT.C_ICO,
deptcode = mb.SYS_DEPT.DEPT_CODE,
name = mb.NAME,
mobile = mb.MOBILE,
update = mb.UPDATE_DATE,
upuser = mb.UPDATE_USER,
job = mb.JOB,
phone = mb.PHONE,
loctionflag = mb.LOCATION_FLAG,
intelligence = mb.SYS_INTELLIGENCE_DIC.DIC_NAME,
poslevel = mb.SYS_POSLEVEL_DIC.DIC_NAME,
state = mb.MOBILE_STATE
}
).ToList();
//return ObjToJson.GetToJson(listMenu, total, true);
return(ObjToJson.ViewModelToJson(listMEMBER, total));
}
public AjaxMsgModel Del(VIEW_SYS_MEMBER data)
{
return(Model_SYS_MEMBER.Del(data.MEMBER_ID));
}
