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); }