public void TestMethod1()
{
CaseAllPageRequestModel request = new CaseAllPageRequestModel()
{
PageSize = 100,
};
CaseAllController call = new CaseAllController();
var list = call.GetPageIndex(request);
}
/// <summary>
/// 所有案件列表查询
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetPageIndex(CaseAllPageRequestModel request)
{
var bad = new ALLCaseDAL();
var response = new CaseAllPageResponseModel();
var list = bad.GetAll(CurrentUser);
list = list.Where(s => !s.NewCaseNum.Contains("HIS"));
if (!string.IsNullOrEmpty(request.CaseNum))
{
list = list.Where(s => s.NewCaseNum.Contains(request.CaseNum));
}
if (!string.IsNullOrEmpty(request.SalesGroupId))
{
list = list.Where(s => s.SalesGroupID == request.SalesGroupId);
}
if (!string.IsNullOrEmpty(request.CaseMode))
{
if (request.CaseMode == "-CaseMode-WeiXuanZe")
{
list = list.Where(s => s.CaseMode == null);
}
else
{
list = list.Where(s => s.CaseMode == request.CaseMode);
}
}
if (!string.IsNullOrEmpty(request.ThirdParty))
{
list = list.Where(s => s.ThirdParty == request.ThirdParty);
}
if (!string.IsNullOrEmpty(request.BorrowerName))
{
list = list.Where(s => s.BorrowerName.Contains(request.BorrowerName));
}
if (!string.IsNullOrEmpty(request.CaseStatus))
{
list = list.Where(s => s.CaseStatus == request.CaseStatus);
}
if (!string.IsNullOrEmpty(request.LendTimeStart.ToString()))
{
list = list.Where(s => s.LendTime >= request.LendTimeStart);
}
if (!string.IsNullOrEmpty(request.LendTimeEnd.ToString()))
{
list = list.Where(s => request.LendTimeEnd != null && s.LendTime <= request.LendTimeEnd);
}
try
{
var caselist = list.Skip((request.PageIndex - 1) * request.PageSize).Take(request.PageSize);
var newcaselist = caselist.Select(s => new CaseAllPageViewModel().CopyModel(s));
response.PageIndex = request.PageIndex;
response.PageSize = request.PageSize == 0 ? 10 : request.PageSize;
response.Total = list.Count();
response.TotalPage = (int)Math.Ceiling((decimal)response.Total / response.PageSize);
response.Data = newcaselist;
return(Json(response, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
response.PageIndex = request.PageIndex;
response.PageSize = request.PageSize == 0 ? 10 : request.PageSize;
response.Total = 0;
//response.TotalPage = (int)Math.Ceiling((decimal)response.Total / response.PageSize);
response.Data = null;
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
