daocustomer.java.svn-base

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

              ! (eEnEnt_Customer_Enterprise.getChEnterpriseFax()  + "A").equals("A"))
          {
               if(i==0){
               sql = sql + " Ent_Customer_Enterprise.chEnterpriseFax like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseFax().trim() + "%'";
               i++;
               }else{
               sql = sql + " and Ent_Customer_Enterprise.chEnterpriseFax like '%" + eEnEnt_Customer_Enterprise.getChEnterpriseFax().trim() + "%'";
               }
          }
      
      if (eEnEnt_Customer_Enterprise.getChEnterprisePhone() != null &&
              ! (eEnEnt_Customer_Enterprise.getChEnterprisePhone()  + "A").equals("A"))
          {
               if(i==0){
               sql = sql + " Ent_Customer_Enterprise.chEnterprisePhone like '%" + eEnEnt_Customer_Enterprise.getChEnterprisePhone().trim() + "%'";
               i++;
               }else{
               sql = sql + " and Ent_Customer_Enterprise.chEnterprisePhone like '%" + eEnEnt_Customer_Enterprise.getChEnterprisePhone().trim() + "%'";
               }
          }
      
      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 EnEnt_Customer_Enterprise [] searcheEnContract2(DbAccess db,
	  		EnEnt_Customer_Enterprise SearchEnContract,String startTime,String endTime,String chStationCode,String idstr)
	    throws Exception
	{
	  String eEnEnt_Customer_Enterprise="";

	  if ((SearchEnContract.getChEnterpriseLinkman() != null && SearchEnContract.getChEnterpriseLinkman().length() != 0)
	    ||(SearchEnContract.getChEnterpriseFullName() != null && SearchEnContract.getChEnterpriseFullName().length() != 0)
	    ||(SearchEnContract.getChSeatCode() != null && SearchEnContract.getChSeatCode().length() != 0)
	    ||(SearchEnContract.getChStationCode() != null && SearchEnContract.getChStationCode().length() != 0)
	    ||(SearchEnContract.getChStation() != null && SearchEnContract.getChStation().length() != 0)
	    
	    ||(SearchEnContract.getChEnterpriseProvinceCode() != null && SearchEnContract.getChEnterpriseProvinceCode().length() != 0)
	    ||(SearchEnContract.getChEnterpriseCityName() != null && SearchEnContract.getChEnterpriseCityName().length() != 0)
	    ||(SearchEnContract.getChArea() != null && SearchEnContract.getChArea().length() != 0)
	    ||(SearchEnContract.getChEnterpriseGrade() != null && SearchEnContract.getChEnterpriseGrade().length() != 0)
	    
	    ||(SearchEnContract.getChEnterpriseFax() != null && SearchEnContract.getChEnterpriseFax().length() != 0)
	    ||(SearchEnContract.getChEnterprisePhone() != null && SearchEnContract.getChEnterprisePhone().length() != 0)
	    ||(SearchEnContract.getLinkmanTel() != null && SearchEnContract.getLinkmanTel().length() != 0)
	    
	    ||(SearchEnContract.getChEnterpriseCategory() != null && SearchEnContract.getChEnterpriseCategory().length() != 0)
	    ||(SearchEnContract.getChProduct() != null && SearchEnContract.getChProduct().length() != 0)
	    ||(startTime != null && startTime.length()!=0)
	    ||(endTime != null && endTime.length()!=0)
	    ||(SearchEnContract.getChCommitName() != null && SearchEnContract.getChCommitName().toString().length() != 0) ) 
	  {
	  	//eEnEnt_Customer_Enterprise = "(select * from Ent_Customer_Enterprise where chIsAudited like '1' and "+ GDPE.customer.enterprise.DAOCustomer.searchSql(SearchEnContract,startTime,endTime)+") Ent_Customer_Enterprise ";
	      
		  eEnEnt_Customer_Enterprise ="(select * from (select * from ent_customer_enterprise  where  chAreacode = '"+chStationCode+"' or  chStationCode ='"+chStationCode+"' or  chCommitCode ='"+idstr+"') Ent_Customer_Enterprise where chIsAudited like '0' and "+ GDPE.customer.enterprise.DAOCustomer.searchSql(SearchEnContract,startTime,endTime)+") 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);
	} 
  
}