From 8b613a5275e6fe23b91f65cc6a7fba720ae4d7ef Mon Sep 17 00:00:00 2001 From: 移动系统liao <liaoxujun@qq.com> Date: 星期二, 18 二月 2025 11:10:35 +0800 Subject: [PATCH] 完成阿里云本地上传token生成,实现小程序本地上传 --- cylsg/cylsg.Application/CyOS/CyOSBaoXiaoZHuGuanController.cs | 25 +++++++++++++++++++++++-- 1 files changed, 23 insertions(+), 2 deletions(-) diff --git a/cylsg/cylsg.Application/CyOS/CyOSBaoXiaoZHuGuanController.cs b/cylsg/cylsg.Application/CyOS/CyOSBaoXiaoZHuGuanController.cs index 39e60fe..5ccdc56 100644 --- a/cylsg/cylsg.Application/CyOS/CyOSBaoXiaoZHuGuanController.cs +++ b/cylsg/cylsg.Application/CyOS/CyOSBaoXiaoZHuGuanController.cs @@ -25,8 +25,29 @@ _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> @@ -91,7 +112,7 @@ RefAsync<int> totle = 0; //寮哄埗澧炲姞鍛樺伐杩囨护 - + var data = await _SugarClient.Queryable<OaWorkPlan>().Includes(x=>x.Depart) .Includes(x=>x.OaWorkPlanShenpis.Where(y=>y.ApprovalStaffId==Permissions.MemberId&&y.Buzhou==1).ToList()) .Where(SearchList).OrderByDescending(x => x.PlanStartTime).Mapper( -- Gitblit v1.9.1