public void SaveKuaFuLueDuoServerData(int season, KuaFuLueDuoServerInfo data)
{
string sql = string.Format("INSERT INTO t_kfld_server(`serverid`, `sum_ziyuan`, `last_ziyuan`,`mingxing`,`season`) VALUES({0},{1},{2},'{3}',{4}) ON DUPLICATE KEY UPDATE sum_ziyuan='{1}', `last_ziyuan`={2}, `mingxing`='{3}',`season`={4}", new object[]
{
data.ServerId,
data.ZiYuan,
data.LastZiYuan,
data.MingXingZhanMengList,
season
});
this.ExecuteSqlNoQuery(sql);
}
public void SaveKuaFuLueDuoServerRankData(int season, int group, KuaFuLueDuoServerInfo data, int destServerId, int percent)
{
if (destServerId > 0)
{
string sql = string.Format("INSERT IGNORE INTO `t_kfld_zhengfu` (`season`, `serverid`, `fall_sid`, `group`, `info`) VALUES ({0}, {1}, {2}, {3}, {4});", new object[]
{
season,
data.ServerId,
destServerId,
group,
percent
});
this.AddDelayWriteSql(sql);
}
}
private bool LoadKuaFuLueDuoServerData(int minSeasonID)
{
try
{
string strSql = string.Format("SELECT * FROM t_kfld_server where `season`>={0}", minSeasonID);
using (MySqlDataReader sdr = DbHelperMySQL.ExecuteReader(strSql, false))
{
while (sdr != null && sdr.Read())
{
int serverId = Convert.ToInt32(sdr["serverid"]);
if (serverId >= 0 && serverId < this.ZoneID2ServerIDs.Length)
{
int sid = this.ZoneID2ServerIDs[serverId];
KuaFuLueDuoServerInfo data;
if (!this.ServerInfoDict.TryGetValue(sid, out data))
{
data = new KuaFuLueDuoServerInfo
{
ServerId = sid
};
data.ZhengFuList = new List <int>();
data.ShiChouList = new List <int>();
this.ServerInfoDict[sid] = data;
}
int sum_ziyuan = Convert.ToInt32(sdr["sum_ziyuan"]);
int last_ziyuan = Convert.ToInt32(sdr["last_ziyuan"]);
if (data.ZiYuan <= sum_ziyuan)
{
data.ZiYuan = sum_ziyuan;
data.LastZiYuan = last_ziyuan;
data.SeasonId = Convert.ToInt32(sdr["season"]);
data.MingXingZhanMengList = sdr["mingxing"].ToString();
}
if (serverId != sid)
{
this.ExecuteSqlNoQuery(string.Format("update `t_kfld_server` set `season`=0 where `serverid`={0}", serverId));
}
}
}
}
strSql = string.Format("SELECT `serverid`,`fall_sid` FROM t_kfld_zhengfu where `season`>={0}", minSeasonID);
using (MySqlDataReader sdr = DbHelperMySQL.ExecuteReader(strSql, false))
{
while (sdr != null && sdr.Read())
{
int serverId = Convert.ToInt32(sdr["serverid"]);
int fall_sid = Convert.ToInt32(sdr["fall_sid"]);
if (serverId >= 0 && serverId < this.ZoneID2ServerIDs.Length && fall_sid >= 0 && fall_sid <= this.ZoneID2ServerIDs.Length)
{
int sa = this.ZoneID2ServerIDs[serverId];
KuaFuLueDuoServerInfo data;
if (this.ServerInfoDict.TryGetValue(sa, out data))
{
if (!data.ZhengFuList.Contains(fall_sid))
{
data.ZhengFuList.Add(fall_sid);
}
int sb = this.ZoneID2ServerIDs[fall_sid];
if (this.ServerInfoDict.TryGetValue(sb, out data))
{
if (!data.ShiChouList.Contains(sa))
{
data.ShiChouList.Add(sa);
}
}
}
}
}
}
foreach (KuaFuLueDuoServerInfo data in this.ServerInfoDict.Values)
{
if (data.SeasonId > 0)
{
string sql = string.Format("update t_kfld_server set `sum_ziyuan`={1}, `last_ziyuan`={2},`zhengfu`={3} where `serverid`={0}", new object[]
{
data.ServerId,
data.ZiYuan,
data.LastZiYuan,
data.ZhengFuList.Count
});
this.ExecuteSqlNoQuery(sql);
}
}
}
catch (Exception ex)
{
LogManager.WriteExceptionUseCache(ex.ToString());
return(false);
}
return(true);
}
public void SaveKuaFuLueDuoServerZhengFuData(int season, KuaFuLueDuoServerInfo data)
{
string sql = string.Format("UPDATE t_kfld_server set `season`={1},`zhengfu`={2} where `serverid`={0}", data.ServerId, season, (data.ZhengFuList == null) ? 0 : data.ZhengFuList.Count);
this.AddDelayWriteSql(sql);
}
