/// <summary> /// 导入Excell数据 /// </summary> /// <returns></returns> public ActionResult ImportExel() { int IsOk = 1; //导入状态 DataTable Result = new DataTable(); //导入错误记录表 try { string moduleId = Request["moduleId"];//表名 StringBuilder sb_table = new StringBuilder(); HttpFileCollectionBase files = Request.Files; HttpPostedFileBase file = files["filePath"]; //获取上传的文件 string fullname = file.FileName; string IsXls = System.IO.Path.GetExtension(fullname).ToString().ToLower(); //System.IO.Path.GetExtension获得文件的扩展名 if (IsXls != ".xls" && IsXls != ".xlsx") { IsOk = 0; } else { string filename = Guid.NewGuid().ToString() + ".xls"; if (fullname.IndexOf(".xlsx") > 0) { filename = Guid.NewGuid().ToString() + ".xlsx"; } if (file != null && file.FileName != "") { string msg = UploadHelper.FileUpload(file, Server.MapPath("~/Resource/UploadFile/ImportExcel/"), filename); } DataTable dt = ImportExcel.ExcelToDataTable("Sheet1", Server.MapPath("~/Resource/UploadFile/ImportExcel/") + filename); IsOk = Baseexceliportbll.ImportExcel(moduleId, dt, out Result); } } catch (Exception ex) { BaseSysLogBll.Instance.WriteLog("", OperationType.Add, "-1", "异常错误:" + ex.Message); IsOk = 0; } if (Result.Rows.Count > 0) { IsOk = 0; } var JsonData = new { Status = IsOk > 0 ? "true" : "false", ResultData = Result }; return(Content(Util.Json.ToJson(JsonData))); }