public ActionResult UploadExcel()
{
var files = Request.Files;
if (files.Count < 1)
{
return(Json(new { Status = false, Msg = "请选择文件" }, JsonRequestBehavior.AllowGet));
}
var file = files[0];
if (file.ContentType != "application/vnd.ms-excel" &&
file.ContentType != "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
return(Json(new { Status = false, Msg = "请上传Excel文件" }, JsonRequestBehavior.AllowGet));
}
var convertResult = ConvertExcelToList(file);
if (!string.IsNullOrEmpty(convertResult.Item2))
{
return(Json(new { Status = false, Msg = convertResult.Item2 }, JsonRequestBehavior.AllowGet));
}
else if (convertResult.Item1 == null || !convertResult.Item1.Any())
{
return(Json(new { Status = false, Msg = "Excel内容为空" }, JsonRequestBehavior.AllowGet));
}
else
{
var manager = new PaintDiscountConfigManager();
var user = User.Identity.Name;
var result = manager.UploadPaintDiscountConfig(convertResult.Item1, user);
return(Json(new { Status = result, Msg = $"导入{(result ? "成功" : "失败")}" }
, JsonRequestBehavior.AllowGet));
}
}