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);
}
