company.java

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

						accepter.setSocialinsuranceid(rs.getString("socialinsuranceid"));
						accepter.setFinishschool(rs.getString("finishschool"));
						accepter.setSpecialty(rs.getString("specialty"));
						accepter.setAcademic(rs.getString("academic"));
						accepter.setDwelling(rs.getString("dwelling"));
						accepter.setAdddate(rs.getDate("adddate"));
						accepter.setOutdate(rs.getDate("outdate"));
						accepter.setPassdate(rs.getDate("passdate"));
						accepter.setUsername(rs.getString("username"));
						accepter.setPassword(rs.getString("password"));
						accepter.setIslock(rs.getByte("islock"));
						accepter.setA(rs.getInt("A"));
						accepter.setB(rs.getInt("B"));
					}
					rs.close();
				}
				catch (Exception e)
				{
					e.printStackTrace();
				}
				finally
				{
					cm.close();
				}
			}
		}
		return accepter;
	}
	public void setAccepter(Personnel accepter)
	{
		this.accepter = accepter;
	}
	public Industry getIndustry()
	{
		if (this.industry==null)
		{
			ResultSet rs = null;
			String sql = "select * from industry where industryid = " + this.industryid;
			ConnectManager cm = ConnectManager.newInstance();
			if (cm.getConnection())
			{
				try
				{
					rs = cm.executeQuery(sql);
					if (rs.next())
					{
						industry = new Industry();
						industry.setIndustryid(rs.getInt("industryid"));
						industry.setIndustry(rs.getString("industry"));
						industry.setIslock(rs.getByte("islock"));
					}
					rs.close();
				}
				catch (Exception e)
				{
					e.printStackTrace();
				}
				finally
				{
					cm.close();
				}
			}
		}
		return industry;
	}
	public void setIndustry(Industry industry)
	{
		this.industry = industry;
	}
	public Personnel getLastPersonnel()
	{
		if (this.lastPersonnel==null)
		{
			ResultSet rs = null;
			String sql = "select * from personnel where personnelid = " + this.lastPersonnelid;
			ConnectManager cm = ConnectManager.newInstance();
			if (cm.getConnection())
			{
				try
				{
					rs = cm.executeQuery(sql);
					if (rs.next())
					{
						lastPersonnel = new Personnel();
						lastPersonnel.setPersonnelid(rs.getInt("personnelid"));
						lastPersonnel.setRealname(rs.getString("realname"));
						lastPersonnel.setDeptid(rs.getInt("deptid"));
						lastPersonnel.setPositionid(rs.getInt("positionid"));
						lastPersonnel.setJobid(rs.getString("jobid"));
						lastPersonnel.setSex(rs.getByte("sex"));
						lastPersonnel.setBirthday(rs.getDate("birthday"));
						lastPersonnel.setNation(rs.getString("native"));
						lastPersonnel.setNation(rs.getString("nation"));
						lastPersonnel.setPolity(rs.getString("polity"));
						lastPersonnel.setWedlock(rs.getByte("wedlock"));
						lastPersonnel.setIdcardno(rs.getString("idcardno"));
						lastPersonnel.setIdcardaddress(rs.getString("idcardaddress"));
						lastPersonnel.setSocialinsuranceid(rs.getString("socialinsuranceid"));
						lastPersonnel.setFinishschool(rs.getString("finishschool"));
						lastPersonnel.setSpecialty(rs.getString("specialty"));
						lastPersonnel.setAcademic(rs.getString("academic"));
						lastPersonnel.setDwelling(rs.getString("dwelling"));
						lastPersonnel.setAdddate(rs.getDate("adddate"));
						lastPersonnel.setOutdate(rs.getDate("outdate"));
						lastPersonnel.setPassdate(rs.getDate("passdate"));
						lastPersonnel.setUsername(rs.getString("username"));
						lastPersonnel.setPassword(rs.getString("password"));
						lastPersonnel.setIslock(rs.getByte("islock"));
						lastPersonnel.setA(rs.getInt("A"));
						lastPersonnel.setB(rs.getInt("B"));
						lastPersonnel.setBill_con(rs.getInt("bill_con"));
					}
					rs.close();
				}
				catch (Exception e)
				{
					e.printStackTrace();
				}
				finally
				{
					cm.close();
				}
			}
		}
		return lastPersonnel;
	}
	public void setLastPersonnel(Personnel lastPersonnel)
	{
		this.lastPersonnel = lastPersonnel;
	}
	public Personnel getPersonnel()
	{
		if (this.personnel==null)
		{
			ResultSet rs = null;
			String sql = "select * from personnel where personnelid = " + this.personnelid;;
			ConnectManager cm = ConnectManager.newInstance();
			if (cm.getConnection())
			{
				try
				{
					rs = cm.executeQuery(sql);
					if (rs.next())
					{
						personnel = new Personnel();
						personnel.setPersonnelid(rs.getInt("personnelid"));
						personnel.setRealname(rs.getString("realname"));
						personnel.setDeptid(rs.getInt("deptid"));
						personnel.setPositionid(rs.getInt("positionid"));
						personnel.setJobid(rs.getString("jobid"));
						personnel.setSex(rs.getByte("sex"));
						personnel.setBirthday(rs.getDate("birthday"));
						personnel.setNation(rs.getString("native"));
						personnel.setNation(rs.getString("nation"));
						personnel.setPolity(rs.getString("polity"));
						personnel.setWedlock(rs.getByte("wedlock"));
						personnel.setIdcardno(rs.getString("idcardno"));
						personnel.setIdcardaddress(rs.getString("idcardaddress"));
						personnel.setSocialinsuranceid(rs.getString("socialinsuranceid"));
						personnel.setFinishschool(rs.getString("finishschool"));
						personnel.setSpecialty(rs.getString("specialty"));
						personnel.setAcademic(rs.getString("academic"));
						personnel.setDwelling(rs.getString("dwelling"));
						personnel.setAdddate(rs.getDate("adddate"));
						personnel.setOutdate(rs.getDate("outdate"));
						personnel.setPassdate(rs.getDate("passdate"));
						personnel.setUsername(rs.getString("username"));
						personnel.setPassword(rs.getString("password"));
						personnel.setIslock(rs.getByte("islock"));
						personnel.setA(rs.getInt("A"));
						personnel.setB(rs.getInt("B"));
						personnel.setBill_con(rs.getInt("bill_con"));
					}
					rs.close();
				}
				catch (Exception e)
				{
					e.printStackTrace();
				}
				finally
				{
					cm.close();
				}
			}
		}
		return personnel;
	}
	public void setPersonnel(Personnel personnel)
	{
		this.personnel = personnel;
	}
	public void insert()
	{
		String sql = "insert into company (namekeywords,nameparticular,districtid,companyaddress,type," +
					"neturl,companytype,companystate,adddate,indate,companynarrate,personnelid,lastvisitdate," +
					"visitcount,industryid,addPersonnel) " +
					"values ('"+this.namekeywords+"','"+this.nameparticular+"',"+this.districtid+",'"+this.companyaddress+
					"','E','"+this.neturl+"','B','A','"+Date.valueOf(DateFormat.getDateInstance(DateFormat.DEFAULT).format(new java.util.Date()))+
					"','"+Date.valueOf(DateFormat.getDateInstance(DateFormat.DEFAULT).format(new java.util.Date()))+"','"+this.companynarrate+
					"',"+this.personnelid+",null,0,"+this.industryid+","+this.addPersonnelid+")";
		ConnectManager cm = ConnectManager.newInstance();
		if (cm.getConnection())
		{
			try
			{
				cm.executeUpdate(sql);
			}
			finally
			{
				cm.close();
			}
		}
	}
	public void getnew()
	{
		String sql = "select * from Company where companyid = (select max(companyid) FROM Company where personnelid = "+this.personnelid+")";
		ConnectManager cm = ConnectManager.newInstance();
		if (cm.getConnection())
		{
			try
			{
				ResultSet rs = cm.executeQuery(sql);
				if (rs.next())
				{
					this.setCompanyid(rs.getInt("companyid"));
					this.setNamekeywords(rs.getString("namekeywords"));
					this.setNameparticular(rs.getString("nameparticular"));
					this.setDistrictid(rs.getInt("districtid"));
					this.setCompanyaddress(rs.getString("companyaddress"));
					this.setType(rs.getString("type"));
					this.setNeturl(rs.getString("neturl"));
					this.setCompanytype(rs.getString("companytype"));
					this.setCompanystate(rs.getString("companystate"));
					this.setAdddate(rs.getDate("adddate"));
					this.setIndate(rs.getDate("indate"));
					this.setCompanynarrate(rs.getString("companynarrate"));
					this.setPersonnelid(rs.getInt("personnelid"));
					this.setAccepterid(rs.getInt("accepterid"));
					this.setLastPersonnelid(rs.getInt("lastPersonnel"));
					this.setLastvisitdate(rs.getDate("lastvisitdate"));
					this.setVisitcount(rs.getInt("visitcount"));
					this.setIndustryid(rs.getInt("industryid"));
				}
			}
			catch (Exception e)
			{
				e.printStackTrace();
			}
			finally
			{
				cm.close();
			}
		}
	}
	public Integer getAddPersonnelid()
	{
		return addPersonnelid;
	}
	public void setAddPersonnelid(Integer addPersonnelid)
	{
		this.addPersonnelid = addPersonnelid;
	}
	public Personnel getAddPersonnel()
	{
		if (this.addPersonnel==null)
		{
			ResultSet rs = null;
			String sql = "select * from personnel where personnelid = " + this.addPersonnelid;
			ConnectManager cm = ConnectManager.newInstance();
			if (cm.getConnection())
			{
				try
				{
					rs = cm.executeQuery(sql);
					if (rs.next())
					{
						addPersonnel = new Personnel();
						addPersonnel.setPersonnelid(rs.getInt("personnelid"));
						addPersonnel.setRealname(rs.getString("realname"));
						addPersonnel.setDeptid(rs.getInt("deptid"));
						addPersonnel.setPositionid(rs.getInt("positionid"));
						addPersonnel.setJobid(rs.getString("jobid"));
						addPersonnel.setSex(rs.getByte("sex"));
						addPersonnel.setBirthday(rs.getDate("birthday"));
						addPersonnel.setNation(rs.getString("native"));
						addPersonnel.setNation(rs.getString("nation"));
						addPersonnel.setPolity(rs.getString("polity"));
						addPersonnel.setWedlock(rs.getByte("wedlock"));
						addPersonnel.setIdcardno(rs.getString("idcardno"));
						addPersonnel.setIdcardaddress(rs.getString("idcardaddress"));
						addPersonnel.setSocialinsuranceid(rs.getString("socialinsuranceid"));
						addPersonnel.setFinishschool(rs.getString("finishschool"));
						addPersonnel.setSpecialty(rs.getString("specialty"));
						addPersonnel.setAcademic(rs.getString("academic"));
						addPersonnel.setDwelling(rs.getString("dwelling"));
						addPersonnel.setAdddate(rs.getDate("adddate"));
						addPersonnel.setOutdate(rs.getDate("outdate"));
						addPersonnel.setPassdate(rs.getDate("passdate"));
						addPersonnel.setUsername(rs.getString("username"));
						addPersonnel.setPassword(rs.getString("password"));
						addPersonnel.setIslock(rs.getByte("islock"));
						addPersonnel.setA(rs.getInt("A"));
						addPersonnel.setB(rs.getInt("B"));
						addPersonnel.setBill_con(rs.getInt("bill_con"));
					}
					rs.close();
				}
				catch (Exception e)
				{
					e.printStackTrace();
				}
				finally
				{
					cm.close();
				}
			}
		}
		return addPersonnel;
	}
	public void setAddPersonnel(Personnel addPersonnel)
	{
		this.addPersonnel = addPersonnel;
	}
	public List<DestineNote> getDestineNote()
	{
		if (this.destineNote==null)
		{
			ResultSet rs = null;
			String sql = "select * from destinenote where companyid = " + this.companyid;
			ConnectManager cm = ConnectManager.newInstance();
			if (cm.getConnection())
			{
				try
				{
					rs = cm.executeQuery(sql);
					if (rs.next())
					{
						destineNote = new ArrayList<DestineNote>();
						do
						{
							DestineNote dn = new DestineNote();
							dn.setSpeakForNoteId(rs.getInt("speakfornoteid"));
							dn.setBillId(rs.getInt("billid"));
							dn.setCompanyId(rs.getInt("companyid"));
							dn.setPersonnelId(rs.getInt("personnelid"));
							dn.setDestineDate(rs.getDate("destinedate"));
							dn.setPostponeDate(rs.getDate("postponedate"));
							dn.setDestime(rs.getInt("destime"));
							dn.setEnding(rs.getString("ending"));
							dn.setWhys(rs.getString("whys"));
							dn.setEndingDate(rs.getDate("endingdate"));
							destineNote.add(dn);
						}
						while (rs.next());
					}
				}
				catch (SQLException e)
				{
					e.printStackTrace();
				}
				finally
				{

				}
			}
		}
		return destineNote;
	}
	public void setDestineNote(List<DestineNote> destineNote)
	{
		this.destineNote = destineNote;
	}
}