public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_keywordId = Body.GetQueryInt("keywordID");
if (!IsPostBack)
{
EMatchTypeUtils.AddListItems(DdlMatchType);
CbIsEnabled.Checked = true;
BtnContentSelect.Attributes.Add("onclick", ModalContentSelect.GetOpenWindowString(PublishmentSystemId, false, "contentSelect"));
BtnChannelSelect.Attributes.Add("onclick", ModalChannelSelect.GetOpenWindowString(PublishmentSystemId, true));
if (_keywordId > 0)
{
var keywordInfo = DataProviderWx.KeywordDao.GetKeywordInfo(_keywordId);
TbKeywords.Text = keywordInfo.Keywords;
ControlUtils.SelectListItems(DdlMatchType, EMatchTypeUtils.GetValue(keywordInfo.MatchType));
CbIsEnabled.Checked = !keywordInfo.IsDisabled;
TbReply.Text = keywordInfo.Reply;
}
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
keywordID = TranslateUtils.ToInt(GetQueryString("keywordID"));
if (!IsPostBack)
{
EMatchTypeUtils.AddListItems(ddlMatchType);
cbIsEnabled.Checked = true;
btnContentSelect.Attributes.Add("onclick", ContentSelect.GetOpenWindowString(PublishmentSystemID, false, "contentSelect"));
btnChannelSelect.Attributes.Add("onclick", CMS.BackgroundPages.Modal.ChannelSelect.GetOpenWindowString(PublishmentSystemID, true));
if (keywordID > 0)
{
var keywordInfo = DataProviderWX.KeywordDAO.GetKeywordInfo(keywordID);
tbKeywords.Text = keywordInfo.Keywords;
ControlUtils.SelectListItems(ddlMatchType, EMatchTypeUtils.GetValue(keywordInfo.MatchType));
cbIsEnabled.Checked = !keywordInfo.IsDisabled;
tbReply.Text = keywordInfo.Reply;
}
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
keywordID = TranslateUtils.ToInt(GetQueryString("keywordID"));
isSingle = TranslateUtils.ToBool(GetQueryString("isSingle"));
if (!IsPostBack)
{
EMatchTypeUtils.AddListItems(ddlMatchType);
cbIsEnabled.Checked = true;
if (keywordID > 0)
{
var keywordInfo = DataProviderWX.KeywordDAO.GetKeywordInfo(keywordID);
tbKeywords.Text = keywordInfo.Keywords;
ControlUtils.SelectListItems(ddlMatchType, EMatchTypeUtils.GetValue(keywordInfo.MatchType));
cbIsEnabled.Checked = !keywordInfo.IsDisabled;
}
else
{
phSelect.Visible = true;
}
}
}
public void Update(KeywordInfo keywordInfo)
{
if (keywordInfo != null && keywordInfo.KeywordId > 0)
{
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, keywordInfo.PublishmentSystemId),
GetParameter(ParmKeywords, EDataType.NVarChar, 255, keywordInfo.Keywords),
GetParameter(ParmIsDisabled, EDataType.VarChar, 18, keywordInfo.IsDisabled.ToString()),
GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordInfo.KeywordType)),
GetParameter(ParmMatchType, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(keywordInfo.MatchType)),
GetParameter(ParmReply, EDataType.NText, keywordInfo.Reply),
GetParameter(ParmAddDate, EDataType.DateTime, keywordInfo.AddDate),
GetParameter(ParmTaxis, EDataType.Integer, keywordInfo.Taxis),
GetParameter(ParmKeywordId, EDataType.Integer, keywordInfo.KeywordId)
};
ExecuteNonQuery(SqlUpdate, parms);
DataProviderWx.KeywordMatchDao.DeleteByKeywordId(keywordInfo.KeywordId);
foreach (var str in TranslateUtils.StringCollectionToStringList(keywordInfo.Keywords, ' '))
{
var keyword = str.Trim();
if (!string.IsNullOrEmpty(keyword))
{
DataProviderWx.KeywordMatchDao.Insert(new KeywordMatchInfo(0, keywordInfo.PublishmentSystemId, keyword, keywordInfo.KeywordId, keywordInfo.IsDisabled, keywordInfo.KeywordType, keywordInfo.MatchType));
}
}
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_keywordId = Body.GetQueryInt("keywordID");
_keyword = Body.GetQueryString("keyword");
if (!IsPostBack)
{
EMatchTypeUtils.AddListItems(DdlMatchType);
CbIsEnabled.Checked = true;
if (_keywordId > 0)
{
var keywordInfo = DataProviderWx.KeywordDao.GetKeywordInfo(_keywordId);
TbKeyword.Text = _keyword;
ControlUtils.SelectListItems(DdlMatchType, EMatchTypeUtils.GetValue(keywordInfo.MatchType));
CbIsEnabled.Checked = !keywordInfo.IsDisabled;
}
}
}
public void Update(KeywordInfo keywordInfo)
{
if (keywordInfo != null && keywordInfo.KeywordID > 0)
{
var parms = new IDataParameter[]
{
GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, keywordInfo.PublishmentSystemID),
GetParameter(PARM_KEYWORDS, EDataType.NVarChar, 255, keywordInfo.Keywords),
GetParameter(PARM_IS_DISABLED, EDataType.VarChar, 18, keywordInfo.IsDisabled.ToString()),
GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordInfo.KeywordType)),
GetParameter(PARM_MATCH_TYPE, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(keywordInfo.MatchType)),
GetParameter(PARM_REPLY, EDataType.NText, keywordInfo.Reply),
GetParameter(PARM_ADD_DATE, EDataType.DateTime, keywordInfo.AddDate),
GetParameter(PARM_TAXIS, EDataType.Integer, keywordInfo.Taxis),
GetParameter(PARM_KEYWORD_ID, EDataType.Integer, keywordInfo.KeywordID)
};
ExecuteNonQuery(SQL_UPDATE, parms);
DataProviderWX.KeywordMatchDAO.DeleteByKeywordID(keywordInfo.KeywordID);
foreach (var str in TranslateUtils.StringCollectionToStringList(keywordInfo.Keywords, ' '))
{
var keyword = str.Trim();
if (!string.IsNullOrEmpty(keyword))
{
DataProviderWX.KeywordMatchDAO.Insert(new KeywordMatchInfo(0, keywordInfo.PublishmentSystemID, keyword, keywordInfo.KeywordID, keywordInfo.IsDisabled, keywordInfo.KeywordType, keywordInfo.MatchType));
}
}
}
}
public int Insert(KeywordInfo keywordInfo)
{
var keywordID = 0;
var sqlString = "INSERT INTO wx_Keyword (PublishmentSystemID, Keywords, IsDisabled, KeywordType, MatchType, Reply, AddDate, Taxis) VALUES (@PublishmentSystemID, @Keywords, @IsDisabled, @KeywordType, @MatchType, @Reply, @AddDate, @Taxis)";
var taxis = GetMaxTaxis(keywordInfo.PublishmentSystemID, keywordInfo.KeywordType) + 1;
var parms = new IDataParameter[]
{
GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, keywordInfo.PublishmentSystemID),
GetParameter(PARM_KEYWORDS, EDataType.NVarChar, 255, keywordInfo.Keywords),
GetParameter(PARM_IS_DISABLED, EDataType.VarChar, 18, keywordInfo.IsDisabled.ToString()),
GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordInfo.KeywordType)),
GetParameter(PARM_MATCH_TYPE, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(keywordInfo.MatchType)),
GetParameter(PARM_REPLY, EDataType.NText, keywordInfo.Reply),
GetParameter(PARM_ADD_DATE, EDataType.DateTime, keywordInfo.AddDate),
GetParameter(PARM_TAXIS, EDataType.Integer, taxis)
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
ExecuteNonQuery(trans, sqlString, parms);
keywordID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, "wx_Keyword");
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
foreach (var str in TranslateUtils.StringCollectionToStringList(keywordInfo.Keywords, ' '))
{
var keyword = str.Trim();
if (!string.IsNullOrEmpty(keyword))
{
DataProviderWX.KeywordMatchDAO.Insert(new KeywordMatchInfo(0, keywordInfo.PublishmentSystemID, keyword, keywordID, keywordInfo.IsDisabled, keywordInfo.KeywordType, keywordInfo.MatchType));
}
}
return(keywordID);
}
public int Insert(KeywordInfo keywordInfo)
{
var keywordId = 0;
var sqlString = "INSERT INTO wx_Keyword (PublishmentSystemID, Keywords, IsDisabled, KeywordType, MatchType, Reply, AddDate, Taxis) VALUES (@PublishmentSystemID, @Keywords, @IsDisabled, @KeywordType, @MatchType, @Reply, @AddDate, @Taxis)";
var taxis = GetMaxTaxis(keywordInfo.PublishmentSystemId, keywordInfo.KeywordType) + 1;
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, keywordInfo.PublishmentSystemId),
GetParameter(ParmKeywords, EDataType.NVarChar, 255, keywordInfo.Keywords),
GetParameter(ParmIsDisabled, EDataType.VarChar, 18, keywordInfo.IsDisabled.ToString()),
GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordInfo.KeywordType)),
GetParameter(ParmMatchType, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(keywordInfo.MatchType)),
GetParameter(ParmReply, EDataType.NText, keywordInfo.Reply),
GetParameter(ParmAddDate, EDataType.DateTime, keywordInfo.AddDate),
GetParameter(ParmTaxis, EDataType.Integer, taxis)
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
keywordId = ExecuteNonQueryAndReturnId(trans, sqlString, parms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
foreach (var str in TranslateUtils.StringCollectionToStringList(keywordInfo.Keywords, ' '))
{
var keyword = str.Trim();
if (!string.IsNullOrEmpty(keyword))
{
DataProviderWx.KeywordMatchDao.Insert(new KeywordMatchInfo(0, keywordInfo.PublishmentSystemId, keyword, keywordId, keywordInfo.IsDisabled, keywordInfo.KeywordType, keywordInfo.MatchType));
}
}
return(keywordId);
}
public void Insert(KeywordMatchInfo matchInfo)
{
var sqlString = "INSERT INTO wx_KeywordMatch (PublishmentSystemID, Keyword, KeywordID, IsDisabled, KeywordType, MatchType) VALUES (@PublishmentSystemID, @Keyword, @KeywordID, @IsDisabled, @KeywordType, @MatchType)";
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, matchInfo.PublishmentSystemId),
GetParameter(ParmKeyword, EDataType.NVarChar, 255, matchInfo.Keyword),
GetParameter(ParmKeywordId, EDataType.Integer, matchInfo.KeywordId),
GetParameter(ParmIsDisabled, EDataType.VarChar, 18, matchInfo.IsDisabled.ToString()),
GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(matchInfo.KeywordType)),
GetParameter(ParmMatchType, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(matchInfo.MatchType))
};
ExecuteNonQuery(sqlString, parms);
}
public void Insert(KeywordMatchInfo matchInfo)
{
var sqlString = "INSERT INTO wx_KeywordMatch (PublishmentSystemID, Keyword, KeywordID, IsDisabled, KeywordType, MatchType) VALUES (@PublishmentSystemID, @Keyword, @KeywordID, @IsDisabled, @KeywordType, @MatchType)";
var parms = new IDataParameter[]
{
GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, matchInfo.PublishmentSystemID),
GetParameter(PARM_KEYWORD, EDataType.NVarChar, 255, matchInfo.Keyword),
GetParameter(PARM_KEYWORD_ID, EDataType.Integer, matchInfo.KeywordID),
GetParameter(PARM_IS_DISABLED, EDataType.VarChar, 18, matchInfo.IsDisabled.ToString()),
GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(matchInfo.KeywordType)),
GetParameter(PARM_MATCH_TYPE, EDataType.VarChar, 50, EMatchTypeUtils.GetValue(matchInfo.MatchType))
};
ExecuteNonQuery(sqlString, parms);
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
try
{
var conflictKeywords = string.Empty;
if (KeywordManager.IsKeywordUpdateConflict(PublishmentSystemId, _keywordId, TbKeyword.Text, out conflictKeywords))
{
FailMessage($"关键词“{conflictKeywords}”已存在，请设置其他关键词");
}
else
{
var keywordInfo = DataProviderWx.KeywordDao.GetKeywordInfo(_keywordId);
var keywordList = TranslateUtils.StringCollectionToStringList(keywordInfo.Keywords, ' ');
var i = keywordList.IndexOf(_keyword);
if (i != -1)
{
keywordList[i] = TbKeyword.Text;
}
keywordInfo.Keywords = TranslateUtils.ObjectCollectionToString(keywordList, " ");
keywordInfo.IsDisabled = !CbIsEnabled.Checked;
keywordInfo.MatchType = EMatchTypeUtils.GetEnumType(DdlMatchType.SelectedValue);
DataProviderWx.KeywordDao.Update(keywordInfo);
Body.AddSiteLog(PublishmentSystemId, "编辑关键词", $"关键词:{_keyword}");
isChanged = true;
}
}
catch (Exception ex)
{
FailMessage(ex, "失败：" + ex.Message);
}
if (isChanged)
{
PageUtils.CloseModalPage(Page);
}
}
public object GetValue(string attributeName)
{
foreach (var name in AllAttributes)
{
if (StringUtils.EqualsIgnoreCase(name, attributeName))
{
var nameVlaue = GetType().GetProperty(name).GetValue(this, null);
if (attributeName == "KeywordType")
{
return(EKeywordTypeUtils.GetEnumType(nameVlaue.ToString()));
}
if (attributeName == "MatchType")
{
return(EMatchTypeUtils.GetEnumType(nameVlaue.ToString()));
}
return(nameVlaue);
}
}
return(null);
}
void dgContents_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var keywordId = SqlUtils.EvalInt(e.Item.DataItem, "KeywordId");
var keywords = SqlUtils.EvalString(e.Item.DataItem, "Keywords");
var reply = SqlUtils.EvalString(e.Item.DataItem, "Reply");
var isDisabled = TranslateUtils.ToBool(SqlUtils.EvalString(e.Item.DataItem, "IsDisabled"));
var matchType = EMatchTypeUtils.GetEnumType(SqlUtils.EvalString(e.Item.DataItem, "MatchType"));
var addDate = SqlUtils.EvalDateTime(e.Item.DataItem, "AddDate");
var ltlReply = e.Item.FindControl("ltlReply") as Literal;
var ltlAddDate = e.Item.FindControl("ltlAddDate") as Literal;
var ltlMatchType = e.Item.FindControl("ltlMatchType") as Literal;
var ltlIsEnabled = e.Item.FindControl("ltlIsEnabled") as Literal;
var hlUp = e.Item.FindControl("hlUp") as HyperLink;
var hlDown = e.Item.FindControl("hlDown") as HyperLink;
var ltlEditUrl = e.Item.FindControl("ltlEditUrl") as Literal;
var ltlDeleteUrl = e.Item.FindControl("ltlDeleteUrl") as Literal;
ltlReply.Text = StringUtils.CleanText(reply);
ltlAddDate.Text = DateUtils.GetDateString(addDate);
ltlMatchType.Text = EMatchTypeUtils.GetText(matchType);
ltlIsEnabled.Text = StringUtils.GetTrueOrFalseImageHtml(!isDisabled);
var redirectUrl = GetRedirectUrl(PublishmentSystemId);
hlUp.NavigateUrl = $"{redirectUrl}&SetTaxis=True&KeywordId={keywordId}&Direction=UP";
hlDown.NavigateUrl = $"{redirectUrl}&SetTaxis=True&KeywordId={keywordId}&Direction=DOWN";
var showPopWinString = ModalKeywordAddText.GetOpenWindowStringToEdit(PublishmentSystemId, keywordId);
ltlEditUrl.Text = $@"<a href=""javascript:;"" onClick=""{showPopWinString}"">修改</a>";
ltlDeleteUrl.Text =
$@"<a href=""{redirectUrl}&Delete=True&KeywordID={keywordId}"" onClick=""javascript:return confirm('此操作将删除关键字“{keywords}”，确认吗？');"">删除</a>";
}
}
public List <KeywordInfo> GetKeywordInfoList(int publishmentSystemId, EKeywordType keywordType)
{
var list = new List <KeywordInfo>();
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId),
GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType))
};
using (var rdr = ExecuteReader(SqlSelectAllByType, parms))
{
while (rdr.Read())
{
var keywordInfo = new KeywordInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), TranslateUtils.ToBool(rdr.GetValue(3).ToString()), EKeywordTypeUtils.GetEnumType(rdr.GetValue(4).ToString()), EMatchTypeUtils.GetEnumType(rdr.GetValue(5).ToString()), rdr.GetValue(6).ToString(), rdr.GetDateTime(7), rdr.GetInt32(8));
list.Add(keywordInfo);
}
rdr.Close();
}
return(list);
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
var keywordIdNew = 0;
try
{
if (_keywordId == 0)
{
var conflictKeywords = string.Empty;
if (KeywordManager.IsKeywordInsertConflict(PublishmentSystemId, TbKeywords.Text, out conflictKeywords))
{
FailMessage($"触发关键词“{conflictKeywords}”已存在，请设置其他关键词");
}
else
{
var keywordInfo = new KeywordInfo();
keywordInfo.KeywordId = 0;
keywordInfo.PublishmentSystemId = PublishmentSystemId;
keywordInfo.Keywords = TbKeywords.Text;
keywordInfo.IsDisabled = !CbIsEnabled.Checked;
keywordInfo.KeywordType = EKeywordType.News;
keywordInfo.MatchType = EMatchTypeUtils.GetEnumType(DdlMatchType.SelectedValue);
keywordInfo.Reply = string.Empty;
keywordInfo.AddDate = DateTime.Now;
keywordInfo.Taxis = 0;
keywordIdNew = DataProviderWx.KeywordDao.Insert(keywordInfo);
Body.AddSiteLog(PublishmentSystemId, "添加图文回复关键词", $"关键词:{TbKeywords.Text}");
isChanged = true;
}
}
else
{
var conflictKeywords = string.Empty;
if (KeywordManager.IsKeywordUpdateConflict(PublishmentSystemId, _keywordId, TbKeywords.Text, out conflictKeywords))
{
FailMessage($"触发关键词“{conflictKeywords}”已存在，请设置其他关键词");
}
else
{
var keywordInfo = DataProviderWx.KeywordDao.GetKeywordInfo(_keywordId);
keywordInfo.Keywords = TbKeywords.Text;
keywordInfo.IsDisabled = !CbIsEnabled.Checked;
keywordInfo.MatchType = EMatchTypeUtils.GetEnumType(DdlMatchType.SelectedValue);
DataProviderWx.KeywordDao.Update(keywordInfo);
Body.AddSiteLog(PublishmentSystemId, "编辑图文回复关键词", $"关键词:{TbKeywords.Text}");
isChanged = true;
}
}
}
catch (Exception ex)
{
FailMessage(ex, "失败：" + ex.Message);
}
if (isChanged)
{
if (_keywordId == 0)
{
if (CbIsSelect.Checked)
{
PageUtils.Redirect(ModalContentSelect.GetRedirectUrlByKeywordAddList(PublishmentSystemId, !_isSingle, keywordIdNew));
}
else
{
PageUtils.CloseModalPageAndRedirect(Page, PageKeywordNewsAdd.GetRedirectUrl(PublishmentSystemId, keywordIdNew, 0, _isSingle));
}
}
else
{
PageUtils.CloseModalPage(Page);
}
}
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
var keywordIDNew = 0;
try
{
if (keywordID == 0)
{
var conflictKeywords = string.Empty;
if (KeywordManager.IsKeywordInsertConflict(PublishmentSystemID, tbKeywords.Text, out conflictKeywords))
{
FailMessage($"触发关键词“{conflictKeywords}”已存在，请设置其他关键词");
}
else
{
var keywordInfo = new KeywordInfo();
keywordInfo.KeywordID = 0;
keywordInfo.PublishmentSystemID = PublishmentSystemID;
keywordInfo.Keywords = tbKeywords.Text;
keywordInfo.IsDisabled = !cbIsEnabled.Checked;
keywordInfo.KeywordType = EKeywordType.News;
keywordInfo.MatchType = EMatchTypeUtils.GetEnumType(ddlMatchType.SelectedValue);
keywordInfo.Reply = string.Empty;
keywordInfo.AddDate = DateTime.Now;
keywordInfo.Taxis = 0;
keywordIDNew = DataProviderWX.KeywordDAO.Insert(keywordInfo);
StringUtility.AddLog(PublishmentSystemID, "添加图文回复关键词", $"关键词:{tbKeywords.Text}");
isChanged = true;
}
}
else
{
var conflictKeywords = string.Empty;
if (KeywordManager.IsKeywordUpdateConflict(PublishmentSystemID, keywordID, tbKeywords.Text, out conflictKeywords))
{
FailMessage($"触发关键词“{conflictKeywords}”已存在，请设置其他关键词");
}
else
{
var keywordInfo = DataProviderWX.KeywordDAO.GetKeywordInfo(keywordID);
keywordInfo.Keywords = tbKeywords.Text;
keywordInfo.IsDisabled = !cbIsEnabled.Checked;
keywordInfo.MatchType = EMatchTypeUtils.GetEnumType(ddlMatchType.SelectedValue);
DataProviderWX.KeywordDAO.Update(keywordInfo);
StringUtility.AddLog(PublishmentSystemID, "编辑图文回复关键词", $"关键词:{tbKeywords.Text}");
isChanged = true;
}
}
}
catch (Exception ex)
{
FailMessage(ex, "失败：" + ex.Message);
}
if (isChanged)
{
if (keywordID == 0)
{
if (cbIsSelect.Checked)
{
PageUtils.Redirect(ContentSelect.GetRedirectUrlByKeywordAddList(PublishmentSystemID, !isSingle, keywordIDNew));
}
else
{
JsUtils.OpenWindow.CloseModalPageAndRedirect(Page, BackgroundKeywordNewsAdd.GetRedirectUrl(PublishmentSystemID, keywordIDNew, 0, isSingle));
}
}
else
{
JsUtils.OpenWindow.CloseModalPage(Page);
}
}
}
public List <KeywordMatchInfo> GetKeywordMatchInfoList(int publishmentSystemId, int keyWordId)
{
var keywordMatchInfoList = new List <KeywordMatchInfo>();
string sqlWhere =
$"WHERE {KeywordMatchAttribute.PublishmentSystemId} = {publishmentSystemId} AND {KeywordMatchAttribute.KeywordId} = {keyWordId}";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var keywordMatchInfo = new KeywordMatchInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), rdr.GetInt32(3), TranslateUtils.ToBool(rdr.GetValue(6).ToString()), EKeywordTypeUtils.GetEnumType(rdr.GetValue(4).ToString()), EMatchTypeUtils.GetEnumType(rdr.GetValue(5).ToString()));
keywordMatchInfoList.Add(keywordMatchInfo);
}
rdr.Close();
}
return(keywordMatchInfoList);
}
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var keywordId = SqlUtils.EvalInt(e.Item.DataItem, "KeywordId");
var keywords = SqlUtils.EvalString(e.Item.DataItem, "Keywords");
var isDisabled = TranslateUtils.ToBool(SqlUtils.EvalString(e.Item.DataItem, "IsDisabled"));
var reply = SqlUtils.EvalString(e.Item.DataItem, "Reply");
var matchType = EMatchTypeUtils.GetEnumType(SqlUtils.EvalString(e.Item.DataItem, "MatchType"));
var addDate = SqlUtils.EvalDateTime(e.Item.DataItem, "AddDate");
var phSingle = e.Item.FindControl("phSingle") as PlaceHolder;
var phMultiple = e.Item.FindControl("phMultiple") as PlaceHolder;
var resourceInfoList = DataProviderWx.KeywordResourceDao.GetResourceInfoList(keywordId);
phMultiple.Visible = resourceInfoList.Count > 1;
phSingle.Visible = !phMultiple.Visible;
if (phSingle.Visible)
{
var resourceInfo = new KeywordResourceInfo();
if (resourceInfoList.Count > 0)
{
resourceInfo = resourceInfoList[0];
}
var ltlSingleTitle = e.Item.FindControl("ltlSingleTitle") as Literal;
var ltlSingleKeywords = e.Item.FindControl("ltlSingleKeywords") as Literal;
var ltlSingleAddDate = e.Item.FindControl("ltlSingleAddDate") as Literal;
var ltlSingleImageUrl = e.Item.FindControl("ltlSingleImageUrl") as Literal;
var ltlSingleSummary = e.Item.FindControl("ltlSingleSummary") as Literal;
var ltlSingleEditUrl = e.Item.FindControl("ltlSingleEditUrl") as Literal;
var ltlSingleDeleteUrl = e.Item.FindControl("ltlSingleDeleteUrl") as Literal;
ltlSingleTitle.Text = $@"<a href=""{"javascript:;"}"" target=""_blank"">{resourceInfo.Title}</a>";
ltlSingleKeywords.Text =
$@"{keywords + (isDisabled ? "(禁用)" : string.Empty)} <a href=""javascript:;"" onclick=""{ModalKeywordAddNews.GetOpenWindowStringToEdit(PublishmentSystemId, keywordId)}"">修改</a>";
ltlSingleAddDate.Text = addDate.ToShortDateString();
if (!string.IsNullOrEmpty(resourceInfo.ImageUrl))
{
ltlSingleImageUrl.Text =
$@"<img src=""{PageUtility.ParseNavigationUrl(PublishmentSystemInfo, resourceInfo.ImageUrl)}"" class=""appmsg_thumb"">";
}
ltlSingleSummary.Text = MPUtils.GetSummary(resourceInfo.Summary, resourceInfo.Content);
ltlSingleEditUrl.Text =
$@"<a class=""js_edit"" href=""{PageKeywordNewsAdd.GetRedirectUrl(PublishmentSystemId,
keywordId, resourceInfo.ResourceId, phSingle.Visible)}""><i class=""icon18_common edit_gray"">编辑</i></a>";
ltlSingleDeleteUrl.Text =
$@"<a class=""js_del no_extra"" href=""{GetRedirectUrl(
PublishmentSystemId)}&delete=true&keywordID={keywordId}"" onclick=""javascript:return confirm('此操作将删除图文回复“{keywords}”，确认吗？');""><i class=""icon18_common del_gray"">删除</i></a>";
}
else
{
var resourceInfo = resourceInfoList[0];
resourceInfoList.Remove(resourceInfo);
var ltlMultipleKeywords = e.Item.FindControl("ltlMultipleKeywords") as Literal;
var ltlMultipleAddDate = e.Item.FindControl("ltlMultipleAddDate") as Literal;
var ltlMultipleTitle = e.Item.FindControl("ltlMultipleTitle") as Literal;
var ltlMultipleImageUrl = e.Item.FindControl("ltlMultipleImageUrl") as Literal;
var rptMultipleContents = e.Item.FindControl("rptMultipleContents") as Repeater;
var ltlMultipleEditUrl = e.Item.FindControl("ltlMultipleEditUrl") as Literal;
var ltlMultipleDeleteUrl = e.Item.FindControl("ltlMultipleDeleteUrl") as Literal;
ltlMultipleKeywords.Text =
$@"{keywords + (isDisabled ? "(禁用)" : string.Empty)} <a href=""javascript:;"" onclick=""{ModalKeywordAddNews.GetOpenWindowStringToEdit(PublishmentSystemId, keywordId)}"">修改</a>";
ltlMultipleAddDate.Text = addDate.ToShortDateString();
ltlMultipleTitle.Text = $@"<a href=""{"javascript:;"}"" target=""_blank"">{resourceInfo.Title}</a>";
if (!string.IsNullOrEmpty(resourceInfo.ImageUrl))
{
ltlMultipleImageUrl.Text =
$@"<img src=""{PageUtility.ParseNavigationUrl(PublishmentSystemInfo, resourceInfo.ImageUrl)}"" class=""appmsg_thumb"">";
}
rptMultipleContents.DataSource = resourceInfoList;
rptMultipleContents.ItemDataBound += rptMultipleContents_ItemDataBound;
rptMultipleContents.DataBind();
ltlMultipleEditUrl.Text =
$@"<a class=""js_edit"" href=""{PageKeywordNewsAdd.GetRedirectUrl(PublishmentSystemId,
keywordId, resourceInfo.ResourceId, phSingle.Visible)}""><i class=""icon18_common edit_gray"">编辑</i></a>";
ltlMultipleDeleteUrl.Text =
$@"<a class=""js_del no_extra"" href=""{GetRedirectUrl(
PublishmentSystemId)}&delete=true&keywordID={keywordId}"" onclick=""javascript:return confirm('此操作将删除图文回复“{keywords}”，确认吗？');""><i class=""icon18_common del_gray"">删除</i></a>";
}
}
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
try
{
if (_keywordId == 0)
{
var conflictKeywords = string.Empty;
if (KeywordManager.IsKeywordInsertConflict(PublishmentSystemId, PageUtils.FilterSql(TbKeywords.Text), out conflictKeywords))
{
FailMessage($"触发关键词“{conflictKeywords}”已存在，请设置其他关键词");
}
else
{
var keywordInfo = new KeywordInfo();
keywordInfo.KeywordId = 0;
keywordInfo.PublishmentSystemId = PublishmentSystemId;
keywordInfo.Keywords = PageUtils.FilterSql(TbKeywords.Text);
keywordInfo.IsDisabled = !CbIsEnabled.Checked;
keywordInfo.KeywordType = EKeywordType.Text;
keywordInfo.MatchType = EMatchTypeUtils.GetEnumType(DdlMatchType.SelectedValue);
keywordInfo.Reply = TbReply.Text;
keywordInfo.AddDate = DateTime.Now;
keywordInfo.Taxis = 0;
DataProviderWx.KeywordDao.Insert(keywordInfo);
Body.AddSiteLog(PublishmentSystemId, "添加文本回复关键词", $"关键词:{TbKeywords.Text}");
isChanged = true;
}
}
else
{
var conflictKeywords = string.Empty;
if (KeywordManager.IsKeywordUpdateConflict(PublishmentSystemId, _keywordId, TbKeywords.Text, out conflictKeywords))
{
FailMessage($"触发关键词“{conflictKeywords}”已存在，请设置其他关键词");
}
else
{
var keywordInfo = DataProviderWx.KeywordDao.GetKeywordInfo(_keywordId);
keywordInfo.Keywords = TbKeywords.Text;
keywordInfo.IsDisabled = !CbIsEnabled.Checked;
keywordInfo.MatchType = EMatchTypeUtils.GetEnumType(DdlMatchType.SelectedValue);
keywordInfo.Reply = TbReply.Text;
DataProviderWx.KeywordDao.Update(keywordInfo);
Body.AddSiteLog(PublishmentSystemId, "编辑文本回复关键词", $"关键词:{TbKeywords.Text}");
isChanged = true;
}
}
}
catch (Exception ex)
{
FailMessage(ex, "失败：" + ex.Message);
}
if (isChanged)
{
PageUtils.CloseModalPage(Page);
}
}
public int GetKeywordIdbyMpController(int publishmentSystemId, string keyword)
{
var keywordId = 0;
if (!string.IsNullOrEmpty(keyword))
{
keyword = keyword.Trim();
#region 浩然 2014-8-25 修改关键词触发规则（全字匹配优先）
string sqlString =
$@"SELECT TOP 1 KeywordID FROM ( SELECT wx_KeywordMatch.*,'Exact' AS TypeName FROM wx_KeywordMatch WHERE PublishmentSystemID ={publishmentSystemId} AND IsDisabled <> 'True' AND MatchType = '{EMatchTypeUtils
.GetValue(EMatchType.Exact)}' AND Keyword = '{keyword}' union SELECT wx_KeywordMatch.*,'Contains' AS TypeName FROM wx_KeywordMatch WHERE PublishmentSystemID ={publishmentSystemId} AND IsDisabled <> 'True' AND MatchType = '{EMatchTypeUtils
.GetValue(EMatchType.Contains)}' AND CHARINDEX(Keyword, '{keyword}') <> 0 ) AS wx_KM";
#endregion
using (var rdr = ExecuteReader(sqlString))
{
if (rdr.Read() && !rdr.IsDBNull(0))
{
keywordId = rdr.GetInt32(0);
}
rdr.Close();
}
}
return(keywordId);
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
try
{
if (keywordID == 0)
{
var conflictKeywords = string.Empty;
if (KeywordManager.IsKeywordInsertConflict(PublishmentSystemID, PageUtils.FilterSql(tbKeywords.Text), out conflictKeywords))
{
FailMessage($"触发关键词“{conflictKeywords}”已存在，请设置其他关键词");
}
else
{
var keywordInfo = new KeywordInfo();
keywordInfo.KeywordID = 0;
keywordInfo.PublishmentSystemID = PublishmentSystemID;
keywordInfo.Keywords = PageUtils.FilterSql(tbKeywords.Text);
keywordInfo.IsDisabled = !cbIsEnabled.Checked;
keywordInfo.KeywordType = EKeywordType.Text;
keywordInfo.MatchType = EMatchTypeUtils.GetEnumType(ddlMatchType.SelectedValue);
keywordInfo.Reply = tbReply.Text;
keywordInfo.AddDate = DateTime.Now;
keywordInfo.Taxis = 0;
DataProviderWX.KeywordDAO.Insert(keywordInfo);
StringUtility.AddLog(PublishmentSystemID, "添加文本回复关键词", $"关键词:{tbKeywords.Text}");
isChanged = true;
}
}
else
{
var conflictKeywords = string.Empty;
if (KeywordManager.IsKeywordUpdateConflict(PublishmentSystemID, keywordID, tbKeywords.Text, out conflictKeywords))
{
FailMessage($"触发关键词“{conflictKeywords}”已存在，请设置其他关键词");
}
else
{
var keywordInfo = DataProviderWX.KeywordDAO.GetKeywordInfo(keywordID);
keywordInfo.Keywords = tbKeywords.Text;
keywordInfo.IsDisabled = !cbIsEnabled.Checked;
keywordInfo.MatchType = EMatchTypeUtils.GetEnumType(ddlMatchType.SelectedValue);
keywordInfo.Reply = tbReply.Text;
DataProviderWX.KeywordDAO.Update(keywordInfo);
StringUtility.AddLog(PublishmentSystemID, "编辑文本回复关键词", $"关键词:{tbKeywords.Text}");
isChanged = true;
}
}
}
catch (Exception ex)
{
FailMessage(ex, "失败：" + ex.Message);
}
if (isChanged)
{
JsUtils.OpenWindow.CloseModalPage(Page);
}
}
public KeywordInfo GetKeywordInfo(int keywordID)
{
KeywordInfo keywordInfo = null;
if (keywordID > 0)
{
var parms = new IDataParameter[]
{
GetParameter(PARM_KEYWORD_ID, EDataType.Integer, keywordID)
};
using (var rdr = ExecuteReader(SQL_SELECT, parms))
{
if (rdr.Read())
{
keywordInfo = new KeywordInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), TranslateUtils.ToBool(rdr.GetValue(3).ToString()), EKeywordTypeUtils.GetEnumType(rdr.GetValue(4).ToString()), EMatchTypeUtils.GetEnumType(rdr.GetValue(5).ToString()), rdr.GetValue(6).ToString(), rdr.GetDateTime(7), rdr.GetInt32(8));
}
rdr.Close();
}
}
else
{
keywordInfo = new KeywordInfo();
keywordInfo.KeywordID = 0;
keywordInfo.Keywords = "";
}
if (keywordInfo == null)
{
keywordInfo = new KeywordInfo();
keywordInfo.KeywordID = 0;
keywordInfo.Keywords = "";
}
return(keywordInfo);
}
public KeywordInfo GetAvaliableKeywordInfo(int publishmentSystemId, EKeywordType keywordType)
{
KeywordInfo keywordInfo = null;
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId),
GetParameter(ParmIsDisabled, EDataType.VarChar, 18, false.ToString()),
GetParameter(ParmKeywordType, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType))
};
using (var rdr = ExecuteReader(SqlSelectAvaliable, parms))
{
if (rdr.Read())
{
keywordInfo = new KeywordInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), TranslateUtils.ToBool(rdr.GetValue(3).ToString()), EKeywordTypeUtils.GetEnumType(rdr.GetValue(4).ToString()), EMatchTypeUtils.GetEnumType(rdr.GetValue(5).ToString()), rdr.GetValue(6).ToString(), rdr.GetDateTime(7), rdr.GetInt32(8));
}
rdr.Close();
}
return(keywordInfo);
}
public KeywordInfo GetAvaliableKeywordInfo(int publishmentSystemID, EKeywordType keywordType)
{
KeywordInfo keywordInfo = null;
var parms = new IDataParameter[]
{
GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, publishmentSystemID),
GetParameter(PARM_IS_DISABLED, EDataType.VarChar, 18, false.ToString()),
GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType))
};
using (var rdr = ExecuteReader(SQL_SELECT_AVALIABLE, parms))
{
if (rdr.Read())
{
keywordInfo = new KeywordInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), TranslateUtils.ToBool(rdr.GetValue(3).ToString()), EKeywordTypeUtils.GetEnumType(rdr.GetValue(4).ToString()), EMatchTypeUtils.GetEnumType(rdr.GetValue(5).ToString()), rdr.GetValue(6).ToString(), rdr.GetDateTime(7), rdr.GetInt32(8));
}
rdr.Close();
}
return(keywordInfo);
}
public List <KeywordInfo> GetKeywordInfoList(int publishmentSystemID, EKeywordType keywordType)
{
var list = new List <KeywordInfo>();
var parms = new IDataParameter[]
{
GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, publishmentSystemID),
GetParameter(PARM_KEYWORD_TYPE, EDataType.VarChar, 50, EKeywordTypeUtils.GetValue(keywordType))
};
using (var rdr = ExecuteReader(SQL_SELECT_ALL_BY_TYPE, parms))
{
while (rdr.Read())
{
var keywordInfo = new KeywordInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), TranslateUtils.ToBool(rdr.GetValue(3).ToString()), EKeywordTypeUtils.GetEnumType(rdr.GetValue(4).ToString()), EMatchTypeUtils.GetEnumType(rdr.GetValue(5).ToString()), rdr.GetValue(6).ToString(), rdr.GetDateTime(7), rdr.GetInt32(8));
list.Add(keywordInfo);
}
rdr.Close();
}
return(list);
}
