private void RecvZhanMengHongBao(GameServerClient client, int nID, byte[] cmdParams, int count)
{
int ret = 0;
try
{
HongBaoRecvData args = DataHelper.BytesToObject <HongBaoRecvData>(cmdParams, 0, count);
if (args != null)
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("replace into `t_hongbao_recv` (`hongbaoid`, `rid`, `bhid`, `zuanshi`, `recvtime`, `rname`) values('{0}','{1}','{2}','{3}','{4}','{5}');", new object[]
{
args.HongBaoID,
args.RoleId,
args.BhId,
args.ZuanShi,
args.RecvTime,
args.RoleName
});
ret = conn.ExecuteSql(cmdText, new MySQLParameter[0]);
}
}
}
catch (Exception ex)
{
LogManager.WriteException(ex.ToString());
}
client.sendCmd <int>(nID, ret);
}
private void GetZhanMengHongBaoList(GameServerClient client, int nID, byte[] cmdParams, int count)
{
HongBaoListQueryData queryData = null;
try
{
List <HongBaoSendData> list = new List <HongBaoSendData>();
queryData = DataHelper.BytesToObject <HongBaoListQueryData>(cmdParams, 0, count);
if (null == queryData)
{
queryData = new HongBaoListQueryData();
}
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText;
if (queryData.BhId != 0)
{
cmdText = string.Format("SELECT `id`,`bhid`,`senderid`,`sendername`,`sendtime`,`endtime`,`msg`,`zuanshi`,`count`,`type`,`leftzuanshi`,`leftcount`,`state` FROM `t_hongbao_send` WHERE `state`=0 AND `bhid`={0};", queryData.BhId);
}
else
{
cmdText = string.Format("SELECT `id`,`bhid`,`senderid`,`sendername`,`sendtime`,`endtime`,`msg`,`zuanshi`,`count`,`type`,`leftzuanshi`,`leftcount`,`state` FROM `t_hongbao_send` WHERE `state`=0;", new object[0]);
}
MySQLDataReader reader = conn.ExecuteReader(cmdText, new MySQLParameter[0]);
while (reader.Read())
{
list.Add(new HongBaoSendData
{
hongBaoID = Global.SafeConvertToInt32(reader[0].ToString(), 10),
bhid = Global.SafeConvertToInt32(reader[1].ToString(), 10),
senderID = Global.SafeConvertToInt32(reader[2].ToString(), 10),
sender = reader[3].ToString(),
sendTime = Global.SafeConvertToDateTime(reader[4].ToString(), DateTime.MinValue),
endTime = Global.SafeConvertToDateTime(reader[5].ToString(), DateTime.MinValue),
message = reader[6].ToString(),
sumDiamondNum = Global.SafeConvertToInt32(reader[7].ToString(), 10),
sumCount = Global.SafeConvertToInt32(reader[8].ToString(), 10),
type = Global.SafeConvertToInt32(reader[9].ToString(), 10),
leftZuanShi = Global.SafeConvertToInt32(reader[10].ToString(), 10),
leftCount = Global.SafeConvertToInt32(reader[11].ToString(), 10),
hongBaoStatus = Global.SafeConvertToInt32(reader[12].ToString(), 10)
});
}
reader.Close();
foreach (HongBaoSendData hongbao in list)
{
hongbao.RecvList = new List <HongBaoRecvData>();
cmdText = string.Format("SELECT `bhid`,`rid`,`rname`,`recvtime`,`zuanshi` FROM t_hongbao_recv WHERE hongbaoid={0};", hongbao.hongBaoID);
MySQLDataReader mySQLDataReader;
reader = (mySQLDataReader = conn.ExecuteReader(cmdText, new MySQLParameter[0]));
try
{
while (reader.Read())
{
HongBaoRecvData recvData = new HongBaoRecvData();
recvData.HongBaoID = Global.SafeConvertToInt32(reader[0].ToString(), 10);
recvData.RoleId = Global.SafeConvertToInt32(reader[1].ToString(), 10);
recvData.RoleName = reader[2].ToString();
recvData.RecvTime = Global.SafeConvertToDateTime(reader[3].ToString(), DateTime.MinValue);
recvData.ZuanShi = Global.SafeConvertToInt32(reader[4].ToString(), 10);
hongbao.RecvList.Add(recvData);
}
}
finally
{
if (mySQLDataReader != null)
{
((IDisposable)mySQLDataReader).Dispose();
}
}
}
}
queryData.List = list;
queryData.Success = 1;
}
catch (Exception ex)
{
LogManager.WriteException(ex.ToString());
}
client.sendCmd <HongBaoListQueryData>(nID, queryData);
}
private void GetZhanMengHongBaoRecvList(GameServerClient client, int nID, byte[] cmdParams, int count)
{
HongBaoSendData data = new HongBaoSendData();
try
{
int hongBaoId = DataHelper.BytesToObject <int>(cmdParams, 0, count);
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("SELECT `id`,`bhid`,`senderid`,`sendername`,`sendtime`,`endtime`,`msg`,`zuanshi`,`count`,`type`,`leftzuanshi`,`leftcount`,`state` FROM `t_hongbao_send` WHERE id={0};", hongBaoId);
MySQLDataReader reader = conn.ExecuteReader(cmdText, new MySQLParameter[0]);
while (reader.Read())
{
data.hongBaoID = Global.SafeConvertToInt32(reader[0].ToString(), 10);
data.bhid = Global.SafeConvertToInt32(reader[1].ToString(), 10);
data.senderID = Global.SafeConvertToInt32(reader[2].ToString(), 10);
data.sender = reader[3].ToString();
data.sendTime = Global.SafeConvertToDateTime(reader[4].ToString(), DateTime.MinValue);
data.endTime = Global.SafeConvertToDateTime(reader[5].ToString(), DateTime.MinValue);
data.message = reader[6].ToString();
data.sumDiamondNum = Global.SafeConvertToInt32(reader[7].ToString(), 10);
data.sumCount = Global.SafeConvertToInt32(reader[8].ToString(), 10);
data.type = Global.SafeConvertToInt32(reader[9].ToString(), 10);
data.leftZuanShi = Global.SafeConvertToInt32(reader[10].ToString(), 10);
data.leftCount = Global.SafeConvertToInt32(reader[11].ToString(), 10);
data.hongBaoStatus = Global.SafeConvertToInt32(reader[12].ToString(), 10);
}
reader.Close();
data.RecvList = new List <HongBaoRecvData>();
cmdText = string.Format("SELECT `bhid`,`rid`,`rname`,`recvtime`,`zuanshi` FROM t_hongbao_recv WHERE hongbaoid={0};", hongBaoId);
MySQLDataReader mySQLDataReader;
reader = (mySQLDataReader = conn.ExecuteReader(cmdText, new MySQLParameter[0]));
try
{
while (reader.Read())
{
HongBaoRecvData recvData = new HongBaoRecvData();
recvData.HongBaoID = Global.SafeConvertToInt32(reader[0].ToString(), 10);
recvData.RoleId = Global.SafeConvertToInt32(reader[1].ToString(), 10);
recvData.RoleName = reader[2].ToString();
recvData.RecvTime = Global.SafeConvertToDateTime(reader[3].ToString(), DateTime.MinValue);
recvData.ZuanShi = Global.SafeConvertToInt32(reader[4].ToString(), 10);
data.RecvList.Add(recvData);
}
}
finally
{
if (mySQLDataReader != null)
{
((IDisposable)mySQLDataReader).Dispose();
}
}
reader.Close();
}
}
catch (Exception ex)
{
LogManager.WriteException(ex.ToString());
}
client.sendCmd <HongBaoSendData>(nID, data);
}
