public JsonResult ImportExcel()
{
if (Request.Files.Count == 0)
{
return(Json(new Result()
{
success = false, msg = "请上传文件！"
}));
}
else
{
int i = 0;
var file = Request.Files[i];
if (null == file || file.ContentLength <= 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 = Server.MapPath("~/temp/");
if (!System.IO.Directory.Exists(DirUrl)) //检测文件夹是否存在，不存在则创建
{
System.IO.Directory.CreateDirectory(DirUrl);
}
string path = AppDomain.CurrentDomain.BaseDirectory + "/temp/";
file.SaveAs(Path.Combine(path, filename));
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 SensitiveWordsInfo()
{
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 SensitiveWordsInfo()
{
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 SensitiveWordsInfo()
{
SensitiveWord = word, CategoryName = category
};
service.AddSensitiveWord(model);
return(Json(new Result()
{
success = true, msg = "添加成功！"
}));
}
else
{
return(Json(new Result()
{
success = false, msg = "该敏感关键词已存在！"
}));
}
}
