daocompetefriend.java.svn-base

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

package GDPE.compete.friend;

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

	public static EnEnt_Compete_Friend[] searcheEnFriend(DbAccess db,
			EnEnt_Compete_Friend SearchEnFriend) throws Exception {
		String eEnEnt_Compete_Friend = "";

		if ((SearchEnFriend.getId() != 0)
				|| (SearchEnFriend.getChCompete_Friend_Name() != null && SearchEnFriend
						.getChCompete_Friend_Name().length() != 0)
				|| (SearchEnFriend.getChCompete_Level() != null && SearchEnFriend
						.getChCompete_Level().length() != 0)
				|| (SearchEnFriend.getChTelephone() != null && SearchEnFriend
						.getChTelephone().length() != 0)) {
			eEnEnt_Compete_Friend = "(select * from Ent_Compete_Friend where "
					+ GDPE.compete.friend.DAOCompeteFriend
							.searchSql(SearchEnFriend) + ") Ent_Compete_Friend";
			//System.out.println("0000000000000000000"+SearchEnContract.getChEnterpriseName());
		} else {
			eEnEnt_Compete_Friend = "Ent_Compete_Friend";
		}

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

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

		System.out.println("sq-------------------------" + sql);
		EnEnt_Compete_Friend[] aEnEnt_Compete_Friend = null;
		aEnEnt_Compete_Friend = DAOCompeteFriend.SetEnCompeteFriend(db, sql);
		return (aEnEnt_Compete_Friend);
	}

	public static String searchSql(EnEnt_Compete_Friend eEnEnt_Compete_Friend) {
		String sql = "";
		int i = 0;
		if (eEnEnt_Compete_Friend.getId() != 0
				&& !(eEnEnt_Compete_Friend.getId() + "A").equals("A")) {
			sql = sql + "Ent_Compete_Friend.id="
					+ eEnEnt_Compete_Friend.getId();
			i++;
		}
		if (eEnEnt_Compete_Friend.getChCompete_Friend_Name() != null
				&& !(eEnEnt_Compete_Friend.getChCompete_Friend_Name() + "A")
						.equals("A")) {
			if (i == 0) {
				sql = sql
						+ " Ent_Compete_Friend.ChCompete_Friend_Name like '%"
						+ eEnEnt_Compete_Friend.getChCompete_Friend_Name()
								.trim() + "%'";
				i++;
			} else {
				sql = sql
						+ " and Ent_Compete_Friend.ChCompete_Friend_Name like '%"
						+ eEnEnt_Compete_Friend.getChCompete_Friend_Name()
								.trim() + "%'";
			}
		}
		if (eEnEnt_Compete_Friend.getChCompete_Level() != null
				&& !(eEnEnt_Compete_Friend.getChCompete_Level() + "A")
						.equals("A")) {
			if (i == 0) {
				sql = sql + " Ent_Compete_Friend.chCompete_Level like '%"
						+ eEnEnt_Compete_Friend.getChCompete_Level().trim()
						+ "%'";
				i++;
			} else {
				sql = sql + " and Ent_Compete_Friend.chCompete_Level like '%"
						+ eEnEnt_Compete_Friend.getChCompete_Level().trim()
						+ "%'";
			}
		}
		//String drt=eEnEnt_Record_Contract.getDtRecordTime();
		if (eEnEnt_Compete_Friend.getChTelephone() != null
				&& !(eEnEnt_Compete_Friend.getChTelephone() + "A").equals("A")) {
			if (i == 0) { //TO_DATE('01-01-2000','dd-mm-yyyy');
				sql = sql + " Ent_Compete_Friend.chTelephone like '%"
						+ eEnEnt_Compete_Friend.getChTelephone().trim() + "%'";
				i++;
			} else {
				sql = sql + " and Ent_Compete_Friend.chTelephone like '%"
						+ eEnEnt_Compete_Friend.getChTelephone().trim() + "%'";
			}
		}
		return sql;
	}

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

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

		return aEnEnt_Compete_Friend;
	}

}