/// <summary>
/// 获取数据列表(分页)
/// </summary>
public PageModel GetDataListForPage(TbDepartmentRequest request)
{
//组装查询语句
#region 模糊搜索条件
var where = new Where <TbDepartment>();
if (!string.IsNullOrWhiteSpace(request.DepartmentName))
{
where.And(p => p.DepartmentName.Contains(request.DepartmentName));
}
if (!string.IsNullOrWhiteSpace(request.DepartmentType))
{
where.And(p => p.DepartmentType == request.DepartmentType);
}
if (!string.IsNullOrWhiteSpace(request.DepartmentProjectId))
{
where.And(p => p.DepartmentProjectId == request.DepartmentProjectId);
}
#endregion
try
{
var ret = Db.Context.From <TbDepartment>()
.Select(
TbDepartment._.DepartmentCode
, TbDepartment._.DepartmentId
, TbDepartment._.DepartmentName
, TbDepartment._.DepartmentType
, TbDepartment._.DepartmentProjectId
, TbProjectInfo._.ProjectName)
.LeftJoin <TbProjectInfo>((a, c) => a.DepartmentProjectId == c.ProjectId)
.Where(where).OrderByDescending(d => d.DepartmentId).ToPageList(request.rows, request.page);
return(ret);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取分页列表数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetGridJson(TbDepartmentRequest request)
{
var data = dit.GetDataListForPage(request);
return(Content(data.ToJson()));
}
