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