From 451ec557d579f8f9e1b0c84754709cc8b3d2090e Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 07 五月 2025 08:37:46 +0800
Subject: [PATCH] 人事管理里边增加  一个权限

---
 CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs |    8 ++++++--
 1 files changed, 6 insertions(+), 2 deletions(-)

diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs
index 9efec7b..71fd4e7 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs
@@ -294,7 +294,7 @@
         /// <param name="EvaluationStatus"></param>
         /// <param name="RewardType"></param>
         /// <returns></returns>
-        public IEnumerable<Model.OA_WorkPlan> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid MemberId, Guid SentStaffId, Guid ReciveStaffId, int? PlanType, int? PlanDataType, string PlanTitle, DateTime? BeginPlanStartTime, DateTime? EndPlanStartTime, DateTime? BeginPlanRunTime, DateTime? EndPlanRunTime, string PlanPeople, int? PlanStatus, int? ApprovalStatus, int? EvaluationStatus, int? RewardType, string RewardContent = null, string PlanContent = null)
+        public IEnumerable<Model.OA_WorkPlan> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid MemberId, Guid SentStaffId, Guid ReciveStaffId, int? PlanType, int? PlanDataType, string PlanTitle, DateTime? BeginPlanStartTime, DateTime? EndPlanStartTime, DateTime? BeginPlanRunTime, DateTime? EndPlanRunTime, string PlanPeople, int? PlanStatus, int? ApprovalStatus, int? EvaluationStatus, int? RewardType, string RewardContent = null, string PlanContent = null, string BaocunStatus = null)
         {
             try
             {
@@ -338,10 +338,14 @@
                 if (ApprovalStatus >= 0)
                 {
                     if (ApprovalStatus == 1)
-                        condition += " and ( a.ApprovalStatus = '1' or a.ApprovalStatus = '3' )";
+                        condition += " and (( a.PlanDataType = 17  and a.ApprovalStatus = '1'  )  or (  a.PlanDataType != 17 and (a.ApprovalStatus = '3' or  a.ApprovalStatus = '1')  ))";
                     else
                         condition += " and a.ApprovalStatus = '" + ApprovalStatus + "'";
                 }
+                if (!string.IsNullOrEmpty(BaocunStatus))
+                {
+                        condition += " and a.ApprovalStatus != '" + BaocunStatus + "'";
+                }
                 if (EvaluationStatus >= 0)
                 {
                     if (EvaluationStatus == 5)

--
Gitblit v1.9.1