// 开始查询
protected void onQueryAccount(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamQuery param = new ParamQuery();
param.m_way = (QueryWay)m_queryWay.SelectedIndex;
param.m_param = m_param.Text;
param.m_curPage = m_gen.curPage;
param.m_countEachPage = m_gen.rowEachPage;
param.m_time = m_regTime.Text;
if (param.m_way == QueryWay.by_way0)
{
//BtnBlockAcc.Visible = true;
}
else
{
//BtnBlockAcc.Visible = false;
}
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeAccount, user);
genTable(m_result, res, param, user, mgr);
}
// 查询
public OpRes doQuery(object param, QueryType queryType)
{
QueryMgr mgr = getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, queryType, this);
return(res);
}
protected void onStat(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
ParamServerEarnings param = new ParamServerEarnings();
param.m_gameId = m_game.SelectedIndex;
param.m_time = m_time.Text;
OpRes res = mgr.doQuery(param, QueryType.queryTypeServerEarnings, user);
m_result.Rows.Clear();
if (param.m_gameId == 0)
{
// genTable(m_result, res, user, mgr);
TableStatServerEarningsTotal view = new TableStatServerEarningsTotal();
view.genTable(user, m_result, res, null);
}
else
{
/* if (param.m_gameId == (int)GameId.cows)
* {
* genDetailGameTableCows(m_result, res, user);
* }
* else*/
{
genDetailGameTable(m_result, res, user, mgr, param.m_gameId);
}
}
}
protected void onStat(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
ParamServerEarnings param = new ParamServerEarnings();
param.m_gameId = Convert.ToInt32(m_game.SelectedValue);
param.m_time = __time__.Text;
OpRes res = mgr.doQuery(param, QueryType.queryTypeServerEarnings, user);
m_result.Rows.Clear();
if (param.m_gameId == 0)
{
genTable(m_result, res, user, mgr);
}
else
{
/* if (param.m_gameId == (int)GameId.cows)
* {
* genDetailGameTableCows(m_result, res, user);
* }
* else*/
{
genDetailGameTable(m_result, res, user, mgr, param.m_gameId);
}
}
}
protected void onStat(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(null, QueryType.queryTypeIndependentDice, user);
genTable(m_result, res, user, mgr);
}
protected void onStat(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(m_time.Text, QueryType.queryTypeGameRecharge, user);
genTable(m_result, res, user, mgr);
}
protected void onSearch(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(m_time.Text, QueryType.queryTypeCoinGrowthRank, user);
genTable(m_result, res, user, mgr);
}
// 开始查询充值记录
protected void onQueryRecharge(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamQueryRecharge param = genParamQueryRecharge();
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeRecharge, user);
genTable(m_result, res, param, user, mgr);
}
protected void onQuery(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamQuery param = createParam();
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeMoneyAtMost, user);
genTable(m_result, param, user, mgr);
}
protected void Page_Load(object sender, EventArgs e)
{
RightMgr.getInstance().opCheck("operation", Session, Response);
GMUser user = (GMUser)Session["user"];
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(null, QueryType.queryTypeOnlinePlayerCount, user);
int c = (int)mgr.getQueryResult(QueryType.queryTypeOnlinePlayerCount);
m_count.Text = c.ToString();
}
protected void onQuery(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamMoneyQuery param = getParamMoneyQuery();
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeMoney, user);
param.m_property = m_property.SelectedIndex;
genTable(m_result, res, param, user, mgr);
}
protected void onStat(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
ParamServerEarnings param = new ParamServerEarnings();
param.m_gameId = m_game.SelectedIndex + 1;
param.m_time = m_time.Text;
OpRes res = mgr.doQuery(param, QueryType.queryTypeServerEarnings, user);
genTable(m_result, res, user, mgr);
}
protected void onQuery(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamLottery p = new ParamLottery();
p.m_boxId = m_game.SelectedValue;
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(p, QueryType.queryTypeOldEaringsRate, user);
genExpRateTable(m_result, mgr, p);
}
protected void genTable(Table table)
{
GMUser user = (GMUser)Session["user"];
table.GridLines = GridLines.Both;
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];
}
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(null, QueryType.queryTypeFishStat, user);
List <ResultFish> qresult
= (List <ResultFish>)mgr.getQueryResult(QueryType.queryTypeFishStat);
foreach (var data in qresult)
{
m_content[0] = data.m_fishId.ToString();
var fishInfo = FishCFG.getInstance().getValue(data.m_fishId);
if (fishInfo != null)
{
m_content[1] = fishInfo.m_fishName;
}
else
{
m_content[1] = "";
}
m_content[2] = data.m_hitCount.ToString();
m_content[3] = data.m_dieCount.ToString();
m_content[4] = data.getHit_Die();
m_content[5] = data.m_outlay.ToString();
m_content[6] = data.m_income.ToString();
m_content[7] = data.getOutlay_Income();
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];
}
}
}
protected void onQuery(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamLottery p = new ParamLottery();
ListItem item = m_game.Items[m_game.SelectedIndex];
p.m_way = (QueryWay)Convert.ToInt32(item.Value);
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(p, QueryType.queryTypeOldEaringsRate, user);
genExpRateTable(m_result, mgr, p);
}
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];
}
}
}
protected void onStat(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamTotalConsume param = new ParamTotalConsume();
param.m_changeType = m_changeType.SelectedIndex;
param.m_currencyType = Convert.ToInt32(m_currencyType.SelectedValue);
param.m_time = m_time.Text;
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeTotalConsume, user);
genTable(m_result, res, user, mgr);
}
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);
mgr.doQuery(null, QueryType.queryTypeCurNotice, user);
List <ResultNoticeInfo> qresult = (List <ResultNoticeInfo>)mgr.getQueryResult(QueryType.queryTypeCurNotice);
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_tableContent[0] = qresult[i].m_id;
m_tableContent[1] = qresult[i].m_genTime;
m_tableContent[2] = qresult[i].m_deadTime;
m_tableContent[3] = qresult[i].m_title;
m_tableContent[4] = qresult[i].m_content;
m_tableContent[5] = qresult[i].m_comment;
m_tableContent[6] = qresult[i].m_order.ToString();
m_tableContent[7] = Tool.getCheckBoxHtml("sel", m_tableContent[0], false);
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = m_tableContent[j];
}
}
}
protected void onQuery(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamQuery param = new ParamQuery();
param.m_param = m_param.Text;
param.m_time = m_time.Text;
param.m_curPage = m_gen.curPage;
param.m_countEachPage = m_gen.rowEachPage;
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeLoginHistory, user);
genTable(m_result, res, param, user, mgr);
}
protected void onQuery(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamQueryGift param = new ParamQueryGift();
param.m_param = m_time.Text;
param.m_state = m_room.SelectedIndex;
param.m_curPage = m_gen.curPage;
param.m_countEachPage = m_gen.rowEachPage;
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeFishlordStage, user);
genTable(m_result, res, param, user, mgr);
}
protected void onStat(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
if (m_statWay.SelectedIndex == 0)
{
StatMgr mgr = user.getSys <StatMgr>(SysType.sysTypeStat);
mgr.doStat(null, StatType.statTypeVipLevel, user);
genVipLevelTable(m_result, user, mgr);
}
else
{
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
mgr.doQuery(m_statWay.SelectedIndex, QueryType.queryTypeLobby, user);
genGeneralTable(m_result, user, mgr);
}
}
protected void onViewHead(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(m_playerId.Text, QueryType.queryTypePlayerHead, user);
if (res != OpRes.opres_success)
{
m_res.InnerHtml = OpResMgr.getInstance().getResultString(res);
}
else
{
m_res.InnerHtml = "";
}
string url = (string)mgr.getQueryResult(QueryType.queryTypePlayerHead);
m_headImg.ImageUrl = url;
}
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];
}
}
}
public void startQuery()
{
GMUser user = (GMUser)Session["user"];
if (m_channelList.Count == 0)
{
return;
}
ParamSearch param = new ParamSearch();
param.m_minT = m_minT;
param.m_maxT = m_maxT;
param.m_retFields = m_dbFields;
param.m_countEachPage = 0;
param.m_curPage = 1;
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, m_queryType, user);
genTable(m_resultData, OpRes.opres_success, user, mgr);
}
protected void onQuery(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamQuery param = new ParamQuery();
param.m_param = m_giftCode.Text;
param.m_time = m_time.Text;
param.m_curPage = m_gen.curPage;
param.m_countEachPage = m_gen.rowEachPage;
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeGiftCode, user);
if (res == OpRes.opres_success)
{
genTable(m_result, param, user, mgr);
}
else
{
m_res.InnerHtml = OpResMgr.getInstance().getResultString(res);
}
}
private void genTable(int curpage, GMUser user)
{
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];
}
bool css = true;
ParamQuery param = new ParamQuery();
param.m_curPage = curpage;
param.m_countEachPage = ROW_EACH_PAGE;
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeOpLog, user);
//List<Dictionary<string, object>> result = OpLogMgr.getInstance().getAllOpLog((curpage - 1) * ROW_EACH_PAGE, ROW_EACH_PAGE);
List <Dictionary <string, object> > result =
(List <Dictionary <string, object> >)mgr.getQueryResult(QueryType.queryTypeOpLog);
if (result != null)
{
foreach (Dictionary <string, object> data in result)
{
fillTable(data, css);
css = !css;
}
}
}
protected void onSearch(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamQueryGift param = new ParamQueryGift();
param.m_curPage = m_gen.curPage;
param.m_countEachPage = m_gen.rowEachPage;
param.m_state = m_filter.SelectedIndex;
param.m_param = m_param.Text;
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(param, QueryType.queryTypeExchange, user);
genGiftTable(GiftTable, res, param, user, mgr);
if (param.m_state == (int)ExState.wait)
{
m_btnActive.Visible = true;
}
else
{
m_btnActive.Visible = false;
}
}
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 = 100;
param.m_way = QueryWay.by_way1; // 未过期
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 = "";
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] = qresult[i].getGiftList();
m_content[2] = qresult[i].m_deadTime.ToString();
m_content[4] = Tool.getTextBoxHtml("CodeNum" + i, "0");
m_clientInfo.Value += "," + m_content[0];
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
if (j == 3)
{
td.Controls.Add(createPlatList("Plat" + i));
}
else
{
td.Text = m_content[j];
}
tr.Cells.Add(td);
}
}
}
// 期望盈利率表格
protected void genExpRateTable(Table table)
{
GMUser user = (GMUser)Session["user"];
table.GridLines = GridLines.Both;
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];
}
// long totalIncome = 0;
// long totalOutlay = 0;
// long totalCharge = 0;
QueryMgr mgr = user.getSys <QueryMgr>(SysType.sysTypeQuery);
OpRes res = mgr.doQuery(null, QueryType.queryTypeBaccaratEarnings, user);
Dictionary <int, ResultFishlordExpRate> qresult
= (Dictionary <int, ResultFishlordExpRate>)mgr.getQueryResult(QueryType.queryTypeBaccaratEarnings);
for (i = 1; i <= 1 /*StrName.s_roomName.Length*/; i++)
{
m_content[0] = StrName.s_roomName[i - 1];
if (qresult.ContainsKey(i))
{
ResultFishlordExpRate r = qresult[i];
m_content[1] = r.m_playerCharge.ToString();
m_content[2] = r.m_totalIncome.ToString();
m_content[3] = r.m_totalOutlay.ToString();
m_content[4] = r.getDelta().ToString();
m_content[5] = r.getFactExpRate();
m_content[6] = r.m_robotIncome.ToString();
m_content[7] = r.m_robotOutlay.ToString();
m_content[8] = (r.m_robotIncome - r.m_robotOutlay).ToString();
m_content[9] = ItemHelp.getFactExpRate(r.m_robotIncome, r.m_robotOutlay);
// totalIncome += r.m_totalIncome;
// totalOutlay += r.m_totalOutlay;
// totalCharge += r.m_playerCharge;
}
else
{
for (int idx = 1; i < 10; idx++)
{
m_content[idx] = "0";
}
}
m_content[10] = Tool.getCheckBoxHtml("roomList", i.ToString(), 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];
if (j == 3)
{
setColor(td, m_content[j]);
}
}
}
// addStatFoot(table, totalIncome, totalOutlay, totalCharge);
}