| | |
|---|
| | | _OAServices = oaservices; |
|---|
| | | _SugarClient = sugarClient.AsTenant().GetConnection("ECTESTOADB"); |
|---|
| | | } |
|---|
| | | /// <summary> |
|---|
| | | /// 查询 |
|---|
| | | /// </summary> |
|---|
| | | /// <returns></returns> |
|---|
| | | [HttpGet] |
|---|
| | | [AllowAnonymous] |
|---|
| | | public async Task<List<OaWorkPlan>> gettest() |
|---|
| | | { |
|---|
| | | var datal = await _SugarClient.Queryable<OaWorkPlan>().Where(x=>x.PlanType==3&&x.PlanDataType==17) |
|---|
| | | .Select(x => new OaWorkPlan |
|---|
| | | { |
|---|
| | | OaWorkPlanShenpi = SqlFunc.Subqueryable<OaWorkPlanShenpi>().Where(y => y.OA_WorkPlanId == x.Keyid).First() |
|---|
| | | }, true).MergeTable() |
|---|
| | | .OrderBy(z => z.OaWorkPlanShenpi.ApprovalTime).ToListAsync(); |
|---|
| | | return datal; |
|---|
| | | var data2 = await _SugarClient.Queryable<OaWorkPlan>() |
|---|
| | | .Select(x => new OaWorkPlan |
|---|
| | | { |
|---|
| | | SentStaff = SqlFunc.Subqueryable<OaStaff>().Where(y => y.MemberId == x.SentStaffId).First() |
|---|
| | | }, true).MergeTable() |
|---|
| | | .OrderBy(y => y.SentStaff.MemberId).ToListAsync(); |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
| | | /// <summary> |
|---|
| | | /// 查询 |
|---|
| | | /// </summary> |
|---|
