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