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);
}
