daolinkman.java

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

package GDPE.customer.linkman;

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

	public static EnENT_CUSTOMER_LINKMAN[] searcheEnLinkMan(DbAccess db,
			EnENT_CUSTOMER_LINKMAN SearchEnLinkMan) throws Exception {
		String eEnENT_CUSTOMER_LINKMAN = "";

		if ((SearchEnLinkMan.getCHHOME_TEL() != null && SearchEnLinkMan
				.getCHHOME_TEL().length() != 0)
				|| (SearchEnLinkMan.getChName() != null && SearchEnLinkMan
						.getChName().length() != 0)
				||(SearchEnLinkMan.getChStationCode() != null && SearchEnLinkMan.getChStationCode().length() != 0)
				|| (SearchEnLinkMan.getCHPOSITION() != null && SearchEnLinkMan
						.getCHPOSITION().length() != 0)) {
			eEnENT_CUSTOMER_LINKMAN = "(select * from ENT_CUSTOMER_LINKMAN where "
					+ GDPE.customer.linkman.DAOLinkMan
							.searchSql(SearchEnLinkMan)
					+ ") ENT_CUSTOMER_LINKMAN ";
			//System.out.println("0000000000000000000"+SearchEnContract.getChEnterpriseName());
		} else {

			eEnENT_CUSTOMER_LINKMAN = "ENT_CUSTOMER_LINKMAN";
		}

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

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

		//System.out.println("sq-------------------------" + sql);
		EnENT_CUSTOMER_LINKMAN[] aEnENT_CUSTOMER_LINKMAN = null;
		aEnENT_CUSTOMER_LINKMAN = DAOLinkMan.SetEnLinkMan(db, sql);
		return (aEnENT_CUSTOMER_LINKMAN);
	}  

	public static String searchSql(
			EnENT_CUSTOMER_LINKMAN eEnENT_CUSTOMER_LINKMAN) {
		String sql = "";
		//System.out.println("++++++++++++++++++"+eEnENT_CUSTOMER_LINKMAN.getCHHOME_TEL());
		int i = 0;
		if (eEnENT_CUSTOMER_LINKMAN.getChName() != null
				&& !(eEnENT_CUSTOMER_LINKMAN.getChName() + "A")
						.equals("A")) {
			if (i == 0) {
				sql = sql
						+ " ENT_CUSTOMER_LINKMAN.CHName like '%"
						+ eEnENT_CUSTOMER_LINKMAN.getChName()
								.trim() + "%'";
				i++; 
			} else {    
				sql = sql
						+ " and ENT_CUSTOMER_LINKMAN.CHName like '%"
						+ eEnENT_CUSTOMER_LINKMAN.getChName()
								.trim() + "%'";
			}
		}
		if (eEnENT_CUSTOMER_LINKMAN.getCHHOME_TEL() != null
				&& !(eEnENT_CUSTOMER_LINKMAN.getCHHOME_TEL() + "A").equals("A")) {
			if (i == 0) {
				sql = sql
						+ " ENT_CUSTOMER_LINKMAN.CHHOME_TEL like '%"
						+ eEnENT_CUSTOMER_LINKMAN.getCHHOME_TEL().trim() + "%'";
				i++;
			} else {
				sql = sql
						+ " and ENT_CUSTOMER_LINKMAN.CHHOME_TELlike '%"
						+ eEnENT_CUSTOMER_LINKMAN.getCHHOME_TEL().trim() + "%'";
			}
		}
		if (eEnENT_CUSTOMER_LINKMAN.getCHPOSITION() != null
				&& !(eEnENT_CUSTOMER_LINKMAN.getCHPOSITION() + "A").equals("A")) {
			if (i == 0) {
				sql = sql + " ENT_CUSTOMER_LINKMAN.CHPOSITION like '%"
						+ eEnENT_CUSTOMER_LINKMAN.getCHPOSITION().trim() + "%'";
				i++;
			} else {
				sql = sql + " and ENT_CUSTOMER_LINKMAN.CHPOSITION like '%"
						+ eEnENT_CUSTOMER_LINKMAN.getCHPOSITION().trim() + "%'";
			}      
		}
		 if (eEnENT_CUSTOMER_LINKMAN.getChStationCode() != null &&
	              ! (eEnENT_CUSTOMER_LINKMAN.getChStationCode()  + "A").equals("A"))
	          {
	               if(i==0){
	               sql = sql + " ENT_CUSTOMER_LINKMAN.chStationCode like '%" + eEnENT_CUSTOMER_LINKMAN.getChStationCode().trim() + "%'";
	               i++;
	               }else{
	               sql = sql + " and ENT_CUSTOMER_LINKMAN.chStationCode like '%" + eEnENT_CUSTOMER_LINKMAN.getChStationCode().trim() + "%'";
	               }
	          }
		//String drt=eEnEnt_Record_Contract.getDtRecordTime();
		return sql;
	}
   
	public static String setDefaultSort() {
		String sql = "";
		sql = " order by ENT_CUSTOMER_LINKMAN.id";
		return sql;
	}

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

		return eEnENT_CUSTOMER_LINKMAN;     
	}

}