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