public void ProcessFile(string FileName, string EntityClassName)
{
#region 通过文件名、类型获取文件信息
var saveFileInfo = SaveExcelHelper.GetExcelFileInfo(EntityClassName, FileName);
#endregion
#region 通过组件获取实体
var errorEntities = new List <EntityBase>();
var validEntities = ExcelToEntityHelper.GetEntities(saveFileInfo.EntityType, saveFileInfo, out errorEntities);
#endregion
#region 分批持久化数据并反馈进度
var msg = string.Empty;
var processInfo = BatchProcessUtility.GetProcessInfo(validEntities.Count, 10);
for (int i = 0; i < processInfo.TotalPage; i++)
{
try
{
var batchEntities = validEntities.Skip(i * processInfo.PageRecord).Take(processInfo.PageRecord).ToList();
var currentBatchCount = batchEntities.Count();
#region 通过组件持久化实体
EntityToDBHelper.ImportEntitiesWidthBulkCopy(saveFileInfo.EntityType, batchEntities);
#endregion
if (processInfo.IsNewPersent(i + 1, currentBatchCount))
{
Response.Write("<script>parent.fUpdateProcess(" + processInfo.CurrentPersent + "," + processInfo.NeedSeconds + ")</script>");
Response.Flush();
}
}
catch (Exception ex)
{
msg = "处理完成，但处理过程中发生异常：" + ex.Message + ex.StackTrace;
}
}
#endregion
#region 通过组件生成导入错误文件
var errorFileInfo = new ExcelFileInfo(string.Empty, EntityClassName);
if (errorEntities.Count > 0)
{
errorFileInfo = ErrorEntityToFileHelper.WriteFile(saveFileInfo.EntityType, errorEntities);
}
#endregion
#region 反馈最后的导入结果
if (string.IsNullOrEmpty(msg))
{
msg = "处理完成";
}
Response.Write("<script>parent.fProcessResult('" + msg + "','" + errorFileInfo.FileName + "','" + errorFileInfo.EntityClassName + "')</script>");
Response.Flush();
#endregion
}
public ActionResult SubmitUpload(HttpPostedFileBase SubmitFile, string EntityClassName)
{
#region 已知类型调用组件实现导入
/*var fileName = DateTime.Now.ToString("yyyMMddHHmmss") + SubmitFile.FileName;
* var filePath = Request.MapPath("~/UploadFiles");
* var saveFilePathAndName = Path.Combine(filePath, fileName);
*
* SubmitFile.SaveAs(saveFilePathAndName);
*
* var type = Type.GetType("TestDataSourceModel");
*
#region 通过组件获取实体
*
* var fileInfo = new ExcelFileInfo(filePath,fileName);
*
* var errorEntities = new List<TestDataSourceModel>();
*
* var stopWatch = new Stopwatch();
* stopWatch.Start();
* var validEntities= ExcelToEntityHelper.GetEntities<TestDataSourceModel>(fileInfo, out errorEntities);
* stopWatch.Stop();
#endregion
*
#region 通过组件持久化实体
* var stopWatch1 = new Stopwatch();
* stopWatch1.Start();
* EntityToDBHelper.ImportEntitiesWidthBulkCopy<TestDataSourceModel>(validEntities);
* stopWatch1.Stop();
#endregion
*
#region 通过组件生成导入错误文件
* var errorFileInfo = ErrorEntityToFileHelper.GetFile<TestDataSourceModel>(errorEntities);
#endregion
*
* return View("UploadResult", errorFileInfo);*/
#endregion
#region 只知道类型名，调用组件实现导入
#region 通过组件保存文件
var fileName = SubmitFile.FileName;
var fileContent = new byte[SubmitFile.ContentLength];
SubmitFile.InputStream.Read(fileContent, 0, SubmitFile.ContentLength);
var submitExcelInfo = new ExcelFileInfo(fileName, EntityClassName, fileContent);
var saveExcelHelper = new SaveExcelHelper(submitExcelInfo);
var saveFileInfo = saveExcelHelper.SaveFile();
#endregion
#region 通过组件获取实体
var errorEntities = new List <EntityBase>();
var validEntities = ExcelToEntityHelper.GetEntities(saveFileInfo.EntityType, saveFileInfo, out errorEntities);
#endregion
#region 通过组件持久化实体
EntityToDBHelper.ImportEntitiesWidthBulkCopy(saveFileInfo.EntityType, validEntities);
#endregion
#region 通过组件生成导入错误文件
var errorFileInfo = ErrorEntityToFileHelper.WriteFile(saveFileInfo.EntityType, errorEntities);
#endregion
return(View("UploadResult", errorFileInfo));
#endregion
}
public ActionResult ImportError(string EntityClassName, string FileName)
{
var entityType = TypeHelper.GetType(EntityClassName);
return(this.File(ErrorEntityToFileHelper.GetFilePathAndName(entityType, FileName), "application/ms-excel", FileName));
}
