predialtaskqueryvalue.java

采用JAVA开发

package com.gctech.sms.voice.dao;


  /* author:[e-mail] */
  public class PredialtaskQueryValue extends  PredialtaskValueObject { 
      //-----Codes below generated by dao 

    public   PredialtaskQueryValue()  { 
      super();
     } 

    public String   toSql()  { 
      StringBuffer sql = new StringBuffer() ;

      if(this.getSerialnum()!=null&&!this.getSerialnum().equals("")){
      sql.append(" and A.SERIALNUM='"+this.getSerialnum()).append("'");
      }

      if(this.getCallorder()!=null){
      sql.append(" and A.CALLORDER=").append(this.getCallorder());
      }

      if(this.getServicebegintime()!=null&&!this.getServicebegintime().equals("")){
      sql.append(" and A.SERVICEBEGINTIME='"+this.getServicebegintime()).append("'");
      }

      if(this.getServicestoptime()!=null&&!this.getServicestoptime().equals("")){
      sql.append(" and A.SERVICESTOPTIME='"+this.getServicestoptime()).append("'");
      }

      if(this.getDialbegintime()!=null&&!this.getDialbegintime().equals("")){
      sql.append(" and A.DIALBEGINTIME='"+this.getDialbegintime()).append("'");
      }

      if(this.getDialendtime()!=null&&!this.getDialendtime().equals("")){
      sql.append(" and A.DIALENDTIME='"+this.getDialendtime()).append("'");
      }

      if(this.getTimeinterval()!=null){
      sql.append(" and A.TIMEINTERVAL=").append(this.getTimeinterval());
      }

      if(this.getIntervaltype()!=null){
      sql.append(" and A.INTERVALTYPE=").append(this.getIntervaltype());
      }

      if(this.getCaller()!=null&&!this.getCaller().equals("")){
      sql.append(" and A.CALLER='"+this.getCaller()).append("'");
      }

      if(this.getOrigcaller()!=null&&!this.getOrigcaller().equals("")){
      sql.append(" and A.ORIGCALLER='"+this.getOrigcaller()).append("'");
      }

      if(this.getCalled()!=null&&!this.getCalled().equals("")){
      sql.append(" and A.CALLED='"+this.getCalled()).append("'");
      }

      if(this.getOrigcalled()!=null&&!this.getOrigcalled().equals("")){
      sql.append(" and A.ORIGCALLED='"+this.getOrigcalled()).append("'");
      }

      if(this.getPrivatedata()!=null&&!this.getPrivatedata().equals("")){
      sql.append(" and A.PRIVATEDATA='"+this.getPrivatedata()).append("'");
      }

      if(this.getRedialinterval()!=null&&!this.getRedialinterval().equals("")){
      sql.append(" and A.REDIALINTERVAL='"+this.getRedialinterval()).append("'");
      }

      if(this.getRedialcount()!=null){
      sql.append(" and A.REDIALCOUNT=").append(this.getRedialcount());
      }

      if(this.getType()!=null){
      sql.append(" and A.TYPE=").append(this.getType());
      }

      if(this.getServiceid()!=null){
      sql.append(" and A.SERVICEID=").append(this.getServiceid());
      }

      if(this.getAnswertype()!=null){
      sql.append(" and A.ANSWERTYPE=").append(this.getAnswertype());
      }

      if(this.getPriority()!=null){
      sql.append(" and A.PRIORITY=").append(this.getPriority());
      }

      if(this.getStatus()!=null){
      sql.append(" and A.STATUS=").append(this.getStatus());
      }

      if(this.getDefaultinterval()!=null){
      sql.append(" and A.DEFAULTINTERVAL=").append(this.getDefaultinterval());
      }

      if(this.getUserdata()!=null&&!this.getUserdata().equals("")){
      sql.append(" and A.USERDATA='"+this.getUserdata()).append("'");
      }

      return sql.toString();
     } 

      //-----Codes above generated by dao 
 }