SELECT   A.VBELN,   A.VBELN    VBELNCOPY,   A.VBELN    AS VBELN1,   A.DO_VBELN,   A.ERDAT,   A.SHDAT,   A.NAME,   A.GROSS_BOX      I_COUNT,   A.GROSS_AMT      G_PRICE,   A.GROSS_AMT,   A.ADDR,   A.PERSON_NAME,   A.SFA_CAR_NUM,   SFA_NAME,   A.INSDT,   A.REMARK,   A.KUNNR,   A.LINKMAN,   A.LINKTEL,   A.SALE_TYPE,   A.STATUS,   A.SOURCE,   A.GROSS_ZK_AMT,   A.WAREHOUSE_ID,   A.ATX,   A.ZK_TYPE,   A.ZK_AMT,   A.UPDATEDT,   A.DID,   A.VL02N_DAT,   A.SFA_STATUS,   A.PRINT_COUNT,   A.dn_type AS dnType,   A.userid   from dn_order A  -- 交货单   where  A.fyfs in (60001,60003)        and A.did = #{did,jdbcType=VARCHAR}           and SUBSTR(A.erdat FROM 0 FOR 10) > #{dateStart}           and SUBSTR(A.erdat FROM 0 FOR 10) < #{dateEnd}           and A.STATUS in            #{status}                and A.dn_type =#{wOrderType}           AND A.vbeln like CONCAT('%',#{keyWord},'%')           AND A.name like CONCAT('%',#{keyWord},'%')           AND A.person_name like CONCAT('%',#{keyWord},'%')           AND (A.vbeln like CONCAT('%',#{keyWord},'%')     OR A.name like CONCAT('%',#{keyWord},'%')     OR A.person_name like CONCAT('%',#{keyWord},'%')     )           and A.SFA_STATUS=#{sfaStatus}           order by A.insdt,B.warehouse_name,BA.name           order by A.insdt desc