private OpRes query(GMUser user)
{
List <Dictionary <string, object> > dataList = DBMgr.getInstance().executeQuery(TableName.COWS_CARDS,
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++)
{
ResultCowsCard info = new ResultCowsCard();
info.m_key = Convert.ToString(dataList[i]["key"]);
info.m_time = Convert.ToDateTime(dataList[i]["insert_time"]).ToLocalTime().ToString();
info.m_bankerType = Convert.ToInt32(dataList[i]["banker_cards"]);
info.m_other1Type = Convert.ToInt32(dataList[i]["other_cards1"]);
info.m_other2Type = Convert.ToInt32(dataList[i]["other_cards2"]);
info.m_other3Type = Convert.ToInt32(dataList[i]["other_cards3"]);
info.m_other4Type = Convert.ToInt32(dataList[i]["other_cards4"]);
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];
}
OpRes res = user.doQuery(null, QueryType.queryTypeCowsCardsType);
List <ResultCowsCard> qresult
= (List <ResultCowsCard>)user.getQueryResult(QueryType.queryTypeCowsCardsType);
for (i = 0; i < qresult.Count; i++)
{
ResultCowsCard r = qresult[i];
m_content[0] = r.m_time;
m_content[1] = ItemHelp.getCowsCardTypeName(r.m_bankerType);
m_content[2] = ItemHelp.getCowsCardTypeName(r.m_other1Type);
m_content[3] = ItemHelp.getCowsCardTypeName(r.m_other2Type);
m_content[4] = ItemHelp.getCowsCardTypeName(r.m_other3Type);
m_content[5] = ItemHelp.getCowsCardTypeName(r.m_other4Type);
m_content[6] = Tool.getCheckBoxHtml("sel", r.m_key, false);
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];
}
}
}
