jobinfo.java

java阿里巴巴代码

			ArrayList jobList = new ArrayList();
			JobExt jobExt = new JobExt();
			jobExt.setParam(":VJOB_ID", job_id);
			jobList = jobExt.selByList("SEL_ONE_JOB");		
			return jobList;
}	
		// 分页查询
		public ArrayList getJobListByType(int iStart,String job_type) throws SaasApplicationException 
		{
			if(iStart==0)
		    {
				iStart=0;
			}
			else 
			{
			    iStart = (iStart-1)*30;
			}
			ArrayList itemsList = new ArrayList();
			JobExt jobExt = new JobExt();
			jobExt.setParam(":VJOB_TYPE",job_type);
			itemsList = jobExt.selByList("SEL_BY_SEARCH",iStart,30);	 
			return itemsList;
		}
		public int getJobNumberByType(String job_type)throws SaasApplicationException
		{
			ArrayList itemsList = new ArrayList();
			JobExt jobExt = new JobExt();
			jobExt.setParam(":VJOB_TYPE",job_type);
			itemsList = jobExt.selByList("SEL_BY_SEARCH");	 
			if(itemsList !=null && itemsList.size()>0)
			{
				return itemsList.size();
			}
			else
			{
				return 0;
			}
		}

				
	public ArrayList genNewJobList( String cust_id )throws SaasApplicationException{
				ArrayList JobList = new ArrayList();
				JobExt jobExt = new JobExt();
				jobExt.setParam(":VCUST_ID", cust_id );
				JobList = jobExt.selByList("SEL_SPEC_CUST_ID");
				return JobList;
  }
// //////////////////////////////////////////////////////////
	public int genNewJobListAll()
	throws SaasApplicationException
{

	ArrayList JobList = new ArrayList();
 
	JobExt jobExt = new JobExt();
	
	JobList = jobExt.selByList("SEL_NEW_ALL");
	if (JobList == null)
		return 0;	
	return JobList.size();
}
// ////////////////////////////////////////////////////////////////
		public int genNewJobCount( String cust_id )
				throws SaasApplicationException
			{
			
				ArrayList JobList = new ArrayList();
				JobExt jobExt = new JobExt();
				jobExt.setParam(":VCUST_ID", cust_id );
				JobList = jobExt.selByList("SEL_NEW_JOBLIST");
				if (JobList == null)
					return 0;	
				return JobList.size();
			}
			
			// 首页人才招聘
			public ArrayList genMainPageJobList( boolean flag )
				throws SaasApplicationException
			{
			
				ArrayList JobList = new ArrayList();
				JobExt jobExt = new JobExt();
				if( flag )
			  {
					JobList = jobExt.selByList("SEL_BY_TRUE");
			  }
			  else
			  {
			  	JobList = jobExt.selByList("SEL_BY_FALSE");
			  }
				if (JobList == null)
					return null;	
				return JobList;
			}
				
	public ArrayList genLatestJobList(int iStart,int limit) throws SaasApplicationException {

		if (iStart > 1) {
			iStart = (iStart - 1) * limit;
		}
		else {
			iStart = 0;
		}
	 JobExt jobExt = new JobExt();
		
		ArrayList list = jobExt.selByList("SEL_NEW_ALL", iStart, limit);
		return list;
	}

		//搜索
	public ArrayList GetcomByjob(int iStart, String job_key, String pro, String city_1) throws SaasApplicationException {

		log.LOG_INFO("进入Getcombyjob方法");
		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		ArrayList jobList = new ArrayList();
	  JobExt jobExt = new JobExt();
		jobExt.setParam(":VJOB_KEY", "%" + job_key + "%");
		jobExt.setParam(":VPRO", "%" + pro + "%");
		jobExt.setParam(":VCITY_1", "%" + city_1 + "%");
		jobList = jobExt.selByList("SEL_COM_BY_JOB", iStart, 10);
		log.LOG_INFO("退出Getcombyjob方法");
		return jobList;
	}
	
		public int getcomByjob(String job_key, String pro, String city_1) throws SaasApplicationException {

		int size = 0;
	  JobExt jobExt = new JobExt();
		jobExt.setParam(":VJOB_KEY", "%" + job_key + "%");
		jobExt.setParam(":VPRO", "%" + pro + "%");
		jobExt.setParam(":VCITY_1", "%" + city_1 + "%");
		ArrayList list = jobExt.selByList("SEL_COM_BY_JOB");
		if (list != null && list.size() > 0) {
			size = list.size();
		}
		return size;
	}
	
	public ArrayList getComByJobOff(int iStart, String job_key, String pro, String city_1, String part) throws SaasApplicationException {

		log.LOG_INFO("进入getComByJob方法");
		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		ArrayList jobList = new ArrayList();
		 JobExt jobExt = new JobExt();
		jobExt.setParam(":VJOB_KEY", "%" + job_key + "%");
		jobExt.setParam(":VPRO", "%" + pro + "%");
		jobExt.setParam(":VCITY", "%" + city_1 + "%");
		jobExt.setParam(":VPART", part);
		jobList = jobExt.selByList("SEL_PRODUCT_BY_STOCK", iStart, 10);
		log.LOG_INFO("退出getProductByStock方法");
		return jobList;
	}
	
		public int getComByJobOff(String job_key, String pro, String city_1, String part) throws SaasApplicationException {

		int size = 0;
		JobExt jobExt = new JobExt();
		jobExt.setParam(":VJOB_KEY", "%" + job_key + "%");
		jobExt.setParam(":VPRO", "%" + pro + "%");
		jobExt.setParam(":VCITY", "%" + city_1 + "%");
		jobExt.setParam(":VPART", part);
		ArrayList list = jobExt.selByList("SEL_PRODUCT_BY_STOCK");
		if (list != null && list.size() > 0) {
			size = list.size();
		}
		return size;
	}
	
	
	
		//搜索
	public ArrayList GetComByjob(int iStart,String prov_1, String pub_job) throws SaasApplicationException {

		log.LOG_INFO("进入GetComByjob方法");
		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		ArrayList jobList = new ArrayList();
		 JobExt jobExt = new JobExt();
		 jobExt.setParam(":VPROV_1", "%" + prov_1 + "%");
		 jobExt.setParam(":VPUB_JOB", pub_job);
		 jobList = jobExt.selByList("SEL_JOB_BY_NO_KEY", iStart, 10);
		log.LOG_INFO("退出GetComByjob方法");
		return jobList;
	}
	
	

	public int GetComByjob( String prov_1, String pub_job) throws SaasApplicationException {

		int size = 0;
		JobExt jobExt = new JobExt();
		jobExt.setParam(":VPROV_1", "%" + prov_1 + "%");
		jobExt.setParam(":VPUB_JOB", pub_job);
		ArrayList list = jobExt.selByList("SEL_JOB_BY_NO_KEY");
		if (list != null && list.size() > 0) {
			size = list.size();
		}
		return size;
	}
	
	
	
	public ArrayList getComByJobCity(int iStart, String job_key, String prov_1, String pub_job) throws SaasApplicationException {

		log.LOG_INFO("进入getComByJobCity方法");
		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		ArrayList jobList = new ArrayList();
		JobExt jobExt = new JobExt();
		jobExt.setParam(":VJOB_KEY", "%" + job_key + "%");
		jobExt.setParam(":VPROV_1", "%" + prov_1 + "%");
		jobExt.setParam(":VPUB_JOB", pub_job);
		jobList = jobExt.selByList("SEL_JOB_BY_CT", iStart, 10);
		log.LOG_INFO("退出getComByJobCity方法");
		return jobList;
	}
	
	
	
	public int getComByJobCity(String job_key, String prov_1, String pub_job) throws SaasApplicationException {

		int size = 0;
		JobExt jobExt = new JobExt();
		jobExt.setParam(":VJOB_KEY", "%" + job_key + "%");
		jobExt.setParam(":VPROV_1", "%" + prov_1 + "%");
		jobExt.setParam(":VPUB_JOB", pub_job);
		ArrayList list = jobExt.selByList("SEL_JOB_BY_CT");
		if (list != null && list.size() > 0) {
			size = list.size();
		}
		return size;
	}
	
	
	public ArrayList getComByJobKey(int iStart, String prov_1, String city_1, String pub_job) throws SaasApplicationException {

		log.LOG_INFO("进入getComByJobKey方法");
		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		ArrayList jobList = new ArrayList();
		JobExt jobExt = new JobExt();
		jobExt.setParam(":VPROV_1", "%" + prov_1 + "%");
		jobExt.setParam(":VCITY", "%" + city_1 + "%");
		jobExt.setParam(":VPUB_JOB", pub_job);
		jobList = jobExt.selByList("SEL_JOB_NO_KEY", iStart, 10);
		log.LOG_INFO("退出getComByJobKey方法");
		return jobList;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getComByJobKey(String prov_1, String city_1, String pub_job) throws SaasApplicationException {

		int size = 0;
		JobExt jobExt = new JobExt();
		jobExt.setParam(":VPROV_1", "%" + prov_1 + "%");
		jobExt.setParam(":VCITY", "%" + city_1 + "%");
		jobExt.setParam(":VPUB_JOB", pub_job);
		ArrayList list = jobExt.selByList("SEL_JOB_NO_KEY");
		if (list != null && list.size() > 0) {
			size = list.size();
		}
		return size;
	}
	public ArrayList getComByJobPro(int iStart, String job_key, String prov_1, String city_1, String pub_job) throws SaasApplicationException {

		log.LOG_INFO("进入getComByJobPro方法");
		if (iStart > 1) {
			iStart = (iStart - 1) * 10;
		}
		else {
			iStart = 0;
		}
		ArrayList jobList = new ArrayList();
		JobExt jobExt = new JobExt();
		jobExt.setParam(":VJOB_KEY", "%" + job_key + "%");
		jobExt.setParam(":VPROV_1", "%" + prov_1 + "%");
		jobExt.setParam(":VCITY_1", "%" + city_1 + "%");
		jobExt.setParam(":VPUB_JOB", pub_job);
		jobList = jobExt.selByList("SEL_PRO_BY_JOB", iStart,10);
		log.LOG_INFO("退出getComByJobPro方法");
		return jobList;
	}
	
	
	@SuppressWarnings("unchecked")
	public int getComByJobPro(String job_key, String prov_1, String city_1, String pub_job) throws SaasApplicationException {

		int size = 0;
		JobExt jobExt = new JobExt();
		jobExt.setParam(":VJOB_KEY", "%" + job_key + "%");
		jobExt.setParam(":VPROV_1", "%" + prov_1 + "%");
		jobExt.setParam(":VCITY_1", "%" + city_1 + "%");
		jobExt.setParam(":VPUB_JOB", pub_job);
		ArrayList list = jobExt.selByList("SEL_PRO_BY_JOB");
		if (list != null && list.size() > 0) {
			size = list.size();
		}
		return size;
	}
	

	  

	  
}