a.id AS "id", a.order_no AS "orderNo", a.waybill_no AS "waybillNo", a.orderStateCode AS "orderstatecode", a.orderStateDesc AS "orderstatedesc", a.empcode AS "empcode", a.empphone AS "empphone", a.netcode AS "netcode", a.lasttime AS "lasttime", a.booktime AS "booktime", a.carriercode AS "carriercode", a.create_time AS 'createTime' SELECT FROM sf_express_state a WHERE a.id = #{id} SELECT FROM sf_express_state a a.order_no = #{orderNo} ORDER BY ${page.orderBy} ORDER BY create_time DESC SELECT FROM sf_express_state a a.order_no = #{orderNo} ORDER BY create_time DESC SELECT FROM sf_express_state a ORDER BY ${page.orderBy} INSERT INTO sf_express_state( id, order_no, waybill_no, orderStateCode, orderStateDesc, empcode, empphone, netcode, lasttime, booktime, carriercode, create_time ) VALUES ( #{id}, #{orderNo}, #{waybillNo}, #{orderStateCode}, #{orderStateDesc}, #{empcode}, #{empphone}, #{netcode}, #{lasttime}, #{booktime}, #{carriercode}, #{createTime} ) UPDATE sf_express_state SET order_no = #{orderNo}, waybill_no = #{waybillNo}, orderStateCode = #{orderStateCode}, orderStateDesc = #{orderStateDesc}, empCode = #{empCode}, empPhone = #{empPhone}, netCode = #{netCode}, lastTime = #{lastTime}, bookTime = #{bookTime}, carrierCode = #{carrierCode}, WHERE id = #{id} DELETE FROM sf_express_state WHERE id = #{id} update sys_express_send set other_express_no = #{sfExpressState.waybillNo} , origincode = #{sfExpressState.origincode} , destcode = #{sfExpressState.destcode},two_dimension_code = #{sfExpressState.twoDimensionCode}, pro_code = #{sfExpressState.proCode},print_icon = #{sfExpressState.printIcon}, dest_route_label = #{sfExpressState.destRouteLabel},coding_mapping = #{sfExpressState.codingMapping}, dest_team_code = #{sfExpressState.destTeamCode} where id = #{expressSendId};