//资料分类归档 #region 首页查询 /// <summary> /// 列表数据查询 /// </summary> /// <returns></returns> public PageModel GetGridJson(TbDataManageRequest request) { #region 模糊搜索条件 var where = new Where <TbDataManage>(); if (!string.IsNullOrWhiteSpace(request.ProcessFactoryCode)) { where.And(d => d.ProcessFactoryCode == request.ProcessFactoryCode); } if (!string.IsNullOrWhiteSpace(request.TypeName)) { where.And(d => d.TypeName == request.TypeName); } #endregion try { var data = Db.Context.From <TbDataManage>().Select( TbDataManage._.ID, TbDataManage._.FileCode, TbDataManage._.TypeName, TbDataManage._.DataName, TbDataManage._.DataContent, TbDepartment._.DepartmentName, TbDataManage._.InsertTime, TbDataManage._.Remark, TbDataManage._.InsertUserCode, TbUser._.UserName ).AddSelect(Db.Context.From <TbCompany>().Select(p => p.CompanyFullName) .Where(TbCompany._.CompanyCode == TbDataManage._.ProcessFactoryCode), "ProcessFactoryName") .LeftJoin <TbDepartment>((a, c) => a.DepartmentCode == c.DepartmentId) .LeftJoin <TbUser>((a, c) => a.InsertUserCode == c.UserCode) .Where(where) .OrderByDescending(p => p.ID) .ToPageList(request.rows, request.page); return(data); } catch (Exception) { throw; } }
/// <summary> /// 列表数据查询 /// </summary> /// <returns></returns> public ActionResult GetGridJson(TbDataManageRequest request) { var data = _File.GetGridJson(request); return(Content(data.ToJson())); }