/** 插入父单信息 */
private void insertParentSo(Connection con, JumpMQOrderVo jumpMQOrderVo) {
PreparedStatement st = null;
String sql =
"insert into edw1_dev.REALTIME_METADATA_SO (ID, ENDUSERID, ORDERCODE, ORDERCREATETIME, ORDERTYPE, ORDERSTATUS, BIZTYPE, ORDERSOURCE, PARENTSOID, SITETYPE, ORDERAMOUNT, PRODUCTAMOUNT, ISLEAF, PAYSERVICETYPE, MSGSENDTIME, UPDT_TIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
try {
st = con.prepareStatement(sql);
st.setLong(1, jumpMQOrderVo.getId());
st.setLong(2, jumpMQOrderVo.getEndUserId());
st.setString(3, jumpMQOrderVo.getOrderCode());
// st.setDate(4, new java.sql.Date(jumpMQOrderVo.getOrderCreateTime().getTime()));
if (jumpMQOrderVo.getOrderCreateTime() != null) {
st.setTimestamp(4, new Timestamp(jumpMQOrderVo.getOrderCreateTime().getTime()));
} else {
st.setTimestamp(4, new Timestamp(new Date().getTime()));
}
st.setInt(5, jumpMQOrderVo.getOrderType());
st.setInt(6, jumpMQOrderVo.getOrderStatus());
st.setInt(7, jumpMQOrderVo.getBizType());
st.setInt(8, jumpMQOrderVo.getOrderSource());
st.setLong(9, jumpMQOrderVo.getParentSoId());
st.setInt(10, jumpMQOrderVo.getSiteType());
if (jumpMQOrderVo.getOrderAmount() != null) {
st.setDouble(11, jumpMQOrderVo.getOrderAmount().doubleValue());
} else {
st.setDouble(11, 0.0);
}
if (jumpMQOrderVo.getProductAmount() != null) {
st.setDouble(12, jumpMQOrderVo.getProductAmount().doubleValue());
} else {
st.setDouble(12, 0.0);
}
st.setInt(13, jumpMQOrderVo.getIsLeaf());
st.setInt(14, jumpMQOrderVo.getPayServiceType());
// st.setDate(15, new java.sql.Date(jumpMQOrderVo.getMsgSendTime().getTime()));
if (jumpMQOrderVo.getMsgSendTime() != null) {
st.setTimestamp(15, new Timestamp(jumpMQOrderVo.getMsgSendTime().getTime()));
} else {
st.setTimestamp(15, new Timestamp(new Date().getTime()));
}
st.setTimestamp(16, new Timestamp(new Date().getTime()));
st.executeQuery();
} catch (Exception e) {
logger.info("error: Metadata insert error ! ");
} finally {
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
