if(param->UserId >=0 && TransFlag!=2 && TransFlag!=3 && TransFlag!=20)
i+=sprintf(pSql+i," and UserId=%d",param->UserId);
if(RunState==-1 || RunState==0 || RunState==1)
i+=sprintf(pSql+i," and RUNSTATE==%d",RunState);
else
i+=sprintf(pSql+i," and RUNSTATE!=-1");
if(param->TransNodeId>=0)
i+=sprintf(pSql+i," and NodeId=%d",param->TransNodeId);
if(param->NodeId>=0 && (TransFlag==0 || TransFlag==1 || TransFlag==10))
i+=sprintf(pSql+i," and SelfNodeId=%d",param->NodeId);
if(param->NodeId>=0 && (TransFlag==2 || TransFlag==3 || TransFlag==20))
i+=sprintf(pSql+i," and NodeId=%d",param->NodeId);
if(TransFlag==10)
i+=sprintf(pSql+i," and (Flag=0 or Flag=1)");
else if(TransFlag==20)
i+=sprintf(pSql+i," and (Flag=2 or Flag=3)");
else
i+=sprintf(pSql+i," and Flag=%d",TransFlag);
i+=sprintf(pSql+i," order by TRANS_TIME;");
民主不同于专制，不需要强加于人。--- 賴斯
大道之行也，天下为公，选贤与能，讲信修睦。故人不独亲其亲，不独子其子，使老有所终，壮有所用，幼有所长，矜、寡、孤、独、废疾者，皆有所养。男有分，女有归。货恶其弃於地也，不必藏於己；力恶其不出於身也，不必为己。是故，谋闭而不兴，盗窃乱贼而不作，故外户而不闭，是谓大同。--《礼运·大同篇》
| -ICP -IDC -ISP |