<?xml version="1.0" encoding="GBK"?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> <sqlMap namespace="bomGroup"> <resultMap id="BomGroupBean" class="bomGroup.service.bean.StockBillBean"> <result property="rowNumber" column="序号" nullValue=""></result> <result property="bomGroupId" column="主键ID" nullValue=""></result> <result property="parentId" column="父类ID" nullValue=""></result> <result property="name" column="名称" nullValue=""></result> <result property="number" column="编号" nullValue=""></result> <result property="bootId" column="启动ID" nullValue=""></result> <result property="parentName" column="父名称" nullValue=""></result> </resultMap> <select id="getBomGroup" resultMap="BomGroupBean" parameterClass="bomGroup.service.bean.StockBillBean"> SELECT TOP 10 * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY BG1.FInterID DESC) AS 序号 ,BG1.FInterID AS 主键ID ,BG1.FParentID AS 父类ID ,BG1.FName AS 名称 ,BG1.FNumber AS 编号 ,BG1.FBootID AS 启动ID ,BG.FName AS PARENTNAME AS 父名称 FROM ICBOMGroup BG INNER JOIN ICBOMGroup BG1 ON BG.FInterID=BG1.FParentID <dynamic prepend="WHERE "> <isNotNull property="filterKeys"> <iterate property="filterKeys" conjunction="AND"> (BG1.FName LIKE '%$filterKeys[]$%') </iterate> </isNotNull> </dynamic> <!--[CDATA[) T WHERE 序号 >$pageSize$ * ( $pageNumber$ - 1 )) T ]]--> </select> <select id="getBomGroupCount" resultClass="java.lang.Integer" parameterClass="bomGroup.service.bean.StockBillBean"> SELECT COUNT(BG1.FInterID) AS BGCOUNT FROM ICBOMGroup BG INNER JOIN ICBOMGroup BG1 ON BG.FInterID=BG1.FParentID <dynamic prepend="WHERE "> <isNotNull property="filterKeys"> <iterate property="filterKeys" conjunction="AND"> (BG1.FName LIKE '%$filterKeys[]$%') </iterate> </isNotNull> </dynamic> </select> <select id="validCheck" resultClass="java.lang.Integer" parameterClass="bomGroup.service.bean.StockBillBean"> SELECT COUNT(FInterID) FROM ICBOMGroup WHERE FName =#FName# AND FPARENTID=#FPARENTID# </select> <procedure id="bomGroupManage" parameterClass="bomGroup.service.bean.BomGroupBean"> exec p_bomGroup #action# ,#bomGroupId# ,#parentId# ,#name# ,#number# ,#bootId# </procedure> </sqlMap>