public override OpRes doQuery(object param, GMUser user)
{
m_result.Clear();
m_cond.startQuery();
OpRes res = makeQuery(param, user, m_cond);
if (res != OpRes.opres_success)
{
return(res);
}
ParamScoreOpRecord p = (ParamScoreOpRecord)param;
string cond = Convert.ToString(m_cond.getCond()["cond"]);
string cmd = string.Format(SqlStrCMD.SQL_QUERY_SCORE_OP,
TableName.GM_SCORE,
TableName.GM_ACCOUNT,
cond,
(p.m_curPage - 1) * p.m_countEachPage,
p.m_countEachPage);
// 查看满足条件的记当个数
user.totalRecord = user.sqlDb.getRecordCountNoWhere(TableName.GM_SCORE + "," + TableName.GM_ACCOUNT,
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++)
{
ResultScoreOpRecordItem info = new ResultScoreOpRecordItem();
m_result.Add(info);
Dictionary <string, object> data = dataList[i];
info.m_id = Convert.ToInt64(data["opId"]);
info.m_opTime = Convert.ToDateTime(data["opTime"]).ToString();
info.m_opAcc = Convert.ToString(data["opSrc"]);
info.m_opAccAlias = "";
info.m_opType = Convert.ToInt32(data["opType"]);
info.m_opScore = Convert.ToInt64(data["opScore"]);
info.m_dstAcc = Convert.ToString(data["opDst"]);
// info.m_moneyType = Convert.ToInt32(data["moneyType"]);
if (!(data["aliasName"] is DBNull))
{
info.m_opAccAlias = Convert.ToString(data["aliasName"]);
}
if (!(data["opDstRemainMoney"] is DBNull))
{
info.m_dstRemainMoney = Convert.ToInt64(data["opDstRemainMoney"]);
}
if (!(data["opRemainMoney"] is DBNull))
{
info.m_opRemainMoney = Convert.ToInt64(data["opRemainMoney"]);
}
//////////////////////////////////////////////////////////////////////////
if (!(data["userOrderId"] is DBNull))
{
info.m_apiOrder = Convert.ToString(data["userOrderId"]);
}
if (!(data["opResult"] is DBNull))
{
info.m_opResult = Convert.ToInt32(data["opResult"]);
}
else
{
info.m_opResult = PlayerReqOrderState.STATE_FINISH;
}
if (!(data["failReason"] is DBNull))
{
info.m_failReason = Convert.ToInt32(data["failReason"]);
}
if (!(data["logFrom"] is DBNull))
{
info.m_logFrom = Convert.ToInt32(data["logFrom"]);
}
else
{
info.m_logFrom = OrderGenerator.ORDER_FROM_BG_OP;
}
if (!(data["finishTime"] is DBNull))
{
info.m_finishTime = Convert.ToDateTime(data["finishTime"]).ToString();
}
if (!(data["orderId"] is DBNull))
{
info.m_orderId = Convert.ToString(data["orderId"]);
}
}
return(OpRes.opres_success);
}