public ActionResult UploadStaffInfo(HttpPostedFileBase excelFileName)
{
if (excelFileName.ContentLength <= 0)
{
return(RedirectToAction("Index"));
}
string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + Path.GetFileName(excelFileName.FileName);
string extName = Path.GetExtension(excelFileName.FileName);
if (extName != ".xlsx")
{
return(RedirectToAction("Index", new { error = enumErrorCode.FileOnlyExcel }));
}
string serverPath = Path.Combine(Server.MapPath("~/Uploads"), fileName);
excelFileName.SaveAs(serverPath);
List <StaffInfo> staffList = new List <StaffInfo>();
enumErrorCode result = Excel.CheckAndReadStaffInfo(serverPath, staffList);
if (result == enumErrorCode.HandlerSuccess)
{
try
{
foreach (StaffInfo staff in staffList)
{
FactoryRoom tempRoom = db.FactoryRoom.FirstOrDefault(item => item.RoomNumber == staff.DeptNumber);
staff.DeptId = tempRoom.RoomID;
staff.DeptName = tempRoom.RoomName;
db.StaffInfo.Add(staff);
//同步管理账户
WebSecurity.CreateUserAndAccount(staff.Number, staff.Phone);
}
db.SaveChanges();
}
catch
{
result = enumErrorCode.ExcelContentError;
}
}
return(RedirectToAction("Index", new { error = result }));
}
