public void ReFresh(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(ddlKeywordType.SelectedValue))
{
spContents.ControlToPaginate = rptContents;
spContents.ConnectionString = BaiRongDataProvider.ConnectionString;
var keywordType = EKeywordTypeUtils.GetEnumType(ddlKeywordType.SelectedValue);
spContents.SelectCommand = KeywordManager.GetFunctionSqlString(PublishmentSystemID, keywordType);
spContents.ItemsPerPage = 50;
spContents.SortField = "ID";
spContents.SortMode = SortMode.DESC;
rptContents.ItemDataBound += new RepeaterItemEventHandler(rptContents_ItemDataBound);
spContents.DataBind();
phFunction.Visible = rptContents.Items.Count > 0;
}
}
catch (Exception ex)
{
PageUtils.RedirectToErrorPage(ex.Message);
}
}
public string GetFunctionOrChannelOrContentSelectScript(WebMenuInfo menuInfo)
{
if (ENavigationTypeUtils.Equals(menuInfo.NavigationType, ENavigationType.Function))
{
if (menuInfo.FunctionId > 0)
{
var functionName = KeywordManager.GetFunctionName(EKeywordTypeUtils.GetEnumType(menuInfo.KeywordType), menuInfo.FunctionId);
return($@"selectKeyword(""{menuInfo.KeywordType},{menuInfo.FunctionId},{functionName}"")");
}
}
else if (ENavigationTypeUtils.Equals(menuInfo.NavigationType, ENavigationType.Site))
{
if (menuInfo.ContentId > 0)
{
var tableStyle = NodeManager.GetTableStyle(PublishmentSystemInfo, menuInfo.ChannelId);
var tableName = NodeManager.GetTableName(PublishmentSystemInfo, menuInfo.ChannelId);
var contentInfo = DataProvider.ContentDao.GetContentInfo(tableStyle, tableName, menuInfo.ContentId);
var pageUrl = PageUtilityWX.GetContentUrl(PublishmentSystemInfo, contentInfo);
return
($@"contentSelect(""{contentInfo.Title}"", ""{menuInfo.ChannelId}"", ""{menuInfo.ContentId}"", ""{pageUrl}"")");
}
else if (menuInfo.ChannelId > 0)
{
var nodeNames = NodeManager.GetNodeNameNavigation(PublishmentSystemId, menuInfo.ChannelId);
var pageUrl = PageUtilityWX.GetChannelUrl(PublishmentSystemInfo, NodeManager.GetNodeInfo(PublishmentSystemId, menuInfo.ChannelId));
return($"selectChannel('{nodeNames}', '{menuInfo.ChannelId}', '{pageUrl}');");
}
}
return(string.Empty);
}
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var ltlTitle = e.Item.FindControl("ltlTitle") as Literal;
var functionID = TranslateUtils.EvalInt(e.Item.DataItem, "ID");
var keywordType = EKeywordTypeUtils.GetEnumType(ddlKeywordType.SelectedValue);
var pageTitle = KeywordManager.GetFunctionName(keywordType, functionID);
var clickString = string.Empty;
if (Request.QueryString["itemIndex"] != null)
{
clickString =
$@"window.parent.{jsMethod}({itemIndex}, '{EKeywordTypeUtils.GetValue(keywordType)}', {functionID}, '{pageTitle}');{JsUtils
.OpenWindow.HIDE_POP_WIN}";
}
else
{
clickString =
$@"window.parent.{jsMethod}('{EKeywordTypeUtils.GetValue(keywordType)},{functionID},{pageTitle}');{JsUtils
.OpenWindow.HIDE_POP_WIN}";
}
ltlTitle.Text = $@"
<div class=""alert alert-success pull-left"" style=""margin:5px;padding-right:14px; cursor:pointer;"" onclick=""{clickString}"">
<strong style=""color: #468847"">{pageTitle}</strong>
</div>";
}
}
public void ReFresh(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(DdlKeywordType.SelectedValue))
{
SpContents.ControlToPaginate = RptContents;
var keywordType = EKeywordTypeUtils.GetEnumType(DdlKeywordType.SelectedValue);
SpContents.SelectCommand = KeywordManager.GetFunctionSqlString(PublishmentSystemId, keywordType);
SpContents.ItemsPerPage = 50;
SpContents.SortField = "ID";
SpContents.SortMode = SortMode.DESC;
RptContents.ItemDataBound += rptContents_ItemDataBound;
SpContents.DataBind();
PhFunction.Visible = RptContents.Items.Count > 0;
}
}
catch (Exception ex)
{
PageUtils.RedirectToErrorPage(ex.Message);
}
}
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 keyword = SqlUtils.EvalString(e.Item.DataItem, "Keyword");
var keywordType = EKeywordTypeUtils.GetEnumType(SqlUtils.EvalString(e.Item.DataItem, "KeywordType"));
var ltlKeyword = e.Item.FindControl("ltlKeyword") as Literal;
ltlKeyword.Text =
$@"<div class=""alert alert-success pull-left"" style=""margin:5px;padding-right:14px; cursor:pointer;"" onclick=""window.parent.{_jsMethod}('{keyword}');;window.parent.closeWindow();""><strong style=""color: #468847"">{keyword}</strong> ({EKeywordTypeUtils.GetText(keywordType)})</div>";
}
}
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var keywordID = TranslateUtils.EvalInt(e.Item.DataItem, "KeywordID");
var keyword = TranslateUtils.EvalString(e.Item.DataItem, "Keyword");
var keywordType = EKeywordTypeUtils.GetEnumType(TranslateUtils.EvalString(e.Item.DataItem, "KeywordType"));
var ltlKeyword = e.Item.FindControl("ltlKeyword") as Literal;
string urlDelete =
$@"{GetRedirectUrl(PublishmentSystemID)}&delete=true&deleteKeywordID={keywordID}&deleteKeyword={keyword}";
ltlKeyword.Text =
$@"<div class=""alert alert-success pull-left"" style=""margin:5px;padding-right:14px;""><strong style=""color: #468847"">{keyword}</strong> ({EKeywordTypeUtils
.GetText(keywordType)}) <a href=""javascript:;"" onclick=""{Modal.KeywordEdit
.GetOpenWindowString(PublishmentSystemID, keywordID, keyword)}""><i class=""icon-edit""></i></a> <a href=""{urlDelete}"" onclick=""javascript:return confirm('此操作将删除关键字“{keyword}”，确认吗？');""><i class=""icon-remove""></i></a></div>";
}
}
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);
}
private IResponseMessageBase GetResponseMessage(string keyword)
{
KeywordInfo keywordInfo = null;
var keywordID = DataProviderWX.KeywordMatchDAO.GetKeywordIDByMPController(publishmentSystemInfo.PublishmentSystemId, keyword);
if (keywordID == 0 && StringUtils.StartsWith(keyword, "GX_"))
{
var keywordType = EKeywordTypeUtils.GetEnumType(keyword.Substring(3));
keywordInfo = new KeywordInfo(0, publishmentSystemInfo.PublishmentSystemId, keyword, false, keywordType, EMatchType.Exact, string.Empty, DateTime.Now, 0);
}
if (keywordID == 0 && keywordInfo == null && accountInfo.IsDefaultReply && !string.IsNullOrEmpty(accountInfo.DefaultReplyKeyword))
{
keywordID = DataProviderWX.KeywordMatchDAO.GetKeywordIDByMPController(publishmentSystemInfo.PublishmentSystemId, accountInfo.DefaultReplyKeyword);
}
if (keywordInfo == null && keywordID > 0)
{
keywordInfo = DataProviderWX.KeywordDAO.GetKeywordInfo(keywordID);
}
return(GetResponseMessage(keywordInfo, keyword));
}
public static string ParseWebMenu(PublishmentSystemInfo publishmentSystemInfo)
{
if (publishmentSystemInfo.Additional.WxIsWebMenu && !string.IsNullOrEmpty(publishmentSystemInfo.Additional.WxWebMenuType))
{
var directoryUrl = SiteFilesAssets.GetUrl(publishmentSystemInfo.Additional.ApiUrl, $"weixin/components/webMenu/{publishmentSystemInfo.Additional.WxWebMenuType}");
if (PageUtils.IsProtocolUrl(publishmentSystemInfo.PublishmentSystemUrl))
{
directoryUrl = PageUtils.AddProtocolToUrl(SiteFilesAssets.GetUrl(publishmentSystemInfo.Additional.ApiUrl, $"weixin/components/webMenu/{publishmentSystemInfo.Additional.WxWebMenuType}"));
}
var menuPath = SiteFilesAssets.GetPath($"weixin/components/webMenu/{publishmentSystemInfo.Additional.WxWebMenuType}/template.html");
var menuHtml = StlCacheManager.FileContent.GetContentByFilePath(menuPath, ECharset.utf_8);
var startIndex = menuHtml.IndexOf("<!--menu-->");
var endIndex = menuHtml.IndexOf("<!--menu-->", startIndex + 1);
var menuTemplate = menuHtml.Substring(startIndex, endIndex - startIndex);
var startSubIndex = menuTemplate.IndexOf("<!--submenu-->");
var endSubIndex = menuTemplate.IndexOf("<!--submenu-->", startSubIndex + 1);
var subMenuTemplate = menuTemplate.Substring(startSubIndex, endSubIndex - startSubIndex);
var menuBuilder = new StringBuilder();
var menuInfoList = DataProviderWX.WebMenuDAO.GetMenuInfoList(publishmentSystemInfo.PublishmentSystemId, 0);
var index = 0;
foreach (var menuInfo in menuInfoList)
{
var subMenuBuilder = new StringBuilder();
var subMenuInfoList = DataProviderWX.WebMenuDAO.GetMenuInfoList(publishmentSystemInfo.PublishmentSystemId, menuInfo.ID);
if (subMenuInfoList != null && subMenuInfoList.Count > 0)
{
menuInfo.NavigationType = ENavigationTypeUtils.GetValue(ENavigationType.Url);
menuInfo.Url = PageUtils.UnclickedUrl;
foreach (var subMenuInfo in subMenuInfoList)
{
var subMenu = subMenuTemplate.Replace("{{url}}", GetNavigationUrl(publishmentSystemInfo, ENavigationTypeUtils.GetEnumType(subMenuInfo.NavigationType), EKeywordTypeUtils.GetEnumType(subMenuInfo.KeywordType), subMenuInfo.FunctionID, subMenuInfo.ChannelID, subMenuInfo.ContentID, subMenuInfo.Url));
subMenu = subMenu.Replace("{{menuName}}", subMenuInfo.MenuName);
subMenuBuilder.Append(subMenu);
}
}
var menu = menuTemplate.Substring(0, startSubIndex) + subMenuBuilder.ToString() + menuTemplate.Substring(endSubIndex);
menu = menu.Replace("{{url}}", GetNavigationUrl(publishmentSystemInfo, ENavigationTypeUtils.GetEnumType(menuInfo.NavigationType), EKeywordTypeUtils.GetEnumType(menuInfo.KeywordType), menuInfo.FunctionID, menuInfo.ChannelID, menuInfo.ContentID, menuInfo.Url));
menu = menu.Replace("{{index}}", index.ToString());
menu = menu.Replace("{{menuName}}", menuInfo.MenuName);
menuBuilder.Append(menu);
index++;
}
menuHtml = menuHtml.Substring(0, startIndex) + menuBuilder.ToString() + menuHtml.Substring(endIndex);
return($@"
<link rel=""stylesheet"" type=""text/css"" href=""{directoryUrl}/style.css"" />
<script type=""text/javascript"" src=""{directoryUrl}/script.js""></script>
{menuHtml}");
}
return(string.Empty);
}
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);
}
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 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 void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("PublishmentSystemID");
searchID = TranslateUtils.ToInt(GetQueryString("searchID"));
if (!IsPostBack)
{
var pageTitle = searchID > 0 ? "编辑微搜索" : "添加微搜索";
BreadCrumb(AppManager.WeiXin.LeftMenu.ID_Function, AppManager.WeiXin.LeftMenu.Function.ID_Search, pageTitle, AppManager.WeiXin.Permission.WebSite.Search);
ltlPageTitle.Text = pageTitle;
ltlImageUrl.Text =
$@"<img id=""preview_imageUrl"" src=""{SearchManager.GetImageUrl(PublishmentSystemInfo,
string.Empty)}"" width=""370"" align=""middle"" />";
ltlContentImageUrl.Text =
$@"<img id=""preview_contentImageUrl"" src=""{SearchManager.GetContentImageUrl(
PublishmentSystemInfo, string.Empty)}"" width=""370"" align=""middle"" />";
ltlSearchNavs.Text = $@"
itemController.openFunctionSelect = function(itemIndex){{
var openString = ""{Modal.FunctionSelect.GetOpenWindowStringByItemIndex(PublishmentSystemID, "selectFunction",
"itemIndexValue")}"".replace(""itemIndexValue"", itemIndex);
openString = openString.substr(0, openString.indexOf(';'));
eval(openString);
}};
itemController.openChannelSelect = function(itemIndex){{
var openString = ""{CMS.BackgroundPages.Modal.ChannelSelect.GetOpenWindowStringByItemIndex(
PublishmentSystemID, "selectChannel", "itemIndexValue")}"".replace(""itemIndexValue"", itemIndex);
openString = openString.substr(0, openString.indexOf(';'));
eval(openString);
}};
itemController.openContentSelect = function(itemIndex){{
var openString = ""{Modal.ContentSelect.GetOpenWindowStringByItemIndex(PublishmentSystemID, "selectContent",
"itemIndexValue")}"".replace(""itemIndexValue"", itemIndex);
openString = openString.substr(0, openString.indexOf(';'));
eval(openString);
}};
itemController.openImageCssClassSelect = function(itemIndex){{
var openString = ""{Modal.ImageCssClassSelect.GetOpenWindowStringByItemIndex(PublishmentSystemID,
"selectImageCssClass", "itemIndexValue")}"".replace(""itemIndexValue"", itemIndex);
openString = openString.substr(0, openString.indexOf(';'));
eval(openString);
}};
";
if (searchID == 0)
{
ltlSearchNavs.Text += "itemController.itemCount = 2;itemController.items = [{navigationType : 'Url', imageCssClass : 'fa fa-angle-double-down'}, {navigationType : 'Url', imageCssClass : 'fa fa-angle-double-down'}];";
}
else
{
var searchInfo = DataProviderWX.SearchDAO.GetSearchInfo(searchID);
tbKeywords.Text = DataProviderWX.KeywordDAO.GetKeywords(searchInfo.KeywordID);
cbIsEnabled.Checked = !searchInfo.IsDisabled;
tbTitle.Text = searchInfo.Title;
if (!string.IsNullOrEmpty(searchInfo.ImageUrl))
{
ltlImageUrl.Text =
$@"<img id=""preview_imageUrl"" src=""{PageUtility.ParseNavigationUrl(
PublishmentSystemInfo, searchInfo.ImageUrl)}"" width=""370"" align=""middle"" />";
}
tbSummary.Text = searchInfo.Summary;
cbIsOutsiteSearch.Checked = searchInfo.IsOutsiteSearch;
cbIsNavigation.Checked = searchInfo.IsNavigation;
tbNavTitleColor.Text = searchInfo.NavTitleColor;
tbNavImageColor.Text = searchInfo.NavImageColor;
if (!string.IsNullOrEmpty(searchInfo.ContentImageUrl))
{
ltlContentImageUrl.Text =
$@"<img id=""preview_contentImageUrl"" src=""{PageUtility.ParseNavigationUrl(
PublishmentSystemInfo, searchInfo.ContentImageUrl)}"" width=""370"" align=""middle"" />";
}
var searchNavigationInfoList = DataProviderWX.SearchNavigationDAO.GetSearchNavigationInfoList(PublishmentSystemID, searchID);
var itemBuilder = new StringBuilder();
foreach (var searchNavigationInfo in searchNavigationInfoList)
{
var searchPageTitle = string.Empty;
if (searchNavigationInfo.NavigationType == ENavigationTypeUtils.GetValue(ENavigationType.Url))
{
searchPageTitle = string.Empty;
}
else if (searchNavigationInfo.NavigationType == ENavigationTypeUtils.GetValue(ENavigationType.Function))
{
searchPageTitle = KeywordManager.GetFunctionName(EKeywordTypeUtils.GetEnumType(searchNavigationInfo.KeywordType), searchNavigationInfo.FunctionID);
}
else if (searchNavigationInfo.NavigationType == ENavigationTypeUtils.GetValue(ENavigationType.Site))
{
if (searchNavigationInfo.ContentID > 0)
{
var tableStyle = NodeManager.GetTableStyle(PublishmentSystemInfo, searchNavigationInfo.ChannelID);
var tableName = NodeManager.GetTableName(PublishmentSystemInfo, searchNavigationInfo.ChannelID);
var contentInfo = DataProvider.ContentDAO.GetContentInfo(tableStyle, tableName, searchNavigationInfo.ContentID);
var pageUrl = PageUtilityWX.GetContentUrl(PublishmentSystemInfo, contentInfo);
searchPageTitle = $@"内容页：{contentInfo.Title}";
}
else
{
var nodeNames = NodeManager.GetNodeNameNavigation(PublishmentSystemID, searchNavigationInfo.ChannelID);
var pageUrl = PageUtility.GetChannelUrl(PublishmentSystemInfo, NodeManager.GetNodeInfo(PublishmentSystemID, searchNavigationInfo.ChannelID));
searchPageTitle = $@"栏目页：{nodeNames}";
}
}
itemBuilder.AppendFormat("{{id: '{0}', title: '{1}',pageTitle: '{2}', url: '{3}', imageCssClass: '{4}',navigationType:'{5}',keywordType:'{6}',functionID:'{7}',channelID:'{8}',contentID:'{9}'}},", searchNavigationInfo.ID, searchNavigationInfo.Title, searchPageTitle, searchNavigationInfo.Url, searchNavigationInfo.ImageCssClass, searchNavigationInfo.NavigationType, searchNavigationInfo.KeywordType, searchNavigationInfo.FunctionID, searchNavigationInfo.ChannelID, searchNavigationInfo.ContentID);
}
if (itemBuilder.Length > 0)
{
itemBuilder.Length--;
}
ltlSearchNavs.Text += $@"
itemController.itemCount = {searchNavigationInfoList.Count};itemController.items = [{itemBuilder.ToString()}];";
imageUrl.Value = searchInfo.ImageUrl;
contentImageUrl.Value = searchInfo.ContentImageUrl;
tbImageAreaTitle.Text = searchInfo.ImageAreaTitle;
tbTextAreaTitle.Text = searchInfo.TextAreaTitle;
if (searchInfo.ImageAreaChannelID > 0)
{
var nodeNames = NodeManager.GetNodeNameNavigation(PublishmentSystemID, searchInfo.ImageAreaChannelID);
ltlSearchNavs.Text += $@"
$(document).ready(function() {{
selectChannel(1, '{nodeNames}', {searchInfo.ImageAreaChannelID});
}});
";
}
if (searchInfo.TextAreaChannelID > 0)
{
var nodeNames = NodeManager.GetNodeNameNavigation(PublishmentSystemID, searchInfo.TextAreaChannelID);
ltlSearchNavs.Text += $@"
$(document).ready(function() {{
selectChannel(2, '{nodeNames}', {searchInfo.TextAreaChannelID});
}});
";
}
}
btnImageChannelSelect.Attributes.Add("onclick", CMS.BackgroundPages.Modal.ChannelSelect.GetOpenWindowStringByItemIndex(PublishmentSystemID, "selectChannel", "1"));
btnTextChannelSelect.Attributes.Add("onclick", CMS.BackgroundPages.Modal.ChannelSelect.GetOpenWindowStringByItemIndex(PublishmentSystemID, "selectChannel", "2"));
btnReturn.Attributes.Add("onclick",
$@"location.href=""{BackgroundSearch.GetRedirectUrl(PublishmentSystemID)}"";return false");
}
}
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);
}
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 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);
}
