public ActionResult List() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.SurveyClass.List(); vm.SurveyName = db.Table <Entity.tbSurvey>().FirstOrDefault(d => d.Id == vm.SurveyId).SurveyName; return(View(vm)); } }
public ActionResult List(Models.SurveyClass.List vm) { using (var db = new XkSystem.Models.DbContext()) { var classList = new List <int>(); if (string.IsNullOrEmpty(vm.ClassIds) == false) { classList = vm.ClassIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(d => d.ConvertToInt()).ToList(); classList.RemoveAll(d => d == 0); } var surveyClassList = (from p in db.Table <Entity.tbSurveyClass>() .Include(d => d.tbClass) where p.tbSurvey.Id == vm.SurveyId select p).ToList(); foreach (var a in surveyClassList.Where(d => classList.Contains(d.tbClass.Id) == false)) { a.IsDeleted = true; } var list = new List <Entity.tbSurveyClass>(); foreach (var a in classList.Where(d => surveyClassList.Select(q => q.tbClass.Id).Contains(d) == false)) { var tb = new Entity.tbSurveyClass(); tb.tbSurvey = db.Set <Entity.tbSurvey>().Find(vm.SurveyId); tb.tbClass = db.Set <Basis.Entity.tbClass>().Find(a); list.Add(tb); } db.Set <Entity.tbSurveyClass>().AddRange(list); if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加参评班级"); } if (Request["Step"] != null) { return(Code.MvcHelper.Post(null, Url.Action("List", "SurveyGroup", new { surveyId = vm.SurveyId }))); } else { return(Code.MvcHelper.Post(null, Url.Action("List", "Survey", new { searchText = vm.SearchText }))); } } }