private OpRes genQueryCond(ParamQueryOpLog p, GMUser user, ref string resultCond) { QueryCondGenerator gen = new QueryCondGenerator(); if (p.m_logType != 0) { gen.addCondition(string.Format("opType={0}", p.m_logType)); } if (!string.IsNullOrEmpty(p.m_time)) { DateTime mint = DateTime.Now, maxt = DateTime.Now; bool res = Tool.splitTimeStr(p.m_time, ref mint, ref maxt); if (!res) { return(OpRes.op_res_time_format_error); } string cond = string.Format("opTime>='{0}' and opTime<'{1}'", mint, maxt); gen.addCondition(cond); } gen.addCondition(string.Format("opAcc=acc and createCode like '{0}%' ", user.m_createCode)); resultCond = gen.and(); return(OpRes.opres_success); }
string genCond(object param, GMUser user) { QueryCondGenerator gen = new QueryCondGenerator(); gen.addCondition(string.Format("apiCreatorCode like '{0}%' ", user.m_createCode)); if (param != null) { string acc = (string)param; gen.addCondition(string.Format("apiAcc='{0}'", acc)); } return(gen.and()); }
string getCondition(ParamDelDataScoreLog p, DateTime mint, GMUser user) { QueryCondGenerator gen = new QueryCondGenerator(); if (!string.IsNullOrEmpty(p.m_opAcc)) { gen.addCondition(string.Format("opSrc='{0}'", p.m_opAcc)); } if (!string.IsNullOrEmpty(p.m_playerAcc)) { gen.addCondition(string.Format("opDst='{0}'", p.m_playerAcc)); } gen.addCondition(string.Format(" opTime<'{0}' ", mint.ToString(ConstDef.DATE_TIME24))); gen.addCondition(string.Format(" opSrcCreateCode like '{0}%' ", user.m_createCode)); return(gen.and(false)); }
// 构造查询条件 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); }