MyBatis动态查询 模糊查询实例sql
来源:互联网 发布:java开发实战经典视频 编辑:程序博客网 时间:2024/04/28 06:21
<?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="Site">
<resultMap id="siteResultMap" type="Site">
<id column="ID" jdbcType="DECIMAL" property="id"/>
<result column="LOCK_VERSION" jdbcType="DECIMAL" property="version"/>
<result column="CREATE_TIME" jdbcType="TIMESTAMP" property="createTime"/>
<result column="CREATOR" jdbcType="VARCHAR" property="creator"/>
<result column="CREATOR_NAME" jdbcType="VARCHAR" property="creatorName"/>
<result column="LAST_UPDATE_TIME" jdbcType="TIMESTAMP" property="lastUpdateTime"/>
<result column="LAST_UPDATOR" jdbcType="VARCHAR" property="lastUpdator"/>
<result column="LAST_UPDATOR_NAME" jdbcType="VARCHAR" property="lastUpdatorName"/>
<result column="REMARK" jdbcType="VARCHAR" property="remark"/>
<result column="DEFAULT_CURRENCY" jdbcType="DECIMAL" property="defaultCurrency"/>
<result column="DISPATCH_FEE_SITE_ID" jdbcType="DECIMAL" property="dispatchFeeSiteId"/>
<result column="FINANCE_ONE_CENTER_ID" jdbcType="DECIMAL" property="financeOneCenterId"/>
<result column="FINANCE_TWO_CENTER_ID" jdbcType="DECIMAL" property="financeTwoCenterId"/>
<result column="FINANCE_THREE_CENTER_ID" jdbcType="DECIMAL" property="financeThreeCenterId"/>
<result column="FINANCE_FOUR_CENTER_ID" jdbcType="DECIMAL" property="financeFourCenterId"/>
<result column="FINANCE_FIVE_CENTER_ID" jdbcType="DECIMAL" property="financeFiveCenterId"/>
<result column="SETTLEMENT_SITE_ID" jdbcType="DECIMAL" property="settlementSiteId"/>
<result column="SUPERIOR_SITE_ID" jdbcType="DECIMAL" property="superiorSiteId"/>
<result column="DISPATCH_FEE_SITE_NAME" jdbcType="VARCHAR" property="dispatchFeeSiteName"/>
<result column="FINANCE_FIVE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeFiveCenterSiteName"/>
<result column="FINANCE_FOUR_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeFourCenterSiteName"/>
<result column="FINANCE_ONE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeOneCenterSiteName"/>
<result column="FINANCE_THREE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeThreeCenterSiteName"/>
<result column="FINANCE_TWO_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeTwoCenterSiteName"/>
<result column="SETTLEMENT_SITE_NAME" jdbcType="VARCHAR" property="settlementSiteName"/>
<result column="SUPERIOR_SITE_NAME" jdbcType="VARCHAR" property="superiorSiteName"/>
<result column="PHONE" jdbcType="VARCHAR" property="phone"/>
<result column="PRINCIPAL" jdbcType="VARCHAR" property="principal"/>
<result column="SITE_CODE" jdbcType="VARCHAR" property="siteCode"/>
<result column="SITE_NAME" jdbcType="VARCHAR" property="siteName"/>
<result column="SITE_TYPE_ID" jdbcType="DECIMAL" property="siteTypeId"/>
<result column="SITE_TYPE_NAME" jdbcType="VARCHAR" property="siteTypeName"/>
<result column="CANTON_ID" jdbcType="DECIMAL" property="cantonId"/>
<result column="CANTON_NAME" jdbcType="VARCHAR" property="cantonName"/>
<result column="COUNTY_ID" jdbcType="DECIMAL" property="countyId"/>
<result column="COUNTY_NAME" jdbcType="VARCHAR" property="countyName"/>
<result column="CITY_ID" jdbcType="DECIMAL" property="cityId"/>
<result column="CITY_NAME" jdbcType="VARCHAR" property="cityName"/>
<result column="AREA_ID" jdbcType="DECIMAL" property="areaId"/>
<result column="AREA_NAME" jdbcType="VARCHAR" property="areaName"/>
<result column="PROVINCE_ID" jdbcType="DECIMAL" property="provinceId"/>
<result column="PROVINCE_NAME" jdbcType="VARCHAR" property="provinceName"/>
<result column="RANGE_ID" jdbcType="DECIMAL" property="rangeId"/>
<result column="RANGE_NAME" jdbcType="VARCHAR" property="rangeName"/>
<result column="PRICE_ID" jdbcType="DECIMAL" property="priceId"/>
<result column="PRICE_PARENT_ID" jdbcType="DECIMAL" property="priceParentId"/>
<result column="PRICE_TREEPATH" jdbcType="VARCHAR" property="priceTreepath"/>
<result column="DEFAULT_SEND_PLACE" jdbcType="VARCHAR" property="defaultSendPlace"/>
<result column="IS_ALLOW_TOPAYMENT" jdbcType="DECIMAL" property="isAllowTopayment"/>
<result column="MANAGER" jdbcType="VARCHAR" property="manager"/>
<result column="SALE_PHONE" jdbcType="VARCHAR" property="salePhone"/>
<result column="FAX" jdbcType="VARCHAR" property="fax"/>
<result column="SITE_DESC" jdbcType="VARCHAR" property="siteDesc"/>
<result column="DISPATCH_RANGE" jdbcType="VARCHAR" property="dispatchRange"/>
<result column="NOT_DISPATCH_RANGE" jdbcType="VARCHAR" property="notDispatchRange"/>
<result column="DISPATCH_TIME_LIMIT" jdbcType="VARCHAR" property="dispatchTimeLimit"/>
<result column="IS_ALLOW_AGENT_MONEY" jdbcType="DECIMAL" property="isAllowAgentMoney"/>
<result column="PUBLIC_REMARK" jdbcType="VARCHAR" property="publicRemark"/>
<result column="PRIVATE_REMARK" jdbcType="VARCHAR" property="privateRemark"/>
<result column="MANAGER_PHONE" jdbcType="VARCHAR" property="managerPhone"/>
<result column="EXIGENCE_PHONE" jdbcType="VARCHAR" property="exigencePhone"/>
<result column="DISPATCH_MONEY_DESC" jdbcType="VARCHAR" property="dispatchMoneyDesc"/>
<result column="ORDER_BY" jdbcType="DECIMAL" property="orderBy"/>
<result column="IS_CALC_SITE" jdbcType="DECIMAL" property="isCalcSite"/>
<result column="FINANCIAL_ACCOUNT" jdbcType="VARCHAR" property="financialAccount"/>
<result column="SAME_SITE" jdbcType="VARCHAR" property="sameSite"/>
<result column="SAME_SITE_ID" jdbcType="VARCHAR" property="sameSiteId"/>
<result column="MODIFY_SITE" jdbcType="VARCHAR" property="modifySite"/>
<result column="TOPARMENT_GROUP_NAME" jdbcType="VARCHAR" property="toparmentGroupName"/>
<result column="CAR_START_TIME" jdbcType="VARCHAR" property="carStartTime"/>
<result column="CAR_END_TIME" jdbcType="VARCHAR" property="carEndTime"/>
<result column="IS_STOP" jdbcType="DECIMAL" property="isStop"/>
<result column="WEB_RANGE" jdbcType="VARCHAR" property="webRange"/>
<result column="IS_NOT_INPUT" jdbcType="DECIMAL" property="isNotInput"/>
<result column="DISP_FEE1" jdbcType="DECIMAL" property="dispFee1"/>
<result column="DISP_FEE2" jdbcType="DECIMAL" property="dispFee2"/>
<result column="IS_PROBLEM_NOTIFY_SUPER" jdbcType="DECIMAL" property="isProblemNotifySuper"/>
<result column="CALC_PROVINCE" jdbcType="VARCHAR" property="calcProvince"/>
<result column="WEB_SUPERIOR_SITE" jdbcType="VARCHAR" property="webSuperiorSite"/>
<result column="GOODS_PAYMENT_LIMITED" jdbcType="DECIMAL" property="goodsPaymentLimited"/>
<result column="WEB_SITE_NAME" jdbcType="VARCHAR" property="webSiteName"/>
<result column="CAR_START_TIME1" jdbcType="VARCHAR" property="carStartTime1"/>
<result column="CAR_END_TIME1" jdbcType="VARCHAR" property="carEndTime1"/>
<result column="IS12580" jdbcType="DECIMAL" property="is12580"/>
<result column="POST_CODE" jdbcType="VARCHAR" property="postCode"/>
<result column="TOPARMENT_GROUP_ID" jdbcType="DECIMAL" property="toparmentGroupId"/>
<result column="LAT_LNG" jdbcType="VARCHAR" property="latLng"/>
<result column="OVERLAY_VIEW" jdbcType="VARCHAR" property="overlayView"/>
<result column="IS_FINANCE_CENTER" jdbcType="DECIMAL" property="isFinanceCenter"/>
<result column="MODIFY_SITE_ID" jdbcType="DECIMAL" property="modifySiteId"/>
<result column="SYNC_VERSION" jdbcType="DECIMAL" property="syncVersion"/>
<result column="IS_DIRECT_SALE" jdbcType="DECIMAL" property="isDirectSale"/>
<result column="IS_CONTROL_LOGIN" jdbcType="DECIMAL" property="isControlLogin"/>
</resultMap>
<resultMap id="siteVoResultMap" type="SiteVO">
<id column="ID" jdbcType="DECIMAL" property="id"/>
<result column="LOCK_VERSION" jdbcType="DECIMAL" property="version"/>
<result column="CREATE_TIME" jdbcType="TIMESTAMP" property="createTime"/>
<result column="CREATOR" jdbcType="VARCHAR" property="creator"/>
<result column="CREATOR_NAME" jdbcType="VARCHAR" property="creatorName"/>
<result column="LAST_UPDATE_TIME" jdbcType="TIMESTAMP" property="lastUpdateTime"/>
<result column="LAST_UPDATOR" jdbcType="VARCHAR" property="lastUpdator"/>
<result column="LAST_UPDATOR_NAME" jdbcType="VARCHAR" property="lastUpdatorName"/>
<result column="REMARK" jdbcType="VARCHAR" property="remark"/>
<result column="DEFAULT_CURRENCY" jdbcType="DECIMAL" property="defaultCurrency"/>
<result column="DISPATCH_FEE_SITE_ID" jdbcType="DECIMAL" property="dispatchFeeSiteId"/>
<result column="FINANCE_ONE_CENTER_ID" jdbcType="DECIMAL" property="financeOneCenterId"/>
<result column="FINANCE_TWO_CENTER_ID" jdbcType="DECIMAL" property="financeTwoCenterId"/>
<result column="FINANCE_THREE_CENTER_ID" jdbcType="DECIMAL" property="financeThreeCenterId"/>
<result column="FINANCE_FOUR_CENTER_ID" jdbcType="DECIMAL" property="financeFourCenterId"/>
<result column="FINANCE_FIVE_CENTER_ID" jdbcType="DECIMAL" property="financeFiveCenterId"/>
<result column="SETTLEMENT_SITE_ID" jdbcType="DECIMAL" property="settlementSiteId"/>
<result column="SUPERIOR_SITE_ID" jdbcType="DECIMAL" property="superiorSiteId"/>
<result column="DISPATCH_FEE_SITE_NAME" jdbcType="VARCHAR" property="dispatchFeeSiteName"/>
<result column="FINANCE_FIVE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeFiveCenterSiteName"/>
<result column="FINANCE_FOUR_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeFourCenterSiteName"/>
<result column="FINANCE_ONE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeOneCenterSiteName"/>
<result column="FINANCE_THREE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeThreeCenterSiteName"/>
<result column="FINANCE_TWO_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeTwoCenterSiteName"/>
<result column="SETTLEMENT_SITE_NAME" jdbcType="VARCHAR" property="settlementSiteName"/>
<result column="SUPERIOR_SITE_NAME" jdbcType="VARCHAR" property="superiorSiteName"/>
<result column="PHONE" jdbcType="VARCHAR" property="phone"/>
<result column="PRINCIPAL" jdbcType="VARCHAR" property="principal"/>
<result column="SITE_CODE" jdbcType="VARCHAR" property="siteCode"/>
<result column="SITE_NAME" jdbcType="VARCHAR" property="siteName"/>
<result column="SITE_TYPE_ID" jdbcType="DECIMAL" property="siteTypeId"/>
<result column="SITE_TYPE_NAME" jdbcType="VARCHAR" property="siteTypeName"/>
<result column="CANTON_ID" jdbcType="DECIMAL" property="cantonId"/>
<result column="CANTON_NAME" jdbcType="VARCHAR" property="cantonName"/>
<result column="COUNTY_ID" jdbcType="DECIMAL" property="countyId"/>
<result column="COUNTY_NAME" jdbcType="VARCHAR" property="countyName"/>
<result column="CITY_ID" jdbcType="DECIMAL" property="cityId"/>
<result column="CITY_NAME" jdbcType="VARCHAR" property="cityName"/>
<result column="AREA_ID" jdbcType="DECIMAL" property="areaId"/>
<result column="AREA_NAME" jdbcType="VARCHAR" property="areaName"/>
<result column="PROVINCE_ID" jdbcType="DECIMAL" property="provinceId"/>
<result column="PROVINCE_NAME" jdbcType="VARCHAR" property="provinceName"/>
<result column="RANGE_ID" jdbcType="DECIMAL" property="rangeId"/>
<result column="RANGE_NAME" jdbcType="VARCHAR" property="rangeName"/>
<result column="PRICE_ID" jdbcType="DECIMAL" property="priceId"/>
<result column="PRICE_PARENT_ID" jdbcType="DECIMAL" property="priceParentId"/>
<result column="PRICE_TREEPATH" jdbcType="VARCHAR" property="priceTreepath"/>
<result column="DEFAULT_SEND_PLACE" jdbcType="VARCHAR" property="defaultSendPlace"/>
<result column="IS_ALLOW_TOPAYMENT" jdbcType="DECIMAL" property="isAllowTopayment"/>
<result column="MANAGER" jdbcType="VARCHAR" property="manager"/>
<result column="SALE_PHONE" jdbcType="VARCHAR" property="salePhone"/>
<result column="FAX" jdbcType="VARCHAR" property="fax"/>
<result column="SITE_DESC" jdbcType="VARCHAR" property="siteDesc"/>
<result column="DISPATCH_RANGE" jdbcType="VARCHAR" property="dispatchRange"/>
<result column="NOT_DISPATCH_RANGE" jdbcType="VARCHAR" property="notDispatchRange"/>
<result column="DISPATCH_TIME_LIMIT" jdbcType="VARCHAR" property="dispatchTimeLimit"/>
<result column="IS_ALLOW_AGENT_MONEY" jdbcType="DECIMAL" property="isAllowAgentMoney"/>
<result column="PUBLIC_REMARK" jdbcType="VARCHAR" property="publicRemark"/>
<result column="PRIVATE_REMARK" jdbcType="VARCHAR" property="privateRemark"/>
<result column="MANAGER_PHONE" jdbcType="VARCHAR" property="managerPhone"/>
<result column="EXIGENCE_PHONE" jdbcType="VARCHAR" property="exigencePhone"/>
<result column="DISPATCH_MONEY_DESC" jdbcType="VARCHAR" property="dispatchMoneyDesc"/>
<result column="ORDER_BY" jdbcType="DECIMAL" property="orderBy"/>
<result column="IS_CALC_SITE" jdbcType="DECIMAL" property="isCalcSite"/>
<result column="FINANCIAL_ACCOUNT" jdbcType="VARCHAR" property="financialAccount"/>
<result column="SAME_SITE" jdbcType="VARCHAR" property="sameSite"/>
<result column="SAME_SITE_ID" jdbcType="VARCHAR" property="sameSiteId"/>
<result column="MODIFY_SITE" jdbcType="VARCHAR" property="modifySite"/>
<result column="TOPARMENT_GROUP_NAME" jdbcType="VARCHAR" property="toparmentGroupName"/>
<result column="CAR_START_TIME" jdbcType="VARCHAR" property="carStartTime"/>
<result column="CAR_END_TIME" jdbcType="VARCHAR" property="carEndTime"/>
<result column="IS_STOP" jdbcType="DECIMAL" property="isStop"/>
<result column="WEB_RANGE" jdbcType="VARCHAR" property="webRange"/>
<result column="IS_NOT_INPUT" jdbcType="DECIMAL" property="isNotInput"/>
<result column="DISP_FEE1" jdbcType="DECIMAL" property="dispFee1"/>
<result column="DISP_FEE2" jdbcType="DECIMAL" property="dispFee2"/>
<result column="IS_PROBLEM_NOTIFY_SUPER" jdbcType="DECIMAL" property="isProblemNotifySuper"/>
<result column="CALC_PROVINCE" jdbcType="VARCHAR" property="calcProvince"/>
<result column="WEB_SUPERIOR_SITE" jdbcType="VARCHAR" property="webSuperiorSite"/>
<result column="GOODS_PAYMENT_LIMITED" jdbcType="DECIMAL" property="goodsPaymentLimited"/>
<result column="WEB_SITE_NAME" jdbcType="VARCHAR" property="webSiteName"/>
<result column="CAR_START_TIME1" jdbcType="VARCHAR" property="carStartTime1"/>
<result column="CAR_END_TIME1" jdbcType="VARCHAR" property="carEndTime1"/>
<result column="IS12580" jdbcType="DECIMAL" property="is12580"/>
<result column="POST_CODE" jdbcType="VARCHAR" property="postCode"/>
<result column="TOPARMENT_GROUP_ID" jdbcType="DECIMAL" property="toparmentGroupId"/>
<result column="LAT_LNG" jdbcType="VARCHAR" property="latLng"/>
<result column="OVERLAY_VIEW" jdbcType="VARCHAR" property="overlayView"/>
<result column="IS_FINANCE_CENTER" jdbcType="DECIMAL" property="isFinanceCenter"/>
<result column="MODIFY_SITE_ID" jdbcType="DECIMAL" property="modifySiteId"/>
<result column="SYNC_VERSION" jdbcType="DECIMAL" property="syncVersion"/>
<result column="IS_DIRECT_SALE" jdbcType="DECIMAL" property="isDirectSale"/>
<result column="IS_CONTROL_LOGIN" jdbcType="DECIMAL" property="isControlLogin"/>
</resultMap>
<insert id="insert" parameterType="Site">
<selectKey keyProperty="id" resultType="long" order="BEFORE">
select ASS_SITE_SEQ.nextval from dual
</selectKey>
INSERT INTO ASS_SITE(
<!-- 0 --> ID,
<!-- 1 --> LOCK_VERSION,
<!-- 2 --> CREATE_TIME,
<!-- 3 --> CREATOR,
<!-- 4 --> CREATOR_NAME,
<!-- 5 --> LAST_UPDATE_TIME,
<!-- 6 --> LAST_UPDATOR,
<!-- 7 --> LAST_UPDATOR_NAME,
<!-- 8 --> REMARK,
<!-- 9 --> DEFAULT_CURRENCY,
<!-- 10 --> DISPATCH_FEE_SITE_ID,
<!-- 11 --> FINANCE_ONE_CENTER_ID,
<!-- 12 --> FINANCE_TWO_CENTER_ID,
<!-- 13 --> FINANCE_THREE_CENTER_ID,
<!-- 14 --> FINANCE_FOUR_CENTER_ID,
<!-- 15 --> FINANCE_FIVE_CENTER_ID,
<!-- 16 --> SETTLEMENT_SITE_ID,
<!-- 17 --> SUPERIOR_SITE_ID,
<!-- 18 --> DISPATCH_FEE_SITE_NAME,
<!-- 19 --> FINANCE_FIVE_CENTER_SITE_NAME,
<!-- 20 --> FINANCE_FOUR_CENTER_SITE_NAME,
<!-- 21 --> FINANCE_ONE_CENTER_SITE_NAME,
<!-- 22 --> FINANCE_THREE_CENTER_SITE_NAME,
<!-- 23 --> FINANCE_TWO_CENTER_SITE_NAME,
<!-- 24 --> SETTLEMENT_SITE_NAME,
<!-- 25 --> SUPERIOR_SITE_NAME,
<!-- 26 --> PHONE,
<!-- 27 --> PRINCIPAL,
<!-- 28 --> SITE_CODE,
<!-- 29 --> SITE_NAME,
<!-- 30 --> SITE_TYPE_ID,
<!-- 31 --> SITE_TYPE_NAME,
<!-- 32 --> CANTON_ID,
<!-- 33 --> CANTON_NAME,
<!-- 34 --> COUNTY_ID,
<!-- 35 --> COUNTY_NAME,
<!-- 36 --> CITY_ID,
<!-- 37 --> CITY_NAME,
<!-- 38 --> AREA_ID,
<!-- 39 --> AREA_NAME,
<!-- 40 --> PROVINCE_ID,
<!-- 41 --> PROVINCE_NAME,
<!-- 42 --> RANGE_ID,
<!-- 43 --> RANGE_NAME,
<!-- 44 --> PRICE_ID,
<!-- 45 --> PRICE_PARENT_ID,
<!-- 46 --> PRICE_TREEPATH,
<!-- 47 --> DEFAULT_SEND_PLACE,
<!-- 48 --> IS_ALLOW_TOPAYMENT,
<!-- 49 --> MANAGER,
<!-- 50 --> SALE_PHONE,
<!-- 51 --> FAX,
<!-- 52 --> SITE_DESC,
<!-- 53 --> DISPATCH_RANGE,
<!-- 54 --> NOT_DISPATCH_RANGE,
<!-- 55 --> DISPATCH_TIME_LIMIT,
<!-- 56 --> IS_ALLOW_AGENT_MONEY,
<!-- 57 --> PUBLIC_REMARK,
<!-- 58 --> PRIVATE_REMARK,
<!-- 59 --> MANAGER_PHONE,
<!-- 60 --> EXIGENCE_PHONE,
<!-- 61 --> DISPATCH_MONEY_DESC,
<!-- 62 --> ORDER_BY,
<!-- 63 --> IS_CALC_SITE,
<!-- 64 --> FINANCIAL_ACCOUNT,
<!-- 65 --> SAME_SITE,
<!-- 66 --> SAME_SITE_ID,
<!-- 67 --> MODIFY_SITE,
<!-- 68 --> TOPARMENT_GROUP_NAME,
<!-- 69 --> CAR_START_TIME,
<!-- 70 --> CAR_END_TIME,
<!-- 71 --> IS_STOP,
<!-- 72 --> WEB_RANGE,
<!-- 73 --> IS_NOT_INPUT,
<!-- 74 --> DISP_FEE1,
<!-- 75 --> DISP_FEE2,
<!-- 76 --> IS_PROBLEM_NOTIFY_SUPER,
<!-- 77 --> CALC_PROVINCE,
<!-- 78 --> WEB_SUPERIOR_SITE,
<!-- 79 --> GOODS_PAYMENT_LIMITED,
<!-- 80 --> WEB_SITE_NAME,
<!-- 81 --> CAR_START_TIME1,
<!-- 82 --> CAR_END_TIME1,
<!-- 83 --> IS12580,
<!-- 84 --> POST_CODE,
<!-- 85 --> TOPARMENT_GROUP_ID,
<!-- 86 --> LAT_LNG,
<!-- 87 --> OVERLAY_VIEW,
<!-- 88 --> IS_FINANCE_CENTER,
<!-- 89 --> MODIFY_SITE_ID,
<!-- 90 --> SYNC_VERSION,
<!-- 91 --> IS_DIRECT_SALE,
<!-- 92 --> IS_CONTROL_LOGIN
)
VALUES(
<!-- 0 --> #{ id:DECIMAL },
<!-- 1 --> #{ version:DECIMAL },
<!-- 2 --> #{ createTime:TIMESTAMP },
<!-- 3 --> #{ creator:VARCHAR },
<!-- 4 --> #{ creatorName:VARCHAR },
<!-- 5 --> #{ lastUpdateTime:TIMESTAMP },
<!-- 6 --> #{ lastUpdator:VARCHAR },
<!-- 7 --> #{ lastUpdatorName:VARCHAR },
<!-- 8 --> #{ remark:VARCHAR },
<!-- 9 --> #{ defaultCurrency:DECIMAL },
<!-- 10 --> #{ dispatchFeeSiteId:DECIMAL },
<!-- 11 --> #{ financeOneCenterId:DECIMAL },
<!-- 12 --> #{ financeTwoCenterId:DECIMAL },
<!-- 13 --> #{ financeThreeCenterId:DECIMAL },
<!-- 14 --> #{ financeFourCenterId:DECIMAL },
<!-- 15 --> #{ financeFiveCenterId:DECIMAL },
<!-- 16 --> #{ settlementSiteId:DECIMAL },
<!-- 17 --> #{ superiorSiteId:DECIMAL },
<!-- 18 --> #{ dispatchFeeSiteName:VARCHAR },
<!-- 19 --> #{ financeFiveCenterSiteName:VARCHAR },
<!-- 20 --> #{ financeFourCenterSiteName:VARCHAR },
<!-- 21 --> #{ financeOneCenterSiteName:VARCHAR },
<!-- 22 --> #{ financeThreeCenterSiteName:VARCHAR },
<!-- 23 --> #{ financeTwoCenterSiteName:VARCHAR },
<!-- 24 --> #{ settlementSiteName:VARCHAR },
<!-- 25 --> #{ superiorSiteName:VARCHAR },
<!-- 26 --> #{ phone:VARCHAR },
<!-- 27 --> #{ principal:VARCHAR },
<!-- 28 --> #{ siteCode:VARCHAR },
<!-- 29 --> #{ siteName:VARCHAR },
<!-- 30 --> #{ siteTypeId:DECIMAL },
<!-- 31 --> #{ siteTypeName:VARCHAR },
<!-- 32 --> #{ cantonId:DECIMAL },
<!-- 33 --> #{ cantonName:VARCHAR },
<!-- 34 --> #{ countyId:DECIMAL },
<!-- 35 --> #{ countyName:VARCHAR },
<!-- 36 --> #{ cityId:DECIMAL },
<!-- 37 --> #{ cityName:VARCHAR },
<!-- 38 --> #{ areaId:DECIMAL },
<!-- 39 --> #{ areaName:VARCHAR },
<!-- 40 --> #{ provinceId:DECIMAL },
<!-- 41 --> #{ provinceName:VARCHAR },
<!-- 42 --> #{ rangeId:DECIMAL },
<!-- 43 --> #{ rangeName:VARCHAR },
<!-- 44 --> #{ priceId:DECIMAL },
<!-- 45 --> #{ priceParentId:DECIMAL },
<!-- 46 --> #{ priceTreepath:VARCHAR },
<!-- 47 --> #{ defaultSendPlace:VARCHAR },
<!-- 48 --> #{ isAllowTopayment:DECIMAL },
<!-- 49 --> #{ manager:VARCHAR },
<!-- 50 --> #{ salePhone:VARCHAR },
<!-- 51 --> #{ fax:VARCHAR },
<!-- 52 --> #{ siteDesc:VARCHAR },
<!-- 53 --> #{ dispatchRange:VARCHAR },
<!-- 54 --> #{ notDispatchRange:VARCHAR },
<!-- 55 --> #{ dispatchTimeLimit:VARCHAR },
<!-- 56 --> #{ isAllowAgentMoney:DECIMAL },
<!-- 57 --> #{ publicRemark:VARCHAR },
<!-- 58 --> #{ privateRemark:VARCHAR },
<!-- 59 --> #{ managerPhone:VARCHAR },
<!-- 60 --> #{ exigencePhone:VARCHAR },
<!-- 61 --> #{ dispatchMoneyDesc:VARCHAR },
<!-- 62 --> #{ orderBy:DECIMAL },
<!-- 63 --> #{ isCalcSite:DECIMAL },
<!-- 64 --> #{ financialAccount:VARCHAR },
<!-- 65 --> #{ sameSite:VARCHAR },
<!-- 66 --> #{ sameSiteId:VARCHAR },
<!-- 67 --> #{ modifySite:VARCHAR },
<!-- 68 --> #{ toparmentGroupName:VARCHAR },
<!-- 69 --> #{ carStartTime:VARCHAR },
<!-- 70 --> #{ carEndTime:VARCHAR },
<!-- 71 --> #{ isStop:DECIMAL },
<!-- 72 --> #{ webRange:VARCHAR },
<!-- 73 --> #{ isNotInput:DECIMAL },
<!-- 74 --> #{ dispFee1:DECIMAL },
<!-- 75 --> #{ dispFee2:DECIMAL },
<!-- 76 --> #{ isProblemNotifySuper:DECIMAL },
<!-- 77 --> #{ calcProvince:VARCHAR },
<!-- 78 --> #{ webSuperiorSite:VARCHAR },
<!-- 79 --> #{ goodsPaymentLimited:DECIMAL },
<!-- 80 --> #{ webSiteName:VARCHAR },
<!-- 81 --> #{ carStartTime1:VARCHAR },
<!-- 82 --> #{ carEndTime1:VARCHAR },
<!-- 83 --> #{ is12580:DECIMAL },
<!-- 84 --> #{ postCode:VARCHAR },
<!-- 85 --> #{ toparmentGroupId:DECIMAL },
<!-- 86 --> #{ latLng:VARCHAR },
<!-- 87 --> #{ overlayView:VARCHAR },
<!-- 88 --> #{ isFinanceCenter:DECIMAL },
<!-- 89 --> #{ modifySiteId:DECIMAL },
<!-- 90 --> #{ syncVersion:DECIMAL },
<!-- 91 --> #{ isDirectSale:DECIMAL },
<!-- 92 --> #{ isControlLogin:DECIMAL }
)
</insert>
<update id="update" parameterType="Site">
UPDATE ASS_SITE
<set>
LOCK_VERSION = #{ version:DECIMAL },
LAST_UPDATE_TIME = #{ lastUpdateTime:TIMESTAMP },
LAST_UPDATOR = #{ lastUpdator:VARCHAR },
LAST_UPDATOR_NAME = #{ lastUpdatorName:VARCHAR },
REMARK = #{ remark:VARCHAR },
DEFAULT_CURRENCY = #{ defaultCurrency:DECIMAL },
DISPATCH_FEE_SITE_ID = #{ dispatchFeeSiteId:DECIMAL },
FINANCE_ONE_CENTER_ID = #{ financeOneCenterId:DECIMAL },
FINANCE_TWO_CENTER_ID = #{ financeTwoCenterId:DECIMAL },
FINANCE_THREE_CENTER_ID = #{ financeThreeCenterId:DECIMAL },
FINANCE_FOUR_CENTER_ID = #{ financeFourCenterId:DECIMAL },
FINANCE_FIVE_CENTER_ID = #{ financeFiveCenterId:DECIMAL },
SETTLEMENT_SITE_ID = #{ settlementSiteId:DECIMAL },
SUPERIOR_SITE_ID = #{ superiorSiteId:DECIMAL },
DISPATCH_FEE_SITE_NAME = #{ dispatchFeeSiteName:VARCHAR },
FINANCE_FIVE_CENTER_SITE_NAME = #{ financeFiveCenterSiteName:VARCHAR },
FINANCE_FOUR_CENTER_SITE_NAME = #{ financeFourCenterSiteName:VARCHAR },
FINANCE_ONE_CENTER_SITE_NAME = #{ financeOneCenterSiteName:VARCHAR },
FINANCE_THREE_CENTER_SITE_NAME = #{ financeThreeCenterSiteName:VARCHAR },
FINANCE_TWO_CENTER_SITE_NAME = #{ financeTwoCenterSiteName:VARCHAR },
SETTLEMENT_SITE_NAME = #{ settlementSiteName:VARCHAR },
SUPERIOR_SITE_NAME = #{ superiorSiteName:VARCHAR },
PHONE = #{ phone:VARCHAR },
PRINCIPAL = #{ principal:VARCHAR },
SITE_CODE = #{ siteCode:VARCHAR },
SITE_NAME = #{ siteName:VARCHAR },
SITE_TYPE_ID = #{ siteTypeId:DECIMAL },
SITE_TYPE_NAME = #{ siteTypeName:VARCHAR },
CANTON_ID = #{ cantonId:DECIMAL },
CANTON_NAME = #{ cantonName:VARCHAR },
COUNTY_ID = #{ countyId:DECIMAL },
COUNTY_NAME = #{ countyName:VARCHAR },
CITY_ID = #{ cityId:DECIMAL },
CITY_NAME = #{ cityName:VARCHAR },
AREA_ID = #{ areaId:DECIMAL },
AREA_NAME = #{ areaName:VARCHAR },
PROVINCE_ID = #{ provinceId:DECIMAL },
PROVINCE_NAME = #{ provinceName:VARCHAR },
RANGE_ID = #{ rangeId:DECIMAL },
RANGE_NAME = #{ rangeName:VARCHAR },
PRICE_ID = #{ priceId:DECIMAL },
PRICE_PARENT_ID = #{ priceParentId:DECIMAL },
PRICE_TREEPATH = #{ priceTreepath:VARCHAR },
DEFAULT_SEND_PLACE = #{ defaultSendPlace:VARCHAR },
IS_ALLOW_TOPAYMENT = #{ isAllowTopayment:DECIMAL },
MANAGER = #{ manager:VARCHAR },
SALE_PHONE = #{ salePhone:VARCHAR },
FAX = #{ fax:VARCHAR },
SITE_DESC = #{ siteDesc:VARCHAR },
DISPATCH_RANGE = #{ dispatchRange:VARCHAR },
NOT_DISPATCH_RANGE = #{ notDispatchRange:VARCHAR },
DISPATCH_TIME_LIMIT = #{ dispatchTimeLimit:VARCHAR },
IS_ALLOW_AGENT_MONEY = #{ isAllowAgentMoney:DECIMAL },
PUBLIC_REMARK = #{ publicRemark:VARCHAR },
PRIVATE_REMARK = #{ privateRemark:VARCHAR },
MANAGER_PHONE = #{ managerPhone:VARCHAR },
EXIGENCE_PHONE = #{ exigencePhone:VARCHAR },
DISPATCH_MONEY_DESC = #{ dispatchMoneyDesc:VARCHAR },
ORDER_BY = #{ orderBy:DECIMAL },
IS_CALC_SITE = #{ isCalcSite:DECIMAL },
FINANCIAL_ACCOUNT = #{ financialAccount:VARCHAR },
SAME_SITE = #{ sameSite:VARCHAR },
SAME_SITE_ID = #{ sameSiteId:VARCHAR },
MODIFY_SITE = #{ modifySite:VARCHAR },
TOPARMENT_GROUP_NAME = #{ toparmentGroupName:VARCHAR },
CAR_START_TIME = #{ carStartTime:VARCHAR },
CAR_END_TIME = #{ carEndTime:VARCHAR },
IS_STOP = #{ isStop:DECIMAL },
WEB_RANGE = #{ webRange:VARCHAR },
IS_NOT_INPUT = #{ isNotInput:DECIMAL },
DISP_FEE1 = #{ dispFee1:DECIMAL },
DISP_FEE2 = #{ dispFee2:DECIMAL },
IS_PROBLEM_NOTIFY_SUPER = #{ isProblemNotifySuper:DECIMAL },
CALC_PROVINCE = #{ calcProvince:VARCHAR },
WEB_SUPERIOR_SITE = #{ webSuperiorSite:VARCHAR },
GOODS_PAYMENT_LIMITED = #{ goodsPaymentLimited:DECIMAL },
WEB_SITE_NAME = #{ webSiteName:VARCHAR },
CAR_START_TIME1 = #{ carStartTime1:VARCHAR },
CAR_END_TIME1 = #{ carEndTime1:VARCHAR },
IS12580 = #{ is12580:DECIMAL },
POST_CODE = #{ postCode:VARCHAR },
TOPARMENT_GROUP_ID = #{ toparmentGroupId:DECIMAL },
LAT_LNG = #{ latLng:VARCHAR },
OVERLAY_VIEW = #{ overlayView:VARCHAR },
IS_FINANCE_CENTER = #{ isFinanceCenter:DECIMAL },
MODIFY_SITE_ID = #{ modifySiteId:DECIMAL },
SYNC_VERSION = #{ syncVersion:DECIMAL },
IS_DIRECT_SALE = #{ isDirectSale:DECIMAL },
IS_CONTROL_LOGIN = #{ isControlLogin:DECIMAL },
</set>
WHERE ID = #{id}
</update>
<delete id="deleteById" parameterType="long">
DELETE FROM ASS_SITE WHERE ID = #{id,jdbcType=DECIMAL}
</delete>
<select id="getById" parameterType="long" resultMap="siteResultMap">
SELECT * FROM ASS_SITE WHERE ID = #{id,jdbcType=DECIMAL}
</select>
<select id="getListBySo" resultMap="siteVoResultMap">
SELECT t.* FROM ASS_SITE t
<include refid="SO_Where_Clause" />
</select>
<select id="getCountBySo" resultType="int">
SELECT COUNT(t.id) FROM ASS_SITE t
<include refid="SO_Where_Clause" />
</select>
<sql id="SO_Where_Clause">
<where>
<if test="provinceId != null">
PROVINCE_ID = #{provinceId}
</if>
<if test="siteNameLike != null">
and SITE_NAME like '%${siteNameLike}%'
</if>
<if test="cityId != null">
and CITY_ID = #{cityId}
</if>
<if test="siteCodeLike != null">
and SITE_CODE like '%${siteCodeLike}%'
</if>
<if test="siteTypeName != null">
and SITE_TYPE_NAME = #{siteTypeName}
</if>
<if test="superiorSiteNameLike != null">
and SUPERIOR_SITE_NAME like '%${superiorSiteNameLike}%'
</if>
</where>
<trim prefix="where" prefixOverrides="and "> </trim>
</sql>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="Site">
<resultMap id="siteResultMap" type="Site">
<id column="ID" jdbcType="DECIMAL" property="id"/>
<result column="LOCK_VERSION" jdbcType="DECIMAL" property="version"/>
<result column="CREATE_TIME" jdbcType="TIMESTAMP" property="createTime"/>
<result column="CREATOR" jdbcType="VARCHAR" property="creator"/>
<result column="CREATOR_NAME" jdbcType="VARCHAR" property="creatorName"/>
<result column="LAST_UPDATE_TIME" jdbcType="TIMESTAMP" property="lastUpdateTime"/>
<result column="LAST_UPDATOR" jdbcType="VARCHAR" property="lastUpdator"/>
<result column="LAST_UPDATOR_NAME" jdbcType="VARCHAR" property="lastUpdatorName"/>
<result column="REMARK" jdbcType="VARCHAR" property="remark"/>
<result column="DEFAULT_CURRENCY" jdbcType="DECIMAL" property="defaultCurrency"/>
<result column="DISPATCH_FEE_SITE_ID" jdbcType="DECIMAL" property="dispatchFeeSiteId"/>
<result column="FINANCE_ONE_CENTER_ID" jdbcType="DECIMAL" property="financeOneCenterId"/>
<result column="FINANCE_TWO_CENTER_ID" jdbcType="DECIMAL" property="financeTwoCenterId"/>
<result column="FINANCE_THREE_CENTER_ID" jdbcType="DECIMAL" property="financeThreeCenterId"/>
<result column="FINANCE_FOUR_CENTER_ID" jdbcType="DECIMAL" property="financeFourCenterId"/>
<result column="FINANCE_FIVE_CENTER_ID" jdbcType="DECIMAL" property="financeFiveCenterId"/>
<result column="SETTLEMENT_SITE_ID" jdbcType="DECIMAL" property="settlementSiteId"/>
<result column="SUPERIOR_SITE_ID" jdbcType="DECIMAL" property="superiorSiteId"/>
<result column="DISPATCH_FEE_SITE_NAME" jdbcType="VARCHAR" property="dispatchFeeSiteName"/>
<result column="FINANCE_FIVE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeFiveCenterSiteName"/>
<result column="FINANCE_FOUR_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeFourCenterSiteName"/>
<result column="FINANCE_ONE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeOneCenterSiteName"/>
<result column="FINANCE_THREE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeThreeCenterSiteName"/>
<result column="FINANCE_TWO_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeTwoCenterSiteName"/>
<result column="SETTLEMENT_SITE_NAME" jdbcType="VARCHAR" property="settlementSiteName"/>
<result column="SUPERIOR_SITE_NAME" jdbcType="VARCHAR" property="superiorSiteName"/>
<result column="PHONE" jdbcType="VARCHAR" property="phone"/>
<result column="PRINCIPAL" jdbcType="VARCHAR" property="principal"/>
<result column="SITE_CODE" jdbcType="VARCHAR" property="siteCode"/>
<result column="SITE_NAME" jdbcType="VARCHAR" property="siteName"/>
<result column="SITE_TYPE_ID" jdbcType="DECIMAL" property="siteTypeId"/>
<result column="SITE_TYPE_NAME" jdbcType="VARCHAR" property="siteTypeName"/>
<result column="CANTON_ID" jdbcType="DECIMAL" property="cantonId"/>
<result column="CANTON_NAME" jdbcType="VARCHAR" property="cantonName"/>
<result column="COUNTY_ID" jdbcType="DECIMAL" property="countyId"/>
<result column="COUNTY_NAME" jdbcType="VARCHAR" property="countyName"/>
<result column="CITY_ID" jdbcType="DECIMAL" property="cityId"/>
<result column="CITY_NAME" jdbcType="VARCHAR" property="cityName"/>
<result column="AREA_ID" jdbcType="DECIMAL" property="areaId"/>
<result column="AREA_NAME" jdbcType="VARCHAR" property="areaName"/>
<result column="PROVINCE_ID" jdbcType="DECIMAL" property="provinceId"/>
<result column="PROVINCE_NAME" jdbcType="VARCHAR" property="provinceName"/>
<result column="RANGE_ID" jdbcType="DECIMAL" property="rangeId"/>
<result column="RANGE_NAME" jdbcType="VARCHAR" property="rangeName"/>
<result column="PRICE_ID" jdbcType="DECIMAL" property="priceId"/>
<result column="PRICE_PARENT_ID" jdbcType="DECIMAL" property="priceParentId"/>
<result column="PRICE_TREEPATH" jdbcType="VARCHAR" property="priceTreepath"/>
<result column="DEFAULT_SEND_PLACE" jdbcType="VARCHAR" property="defaultSendPlace"/>
<result column="IS_ALLOW_TOPAYMENT" jdbcType="DECIMAL" property="isAllowTopayment"/>
<result column="MANAGER" jdbcType="VARCHAR" property="manager"/>
<result column="SALE_PHONE" jdbcType="VARCHAR" property="salePhone"/>
<result column="FAX" jdbcType="VARCHAR" property="fax"/>
<result column="SITE_DESC" jdbcType="VARCHAR" property="siteDesc"/>
<result column="DISPATCH_RANGE" jdbcType="VARCHAR" property="dispatchRange"/>
<result column="NOT_DISPATCH_RANGE" jdbcType="VARCHAR" property="notDispatchRange"/>
<result column="DISPATCH_TIME_LIMIT" jdbcType="VARCHAR" property="dispatchTimeLimit"/>
<result column="IS_ALLOW_AGENT_MONEY" jdbcType="DECIMAL" property="isAllowAgentMoney"/>
<result column="PUBLIC_REMARK" jdbcType="VARCHAR" property="publicRemark"/>
<result column="PRIVATE_REMARK" jdbcType="VARCHAR" property="privateRemark"/>
<result column="MANAGER_PHONE" jdbcType="VARCHAR" property="managerPhone"/>
<result column="EXIGENCE_PHONE" jdbcType="VARCHAR" property="exigencePhone"/>
<result column="DISPATCH_MONEY_DESC" jdbcType="VARCHAR" property="dispatchMoneyDesc"/>
<result column="ORDER_BY" jdbcType="DECIMAL" property="orderBy"/>
<result column="IS_CALC_SITE" jdbcType="DECIMAL" property="isCalcSite"/>
<result column="FINANCIAL_ACCOUNT" jdbcType="VARCHAR" property="financialAccount"/>
<result column="SAME_SITE" jdbcType="VARCHAR" property="sameSite"/>
<result column="SAME_SITE_ID" jdbcType="VARCHAR" property="sameSiteId"/>
<result column="MODIFY_SITE" jdbcType="VARCHAR" property="modifySite"/>
<result column="TOPARMENT_GROUP_NAME" jdbcType="VARCHAR" property="toparmentGroupName"/>
<result column="CAR_START_TIME" jdbcType="VARCHAR" property="carStartTime"/>
<result column="CAR_END_TIME" jdbcType="VARCHAR" property="carEndTime"/>
<result column="IS_STOP" jdbcType="DECIMAL" property="isStop"/>
<result column="WEB_RANGE" jdbcType="VARCHAR" property="webRange"/>
<result column="IS_NOT_INPUT" jdbcType="DECIMAL" property="isNotInput"/>
<result column="DISP_FEE1" jdbcType="DECIMAL" property="dispFee1"/>
<result column="DISP_FEE2" jdbcType="DECIMAL" property="dispFee2"/>
<result column="IS_PROBLEM_NOTIFY_SUPER" jdbcType="DECIMAL" property="isProblemNotifySuper"/>
<result column="CALC_PROVINCE" jdbcType="VARCHAR" property="calcProvince"/>
<result column="WEB_SUPERIOR_SITE" jdbcType="VARCHAR" property="webSuperiorSite"/>
<result column="GOODS_PAYMENT_LIMITED" jdbcType="DECIMAL" property="goodsPaymentLimited"/>
<result column="WEB_SITE_NAME" jdbcType="VARCHAR" property="webSiteName"/>
<result column="CAR_START_TIME1" jdbcType="VARCHAR" property="carStartTime1"/>
<result column="CAR_END_TIME1" jdbcType="VARCHAR" property="carEndTime1"/>
<result column="IS12580" jdbcType="DECIMAL" property="is12580"/>
<result column="POST_CODE" jdbcType="VARCHAR" property="postCode"/>
<result column="TOPARMENT_GROUP_ID" jdbcType="DECIMAL" property="toparmentGroupId"/>
<result column="LAT_LNG" jdbcType="VARCHAR" property="latLng"/>
<result column="OVERLAY_VIEW" jdbcType="VARCHAR" property="overlayView"/>
<result column="IS_FINANCE_CENTER" jdbcType="DECIMAL" property="isFinanceCenter"/>
<result column="MODIFY_SITE_ID" jdbcType="DECIMAL" property="modifySiteId"/>
<result column="SYNC_VERSION" jdbcType="DECIMAL" property="syncVersion"/>
<result column="IS_DIRECT_SALE" jdbcType="DECIMAL" property="isDirectSale"/>
<result column="IS_CONTROL_LOGIN" jdbcType="DECIMAL" property="isControlLogin"/>
</resultMap>
<resultMap id="siteVoResultMap" type="SiteVO">
<id column="ID" jdbcType="DECIMAL" property="id"/>
<result column="LOCK_VERSION" jdbcType="DECIMAL" property="version"/>
<result column="CREATE_TIME" jdbcType="TIMESTAMP" property="createTime"/>
<result column="CREATOR" jdbcType="VARCHAR" property="creator"/>
<result column="CREATOR_NAME" jdbcType="VARCHAR" property="creatorName"/>
<result column="LAST_UPDATE_TIME" jdbcType="TIMESTAMP" property="lastUpdateTime"/>
<result column="LAST_UPDATOR" jdbcType="VARCHAR" property="lastUpdator"/>
<result column="LAST_UPDATOR_NAME" jdbcType="VARCHAR" property="lastUpdatorName"/>
<result column="REMARK" jdbcType="VARCHAR" property="remark"/>
<result column="DEFAULT_CURRENCY" jdbcType="DECIMAL" property="defaultCurrency"/>
<result column="DISPATCH_FEE_SITE_ID" jdbcType="DECIMAL" property="dispatchFeeSiteId"/>
<result column="FINANCE_ONE_CENTER_ID" jdbcType="DECIMAL" property="financeOneCenterId"/>
<result column="FINANCE_TWO_CENTER_ID" jdbcType="DECIMAL" property="financeTwoCenterId"/>
<result column="FINANCE_THREE_CENTER_ID" jdbcType="DECIMAL" property="financeThreeCenterId"/>
<result column="FINANCE_FOUR_CENTER_ID" jdbcType="DECIMAL" property="financeFourCenterId"/>
<result column="FINANCE_FIVE_CENTER_ID" jdbcType="DECIMAL" property="financeFiveCenterId"/>
<result column="SETTLEMENT_SITE_ID" jdbcType="DECIMAL" property="settlementSiteId"/>
<result column="SUPERIOR_SITE_ID" jdbcType="DECIMAL" property="superiorSiteId"/>
<result column="DISPATCH_FEE_SITE_NAME" jdbcType="VARCHAR" property="dispatchFeeSiteName"/>
<result column="FINANCE_FIVE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeFiveCenterSiteName"/>
<result column="FINANCE_FOUR_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeFourCenterSiteName"/>
<result column="FINANCE_ONE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeOneCenterSiteName"/>
<result column="FINANCE_THREE_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeThreeCenterSiteName"/>
<result column="FINANCE_TWO_CENTER_SITE_NAME" jdbcType="VARCHAR" property="financeTwoCenterSiteName"/>
<result column="SETTLEMENT_SITE_NAME" jdbcType="VARCHAR" property="settlementSiteName"/>
<result column="SUPERIOR_SITE_NAME" jdbcType="VARCHAR" property="superiorSiteName"/>
<result column="PHONE" jdbcType="VARCHAR" property="phone"/>
<result column="PRINCIPAL" jdbcType="VARCHAR" property="principal"/>
<result column="SITE_CODE" jdbcType="VARCHAR" property="siteCode"/>
<result column="SITE_NAME" jdbcType="VARCHAR" property="siteName"/>
<result column="SITE_TYPE_ID" jdbcType="DECIMAL" property="siteTypeId"/>
<result column="SITE_TYPE_NAME" jdbcType="VARCHAR" property="siteTypeName"/>
<result column="CANTON_ID" jdbcType="DECIMAL" property="cantonId"/>
<result column="CANTON_NAME" jdbcType="VARCHAR" property="cantonName"/>
<result column="COUNTY_ID" jdbcType="DECIMAL" property="countyId"/>
<result column="COUNTY_NAME" jdbcType="VARCHAR" property="countyName"/>
<result column="CITY_ID" jdbcType="DECIMAL" property="cityId"/>
<result column="CITY_NAME" jdbcType="VARCHAR" property="cityName"/>
<result column="AREA_ID" jdbcType="DECIMAL" property="areaId"/>
<result column="AREA_NAME" jdbcType="VARCHAR" property="areaName"/>
<result column="PROVINCE_ID" jdbcType="DECIMAL" property="provinceId"/>
<result column="PROVINCE_NAME" jdbcType="VARCHAR" property="provinceName"/>
<result column="RANGE_ID" jdbcType="DECIMAL" property="rangeId"/>
<result column="RANGE_NAME" jdbcType="VARCHAR" property="rangeName"/>
<result column="PRICE_ID" jdbcType="DECIMAL" property="priceId"/>
<result column="PRICE_PARENT_ID" jdbcType="DECIMAL" property="priceParentId"/>
<result column="PRICE_TREEPATH" jdbcType="VARCHAR" property="priceTreepath"/>
<result column="DEFAULT_SEND_PLACE" jdbcType="VARCHAR" property="defaultSendPlace"/>
<result column="IS_ALLOW_TOPAYMENT" jdbcType="DECIMAL" property="isAllowTopayment"/>
<result column="MANAGER" jdbcType="VARCHAR" property="manager"/>
<result column="SALE_PHONE" jdbcType="VARCHAR" property="salePhone"/>
<result column="FAX" jdbcType="VARCHAR" property="fax"/>
<result column="SITE_DESC" jdbcType="VARCHAR" property="siteDesc"/>
<result column="DISPATCH_RANGE" jdbcType="VARCHAR" property="dispatchRange"/>
<result column="NOT_DISPATCH_RANGE" jdbcType="VARCHAR" property="notDispatchRange"/>
<result column="DISPATCH_TIME_LIMIT" jdbcType="VARCHAR" property="dispatchTimeLimit"/>
<result column="IS_ALLOW_AGENT_MONEY" jdbcType="DECIMAL" property="isAllowAgentMoney"/>
<result column="PUBLIC_REMARK" jdbcType="VARCHAR" property="publicRemark"/>
<result column="PRIVATE_REMARK" jdbcType="VARCHAR" property="privateRemark"/>
<result column="MANAGER_PHONE" jdbcType="VARCHAR" property="managerPhone"/>
<result column="EXIGENCE_PHONE" jdbcType="VARCHAR" property="exigencePhone"/>
<result column="DISPATCH_MONEY_DESC" jdbcType="VARCHAR" property="dispatchMoneyDesc"/>
<result column="ORDER_BY" jdbcType="DECIMAL" property="orderBy"/>
<result column="IS_CALC_SITE" jdbcType="DECIMAL" property="isCalcSite"/>
<result column="FINANCIAL_ACCOUNT" jdbcType="VARCHAR" property="financialAccount"/>
<result column="SAME_SITE" jdbcType="VARCHAR" property="sameSite"/>
<result column="SAME_SITE_ID" jdbcType="VARCHAR" property="sameSiteId"/>
<result column="MODIFY_SITE" jdbcType="VARCHAR" property="modifySite"/>
<result column="TOPARMENT_GROUP_NAME" jdbcType="VARCHAR" property="toparmentGroupName"/>
<result column="CAR_START_TIME" jdbcType="VARCHAR" property="carStartTime"/>
<result column="CAR_END_TIME" jdbcType="VARCHAR" property="carEndTime"/>
<result column="IS_STOP" jdbcType="DECIMAL" property="isStop"/>
<result column="WEB_RANGE" jdbcType="VARCHAR" property="webRange"/>
<result column="IS_NOT_INPUT" jdbcType="DECIMAL" property="isNotInput"/>
<result column="DISP_FEE1" jdbcType="DECIMAL" property="dispFee1"/>
<result column="DISP_FEE2" jdbcType="DECIMAL" property="dispFee2"/>
<result column="IS_PROBLEM_NOTIFY_SUPER" jdbcType="DECIMAL" property="isProblemNotifySuper"/>
<result column="CALC_PROVINCE" jdbcType="VARCHAR" property="calcProvince"/>
<result column="WEB_SUPERIOR_SITE" jdbcType="VARCHAR" property="webSuperiorSite"/>
<result column="GOODS_PAYMENT_LIMITED" jdbcType="DECIMAL" property="goodsPaymentLimited"/>
<result column="WEB_SITE_NAME" jdbcType="VARCHAR" property="webSiteName"/>
<result column="CAR_START_TIME1" jdbcType="VARCHAR" property="carStartTime1"/>
<result column="CAR_END_TIME1" jdbcType="VARCHAR" property="carEndTime1"/>
<result column="IS12580" jdbcType="DECIMAL" property="is12580"/>
<result column="POST_CODE" jdbcType="VARCHAR" property="postCode"/>
<result column="TOPARMENT_GROUP_ID" jdbcType="DECIMAL" property="toparmentGroupId"/>
<result column="LAT_LNG" jdbcType="VARCHAR" property="latLng"/>
<result column="OVERLAY_VIEW" jdbcType="VARCHAR" property="overlayView"/>
<result column="IS_FINANCE_CENTER" jdbcType="DECIMAL" property="isFinanceCenter"/>
<result column="MODIFY_SITE_ID" jdbcType="DECIMAL" property="modifySiteId"/>
<result column="SYNC_VERSION" jdbcType="DECIMAL" property="syncVersion"/>
<result column="IS_DIRECT_SALE" jdbcType="DECIMAL" property="isDirectSale"/>
<result column="IS_CONTROL_LOGIN" jdbcType="DECIMAL" property="isControlLogin"/>
</resultMap>
<insert id="insert" parameterType="Site">
<selectKey keyProperty="id" resultType="long" order="BEFORE">
select ASS_SITE_SEQ.nextval from dual
</selectKey>
INSERT INTO ASS_SITE(
<!-- 0 --> ID,
<!-- 1 --> LOCK_VERSION,
<!-- 2 --> CREATE_TIME,
<!-- 3 --> CREATOR,
<!-- 4 --> CREATOR_NAME,
<!-- 5 --> LAST_UPDATE_TIME,
<!-- 6 --> LAST_UPDATOR,
<!-- 7 --> LAST_UPDATOR_NAME,
<!-- 8 --> REMARK,
<!-- 9 --> DEFAULT_CURRENCY,
<!-- 10 --> DISPATCH_FEE_SITE_ID,
<!-- 11 --> FINANCE_ONE_CENTER_ID,
<!-- 12 --> FINANCE_TWO_CENTER_ID,
<!-- 13 --> FINANCE_THREE_CENTER_ID,
<!-- 14 --> FINANCE_FOUR_CENTER_ID,
<!-- 15 --> FINANCE_FIVE_CENTER_ID,
<!-- 16 --> SETTLEMENT_SITE_ID,
<!-- 17 --> SUPERIOR_SITE_ID,
<!-- 18 --> DISPATCH_FEE_SITE_NAME,
<!-- 19 --> FINANCE_FIVE_CENTER_SITE_NAME,
<!-- 20 --> FINANCE_FOUR_CENTER_SITE_NAME,
<!-- 21 --> FINANCE_ONE_CENTER_SITE_NAME,
<!-- 22 --> FINANCE_THREE_CENTER_SITE_NAME,
<!-- 23 --> FINANCE_TWO_CENTER_SITE_NAME,
<!-- 24 --> SETTLEMENT_SITE_NAME,
<!-- 25 --> SUPERIOR_SITE_NAME,
<!-- 26 --> PHONE,
<!-- 27 --> PRINCIPAL,
<!-- 28 --> SITE_CODE,
<!-- 29 --> SITE_NAME,
<!-- 30 --> SITE_TYPE_ID,
<!-- 31 --> SITE_TYPE_NAME,
<!-- 32 --> CANTON_ID,
<!-- 33 --> CANTON_NAME,
<!-- 34 --> COUNTY_ID,
<!-- 35 --> COUNTY_NAME,
<!-- 36 --> CITY_ID,
<!-- 37 --> CITY_NAME,
<!-- 38 --> AREA_ID,
<!-- 39 --> AREA_NAME,
<!-- 40 --> PROVINCE_ID,
<!-- 41 --> PROVINCE_NAME,
<!-- 42 --> RANGE_ID,
<!-- 43 --> RANGE_NAME,
<!-- 44 --> PRICE_ID,
<!-- 45 --> PRICE_PARENT_ID,
<!-- 46 --> PRICE_TREEPATH,
<!-- 47 --> DEFAULT_SEND_PLACE,
<!-- 48 --> IS_ALLOW_TOPAYMENT,
<!-- 49 --> MANAGER,
<!-- 50 --> SALE_PHONE,
<!-- 51 --> FAX,
<!-- 52 --> SITE_DESC,
<!-- 53 --> DISPATCH_RANGE,
<!-- 54 --> NOT_DISPATCH_RANGE,
<!-- 55 --> DISPATCH_TIME_LIMIT,
<!-- 56 --> IS_ALLOW_AGENT_MONEY,
<!-- 57 --> PUBLIC_REMARK,
<!-- 58 --> PRIVATE_REMARK,
<!-- 59 --> MANAGER_PHONE,
<!-- 60 --> EXIGENCE_PHONE,
<!-- 61 --> DISPATCH_MONEY_DESC,
<!-- 62 --> ORDER_BY,
<!-- 63 --> IS_CALC_SITE,
<!-- 64 --> FINANCIAL_ACCOUNT,
<!-- 65 --> SAME_SITE,
<!-- 66 --> SAME_SITE_ID,
<!-- 67 --> MODIFY_SITE,
<!-- 68 --> TOPARMENT_GROUP_NAME,
<!-- 69 --> CAR_START_TIME,
<!-- 70 --> CAR_END_TIME,
<!-- 71 --> IS_STOP,
<!-- 72 --> WEB_RANGE,
<!-- 73 --> IS_NOT_INPUT,
<!-- 74 --> DISP_FEE1,
<!-- 75 --> DISP_FEE2,
<!-- 76 --> IS_PROBLEM_NOTIFY_SUPER,
<!-- 77 --> CALC_PROVINCE,
<!-- 78 --> WEB_SUPERIOR_SITE,
<!-- 79 --> GOODS_PAYMENT_LIMITED,
<!-- 80 --> WEB_SITE_NAME,
<!-- 81 --> CAR_START_TIME1,
<!-- 82 --> CAR_END_TIME1,
<!-- 83 --> IS12580,
<!-- 84 --> POST_CODE,
<!-- 85 --> TOPARMENT_GROUP_ID,
<!-- 86 --> LAT_LNG,
<!-- 87 --> OVERLAY_VIEW,
<!-- 88 --> IS_FINANCE_CENTER,
<!-- 89 --> MODIFY_SITE_ID,
<!-- 90 --> SYNC_VERSION,
<!-- 91 --> IS_DIRECT_SALE,
<!-- 92 --> IS_CONTROL_LOGIN
)
VALUES(
<!-- 0 --> #{ id:DECIMAL },
<!-- 1 --> #{ version:DECIMAL },
<!-- 2 --> #{ createTime:TIMESTAMP },
<!-- 3 --> #{ creator:VARCHAR },
<!-- 4 --> #{ creatorName:VARCHAR },
<!-- 5 --> #{ lastUpdateTime:TIMESTAMP },
<!-- 6 --> #{ lastUpdator:VARCHAR },
<!-- 7 --> #{ lastUpdatorName:VARCHAR },
<!-- 8 --> #{ remark:VARCHAR },
<!-- 9 --> #{ defaultCurrency:DECIMAL },
<!-- 10 --> #{ dispatchFeeSiteId:DECIMAL },
<!-- 11 --> #{ financeOneCenterId:DECIMAL },
<!-- 12 --> #{ financeTwoCenterId:DECIMAL },
<!-- 13 --> #{ financeThreeCenterId:DECIMAL },
<!-- 14 --> #{ financeFourCenterId:DECIMAL },
<!-- 15 --> #{ financeFiveCenterId:DECIMAL },
<!-- 16 --> #{ settlementSiteId:DECIMAL },
<!-- 17 --> #{ superiorSiteId:DECIMAL },
<!-- 18 --> #{ dispatchFeeSiteName:VARCHAR },
<!-- 19 --> #{ financeFiveCenterSiteName:VARCHAR },
<!-- 20 --> #{ financeFourCenterSiteName:VARCHAR },
<!-- 21 --> #{ financeOneCenterSiteName:VARCHAR },
<!-- 22 --> #{ financeThreeCenterSiteName:VARCHAR },
<!-- 23 --> #{ financeTwoCenterSiteName:VARCHAR },
<!-- 24 --> #{ settlementSiteName:VARCHAR },
<!-- 25 --> #{ superiorSiteName:VARCHAR },
<!-- 26 --> #{ phone:VARCHAR },
<!-- 27 --> #{ principal:VARCHAR },
<!-- 28 --> #{ siteCode:VARCHAR },
<!-- 29 --> #{ siteName:VARCHAR },
<!-- 30 --> #{ siteTypeId:DECIMAL },
<!-- 31 --> #{ siteTypeName:VARCHAR },
<!-- 32 --> #{ cantonId:DECIMAL },
<!-- 33 --> #{ cantonName:VARCHAR },
<!-- 34 --> #{ countyId:DECIMAL },
<!-- 35 --> #{ countyName:VARCHAR },
<!-- 36 --> #{ cityId:DECIMAL },
<!-- 37 --> #{ cityName:VARCHAR },
<!-- 38 --> #{ areaId:DECIMAL },
<!-- 39 --> #{ areaName:VARCHAR },
<!-- 40 --> #{ provinceId:DECIMAL },
<!-- 41 --> #{ provinceName:VARCHAR },
<!-- 42 --> #{ rangeId:DECIMAL },
<!-- 43 --> #{ rangeName:VARCHAR },
<!-- 44 --> #{ priceId:DECIMAL },
<!-- 45 --> #{ priceParentId:DECIMAL },
<!-- 46 --> #{ priceTreepath:VARCHAR },
<!-- 47 --> #{ defaultSendPlace:VARCHAR },
<!-- 48 --> #{ isAllowTopayment:DECIMAL },
<!-- 49 --> #{ manager:VARCHAR },
<!-- 50 --> #{ salePhone:VARCHAR },
<!-- 51 --> #{ fax:VARCHAR },
<!-- 52 --> #{ siteDesc:VARCHAR },
<!-- 53 --> #{ dispatchRange:VARCHAR },
<!-- 54 --> #{ notDispatchRange:VARCHAR },
<!-- 55 --> #{ dispatchTimeLimit:VARCHAR },
<!-- 56 --> #{ isAllowAgentMoney:DECIMAL },
<!-- 57 --> #{ publicRemark:VARCHAR },
<!-- 58 --> #{ privateRemark:VARCHAR },
<!-- 59 --> #{ managerPhone:VARCHAR },
<!-- 60 --> #{ exigencePhone:VARCHAR },
<!-- 61 --> #{ dispatchMoneyDesc:VARCHAR },
<!-- 62 --> #{ orderBy:DECIMAL },
<!-- 63 --> #{ isCalcSite:DECIMAL },
<!-- 64 --> #{ financialAccount:VARCHAR },
<!-- 65 --> #{ sameSite:VARCHAR },
<!-- 66 --> #{ sameSiteId:VARCHAR },
<!-- 67 --> #{ modifySite:VARCHAR },
<!-- 68 --> #{ toparmentGroupName:VARCHAR },
<!-- 69 --> #{ carStartTime:VARCHAR },
<!-- 70 --> #{ carEndTime:VARCHAR },
<!-- 71 --> #{ isStop:DECIMAL },
<!-- 72 --> #{ webRange:VARCHAR },
<!-- 73 --> #{ isNotInput:DECIMAL },
<!-- 74 --> #{ dispFee1:DECIMAL },
<!-- 75 --> #{ dispFee2:DECIMAL },
<!-- 76 --> #{ isProblemNotifySuper:DECIMAL },
<!-- 77 --> #{ calcProvince:VARCHAR },
<!-- 78 --> #{ webSuperiorSite:VARCHAR },
<!-- 79 --> #{ goodsPaymentLimited:DECIMAL },
<!-- 80 --> #{ webSiteName:VARCHAR },
<!-- 81 --> #{ carStartTime1:VARCHAR },
<!-- 82 --> #{ carEndTime1:VARCHAR },
<!-- 83 --> #{ is12580:DECIMAL },
<!-- 84 --> #{ postCode:VARCHAR },
<!-- 85 --> #{ toparmentGroupId:DECIMAL },
<!-- 86 --> #{ latLng:VARCHAR },
<!-- 87 --> #{ overlayView:VARCHAR },
<!-- 88 --> #{ isFinanceCenter:DECIMAL },
<!-- 89 --> #{ modifySiteId:DECIMAL },
<!-- 90 --> #{ syncVersion:DECIMAL },
<!-- 91 --> #{ isDirectSale:DECIMAL },
<!-- 92 --> #{ isControlLogin:DECIMAL }
)
</insert>
<update id="update" parameterType="Site">
UPDATE ASS_SITE
<set>
LOCK_VERSION = #{ version:DECIMAL },
LAST_UPDATE_TIME = #{ lastUpdateTime:TIMESTAMP },
LAST_UPDATOR = #{ lastUpdator:VARCHAR },
LAST_UPDATOR_NAME = #{ lastUpdatorName:VARCHAR },
REMARK = #{ remark:VARCHAR },
DEFAULT_CURRENCY = #{ defaultCurrency:DECIMAL },
DISPATCH_FEE_SITE_ID = #{ dispatchFeeSiteId:DECIMAL },
FINANCE_ONE_CENTER_ID = #{ financeOneCenterId:DECIMAL },
FINANCE_TWO_CENTER_ID = #{ financeTwoCenterId:DECIMAL },
FINANCE_THREE_CENTER_ID = #{ financeThreeCenterId:DECIMAL },
FINANCE_FOUR_CENTER_ID = #{ financeFourCenterId:DECIMAL },
FINANCE_FIVE_CENTER_ID = #{ financeFiveCenterId:DECIMAL },
SETTLEMENT_SITE_ID = #{ settlementSiteId:DECIMAL },
SUPERIOR_SITE_ID = #{ superiorSiteId:DECIMAL },
DISPATCH_FEE_SITE_NAME = #{ dispatchFeeSiteName:VARCHAR },
FINANCE_FIVE_CENTER_SITE_NAME = #{ financeFiveCenterSiteName:VARCHAR },
FINANCE_FOUR_CENTER_SITE_NAME = #{ financeFourCenterSiteName:VARCHAR },
FINANCE_ONE_CENTER_SITE_NAME = #{ financeOneCenterSiteName:VARCHAR },
FINANCE_THREE_CENTER_SITE_NAME = #{ financeThreeCenterSiteName:VARCHAR },
FINANCE_TWO_CENTER_SITE_NAME = #{ financeTwoCenterSiteName:VARCHAR },
SETTLEMENT_SITE_NAME = #{ settlementSiteName:VARCHAR },
SUPERIOR_SITE_NAME = #{ superiorSiteName:VARCHAR },
PHONE = #{ phone:VARCHAR },
PRINCIPAL = #{ principal:VARCHAR },
SITE_CODE = #{ siteCode:VARCHAR },
SITE_NAME = #{ siteName:VARCHAR },
SITE_TYPE_ID = #{ siteTypeId:DECIMAL },
SITE_TYPE_NAME = #{ siteTypeName:VARCHAR },
CANTON_ID = #{ cantonId:DECIMAL },
CANTON_NAME = #{ cantonName:VARCHAR },
COUNTY_ID = #{ countyId:DECIMAL },
COUNTY_NAME = #{ countyName:VARCHAR },
CITY_ID = #{ cityId:DECIMAL },
CITY_NAME = #{ cityName:VARCHAR },
AREA_ID = #{ areaId:DECIMAL },
AREA_NAME = #{ areaName:VARCHAR },
PROVINCE_ID = #{ provinceId:DECIMAL },
PROVINCE_NAME = #{ provinceName:VARCHAR },
RANGE_ID = #{ rangeId:DECIMAL },
RANGE_NAME = #{ rangeName:VARCHAR },
PRICE_ID = #{ priceId:DECIMAL },
PRICE_PARENT_ID = #{ priceParentId:DECIMAL },
PRICE_TREEPATH = #{ priceTreepath:VARCHAR },
DEFAULT_SEND_PLACE = #{ defaultSendPlace:VARCHAR },
IS_ALLOW_TOPAYMENT = #{ isAllowTopayment:DECIMAL },
MANAGER = #{ manager:VARCHAR },
SALE_PHONE = #{ salePhone:VARCHAR },
FAX = #{ fax:VARCHAR },
SITE_DESC = #{ siteDesc:VARCHAR },
DISPATCH_RANGE = #{ dispatchRange:VARCHAR },
NOT_DISPATCH_RANGE = #{ notDispatchRange:VARCHAR },
DISPATCH_TIME_LIMIT = #{ dispatchTimeLimit:VARCHAR },
IS_ALLOW_AGENT_MONEY = #{ isAllowAgentMoney:DECIMAL },
PUBLIC_REMARK = #{ publicRemark:VARCHAR },
PRIVATE_REMARK = #{ privateRemark:VARCHAR },
MANAGER_PHONE = #{ managerPhone:VARCHAR },
EXIGENCE_PHONE = #{ exigencePhone:VARCHAR },
DISPATCH_MONEY_DESC = #{ dispatchMoneyDesc:VARCHAR },
ORDER_BY = #{ orderBy:DECIMAL },
IS_CALC_SITE = #{ isCalcSite:DECIMAL },
FINANCIAL_ACCOUNT = #{ financialAccount:VARCHAR },
SAME_SITE = #{ sameSite:VARCHAR },
SAME_SITE_ID = #{ sameSiteId:VARCHAR },
MODIFY_SITE = #{ modifySite:VARCHAR },
TOPARMENT_GROUP_NAME = #{ toparmentGroupName:VARCHAR },
CAR_START_TIME = #{ carStartTime:VARCHAR },
CAR_END_TIME = #{ carEndTime:VARCHAR },
IS_STOP = #{ isStop:DECIMAL },
WEB_RANGE = #{ webRange:VARCHAR },
IS_NOT_INPUT = #{ isNotInput:DECIMAL },
DISP_FEE1 = #{ dispFee1:DECIMAL },
DISP_FEE2 = #{ dispFee2:DECIMAL },
IS_PROBLEM_NOTIFY_SUPER = #{ isProblemNotifySuper:DECIMAL },
CALC_PROVINCE = #{ calcProvince:VARCHAR },
WEB_SUPERIOR_SITE = #{ webSuperiorSite:VARCHAR },
GOODS_PAYMENT_LIMITED = #{ goodsPaymentLimited:DECIMAL },
WEB_SITE_NAME = #{ webSiteName:VARCHAR },
CAR_START_TIME1 = #{ carStartTime1:VARCHAR },
CAR_END_TIME1 = #{ carEndTime1:VARCHAR },
IS12580 = #{ is12580:DECIMAL },
POST_CODE = #{ postCode:VARCHAR },
TOPARMENT_GROUP_ID = #{ toparmentGroupId:DECIMAL },
LAT_LNG = #{ latLng:VARCHAR },
OVERLAY_VIEW = #{ overlayView:VARCHAR },
IS_FINANCE_CENTER = #{ isFinanceCenter:DECIMAL },
MODIFY_SITE_ID = #{ modifySiteId:DECIMAL },
SYNC_VERSION = #{ syncVersion:DECIMAL },
IS_DIRECT_SALE = #{ isDirectSale:DECIMAL },
IS_CONTROL_LOGIN = #{ isControlLogin:DECIMAL },
</set>
WHERE ID = #{id}
</update>
<delete id="deleteById" parameterType="long">
DELETE FROM ASS_SITE WHERE ID = #{id,jdbcType=DECIMAL}
</delete>
<select id="getById" parameterType="long" resultMap="siteResultMap">
SELECT * FROM ASS_SITE WHERE ID = #{id,jdbcType=DECIMAL}
</select>
<select id="getListBySo" resultMap="siteVoResultMap">
SELECT t.* FROM ASS_SITE t
<include refid="SO_Where_Clause" />
</select>
<select id="getCountBySo" resultType="int">
SELECT COUNT(t.id) FROM ASS_SITE t
<include refid="SO_Where_Clause" />
</select>
<sql id="SO_Where_Clause">
<where>
<if test="provinceId != null">
PROVINCE_ID = #{provinceId}
</if>
<if test="siteNameLike != null">
and SITE_NAME like '%${siteNameLike}%'
</if>
<if test="cityId != null">
and CITY_ID = #{cityId}
</if>
<if test="siteCodeLike != null">
and SITE_CODE like '%${siteCodeLike}%'
</if>
<if test="siteTypeName != null">
and SITE_TYPE_NAME = #{siteTypeName}
</if>
<if test="superiorSiteNameLike != null">
and SUPERIOR_SITE_NAME like '%${superiorSiteNameLike}%'
</if>
</where>
<trim prefix="where" prefixOverrides="and "> </trim>
</sql>
</mapper>
主要部分:
- MyBatis动态查询 模糊查询实例sql
- MyBatis-动态sql与模糊查询 -07
- mybatis 动态SQL与模糊查询
- Mybatis 1.动态sql 2.模糊查询
- 03. mybatis 动态sql && 模糊查询
- Mybatis动态SQL与模糊查询
- Mybatis学习----模糊查询和动态sql
- 六、Mybatis动态SQL和模糊查询
- Mybatis之动态SQL 模糊查询
- mybatis的动态SQL与模糊查询
- Mybatis 模糊查询和动态sql语句
- MyBatis的动态SQL的模糊查询
- MyBatis动态sql中模糊查询
- mybatis 模糊查询简单sql
- Mybatis学习总结之动态SQL与模糊查询
- MyBatis入门07--实现sql动态模糊查询
- Mybatis学习笔记-动态SQL与模糊查询
- Mybatis学习总结之动态SQL与模糊查询
- iOS: HTTPS 与自签名证书
- c++文件读写总结
- android的多线程与界面交互的方法
- 图片自动切换
- 内核新手区
- MyBatis动态查询 模糊查询实例sql
- 青年歌手大奖赛_评委会打分
- linux服务器WEB环境一键安装包及及相关教程
- AIR开发ios游戏总结
- 正则表达式与上下文无关文法
- static关键字的使用
- UIApplication对象及其代理UIApplicationDelegate
- hdu4433——dp
- log4j高级技巧--动态配置日志输出文件的位置