a.id AS "id", a.project_id AS "projectId", a.member_code AS "memberCode", a.member_name AS "memberName", a.charging_item_name AS "chargingItemName", a.project_name AS "projectName", a.charging_item_id AS "chargingItemId", a.num AS "num", a.price AS "price", a.total_price AS "totalPrice", a.add_time AS "addTime", a.business_order_code AS "businessOrderCode", a.voucher_code AS "voucherCode", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag", a.business_id as "businessId", a.business_name as "businessName" SELECT FROM payment_project_cart a WHERE a.id = #{id} SELECT FROM payment_project_cart a a.del_flag = #{DEL_FLAG_NORMAL} AND a.voucher_code = #{voucherCode} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM payment_project_cart a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO payment_project_cart( id, project_id, project_name, member_code, member_name, charging_item_id, charging_item_name, num, price, total_price, add_time, business_order_code, voucher_code, create_by, create_date, update_by, update_date, remarks, del_flag, business_id, business_name ) VALUES ( #{id}, #{projectId}, #{projectName}, #{memberCode}, #{memberName}, #{chargingItemId}, #{chargingItemName}, #{num}, #{price}, #{totalPrice}, #{addTime}, #{businessOrderCode}, #{voucherCode}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{businessId}, #{businessName} ) UPDATE payment_project_cart SET project_id = #{projectId}, member_code = #{memberCode}, charging_item_id = #{chargingItemId}, member_name = #{memberName}, charging_item_name = #{chargingItemName}, project_name = #{projectName}, num = #{num}, price = #{price}, total_price = #{totalPrice}, add_time = #{addTime}, voucher_code = #{voucherCode}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, business_id = #{businessId}, business_name = #{businessName} WHERE id = #{id} delete from payment_project_cart where id=#{id} delete from payment_project_cart WHERE project_id = #{projectId} AND member_code = #{memberCode} AND voucher_code = #{voucherCode} DELETE FROM payment_project_cart where project_id = #{projectId} AND member_code = #{memberCode} AND business_order_code = #{businessOrderCode} AND voucher_code = #{voucherCode}