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++)
{
Dictionary <string, object> data = dataList[i];
GameResultShcd info = new GameResultShcd();
info.m_insertTime = Convert.ToDateTime(data["insert_time"]).ToLocalTime().ToString();
info.m_result = Convert.ToInt32(data["next_card_type"]);
if (data.ContainsKey("room_id"))
{
info.m_roomId = Convert.ToInt32(data["room_id"]);
}
m_result.Add(info);
}
return(OpRes.opres_success);
}
protected void genTable(Table table, GMUser user)
{
TableRow tr = new TableRow();
table.Rows.Add(tr);
int i = 0;
for (; i < s_head.Length; i++)
{
TableCell td = new TableCell();
tr.Cells.Add(td);
td.Text = s_head[i];
}
ParamGameResultControl param = new ParamGameResultControl();
param.m_gameId = GameId.shcd;
OpRes res = user.doQuery(param, QueryType.queryTypeGameResultControl);
List <GameResultShcd> qresult
= (List <GameResultShcd>)user.getQueryResult(param, QueryType.queryTypeGameResultControl);
for (i = 0; i < qresult.Count; i++)
{
GameResultShcd r = qresult[i];
m_content[0] = r.m_insertTime;
m_content[1] = StrName.s_shcdArea[r.m_result];
m_content[2] = StrName.s_shcdRoomName[r.m_roomId];
tr = new TableRow();
table.Rows.Add(tr);
for (int j = 0; j < s_head.Length; j++)
{
TableCell td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[j];
}
}
}
