if(startTime!=null&&!startTime.equals("")&&endTime!=null&&!endTime.equals("")){
strWhere+=" and bb.CreateTime between '"+startTime+" 00:00:00' and '" +endTime+" 23:59:59'";
}else if(startTime!=null&&!startTime.equals("")&&(endTime==null||endTime.equals(""))){
strWhere+=" and bb.CreateTime >= '"+startTime+" 00:00:00'";
}else if((startTime==null||startTime.equals(""))&&(endTime!=null&&!endTime.equals(""))){
strWhere+=" and bb.CreateTime <= '" +endTime+" 23:59:59'";
}
if(companyNameCN!=null&&!companyNameCN.equals("")){
strWhere+=" and gg.CompanyNameCN='"+companyNameCN+"'";
}
strWhere+=" and bb.CreateTime between '"+startTime+" 00:00:00' and '" +endTime+" 23:59:59'";
}else if(startTime!=null&&!startTime.equals("")&&(endTime==null||endTime.equals(""))){
strWhere+=" and bb.CreateTime >= '"+startTime+" 00:00:00'";
}else if((startTime==null||startTime.equals(""))&&(endTime!=null&&!endTime.equals(""))){
strWhere+=" and bb.CreateTime <= '" +endTime+" 23:59:59'";
}
if(companyNameCN!=null&&!companyNameCN.equals("")){
strWhere+=" and gg.CompanyNameCN='"+companyNameCN+"'";
}