agentuserinfo.java

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

/**
 * 业务员详细信息
 */
package com.NCL;

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

public class AgentUserInfo{

	protected IndexMap propList;
	protected HashSet Property;
	private List strList = new ArrayList();
	private boolean EOF = false;
	private int COUNT;
	
	/**
	 * 在此映射中关联指定值与指定键
	 * @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();
	}
	/**
	 * 构造函数
	 *
	 */
	public AgentUserInfo(){
		propList=new IndexMap();
		Property=new HashSet();
		Property.add("AgentName");			//代理人姓名;
		Property.add("AgentUnit");			//所属分公司---管理机构;
		Property.add("AgentSex");			//性别;
		Property.add("AgentFolk");			//民族
		Property.add("AgentBirthday");		//出生年月;
		Property.add("AgentTeleNum");		//电话;
		Property.add("AgentMobileNum");		//手机;
		Property.add("AgentMailBox");		//邮箱;
		Property.add("AgentPostCode");		//邮编;
		Property.add("AgentContactAddress");//联系地址;
		Property.add("AgentJob");			//业务员职位o--级别;
		Property.add("AgentMaxim");			//座右铭
		Property.add("AgentStartDate");		//从业时间起始
		Property.add("AgentThisDate");		//从业时间至今
		Property.add("AgentBrief");			//个人简介
		Property.add("AgentCyclostyle");	//选用模板
		Property.add("AgentHeadPort");		//上传头像
		Property.add("AgentAvailability");	//可用状态
		Property.add("AgentNumber");		//业务员编码--agentCode
		Property.add("AgentPicLength");		//头像长度
		Property.add("AgentPicWidth");		//头像宽度
	}
	/**
	 * 初始化
	 * @param AgentNumber 业务员编码
	 */
	public void init(String AgentNumber){
		DBAccess d  = new DBAccess();
		String sql = "SELECT * from AgentUserInfo where AgentNumber=?";
		this.propList = d.init(sql,AgentNumber,this.Property);		
	}
	/**
	 * 根据条件查询业务员信息
	 * @param agui 对象
	 * @param pageSize 分页大小
	 * @param pageIndex 分页页码
	 * @return String
	 */
	public String find(AgentUserInfo agui,int pageSize,int pageIndex){
		String result = "";
		StringBuffer SQL = new StringBuffer("select AgentNumber from AgentUserInfo where 1=1");
		String agentNumber = agui.get("AgentNumber");
		String agentUnit = agui.get("AgentUnit");
		String agentSex = agui.get("AgentSex");
		String agentStartDate = agui.get("AgentStartDate");
		String agentThisDate = agui.get("AgentThisDate");
		String agentName = agui.get("AgentName");
		if(Data.hasValue(agentNumber))
			SQL.append(" and agentNumber=?");
		if(Data.hasValue(agentUnit))
			SQL.append(" and agentUnit like ?");
		if(Data.hasValue(agentName))
			SQL.append(" and agentName like ?");
		if(Data.hasValue(agentSex))
			SQL.append(" and agentSex=?");
		if(Data.hasValue(agentStartDate))
			SQL.append(" and agentStartDate>=to_date(?,'YYYY-MM-DD')");
		if(Data.hasValue(agentThisDate))
			SQL.append(" and agentThisDate<=to_date(?,'YYYY-MM-DD')");
		DBAccess d  = new DBAccess();
		result = d.executeQuery(SQL.toString(),agui.propList,pageSize,pageIndex);
		setCOUNT(d.COUNT);
		setEOF(d.EOF);
		return result;		
	}
	/**
	 * 根据条件查询已开通的业务员
	 * @param agui 对象
	 * @param pageSize 分页大小
	 * @param pageIndex 分页页码
	 * @return
	 */
	public String findAgentPro(AgentUserInfo agui,int pageSize,int pageIndex){
		String result = "";
		StringBuffer SQL = new StringBuffer("select AgentNumber from agentuserinfo a,Agent b where a.AgentNumber=b.agentcode and b.agentstatic='1' ");
		String agentNumber = agui.get("AgentNumber");
		String agentUnit = agui.get("AgentUnit");
		String agentSex = agui.get("AgentSex");
		String agentStartDate = agui.get("AgentStartDate");
		String agentThisDate = agui.get("AgentThisDate");
		String agentName = agui.get("AgentName");
		if(Data.hasValue(agentNumber))
			SQL.append(" and agentNumber=?");
		if(Data.hasValue(agentUnit))
			SQL.append(" and agentUnit like ?");
		if(Data.hasValue(agentName))
			SQL.append(" and agentName like ?");
		if(Data.hasValue(agentSex))
			SQL.append(" and agentSex= ?");
		if(Data.hasValue(agentStartDate))
			SQL.append(" and agentStartDate>=to_date(?,'YYYY-MM-DD')");
		if(Data.hasValue(agentThisDate))
			SQL.append(" and agentThisDate<=to_date(?,'YYYY-MM-DD')");
		SQL.append("order by b.comcode,b.starlevel desc,b.name");
		DBAccess d  = new DBAccess();
		result = d.executeQuery(SQL.toString(),agui.propList,pageSize,pageIndex);
		setCOUNT(d.COUNT);
		setEOF(d.EOF);
		return result;		
	}
	/**
	 * 更新业务员
	 * @return boolean
	 */
	public boolean update(){
		try{
			StringBuffer sql = new StringBuffer("update AgentUserInfo 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 AgentNumber=?");
			l.add(this.get("AgentNumber"));
			strList.clear();
			DBAccess q = new DBAccess();
			return q.executeUpdate(sql.toString(),l);
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("AgentUserInfo.update():" + e.getMessage());
			return false;
		}
		
	}
	/**
	 * 创建业务员
	 * @param messageID 业务员号
	 * @return boolean
	 */
	public boolean createAgentToAgentInfo(String messageID) {
		
		List list = new ArrayList();
		try{
		StringBuffer sql = new StringBuffer("insert into agentuserinfo(" +
													"agentnumber,agentname,agentunit,agentsex," +
													"agentbirthday,agenttelenum,agentmobilenum,agentmailbox," +
													"agentpostcode,agentcontactaddress,agentjob) " + 
											"select * from (" +
												"select " +
														"agentCode,name,comcode,decode((sex),'女','1','男','0')," +
														"birthday,phone,mobile,email," +
														"zipcode,homeaddress,agentgrade " +
												"from agent where agentCode in (");
		String[] messageIDArr = messageID.split(",");
		for(int i = 0; i < messageIDArr.length; i++) {
			sql.append("?,");
			list.add(messageIDArr[i]);
		}
		sql.deleteCharAt(sql.lastIndexOf(","));
		sql.append(")) ss where ss.agentcode not in (select tt.agentnumber from agentuserinfo tt where tt.agentnumber in (");
		for(int i = 0; i < messageIDArr.length; i++) {
			sql.append("?,");
			list.add(messageIDArr[i]);
		}
		sql.deleteCharAt(sql.lastIndexOf(","));
		sql.append("))");
		DBAccess d = new DBAccess();
		return d.executeUpdate(sql.toString(),list);
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("createAgentToAgentInfo():" + e.getMessage());
			return false;
		}
	}
	/**
	 * 删除业务员
	 * @param AgentNumber 业务员编码
	 * @return boolean
	 */
	public boolean delete(String AgentNumber){
		String SQL = "DELETE from AgentUserInfo WHERE AgentNumber=?";	
		DBAccess DBA = new DBAccess();
		return DBA.executeDelete(SQL.toString(), AgentNumber);
	}
	
	public static void main(String[] sg){
	}	
}