<?xml version="1.0" encoding="GB2312"?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> <sqlMap namespace="rolePermission"> <!-- --> <resultMap id="rolePermissionBean" class="rolePermission.service.bean.PermissionBean"> <result property="rowNumber" column="rowNumber" nullValue=""/> <result property="rolePermissionIds" column="rolePermissionIds" nullValue=""/> <result property="roleIds" column="roleIds" nullValue=""/> <result property="permissionIds" column="permissionIds" nullValue=""/> <result property="strNote" column="strNote" nullValue=""/> </resultMap> <!-- 增删改(含批量)Livon 20110616 ======================================================================================== --> <statement id="getPermissionBeanList" resultMap="permissionBean" parameterClass="permission.service.bean.PermissionBean"> select top $pageSize$ * from ( select * from ( select ROW_NUMBER() OVER (ORDER BY f_dtmCreated DESC) AS 'rowNumber' ,t1.f_intRolePermissionId AS 'rolePermissionIds' ,t1.f_intRoleId AS 'roleIds' ,t1.f_intPermissionId AS 'permissionIds' ,t1.f_dtmCreated AS 'createdDate' ,t1.f_strNote AS 'strNote' from t_RolePermission t1 /* 主表 */ <dynamic prepend="WHERE"> <isNotNull property="roleIds" prepend="and"> t1.f_intRoleId in ( #roleIds# ) </isNotNull> </dynamic> ) t WHERE rowNumber > $pageSize$ * ( $pageNumber$ - 1 ) ) t </statement> <!-- 查询记录总数 Livon ======================================================================================== --> <statement id="getPermissionBeanList_records" resultClass="java.lang.Integer" parameterClass="permission.service.bean.PermissionBean"> select count(f_intPermissionId) as records from t_Permission t1 /* 主表 */ <dynamic prepend="WHERE"> <isNotNull property="roleIds" prepend="and"> t1.f_intRoleId in ( #roleIds# ) </isNotNull> </dynamic> </statement> <!-- 增删改(含批量)Livon 20110616 ======================================================================================== --> <select id="permissionManage" parameterClass="permission.service.bean.PermissionBean" resultClass="permission.service.bean.PermissionBean" > exec p_RolePermission #action# ,#rolePermissionIds# ,#roleIds# ,#permissionIds# ,#note# </select> </sqlMap>