/// <summary> /// 在校:调班,转入,复学 /// </summary> /// <returns></returns> public ActionResult StudentInSchool(int id = 0) { var vm = new Models.StudentChange.StudentInSchool(); vm.ClassList = Basis.Controllers.ClassController.SelectList(); vm.StudentChangeTypeList = StudentChangeTypeController.SelectList(Code.EnumHelper.StudentChangeType.InSchool); if (id > 0) { using (var db = new XkSystem.Models.DbContext()) { vm.DataEdit = (from p in db.Table <Entity.tbStudentChange>() where p.Id == id select new Dto.StudentChange.StudentInSchool() { Id = p.Id, StudentId = p.tbStudent.Id, StudentChangeTypeId = p.tbStudentChangeType.Id, StudentCode = p.tbStudent.StudentCode, StudentName = p.tbStudent.StudentName, Remark = p.Remark }).FirstOrDefault(); if (db.Table <Basis.Entity.tbClassStudent>().Where(d => d.tbStudent.Id == vm.DataEdit.StudentId).Any()) { vm.DataEdit.ClassId = db.Table <Basis.Entity.tbClassStudent>().Where(d => d.tbStudent.Id == vm.DataEdit.StudentId).Include(d => d.tbClass).FirstOrDefault().tbClass.Id; } } } return(View(vm)); }
public ActionResult StudentInSchool(Models.StudentChange.StudentInSchool vm) { var error = new List <string>(); if (error.Count == decimal.Zero) { using (var db = new XkSystem.Models.DbContext()) { var tb = new Student.Entity.tbStudentChange(); if (vm.DataEdit.Id > 0) { tb = db.Table <Entity.tbStudentChange>().Where(d => d.Id == vm.DataEdit.Id).Include(d => d.tbStudent.tbSysUser).FirstOrDefault(); tb.InputDate = DateTime.Now; tb.Remark = vm.DataEdit.Remark; tb.tbStudentChangeType = db.Set <Student.Entity.tbStudentChangeType>().Find(vm.DataEdit.StudentChangeTypeId); tb.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find(Code.Common.UserId); } else { var studentCode = ""; if (vm.DataEdit.StudentCode.IndexOf('(') > 0) { studentCode = vm.DataEdit.StudentCode.Split('(')[0]; } var student = db.Table <Student.Entity.tbStudent>().Where(d => d.StudentCode == studentCode).Include(d => d.tbSysUser).FirstOrDefault(); if (student == null) { error.Add("学生不存在!"); return(Code.MvcHelper.Post(error)); } tb = new Student.Entity.tbStudentChange() { InputDate = DateTime.Now, Remark = vm.DataEdit.Remark, tbStudent = student, tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find(Code.Common.UserId), tbStudentChangeType = db.Set <Student.Entity.tbStudentChangeType>().Find(vm.DataEdit.StudentChangeTypeId) }; db.Set <Student.Entity.tbStudentChange>().Add(tb); } tb.tbStudent.tbSysUser.IsDisable = false; var classStudent = db.Table <Basis.Entity.tbClassStudent>().Where(d => d.tbStudent.StudentCode == vm.DataEdit.StudentCode).Include(d => d.tbClass).FirstOrDefault(); classStudent.tbClass = db.Set <Basis.Entity.tbClass>().Find(vm.DataEdit.ClassId); if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加学生调动"); } } } return(Code.MvcHelper.Post(error)); }