daocontract.java.svn-base

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

package GDPE.contract.phone;

import levin.base.*;
import levin.util.DbAccess;
import levin.util.DataSet;

/**
 * 合同管理 数据库访问类
 * <p>Title: 企业合同</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author
 * @version 1.0
 */
public class DAOContract extends DAOBase {
    public DAOContract() {
    }
    public static EnENT_PHONE_CONTRACT [] searchePhContract(DbAccess db,
    		EnENT_PHONE_CONTRACT SearchEnContract)
      throws Exception
  {
    String eEnENT_PHONE_CONTRACT="";

    if ((SearchEnContract.getChEnterpriseName() != null && SearchEnContract.getChEnterpriseName().length() != 0)
      ||(SearchEnContract.getChConnectPhone() != null && SearchEnContract.getChConnectPhone().length() != 0)
      ||(SearchEnContract.getChDealPhone()!=null && SearchEnContract.getChDealPhone().length() !=0)
      ||(SearchEnContract.getChPassword()!=null && SearchEnContract.getChPassword().length()!=0)
    )
    {
    	eEnENT_PHONE_CONTRACT = "(select * from ENT_PHONE_CONTRACT where "+ GDPE.contract.phone.DAOContract.searchSql(SearchEnContract)+") ENT_PHONE_CONTRACT ";
        //System.out.println("0000000000000000000"+SearchEnContract.getChEnterpriseName());
    }else{
    	eEnENT_PHONE_CONTRACT="ENT_PHONE_CONTRACT";
    }

    //System.out.println(Auditor);
    String  sql="";
   
   //String sql = "select * from Ent_Record_Contract where chContractNo='"+SearchEnContract.getChContractNo()+"'";
    sql = sql + " select ENT_PHONE_CONTRACT.*";
    sql = sql + " from "+eEnENT_PHONE_CONTRACT;
    sql = sql + setDefaultSort();

    //System.out.println("sq-------------------------"+sql);
    EnENT_PHONE_CONTRACT [] aEnENT_PHONE_CONTRACT = null;
    aEnENT_PHONE_CONTRACT =DAOContract.SetEnContract(db, sql);
    return (aEnENT_PHONE_CONTRACT);
 }

  public static String searchSql(EnENT_PHONE_CONTRACT eEnEnt_Record_Contract)
    {
      String sql = "";
      int i=0;
      if (eEnEnt_Record_Contract.getChEnterpriseName() != null &&
          ! (eEnEnt_Record_Contract.getChEnterpriseName() + "A").equals("A"))
      {
        sql = sql + "ENT_PHONE_CONTRACT.chEnterpriseName like '%" + eEnEnt_Record_Contract.getChEnterpriseName().trim()+"%'";
        i++;
      }
      if (eEnEnt_Record_Contract.getChConnectPhone() != null &&
          ! (eEnEnt_Record_Contract.getChConnectPhone() + "A").equals("A"))
      {
           if(i==0){
           sql = sql + " ENT_PHONE_CONTRACT.chConnectPhone like '%" + eEnEnt_Record_Contract.getChConnectPhone().trim() + "%'";
           i++;
           }else{
           sql = sql + " and ENT_PHONE_CONTRACT.chConnectPhone like '%" + eEnEnt_Record_Contract.getChConnectPhone().trim() + "%'";
           }
      }
      if (eEnEnt_Record_Contract.getChDealPhone() != null &&
              ! (eEnEnt_Record_Contract.getChDealPhone() + "A").equals("A"))
          {
               if(i==0){
               sql = sql + " ENT_PHONE_CONTRACT.chDealPhone like '%" + eEnEnt_Record_Contract.getChDealPhone().trim() + "%'";
               i++;
               }else{
               sql = sql + " and ENT_PHONE_CONTRACT.chDealPhone like '%" + eEnEnt_Record_Contract.getChDealPhone().trim() + "%'";
               }
          }
      if (eEnEnt_Record_Contract.getChPassword() != null &&
              ! (eEnEnt_Record_Contract.getChPassword() + "A").equals("A"))
          {
               if(i==0){
               sql = sql + " ENT_PHONE_CONTRACT.chPassword like '%" + eEnEnt_Record_Contract.getChPassword().trim() + "%'";
               i++;
               }else{
               sql = sql + " and ENT_PHONE_CONTRACT.chPassword like '%" + eEnEnt_Record_Contract.getChPassword().trim() + "%'";
               }
          }

      //String drt=eEnEnt_Record_Contract.getDtRecordTime();
 

      return sql;
  }

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


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

      return eEnt_Record_Contract;
  }
  
  
}