daocustomer.java.svn-base

公司CRM部分原代码,采用的是java技术.

               }
          }
      
      if (eEnEnt_Customer_Enterprise.getLinkmanTel() != null &&
              ! (eEnEnt_Customer_Enterprise.getLinkmanTel()  + "A").equals("A"))
          {
               if(i==0){
               sql = sql + " Ent_Customer_Enterprise.LinkmanTel like '%" + eEnEnt_Customer_Enterprise.getLinkmanTel().trim() + "%'";
               i++;
               }else{
               sql = sql + " and Ent_Customer_Enterprise.LinkmanTel like '%" + eEnEnt_Customer_Enterprise.getLinkmanTel().trim() + "%'";
               }
         }
           
      if (eEnEnt_Customer_Enterprise.getChEnterpriseCategory() != null &&
              ! (eEnEnt_Customer_Enterprise.getChEnterpriseCategory()  + "A").equals("A"))
          {
               if(i==0){
               sql = sql + " Ent_Customer_Enterprise.chEnterpriseCategory like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseCategory().trim() + "%'";
               i++;
               }else{
               sql = sql + " and Ent_Customer_Enterprise.chEnterpriseCategory like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseCategory().trim() + "%'";
               }
          }
      if (eEnEnt_Customer_Enterprise.getChProduct() != null &&
              ! (eEnEnt_Customer_Enterprise.getChProduct()  + "A").equals("A"))
          {
               if(i==0){
               sql = sql + " Ent_Customer_Enterprise.chProduct like '%" + eEnEnt_Customer_Enterprise.getChProduct().trim() + "%'";
               i++;
               }else{
               sql = sql + " and Ent_Customer_Enterprise.chProduct like '%" + eEnEnt_Customer_Enterprise.getChProduct().trim() + "%'";
               }
          }
      
      if (startTime != null && ! (startTime + "A").equals("A"))
      {
        if(i==0){                                                 //TO_DATE('01-01-2000','dd-mm-yyyy');
                sql = sql + " Ent_Customer_Enterprise.dtFoundTime >= TO_DATE('" + startTime.trim() + "','yyyy-MM-dd')";
                i++;
        }else{
                sql = sql + " and Ent_Customer_Enterprise.dtFoundTime >= TO_DATE('" + startTime.trim() + "','yyyy-MM-dd')";
        }
      }

      if (endTime != null &&
              ! (endTime + "A").equals("A"))
          {
            if(i==0){
                    sql = sql + " Ent_Customer_Enterprise.dtFoundTime <= TO_DATE('" + endTime.trim() + "','yyyy-MM-dd')";
                    i++;
            }else{
                    sql = sql + " and Ent_Customer_Enterprise.dtFoundTime <= TO_DATE('" + endTime.trim() + "','yyyy-MM-dd')";
            }
    }
      
      return sql;
  }

  public static String setDefaultSort()
  {
    String sql = "";
    sql = " order by Ent_Customer_Enterprise.chSeatCode";
    return sql ;
  }

  public static EnEnt_Customer_Enterprise[] SetEnCustomert(DbAccess db, String sql)
        throws Exception
    {
      DataSet ds = db.executeQuery(sql);
      EnEnt_Customer_Enterprise[] eEnt_Customer_Enterprise = (EnEnt_Customer_Enterprise[]) DAOBase.resumeFromDataSet(ds, EnEnt_Customer_Enterprise.class.getName());

      return eEnt_Customer_Enterprise;
  }
  
  public static EnEnt_Customer_Enterprise [] searcheEnContract(DbAccess db,
  		EnEnt_Customer_Enterprise SearchEnContract)
    throws Exception
{
  String eEnEnt_Customer_Enterprise="";

  if ((SearchEnContract.getChCorporateName() != null && SearchEnContract.getChCorporateName().length() != 0)
    ||(SearchEnContract.getChEnterpriseFullName() != null && SearchEnContract.getChEnterpriseFullName().length() != 0)
    ||(SearchEnContract.getChSeatCode() != null && SearchEnContract.getChSeatCode().length() != 0)
    ||(SearchEnContract.getChStationCode() != null && SearchEnContract.getChStationCode().length() != 0)
    ||(SearchEnContract.getChCommitName() != null && SearchEnContract.getChCommitName().toString().length() != 0) )
  {
  	eEnEnt_Customer_Enterprise = "(select * from Ent_Customer_Enterprise where "+ GDPE.customer.enterprise.DAOCustomer.searchSql(SearchEnContract,null,null)+") Ent_Customer_Enterprise ";
      //System.out.println("0000000000000000000"+SearchEnContract.getChEnterpriseName());
  }else{
  	
  	eEnEnt_Customer_Enterprise="Ent_Customer_Enterprise";
  }

  //System.out.println(Auditor);
  String  sql="";

 //String sql = "select * from Ent_Record_Contract where chContractNo='"+SearchEnContract.getChContractNo()+"'";
  sql = sql + " select Ent_Customer_Enterprise.*";
  sql = sql + " from "+eEnEnt_Customer_Enterprise;
  sql = sql + setDefaultSort();

  //System.out.println("sq-------------------------"+sql);
  EnEnt_Customer_Enterprise [] aEnEnt_Customer_Enterprise = null;
  aEnEnt_Customer_Enterprise =DAOCustomer.SetEnCustomert(db, sql);
  return (aEnEnt_Customer_Enterprise);
}
  
  public static String searchSql2(EnEnt_Customer_Enterprise eEnEnt_Customer_Enterprise,String startTime,String endTime)
  {
    String sql = "";
    int i=0;
    if (eEnEnt_Customer_Enterprise.getChEnterpriseLinkman() != null &&
        ! (eEnEnt_Customer_Enterprise.getChEnterpriseLinkman() + "A").equals("A"))
    {
      sql = sql + "Ent_Customer_Enterprise.chEnterpriseLinkman like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseLinkman().trim()+"%'";
      i++;
    }
    if (eEnEnt_Customer_Enterprise.getChEnterpriseFullName() != null &&
        ! (eEnEnt_Customer_Enterprise.getChEnterpriseFullName() + "A").equals("A"))
    {
         if(i==0){
         sql = sql + " Ent_Customer_Enterprise.chEnterpriseFullName like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseFullName().trim() + "%'";
         i++;
         }else{
         sql = sql + " and Ent_Customer_Enterprise.chEnterpriseFullName like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseFullName().trim() + "%'";
         }
    }
    if (eEnEnt_Customer_Enterprise.getChSeatCode() != null &&
        ! (eEnEnt_Customer_Enterprise.getChSeatCode()  + "A").equals("A"))
    {
         if(i==0){
         sql = sql + " Ent_Customer_Enterprise.chSeatCode like '%" + eEnEnt_Customer_Enterprise.getChSeatCode().trim() + "%'";
         i++;
         }else{
         sql = sql + " and Ent_Customer_Enterprise.chSeatCode like '%" + eEnEnt_Customer_Enterprise.getChSeatCode().trim() + "%'";
         }
    }
    //String drt=eEnEnt_Record_Contract.getDtRecordTime();
 
    if (eEnEnt_Customer_Enterprise.getChCommitName() != null &&
            ! (eEnEnt_Customer_Enterprise.getChCommitName()  + "A").equals("A"))
        {
             if(i==0){
             sql = sql + " Ent_Customer_Enterprise.chCommitName like '%" + eEnEnt_Customer_Enterprise.getChCommitName().trim() + "%'";
             i++;
             }else{
             sql = sql + " and Ent_Customer_Enterprise.chCommitName like '%" + eEnEnt_Customer_Enterprise.getChCommitName().trim() + "%'";
             }
        }
    if (eEnEnt_Customer_Enterprise.getChCommitCode() != null &&
            ! (eEnEnt_Customer_Enterprise.getChCommitCode()  + "A").equals("A"))
        {
             if(i==0){
             sql = sql + " Ent_Customer_Enterprise.chCommitCode like '%" + eEnEnt_Customer_Enterprise.getChCommitCode().trim() + "%'";
             i++;
             }else{
             sql = sql + " and Ent_Customer_Enterprise.chCommitCode like '%" + eEnEnt_Customer_Enterprise.getChCommitCode().trim() + "%'";
             }
        }
    if (eEnEnt_Customer_Enterprise.getChStationCode() != null &&
            ! (eEnEnt_Customer_Enterprise.getChStationCode()  + "A").equals("A"))
        {
             if(i==0){
             sql = sql + " Ent_Customer_Enterprise.chStationCode like '%" + eEnEnt_Customer_Enterprise.getChStationCode().trim() + "%'";
             i++;
             }else{
             sql = sql + " and Ent_Customer_Enterprise.chStationCode like '%" + eEnEnt_Customer_Enterprise.getChStationCode().trim() + "%'";
             }
        }
    
    if (eEnEnt_Customer_Enterprise.getChStation() != null &&
            ! (eEnEnt_Customer_Enterprise.getChStation()  + "A").equals("A"))
        {
             if(i==0){
             sql = sql + " Ent_Customer_Enterprise.chStation like '%" + eEnEnt_Customer_Enterprise.getChStation().trim() + "%'";
             i++;
             }else{
             sql = sql + " and Ent_Customer_Enterprise.chStation like '%" + eEnEnt_Customer_Enterprise.getChStation().trim() + "%'";
             }
        }
    
    if (eEnEnt_Customer_Enterprise.getChEnterpriseProvinceCode() != null &&
            ! (eEnEnt_Customer_Enterprise.getChEnterpriseProvinceCode()  + "A").equals("A"))
        {
             if(i==0){
             sql = sql + " Ent_Customer_Enterprise.chEnterpriseProvinceCode like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseProvinceCode().trim() + "%'";
             i++;
             }else{
             sql = sql + " and Ent_Customer_Enterprise.chEnterpriseProvinceCode like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseProvinceCode().trim() + "%'";
             }
        }
    if (eEnEnt_Customer_Enterprise.getChEnterpriseCityName() != null &&
            ! (eEnEnt_Customer_Enterprise.getChEnterpriseCityName()  + "A").equals("A"))
        {
             if(i==0){
             sql = sql + " Ent_Customer_Enterprise.chEnterpriseCityName like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseCityName().trim() + "%'";
             i++;
             }else{
             sql = sql + " and Ent_Customer_Enterprise.chEnterpriseCityName like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseCityName().trim() + "%'";