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