public JsonResult ImportExcel() { if (Request.Form.Files.Count == 0) { return(Json(new Result() { success = false, msg = "请上传文件!" })); } else { int i = 0; var file = Request.Form.Files[i]; if (null == file || file.Length <= 0) { return(Json(new Result() { success = false, msg = "上传文件格式不正确!" })); } //if(Request.ContentLength > maxRequestLength) //{ // return Json(new Result() { success = false, msg = "文件大小超出限制!" }); //} Random ra = new Random(); string filename = DateTime.Now.ToString("yyyyMMddHHmmssffffff") + i + Path.GetExtension(file.FileName); string DirUrl = _hostingEnvironment.ContentRootPath + "/temp/"; if (!System.IO.Directory.Exists(DirUrl)) //检测文件夹是否存在,不存在则创建 { System.IO.Directory.CreateDirectory(DirUrl); } string path = AppDomain.CurrentDomain.BaseDirectory + "/temp/" + filename; using (var fileStream = new FileStream(path, FileMode.Create)) file.CopyToAsync(fileStream).Wait(); DataTable dt = GetData(Path.Combine(path, filename)); var service = _iSensitiveWordService; foreach (DataRow dr in dt.Rows) { if (service.ExistSensitiveWord(dr[1].ToString()) == false) { var model = new Entities.SensitiveWordInfo() { CategoryName = dr[0].ToString(), SensitiveWord = dr[1].ToString() }; service.AddSensitiveWord(model); } } return(Json(new Result() { success = true, msg = "导入成功!" })); } }
public JsonResult Eidt(int id, string word, string category) { var model = new Entities.SensitiveWordInfo() { Id = id, SensitiveWord = word, CategoryName = category }; _iSensitiveWordService.UpdateSensitiveWord(model); return(Json(new Result() { success = true, msg = "修改成功!" })); }
public JsonResult Add(string word, string category) { var service = _iSensitiveWordService; if (service.ExistSensitiveWord(word) == false) { var model = new Entities.SensitiveWordInfo() { SensitiveWord = word, CategoryName = category }; service.AddSensitiveWord(model); return(Json(new Result() { success = true, msg = "添加成功!" })); } else { return(Json(new Result() { success = false, msg = "该敏感关键词已存在!" })); } }