<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="SettleAccountsDao">
<typeAlias alias="SettleAccounts" type="com.jala.finance.entity.SettleAccounts" />
<resultMap id="SettleAccounts-Rusult" class="SettleAccounts">
<result property="k3code" column="k3code" jdbcType="VARCHAR2" />
<result property="vid" column="vid" jdbcType="NUMBER" nullValue="0" />
<result property="settleAccountsId" column="settle_accounts_id" jdbcType="NUMBER" nullValue="0" />
<result property="orderSourceTypeId" column="order_source_type_id" jdbcType="NUMBER" nullValue="0" />
<result property="orderSourceTypeName" column="order_source_type_name" jdbcType="VARCHAR2" />
<result property="settleAccountsDrpId" column="settle_accounts_drp_id" jdbcType="VARCHAR2" />
<result property="settleAccountsType" column="settle_accounts_type" jdbcType="VARCHAR2" />
<result property="dealerName" column="dealer_name" jdbcType="VARCHAR2" />
<result property="ccUserId" column="cc_user_id" jdbcType="NUMBER" nullValue="0" />
<result property="lastCcUserId" column="last_cc_user_id" jdbcType="NUMBER" nullValue="0" />
<result property="createTime" column="create_time" jdbcType="VARCHAR2" />
<result property="lastTime" column="last_time" jdbcType="VARCHAR2" />
</resultMap>
<select id="SettleAccounts-SelectByKey" resultMap="SettleAccounts-Rusult">
<![CDATA[
select
k3code,
settle_accounts_id,
order_source_type_id,
order_source_type_name,
settle_accounts_drp_id,
settle_accounts_type,
dealer_name,
cc_user_id,
last_cc_user_id,
create_time,
last_time,
vid
from CRM_SETTLE_ACCOUNTS
where settleAccountsId = #value#
]]>
</select>
<select id="SettleAccounts-SelectByObject" resultMap="SettleAccounts-Rusult">
select
k3code,
settle_accounts_id,
order_source_type_id,
order_source_type_name,
settle_accounts_drp_id,
settle_accounts_type,
dealer_name,
cc_user_id,
last_cc_user_id,
create_time,
last_time,
vid
from CRM_SETTLE_ACCOUNTS
<dynamic prepend="WHERE">
<isNotNull prepend="and" property="k3code">
k3code = #k3code#
</isNotNull>
<isNotEqual prepend="and" property="vid" compareValue="0">
vid = #vid#
</isNotEqual>
<isNotEqual prepend="and" property="settleAccountsId" compareValue="0">
settle_accounts_id = #settleAccountsId#
</isNotEqual>
<isNotEqual prepend="and" property="orderSourceTypeId" compareValue="0">
order_source_type_id = #orderSourceTypeId#
</isNotEqual>
<isNotNull prepend="and" property="orderSourceTypeName">
order_source_type_name = #orderSourceTypeName#
</isNotNull>
<isNotNull prepend="and" property="settleAccountsDrpId">
settle_accounts_drp_id = #settleAccountsDrpId#
</isNotNull>
<isNotNull prepend="and" property="settleAccountsType">
settle_accounts_type = #settleAccountsType#
</isNotNull>
<isNotNull prepend="and" property="dealerName">
dealer_name = #dealerName#
</isNotNull>
<isNotEqual prepend="and" property="ccUserId" compareValue="0">
cc_user_id = #ccUserId#
</isNotEqual>
<isNotEqual prepend="and" property="lastCcUserId" compareValue="0">
last_cc_user_id = #lastCcUserId#
</isNotEqual>
<isNotNull prepend="and" property="createTime">
create_time = #createTime#
</isNotNull>
<isNotNull prepend="and" property="lastTime">
last_time = #lastTime#
</isNotNull>
</dynamic>
</select>
<!-- mapped statement for IbatisWpTingDAO.insert -->
<insert id="SettleAccounts-Insert" parameterClass="SettleAccounts">
<![CDATA[
INSERT INTO CRM_SETTLE_ACCOUNTS(
k3code,
settle_accounts_id,
order_source_type_id,
order_source_type_name,
settle_accounts_drp_id,
settle_accounts_type,
dealer_name,
cc_user_id,
last_cc_user_id,
create_time,
last_time,
vid
)VALUES(
#k3code#,
#settleAccountsId#,
#orderSourceTypeId#,
#orderSourceTypeName#,
#settleAccountsDrpId#,
#settleAccountsType#,
#dealerName#,
#ccUserId#,
#lastCcUserId#,
#createTime#,
#lastTime#,
1
)
]]>
</insert>
<delete id="SettleAccounts-DeleteByKey">
<![CDATA[
delete from CRM_SETTLE_ACCOUNTS
where settleAccountsId = #value#
]]>
</delete>
<delete id="SettleAccounts-DeleteByObject" parameterClass="SettleAccounts">
<![CDATA[
delete from CRM_SETTLE_ACCOUNTS
where settleAccountsId = #settleAccountsId#
]]>
</delete>
<update id="SettleAccounts-Update" parameterClass="SettleAccounts">
<![CDATA[
update CRM_SETTLE_ACCOUNTS
set
k3code = #k3code#,
order_source_type_id = #orderSourceTypeId#,
order_source_type_name = #orderSourceTypeName#,
settle_accounts_drp_id = #settleAccountsDrpId#,
settle_accounts_type = #settleAccountsType#,
dealer_name = #dealerName#,
cc_user_id = #ccUserId#,
last_cc_user_id = #lastCcUserId#,
create_time = #createTime#,
last_time = #lastTime#,
vid = vid + 1
where settleAccountsId = #settleAccountsId#
and vid = #vid#
]]>
</update>
</sqlMap>