public static bool ReplaceOpenLottery(OpenLottery data)
{
int ret = -1;
try
{
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string sql = string.Format("REPLACE INTO t_bocai_open_lottery(DataPeriods, AllBalance, SurplusBalance, XiaoHaoDaiBi, BocaiType, strWinNum, WinInfo, IsAward) VALUES({0},{1},{2},{3},{4},'{5}','{6}', {7});", new object[]
{
data.DataPeriods,
data.AllBalance,
data.SurplusBalance,
data.XiaoHaoDaiBi,
data.BocaiType,
data.strWinNum,
data.WinInfo,
data.IsAward
});
ret = conn.ExecuteNonQuery(sql, 0);
}
}
catch (Exception ex)
{
LogManager.WriteLog(LogTypes.Exception, string.Format("[ljl]{0}", ex.ToString()), null, true);
}
return(ret > -1);
}
private void updateOpen(GameServerClient client, int nID, byte[] cmdParams, int count)
{
string msgStr = "false";
try
{
OpenLottery Data = DataHelper.BytesToObject <OpenLottery>(cmdParams, 0, count);
msgStr = BoCaiDBOperator.ReplaceOpenLottery(Data).ToString();
}
catch (Exception ex)
{
LogManager.WriteLog(LogTypes.Exception, ex.ToString(), null, true);
}
client.sendCmd(nID, msgStr);
}
public static void SelectOpenLottery(int bocaiType, out List <OpenLottery> dList)
{
MySQLConnection conn = null;
DBManager dbMgr = DBManager.getInstance();
dList = null;
try
{
conn = dbMgr.DBConns.PopDBConnection();
string sql = string.Format("SELECT `DataPeriods`,`XiaoHaoDaiBi`,`strWinNum`,`WinInfo` ,`AllBalance`,`SurplusBalance` FROM t_bocai_open_lottery WHERE `IsAward` < 1 AND `BocaiType`={0};", bocaiType);
MySQLCommand cmd = new MySQLCommand(sql, conn);
MySQLDataReader reader = cmd.ExecuteReaderEx();
dList = new List <OpenLottery>();
while (reader.Read())
{
OpenLottery Item = new OpenLottery
{
strWinNum = reader["strWinNum"].ToString(),
XiaoHaoDaiBi = Convert.ToInt32(reader["XiaoHaoDaiBi"].ToString()),
WinInfo = reader["WinInfo"].ToString(),
DataPeriods = Convert.ToInt64(reader["DataPeriods"].ToString()),
AllBalance = Convert.ToInt64(reader["AllBalance"].ToString()),
SurplusBalance = Convert.ToInt64(reader["SurplusBalance"].ToString()),
BocaiType = bocaiType
};
dList.Add(Item);
}
GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", sql), EventLevels.Important);
cmd.Dispose();
}
catch (Exception ex)
{
LogManager.WriteLog(LogTypes.Exception, string.Format("[ljl]{0}", ex.ToString()), null, true);
}
finally
{
if (null != conn)
{
dbMgr.DBConns.PushDBConnection(conn);
}
}
}