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