using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using AutoMapper;
|
using DTO;
|
using IServices;
|
using Microsoft.AspNetCore.Mvc.Rendering;
|
using Microsoft.EntityFrameworkCore;
|
using zhengcaioa.Models;
|
|
|
|
namespace Services
|
{
|
public class ExpertTestTopicService: IExpertTestTopicService
|
{
|
private readonly zhengcaioaContext _context;
|
private readonly IMapper _mapper;
|
public ExpertTestTopicService(zhengcaioaContext context, IMapper mapper)
|
{
|
_context = context;
|
_mapper = mapper;
|
}
|
public ResultEntity save(ExpertTestTopicDTO dto)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
|
var checkUserSn = _context.ExpertTestTopics.Where(x => x.Topic == dto.Topic && x.RecStatus == "A" && x.Id != dto.Id).FirstOrDefault();
|
if (checkUserSn != null && (string.IsNullOrWhiteSpace(dto.Id) || (!string.IsNullOrWhiteSpace(dto.Id) && checkUserSn.Id != dto.Id)))
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "试题重复";
|
return resultEntity;
|
}
|
|
|
var entity = _mapper.Map<ExpertTestTopic>(dto);
|
|
|
if (String.IsNullOrEmpty(entity.Id))
|
{
|
entity.Id = Guid.NewGuid().ToString();
|
dto.Id = entity.Id;
|
_context.ExpertTestTopics.Add(entity);
|
}
|
else
|
{
|
var updateproject = _context.ExpertTestTopics.Find(entity.Id);
|
|
updateproject.Topictype = entity.Topictype;
|
updateproject.Zhishitype = entity.Zhishitype;
|
|
|
updateproject.Topic = entity.Topic;
|
updateproject.Area = entity.Area;
|
|
|
updateproject.Zhongdian = entity.Zhongdian;
|
updateproject.JiexiStatus = entity.JiexiStatus;
|
updateproject.ShenpiStatus = entity.ShenpiStatus;
|
|
updateproject.RecStatus = entity.RecStatus;
|
updateproject.Modifier = entity.Modifier;
|
updateproject.Modifytime = entity.Modifytime;
|
updateproject.Jiexi = entity.Jiexi;
|
}
|
|
|
//子表
|
|
var expertTestTopicanwsers = _context.ExpertTestTopicanwsers.Where(x => x.Topic == dto.Id).ToList();
|
if (expertTestTopicanwsers != null && expertTestTopicanwsers.Count > 0)
|
{
|
foreach (var expertTestTopicanwser in expertTestTopicanwsers)
|
{
|
_context.ExpertTestTopicanwsers.Remove(expertTestTopicanwser);
|
}
|
}
|
var anwserno = dto.anwserno;
|
if (anwserno != null && anwserno.Length > 0)
|
{
|
for (int i = 0; i < anwserno.Length; i++)
|
{
|
if (!string.IsNullOrEmpty(dto.anwserno[i]))
|
{
|
ExpertTestTopicanwser expertTestTopicanwser = new ExpertTestTopicanwser();
|
|
expertTestTopicanwser.Id = Guid.NewGuid().ToString();
|
expertTestTopicanwser.Topic = dto.Id;
|
|
|
expertTestTopicanwser.Anwserno = dto.anwserno[i];
|
expertTestTopicanwser.Anwser = dto.Anwser[i];
|
expertTestTopicanwser.Shifouzhengqu = dto.Shifouzhengqu[i];
|
expertTestTopicanwser.Creater = dto.Modifier;
|
expertTestTopicanwser.Createtime = DateTime.Now;
|
expertTestTopicanwser.Modifier = dto.Modifier;
|
expertTestTopicanwser.Modifytime = DateTime.Now;
|
_context.ExpertTestTopicanwsers.Add(expertTestTopicanwser);
|
}
|
}
|
}
|
|
|
|
//解析
|
|
var expertTestTopicjiexis = _context.ExpertTestTopicjiexis.Where(x => x.Topic == dto.Id).ToList();
|
if (expertTestTopicjiexis != null && expertTestTopicjiexis.Count > 0)
|
{
|
foreach (var expertTestTopicjiexi in expertTestTopicjiexis)
|
{
|
_context.ExpertTestTopicjiexis.Remove(expertTestTopicjiexi);
|
}
|
}
|
var Falv = dto.Falv;
|
if (Falv != null && Falv.Length > 0)
|
{
|
for (int i = 0; i < Falv.Length; i++)
|
{
|
if (!string.IsNullOrEmpty(dto.Falv[i]))
|
{
|
ExpertTestTopicjiexi expertTestTopicjiexi = new ExpertTestTopicjiexi();
|
|
expertTestTopicjiexi.Id = Guid.NewGuid().ToString();
|
expertTestTopicjiexi.Topic = dto.Id;
|
|
|
expertTestTopicjiexi.Falv = dto.Falv[i];
|
expertTestTopicjiexi.Fatiao = dto.Fatiao[i];
|
expertTestTopicjiexi.Flag = dto.Flag[i];
|
expertTestTopicjiexi.Creater = dto.Modifier;
|
expertTestTopicjiexi.Createtime = DateTime.Now;
|
expertTestTopicjiexi.Modifier = dto.Modifier;
|
expertTestTopicjiexi.Modifytime = DateTime.Now;
|
_context.ExpertTestTopicjiexis.Add(expertTestTopicjiexi);
|
}
|
}
|
}
|
|
|
|
_context.SaveChanges();
|
resultEntity.ReturnID = entity.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
|
}
|
return resultEntity;
|
}
|
|
public ExpertTestTopicDTO Get(string id)
|
{
|
|
var entity = _context.ExpertTestTopics.Find(id);
|
|
if (entity.RecStatus != "A")
|
{
|
entity = new ExpertTestTopic();
|
}
|
|
var result = _mapper.Map<ExpertTestTopicDTO>(entity);
|
|
|
return result;
|
}
|
|
public ResultDataEntity<ExpertTestTopicDTO> SearchByPaging(ExpertTestTopicDTOSearch searchEntity)
|
{
|
|
|
|
ResultDataEntity<ExpertTestTopicDTO> data = new ResultDataEntity<ExpertTestTopicDTO>();
|
List<ExpertTestTopicDTO> list = new List<ExpertTestTopicDTO>();
|
|
|
|
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
|
}
|
);
|
|
///ExpertTestTopics
|
var query = (from a in _context.ExpertTestTopics
|
|
|
join e in listCode.Where(x => x.CodeTable == "expert_test_topic" && x.CodeField == "topictype")
|
on a.Topictype equals e.CodeSn
|
into esssss
|
from eee in esssss.DefaultIfEmpty()
|
|
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()
|
|
join g in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou")
|
on a.Zhongdian equals g.CodeSn
|
into gsssss
|
from ggg in gsssss.DefaultIfEmpty()
|
|
join h in listCode.Where(x => x.CodeTable == "expert_test_topic" && x.CodeField == "jiexi_status")
|
on a.JiexiStatus equals h.CodeSn
|
into hsssss
|
from hhh in hsssss.DefaultIfEmpty()
|
|
|
join i in listCode.Where(x => x.CodeTable == "expert_test_topic" && x.CodeField == "shenpi_status")
|
on a.ShenpiStatus equals i.CodeSn
|
into isssss
|
from iii in isssss.DefaultIfEmpty()
|
|
|
join j in listCode.Where(x => x.CodeTable == "expert_test_topicjiexi" && x.CodeField == "falv")
|
on a.ShenpiStatus equals j.CodeSn
|
into jsssss
|
from jjj in jsssss.DefaultIfEmpty()
|
|
|
join k in _context.Areas
|
on a.Area equals k.CodeId
|
into ksssss
|
from kkk in ksssss.DefaultIfEmpty()
|
|
|
//join ll in ( from aaa in _context.ExpertTestTopicanwsers.Where(x => x.RecStatus == "A").Select(e => new { Topic = e.Topic, Items = e.Anwserno + " " + e.Anwser + "</br>" }).GroupBy(e => new { e.Topic })
|
// let ids = aaa.Select(b => b.Items.ToString()).ToArray()
|
|
// select new { Topic = aaa.Key.Topic, Items = String.Join(" ", ids) }
|
// //.Select(eg => new
|
// //{
|
// // Topic = eg.Key.Topic,
|
// // //EmployeeName = eg.First().EmployeeName,
|
// // Items = eg.Select(i => i.Anwserno) + " " + eg.Select(i => i.Anwser) + "</br>",
|
// //})
|
// )
|
//on a.Id equals ll.Topic
|
// into llsssss
|
//from llll in llsssss.DefaultIfEmpty()
|
|
|
|
|
|
|
where a.RecStatus == "A"
|
|
&& (string.IsNullOrWhiteSpace(searchEntity.Topictype) || a.Topictype == searchEntity.Topictype.Trim())
|
&& (string.IsNullOrWhiteSpace(searchEntity.Zhishitype) || a.Zhishitype == searchEntity.Zhishitype.Trim())
|
&& (string.IsNullOrWhiteSpace(searchEntity.Zhongdian) || a.Zhongdian == searchEntity.Zhongdian.Trim())
|
&& (string.IsNullOrWhiteSpace(searchEntity.JiexiStatus) || a.JiexiStatus == searchEntity.JiexiStatus.Trim())
|
&& (string.IsNullOrWhiteSpace(searchEntity.ShenpiStatus) || a.ShenpiStatus == searchEntity.ShenpiStatus.Trim())
|
&& (string.IsNullOrWhiteSpace(searchEntity.Topic) || a.Topic.Contains(searchEntity.Topic.Trim()))
|
&& (string.IsNullOrWhiteSpace(searchEntity.Area) || a.Area == searchEntity.Area.Trim())
|
|
|
|
|
|
|
select new ExpertTestTopicDTO
|
{
|
Id = a.Id,
|
Topictype = a.Topictype,
|
TopictypeName = eee.Comments,
|
Zhishitype = a.Zhishitype,
|
ZhishitypeName = fff.Comments,
|
Topic = a.Topic + "</br>" /*+ llll.Items*/,
|
Zhongdian = a.Zhongdian,
|
ZhongdianName = ggg.Comments,
|
JiexiStatus = a.JiexiStatus,
|
JiexiStatusName = hhh.Comments,
|
Jiexi = a.Jiexi,
|
ShenpiStatus = a.ShenpiStatus,
|
ShenpiStatusName = iii.Comments,
|
Area = a.Area,
|
AreaName = kkk.Name,
|
|
|
Creater = a.Creater,
|
Createtime = a.Createtime,
|
|
RecStatus = a.RecStatus,
|
Modifier = a.Modifier,
|
Modifytime = a.Modifytime,
|
|
}
|
).OrderByDescending(x => x.Modifytime).ToList();
|
|
|
|
|
|
|
//if (searchEntity.totalrows == 0)
|
searchEntity.totalrows = query.Count();
|
var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
|
|
var lianlist11 = lianlist.Select(x => x.Id).ToList();
|
|
var querydels = (from aaa in _context.ExpertTestTopicanwsers.Where(x => x.RecStatus == "A" && lianlist11.Contains(x.Topic) ) select aaa).ToList();
|
|
foreach(var lian in lianlist)
|
{
|
var querydel = querydels.Where(x => x.Topic == lian.Id).OrderBy(x=>x.Anwserno).ToList();
|
|
foreach (var quer in querydel)
|
{
|
lian.Topic += quer.Anwserno + " " + quer.Anwser + " </br>";
|
}
|
}
|
|
|
data.LoadData(searchEntity, lianlist);
|
return data;
|
}
|
|
|
|
|
|
|
/// <summary>
|
/// 修改主表状态
|
/// </summary>
|
/// <param name="id">主id</param>
|
/// <param name="userid">用户</param>
|
/// <returns></returns>
|
public ResultEntity ModifyStatus(string id, string userid)
|
{
|
ResultEntity result = new ResultEntity();
|
result.Result = true;
|
|
var model = _context.ExpertTestTopics.Find(id);
|
if (model != null)
|
{
|
model.RecStatus = "D";
|
model.Modifier = userid;
|
model.Modifytime = DateTime.Now;
|
_context.SaveChanges();
|
}
|
|
return result;
|
}
|
|
|
/// <summary>
|
/// 获取所有有效角色
|
/// </summary>
|
/// <returns></returns>
|
public List<ExpertTestTopicDTO> GetList()
|
{
|
|
|
var listRole = _context.ExpertTestTopics.Where(r => r.RecStatus == "A").ToList();
|
|
|
var list = _mapper.Map<List<ExpertTestTopicDTO>>(listRole);
|
return list;
|
}
|
|
public ResultEntity saveanwser(ExpertTestTopicanwserDTO dto)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
|
|
var entity = _mapper.Map<ExpertTestTopicanwser>(dto);
|
|
|
if (String.IsNullOrEmpty(entity.Id))
|
{
|
entity.Id = Guid.NewGuid().ToString();
|
dto.Id = entity.Id;
|
_context.ExpertTestTopicanwsers.Add(entity);
|
}
|
else
|
{
|
var updateproject = _context.ExpertTestTopicanwsers.Find(entity.Id);
|
|
updateproject.Topic = entity.Topic;
|
updateproject.Anwserno = entity.Anwserno;
|
|
|
updateproject.Anwser = entity.Anwser;
|
updateproject.Shifouzhengqu = entity.Shifouzhengqu;
|
|
|
|
|
updateproject.RecStatus = entity.RecStatus;
|
updateproject.Modifier = entity.Modifier;
|
updateproject.Modifytime = entity.Modifytime;
|
|
}
|
|
_context.SaveChanges();
|
resultEntity.ReturnID = entity.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
|
}
|
return resultEntity;
|
}
|
|
/// <summary>
|
/// 获取所有有效角色
|
/// </summary>
|
/// <returns></returns>
|
public List<ExpertTestTopicanwserDTO> GetListanwser(string topicId = "")
|
{
|
|
|
var listRole = _context.ExpertTestTopicanwsers.Where(r => r.RecStatus == "A").ToList();
|
if (!string.IsNullOrEmpty(topicId))
|
{
|
listRole = listRole.Where(x=>x.Topic == topicId).OrderBy(x=>x.Anwserno).ToList();
|
}
|
|
var list = _mapper.Map<List<ExpertTestTopicanwserDTO>>(listRole);
|
return list;
|
}
|
|
|
public ResultEntity savejiexi(ExpertTestTopicjiexiDTO dto)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
|
|
var entity = _mapper.Map<ExpertTestTopicjiexi>(dto);
|
|
|
if (String.IsNullOrEmpty(entity.Id))
|
{
|
entity.Id = Guid.NewGuid().ToString();
|
dto.Id = entity.Id;
|
_context.ExpertTestTopicjiexis.Add(entity);
|
}
|
else
|
{
|
var updateproject = _context.ExpertTestTopicjiexis.Find(entity.Id);
|
|
updateproject.Topic = entity.Topic;
|
updateproject.Falv = entity.Falv;
|
|
|
updateproject.Fatiao = entity.Fatiao;
|
updateproject.Jiexi = entity.Jiexi;
|
|
updateproject.Flag = entity.Flag;
|
|
|
updateproject.RecStatus = entity.RecStatus;
|
updateproject.Modifier = entity.Modifier;
|
updateproject.Modifytime = entity.Modifytime;
|
|
}
|
|
_context.SaveChanges();
|
resultEntity.ReturnID = entity.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
|
}
|
return resultEntity;
|
}
|
|
/// <summary>
|
/// 获取所有有效角色
|
/// </summary>
|
/// <returns></returns>
|
public List<ExpertTestTopicjiexiDTO> GetListjiexi(string topicId = "")
|
{
|
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 = (from a in _context.ExpertTestTopicjiexis
|
|
join e in listCode.Where(x => x.CodeTable == "expert_test_topicjiexi" && x.CodeField == "falv")
|
on a.Falv equals e.CodeSn
|
into esssss
|
from eee in esssss.DefaultIfEmpty()
|
|
join f in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou")
|
on a.Flag equals f.CodeSn
|
into fsssss
|
from fff in fsssss.DefaultIfEmpty()
|
|
|
where a.RecStatus == "A"
|
&& (string.IsNullOrWhiteSpace(topicId) || a.Topic == topicId.Trim())
|
select new ExpertTestTopicjiexiDTO
|
{
|
Id = a.Id,
|
Topic = a.Topic,
|
Falv = a.Falv,
|
FalvName = eee.Comments,
|
Fatiao = a.Fatiao,
|
Flag = a.Flag,
|
FlagName = fff.Comments,
|
Jiexi = a.Jiexi,
|
|
Creater = a.Creater,
|
Createtime = a.Createtime,
|
|
RecStatus = a.RecStatus,
|
Modifier = a.Modifier,
|
Modifytime = a.Modifytime,
|
|
}
|
).OrderBy(x => x.Flag).ThenByDescending(x=>x.Modifytime).ToList();
|
|
return listRole;
|
}
|
|
|
|
public ResultEntity shenpi(ExpertTestTopicDTO dto)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
var updateproject = _context.ExpertTestTopics.Find(dto.Id);
|
|
updateproject.ShenpiStatus = dto.ShenpiStatus;
|
updateproject.Modifier = dto.Modifier;
|
updateproject.Modifytime = dto.Modifytime;
|
|
|
|
_context.SaveChanges();
|
resultEntity.ReturnID = dto.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
|
}
|
return resultEntity;
|
}
|
|
|
public ResultDataEntity<ExpertTestTopicjiexiDTO> SearchByPagingjiexi(ExpertTestTopicDTOSearch searchEntity)
|
{
|
|
|
|
ResultDataEntity<ExpertTestTopicjiexiDTO> data = new ResultDataEntity<ExpertTestTopicjiexiDTO>();
|
List<ExpertTestTopicjiexiDTO> list = new List<ExpertTestTopicjiexiDTO>();
|
|
|
|
|
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 query = (from a in _context.ExpertTestTopicjiexis
|
|
join e in listCode.Where(x => x.CodeTable == "expert_test_topicjiexi" && x.CodeField == "falv")
|
on a.Falv equals e.CodeSn
|
into esssss
|
from eee in esssss.DefaultIfEmpty()
|
|
join f in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou")
|
on a.Flag equals f.CodeSn
|
into fsssss
|
from fff in fsssss.DefaultIfEmpty()
|
|
|
where a.RecStatus == "A"
|
&& (string.IsNullOrWhiteSpace(searchEntity.TopicId) || a.Topic == searchEntity.TopicId.Trim())
|
&& (string.IsNullOrWhiteSpace(searchEntity.Falv) || a.Falv == searchEntity.Falv.Trim())
|
select new ExpertTestTopicjiexiDTO
|
{
|
Id = a.Id,
|
Topic = a.Topic,
|
Falv = a.Falv,
|
FalvName = eee.Comments,
|
Fatiao = a.Fatiao,
|
Flag = a.Flag,
|
FlagName = fff.Comments,
|
Jiexi = a.Jiexi,
|
|
Creater = a.Creater,
|
Createtime = a.Createtime,
|
|
RecStatus = a.RecStatus,
|
Modifier = a.Modifier,
|
Modifytime = a.Modifytime,
|
|
}
|
).OrderBy(x => x.Flag).ThenByDescending(x => x.Modifytime).ToList();
|
|
|
|
//if (searchEntity.totalrows == 0)
|
searchEntity.totalrows = query.Count();
|
var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
|
|
|
|
|
data.LoadData(searchEntity, lianlist);
|
return data;
|
}
|
|
public ExpertTestTopicjiexiDTO Getjiexi(string id)
|
{
|
|
var entity = _context.ExpertTestTopicjiexis.Find(id);
|
|
if (entity.RecStatus != "A")
|
{
|
entity = new ExpertTestTopicjiexi();
|
}
|
|
var result = _mapper.Map<ExpertTestTopicjiexiDTO>(entity);
|
|
|
return result;
|
}
|
|
|
/// <summary>
|
/// 修改主表状态
|
/// </summary>
|
/// <param name="id">主id</param>
|
/// <param name="userid">用户</param>
|
/// <returns></returns>
|
public ResultEntity ModifyStatusjiexi(string id, string userid)
|
{
|
ResultEntity result = new ResultEntity();
|
result.Result = true;
|
|
var model = _context.ExpertTestTopicjiexis.Find(id);
|
if (model != null)
|
{
|
model.RecStatus = "D";
|
model.Modifier = userid;
|
model.Modifytime = DateTime.Now;
|
_context.SaveChanges();
|
}
|
|
return result;
|
}
|
|
|
/// <summary>
|
/// 获取所有有效角色
|
/// </summary>
|
/// <returns></returns>
|
public List<ExpertTestResultDTO> GetListResult()
|
{
|
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 = (from a in _context.ExpertTestResults
|
|
join e in listCode.Where(x => x.CodeTable == "expert_test_result" && x.CodeField == "resulttype")
|
on a.Resulttype equals e.CodeSn
|
into esssss
|
from eee in esssss.DefaultIfEmpty()
|
|
|
|
where a.RecStatus == "A"
|
//&& (string.IsNullOrWhiteSpace(topicId) || a.Topic == topicId.Trim())
|
select new ExpertTestResultDTO
|
{
|
Id = a.Id,
|
Resulttype = a.Resulttype,
|
|
ResulttypeName = eee.Comments,
|
Result = a.Result,
|
|
|
Creater = a.Creater,
|
Createtime = a.Createtime,
|
|
RecStatus = a.RecStatus,
|
Modifier = a.Modifier,
|
Modifytime = a.Modifytime,
|
|
}
|
).OrderBy(x => x).ToList();
|
|
return listRole;
|
}
|
|
|
/// <summary>
|
/// 获取所有有效角色
|
/// </summary>
|
/// <returns></returns>
|
public List<ExpertTestTopicpeizhiDTO> GetListpeizhi()
|
{
|
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 = (from a in _context.ExpertTestTopicpeizhis
|
|
join e in listCode.Where(x => x.CodeTable == "expert_test_topic" && x.CodeField == "topictype")
|
on a.Topictype equals e.CodeSn
|
into esssss
|
from eee in esssss.DefaultIfEmpty()
|
|
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()
|
|
|
where a.RecStatus == "A"
|
//&& (string.IsNullOrWhiteSpace(topicId) || a.Topic == topicId.Trim())
|
select new ExpertTestTopicpeizhiDTO
|
{
|
Id = a.Id,
|
ShijianId = a.ShijianId,
|
Topictype = a.Topictype,
|
TopictypeName = eee.Comments,
|
Zhishitype = a.Zhishitype,
|
ZhishitypeName = fff.Comments,
|
Fenshu = a.Fenshu,
|
Fenzhi = a.Fenzhi,
|
|
Creater = a.Creater,
|
Createtime = a.Createtime,
|
|
RecStatus = a.RecStatus,
|
Modifier = a.Modifier,
|
Modifytime = a.Modifytime,
|
|
}
|
).OrderBy(x => x.Topictype).ThenBy(x => x.Zhishitype).ToList();
|
|
return listRole;
|
}
|
|
|
public ResultEntity saveResult(ExpertTestResultDTO dto)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
|
|
var entity = _mapper.Map<ExpertTestResult>(dto);
|
|
|
if (String.IsNullOrEmpty(entity.Id))
|
{
|
entity.Id = Guid.NewGuid().ToString();
|
dto.Id = entity.Id;
|
_context.ExpertTestResults.Add(entity);
|
}
|
else
|
{
|
var updateproject = _context.ExpertTestResults.Find(entity.Id);
|
|
updateproject.Resulttype = entity.Resulttype;
|
updateproject.Result = entity.Result;
|
|
|
|
|
|
updateproject.RecStatus = entity.RecStatus;
|
updateproject.Modifier = entity.Modifier;
|
updateproject.Modifytime = entity.Modifytime;
|
|
}
|
|
_context.SaveChanges();
|
resultEntity.ReturnID = entity.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
|
}
|
return resultEntity;
|
}
|
|
|
|
public ResultEntity savepeizhi(ExpertTestTopicpeizhiDTO dto)
|
{
|
ResultEntity resultEntity = new ResultEntity();
|
try
|
{
|
|
|
var entity = _mapper.Map<ExpertTestTopicpeizhi>(dto);
|
|
|
if (String.IsNullOrEmpty(entity.Id))
|
{
|
entity.Id = Guid.NewGuid().ToString();
|
dto.Id = entity.Id;
|
_context.ExpertTestTopicpeizhis.Add(entity);
|
}
|
else
|
{
|
var updateproject = _context.ExpertTestTopicpeizhis.Find(entity.Id);
|
|
updateproject.ShijianId = entity.ShijianId;
|
updateproject.Topictype = entity.Topictype;
|
updateproject.Zhishitype = entity.Zhishitype;
|
updateproject.Fenshu = entity.Fenshu;
|
updateproject.Fenzhi = entity.Fenzhi;
|
|
|
|
|
|
updateproject.RecStatus = entity.RecStatus;
|
updateproject.Modifier = entity.Modifier;
|
updateproject.Modifytime = entity.Modifytime;
|
|
}
|
|
_context.SaveChanges();
|
resultEntity.ReturnID = entity.Id;
|
resultEntity.Result = true;
|
}
|
catch (Exception ex)
|
{
|
resultEntity.Result = false;
|
resultEntity.Message = "保存失败，请联系管理员";
|
|
}
|
return resultEntity;
|
}
|
|
}
|
}
|
