From 06e75f18b5b3b0fbfd25731c8b7324cc42df045f Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 07 七月 2021 17:15:30 +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