public ActionResult List()
{
var vm = new Models.DormData.List();
vm.DormOptionList = DormOptionController.SelectList();
using (var db = new XkSystem.Models.DbContext())
{
var tb = db.Table <Dorm.Entity.tbDormData>();
if (!string.IsNullOrEmpty(vm.SearchText))
{
tb = tb.Where(d => d.tbStudent.StudentCode.Contains(vm.SearchText) || d.tbStudent.StudentName.Contains(vm.SearchText));
}
if (vm.DormOptionId > 0)
{
tb = tb.Where(d => d.tbDormOption.Id == vm.DormOptionId);
}
vm.DormDataList = (from p in tb
orderby p.No
select new Dto.DormData.List()
{
Id = p.Id,
DormOptionName = p.tbDormOption.DormOptionName,
DormOptionValue = p.tbDormOption.DormOptionValue,
InputDate = p.InputDate,
Sex = p.tbStudent.tbSysUser.tbSex.SexName,
StudentCode = p.tbStudent.StudentCode,
StudentName = p.tbStudent.StudentName
}).ToPageList(vm.Page);
}
return(View(vm));
}
public ActionResult Edit(int id = 0)
{
var vm = new Models.DormData.Edit();
if (id > 0)
{
using (var db = new XkSystem.Models.DbContext())
{
vm.DormDataEdit = (from p in db.Table <Dorm.Entity.tbDormData>()
where p.Id == id
select new Dto.DormData.Edit()
{
Id = p.Id,
DormOptionId = p.tbDormOption.Id,
Remark = p.Remark,
StudentCode = p.tbStudent.StudentCode,
StudentName = p.tbStudent.StudentName
}).FirstOrDefault();
}
}
vm.DormOptionList = DormOptionController.SelectList(vm.DormDataEdit.DormOptionId);
return(View(vm));
}