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