ID_, ROAD_SEGMENT_ID_, ROAD_SEGMENT_NAME_, OFFICE_ID_, OFFICE_NAME_, COMPANY_ID_, COMPANY_NAME_, INITIATOR_, NAME_, TYPE_, TYPE_VALUE_, FIRST_PARTY_, SECOND_PARTY_, THIRD_PARTY_, CONTRACT_NUMBER_, UNIQUE_NUMBER_, CLASSIFICATION_NUMBER_, CONTRACT_AMOUNT_, RETENTION_MONEY_, CONTRACT_DATE_, TREATY_CONTENTS_, CONFIRMATION_MODE_, URL_, REMARKS_, CREATE_BY_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_, TENANT_ID_ SELECT * FROM BIZ_CONTRACT ${ew.customSqlSegment} AND CONTRACT_DATE_>=#{map.beginCheckDate,jdbcType=TIMESTAMP} AND CONTRACT_DATE_ <=#{map.endCheckDate,jdbcType=TIMESTAMP}