public ActionResult Edit(Models.ClassAllotStudent.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); if (error.Count == decimal.Zero) { if (vm.ClassAllotStudentEdit.Id != 0) { var tb = db.Set <Basis.Entity.tbClassAllotStudent>().Find(vm.ClassAllotStudentEdit.Id); tb.tbYear = db.Set <Basis.Entity.tbYear>().Find(vm.ClassAllotStudentEdit.YearId); tb.Score = vm.ClassAllotStudentEdit.Score; tb.tbClassType = db.Set <Basis.Entity.tbClassType>().Find(vm.ClassAllotStudentEdit.ClassTypeId); tb.tbGrade = db.Set <Basis.Entity.tbGrade>().Find(vm.ClassAllotStudentEdit.GradeId); tb.tbStudent = db.Table <Student.Entity.tbStudent>().Where(d => d.StudentCode == vm.ClassAllotStudentEdit.StudentCode).FirstOrDefault(); } else { var student = new Student.Entity.tbStudent(); if (db.Table <Student.Entity.tbStudent>().Where(d => d.StudentCode == vm.ClassAllotStudentEdit.StudentCode && d.StudentName == vm.ClassAllotStudentEdit.StudentName).Count() == 0) { var studentEdit = new Student.Dto.Student.Edit() { StudentCode = vm.ClassAllotStudentEdit.StudentCode, StudentName = vm.ClassAllotStudentEdit.StudentName }; var studentEditList = new List <Student.Dto.Student.Edit>(); studentEditList.Add(studentEdit); student = Student.Controllers.StudentController.BuildList(db, studentEditList).FirstOrDefault(); } else { student = db.Table <Student.Entity.tbStudent>().Where(d => d.StudentCode == vm.ClassAllotStudentEdit.StudentCode && d.StudentName == vm.ClassAllotStudentEdit.StudentName).FirstOrDefault(); } var tb = new Basis.Entity.tbClassAllotStudent() { tbYear = db.Set <Basis.Entity.tbYear>().Find(vm.ClassAllotStudentEdit.YearId), Score = vm.ClassAllotStudentEdit.Score, tbClassType = db.Set <Basis.Entity.tbClassType>().Find(vm.ClassAllotStudentEdit.ClassTypeId), tbGrade = db.Set <Basis.Entity.tbGrade>().Find(vm.ClassAllotStudentEdit.GradeId), tbStudent = student }; db.Set <Basis.Entity.tbClassAllotStudent>().Add(tb); } if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加/修改了分班学生"); } } return(Code.MvcHelper.Post(error)); } }
public ActionResult StudentIn(Models.StudentChange.StudentIn vm) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); if (error.Count == decimal.Zero) { var student = new Student.Entity.tbStudent() { StudentCode = vm.DataEdit.StudentCode, StudentName = vm.DataEdit.StudentName, tbSysUser = new Sys.Entity.tbSysUser() { UserCode = vm.DataEdit.StudentCode, UserName = vm.DataEdit.StudentName, Password = Code.Common.DESEnCode("123456"), PasswordMd5 = Code.Common.CreateMD5Hash("123456"), UserType = Code.EnumHelper.SysUserType.Student, tbSex = db.Table <Dict.Entity.tbDictSex>().Where(d => d.SexName == vm.DataEdit.SexName).FirstOrDefault() } }; var 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.Table <Student.Entity.tbStudentChangeType>().Where(d => d.StudentChangeTypeName == "转入").FirstOrDefault() }; db.Set <Student.Entity.tbStudentChange>().Add(tb); var classStudent = new Basis.Entity.tbClassStudent() { tbClass = db.Set <Basis.Entity.tbClass>().Find(vm.DataEdit.ClassId), tbStudent = student }; db.Set <Basis.Entity.tbClassStudent>().Add(classStudent); if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加学生调动"); } } return(Code.MvcHelper.Post(error)); } }
public bool InsertFamily(XkSystem.Models.DbContext db, Student.Entity.tbStudent student, string json) { var error = new List <string>(); if (json.Length > 20) { List <Dto.StudentFamily.InsertFamily> list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Dto.StudentFamily.InsertFamily> >(json); foreach (var v in list) { if (v.Id > 0) { #region 修改 var tb = (from p in db.Table <Student.Entity.tbStudentFamily>() where p.tbStudent.StudentCode == student.StudentCode && p.Id == v.Id select p).FirstOrDefault(); if (tb != null) { tb.FamilyName = v.FamilyName; tb.tbDictKinship = db.Set <Dict.Entity.tbDictKinship>().Find(v.KinshipId); tb.UnitName = v.UnitName; tb.Job = v.Job; tb.Mobile = v.Mobile; tb.tbDictEducation = db.Set <Dict.Entity.tbDictEducation>().Find(v.EducationId); XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改学生家庭成员"); } else { error.AddError(Resources.LocalizedText.MsgNotFound); return(false); } #endregion } else { #region 新增 var tb = new Student.Entity.tbStudentFamily(); tb.tbStudent = student; tb.FamilyName = string.IsNullOrEmpty(v.FamilyName) ? "" : v.FamilyName; tb.tbDictKinship = db.Set <Dict.Entity.tbDictKinship>().Find(v.KinshipId); tb.UnitName = string.IsNullOrEmpty(v.UnitName) ? "" : v.UnitName; tb.Job = string.IsNullOrEmpty(v.Job) ? "" : v.Job; tb.Mobile = string.IsNullOrEmpty(v.Mobile) ? "" : v.Mobile; tb.tbDictEducation = db.Set <Dict.Entity.tbDictEducation>().Find(v.EducationId); db.Set <Student.Entity.tbStudentFamily>().Add(tb); XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加学生家庭成员"); #endregion } } #region 除ID不属于json的全部数据 var familyList = (from p in db.Table <Student.Entity.tbStudentFamily>() where p.tbStudent.StudentCode == student.StudentCode select p).ToList(); foreach (var v in familyList) { if (list.Where(d => d.Id == v.Id).Count() == 0) { v.IsDeleted = true; } } #endregion } return(true); }