package com.huimv.lierda.dao;

import com.huimv.busi.base.dto.ResponseBean;
import com.huimv.busi.xt.constant.XtSqlMapConstant;
import com.huimv.da.dataobject.DaMcda;
import com.huimv.da.dataobject.DaZsda;
import com.huimv.lierda.dataobject.LierdaDyda;
import com.huimv.lierda.dataobject.LierdaDydaExample;
import com.huimv.web.base.PageBean;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

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

public class LierdaDydaDAOImpl extends SqlMapClientDaoSupport implements LierdaDydaDAO {

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    public LierdaDydaDAOImpl() {
        super();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    public int countByExample(LierdaDydaExample example) {
        Integer count = (Integer)  getSqlMapClientTemplate().queryForObject("lierda_dyda.ibatorgenerated_countByExample", example);
        return count;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    public int deleteByExample(LierdaDydaExample example) {
        int rows = getSqlMapClientTemplate().delete("lierda_dyda.ibatorgenerated_deleteByExample", example);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    public int deleteByPrimaryKey(Integer id) {
        LierdaDyda key = new LierdaDyda();
        key.setId(id);
        int rows = getSqlMapClientTemplate().delete("lierda_dyda.ibatorgenerated_deleteByPrimaryKey", key);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    public void insert(LierdaDyda record) {
        getSqlMapClientTemplate().insert("lierda_dyda.ibatorgenerated_insert", record);
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    public void insertSelective(LierdaDyda record) {
        getSqlMapClientTemplate().insert("lierda_dyda.ibatorgenerated_insertSelective", record);
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    @SuppressWarnings("unchecked")
    public List<LierdaDyda> selectByExample(LierdaDydaExample example) {
        List<LierdaDyda> list = getSqlMapClientTemplate().queryForList("lierda_dyda.ibatorgenerated_selectByExample", example);
        return list;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    public LierdaDyda selectByPrimaryKey(Integer id) {
        LierdaDyda key = new LierdaDyda();
        key.setId(id);
        LierdaDyda record = (LierdaDyda) getSqlMapClientTemplate().queryForObject("lierda_dyda.ibatorgenerated_selectByPrimaryKey", key);
        return record;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    public int updateByExampleSelective(LierdaDyda record, LierdaDydaExample example) {
        UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
        int rows = getSqlMapClientTemplate().update("lierda_dyda.ibatorgenerated_updateByExampleSelective", parms);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    public int updateByExample(LierdaDyda record, LierdaDydaExample example) {
        UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
        int rows = getSqlMapClientTemplate().update("lierda_dyda.ibatorgenerated_updateByExample", parms);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    public int updateByPrimaryKeySelective(LierdaDyda record) {
        int rows = getSqlMapClientTemplate().update("lierda_dyda.ibatorgenerated_updateByPrimaryKeySelective", record);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    public int updateByPrimaryKey(LierdaDyda record) {
        int rows = getSqlMapClientTemplate().update("lierda_dyda.ibatorgenerated_updateByPrimaryKey", record);
        return rows;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table lierda_dyda
     *
     * @ibatorgenerated Thu Sep 19 14:44:46 CST 2019
     */
    private static class UpdateByExampleParms extends LierdaDydaExample {
        private Object record;

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

        public Object getRecord() {
            return record;
        }
    }
    
    public ResponseBean selectListByParam(Map<String , Object> paramMap , PageBean pageBean) {
    	ResponseBean rb = new ResponseBean();
		List<LierdaDyda> list = new ArrayList<LierdaDyda>();
		int count = (Integer) getSqlMapClientTemplate().queryForObject(XtSqlMapConstant.SQLMAP_COUNT_LIERDALIST_BY_PARAM, paramMap);
		
		if(null != pageBean) {
			int startRecord = pageBean.getCurrentPageFirstRecord();
			int endRecord = pageBean.getPageSize();
			paramMap.put("startRecord", startRecord);
			paramMap.put("endRecord", endRecord);
			pageBean.setRecordCount(count);
		} else {
			paramMap.put("startRecord", 0);
			paramMap.put("endRecord", count);
		}
		list = getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_LIERDALIST_BY_PARAM, paramMap);
    	rb.setResult(list);
		rb.setReturnCode(count);
    	return rb;
    }
    //绑定单元时遍历单元（ifm为猪舍，szmc为单元）
    public List<DaZsda> getDydaList(Map<String , Object> paramMap) {
        List<DaZsda> list = getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_DYDALIST_BY_PARAM, paramMap);
        return list;
    }
}