From 439f10462e6b1ab0ebd454f53c2156c6fab24266 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期一, 14 十一月 2022 11:12:46 +0800 Subject: [PATCH] 抓取的项目, 已确认,未确认 未确认为橙色 客户档案管理 有无手机号,未确认为橙色 客户资料页面查看访问记录 --- zhengcaioa/Services/LiaotianService.cs | 21 +++++++++++++++++++++ 1 files changed, 21 insertions(+), 0 deletions(-) diff --git a/zhengcaioa/Services/LiaotianService.cs b/zhengcaioa/Services/LiaotianService.cs index 6ddb2bb..ed98b8f 100644 --- a/zhengcaioa/Services/LiaotianService.cs +++ b/zhengcaioa/Services/LiaotianService.cs @@ -107,7 +107,28 @@ return sysCodeDtls; } + public List<SysCodeDtl> GetSYScodeshanchu(string code_table, string code_field) + { + + List<SysCodeDtl> sysCodeDtls = (from e in _context.SysCodes + join c in _context.SysCodeDtls + on e.Id equals c.CodeId + where e.RecStatus == "A" + && c.RecStatus == "D" + && e.CodeTable == code_table + && e.CodeField == code_field + select c).OrderBy(x => x.Sort).ToList(); + + + + + + + + return sysCodeDtls; + } + public ResultDataEntity<LiaotianDTO> SearchByPaging(LiaotianDTOSearch searchEntity) { ResultDataEntity<LiaotianDTO> data = new ResultDataEntity<LiaotianDTO>(); -- Gitblit v1.9.1