/**
 * Project Name:hehenian-manager
 * File Name:PropertyDaoImpl.java
 * Package Name:com.hehenian.manager.modules.basicdata.service.impl
 * Date:2015年5月5日下午2:36:49
 * Copyright (c) 2015, hehenian.com All Rights Reserved.
 *
*/

package com.hehenian.manager.modules.basicdata.dao.impl;

import javax.annotation.Resource;

import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Repository;

import com.hehenian.manager.modules.basicdata.dao.SysCodeDao;
import com.hehenian.manager.modules.basicdata.model.SysCode;

/**
 * 
 * @author   songxjmf
 * @date: 2015年5月5日 下午2:36:49 	 
 */
@Repository("sysCodeDao")
public class SysCodeDaoImpl implements SysCodeDao {

	@Resource
	protected NamedParameterJdbcTemplate sp2pNameJdbcTemplate;
	
	/**
	 * 根据省/市/区/小区、级别查找编码
	 */
	@Override
	public Long getSubjectByNameAndType(String parentSubjectName,String subjectName, int sysCodeType) {
		String sql = "SELECT s2.id FROM syscode s1,syscode s2 WHERE s1.id = s2.parentId AND s1.remark = ? AND s2.remark = ? AND s1.invalid = 0 AND s2.invalid = 0 AND s2.typeId = ?";
		Object obj;
		try {
			obj = sp2pNameJdbcTemplate.getJdbcOperations().queryForObject(sql, Long.class, parentSubjectName,subjectName,sysCodeType);
		} catch (Exception e) {
			return null;
		}
		return Long.valueOf(obj.toString());
	}
	
	/**
	 * 找区县下面最大的小区编号
	 *
	 * @author songxjmf
	 * @date: 2015年5月5日 下午6:00:47
	 */
	public Long getMaxCommunityId(Long districtId){
		String sql = "SELECT MAX(id) FROM syscode WHERE parentId = ?";
		Object obj;
		try {
			obj = sp2pNameJdbcTemplate.getJdbcOperations().queryForObject(sql, Long.class, districtId);
		} catch (Exception e) {
			return null;
		}
		return obj==null?null:Long.valueOf(obj.toString());
	}
	
	/**
	 * 新增省/市/区/小区
	 * @author songxjmf
	 * @date: 2015年5月5日 下午3:20:51
	 */
	@Override
	public void insertSubject(SysCode sysCode){
		String sql = "INSERT INTO syscode (typeId,id,parentTypeId,parentId,remark,remarkForShow,invalid,createTime)VALUES(?, ?, ?, ?, ?, ?, ?, ?)";
		sp2pNameJdbcTemplate.getJdbcOperations().update(sql, sysCode.getTypeId(),sysCode.getId(),sysCode.getParentTypeId(),sysCode.getParentId(),sysCode.getRemark(),sysCode.getRemarkForShow(),sysCode.getInvalid(),sysCode.getCreateTime());
	}
}