protected void onExport(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamScoreOpRecord param = getParam();
ExportMgr mgr = user.getSys <ExportMgr>(SysType.sysTypeExport);
OpRes res = mgr.doExport(param, ExportType.exportTypeScoreOpLog, user);
setOpRes(res);
}
ParamScoreOpRecord getParam()
{
ParamScoreOpRecord param = new ParamScoreOpRecord();
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;
param.m_orderState = Convert.ToInt32(m_orderResult.SelectedValue);
return(param);
}
public override void genPage(ParamQueryBase queryParam, string url, ref string page_link, ref string foot, GMUser user)
{
ParamScoreOpRecord dparam = (ParamScoreOpRecord)queryParam;
PageBrowseGenerator p = new PageBrowseGenerator();
long total_page = 0;
Dictionary <string, object> urlParam = new Dictionary <string, object>();
urlParam["opAcc"] = dparam.m_opAcc;
urlParam["time"] = dparam.m_time;
urlParam["dstAcc"] = dparam.m_dstAcc;
page_link = p.genPageFoot(queryParam.m_curPage, m_rowEachPage, url, ref total_page, user, urlParam);
if (total_page != 0)
{
foot = queryParam.m_curPage + "/" + total_page;
}
}
public override OpRes makeQuery(object param, GMUser user, QueryCondition imq)
{
ParamScoreOpRecord p = (ParamScoreOpRecord)param;
string cond = "";
OpRes res = getQueryCond(p, user, ref cond, imq);
if (res == OpRes.opres_success)
{
imq.addCond("cond", cond);
if (imq.isExport())
{
imq.addCond("moneyBase", DefCC.MONEY_BASE);
}
}
return(res);
}
protected void onQueryRecord(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamScoreOpRecord param = getParam();
m_time.Text = searchDateSpan.getDateTimeSpanLeft() + " - " + searchDateSpan.getDateTimeSpanRight();
m_page.InnerHtml = "";
m_foot.InnerHtml = "";
OpRes res = user.doQuery(param, QueryType.queryTypeQueryScoreOpRecord);
m_view.genTable(m_result, res, user);
string page_html = "", foot_html = "";
m_gen.genPage(param, @"/appaspx/account/AccountScoreOpLog.aspx", ref page_html, ref foot_html, user);
m_page.InnerHtml = page_html;
m_foot.InnerHtml = foot_html;
}
// 构造查询条件
OpRes getQueryCond(ParamScoreOpRecord p, GMUser user, ref string condStr)
{
DateTime mint = DateTime.Now, maxt = mint;
bool useTime = false;
if (!string.IsNullOrEmpty(p.m_time))
{
useTime = Tool.splitTimeStr(p.m_time, ref mint, ref maxt);
if (!useTime)
{
return(OpRes.op_res_time_format_error);
}
}
QueryCondGenerator gen = new QueryCondGenerator();
gen.addCondition(string.Format(" gmCreateCode like '{0}%' ", ItemHelp.getCreateCodeSpecial(user)));
if (!string.IsNullOrEmpty(p.m_opAcc))
{
gen.addCondition(string.Format("gmAcc='{0}'", p.m_opAcc));
}
if (!string.IsNullOrEmpty(p.m_dstAcc))
{
gen.addCondition(string.Format("playerAcc='{0}'", p.m_dstAcc));
}
if (useTime)
{
gen.addCondition(string.Format(" genTime>='{0}' and genTime<'{1}' ", mint.ToString(ConstDef.DATE_TIME24),
maxt.ToString(ConstDef.DATE_TIME24)));
}
condStr = gen.and();
return(OpRes.opres_success);
}
// 构造查询条件
OpRes getQueryCond(ParamScoreOpRecord p, GMUser user, ref string condStr, QueryCondition queryCond)
{
DateTime mint = DateTime.Now, maxt = mint;
bool useTime = false;
if (!string.IsNullOrEmpty(p.m_time))
{
useTime = Tool.splitTimeStr(p.m_time, ref mint, ref maxt);
if (!useTime)
{
return(OpRes.op_res_time_format_error);
}
}
QueryCondGenerator gen = new QueryCondGenerator();
gen.addCondition(string.Format(" opSrcCreateCode like '{0}%' ", ItemHelp.getCreateCodeSpecial(user)));
if (!string.IsNullOrEmpty(p.m_opAcc))
{
gen.addCondition(string.Format("opSrc='{0}'", p.m_opAcc));
if (queryCond.isExport())
{
queryCond.addCond("opSrc", p.m_opAcc);
}
}
if (!string.IsNullOrEmpty(p.m_dstAcc))
{
gen.addCondition(string.Format("opDst='{0}'", p.m_dstAcc));
if (queryCond.isExport())
{
queryCond.addCond("opDst", p.m_dstAcc);
}
}
if (useTime)
{
gen.addCondition(string.Format(" opTime>='{0}' and opTime<'{1}' ", mint.ToString(ConstDef.DATE_TIME24),
maxt.ToString(ConstDef.DATE_TIME24)));
if (queryCond.isExport())
{
queryCond.addCond("time", p.m_time);
}
}
if (p.m_orderState > -1)
{
gen.addCondition(string.Format("opResult={0}", p.m_orderState));
if (queryCond.isExport())
{
queryCond.addCond("opResult", p.m_orderState);
}
}
gen.addCondition(string.Format(" {0}.opSrc={1}.acc", TableName.GM_SCORE, TableName.GM_ACCOUNT));
condStr = gen.and();
return(OpRes.opres_success);
}
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);
}
