<?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="permission"> <!-- --> <resultMap id="permissionBean" class="permission.service.bean.PermissionBean"> <result property="rowNumber" column="rowNumber" nullValue=""/> <result property="permissionIds" column="permissionIds" nullValue=""/> <result property="permissionNumber" column="permissionNumber" nullValue=""/> <result property="permissionName" column="permissionName" nullValue=""/> <result property="createdDate" column="createdDate" nullValue=""/> <result property="records" column="records" 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_intPermissionId AS 'permissionIds' ,t1.f_strPermissionNumber AS 'permissionNumber' ,t1.f_strPermissionName AS 'permissionName' ,t1.f_dtmCreated AS 'createdDate' ,0 AS 'records' from t_Permission t1 /* 主表 */ <dynamic prepend="WHERE"> <isNotNull property="filterKeys" prepend="WHERE"> <iterate property="filterKeys" conjunction="AND"> ( t1.f_strPermissionNumber LIKE '%$filterKeys[]$%' OR t1.f_strPermissionName LIKE '%$filterKeys[]$%' ) </iterate> </isNotNull> <isNotNull property="permissionIds" prepend="and"> t1.f_intPermissionId in ( #permissionIds# ) </isNotNull> <isNotEmpty prepend="and" property="permissionName"> t1.f_strPermissionName = #permissionName# </isNotEmpty> <isNotEmpty prepend="and" property="permissionNumber"> t1.f_strPermissionNumber = #permissionNumber# </isNotEmpty> </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="filterKeys" prepend="WHERE"> <iterate property="filterKeys" conjunction="AND"> ( t1.f_strPermissionNumber LIKE '%$filterKeys[]$%' OR t1.f_strPermissionName LIKE '%$filterKeys[]$%' ) </iterate> </isNotNull> <isNotNull property="permissionIds" prepend="and"> t1.f_intPermissionId in ( #permissionIds# ) </isNotNull> <isNotEmpty prepend="and" property="permissionName"> t1.f_strPermissionName = #permissionName# </isNotEmpty> <isNotEmpty prepend="and" property="permissionNumber"> t1.f_strPermissionNumber = #permissionNumber# </isNotEmpty> </dynamic> </statement> <!-- 增删改(含批量)Livon 20110616 ======================================================================================== --> <select id="permissionManage" parameterClass="permission.service.bean.PermissionBean" resultClass="permission.service.bean.PermissionBean" > exec p_Permission #action# ,#permissionIds# ,#organizationId# ,#permissionNumber# ,#permissionName# ,#description# ,#isActive# ,#note# </select> <!-- Valid Check ( Livon 20110617 ) ======================================================================================== --> <select id="validCheck" parameterClass="permission.service.bean.PermissionBean" resultClass="permission.service.bean.PermissionBean" > select count(t.f_intPermissionId) as 'records' , case when count(t.f_intPermissionId) > 0 then '无效值!' end as 'message' from ( select * from t_Permission t1 <dynamic prepend="WHERE"> <isNotNull prepend="and" property="permissionIds"> t1.f_intPermissionId <> #permissionIds# </isNotNull> <isNotEmpty prepend="and" property="permissionName"> t1.f_strPermissionName = #permissionName# </isNotEmpty> <isNotEmpty prepend="and" property="permissionNumber"> t1.f_strPermissionNumber = #permissionNumber# </isNotEmpty> </dynamic> ) t </select> </sqlMap>