public JsonResult UploadProductsExcel(HttpPostedFileBase fileData) { if (fileData != null) { try { // 文件上传后的保存路径 string tmpStr = ""; if (Request.Params.AllKeys.Contains("toPath")) { tmpStr = Request.Params["toPath"].ToString(); } else { tmpStr = PubFunction.GetUploadFilePathUsingDate(); } string filePath = Server.MapPath("/Uploads/"); if (!string.IsNullOrEmpty(tmpStr)) { filePath = Server.MapPath(tmpStr); } if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } string fileName = Path.GetFileName(fileData.FileName); // 原始文件名称 string fileExtension = Path.GetExtension(fileName); // 文件扩展名 string saveName = Guid.NewGuid().ToString() + fileExtension; // 保存文件名称 fileData.SaveAs(filePath + saveName); tmpStr = tmpStr.TrimStart(new char[] { '~' }); //处理上传的Excel文件 Dictionary <string, StringToMemberDG> dict = new Dictionary <string, StringToMemberDG>(); dict.Add("ProductTags", new StringToMemberDG(MTSHelper.ListToString)); dict.Add("SaleCountLST", new StringToMemberDG(MTSHelper.ListToString)); IEnumerable <Product> productArr = PubFunction.LoadFromExcel <Product>(filePath + saveName, dict); if (productArr == null) { //文件不存在 } else { foreach (Product item in productArr) { db.Products.Add(item); } db.SaveChanges(); } return(Json(new { Success = true, FileName = fileName, SaveName = saveName, imgSrc = tmpStr + saveName })); } catch (Exception ex) { return(Json(new { Success = false, Message = ex.Message }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { Success = false, Message = "请选择要上传的文件!" }, JsonRequestBehavior.AllowGet)); } }