public override OpRes doQuery(object param, GMUser user) { m_result.Clear(); ParamRealTimeOrder p = (ParamRealTimeOrder)param; string cond = ""; OpRes res = getQueryCond(p, user, ref cond); if (res != OpRes.opres_success) { return(res); } string cmd = string.Format(SQL_QUERY_REAL_TIME_ORDER, TableName.PLAYER_ORDER_COMPLETE, cond, (p.m_curPage - 1) * p.m_countEachPage, p.m_countEachPage); // 查看满足条件的记当个数 user.totalRecord = user.sqlDb.getRecordCountNoWhere(TableName.PLAYER_ORDER_COMPLETE, cond, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA); List <Dictionary <string, object> > dataList = user.sqlDb.queryList(cmd, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA); if (dataList == null) { return(OpRes.op_res_failed); } for (int i = 0; i < dataList.Count; i++) { OrderInfoItem info = new OrderInfoItem(); m_result.Add(info); Dictionary <string, object> data = dataList[i]; info.m_orderId = Convert.ToString(data["orderId"]); info.m_apiOrderId = Convert.ToString(data["apiOrderId"]); info.m_genTime = Convert.ToDateTime(data["genTime"]); info.m_finishTime = Convert.ToDateTime(data["finishTime"]); info.m_gmAcc = Convert.ToString(data["gmAcc"]); info.m_playerAcc = Convert.ToString(data["playerAcc"]); info.m_orderType = Convert.ToInt32(data["orderType"]); info.m_money = Convert.ToInt64(data["money"]); info.m_orderState = Convert.ToInt32(data["orderState"]); info.m_failReason = Convert.ToInt32(data["failReason"]); } return(OpRes.opres_success); }
protected void onQueryRecord(object sender, EventArgs e) { GMUser user = (GMUser)Session["user"]; ParamRealTimeOrder param = new ParamRealTimeOrder(); param.m_countEachPage = m_gen.rowEachPage; param.m_curPage = m_gen.curPage; param.m_time = m_time.Text; param.m_opAcc = m_opAcc.Text; param.m_dstAcc = m_dstAcc.Text; m_page.InnerHtml = ""; m_foot.InnerHtml = ""; OpRes res = user.doQuery(param, QueryType.queryTypeQueryRealTimeOrder); m_view.genTable(m_result, res, user); string page_html = "", foot_html = ""; m_gen.genPage(param, @"/appaspx/account/AccountRealTimeOrder.aspx", ref page_html, ref foot_html, user); m_page.InnerHtml = page_html; m_foot.InnerHtml = foot_html; }