daocontract.java

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

package GDPE.contract.manager;

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_Record_Contract [] searcheEnContract(DbAccess db,
                                         EnEnt_Record_Contract SearchEnContract,String startTime,String endTime)
      throws Exception
  {
    String eEnEnt_Record_Contract="";

    if ((SearchEnContract.getChContractNo() != null && SearchEnContract.getChContractNo().length() != 0)
      ||(SearchEnContract.getChEnterpriseName() != null && SearchEnContract.getChEnterpriseName().length() != 0)
      ||(SearchEnContract.getChProtocol()!=null && SearchEnContract.getChProtocol().length() !=0)
      ||(SearchEnContract.getChLoginStationName()!=null && SearchEnContract.getChLoginStationName().length()!=0)
      ||(SearchEnContract.getChContractFollowUserName() != null && SearchEnContract.getChContractFollowUserName().length() != 0)
      ||(SearchEnContract.getDtRecordTime() != null && SearchEnContract.getDtRecordTime().toString().length() != 0)//////????gai
      ||(startTime != null && startTime.length() != 0)||(endTime != null && endTime.length() != 0) )
    {
        eEnEnt_Record_Contract = "(select * from Ent_Record_Contract where "+ GDPE.contract.manager.DAOContract.searchSql(SearchEnContract,startTime,endTime)+") Ent_Record_Contract ";
        //System.out.println("0000000000000000000"+SearchEnContract.getChEnterpriseName());
    }else{
        eEnEnt_Record_Contract="Ent_Record_Contract";
    }

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

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

  public static String searchSql(EnEnt_Record_Contract eEnEnt_Record_Contract,String startTime,String endTime)
    {
      String sql = "";
      int i=0;
      if (eEnEnt_Record_Contract.getChContractNo() != null &&
          ! (eEnEnt_Record_Contract.getChContractNo() + "A").equals("A"))
      {
        sql = sql + "Ent_Record_Contract.chContractNo like '%" + eEnEnt_Record_Contract.getChContractNo().trim()+"%'";
        i++;
      }
      if (eEnEnt_Record_Contract.getChEnterpriseName() != null &&
          ! (eEnEnt_Record_Contract.getChEnterpriseName() + "A").equals("A"))
      {
           if(i==0){
           sql = sql + " Ent_Record_Contract.chEnterpriseName like '%" + eEnEnt_Record_Contract.getChEnterpriseName().trim() + "%'";
           i++;
           }else{
           sql = sql + " and Ent_Record_Contract.chEnterpriseName like '%" + eEnEnt_Record_Contract.getChEnterpriseName().trim() + "%'";
           }
      }
      if (eEnEnt_Record_Contract.getChProtocol() != null &&
              ! (eEnEnt_Record_Contract.getChProtocol() + "A").equals("A"))
          {
               if(i==0){
               sql = sql + " Ent_Record_Contract.chProtocol like '%" + eEnEnt_Record_Contract.getChProtocol().trim() + "%'";
               i++;
               }else{
               sql = sql + " and Ent_Record_Contract.chProtocol like '%" + eEnEnt_Record_Contract.getChProtocol().trim() + "%'";
               }
          }
      if (eEnEnt_Record_Contract.getChLoginStationName() != null &&
              ! (eEnEnt_Record_Contract.getChLoginStationName() + "A").equals("A"))
          {
               if(i==0){
               sql = sql + " Ent_Record_Contract.chLoginStationName like '%" + eEnEnt_Record_Contract.getChLoginStationName().trim() + "%'";
               i++;
               }else{
               sql = sql + " and Ent_Record_Contract.chLoginStationName like '%" + eEnEnt_Record_Contract.getChLoginStationName().trim() + "%'";
               }
          }
      if (eEnEnt_Record_Contract.getChContractFollowUserName() != null &&
          ! (eEnEnt_Record_Contract.getChContractFollowUserName()  + "A").equals("A"))
      {
           if(i==0){
           sql = sql + " Ent_Record_Contract.chContractFollowUserName like '%" + eEnEnt_Record_Contract.getChContractFollowUserName().trim() + "%'";
           i++;
           }else{
           sql = sql + " and Ent_Record_Contract.chContractFollowUserName like '%" + eEnEnt_Record_Contract.getChContractFollowUserName().trim() + "%'";
           }
      }
      //String drt=eEnEnt_Record_Contract.getDtRecordTime();
      if (startTime != null && ! (startTime + "A").equals("A"))
        {
          if(i==0){                                                 //TO_DATE('01-01-2000','dd-mm-yyyy');
                  sql = sql + " Ent_Record_Contract.dtRecordTime >= TO_DATE('" + startTime.trim() + "','yyyy-MM-dd')";
                  i++;
          }else{
                  sql = sql + " and Ent_Record_Contract.dtRecordTime >= TO_DATE('" + startTime.trim() + "','yyyy-MM-dd')";
          }
        }

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

      return sql;
  }

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


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

      return eEnt_Record_Contract;
  }
  
  
}