public HttpResponseMessage GetGridJson([FromUri] InterimUseElectricCheckRequest request)
{
try
{
var data = _iueclogic.GetDataListForPage(request);
return(AjaxResult.Success(data).ToJsonApi());
}
catch (Exception)
{
return(AjaxResult.Error("操作失败").ToJsonApi());
}
}
/// <summary>
/// 获取数据列表(分页)
/// </summary>
public PageModel GetDataListForPage(InterimUseElectricCheckRequest request)
{
#region 模糊搜索条件
var where = new Where <TbInterimUseElectricCheck>();
if (!string.IsNullOrWhiteSpace(request.CheckCode))
{
where.And(d => d.CheckCode == request.CheckCode);
}
if (!string.IsNullOrWhiteSpace(request.ProcessFactoryCode))
{
where.And(d => d.ProcessFactoryCode == request.ProcessFactoryCode);
}
//if (!string.IsNullOrWhiteSpace(request.ProjectId))
//{
// where.And(d => d.ProjectId == request.ProjectId);
//}
if (request.CheckTimeS.HasValue)
{
where.And(d => d.CheckDate >= request.CheckTimeS);
}
if (request.CheckTimeE.HasValue)
{
where.And(d => d.CheckDate <= request.CheckTimeE);
}
#endregion
try
{
var data = Db.Context.From <TbInterimUseElectricCheck>()
.Select(
TbInterimUseElectricCheck._.All
, TbCompany._.CompanyFullName.As("ProcessFactoryName")
, TbUser._.UserName)
.LeftJoin <TbCompany>((a, c) => a.ProcessFactoryCode == c.CompanyCode)
.LeftJoin <TbUser>((a, c) => a.InsertUserCode == c.UserCode)
.Where(where)
.OrderByDescending(TbInterimUseElectricCheck._.CheckCode)
.ToPageList(request.rows, request.page);
return(data);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取分页列表数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetGridJson(InterimUseElectricCheckRequest request)
{
var data = _iueclogic.GetDataListForPage(request);
return(Content(data.ToJson()));
}
