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