package com.huimv.da.dao;

import com.huimv.da.dataobject.DaLqda;
import com.huimv.da.dataobject.DaLqdaExample;

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

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

import com.huimv.busi.da.dto.DaLqdaDTO;
import com.huimv.busi.da.dto.DaSlxxDTO;
import com.huimv.busi.da.dto.DaZsdaDTO;
import com.huimv.busi.xt.constant.XtSqlMapConstant;

public class DaLqdaDAOImpl extends SqlMapClientDaoSupport implements DaLqdaDAO {

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public DaLqdaDAOImpl() {
        super();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public int countByExample(DaLqdaExample example) {
        Integer count = (Integer)  getSqlMapClientTemplate().queryForObject("da_lqda.ibatorgenerated_countByExample", example);
        return count;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public int deleteByExample(DaLqdaExample example) {
        int rows = getSqlMapClientTemplate().delete("da_lqda.ibatorgenerated_deleteByExample", example);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public int deleteByPrimaryKey(Integer id) {
        DaLqda key = new DaLqda();
        key.setId(id);
        int rows = getSqlMapClientTemplate().delete("da_lqda.ibatorgenerated_deleteByPrimaryKey", key);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public void insert(DaLqda record) {
        getSqlMapClientTemplate().insert("da_lqda.ibatorgenerated_insert", record);
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public void insertSelective(DaLqda record) {
        getSqlMapClientTemplate().insert("da_lqda.ibatorgenerated_insertSelective", record);
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    @SuppressWarnings("unchecked")
    public List<DaLqda> selectByExample(DaLqdaExample example) {
        List<DaLqda> list = getSqlMapClientTemplate().queryForList("da_lqda.ibatorgenerated_selectByExample", example);
        return list;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public DaLqda selectByPrimaryKey(Integer id) {
        DaLqda key = new DaLqda();
        key.setId(id);
        DaLqda record = (DaLqda) getSqlMapClientTemplate().queryForObject("da_lqda.ibatorgenerated_selectByPrimaryKey", key);
        return record;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public int updateByExampleSelective(DaLqda record, DaLqdaExample example) {
        UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
        int rows = getSqlMapClientTemplate().update("da_lqda.ibatorgenerated_updateByExampleSelective", parms);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public int updateByExample(DaLqda record, DaLqdaExample example) {
        UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
        int rows = getSqlMapClientTemplate().update("da_lqda.ibatorgenerated_updateByExample", parms);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public int updateByPrimaryKeySelective(DaLqda record) {
        int rows = getSqlMapClientTemplate().update("da_lqda.ibatorgenerated_updateByPrimaryKeySelective", record);
        return rows;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public int updateByPrimaryKey(DaLqda record) {
        int rows = getSqlMapClientTemplate().update("da_lqda.ibatorgenerated_updateByPrimaryKey", record);
        return rows;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table da_lqda
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    private static class UpdateByExampleParms extends DaLqdaExample {
        private Object record;

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

        @SuppressWarnings("unused")
		public Object getRecord() {
            return record;
        }
    }
    
	@SuppressWarnings("unchecked")
    public List<DaLqdaDTO> selectMCZSLQDAByExample(DaLqdaExample example) {
		List<DaLqdaDTO> list = getSqlMapClientTemplate().queryForList("da_lqda.ibatorgenerated_selectMCZSLQDAByExample", example);
        return list;
    }
    
    public int countMCZSLQDAByExample(DaLqdaExample example) {
        Integer count = (Integer) getSqlMapClientTemplate().queryForObject("da_lqda.ibatorgenerated_countMCZSLQDAByExample", example);
        return count;
    }
    
    public DaLqdaDTO selectMCZSLQDAByPrimaryKey(Integer id) {
        DaLqda key = new DaLqda();
        key.setId(id);
        DaLqdaDTO daLqdaDTO = (DaLqdaDTO) getSqlMapClientTemplate().queryForObject("da_lqda.ibatorgenerated_selectMCZSLQDAByPrimaryKey", key);
        return daLqdaDTO;
    }
    
    @SuppressWarnings("unchecked")
	public List<DaLqda> selectLqdaByZsid(String zsid) {
    	List<DaLqda> daLqdas = null;
    	daLqdas = (List<DaLqda>) getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SELECT_LQDA_BY_ZSID, zsid);
    	return daLqdas;
    }
    
	@SuppressWarnings("unchecked")
    public List<DaSlxxDTO> selectMCZSLQSLByExample(DaLqdaExample example) {
		List<DaSlxxDTO> list = getSqlMapClientTemplate().queryForList("da_lqda.ibatorgenerated_selectMCZSLQSLByExample", example);
        return list;
    }

	@SuppressWarnings("unchecked")
	public List<DaZsdaDTO> selectZsdaDtoByParam(Map<String, Object> param) {
		List<DaZsdaDTO> list = getSqlMapClientTemplate().queryForList("select.zsdadto.by.mcid", param);
        return list;
	}
	
	@SuppressWarnings("unchecked")
	public List<DaLqda> selectDqlq() {
		List<DaLqda> list = getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_DQLQ_LQID);
        return list;
	}
    
}