u206691
/
synyi-service


			
				
					
						
						
							123456789101112131415161718192021
							<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.synyi.edc.dao.ISqlbuilderDao" >
  <resultMap id="BaseResultMap" type="com.synyi.edc.pojo.Parameter" >
    <result column="org_code" property="orgCode" jdbcType="VARCHAR" />
    <result column="org_name" property="orgName" jdbcType="VARCHAR" />
    <result column="item_id" property="itemId" jdbcType="VARCHAR" />
    <result column="item_name" property="itemName" jdbcType="VARCHAR" />
  </resultMap>
  <select id="getAllOrgInfo" resultMap="BaseResultMap"  >
    select 
    org_code,org_name from mdm.organization
  </select>
  <select id="getAllLabInfo" resultMap="BaseResultMap"  parameterType="com.synyi.edc.pojo.Parameter">
    select item_id,item_name from mdm.lis_item where code_sys_id =197 
   	<if test="labName != null and labName != ''">
   		and item_name like '%${labName}%'  
   	</if>
  </select>
  
</mapper>