activemanage.java

java swing源码 欢迎下载 有问题请联系 我一定负责到底

/**
 * 活动管理
 */
package com.NCL;

import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import com.sinosoft.common.*;

public class ActiveManage{
	protected IndexMap propList;
	protected HashSet Property;
	private List strList = new ArrayList();
	private boolean EOF = false;
	private int COUNT;
	/**
	 * 构造函数
	 *
	 */
	public ActiveManage(){
		propList = new IndexMap();
		Property = new HashSet();
		Property.add("ID");				//自增长ID
		Property.add("ActiveName");		//活动名称
		Property.add("FinishDate");		//结束日期
		Property.add("Status");			//活动状态
	}
	/**
	 * 在此映射中关联指定值与指定键
	 * @param name 指定键
	 * @param value 指定值
	 */
	public boolean set(String name, Object value){
		if(Property.contains(name)){
			propList.put(name,value);
			return true;
		}else
			return false;		
	}
	/**
	 * 返回指定键在此映射中所映射的值
	 * @param name 指定键
	 * @return
	 */
	public String get(String name){
		if (Property.contains(name)){
			String value = (String)propList.get(name);
			if(value != null && !value.equals(""))
				return value;
			else
				return "";
		}else 
			return "";
	}
	/**
	 * 返回COUNT
	 * @return int
	 */
	public int getCOUNT() {
		return COUNT;
	}
	/**
	 * 设置COUNT
	 * @param count
	 */
	public void setCOUNT(int count) {
		COUNT = count;
	}
	/**
	 * 返回EOF
	 * @return boolean
	 */
	public boolean isEOF() {
		return EOF;
	}
	/**
	 * 设置EOF
	 * @param eof
	 */
	public void setEOF(boolean eof) {
		EOF = eof;
	}
	/**
	 * 清空propList
	 *
	 */
	public void clear(){
		propList.clear();
	}
	/**
	 * 在此映射中关联指定值与指定键
	 * @param name 指定键
	 * @param value 指定值
	 */
	public void setUpdateValue(String name,Object value){
		if(this.set(name,value)){
			Object[] uValue = new Object[2];
			uValue[0] = name;
			uValue[1] = value;
			strList.add(uValue);
		}
	}
	/**
	 * 初始化
	 * @param id 自增长ID
	 */
	public void init(String id){
		DBAccess d  = new DBAccess();
		String sql = "SELECT * from ActiveManage where id=?";
		this.propList = d.init(sql,id,this.Property);	
	}
	/**
	 * 创建
	 * @return boolean
	 */
	public boolean create(){
		String sql = "INSERT into ActiveManage values (ActiveManageID_SQE.nextval,?,to_date(?,'yyyy-MM-dd'),1)";
		DBAccess d  = new DBAccess();
		return d.execute(sql,this.propList);
	}
	
	/**
	 * 删除活动报名
	 * @param agentPhotoID 自增长ID
	 * @return
	 */
	public boolean delete(String agentPhotoID){
		DBAccess DBA= new DBAccess();
		String sql = "DELETE from ActiveManage WHERE id=?";		
		return DBA.executeDelete(sql,agentPhotoID);
	}
	/**
	 * 根据条件查询
	 * @param cm 对象
	 * @param pageSize 分页大小
	 * @param pageIndex 分页页码
	 * @return
	 */
	public String find(ActiveManage cm,int pageSize,int pageIndex){
		String ID = cm.get("ID");
		String Status = cm.get("Status");
		StringBuffer SQL = new StringBuffer("SELECT id from ActiveManage where 1=1");
		if(Data.hasValue(ID))
			SQL.append(" and ID=?");
		if(Data.hasValue(Status))
			SQL.append(" and Status=?");
		SQL.append(" order by ID desc");
		String result = "";
		DBAccess d  = new DBAccess();
		result = d.executeQuery(SQL.toString(),cm.propList,pageSize,pageIndex);
		setCOUNT(d.COUNT);
		setEOF(d.EOF);
		return result;	
	}
	
	/**
	 * 获取活动名称的html代码
	 * @return String
	 */
	public String getActiveCode(){
		String sql = "select ID,ActiveName from ActiveManage order by ID desc";
		DBAccess d = new DBAccess();
		List l = new ArrayList();
		l = d.parseSQL(sql,new ArrayList());
		String str = "";
		for(int i=0;i<l.size();i+=2){
			str += "<option value='"+l.get(i).toString().trim()+"'>"+l.get(i+1).toString().trim()+"</option>\n";
		}
		return str;
	}
	
	/**
	 * 批量关闭活动报名
	 * @param tmpID 活动ID
	 * @return boolean
	 */
	public boolean closeActive(String tmpID){
		if(tmpID.endsWith(","))
			tmpID = tmpID.substring(0,tmpID.length()-1);
		String[] ID = tmpID.split(",");
		if(ID.length<1)return false;
		List list = new ArrayList();
		String sql = "update ActiveManage set Status=0 where ID in (";
		for(int i=0;i<ID.length;i++){
			if(Data.hasValue(ID[i])){
				sql +="?,";
				list.add(ID[i]);
			}
		}
		sql = sql.substring(0,sql.length()-1);
		sql += ")";
		DBAccess db = new DBAccess();
		return db.executeUpdate(sql, list);
	}
	
	/**
	 * 批量开放活动报名
	 * @param tmpID 活动ID
	 * @return boolean
	 */
	public boolean openActive(String tmpID){
		if(tmpID.endsWith(","))
			tmpID = tmpID.substring(0,tmpID.length()-1);
		String[] ID = tmpID.split(",");
		if(ID.length<1)return false;
		List list = new ArrayList();
		String sql = "update ActiveManage set Status=1 where ID in (";
		for(int i=0;i<ID.length;i++){
			if(Data.hasValue(ID[i])){
				sql +="?,";
				list.add(ID[i]);
			}
		}
		sql = sql.substring(0,sql.length()-1);
		sql += ")";
		DBAccess db = new DBAccess();
		return db.executeUpdate(sql, list);
	}
	
	public static void main(String args[]){
	}
}