public JsonResult GetSeniorAuditList(MerchantSearchCondition condition) { var waitAuditCount = (from h in CurrentDb.BizProcessesAudit where (h.AduitType == Enumeration.BizProcessesAuditType.MerchantAudit) && h.Status == (int)Enumeration.MerchantAuditStatus.WaitSeniorAudit select h.Id).Count(); var inAuditCount = (from h in CurrentDb.BizProcessesAudit where (h.AduitType == Enumeration.BizProcessesAuditType.MerchantAudit) && h.Status == (int)Enumeration.MerchantAuditStatus.InSeniorAudit && h.Auditor == this.CurrentUserId select h.Id).Count(); var query = (from b in CurrentDb.BizProcessesAudit join m in CurrentDb.Merchant on b.AduitReferenceId equals m.Id where (b.AduitType == Enumeration.BizProcessesAuditType.MerchantAudit) select new { b.Id, b.Status, b.Auditor, m.ClientCode, m.Type, m.RepairCapacity, m.Area, m.YYZZ_Name, m.FR_Name, m.ContactName, m.CreateTime }); if (condition.AuditStatus == Enumeration.MerchantAuditStatus.WaitSeniorAudit) { query = query.Where(m => m.Status == (int)Enumeration.MerchantAuditStatus.WaitSeniorAudit); } else if (condition.AuditStatus == Enumeration.MerchantAuditStatus.InSeniorAudit) { query = query.Where(m => m.Status == (int)Enumeration.MerchantAuditStatus.InSeniorAudit && 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.YYZZ_Name, item.ContactName, Type = item.Type.GetCnName(), RepairCapacity = item.RepairCapacity.GetCnName(), item.Area, item.CreateTime, AuditStatus = item.Status }); } PageEntity pageEntity = new PageEntity { PageSize = pageSize, TotalRecord = total, Rows = list, Status = new { waitAuditCount = waitAuditCount, inAuditCount = inAuditCount } }; return(Json(ResultType.Success, pageEntity, "")); }
public CustomJsonResult GetList(MerchantSearchCondition condition) { string clientCode = condition.ClientCode.ToSearchString(); string yYZZ_Name = condition.YYZZ_Name.ToSearchString(); string yYZZ_RegisterNo = condition.YYZZ_RegisterNo.ToSearchString(); var query = (from m in CurrentDb.Merchant join u in CurrentDb.SysClientUser on m.UserId equals u.Id where m.AgentId == this.CurrentUserId && (clientCode.Length == 0 || u.ClientCode.Contains(clientCode)) && (yYZZ_Name.Length == 0 || m.YYZZ_Name.Contains(yYZZ_Name)) && (yYZZ_RegisterNo.Length == 0 || m.YYZZ_RegisterNo.Contains(yYZZ_RegisterNo)) select new { m.Id, u.ClientCode, m.Type, m.RepairCapacity, m.Area, m.YYZZ_Name, m.FR_Name, m.ContactName, m.CreateTime }); 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.YYZZ_Name, item.ContactName, Type = item.Type.GetCnName(), RepairCapacity = item.RepairCapacity.GetCnName(), item.Area, item.CreateTime }); } PageEntity pageEntity = new PageEntity { PageSize = pageSize, TotalRecord = total, Rows = list }; return(Json(ResultType.Success, pageEntity, "")); }