From 13ca8b4cab099521fc95d551c4b21c1a7ae5984d Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期五, 30 十二月 2022 09:44:04 +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