public static string GetSelectSqlStringByQueryString(string connectionString, string queryString, int startNum,
int totalNum, string orderByString)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(TableStructure),
nameof(GetSelectSqlStringByQueryString), connectionString, queryString, startNum.ToString(),
totalNum.ToString(), orderByString);
var retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval == null)
{
retval = DataProvider.DatabaseDao.GetSelectSqlStringByQueryString(connectionString,
queryString, startNum, totalNum, orderByString);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static string GetStlWhereStringBySearch(string group, string groupNot, bool isImageExists, bool isImage, bool isVideoExists, bool isVideo, bool isFileExists, bool isFile, bool isTopExists, bool isTop, bool isRecommendExists, bool isRecommend, bool isHotExists, bool isHot, bool isColorExists, bool isColor, string where)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content), nameof(GetStlWhereStringBySearch), group, groupNot, isImageExists.ToString(), isImage.ToString(),
isVideoExists.ToString(), isVideo.ToString(), isFileExists.ToString(), isFile.ToString(),
isTopExists.ToString(), isTop.ToString(), isRecommendExists.ToString(), isRecommend.ToString(),
isHotExists.ToString(), isHot.ToString(), isColorExists.ToString(), isColor.ToString(), where);
var retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval == null)
{
retval = DataProvider.ContentDao.GetStlWhereStringBySearch(group, groupNot,
isImageExists, isImage, isVideoExists, isVideo, isFileExists, isFile, isTopExists, isTop,
isRecommendExists, isRecommend, isHotExists, isHot, isColorExists, isColor, where);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static string GetStlWhereString(int siteId, string group, string groupNot, string tags, bool isTopExists, bool isTop, string where)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content), nameof(GetStlWhereString),
siteId.ToString(), group, groupNot, tags, isTopExists.ToString(), isTop.ToString(),
where);
var retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval == null)
{
retval = DataProvider.ContentDao.GetStlWhereString(siteId, group, groupNot, tags,
isTopExists, isTop, where);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static int GetCountOfContentAdd(string tableName, int siteId, int channelId, EScopeType scope,
DateTime begin, DateTime end, string userName, ETriState checkedState)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content), nameof(GetCountOfContentAdd),
siteId.ToString(), channelId.ToString(), EScopeTypeUtils.GetValue(scope),
DateUtils.GetDateString(begin), DateUtils.GetDateString(end), userName, ETriStateUtils.GetValue(checkedState));
var retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval != -1)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval == -1)
{
retval = DataProvider.ContentDao.GetCountOfContentAdd(tableName, siteId, channelId, scope,
begin, end, userName, checkedState);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static string GetStlSqlStringChecked(string tableName, int siteId, int channelId, int startNum, int totalNum, string orderByString, string whereString, EScopeType scopeType, string groupChannel, string groupChannelNot)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content), nameof(GetStlSqlStringChecked),
tableName, siteId.ToString(), channelId.ToString(), startNum.ToString(),
totalNum.ToString(), orderByString, whereString, EScopeTypeUtils.GetValue(scopeType), groupChannel,
groupChannelNot);
var retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval == null)
{
var channelInfo = ChannelManager.GetChannelInfo(siteId, channelId);
var channelIdList = ChannelManager.GetChannelIdList(channelInfo, scopeType, groupChannel, groupChannelNot, string.Empty);
retval = DataProvider.ContentDao.GetStlSqlStringChecked(channelIdList, tableName, siteId, channelId, startNum,
totalNum, orderByString, whereString, scopeType, groupChannel, groupChannelNot);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static string GetWhereString(int siteId, string groupContent, string groupContentNot, bool isImageExists, bool isImage, string where)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Node), nameof(GetWhereString),
siteId.ToString(), groupContent, groupContentNot, isImageExists.ToString(),
isImage.ToString(), where);
var retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval == null)
{
retval = DataProvider.ChannelDao.GetWhereString(siteId, groupContent, groupContentNot,
isImageExists, isImage, where);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static int GetIdByParentIdAndChannelName(int siteId, int parentId, string nodeName, bool recursive)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Node),
nameof(GetIdByParentIdAndChannelName), siteId.ToString(),
parentId.ToString(), nodeName, recursive.ToString());
var retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval != -1)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval == -1)
{
retval = DataProvider.ChannelDao.GetIdByParentIdAndChannelName(siteId,
parentId, nodeName, recursive);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static string GetStlSqlStringCheckedBySearch(string tableName, int startNum, int totalNum, string orderByString, string whereString)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content),
nameof(GetStlSqlStringCheckedBySearch),
tableName, startNum.ToString(), totalNum.ToString(), orderByString, whereString);
var retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval == null)
{
retval = DataProvider.ContentDao.GetStlSqlStringCheckedBySearch(tableName, startNum, totalNum,
orderByString, whereString);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static int GetSiteIdBySiteDir(string siteDir)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Site),
nameof(GetSiteIdBySiteDir), siteDir);
var retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval != -1)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval == -1)
{
retval =
DataProvider.SiteDao.GetIdBySiteDir(
siteDir);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static string GetDisplayName(string userName)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(User), nameof(GetDisplayName), userName);
var retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval == null)
{
retval = DataProvider.UserDao.GetDisplayName(userName);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static ContentInfo GetContentInfo(string tableName, int contentId)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content), nameof(GetContentInfo), tableName, contentId.ToString());
var retval = StlCacheUtils.GetCache <ContentInfo>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <ContentInfo>(cacheKey);
if (retval == null)
{
retval = DataProvider.ContentDao.GetContentInfo(tableName, contentId);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static List <int> GetIdListByTotalNum(List <int> channelIdList, int totalNum, string orderByString, string whereString)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Node), nameof(GetIdListByTotalNum),
TranslateUtils.ObjectCollectionToString(channelIdList), totalNum.ToString(), orderByString, whereString);
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.GetIdListByTotalNum(channelIdList, totalNum, orderByString, whereString);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static int GetChannelId(string tableName, int contentId)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content), nameof(GetChannelId), tableName,
contentId.ToString());
var retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval != -1)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval == -1)
{
retval = DataProvider.ContentDao.GetChannelId(tableName, contentId);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static ChannelInfo GetChannelInfoByTaxis(int channelId)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Node), nameof(GetChannelInfoByTaxis),
channelId.ToString());
var retval = StlCacheUtils.GetCache <ChannelInfo>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <ChannelInfo>(cacheKey);
if (retval == null)
{
retval = DataProvider.ChannelDao.GetChannelInfoByTaxis(channelId);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static List <int> GetContentIdListChecked(string tableName, int channelId, string orderByFormatString)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content), nameof(GetContentIdListChecked),
tableName, channelId.ToString(), orderByFormatString);
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.ContentDao.GetContentIdListChecked(tableName, channelId, orderByFormatString);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static DateTime GetLastEditDate(string tableName, int contentId)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content), nameof(GetLastEditDate), tableName,
contentId.ToString());
var retval = StlCacheUtils.GetDateTimeCache(cacheKey);
if (retval != DateTime.MinValue)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetDateTimeCache(cacheKey);
if (retval == DateTime.MinValue)
{
retval = DataProvider.ContentDao.GetLastEditDate(tableName, contentId);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static List <TagInfo> GetTagInfoList(int siteId, int contentId, bool isOrderByCount, int totalNum)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Tag),
nameof(GetTagInfoList), siteId.ToString(), contentId.ToString(), isOrderByCount.ToString(), totalNum.ToString());
var retval = StlCacheUtils.GetCache <List <TagInfo> >(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <List <TagInfo> >(cacheKey);
if (retval == null)
{
retval = DataProvider.TagDao.GetTagInfoList(siteId, contentId, isOrderByCount, totalNum);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static int GetSequence(int siteId, int channelId)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Node), nameof(GetSequence),
siteId.ToString(), channelId.ToString());
var retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval != -1)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval == -1)
{
retval = DataProvider.ChannelDao.GetSequence(siteId, channelId);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static List <int> GetIdListByScopeType(int channelId, int childrenCount, EScopeType scope, string group, string groupNot)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Node), nameof(GetIdListByScopeType),
channelId.ToString(), childrenCount.ToString(), EScopeTypeUtils.GetValue(scope), group, groupNot);
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, childrenCount, scope, group, groupNot, string.Empty);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static string GetValue(string tableName, int contentId, string type)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content), nameof(GetValue), tableName,
contentId.ToString(), type);
var retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval == null)
{
retval = DataProvider.ContentDao.GetValue(tableName, contentId, type);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static int GetIdByParentIdAndTaxis(int parentId, int taxis, bool isNextChannel)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Node), nameof(GetIdByParentIdAndTaxis),
parentId.ToString(), taxis.ToString(), isNextChannel.ToString());
var retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval != -1)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval == -1)
{
retval = DataProvider.ChannelDao.GetIdByParentIdAndTaxis(parentId, taxis, isNextChannel);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static DataSet GetStlDataSourceChecked(List <int> channelIdList, string tableName, int startNum, int totalNum, string orderByString, string whereString, LowerNameValueCollection others)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content), nameof(GetStlDataSourceChecked),
TranslateUtils.ObjectCollectionToString(channelIdList), tableName, startNum.ToString(), totalNum.ToString(), orderByString, whereString, TranslateUtils.NameValueCollectionToString(others));
var retval = StlCacheUtils.GetCache <DataSet>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <DataSet>(cacheKey);
if (retval == null)
{
retval = DataProvider.ContentDao.GetStlDataSourceChecked(channelIdList, tableName, startNum, totalNum, orderByString, whereString, others);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static DataSet GetStlDataSourceBySiteId(int siteId, int startNum, int totalNum, string whereString, string orderByString)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Node), nameof(GetStlDataSourceBySiteId),
siteId.ToString(), startNum.ToString(), totalNum.ToString(), whereString, orderByString);
var retval = StlCacheUtils.GetCache <DataSet>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <DataSet>(cacheKey);
if (retval == null)
{
retval = DataProvider.ChannelDao.GetStlDataSourceBySiteId(siteId, startNum, totalNum, whereString, orderByString);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static int GetCountCheckedImage(int siteId, int channelId)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Content), nameof(GetCountCheckedImage),
siteId.ToString(), channelId.ToString());
var retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval != -1)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval == -1)
{
retval = DataProvider.ContentDao.GetCountCheckedImage(siteId, channelId);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static int GetPageTotalCount(string sqlString)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Database), nameof(GetPageTotalCount),
sqlString);
var retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval != -1)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetIntCache(cacheKey);
if (retval == -1)
{
retval = DataProvider.DatabaseDao.GetPageTotalCount(sqlString);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static DataSet GetDataSet(string connectionString, string queryString)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Database), nameof(GetDataSet),
connectionString, queryString);
var retval = StlCacheUtils.GetCache <DataSet>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <DataSet>(cacheKey);
if (retval == null)
{
retval = DataProvider.DatabaseDao.GetDataSet(connectionString, queryString);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static List <int> GetContentIdListByTagCollection(StringCollection tagCollection, int siteId)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Tag),
nameof(GetContentIdListByTagCollection), TranslateUtils.ObjectCollectionToString(tagCollection),
siteId.ToString());
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.TagDao.GetContentIdListByTagCollection(tagCollection, siteId);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static string GetStlPageSqlString(string sqlString, string orderByString, int totalNum, int pageNum, int currentPageIndex)
{
var cacheKey = StlCacheUtils.GetCacheKey(nameof(Database), nameof(GetStlPageSqlString),
sqlString, orderByString, totalNum.ToString(), pageNum.ToString(), currentPageIndex.ToString());
var retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval != null)
{
return(retval);
}
lock (LockObject)
{
retval = StlCacheUtils.GetCache <string>(cacheKey);
if (retval == null)
{
retval = DataProvider.DatabaseDao.GetStlPageSqlString(sqlString, orderByString, totalNum, pageNum,
currentPageIndex);
StlCacheUtils.SetCache(cacheKey, retval);
}
}
return(retval);
}
public static void ClearCache()
{
StlCacheUtils.ClearCache(nameof(Node));
}
public static void ClearCache()
{
StlCacheUtils.ClearCache(nameof(Content));
}
