public ActionResult ImportUserInfo(HttpPostedFileBase file)
{
if (file == null)
{
return(View());
}
MemoryStream ms = new MemoryStream();
file.InputStream.CopyTo(ms);
DataTable dt = ExcelHelper.ImportExcel(ms);
IList <UserInfoDataObject> list = new List <UserInfoDataObject>();
IList <DepartmentDataObject> deptList = this.departmentService.GetList();
IList <DutiesDataObject> dutiesList = this.dutiesService.GetList();
foreach (DataRow row in dt.Rows)
{
UserInfoDataObject userInfo = new UserInfoDataObject();
userInfo.WorkNo = row[0].ToString();
userInfo.UserName = row[1].ToString();
userInfo.Password = "******";
DepartmentDataObject dept = deptList.FirstOrDefault(p => p.Name == row[2].ToString());
userInfo.DepartmentID = dept == null ? 0 : dept.ID;
userInfo.Professional = row[3].ToString();
DutiesDataObject duty = dutiesList.FirstOrDefault(p => p.Name == row[4].ToString());
userInfo.DutiesID = duty == null ? 0 : duty.ID;
userInfo.MajorLeader = row[5].ToString() == "是" ? true : false;
userInfo.Director = row[6].ToString() == "是";
userInfo.Instructor = row[7].ToString() == "是";
userInfo.Secretary = row[8].ToString() == "是";
list.Add(userInfo);
}
int count = this.userInfoService.Import(list);
ViewData["Msg"] = string.Format("{0}条数据导入成功!", count);
return(View());
}
public void DeleteDuties(DutiesDataObject duty)
{
this.dutiesService.RemoveById(duty.ID);
}
public void SaveDuties(DutiesDataObject duty)
{
this.dutiesService.Update(duty);
}
