private void genTable(Table table, OpRes res, ParamQuery param, GMUser user, QueryMgr mgr)
{
m_page.InnerHtml = "";
m_foot.InnerHtml = "";
table.GridLines = GridLines.Both;
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
if (res != OpRes.opres_success)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = OpResMgr.getInstance().getResultString(res);
return;
}
List <LoginItem> qresult = (List <LoginItem>)mgr.getQueryResult(QueryType.queryTypeLoginHistory);
int i = 0, j = 0;
for (i = 0; i < s_head.Length; i++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = s_head[i];
}
for (i = 0; i < qresult.Count; i++)
{
tr = new TableRow();
if ((i & 1) == 0)
{
tr.CssClass = "alt";
}
table.Rows.Add(tr);
m_content[0] = qresult[i].m_time;
m_content[1] = qresult[i].m_account;
m_content[2] = qresult[i].m_ip;
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[j];
}
}
string page_html = "", foot_html = "";
m_gen.genPage(param, @"/appaspx/operation/OperationLoginQuery.aspx", ref page_html, ref foot_html, user);
m_page.InnerHtml = page_html;
m_foot.InnerHtml = foot_html;
}
private void genTable(Table table, ParamQuery param, GMUser user, QueryMgr mgr)
{
m_page.InnerHtml = "";
m_foot.InnerHtml = "";
m_res.InnerHtml = "";
table.GridLines = GridLines.Both;
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
List <GiftCodeItem> qresult = (List <GiftCodeItem>)mgr.getQueryResult(QueryType.queryTypeGiftCode);
int i = 0, j = 0;
// 表头
for (i = 0; i < s_head.Length; i++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = s_head[i];
}
for (i = 0; i < qresult.Count; i++)
{
tr = new TableRow();
if ((i & 1) == 0)
{
tr.CssClass = "alt";
}
table.Rows.Add(tr);
m_content[0] = qresult[i].m_genTime; // 生成时间
m_content[1] = qresult[i].m_giftCode; // 礼包码
m_content[2] = qresult[i].m_plat; // 目标平台
m_content[3] = qresult[i].m_giftId; // 对应礼包ID
m_content[4] = qresult[i].m_playerServerId.ToString(); // 玩家所在服务器ID
m_content[5] = qresult[i].playerPlat; // 玩家平台
m_content[6] = qresult[i].m_playerId.ToString(); // 玩家ID
m_content[7] = qresult[i].m_playerAcc; // 玩家账号
m_content[8] = qresult[i].m_playerId > 0 ? qresult[i].m_useTime : ""; // 使用时间
m_content[9] = qresult[i].m_playerId > 0 ? "已使用" : "未使用"; // 是否使用
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[j];
}
}
string page_html = "", foot_html = "";
m_gen.genPage(param, @"/appaspx/operation/OperationGiftCodeQuery.aspx", ref page_html, ref foot_html, user);
m_page.InnerHtml = page_html;
m_foot.InnerHtml = foot_html;
}
private void genTable(Table table, GMUser user)
{
table.GridLines = GridLines.Both;
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(null, QueryType.queryTypeGmAccount, user);
if (res != OpRes.opres_success)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = OpResMgr.getInstance().getResultString(res);
return;
}
int i = 0, j = 0;
// 表头
for (i = 0; i < s_head.Length; i++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = s_head[i];
}
List <GMAccountItem> qresult = (List <GMAccountItem>)mgr.getQueryResult(QueryType.queryTypeGmAccount);
for (i = 0; i < qresult.Count; i++)
{
if (qresult[i].m_type == "admin")
{
continue;
}
tr = new TableRow();
table.Rows.Add(tr);
m_content[0] = qresult[i].m_user;
m_content[1] = getText(m_content[0], qresult[i].m_type);
m_content[2] = Tool.getCheckBoxHtml("flag", m_content[0], false);
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[j];
}
}
}
private void genTable(Table table, ParamQuery param, GMUser user, QueryMgr mgr)
{
table.GridLines = GridLines.Both;
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
List <ResultMoneyMost> qresult = (List <ResultMoneyMost>)mgr.getQueryResult(QueryType.queryTypeMoneyAtMost);
int i = 0, j = 0;
string[] head = null;
if (param.m_way == QueryWay.by_way0)
{
head = s_head;
}
else
{
head = s_head1;
}
// 表头
for (i = 0; i < head.Length; i++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = head[i];
}
for (i = 0; i < qresult.Count; i++)
{
tr = new TableRow();
if ((i & 1) == 0)
{
tr.CssClass = "alt";
}
table.Rows.Add(tr);
m_content[0] = qresult[i].m_playerId.ToString();
m_content[1] = qresult[i].m_nickName;
m_content[2] = qresult[i].m_val.ToString();
m_content[3] = qresult[i].m_safeBox.ToString();
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[j];
}
}
}
private void genTable(Table table, OpRes res, GMUser user, QueryMgr mgr)
{
table.GridLines = GridLines.Both;
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
if (res != OpRes.opres_success)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = OpResMgr.getInstance().getResultString(res);
return;
}
List <EarningItem> qresult = (List <EarningItem>)mgr.getQueryResult(QueryType.queryTypeServerEarnings);
int i = 0, j = 0;
// 表头
for (i = 0; i < s_head.Length; i++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = s_head[i];
}
for (i = 0; i < qresult.Count; i++)
{
tr = new TableRow();
if ((i & 1) == 0)
{
tr.CssClass = "alt";
}
m_result.Rows.Add(tr);
m_content[0] = qresult[i].m_time;
m_content[1] = qresult[i].m_totalIncome.ToString();
m_content[2] = qresult[i].m_totalOutlay.ToString();
m_content[3] = qresult[i].getFactExpRate();
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[j];
}
}
}
private void genTable(Table table, OpRes res, GMUser user, QueryMgr mgr)
{
table.GridLines = GridLines.Both;
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
if (res != OpRes.opres_success)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = OpResMgr.getInstance().getResultString(res);
return;
}
int i = 0, j = 0;
// 表头
for (i = 0; i < s_head.Length; i++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = s_head[i];
}
ResultFishLord qresult = (ResultFishLord)mgr.getQueryResult(QueryType.queryTypeIndependentFishlord);
for (i = 1; i < qresult.getRoomCount(); i++)
{
tr = new TableRow();
if ((i & 1) != 0)
{
tr.CssClass = "alt";
}
m_result.Rows.Add(tr);
m_content[0] = "房间" + i.ToString();
m_content[1] = qresult.getEnterRoomCount(i);
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[j];
}
}
}
private void genTable(GMUser user, ParamQueryOpLog param)
{
LogTable.GridLines = GridLines.Both;
// 添加标题行
TableRow tr = new TableRow();
LogTable.Rows.Add(tr);
int col = s_head.Length;
int i = 0;
for (; i < col; i++)
{
TableCell td = new TableCell();
tr.Cells.Add(td);
td.Text = s_head[i];
}
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeOpLog, user);
List <Dictionary <string, object> > result =
(List <Dictionary <string, object> >)mgr.getQueryResult(QueryType.queryTypeOpLog);
if (result != null)
{
bool css = true;
foreach (Dictionary <string, object> data in result)
{
fillTable(data, css);
css = !css;
}
}
m_page.InnerHtml = "";
m_foot.InnerHtml = "";
string page_html = "", foot_html = "";
param.m_logType = opType.SelectedIndex;
m_gen.genPage(param, @"/appaspx/LogViewer.aspx", ref page_html, ref foot_html, user);
m_page.InnerHtml = page_html;
m_foot.InnerHtml = foot_html;
}
private void genTable(Table table, GMUser user)
{
table.GridLines = GridLines.Both;
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
int i = 0, j = 0;
// 表头
for (i = 0; i < s_head.Length; i++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = s_head[i];
}
QueryMgr qmgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
qmgr.doQuery(null, QueryType.queryTypeServiceInfo, user);
List <ServiceInfoItem> sInfo = (List <ServiceInfoItem>)qmgr.getQueryResult(QueryType.queryTypeServiceInfo);
for (i = 0; i < sInfo.Count; i++)
{
tr = new TableRow();
table.Rows.Add(tr);
m_content[0] = sInfo[i].m_platChaName;
m_content[1] = sInfo[i].m_platEngName;
m_content[2] = sInfo[i].m_info;
m_content[3] = Tool.getCheckBoxHtml("sel", m_content[1], false);
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[j];
}
}
}
private void genTable(Table table, OpRes res, GMUser user, QueryMgr mgr)
{
table.GridLines = GridLines.Both;
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
ResultGameRecharge qresult = (ResultGameRecharge)mgr.getQueryResult(QueryType.queryTypeGameRecharge);
if (qresult.m_fields.Count == 0)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = OpResMgr.getInstance().getResultString(res);
return;
}
int i = 0, j = 0;
s_head = new string[2 + qresult.m_fields.Count];
m_content = new string[2 + qresult.m_fields.Count];
s_head[0] = "日期";
foreach (var r in qresult.m_fields)
{
s_head[++i] = r;
}
s_head[++i] = "总计";
// 表头
for (i = 0; i < s_head.Length; i++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = s_head[i];
}
for (i = 0; i < qresult.m_result.Count; i++)
{
tr = new TableRow();
if ((i & 1) == 0)
{
tr.CssClass = "alt";
}
table.Rows.Add(tr);
m_content[0] = qresult.m_result[i].m_time.ToLongDateString();
j = 1;
foreach (var game in qresult.m_fields)
{
m_content[j] = qresult.m_result[i].getValue(game).ToString();
j++;
}
m_content[j] = qresult.m_result[i].m_totalRecharge.ToString();
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[j];
}
}
}
private void genTable(Table table, OpRes res, ParamQuery param, GMUser user, QueryMgr mgr)
{
m_page.InnerHtml = "";
m_foot.InnerHtml = "";
m_res.InnerHtml = "";
table.GridLines = GridLines.Both;
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
if (res != OpRes.opres_success)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = OpResMgr.getInstance().getResultString(res);
return;
}
List <MoneyItem> qresult = (List <MoneyItem>)mgr.getQueryResult(QueryType.queryTypeMoney);
int i = 0, j = 0;
// 表头
for (i = 0; i < s_head.Length; i++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = s_head[i];
}
for (i = 0; i < qresult.Count; i++)
{
tr = new TableRow();
// if ((i & 1) == 0)
// {
// tr.CssClass = "alt";
// }
table.Rows.Add(tr);
m_content[0] = qresult[i].m_genTime;
m_content[1] = qresult[i].m_playerId.ToString();
m_content[2] = qresult[i].m_acc;
m_content[3] = qresult[i].m_nickName;
m_content[4] = ItemHelp.toStrByComma(ItemHelp.showMoneyValue(qresult[i].m_startValue));
m_content[5] = ItemHelp.toStrByComma(ItemHelp.showMoneyValue(qresult[i].m_endValue));
m_content[6] = ItemHelp.toStrByComma(ItemHelp.showMoneyValue(qresult[i].m_deltaValue));
m_content[7] = ItemHelp.toStrByComma(ItemHelp.showMoneyValue(qresult[i].m_outlay));
m_content[8] = ItemHelp.toStrByComma(ItemHelp.showMoneyValue(qresult[i].m_income));
m_content[9] = ItemHelp.toStrByComma(ItemHelp.showMoneyValue(qresult[i].m_income - qresult[i].m_outlay));
m_content[10] = ItemHelp.toStrByComma(ItemHelp.showMoneyValue(qresult[i].m_playerWinBet));
m_content[11] = qresult[i].getGameName();
m_content[12] = qresult[i].getExParam(i);
m_content[13] = qresult[i].m_id;
if (qresult[i].m_actionType > 0)
{
m_content[14] = qresult[i].getActionName();
}
else
{
m_content[14] = "";
}
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[j];
}
}
string page_html = "", foot_html = "";
m_gen.genPage(param, @"/appaspx/operation/OperationMoneyQuery.aspx", ref page_html, ref foot_html, user);
m_page.InnerHtml = page_html;
m_foot.InnerHtml = foot_html;
}
private void genTable(Table table, GMUser user)
{
table.GridLines = GridLines.Both;
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
ParamQuery param = new ParamQuery();
param.m_curPage = 1;
param.m_countEachPage = 1000;
param.m_way = (QueryWay)m_queryWay.SelectedIndex;
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeGift, user);
List <GiftItem> qresult = (List <GiftItem>)mgr.getQueryResult(QueryType.queryTypeGift);
int i = 0, j = 0;
// 表头
for (i = 0; i < s_head.Length; i++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = s_head[i];
}
m_clientInfo.Value = "";
m_modifyInfo.Value = "";
if (qresult.Count > 0)
{
m_clientInfo.Value += qresult.Count;
}
for (i = 0; i < qresult.Count; i++)
{
tr = new TableRow();
if ((i & 1) == 0)
{
tr.CssClass = "alt";
}
table.Rows.Add(tr);
m_content[0] = qresult[i].m_giftId.ToString();
//m_content[1] = Tool.getTextBoxHtml("Content" + i, qresult[i].getSrcGiftList());
m_content[2] = Tool.getTextBoxHtml("DeadTime" + i, qresult[i].m_deadTime.ToString("yyyy/MM/dd"));
m_clientInfo.Value += "," + m_content[0];
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
if (j == 1)
{
td.Width = Unit.Pixel(500);
td.Controls.Add(createTxt("Content" + i, qresult[i].getSrcGiftList(), td.Width));
}
else
{
td.Text = m_content[j];
}
tr.Cells.Add(td);
}
}
}
private void genDetailGameTable(Table table, OpRes res, GMUser user, QueryMgr mgr, int gameId)
{
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
if (res != OpRes.opres_success)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = OpResMgr.getInstance().getResultString(res);
return;
}
List <EarningItem> qresult = (List <EarningItem>)mgr.getQueryResult(QueryType.queryTypeServerEarnings);
int i = 0, j = 0;
// 表头
for (i = 0; i < getHead1Length(gameId); i++)
{
td = new TableCell();
tr.Cells.Add(td);
if (i == 17 || i == 18)
{
td.Text = string.Format(s_head1[i], StrName.s_gameName1[gameId]);
}
else
{
td.Text = s_head1[i];
}
}
EarningItem statItem = new EarningItem();
for (i = 0; i < qresult.Count; i++)
{
tr = new TableRow();
tr.Cells.Clear();
if ((i & 1) == 0)
{
tr.CssClass = "alt";
}
m_result.Rows.Add(tr);
m_content[0] = qresult[i].m_time;
m_content[1] = ItemHelp.showMoneyValue(qresult[i].getRoomIncome(0)).ToString();
m_content[2] = ItemHelp.showMoneyValue(qresult[i].getRoomOutlay(0)).ToString();
m_content[3] = ItemHelp.showMoneyValue(qresult[i].getDelta(0)).ToString();
m_content[4] = qresult[i].getFactExpRate(0);
statItem.addRoomIncome(0, qresult[i].getRoomIncome(0));
statItem.addRoomOutlay(0, qresult[i].getRoomOutlay(0));
/* m_content[5] = ItemHelp.showMoneyValue(qresult[i].getRoomIncome(1)).ToString();
* m_content[6] = ItemHelp.showMoneyValue(qresult[i].getRoomOutlay(1)).ToString();
* m_content[7] = ItemHelp.showMoneyValue(qresult[i].getDelta(1)).ToString();
* m_content[8] = qresult[i].getFactExpRate(1);
* statItem.addRoomIncome(1, qresult[i].getRoomIncome(1));
* statItem.addRoomOutlay(1, qresult[i].getRoomOutlay(1));
*
* m_content[9] = ItemHelp.showMoneyValue(qresult[i].getRoomIncome(2)).ToString();
* m_content[10] = ItemHelp.showMoneyValue(qresult[i].getRoomOutlay(2)).ToString();
* m_content[11] = ItemHelp.showMoneyValue(qresult[i].getDelta(2)).ToString();
* m_content[12] = qresult[i].getFactExpRate(2);
* statItem.addRoomIncome(2, qresult[i].getRoomIncome(2));
* statItem.addRoomOutlay(2, qresult[i].getRoomOutlay(2));
*
* m_content[13] = ItemHelp.showMoneyValue(qresult[i].getRoomIncome(3)).ToString();
* m_content[14] = ItemHelp.showMoneyValue(qresult[i].getRoomOutlay(3)).ToString();
* m_content[15] = ItemHelp.showMoneyValue(qresult[i].getDelta(3)).ToString();
* m_content[16] = qresult[i].getFactExpRate(3);
* statItem.addRoomIncome(3, qresult[i].getRoomIncome(3));
* statItem.addRoomOutlay(3, qresult[i].getRoomOutlay(3));
*
* m_content[17] = ItemHelp.showMoneyValue(qresult[i].getRoomIncome(4)).ToString();
* m_content[18] = ItemHelp.showMoneyValue(qresult[i].getRoomOutlay(4)).ToString();
* m_content[19] = ItemHelp.showMoneyValue(qresult[i].getDelta(4)).ToString();
* m_content[20] = qresult[i].getFactExpRate(4);
* statItem.addRoomIncome(4, qresult[i].getRoomIncome(4));
* statItem.addRoomOutlay(4, qresult[i].getRoomOutlay(4));
*
* if (gameId == (int)GameId.fishlord)
* {
* m_content[21] = ItemHelp.showMoneyValue(qresult[i].getRoomOutlay(5)).ToString();
* m_content[22] = ItemHelp.showMoneyValue(qresult[i].getRoomOutlay(6)).ToString();
* statItem.addRoomOutlay(5, qresult[i].getRoomOutlay(5));
* statItem.addRoomOutlay(6, qresult[i].getRoomOutlay(6));
* }*/
for (j = 0; j < getHead1Length(gameId); j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Style.Clear();
td.Text = m_content[j];
}
/*for (int k = 3; k < 20; k += 4)
* {
* setRedColor(tr.Cells[k]);
* setRedColor(tr.Cells[k + 1]);
* }*/
}
addDetailStatFoot(table, statItem, gameId);
}