package com.hp.cmsz.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;

import com.hp.cmsz.entity.Province;
import com.hp.cmsz.repository.ProvinceDao;
import com.hp.cmsz.repository.YwglTagDao;

/**
 * 
 * @author Liu Ying
 *
 */
@Component
@Transactional(readOnly = true)
public class ProvinceService {

	@Autowired
	private ProvinceDao provinceDao;
	
	@Autowired
	private YwglTagDao ywglTagDao;
	
	public long getProvinceSize() {
		return provinceDao.count();
	}

	public List<Province> getProvinceList() {
		return (List<Province>) provinceDao.findAll();
	}
	
	//业务规律省份地市   author Sophia
	public List<Object[]> getCityByProvince(List<Long> pro){
		return (List<Object[]>) ywglTagDao.findCityByProvince(pro);	
	}
	
	//有省份ID号得到省份的名称
	public String getProvinceNameByProvinceIds(List<Long> provinceIds){
		List<Province> provinces = provinceDao.findByProvinceIdIn(provinceIds);
		String provinceStr="";
		for(int i=0;i<provinces.size();i++){
			if(i==(provinces.size()-1)){
				provinceStr += provinces.get(i).getProvinceName();
			}
			else{
				provinceStr += provinces.get(i).getProvinceName()+" ";
			}
		}
		return provinceStr;
	}
	
}