package com.ld.igds.inout.dto;

import org.springframework.jdbc.core.RowMapper;

import com.ld.igds.constant.FoodVariety;

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


public class ReportFoodVarietyRowMapper implements RowMapper<ReportInoutDepotData> {

	@Override
	public ReportInoutDepotData mapRow(ResultSet rs, int rowNum) throws SQLException {
		ReportInoutDepotData d = new ReportInoutDepotData();
		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"));
		d.setFoodVarietyName(FoodVariety.getMsg(rs.getString("foodVariety")));
		return d;
	}

}