public ActionResult InputMultipleEdit(int id = 0) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.PerformDataDay.InputMultipleEdit(); var tbPerformItem = (from p in db.Table <Entity.tbPerformItem>() where p.Id == vm.PerformItemId && p.IsSelect && p.IsMany select p).FirstOrDefault(); if (tbPerformItem == null) { } else { vm.PerformOptionList = PerformOptionController.SelectList(vm.PerformItemId); } if (id != 0) { var tb = (from p in db.Table <Entity.tbPerformData>() where p.Id == id select new Dto.PerformDataDay.InputMultipleEdit { Id = p.Id, PerformItemName = p.tbPerformItem.PerformItemName, StudentCode = p.tbStudent.StudentCode, StudentName = p.tbStudent.StudentName, Score = p.Score, PerformOptionId = p.tbPerformOption == null ? 0 : p.tbPerformOption.Id }).FirstOrDefault(); if (tb != null) { vm.PerformInputMultipleEdit = tb; } } else { vm.PerformInputMultipleEdit.PerformItemName = db.Set <Entity.tbPerformItem>().Find(vm.PerformItemId).PerformItemName; vm.PerformInputMultipleEdit.StudentName = db.Set <Student.Entity.tbStudent>().Find(vm.StudentId).StudentName; } return(View(vm)); } }
public ActionResult InputMultipleList() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.PerformDataDay.InputMultipleList(); vm.PerformInputMultipleList = (from p in db.Table <Entity.tbPerformData>() where p.tbPerformItem.Id == vm.PerformItemId && p.tbStudent.Id == vm.StudentId && p.tbPerformItem.IsDeleted == false && p.tbCourse.IsDeleted == false select new Dto.PerformDataDay.InputMultipleList { Id = p.Id, PerformItemId = p.tbPerformItem.Id, PerformItemName = p.tbPerformItem.PerformItemName, PerformOptionId = p.tbPerformOption == null ? 0 : p.tbPerformOption.Id, PerformOptionValue = p.tbPerformOption == null ? 0 : p.tbPerformOption.OptionValue, StudentName = p.tbStudent.StudentName, StudentCode = p.tbStudent.StudentCode, StudentId = p.tbStudent.Id, Score = p.Score, InputDate = p.InputDate, SysUserName = p.tbSysUser.UserName }).ToList(); var tbPerformItem = (from p in db.Table <Entity.tbPerformItem>() where p.Id == vm.PerformItemId && p.IsSelect && p.IsMany select p).FirstOrDefault(); if (tbPerformItem == null) { } else { vm.PerformOptionList = PerformOptionController.SelectList(vm.PerformItemId); } return(View(vm)); } }