package com.ld.igds.inout.dto;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;


public class ReportInoutDepotRowMapper implements RowMapper<ReportInoutDepotData> {

	@Override
	public ReportInoutDepotData mapRow(ResultSet rs, int rowNum) throws SQLException {
		ReportInoutDepotData d = new ReportInoutDepotData();
		d.setDepotId(rs.getString("depotId"));
		d.setDepotName(rs.getString("depotName"));
		d.setFoodType(rs.getString("foodType"));
		d.setFoodVariety(rs.getString("foodVariety"));
		d.setCqkc(rs.getDouble("cqkc"));
		d.setInNum(rs.getDouble("inNum"));
		d.setOverNum(rs.getDouble("overNum"));
		d.setInSum(rs.getDouble("inSum"));
		d.setOutNum(rs.getDouble("outNum"));
		d.setLossNum(rs.getDouble("lossNum"));
		d.setOutSum(rs.getDouble("outSum"));
		d.setQmkc(rs.getDouble("qmkc"));
		return d;
	}

}