public JsonResult GetSeniorAuditList(ExtendedAppSearchCondition condition)
{
var waitCount = (from h in CurrentDb.BizProcessesAudit where (h.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppOn || h.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppOff || h.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppRecovery) && h.Status == (int)Enumeration.ExtendedAppAuditStatus.WaitReview select h.Id).Count();
var handleCount = (from h in CurrentDb.BizProcessesAudit where (h.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppOn || h.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppOff || h.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppRecovery) && h.Status == (int)Enumeration.ExtendedAppAuditStatus.InReview && h.Auditor == this.CurrentUserId select h.Id).Count();
var query = (from b in CurrentDb.BizProcessesAudit
join e in CurrentDb.ExtendedApp on
b.AduitReferenceId equals e.Id
where (b.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppOff ||
b.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppOn ||
b.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppRecovery
) &&
e.Type == Enumeration.ExtendedAppType.ThirdPartyApp
select new { b.Id, b.AduitType, e.ImgUrl, e.LinkUrl, e.Name, b.Status, b.CreateTime, b.Auditor, b.Remark });
if (condition.AuditStatus == Enumeration.ExtendedAppAuditStatus.WaitReview)
{
query = query.Where(m => m.Status == (int)Enumeration.ExtendedAppAuditStatus.WaitReview);
}
else if (condition.AuditStatus == Enumeration.ExtendedAppAuditStatus.InReview)
{
query = query.Where(m => m.Status == (int)Enumeration.ExtendedAppAuditStatus.InReview && 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.ImgUrl,
item.LinkUrl,
item.Name,
AuditStatus = item.Status,
AduitType = item.AduitType.GetCnName(),
item.CreateTime,
item.Remark,
});
}
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = list, Status = new { waitCount = waitCount, handleCount = handleCount }
};
return(Json(ResultType.Success, pageEntity, ""));
}
public JsonResult GetApplyList(ExtendedAppSearchCondition condition)
{
string name = condition.Name.ToSearchString();
var query = (from b in CurrentDb.BizProcessesAudit
join e in CurrentDb.ExtendedApp on
b.AduitReferenceId equals e.Id
where (b.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppOff ||
b.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppOn || b.AduitType == Enumeration.BizProcessesAuditType.ExtendedAppRecovery) &&
e.Type == Enumeration.ExtendedAppType.ThirdPartyApp &&
(name.Length == 0 || e.Name.Contains(name))
select new { e.Id, b.AduitType, e.ImgUrl, e.LinkUrl, e.Name, b.Status, b.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.ImgUrl,
item.LinkUrl,
AduitType = item.AduitType.GetCnName(),
item.Name,
Status = ((Enumeration.ExtendedAppAuditStatus)item.Status).GetCnName(),
item.CreateTime,
});
}
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = list
};
return(Json(ResultType.Success, pageEntity, ""));
}
public JsonResult GetList(ExtendedAppSearchCondition condition)
{
string name = condition.Name.ToSearchString();
var query = (from e in CurrentDb.ExtendedApp
where
(name.Length == 0 || e.Name.Contains(name))
select new { e.Id, e.ImgUrl, e.LinkUrl, e.Name, e.Status, e.CreateTime, e.IsDisplay });
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.ImgUrl,
item.LinkUrl,
item.Name,
Status = item.Status.GetCnName(),
IsDisplay = GetIsDisplay(item.IsDisplay),
item.CreateTime
});
}
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = list
};
return(Json(ResultType.Success, pageEntity, ""));
}
