日期:2014-05-18 浏览次数:20737 次
<!-- 调用存储过程计算请假时长 -->
<parameterMap type="map" id="LeaveApplyDetailMap">
<parameter property="strEmployeeNo" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="beginDate" jdbcType="DATE" javaType="java.util.Date" mode="IN"/>
<parameter property="endDate" jdbcType="DATE" javaType="java.util.Date" mode="IN"/>
<parameter property="typeNo" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="resultCode" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
<parameter property="resultData" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
</parameterMap>
<!-- 检查请假日期是否有效 -->
<select id="LeaveCheck" parameterMap="LeaveApplyDetailMap">
CALL PKG_ATT.SP_Get_LeaveCheck(#{strEmployeeNo},#{beginDate},#{endDate},#{typeNo},#{resultCode},#{resultData})
</select>
Map map = new HashMap<String, Object>();
map.put("strEmployeeNo",detail.getStrEmployeeNo());
map.put("beginDate", detail.getBeginDate());
map.put("endDate", detail.getEndDate());
map.put("typeNo", detail.getStrTypeNo());
map.put("resultCode", "0");
map.put("resultData", "0");
dao.get("LeaveCheck", map);