DELETE FROM "STRPTDAILYPUMPMETER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("STORE_ID" = :Original_STORE_ID) AND ("PUMP_ID" = :Original_PUMP_ID) AND ("PRODUCT_NO" = :Original_PRODUCT_NO)) INSERT INTO "STRPTDAILYPUMPMETER" ("COOP_ID", "STORE_ID", "PUMP_ID", "PRODUCT_NO", "WORKING_DATE", "BEFORE_METER", "AFTER_METER", "UNIT_PRICE", "BFBALANCE_QTY", "BFBALANCE_PRICE", "LOT_QTY", "LOT_PRICE", "SALE_QTY", "SALE_PRICE", "BALANCE_QTY", "BALANCE_PRICE", "CKBALANCE_QTY", "CKBALANCE_PRICE", "EXPEND_QTY", "REFUND_QTY") VALUES (:COOP_ID, :STORE_ID, :PUMP_ID, :PRODUCT_NO, :WORKING_DATE, :BEFORE_METER, :AFTER_METER, :UNIT_PRICE, :BFBALANCE_QTY, :BFBALANCE_PRICE, :LOT_QTY, :LOT_PRICE, :SALE_QTY, :SALE_PRICE, :BALANCE_QTY, :BALANCE_PRICE, :CKBALANCE_QTY, :CKBALANCE_PRICE, :EXPEND_QTY, :REFUND_QTY) select * from strptdailypumpmeter UPDATE "STRPTDAILYPUMPMETER" SET "COOP_ID" = :COOP_ID, "STORE_ID" = :STORE_ID, "PUMP_ID" = :PUMP_ID, "PRODUCT_NO" = :PRODUCT_NO, "WORKING_DATE" = :WORKING_DATE, "BEFORE_METER" = :BEFORE_METER, "AFTER_METER" = :AFTER_METER, "UNIT_PRICE" = :UNIT_PRICE, "BFBALANCE_QTY" = :BFBALANCE_QTY, "BFBALANCE_PRICE" = :BFBALANCE_PRICE, "LOT_QTY" = :LOT_QTY, "LOT_PRICE" = :LOT_PRICE, "SALE_QTY" = :SALE_QTY, "SALE_PRICE" = :SALE_PRICE, "BALANCE_QTY" = :BALANCE_QTY, "BALANCE_PRICE" = :BALANCE_PRICE, "CKBALANCE_QTY" = :CKBALANCE_QTY, "CKBALANCE_PRICE" = :CKBALANCE_PRICE, "EXPEND_QTY" = :EXPEND_QTY, "REFUND_QTY" = :REFUND_QTY WHERE (("COOP_ID" = :Original_COOP_ID) AND ("STORE_ID" = :Original_STORE_ID) AND ("PUMP_ID" = :Original_PUMP_ID) AND ("PRODUCT_NO" = :Original_PRODUCT_NO))