public ActionResult Upload(HttpPostedFileBase[] fileCollection)
{
AjaxResult ar = new Globals.AjaxResult();
if (fileCollection.First() == null)
{
ar.state = ResultType.error.ToString();
ar.message = "上传的文件为空，请重新上传";
return(Json(ar, JsonRequestBehavior.AllowGet));
}
var currentUser = LoginManager.GetCurrentUser();
List <string> fileList = new List <string>();
fileList = FileManager.SaveFile(fileCollection, Server.MapPath("~/Files"));
List <Information> informationList = new List <Information>();
List <CustomItem> customItemList = new List <CustomItem>();
_customItemBLL.GetCustomItems(currentUser.Account, ref customItemList);
List <CustomItemValue> customItemValueList = new List <CustomItemValue>();
try
{
foreach (var item in fileList)
{
List <Information> tempInforList = new List <Information>();
_excelManager.Open(item);
_excelManager.GetDataFromExcel(currentUser.Account, ref tempInforList, ref customItemList, ref customItemValueList);
_excelManager.Close(); //关闭并删除文件
informationList.AddRange(tempInforList);
}
}
catch (Exception ex)
{
LogHelper.writeLog_error(ex.Message);
LogHelper.writeLog_error(ex.StackTrace);
ar.state = ResultType.error.ToString();
ar.message = "解析数据失败";
return(Json(ar, JsonRequestBehavior.AllowGet));
}
bool state = _dataManager.ExcelToDataBase(informationList, currentUser, customItemList, customItemValueList);
if (state)
{
ar.state = ResultType.success.ToString();
ar.message = "导入成功";
}
else
{
ar.state = ResultType.error.ToString();
ar.message = "导入数据失败";
}
return(Json(ar, JsonRequestBehavior.AllowGet));
}