public static string InsertDefault(XkSystem.Models.DbContext db, int electiveId) { var tb = new Entity.tbElectiveSection(); tb.No = 1; tb.tbElective = db.Set <Entity.tbElective>().Find(electiveId); tb.ElectiveSectionName = "默认分段"; tb.MaxElective = 99; tb.MinElective = 0; db.Set <Entity.tbElectiveSection>().Add(tb); if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了选课时段"); } return(string.Empty); }
public ActionResult Edit(Models.ElectiveSection.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); if (vm.ElectiveSectionEdit.MaxElective < vm.ElectiveSectionEdit.MinElective) { error.AddError("最大选课数和最小选课数设置错误,无法比较大小!"); } if (error.Count == decimal.Zero) { if (db.Table <Entity.tbElectiveSection>().Where(d => d.ElectiveSectionName == vm.ElectiveSectionEdit.ElectiveSectionName && d.tbElective.Id == vm.ElectiveId && d.Id != vm.ElectiveSectionEdit.Id).Any()) { error.AddError("该选课分段已存在!"); } else { if (vm.ElectiveSectionEdit.Id == 0) { var tb = new Entity.tbElectiveSection(); tb.No = vm.ElectiveSectionEdit.No == null?db.Table <Entity.tbElectiveSection>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.ElectiveSectionEdit.No; tb.tbElective = db.Set <Entity.tbElective>().Find(vm.ElectiveId); tb.ElectiveSectionName = vm.ElectiveSectionEdit.ElectiveSectionName; tb.MaxElective = vm.ElectiveSectionEdit.MaxElective; tb.MinElective = vm.ElectiveSectionEdit.MinElective; db.Set <Entity.tbElectiveSection>().Add(tb); if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了选课时段"); } } else { var tb = (from p in db.Table <Entity.tbElectiveSection>() where p.Id == vm.ElectiveSectionEdit.Id select p).FirstOrDefault(); if (tb != null) { tb.No = vm.ElectiveSectionEdit.No == null?db.Table <Entity.tbElectiveSection>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.ElectiveSectionEdit.No; tb.ElectiveSectionName = vm.ElectiveSectionEdit.ElectiveSectionName; tb.MaxElective = vm.ElectiveSectionEdit.MaxElective; tb.MinElective = vm.ElectiveSectionEdit.MinElective; if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改了选课时段"); } } else { error.AddError(Resources.LocalizedText.MsgNotFound); } } } } return(Code.MvcHelper.Post(error)); } }