company.java

使用java写的ERP系统,功能比较全

package sys.dao.bean;

import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.util.ArrayList;
import java.util.List;

import sys.dao.ConnectManager;

public class Company implements java.io.Serializable
{
	private static final long serialVersionUID = -4579662514420302269L;
	//公司ID
	private Integer companyid;
	//公司关键字
	private String namekeywords;
	//公司名
	private String nameparticular;
	//所在城市ID
	private Integer districtid;
	//所在城市
	private District district = null;
	//公司地址ַ
	private String companyaddress;
	//公司类型:按业务员拜访分类,一共分A,B,C,D,E
	private String type;
	//公司网址ַ
	private String neturl;
	//公司等级:A无意向,B未拜访,C已拜访,D已签单,E已收费,F大客户
	private String companytype;
	//公司所在库:A库,B库,C库公共库,D服务库
	private String companystate;
	//添加日期
	private Date adddate;
	//加入A库日期
	private Date indate;
	//公司简介
	private String companynarrate;
	//所属业务员ID
	private Integer personnelid;
	//所属业务员
	private Personnel personnel = null;
	//等待接受的业务员ID
	private Integer accepterid;
	//等待接受的业务员
	private Personnel accepter = null;
	//最后拜访日期
	private Date lastvisitdate;
	//拜访次数
	private Integer visitcount;
	//所在行业ID
	private Integer industryid;
	//所在行业
	private Industry industry = null;
	//最后拜访人的ID
	private Integer lastPersonnelid;
	//最后拜访人
	private Personnel lastPersonnel = null;
	//添加人的ID
	private Integer addPersonnelid;
	//添加人
	private Personnel addPersonnel = null;
	//这公司的预定过的记录
	private List<DestineNote> destineNote = null;
	//所有联系人
	private List<Linkman> linkmans = null;
	//所有拜访记录
	private List<Visit> visits = null;
	
	public Integer getAccepterid()
	{
		return accepterid;
	}
	public void setAccepterid(Integer accepterid)
	{
		this.accepterid = accepterid;
	}
	public Date getAdddate()
	{
		return adddate;
	}
	public void setAdddate(Date adddate)
	{
		this.adddate = adddate;
	}
	public String getCompanyaddress()
	{
		return companyaddress;
	}
	public void setCompanyaddress(String companyaddress)
	{
		this.companyaddress = companyaddress;
	}
	public Integer getCompanyid()
	{
		return companyid;
	}
	public void setCompanyid(Integer companyid)
	{
		this.companyid = companyid;
	}
	public String getCompanynarrate()
	{
		return companynarrate;
	}
	public void setCompanynarrate(String companynarrate)
	{
		this.companynarrate = companynarrate;
	}
	public String getCompanystate()
	{
		return companystate;
	}
	public void setCompanystate(String companystate)
	{
		this.companystate = companystate;
	}
	public String getCompanytype()
	{
		return companytype;
	}
	public void setCompanytype(String companytype)
	{
		this.companytype = companytype;
	}
	public Integer getDistrictid()
	{
		return districtid;
	}
	public void setDistrictid(Integer districtid)
	{
		this.districtid = districtid;
	}
	public Date getIndate()
	{
		return indate;
	}
	public void setIndate(Date indate)
	{
		this.indate = indate;
	}
	public Integer getIndustryid()
	{
		return industryid;
	}
	public void setIndustryid(Integer industryid)
	{
		this.industryid = industryid;
	}
	public Integer getLastPersonnelid()
	{
		return lastPersonnelid;
	}
	public void setLastPersonnelid(Integer lastPersonnelid)
	{
		this.lastPersonnelid = lastPersonnelid;
	}
	public Date getLastvisitdate()
	{
		return lastvisitdate;
	}
	public void setLastvisitdate(Date lastvisitdate)
	{
		this.lastvisitdate = lastvisitdate;
	}
	public List<Linkman> getLinkmans()
	{
		if (linkmans==null)
		{
			ResultSet rs = null;
			String sql = "select * from linkman where companyid = " + this.companyid;
			ConnectManager cm = ConnectManager.newInstance();
			if (cm.getConnection())
			{
				rs = cm.executeQuery(sql);
				try
				{
					if (rs.next())
					{
						linkmans = new ArrayList<Linkman>();
						do
						{
							Linkman linkman = new Linkman();
							linkman.setLinkmanid(rs.getInt("linkmanid"));
							linkman.setLinkmanname(rs.getString("linkmanname"));
							linkman.setLinkmanemail(rs.getString("linkmanemail"));
							linkman.setLinkmanphone(rs.getString("linkmanphone"));
							linkman.setLinkmanmoblie(rs.getString("linkmanmoblie"));
							linkman.setCompanyid(rs.getInt("companyid"));
							linkman.setJob(rs.getString("job"));
							linkman.setAdddate(rs.getDate("adddate"));
							linkmans.add(linkman);
						} while (rs.next());
					}
					rs.close();
				} 
				catch (SQLException e)
				{
					e.printStackTrace();
				}
				finally
				{
					cm.close();
				}
			}
		}
		return linkmans;
	}
	public void setLinkmans(List<Linkman> linkmans)
	{
		this.linkmans = linkmans;
	}
	public String getNamekeywords()
	{
		return namekeywords;
	}
	public void setNamekeywords(String namekeywords)
	{
		this.namekeywords = namekeywords;
	}
	public String getNameparticular()
	{
		return nameparticular;
	}
	public void setNameparticular(String nameparticular)
	{
		this.nameparticular = nameparticular;
	}
	public String getNeturl()
	{
		return neturl;
	}
	public void setNeturl(String neturl)
	{
		this.neturl = neturl;
	}
	public Integer getPersonnelid()
	{
		return personnelid;
	}
	public void setPersonnelid(Integer personnelid)
	{
		this.personnelid = personnelid;
	}
	public String getType()
	{
		return type;
	}
	public void setType(String type)
	{
		this.type = type;
	}
	public Integer getVisitcount()
	{
		return visitcount;
	}
	public void setVisitcount(Integer visitcount)
	{
		this.visitcount = visitcount;
	}
	public List<Visit> getVisits()
	{
		if (visits==null)
		{
			ResultSet rs = null;
			String sql = "select * from visit where companyid = " + this.companyid;
			ConnectManager cm = ConnectManager.newInstance();
			if (cm.getConnection())
			{
				try
				{
					rs = cm.executeQuery(sql);
					if (rs.next())
					{
						visits = new ArrayList<Visit>();
						do
						{
							Visit visit = new Visit();
							visit.setVisitid(rs.getInt("visitid"));
							visit.setVisittype(rs.getString("visittype"));
							visit.setVisittime(rs.getDate("visittime"));
							visit.setLinkmanid(rs.getInt("linkmanid"));
							visit.setPersonnelid(rs.getInt("personnelid"));
							visit.setCompanyid(rs.getInt("companyid"));
							visit.setVisitlog(rs.getString("visitlog"));
							visits.add(visit);
						} while (rs.next());
					}
					rs.close();
				}
				catch (Exception e)
				{
					e.printStackTrace();
				}
				finally
				{
					cm.close();
				}
			}
		}
		return visits;
	}
	public void setVisits(List<Visit> visits)
	{
		this.visits = visits;
	}
	public void setDistrict(District district)
	{
		this.district = district;
	}
	public District getDistrict()
	{
		if (this.district==null)
		{
			ResultSet rs = null;
			String sql = "select * from district where districtid = " + this.districtid;
			ConnectManager cm = ConnectManager.newInstance();
			if (cm.getConnection())
			{
				try
				{
					rs = cm.executeQuery(sql);
					if (rs.next())
					{
						this.district = new District();
						this.district.setDistrictid(rs.getInt("districtid"));
						this.district.setSuperiorid(rs.getInt("superiorid"));
						this.district.setDistrict(rs.getString("district"));
					}
					rs.close();
				}
				catch (Exception e)
				{
					e.printStackTrace();
				}
				finally
				{
					cm.close();
				}
			}
		}
		return district;
	}
	public Personnel getAccepter()
	{
		if (this.accepter==null)
		{
			ResultSet rs = null;
			String sql = "select * from personnel where personnelid = " + this.accepterid;
			ConnectManager cm = ConnectManager.newInstance();
			if (cm.getConnection())
			{
				try
				{
					rs = cm.executeQuery(sql);
					if (rs.next())
					{
						accepter = new Personnel();
						accepter.setPersonnelid(rs.getInt("personnelid"));
						accepter.setRealname(rs.getString("realname"));
						accepter.setDeptid(rs.getInt("deptid"));
						accepter.setPositionid(rs.getInt("positionid"));
						accepter.setJobid(rs.getString("jobid"));
						accepter.setSex(rs.getByte("sex"));
						accepter.setBirthday(rs.getDate("birthday"));
						accepter.setNation(rs.getString("native"));
						accepter.setNation(rs.getString("nation"));
						accepter.setPolity(rs.getString("polity"));
						accepter.setWedlock(rs.getByte("wedlock"));
						accepter.setIdcardno(rs.getString("idcardno"));
						accepter.setIdcardaddress(rs.getString("idcardaddress"));