@Insert("<script>" + "INSERT INTO DTS.BUS_Charge_Data(businessDate,tradeType,ticketMainType,ticketType,chipType,ticketVersion," + "logicalID,physicalID,counter,operatorID,shiftID,posID,samID,samSeqNo,tradeTime,paymentMode,tradeAmount," + "cashTradeAmount,tradeBalance,deposit,fee,favourAmount,curStationID,lastStationID,lastTradeTime," + "deviceID,deviceSeqNo,cardValidDate,saleCardMode,batchID,authorSeqID,limitAuthorSeqId,lastTradeType," + "lastTradeDeviceId,lastTradeAmount,lastTradeCounter,lastTradeDateTime,lastTradePreBalance,lastTradeTac," + "cityCode,testCardFlag,tac,netOrderNumber,reserve) VALUES " + "<foreach collection='dto' item='item' separator=','> " + "(#{item.businessDate},#{item.tradeType},#{item.ticketMainType},#{item.ticketType},#{item.chipType}," + "#{item.ticketVersion},#{item.logicalID},#{item.physicalID},#{item.counter},#{item.operatorID}," + "#{item.shiftID},#{item.posID},#{item.samID},#{item.samSeqNo},#{item.tradeTime},#{item.paymentMode}," + "#{item.tradeAmount},#{item.cashTradeAmount},#{item.tradeBalance},#{item.deposit},#{item.fee}," + "#{item.favourAmount},#{item.curStationID},#{item.lastStationID},#{item.lastTradeTime},#{item.deviceID}," + "#{item.deviceSeqNo},#{item.cardValidDate},#{item.saleCardMode},#{item.batchID},#{item.authorSeqID}," + "#{item.limitAuthorSeqId},#{item.lastTradeType},#{item.lastTradeDeviceId},#{item.lastTradeAmount}," + "#{item.lastTradeCounter},#{item.lastTradeDateTime},#{item.lastTradePreBalance},#{item.lastTradeTac}," + "#{item.cityCode},#{item.testCardFlag},#{item.tac},#{item.netOrderNumber},#{item.reserve})" + "</foreach> " + "</script>")
478
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
