/// <summary> /// 离校:休学,转学,开除,退学,出国,其他 /// </summary> /// <returns></returns> public ActionResult StudentOutSchool(int id = 0) { var vm = new Models.StudentChange.StudentOutSchool(); vm.StudentChangeTypeList = StudentChangeTypeController.SelectList(Code.EnumHelper.StudentChangeType.OutSchool); 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.StudentOutSchool() { Id = p.Id, StudentId = p.tbStudent.Id, StudentChangeTypeId = p.tbStudentChangeType.Id, StudentCode = p.tbStudent.StudentCode, StudentName = p.tbStudent.StudentName, Remark = p.Remark }).FirstOrDefault(); } } return(View(vm)); }
public ActionResult StudentOutSchool(Models.StudentChange.StudentOutSchool 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.IsDeleted = true; tb.tbStudent.tbSysUser.IsDisable = true; if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加学生调动"); } } } return(Code.MvcHelper.Post(error)); }