a.id AS "id", a.cate_id AS "cateId", a.cate_name AS "cateName", a.business_id AS "businessId", a.business_name AS "businessName", a.sku_id AS "skuId", a.sku_name AS "skuName", a.unit_price AS "unitPrice", a.num AS "num", a.total_price AS "totalPrice", a.member_code AS "memberCode", a.order_code AS "orderCode", a.charging_item_ids AS "chargingItemIds", a.charging_item_names AS "chargingItemNames", 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" SELECT FROM business_order a WHERE a.id = #{id} SELECT FROM business_order a a.del_flag = #{DEL_FLAG_NORMAL} AND a.cate_id = #{cateId} AND a.cate_name = #{cateName} AND a.business_id = #{businessId} AND a.business_name = #{businessName} AND a.sku_id = #{skuId} AND a.sku_name = #{skuName} AND a.member_code = #{memberCode} AND a.order_code = #{orderCode} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM business_order a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO business_order( id, cate_id, cate_name, business_id, business_name, sku_id, sku_name, unit_price, num, total_price, member_code, order_code, charging_item_ids, charging_item_names, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{cateId}, #{cateName}, #{businessId}, #{businessName}, #{skuId}, #{skuName}, #{unitPrice}, #{num}, #{totalPrice}, #{memberCode}, #{orderCode}, #{chargingItemIds}, #{chargingItemNames}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE business_order SET cate_id = #{cateId}, cate_name = #{cateName}, business_id = #{businessId}, business_name = #{businessName}, sku_id = #{skuId}, sku_name = #{skuName}, unit_price = #{unitPrice}, num = #{num}, total_price = #{totalPrice}, member_code = #{memberCode}, order_code = #{orderCode}, charging_item_ids = #{chargingItemIds}, charging_item_names = #{chargingItemNames}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE business_order SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} UPDATE business_order SET del_flag = '1' WHERE order_code = #{orderCode}