public void Delete(string tagName, int siteId)
{
var contentTagParms = new IDataParameter[]
{
GetParameter(ParmTagName, DataType.VarChar, 255, tagName),
GetParameter(ParmSiteId, DataType.Integer, siteId)
};
ExecuteNonQuery(SqlDelete, contentTagParms);
ContentTagManager.ClearCache();
}
public void Update(ContentTagInfo contentTag)
{
var updateParms = new IDataParameter[]
{
GetParameter(ParmUseNum, DataType.Integer, contentTag.UseNum),
GetParameter(ParmTagName, DataType.VarChar, 255, contentTag.TagName),
GetParameter(ParmSiteId, DataType.Integer, contentTag.SiteId)
};
ExecuteNonQuery(SqlUpdate, updateParms);
ContentTagManager.ClearCache();
}
public object GetContentAdd(RequestImpl request)
{
var requestSiteId = request.SiteId;
var requestChannelId = request.ChannelId;
var requestContentId = request.ContentId;
var sites = new List <object>();
var channels = new List <object>();
object site = null;
object channel = null;
List <string> groupNames = null;
List <string> tagNames = null;
ContentInfo contentInfo = null;
List <TableStyleInfo> styles = null;
List <KeyValuePair <int, string> > checkedLevels = null;
var checkedLevel = 0;
if (request.IsUserLoggin)
{
SiteInfo siteInfo = null;
ChannelInfo channelInfo = null;
var siteIdList = request.UserPermissionsImpl.GetSiteIdList();
foreach (var siteId in siteIdList)
{
var permissionSiteInfo = SiteManager.GetSiteInfo(siteId);
if (requestSiteId == siteId)
{
siteInfo = permissionSiteInfo;
}
sites.Add(new
{
permissionSiteInfo.Id,
permissionSiteInfo.SiteName
});
}
if (siteInfo == null && siteIdList.Count > 0)
{
siteInfo = SiteManager.GetSiteInfo(siteIdList[0]);
}
if (siteInfo != null)
{
var channelIdList = request.UserPermissionsImpl.GetChannelIdList(siteInfo.Id,
ConfigManager.ChannelPermissions.ContentAdd);
foreach (var permissionChannelId in channelIdList)
{
var permissionChannelInfo = ChannelManager.GetChannelInfo(siteInfo.Id, permissionChannelId);
if (channelInfo == null || permissionChannelInfo.Id == requestChannelId)
{
channelInfo = permissionChannelInfo;
}
channels.Add(new
{
permissionChannelInfo.Id,
ChannelName = ChannelManager.GetChannelNameNavigation(siteInfo.Id, permissionChannelId)
});
}
site = new
{
siteInfo.Id,
siteInfo.SiteName,
SiteUrl = PageUtility.GetSiteUrl(siteInfo, false)
};
groupNames = ContentGroupManager.GetGroupNameList(siteInfo.Id);
tagNames = ContentTagManager.GetTagNameList(siteInfo.Id);
}
if (channelInfo != null)
{
channel = new
{
channelInfo.Id,
ChannelName = ChannelManager.GetChannelNameNavigation(siteInfo.Id, channelInfo.Id)
};
styles = TableStyleManager.GetContentStyleInfoList(siteInfo, channelInfo);
var checkKeyValuePair = CheckManager.GetUserCheckLevel(request.AdminPermissionsImpl, siteInfo, siteInfo.Id);
checkedLevels = CheckManager.GetCheckedLevels(siteInfo, checkKeyValuePair.Key, checkedLevel, true);
if (requestContentId != 0)
{
checkedLevels.Insert(0, new KeyValuePair <int, string>(CheckManager.LevelInt.NotChange, CheckManager.Level.NotChange));
checkedLevel = CheckManager.LevelInt.NotChange;
contentInfo = ContentManager.GetContentInfo(siteInfo, channelInfo, requestContentId);
if (contentInfo != null &&
(contentInfo.SiteId != siteInfo.Id || contentInfo.ChannelId != channelInfo.Id))
{
contentInfo = null;
}
}
else
{
contentInfo = new ContentInfo(new
{
Id = 0,
SiteId = siteInfo.Id,
ChannelId = channelInfo.Id,
AddDate = DateTime.Now
});
}
}
}
return(new
{
Value = request.UserInfo,
Config = ConfigManager.Instance.SystemConfigInfo,
Sites = sites,
Channels = channels,
Site = site,
Channel = channel,
AllGroupNames = groupNames,
AllTagNames = tagNames,
Styles = styles,
CheckedLevels = checkedLevels,
CheckedLevel = checkedLevel,
Content = contentInfo,
});
}
