package com.ld.igds.m.dto;

import java.sql.ResultSet;
import java.sql.SQLException;
import org.springframework.jdbc.core.RowMapper;

public class ReportInoutCheckDataRowMapepr implements
		RowMapper<ReportInoutCheckData> {

	@Override
	public ReportInoutCheckData mapRow(ResultSet rs, int rowNum)
			throws SQLException {
		ReportInoutCheckData d = new ReportInoutCheckData();

		d.setId(rs.getString("id"));
		d.setDepotId(rs.getString("depotId"));
		d.setDeptId(rs.getString("deptId"));
		d.setUserName(rs.getString("userName"));
		d.setPlateNum(rs.getString("plateNum"));
		d.setCustomerId(rs.getString("customerId"));
		d.setCustomerName(rs.getString("customerName"));
		d.setFoodVariety(rs.getString("foodVariety"));
		d.setFoodLevel(rs.getString("foodLevel"));
		d.setFoodLocation(rs.getString("foodLocation"));
		d.setFoodYear(rs.getString("foodYear"));
		d.setCheckStatus(rs.getString("checkStatus"));
		d.setSettleWeight(rs.getDouble("settleWeight"));
		d.setCompleteTime(rs.getTimestamp("completeTime"));
		d.setRemarks(rs.getString("remarks"));
		d.setStandardId(rs.getString("standardId"));
		d.setStandardName(rs.getString("standardName"));
		d.setLowerLimit(rs.getDouble("lowerLimit"));
		d.setUpperLimit(rs.getDouble("upperLimit"));
		d.setValue(rs.getString("value"));
		d.setStandardId2(rs.getString("standardId2"));
		d.setStandardName2(rs.getString("standardName2"));
		d.setLowerLimit2(rs.getDouble("lowerLimit2"));
		d.setUpperLimit2(rs.getDouble("upperLimit2"));
		d.setValue2(rs.getString("value2"));

		return d;
	}

}