public void UpdateParentIdToZero(int parentId) { var sqlString = "UPDATE siteserver_Site SET ParentId = 0 WHERE ParentId = " + parentId; ExecuteNonQuery(sqlString); SiteManager.ClearCache(); }
public void Update(SiteInfo info) { var sqlString = $"UPDATE {TableName} SET SiteName = @SiteName, DomainName = @DomainName, SiteDir = @SiteDir, TableName = @TableName, IsRoot = @IsRoot, ParentId = @ParentId, Taxis = @Taxis, SettingsXML = @SettingsXML WHERE Id = @Id"; var updateParms = new IDataParameter[] { GetParameter(ParmSiteName, DataType.VarChar, 50, info.SiteName), GetParameter(ParmDomainName, DataType.VarChar, 150, info.DomainName), GetParameter(ParmSiteDir, DataType.VarChar, 50, info.SiteDir), GetParameter(ParmTableName, DataType.VarChar, 50, info.TableName), GetParameter(ParmIsRoot, DataType.VarChar, 18, info.IsRoot.ToString()), GetParameter(ParmParentId, DataType.Integer, info.ParentId), GetParameter(ParmTaxis, DataType.Integer, info.Taxis), GetParameter(ParmSettingsXml, DataType.Text, info.Additional.ToString()), GetParameter(ParmId, DataType.Integer, info.Id) }; if (info.IsRoot) { UpdateAllIsRoot(); } ExecuteNonQuery(sqlString, updateParms); SiteManager.ClearCache(); SystemManager.UpdateSites(); }
private void UpdateAllIsRoot() { var sqlString = $"UPDATE {TableName} SET IsRoot = @IsRoot"; var updateParms = new IDataParameter[] { GetParameter(ParmIsRoot, DataType.VarChar, 18, false.ToString()) }; ExecuteNonQuery(sqlString, updateParms); SiteManager.ClearCache(); }
public void UpdateTableName(int siteId, string tableName) { var sqlString = $"UPDATE {TableName} SET TableName = @TableName WHERE Id = @Id"; var updateParms = new IDataParameter[] { GetParameter(ParmTableName, DataType.VarChar, 50, tableName), GetParameter(ParmId, DataType.Integer, siteId) }; ExecuteNonQuery(sqlString, updateParms); SiteManager.ClearCache(); }
public void Delete(int siteId) { var siteInfo = SiteManager.GetSiteInfo(siteId); var list = ChannelManager.GetChannelIdList(siteId); DataProvider.TableStyleDao.Delete(list, siteInfo.TableName); DataProvider.TagDao.DeleteTags(siteId); DataProvider.ChannelDao.Delete(siteId, siteId); UpdateParentIdToZero(siteId); ExecuteNonQuery($"DELETE FROM siteserver_Site WHERE Id = {siteId}"); SiteManager.ClearCache(); ChannelManager.RemoveCache(siteId); PermissionManager.ClearAllCache(); }
public void InsertWithTrans(SiteInfo info, IDbTransaction trans) { var sqlString = $"INSERT INTO {TableName} (Id, SiteName, SiteDir, TableName, IsRoot, ParentId, Taxis, SettingsXML) VALUES (@Id, @SiteName, @SiteDir, @TableName, @IsRoot, @ParentId, @Taxis, @SettingsXML)"; //获取排序值 var taxis = GetMaxTaxis() + 1; var insertParms = new IDataParameter[] { GetParameter(ParmId, DataType.Integer, info.Id), GetParameter(ParmSiteName, DataType.VarChar, 50, info.SiteName), GetParameter(ParmSiteDir, DataType.VarChar, 50, info.SiteDir), GetParameter(ParmTableName, DataType.VarChar, 50, info.TableName), GetParameter(ParmIsRoot, DataType.VarChar, 18, info.IsRoot.ToString()), GetParameter(ParmParentId, DataType.Integer, info.ParentId), GetParameter(ParmTaxis, DataType.Integer, taxis), GetParameter(ParmSettingsXml, DataType.Text, info.Additional.ToString()) }; ExecuteNonQuery(trans, sqlString, insertParms); SiteManager.ClearCache(); }
public bool UpdateTaxisToUp(int siteId) { SetTaxisNotZero(); //var sbSql = new StringBuilder(); //sbSql.AppendFormat("SELECT TOP 1 Id, Taxis FROM siteserver_Site "); //sbSql.AppendFormat(" WHERE Taxis < (SELECT Taxis FROM siteserver_Site WHERE Id = {0}) ", siteId); //sbSql.AppendFormat(" ORDER BY Taxis DESC"); var sqlString = SqlUtils.ToTopSqlString("siteserver_Site", "Id, Taxis", $"WHERE Taxis < (SELECT Taxis FROM siteserver_Site WHERE Id = {siteId})", "ORDER BY Taxis DESC", 1); var higherId = 0; var higherTaxis = 0; using (var reader = ExecuteReader(sqlString)) { if (reader.Read()) { higherId = Convert.ToInt32(reader[0]); higherTaxis = Convert.ToInt32(reader[1]); } reader.Close(); } var selectedTaxis = GetTaxis(siteId); if (higherId == 0) { return(false); } SetTaxis(siteId, higherTaxis); SetTaxis(higherId, selectedTaxis); SiteManager.ClearCache(); return(true); }