daoactivity.java.svn-base

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

package GDPE.market.activity;

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

	public static EnENT_MARKET_ACTIVITY[] searcheEnActivity(DbAccess db,
			EnENT_MARKET_ACTIVITY SearchEnActivity) throws Exception {
		String eEnENT_MARKET_ACTIVITY = "";

		if ((SearchEnActivity.getChActivity_Title() != null && SearchEnActivity
				.getChActivity_Title().length() != 0)
				|| (SearchEnActivity.getChReceive_Name() != null && SearchEnActivity
						.getChReceive_Name().length() != 0)
				|| (SearchEnActivity.getChCharge_Man() != null && SearchEnActivity
						.getChCharge_Man().length() != 0)) {
			eEnENT_MARKET_ACTIVITY = "(select * from ENT_MARKET_ACTIVITY where "
					+ GDPE.market.activity.DAOActivity
							.searchSql(SearchEnActivity)
					+ ") ENT_MARKET_ACTIVITY ";
			//System.out.println("0000000000000000000"+SearchEnContract.getChEnterpriseName());
		} else {

			eEnENT_MARKET_ACTIVITY = "ENT_MARKET_ACTIVITY";
		}

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

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

		System.out.println("sq-------------------------" + sql);
		EnENT_MARKET_ACTIVITY[] aEnENT_MARKET_ACTIVITY = null;
		aEnENT_MARKET_ACTIVITY = DAOActivity.SetEnActivity(db, sql);
		return (aEnENT_MARKET_ACTIVITY);
	}  

	public static String searchSql(
			EnENT_MARKET_ACTIVITY eEnENT_MARKET_ACTIVITY) {
		String sql = "";
		int i = 0;
		if (eEnENT_MARKET_ACTIVITY.getChCharge_Man() != null
				&& !(eEnENT_MARKET_ACTIVITY.getChCharge_Man() + "A")
						.equals("A")) {
			if (i == 0) {
				sql = sql
						+ " ENT_MARKET_ACTIVITY.chCharge_Man like '%"
						+ eEnENT_MARKET_ACTIVITY.getChCharge_Man()
								.trim() + "%'";
				i++; 
			} else {    
				sql = sql
						+ " and ENT_MARKET_ACTIVITY.chCharge_Man like '%"
						+ eEnENT_MARKET_ACTIVITY.getChCharge_Man()
								.trim() + "%'";
			} 
		}
		if (eEnENT_MARKET_ACTIVITY.getChReceive_Name() != null
				&& !(eEnENT_MARKET_ACTIVITY.getChReceive_Name() + "A").equals("A")) {
			if (i == 0) {
				sql = sql
						+ " ENT_MARKET_ACTIVITY.chReceive_Name like '%"
						+ eEnENT_MARKET_ACTIVITY.getChReceive_Name().trim() + "%'";
				i++;
			} else {  
				sql = sql
						+ " and ENT_MARKET_ACTIVITY.chReceive_Name like '%"
						+ eEnENT_MARKET_ACTIVITY.getChReceive_Name().trim() + "%'";
			}
		}
		if (eEnENT_MARKET_ACTIVITY.getChActivity_Title() != null
				&& !(eEnENT_MARKET_ACTIVITY.getChActivity_Title() + "A").equals("A")) {
			if (i == 0) {
				sql = sql + " ENT_MARKET_ACTIVITY.chActivity_Title like '%"
						+ eEnENT_MARKET_ACTIVITY.getChActivity_Title().trim() + "%'";
				i++;
			} else {        
				sql = sql + " and ENT_MARKET_ACTIVITY.chActivity_Title like '%"
						+ eEnENT_MARKET_ACTIVITY.getChActivity_Title().trim() + "%'";
			}       
		}
		//String drt=eEnEnt_Record_Contract.getDtRecordTime();
		return sql;
	}
   
	public static String setDefaultSort() {
		String sql = "";
		sql = " order by ENT_MARKET_ACTIVITY.id";
		return sql; 
	}

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

		return eEnENT_MARKET_ACTIVITY;     
	}

}