b6b2aa2b5493db0d49e7f08f3c95390467148e71.svn-base 2.6 KB
<?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.phxl.modules.goods.dao.billsettlement.BillSettlementDao">

	<!--BaseResultMap -->
	<resultMap id="BaseResultMap"
		type="com.phxl.modules.goods.entity.billsettlement.BillSettlement">
		<id column="id" property="id" jdbcType="BIGINT" />
		<result column="settle_bill_no" property="settleBillNo" jdbcType="VARCHAR" />
		<result column="settle_date" property="settleDate" jdbcType="TIMESTAMP" />
		<result column="bill_state" property="billState" jdbcType="VARCHAR" />
		<result column="purchaser_corp_code" property="medCode" jdbcType="VARCHAR" />
		<result column="purchaser_corp_name" property="medName" jdbcType="VARCHAR" />
		<result column="supplier_code" property="supplierCode" jdbcType="VARCHAR" />
		<result column="supplier_name" property="supplierName" jdbcType="TIMESTAMP" />
		<result column="goods_sum" property="goodsSum" jdbcType="TINYINT" />
		<result column="amount" property="amount" jdbcType="DECIMAL" />
		<result column="begin_date" property="beginDate" jdbcType="TIMESTAMP" />
		<result column="end_date" property="endDate" jdbcType="TIMESTAMP" />
		<result column="use_bill_no" property="usebillno" jdbcType="VARCHAR" />
		<result column="create_time" property="create_time" jdbcType="TIMESTAMP" />
		<result column="update_time" property="update_time" jdbcType="TIMESTAMP" />  
	</resultMap>

	<!--Base_Column_List -->
	<sql id="Base_Column_List">id,settle_bill_no,settle_date,bill_state,purchaser_corp_code,purchaser_corp_name,supplier_code,supplier_name,goods_sum,amount,begin_date,end_date,use_bill_no,create_time,update_time</sql>

	
	<!-- 新增BillBack-->
    <insert id="insert"  parameterType="com.phxl.modules.goods.entity.billsettlement.BillSettlement">
	    insert into med_bill_settlement (id,settle_bill_no,settle_date,bill_state,purchaser_corp_code,purchaser_corp_name,supplier_code,supplier_name,goods_sum,amount,begin_date,end_date,use_bill_no,create_time,update_time)
	    values (
	            #{id,jdbcType=VARCHAR}
				,#{settleBillNo,jdbcType=VARCHAR}
				,#{settleDate,jdbcType=TIMESTAMP}
				,#{billState,jdbcType=VARCHAR}
				,#{medCode,jdbcType=VARCHAR}
				,#{medName,jdbcType=VARCHAR}
				,#{supplierCode,jdbcType=VARCHAR}
				,#{supplierName,jdbcType=TIMESTAMP}
				,#{goodsSum,jdbcType=TINYINT}
				,#{amount,jdbcType=DECIMAL}
				,#{beginDate,jdbcType=TIMESTAMP}
				,#{endDate,jdbcType=TIMESTAMP}
				,#{useBillNo,jdbcType=VARCHAR}
				,#{create_time,jdbcType=TIMESTAMP}
				,#{update_time,jdbcType=TIMESTAMP}
	    )
	</insert>

</mapper>