= NVL(?, '000') AND A.COIL_THK <= NVL(?, '999') AND A.COIL_WTH >= NVL(?, '00000') AND A.COIL_WTH <= NVL(?, '99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND A.ORD_NO || '&' LIKE ? || '%' AND A.CUR_PROG_CD || '&' LIKE ? || '%' AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%' AND E.SMP_SEND_DTIME || '&' LIKE ? || '%' AND A.PRODNM_CD || '&' LIKE ? || '%' AND A.ORD_FL || '&' LIKE ? || '%' ]]> = NVL(?, '000') AND A.COIL_THK <= NVL(?, '999') AND A.COIL_WTH >= NVL(?, '00000') AND A.COIL_WTH <= NVL(?, '99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND A.ORD_NO || '&' LIKE ? || '%' AND A.CUR_PROG_CD || '&' LIKE ? || '%' AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%' AND E.SMP_SEND_DTIME || '&' LIKE ? || '%' AND A.PRODNM_CD || '&' LIKE ? || '%' AND A.ORD_FL || '&' LIKE ? || '%' ]]> = NVL(?, 0) AND SUBSTR(NVL(A.mILL_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND NVL(W.WANGGOU_YN,'N') LIKE ? || '%' -- AND A.ORD_NO || '&' LIKE ? || '%' order by a.old_sampl_no desc ]]> = NVL(?, '00000000') AND NVL(T.MILL_TIME, '00000000') <= NVL(?, '99999999') AND NVL(W.WANGGOU_YN,'N') LIKE ? || '%' -- AND A.ORD_NO || '&' LIKE ? || '%' order by T.old_sampl_no desc ]]> = NVL(?, 0) AND SUBSTR(NVL(A.mILL_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND NVL(W.WANGGOU_YN,'N') LIKE ? || '%' -- AND A.ORD_NO || '&' LIKE ? || '%' order by a.old_sampl_no desc ]]> = NVL(?, '00000000') AND NVL(T.MILL_TIME, '00000000') <= NVL(?, '99999999') AND NVL(W.WANGGOU_YN,'N') LIKE ? || '%' -- AND A.ORD_NO || '&' LIKE ? || '%' order by T.old_sampl_no desc ]]> insert into TBC01_WSXS_COIL_COM ( COIL_NO, WANGGOU_YN, PROD_LINE, WANGGOU_INFO, REMARKS, REG_PGM_ID, REG_ID, REG_DTIME ) VALUES(?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')) UPDATE TBC01_WSXS_COIL_COM SET WANGGOU_YN = ? --网购卷标识 ,REMARKS = ? ,MOD_PGM_ID = ? ,MOD_ID = ? ,MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE COIL_NO = ? --目标钢号