//根据 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);
}
