From a6b6b4303483395bf6ff745f5abf171552afae38 Mon Sep 17 00:00:00 2001 From: LR-20210131IOQH\Administrator <jackcold@163.com> Date: 星期五, 18 六月 2021 17:30:14 +0800 Subject: [PATCH] 电话卡分配,电话费用录入 --- zhengcaioa/Services/ProjectService.cs | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/zhengcaioa/Services/ProjectService.cs b/zhengcaioa/Services/ProjectService.cs index 2543a63..765ddb6 100644 --- a/zhengcaioa/Services/ProjectService.cs +++ b/zhengcaioa/Services/ProjectService.cs @@ -301,6 +301,20 @@ sql.Append(" )"); } + + if (!string.IsNullOrWhiteSpace(searchEntity.fblx)) + { + if (searchEntity.fblx == "A") + { + sql.Append(" and a.fblx is not null "); + } + else + { + sql.Append(" and a.fblx is null "); + } + + + } if (!string.IsNullOrWhiteSpace(searchEntity.StartTimestar)) { -- Gitblit v1.9.1