package swing;

/**
 * <p>Title:SeliatF </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author SeliatF
 * @version 1.0
 */

public class Thstat {

  private String names;
  private String types;
  private String bosses;
  private String plan;
  private String trim;
  private String sql="select * from tb_th_plan where";
  private String cut="";

  private String toTrim(String trims){
    //this.trim=trim.trim();
    if(!trims.equals("")||trims!=null){
      return this.trim=trims.trim();
    }
    return this.trim="";
  }

  private void setName(String names){
    this.names=toTrim(names);
  }
  private void setType(String types){
    this.types=toTrim(types);
  }
  private void setBoss(String bosses){
    this.bosses=toTrim(bosses);
  }
  private void setPlan(String plan){
    this.plan=toTrim(plan);
  }

  private String cutString(String cut){
    int length=cut.length();
    this.cut=cut.substring(0,length-5);
    return this.cut;
  }

  public String toSql(String names,String types,String bosses,String plan){
    setName(names);
    setType(types);
    setBoss(bosses);
    setPlan(plan);
    if(!names.trim().equals("")){
      sql=sql+" Name='"+names+"' and  ";
    }if(!types.trim().equals("")){
      sql=sql+" Type='"+types+"' and  ";
    }if(!bosses.trim().equals("")){
      sql=sql+" Boss='"+bosses+"' and  ";
    }if(!plan.trim().equals("")){
      sql=sql+" Planing="+plan+" and  ";
    }
    return cutString(sql);
  }
}