//导入 public ActionResult ImportUser() { string strErrorPath = null; HttpFileCollectionBase httfiles = Request.Files; if (httfiles.Count > 0) { HttpPostedFileBase httpfile = httfiles[0]; try { List <string[]> arrstrmapplst = new List <string[]> { new string[] { "用户编号", "UserCode" }, new string[] { "用户名称", "FullName" }, new string[] { "手机号", "PhoneNumber" }, new string[] { "邮箱", "Email" }, new string[] { "角色", "RoleNamestr" }, new string[] { "经销商", "DistributorNamestr" }, new string[] { "到期日", "StopTime" }, new string[] { "检测情况", "CheckInfo" } }; string strGenarateDir = Server.MapPath(@"~/TempFile"); string strGenarateFile = Guid.NewGuid().ToString("N") + ".xlsx"; string strExportFile = strGenarateDir + "\\" + strGenarateFile; List <ExcelUser> rplst = ExcelHelper.Import <ExcelUser>(httpfile.InputStream, "Sheet1", arrstrmapplst, CheckUserInfo, strExportFile); if (rplst == null) { strErrorPath = strGenarateFile; } else { var boolD = UserAuthorityProvider.ImportUser(rplst); if (!boolD.SubmitResult) { Logger.WriteLog(boolD.Message.ToString()); strErrorPath = "导入失败"; } } } catch (Exception ex) { Logger.WriteLog(ex.ToString()); strErrorPath = "导入失败"; } } return(Json(strErrorPath)); }