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