日期:2014-05-16 浏览次数:20500 次
<!-- Added by Me for C08_Story17 on 2011/10/08 begin --> <!-- 根据申请单号查询所有的日志记录:--> <select id="findLogByApplyFormID" parameterClass="java.util.HashMap" resultClass="java.util.HashMap" remapResults="true"> <![CDATA[ select PARTICIPANT_TIME, poForm.PARTICIPANT_ID, poForm.WF_JOB_POSITION from SUP_PO_APPLY_FORM_LOG poForm where poForm.APPLYFORM_ID = #applyFormID# ]]> </select> <!-- Added by Me for C08_Story17 on 2011/10/08 end -->
<select id="findLogByApplyFormID" parameterClass="java.util.HashMap" resultClass="java.util.HashMap" remapResults="true"> <![CDATA[ select (to_char(poForm.PARTICIPANT_TIME,'DD-MM-YYYY HH:MI:SS'))PARTICIPANT_TIME poForm.PARTICIPANT_ID, poForm.WF_JOB_POSITION from SUP_PO_APPLY_FORM_LOG poForm where poForm.APPLYFORM_ID = #applyFormID# ]]> </select>