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 = "该敏感关键词已存在！"
}));
}
}
