From 3a864ec2d204077d34bd0b874540829702581c6c Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 11 二月 2022 15:16:35 +0800
Subject: [PATCH] 删除知识点查询
---
zhengcaioa/Services/ExpertTestTopicService.cs | 26 ++++++++++++++++++++++++--
1 files changed, 24 insertions(+), 2 deletions(-)
diff --git a/zhengcaioa/Services/ExpertTestTopicService.cs b/zhengcaioa/Services/ExpertTestTopicService.cs
index 847b3db..2b227c6 100644
--- a/zhengcaioa/Services/ExpertTestTopicService.cs
+++ b/zhengcaioa/Services/ExpertTestTopicService.cs
@@ -407,9 +407,31 @@
/// <returns></returns>
public List<ExpertTestTopicDTO> GetList()
{
+ var listCode = (from a in _context.SysCodeDtls
+ join b in _context.SysCodes
+ on a.CodeId equals b.Id
+ where a.RecStatus == "A" && b.RecStatus == "A"
+ select new CodeDataEntity()
+ {
+ CodeId = b.Id,
+ CodeTable = b.CodeTable,
+ CodeField = b.CodeField,
+ CodeSn = a.CodeSn,
+ Comments = a.Comments,
+ Contents = a.Contents,
+ RecStatus = a.RecStatus,
+ Sort = a.Sort
+ }
+ );
-
- var listRole = _context.ExpertTestTopics.Where(r => r.RecStatus == "A").ToList();
+ var listRole =
+ ( from a in _context.ExpertTestTopics.Where(r => r.RecStatus == "A")
+ join f in listCode.Where(x => x.CodeTable == "expert_test_topic" && x.CodeField == "zhishitype")
+ on a.Zhishitype equals f.CodeSn
+
+
+
+ select a ).ToList();
var list = _mapper.Map<List<ExpertTestTopicDTO>>(listRole);
--
Gitblit v1.9.1