<?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.chinacreator.video.mapper.ShangHaiOrderDao" >
  		
    <insert id="addShInPaInfo" >
       INSERT INTO TL_SHORDER_INOUT_PARAMS(
			ID,	TRADE_ID, TRANS_ID, ACCOUNT_ID, INPARAMS, INSERTTIME)
 		VALUES(#{logid},#{tradeid},#{transid},#{accountid},#{inparams},SYSDATE)
    </insert>
    
    <select id="getShInPaInfoById" parameterType="string"  resultType="Map" >
       SELECT * FROM TL_SHORDER_INOUT_PARAMS WHERE ID = #{id}        
    </select>

    <select id="getCsMakeupConf" resultType="java.util.Map">
      select  *  from  TB_CSMAKEUP_PROD_CONF where  BUSITYPE='5' and status='0'  and  spid=#{spid}
    </select>

    <update id="updShInPaInfo" >
		UPDATE TL_SHORDER_INOUT_PARAMS SET OUTPARAMS =  #{outparams}
		WHERE ID = #{logid} 
	</update> 	 
</mapper>