| | |
|---|
| | | 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" |
|---|
| | | where b.RecStatus == "A" |
|---|
| | | select new CodeDataEntity() |
|---|
| | | { |
|---|
| | | CodeId = b.Id, |
|---|
| | |
|---|
| | | |
|---|
| | | && (string.IsNullOrWhiteSpace(searchEntity.Falv) || lll.Falv == searchEntity.Falv.Trim()) |
|---|
| | | |
|---|
| | | |
|---|
| | | && (string.IsNullOrWhiteSpace(searchEntity.shanchuzhishitype) || a.Zhishitype == searchEntity.shanchuzhishitype.Trim()) |
|---|
| | | |
|---|
| | | |
|---|
| | | select new ExpertTestTopicDTO |
|---|
| | |
|---|
| | | |
|---|
| | | join f in listCode.Where(x => x.CodeTable == "expert_test_topic" && x.CodeField == "zhishitype") |
|---|
| | | on a.Zhishitype equals f.CodeSn |
|---|
| | | into fsssss |
|---|
| | | from fff in fsssss.DefaultIfEmpty() |
|---|
| | | //into fsssss |
|---|
| | | // from fff in fsssss.DefaultIfEmpty() |
|---|
| | | |
|---|
| | | |
|---|
| | | where a.RecStatus == "A" |
|---|
| | |
|---|
| | | Topictype = a.Topictype, |
|---|
| | | TopictypeName = eee.Comments, |
|---|
| | | Zhishitype = a.Zhishitype, |
|---|
| | | ZhishitypeName = fff.Comments, |
|---|
| | | ZhishitypeName = f.Comments, |
|---|
| | | Fenshu = a.Fenshu ?? 0, |
|---|
| | | Fenzhi = a.Fenzhi??0, |
|---|
| | | FenshuName = (a.Fenshu ?? 0).ToString("0.##"), |
|---|
