package cn.com.taiji.zhongxiao.service;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.inject.Inject;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Service;

import cn.com.taiji.util.ToolUtil;
import cn.com.taiji.zhongxiao.domain.TbusinessItemAndInfoClass;
import cn.com.taiji.zhongxiao.domain.TbusinessItemAndInfoClassRepository;

@Service
public class TbusinessItemAndInfoClassService {
    @Inject
    TbusinessItemAndInfoClassRepository tbusinessItemAndInfoClassRepository;
    @Inject
    JdbcTemplate jdbcTemplate;
    public List<TbusinessItemAndInfoClass> findTbusinessItemAndInfoClassByClassId(
	    String classid) {
	// TODO Auto-generated method stub
	return tbusinessItemAndInfoClassRepository.findTbusinessItemAndInfoClassByClassId(classid);
    }

    public void saveRelationShip(String[] ywsxids, String[] ywsxs, String id) {
	// TODO Auto-generated method stub
	tbusinessItemAndInfoClassRepository.deleteRelationShipByClassId(id);
	if(ywsxids.length==ywsxs.length&&ywsxs.length>0){
	    for(int i =0;i<ywsxs.length;i++){
		if(!"".equals(ywsxids[i])){
		    TbusinessItemAndInfoClass info = new TbusinessItemAndInfoClass();
			info.setDataid(ToolUtil.getUUID());
			info.setInfoclassid(id);
			info.setItemid(ywsxids[i]);
			info.setItemname(ywsxs[i]);
			tbusinessItemAndInfoClassRepository.save(info);
		     
		}
		}
	}
    }

    public List<TbusinessItemAndInfoClass> findTbusinessItemAndInfoClassByItemid(
	    String ywsxid) {
	// TODO Auto-generated method stub
	StringBuffer sql=new StringBuffer("select p.infoname,s.itemname,s.infoclassid from t_businessitem_infoclass s,t_infoclass p where s.infoclassid=p.id and s.itemid=?"); 
	List<String> paramList=new ArrayList<String>();
	paramList.add(ywsxid);
	  Object[] args = new Object[]{};
	  int length = paramList.size();
	  if(length>0){
	      args=new Object[length];
	      for(int i=0;i<length;i++){
		  args[i] = paramList.get(i);
	      }
	      
	  }
	  List<TbusinessItemAndInfoClass> infoList = jdbcTemplate.query(sql.toString(),args,new RowMapper<TbusinessItemAndInfoClass>(){
	      @Override  
            public TbusinessItemAndInfoClass mapRow(ResultSet rs, int rowNum) throws SQLException {  
		  TbusinessItemAndInfoClass info = new TbusinessItemAndInfoClass(); 
		  info.setItemname(rs.getString("itemname"));
		  info.setInfoclassname(rs.getString("infoname"));
		  info.setInfoclassid(rs.getString("infoclassid"));
		  return info;  
            }   
	  });

	return infoList;
    }
}