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