public HongBaoListQueryData QueryHongBaoList()
{
try
{
HongBaoListQueryData queryData = new HongBaoListQueryData
{
KeyStr = this.ActivityKeyStr
};
return(Global.sendToDB <HongBaoListQueryData, HongBaoListQueryData>(1437, queryData, 0));
}
catch (Exception ex)
{
LogManager.WriteException(ex.ToString());
}
return(null);
}
private void GetJieRiHongBaoList(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.List = list;
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string cmdText = string.Format("SELECT `id`,`senderid`,`keystr`,`sendtime`,`endtime`,`msg`,`zuanshi`,`type`,`leftzuanshi`,`state` FROM `t_hongbao_jieri_send` WHERE keystr='{0}';", queryData.KeyStr);
MySQLDataReader reader = conn.ExecuteReader(cmdText, new MySQLParameter[0]);
while (reader.Read())
{
list.Add(new HongBaoSendData
{
hongBaoID = Global.SafeConvertToInt32(reader[0].ToString(), 10),
senderID = Global.SafeConvertToInt32(reader[1].ToString(), 10),
sender = reader[2].ToString(),
sendTime = Global.SafeConvertToDateTime(reader[3].ToString(), DateTime.MinValue),
endTime = Global.SafeConvertToDateTime(reader[4].ToString(), DateTime.MinValue),
message = reader[5].ToString(),
sumDiamondNum = Global.SafeConvertToInt32(reader[6].ToString(), 10),
type = Global.SafeConvertToInt32(reader[7].ToString(), 10),
leftZuanShi = Global.SafeConvertToInt32(reader[8].ToString(), 10),
hongBaoStatus = Global.SafeConvertToInt32(reader[9].ToString(), 10)
});
}
}
queryData.Success = 1;
}
}
catch (Exception ex)
{
LogManager.WriteException(ex.ToString());
}
client.sendCmd <HongBaoListQueryData>(nID, queryData);
}
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);
}
