org_struct.xml.svn-base

一个实用的CMS管理

<?xml version="1.0" encoding="UTF-8" ?> 
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" 
"http://ibatis.apache.org/dtd/sql-map-2.dtd"> 
<sqlMap namespace="Org_Struct"> 
<typeAlias alias="org_struct" type="com.suncms.domain.Org_Struct"/> 

<resultMap id="org_structInfoResult"  class="Org_Struct"> 
<result property="row_id" column="ROW_ID"/> 
<result property="org_name" column="ORG_NAME"/> 
<result property="org_desc" column="ORG_DESC"/> 
<result property="parent_id" column="PARENT_ID"/> 
<result property="parent_name" column="PARENT_NAME"/> 
<result property="org_type" column="ORG_TYPE"/> 
<result property="create_by" column="CREATE_BY"/> 
<result property="create_time" column="CREATE_TIME"/> 
<result property="update_by" column="UPDATE_BY"/> 
<result property="update_time" column="UPDATE_TIME"/> 
 </resultMap> 
<insert id="insertOrg_Struct" parameterClass="org_struct"> 
INSERT INTO 
Org_Struct (
ROW_ID,
ORG_NAME,
ORG_DESC,
PARENT_ID,
PARENT_NAME,
ORG_TYPE,
CREATE_BY,
CREATE_TIME,
UPDATE_BY,
UPDATE_TIME
)
 values(
#row_id#,
#org_name#,
#org_desc#,
#parent_id#,
#parent_name#,
#org_type#,
#create_by#,
#create_time#,
#update_by#,
#update_time#
) 
</insert> 

<select id="getOrgClass" resultMap="org_structInfoResult" >
      select * from ORG_STRUCT
</select>

<select id="getValidOrgClass" resultMap="org_structInfoResult" >
      select * from ORG_STRUCT where ORG_TYPE = 'Y'
</select>

<select id="getOrgClassByParID" resultMap="org_structInfoResult" parameterClass="java.lang.String">
      select * from ORG_STRUCT where PARENT_ID=#parent_id#
</select>

<select id="getOrgClassByID" resultMap="org_structInfoResult" parameterClass="java.lang.String">
      select * from ORG_STRUCT where ROW_ID=#row_id#
</select>
 
 <select id="getOrgClassRoot" resultMap="org_structInfoResult" >
      select * from ORG_STRUCT where PARENT_ID='0'
</select>
<select id="getOrgByName" resultMap="org_structInfoResult" parameterClass="java.lang.String">
      select * from ORG_STRUCT where ORG_NAME=#org_name#
</select>

 <update id="updateorgById" parameterClass="org_struct">
      update ORG_STRUCT set 
      ROW_ID=#row_id#,ORG_NAME=#org_name#,ORG_DESC=#org_desc#,PARENT_ID=#parent_id#,PARENT_NAME=#parent_name#,ORG_TYPE=#org_type#
      where ROW_ID=#row_id#
 </update>
<select id="getOrgByNotUserID" resultMap="org_structInfoResult" parameterClass="java.lang.String">
      select * from ORG_STRUCT  where row_id not in (select ORG_ID from USER_ORG where USER_ID=#user_id#)
</select>
<select id="getOrgByIsUserID" resultMap="org_structInfoResult" parameterClass="java.lang.String">
      select * from ORG_STRUCT  where row_id in (select ORG_ID from USER_ORG where user_id=#user_id#)
</select>
</sqlMap>