<?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.huazheng.project.greenplum.mapper.GPMapper">
    
    <select id="selectHandover" parameterType="com.huazheng.project.mysql.model.Handover" resultType="com.huazheng.project.mysql.model.Handover">
    	select * from handover 
    	where handover_id = #{handover_id}
    </select>
    <insert id="insertHandover" parameterType="com.huazheng.project.mysql.model.Handover">
    	insert into handover (vbeln, task_id, handover_id, handover_type, order_type, task_no, sale_no, 
			delivery_type, handover_state, f_plant, plant, customer_id, customer_name, 
			fmenge, delivery_num, port, piect_total, total_net_weight, weight_total, 
			settlement_weight, weight_state, vrkme, average_freight, order_remark, 
			delivery_time, erdat, plan_product_time, open_ready_time, already_ready_time, 
			appearance_time, sign_time, edatu, area_no, area_name, fmenge_time, klabc, 
			sales_man, sales_department, is_valid, created_user_id, created_time, 
			modified_user_id, modified_time, remark, is_auto_created, delivery_state, 
			operate_tag, transport_time, is_date_success, is_num_success, is_sign_success, 
			weighing_weight, delivery_issued_time, hashResult) 
    	values(#{vbeln}, #{task_id}, #{handover_id}, #{handover_type}, #{order_type}, #{task_no}, #{sale_no},
			#{delivery_type}, #{handover_state}, #{f_plant}, #{plant}, #{customer_id}, #{customer_name},
			#{fmenge}, #{delivery_num}, #{port}, #{piect_total}, #{total_net_weight}, #{weight_total},
			#{settlement_weight}, #{weight_state}, #{vrkme}, #{average_freight}, #{order_remark},
			#{delivery_time}, #{erdat}, #{plan_product_time}, #{open_ready_time}, #{already_ready_time},
			#{appearance_time}, #{sign_time}, #{edatu}, #{area_no}, #{area_name}, #{fmenge_time}, #{klabc},
			#{sales_man}, #{sales_department}, #{is_valid}, #{created_user_id}, #{created_time},
			#{modified_user_id}, #{modified_time}, #{remark}, #{is_auto_created}, #{delivery_state},
			#{operate_tag}, #{transport_time}, #{is_date_success}, #{is_num_success}, #{is_sign_success},
			#{weighing_weight}, #{delivery_issued_time}, #{hashResult})
    </insert>
    <delete id="deleteHandover" parameterType="com.huazheng.project.mysql.model.Handover">
    	delete from handover 
    	where handover_id = #{handover_id}
    </delete>
	<update id="updateHandover" parameterType="com.huazheng.project.mysql.model.Handover">
		update handover set
			vbeln = #{vbeln}, task_id = #{task_id}, handover_id = #{handover_id}, handover_type = #{handover_type}, order_type = #{order_type}, 
			task_no = #{task_no}, sale_no = #{sale_no}, delivery_type = #{delivery_type}, handover_state = #{handover_state}, f_plant = #{f_plant}, 
			plant = #{plant}, customer_id = #{customer_id}, customer_name = #{customer_name}, fmenge = #{fmenge}, delivery_num = #{delivery_num}, 
			port = #{port}, piect_total = #{piect_total}, total_net_weight = #{total_net_weight}, weight_total = #{weight_total}, 
			settlement_weight = #{settlement_weight}, weight_state = #{weight_state}, vrkme = #{vrkme}, average_freight = #{average_freight}, 
			order_remark = #{order_remark}, delivery_time = #{delivery_time}, erdat = #{erdat}, plan_product_time = #{plan_product_time}, 
			open_ready_time = #{open_ready_time}, already_ready_time = #{already_ready_time}, appearance_time = #{appearance_time}, 
			sign_time = #{sign_time}, edatu = #{edatu}, area_no = #{area_no}, area_name = #{area_name}, fmenge_time = #{fmenge_time}, klabc = #{klabc}, 
			sales_man = #{sales_man}, sales_department = #{sales_department}, is_valid = #{is_valid}, created_user_id = #{created_user_id}, 
			created_time = #{created_time}, modified_user_id = #{modified_user_id}, modified_time = #{modified_time}, remark = #{remark}, 
			is_auto_created = #{is_auto_created}, delivery_state = #{delivery_state}, operate_tag = #{operate_tag}, transport_time = #{transport_time}, 
			is_date_success = #{is_date_success}, is_num_success = #{is_num_success}, is_sign_success = #{is_sign_success}, weighing_weight = #{weighing_weight}, 
			delivery_issued_time = #{delivery_issued_time}, hashResult = #{hashResult}
		where handover_id = #{handover_id}
	</update>
    <select id="selectHandoverCheck" parameterType="com.huazheng.project.mysql.model.Handover" resultType="com.huazheng.project.mysql.model.Handover">
    	select * from handover where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectHandoverTask" parameterType="com.huazheng.project.mysql.model.HandoverTask" resultType="com.huazheng.project.mysql.model.HandoverTask">
    	select * from HandoverTask 
    	where task_id = #{task_id}
    </select>
	<insert id="insertHandoverTask" parameterType="com.huazheng.project.mysql.model.HandoverTask">
    	insert into HandoverTask (task_id, task_no, task_type, task_state, f_plant, plant, customer_id, 
    		customer_name, kunnr, actual_handover_num, receipt_state, receipt_time, 
    		cost_state, cost_handle_time, handover_print_state, last_print_time, 
    		appearance_state, appearance_time, company_id, company_no, company_name, 
    		netweight_count, weight_count, handover_direct_count, transport_type, vehicle_type, 
    		delivery_cost, delivery_date, sign_time, area_name, area_id, port, delivery_type, 
    		dispatch_type, piece_count, remark, is_valid, created_user_id, created_time, 
    		modified_user_id, modified_time, receipt_remark,s12,s21,s24, hashResult) 
    	values(#{task_id}, #{task_no}, #{task_type}, #{task_state}, #{f_plant}, #{plant}, #{customer_id},
    		#{customer_name}, #{kunnr}, #{actual_handover_num}, #{receipt_state}, #{receipt_time},
    		#{cost_state}, #{cost_handle_time}, #{handover_print_state}, #{last_print_time},
    		#{appearance_state}, #{appearance_time}, #{company_id}, #{company_no}, #{company_name},
    		#{netweight_count}, #{weight_count}, #{handover_direct_count}, #{transport_type}, #{vehicle_type},
    		#{delivery_cost}, #{delivery_date}, #{sign_time}, #{area_name}, #{area_id}, #{port}, #{delivery_type},
    		#{dispatch_type}, #{piece_count}, #{remark}, #{is_valid}, #{created_user_id}, #{created_time},
    		#{modified_user_id}, #{modified_time}, #{receipt_remark}, #{s12}, #{s21}, #{s24}, #{hashResult})
    </insert>
    <delete id="deleteHandoverTask" parameterType="com.huazheng.project.mysql.model.HandoverTask">
    	delete from HandoverTask 
    	where task_id = #{task_id}
    </delete>
    <update id="updateHandoverTask" parameterType="com.huazheng.project.mysql.model.HandoverTask">
    	update HandoverTask set
			task_id = #{task_id},task_no = #{task_no},task_type = #{task_type},task_state = #{task_state},
			f_plant = #{f_plant},plant = #{plant},customer_id = #{customer_id},customer_name = #{customer_name},
			kunnr = #{kunnr},actual_handover_num = #{actual_handover_num},receipt_state = #{receipt_state},
			receipt_time = #{receipt_time},cost_state = #{cost_state},cost_handle_time = #{cost_handle_time},
			handover_print_state = #{handover_print_state},last_print_time = #{last_print_time},
			appearance_state = #{appearance_state},appearance_time = #{appearance_time},company_id = #{company_id},
			company_no = #{company_no},company_name = #{company_name},netweight_count = #{netweight_count},
			weight_count = #{weight_count},handover_direct_count = #{handover_direct_count},transport_type = #{transport_type},
			vehicle_type = #{vehicle_type},delivery_cost = #{delivery_cost},delivery_date = #{delivery_date},
			sign_time = #{sign_time},area_name = #{area_name},area_id = #{area_id},port = #{port},delivery_type = #{delivery_type},
			dispatch_type = #{dispatch_type},piece_count = #{piece_count},remark = #{remark},is_valid = #{is_valid},
			created_user_id = #{created_user_id},created_time = #{created_time},modified_user_id = #{modified_user_id},
			modified_time = #{modified_time},receipt_remark = #{receipt_remark},s12 = #{s12},s21 = #{s21},s24 = #{s24},hashResult=#{hashResult}
		where task_id = #{task_id}
    </update>
    <select id="selectHandoverTaskCheck" parameterType="com.huazheng.project.mysql.model.HandoverTask" resultType="com.huazheng.project.mysql.model.HandoverTask">
    	select * from handoverTask where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectTransformNewNode" parameterType="com.huazheng.project.mysql.model.TransformNewNode" resultType="com.huazheng.project.mysql.model.TransformNewNode">
    	select * from TransformNewNode 
    	where id = #{id}
    </select>
    <insert id="insertTransformNewNode" parameterType="com.huazheng.project.mysql.model.TransformNewNode">
    	insert into TransformNewNode (id, task_id, task_no, vehicle_no, last_commit_time, first_node, second_node, 
			vehicle_type, driver, driver_phone, location, exception_comment, comit_type, 
			exception_type, exception_picture, is_valid, lon, lat, created_user_id, 
			created_time, modified_user_id, modified_time, hashResult) 
    	values(#{id}, #{task_id}, #{task_no}, #{vehicle_no}, #{last_commit_time}, #{first_node}, #{second_node},
			#{vehicle_type}, #{driver}, #{driver_phone}, #{location}, #{exception_comment}, #{comit_type},
			#{exception_type}, #{exception_picture}, #{is_valid}, #{lon}, #{lat}, #{created_user_id},
			#{created_time}, #{modified_user_id}, #{modified_time}, #{hashResult})
    </insert>
    <delete id="deleteTransformNewNode" parameterType="com.huazheng.project.mysql.model.TransformNewNode">
    	delete from TransformNewNode 
    	where id = #{id}
    </delete>
    <update id="updateTransformNewNode" parameterType="com.huazheng.project.mysql.model.TransformNewNode">
    	update TransformNewNode set 
	    	id = #{id}, task_id = #{task_id}, task_no = #{task_no}, vehicle_no = #{vehicle_no}, last_commit_time = #{last_commit_time}, 
	    	first_node = #{first_node}, second_node = #{second_node}, vehicle_type = #{vehicle_type}, driver = #{driver}, 
	    	driver_phone = #{driver_phone}, location = #{location}, exception_comment = #{exception_comment}, comit_type = #{comit_type}, 
	    	exception_type = #{exception_type}, exception_picture = #{exception_picture}, is_valid = #{is_valid}, 
	    	lon = #{lon}, lat = #{lat}, created_user_id = #{created_user_id}, created_time = #{created_time}, modified_user_id = #{modified_user_id}, 
	    	modified_time = #{modified_time}, hashResult = #{hashResult}
    	where id = #{id}
    </update>
    <select id="selectTransformNewNodeCheck" parameterType="com.huazheng.project.mysql.model.TransformNewNode" resultType="com.huazheng.project.mysql.model.TransformNewNode">
    	select * from TransformNewNode where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectTransformHistoryNode" parameterType="com.huazheng.project.mysql.model.TransformHistoryNode" resultType="com.huazheng.project.mysql.model.TransformHistoryNode">
    	select * from TransformHistoryNode 
    	where id = #{id}
    </select>
    <insert id="insertTransformHistoryNode" parameterType="com.huazheng.project.mysql.model.TransformHistoryNode">
    	insert into TransformHistoryNode (id, task_no, last_commit_time, second_node, hashResult) 
    	values(#{id}, #{task_no}, #{last_commit_time}, #{second_node}, #{hashResult})
    </insert>
    <delete id="deleteTransformHistoryNode" parameterType="com.huazheng.project.mysql.model.TransformHistoryNode">
    	delete from TransformHistoryNode 
    	where id = #{id}
    </delete>
	<update id="updateTransformHistoryNode" parameterType="com.huazheng.project.mysql.model.TransformHistoryNode">
    	update TransformHistoryNode set 
	    	id = #{id}, task_no = #{task_no}, last_commit_time = #{last_commit_time}, second_node = #{second_node}, hashResult = #{hashResult}
    	where id = #{id}
    </update>
    <select id="selectTransformHistoryNodeCheck" parameterType="com.huazheng.project.mysql.model.TransformHistoryNode" resultType="com.huazheng.project.mysql.model.TransformHistoryNode">
    	select * from TransformHistoryNode where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    
    
    <select id="selectTasks" parameterType="com.huazheng.project.mssql4.model.Tasks" resultType="com.huazheng.project.mssql4.model.Tasks">
    	select * from Tasks 
    	where taskId = #{taskId}
    </select>
    <insert id="insertTasks" parameterType="com.huazheng.project.mssql4.model.Tasks">
    	insert into Tasks (taskId, processName, incident, startTime, taskUser, hashResult) 
    	values(#{taskId}, #{processName}, #{incident}, #{startTime}, #{taskUser}, #{hashResult})
    </insert>
    <delete id="deleteTasks" parameterType="com.huazheng.project.mssql4.model.Tasks">
    	delete from Tasks 
    	where taskId = #{taskId}
    </delete>
	<update id="updateTasks" parameterType="com.huazheng.project.mssql4.model.Tasks">
    	update Tasks set 
	    	taskId = #{taskId}, processName = #{processName}, incident = #{incident}, startTime = #{startTime}, taskUser = #{taskUser}, hashResult = #{hashResult}
    	where taskId = #{taskId}
    </update>
    <select id="selectTasksCheck" parameterType="com.huazheng.project.mssql4.model.Tasks" resultType="com.huazheng.project.mssql4.model.Tasks">
    	select * from Tasks where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    
    
    
	<select id="selectSysSAPreturnNo" parameterType="com.huazheng.project.mssql2.model.SysSAPreturnNo" resultType="com.huazheng.project.mssql2.model.SysSAPreturnNo">
    	select * from SysSAPreturnNo 
    	where id = #{id}
    </select>
    <insert id="insertSysSAPreturnNo" parameterType="com.huazheng.project.mssql2.model.SysSAPreturnNo">
    	insert into SysSAPreturnNo (id, processName, shiLiH, sapNo, chuangJianSJ, hashResult) 
    	values(#{id}, #{processName}, #{shiLiH}, #{sapNo}, #{chuangJianSJ}, #{hashResult})
    </insert>
	<delete id="deleteSysSAPreturnNo" parameterType="com.huazheng.project.mssql2.model.SysSAPreturnNo">
    	delete from SysSAPreturnNo 
    	where id = #{id}
    </delete>
	<update id="updateSysSAPreturnNo" parameterType="com.huazheng.project.mssql2.model.SysSAPreturnNo">
    	update SysSAPreturnNo set 
	    	id = #{id}, processName = #{processName}, shiLiH = #{shiLiH}, sapNo = #{sapNo}, chuangJianSJ = #{chuangJianSJ}, hashResult = #{hashResult}
    	where id = #{id}
    </update>
	<select id="selectSysSAPreturnNoCheck" parameterType="com.huazheng.project.mssql2.model.SysSAPreturnNo" resultType="com.huazheng.project.mssql2.model.SysSAPreturnNo">
    	select * from SysSAPreturnNo where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
	<select id="selectSalesContractProcess" parameterType="com.huazheng.project.mssql.model.SalesContractProcess" resultType="com.huazheng.project.mssql.model.SalesContractProcess">
    	select * from SalesContractProcess where id = #{id}
    </select>
    <insert id="insertSalesContractProcess" parameterType="com.huazheng.project.mssql.model.SalesContractProcess">
    	insert into SalesContractProcess (id, xiaoShouDDBH, xuFangGSID, xuFangGS, gongFangGSt, xiaoShouBMt, shouHuoGSID, shouHuoGS, 
			fuKuanTJt, caiGouDDBH, dangQianXYED, yvQiK, dengJi, biZhongt, yongJin, zongHeMLL, sysProcessname, sysIncident, ziShiYBv, hashResult) 
    	values(#{id}, #{xiaoShouDDBH}, #{xuFangGSID}, #{xuFangGS}, #{gongFangGSt}, #{xiaoShouBMt}, #{shouHuoGSID}, #{shouHuoGS}, #{fuKuanTJt}, 
    	#{caiGouDDBH}, #{dangQianXYED}, #{yvQiK}, #{dengJi}, #{biZhongt}, #{yongJin}, #{zongHeMLL}, #{sysProcessname}, #{sysIncident}, #{ziShiYBv}, #{hashResult})
    </insert>
    <delete id="deleteSalesContractProcess" parameterType="com.huazheng.project.mssql.model.SalesContractProcess">
    	delete from SalesContractProcess where id = #{id}
    </delete>
    <update id="updateSalesContractProcess" parameterType="com.huazheng.project.mssql.model.SalesContractProcess">
    	update SalesContractProcess set 
    		id = #{id}, xiaoShouDDBH = #{xiaoShouDDBH}, xuFangGSID = #{xuFangGSID}, xuFangGS = #{xuFangGS}, gongFangGSt = #{gongFangGSt}, 
    		xiaoShouBMt = #{xiaoShouBMt}, shouHuoGSID = #{shouHuoGSID}, shouHuoGS = #{shouHuoGS}, fuKuanTJt = #{fuKuanTJt}, caiGouDDBH = #{caiGouDDBH}, 
    		dangQianXYED = #{dangQianXYED}, yvQiK = #{yvQiK}, dengJi = #{dengJi}, biZhongt = #{biZhongt}, yongJin = #{yongJin}, zongHeMLL = #{zongHeMLL}, 
    		sysProcessname = #{sysProcessname}, sysIncident = #{sysIncident}, ziShiYBv = #{ziShiYBv}, hashResult = #{hashResult}
		where id = #{id}
    </update>
	<select id="selectSalesContractProcessCheck" parameterType="com.huazheng.project.mssql.model.SalesContractProcess" resultType="com.huazheng.project.mssql.model.SalesContractProcess">
    	select * from SalesContractProcess where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectSalesContractProcessMX" parameterType="com.huazheng.project.mssql.model.SalesContractProcessMX" resultType="com.huazheng.project.mssql.model.SalesContractProcessMX">
    	select * from SalesContractProcessMX where id = #{id}
    </select>
    <insert id="insertSalesContractProcessMX" parameterType="com.huazheng.project.mssql.model.SalesContractProcessMX">
    	insert into SalesContractProcessMX (id, chengben, sysIncident, zongjia, maolibz, hashResult) values(#{id}, #{chengben}, #{sysIncident}, #{zongjia}, #{maolibz}, #{hashResult})
    </insert>
    <delete id="deleteSalesContractProcessMX" parameterType="com.huazheng.project.mssql.model.SalesContractProcessMX">
    	delete from SalesContractProcessMX where id = #{id}
    </delete>
	<update id="updateSalesContractProcessMX" parameterType="com.huazheng.project.mssql.model.SalesContractProcessMX">
    	update SalesContractProcessMX set 
    		id = #{id}, chengben = #{chengben}, sysIncident = #{sysIncident}, zongjia = #{zongjia}, maolibz = #{maolibz}, hashResult = #{hashResult}
		where id = #{id}
    </update>
	<select id="selectSalesContractProcessMXCheck" parameterType="com.huazheng.project.mssql.model.SalesContractProcessMX" resultType="com.huazheng.project.mssql.model.SalesContractProcessMX">
    	select * from SalesContractProcessMX where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectSalesForecastProcess" parameterType="com.huazheng.project.mssql.model.SalesForecastProcess" resultType="com.huazheng.project.mssql.model.SalesForecastProcess">
    	select * from SalesForecastProcess where id = #{id}
    </select>
    <insert id="insertSalesForecastProcess" parameterType="com.huazheng.project.mssql.model.SalesForecastProcess">
    	insert into SalesForecastProcess (id, shenQingR, sysIncstatus, sysProcessname, sysIncident, shenQingRBM, yuCeLXt, kaiShiSJ, jieShuSJ,shenQingRLN, hashResult) 
    	values(#{id}, #{shenQingR}, #{sysIncstatus}, #{sysProcessname}, #{sysIncident}, #{shenQingRBM}, #{yuCeLXt}, #{kaiShiSJ}, #{jieShuSJ}, #{shenQingRLN}, #{hashResult})
    </insert>
    <delete id="deleteSalesForecastProcess" parameterType="com.huazheng.project.mssql.model.SalesForecastProcess">
    	delete from SalesForecastProcess where id = #{id}
    </delete>
    <update id="updateSalesForecastProcess" parameterType="com.huazheng.project.mssql.model.SalesForecastProcess">
    	update SalesForecastProcess set
    	id = #{id}, shenQingR = #{shenQingR}, sysIncstatus = #{sysIncstatus}, sysProcessname = #{sysProcessname}, sysIncident = #{sysIncident}, 
    	shenQingRBM = #{shenQingRBM}, yuCeLXt = #{yuCeLXt}, kaiShiSJ = #{kaiShiSJ}, jieShuSJ = #{jieShuSJ}, shenQingRLN = #{shenQingRLN}, hashResult = #{hashResult}
    	where id = #{id}
    </update>
	<select id="selectSalesForecastProcessCheck" parameterType="com.huazheng.project.mssql.model.SalesForecastProcess" resultType="com.huazheng.project.mssql.model.SalesForecastProcess">
    	select * from SalesForecastProcess where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectSalesForecastProcessMX" parameterType="com.huazheng.project.mssql.model.SalesForecastProcessMX" resultType="com.huazheng.project.mssql.model.SalesForecastProcessMX">
    	select * from SalesForecastProcessMX where id = #{id}
    </select>
    <insert id="insertSalesForecastProcessMX" parameterType="com.huazheng.project.mssql.model.SalesForecastProcessMX">
    	insert into SalesForecastProcessMX (id, wuLiaoH, wuLiaoMS, keHuMC, jiHuaJDL, mingXiMingC, sysIncident, hashResult) 
    	values(#{id}, #{wuLiaoH}, #{wuLiaoMS}, #{keHuMC}, #{jiHuaJDL}, #{mingXiMingC}, #{sysIncident}, #{hashResult})
    </insert>
    <delete id="deleteSalesForecastProcessMX" parameterType="com.huazheng.project.mssql.model.SalesForecastProcessMX">
    	delete from SalesForecastProcessMX where id = #{id}
    </delete>
    <update id="updateSalesForecastProcessMX" parameterType="com.huazheng.project.mssql.model.SalesForecastProcessMX">
    	update SalesForecastProcessMX set
    	id = #{id}, wuLiaoH = #{wuLiaoH}, wuLiaoMS = #{wuLiaoMS}, keHuMC = #{keHuMC}, jiHuaJDL = #{jiHuaJDL}, 
    	mingXiMingC = #{mingXiMingC}, sysIncident = #{sysIncident}, hashResult = #{hashResult}
    	where id = #{id}
    </update>
	<select id="selectSalesForecastProcessMXCheck" parameterType="com.huazheng.project.mssql.model.SalesForecastProcessMX" resultType="com.huazheng.project.mssql.model.SalesForecastProcessMX">
    	select * from SalesForecastProcessMX where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    
    
    
    <select id="selectSampleApplicationProcess" parameterType="com.huazheng.project.mssql.model.SampleApplicationProcess" resultType="com.huazheng.project.mssql.model.SampleApplicationProcess">
    	select * from SampleApplicationProcess where id = #{id}
    </select>
    <insert id="insertSampleApplicationProcess" parameterType="com.huazheng.project.mssql.model.SampleApplicationProcess">
    	insert into SampleApplicationProcess (id, dingDanLXv, dingDanLXt, sYS_INCIDENT, yeWuYID, xuFangGS, xuFangGSID, 
    		yangPinLXv, yangPinLXt, pCBCS, chanPinYY, jiFuBZ, sYS_UPDATETIME,pCBCS2chanPinYY, ziSHiYBv, hashResult) 
    	values(#{id}, #{dingDanLXv}, #{dingDanLXt}, #{sYS_INCIDENT}, #{yeWuYID}, #{xuFangGS}, #{xuFangGSID}, 
    		#{yangPinLXv}, #{yangPinLXt}, #{pCBCS}, #{chanPinYY}, #{jiFuBZ}, #{sYS_UPDATETIME},#{pCBCS2chanPinYY},#{ziSHiYBv}, #{hashResult})
    </insert>
    <delete id="deleteSampleApplicationProcess" parameterType="com.huazheng.project.mssql.model.SampleApplicationProcess">
    	delete from SampleApplicationProcess where id = #{id}
    </delete>
    <update id="updateSampleApplicationProcess" parameterType="com.huazheng.project.mssql.model.SampleApplicationProcess">
    	update SampleApplicationProcess set
    		dingDanLXv = #{dingDanLXv}, dingDanLXt = #{dingDanLXt}, sYS_INCIDENT = #{sYS_INCIDENT}, yeWuYID = #{yeWuYID}, xuFangGS = #{xuFangGS}, xuFangGSID = #{xuFangGSID}, 
    		yangPinLXv = #{yangPinLXv}, yangPinLXt = #{yangPinLXt}, pCBCS = #{pCBCS}, chanPinYY = #{chanPinYY}, jiFuBZ = #{jiFuBZ}, 
    		sYS_UPDATETIME = #{sYS_UPDATETIME},pCBCS2chanPinYY=#{pCBCS2chanPinYY},ziSHiYBv=#{ziSHiYBv}, hashResult = #{hashResult}
    	where id = #{id}
    </update>
	<select id="selectSampleApplicationProcessCheck" parameterType="com.huazheng.project.mssql.model.SampleApplicationProcess" resultType="com.huazheng.project.mssql.model.SampleApplicationProcess">
    	select * from SampleApplicationProcess where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    
    
    
    
    <select id="selectSampleApplicationProcessMingXi" parameterType="com.huazheng.project.mssql.model.SampleApplicationProcessMingXi" resultType="com.huazheng.project.mssql.model.SampleApplicationProcessMingXi">
    	select * from SampleApplicationProcessMingXi where id = #{id}
    </select>
    <insert id="insertSampleApplicationProcessMingXi" parameterType="com.huazheng.project.mssql.model.SampleApplicationProcessMingXi">
    	insert into SampleApplicationProcessMingXi (id,sYS_INCIDENT,uLPH,wuLiaoMS,shuLiang,hangXiangMH,hangxiangmh1,hashResult) 
    	values(#{id},#{sYS_INCIDENT},#{uLPH},#{wuLiaoMS},#{shuLiang},#{hangXiangMH},#{hangxiangmh1},#{hashResult})
    </insert>
    <delete id="deleteSampleApplicationProcessMingXi" parameterType="com.huazheng.project.mssql.model.SampleApplicationProcessMingXi">
    	delete from SampleApplicationProcessMingXi where id = #{id}
    </delete>
    <update id="updateSampleApplicationProcessMingXi" parameterType="com.huazheng.project.mssql.model.SampleApplicationProcessMingXi">
    	update SampleApplicationProcessMingXi set
    		sYS_INCIDENT=#{sYS_INCIDENT},uLPH=#{uLPH},wuLiaoMS=#{wuLiaoMS},shuLiang=#{shuLiang},hangXiangMH=#{hangXiangMH},
    		hangxiangmh1=#{hangxiangmh1},hashResult=#{hashResult}
    	where id = #{id}
    </update>
	<select id="selectSampleApplicationProcessMingXiCheck" parameterType="com.huazheng.project.mssql.model.SampleApplicationProcessMingXi" resultType="com.huazheng.project.mssql.model.SampleApplicationProcessMingXi">
    	select * from SampleApplicationProcessMingXi where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    
    
    
	<select id="selectSampleClosingProcess" parameterType="com.huazheng.project.mssql.model.SampleClosingProcess" resultType="com.huazheng.project.mssql.model.SampleClosingProcess">
    	select * from SampleClosingProcess where id = #{id}
    </select>
    <insert id="insertSampleClosingProcess" parameterType="com.huazheng.project.mssql.model.SampleClosingProcess">
    	insert into SampleClosingProcess (id,sYS_INCIDENT,yangPinSQSLH,yangPinSQSLHi,sYS_INCSTATUS,hashResult) 
    	values(#{id},#{sYS_INCIDENT},#{yangPinSQSLH},#{yangPinSQSLHi},#{sYS_INCSTATUS},#{sys_updatetime},#{hashResult})
    </insert>
    <delete id="deleteSampleClosingProcess" parameterType="com.huazheng.project.mssql.model.SampleClosingProcess">
    	delete from SampleClosingProcess where id = #{id}
    </delete>
    <update id="updateSampleClosingProcess" parameterType="com.huazheng.project.mssql.model.SampleClosingProcess">
    	update SampleClosingProcess set
			sYS_INCIDENT=#{sYS_INCIDENT},yangPinSQSLH=#{yangPinSQSLH},yangPinSQSLHi=#{yangPinSQSLHi},
			sYS_INCSTATUS=#{sYS_INCSTATUS},sys_updatetime=#{sys_updatetime},hashResult=#{hashResult}
    	where id = #{id}
    </update>
	<select id="selectSampleClosingProcessCheck" parameterType="com.huazheng.project.mssql.model.SampleClosingProcess" resultType="com.huazheng.project.mssql.model.SampleClosingProcess">
    	select * from SampleClosingProcess where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    
    
    
    
    
	<select id="selectSampleClosingProcessMingXi" parameterType="com.huazheng.project.mssql.model.SampleClosingProcessMingXi" resultType="com.huazheng.project.mssql.model.SampleClosingProcessMingXi">
    	select * from SampleClosingProcessMingXi where id = #{id}
    </select>
    <insert id="insertSampleClosingProcessMingXi" parameterType="com.huazheng.project.mssql.model.SampleClosingProcessMingXi">
    	insert into SampleClosingProcessMingXi (id,sYS_INCIDENT,shiFouTGv,shiFouTGt,hashResult) 
    	values(#{id},#{sYS_INCIDENT},#{shiFouTGv},#{shiFouTGt},#{hashResult})
    </insert>
    <delete id="deleteSampleClosingProcessMingXi" parameterType="com.huazheng.project.mssql.model.SampleClosingProcessMingXi">
    	delete from SampleClosingProcessMingXi where id = #{id}
    </delete>
    <update id="updateSampleClosingProcessMingXi" parameterType="com.huazheng.project.mssql.model.SampleClosingProcessMingXi">
    	update SampleClosingProcessMingXi set
    		sYS_INCIDENT=#{sYS_INCIDENT},shiFouTGv=#{shiFouTGv},shiFouTGt=#{shiFouTGt},hashResult=#{hashResult}
    	where id = #{id}
    </update>
	<select id="selectSampleClosingProcessMingXiCheck" parameterType="com.huazheng.project.mssql.model.SampleClosingProcessMingXi" resultType="com.huazheng.project.mssql.model.SampleClosingProcessMingXi">
    	select * from SampleClosingProcessMingXi where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
	<select id="selectTKeHu" parameterType="com.huazheng.project.mssql2.model.TKeHu" resultType="com.huazheng.project.mssql2.model.TKeHu">
    	select * from TKeHu where keHuID = #{keHuID}
    </select>
    <insert id="insertTKeHu" parameterType="com.huazheng.project.mssql2.model.TKeHu">
    	insert into TKeHu (keHuID,keHuCode,keHuMC,xinBaoED,diQu,hashResult) 
    	values(#{keHuID}, #{keHuCode}, #{keHuMC}, #{xinBaoED}, #{diQu}, #{hashResult})
    </insert>
	<delete id="deleteTKeHu" parameterType="com.huazheng.project.mssql2.model.TKeHu">
    	delete from TKeHu where keHuID = #{keHuID}
    </delete>
    <update id="updateTKeHu" parameterType="com.huazheng.project.mssql2.model.TKeHu">
    	update TKeHu set
    	keHuID = #{keHuID}, keHuCode = #{keHuCode}, keHuMC = #{keHuMC}, xinBaoED = #{xinBaoED}, diQu = #{diQu}, hashResult = #{hashResult}
    	where keHuID = #{keHuID}
    </update>
	<select id="selectTKeHuCheck" parameterType="com.huazheng.project.mssql2.model.TKeHu" resultType="com.huazheng.project.mssql2.model.TKeHu">
    	select * from TKeHu where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
   	<select id="selectTKeHuXiaoShouZZ" parameterType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZ" resultType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZ">
    	select * from TKeHuXiaoShouZZ where id = #{id}
    </select>
    <insert id="insertTKeHuXiaoShouZZ" parameterType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZ">
    	insert into TKeHuXiaoShouZZ (id,keHuID,fuKuanTJ,hashResult) 
    	values(#{id}, #{keHuID}, #{fuKuanTJ}, #{hashResult})
    </insert>
	<delete id="deleteTKeHuXiaoShouZZ" parameterType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZ">
    	delete from TKeHuXiaoShouZZ where id = #{id}
    </delete>
    <update id="updateTKeHuXiaoShouZZ" parameterType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZ">
    	update TKeHuXiaoShouZZ set
    	id = #{id}, keHuID = #{keHuID}, fuKuanTJ = #{fuKuanTJ}, hashResult = #{hashResult}
    	where id = #{id}
    </update>
	<select id="selectTKeHuXiaoShouZZCheck" parameterType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZ" resultType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZ">
    	select * from TKeHuXiaoShouZZ where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
	<select id="selectTKeHuXiaoShouZZYeWuY" parameterType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZYeWuY" resultType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZYeWuY">
    	select * from TKeHuXiaoShouZZYeWuY where id = #{id}
    </select>
    <insert id="insertTKeHuXiaoShouZZYeWuY" parameterType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZYeWuY">
    	insert into TKeHuXiaoShouZZYeWuY (id,keHuID,yeWuYMC,hashResult) 
    	values(#{id}, #{keHuID}, #{yeWuYMC}, #{hashResult})
    </insert>
	<delete id="deleteTKeHuXiaoShouZZYeWuY" parameterType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZYeWuY">
    	delete from TKeHuXiaoShouZZYeWuY where id = #{id}
    </delete>
    <update id="updateTKeHuXiaoShouZZYeWuY" parameterType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZYeWuY">
    	update TKeHuXiaoShouZZYeWuY set
    	id = #{id}, keHuID = #{keHuID}, yeWuYMC = #{yeWuYMC},yeWuYLoginName = #{yeWuYLoginName}, hashResult = #{hashResult}
    	where id = #{id}
    </update>
	<select id="selectTKeHuXiaoShouZZYeWuYCheck" parameterType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZYeWuY" resultType="com.huazheng.project.mssql2.model.TKeHuXiaoShouZZYeWuY">
    	select * from TKeHuXiaoShouZZYeWuY where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
	<select id="selectTWuLiaoDB" parameterType="com.huazheng.project.mssql2.model.TWuLiaoDB" resultType="com.huazheng.project.mssql2.model.TWuLiaoDB">
    	select * from TWuLiaoDB where id = #{id}
    </select>
    <insert id="insertTWuLiaoDB" parameterType="com.huazheng.project.mssql2.model.TWuLiaoDB">
    	insert into TWuLiaoDB (id, chuangJianRLN, chuangJianR, chuangJianSJ, gengXinRLN, gengXinR, gengXinSJ, 
    		shanChuRLN, shanChuR, shanChuSJ, shiFouYSC, keHuID, keHuMC, keHuWLMC, xiTongWLMC, xiTongWLBM, keHuWLBM,hashResult) 
    	values(#{id}, #{chuangJianRLN}, #{chuangJianR}, #{chuangJianSJ}, #{gengXinRLN}, #{gengXinR}, #{gengXinSJ}, 
    		#{shanChuRLN}, #{shanChuR}, #{shanChuSJ}, #{shiFouYSC}, #{keHuID}, #{keHuMC}, #{keHuWLMC}, #{xiTongWLMC}, #{xiTongWLBM}, #{keHuWLBM}, #{hashResult})
    </insert>
    <delete id="deleteTWuLiaoDB" parameterType="com.huazheng.project.mssql2.model.TWuLiaoDB">
    	delete from TWuLiaoDB where id = #{id}
    </delete>
    <update id="updateTWuLiaoDB" parameterType="com.huazheng.project.mssql2.model.TWuLiaoDB">
    	update TWuLiaoDB set
	    	id = #{id}, chuangJianRLN = #{chuangJianRLN}, chuangJianR = #{chuangJianR}, chuangJianSJ = #{chuangJianSJ}, gengXinRLN = #{gengXinRLN}, 
	    	gengXinR = #{gengXinR}, gengXinSJ = #{gengXinSJ}, shanChuRLN = #{shanChuRLN}, shanChuR = #{shanChuR}, shanChuSJ = #{shanChuSJ}, 
	    	shiFouYSC = #{shiFouYSC}, keHuID = #{keHuID}, keHuMC = #{keHuMC}, keHuWLMC = #{keHuWLMC}, xiTongWLMC = #{xiTongWLMC}, 
	    	xiTongWLBM = #{xiTongWLBM}, keHuWLBM = #{keHuWLBM}, hashResult = #{hashResult}
    	where id = #{id}
    </update>
	<select id="selectTWuLiaoDBCheck" parameterType="com.huazheng.project.mssql2.model.TWuLiaoDB" resultType="com.huazheng.project.mssql2.model.TWuLiaoDB">
    	select * from TWuLiaoDB where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
	
    <select id="selectAfko" parameterType="com.huazheng.project.hana.model.Afko" resultType="com.huazheng.project.hana.model.Afko">
    	select * from afko where aufnr = #{aufnr} and mandt = #{mandt}
    </select>    
    <insert id="insertAfko" parameterType="com.huazheng.project.hana.model.Afko">
    	insert into afko (aufnr, mandt, gltrp, gamng, plnbez, gmein, plnnr, plnal, stlnr, cy_seqnr, gstrp, 
    		aufpl, aplzt, gltrp1, gstrp1,hashResult) 
    	values(#{aufnr}, #{mandt}, #{gltrp}, #{gamng}, #{plnbez}, #{gmein}, #{plnnr}, #{plnal}, #{stlnr}, #{cy_seqnr}, #{gstrp},
    		#{aufpl}, #{aplzt}, #{gltrp1}, #{gstrp1}, #{hashResult})
    </insert>
    <delete id="deleteAfko" parameterType="com.huazheng.project.hana.model.Afko">
    	delete from afko where aufnr = #{aufnr} and mandt = #{mandt}
    </delete>
    <update id="updateAfko" parameterType="com.huazheng.project.hana.model.Afko">
    	update Afko set
	    	aufnr = #{aufnr}, mandt = #{mandt}, gltrp = #{gltrp}, gamng = #{gamng}, plnbez = #{plnbez}, 
	    	gmein = #{gmein}, plnnr = #{plnnr}, plnal = #{plnal}, stlnr = #{stlnr}, cy_seqnr = #{cy_seqnr}, 
	    	gstrp = #{gstrp}, aufpl = #{aufpl}, aplzt = #{aplzt}, gltrp1 = #{gltrp1}, gstrp1 = #{gstrp1}, hashResult = #{hashResult}
    	where aufnr = #{aufnr} and mandt = #{mandt}
    </update>
	<select id="selectAfkoCheck" parameterType="com.huazheng.project.hana.model.Afko" resultType="com.huazheng.project.hana.model.Afko">
    	select * from Afko where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectAfpo" parameterType="com.huazheng.project.hana.model.Afpo" resultType="com.huazheng.project.hana.model.Afpo">
    	select * from afpo 
    	where aufnr = #{aufnr} and mandt = #{mandt} and posnr = #{posnr}
    </select>
    <insert id="insertAfpo" parameterType="com.huazheng.project.hana.model.Afpo">
    	insert into afpo (kdauf, kdpos, aufnr, mandt, posnr, psmng, wemng, meins, matnr, uebto, untto, pwerk, 
    		verid, dwerk, dauat, krsnr, sernr, plnum,hashResult) 
    	values(#{kdauf}, #{kdpos}, #{aufnr}, #{mandt}, #{posnr}, #{psmng}, #{wemng}, #{meins}, #{matnr}, #{uebto}, #{untto}, #{pwerk},
    		#{verid}, #{dwerk}, #{dauat}, #{krsnr}, #{sernr}, #{plnum}, #{hashResult})
    </insert>
    <delete id="deleteAfpo" parameterType="com.huazheng.project.hana.model.Afpo">
    	delete from afpo 
    	where aufnr = #{aufnr} and mandt = #{mandt} and posnr = #{posnr}
    </delete>
    <update id="updateAfpo" parameterType="com.huazheng.project.hana.model.Afpo">
    	update Afpo set
			kdauf = #{kdauf}, kdpos = #{kdpos}, aufnr = #{aufnr}, mandt = #{mandt}, posnr = #{posnr}, psmng = #{psmng}, wemng = #{wemng}, 
			meins = #{meins}, matnr = #{matnr}, uebto = #{uebto}, untto = #{untto}, pwerk = #{pwerk}, verid = #{verid}, dwerk = #{dwerk}, 
			dauat = #{dauat}, krsnr = #{krsnr}, sernr = #{sernr}, plnum = #{plnum}, hashResult = #{hashResult}
    	where aufnr = #{aufnr} and mandt = #{mandt} and posnr = #{posnr}
    </update>
	<select id="selectAfpoCheck" parameterType="com.huazheng.project.hana.model.Afpo" resultType="com.huazheng.project.hana.model.Afpo">
    	select * from Afpo where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectAufk" parameterType="com.huazheng.project.hana.model.Aufk" resultType="com.huazheng.project.hana.model.Aufk">
    	select * from aufk where mandt = #{mandt} and aufnr = #{aufnr}
    </select>
    <insert id="insertAufk" parameterType="com.huazheng.project.hana.model.Aufk">
		insert into aufk (kdauf, kdpos, mandt, aufnr, erdat, erfzeit, ernam, aenam, bukrs, erdat1, erdat2, loekz, auart, werks, hashResult) 
		values (#{kdauf}, #{kdpos}, #{mandt}, #{aufnr}, #{erdat}, #{erfzeit}, #{ernam}, #{aenam}, #{bukrs}, #{erdat1}, #{erdat2}, #{loekz}, #{auart}, #{werks}, #{hashResult})
    </insert>
    <delete id="deleteAufk" parameterType="com.huazheng.project.hana.model.Aufk">
    	delete from aufk where mandt = #{mandt} and aufnr = #{aufnr}
    </delete>
    <update id="updateAufk" parameterType="com.huazheng.project.hana.model.Aufk">
    	update Aufk set
			kdauf = #{kdauf}, kdpos = #{kdpos}, mandt = #{mandt}, aufnr = #{aufnr}, erdat = #{erdat}, erfzeit = #{erfzeit}, 
			ernam = #{ernam}, aenam = #{aenam}, bukrs = #{bukrs}, erdat1 = #{erdat1}, erdat2 = #{erdat2}, loekz=#{loekz}, auart=#{auart}, werks=#{werks}, hashResult = #{hashResult}
    	where mandt = #{mandt} and aufnr = #{aufnr}
    </update>
	<select id="selectAufkCheck" parameterType="com.huazheng.project.hana.model.Aufk" resultType="com.huazheng.project.hana.model.Aufk">
    	select * from Aufk where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
	<select id="selectAufm" parameterType="com.huazheng.project.hana.model.Aufm" resultType="com.huazheng.project.hana.model.Aufm">
    	select * from aufm where mblnr = #{mblnr} and mandt = #{mandt}  and mjahr = #{mjahr} and zeile = #{zeile}
    </select>
    <insert id="insertAufm" parameterType="com.huazheng.project.hana.model.Aufm">
    	insert into aufm (mblnr, mjahr, zeile, bldat, budat, bwart, matnr, werks, lgort, 
			charg, sobkz, lifnr, kdauf, kdpos, shkzg, menge, bwtar, aufnr, bldat1, budat1, mandt, hashResult) 
    	values(#{mblnr}, #{mjahr}, #{zeile}, #{bldat}, #{budat}, #{bwart}, #{matnr}, #{werks}, #{lgort},
			#{charg}, #{sobkz}, #{lifnr}, #{kdauf}, #{kdpos}, #{shkzg}, #{menge}, #{bwtar}, #{aufnr}, #{bldat1}, #{budat1}, #{mandt}, #{hashResult})
    </insert>
   	<delete id="deleteAufm" parameterType="com.huazheng.project.hana.model.Aufm">
    	delete from aufm where mblnr = #{mblnr} and mandt = #{mandt}  and mjahr = #{mjahr} and zeile = #{zeile}
    </delete>
    <update id="updateAufm" parameterType="com.huazheng.project.hana.model.Aufm">
    	update Aufm set
			mblnr = #{mblnr}, mjahr = #{mjahr}, zeile = #{zeile}, bldat = #{bldat}, budat = #{budat}, bwart = #{bwart}, matnr = #{matnr}, 
			werks = #{werks}, lgort = #{lgort}, charg = #{charg}, sobkz = #{sobkz}, lifnr = #{lifnr}, kdauf = #{kdauf}, kdpos = #{kdpos}, 
			shkzg = #{shkzg}, menge = #{menge}, bwtar = #{bwtar}, aufnr = #{aufnr}, bldat1 = #{bldat1}, budat1 = #{budat1}, mandt = #{mandt}, 
			hashResult = #{hashResult}
    	where mblnr = #{mblnr} and mandt = #{mandt}  and mjahr = #{mjahr} and zeile = #{zeile}
    </update>
	<select id="selectAufmCheck" parameterType="com.huazheng.project.hana.model.Aufm" resultType="com.huazheng.project.hana.model.Aufm">
    	select * from Aufm where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
	<select id="selectKna1" parameterType="com.huazheng.project.hana.model.Kna1" resultType="com.huazheng.project.hana.model.Kna1">
    	select * from kna1 where kunnr = #{kunnr} and mandt = #{mandt} 
    </select>
    <insert id="insertKna1" parameterType="com.huazheng.project.hana.model.Kna1">
    	insert into kna1 (kunnr, name1, name2, mandt, ktokd, hashResult) values(#{kunnr}, #{name1}, #{name2}, #{mandt}, #{ktokd}, #{hashResult})
    </insert>
	<delete id="deleteKna1" parameterType="com.huazheng.project.hana.model.Kna1">
    	delete from kna1 where kunnr = #{kunnr} and mandt = #{mandt} 
    </delete>
    <update id="updateKna1" parameterType="com.huazheng.project.hana.model.Kna1">
    	update Kna1 set
    		kunnr = #{kunnr}, name1 = #{name1}, name2 = #{name2}, mandt = #{mandt}, ktokd = #{ktokd}, hashResult = #{hashResult}
    	where kunnr = #{kunnr} and mandt = #{mandt}
    </update>
	<select id="selectKna1Check" parameterType="com.huazheng.project.hana.model.Kna1" resultType="com.huazheng.project.hana.model.Kna1">
    	select * from Kna1 where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectKnkk" parameterType="com.huazheng.project.hana.model.Knkk" resultType="com.huazheng.project.hana.model.Knkk">
    	select * from Knkk where mandt = #{mandt} and kunnr = #{kunnr} and kkber = #{kkber}
    </select>
    <insert id="insertKnkk" parameterType="com.huazheng.project.hana.model.Knkk">
    	insert into Knkk (mandt,kunnr,kkber,klimk,skfor,ssobl,aedat, hashResult) 
    	values(#{mandt},#{kunnr},#{kkber},#{klimk},#{skfor}, #{ssobl},#{aedat}, #{hashResult})
    </insert>
	<delete id="deleteKnkk" parameterType="com.huazheng.project.hana.model.Knkk">
    	delete from Knkk where mandt = #{mandt} and kunnr = #{kunnr} and kkber = #{kkber}
    </delete>
    <update id="updateKnkk" parameterType="com.huazheng.project.hana.model.Knkk">
    	update Knkk set
    		mandt = #{mandt},kunnr = #{kunnr},kkber = #{kkber},klimk = #{klimk},skfor = #{skfor},
    		ssobl = #{ssobl},aedat=#{aedat}, hashResult = #{hashResult}
    	where mandt = #{mandt} and kunnr = #{kunnr} and kkber = #{kkber}
    </update>
	<select id="selectKnkkCheck" parameterType="com.huazheng.project.hana.model.Knkk" resultType="com.huazheng.project.hana.model.Knkk">
    	select * from Knkk where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectKnvv" parameterType="com.huazheng.project.hana.model.Knvv" resultType="com.huazheng.project.hana.model.Knvv">
    	select * from Knvv where mandt = #{mandt} and kunnr = #{kunnr} and vkorg = #{vkorg} and vtweg = #{vtweg} and spart = #{spart}
    </select>
    <insert id="insertKnvv" parameterType="com.huazheng.project.hana.model.Knvv">
    	insert into Knvv (mandt, kunnr, vkorg, vtweg, spart, waers, klabc,hashResult) 
    	values(#{mandt},#{kunnr},#{vkorg},#{vtweg},#{spart}, #{waers}, #{klabc},#{hashResult})
    </insert>
	<delete id="deleteKnvv" parameterType="com.huazheng.project.hana.model.Knvv">
    	delete from Knvv where mandt = #{mandt} and kunnr = #{kunnr} and vkorg = #{vkorg} and vtweg = #{vtweg} and spart = #{spart}
    </delete>
    <update id="updateKnvv" parameterType="com.huazheng.project.hana.model.Knvv">
    	update Knvv set
    		mandt = #{mandt}, kunnr = #{kunnr}, vkorg = #{vkorg}, vtweg = #{vtweg}, spart = #{spart}, waers = #{waers}, klabc = #{klabc},hashResult = #{hashResult}
    	where mandt = #{mandt} and kunnr = #{kunnr} and vkorg = #{vkorg} and vtweg = #{vtweg} and spart = #{spart}
    </update>
	<select id="selectKnvvCheck" parameterType="com.huazheng.project.hana.model.Knvv" resultType="com.huazheng.project.hana.model.Knvv">
    	select * from Knvv where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
   
    <select id="selectAfvc" parameterType="com.huazheng.project.hana.model.Afvc" resultType="com.huazheng.project.hana.model.Afvc">
    	select * from Afvc where mandt = #{mandt} and aufpl = #{aufpl} and aplzl = #{aplzl}
    </select>
    <insert id="insertAfvc" parameterType="com.huazheng.project.hana.model.Afvc">
    	insert into Afvc (mandt, aufpl, aplzl, steus, hashResult) 
    	values(#{mandt},#{aufpl},#{aplzl},#{steus},#{hashResult})
    </insert>
	<delete id="deleteAfvc" parameterType="com.huazheng.project.hana.model.Afvc">
    	delete from Afvc where mandt = #{mandt} and aufpl = #{aufpl} and aplzl = #{aplzl}
    </delete>
    <update id="updateAfvc" parameterType="com.huazheng.project.hana.model.Afvc">
    	update Afvc set
    		mandt = #{mandt}, aufpl = #{aufpl}, aplzl = #{aplzl}, steus = #{steus}, hashResult = #{hashResult}
    	where mandt = #{mandt} and aufpl = #{aufpl} and aplzl = #{aplzl}
    </update>
	<select id="selectAfvcCheck" parameterType="com.huazheng.project.hana.model.Afvc" resultType="com.huazheng.project.hana.model.Afvc">
        select * from Afvc where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
     <select id="selectKnvp" parameterType="com.huazheng.project.hana.model.Knvp" resultType="com.huazheng.project.hana.model.Knvp">
    	select * from Knvp where mandt = #{mandt} and kunnr = #{kunnr} and vkorg = #{vkorg} and vtweg = #{vtweg} and spart = #{spart} and parvw = #{parvw} and parza = #{parza}
    </select>
    <insert id="insertKnvp" parameterType="com.huazheng.project.hana.model.Knvp">
    	insert into Knvp (mandt, kunnr, vkorg, vtweg, spart, parvw, parza, kunn2, pernr, knref, hashResult) 
    	values(#{mandt},#{kunnr},#{vkorg},#{vtweg},#{spart},#{parvw},#{parza},#{kunn2},#{pernr},#{knref},#{hashResult})
    </insert>
	<delete id="deleteKnvp" parameterType="com.huazheng.project.hana.model.Knvp">
    	delete from Knvp where mandt = #{mandt} and kunnr = #{kunnr} and vkorg = #{vkorg} and vtweg = #{vtweg} and spart = #{spart} and parvw = #{parvw} and parza = #{parza}
    </delete>
    <update id="updateKnvp" parameterType="com.huazheng.project.hana.model.Knvp">
    	update Knvp set
    		mandt = #{mandt}, kunnr = #{kunnr}, vkorg = #{vkorg}, vtweg = #{vtweg}, spart = #{spart}, parvw = #{parvw}, parza = #{parza}, kunn2 = #{kunn2}, pernr = #{pernr}, knref = #{knref}, hashResult = #{hashResult}
    	where mandt = #{mandt} and kunnr = #{kunnr} and vkorg = #{vkorg} and vtweg = #{vtweg} and spart = #{spart} and parvw = #{parvw} and parza = #{parza}
    </update>
	<select id="selectKnvpCheck" parameterType="com.huazheng.project.hana.model.Knvp" resultType="com.huazheng.project.hana.model.Knvp">
        select * from Knvp where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectAusp" parameterType="com.huazheng.project.hana.model.Ausp" resultType="com.huazheng.project.hana.model.Ausp">
    	select * from Ausp where mandt = #{mandt} and objek = #{objek} and atinn = #{atinn} and atzhl = #{atzhl} and mafid = #{mafid} and klart = #{klart} and adzhl = #{adzhl}
    </select>
    <insert id="insertAusp" parameterType="com.huazheng.project.hana.model.Ausp">
    	insert into Ausp (mandt, objek, atinn, atzhl, mafid, klart, adzhl, atwrt, hashResult) 
    	values(#{mandt},#{objek},#{atinn},#{atzhl},#{mafid},#{klart},#{adzhl},#{atwrt},#{hashResult})
    </insert>
	<delete id="deleteAusp" parameterType="com.huazheng.project.hana.model.Ausp">
    	delete from Ausp where mandt = #{mandt} and objek = #{objek} and atinn = #{atinn} and atzhl = #{atzhl} and mafid = #{mafid} and klart = #{klart} and adzhl = #{adzhl}
    </delete>
    <update id="updateAusp" parameterType="com.huazheng.project.hana.model.Ausp">
    	update Ausp set               
    		mandt = #{mandt}, objek = #{objek}, atinn = #{atinn}, atzhl = #{atzhl}, mafid = #{mafid}, klart = #{klart}, adzhl = #{adzhl}, atwrt = #{atwrt}, hashResult = #{hashResult}
    	where mandt = #{mandt} and objek = #{objek} and atinn = #{atinn} and atzhl = #{atzhl} and mafid = #{mafid} and klart = #{klart} and adzhl = #{adzhl}
    </update>
	<select id="selectAuspCheck" parameterType="com.huazheng.project.hana.model.Ausp" resultType="com.huazheng.project.hana.model.Ausp">
        select * from Ausp where rownum &gt; #{rowNum} order by rownum limit 20
    </select>                       
    
    <select id="selectAfru" parameterType="com.huazheng.project.hana.model.Afru" resultType="com.huazheng.project.hana.model.Afru">
    	select * from Afru where mandt = #{mandt} and rueck = #{rueck} and rmzhl = #{rmzhl}
    </select>
    <insert id="insertAfru" parameterType="com.huazheng.project.hana.model.Afru">
    	insert into Afru (mandt, rueck, rmzhl, ersda, wablnr, aufnr, stokz, stzhl, hashResult) 
    	values(#{mandt},#{rueck},#{rmzhl},#{ersda},#{wablnr},#{aufnr},#{stokz},#{stzhl},#{hashResult})
    </insert>
	<delete id="deleteAfru" parameterType="com.huazheng.project.hana.model.Afru">
    	delete from Afru where mandt = #{mandt} and rueck = #{rueck} and rmzhl = #{rmzhl}
    </delete>
    <update id="updateAfru" parameterType="com.huazheng.project.hana.model.Afru">
    	update Afru set
    		mandt = #{mandt}, rueck = #{rueck}, rmzhl = #{rmzhl}, ersda = #{ersda}, wablnr = #{wablnr}, aufnr = #{aufnr}, stokz = #{stokz}, stzhl = #{stzhl}, hashResult = #{hashResult}
    	where mandt = #{mandt} and rueck = #{rueck} and rmzhl = #{rmzhl}
    </update>
	<select id="selectAfruCheck" parameterType="com.huazheng.project.hana.model.Afru" resultType="com.huazheng.project.hana.model.Afru">
        select * from Afru where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectTspat" parameterType="com.huazheng.project.hana.model.Tspat" resultType="com.huazheng.project.hana.model.Tspat">
    	select * from Tspat where mandt = #{mandt} and spras = #{spras} and spart = #{spart}
    </select>
    <insert id="insertTspat" parameterType="com.huazheng.project.hana.model.Tspat">
    	insert into Tspat (mandt, spras, spart, vtext, hashResult) 
    	values(#{mandt},#{spras},#{spart},#{vtext},#{hashResult})
    </insert>
	<delete id="deleteTspat" parameterType="com.huazheng.project.hana.model.Tspat">
    	delete from Tspat where mandt = #{mandt} and spras = #{spras} and spart = #{spart}
    </delete>
    <update id="updateTspat" parameterType="com.huazheng.project.hana.model.Tspat">
    	update Tspat set
    		mandt = #{mandt}, spras = #{spras}, spart = #{spart}, vtext = #{vtext}, hashResult = #{hashResult}
    	where mandt = #{mandt} and spras = #{spras} and spart = #{spart}
    </update>
	<select id="selectTspatCheck" parameterType="com.huazheng.project.hana.model.Tspat" resultType="com.huazheng.project.hana.model.Tspat">
        select * from Tspat where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectZpoedit" parameterType="com.huazheng.project.hana.model.Zpoedit" resultType="com.huazheng.project.hana.model.Zpoedit">
    	select * from Zpoedit where mandt = #{mandt} and pwerk = #{pwerk} and aufnr = #{aufnr}
    </select>
    <insert id="insertZpoedit" parameterType="com.huazheng.project.hana.model.Zpoedit">
    	insert into Zpoedit (mandt, pwerk, aufnr, reason, hashResult) 
    	values(#{mandt},#{pwerk},#{aufnr},#{reason},#{hashResult})
    </insert>
	<delete id="deleteZpoedit" parameterType="com.huazheng.project.hana.model.Zpoedit">
    	delete from Zpoedit where mandt = #{mandt} and pwerk = #{pwerk} and aufnr = #{aufnr}
    </delete>
    <update id="updateZpoedit" parameterType="com.huazheng.project.hana.model.Zpoedit">
    	update Zpoedit set
    		mandt = #{mandt}, pwerk = #{pwerk}, aufnr = #{aufnr}, reason = #{reason}, hashResult = #{hashResult}
    	where mandt = #{mandt} and pwerk = #{pwerk} and aufnr = #{aufnr}
    </update>
	<select id="selectZpoeditCheck" parameterType="com.huazheng.project.hana.model.Zpoedit" resultType="com.huazheng.project.hana.model.Zpoedit">
        select * from Zpoedit where rownum &gt; #{rowNum} order by rownum limit 20
    </select>

    
    <select id="selectMseg" parameterType="com.huazheng.project.hana.model.Mseg" resultType="com.huazheng.project.hana.model.Mseg">
    	select * from Mseg where mandt = #{mandt} and mblnr = #{mblnr} and mjahr = #{mjahr} and zeile = #{zeile}
    </select>
    <insert id="insertMseg" parameterType="com.huazheng.project.hana.model.Mseg">
    	insert into Mseg (mandt, mblnr, mjahr, zeile, bwart, charg, menge, budat_mkpf, cputm_mkpf, hashResult) 
    	values(#{mandt},#{mblnr},#{mjahr},#{zeile},#{bwart},#{charg},#{menge},#{budat_mkpf},#{cputm_mkpf},#{hashResult})
    </insert>
	<delete id="deleteMseg" parameterType="com.huazheng.project.hana.model.Mseg">
    	delete from Mseg where mandt = #{mandt} and mblnr = #{mblnr} and mjahr = #{mjahr} and zeile = #{zeile}
    </delete>
    <update id="updateMseg" parameterType="com.huazheng.project.hana.model.Mseg">
    	update Mseg set
    		mandt = #{mandt}, mblnr = #{mblnr}, mjahr = #{mjahr}, zeile = #{zeile}, bwart = #{bwart}, charg = #{charg}, menge = #{menge}, budat_mkpf = #{budat_mkpf}, cputm_mkpf = #{cputm_mkpf}, hashResult = #{hashResult}
    	where mandt = #{mandt} and mblnr = #{mblnr} and mjahr = #{mjahr} and zeile = #{zeile}
    </update>
	<select id="selectMsegCheck" parameterType="com.huazheng.project.hana.model.Mseg" resultType="com.huazheng.project.hana.model.Mseg">
        select * from Mseg where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectMkpf" parameterType="com.huazheng.project.hana.model.Mkpf" resultType="com.huazheng.project.hana.model.Mkpf">
    	select * from Mkpf where mandt = #{mandt} and mblnr = #{mblnr} and mjahr = #{mjahr}
    </select>
    <insert id="insertMkpf" parameterType="com.huazheng.project.hana.model.Mkpf">
    	insert into Mkpf (mandt,mblnr,mjahr,bldat,cputm,hashResult) 
    	values(#{mandt},#{mblnr},#{mjahr},#{bldat},#{cputm},#{hashResult})
    </insert>
    <delete id="deleteMkpf" parameterType="com.huazheng.project.hana.model.Mkpf">
    	delete from Mkpf where mandt = #{mandt} and mblnr = #{mblnr} and mjahr = #{mjahr}
    </delete>
    <update id="updateMkpf" parameterType="com.huazheng.project.hana.model.Mkpf">
    	update Mkpf set
    		mandt = #{mandt}, mblnr = #{mblnr}, mjahr = #{mjahr}, bldat = #{bldat}, cputm = #{cputm}, hashResult = #{hashResult}
    	where mandt = #{mandt} and mblnr = #{mblnr} and mjahr = #{mjahr}
    </update>
    <select id="selectMkpfCheck" parameterType="com.huazheng.project.hana.model.Mkpf" resultType="com.huazheng.project.hana.model.Mkpf">
        select * from Mkpf where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectKonv" parameterType="com.huazheng.project.hana.model.Konv" resultType="com.huazheng.project.hana.model.Konv">
    	select * from Konv
    	where mandt = #{mandt} and knumv = #{knumv} and kposn = #{kposn} and stunr = #{stunr} and zaehk = #{zaehk}
    </select>
    <insert id="insertKonv" parameterType="com.huazheng.project.hana.model.Konv">
    	insert into Konv (mandt,knumv,kposn,stunr,zaehk,kntyp,kbetr, hashResult) 
    	values(#{mandt},#{knumv},#{kposn},#{stunr},#{zaehk},#{kntyp},#{kbetr}, #{hashResult})
    </insert>
    <delete id="deleteKonv" parameterType="com.huazheng.project.hana.model.Konv">
    	delete from Konv
    	where mandt = #{mandt} and knumv = #{knumv} and kposn = #{kposn} and stunr = #{stunr} and zaehk = #{zaehk}
    </delete>
    <update id="updateKonv" parameterType="com.huazheng.project.hana.model.Konv">
    	update Konv set
    		mandt = #{mandt},knumv = #{knumv},kposn = #{kposn},stunr = #{stunr},zaehk = #{zaehk},kntyp = #{kntyp},kbetr = #{kbetr},hashResult = #{hashResult}
    	where mandt = #{mandt} and knumv = #{knumv} and kposn = #{kposn} and stunr = #{stunr} and zaehk = #{zaehk}
    </update>
	<select id="selectKonvCheck" parameterType="com.huazheng.project.hana.model.Konv" resultType="com.huazheng.project.hana.model.Konv">
    	select * from Konv where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectLikp" parameterType="com.huazheng.project.hana.model.Likp" resultType="com.huazheng.project.hana.model.Likp">
    	select * from likp where vbeln = #{vbeln} and mandt = #{mandt}
    </select>
    <insert id="insertLikp" parameterType="com.huazheng.project.hana.model.Likp">
    	insert into likp (vbeln, mandt, erdat, wadat_ist , ctlpc, kunnr, erdat1, wadat_ist1, aedat,lfuhr, wadat_ist2lfuhr, hashResult) 
    	values(#{vbeln}, #{mandt}, #{erdat}, #{wadat_ist}, #{ctlpc}, #{kunnr}, #{erdat1}, #{wadat_ist1}, #{aedat},#{lfuhr}, #{wadat_ist2lfuhr}, #{hashResult})
    </insert>
    <delete id="deleteLikp" parameterType="com.huazheng.project.hana.model.Likp">
    	delete from likp where vbeln = #{vbeln} and mandt = #{mandt}
    </delete>
    <update id="updateLikp" parameterType="com.huazheng.project.hana.model.Likp">
    	update Likp set
    		vbeln = #{vbeln}, mandt = #{mandt}, erdat = #{erdat}, wadat_ist = #{wadat_ist}, ctlpc = #{ctlpc}, 
    		kunnr = #{kunnr}, erdat1 = #{erdat1}, wadat_ist1 = #{wadat_ist1}, aedat = #{aedat}, 
    		lfuhr = #{lfuhr}, wadat_ist2lfuhr = #{wadat_ist2lfuhr}, hashResult = #{hashResult}
    	where vbeln = #{vbeln} and mandt = #{mandt}
    </update>
	<select id="selectLikpCheck" parameterType="com.huazheng.project.hana.model.Likp" resultType="com.huazheng.project.hana.model.Likp">
    	select * from Likp where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    <select id="selectLikpCheckByUpdate" parameterType="com.huazheng.project.hana.model.Likp" resultType="com.huazheng.project.hana.model.Likp">
    	select * from Likp where aedat &gt;= #{aedat} order by rownum
    </select>
    
    <select id="selectLips" parameterType="com.huazheng.project.hana.model.Lips" resultType="com.huazheng.project.hana.model.Lips">
    	select * from lips where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </select>
    <insert id="insertLips" parameterType="com.huazheng.project.hana.model.Lips">
    	insert into lips (vbeln, posnr, vgbel, vgpos, mandt, matnr, matkl, arktx, werks, lgort, 
    		charg, lfimg, uebto, untto, erdat, erzet, erdat1, erdat2, aedat, hashResult) 
    	values(#{vbeln}, #{posnr}, #{vgbel}, #{vgpos}, #{mandt}, #{matnr}, #{matkl}, #{arktx}, #{werks}, #{lgort},
    		#{charg}, #{lfimg}, #{uebto}, #{untto}, #{erdat}, #{erzet}, #{erdat1}, #{erdat2}, #{aedat}, #{hashResult})
    </insert>
    <delete id="deleteLips" parameterType="com.huazheng.project.hana.model.Lips">
    	delete from lips where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </delete>
    <update id="updateLips" parameterType="com.huazheng.project.hana.model.Lips">
    	update Lips set
    		vbeln = #{vbeln}, posnr = #{posnr}, vgbel = #{vgbel}, vgpos = #{vgpos}, mandt = #{mandt}, matnr = #{matnr}, matkl = #{matkl}, arktx = #{arktx}, werks = #{werks}, lgort = #{lgort}, 
    		charg = #{charg}, lfimg = #{lfimg}, uebto = #{uebto}, untto = #{untto}, erdat = #{erdat}, erzet = #{erzet}, erdat1 = #{erdat1}, erdat2 = #{erdat2}, 
    		aedat = #{aedat}, hashResult = #{hashResult}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </update>
	<select id="selectLipsCheck" parameterType="com.huazheng.project.hana.model.Lips" resultType="com.huazheng.project.hana.model.Lips">
    	select * from Lips where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    <select id="selectLipsCheckByUpdate" parameterType="com.huazheng.project.hana.model.Lips" resultType="com.huazheng.project.hana.model.Lips">
    	select * from Lips where aedat &gt;= #{aedat} order by rownum
    </select>
    
    <select id="selectMakt" parameterType="com.huazheng.project.hana.model.Makt" resultType="com.huazheng.project.hana.model.Makt">
    	select * from makt where matnr = #{matnr} and mandt = #{mandt} and spras = #{spras}
    </select>
    <insert id="insertMakt" parameterType="com.huazheng.project.hana.model.Makt">
    	insert into makt (matnr, mandt, spras, maktx, maktxSize, hashResult) 
    	values(#{matnr}, #{mandt}, #{spras}, #{maktx}, #{maktxSize}, #{hashResult})
    </insert>
    <delete id="deleteMakt" parameterType="com.huazheng.project.hana.model.Makt">
    	delete from makt where matnr = #{matnr} and mandt = #{mandt} and spras = #{spras}
    </delete>
    <update id="updateMakt" parameterType="com.huazheng.project.hana.model.Makt">
    	update Makt set
			matnr = #{matnr}, mandt = #{mandt}, spras = #{spras}, maktx = #{maktx}, maktxSize = #{maktxSize}, hashResult = #{hashResult}
    	where matnr = #{matnr} and mandt = #{mandt} and spras = #{spras}
    </update>
	<select id="selectMaktCheck" parameterType="com.huazheng.project.hana.model.Makt" resultType="com.huazheng.project.hana.model.Makt">
    	select * from Makt where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectMara" parameterType="com.huazheng.project.hana.model.Mara" resultType="com.huazheng.project.hana.model.Mara">
    	select * from mara where matnr = #{matnr} and mandt = #{mandt}
    </select>
    <insert id="insertMara" parameterType="com.huazheng.project.hana.model.Mara">
    	insert into mara (matnr, mandt, ersda, ernam, laeda, aenam, vpsta, pstat, mtart, mbrsh, matkl, 
    		bismt, meins, bstme, wrkst, brgew, ntgew, gewei, spart, kzkfg, extwg, cuobf, hashResult) 
    	values(#{matnr}, #{mandt}, #{ersda}, #{ernam}, #{laeda}, #{aenam}, #{vpsta}, #{pstat}, #{mtart}, #{mbrsh}, #{matkl}, 
    		#{bismt}, #{meins}, #{bstme}, #{wrkst}, #{brgew}, #{ntgew}, #{gewei}, #{spart}, #{kzkfg}, #{extwg}, #{cuobf}, #{hashResult})
    </insert>
    <delete id="deleteMara" parameterType="com.huazheng.project.hana.model.Mara">
    	delete from mara where matnr = #{matnr} and mandt = #{mandt}
    </delete>
    <update id="updateMara" parameterType="com.huazheng.project.hana.model.Mara">
    	update Mara set
    		matnr = #{matnr}, mandt = #{mandt}, ersda = #{ersda}, ernam = #{ernam}, laeda = #{laeda}, aenam = #{aenam}, 
    		vpsta = #{vpsta}, pstat = #{pstat}, mtart = #{mtart}, mbrsh = #{mbrsh}, matkl = #{matkl}, bismt = #{bismt}, 
    		meins = #{meins}, bstme = #{bstme}, wrkst = #{wrkst}, brgew = #{brgew}, ntgew = #{ntgew}, gewei = #{gewei}, 
    		spart = #{spart}, kzkfg = #{kzkfg}, extwg = #{extwg}, cuobf = #{cuobf}, hashResult = #{hashResult}
    	where matnr = #{matnr} and mandt = #{mandt}
    </update>
	<select id="selectMaraCheck" parameterType="com.huazheng.project.hana.model.Mara" resultType="com.huazheng.project.hana.model.Mara">
    	select * from Mara where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
	<select id="selectMska" parameterType="com.huazheng.project.hana.model.Mska" resultType="com.huazheng.project.hana.model.Mska">
    	select * from mska 
    	where mandt = #{mandt} and matnr = #{matnr} and werks = #{werks} and lgort = #{lgort} 
			and charg = #{charg} and sobkz = #{sobkz} and vbeln = #{vbeln} and posnr = #{posnr}
    </select>
    <insert id="insertMska" parameterType="com.huazheng.project.hana.model.Mska">
    	insert into mska (vbeln, posnr, mandt, matnr, werks, lgort, charg, sobkz, kaspe, kalab, hashResult) 
    	values(#{vbeln}, #{posnr}, #{mandt}, #{matnr}, #{werks}, #{lgort}, #{charg}, #{sobkz}, #{kaspe}, #{kalab}, #{hashResult})
    </insert>
    <delete id="deleteMska" parameterType="com.huazheng.project.hana.model.Mska">
    	delete from mska 
    	where mandt = #{mandt} and matnr = #{matnr} and werks = #{werks} and lgort = #{lgort} 
			and charg = #{charg} and sobkz = #{sobkz} and vbeln = #{vbeln} and posnr = #{posnr}
    </delete>
    <update id="updateMska" parameterType="com.huazheng.project.hana.model.Mska">
    	update Mska set
			vbeln = #{vbeln}, posnr = #{posnr}, mandt = #{mandt}, matnr = #{matnr}, werks = #{werks}, lgort = #{lgort}, 
			charg = #{charg}, sobkz = #{sobkz}, kaspe = #{kaspe}, kalab = #{kalab}, hashResult = #{hashResult}
    	where mandt = #{mandt} and matnr = #{matnr} and werks = #{werks} and lgort = #{lgort} 
			and charg = #{charg} and sobkz = #{sobkz} and vbeln = #{vbeln} and posnr = #{posnr}
    </update>
	<select id="selectMskaCheck" parameterType="com.huazheng.project.hana.model.Mska" resultType="com.huazheng.project.hana.model.Mska">
    	select * from Mska where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectPa0002" parameterType="com.huazheng.project.hana.model.Pa0002" resultType="com.huazheng.project.hana.model.Pa0002">
    	select * from Pa0002
    	where mandt = #{mandt} and pernr = #{pernr} and subty = #{subty} and objps = #{objps}
			and sprps = #{sprps} and endda = #{endda} and begda = #{begda} and seqnr = #{seqnr}
    </select>
    <insert id="insertPa0002" parameterType="com.huazheng.project.hana.model.Pa0002">
    	insert into Pa0002 (mandt,pernr,subty,objps,sprps,endda,begda,seqnr,nachn,vorna, endda1, yeWuYMC,aedtm, hashResult) 
    	values(#{mandt},#{pernr},#{subty},#{objps},#{sprps},#{endda},#{begda},#{seqnr},#{nachn},#{vorna},#{endda1},#{yeWuYMC},#{aedtm}, #{hashResult})
    </insert>
    <delete id="deletePa0002" parameterType="com.huazheng.project.hana.model.Pa0002">
    	delete from Pa0002
    	where mandt = #{mandt} and pernr = #{pernr} and subty = #{subty} and objps = #{objps}
			and sprps = #{sprps} and endda = #{endda} and begda = #{begda} and seqnr = #{seqnr}
    </delete>
    <update id="updatePa0002" parameterType="com.huazheng.project.hana.model.Pa0002">
    	update Pa0002 set
			mandt = #{mandt},pernr = #{pernr},subty = #{subty},objps = #{objps},sprps = #{sprps},endda = #{endda},begda = #{begda},
			seqnr = #{seqnr},nachn = #{nachn},vorna = #{vorna}, endda1 = #{endda1}, yeWuYMC = #{yeWuYMC},aedtm=#{aedtm}, hashResult = #{hashResult}
    	where mandt = #{mandt} and pernr = #{pernr} and subty = #{subty} and objps = #{objps}
			and sprps = #{sprps} and endda = #{endda} and begda = #{begda} and seqnr = #{seqnr}
    </update>
	<select id="selectPa0002Check" parameterType="com.huazheng.project.hana.model.Pa0002" resultType="com.huazheng.project.hana.model.Pa0002">
    	select * from Pa0002 where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    <select id="selectPa0002CheckByUpdate" parameterType="com.huazheng.project.hana.model.Pa0002" resultType="com.huazheng.project.hana.model.Pa0002">
    	select * from Pa0002 where aedtm &gt;= #{aedtm} order by rownum
    </select>
    
    <select id="selectS066" parameterType="com.huazheng.project.hana.model.S066" resultType="com.huazheng.project.hana.model.S066">
    	select * from S066
    	where mandt = #{mandt} and ssour = #{ssour} and vrsio = #{vrsio} and kkber = #{kkber} and
			knkli = #{knkli} and spmons = #{spmons} and sptags = #{sptags} and spwocs = #{spwocs} and spbups = #{spbups}
    </select>
    <insert id="insertS066" parameterType="com.huazheng.project.hana.model.S066">
    	insert into s066 (mandt, ssour, vrsio, kkber, knkli, spmon, sptag, spwoc, spbup, oeikw
    	,sptags, spwocs, spbups, spmons, hashResult) 
    	values(#{mandt}, #{ssour}, #{vrsio}, #{kkber}, #{knkli}, #{spmon}, #{sptag}, #{spwoc}, #{spbup}, #{oeikw}
    	,#{sptags}, #{spwocs}, #{spbups}, #{spmons}, #{hashResult})
    </insert>
	<delete id="deleteS066" parameterType="com.huazheng.project.hana.model.S066">
    	delete from S066
    	where mandt = #{mandt} and ssour = #{ssour} and vrsio = #{vrsio} and kkber = #{kkber} and
			knkli = #{knkli} and spmons = #{spmons} and sptags = #{sptags} and spwocs = #{spwocs} and spbups = #{spbups}
    </delete>
    <update id="updateS066" parameterType="com.huazheng.project.hana.model.S066">
    	update S066 set
			mandt = #{mandt}, ssour = #{ssour}, vrsio = #{vrsio}, kkber = #{kkber}, knkli = #{knkli}, spmon = #{spmon}, 
			sptag = #{sptag}, spwoc = #{spwoc}, spbup = #{spbup}, oeikw = #{oeikw}
			,sptags = #{sptags}, spwocs = #{spwocs}, spbups = #{spbups}, spmons = #{spmons}, hashResult = #{hashResult}
    	where mandt = #{mandt} and ssour = #{ssour} and vrsio = #{vrsio} and kkber = #{kkber} and
			knkli = #{knkli} and spmons = #{spmons} and sptags = #{sptags} and spwocs = #{spwocs} and spbups = #{spbups}
    </update>
	<select id="selectS066Check" parameterType="com.huazheng.project.hana.model.S066" resultType="com.huazheng.project.hana.model.S066">
    	select * from S066 where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectS067" parameterType="com.huazheng.project.hana.model.S067" resultType="com.huazheng.project.hana.model.S067">
    	select * from S067
    	where mandt = #{mandt} and ssour = #{ssour} and vrsio = #{vrsio} and kkber = #{kkber} and
			knkli = #{knkli} and spmons = #{spmons} and sptags = #{sptags} and spwocs = #{spwocs} and spbups = #{spbups}
    </select>
    <insert id="insertS067" parameterType="com.huazheng.project.hana.model.S067">
    	insert into s067 (mandt, ssour, vrsio, kkber, knkli, spmon, sptag, spwoc, spbup, olikw, ofakw
    	,sptags, spwocs, spbups, spmons, hashResult) 
    	values(#{mandt}, #{ssour}, #{vrsio}, #{kkber}, #{knkli}, #{spmon}, #{sptag}, #{spwoc}, #{spbup}, #{olikw}, #{ofakw}
    	,#{sptags}, #{spwocs}, #{spbups}, #{spmons}, #{hashResult})
    </insert>
    <delete id="deleteS067" parameterType="com.huazheng.project.hana.model.S067">
    	delete from S067
    	where mandt = #{mandt} and ssour = #{ssour} and vrsio = #{vrsio} and kkber = #{kkber} and
			knkli = #{knkli} and spmons = #{spmons} and sptags = #{sptags} and spwocs = #{spwocs} and spbups = #{spbups}
    </delete>
    <update id="updateS067" parameterType="com.huazheng.project.hana.model.S067">
    	update S067 set
			mandt = #{mandt}, ssour = #{ssour}, vrsio = #{vrsio}, kkber = #{kkber}, knkli = #{knkli}, spmon = #{spmon}, 
			sptag = #{sptag}, spwoc = #{spwoc}, spbup = #{spbup}, olikw = #{olikw}, ofakw = #{ofakw}
			,sptags = #{sptags}, spwocs = #{spwocs}, spbups = #{spbups}, spmons = #{spmons}, hashResult = #{hashResult}
    	where mandt = #{mandt} and ssour = #{ssour} and vrsio = #{vrsio} and kkber = #{kkber} and
			knkli = #{knkli} and spmons = #{spmons} and sptags = #{sptags} and spwocs = #{spwocs} and spbups = #{spbups}
    </update>
	<select id="selectS067Check" parameterType="com.huazheng.project.hana.model.S067" resultType="com.huazheng.project.hana.model.S067">
    	select * from S067 where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectT001w" parameterType="com.huazheng.project.hana.model.T001w" resultType="com.huazheng.project.hana.model.T001w">
    	select * from T001w where werks = #{werks} and mandt = #{mandt}
    </select>
    <insert id="insertT001w" parameterType="com.huazheng.project.hana.model.T001w">
    	insert into T001w (mandt, werks, name1, bwkey, hashResult) 
    	values(#{mandt},#{werks},#{name1},#{bwkey}, #{hashResult})
    </insert>
    <delete id="deleteT001w" parameterType="com.huazheng.project.hana.model.T001w">
    	delete from T001w where werks = #{werks} and mandt = #{mandt}
    </delete>
    <update id="updateT001w" parameterType="com.huazheng.project.hana.model.T001w">
    	update T001w set
			mandt = #{mandt}, werks = #{werks}, name1 = #{name1}, bwkey = #{bwkey}, hashResult = #{hashResult}
    	where werks = #{werks} and mandt = #{mandt}
    </update>
	<select id="selectT001wCheck" parameterType="com.huazheng.project.hana.model.T001w" resultType="com.huazheng.project.hana.model.T001w">
    	select * from T001w where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
	<select id="selectT023t" parameterType="com.huazheng.project.hana.model.T023t" resultType="com.huazheng.project.hana.model.T023t">
    	select * from T023t where mandt = #{mandt} and spras = #{spras} and matkl = #{matkl}
    </select>
    <insert id="insertT023t" parameterType="com.huazheng.project.hana.model.T023t">
    	insert into T023t (mandt,spras,matkl,wgbez,wgbez60, hashResult) 
    	values(#{mandt},#{spras},#{matkl},#{wgbez},#{wgbez60}, #{hashResult})
    </insert>
	<delete id="deleteT023t" parameterType="com.huazheng.project.hana.model.T023t">
    	delete from T023t where mandt = #{mandt} and spras = #{spras} and matkl = #{matkl}
    </delete>
    <update id="updateT023t" parameterType="com.huazheng.project.hana.model.T023t">
    	update T023t set
			mandt = #{mandt},spras = #{spras},matkl = #{matkl},wgbez = #{wgbez},wgbez60 = #{wgbez60}, hashResult = #{hashResult}
    	where mandt = #{mandt} and spras = #{spras} and matkl = #{matkl}
    </update>
	<select id="selectT023tCheck" parameterType="com.huazheng.project.hana.model.T023t" resultType="com.huazheng.project.hana.model.T023t">
    	select * from T023t where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectVbak" parameterType="com.huazheng.project.hana.model.Vbak" resultType="com.huazheng.project.hana.model.Vbak">
    	select * from vbak where vbeln = #{vbeln} and mandt = #{mandt}
    </select>
    <insert id="insertVbak" parameterType="com.huazheng.project.hana.model.Vbak">
    	insert into vbak (vbeln, mandt, vbtyp, audat, waerk, kalsm, ctlpc, kunnr, bukrs_vf, bstnk, 
    		bname, telf1, netwr, vkbur, audat1, knumv, vkorg, vtweg, kkber, auart, aedat, pernr, 
    		erdat2erzet, erdat, erzet, spart, hashResult) 
    	values(#{vbeln}, #{mandt}, #{vbtyp}, #{audat}, #{waerk}, #{kalsm}, #{ctlpc}, #{kunnr}, #{bukrs_vf}, #{bstnk},
    		#{bname}, #{telf1}, #{netwr}, #{vkbur}, #{audat1}, #{knumv}, #{vkorg}, #{vtweg}, #{kkber}, #{auart}, #{aedat}, #{pernr}, 
    		#{erdat2erzet}, #{erdat}, #{erzet}, #{erzet}, #{hashResult})
    </insert>
    <delete id="deleteVbak" parameterType="com.huazheng.project.hana.model.Vbak">
    	delete from vbak where vbeln = #{vbeln} and mandt = #{mandt}
    </delete>
    <update id="updateVbak" parameterType="com.huazheng.project.hana.model.Vbak">
    	update vbak set 
			vbeln = #{vbeln}, mandt = #{mandt}, vbtyp = #{vbtyp}, audat = #{audat}, 
			waerk = #{waerk}, kalsm = #{kalsm}, ctlpc = #{ctlpc}, kunnr = #{kunnr}, 
			bukrs_vf = #{bukrs_vf}, bstnk = #{bstnk}, bname = #{bname}, 
			telf1 = #{telf1}, netwr = #{netwr}, vkbur = #{vkbur}, audat1 = #{audat1}, 
			knumv = #{knumv}, vkorg = #{vkorg}, vtweg = #{vtweg}, kkber = #{kkber}, 
			auart = #{auart}, aedat = #{aedat}, pernr = #{pernr}, 
			erdat2erzet = #{erdat2erzet}, erdat = #{erdat}, erzet = #{erzet}, spart = #{spart}, hashResult = #{hashResult}
    	where vbeln = #{vbeln} and mandt = #{mandt}
    </update>
	<select id="selectVbakCheck" parameterType="com.huazheng.project.hana.model.Vbak" resultType="com.huazheng.project.hana.model.Vbak">
    	select * from Vbak where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    <select id="selectVbakCheckByUpdate" parameterType="com.huazheng.project.hana.model.Vbak" resultType="com.huazheng.project.hana.model.Vbak">
    	select * from Vbak where aedat &gt;= #{aedat} order by rownum
    </select>
    
    <select id="selectVbep" parameterType="com.huazheng.project.hana.model.Vbep" resultType="com.huazheng.project.hana.model.Vbep">
    	select * from vbep 
    	where vbeln = #{vbeln} and posnr = #{posnr} and etenr = #{etenr} and mandt = #{mandt}
    </select>
    <insert id="insertVbep" parameterType="com.huazheng.project.hana.model.Vbep">
    	insert into vbep (vbeln, posnr, edatu, ettyp, wmeng, bmeng, edatu1, mandt, etenr, aufnr, hashResult) 
    	values(#{vbeln}, #{posnr}, #{edatu}, #{ettyp}, #{wmeng}, #{bmeng}, #{edatu1}, #{mandt}, #{etenr}, #{aufnr}, #{hashResult})
    </insert>
    <delete id="deleteVbep" parameterType="com.huazheng.project.hana.model.Vbep">
    	delete from vbep 
    	where vbeln = #{vbeln} and posnr = #{posnr} and etenr = #{etenr} and mandt = #{mandt}
    </delete>
    <update id="updateVbep" parameterType="com.huazheng.project.hana.model.Vbep">
    	update Vbep set 
			vbeln = #{vbeln}, posnr = #{posnr}, edatu = #{edatu}, ettyp = #{ettyp}, wmeng = #{wmeng}, 
			bmeng = #{bmeng}, edatu1 = #{edatu1}, mandt = #{mandt}, etenr = #{etenr}, aufnr = #{aufnr}, hashResult = #{hashResult}
    	where vbeln = #{vbeln} and posnr = #{posnr} and etenr = #{etenr} and mandt = #{mandt}
    </update>
	<select id="selectVbepCheck" parameterType="com.huazheng.project.hana.model.Vbep" resultType="com.huazheng.project.hana.model.Vbep">
    	select * from Vbep where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectVbpa" parameterType="com.huazheng.project.hana.model.Vbpa" resultType="com.huazheng.project.hana.model.Vbpa">
    	select * from Vbpa
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and parvw = #{parvw}
    </select>
    <insert id="insertVbpa" parameterType="com.huazheng.project.hana.model.Vbpa">
    	insert into Vbpa (mandt, vbeln, posnr, parvw, pernr, hashResult) 
    	values(#{mandt},#{vbeln},#{posnr},#{parvw},#{pernr}, #{hashResult})
    </insert>
    <delete id="deleteVbpa" parameterType="com.huazheng.project.hana.model.Vbpa">
    	delete from Vbpa
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and parvw = #{parvw}
    </delete>
    <update id="updateVbpa" parameterType="com.huazheng.project.hana.model.Vbpa">
    	update Vbpa set 
			mandt = #{mandt}, vbeln = #{vbeln}, posnr = #{posnr}, 
			parvw = #{parvw}, pernr = #{pernr}, hashResult = #{hashResult}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and parvw = #{parvw}
    </update>
	<select id="selectVbpaCheck" parameterType="com.huazheng.project.hana.model.Vbpa" resultType="com.huazheng.project.hana.model.Vbpa">
    	select * from Vbpa where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
	<select id="selectVbrk" parameterType="com.huazheng.project.hana.model.Vbrk" resultType="com.huazheng.project.hana.model.Vbrk">
    	select * from Vbrk where vbeln = #{vbeln} and mandt = #{mandt} 
    </select>
    <insert id="insertVbrk" parameterType="com.huazheng.project.hana.model.Vbrk">
    	insert into Vbrk (vbeln,fkart,waerk,erdat,erzet,zterm,kunrg,bstnk_vf,
			zbillty,zbz01,zbz02,zdc_flg,bukrs,ktgrd,fkdat,inco1,
			inco2,netwr,mwsbk,aedat,mandt,hashResult) 
    	values(#{vbeln}, #{fkart}, #{waerk}, #{erdat}, #{erzet}, #{zterm}, #{kunrg}, #{bstnk_vf}, 
    	#{zbillty}, #{zbz01}, #{zbz02}, #{zdc_flg}, #{bukrs}, #{ktgrd}, #{fkdat}, #{inco1}, 
    	#{inco2}, #{netwr}, #{mwsbk}, #{aedat}, #{mandt}, #{hashResult})
    </insert>
	<delete id="deleteVbrk" parameterType="com.huazheng.project.hana.model.Vbrk">
    	delete from Vbrk where vbeln = #{vbeln} and mandt = #{mandt} 
    </delete>
    <update id="updateVbrk" parameterType="com.huazheng.project.hana.model.Vbrk">
    	update Vbrk set 
			vbeln=#{vbeln},fkart=#{fkart},waerk=#{waerk},erdat=#{erdat},erzet=#{erzet},zterm=#{zterm},kunrg=#{kunrg},bstnk_vf=#{bstnk_vf},
			zbillty=#{zbillty},zbz01=#{zbz01},zbz02=#{zbz02},zdc_flg=#{zdc_flg},bukrs=#{bukrs},ktgrd=#{ktgrd},fkdat=#{fkdat},inco1=#{inco1},
			inco2=#{inco2},netwr=#{netwr},mwsbk=#{mwsbk},aedat=#{aedat},mandt=#{mandt}, hashResult=#{hashResult}
    	where vbeln = #{vbeln} and mandt = #{mandt} 
    </update>
	<select id="selectVbrkCheck" parameterType="com.huazheng.project.hana.model.Vbrk" resultType="com.huazheng.project.hana.model.Vbrk">
    	select * from Vbrk where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    <select id="selectVbrkCheckByUpdate" parameterType="com.huazheng.project.hana.model.Vbrk" resultType="com.huazheng.project.hana.model.Vbrk">
    	select * from Vbrk where aedat &gt;= #{aedat} order by rownum
    </select>
    
	<select id="selectVbrp" parameterType="com.huazheng.project.hana.model.Vbrp" resultType="com.huazheng.project.hana.model.Vbrp">
    	select * from Vbrp
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} 
    </select>
    <insert id="insertVbrp" parameterType="com.huazheng.project.hana.model.Vbrp">
    	insert into Vbrp (vbeln,posnr,fkimg,meins,vgbel,vgpos,aubel,aupos,matnr,
			arktx,matkl,spart,zarktx_js,zfkimg_js,zvrkme_js,mandt,netwr,mwsbp, hashResult) 
    	values(#{vbeln}, #{posnr}, #{fkimg}, #{meins}, #{vgbel}, #{vgpos}, #{aubel}, #{aupos}, #{matnr}, 
    	#{arktx}, #{matkl}, #{spart}, #{zarktx_js}, #{zfkimg_js}, #{zvrkme_js}, #{mandt}, #{netwr}, #{mwsbp}, #{hashResult})
    </insert>
	<delete id="deleteVbrp" parameterType="com.huazheng.project.hana.model.Vbrp">
    	delete from Vbrp
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} 
    </delete>
    <update id="updateVbrp" parameterType="com.huazheng.project.hana.model.Vbrp">
    	update Vbrp set 
			vbeln=#{vbeln},posnr=#{posnr},fkimg=#{fkimg},meins=#{meins},vgbel=#{vgbel},vgpos=#{vgpos},
			aubel=#{aubel},aupos=#{aupos},matnr=#{matnr},arktx=#{arktx},matkl=#{matkl},spart=#{spart},
			zarktx_js=#{zarktx_js},zfkimg_js=#{zfkimg_js},zvrkme_js=#{zvrkme_js},mandt=#{mandt},
			netwr=#{netwr},mwsbp=#{mwsbp},hashResult=#{hashResult}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} 
    </update>
	<select id="selectVbrpCheck" parameterType="com.huazheng.project.hana.model.Vbrp" resultType="com.huazheng.project.hana.model.Vbrp">
    	select * from Vbrp where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
	<select id="selectVbuk" parameterType="com.huazheng.project.hana.model.Vbuk" resultType="com.huazheng.project.hana.model.Vbuk">
    	select * from Vbuk where vbeln = #{vbeln} and mandt = #{mandt} 
    </select>
    <insert id="insertVbuk" parameterType="com.huazheng.project.hana.model.Vbuk">
    	insert into Vbuk (vbeln, wbstk, kostk, mandt, hashResult) 
    	values(#{vbeln}, #{wbstk}, #{kostk}, #{mandt}, #{hashResult})
    </insert>
	<delete id="deleteVbuk" parameterType="com.huazheng.project.hana.model.Vbuk">
    	delete from Vbuk where vbeln = #{vbeln} and mandt = #{mandt}
    </delete>
    <update id="updateVbuk" parameterType="com.huazheng.project.hana.model.Vbuk">
    	update Vbuk set 
    		vbeln = #{vbeln}, wbstk = #{wbstk}, kostk = #{kostk}, mandt = #{mandt}, hashResult = #{hashResult}
    	where vbeln = #{vbeln} and mandt = #{mandt}
    </update>
	<select id="selectVbukCheck" parameterType="com.huazheng.project.hana.model.Vbuk" resultType="com.huazheng.project.hana.model.Vbuk">
    	select * from Vbuk where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
	<select id="selectZmdpc" parameterType="com.huazheng.project.hana.model.Zmdpc" resultType="com.huazheng.project.hana.model.Zmdpc">
    	select * from Zmdpc
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </select>
    <insert id="insertZmdpc" parameterType="com.huazheng.project.hana.model.Zmdpc">
    	insert into Zmdpc (vbeln,posnr,f_plant,plant,x_plant,mandt,hashResult) 
    	values(#{vbeln},#{posnr},#{f_plant},#{plant},#{x_plant},#{mandt},#{hashResult})
    </insert>
	<delete id="deleteZmdpc" parameterType="com.huazheng.project.hana.model.Zmdpc">
    	delete from Zmdpc
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </delete>
    <update id="updateZmdpc" parameterType="com.huazheng.project.hana.model.Zmdpc">
    	update Zmdpc set 
    		vbeln=#{vbeln},posnr=#{posnr},f_plant=#{f_plant},plant=#{plant},
    		x_plant=#{x_plant},mandt=#{mandt},hashResult=#{hashResult}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </update>
	<select id="selectZmdpcCheck" parameterType="com.huazheng.project.hana.model.Zmdpc" resultType="com.huazheng.project.hana.model.Zmdpc">
    	select * from Zmdpc where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectZsd06" parameterType="com.huazheng.project.hana.model.Zsd06" resultType="com.huazheng.project.hana.model.Zsd06">
    	select * from zsd06 
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </select>
    <insert id="insertZsd06" parameterType="com.huazheng.project.hana.model.Zsd06">
    	insert into zsd06 (vbeln, posnr, mandt, datum, uname, crt_uname, crt_datum, 
    	crt_time, cha_name, cha_datum, cha_time, datum1, crt_datum1, cha_datum1,hashResult) 
    	values(#{vbeln}, #{posnr}, #{mandt}, #{datum}, #{uname}, #{crt_uname}, #{crt_datum},
    	#{crt_time}, #{cha_name}, #{cha_datum}, #{cha_time}, #{datum1}, #{crt_datum1}, #{cha_datum1},#{hashResult})
    </insert>
    <delete id="deleteZsd06" parameterType="com.huazheng.project.hana.model.Zsd06">
    	delete from zsd06 
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </delete>
    <update id="updateZsd06" parameterType="com.huazheng.project.hana.model.Zsd06">
    	update Zsd06 set 
    		vbeln=#{vbeln}, posnr=#{posnr}, mandt=#{mandt}, datum=#{datum}, uname=#{uname}, crt_uname=#{crt_uname}, crt_datum=#{crt_datum}, 
    		crt_time=#{crt_time}, cha_name=#{cha_name}, cha_datum=#{cha_datum}, cha_time=#{cha_time}, datum1=#{datum1}, crt_datum1=#{crt_datum1}, 
    		cha_datum1=#{cha_datum1},hashResult=#{hashResult}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </update>
	<select id="selectZsd06Check" parameterType="com.huazheng.project.hana.model.Zsd06" resultType="com.huazheng.project.hana.model.Zsd06">
    	select * from Zsd06 where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    <select id="selectZsd06CheckByUpdate" parameterType="com.huazheng.project.hana.model.Zsd06" resultType="com.huazheng.project.hana.model.Zsd06">
    	select * from Zsd06 where cha_datum &gt;= #{cha_datum} order by rownum
    </select>
    
    <select id="selectZsdfhzl" parameterType="com.huazheng.project.hana.model.Zsdfhzl" resultType="com.huazheng.project.hana.model.Zsdfhzl">
    	select * from Zsdfhzl 
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </select>
    <insert id="insertZsdfhzl" parameterType="com.huazheng.project.hana.model.Zsdfhzl">
    	insert into Zsdfhzl (vbeln, posnr, mandt, vgbel, vgpos, uname, matnr, 
    	fmenge, cdate, ctime, fh_date, werks, cdate1, fh_date1,cha_datum,hashResult) 
    	values(#{vbeln}, #{posnr}, #{mandt}, #{vgbel}, #{vgpos}, #{uname}, #{matnr}, 
    	#{fmenge}, #{cdate}, #{ctime}, #{fh_date}, #{werks}, #{cdate1}, #{fh_date1},#{cha_datum},#{hashResult})
    </insert>
    <delete id="deleteZsdfhzl" parameterType="com.huazheng.project.hana.model.Zsdfhzl">
    	delete from Zsdfhzl 
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </delete>
    <update id="updateZsdfhzl" parameterType="com.huazheng.project.hana.model.Zsdfhzl">
    	update Zsdfhzl set 
    		vbeln=#{vbeln}, posnr=#{posnr}, mandt=#{mandt}, vgbel=#{vgbel}, vgpos=#{vgpos}, uname=#{uname}, matnr=#{matnr}, 
    		fmenge=#{fmenge}, cdate=#{cdate}, ctime=#{ctime}, fh_date=#{fh_date}, werks=#{werks}, cdate1=#{cdate1}, 
    		fh_date1=#{fh_date1},cha_datum=#{cha_datum},hashResult=#{hashResult}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </update>
	<select id="selectZsdfhzlCheck" parameterType="com.huazheng.project.hana.model.Zsdfhzl" resultType="com.huazheng.project.hana.model.Zsdfhzl">
    	select * from Zsdfhzl where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    <select id="selectZsdfhzlCheckByUpdate" parameterType="com.huazheng.project.hana.model.Zsdfhzl" resultType="com.huazheng.project.hana.model.Zsdfhzl">
    	select * from Zsdfhzl where cha_datum &gt;= #{cha_datum} order by rownum
    </select>
    
	<select id="selectBsad" parameterType="com.huazheng.project.hana.model.Bsad" resultType="com.huazheng.project.hana.model.Bsad">
    	select * from Bsad
    	where mandt = #{mandt}
			and bukrs = #{bukrs} and kunnr = #{kunnr} and umsks = #{umsks} and umskz = #{umskz} 
			and augdt = #{augdt} and augbl = #{augbl} and zuonr = #{zuonr} and gjahr = #{gjahr} 
			and belnr = #{belnr} and buzei = #{buzei} 
    </select>
    <insert id="insertBsad" parameterType="com.huazheng.project.hana.model.Bsad">
    	insert into Bsad (vbeln,mandt,bukrs,kunnr,umsks,umskz,augdt,augbl,zuonr,gjahr,belnr,
    	buzei,blart,waers,wrbtr,shkzg,budat,budatc,zfbdt,dqsjc,zterm,budatd,augdts,buzeis,hashResult) 
    	values(#{vbeln},#{mandt},#{bukrs},#{kunnr},#{umsks},#{umskz},#{augdt},#{augbl},#{zuonr},#{gjahr},#{belnr},
    	#{buzei},#{blart},#{waers},#{wrbtr},#{shkzg},#{budat},#{budatc},#{zfbdt},#{dqsjc},#{zterm},#{budatd},#{augdts},#{buzeis},#{hashResult})
    </insert>
    <delete id="deleteBsad" parameterType="com.huazheng.project.hana.model.Bsad">
    	delete from Bsad 
    	where mandt = #{mandt}
			and bukrs = #{bukrs} and kunnr = #{kunnr} and umsks = #{umsks} and umskz = #{umskz} 
			and augdt = #{augdt} and augbl = #{augbl} and zuonr = #{zuonr} and gjahr = #{gjahr} 
			and belnr = #{belnr} and buzei = #{buzei} 
    </delete>
	<update id="updateBsad" parameterType="com.huazheng.project.hana.model.Bsad">
    	update Bsad set
    		vbeln = #{vbeln},mandt = #{mandt},bukrs = #{bukrs},kunnr = #{kunnr},umsks = #{umsks},umskz = #{umskz},augdt = #{augdt},
    		augbl = #{augbl},zuonr = #{zuonr},gjahr = #{gjahr},belnr = #{belnr},buzei = #{buzei},blart = #{blart},waers = #{waers},
    		wrbtr = #{wrbtr},shkzg = #{shkzg},budat = #{budat},budatc = #{budatc},zfbdt = #{zfbdt},dqsjc = #{dqsjc},zterm = #{zterm},budatd = #{budatd},
    		augdts=#{augdts},buzeis=#{buzeis},hashResult = #{hashResult}
    	where mandt = #{mandt}
			and bukrs = #{bukrs} and kunnr = #{kunnr} and umsks = #{umsks} and umskz = #{umskz} 
			and augdt = #{augdt} and augbl = #{augbl} and zuonr = #{zuonr} and gjahr = #{gjahr} 
			and belnr = #{belnr} and buzei = #{buzei}
    </update>
	<select id="selectBsadCheck" parameterType="com.huazheng.project.hana.model.Bsad" resultType="com.huazheng.project.hana.model.Bsad">
    	select * from Bsad where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    
    
    
    
    
    
    
    
    
    
    <select id="selectBsid" parameterType="com.huazheng.project.hana.model.Bsid" resultType="com.huazheng.project.hana.model.Bsid">
    	select * from Bsid
    	where mandt = #{mandt}
			and bukrs = #{bukrs} and kunnr = #{kunnr} and umsks = #{umsks} and umskz = #{umskz} 
			and augdt = #{augdt} and augbl = #{augbl} and zuonr = #{zuonr} and gjahr = #{gjahr} 
			and belnr = #{belnr} and buzei = #{buzei}
    </select>
    <insert id="insertBsid" parameterType="com.huazheng.project.hana.model.Bsid">
    	insert into Bsid (vbeln,mandt,bukrs,kunnr,umsks,umskz,augdt,augbl,zuonr,gjahr,belnr,
    	buzei,blart,waers,wrbtr,shkzg,budat,budatc,zfbdt,dqsjc,zterm,budatd,augdts,buzeis,hashResult) 
    	values(#{vbeln},#{mandt},#{bukrs},#{kunnr},#{umsks},#{umskz},#{augdt},#{augbl},#{zuonr},#{gjahr},#{belnr},
    	#{buzei},#{blart},#{waers},#{wrbtr},#{shkzg},#{budat},#{budatc},#{zfbdt},#{dqsjc},#{zterm},#{budatd},#{augdts},#{buzeis},#{hashResult})
    </insert>
    <delete id="deleteBsid" parameterType="com.huazheng.project.hana.model.Bsid">
    	delete from Bsid 
    	where mandt = #{mandt}
			and bukrs = #{bukrs} and kunnr = #{kunnr} and umsks = #{umsks} and umskz = #{umskz} 
			and augdt = #{augdt} and augbl = #{augbl} and zuonr = #{zuonr} and gjahr = #{gjahr} 
			and belnr = #{belnr} and buzei = #{buzei}
    </delete>
	<update id="updateBsid" parameterType="com.huazheng.project.hana.model.Bsid">
    	update Bsid set
    		vbeln = #{vbeln},mandt = #{mandt},bukrs = #{bukrs},kunnr = #{kunnr},umsks = #{umsks},umskz = #{umskz},augdt = #{augdt},
    		augbl = #{augbl},zuonr = #{zuonr},gjahr = #{gjahr},belnr = #{belnr},buzei = #{buzei},blart = #{blart},waers = #{waers},
    		wrbtr = #{wrbtr},shkzg = #{shkzg},budat = #{budat},budatc = #{budatc},zfbdt = #{zfbdt},dqsjc = #{dqsjc},zterm = #{zterm},budatd = #{budatd},
    		augdts=#{augdts},buzeis=#{buzeis},hashResult = #{hashResult}
    	where mandt = #{mandt}
			and bukrs = #{bukrs} and kunnr = #{kunnr} and umsks = #{umsks} and umskz = #{umskz} 
			and augdt = #{augdt} and augbl = #{augbl} and zuonr = #{zuonr} and gjahr = #{gjahr} 
			and belnr = #{belnr} and buzei = #{buzei}
    </update>
	<select id="selectBsidCheck" parameterType="com.huazheng.project.hana.model.Bsid" resultType="com.huazheng.project.hana.model.Bsid">
    	select * from Bsid where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    <select id="selectTvkbt" parameterType="com.huazheng.project.hana.model.Tvkbt" resultType="com.huazheng.project.hana.model.Tvkbt">
    	select * from Tvkbt
    	where mandt = #{mandt} and spras = #{spras} and vkbur = #{vkbur}
    </select>
    <insert id="insertTvkbt" parameterType="com.huazheng.project.hana.model.Tvkbt">
    	insert into Tvkbt (mandt, spras, vkbur, bezei, hashResult) 
    	values(#{mandt},#{spras},#{vkbur},#{bezei},#{hashResult})
    </insert>
    <delete id="deleteTvkbt" parameterType="com.huazheng.project.hana.model.Tvkbt">
    	delete from Tvkbt 
    	where mandt = #{mandt} and spras = #{spras} and vkbur = #{vkbur}
    </delete>
	<update id="updateTvkbt" parameterType="com.huazheng.project.hana.model.Tvkbt">
    	update Tvkbt set
    		mandt = #{mandt},spras = #{spras},vkbur = #{vkbur},bezei = #{bezei},hashResult = #{hashResult}
    	where mandt = #{mandt} and spras = #{spras} and vkbur = #{vkbur}
    </update>
	<select id="selectTvkbtCheck" parameterType="com.huazheng.project.hana.model.Tvkbt" resultType="com.huazheng.project.hana.model.Tvkbt">
    	select * from Tvkbt where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    
    
    
    
    
    
    
    
    
    
    
    
    
	<select id="selectVbap" parameterType="com.huazheng.project.hana.model.Vbap" resultType="com.huazheng.project.hana.model.Vbap">
    	select * from vbap 
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </select>
    <insert id="insertVbap" parameterType="com.huazheng.project.hana.model.Vbap">
    	insert into vbap (
			vbeln, posnr, matnr, mandt, matkl, spart, kwmeng, netwr, mwsbp, waerk, vrkme, abgru, 
    		uebto, untto, werks, vstel, mvgr1, plavo, mvgr4, mvgr5, ulxh, zma_ftb_02, zma_ftb_03, 
    		zma_ftb_45, zma_ftb_06, zma_ftb_07, zma_ftb_08, zma_jyb_02, zma_jyb_03, zma_jyb_45, 
    		zma_jyb_06, zma_jyb_07, zma_ljb_03, zma_ljb_04, zma_ljb_06, zma_ljb_07, zma_ljb_08, 
    		zma_ljb_11, zma_ljb_12, zma_ljb_13, zma_yhbg_02, zma_yhbg_04, zma_yhbg_05, zma_yhbg_06, 
    		tbpz, ws, cu_maktx, cu_pcdst, ztype, barcode, gdno, lh, dgxx, zklx, erdat, erzet, 
    		erdat1, erdat2, netpr,aedat,pernr, hashResult
		) 
    	values(
    		#{vbeln}, #{posnr}, #{matnr}, #{mandt}, #{matkl}, #{spart}, #{kwmeng}, #{netwr}, #{mwsbp}, #{waerk}, #{vrkme}, #{abgru},
    		#{uebto}, #{untto}, #{werks}, #{vstel}, #{mvgr1}, #{plavo}, #{mvgr4}, #{mvgr5}, #{ulxh}, #{zma_ftb_02}, #{zma_ftb_03},
    		#{zma_ftb_45}, #{zma_ftb_06}, #{zma_ftb_07}, #{zma_ftb_08}, #{zma_jyb_02}, #{zma_jyb_03}, #{zma_jyb_45},
    		#{zma_jyb_06}, #{zma_jyb_07}, #{zma_ljb_03}, #{zma_ljb_04}, #{zma_ljb_06}, #{zma_ljb_07}, #{zma_ljb_08},
    		#{zma_ljb_11}, #{zma_ljb_12}, #{zma_ljb_13}, #{zma_yhbg_02}, #{zma_yhbg_04}, #{zma_yhbg_05}, #{zma_yhbg_06},
    		#{tbpz}, #{ws}, #{cu_maktx}, #{cu_pcdst}, #{ztype}, #{barcode}, #{gdno}, #{lh}, #{dgxx}, #{zklx}, #{erdat}, #{erzet},
    		#{erdat1}, #{erdat2}, #{netpr},#{aedat},#{pernr}, #{hashResult}
    	)
    </insert>
    <delete id="deleteVbap" parameterType="com.huazheng.project.hana.model.Vbap">
    	delete from vbap 
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </delete>
	<update id="updateVbap" parameterType="com.huazheng.project.hana.model.Vbap">
    	update Vbap set
			vbeln = #{vbeln}, posnr = #{posnr}, matnr = #{matnr}, mandt = #{mandt}, matkl = #{matkl}, spart = #{spart}, 
			kwmeng = #{kwmeng}, netwr = #{netwr}, mwsbp = #{mwsbp}, waerk = #{waerk}, vrkme = #{vrkme}, abgru = #{abgru}, 
			uebto = #{uebto}, untto = #{untto}, werks = #{werks}, vstel = #{vstel}, mvgr1 = #{mvgr1}, plavo = #{plavo}, 
			mvgr4 = #{mvgr4}, mvgr5 = #{mvgr5}, ulxh = #{ulxh}, zma_ftb_02 = #{zma_ftb_02}, zma_ftb_03 = #{zma_ftb_03}, 
			zma_ftb_45 = #{zma_ftb_45}, zma_ftb_06 = #{zma_ftb_06}, zma_ftb_07 = #{zma_ftb_07}, zma_ftb_08 = #{zma_ftb_08}, 
			zma_jyb_02 = #{zma_jyb_02}, zma_jyb_03 = #{zma_jyb_03}, zma_jyb_45 = #{zma_jyb_45}, zma_jyb_06 = #{zma_jyb_06}, 
			zma_jyb_07 = #{zma_jyb_07}, zma_ljb_03 = #{zma_ljb_03}, zma_ljb_04 = #{zma_ljb_04}, zma_ljb_06 = #{zma_ljb_06}, 
			zma_ljb_07 = #{zma_ljb_07}, zma_ljb_08 = #{zma_ljb_08}, zma_ljb_11 = #{zma_ljb_11}, zma_ljb_12 = #{zma_ljb_12}, 
			zma_ljb_13 = #{zma_ljb_13}, zma_yhbg_02 = #{zma_yhbg_02}, zma_yhbg_04 = #{zma_yhbg_04}, zma_yhbg_05 = #{zma_yhbg_05}, 
			zma_yhbg_06 = #{zma_yhbg_06}, tbpz = #{tbpz}, ws = #{ws}, cu_maktx = #{cu_maktx}, cu_pcdst = #{cu_pcdst}, 
			ztype = #{ztype}, barcode = #{barcode}, gdno = #{gdno}, lh = #{lh}, dgxx = #{dgxx}, zklx = #{zklx}, 
			erdat = #{erdat}, erzet = #{erzet}, erdat1 = #{erdat1}, erdat2 = #{erdat2}, netpr = #{netpr},aedat=#{aedat},pernr=#{pernr}, hashResult = #{hashResult}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
	<select id="selectVbapCheck" parameterType="com.huazheng.project.hana.model.Vbap" resultType="com.huazheng.project.hana.model.Vbap">
    	select * from Vbap where rownum &gt; #{rowNum} order by rownum limit 20
    </select>
    <select id="selectVbapCheckByUpdate" parameterType="com.huazheng.project.hana.model.Vbap" resultType="com.huazheng.project.hana.model.Vbap">
    	select * from Vbap where aedat &gt;= #{aedat} order by rownum
    </select>
    
    
    
	
    



    




	<select id="selectPersonComp" parameterType="com.huazheng.project.mssql3.model.PersonComp" resultType="com.huazheng.project.mssql3.model.PersonComp">
    	select * from PersonComp 
    	<where>
	    	<if test="uposnr != null  and uposnr != ''">and uposnr = #{uposnr}</if>
	    	<if test="dposnr != null  and dposnr != ''">and dposnr = #{dposnr}</if>
    	</where>
    </select>
    <insert id="insertPersonComp" parameterType="com.huazheng.project.mssql3.model.PersonComp">
    	insert into PersonComp (id, uname, uposnr, dname, dposnr, hashResult) values (#{id}, #{uname}, #{uposnr}, #{dname}, #{dposnr}, #{hashResult})
    </insert>
	<delete id="deletePersonComp" parameterType="com.huazheng.project.mssql3.model.PersonComp">
    	delete from PersonComp
    	<where>
	    	<if test="uposnr != null  and uposnr != ''">and uposnr = #{uposnr}</if>
	    	<if test="dposnr != null  and dposnr != ''">and dposnr = #{dposnr}</if>
    	</where>
    </delete>
    <update id="updatePersonComp" parameterType="com.huazheng.project.mssql3.model.PersonComp">
    	update PersonComp set
    		uname = #{uname}, uposnr = #{uposnr}, dname = #{dname}, dposnr = #{dposnr}, hashResult = #{hashResult}
    	<where>
	    	<if test="uposnr != null  and uposnr != ''">and uposnr = #{uposnr}</if>
	    	<if test="dposnr != null  and dposnr != ''">and dposnr = #{dposnr}</if>
    	</where>
    </update>
	<select id="selectPersonCompCheck" parameterType="com.huazheng.project.mssql3.model.PersonComp" resultType="com.huazheng.project.mssql3.model.PersonComp">
    	select * from PersonComp where rownum &gt; #{rowNum} order by rownum limit 20
    </select>    
    
    
    




    
    
    
<!--     <select id="selectBsid2Bsad" parameterType="com.huazheng.project.hana.model.Bsid2Bsad" resultType="com.huazheng.project.hana.model.Bsid2Bsad"> -->
<!--     	select * from Bsid2Bsad -->
<!--     	where mandt = #{mandt} -->
<!-- 			and bukrs = #{bukrs} and kunnr = #{kunnr} and umsks = #{umsks} and umskz = #{umskz}  -->
<!-- 			and augdt = #{augdt} and augbl = #{augbl} and zuonr = #{zuonr} and gjahr = #{gjahr}  -->
<!-- 			and belnr = #{belnr} and buzei = #{buzei}  -->
<!--     </select> -->
<!--     <insert id="insertBsid2Bsad" parameterType="com.huazheng.project.hana.model.Bsid2Bsad"> -->
<!--     	insert into Bsid2Bsad (vbeln,mandt,bukrs,kunnr,umsks,umskz,augdt,augbl,zuonr,gjahr,belnr, -->
<!--     	buzei,blart,waers,wrbtr,shkzg,budat,budatc,zfbdt,dqsjc,zterm,budatd)  -->
<!--     	values(#{vbeln},#{mandt},#{bukrs},#{kunnr},#{umsks},#{umskz},#{augdt},#{augbl},#{zuonr},#{gjahr},#{belnr}, -->
<!--     	#{buzei},#{blart},#{waers},#{wrbtr},#{shkzg},#{budat},#{budatc},#{zfbdt},#{dqsjc},#{zterm},#{budatd}) -->
<!--     </insert> -->
<!-- 	<update id="updateBsid2Bsad" parameterType="com.huazheng.project.hana.model.Bsid2Bsad"> -->
<!--     	update Bsid2Bsad set -->
<!--     		vbeln = #{vbeln},mandt = #{mandt},bukrs = #{bukrs},kunnr = #{kunnr},umsks = #{umsks},umskz = #{umskz},augdt = #{augdt}, -->
<!--     		augbl = #{augbl},zuonr = #{zuonr},gjahr = #{gjahr},belnr = #{belnr},buzei = #{buzei},blart = #{blart},waers = #{waers}, -->
<!--     		wrbtr = #{wrbtr},shkzg = #{shkzg},budat = #{budat},budatc = #{budatc},zfbdt = #{zfbdt},dqsjc = #{dqsjc},zterm = #{zterm},budatd = #{budatd} -->
<!--     	where mandt = #{mandt} -->
<!-- 			and bukrs = #{bukrs} and kunnr = #{kunnr} and umsks = #{umsks} and umskz = #{umskz}  -->
<!-- 			and augdt = #{augdt} and augbl = #{augbl} and zuonr = #{zuonr} and gjahr = #{gjahr}  -->
<!-- 			and belnr = #{belnr} and buzei = #{buzei} -->
<!--     </update> -->
<!--     <delete id="deleteBsid2Bsad" parameterType="com.huazheng.project.hana.model.Bsid2Bsad"> -->
<!--     	delete from Bsid2Bsad -->
<!--     	where mandt = #{mandt} -->
<!-- 			and bukrs = #{bukrs} and kunnr = #{kunnr} and umsks = #{umsks} and umskz = #{umskz}  -->
<!-- 			and augdt = #{augdt} and augbl = #{augbl} and zuonr = #{zuonr} and gjahr = #{gjahr}  -->
<!-- 			and belnr = #{belnr} and buzei = #{buzei} -->
<!--     </delete> -->
<!--     <select id="selectBsid2BsadCheck" parameterType="com.huazheng.project.hana.model.Bsid2Bsad" resultType="com.huazheng.project.hana.model.Bsid2Bsad"> -->
<!--     	select * from Bsid2Bsad where rownum &gt; #{rowNum} order by rownum limit 20 -->
<!--     </select> -->
    
    
    
    
    
    
    
    <insert id="insertVbapAdv" parameterType="com.huazheng.project.hana.model.Vbap">
    	insert into VbapAdv (
			vbeln, posnr, matnr, mandt, matkl, spart, kwmeng, netwr, mwsbp, waerk, vrkme, abgru, 
    		uebto, untto, werks, vstel, mvgr1, plavo, mvgr4, mvgr5, ulxh, zma_ftb_02, zma_ftb_03, 
    		zma_ftb_45, zma_ftb_06, zma_ftb_07, zma_ftb_08, zma_jyb_02, zma_jyb_03, zma_jyb_45, 
    		zma_jyb_06, zma_jyb_07, zma_ljb_03, zma_ljb_04, zma_ljb_06, zma_ljb_07, zma_ljb_08, 
    		zma_ljb_11, zma_ljb_12, zma_ljb_13, zma_yhbg_02, zma_yhbg_04, zma_yhbg_05, zma_yhbg_06, 
    		tbpz, ws, cu_maktx, cu_pcdst, ztype, barcode, gdno, lh, dgxx, zklx, erdat, erzet, erdat1, erdat2,
    		htsl, pssj, netpr, aedat,pernr
		) 
    	values(
    		#{vbeln}, #{posnr}, #{matnr}, #{mandt}, #{matkl}, #{spart}, #{kwmeng}, #{netwr}, #{mwsbp}, #{waerk}, #{vrkme}, #{abgru},
    		#{uebto}, #{untto}, #{werks}, #{vstel}, #{mvgr1}, #{plavo}, #{mvgr4}, #{mvgr5}, #{ulxh}, #{zma_ftb_02}, #{zma_ftb_03},
    		#{zma_ftb_45}, #{zma_ftb_06}, #{zma_ftb_07}, #{zma_ftb_08}, #{zma_jyb_02}, #{zma_jyb_03}, #{zma_jyb_45},
    		#{zma_jyb_06}, #{zma_jyb_07}, #{zma_ljb_03}, #{zma_ljb_04}, #{zma_ljb_06}, #{zma_ljb_07}, #{zma_ljb_08},
    		#{zma_ljb_11}, #{zma_ljb_12}, #{zma_ljb_13}, #{zma_yhbg_02}, #{zma_yhbg_04}, #{zma_yhbg_05}, #{zma_yhbg_06},
    		#{tbpz}, #{ws}, #{cu_maktx}, #{cu_pcdst}, #{ztype}, #{barcode}, #{gdno}, #{lh}, #{dgxx}, #{zklx}, #{erdat}, #{erzet}, #{erdat1}, #{erdat2},
    		#{kwmeng}, #{erdat1}, #{netpr}, #{aedat},#{pernr}
    		)
    </insert>
    <update id="updateVbapAdv" parameterType="com.huazheng.project.hana.model.Vbap">
    	update VbapAdv set
			vbeln = #{vbeln}, posnr = #{posnr}, matnr = #{matnr}, mandt = #{mandt}, matkl = #{matkl}, spart = #{spart}, 
			kwmeng = #{kwmeng}, netwr = #{netwr}, mwsbp = #{mwsbp}, waerk = #{waerk}, vrkme = #{vrkme}, abgru = #{abgru}, 
			uebto = #{uebto}, untto = #{untto}, werks = #{werks}, vstel = #{vstel}, mvgr1 = #{mvgr1}, plavo = #{plavo}, 
			mvgr4 = #{mvgr4}, mvgr5 = #{mvgr5}, ulxh = #{ulxh}, zma_ftb_02 = #{zma_ftb_02}, zma_ftb_03 = #{zma_ftb_03}, 
			zma_ftb_45 = #{zma_ftb_45}, zma_ftb_06 = #{zma_ftb_06}, zma_ftb_07 = #{zma_ftb_07}, zma_ftb_08 = #{zma_ftb_08}, 
			zma_jyb_02 = #{zma_jyb_02}, zma_jyb_03 = #{zma_jyb_03}, zma_jyb_45 = #{zma_jyb_45}, zma_jyb_06 = #{zma_jyb_06}, 
			zma_jyb_07 = #{zma_jyb_07}, zma_ljb_03 = #{zma_ljb_03}, zma_ljb_04 = #{zma_ljb_04}, zma_ljb_06 = #{zma_ljb_06}, 
			zma_ljb_07 = #{zma_ljb_07}, zma_ljb_08 = #{zma_ljb_08}, zma_ljb_11 = #{zma_ljb_11}, zma_ljb_12 = #{zma_ljb_12}, 
			zma_ljb_13 = #{zma_ljb_13}, zma_yhbg_02 = #{zma_yhbg_02}, zma_yhbg_04 = #{zma_yhbg_04}, zma_yhbg_05 = #{zma_yhbg_05}, 
			zma_yhbg_06 = #{zma_yhbg_06}, tbpz = #{tbpz}, ws = #{ws}, cu_maktx = #{cu_maktx}, cu_pcdst = #{cu_pcdst}, 
			ztype = #{ztype}, barcode = #{barcode}, gdno = #{gdno}, lh = #{lh}, dgxx = #{dgxx}, zklx = #{zklx}, 
			erdat = #{erdat}, erzet = #{erzet}, erdat1 = #{erdat1}, erdat2 = #{erdat2}, netpr = #{netpr},aedat=#{aedat},pernr=#{pernr}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
    
    
    
    
	<select id="selectVbapAdv" parameterType="com.huazheng.project.hana.model.VbapAdv" resultType="com.huazheng.project.hana.model.VbapAdv">
    	select 
    		vbeln, posnr, matnr, mandt, matkl, spart, kwmeng, netwr, mwsbp, waerk, vrkme, abgru, 
    		uebto, untto, werks, vstel, mvgr1, plavo, mvgr4, mvgr5, ulxh, zma_ftb_02, zma_ftb_03, 
    		zma_ftb_45, zma_ftb_06, zma_ftb_07, zma_ftb_08, zma_jyb_02, zma_jyb_03, zma_jyb_45, 
    		zma_jyb_06, zma_jyb_07, zma_ljb_03, zma_ljb_04, zma_ljb_06, zma_ljb_07, zma_ljb_08, 
    		zma_ljb_11, zma_ljb_12, zma_ljb_13, zma_yhbg_02, zma_yhbg_04, zma_yhbg_05, zma_yhbg_06, 
    		tbpz, ws, cu_maktx, cu_pcdst, ztype, barcode, gdno, lh, dgxx, zklx, erdat, erzet, erdat1, erdat2,
			kpsj,htsl,pssj,jhsj,pcsj,rksj,ccsj,pcsl,rksl,jhsl,ccsl,kpsl,wlsj,
			netpr, aedat,pernr
    	from VbapAdv
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </select>
    <delete id="deleteVbapAdv" parameterType="com.huazheng.project.hana.model.Vbap">
    	delete from VbapAdv 
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </delete>
    <update id="resetCaVbapAdv" parameterType="com.huazheng.project.hana.model.Vbap">
	    update VbapAdv set
	    	kpsj = null, jhsj = null, jhsl = null, rksj = null, kpsl = null, ccsl = null, rksl = null, pcsl = null
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
    
    <update id="updateVbapAdv4Aufk" parameterType="com.huazheng.project.hana.model.Aufk">
    	update VbapAdv set
	    	aufk_kdauf = #{kdauf}, aufk_kdpos = #{kdpos}, aufk_mandt = #{mandt}, aufk_aufnr = #{aufnr}, 
	    	aufk_erdat = #{erdat}, aufk_erfzeit = #{erfzeit}, aufk_ernam = #{ernam}, aufk_aenam = #{aenam}, 
	    	aufk_bukrs = #{bukrs}, aufk_erdat1 = #{erdat1}, aufk_erdat2 = #{erdat2}, aufk_auart=#{auart}, aufk_werks=#{werks},
	    	pcsj = #{erdat1}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
    <update id="updateVbapAdv4SysSAPreturnNo" parameterType="com.huazheng.project.mssql2.model.SysSAPreturnNo">
    	update VbapAdv set
	    	ssspn_id = #{id}, ssspn_processName = #{processName}, ssspn_shiLiH = #{shiLiH}, 
	    	ssspn_sapNo = #{sapNo}, ssspn_chuangJianSJ = #{chuangJianSJ}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
	<update id="updateVbapAdv4SalesContractProcess" parameterType="com.huazheng.project.mssql.model.SalesContractProcess">
    	update VbapAdv set
	    	scp_id = #{id}, scp_xiaoShouDDBH = #{xiaoShouDDBH}, scp_xuFangGSID = #{xuFangGSID}, 
	    	scp_xuFangGS = #{xuFangGS}, scp_gongFangGSt = #{gongFangGSt}, scp_xiaoShouBMt = #{xiaoShouBMt}, 
	    	scp_shouHuoGSID = #{shouHuoGSID}, scp_shouHuoGS = #{shouHuoGS}, scp_fuKuanTJt = #{fuKuanTJt}, 
	    	scp_caiGouDDBH = #{caiGouDDBH}, scp_dangQianXYED = #{dangQianXYED}, scp_yvQiK = #{yvQiK}, 
	    	scp_dengJi = #{dengJi}, scp_biZhongt = #{biZhongt}, scp_yongJin = #{yongJin}, 
	    	scp_zongHeMLL = #{zongHeMLL}, scp_sysProcessname = #{sysProcessname}, scp_sysIncident = #{sysIncident},
	    	scp_ziShiYBv = #{ziShiYBv}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
	<update id="updateVbapAdv4Mara" parameterType="com.huazheng.project.hana.model.Mara">
    	update VbapAdv set
    		mara_matnr = #{matnr}, mara_mandt = #{mandt}, mara_ersda = #{ersda}, mara_ernam = #{ernam}, 
    		mara_laeda = #{laeda}, mara_aenam = #{aenam}, mara_vpsta = #{vpsta}, mara_pstat = #{pstat}, 
    		mara_mtart = #{mtart}, mara_mbrsh = #{mbrsh}, mara_matkl = #{matkl}, mara_bismt = #{bismt}, 
    		mara_meins = #{meins}, mara_bstme = #{bstme}, mara_wrkst = #{wrkst}, mara_brgew = #{brgew}, 
    		mara_ntgew = #{ntgew}, mara_gewei = #{gewei}, mara_spart = #{spart}, mara_kzkfg = #{kzkfg}, 
    		mara_extwg = #{extwg}, mara_cuobf = #{cuobf}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
	<update id="updateVbapAdv4Makt" parameterType="com.huazheng.project.hana.model.Makt">
    	update VbapAdv set
			makt_matnr = #{matnr}, makt_mandt = #{mandt}, makt_spras = #{spras}, makt_maktx = #{maktx}, makt_maktxSize = #{maktxSize}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
	<update id="updateVbapAdv4Zsd06" parameterType="com.huazheng.project.hana.model.Zsd06">
    	update VbapAdv set
			zsd06_vbeln = #{vbeln}, zsd06_posnr = #{posnr}, zsd06_mandt = #{mandt}, zsd06_datum = #{datum}, 
			zsd06_uname = #{uname}, zsd06_crt_uname = #{crt_uname}, zsd06_crt_datum = #{crt_datum}, 
			zsd06_crt_time = #{crt_time}, zsd06_cha_name = #{cha_name}, zsd06_cha_datum = #{cha_datum}, 
			zsd06_cha_time = #{cha_time}, zsd06_datum1 = #{datum1}, zsd06_crt_datum1 = #{crt_datum1}, 
			zsd06_cha_datum1 = #{cha_datum1}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
   	<update id="updateVbapAdv4Vbak" parameterType="com.huazheng.project.hana.model.Vbak">
    	update VbapAdv set
			vbak_vbeln = #{vbeln}, vbak_mandt = #{mandt}, vbak_vbtyp = #{vbtyp}, vbak_audat = #{audat}, 
			vbak_waerk = #{waerk}, vbak_kalsm = #{kalsm}, vbak_ctlpc = #{ctlpc}, vbak_kunnr = #{kunnr}, 
			vbak_bukrs_vf = #{bukrs_vf}, vbak_bstnk = #{bstnk}, vbak_bname = #{bname}, vbak_telf1 = #{telf1}, 
			vbak_netwr = #{netwr}, vbak_vkbur = #{vkbur}, vbak_audat1 = #{audat1}, vbak_knumv = #{knumv}, 
			vbak_vkorg = #{vkorg}, vbak_vtweg = #{vtweg}, vbak_kkber = #{kkber}, vbak_auart = #{auart}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
	<update id="updateVbapAdv4Likp" parameterType="com.huazheng.project.hana.model.Likp">
    	update VbapAdv set
			likp_vbeln = #{vbeln}, likp_mandt = #{mandt}, likp_erdat = #{erdat}, likp_wadat_ist = #{wadat_ist}, 
			likp_ctlpc = #{ctlpc}, likp_kunnr = #{kunnr}, likp_erdat1 = #{erdat1}, likp_wadat_ist1 = #{wadat_ist1}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
	<update id="updateVbapAdv4Handover" parameterType="com.huazheng.project.mysql.model.Handover">
    	update VbapAdv set
			handover_vbeln = #{vbeln},
			handover_task_id = #{task_id},
			handover_handover_id = #{handover_id},
			handover_handover_type = #{handover_type},
			handover_order_type = #{order_type},
			handover_task_no = #{task_no},
			handover_sale_no = #{sale_no},
			handover_delivery_type = #{delivery_type},
			handover_handover_state = #{handover_state},
			handover_f_plant = #{f_plant},
			handover_plant = #{plant},
			handover_customer_id = #{customer_id},
			handover_customer_name = #{customer_name},
			handover_fmenge = #{fmenge},
			handover_delivery_num = #{delivery_num},
			handover_port = #{port},
			handover_piect_total = #{piect_total},
			handover_total_net_weight = #{total_net_weight},
			handover_weight_total = #{weight_total},
			handover_settlement_weight = #{settlement_weight},
			handover_weight_state = #{weight_state},
			handover_vrkme = #{vrkme},
			handover_average_freight = #{average_freight},
			handover_order_remark = #{order_remark},
			handover_delivery_time = #{delivery_time},
			handover_erdat = #{erdat},
			handover_plan_product_time = #{plan_product_time},
			handover_open_ready_time = #{open_ready_time},
			handover_already_ready_time = #{already_ready_time},
			handover_appearance_time = #{appearance_time},
			handover_sign_time = #{sign_time},
			handover_edatu = #{edatu},
			handover_area_no = #{area_no},
			handover_area_name = #{area_name},
			handover_fmenge_time = #{fmenge_time},
			handover_klabc = #{klabc},
			handover_sales_man = #{sales_man},
			handover_sales_department = #{sales_department},
			handover_is_valid = #{is_valid},
			handover_created_user_id = #{created_user_id},
			handover_created_time = #{created_time},
			handover_modified_user_id = #{modified_user_id},
			handover_modified_time = #{modified_time},
			handover_remark = #{remark},
			handover_is_auto_created = #{is_auto_created},
			handover_delivery_state = #{delivery_state},
			handover_operate_tag = #{operate_tag},
			handover_transport_time = #{transport_time},
			handover_is_date_success = #{is_date_success},
			handover_is_num_success = #{is_num_success},
			handover_is_sign_success = #{is_sign_success},
			handover_weighing_weight = #{weighing_weight},
			handover_delivery_issued_time = #{delivery_issued_time},
			ccsj = #{already_ready_time}, wlsj = #{sign_time}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
    <update id="updateVbapAdv4Zmdpc" parameterType="com.huazheng.project.hana.model.Zmdpc">
    	update VbapAdv set
			zmdpc_vbeln = #{vbeln},zmdpc_posnr = #{posnr},zmdpc_f_plant = #{f_plant},
			zmdpc_plant = #{plant},zmdpc_x_plant = #{x_plant},zmdpc_mandt = #{mandt}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
    <update id="updateVbapAdv4T023t" parameterType="com.huazheng.project.hana.model.T023t">
    	update VbapAdv set
			t023t_mandt = #{mandt},t023t_spras = #{spras},t023t_matkl = #{matkl},t023t_wgbez = #{wgbez},t023t_wgbez60 = #{wgbez60}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
    <update id="updateVbapAdv4Kna1" parameterType="com.huazheng.project.hana.model.Kna1">
    	update VbapAdv set
			kna1_kunnr = #{kunnr}, kna1_name1 = #{name1}, kna1_name2 = #{name2}, kna1_mandt = #{mandt}
    	where vbeln = #{vbap.vbeln} and posnr = #{vbap.posnr} and mandt = #{vbap.mandt} and erdat1 = #{vbap.erdat1}
    </update>
    
    
    
    
    
    
    <update id="updateCaVbapAdv4Lips" parameterType="com.huazheng.project.hana.model.VbapAdv">
    	update VbapAdv set ccsl = #{ccsl}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
	<update id="updateCaVbapAdv4Vbrp" parameterType="com.huazheng.project.hana.model.VbapAdv">
    	update VbapAdv set kpsl = #{kpsl}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
	<update id="updateCaVbapAdv4Vbrk" parameterType="com.huazheng.project.hana.model.VbapAdv">
    	update VbapAdv set kpsj = #{kpsj}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
    <update id="updateCaVbapAdv4VbepJhsj" parameterType="com.huazheng.project.hana.model.VbapAdv">
    	update VbapAdv set jhsj = #{jhsj}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
	<update id="updateCaVbapAdv4VbepJhsl" parameterType="com.huazheng.project.hana.model.VbapAdv">
    	update VbapAdv set jhsl = #{jhsl}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
    <update id="updateCaVbapAdv4AfpoRksl" parameterType="com.huazheng.project.hana.model.VbapAdv">
    	update VbapAdv set rksl = #{rksl}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
    <update id="updateCaVbapAdv4AfpoPcsl" parameterType="com.huazheng.project.hana.model.VbapAdv">
    	update VbapAdv set pcsl = #{pcsl}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
    <update id="updateCaVbapAdv4Aufm" parameterType="com.huazheng.project.hana.model.VbapAdv">
    	update VbapAdv set rksj = #{rksj}
    	where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
    
    
    
    
    
    
    
    
    
    
    
    
    
    <select id="selectVbapAdv4Aufk" resultType="com.huazheng.project.hana.model.Aufk">
    	select * from aufk where kdauf = #{vbeln} and kdpos = #{posnr} and mandt = #{mandt} limit 1
    </select>
    <select id="selectVbapAdv4SysSAPreturnNo" resultType="com.huazheng.project.mssql2.model.SysSAPreturnNo">
    	select * from SysSAPreturnNo where sapno = #{vbeln} limit 1
    </select>
    <select id="selectVbapAdv4SalesContractProcess" resultType="com.huazheng.project.mssql.model.SalesContractProcess">
    	select b.* from SysSAPreturnNo a
		left join SalesContractProcess b on a.processName = b.SYSPROCESSNAME and a.shiLiH = SYSINCIDENT
		where b.id is not null and a.sapno = #{vbeln}
		limit 1
    </select>
    <select id="selectVbapAdv4Mara" resultType="com.huazheng.project.hana.model.Mara">
    	select * from mara where matnr = #{matnr} and mandt = #{mandt} limit 1
    </select>
    <select id="selectVbapAdv4Makt" resultType="com.huazheng.project.hana.model.Makt">
    	select * from makt where matnr = #{matnr} and mandt = #{mandt} limit 1
    </select>
    <select id="selectVbapAdv4Zsd06" resultType="com.huazheng.project.hana.model.Zsd06">
    	select * from zsd06 where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} limit 1
    </select>
    <select id="selectVbapAdv4Vbak" resultType="com.huazheng.project.hana.model.Vbak">
    	select * from vbak where vbeln = #{vbeln} and mandt = #{mandt} limit 1
    </select>
    <select id="selectVbapAdv4Likp" resultType="com.huazheng.project.hana.model.Likp">
    	select b.* from lips a
		left join likp b on b.vbeln = a.vbeln and b.mandt = a.mandt
		where b.vbeln is not null and a.vgbel = #{vbeln} and a.vgpos = #{posnr} and a.mandt = #{mandt}
		limit 1
    </select>
    <select id="selectVbapAdv4Handover" resultType="com.huazheng.project.mysql.model.Handover">
    	select b.* from lips a
		left join (
	    	select aa.mandt, bb.* from likp aa
			left join Handover bb on aa.vbeln = bb.vbeln
			where bb.vbeln is not null
		) b on b.vbeln = a.vbeln and b.mandt = a.mandt
		where b.vbeln is not null and a.vgbel = #{vbeln} and a.vgpos = #{posnr} and a.mandt = #{mandt}
		limit 1
    </select>
    <select id="selectVbapAdv4Zmdpc" resultType="com.huazheng.project.hana.model.Zmdpc">
    	select * from Zmdpc where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} limit 1
    </select>
    <select id="selectVbapAdv4T023t" resultType="com.huazheng.project.hana.model.T023t">
    	select b.* from mara a
		left join T023t b on b.matkl = a.matkl and b.mandt = a.mandt
		where a.matnr = #{matnr} and a.mandt = #{mandt} and b.matkl is not null
		limit 1
    </select>
    <select id="selectVbapAdv4Kna1" resultType="com.huazheng.project.hana.model.Kna1">
    	select b.* from vbak a
		left join kna1 b on b.kunnr = a.kunnr and b.mandt = a.mandt and b.kunnr is not null
		where a.vbeln = #{vbeln} and a.mandt = #{mandt} limit 1
    </select>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    <select id="caLips4ccsl" parameterType="com.huazheng.project.hana.model.Vbap" resultType="java.math.BigDecimal">
    	select sum(lfimg) as ccsl from lips where vgbel = #{vbeln} and vgpos = #{posnr} and mandt = #{mandt}
    </select>
    <select id="caVbep4jhsl" parameterType="com.huazheng.project.hana.model.Vbap" resultType="java.math.BigDecimal">
    	select sum(Bmeng) as jhsl from vbep where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </select>
    <select id="caAfpo4rksl" parameterType="com.huazheng.project.hana.model.Vbap" resultType="java.math.BigDecimal">
    	select sum(wemng) as rksl from afpo where kdauf = #{vbeln} and kdpos = #{posnr} and mandt = #{mandt}
    </select>
    <select id="caAfpo4pcsl" parameterType="com.huazheng.project.hana.model.Vbap" resultType="java.math.BigDecimal">
    	select sum(psmng) as pcsl from afpo where kdauf = #{vbeln} and kdpos = #{posnr} and mandt = #{mandt}
    </select>
    <select id="caVbrp4kpsl" parameterType="com.huazheng.project.hana.model.Vbap" resultType="java.math.BigDecimal">
    	    select sum(q.fkimg) as kpsl from vbap p
			left join (
				select b.fkimg, b.aubel, b.aupos, a.mandt from vbrk a
				left join vbrp b on a.vbeln = b.vbeln and a.mandt = b.mandt
				where a.mandt is not null and b.mandt is not null and a.fkart not in ('ZIV1', 'ZIVR')
				group by b.fkimg, b.aubel, b.aupos, a.mandt
			) q on p.vbeln = q.aubel and p.mandt = q.mandt and p.posnr = q.aupos
			where p.vbeln = #{vbeln} and p.posnr = #{posnr} and p.mandt = #{mandt} and p.erdat1 = #{erdat1}
    </select>
    <select id="caVbep4jhsj" parameterType="com.huazheng.project.hana.model.Vbap" resultType="java.util.Date">
    	select max(edatu1) as Jhsj from vbep where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt}
    </select>
    <select id="caVbrk4kpsj" parameterType="com.huazheng.project.hana.model.Vbap" resultType="java.util.Date">
    	select max(r.kpsj) as kpsj from (
			select a.vbeln, a.posnr, a.mandt, a.erdat1, b.kpsj from vbap a
			left join (
				select aa.vbeln, aa.posnr, aa.mandt, bb.kpsj from lips aa
					left join (
						select aaa.vgbel,aaa.vgpos,aaa.vbeln,aaa.mandt,bbb.kpsj from Vbrp aaa
						left join (
							select vbeln, mandt, max(Fkdat1) as kpsj from vbrk group by vbeln, mandt
						) bbb on aaa.vbeln = bbb.vbeln and aaa.mandt = bbb.mandt
					) bb on aa.vbeln = bb.vgbel and aa.posnr = bb.vgpos and aa.mandt = bb.mandt
			) b on a.vbeln = b.vbeln and a.posnr = b.posnr and a.mandt = b.mandt
			where a.vbeln = #{vbeln} and a.posnr = #{posnr} and a.mandt = #{mandt} and a.erdat1 = #{erdat1}
		) r
    </select>
    <select id="caAufm4rksj" parameterType="com.huazheng.project.hana.model.Vbap" resultType="java.util.Date">
    	select max(r.rksj) as rksj from (
			select a.vbeln, a.posnr, a.mandt, a.erdat1, b.rksj from vbap a
			left join (
				select aa.kdauf,aa.kdpos,aa.mandt,aa.aufnr,bb.rksj from afpo aa
				left join (
					select aaa.aufnr,aaa.mandt,bbb.rksj from afko aaa
					left join (
						select aufnr,mandt,max(budat1) as rksj from aufm where budat1 is not null group by aufnr,mandt
					) bbb on aaa.aufnr = bbb.aufnr and aaa.mandt = bbb.mandt
					where bbb.rksj is not null
				) bb on aa.aufnr = bb.aufnr and aa.mandt = bb.mandt
				where bb.rksj is not null
			) b on a.vbeln = b.kdauf and a.posnr = b.kdpos and a.mandt = b.mandt
			where a.vbeln = #{vbeln} and a.posnr = #{posnr} and a.mandt = #{mandt} and a.erdat1 = #{erdat1} and b.rksj is not null
		) r
    </select>
    <select id="caHandover4ccsj" parameterType="com.huazheng.project.hana.model.Vbap" resultType="java.util.Date">
    	select max(r.already_ready_time) as ccsj from (
			select a.vbeln, a.posnr, a.mandt, a.erdat1, b.already_ready_time from vbap a
			left join (
				select aa.vbeln, aa.posnr, aa.mandt, bb.already_ready_time from lips aa
				left join (
					select aaa.vbeln,aaa.mandt,bbb.already_ready_time from likp aaa
					left join (
						select vbeln,max(already_ready_time) as already_ready_time from handover group by vbeln
					) bbb on aaa.vbeln = bbb.vbeln
				) bb on aa.vbeln = bb.vbeln and aa.mandt = bb.mandt
			) b on a.vbeln = b.vbeln and a.posnr = b.posnr and a.mandt = b.mandt
			where a.vbeln = #{vbeln} and a.posnr = #{posnr} and a.mandt = #{mandt} and a.erdat1 = #{erdat1}
		) r
    </select>
    <select id="caHandover4wlsj" parameterType="com.huazheng.project.hana.model.Vbap" resultType="java.util.Date">
    	select max(r.sign_time) as wlsj from (
			select a.vbeln, a.posnr, a.mandt, a.erdat1, b.sign_time from vbap a
			left join (
				select aa.vbeln, aa.posnr, aa.mandt, bb.sign_time from lips aa
				left join (
					select aaa.vbeln,aaa.mandt,bbb.sign_time from likp aaa
					left join (
						select vbeln,max(sign_time) as sign_time from handover group by vbeln
					) bbb on aaa.vbeln = bbb.vbeln
				) bb on aa.vbeln = bb.vbeln and aa.mandt = bb.mandt
			) b on a.vbeln = b.vbeln and a.posnr = b.posnr and a.mandt = b.mandt
			where a.vbeln = #{vbeln} and a.posnr = #{posnr} and a.mandt = #{mandt} and a.erdat1 = #{erdat1}
		) r
    </select>
    
    
    
    
    <update id="updatevbapAdv4CaAll" parameterType="com.huazheng.project.hana.model.VbapAdv">
    	update vbapadv set 
			ccsl = #{ccsl}, jhsl = #{jhsl}, rksl = #{rksl}, pcsl = #{pcsl}, kpsl = #{kpsl}, jhsj = #{jhsj}, kpsj = #{kpsj}, 
			rksj = #{rksj}, ccsj = #{ccsj}, wlsj = #{wlsj}, htsl = #{htsl}, pssj = #{pssj}, pcsj = #{pcsj}
		where vbeln = #{vbeln} and posnr = #{posnr} and mandt = #{mandt} and erdat1 = #{erdat1}
    </update>
	
    <select id="selectCAVThisMonthByEveryMonth" resultType="com.huazheng.project.hana.model.CAVThisMonth">
		select r.kunnr,r.waers,
			r.budatd,
			TO_CHAR(to_date(r.budatd,'yyyy-MM') + INTERVAL '-1 MONTH','YYYY-MM') budatb,
			max(r.byxse) as byxse,max(r.byhk) as byhk
		from (
			select r1.kunnr,r1.byhk, '0' as BYXSE,r1.budatd,r1.waers from (
				select 
					a.KUNNR,
					round((a.WRBTR_S + a.WRBTR_H),2) as BYHK, 
					a.budatd,a.waers
				from (
					select KUNNR,waers,
					sum(case when shkzg='S' then WRBTR/-1 else 0 end) as WRBTR_S,
					sum(case when shkzg='H' then WRBTR else 0 end) as WRBTR_H,
					budatd
					from bsid2bsad 
					where UMSKZ = '' and BLART in ('DZ', 'ZD')
					GROUP BY KUNNR,budatd,waers
				) a
				where a.budatd is not null
			) r1 
			union all
			select r2.kunnr, '0' as byhk,r2.BYXSE,r2.budatd,r2.waers from (
				select 
					a.KUNNR,
					round((a.WRBTR_S + a.WRBTR_H),2) as BYXSE,
					a.budatd,a.waers
				from (
					select KUNNR,waers,
					sum(case when shkzg='S' then WRBTR else 0 end) as WRBTR_S,
					sum(case when shkzg='H' then WRBTR/-1 else 0 end) as WRBTR_H,
					budatd
					from bsid2bsad 
					where UMSKZ = '' and BLART in ('RV', 'QC')
					GROUP BY KUNNR,budatd,waers
				) a
				where a.budatd is not null
			) r2
		) r 
		group by r.kunnr,r.budatd,r.waers
		order by r.budatd
    </select>
    
    <select id="selectCAVThisMonth" parameterType="com.huazheng.project.hana.model.CAVThisMonth" resultType="com.huazheng.project.hana.model.CAVThisMonth">
    	select * from CAVThisMonth where kunnr=#{kunnr} and waers=#{waers} and budatd=#{budatd} and budatb=#{budatb}
    </select>
    <insert id="insertCAVThisMonth" parameterType="com.huazheng.project.hana.model.CAVThisMonth">
    	insert into CAVThisMonth(kunnr,waers,budatd,budatb,byxse,byhk,dyjhk,ljsyysk) 
    	values (#{kunnr},#{waers},#{budatd},#{budatb},#{byxse},#{byhk},#{dyjhk},#{ljsyysk})
    </insert>
    <update id="updateCAVThisMonth" parameterType="com.huazheng.project.hana.model.CAVThisMonth">
    	update CAVThisMonth set
    		kunnr=#{kunnr},waers=#{waers},budatd=#{budatd},budatb=#{budatb},
    		byxse=#{byxse},byhk=#{byhk},dyjhk=#{dyjhk},ljsyysk=#{ljsyysk},
    		hashResult=#{hashResult}
    	where kunnr=#{kunnr} and waers=#{waers} and budatd=#{budatd} and budatb=#{budatb}
    </update>
    
</mapper>
