public static string GetValue(EScopeType type)
{
if (type == EScopeType.Self)
{
return("Self");
}
else if (type == EScopeType.Children)
{
return("Children");
}
else if (type == EScopeType.SelfAndChildren)
{
return("SelfAndChildren");
}
else if (type == EScopeType.Descendant)
{
return("Descendant");
}
else if (type == EScopeType.All)
{
return("All");
}
else
{
throw new Exception();
}
}
public static string GetText(EScopeType type)
{
if (type == EScopeType.Children)
{
return("子栏目");
}
else if (type == EScopeType.Descendant)
{
return("所有子栏目");
}
else if (type == EScopeType.Self)
{
return("本级栏目");
}
else if (type == EScopeType.SelfAndChildren)
{
return("本级栏目及子栏目");
}
else if (type == EScopeType.All)
{
return("全部");
}
else
{
throw new Exception();
}
}
public static ListItem GetListItem(EScopeType type, bool selected)
{
var item = new ListItem(GetValue(type) + " (" + GetText(type) + ")", GetValue(type));
if (selected)
{
item.Selected = true;
}
return(item);
}
public static bool Equals(EScopeType type, string typeStr)
{
if (string.IsNullOrEmpty(typeStr))
{
return(false);
}
if (string.Equals(GetValue(type).ToLower(), typeStr.ToLower()))
{
return(true);
}
return(false);
}
public static List <int> GetNodeIdListByScopeType(NodeInfo nodeInfo, EScopeType scopeType)
{
List <int> list;
var dic = GetDictionary();
var key = EScopeTypeUtils.GetValue(scopeType) + nodeInfo.NodeId;
if (dic.ContainsKey(key))
{
list = dic[key];
}
else
{
list = DataProvider.NodeDao.GetNodeIdListByScopeType(nodeInfo, scopeType, string.Empty, string.Empty);
dic[key] = list;
}
return(list);
}
public static List <int> GetIdListByScopeType(int channelId, EScopeType scopeType, string groupChannel, string groupChannelNot)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Node), nameof(GetIdListByScopeType),
channelId.ToString(), EScopeTypeUtils.GetValue(scopeType), groupChannel, groupChannelNot);
var retval = StlCacheUtils.GetCache <List <int> >(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <List <int> >(cacheKey);
if (retval == null)
{
retval = DataProvider.ChannelDao.GetIdListByScopeType(channelId, scopeType, groupChannel, groupChannelNot);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static List<MinContentInfo> GetMinContentInfoList(SiteInfo siteInfo, int channelId, int contentId, string groupContent, string groupContentNot, string tags, bool isImageExists, bool isImage, bool isVideoExists, bool isVideo, bool isFileExists, bool isFile, bool isRelatedContents, int startNum, int totalNum, string orderByString, bool isTopExists, bool isTop, bool isRecommendExists, bool isRecommend, bool isHotExists, bool isHot, bool isColorExists, bool isColor, string where, EScopeType scopeType, string groupChannel, string groupChannelNot, NameValueCollection others)
{
var dataSource = GetContentsDataSource(siteInfo, channelId, contentId, groupContent, groupContentNot, tags,
isImageExists, isImage, isVideoExists, isVideo, isFileExists, isFile, isRelatedContents, startNum,
totalNum, orderByString, isTopExists, isTop, isRecommendExists, isRecommend, isHotExists, isHot,
isColorExists, isColor, where, scopeType, groupChannel, groupChannelNot, others);
var list = new List<MinContentInfo>();
foreach (DataRow dataItem in dataSource.Tables[0].Rows)
{
var minContentInfo = new MinContentInfo
{
Id = (int) dataItem[ContentAttribute.Id],
ChannelId = (int) dataItem[ContentAttribute.ChannelId]
};
list.Add(minContentInfo);
}
return list;
}
private static string ParseImpl(PageInfo pageInfo, ContextInfo contextInfo, string type, string channelIndex, string channelName, int upLevel, int topLevel, EScopeType scope, string since)
{
var count = 0;
var sinceDate = DateUtils.SqlMinValue;
if (!string.IsNullOrEmpty(since))
{
sinceDate = DateTime.Now.AddHours(-DateUtils.GetSinceHours(since));
}
if (string.IsNullOrEmpty(type) || StringUtils.EqualsIgnoreCase(type, TypeContents))
{
var channelId = StlDataUtility.GetChannelIdByLevel(pageInfo.SiteId, contextInfo.ChannelId, upLevel, topLevel);
channelId = StlDataUtility.GetChannelIdByChannelIdOrChannelIndexOrChannelName(pageInfo.SiteId, channelId, channelIndex, channelName);
var nodeInfo = ChannelManager.GetChannelInfo(pageInfo.SiteId, channelId);
var channelIdList = ChannelManager.GetChannelIdList(nodeInfo, scope, string.Empty, string.Empty, string.Empty);
foreach (var theChannelId in channelIdList)
{
var tableName = ChannelManager.GetTableName(pageInfo.SiteInfo, theChannelId);
count += Content.GetCountOfContentAdd(tableName, pageInfo.SiteId, theChannelId, EScopeType.Self, sinceDate, DateTime.Now.AddDays(1), string.Empty, ETriState.True);
}
}
else if (StringUtils.EqualsIgnoreCase(type, TypeChannels))
{
var channelId = StlDataUtility.GetChannelIdByLevel(pageInfo.SiteId, contextInfo.ChannelId, upLevel, topLevel);
channelId = StlDataUtility.GetChannelIdByChannelIdOrChannelIndexOrChannelName(pageInfo.SiteId, channelId, channelIndex, channelName);
var nodeInfo = ChannelManager.GetChannelInfo(pageInfo.SiteId, channelId);
count = nodeInfo.ChildrenCount;
}
else if (StringUtils.EqualsIgnoreCase(type, TypeDownloads))
{
if (contextInfo.ContentId > 0)
{
count = CountManager.GetCount(pageInfo.SiteInfo.TableName, contextInfo.ContentId.ToString(), ECountType.Download);
}
}
return(count.ToString());
}
public static DataSet GetContentsDataSource(SiteInfo siteInfo, int channelId, int contentId, string groupContent, string groupContentNot, string tags, bool isImageExists, bool isImage, bool isVideoExists, bool isVideo, bool isFileExists, bool isFile, bool isRelatedContents, int startNum, int totalNum, string orderByString, bool isTopExists, bool isTop, bool isRecommendExists, bool isRecommend, bool isHotExists, bool isHot, bool isColorExists, bool isColor, string where, EScopeType scopeType, string groupChannel, string groupChannelNot, NameValueCollection others)
{
if (!ChannelManager.IsExists(siteInfo.Id, channelId)) return null;
var nodeInfo = ChannelManager.GetChannelInfo(siteInfo.Id, channelId);
var tableName = ChannelManager.GetTableName(siteInfo, nodeInfo);
if (isRelatedContents && contentId > 0)
{
var tagCollection = StlContentCache.GetValue(tableName, contentId, ContentAttribute.Tags);
if (!string.IsNullOrEmpty(tagCollection))
{
var contentIdList = StlTagCache.GetContentIdListByTagCollection(TranslateUtils.StringCollectionToStringList(tagCollection), siteInfo.Id);
if (contentIdList.Count > 0)
{
contentIdList.Remove(contentId);
if (string.IsNullOrEmpty(where))
{
where =
$"ID IN ({TranslateUtils.ToSqlInStringWithoutQuote(contentIdList)})";
}
else
{
where +=
$" AND (ID IN ({TranslateUtils.ToSqlInStringWithoutQuote(contentIdList)}))";
}
}
}
else
{
if (string.IsNullOrEmpty(where))
{
where = $"ID <> {contentId}";
}
else
{
where += $" AND (ID <> {contentId})";
}
}
}
var sqlWhereString = PluginManager.IsExists(nodeInfo.ContentModelPluginId)
? StlContentCache.GetStlWhereString(siteInfo.Id, groupContent, groupContentNot,
tags, isTopExists, isTop, where)
: StlContentCache.GetStlWhereString(siteInfo.Id, groupContent,
groupContentNot, tags, isImageExists, isImage, isVideoExists, isVideo, isFileExists, isFile,
isTopExists, isTop, isRecommendExists, isRecommend, isHotExists, isHot, isColorExists, isColor,
where);
var channelIdList = ChannelManager.GetChannelIdList(nodeInfo, scopeType, groupChannel, groupChannelNot, string.Empty);
return StlContentCache.GetStlDataSourceChecked(channelIdList, tableName, startNum, totalNum, orderByString, sqlWhereString, others);
}
public static List <int> GetChannelIdList(ChannelInfo channelInfo, EScopeType scopeType)
{
return(GetChannelIdList(channelInfo, scopeType, string.Empty, string.Empty, string.Empty));
}
public static string GetPageContentsSqlString(PublishmentSystemInfo publishmentSystemInfo, int channelId, string groupContent, string groupContentNot, string tags, bool isImageExists, bool isImage, bool isVideoExists, bool isVideo, bool isFileExists, bool isFile, bool isNoDup, int startNum, int totalNum, string orderByString, bool isTopExists, bool isTop, bool isRecommendExists, bool isRecommend, bool isHotExists, bool isHot, bool isColorExists, bool isColor, string where, EScopeType scopeType, string groupChannel, string groupChannelNot)
{
var sqlString = string.Empty;
if (DataProvider.NodeDao.IsExists(channelId))
{
var nodeInfo = NodeManager.GetNodeInfo(publishmentSystemInfo.PublishmentSystemId, channelId);
var tableStyle = NodeManager.GetTableStyle(publishmentSystemInfo, nodeInfo);
var tableName = NodeManager.GetTableName(publishmentSystemInfo, nodeInfo);
string sqlWhereString;
if (tableStyle == ETableStyle.BackgroundContent)
{
sqlWhereString = DataProvider.BackgroundContentDao.GetStlWhereString(publishmentSystemInfo, tableName, groupContent, groupContentNot, tags, isImageExists, isImage, isVideoExists, isVideo, isFileExists, isFile, isTopExists, isTop, isRecommendExists, isRecommend, isHotExists, isHot, isColorExists, isColor, where);
}
else
{
sqlWhereString = BaiRongDataProvider.ContentDao.GetStlWhereString(publishmentSystemInfo.PublishmentSystemId, groupContent, groupContentNot, tags, isTopExists, isTop, where);
}
sqlString = DataProvider.ContentDao.GetStlSqlStringChecked(tableName, publishmentSystemInfo.PublishmentSystemId, channelId, startNum, totalNum, orderByString, sqlWhereString, scopeType, groupChannel, groupChannelNot, isNoDup);
}
return(sqlString);
}
public static List<int> GetChannelIdList(int siteId, int channelId, string orderByString, EScopeType scopeType, string groupChannel, string groupChannelNot, bool isImageExists, bool isImage, int totalNum, string where)
{
var whereString = StlChannelCache.GetWhereString(siteId, groupChannel, groupChannelNot, isImageExists, isImage, where);
var channelInfo = ChannelManager.GetChannelInfo(siteId, channelId);
var channelIdList = ChannelManager.GetChannelIdList(channelInfo, scopeType, groupChannel, groupChannelNot, string.Empty);
return StlChannelCache.GetIdListByTotalNum(channelIdList, totalNum, orderByString, whereString);
}
private static string ParseImpl(PageInfo pageInfo, ContextInfo contextInfo, string type, string channelIndex, string channelName, int upLevel, int topLevel, EScopeType scope, string since)
{
var count = 0;
var sinceDate = DateUtils.SqlMinValue;
if (!string.IsNullOrEmpty(since))
{
sinceDate = DateTime.Now.AddHours(-DateUtils.GetSinceHours(since));
}
if (string.IsNullOrEmpty(type) || StringUtils.EqualsIgnoreCase(type, TypeContents))
{
var channelId = StlDataUtility.GetNodeIdByLevel(pageInfo.PublishmentSystemId, contextInfo.ChannelId, upLevel, topLevel);
channelId = StlCacheManager.NodeId.GetNodeIdByChannelIdOrChannelIndexOrChannelName(pageInfo.PublishmentSystemId, channelId, channelIndex, channelName);
var nodeInfo = NodeManager.GetNodeInfo(pageInfo.PublishmentSystemId, channelId);
var nodeIdList = DataProvider.NodeDao.GetNodeIdListByScopeType(nodeInfo, scope, string.Empty, string.Empty);
foreach (var nodeId in nodeIdList)
{
var tableName = NodeManager.GetTableName(pageInfo.PublishmentSystemInfo, nodeId);
count += DataProvider.ContentDao.GetCountOfContentAdd(tableName, pageInfo.PublishmentSystemId, nodeId, EScopeType.Self, sinceDate, DateTime.Now.AddDays(1), string.Empty);
}
}
else if (StringUtils.EqualsIgnoreCase(type, TypeChannels))
{
var channelId = StlDataUtility.GetNodeIdByLevel(pageInfo.PublishmentSystemId, contextInfo.ChannelId, upLevel, topLevel);
channelId = StlCacheManager.NodeId.GetNodeIdByChannelIdOrChannelIndexOrChannelName(pageInfo.PublishmentSystemId, channelId, channelIndex, channelName);
var nodeInfo = NodeManager.GetNodeInfo(pageInfo.PublishmentSystemId, channelId);
count = nodeInfo.ChildrenCount;
}
else if (StringUtils.EqualsIgnoreCase(type, TypeComments))
{
count = DataProvider.CommentDao.GetCountChecked(pageInfo.PublishmentSystemId, contextInfo.ChannelId, contextInfo.ContentId);
}
else if (StringUtils.EqualsIgnoreCase(type, TypeDownloads))
{
if (contextInfo.ContentId > 0)
{
count = CountManager.GetCount(pageInfo.PublishmentSystemInfo.AuxiliaryTableForContent, contextInfo.ContentId.ToString(), ECountType.Download);
}
}
return(count.ToString());
}
public IEnumerable GetStlDataSourceChecked(string tableName, int nodeId, int startNum, int totalNum, string orderByString, string whereString, EScopeType scopeType, string groupChannel, string groupChannelNot, bool isNoDup, NameValueCollection otherAttributes)
{
var nodeIdList = DataProvider.NodeDao.GetNodeIdListByScopeType(nodeId, scopeType, groupChannel, groupChannelNot);
return(BaiRongDataProvider.ContentDao.GetStlDataSourceChecked(tableName, nodeIdList, startNum, totalNum, orderByString, whereString, isNoDup, otherAttributes));
}
private static string ParseImpl(PageInfo pageInfo, ContextInfo contextInfo, HtmlGenericControl genericControl, string channelIndex, string channelName, EScopeType scopeType, string groupChannel, string groupChannelNot, string groupContent, string groupContentNot, string tags, string orderByString, int startNum, int totalNum, bool isShowText, string isTopText, int titleWordNum, string where, bool isTop, bool isTopExists, bool isRecommend, bool isRecommendExists, bool isHot, bool isHotExists, bool isColor, bool isColorExists, string theme, int imageWidth, int imageHeight, int textHeight, string bgColor)
{
var parsedContent = string.Empty;
var channelID = StlCacheManager.NodeId.GetNodeIdByChannelIdOrChannelIndexOrChannelName(pageInfo.PublishmentSystemId, contextInfo.ChannelID, channelIndex, channelName);
var dataSource = StlDataUtility.GetContentsDataSource(pageInfo.PublishmentSystemInfo, channelID, 0, groupContent, groupContentNot, tags, true, true, false, false, false, false, false, false, startNum, totalNum, orderByString, isTopExists, isTop, isRecommendExists, isRecommend, isHotExists, isHot, isColorExists, isColor, where, scopeType, groupChannel, groupChannelNot, null);
if (dataSource != null)
{
if (StringUtils.EqualsIgnoreCase(theme, Theme_Style2))
{
pageInfo.AddPageScriptsIfNotExists(PageInfo.JsAcSwfObject);
var imageUrls = new StringCollection();
var navigationUrls = new StringCollection();
var titleCollection = new StringCollection();
foreach (var dataItem in dataSource)
{
var contentInfo = new BackgroundContentInfo(dataItem);
if (contentInfo != null && !string.IsNullOrEmpty(contentInfo.ImageUrl))
{
if (contentInfo.ImageUrl.ToLower().EndsWith(".jpg") || contentInfo.ImageUrl.ToLower().EndsWith(".jpeg") || contentInfo.ImageUrl.ToLower().EndsWith(".png") || contentInfo.ImageUrl.ToLower().EndsWith(".pneg"))
{
titleCollection.Add(StringUtils.ToJsString(PageUtils.UrlEncode(StringUtils.MaxLengthText(StringUtils.StripTags(contentInfo.Title), titleWordNum))));
navigationUrls.Add(PageUtils.UrlEncode(PageUtility.GetContentUrl(pageInfo.PublishmentSystemInfo, contentInfo)));
imageUrls.Add(PageUtils.UrlEncode(PageUtility.ParseNavigationUrl(pageInfo.PublishmentSystemInfo, contentInfo.ImageUrl)));
}
}
}
if (string.IsNullOrEmpty(bgColor))
{
bgColor = "0xDADADA";
}
else
{
bgColor = bgColor.TrimStart('#');
if (!bgColor.StartsWith("0x"))
{
bgColor = "0x" + bgColor;
}
}
if (string.IsNullOrEmpty(isTopText))
{
isTopText = "0";
}
else
{
isTopText = (TranslateUtils.ToBool(isTopText)) ? "0" : "1";
}
var uniqueID = "FocusViewer_" + pageInfo.UniqueId;
var paramBuilder = new StringBuilder();
paramBuilder.Append(
$@"so_{uniqueID}.addParam(""quality"", ""high"");").Append(StringUtils.Constants.ReturnAndNewline);
paramBuilder.Append(
$@"so_{uniqueID}.addParam(""wmode"", ""transparent"");").Append(StringUtils.Constants.ReturnAndNewline);
paramBuilder.Append(
$@"so_{uniqueID}.addParam(""menu"", ""false"");").Append(StringUtils.Constants.ReturnAndNewline);
paramBuilder.Append(
$@"so_{uniqueID}.addParam(""FlashVars"", ""bcastr_file=""+files_uniqueID+""&bcastr_link=""+links_uniqueID+""&bcastr_title=""+texts_uniqueID+""&AutoPlayTime=5&TitleBgPosition={isTopText}&TitleBgColor={bgColor}&BtnDefaultColor={bgColor}"");").Append(StringUtils.Constants.ReturnAndNewline);
string scriptHtml = $@"
<div id=""flashcontent_{uniqueID}""></div>
<script type=""text/javascript"">
var files_uniqueID='{TranslateUtils.ObjectCollectionToString(imageUrls, "|")}';
var links_uniqueID='{TranslateUtils.ObjectCollectionToString(navigationUrls, "|")}';
var texts_uniqueID='{TranslateUtils.ObjectCollectionToString(titleCollection, "|")}';
var so_{uniqueID} = new SWFObject(""{SiteFilesAssets.GetUrl(pageInfo.ApiUrl, SiteFilesAssets.Flashes.Bcastr)}"", ""flash_{uniqueID}"", ""{imageWidth}"", ""{imageHeight}"", ""7"", """");
{paramBuilder}
so_{uniqueID}.write(""flashcontent_{uniqueID}"");
</script>
";
scriptHtml = scriptHtml.Replace("uniqueID", uniqueID);
parsedContent = scriptHtml;
}
else if (StringUtils.EqualsIgnoreCase(theme, Theme_Style3))
{
pageInfo.AddPageScriptsIfNotExists(PageInfo.JsAcSwfObject);
var imageUrls = new StringCollection();
var navigationUrls = new StringCollection();
var titleCollection = new StringCollection();
foreach (var dataItem in dataSource)
{
var contentInfo = new BackgroundContentInfo(dataItem);
if (contentInfo != null && !string.IsNullOrEmpty(contentInfo.ImageUrl))
{
if (contentInfo.ImageUrl.ToLower().EndsWith(".jpg") || contentInfo.ImageUrl.ToLower().EndsWith(".jpeg") || contentInfo.ImageUrl.ToLower().EndsWith(".png") || contentInfo.ImageUrl.ToLower().EndsWith(".pneg"))
{
titleCollection.Add(StringUtils.ToJsString(PageUtils.UrlEncode(StringUtils.MaxLengthText(StringUtils.StripTags(contentInfo.Title), titleWordNum))));
navigationUrls.Add(PageUtils.UrlEncode(PageUtility.GetContentUrl(pageInfo.PublishmentSystemInfo, contentInfo)));
imageUrls.Add(PageUtils.UrlEncode(PageUtility.ParseNavigationUrl(pageInfo.PublishmentSystemInfo, contentInfo.ImageUrl)));
}
}
}
var uniqueID = "FocusViewer_" + pageInfo.UniqueId;
var paramBuilder = new StringBuilder();
paramBuilder.Append($@"so_{uniqueID}.addParam(""quality"", ""high"");").Append(StringUtils.Constants.ReturnAndNewline);
paramBuilder.Append($@"so_{uniqueID}.addParam(""wmode"", ""transparent"");").Append(StringUtils.Constants.ReturnAndNewline);
paramBuilder.Append($@"so_{uniqueID}.addParam(""allowFullScreen"", ""true"");").Append(StringUtils.Constants.ReturnAndNewline);
paramBuilder.Append($@"so_{uniqueID}.addParam(""allowScriptAccess"", ""always"");").Append(StringUtils.Constants.ReturnAndNewline);
paramBuilder.Append($@"so_{uniqueID}.addParam(""menu"", ""false"");").Append(StringUtils.Constants.ReturnAndNewline);
paramBuilder.Append(
$@"so_{uniqueID}.addParam(""flashvars"", ""pw={imageWidth}&ph={imageHeight}&Times=4000&sizes=14&umcolor=16777215&btnbg=12189697&txtcolor=16777215&urls=""+urls_uniqueID+""&imgs=""+imgs_uniqueID+""&titles=""+titles_uniqueID);").Append(StringUtils.Constants.ReturnAndNewline);
string scriptHtml = $@"
<div id=""flashcontent_{uniqueID}""></div>
<script type=""text/javascript"">
var urls_uniqueID='{TranslateUtils.ObjectCollectionToString(navigationUrls, "|")}';
var imgs_uniqueID='{TranslateUtils.ObjectCollectionToString(imageUrls, "|")}';
var titles_uniqueID='{TranslateUtils.ObjectCollectionToString(titleCollection, "|")}';
var so_{uniqueID} = new SWFObject(""{SiteFilesAssets.GetUrl(pageInfo.ApiUrl, SiteFilesAssets.Flashes.Ali)}"", ""flash_{uniqueID}"", ""{imageWidth}"", ""{imageHeight}"", ""7"", """");
{paramBuilder}
so_{uniqueID}.write(""flashcontent_{uniqueID}"");
</script>
";
scriptHtml = scriptHtml.Replace("uniqueID", uniqueID);
parsedContent = scriptHtml;
}
else if (StringUtils.EqualsIgnoreCase(theme, Theme_Style4))
{
var imageUrls = new StringCollection();
var navigationUrls = new StringCollection();
foreach (var dataItem in dataSource)
{
var contentInfo = new BackgroundContentInfo(dataItem);
if (contentInfo != null && !string.IsNullOrEmpty(contentInfo.ImageUrl))
{
navigationUrls.Add(PageUtility.GetContentUrl(pageInfo.PublishmentSystemInfo, contentInfo));
imageUrls.Add(PageUtility.ParseNavigationUrl(pageInfo.PublishmentSystemInfo, contentInfo.ImageUrl));
}
}
var imageBuilder = new StringBuilder();
var numBuilder = new StringBuilder();
imageBuilder.Append($@"
<div style=""display:block""><a href=""{navigationUrls[0]}"" target=""_blank""><img src=""{imageUrls[0]}"" width=""{imageWidth}"" height=""{imageHeight}"" border=""0"" onMouseOver=""fv_clearAuto();"" onMouseOut=""fv_setAuto()"" /></a></div>
");
if (navigationUrls.Count > 1)
{
for (var i = 1; i < navigationUrls.Count; i++)
{
imageBuilder.Append($@"
<div style=""display:none""><a href=""{navigationUrls[i]}"" target=""_blank""><img src=""{imageUrls[i]}"" width=""{imageWidth}"" height=""{imageHeight}"" border=""0"" onMouseOver=""fv_clearAuto();"" onMouseOut=""fv_setAuto()"" /></a></div>
");
}
}
numBuilder.Append(@"
<td width=""18"" height=""16"" class=""fv_bigon"" onmouseover=""fv_clearAuto();fv_Mea(0);"" onmouseout=""fv_setAuto()"">1</td>
");
if (navigationUrls.Count > 1)
{
for (var i = 1; i < navigationUrls.Count; i++)
{
numBuilder.Append($@"
<td width=""18"" class=""fv_bigoff"" onmouseover=""fv_clearAuto();fv_Mea({i});"" onmouseout=""fv_setAuto()"">{i + 1}</td>
");
}
}
var bgUrl = PageUtility.ParseNavigationUrl(pageInfo.PublishmentSystemInfo,
"@/images/focusviewerbg.png");
string scriptHtml = $@"
<style type=""text/css"">
.fv_adnum{{ position:absolute; z-index:1005; width:{imageWidth - 24}px; height:24px; padding:5px 3px 0 0; left:21px; top:{imageHeight -
29}px; }}
.fv_bigon{{ background:#E59948; font-family:Arial; color:#fff; font-size:12px; text-align:center; cursor:pointer}}
.fv_bigoff{{ background:#7DCABD; font-family:Arial; color:#fff; font-size:12px; text-align:center; cursor:pointer}}
</style>
<div style=""position:relative; left:0; top:0; width:{imageWidth}px; height:{imageHeight}px; background:#000"">
<div id=""fv_filbox"" style=""position:absolute; z-index:999; left:0; top:0; width:{imageWidth}px; height:{imageHeight}px; filter:progid:DXImageTransform.Microsoft.Fade( duration=0.5,overlap=1.0 );"">
{imageBuilder}
</div>
<div class=""fv_adnum"" style=""background:url({bgUrl}) no-repeat !important; background:none ;filter: progid:DXImageTransform.Microsoft.AlphaImageLoader(enabled=true, src='{bgUrl}')""></div>
<div class=""fv_adnum"">
<table border=""0"" cellspacing=""1"" cellpadding=""0"" align=""right"" id=""fv_num"">
<tr>
{numBuilder}
</tr>
</table>
</div>
</div>
<script language=""javascript"">
var fv_n=0;
var fv_nums={navigationUrls.Count};
var fv_showNum = document.getElementById(""fv_num"");
var is_IE=(navigator.appName==""Microsoft Internet Explorer"");
function fv_Mea(value){{
fv_n=value;
for(var i=0;i<fv_nums;i++)
if(value==i){{
fv_showNum.getElementsByTagName(""td"")[i].setAttribute('className', 'fv_bigon');
fv_showNum.getElementsByTagName(""td"")[i].setAttribute('class', 'fv_bigon');
}}
else{{
fv_showNum.getElementsByTagName(""td"")[i].setAttribute('className', 'fv_bigoff');
fv_showNum.getElementsByTagName(""td"")[i].setAttribute('class', 'fv_bigoff');
}}
var divs = document.getElementById(""fv_filbox"").getElementsByTagName(""div"");
if (is_IE){{
document.getElementById(""fv_filbox"").filters[0].Apply();
}}
for(i=0;i<fv_nums;i++)i==value?divs[i].style.display=""block"":divs[i].style.display=""none"";
if (is_IE){{
document.getElementById(""fv_filbox"").filters[0].play();
}}
}}
function fv_clearAuto(){{clearInterval(autoStart)}}
function fv_setAuto(){{autoStart=setInterval(""auto(fv_n)"", 5000)}}
function auto(){{
fv_n++;
if(fv_n>(fv_nums-1))fv_n=0;
fv_Mea(fv_n);
}}
fv_setAuto();
</script>
";
parsedContent = scriptHtml.Replace("fv_", $"fv{pageInfo.UniqueId}_");
}
else
{
var imageUrls = new StringCollection();
var navigationUrls = new StringCollection();
var titleCollection = new StringCollection();
foreach (var dataItem in dataSource)
{
var contentInfo = new BackgroundContentInfo(dataItem);
if (contentInfo != null && !string.IsNullOrEmpty(contentInfo.ImageUrl))
{
//这里使用png图片不管用
//||contentInfo.ImageUrl.ToLower().EndsWith(".png")||contentInfo.ImageUrl.ToLower().EndsWith(".pneg")
if (contentInfo.ImageUrl.ToLower().EndsWith(".jpg") || contentInfo.ImageUrl.ToLower().EndsWith(".jpeg"))
{
titleCollection.Add(StringUtils.ToJsString(PageUtils.UrlEncode(StringUtils.MaxLengthText(StringUtils.StripTags(contentInfo.Title), titleWordNum))));
navigationUrls.Add(PageUtils.UrlEncode(PageUtility.GetContentUrl(pageInfo.PublishmentSystemInfo, contentInfo)));
imageUrls.Add(PageUtils.UrlEncode(PageUtility.ParseNavigationUrl(pageInfo.PublishmentSystemInfo, contentInfo.ImageUrl)));
}
}
}
if (string.IsNullOrEmpty(bgColor))
{
bgColor = "#DADADA";
}
var titles = string.Empty;
if (isShowText == false)
{
textHeight = 0;
}
else
{
titles = TranslateUtils.ObjectCollectionToString(titleCollection, "|");
}
var uniqueID = "FocusViewer_" + pageInfo.UniqueId;
genericControl.ID = uniqueID;
genericControl.InnerHtml = " ";
var divHtml = ControlUtils.GetControlRenderHtml(genericControl);
string scriptHtml = $@"
<script type=""text/javascript"" src=""{SiteFilesAssets.GetUrl(pageInfo.ApiUrl, SiteFilesAssets.BaiRongFlash.Js)}""></script>
<SCRIPT language=javascript type=""text/javascript"">
<!--
var uniqueID_focus_width={imageWidth}
var uniqueID_focus_height={imageHeight}
var uniqueID_text_height={textHeight}
var uniqueID_swf_height = uniqueID_focus_height + uniqueID_text_height
var uniqueID_pics='{TranslateUtils.ObjectCollectionToString(imageUrls, "|")}'
var uniqueID_links='{TranslateUtils.ObjectCollectionToString(navigationUrls, "|")}'
var uniqueID_texts='{titles}'
var uniqueID_FocusFlash = new bairongFlash(""{SiteFilesAssets.GetUrl(pageInfo.ApiUrl, SiteFilesAssets.Flashes.FocusViewer)}"", ""focusflash"", uniqueID_focus_width, uniqueID_swf_height, ""7"", ""{bgColor}"", false, ""High"");
uniqueID_FocusFlash.addParam(""allowScriptAccess"", ""sameDomain"");
uniqueID_FocusFlash.addParam(""menu"", ""false"");
uniqueID_FocusFlash.addParam(""wmode"", ""transparent"");
uniqueID_FocusFlash.addVariable(""pics"", uniqueID_pics);
uniqueID_FocusFlash.addVariable(""links"", uniqueID_links);
uniqueID_FocusFlash.addVariable(""texts"", uniqueID_texts);
uniqueID_FocusFlash.addVariable(""borderwidth"", uniqueID_focus_width);
uniqueID_FocusFlash.addVariable(""borderheight"", uniqueID_focus_height);
uniqueID_FocusFlash.addVariable(""textheight"", uniqueID_text_height);
uniqueID_FocusFlash.write(""uniqueID"");
//-->
</SCRIPT>
";
scriptHtml = scriptHtml.Replace("uniqueID", uniqueID);
parsedContent = divHtml + scriptHtml;
}
}
return(parsedContent);
}
public static List <int> GetNodeIdList(int publishmentSystemId, int channelId, string groupContent, string groupContentNot, string orderByString, EScopeType scopeType, string groupChannel, string groupChannelNot, bool isImageExists, bool isImage, int totalNum, string where)
{
var whereString = DataProvider.NodeDao.GetWhereString(publishmentSystemId, groupContent, groupContentNot, isImageExists, isImage, where);
return(DataProvider.NodeDao.GetNodeIdList(channelId, totalNum, orderByString, whereString, scopeType, groupChannel, groupChannelNot));
}
public static DataSet GetChannelsDataSource(int siteId, int channelId, string group, string groupNot, bool isImageExists, bool isImage, int startNum, int totalNum, string orderByString, EScopeType scopeType, bool isTotal, string where)
{
DataSet ie;
if (isTotal)//从所有栏目中选择
{
var sqlWhereString = Node.GetWhereString(siteId, group, groupNot, isImageExists, isImage, where);
ie = Node.GetStlDataSourceBySiteId(siteId, startNum, totalNum, sqlWhereString, orderByString);
}
else
{
var nodeInfo = ChannelManager.GetChannelInfo(siteId, channelId);
if (nodeInfo == null)
{
return(null);
}
var sqlWhereString = Node.GetWhereString(siteId, group, groupNot, isImageExists, isImage, where);
var channelIdList = ChannelManager.GetChannelIdList(nodeInfo, scopeType, string.Empty, string.Empty, string.Empty);
//ie = DataProvider.ChannelDao.GetStlDataSource(channelIdList, startNum, totalNum, sqlWhereString, orderByString);
ie = Node.GetStlDataSet(channelIdList, startNum, totalNum, sqlWhereString, orderByString);
}
return(ie);
}
public static IEnumerable GetSitesDataSource(string siteName, string directory, int startNum, int totalNum, string whereString, EScopeType scopeType, string orderByString, string since)
{
return(DataProvider.PublishmentSystemDao.GetStlDataSource(siteName, directory, startNum, totalNum, whereString, scopeType, orderByString, since));
}
public static DataSet GetPageChannelsDataSet(int publishmentSystemId, int channelId, string group, string groupNot, bool isImageExists, bool isImage, int startNum, int totalNum, string orderByString, EScopeType scopeType, bool isTotal, string where)
{
DataSet dataSet = null;
if (isTotal)//从所有栏目中选择
{
var sqlWhereString = DataProvider.NodeDao.GetWhereString(publishmentSystemId, group, groupNot, isImageExists, isImage, where);
dataSet = DataProvider.NodeDao.GetStlDataSetByPublishmentSystemId(publishmentSystemId, startNum, totalNum, sqlWhereString, orderByString);
}
else
{
var nodeInfo = NodeManager.GetNodeInfo(publishmentSystemId, channelId);
if (nodeInfo != null)
{
var sqlWhereString = DataProvider.NodeDao.GetWhereString(publishmentSystemId, group, groupNot, isImageExists, isImage, where);
dataSet = DataProvider.NodeDao.GetStlDataSet(nodeInfo, startNum, totalNum, sqlWhereString, scopeType, orderByString);
}
}
return(dataSet);
}
public static IEnumerable GetContentsDataSource(PublishmentSystemInfo publishmentSystemInfo, int channelId, int contentId, string groupContent, string groupContentNot, string tags, bool isImageExists, bool isImage, bool isVideoExists, bool isVideo, bool isFileExists, bool isFile, bool isNoDup, bool isRelatedContents, int startNum, int totalNum, string orderByString, bool isTopExists, bool isTop, bool isRecommendExists, bool isRecommend, bool isHotExists, bool isHot, bool isColorExists, bool isColor, string where, EScopeType scopeType, string groupChannel, string groupChannelNot, NameValueCollection otherAttributes)
{
IEnumerable ie = null;
if (DataProvider.NodeDao.IsExists(channelId))
{
var nodeInfo = NodeManager.GetNodeInfo(publishmentSystemInfo.PublishmentSystemId, channelId);
var tableStyle = NodeManager.GetTableStyle(publishmentSystemInfo, nodeInfo);
var tableName = NodeManager.GetTableName(publishmentSystemInfo, nodeInfo);
if (isRelatedContents && contentId > 0)
{
var isTags = false;
var tagCollection = BaiRongDataProvider.ContentDao.GetValue(tableName, contentId, ContentAttribute.Tags);
if (!string.IsNullOrEmpty(tagCollection))
{
var contentIdArrayList = BaiRongDataProvider.TagDao.GetContentIdListByTagCollection(TranslateUtils.StringCollectionToStringCollection(tagCollection), publishmentSystemInfo.PublishmentSystemId);
contentIdArrayList.Remove(contentId);
if (contentIdArrayList.Count > 0)
{
isTags = true;
if (string.IsNullOrEmpty(where))
{
where =
$"ID IN ({TranslateUtils.ToSqlInStringWithoutQuote(contentIdArrayList)})";
}
else
{
where +=
$" AND (ID IN ({TranslateUtils.ToSqlInStringWithoutQuote(contentIdArrayList)}))";
}
}
}
if (!isTags)
{
if (string.IsNullOrEmpty(where))
{
where = $"ID <> {contentId}";
}
else
{
where += $" AND (ID <> {contentId})";
}
}
}
string sqlWhereString;
if (tableStyle == ETableStyle.BackgroundContent || tableStyle == ETableStyle.GovPublicContent)
{
sqlWhereString = DataProvider.BackgroundContentDao.GetStlWhereString(publishmentSystemInfo, tableName, groupContent, groupContentNot, tags, isImageExists, isImage, isVideoExists, isVideo, isFileExists, isFile, isTopExists, isTop, isRecommendExists, isRecommend, isHotExists, isHot, isColorExists, isColor, where);
}
else
{
sqlWhereString = BaiRongDataProvider.ContentDao.GetStlWhereString(publishmentSystemInfo.PublishmentSystemId, groupContent, groupContentNot, tags, isTopExists, isTop, where);
}
ie = DataProvider.ContentDao.GetStlDataSourceChecked(tableName, channelId, startNum, totalNum, orderByString, sqlWhereString, scopeType, groupChannel, groupChannelNot, isNoDup, otherAttributes);
}
return(ie);
}
public static DataSet GetPageChannelsDataSet(int siteId, int channelId, string group, string groupNot, bool isImageExists, bool isImage, int startNum, int totalNum, string orderByString, EScopeType scopeType, bool isTotal, string where)
{
DataSet dataSet;
if (isTotal)//从所有栏目中选择
{
var sqlWhereString = StlChannelCache.GetWhereString(siteId, group, groupNot, isImageExists, isImage, where);
dataSet = DataProvider.ChannelDao.GetStlDataSetBySiteId(siteId, startNum, totalNum, sqlWhereString, orderByString);
}
else
{
var nodeInfo = ChannelManager.GetChannelInfo(siteId, channelId);
if (nodeInfo == null) return null;
var sqlWhereString = StlChannelCache.GetWhereString(siteId, group, groupNot, isImageExists, isImage, where);
var channelIdList = ChannelManager.GetChannelIdList(nodeInfo, scopeType, string.Empty, string.Empty, string.Empty);
dataSet = DataProvider.ChannelDao.GetStlDataSet(channelIdList, startNum, totalNum, sqlWhereString, orderByString);
}
return dataSet;
}
public static List <int> GetChannelIdList(int siteId, int channelId, string orderByString, EScopeType scopeType, string groupChannel, string groupChannelNot, bool isImageExists, bool isImage, int totalNum, string where)
{
var whereString = Node.GetWhereString(siteId, groupChannel, groupChannelNot, isImageExists, isImage, where);
var channelIdList = Node.GetIdListByScopeType(channelId, scopeType, groupChannel, groupChannelNot);
return(Node.GetIdListByTotalNum(channelIdList, totalNum, orderByString, whereString));
}
public static IDataReader GetSitesDataSource(string siteName, string siteDir, int startNum, int totalNum, string whereString, EScopeType scopeType, string orderByString)
{
return DataProvider.SiteDao.GetStlDataSource(siteName, siteDir, startNum, totalNum, whereString, scopeType, orderByString);
}
public static bool Equals(string typeStr, EScopeType type)
{
return(Equals(type, typeStr));
}
public IEnumerable GetStlDataSource(string siteName, string siteDir, int startNum, int totalNum, string whereString, EScopeType scopeType, string orderByString, string since)
{
IEnumerable ie = null;
var sqlWhereString = string.Empty;
PublishmentSystemInfo publishmentSystemInfo = null;
if (!string.IsNullOrEmpty(siteName))
{
publishmentSystemInfo = PublishmentSystemManager.GetPublishmentSystemInfoBySiteName(siteName);
}
else if (!string.IsNullOrEmpty(siteDir))
{
publishmentSystemInfo = PublishmentSystemManager.GetPublishmentSystemInfoByDirectory(siteDir);
}
if (publishmentSystemInfo != null)
{
sqlWhereString = $"WHERE (ParentPublishmentSystemID = {publishmentSystemInfo.PublishmentSystemId})";
}
else
{
if (scopeType == EScopeType.Children)
{
sqlWhereString = "WHERE (ParentPublishmentSystemID = 0 AND IsHeadquarters = 'False')";
}
else if (scopeType == EScopeType.Descendant)
{
sqlWhereString = "WHERE (IsHeadquarters = 'False')";
}
}
if (!string.IsNullOrEmpty(whereString))
{
sqlWhereString = string.IsNullOrEmpty(sqlWhereString) ? $"WHERE ({whereString})" : $"{sqlWhereString} AND ({whereString})";
}
if (string.IsNullOrEmpty(orderByString) || StringUtils.EqualsIgnoreCase(orderByString, "default"))
{
orderByString = "ORDER BY IsHeadquarters DESC, ParentPublishmentSystemID, Taxis DESC, PublishmentSystemID";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(TableName, startNum, totalNum, SqlUtils.Asterisk, sqlWhereString, orderByString);
ie = (IEnumerable)ExecuteReader(sqlSelect);
}
return(ie);
}
public List <int> GetContentIdListChecked(string tableName, int nodeId, int totalNum, string orderByString, string whereString, EScopeType scopeType)
{
var nodeIdList = DataProvider.NodeDao.GetNodeIdListByScopeType(nodeId, scopeType, string.Empty, string.Empty);
return(BaiRongDataProvider.ContentDao.GetContentIdListChecked(tableName, nodeIdList, totalNum, orderByString, whereString));
}
public IDataReader GetStlDataSource(string siteName, string siteDir, int startNum, int totalNum, string whereString, EScopeType scopeType, string orderByString)
{
IDataReader ie = null;
var sqlWhereString = string.Empty;
SiteInfo siteInfo = null;
if (!string.IsNullOrEmpty(siteName))
{
siteInfo = SiteManager.GetSiteInfoBySiteName(siteName);
}
else if (!string.IsNullOrEmpty(siteDir))
{
siteInfo = SiteManager.GetSiteInfoByDirectory(siteDir);
}
if (siteInfo != null)
{
sqlWhereString = $"WHERE (ParentId = {siteInfo.Id})";
}
else
{
if (scopeType == EScopeType.Children)
{
sqlWhereString = "WHERE (ParentId = 0 AND IsRoot = 'False')";
}
else if (scopeType == EScopeType.Descendant)
{
sqlWhereString = "WHERE (IsRoot = 'False')";
}
}
if (!string.IsNullOrEmpty(whereString))
{
sqlWhereString = string.IsNullOrEmpty(sqlWhereString) ? $"WHERE ({whereString})" : $"{sqlWhereString} AND ({whereString})";
}
if (string.IsNullOrEmpty(orderByString) || StringUtils.EqualsIgnoreCase(orderByString, "default"))
{
orderByString = "ORDER BY IsRoot DESC, ParentId, Taxis DESC, Id";
var sqlSelect = DataProvider.DatabaseDao.GetSelectSqlString(TableName, startNum, totalNum, SqlUtils.Asterisk, sqlWhereString, orderByString);
ie = ExecuteReader(sqlSelect);
}
return(ie);
}
public List <int> GetContentIdArrayListChecked(string tableName, int nodeId, bool isSystemAdministrator, List <int> owningNodeIdList, int totalNum, string orderByString, string whereString, EScopeType scopeType)
{
var nodeIdList = DataProvider.NodeDao.GetNodeIdListByScopeType(nodeId, scopeType, string.Empty, string.Empty);
var theList = new List <int>();
foreach (int theNodeId in nodeIdList)
{
if (isSystemAdministrator || owningNodeIdList.Contains(theNodeId))
{
theList.Add(theNodeId);
}
}
return(BaiRongDataProvider.ContentDao.GetContentIdListChecked(tableName, theList, totalNum, orderByString, whereString));
}
public static List <int> GetChannelIdList(ChannelInfo channelInfo, EScopeType scopeType, string group, string groupNot, string contentModelPluginId)
{
if (channelInfo == null)
{
return(new List <int>());
}
var dic = ChannelManagerCache.GetChannelInfoDictionaryBySiteId(channelInfo.SiteId);
var channelInfoList = new List <ChannelInfo>();
if (channelInfo.ChildrenCount == 0)
{
if (scopeType != EScopeType.Children && scopeType != EScopeType.Descendant)
{
channelInfoList.Add(channelInfo);
}
}
else if (scopeType == EScopeType.Self)
{
channelInfoList.Add(channelInfo);
}
else if (scopeType == EScopeType.All)
{
foreach (var nodeInfo in dic.Values)
{
if (nodeInfo.Id == channelInfo.Id || nodeInfo.ParentId == channelInfo.Id || StringUtils.In(nodeInfo.ParentsPath, channelInfo.Id))
{
channelInfoList.Add(nodeInfo);
}
}
}
else if (scopeType == EScopeType.Children)
{
foreach (var nodeInfo in dic.Values)
{
if (nodeInfo.ParentId == channelInfo.Id)
{
channelInfoList.Add(nodeInfo);
}
}
}
else if (scopeType == EScopeType.Descendant)
{
foreach (var nodeInfo in dic.Values)
{
if (nodeInfo.ParentId == channelInfo.Id || StringUtils.In(nodeInfo.ParentsPath, channelInfo.Id))
{
channelInfoList.Add(nodeInfo);
}
}
}
else if (scopeType == EScopeType.SelfAndChildren)
{
foreach (var nodeInfo in dic.Values)
{
if (nodeInfo.Id == channelInfo.Id || nodeInfo.ParentId == channelInfo.Id)
{
channelInfoList.Add(nodeInfo);
}
}
}
var filteredChannelInfoList = new List <ChannelInfo>();
foreach (var nodeInfo in channelInfoList)
{
if (!string.IsNullOrEmpty(group))
{
if (!StringUtils.In(nodeInfo.GroupNameCollection, group))
{
continue;
}
}
if (!string.IsNullOrEmpty(groupNot))
{
if (StringUtils.In(nodeInfo.GroupNameCollection, groupNot))
{
continue;
}
}
if (!string.IsNullOrEmpty(contentModelPluginId))
{
if (!StringUtils.EqualsIgnoreCase(nodeInfo.ContentModelPluginId, contentModelPluginId))
{
continue;
}
}
filteredChannelInfoList.Add(nodeInfo);
}
return(filteredChannelInfoList.OrderBy(c => c.Taxis).Select(channelInfoInList => channelInfoInList.Id).ToList());
}
public string GetStlSqlStringChecked(string tableName, int publishmentSystemId, int nodeId, int startNum, int totalNum, string orderByString, string whereString, EScopeType scopeType, string groupChannel, string groupChannelNot, bool isNoDup)
{
string sqlWhereString;
if (publishmentSystemId == nodeId && scopeType == EScopeType.All && string.IsNullOrEmpty(groupChannel) && string.IsNullOrEmpty(groupChannelNot))
{
sqlWhereString =
$"WHERE (PublishmentSystemId = {publishmentSystemId} AND NodeID > 0 AND IsChecked = '{true}' {whereString})";
}
else
{
var nodeIdList = DataProvider.NodeDao.GetNodeIdListByScopeType(nodeId, scopeType, groupChannel, groupChannelNot);
if (nodeIdList == null || nodeIdList.Count == 0)
{
return(string.Empty);
}
sqlWhereString = nodeIdList.Count == 1 ? $"WHERE (NodeID = {nodeIdList[0]} AND IsChecked = '{true}' {whereString})" : $"WHERE (NodeID IN ({TranslateUtils.ToSqlInStringWithoutQuote(nodeIdList)}) AND IsChecked = '{true}' {whereString})";
}
if (isNoDup)
{
var sqlString = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(tableName, "MIN(ID)", sqlWhereString + " GROUP BY Title");
sqlWhereString += $" AND ID IN ({sqlString})";
}
if (!string.IsNullOrEmpty(tableName))
{
return(BaiRongDataProvider.TableStructureDao.GetSelectSqlString(tableName, startNum, totalNum, SqlUtils.Asterisk, sqlWhereString, orderByString));
}
return(string.Empty);
}
