public Dictionary <int, List <ContentTagInfo> > GetAllContentTags()
{
var allDict = new Dictionary <int, List <ContentTagInfo> >();
var sqlString =
$"SELECT Id, TagName, SiteId, UseNum FROM {TableName} ORDER BY UseNum DESC, TagName";
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
var i = 0;
var tag = new ContentTagInfo(GetInt(rdr, i++), GetString(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i));
allDict.TryGetValue(tag.SiteId, out var list);
if (list == null)
{
list = new List <ContentTagInfo>();
}
list.Add(tag);
allDict[tag.SiteId] = list;
}
rdr.Close();
}
return(allDict);
}
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();
}
