//添加教职工信息
public BaseViewModel addFacultystaffInfo(FacultystaffBaseModel model)
{
BaseViewModel viewModel = new BaseViewModel();
try
{
//验证 学校 是否存在
if (_schoolInfoRepository.CheckInfo(model.SchoolCode, model.SchoolName))
{
facultystaff_Info info = new facultystaff_Info();
info = _IMapper.Map <FacultystaffBaseModel, facultystaff_Info>(model);
info.CreateDate = DateTime.Now;
_facultystaffInfoRepository.Add(info);
_userInfoRepository.AddDefault(info.IdNumber);
int i = _facultystaffInfoRepository.SaveChanges();
if (i > 0)
{
viewModel.ResponseCode = 0;
viewModel.Message = "信息添加成功";
}
else
{
viewModel.ResponseCode = 1;
viewModel.Message = "信息添加失败";
}
}
else
{
viewModel.ResponseCode = 6;
viewModel.Message = "学校信息不存在";
}
}
catch (Exception ex)
{
viewModel.ResponseCode = 3;
viewModel.Message = "出现异常";
}
return(viewModel);
}
//导入老师以及员工信息
public int InputWhiteListIntoDataBase_facultystaffInfo(string FilePath, string FileName)
{
Student_Info student_Info = new Student_Info();
var aa = student_Info.CreateDate;
var package = new ExcelPackage(new System.IO.FileInfo(FilePath));
var workbook = package.Workbook;
var worksheet = workbook.Worksheets.First();
var facultystaffInfo = worksheet.ConvertSheetToObjects <facultystaff_Info>(FileName).ToList();
_facultystaffInfoRepository.AddList(facultystaffInfo);
return(_facultystaffInfoRepository.SaveChanges());
}
