public List <ExamTypeDTO> getExamTypeList()
{
using (IDbSvc dbSvc = new DbSvc(_configSvc))
{
try
{
dbSvc.OpenConnection();
MySqlCommand command = new MySqlCommand();
command.CommandText = "select ExamTypeId, ExamTypeDescription from examtypes where Active=1";
command.Connection = dbSvc.GetConnection() as MySqlConnection;
_dtData = new DataTable();
MySqlDataAdapter msDa = new MySqlDataAdapter(command);
msDa.Fill(_dtData);
List <ExamTypeDTO> lstexamType = new List <ExamTypeDTO>();
if (_dtData != null && _dtData.Rows.Count > 0)
{
ExamTypeDTO examType = null;
foreach (DataRow dr in _dtData.Rows)
{
examType = new ExamTypeDTO();
examType.ExamTypeId = (int)dr["ExamTypeId"];
examType.ExamTypeDescription = dr["ExamTypeDescription"].ToString();
lstexamType.Add(examType);
}
}
return(lstexamType);
}
catch (Exception exp)
{
throw exp;
}
}
}
public ActionResult Edit(ExamTypeDTO model)
{
examTypeService.Edit(model);
return(Json(new AjaxResult {
Status = "ok"
}));
}
public ExamTypeDTO ToDTO(ExamTypeEntity ef)
{
ExamTypeDTO dto = new ExamTypeDTO();
dto.Description = ef.Description;
dto.Name = ef.Name;
dto.Id = ef.Id;
return(dto);
}
public void Add(ExamTypeDTO model)
{
using (MyDbContext ctx = new MyDbContext())
{
ExamTypeEntity ef = new ExamTypeEntity();
ef.Description = model.Description;
ef.Name = model.Name;
ctx.ExamTypes.Add(ef);
ctx.SaveChanges();
}
}
public ActionResult Add(string name, string description)
{
ExamTypeDTO dto = new ExamTypeDTO();
dto.Description = description;
dto.Name = name;
examTypeService.Add(dto);
return(Json(new AjaxResult {
Status = "ok"
}));
}
public SelectList getExamTypeDropDown()
{
List <ExamTypeDTO> rDto = _ddlRepo.getExamType();
ExamTypeDTO examtypeDTO = new ExamTypeDTO();
examtypeDTO.ExamTypeId = -1;
examtypeDTO.ExamTypeDescription = "";
rDto.Insert(0, examtypeDTO);
return(new SelectList(rDto, "ExamTypeId", "ExamTypeDescription"));
}
public void Edit(ExamTypeDTO model)
{
using (MyDbContext ctx = new MyDbContext())
{
BaseService <ExamTypeEntity> bs = new BaseService <ExamTypeEntity>(ctx);
var data = bs.GetById(model.Id);
if (data == null)
{
throw new ArgumentNullException("没有找到记录id=" + model.Id);
}
data.Name = model.Name;
data.Description = model.Description;
ctx.SaveChanges();
}
}
public SearchResult Search(SearchOpt options)
{
using (MyDbContext ctx = new MyDbContext())
{
BaseService <ExamEntity> bs = new BaseService <ExamEntity>(ctx);
BaseService <ExamTypeEntity> bsType = new BaseService <ExamTypeEntity>(ctx);
var items = bs.GetAll();
if (options.TypeId != null && options.TypeId != 9999)
{
items = items.Where(t => t.ExamTypes.Id == options.TypeId);
}
if (!string.IsNullOrEmpty(options.Keywords))
{
items = items.Where(t => t.StuName == options.Keywords ||
t.SFZCode == options.Keywords ||
t.ZKZCode == options.Keywords);
}
if (options.IsLook != null && options.IsLook != 2)
{
if (options.IsLook == 0)
{
items = items.Where(t => t.IsLook == false);
}
else
{
items = items.Where(t => t.IsLook == true);
}
}
var typeids = bsType.GetAll().Select(e => e.Id);
items = items.Where(m => typeids.Contains(m.TypeId));
long totalCount = items.LongCount();//总搜索结果条数
items = items.Include(e => e.ExamTypes).OrderByDescending(t => t.CreateDateTime).Skip((options.CurrentIndex - 1) * options.PageSize)
.Take(options.PageSize);
SearchResult res = new SearchResult();
res.totalCount = totalCount;
List <ExamDTO> exams = new List <ExamDTO>();
foreach (var item in items)
{
exams.Add(ToDTO(item));
}
res.result = exams.ToArray();
List <ExamTypeDTO> examTypes = new List <ExamTypeDTO>();
var efexamTypes = bsType.GetAll();
ExamTypeDTO dtotype2 = new ExamTypeDTO();
dtotype2.Description = "所有";
dtotype2.Name = "全部";
dtotype2.Id = 9999;
examTypes.Add(dtotype2);
foreach (var item in efexamTypes)
{
ExamTypeDTO dtotype = new ExamTypeDTO();
dtotype.Description = item.Description;
dtotype.Name = item.Name;
dtotype.Id = item.Id;
examTypes.Add(dtotype);
}
res.examType = examTypes.ToArray();
return(res);
}
}