package jnpf.elnEntity.runtime;
|
|
import com.baomidou.mybatisplus.annotation.FieldFill;
|
import com.baomidou.mybatisplus.annotation.IdType;
|
import com.baomidou.mybatisplus.annotation.TableField;
|
import com.baomidou.mybatisplus.annotation.TableId;
|
import com.baomidou.mybatisplus.annotation.TableName;
|
import com.baomidou.mybatisplus.annotation.Version;
|
import com.fasterxml.jackson.core.type.TypeReference;
|
import com.fasterxml.jackson.databind.ObjectMapper;
|
import lombok.Data;
|
import org.apache.ibatis.type.BaseTypeHandler;
|
import org.apache.ibatis.type.JdbcType;
|
|
import java.io.Serializable;
|
import java.math.BigDecimal;
|
import java.sql.CallableStatement;
|
import java.sql.PreparedStatement;
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.sql.Types;
|
import java.util.Date;
|
import java.util.Map;
|
|
@Data
|
@TableName(value = "eln_formula_calculation_log", autoResultMap = true)
|
public class ElnFormulaCalculationLogEntity implements Serializable {
|
private static final long serialVersionUID = 1L;
|
|
@TableId(value = "f_id", type = IdType.INPUT)
|
private String id;
|
@TableField("dianzi_jilu_id")
|
private String dianziJiluId;
|
@TableField("xiuding_id")
|
private String xiudingId;
|
@TableField("muban_gongshi_bangding_id")
|
private String mubanGongshiBangdingId;
|
@TableField("gongshi_banben_id")
|
private String gongshiBanbenId;
|
@TableField("jieguo_muban_bangding_id")
|
private String jieguoMubanBangdingId;
|
@TableField("jieguo_ziduan_banben_id")
|
private String jieguoZiduanBanbenId;
|
@TableField("jisuan_caozuo_bianma")
|
private String jisuanCaozuoBianma;
|
@TableField("jisuan_moshi")
|
private String jisuanMoshi;
|
@TableField("jisuan_zhuangtai")
|
private String jisuanZhuangtai;
|
@TableField(value = "shuru_kuaizhao", jdbcType = JdbcType.OTHER,
|
typeHandler = InputSnapshotTypeHandler.class)
|
private Map<String, Object> shuruKuaizhao;
|
@TableField("jieguo_wenben")
|
private String jieguoWenben;
|
@TableField("jieguo_shuzhi")
|
private BigDecimal jieguoShuzhi;
|
@TableField("shibai_yuanyin")
|
private String shibaiYuanyin;
|
@TableField("jisuan_shijian")
|
private Date jisuanShijian;
|
@TableField("f_tenant_id")
|
private String fTenantId;
|
@Version
|
@TableField("f_version")
|
private Integer fVersion;
|
@TableField(value = "f_creator_user_id", fill = FieldFill.INSERT)
|
private String fCreatorUserId;
|
@TableField(value = "f_creator_time", fill = FieldFill.INSERT)
|
private Date fCreatorTime;
|
@TableField(value = "f_last_modify_user_id", fill = FieldFill.INSERT_UPDATE)
|
private String fLastModifyUserId;
|
@TableField(value = "f_last_modify_time", fill = FieldFill.INSERT_UPDATE)
|
private Date fLastModifyTime;
|
@TableField("f_delete_user_id")
|
private String fDeleteUserId;
|
@TableField("f_delete_time")
|
private Date fDeleteTime;
|
@TableField("f_delete_mark")
|
private Integer fDeleteMark;
|
|
public static final class InputSnapshotTypeHandler
|
extends BaseTypeHandler<Map<String, Object>> {
|
private static final ObjectMapper MAPPER = new ObjectMapper();
|
private static final TypeReference<Map<String, Object>> TYPE =
|
new TypeReference<Map<String, Object>>() { };
|
|
@Override
|
public void setNonNullParameter(PreparedStatement statement, int index,
|
Map<String, Object> parameter, JdbcType jdbcType) throws SQLException {
|
try {
|
statement.setObject(index, MAPPER.writeValueAsString(parameter), Types.OTHER);
|
} catch (Exception ex) {
|
throw new SQLException("权威计算输入快照序列化失败", ex);
|
}
|
}
|
|
@Override
|
public Map<String, Object> getNullableResult(ResultSet resultSet, String columnName)
|
throws SQLException {
|
return parse(resultSet.getString(columnName));
|
}
|
|
@Override
|
public Map<String, Object> getNullableResult(ResultSet resultSet, int columnIndex)
|
throws SQLException {
|
return parse(resultSet.getString(columnIndex));
|
}
|
|
@Override
|
public Map<String, Object> getNullableResult(CallableStatement statement, int columnIndex)
|
throws SQLException {
|
return parse(statement.getString(columnIndex));
|
}
|
|
private static Map<String, Object> parse(String json) throws SQLException {
|
if (json == null) {
|
return null;
|
}
|
try {
|
return MAPPER.readValue(json, TYPE);
|
} catch (Exception ex) {
|
throw new SQLException("权威计算输入快照解析失败", ex);
|
}
|
}
|
}
|
}
|
