//根据 id 批量删除 学生信息 20200828 public BaseViewModel batchdelStudentInfo(List <int> ids, string memo) { BaseViewModel baseView = new BaseViewModel(); int i = 0, j = 0; string names = ""; foreach (var id in ids) { Student_Info info = _studentInfoRepository.getbyID(id); if (info != null) { // 保存到备份数据库 Student_Info_Delete info_Delete = new Student_Info_Delete(); info_Delete = _IMapper.Map <Student_Info, Student_Info_Delete>(info); info_Delete.id = Guid.NewGuid().ToString(); info_Delete.Student_id = info.id; info_Delete.Memo = memo; _deleteStudentInfo.Add(info_Delete); int m = _deleteStudentInfo.SaveChanges(); _studentInfoRepository.RemoveInfo(info); int n = _studentInfoRepository.SaveChanges(); if (n > 0) { i++; } else { j++; names += info.Name + ","; } } else { j++; names += "该id=" + id + "未找到学生信息,"; } } if (j > 0) { baseView.ResponseCode = 1; baseView.Message = "删除成功:" + i.ToString() + "条数据;删除失败:" + j + "条数据。删除失败姓名包括:" + names; } else { baseView.ResponseCode = 0; baseView.Message = "全部删除成功共:" + i.ToString() + "条数据"; } return(baseView); }
//根据id获取学生信息 public Student_Info_Delete getbyID(int id) { Student_Info_Delete info = new Student_Info_Delete(); //查询条件 var predicate = WhereExtension.True <Student_Info_Delete>();//初始化where表达式 predicate = predicate.And(p => p.Student_id.Equals(id)); var result = DbSet.Where(predicate).ToList(); if (result.Count > 0) { info = result.First(); } else { info = null; } return(info); }
public void Update(Student_Info_Delete obj) { DbSet.Update(obj); }
public void Add(Student_Info_Delete obj) { DbSet.Add(obj); }
//删除信息 public void RemoveInfo(Student_Info_Delete info) { DbSet.Remove(info); }
//根据 id 批量学生 信息批量 升班 public BaseViewModel BatchChangeStudentInfo(StudentChangeInfo model) { BaseViewModel baseView = new BaseViewModel(); int i = 0, j = 0; foreach (var id in model.ids) { Student_Info info = _studentInfoRepository.getbyID(id); if (info != null) { // 保存到备份数据库 Student_Info_Delete info_Delete = new Student_Info_Delete(); info_Delete = _IMapper.Map <Student_Info, Student_Info_Delete>(info); info_Delete.id = Guid.NewGuid().ToString(); info_Delete.Student_id = info.id; info_Delete.Memo = model.Memo; _deleteStudentInfo.Add(info_Delete); int m = _deleteStudentInfo.SaveChanges(); //修改基本信息的 年级、班级信息 //获取年级信息 info.GradeCode = model.GradeCode; var grades = _gradeInfoRepository.getnameInfoBycode(model.GradeCode); if (grades != null) { info.GradeName = grades.GradeName; } //获取班级信息 var classes = _classInfoRepository.getNameInfoBycode(model.ClassCode); if (classes != null) { info.ClassName = classes.ClassName; } info.ClassCode = model.ClassCode; _studentInfoRepository.Update(info); int n = _studentInfoRepository.SaveChanges(); if (n > 0) { i++; } else { j++; } } else { j++; } } if (j > 0) { baseView.ResponseCode = 1; baseView.Message = "修改成功:" + i.ToString() + "条数据;修改失败:" + j + "条数据"; } else { baseView.ResponseCode = 0; baseView.Message = "全部修改成功共:" + i.ToString() + "条数据"; } return(baseView); }