package cn.gistack.sm.sjztdw.excel;
|
|
import com.alibaba.excel.annotation.ExcelIgnore;
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import com.alibaba.excel.annotation.format.DateTimeFormat;
|
import com.alibaba.excel.annotation.write.style.ColumnWidth;
|
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
|
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
|
import lombok.Data;
|
|
import java.io.Serializable;
|
import java.util.Date;
|
|
/**
|
* 大坝人工上报
|
*/
|
@Data
|
@ColumnWidth(30)
|
@HeadRowHeight(20)
|
@ContentRowHeight(18)
|
public class DbExcel implements Serializable {
|
|
private static final long serialVersionUID = 1L;
|
|
@ExcelProperty("日期")
|
@DateTimeFormat("yyyy-MM-dd")
|
private String monitorDate;
|
|
@ExcelProperty("降雨量(mm)")
|
//SJZT_DW dws_rain_res_di表 drp
|
private String drp;
|
|
//SJZT_DW dws_water_res_z_eight_detail_all表 rz 字段
|
@ExcelProperty("坝前水位(m)")
|
private String rz;
|
|
//SJZT_DW dws_water_res_z_eight_detail_all表 low_z 字段
|
@ExcelProperty("下游水位(m)")
|
private String lowZ;
|
|
//SJZT_DW dws_res_press_di 存avg_value
|
@ExcelProperty("测压管水位或渗压计值(m)")
|
private String avgValue;
|
|
//SJZT_DW dws_res_sl_di 存avg_spqn_value
|
@ExcelProperty("渗流量(L)")
|
private String avgSpqnValue;
|
}
|
