import java.util.ArrayList;

import java.util.List;

import org.springframework.jdbc.core.BeanPropertyRowMapper;

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

import org.springframework.stereotype.Repository;

import com.yundaex.common.dao.DataGrid;

import com.yundaex.common.dao.QueryCriteria;

import com.yundaex.common.dao.impl.BaseDaoImpl;

import com.yundaex.common.security.annotation.EnableDataSecurity;

import com.yundaex.wms.basicdata.dao.RivWorkingPositionDao;

import com.yundaex.wms.basicdata.po.RivWorkingPosition;

@Repository("workingPositionDao")

public class RivWorkingPositionDaoImpl extends BaseDaoImpl<RivWorkingPosition>

        implements RivWorkingPositionDao {

    //查询简单类型

    @Override

    public int querySomeTypeQtyEnabled(String type) {

        List<Object> params = new ArrayList<Object>();

        params.add(type);

        String sql = "select count(1) from riv_working_position wkp where wkp.WKP_WORKING_P_TYPE = ? and wkp.WKP_IS_ENABLED =1";

        Integer result = this.jdbcTemplate.getJdbcOperations().queryForObject(sql, params.toArray(),Integer.class);

        return result;

    }
    //查询复杂类型

//this.jdbcTemplate.getJdbcOperations().queryForObject(sql, params.toArray(),new BeanPropertyRowMapper<AClass>(AClass.class));

}

    public List<Map<String, Object>> queryMatInfoByMatCode(String matCodeList) {

        if (StringUtil.isBlank(matCodeList)) {

            return new ArrayList<Map<String, Object>>();

        }

        List<Object> params = new ArrayList<Object>();

        params.add(matCodeList);

        String sql = "select mat.MAT_ID, mat.MAT_CODE from riv_material mat where mat.MAT_CODE in (?)";

        List<Map<String, Object>> list = jdbcTemplate.getJdbcOperations().queryForList(sql,params.toArray());

        return list;

    }