daophoneorder.java.svn-base

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

package GDPE.quashorder;

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 DAOPhoneOrder extends DAOBase {
    public DAOPhoneOrder() {
    }
 
    public static EnEnt_QuashOrder_Cord [] searcheEnContract(DbAccess db,
    		EnEnt_QuashOrder_Cord SearchEnContract,String startTime,String endTime)
      throws Exception
  {
    String eEnEnt_Record_Contract="";

    if ((SearchEnContract.getChSeatCode() != null && SearchEnContract.getChSeatCode().length() != 0)
      ||(SearchEnContract.getChLinkPhone() != null && SearchEnContract.getChLinkPhone().length() != 0)
      ||(startTime != null && startTime.length() != 0)||(endTime != null && endTime.length() != 0) )
    {
        eEnEnt_Record_Contract = "(select * from Ent_QuashOrder_Cord where "+ GDPE.quashorder.DAOPhoneOrder.searchSql(SearchEnContract,startTime,endTime)+") Ent_QuashOrder_Cord ";
        //System.out.println("0000000000000000000"+SearchEnContract.getChEnterpriseName());
    }else{
        eEnEnt_Record_Contract="Ent_QuashOrder_Cord";
    }

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

    //System.out.println("sq-------------------------"+sql);
    EnEnt_QuashOrder_Cord [] aEnEnt_QuashOrder_Cord = null;
    aEnEnt_QuashOrder_Cord =DAOPhoneOrder.SetEnContract(db, sql);
    return (aEnEnt_QuashOrder_Cord);
 } 

  public static String searchSql(EnEnt_QuashOrder_Cord eEnEnt_Record_Contract,String startTime,String endTime)
    {
      String sql = "";
      int i=0;
      if (eEnEnt_Record_Contract.getChSeatCode() != null &&
          ! (eEnEnt_Record_Contract.getChSeatCode() + "A").equals("A"))
      {
        sql = sql + "Ent_QuashOrder_Cord.chSeatCode like '%" + eEnEnt_Record_Contract.getChSeatCode().trim()+"%'";
        i++;
      }
      if (eEnEnt_Record_Contract.getChLinkPhone() != null &&
          ! (eEnEnt_Record_Contract.getChLinkPhone() + "A").equals("A"))
      {
           if(i==0){
           sql = sql + " Ent_QuashOrder_Cord.chLinkPhone like '%" + eEnEnt_Record_Contract.getChLinkPhone().trim() + "%'";
           i++;
           }else{
           sql = sql + " and Ent_QuashOrder_Cord.chLinkPhone like '%" + eEnEnt_Record_Contract.getChLinkPhone().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_QuashOrder_Cord.chTradeTime >= TO_DATE('" + startTime.trim() + "','yyyy-MM-dd')";
                  i++;
          }else{
                  sql = sql + " and Ent_QuashOrder_Cord.chTradeTime >= TO_DATE('" + startTime.trim() + "','yyyy-MM-dd')";
          }
        }

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

      return sql;
  }

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


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

      return eEnt_PhoneOrder_Cord;
  }
  
  
}