From fe1d552606aa8a989647ff12d7c124dd6ac5a1dd Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 07 七月 2021 15:07:00 +0800
Subject: [PATCH] 线下培训的订单

---
 zhengcaioa/Services/ProjectService.cs |    9 +++++++++
 1 files changed, 9 insertions(+), 0 deletions(-)

diff --git a/zhengcaioa/Services/ProjectService.cs b/zhengcaioa/Services/ProjectService.cs
index a46891d..14bf1cf 100644
--- a/zhengcaioa/Services/ProjectService.cs
+++ b/zhengcaioa/Services/ProjectService.cs
@@ -334,6 +334,15 @@
                 }
             }
 
+            if (!string.IsNullOrWhiteSpace(searchEntity.Fenchadayu))
+            {
+                decimal aaaa = 0;
+                decimal.TryParse(searchEntity.Fenchadayu, out aaaa);
+                if (aaaa > 0)
+                {
+                    sql.Append(" and exists ( select b.[ProjectId] from [Projectzhongbiao] b  where  a.[Id]=b.[ProjectId] and  (b.[defen]-a.[drhx_defen])  >= " + aaaa + " ) ");
+                }
+            }
 
             if (!string.IsNullOrWhiteSpace(searchEntity.Shuliang))
             {

--
Gitblit v1.9.1