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