package com.myproject.dao;

import com.myproject.bean.stencil.StencilCheckBean;
import com.myproject.bean.stencil.StencilTensionRecord;
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * Created by sunke on 2018/12/19.
 */
@Repository
public class StencilDbDao {

    protected final transient Logger log = LogManager.getLogger(getClass());

    @Autowired
    protected DbUtilsTemplate dbUtilsTemplate;

    public StencilCheckBean washCheck(String prjname){
        StencilCheckBean checkBean = dbUtilsTemplate.findFirst(StencilCheckBean.class, "select * from sinhovo_stencil_chk_tab WHERE barcode=? ORDER BY recd_time DESC", prjname);
        return checkBean;
    }

    /**
     * 获取张力值
     * */
    public StencilTensionRecord findTensionRecord(int idx){
        String sql = "SELECT * FROM sinhovo_stencil_tension_record WHERE prj_idx=?";
        StencilTensionRecord record = dbUtilsTemplate.findFirst(StencilTensionRecord.class, sql, idx);
        return record;
    }
}