daopersonal.java

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

package GDPE.customer.personal;

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

	public static EnENT_CUSTOMER_PERSONAL[] searcheEnPersonal(DbAccess db,
			EnENT_CUSTOMER_PERSONAL SearchEnPersonal) throws Exception {
		String eENT_CUSTOMER_PERSONAL = "";

		if ((SearchEnPersonal.getChBusiness_TEL() != null && SearchEnPersonal.getChBusiness_TEL().length() != 0)
		 || (SearchEnPersonal.getChSeat_Code() != null && SearchEnPersonal.getChSeat_Code().length() != 0)
		 || (SearchEnPersonal.getChCommit_Name() != null && SearchEnPersonal.getChCommit_Name().length() != 0)
		 || (SearchEnPersonal.getChTrade_Type()!=null && SearchEnPersonal.getChTrade_Type().length()!= 0 )
		 || (SearchEnPersonal.getChName()!=null && SearchEnPersonal.getChName().length()!= 0 )
		 || (SearchEnPersonal.getChEnterpriseCityName()!=null && SearchEnPersonal.getChEnterpriseCityName().length()!= 0)) {
			eENT_CUSTOMER_PERSONAL = "(select * from ENT_CUSTOMER_PERSONAL where "
					+ GDPE.customer.personal.DAOPersonal
							.searchSql(SearchEnPersonal)
					+ ") ENT_CUSTOMER_PERSONAL ";
			//System.out.println("0000000000000000000"+SearchEnContract.getChEnterpriseName());
		} else {

			eENT_CUSTOMER_PERSONAL = "ENT_CUSTOMER_PERSONAL";
		}

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

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

		//System.out.println("sq-------------------------" + sql);
		EnENT_CUSTOMER_PERSONAL[] aENT_CUSTOMER_PERSONAL = null;
		aENT_CUSTOMER_PERSONAL = DAOPersonal.SetEnPersonal(db, sql);
		return (aENT_CUSTOMER_PERSONAL);
	}  

	public static String searchSql(
			EnENT_CUSTOMER_PERSONAL eENT_CUSTOMER_PERSONAL) {
		String sql = "";
		//System.out.println("++++++++++++++++++"+eENT_CUSTOMER_PERSONAL.getChBusiness_TEL());
		int i = 0;
		if (eENT_CUSTOMER_PERSONAL.getChBusiness_TEL() != null
				&& !(eENT_CUSTOMER_PERSONAL.getChBusiness_TEL() + "A").equals("A")) {
			if (i == 0) {
				sql = sql
						+ "ENT_CUSTOMER_PERSONAL.chBusiness_TEL like '%"
						+ eENT_CUSTOMER_PERSONAL.getChBusiness_TEL().trim() + "%'";
				i++; 
			} else {    
				sql = sql
						+ " and ENT_CUSTOMER_PERSONAL.chBusiness_TEL like '%"
						+ eENT_CUSTOMER_PERSONAL.getChBusiness_TEL().trim() + "%'";
			}
		}
		if (eENT_CUSTOMER_PERSONAL.getChSeat_Code() != null
				&& !(eENT_CUSTOMER_PERSONAL.getChSeat_Code() + "A").equals("A")) {
			if (i == 0) {
				sql = sql
						+ " ENT_CUSTOMER_PERSONAL.chSeat_Code like '%"
						+ eENT_CUSTOMER_PERSONAL.getChSeat_Code().trim() + "%'";
				i++;
			} else {
				sql = sql
						+ " and ENT_CUSTOMER_PERSONAL.chSeat_Code like '%"
						+ eENT_CUSTOMER_PERSONAL.getChSeat_Code().trim() + "%'";
			}
		} 
		if (eENT_CUSTOMER_PERSONAL.getChEnterpriseCityName() != null
				&& !(eENT_CUSTOMER_PERSONAL.getChEnterpriseCityName() + "A").equals("A")) {
			if (i == 0) {
				sql = sql
						+ " ENT_CUSTOMER_PERSONAL.chLogin_Station_Name like '%"
						+ eENT_CUSTOMER_PERSONAL.getChEnterpriseCityName().trim() + "%'";
				i++;
			} else {
				sql = sql
						+ " and ENT_CUSTOMER_PERSONAL.chLogin_Station_Name like '%"
						+ eENT_CUSTOMER_PERSONAL.getChEnterpriseCityName().trim() + "%'";
			}
		}
		if (eENT_CUSTOMER_PERSONAL.getChTrade_Type() != null
				&& !(eENT_CUSTOMER_PERSONAL.getChTrade_Type() + "A").equals("A")) {
			if (i == 0) {
				sql = sql
						+ " ENT_CUSTOMER_PERSONAL.chTrade_Type like '%"
						+ eENT_CUSTOMER_PERSONAL.getChTrade_Type().trim() + "%'";
				i++;
			} else {
				sql = sql
						+ " and ENT_CUSTOMER_PERSONAL.chTrade_Type like '%"
						+ eENT_CUSTOMER_PERSONAL.getChTrade_Type().trim() + "%'";
			}
		}
		if (eENT_CUSTOMER_PERSONAL.getChName() != null
				&& !(eENT_CUSTOMER_PERSONAL.getChName() + "A").equals("A")) {
			if (i == 0) {
				sql = sql
						+ " ENT_CUSTOMER_PERSONAL.chName like '%"
						+ eENT_CUSTOMER_PERSONAL.getChName().trim() + "%'";
				i++;
			} else {
				sql = sql
						+ " and ENT_CUSTOMER_PERSONAL.chName like '%"
						+ eENT_CUSTOMER_PERSONAL.getChName().trim() + "%'";
			}
		}
		if (eENT_CUSTOMER_PERSONAL.getChCommit_Name() != null
				&& !(eENT_CUSTOMER_PERSONAL.getChCommit_Name() + "A").equals("A")) {
			if (i == 0) {
				sql = sql
						+ " ENT_CUSTOMER_PERSONAL.chCommit_Name like '%"
						+ eENT_CUSTOMER_PERSONAL.getChCommit_Name().trim() + "%'";
				i++;
			} else {
				sql = sql
						+ " and ENT_CUSTOMER_PERSONAL.chCommit_Name like '%"
						+ eENT_CUSTOMER_PERSONAL.getChCommit_Name().trim() + "%'";
			}
		}		
		//String drt=eEnEnt_Record_Contract.getDtRecordTime();
		return sql;
	}
   
	public static String setDefaultSort() {
		String sql = "";
		sql = " order by ENT_CUSTOMER_PERSONAL.id";
		return sql;
	}

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

		return eENT_CUSTOMER_PERSONAL;     
	}

}