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); }
// 填充百家乐数据 void fillBaccarat(ParamGameHistory param, GMUser user, List <Dictionary <string, object> > dataList) { for (int i = 0; i < dataList.Count; i++) { Dictionary <string, object> data = dataList[i]; ResultGameHistoryBaccaratIem tmp = new ResultGameHistoryBaccaratIem(); m_result.Add(tmp); tmp.m_time = Convert.ToDateTime(data["genTime"]).ToLocalTime().ToString(ConstDef.DATE_TIME24); tmp.m_gameId = (int)GameId.baccarat; tmp.m_totalBound = Convert.ToInt64(data["gameIndex"]); tmp.m_boundToday = Convert.ToInt64(data["dayIndex"]); string[] arr = Tool.split(Convert.ToString(data["resultStr"]), ',', StringSplitOptions.RemoveEmptyEntries); for (int k = 0; k < arr.Length; k++) { tmp.m_resultList.Add(Convert.ToInt32(arr[k])); } arr = Tool.split(Convert.ToString(data["playerCardStr"]), ',', StringSplitOptions.RemoveEmptyEntries); for (int k = 0; k < arr.Length; k++) { tmp.m_cardListXian.Add(Convert.ToInt32(arr[k])); } arr = Tool.split(Convert.ToString(data["bankerCardStr"]), ',', StringSplitOptions.RemoveEmptyEntries); for (int k = 0; k < arr.Length; k++) { tmp.m_cardListZhuang.Add(Convert.ToInt32(arr[k])); } } }
protected void onQueryRecord(object sender, EventArgs e) { m_view = ViewGameHistoryBase.create(Convert.ToInt32(m_whichGame.SelectedValue)); if (m_view == null) { return; } GMUser user = (GMUser)Session["user"]; ParamGameHistory param = new ParamGameHistory(); param.m_countEachPage = m_gen.rowEachPage; param.m_curPage = m_gen.curPage; param.m_gameId = Convert.ToInt32(m_whichGame.SelectedValue); param.m_time = m_time.Text; param.m_bound = m_bound.Text; m_page.InnerHtml = ""; m_foot.InnerHtml = ""; OpRes res = user.doQuery(param, QueryType.queryTypeGameHistory); m_view.genTable(m_result, res, user); param.m_gameId = m_whichGame.SelectedIndex; string page_html = "", foot_html = ""; m_gen.genPage(param, @"/appaspx/stat/gamehistory/GameHistory.aspx", ref page_html, ref foot_html, user); m_page.InnerHtml = page_html; m_foot.InnerHtml = foot_html; }
// 填充黑红梅方数据 void fillShcd(ParamGameHistory param, GMUser user, List <Dictionary <string, object> > dataList) { for (int i = 0; i < dataList.Count; i++) { Dictionary <string, object> data = dataList[i]; ResultGameHistoryShcdItem tmp = new ResultGameHistoryShcdItem(); m_result.Add(tmp); tmp.m_time = Convert.ToDateTime(data["genTime"]).ToLocalTime().ToString(ConstDef.DATE_TIME24); tmp.m_gameId = (int)GameId.shcd; tmp.m_totalBound = Convert.ToInt64(data["gameIdx"]); tmp.m_cardType = Convert.ToInt32(data["cardType"]); tmp.m_cardValue = Convert.ToInt32(data["cardValue"]); } }
// 填充骰宝数据 void fillDice(ParamGameHistory param, GMUser user, List <Dictionary <string, object> > dataList) { for (int i = 0; i < dataList.Count; i++) { Dictionary <string, object> data = dataList[i]; ResultGameHistoryDicetIem tmp = new ResultGameHistoryDicetIem(); m_result.Add(tmp); tmp.m_time = Convert.ToDateTime(data["genTime"]).ToLocalTime().ToString(ConstDef.DATE_TIME24); tmp.m_gameId = (int)GameId.dice; tmp.m_totalBound = Convert.ToInt64(data["gameIndex"]); tmp.m_dice1 = Convert.ToInt32(data["dice1"]); tmp.m_dice2 = Convert.ToInt32(data["dice2"]); tmp.m_dice3 = Convert.ToInt32(data["dice3"]); } }
public override OpRes doQuery(object param, GMUser user) { m_result.Clear(); m_cond.startQuery(); OpRes res = makeQuery(param, user, m_cond); if (res != OpRes.opres_success) { return(res); } IMongoQuery imq = m_cond.getImq(); ParamGameHistory p = (ParamGameHistory)param; return(query(p, imq, user)); }
public override void genPage(ParamQueryBase queryParam, string url, ref string page_link, ref string foot, GMUser user) { ParamGameHistory dparam = (ParamGameHistory)queryParam; PageBrowseGenerator p = new PageBrowseGenerator(); long total_page = 0; Dictionary <string, object> urlParam = new Dictionary <string, object>(); urlParam["time"] = dparam.m_time; urlParam["gameIndex"] = dparam.m_gameId; urlParam["bound"] = dparam.m_bound; page_link = p.genPageFoot(queryParam.m_curPage, m_rowEachPage, url, ref total_page, user, urlParam); if (total_page != 0) { foot = queryParam.m_curPage + "/" + total_page; } }
// 填充牛牛数据 void fillCows(ParamGameHistory param, GMUser user, List <Dictionary <string, object> > dataList) { for (int i = 0; i < dataList.Count; i++) { Dictionary <string, object> data = dataList[i]; ResultGameHistoryCowstIem tmp = new ResultGameHistoryCowstIem(); m_result.Add(tmp); tmp.m_time = Convert.ToDateTime(data["genTime"]).ToLocalTime().ToString(ConstDef.DATE_TIME24); tmp.m_gameId = (int)GameId.cows; if (data.ContainsKey("gameIndex")) { tmp.m_totalBound = Convert.ToInt64(data["gameIndex"]); } GameDetail.detailInfoForCows(tmp.m_info, data); } }
string getTableName(ParamGameHistory param, ref fillData fillFun) { string tableName = ""; switch (param.m_gameId) { case (int)GameId.crocodile: { fillFun = fillCrocodile; tableName = TableName.HISTORY_CROCODILE; } break; case (int)GameId.dice: { fillFun = fillDice; tableName = TableName.HISTORY_DICE; } break; case (int)GameId.cows: { fillFun = fillCows; tableName = TableName.HISTORY_COWS; } break; case (int)GameId.baccarat: { fillFun = fillBaccarat; tableName = TableName.HISTORY_BACCARAT; } break; case (int)GameId.shcd: { fillFun = fillShcd; tableName = TableName.HISTORY_SHCD; } break; } return(tableName); }
// 填充鳄鱼大亨数据 void fillCrocodile(ParamGameHistory param, GMUser user, List <Dictionary <string, object> > dataList) { for (int i = 0; i < dataList.Count; i++) { Dictionary <string, object> data = dataList[i]; ResultGameHistoryCrocodiletIem tmp = new ResultGameHistoryCrocodiletIem(); m_result.Add(tmp); tmp.m_time = Convert.ToDateTime(data["genTime"]).ToLocalTime().ToString(ConstDef.DATE_TIME24); tmp.m_gameId = (int)GameId.crocodile; tmp.m_totalBound = Convert.ToInt64(data["gameIndex"]); tmp.m_awardType = Convert.ToInt32(data["awardType"]); tmp.m_handSel = Convert.ToInt32(data["handselProb"]); string[] arr = Tool.split(Convert.ToString(data["resultStr"]), ',', StringSplitOptions.RemoveEmptyEntries); for (int k = 0; k < arr.Length; k++) { tmp.m_result.Add(Convert.ToInt32(arr[k])); } } }
public override OpRes makeQuery(object param, GMUser user, QueryCondition queryCond) { ParamGameHistory p = (ParamGameHistory)param; bool res = false; DateTime mint = DateTime.Now, maxt = DateTime.Now; res = Tool.splitTimeStr(p.m_time, ref mint, ref maxt); if (!res) { return(OpRes.op_res_time_format_error); } IMongoQuery imq1 = Query.LT("genTime", BsonValue.Create(maxt)); IMongoQuery imq2 = Query.GTE("genTime", BsonValue.Create(mint)); queryCond.addImq(Query.And(imq1, imq2)); switch (p.m_gameId) { case (int)GameId.baccarat: // 百家乐 { if (!string.IsNullOrEmpty(p.m_bound)) { int x = 0; if (!int.TryParse(p.m_bound, out x)) { return(OpRes.op_res_pwd_not_valid); } int minV = (x - 1) * 66; int maxV = x * 66 + 1; IMongoQuery imqx1 = Query.LT("dayIndex", BsonValue.Create(maxV)); IMongoQuery imqx2 = Query.GT("dayIndex", BsonValue.Create(minV)); queryCond.addImq(Query.And(imqx1, imqx2)); } } break; } return(OpRes.opres_success); }