public JsonResult GetVerifyAmountList(CarClaimSearchCondition condition) { var waitVerifyOrderCount = (from h in CurrentDb.BizProcessesAudit where (h.AduitType == Enumeration.BizProcessesAuditType.CarClaim) && h.Status == (int)Enumeration.CarClaimDealtStatus.WaitVerifyAmount select h.Id).Count(); var inVerifyOrderCount = (from h in CurrentDb.BizProcessesAudit where (h.AduitType == Enumeration.BizProcessesAuditType.CarClaim) && h.Status == (int)Enumeration.CarClaimDealtStatus.InVerifyAmount && h.Auditor == this.CurrentUserId select h.Id).Count(); var query = (from b in CurrentDb.BizProcessesAudit join o in CurrentDb.OrderToCarClaim on b.AduitReferenceId equals o.Id join m in CurrentDb.Merchant on o.MerchantId equals m.Id where b.AduitType == Enumeration.BizProcessesAuditType.CarClaim select new { b.Id, m.ClientCode, o.Sn, m.YYZZ_Name, o.ProductName, o.HandPerson, o.HandPersonPhone, o.CarPlateNo, o.SubmitTime, b.Status, b.CreateTime, b.Auditor, o.InsuranceCompanyName }); if (condition.DealtStatus == Enumeration.CarClaimDealtStatus.WaitVerifyAmount) { query = query.Where(m => m.Status == (int)Enumeration.CarClaimDealtStatus.WaitVerifyAmount); } else if (condition.DealtStatus == Enumeration.CarClaimDealtStatus.InVerifyAmount) { query = query.Where(m => m.Status == (int)Enumeration.CarClaimDealtStatus.InVerifyAmount && m.Auditor == this.CurrentUserId); } int total = query.Count(); int pageIndex = condition.PageIndex; int pageSize = 10; query = query.OrderByDescending(r => r.CreateTime).Skip(pageSize * (pageIndex)).Take(pageSize); List <object> list = new List <object>(); foreach (var item in query) { list.Add(new { item.Id, item.ClientCode, item.Sn, item.YYZZ_Name, item.HandPerson, item.HandPersonPhone, item.CarPlateNo, item.ProductName, item.SubmitTime, item.InsuranceCompanyName, DealtStatus = item.Status }); } PageEntity pageEntity = new PageEntity { PageSize = pageSize, TotalRecord = total, Rows = list, Status = new { waitVerifyOrderCount = waitVerifyOrderCount, inVerifyOrderCount = inVerifyOrderCount } }; return(Json(ResultType.Success, pageEntity, "")); }
public JsonResult GetList(CarClaimSearchCondition condition) { string sn = condition.Sn.ToSearchString(); string clientCode = condition.ClientCode.ToSearchString(); string clientName = condition.ClientName.ToSearchString(); var query = (from o in CurrentDb.OrderToCarClaim join m in CurrentDb.Merchant on o.MerchantId equals m.Id where o.PId == null && (o.Status == condition.Status || condition.Status == Enumeration.OrderStatus.Unknow) && (sn.Length == 0 || o.Sn.Contains(sn)) && (clientCode.Length == 0 || m.ClientCode.Contains(clientCode)) && (clientCode.Length == 0 || m.YYZZ_Name.Contains(clientCode)) select new { o.Id, m.ClientCode, o.Sn, m.YYZZ_Name, o.ProductName, o.HandPerson, o.HandPersonPhone, o.CarPlateNo, o.SubmitTime, o.Status, o.CreateTime, o.InsuranceCompanyName }); int total = query.Count(); int pageIndex = condition.PageIndex; int pageSize = 10; query = query.OrderByDescending(r => r.CreateTime).Skip(pageSize * (pageIndex)).Take(pageSize); List <object> list = new List <object>(); foreach (var item in query) { list.Add(new { item.Id, item.ClientCode, item.Sn, item.YYZZ_Name, item.HandPerson, item.HandPersonPhone, item.CarPlateNo, item.ProductName, item.SubmitTime, item.InsuranceCompanyName, Status = item.Status.GetCnName() }); } PageEntity pageEntity = new PageEntity { PageSize = pageSize, TotalRecord = total, Rows = list }; return(Json(ResultType.Success, pageEntity, "")); }