relation.java

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

/**
 * 分公司管理员联系列表
 */
package com.NCL;

import com.sinosoft.common.*;
import java.util.*;

public class Relation{
	protected IndexMap propList;	
	protected HashSet Property;
	private List strList = new ArrayList();
	private String errorStr = "";      
	private boolean EOF = false;
	private int COUNT;
	/**
	 * 构造函数
	 *
	 */
	public Relation(){
		propList=new IndexMap();
		Property=new HashSet();
		Property.add("ID");					//自增长ID
		Property.add("ComName");			//分公司名称		
		Property.add("BranchName");			//支公司名称
		Property.add("RelationName");		//联系人名字	
		Property.add("Department");			//部门
		Property.add("Telephone");	    	//电话
		Property.add("Fax");				//传真
		Property.add("Email");  			//电子邮箱
		Property.add("Service");			//所属营销服务部
	}
	/**
	 * 设置errorStr
	 * @param tmp 信息
	 */
	public void setErrorStr(String tmp){
		errorStr = tmp;
	}
	/**
	 * 获取errorStr
	 * @return String
	 */
	public String getErrorStr(){
		return errorStr;
	}
	
	/**
	 * 在此映射中关联指定值与指定键
	 * @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 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 ID	自增长ID
	 */
	public void init(String ID){
		DBAccess d  = new DBAccess();
		String sql = "SELECT * from Relation where ID=?";
		this.propList = d.init(sql,ID,this.Property);	
	}
	
	/**
	 * 创建
	 * @return	boolean
	 */
	public boolean create(){
		String sql = "INSERT into Relation values (RelationID_SQE.nextval,?,?,?,?,?,?,?,?)";
		DBAccess d  = new DBAccess();
		return d.execute(sql,this.propList);
	}
	
	/**
	 * 删除
	 * @param ID	自增长ID
	 * @return boolean
	 */
	public boolean delete(String ID){
		DBAccess d= new DBAccess();
		String sql = "DELETE from Relation WHERE ID=?";		
		return d.executeDelete(sql,ID);
	}
	
	/**
	 * 更新
	 * @return boolean
	 */
	public boolean update(){
		StringBuffer sql = new StringBuffer("update Relation set ");
		List l = new ArrayList();
		for(int i=0;i<strList.size();i++){
			Object[] strArray =(Object[]) strList.get(i);
			sql.append(strArray[0]);
			sql.append("=?,");
			l.add(strArray[1]);
		}
		sql.deleteCharAt(sql.lastIndexOf(","));
		sql.append(" where ID=?");
		l.add(this.get("ID"));
		strList.clear();
		DBAccess d = new DBAccess();
		return d.executeUpdate(sql.toString(),l);
	}
	
	/**
	 * 根据条件查询
	 * @param cm		对象
	 * @param pageSize	分页大小
	 * @param pageIndex	分页页码
	 * @return	String
	 */
	public String find(Relation cm,int pageSize,int pageIndex){
		String ComName = cm.get("ComName");
		String BranchName = cm.get("BranchName");
		String RelationName = cm.get("RelationName");
		String Department = cm.get("Department");
		String Telephone = cm.get("Telephone");
		String Fax = cm.get("Fax");
		String Email = cm.get("Email");
		String Service = cm.get("Service");
		StringBuffer SQL = new StringBuffer("SELECT ID from Relation where 1=1");
		if(Data.hasValue(ComName))
			SQL.append(" and ComName=?");
		if(Data.hasValue(BranchName))
			SQL.append(" and BranchName=?");
		if(Data.hasValue(RelationName))
			SQL.append(" and RelationName=?");
		if(Data.hasValue(Department))
			SQL.append(" and Department=?");
		if(Data.hasValue(Telephone))
			SQL.append(" and Telephone=?");
		if(Data.hasValue(Fax))
			SQL.append(" and Fax=?");
		if(Data.hasValue(Email))
			SQL.append(" and Email=?");
		if(Data.hasValue(Service))
			SQL.append(" and Service=?");
		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;	
	}
	
	/**
	 * 批量执行
	 * @param l		对象
	 * @param flag	操作类型
	 * @return boolean
	 */
	public boolean batchExecute(List l,String flag){
		String sql = "";
		DBAccess d  = new DBAccess();
		if("create".equals(flag))sql = "INSERT into Relation values (RelationID_SQE.nextval,?,?,?,?,?,?,?,?)";
		else if("delete".equals(flag))sql = "DELETE from Relation WHERE ID=?";
		else if("update".equals(flag))sql = "UPDATE Relation set comname=?,branchname=?,relationname=?,department=?,telephone=?,fax=?,email=?,Service=? WHERE ID=?";
		else return false;
		return d.mulExecute(sql, l);
	}
	
	/**
	 * 获取支公司下拉列表html代码
	 * @param ComName 分公司名称
	 * @return String
	 */
	public String getBranchName(String ComName){
		String str = "";
		String sql = "select BranchName from Relation where ComName=? order by ID desc";
		DBAccess d = new DBAccess();
		List l = new ArrayList();
		l.add(ComName);
		l = d.parseSQL(sql,l);
		if(l==null)return str;
		for(int i=0;i<l.size();i++){
			str += "<option value='"+l.get(i).toString().trim()+"'>"+l.get(i).toString().trim()+"</option>\n";
		}
		return str;
	}
	
	/**
	 * 获取分公司管理员信息
	 * @param ComName
	 * @return
	 */
	public List getBranchInfo(String ComName){
		String sql = "select * from Relation where ComName=? order by ID desc";
		DBAccess d = new DBAccess();
		List l = new ArrayList();
		l.add(ComName);
		return d.mulparseSQL(sql, l);
	}
}