public bool addNotice(string title, string content, int dayamount, GMUser user) { if (user == null) { return(false); } string[] sp = { "\r\n" }; string[] tmp = content.Split(sp, StringSplitOptions.None); int i = 0; content = ""; for (; i < tmp.Length - 1; i++) { content += tmp[i]; content += "&"; } content += tmp[i]; bool res = _addNotice(title, content, dayamount, user.getDbServerID()); if (res) { // OpLogMgr.getInstance().addLog(LogType.PUBLIC_NOTICE, new ParamAddNotice(title, content, dayamount), user); } user.setOpResult(res ? OpRes.opres_success : OpRes.op_res_failed); return(res); }
private OpRes query(ParamGameHistory param, IMongoQuery imq, GMUser user) { fillData fillFun = null; string tableName = getTableName(param, ref fillFun); if (tableName == "") { return(OpRes.op_res_not_found_data); } user.totalRecord = DBMgr.getInstance().getRecordCount(tableName, imq, user.getDbServerID(), DbName.DB_PUMP); List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(tableName, user.getDbServerID(), DbName.DB_PUMP, imq, (param.m_curPage - 1) * param.m_countEachPage, param.m_countEachPage); if (dataList == null || dataList.Count == 0) { return(OpRes.op_res_not_found_data); } fillFun(param, user, dataList); return(OpRes.opres_success); }
// 解析牛牛json串信息 public static InfoCows parseInfoCows(string exInfo, GMUser user) { InfoCows info = null; try { DbCowsBet bet = BaseJsonSerializer.deserialize <DbCowsBet>(exInfo); if (bet == null) { return(null); } info = new InfoCows(); info.m_betInfo = bet; ObjectId oid = ObjectId.Parse(bet.key); Dictionary <string, object> data = DBMgr.getInstance().getTableData(TableName.PUMP_COWS_CARD, "_id", oid, user.getDbServerID(), DbName.DB_PUMP); if (data == null) { return(null); } detailInfoForCows(info, data); } catch (System.Exception ex) { } return(info); }
// 金币下注分布 private OpRes queryOutlayDistribution(ParamQuery param, IMongoQuery imq, GMUser user) { List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.STAT_NEW_PLAYER_OUTLAY_DISTRIBUTION, user.getDbServerID(), DbName.DB_PUMP, imq, 0, 0, null, "genTime", false); if (dataList == null || dataList.Count == 0) { return(OpRes.op_res_not_found_data); } int i = 0; for (i = 0; i < dataList.Count; i++) { Dictionary <string, object> data = dataList[i]; DateTime time = Convert.ToDateTime(data["genTime"]).ToLocalTime(); for (int k = 0; k < 11; k++) { int val = Convert.ToInt32(data[k.ToString()]); m_result.addOutlayInfo(time, k, val); } } return(OpRes.opres_success); }
// 开始统计 public override OpRes doStat(object param, GMUser user) { m_result.reset(); MapReduceResult map_result = DBMgr.getInstance().executeMapReduce(TableName.PLAYER_INFO, user.getDbServerID(), DbName.DB_PLAYER, null, MapReduceTable.getMap("vipLevel"), MapReduceTable.getReduce("vipLevel")); if (map_result != null) { IEnumerable <BsonDocument> bson = map_result.GetResults(); foreach (BsonDocument d in bson) { try { BsonValue resValue = d["value"]; int count = resValue["count"].ToInt32(); int vip = Convert.ToInt32(d["_id"]); m_result.addVipLevel(vip, count); } catch (System.Exception ex) { } } } return(OpRes.opres_success); }
void getSEValue(ParamQuery param, GMUser user, string[] fields, int playerId, ref long svalue, ref long evalue) { DateTime mint = DateTime.Now, maxt = DateTime.Now; Tool.splitTimeStr(param.m_time, ref mint, ref maxt); IMongoQuery imq1 = Query.LT("genTime", BsonValue.Create(maxt)); IMongoQuery imq2 = Query.GTE("genTime", BsonValue.Create(mint)); IMongoQuery imq = Query.And(imq1, imq2, Query.EQ("playerId", BsonValue.Create(playerId))); List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.STAT_PLAYER_DRAGON, user.getDbServerID(), DbName.DB_PUMP, imq, 0, 1, fields, "genTime", true); if (dataList.Count > 0) { svalue = Convert.ToInt32(dataList[0][fields[0]]); } dataList = DBMgr.getInstance().executeQuery(TableName.STAT_PLAYER_DRAGON, user.getDbServerID(), DbName.DB_PUMP, imq, 0, 1, fields, "genTime", false); if (dataList.Count > 0) { evalue = Convert.ToInt32(dataList[0][fields[1]]); } }
private OpRes queryEnterRoom(ParamQuery param, IMongoQuery imq, GMUser user) { List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.STAT_NEW_PLAYER_ENTER_ROOM, user.getDbServerID(), DbName.DB_PUMP, imq, 0, 0, null, "genTime", false); if (dataList == null || dataList.Count == 0) { return(OpRes.op_res_not_found_data); } int i = 0; for (i = 0; i < dataList.Count; i++) { Dictionary <string, object> data = dataList[i]; DateTime time = Convert.ToDateTime(data["genTime"]).ToLocalTime(); int roomId = Convert.ToInt32(data["roomId"]); int enterCount = Convert.ToInt32(data["enterCount"]); m_result.addEnterCount(time, roomId, enterCount); } return(OpRes.opres_success); }
// 给指定玩家加钱,gold金币, gem钻石 public bool addPlayerMoney(int playerid, int gold, int gem, GMUser account) { if (gold < 0 || gem < 0 || account == null) { LOG.Info("给玩家id [{0}]增加金币时出错,传入的值为负!", playerid); return(false); } bool res = _addPlayerMoney(playerid, gold, gem, account.getDbServerID()); if (res) { Dictionary <string, object> data = null; // DBMgr.getInstance().getTableData("EtPlayer", "Id", playerid, account.getDbServerID(), DbName.DB_FISH_LORD); if (data != null) { if (data.ContainsKey("IsBot")) { bool isbot = Convert.ToBoolean(data["IsBot"]); if (!isbot) { OpLogMgr.getInstance().addLog(LogType.ADD_MONEY, new ParamAddMoney(playerid, gold, gem), account); } } } } account.setOpResult(res ? OpRes.opres_success : OpRes.op_res_failed); return(res); }
protected override MapReduceResult getMapReduceResult(IMongoQuery imq, GMUser user) { MapReduceResult mapResult = DBMgr.getInstance().executeMapReduce(TableName.PUMP_ACTIVE_PERSON, user.getDbServerID(), DbName.DB_PUMP, imq, MapReduceTable.getMap("activePerson"), MapReduceTable.getReduce("activePerson")); return(mapResult); }
protected OpRes query(ParamSearch param, IMongoQuery imq, GMUser user, string tableName, int dbName) { user.totalRecord = DBMgr.getInstance().getRecordCount(tableName, imq, user.getDbServerID(), dbName); List <Dictionary <string, object> > data = DBMgr.getInstance().executeQuery(tableName, user.getDbServerID(), DbName.DB_ACCOUNT, imq, (param.m_curPage - 1) * param.m_countEachPage, param.m_countEachPage, param.m_retFields, "date", false); if (data == null || data.Count == 0) { return(OpRes.op_res_not_found_data); } int i = 0; for (i = 0; i < data.Count; i++) { ResultItem tmp = new ResultItem(); m_result.Add(tmp); tmp.m_time = Convert.ToDateTime(data[i]["date"]).ToLocalTime().ToShortDateString(); foreach (var d in data[i]) { if (d.Key == "date") { continue; } tmp.addValue(d.Key, Convert.ToInt64(d.Value)); } } return(OpRes.opres_success); }
// 开始统计 public override OpRes doStat(object param, GMUser user) { m_result.Clear(); m_cond.startQuery(); OpRes res = makeQuery(param, user, m_cond); if (res != OpRes.opres_success) { return(res); } ParamQuery p = (ParamQuery)param; if (isSame(p, user)) { return(query(p, null, user)); } else { m_lastSearchTime = p.m_time; m_dbId = user.getDbServerID(); } IMongoQuery imqTime = m_cond.getImq(); MapReduceResult map_result = DBMgr.getInstance().executeMapReduce(TableName.STAT_PLAYER_DRAGON, user.getDbServerID(), DbName.DB_PUMP, imqTime, MapReduceTable.getMap("playerDragonBall"), MapReduceTable.getReduce("playerDragonBall"), MapTable); if (map_result != null) { return(query(p, null, user)); } return(OpRes.opres_success); }
// 开始统计 public override OpRes doStat(object param, GMUser user) { m_result.Clear(); m_cond.startQuery(); OpRes res = makeQuery(param, user, m_cond); if (res != OpRes.opres_success) { return(res); } ParamIncomeExpenses p = (ParamIncomeExpenses)param; if (isSame(p, user)) { return(query(p, null, user)); } else { m_lastParam.assign(p, user.getDbServerID()); } IMongoQuery imqTime = m_cond.getImq(); MapReduceResult map_result = DBMgr.getInstance().executeMapReduce(TableName.STAT_INCOME_EXPENSES, user.getDbServerID(), DbName.DB_PUMP, imqTime, MapReduceTable.getMap("playerIncomeExpenses"), MapReduceTable.getReduce("playerIncomeExpenses"), MapTable); if (map_result != null) { return(query(p, null, user)); } return(OpRes.opres_success); }
protected virtual OpRes query(ParamQuery param, IMongoQuery imq, GMUser user) { // 查看满足条件的记当个数 user.totalRecord = DBMgr.getInstance().getRecordCount(MapTable, null, user.getDbServerID(), DbName.DB_PUMP); List <BsonDocument> data = DBMgr.getInstance().executeQueryBsonDoc(MapTable, user.getDbServerID(), DbName.DB_PUMP, null, (param.m_curPage - 1) * param.m_countEachPage, param.m_countEachPage, null, "value.rechargeMoney", false); if (data == null || data.Count == 0) { return(OpRes.op_res_not_found_data); } int i = 0; for (i = 0; i < data.Count; i++) { addResult(data[i], user); } return(OpRes.opres_success); }
OpRes statAve(IMongoQuery imq, GMUser user) { m_result.Clear(); MapReduceResult mapResult = DBMgr.getInstance().executeMapReduce(TableName.STAT_PLAYER_GAME_BET_RESULT, user.getDbServerID(), DbName.DB_PUMP, imq, MapReduceTable.getMap("userGameBet"), MapReduceTable.getReduce("userGameBet")); if (mapResult != null) { IEnumerable <BsonDocument> bson = mapResult.GetResults(); foreach (BsonDocument d in bson) { ResultItemPlayerGameBet tmp = new ResultItemPlayerGameBet(); m_result.Add(tmp); BsonValue resValue = d["value"]; tmp.m_time = Convert.ToDateTime(d["_id"]).ToLocalTime(); tmp.m_round = resValue["playerCount"].ToInt32(); long max = resValue["maxCarry"].ToInt64(); long min = resValue["minCarry"].ToInt64(); double sum = resValue["sumCarry"].ToDouble(); tmp.addData(ResultItemPlayerGameBet.CARRY, sum, max, min); max = resValue["maxOutlay"].ToInt64(); min = resValue["minOutlay"].ToInt64(); sum = resValue["sumOutlay"].ToDouble(); tmp.addData(ResultItemPlayerGameBet.OUTLAY, sum, max, min); max = resValue["maxWin"].ToInt64(); min = resValue["minWin"].ToInt64(); sum = resValue["sumWin"].ToDouble(); tmp.addData(ResultItemPlayerGameBet.WIN, sum, max, min); max = resValue["maxLose"].ToInt64(); min = resValue["minLose"].ToInt64(); sum = resValue["sumLose"].ToDouble(); tmp.addData(ResultItemPlayerGameBet.LOSE, sum, max, min); tmp.m_rw = resValue["rw"].ToInt64(); } } return(OpRes.opres_success); }
// 开始统计 public override OpRes doStat(object param, GMUser user) { IMongoQuery imqTime = null; string time = (string)param; if (!string.IsNullOrEmpty(time)) { DateTime mint = DateTime.Now, maxt = DateTime.Now; bool res = Tool.splitTimeStr(time, ref mint, ref maxt); if (!res) { return(OpRes.op_res_time_format_error); } m_result.reset(); IMongoQuery imq1 = Query.LT("create_time", BsonValue.Create(maxt)); IMongoQuery imq2 = Query.GTE("create_time", BsonValue.Create(mint)); imqTime = Query.And(imq1, imq2); } m_result.reset(); MapReduceResult map_result = DBMgr.getInstance().executeMapReduce(TableName.PLAYER_INFO, user.getDbServerID(), DbName.DB_PLAYER, imqTime, MapReduceTable.getMap("vipLevel"), MapReduceTable.getReduce("vipLevel")); if (map_result != null) { IEnumerable <BsonDocument> bson = map_result.GetResults(); foreach (BsonDocument d in bson) { try { BsonValue resValue = d["value"]; int count = resValue["count"].ToInt32(); int vip = Convert.ToInt32(d["_id"]); m_result.addVipLevel(vip, count); } catch (System.Exception ex) { } } } return(OpRes.opres_success); }
private OpRes query(ParamQuery param, IMongoQuery imq, GMUser user) { List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.STAT_PLAYER_GAME_BET_RESULT, user.getDbServerID(), DbName.DB_PUMP, imq, 0, 0, null, "genTime", false); if (dataList == null || dataList.Count == 0) { return(OpRes.op_res_not_found_data); } int i = 0; for (i = 0; i < dataList.Count; i++) { ResultItemPlayerGameBet tmp = new ResultItemPlayerGameBet(); m_result.Add(tmp); Dictionary <string, object> data = dataList[i]; tmp.m_time = Convert.ToDateTime(data["genTime"]).ToLocalTime(); tmp.m_round = Convert.ToInt32(data["round"]); tmp.m_playerId = Convert.ToInt32(data["playerId"]); tmp.m_gameId = Convert.ToInt32(data["gameId"]); long max = Convert.ToInt64(data["maxCarry"]); long min = Convert.ToInt64(data["minCarry"]); long sum = Convert.ToInt64(data["sumCarry"]); tmp.addData(ResultItemPlayerGameBet.CARRY, sum, max, min); max = Convert.ToInt64(data["maxOutlay"]); min = Convert.ToInt64(data["minOutlay"]); sum = Convert.ToInt64(data["sumOutlay"]); tmp.addData(ResultItemPlayerGameBet.OUTLAY, sum, max, min); max = Convert.ToInt64(data["maxWin"]); min = Convert.ToInt64(data["minWin"]); sum = Convert.ToInt64(data["sumWin"]); tmp.addData(ResultItemPlayerGameBet.WIN, sum, max, min); max = Convert.ToInt64(data["maxLose"]); min = Convert.ToInt64(data["minLose"]); sum = Convert.ToInt64(data["sumLose"]); tmp.addData(ResultItemPlayerGameBet.LOSE, sum, max, min); } return(OpRes.opres_success); }
public bool deleteNotice(int[] arr_index, GMUser account) { if (account == null) { return(false); } List <CSystemAnnounce> out_list = null; bool res = _deleteNotice(arr_index, ref out_list, account.getDbServerID()); if (res) { if (out_list != null) { // OpLogMgr.getInstance().addLog(LogType.DELETE_NOTICE, new ParamDeleteNotice(out_list), account); } } return(res); }
bool isSame(ParamIncomeExpenses p, GMUser user) { if (p.m_time != m_lastParam.m_time) { return(false); } if (user.getDbServerID() != m_lastParam.m_dbId) { return(false); } if (p.m_playerGainDb != m_lastParam.m_playerGainDb) { return(false); } return(true); }
public bool activateNotice(int index, GMUser account) { if (account == null) { return(false); } CSystemAnnounce pa = null; bool res = _activateNotice(index, ref pa, account.getDbServerID()); if (res) { if (pa != null) { // OpLogMgr.getInstance().addLog(LogType.ACTIVATE_NOTICE, new ParamActivateNotice(pa.mTitle, pa.mContent, pa.mDayAmount), account); } } return(res); }
// 删除统计数据 public OpRes delAllStatData(int index, GMUser user) { if (user == null) { return(OpRes.op_res_failed); } if (index < 0 || index >= m_dels.Count) { return(OpRes.op_res_failed); } FishDelInfo info = m_dels[index]; // 清除指定表中的所有数据 bool res = DBMgr.getInstance().clearTable(info.m_tableName, user.getDbServerID(), DbName.DB_PUMP); if (res) // 添加LOG { //OpLogMgr.getInstance().addLog(LogType.LOG_TYPE_DEL_STAT_DATA, new ParamDelStatData(info.m_data), user); return(OpRes.opres_success); } return(OpRes.op_res_failed); }
// 向机器人批量加钱 public bool addMoneyToBot(int gold, int gem, GMUser account) { if (gold < 0 || gem < 0 || account == null) { LOG.Info("给机器人加钱时出错,传入的值为负!"); return(false); } int serverid = account.getDbServerID(); List <Dictionary <string, object> > datalist = null; // DBMgr.getInstance().getDataListFromTable("EtPlayer", serverid, DbName.DB_FISH_LORD, "IsBot", true); if (datalist != null) { foreach (Dictionary <string, object> data in datalist) { int playerid = Convert.ToInt32(data["Id"]); _addPlayerMoney(playerid, gold, gem, serverid); } } account.setOpResult(OpRes.opres_success); OpLogMgr.getInstance().addLog(LogType.BATCH_ADD_MONEY, new ParamAddMoney(gold, gem), account); return(true); }
public override OpRes doQuery(object param, GMUser user) { m_result.Clear(); List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.SHCD_RESULT, user.getDbServerID(), DbName.DB_GAME, null, 0, 0, null, "insert_time", false); if (dataList == null) { return(OpRes.opres_success); } for (int i = 0; i < dataList.Count; i++) { GameResultShcd info = new GameResultShcd(); info.m_insertTime = Convert.ToDateTime(dataList[i]["insert_time"]).ToLocalTime().ToString(); info.m_result = Convert.ToInt32(dataList[i]["next_card_type"]); m_result.Add(info); } return(OpRes.opres_success); }
private OpRes query(GMUser user) { List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.DRAGON_ROOM, user.getDbServerID(), DbName.DB_GAME); if (dataList == null) { return(OpRes.opres_success); } for (int i = 0; i < dataList.Count; i++) { ResultDragonParam info = new ResultDragonParam(); m_result.Add(info); info.m_roomId = Convert.ToInt32(dataList[i]["room_id"]); if (dataList[i].ContainsKey("expect_earn_rate")) { info.m_expRate = Convert.ToDouble(dataList[i]["expect_earn_rate"]); } else { info.m_expRate = 0.05; } if (dataList[i].ContainsKey("room_income")) // 总收入 { info.m_totalIncome = Convert.ToInt64(dataList[i]["room_income"]); } if (dataList[i].ContainsKey("room_outcome")) // 总支出 { info.m_totalOutlay = Convert.ToInt64(dataList[i]["room_outcome"]); } if (dataList[i].ContainsKey("double_income")) // 翻倍收入 { info.m_doubleIncome = Convert.ToInt64(dataList[i]["double_income"]); } if (dataList[i].ContainsKey("double_outcome")) // 翻倍支出 { info.m_doubleOutcome = Convert.ToInt64(dataList[i]["double_outcome"]); } } return(OpRes.opres_success); }
private OpRes queryLevel(GMUser user) { List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.CALF_ROPING_PASS_LOG, user.getDbServerID(), DbName.DB_PUMP); if (dataList == null) { return(OpRes.opres_success); } for (int i = 0; i < dataList.Count; i++) { ResultCalfRopingLevelItem item = new ResultCalfRopingLevelItem(); m_result3.Add(item); Dictionary <string, object> data = dataList[i]; if (data.ContainsKey("passid")) { item.m_passId = Convert.ToInt32(data["passid"]); } if (data.ContainsKey("hitcount")) { item.m_hitCount = Convert.ToInt64(data["hitcount"]); } if (data.ContainsKey("allcount")) { item.allcount = Convert.ToInt64(data["allcount"]); } } return(OpRes.opres_success); }
private OpRes query(GMUser user, IMongoQuery imq) { List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.DRAGON_TABLE, user.getDbServerID(), DbName.DB_GAME, imq); if (dataList == null) { return(OpRes.opres_success); } long income = 0, outlay = 0; for (int i = 0; i < dataList.Count; i++) { income = outlay = 0; Dictionary <string, object> data = dataList[i]; if (data.ContainsKey("table_income")) { income = Convert.ToInt64(data["table_income"]); } if (data.ContainsKey("normal_outcome")) { outlay = Convert.ToInt64(data["normal_outcome"]); } m_result.addModeData(ResultDragonGameModeEarning.MODE_NORMAL, income, outlay); income = outlay = 0; if (data.ContainsKey("free_outcome")) { outlay = Convert.ToInt64(data["free_outcome"]); } m_result.addModeData(ResultDragonGameModeEarning.MODE_FREE_GAME, income, outlay); income = outlay = 0; if (data.ContainsKey("double_income")) { income = Convert.ToInt64(data["double_income"]); } if (data.ContainsKey("double_outcome")) { outlay = Convert.ToInt64(data["double_outcome"]); } m_result.addModeData(ResultDragonGameModeEarning.MODE_DOUBLE, income, outlay); } return(OpRes.opres_success); }
private OpRes queryIndependent(GMUser user) { List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.CALF_ROPING_ROOM, user.getDbServerID(), DbName.DB_GAME); if (dataList == null) { return(OpRes.opres_success); } for (int i = 0; i < dataList.Count; i++) { Dictionary <string, object> data = dataList[i]; if (data.ContainsKey("enter_count")) { m_result1.m_enterCount = Convert.ToInt64(data["enter_count"]); } if (data.ContainsKey("NorRewardNum")) { m_result1.m_norRewardNum = Convert.ToInt64(data["NorRewardNum"]); } if (data.ContainsKey("NorRewardGold")) { m_result1.m_norRewardGold = Convert.ToInt64(data["NorRewardGold"]); } if (data.ContainsKey("BigRewardNum")) { m_result1.m_bigRewardNum = Convert.ToInt64(data["BigRewardNum"]); } if (data.ContainsKey("BigRewardGold")) { m_result1.m_bigRewardGold = Convert.ToInt64(data["BigRewardGold"]); } if (data.ContainsKey("BuyLifeNum")) { m_result1.m_buyLifeNum = Convert.ToInt64(data["BuyLifeNum"]); } } return(OpRes.opres_success); }
private OpRes queryParam(GMUser user) { List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.CALF_ROPING_ROOM, user.getDbServerID(), DbName.DB_GAME); if (dataList == null) { return(OpRes.opres_success); } for (int i = 0; i < dataList.Count; i++) { ResultExpRateParam info = new ResultExpRateParam(); m_result.Add(info); if (dataList[i].ContainsKey("ExpectEarnRate")) { info.m_expRate = Convert.ToDouble(dataList[i]["ExpectEarnRate"]); } else { info.m_expRate = 0.05; } if (dataList[i].ContainsKey("lobby_income")) // 总收入 { info.m_totalIncome = Convert.ToInt64(dataList[i]["lobby_income"]); } if (dataList[i].ContainsKey("lobby_outcome")) // 总支出 { info.m_totalOutlay = Convert.ToInt64(dataList[i]["lobby_outcome"]); } } return(OpRes.opres_success); }
private OpRes query(GMUser user) { List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.SHCDCARDS_ROOM, user.getDbServerID(), DbName.DB_GAME); for (int i = 0; i < dataList.Count; i++) { for (int k = 1; k <= StrName.s_shcdArea.Length; k++) { // 总收入 string totalWinKey = string.Format("WinGold{0}", k); // 总支出 string totalLoseGoldKey = string.Format("LoseGold{0}", k); // 押注次数 string betCountKey = string.Format("BetCount{0}", k); long income = 0, outlay = 0, betCount = 0; if (dataList[i].ContainsKey(totalWinKey)) { income = Convert.ToInt64(dataList[i][totalWinKey]); } if (dataList[i].ContainsKey(totalLoseGoldKey)) { outlay = Convert.ToInt64(dataList[i][totalLoseGoldKey]); } if (dataList[i].ContainsKey(betCountKey)) { betCount = Convert.ToInt64(dataList[i][betCountKey]); } m_result.addBetCount(k, betCount, 0, income, outlay); } } return(OpRes.opres_success); }
private OpRes query(GMUser user) { List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.COWS_ROOM, user.getDbServerID(), DbName.DB_GAME); if (dataList == null) { return(OpRes.opres_success); } for (int i = 0; i < dataList.Count; i++) { ResultParamCows info = new ResultParamCows(); info.m_roomId = Convert.ToInt32(dataList[i]["room_id"]); if (dataList[i].ContainsKey("ExpectEarnRate")) { info.m_expRate = Convert.ToDouble(dataList[i]["ExpectEarnRate"]); } else { info.m_expRate = 0.05; } if (dataList[i].ContainsKey("room_income")) // 总收入 { info.m_totalIncome = Convert.ToInt64(dataList[i]["room_income"]); } if (dataList[i].ContainsKey("room_outcome")) // 总支出 { info.m_totalOutlay = Convert.ToInt64(dataList[i]["room_outcome"]); } if (dataList[i].ContainsKey("BankerAddGold")) // 上庄手续费 { info.m_serviceCharge = Convert.ToInt64(dataList[i]["BankerAddGold"]); } if (dataList[i].ContainsKey("BankerSubGold")) // 爆庄支出 { info.m_burstZhuang = Convert.ToInt64(dataList[i]["BankerSubGold"]); } if (dataList[i].ContainsKey("TotalRobotWinGold")) // 机器人收入 { info.m_robotIncome = Convert.ToInt64(dataList[i]["TotalRobotWinGold"]); } if (dataList[i].ContainsKey("TotalRobotLoseGold")) // 机器人支出 { info.m_robotOutlay = Convert.ToInt64(dataList[i]["TotalRobotLoseGold"]); } m_result.Add(info.m_roomId, info); } return(OpRes.opres_success); }
private OpRes query(GMUser user) { List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.SHCDCARDS_ROOM, user.getDbServerID(), DbName.DB_GAME); if (dataList == null) { return(OpRes.opres_success); } for (int i = 0; i < dataList.Count; i++) { ResultShcdParam info = new ResultShcdParam(); m_result.Add(info); info.m_roomId = Convert.ToInt32(dataList[i]["room_id"]); if (dataList[i].ContainsKey("ExpectEarnRate")) { info.m_expRate = Convert.ToDouble(dataList[i]["ExpectEarnRate"]); } else { info.m_expRate = 0.05; } if (dataList[i].ContainsKey("room_income")) // 总收入 { info.m_totalIncome = Convert.ToInt64(dataList[i]["room_income"]); } if (dataList[i].ContainsKey("room_outcome")) // 总支出 { info.m_totalOutlay = Convert.ToInt64(dataList[i]["room_outcome"]); } if (dataList[i].ContainsKey("EarnRateControl")) { info.m_level = Convert.ToInt32(dataList[i]["EarnRateControl"]); } else { info.m_level = 0; } if (dataList[i].ContainsKey("next_joker_count")) { info.m_jokerCount = Convert.ToInt32(dataList[i]["next_joker_count"]); } else { info.m_jokerCount = 0; } if (dataList[i].ContainsKey("beginCheatIndex") && dataList[i].ContainsKey("endCheatIndex")) { info.m_cheatSE = Convert.ToString(dataList[i]["beginCheatIndex"]) + "-" + Convert.ToString(dataList[i]["endCheatIndex"]); } else { info.m_cheatSE = ""; } } return(OpRes.opres_success); }