public ActionResult Edit(int classId, int id = 0) { var vm = new Models.ClassGroup.Edit(); vm.ClassId = classId; if (id != 0) { using (var db = new XkSystem.Models.DbContext()) { vm.ClassGroupEdit = (from p in db.Table <Basis.Entity.tbClassGroup>() where p.Id == id select new Dto.ClassGroup.Edit() { Id = p.Id, No = p.No, ClassGroupName = p.ClassGroupName, TeacherId = p.tbTeacher.Id, ClassName = p.tbClass.ClassName, TeacherCode = p.tbTeacher.TeacherCode + "(" + p.tbTeacher.TeacherName + ")" }).FirstOrDefault(); } } vm.TeacherList = Teacher.Controllers.TeacherController.SelectList1(vm.ClassGroupEdit.TeacherId); return(View(vm)); }
public ActionResult Edit(Models.ClassGroup.Edit vm) { var error = new List <string>(); if (error.Count == decimal.Zero) { using (var db = new XkSystem.Models.DbContext()) { var classGroupList = db.Table <Basis.Entity.tbClassGroup>() .Include(d => d.tbTeacher) .Where(d => d.tbClass.Id == vm.ClassId).ToList(); //var teacherCode = vm.ClassGroupEdit.TeacherCode.Split(new char[] { '(', ')' })[0]; //var teacherName = vm.ClassGroupEdit.TeacherCode.Split(new char[] { '(', ')' })[1]; if (vm.ClassGroupEdit.Id > 0) { //判断重名 if (classGroupList.Where(d => d.ClassGroupName == vm.ClassGroupEdit.ClassGroupName).Count() > 1) { error.Add("小组名称重复!"); return(Code.MvcHelper.Post(error)); } var tb = classGroupList.Where(d => d.Id == vm.ClassGroupEdit.Id).FirstOrDefault(); tb.No = vm.ClassGroupEdit.No; tb.ClassGroupName = vm.ClassGroupEdit.ClassGroupName; tb.tbTeacher = db.Set <Teacher.Entity.tbTeacher>().Find(vm.ClassGroupEdit.TeacherId); //tb.tbTeacher = db.Table<Teacher.Entity.tbTeacher>().Where(d => d.TeacherCode == teacherCode && d.TeacherName == teacherName).FirstOrDefault(); } else { //判断重名 if (classGroupList.Where(d => d.ClassGroupName == vm.ClassGroupEdit.ClassGroupName).Count() > 0) { error.Add("小组名称重复!"); return(Code.MvcHelper.Post(error)); } var tb = new Basis.Entity.tbClassGroup() { ClassGroupName = vm.ClassGroupEdit.ClassGroupName, No = vm.ClassGroupEdit.No, tbClass = db.Set <Basis.Entity.tbClass>().Find(vm.ClassId), tbTeacher = db.Set <Teacher.Entity.tbTeacher>().Find(vm.ClassGroupEdit.TeacherId) //tbTeacher = db.Table<Teacher.Entity.tbTeacher>().Where(d => d.TeacherCode == teacherCode && d.TeacherName == teacherName).FirstOrDefault() }; db.Set <Basis.Entity.tbClassGroup>().Add(tb); } if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加/修改了行政班小组"); } } } return(Code.MvcHelper.Post(error)); }