//资料分类归档
#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()));
}
