private static GeneralRecordData LoadSingleTableUserInfo(List<string> primaryKeys) { GeneralRecordData ret = null; try { using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = DBConn.MySqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoadSingleTableUserInfo"; if(primaryKeys.Count != 1) throw new Exception("primary key number don't match !!!"); MySqlParameter inputParam; inputParam = new MySqlParameter("@_Guid", MySqlDbType.UInt64); inputParam.Direction = ParameterDirection.Input; inputParam.Value = (ulong)Convert.ChangeType(primaryKeys[0],typeof(ulong)); cmd.Parameters.Add(inputParam); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { ret = new GeneralRecordData(); object val; TableUserInfo msg = new TableUserInfo(); val = reader["Guid"]; msg.Guid = (ulong)val; ret.PrimaryKeys.Add(val.ToString()); val = reader["AccountId"]; msg.AccountId = (string)val; ret.ForeignKeys.Add(val.ToString()); val = reader["Nickname"]; msg.Nickname = (string)val; val = reader["HeroId"]; msg.HeroId = (int)val; val = reader["CreateTime"]; msg.CreateTime = (string)val; val = reader["LastLogoutTime"]; msg.LastLogoutTime = (string)val; val = reader["Level"]; msg.Level = (int)val; val = reader["ExpPoints"]; msg.ExpPoints = (int)val; val = reader["SceneId"]; msg.SceneId = (int)val; val = reader["PositionX"]; msg.PositionX = (float)val; val = reader["PositionZ"]; msg.PositionZ = (float)val; val = reader["FaceDir"]; msg.FaceDir = (float)val; val = reader["Money"]; msg.Money = (int)val; val = reader["Gold"]; msg.Gold = (int)val; val = reader["SummonerSkillId"]; msg.SummonerSkillId = (int)val; val = reader["IntDatas"]; msg.IntDatas = (string)val; val = reader["FloatDatas"]; msg.FloatDatas = (string)val; val = reader["StringDatas"]; msg.StringDatas = (string)val; ret.DataVersion = (int)reader["DataVersion"]; ret.Data = DbDataSerializer.Encode(msg); } } } } catch (Exception ex) { DBConn.Close(); throw ex; } return ret; }
private static List<GeneralRecordData> LoadAllTableAccount(int start, int count) { List<GeneralRecordData> ret = new List<GeneralRecordData>(); try { using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = DBConn.MySqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoadAllTableAccount"; MySqlParameter inputParam; inputParam = new MySqlParameter("@_Start", MySqlDbType.Int32); inputParam.Direction = ParameterDirection.Input; inputParam.Value = start; cmd.Parameters.Add(inputParam); inputParam = new MySqlParameter("@_Count", MySqlDbType.Int32); inputParam.Direction = ParameterDirection.Input; inputParam.Value = count; cmd.Parameters.Add(inputParam); using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { GeneralRecordData record = new GeneralRecordData(); object val; TableAccount msg = new TableAccount(); val = reader["AccountId"]; msg.AccountId = (string)val; record.PrimaryKeys.Add(val.ToString()); val = reader["IsBanned"]; msg.IsBanned = (bool)val; val = reader["UserGuid"]; msg.UserGuid = (ulong)val; val = reader["IsValid"]; msg.IsValid = (bool)val; record.DataVersion = (int)reader["DataVersion"]; record.Data = DbDataSerializer.Encode(msg); ret.Add(record); } } } } catch (Exception ex) { DBConn.Close(); throw ex; } return ret; }
private static GeneralRecordData LoadSingleTableNicknameInfo(List<string> primaryKeys) { GeneralRecordData ret = null; try { using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = DBConn.MySqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoadSingleTableNicknameInfo"; if(primaryKeys.Count != 1) throw new Exception("primary key number don't match !!!"); MySqlParameter inputParam; inputParam = new MySqlParameter("@_Nickname", MySqlDbType.VarChar); inputParam.Direction = ParameterDirection.Input; inputParam.Value = primaryKeys[0]; inputParam.Size = 32; cmd.Parameters.Add(inputParam); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { ret = new GeneralRecordData(); object val; TableNicknameInfo msg = new TableNicknameInfo(); val = reader["Nickname"]; msg.Nickname = (string)val; ret.PrimaryKeys.Add(val.ToString()); val = reader["UserGuid"]; msg.UserGuid = (ulong)val; ret.DataVersion = (int)reader["DataVersion"]; ret.Data = DbDataSerializer.Encode(msg); } } } } catch (Exception ex) { DBConn.Close(); throw ex; } return ret; }
private static GeneralRecordData LoadSingleTableMailStateInfo(List<string> primaryKeys) { GeneralRecordData ret = null; try { using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = DBConn.MySqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoadSingleTableMailStateInfo"; if(primaryKeys.Count != 1) throw new Exception("primary key number don't match !!!"); MySqlParameter inputParam; inputParam = new MySqlParameter("@_MailGuid", MySqlDbType.UInt64); inputParam.Direction = ParameterDirection.Input; inputParam.Value = (ulong)Convert.ChangeType(primaryKeys[0],typeof(ulong)); cmd.Parameters.Add(inputParam); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { ret = new GeneralRecordData(); object val; TableMailStateInfo msg = new TableMailStateInfo(); val = reader["MailGuid"]; msg.MailGuid = (ulong)val; ret.PrimaryKeys.Add(val.ToString()); val = reader["UserGuid"]; msg.UserGuid = (ulong)val; ret.ForeignKeys.Add(val.ToString()); val = reader["IsRead"]; msg.IsRead = (bool)val; val = reader["IsReceived"]; msg.IsReceived = (bool)val; val = reader["IsDeleted"]; msg.IsDeleted = (bool)val; val = reader["ExpiryDate"]; msg.ExpiryDate = (string)val; ret.DataVersion = (int)reader["DataVersion"]; ret.Data = DbDataSerializer.Encode(msg); } } } } catch (Exception ex) { DBConn.Close(); throw ex; } return ret; }
private static List<GeneralRecordData> LoadMultiTableMemberInfo(List<string> foreignKeys) { List<GeneralRecordData> ret = new List<GeneralRecordData>(); try { using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = DBConn.MySqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoadMultiTableMemberInfo"; if(foreignKeys.Count != 1) throw new Exception("foreign key number don't match !!!"); MySqlParameter inputParam; inputParam = new MySqlParameter("@_UserGuid", MySqlDbType.UInt64); inputParam.Direction = ParameterDirection.Input; inputParam.Value = (ulong)Convert.ChangeType(foreignKeys[0],typeof(ulong)); cmd.Parameters.Add(inputParam); using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { GeneralRecordData record = new GeneralRecordData(); object val; TableMemberInfo msg = new TableMemberInfo(); val = reader["MemberGuid"]; msg.MemberGuid = (ulong)val; record.PrimaryKeys.Add(val.ToString()); val = reader["UserGuid"]; msg.UserGuid = (ulong)val; record.ForeignKeys.Add(val.ToString()); val = reader["HeroId"]; msg.HeroId = (int)val; val = reader["Level"]; msg.Level = (int)val; record.DataVersion = (int)reader["DataVersion"]; record.Data = DbDataSerializer.Encode(msg); ret.Add(record); } } } } catch (Exception ex) { DBConn.Close(); throw ex; } return ret; }
private static List<GeneralRecordData> LoadAllTableUserInfo(int start, int count) { List<GeneralRecordData> ret = new List<GeneralRecordData>(); try { using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = DBConn.MySqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoadAllTableUserInfo"; MySqlParameter inputParam; inputParam = new MySqlParameter("@_Start", MySqlDbType.Int32); inputParam.Direction = ParameterDirection.Input; inputParam.Value = start; cmd.Parameters.Add(inputParam); inputParam = new MySqlParameter("@_Count", MySqlDbType.Int32); inputParam.Direction = ParameterDirection.Input; inputParam.Value = count; cmd.Parameters.Add(inputParam); using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { GeneralRecordData record = new GeneralRecordData(); object val; TableUserInfo msg = new TableUserInfo(); val = reader["Guid"]; msg.Guid = (ulong)val; record.PrimaryKeys.Add(val.ToString()); val = reader["AccountId"]; msg.AccountId = (string)val; record.ForeignKeys.Add(val.ToString()); val = reader["Nickname"]; msg.Nickname = (string)val; val = reader["HeroId"]; msg.HeroId = (int)val; val = reader["CreateTime"]; msg.CreateTime = (string)val; val = reader["LastLogoutTime"]; msg.LastLogoutTime = (string)val; val = reader["Level"]; msg.Level = (int)val; val = reader["ExpPoints"]; msg.ExpPoints = (int)val; val = reader["SceneId"]; msg.SceneId = (int)val; val = reader["PositionX"]; msg.PositionX = (float)val; val = reader["PositionZ"]; msg.PositionZ = (float)val; val = reader["FaceDir"]; msg.FaceDir = (float)val; val = reader["Money"]; msg.Money = (int)val; val = reader["Gold"]; msg.Gold = (int)val; val = reader["SummonerSkillId"]; msg.SummonerSkillId = (int)val; val = reader["IntDatas"]; msg.IntDatas = (string)val; val = reader["FloatDatas"]; msg.FloatDatas = (string)val; val = reader["StringDatas"]; msg.StringDatas = (string)val; record.DataVersion = (int)reader["DataVersion"]; record.Data = DbDataSerializer.Encode(msg); ret.Add(record); } } } } catch (Exception ex) { DBConn.Close(); throw ex; } return ret; }
private static List<GeneralRecordData> LoadAllTableMailInfo(int start, int count) { List<GeneralRecordData> ret = new List<GeneralRecordData>(); try { using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = DBConn.MySqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoadAllTableMailInfo"; MySqlParameter inputParam; inputParam = new MySqlParameter("@_Start", MySqlDbType.Int32); inputParam.Direction = ParameterDirection.Input; inputParam.Value = start; cmd.Parameters.Add(inputParam); inputParam = new MySqlParameter("@_Count", MySqlDbType.Int32); inputParam.Direction = ParameterDirection.Input; inputParam.Value = count; cmd.Parameters.Add(inputParam); using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { GeneralRecordData record = new GeneralRecordData(); object val; TableMailInfo msg = new TableMailInfo(); val = reader["Guid"]; msg.Guid = (ulong)val; record.PrimaryKeys.Add(val.ToString()); val = reader["Sender"]; msg.Sender = (string)val; val = reader["Receiver"]; msg.Receiver = (long)val; val = reader["SendDate"]; msg.SendDate = (string)val; val = reader["ExpiryDate"]; msg.ExpiryDate = (string)val; val = reader["Title"]; msg.Title = (string)val; val = reader["Text"]; msg.Text = (string)val; val = reader["Money"]; msg.Money = (int)val; val = reader["Gold"]; msg.Gold = (int)val; val = reader["ItemIds"]; msg.ItemIds = (string)val; val = reader["ItemNumbers"]; msg.ItemNumbers = (string)val; val = reader["LevelDemand"]; msg.LevelDemand = (int)val; val = reader["IsRead"]; msg.IsRead = (bool)val; record.DataVersion = (int)reader["DataVersion"]; record.Data = DbDataSerializer.Encode(msg); ret.Add(record); } } } } catch (Exception ex) { DBConn.Close(); throw ex; } return ret; }