package com.huimv.sjlr.dao;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import org.springframework.orm.ibatis.SqlMapClientCallback;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.huimv.busi.xt.constant.XtSqlMapConstant;
import com.huimv.dto.SjlrMzxxxxDTO;
import com.huimv.sjlr.dataobject.SjlrMzda;
import com.huimv.sjlr.dataobject.SjlrMzdaExample;
import com.ibatis.sqlmap.client.SqlMapExecutor;

public class SjlrMzdaDAOImpl extends SqlMapClientDaoSupport implements SjlrMzdaDAO {

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    public SjlrMzdaDAOImpl() {
        super();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    public int countByExample(SjlrMzdaExample example) {
        Integer count = (Integer)  getSqlMapClientTemplate().queryForObject("sjlr_mzda.ibatorgenerated_countByExample", example);
        return count;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    public int deleteByExample(SjlrMzdaExample example) {
        int rows = getSqlMapClientTemplate().delete("sjlr_mzda.ibatorgenerated_deleteByExample", example);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    public int deleteByPrimaryKey(Integer id) {
        SjlrMzda key = new SjlrMzda();
        key.setId(id);
        int rows = getSqlMapClientTemplate().delete("sjlr_mzda.ibatorgenerated_deleteByPrimaryKey", key);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    public void insert(SjlrMzda record) {
        getSqlMapClientTemplate().insert("sjlr_mzda.ibatorgenerated_insert", record);
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    public void insertSelective(SjlrMzda record) {
        getSqlMapClientTemplate().insert("sjlr_mzda.ibatorgenerated_insertSelective", record);
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    @SuppressWarnings("unchecked")
    public List<SjlrMzda> selectByExample(SjlrMzdaExample example) {
        List<SjlrMzda> list = getSqlMapClientTemplate().queryForList("sjlr_mzda.ibatorgenerated_selectByExample", example);
        return list;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    public SjlrMzda selectByPrimaryKey(Integer id) {
        SjlrMzda key = new SjlrMzda();
        key.setId(id);
        SjlrMzda record = (SjlrMzda) getSqlMapClientTemplate().queryForObject("sjlr_mzda.ibatorgenerated_selectByPrimaryKey", key);
        return record;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    public int updateByExampleSelective(SjlrMzda record, SjlrMzdaExample example) {
        UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
        int rows = getSqlMapClientTemplate().update("sjlr_mzda.ibatorgenerated_updateByExampleSelective", parms);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    public int updateByExample(SjlrMzda record, SjlrMzdaExample example) {
        UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
        int rows = getSqlMapClientTemplate().update("sjlr_mzda.ibatorgenerated_updateByExample", parms);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    public int updateByPrimaryKeySelective(SjlrMzda record) {
        int rows = getSqlMapClientTemplate().update("sjlr_mzda.ibatorgenerated_updateByPrimaryKeySelective", record);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    public int updateByPrimaryKey(SjlrMzda record) {
        int rows = getSqlMapClientTemplate().update("sjlr_mzda.ibatorgenerated_updateByPrimaryKey", record);
        return rows;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table sjlr_mzda
     *
     * @ibatorgenerated Wed Mar 08 10:43:49 CST 2017
     */
    private static class UpdateByExampleParms extends SjlrMzdaExample {
        private Object record;

        public UpdateByExampleParms(Object record, SjlrMzdaExample example) {
            super(example);
            this.record = record;
        }

        public Object getRecord() {
            return record;
        }
    }
    /**
     * 获取母猪档案
     */
	@Override
	public List<SjlrMzda> getMzdaListByParam(Map<String, Object> paramMap) {
		@SuppressWarnings("unchecked")
		List<SjlrMzda> mzdaList = (List<SjlrMzda>)getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_SJLR_MZDA_BY_PARAM, paramMap);
		return mzdaList;
	}
	
	/**
	 * 正在配种的母猪
	 * @param paramMap
	 * @return
	 */
	public List<SjlrMzda> getMzdaListByPzjl(Map<String, Object> paramMap) {
		@SuppressWarnings("unchecked")
		List<SjlrMzda> mzdaList = (List<SjlrMzda>)getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_SJLR_MZDA_BY_PZJL, paramMap);
		return mzdaList;
	}
	
	public void updatMzdaByParam(List<SjlrMzda> paramMapList,List<SjlrMzdaExample> mzdaExList) {
		HpSjlrMzdaSqlMapClientCallback hpSjlrMzdaSqlMapClientCallback = new HpSjlrMzdaSqlMapClientCallback();
		hpSjlrMzdaSqlMapClientCallback.setMzdaList(paramMapList);
		hpSjlrMzdaSqlMapClientCallback.setMzdaExList(mzdaExList);
		getSqlMapClientTemplate().execute(hpSjlrMzdaSqlMapClientCallback);
	}
	
	/**
	 * 批量更新母猪档案
	 * @param paramMap
	 * @return
	 */
	//回调
	public class HpSjlrMzdaSqlMapClientCallback implements SqlMapClientCallback {
		private List<SjlrMzda> sjlrMzdaList ;
		private List<SjlrMzdaExample> mzdaExList ;

		public void setMzdaList(List<SjlrMzda> sjlrMzdaList) {
			this.sjlrMzdaList=sjlrMzdaList;
		}
		public void setMzdaExList(List<SjlrMzdaExample> sjlrMzdaExList) {
			this.mzdaExList=sjlrMzdaExList;
		}

		public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
			executor.startBatch();
			for (int i=0;i<sjlrMzdaList.size();i++) {
				SjlrMzda sjlrMzda=new SjlrMzda();
				sjlrMzda=sjlrMzdaList.get(i);
				SjlrMzdaExample sjlrMzdaExample=new SjlrMzdaExample();
				sjlrMzdaExample= mzdaExList.get(i);
				//更新
				UpdateByExampleParms parms = new UpdateByExampleParms(sjlrMzda, sjlrMzdaExample);
				executor.update("sjlr_mzda.ibatorgenerated_updateByExampleSelective", parms);		
			}
			executor.executeBatch();
			return null;
		}
	}

	/**
	 * 获取母猪相关信息
	 * @param paramMap
	 * @return
	 */
	public List<SjlrMzxxxxDTO> getMzxxListByParam(Map<String, Object> paramMap) {
		@SuppressWarnings("unchecked")
		List<SjlrMzxxxxDTO> mzdaList = (List<SjlrMzxxxxDTO>)getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_SJLR_MZXX_BY_PARAM, paramMap);
		return mzdaList;
	}

	@Override
	public List<SjlrMzda> getDaListByZzds(Map<String, Object> paramMap) {
		@SuppressWarnings("unchecked")
		List<SjlrMzda> mzdaList = (List<SjlrMzda>)getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_SJLR_MZDA_BY_ZZDS, paramMap);
		return mzdaList;
	}

	@Override
	public int updateDwebAllByParam(Map<String, Object> paramMap) {
		// TODO Auto-generated method stub
		getSqlMapClientTemplate().queryForObject(XtSqlMapConstant.SQLMAP_UPDATE_ALL_DWEB_BY_PARAM, paramMap);
		return 1;
	}

	@Override
	public List<SjlrMzxxxxDTO> getTtMzxxListByParam(Map<String, Object> paramMap) {
		@SuppressWarnings("unchecked")
		List<SjlrMzxxxxDTO> mzdaList = (List<SjlrMzxxxxDTO>)getSqlMapClientTemplate().queryForList
				(XtSqlMapConstant.SQLMAP_SELECT_SJLR_TTMZXX_BY_PARAM, paramMap);
		return mzdaList;
	}

}