daorequest.java.svn-base

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

package GDPE.customer.request;

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 DAORequest extends DAOBase {
	public DAORequest() {
	} 

	public static EnEnt_Customer_request[] searcheEnRequest(DbAccess db,
			EnEnt_Customer_request SearchEnRequest) throws Exception {
		String eEnEnt_Customer_request = "";

		if ((SearchEnRequest.getDtRequest_Time() != null && SearchEnRequest
				.getDtRequest_Time().length() != 0)
				|| (SearchEnRequest.getChCustomer_Linkman_Tele() != null && SearchEnRequest
						.getChCustomer_Linkman_Tele().length() != 0)
				|| (SearchEnRequest.getChRequest_Tile() != null && SearchEnRequest
						.getChRequest_Tile().length() != 0)) {
			eEnEnt_Customer_request = "(select * from Ent_Customer_request where "
					+ GDPE.customer.request.DAORequest
							.searchSql(SearchEnRequest)
					+ ") Ent_Customer_request ";
			//System.out.println("0000000000000000000"+SearchEnContract.getChEnterpriseName());
		} else {

			eEnEnt_Customer_request = "Ent_Customer_request";
		}

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

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

		//System.out.println("sq-------------------------" + sql);
		EnEnt_Customer_request[] aEnEnt_Customer_request = null;
		aEnEnt_Customer_request = DAORequest.SetEnRequest(db, sql);
		return (aEnEnt_Customer_request);
	}  

	public static String searchSql(
			EnEnt_Customer_request eEnEnt_Customer_request) {
		String sql = "";
		int i = 0;
		if (eEnEnt_Customer_request.getDtRequest_Time() != null
				&& !(eEnEnt_Customer_request.getDtRequest_Time() + "A")
						.equals("A")) {
			if (i == 0) {
				sql = sql
						+ " Ent_Customer_request.dtRequest_Time like '%"
						+ eEnEnt_Customer_request.getDtRequest_Time()
								.trim() + "%'";
				i++; 
			} else {    
				sql = sql
						+ " and Ent_Customer_request.dtRequest_Time like '%"
						+ eEnEnt_Customer_request.getDtRequest_Time()
								.trim() + "%'";
			}
		}
		if (eEnEnt_Customer_request.getChCustomer_Linkman_Tele() != null
				&& !(eEnEnt_Customer_request.getChCustomer_Linkman_Tele() + "A").equals("A")) {
			if (i == 0) {
				sql = sql
						+ " Ent_Customer_request.ChCustomer_Linkman_Tele like '%"
						+ eEnEnt_Customer_request.getChCustomer_Linkman_Tele().trim() + "%'";
				i++;
			} else {  
				sql = sql
						+ " and Ent_Customer_request.ChCustomer_Linkman_Tele like '%"
						+ eEnEnt_Customer_request.getChCustomer_Linkman_Tele().trim() + "%'";
			}
		}
		if (eEnEnt_Customer_request.getChRequest_Tile() != null
				&& !(eEnEnt_Customer_request.getChRequest_Tile() + "A").equals("A")) {
			if (i == 0) {
				sql = sql + " Ent_Customer_request.ChRequest_Tile like '%"
						+ eEnEnt_Customer_request.getChRequest_Tile().trim() + "%'";
				i++;
			} else {        
				sql = sql + " and Ent_Customer_request.ChRequest_Tile like '%"
						+ eEnEnt_Customer_request.getChRequest_Tile().trim() + "%'";
			}       
		}
		//String drt=eEnEnt_Record_Contract.getDtRecordTime();
		return sql;
	}
   
	public static String setDefaultSort() {
		String sql = "";
		sql = " order by Ent_Customer_request.id";
		return sql; 
	}

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

		return eEnEnt_Customer_request;     
	}

}