string str = "1,2,3";
sqlstr+="and 1-1 and (1!=1";
string str0="";
for(int i=0;i<str.length;i++){
if(str[i].equals("1")){
str0+="or eventtype=1";
}
else if(str[i].equals("2")){
str0+="or eventtype in (0,2,3)";
}
else if(str[i].equals("3")){
str0+="or eventtype >4";
}
if(i==str.length-1){
str0+=")";
}
sqlstr = sqlstr+str0;
}
}