/// <summary> /// 获取我已审批 /// </summary> /// <param name="request"></param> /// <returns></returns> public PageResponse <string> getHaveApprovedList(QueryPendingRequest request) { var query = Db.Queryable <TaskRecord, ApproveRecord>((tr, ar) => new object[] { JoinType.Left, tr.Id == ar.DocId }).Where((tr, ar) => tr.Desc.Contains(request.key) && ar.ApproverId == user.UserId && !ar.Result.Equals("已提交")); if (!string.IsNullOrEmpty(request.startTime) && !string.IsNullOrEmpty(request.endTime)) { query = query.Where((tr, ar) => SqlFunc.Between(tr.CreateTime, request.startTime, request.endTime)); } var total = 0; var json = query.Select((tr, ar) => new { id = tr.Id, submitterName = tr.SubmitterName, desc = tr.Desc, status = tr.Status, createTime = tr.CreateTime, attachment = tr.Attachment, percent = tr.Percent, taskId = tr.TaskId }).ToPageList(request.page, request.limit, ref total).ToJson(); // 此处返回json的原因是 目前审批类别只有任务完成情况 以后可能会新增审批类别 所以统一转成json返回 var pageResponse = new PageResponse <string> { Total = total, Result = json }; return(pageResponse); }
public PageResponse <string> getMySubmitList(QueryPendingRequest request) { var result = new PageResponse <string>(); try { result = _service.getMySubmitList(request); } catch (Exception ex) { result.Code = 500; result.Message = ex.Message; } return(result); }
/// <summary> /// 获取我已提交 /// </summary> /// <param name="request"></param> /// <returns></returns> public PageResponse <string> getMySubmitList(QueryPendingRequest request) { var query = SimpleDb.AsQueryable().Where(u => u.SubmitterId == user.UserId && u.Desc.Contains(request.key)); if (!string.IsNullOrEmpty(request.startTime) && !string.IsNullOrEmpty(request.endTime)) { query = query.Where(u => SqlFunc.Between(u.CreateTime, request.startTime, request.endTime)); } var total = 0; var json = query.Select(u => new { id = u.Id, submitterName = u.SubmitterName, desc = u.Desc, status = u.Status, createTime = u.CreateTime, attachment = u.Attachment, percent = u.Percent, taskId = u.TaskId }).ToPageList(request.page, request.limit, ref total).ToJson(); // 此处返回json的原因是 目前审批类别只有任务完成情况 以后可能会新增审批类别 所以统一转成json返回 var pageResponse = new PageResponse <string> { Total = total, Result = json }; return(pageResponse); }