protected void genTable(Table table, GMUser user) { ParamTotalConsume param = new ParamTotalConsume(); param.m_time = m_time.Text; param.m_currencyType = moneyType.SelectedIndex + 1; OpRes res = user.doQuery(param, QueryType.queryTypeFishConsume); if (res != OpRes.opres_success) { return; } ResultTotalConsume qresult = (ResultTotalConsume)user.getQueryResult(QueryType.queryTypeFishConsume); var fields = from f in qresult.m_fields orderby f ascending select f; int i = 0, k = 0; TableCell td = new TableCell(); TableRow tr = new TableRow(); tr.Cells.Add(td); table.Rows.Add(tr); // 生成行标题 foreach (var reason in fields) { tr = new TableRow(); table.Rows.Add(tr); td = new TableCell(); td.Text = qresult.getFishReason(reason); tr.Cells.Add(td); } for (i = 0; i < qresult.getResultCount(); i++) { TotalConsumeItem item = qresult.m_result[i]; td = new TableCell(); td.Text = item.m_time.ToShortDateString(); k = 0; tr = table.Rows[k]; tr.Cells.Add(td); // 生成这个结果 foreach (var reason in fields) { k++; tr = table.Rows[k]; td = new TableCell(); td.Text = ItemHelp.showMoneyValue(item.getValue(reason)).ToString(); tr.Cells.Add(td); } } }
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); }
protected void btnStat_Click(object sender, EventArgs e) { GMUser user = (GMUser)Session["user"]; if (moneyType.SelectedIndex == 2) { ParamTotalConsume param = new ParamTotalConsume(); param.m_time = m_time.Text; param.m_currencyType = moneyType.SelectedIndex + 1; OpRes res = user.doQuery(param, QueryType.queryTypeFishConsume); TableFishConsumeItem view = new TableFishConsumeItem(); view.genTable(user, tabResult, res); } else { genTable(tabResult, user); } }