package com.ld.igds.drug.service;

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

import org.springframework.jdbc.core.RowMapper;

import com.ld.igds.models.DrugLog;

public class DrugLogRowMapper implements RowMapper<DrugLog> {

    @Override
    public DrugLog mapRow(ResultSet rs, int index) throws SQLException {
        DrugLog data = new DrugLog();
        data.setId(rs.getString("ID_"));
        data.setCompanyId(rs.getString("COMPANY_ID_"));
        data.setDeptId(rs.getString("DEPT_ID_"));
        data.setDepotId(rs.getString("DEPOT_ID_"));
        data.setEnd(rs.getTimestamp("END_"));
        data.setStart(rs.getTimestamp("START_"));

        data.setPestBatchId(rs.getString("PEST_BATCH_ID_"));
        data.setNum(rs.getInt("NUM_"));
        data.setMode(rs.getString("MODE_"));
        data.setRecirMode(rs.getString("RECIR_MODE_"));
        data.setDrugName(rs.getString("DRUG_NAME_"));
        data.setConcentration(rs.getDouble("CONCENTRATION_"));
        data.setGrainDose(rs.getDouble("GRAIN_DOSE_"));

        data.setSpaceDose(rs.getDouble("SPACE_DOSE_"));
        data.setDose(rs.getDouble("DOSE_"));
        data.setVentilateMethod(rs.getString("VENTILATE_METHOD_"));
        data.setVentilateTime(rs.getDate("VENTILATE_TIME_"));
        data.setAfterPh3(rs.getDouble("AFTER_PH3_"));
        data.setEvaluate(rs.getString("EVALUATE_"));
        data.setCzsjff(rs.getString("CZSJFF_"));
        data.setCzclcs(rs.getString("CZCLCS_"));

        data.setRemarks(rs.getString("REMARKS_"));
        data.setUpdateTime(rs.getTimestamp("UPDATE_TIME_"));
        data.setUpdateUser(rs.getString("UPDATE_USER_"));

        data.setUser(rs.getString("USER_"));
        return data;
    }

}