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