/// <summary> /// 获取数据列表(分页) /// </summary> public PageModel GetDataListForPage(WastagerReportFormRequest request) { //组装查询语句 #region 模糊搜索条件 var where = new Where <TbWastagerReportForm>(); if (!string.IsNullOrWhiteSpace(request.MaterialName)) { where.And(p => p.MaterialName.Like(request.MaterialName)); } if (!string.IsNullOrWhiteSpace(request.SpecificationType)) { where.And(p => p.SpecificationType.Like(request.SpecificationType)); } if (!string.IsNullOrEmpty(request.ProjectId)) { where.And(p => p.ProjectId == request.ProjectId); } #endregion try { var ret = Db.Context.From <TbWastagerReportForm>() .Select( TbWastagerReportForm._.All , TbUser._.UserName , TbSysDictionaryData._.DictionaryText.As("MeasurementUnitNew")) .LeftJoin <TbSysDictionaryData>((a, c) => a.MeasureUnit == c.DictionaryCode && c.FDictionaryCode == "Unit") .LeftJoin <TbUser>((a, c) => a.InsertUserCode == c.UserCode) .Where(where).OrderBy(d => d.ID).ToPageList(request.rows, request.page); return(ret); } catch (Exception) { throw; } }
/// <summary> /// 获取分页列表数据 /// </summary> /// <param name="request"></param> /// <returns></returns> public ActionResult GetGridJson(WastagerReportFormRequest request) { var data = _wasRFLogic.GetDataListForPage(request); return(Content(data.ToJson())); }