public void DeleteMatch(int publishmentSystemId, int nodeId, bool isChannel)
{
var parms = new IDataParameter[]
{
GetParameter(ParmNodeId, EDataType.Integer, nodeId),
GetParameter(ParmIsChannel, EDataType.VarChar, 18, isChannel.ToString()),
};
ExecuteNonQuery(SqlDeleteMatchByNodeId, parms);
SeoManager.RemoveCache(publishmentSystemId);
}
//siteserver_SeoMetasInNodes
public void InsertMatch(int publishmentSystemId, int nodeId, int seoMetaId, bool isChannel)
{
var lastSeoMetaId = GetSeoMetaIdByNodeId(nodeId, isChannel);
if (lastSeoMetaId != 0)
{
DeleteMatch(publishmentSystemId, nodeId, isChannel);
}
var insertParms = new IDataParameter[]
{
GetParameter(ParmNodeId, EDataType.Integer, nodeId),
GetParameter(ParmIsChannel, EDataType.VarChar, 18, isChannel.ToString()),
GetParameter(ParmSeoMetaId, EDataType.Integer, seoMetaId),
GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId),
};
ExecuteNonQuery(SqlInsertMatch, insertParms);
SeoManager.RemoveCache(publishmentSystemId);
}