/// <summary> /// 上传工资Excel /// </summary> /// <returns></returns> public JsonResult UpLoadSalary() { var models = new ActionResultModel <string> { isSuccess = false, respnseInfo = "" }; if (Request.Files.Count <= 0) { return(Json(models)); } if (Request.Files[0].ContentLength / 1024.0 / 1024.0 >= 1000) { models.respnseInfo = "文件超过1000M!"; return(Json(models)); } string fileName = DateTime.Now.ToString("yyyyMMddHHmmss"); string saveFolder = Server.MapPath("/UpLoadFile/PushObjectImport/" + fileName + Path.GetExtension(Request.Files[0].FileName)); Request.Files[0].SaveAs(saveFolder); UploadHelper uploadHelper = new UploadHelper(); DataTable dt = uploadHelper.GetDataByExcel(saveFolder, true); System.IO.File.Delete(saveFolder); if (dt.Rows.Count == 0) { models.respnseInfo = "表格不能为空!"; return(Json(models)); } try { models.isSuccess = _dl.SaveUpLoadSalary(dt); models.respnseInfo = "1"; } catch (Exception ex) { models.respnseInfo = ex.Message; } return(Json(models)); }