public ActionResult Query(AlermSearchDTO dto) { UserLoginDTO lng = Session["UserLoginInfo"] as UserLoginDTO; dto.UserInfo = lng.UserInfo(); var result = AlermdProvider.Query(dto); return(new JsonResult(result)); }
public ActionResult Export(AlermSearchDTO dto) { UserLoginDTO lng = Session["UserLoginInfo"] as UserLoginDTO; dto.UserInfo = lng.UserInfo(); dto.rows = int.MaxValue; dto.page = 1; var result = AlermdProvider.Query(dto); var headers = new List <ExcelHeaderModel>() { new ExcelHeaderModel { Header = "用户代号", PropertyName = "UserCode", Width = 15 }, new ExcelHeaderModel { Header = "用户名称", PropertyName = "FullName", Width = 15 }, new ExcelHeaderModel { Header = "手机号", PropertyName = "PhoneNumber", Width = 15 }, new ExcelHeaderModel { Header = "邮箱", PropertyName = "Email", Width = 15 }, new ExcelHeaderModel { Header = "所属领域", PropertyName = "DomainDesc", Width = 10 }, new ExcelHeaderModel { Header = "角色", PropertyName = "RoleDesc", Width = 22 }, new ExcelHeaderModel { Header = "关联经销商", PropertyName = "RelDistributorDesc", Width = 40 }, new ExcelHeaderModel { Header = "提醒日期", PropertyName = "DomainDesc", Width = 22 }, new ExcelHeaderModel { Header = "更新日期", PropertyName = "AlarmTime", Width = 22 } }; var buffer = result.rows.ToExcel(headers); return(File(buffer, "application/vnd.ms-excel", string.Format("FCPA Warning List({ 0}).xlsx", DateTime.Now.ToString("yyyyMMddHHmmss")))); }
public PageableDTO <AlermResultDTO> Query(AlermSearchDTO q) { q.InitQuery("AlarmTime", false); var roles = q.Role.ToIntArray(); var res = fcpa.fcpa_AlarmInfo.Where(p => (string.IsNullOrEmpty(q.UserCode) ? true : p.fcpa_UserInfo.UserCode.Contains(q.UserCode)) && (string.IsNullOrEmpty(q.FullName) ? true : p.fcpa_UserInfo.FullName.Contains(q.FullName)) && (string.IsNullOrEmpty(q.PhoneNumber) ? true : p.fcpa_UserInfo.PhoneNumber.Contains(q.PhoneNumber)) && (string.IsNullOrEmpty(q.Email) ? true : p.fcpa_UserInfo.Email.Contains(q.Email)) && (q.Domain1.HasValue ? p.fcpa_UserInfo.Domain1 == q.Domain1 : true) && (q.Domain2.HasValue ? p.fcpa_UserInfo.Domain2 == q.Domain2 : true) && (string.IsNullOrEmpty(q.Role) ? true : roles.Any(a => p.fcpa_UserInfo.Role == a)) && (string.IsNullOrEmpty(q.RelDistributor) ? true : p.fcpa_UserInfo.RelDistributor.Contains(q.RelDistributor)) && (q.AlarmTimeFrom.HasValue ? p.AlarmTime >= q.AlarmTimeFrom : true) && (q.AlarmTimeTo.HasValue ? p.AlarmTime <= q.AlarmTimeTo : true) ).Select(p => new AlermResultDTO { ID = p.ID, UserCode = p.fcpa_UserInfo.UserCode, FullName = p.fcpa_UserInfo.FullName, PhoneNumber = p.fcpa_UserInfo.PhoneNumber, Email = p.fcpa_UserInfo.Email, Domain1 = p.fcpa_UserInfo.Domain1, Domain2 = p.fcpa_UserInfo.Domain2, Role = p.fcpa_UserInfo.Role, RelDistributor = p.fcpa_UserInfo.RelDistributor, AlarmTime = p.AlarmTime }) .ToPageable(q); res.rows.ForEach(p => { p.RoleDesc = Const.Role(p.Role); p.RelDistributorDesc = Const.RelDistributor(p.RelDistributor, fcpa); p.DomainDesc = Const.Domain(p.Domain1, p.Domain2); }); return(res); }
public static PageableDTO <AlermResultDTO> Query(AlermSearchDTO dto) { return(PostAPI <PageableDTO <AlermResultDTO> >(WebConfiger.FcpaServicesUrl + "Alerm/Query", dto)); }
public PageableDTO <AlermResultDTO> Query(AlermSearchDTO q) { return(_AlermService.Query(q)); }