From b0c19dd2793b5ada90b303b7ec23a670cdbf48f6 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期五, 11 二月 2022 14:52:52 +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