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, ""));
}
