package com.huimv.xx.dao;

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

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

import com.huimv.busi.base.dto.ResponseBean;
import com.huimv.busi.xt.constant.XtSqlMapConstant;
import com.huimv.web.base.PageBean;
import com.huimv.xx.dataobject.XxXwfb;
import com.huimv.xx.dataobject.XxXwfbExample;

public class XxXwfbDAOImpl extends SqlMapClientDaoSupport implements XxXwfbDAO {

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public XxXwfbDAOImpl() {
        super();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public int countByExample(XxXwfbExample example) {
        Integer count = (Integer)  getSqlMapClientTemplate().queryForObject("xx_xwfb.ibatorgenerated_countByExample", example);
        return count;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public int deleteByExample(XxXwfbExample example) {
        int rows = getSqlMapClientTemplate().delete("xx_xwfb.ibatorgenerated_deleteByExample", example);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public int deleteByPrimaryKey(Integer id) {
        XxXwfb key = new XxXwfb();
        key.setId(id);
        int rows = getSqlMapClientTemplate().delete("xx_xwfb.ibatorgenerated_deleteByPrimaryKey", key);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public void insert(XxXwfb record) {
        getSqlMapClientTemplate().insert("xx_xwfb.ibatorgenerated_insert", record);
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public void insertSelective(XxXwfb record) {
        getSqlMapClientTemplate().insert("xx_xwfb.ibatorgenerated_insertSelective", record);
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    @SuppressWarnings("unchecked")
    public List<XxXwfb> selectByExampleWithBLOBs(XxXwfbExample example) {
        List<XxXwfb> list = getSqlMapClientTemplate().queryForList("xx_xwfb.ibatorgenerated_selectByExampleWithBLOBs", example);
        return list;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    @SuppressWarnings("unchecked")
    public List<XxXwfb> selectByExampleWithoutBLOBs(XxXwfbExample example) {
        List<XxXwfb> list = getSqlMapClientTemplate().queryForList("xx_xwfb.ibatorgenerated_selectByExample", example);
        return list;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public XxXwfb selectByPrimaryKey(Integer id) {
        XxXwfb key = new XxXwfb();
        key.setId(id);
        XxXwfb record = (XxXwfb) getSqlMapClientTemplate().queryForObject("xx_xwfb.ibatorgenerated_selectByPrimaryKey", key);
        return record;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public int updateByExampleSelective(XxXwfb record, XxXwfbExample example) {
        UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
        int rows = getSqlMapClientTemplate().update("xx_xwfb.ibatorgenerated_updateByExampleSelective", parms);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public int updateByExampleWithBLOBs(XxXwfb record, XxXwfbExample example) {
        UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
        int rows = getSqlMapClientTemplate().update("xx_xwfb.ibatorgenerated_updateByExampleWithBLOBs", parms);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public int updateByExampleWithoutBLOBs(XxXwfb record, XxXwfbExample example) {
        UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
        int rows = getSqlMapClientTemplate().update("xx_xwfb.ibatorgenerated_updateByExample", parms);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public int updateByPrimaryKeySelective(XxXwfb record) {
        int rows = getSqlMapClientTemplate().update("xx_xwfb.ibatorgenerated_updateByPrimaryKeySelective", record);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public int updateByPrimaryKeyWithBLOBs(XxXwfb record) {
        int rows = getSqlMapClientTemplate().update("xx_xwfb.ibatorgenerated_updateByPrimaryKeyWithBLOBs", record);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    public int updateByPrimaryKeyWithoutBLOBs(XxXwfb record) {
        int rows = getSqlMapClientTemplate().update("xx_xwfb.ibatorgenerated_updateByPrimaryKey", record);
        return rows;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table xx_xwfb
     *
     * @ibatorgenerated Wed Jun 18 09:54:04 CST 2014
     */
    private static class UpdateByExampleParms extends XxXwfbExample {
        private Object record;

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

        @SuppressWarnings("unused")
		public Object getRecord() {
            return record;
        }
    }
    
    @SuppressWarnings("unchecked")
	public ResponseBean selectXxXwfbByParam(Map<String, Object> paramMap, PageBean pageBean) throws Exception {
    	ResponseBean rb = new ResponseBean();
    	List<XxXwfb> xxXwfbs = new ArrayList<XxXwfb>();
    	int count = (Integer) getSqlMapClientTemplate().queryForObject(XtSqlMapConstant.SQLMAP_COUNT_XWFB_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);
		}
    	xxXwfbs = (List<XxXwfb>) getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_XWFB_BY_PARAM, paramMap);
    	rb.setResult(xxXwfbs);
    	rb.setReturnCode(count);
    	return rb;
    }
    
    public int getXxXwfbMaxId() {
    	Integer maxId = (Integer) getSqlMapClientTemplate().queryForObject(XtSqlMapConstant.SQLMAP_GET_XWFB_MAX_ID);
    	if(maxId == null) {
    		maxId = 0;
    	}
    	return maxId;
    }

}