private void RptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType != ListItemType.Item && e.Item.ItemType != ListItemType.AlternatingItem)
{
return;
}
var keywordId = SqlUtils.EvalInt(e.Item.DataItem, nameof(KeywordInfo.Id));
var keyword = SqlUtils.EvalString(e.Item.DataItem, nameof(KeywordInfo.Keyword));
var alternative = SqlUtils.EvalString(e.Item.DataItem, nameof(KeywordInfo.Alternative));
var grade = EKeywordGradeUtils.GetEnumType(SqlUtils.EvalString(e.Item.DataItem, nameof(KeywordInfo.Grade)));
var ltlKeyword = (Literal)e.Item.FindControl("ltlKeyword");
var ltlAlternative = (Literal)e.Item.FindControl("ltlAlternative");
var ltlGrade = (Literal)e.Item.FindControl("ltlGrade");
var ltlEdit = (Literal)e.Item.FindControl("ltlEdit");
var ltlDelete = (Literal)e.Item.FindControl("ltlDelete");
ltlKeyword.Text = keyword;
ltlAlternative.Text = alternative;
ltlGrade.Text = EKeywordGradeUtils.GetText(grade);
ltlEdit.Text =
$@"<a href='javascript:;' onclick=""{ModalKeywordAdd.GetOpenWindowStringToEdit(keywordId)}"">编辑</a>";
var urlDelete = PageUtils.GetSettingsUrl(nameof(PageSiteKeyword), new NameValueCollection
{
{ "Delete", "True" },
{ "KeywordID", keywordId.ToString() }
});
ltlDelete.Text =
$@"<a href=""{urlDelete}"" onClick=""javascript:return confirm('此操作将删除关键字“{keyword}”确认吗？')"";>删除</a>";
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_keywordId = AuthRequest.GetQueryInt("KeywordID");
if (IsPostBack)
{
return;
}
EKeywordGradeUtils.AddListItems(DdlGrade);
if (_keywordId <= 0)
{
return;
}
var keywordInfo = DataProvider.KeywordDao.GetKeywordInfo(_keywordId);
TbKeyword.Text = keywordInfo.Keyword;
TbAlternative.Text = keywordInfo.Alternative;
ControlUtils.SelectSingleItem(DdlGrade, EKeywordGradeUtils.GetValue(keywordInfo.Grade));
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
if (!IsPostBack)
{
EKeywordGradeUtils.AddListItems(ddlGrade);
}
}
public void Update(KeywordInfo keywordInfo)
{
var parms = new IDataParameter[]
{
GetParameter(ParmKeyword, DataType.VarChar, 50, keywordInfo.Keyword),
GetParameter(ParmAlternative, DataType.VarChar, 50, keywordInfo.Alternative),
GetParameter(ParmGrade, DataType.VarChar, 50, EKeywordGradeUtils.GetValue(keywordInfo.Grade)),
GetParameter(ParmId, DataType.Integer, keywordInfo.Id)
};
ExecuteNonQuery(SqlUpdate, parms);
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
if (_keywordId > 0)
{
try
{
var keywordInfo = DataProvider.KeywordDao.GetKeywordInfo(_keywordId);
keywordInfo.Keyword = tbKeyword.Text.Trim();
keywordInfo.Alternative = tbAlternative.Text.Trim();
keywordInfo.Grade = EKeywordGradeUtils.GetEnumType(ddlGrade.SelectedValue);
DataProvider.KeywordDao.Update(keywordInfo);
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "修改敏感词失败！");
}
}
else
{
if (DataProvider.KeywordDao.IsExists(tbKeyword.Text))
{
FailMessage("敏感词添加失败，敏感词名称已存在！");
}
else
{
try
{
var keywordInfo = new KeywordInfo
{
Keyword = tbKeyword.Text.Trim(),
Alternative = tbAlternative.Text.Trim(),
Grade = EKeywordGradeUtils.GetEnumType(ddlGrade.SelectedValue)
};
DataProvider.KeywordDao.Insert(keywordInfo);
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "添加敏感词失败！");
}
}
}
if (isChanged)
{
PageUtils.CloseModalPage(Page);
}
}
public void Insert(KeywordInfo keywordInfo)
{
var sqlString = "INSERT INTO siteserver_Keyword(Keyword, Alternative, Grade) VALUES(@Keyword, @Alternative, @Grade)";
var parms = new IDataParameter[]
{
GetParameter(ParmKeyword, DataType.VarChar, 50, keywordInfo.Keyword),
GetParameter(ParmAlternative, DataType.VarChar, 50, keywordInfo.Alternative),
GetParameter(ParmGrade, DataType.VarChar, 50, EKeywordGradeUtils.GetValue(keywordInfo.Grade))
};
ExecuteNonQuery(sqlString, parms);
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
try
{
var grade = EKeywordGradeUtils.GetEnumType(ddlGrade.SelectedValue);
var keywordArray = tbKeywords.Text.Split(',');
foreach (var item in keywordArray)
{
if (!string.IsNullOrEmpty(item))
{
var value = item.Trim();
var keyword = string.Empty;
var alternative = string.Empty;
if (value.IndexOf('|') != -1)
{
keyword = value.Split('|')[0];
alternative = value.Split('|')[1];
}
else
{
keyword = value;
}
if (!string.IsNullOrEmpty(keyword) && !DataProvider.KeywordDao.IsExists(keyword))
{
var keywordInfo = new KeywordInfo(0, keyword, alternative, grade);
DataProvider.KeywordDao.Insert(keywordInfo);
}
}
}
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "导入敏感词失败");
}
if (isChanged)
{
PageUtils.CloseModalPage(Page);
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_keywordId = Body.GetQueryInt("KeywordID");
if (!IsPostBack)
{
EKeywordGradeUtils.AddListItems(ddlGrade);
if (_keywordId > 0)
{
var keywordInfo = DataProvider.KeywordDao.GetKeywordInfo(_keywordId);
tbKeyword.Text = keywordInfo.Keyword;
tbAlternative.Text = keywordInfo.Alternative;
ControlUtils.SelectListItems(ddlGrade, EKeywordGradeUtils.GetValue(keywordInfo.Grade));
}
}
}
public KeywordInfo GetKeywordInfo(int id)
{
var keywordInfo = new KeywordInfo();
var parms = new IDataParameter[]
{
GetParameter(ParmId, DataType.Integer, id)
};
using (var rdr = ExecuteReader(SqlSelect, parms))
{
if (rdr.Read())
{
var i = 0;
keywordInfo = new KeywordInfo(GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), EKeywordGradeUtils.GetEnumType(GetString(rdr, i)));
}
rdr.Close();
}
return(keywordInfo);
}
public List <KeywordInfo> GetKeywordInfoList(List <string> keywords)
{
if (keywords == null || keywords.Count == 0)
{
return(new List <KeywordInfo>());
}
var list = new List <KeywordInfo>();
string sqlSelectKeywords =
$"SELECT Id, Keyword, Alternative, Grade FROM siteserver_Keyword WHERE Keyword IN ({TranslateUtils.ToSqlInStringWithQuote(keywords)})";
using (var rdr = ExecuteReader(sqlSelectKeywords))
{
while (rdr.Read())
{
var i = 0;
var keywordInfo = new KeywordInfo(GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), EKeywordGradeUtils.GetEnumType(GetString(rdr, i)));
list.Add(keywordInfo);
}
rdr.Close();
}
return(list);
}
public List <KeywordInfo> GetKeywordInfoList()
{
var list = new List <KeywordInfo>();
using (var rdr = ExecuteReader(SqlSelectAll))
{
while (rdr.Read())
{
var i = 0;
var keywordInfo = new KeywordInfo(GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), EKeywordGradeUtils.GetEnumType(GetString(rdr, i)));
list.Add(keywordInfo);
}
rdr.Close();
}
return(list);
}