PowerPlusWaterMarkObject4396046, "DRAFT1", "宋体", 1, False, False, 0, 0). _

这看起来像是 Microsoft Office Word 中插入水印的代码。其中，PowerPlusWaterMarkObject4396046 是水印的名称，"DRAFT1" 是文本内容，"宋体" 是字体名称，1 是字体大小，False 表示不加粗，False 表示不倾斜，0 和 0 是水印的横向和纵向位置。

相关问题

SELECT DISTINCT c.ID AS id, c.NAME AS contName, c.CONTRACT_NO AS contractNo, c.INSTANCE_ID AS instanceId, c.UNDERTAKE_DEPT_ID AS remindDeptId, c.UNDERTAKE_DEPT_NAME AS sendDeptName, c.CREATE_USER_ID, c.CREATE_USER_NAME AS contractOpteraterName, c.PLAN_STATE AS planState, c.PLAN_STATE_NAME AS planStateName, aw.INSTANCE_ID AS inId, aw.CREATE_TIME AS sendTime FROM ( SELECT c.* FROM ( SELECT c.* FROM ( SELECT c.ORIGINAL_CONTRACT_ID, MAX(CREATE_TIME) CREATE_TIME FROM CONTRACT_DRAFT.C_CONTRACT_INFO c WHERE c.ORIGINAL_CONTRACT_ID IS NOT NULL AND c.ORIGINAL_CONTRACT_ID != '' GROUP BY c.ORIGINAL_CONTRACT_ID ) t LEFT JOIN CONTRACT_DRAFT.C_CONTRACT_INFO c ON t.ORIGINAL_CONTRACT_ID = c.ORIGINAL_CONTRACT_ID AND t.CREATE_TIME = c.CREATE_TIME UNION ALL SELECT c.* FROM CONTRACT_DRAFT.C_CONTRACT_INFO c WHERE ( c.ORIGINAL_CONTRACT_ID IS NULL OR c.ORIGINAL_CONTRACT_ID = '' ) AND c.ID NOT IN ( SELECT c.ORIGINAL_CONTRACT_ID FROM CONTRACT_DRAFT.C_CONTRACT_INFO c WHERE c.ORIGINAL_CONTRACT_ID IS NOT NULL AND c.ORIGINAL_CONTRACT_ID != '')) c WHERE c.deleted_flag = 0 AND c.BELONG = 1 AND sysdate > c.end_date AND c.plan_state IN (4100, 4110, 4120, 4200, 4210, 4220, 5100, 5110, 5120) ) c INNER JOIN (SELECT INSTANCE_ID,create_time,state FROM CONTRACT_DRAFT.C_ACTIVITY_WORKITEMS WHERE state = 'Waiting') aw ON c.INSTANCE_ID = aw.INSTANCE_ID LEFT JOIN (SELECT deleted_flag,CONT_ID FROM CONTRACT_DRAFT.C_GET_PAY_PLAN WHERE deleted_flag = 0 ) g ON c.ID = g.CONT_ID LEFT JOIN CONTRACT_DRAFT.C_OUR_ENTITY_INFO oe ON c.OUR_ENTITY_ID = oe.ID AND oe.DELETED_FLAG = 0 ORDER BY aw.CREATE_TIME DESC 优化

这是一个查询语句，用于从数据库中获取特定条件下的数据。该查询可以进行一些优化，包括使用内连接而不是左连接，并且将一些子查询转换为内联查询。以下是优化后的查询语句：

SELECT DISTINCT
c.ID AS id,
c.NAME AS contName,
c.CONTRACT_NO AS contractNo,
c.INSTANCE_ID AS instanceId,
c.UNDERTAKE_DEPT_ID AS remindDeptId,
c.UNDERTAKE_DEPT_NAME AS sendDeptName,
c.CREATE_USER_ID,
c.CREATE_USER_NAME AS contractOpteraterName,
c.PLAN_STATE AS planState,
c.PLAN_STATE_NAME AS planStateName,
aw.INSTANCE_ID AS inId,
aw.CREATE_TIME AS sendTime
FROM CONTRACT_DRAFT.C_CONTRACT_INFO c
INNER JOIN (
SELECT
INSTANCE_ID,
create_time,
state
FROM CONTRACT_DRAFT.C_ACTIVITY_WORKITEMS
WHERE state = 'Waiting'
) aw ON c.INSTANCE_ID = aw.INSTANCE_ID
LEFT JOIN CONTRACT_DRAFT.C_GET_PAY_PLAN g ON c.ID = g.CONT_ID AND g.deleted_flag = 0
LEFT JOIN CONTRACT_DRAFT.C_OUR_ENTITY_INFO oe ON c.OUR_ENTITY_ID = oe.ID AND oe.DELETED_FLAG = 0
WHERE
c.deleted_flag = 0
AND c.BELONG = 1
AND sysdate > c.end_date
AND c.plan_state IN (4100, 4110, 4120, 4200, 4210, 4220, 5100, 5110, 5120)
ORDER BY aw.CREATE_TIME DESC

请注意，我已经对查询进行了重构，并且没有修改查询条件。优化后的查询使用内连接和内联查询来提高查询性能。

优化这段代码：if (icbcDtlRsp.getBillSta().equals("CS01") && icbcDtlRsp.getRangeStage().equals("TF0101")) { //CS01已出票 & TFO101待收票---010004出票已登记 ecdsDrftInf.setDrftSndStat(getValueOrDefault(ECDSConstants.DRAFT_STATUS_CPYDJ, ecdsDrftInf.getDrftSndStat())); // 票据发送人状态 ecdsDrftInf.setDrftRcvStat(getValueOrDefault(ECDSConstants.DRAFT_STATUS_CPYDJ, ecdsDrftInf.getDrftRcvStat())); // 票据接收人状态 ecdsDrftInf.setDrftCurrStat(getValueOrDefault(ECDSConstants.DRAFT_STATUS_CPYDJ, ecdsDrftInf.getDrftCurrStat())); // 人行当前状态 } else if (ecdsDrftInf.getDrftOrgStat().equals(ECDSConstants.DRAFT_STATUS_CPYDJ) && icbcDtlRsp.getBillSta().equals("CS01") && icbcDtlRsp.getRangeStage().equals("TF0302")) { //CS01已出票 & TF0302已锁定--- 020001承兑待签收 ecdsDrftInf.setDrftSndStat(getValueOrDefault(ECDSConstants.DRAFT_STATUS_TSCDDQS, ecdsDrftInf.getDrftSndStat())); // 票据发送人状态 ecdsDrftInf.setDrftRcvStat(getValueOrDefault(ECDSConstants.DRAFT_STATUS_TSCDDQS, ecdsDrftInf.getDrftRcvStat())); // 票据接收人状态 ecdsDrftInf.setDrftCurrStat(getValueOrDefault(ECDSConstants.DRAFT_STATUS_TSCDDQS, ecdsDrftInf.getDrftCurrStat())); // 人行当前状态 } else if (ecdsDrftInf.getDrftOrgStat().equals(ECDSConstants.DRAFT_STATUS_CPYDJ) && icbcDtlRsp.getBillSta().equals("CS02") && icbcDtlRsp.getRangeStage().equals("TFO101")) { //CS02已承兑 & TFO101待收票---020006承兑已签收 ecdsDrftInf.setDrftSndStat(getValueOrDefault(ECDSConstants.DRAFT_STATUS_TSCDYQS, ecdsDrftInf.getDrftSndStat())); // 票据发送人状态 ecdsDrftInf.setDrftRcvStat(getValueOrDefault(ECDSConstants.DRAFT_STATUS_TSCDYQS, ecdsDrftInf.getDrftRcvStat())); // 票据接收人状态 ecdsDrftInf.setDrftCurrStat(getValueOrDefault(ECDSConstants.DRAFT_STATUS_TSCDYQS, ecdsDrftInf.getDrftCurrStat())); // 人行当前状态 }

可以将常量提取出来，避免多次调用 getValueOrDefault() 方法，可以使用一个 Map 存储常量值，然后根据条件直接获取即可。同时，可以将多个 if/else if 语句转换为一个 switch 语句，使代码更加简洁易读。优化后的代码如下：

private static final Map<String, String> DRAFT_STATUS_MAP = new HashMap<>();
static {
    DRAFT_STATUS_MAP.put(ECDSConstants.DRAFT_STATUS_CPYDJ, ECDSConstants.DRAFT_STATUS_TSCDDQS);
    DRAFT_STATUS_MAP.put(ECDSConstants.DRAFT_STATUS_TSCDDQS, ECDSConstants.DRAFT_STATUS_TSCDDQS);
    DRAFT_STATUS_MAP.put(ECDSConstants.DRAFT_STATUS_TSCDYQS, ECDSConstants.DRAFT_STATUS_TSCDYQS);
}

// ...

switch (icbcDtlRsp.getBillSta() + icbcDtlRsp.getRangeStage()) {
    case "CS01TF0101": // CS01已出票 & TFO101待收票---010004出票已登记
        ecdsDrftInf.setDrftSndStat(DRAFT_STATUS_MAP.getOrDefault(ecdsDrftInf.getDrftSndStat(), ECDSConstants.DRAFT_STATUS_CPYDJ));
        ecdsDrftInf.setDrftRcvStat(DRAFT_STATUS_MAP.getOrDefault(ecdsDrftInf.getDrftRcvStat(), ECDSConstants.DRAFT_STATUS_CPYDJ));
        ecdsDrftInf.setDrftCurrStat(DRAFT_STATUS_MAP.getOrDefault(ecdsDrftInf.getDrftCurrStat(), ECDSConstants.DRAFT_STATUS_CPYDJ));
        break;
    case "CS01TF0302": // CS01已出票 & TF0302已锁定--- 020001承兑待签收
        if (ecdsDrftInf.getDrftOrgStat().equals(ECDSConstants.DRAFT_STATUS_CPYDJ)) {
            ecdsDrftInf.setDrftSndStat(DRAFT_STATUS_MAP.getOrDefault(ecdsDrftInf.getDrftSndStat(), ECDSConstants.DRAFT_STATUS_TSCDDQS));
            ecdsDrftInf.setDrftRcvStat(DRAFT_STATUS_MAP.getOrDefault(ecdsDrftInf.getDrftRcvStat(), ECDSConstants.DRAFT_STATUS_TSCDDQS));
            ecdsDrftInf.setDrftCurrStat(DRAFT_STATUS_MAP.getOrDefault(ecdsDrftInf.getDrftCurrStat(), ECDSConstants.DRAFT_STATUS_TSCDDQS));
        }
        break;
    case "CS02TFO101": // CS02已承兑 & TFO101待收票---020006承兑已签收
        if (ecdsDrftInf.getDrftOrgStat().equals(ECDSConstants.DRAFT_STATUS_CPYDJ)) {
            ecdsDrftInf.setDrftSndStat(DRAFT_STATUS_MAP.getOrDefault(ecdsDrftInf.getDrftSndStat(), ECDSConstants.DRAFT_STATUS_TSCDYQS));
            ecdsDrftInf.setDrftRcvStat(DRAFT_STATUS_MAP.getOrDefault(ecdsDrftInf.getDrftRcvStat(), ECDSConstants.DRAFT_STATUS_TSCDYQS));
            ecdsDrftInf.setDrftCurrStat(DRAFT_STATUS_MAP.getOrDefault(ecdsDrftInf.getDrftCurrStat(), ECDSConstants.DRAFT_STATUS_TSCDYQS));
        }
        break;
    default:
        break;
}