public override OpRes doQuery(object param, GMUser user) { ParamPlayerOrderQuery p = (ParamPlayerOrderQuery)param; m_result.Clear(); string cmd = genOrderSqlCmd(p, user); 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++) { ResultPlayerOrderItem info = new ResultPlayerOrderItem(); m_result.Add(info); Dictionary <string, object> data = dataList[i]; info.m_orderId = Convert.ToString(data["orderId"]); info.m_orderTime = Convert.ToDateTime(data["orderTime"]).ToString(ConstDef.DATE_TIME24); info.m_playerAcc = Convert.ToString(data["playerAcc"]); info.m_playerOwner = Convert.ToString(data["playerOwner"]); info.m_playerOwnerCreator = Convert.ToString(data["playerOwnerCreator"]); info.m_orderState = Convert.ToInt32(data["orderState"]); info.m_orderMoney = Convert.ToInt32(data["orderMoney"]); info.m_orderType = Convert.ToInt32(data["orderType"]); } return(OpRes.opres_success); }
protected void queryRecord() { GMUser user = (GMUser)Session["user"]; ParamPlayerOrderQuery param = new ParamPlayerOrderQuery(); param.m_orderState = Convert.ToInt32(m_orderState.SelectedValue); OpRes res = user.doQuery(param, QueryType.queryTypeQueryPlayerOrder); m_view.genTable(m_result, res, user, new EventHandler(onScoreOp)); }
ResultPlayerOrderItem getItem(ParamPlayerOrder p, GMUser user) { ParamPlayerOrderQuery param = new ParamPlayerOrderQuery(); param.m_orderState = OrderState.STATE_WAIT; param.m_orderId = p.m_orderId; param.m_playerAcc = p.m_playerAcc; param.m_op = 1; OpRes res = user.doQuery(param, QueryType.queryTypeQueryPlayerOrder); List <ResultPlayerOrderItem> items = (List <ResultPlayerOrderItem>)user.getQueryResult(QueryType.queryTypeQueryPlayerOrder); if (items.Count > 0) { return(items[0]); } return(null); }
// 返回查询语句 string genOrderSqlCmd(ParamPlayerOrderQuery p, GMUser user) { string cmd = ""; string tableName = ""; switch (p.m_orderState) { case OrderState.STATE_WAIT: { tableName = TableName.PLAYER_ORDER_WAIT; } break; default: { tableName = TableName.PLAYER_ORDER_FINISH; } break; } switch (p.m_op) { case 0: // 查询指定状态订单 { cmd = string.Format(SQL_QUERY_ORDER, tableName, string.Format(" curOpAcc='{0}' and orderState='{1}' ", user.m_user, p.m_orderState)); } break; case 1: { cmd = string.Format(SQL_QUERY_ORDER, tableName, string.Format(" orderId='{0}' and playerAcc='{1}' ", p.m_orderId, p.m_playerAcc)); } break; } return(cmd); }