private void OlympicsGuess(GameServerClient client, int nID, byte[] cmdParams, int count)
{
string[] fields = null;
int length = 2;
if (!CheckHelper.CheckTCPCmdFields(nID, cmdParams, count, out fields, length))
{
client.sendCmd <bool>(nID, false);
}
else
{
int roleID = int.Parse(fields[0]);
int dayID = int.Parse(fields[1]);
OlympicsGuessDataDB data = new OlympicsGuessDataDB();
data.RoleID = roleID;
data.DayID = dayID;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("SELECT a1,a2,a3,award1,award2,award3 FROM t_olympics_guess WHERE roleID='{0}' and dayID='{1}' ", roleID, dayID);
MySQLDataReader reader = conn.ExecuteReader(cmdText, new MySQLParameter[0]);
while (reader.Read())
{
data.A1 = int.Parse(reader["a1"].ToString());
data.A2 = int.Parse(reader["a2"].ToString());
data.A3 = int.Parse(reader["a3"].ToString());
data.Award1 = int.Parse(reader["award1"].ToString());
data.Award2 = int.Parse(reader["award2"].ToString());
data.Award3 = int.Parse(reader["award3"].ToString());
}
}
client.sendCmd <OlympicsGuessDataDB>(nID, data);
}
}
private void OlympicsGuessUpdate(GameServerClient client, int nID, byte[] cmdParams, int count)
{
OlympicsGuessDataDB data = DataHelper.BytesToObject <OlympicsGuessDataDB>(cmdParams, 0, count);
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("REPLACE INTO t_olympics_guess(roleID,dayID,a1,a2,a3,award1,award2,award3) \r\n VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}')", new object[]
{
data.RoleID,
data.DayID,
data.A1,
data.A2,
data.A3,
data.Award1,
data.Award2,
data.Award3
});
bool isDB = conn.ExecuteNonQueryBool(cmdText, 0);
}
client.sendCmd <bool>(nID, true);
}
