a.id AS "id", a.member_code AS "memberCode", a.member_name AS "memberName", a.province AS "province", a.city AS "city", a.area AS "area", a.street AS "street", a.running_number AS "runningNumber", a.phone AS "phone", a.item_name AS "itemName", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.create_date AS "createDate", a.remarks AS "remarks", a.del_flag AS "delFlag", a.create_by AS "createBy.id", a.receiver AS "receiver" , a.postcode AS "postcode", a.express_send_id AS "expressSendId", a.business_table AS "businessTable", a.business_id AS "businessId", a.charge_item_id AS "chargeItemId" SELECT FROM sys_express_queue a WHERE a.id = #{id} SELECT FROM sys_express_queue a a.del_flag = #{DEL_FLAG_NORMAL} AND a.member_code = #{memberCode} AND a.member_name = #{memberName} AND a.province = #{province} AND a.city = #{city} AND a.area = #{area} AND a.item_name = #{itemName} AND a.express_send_id = #{expressSendId} AND (a.express_send_id is NULL OR a.express_send_id = '') AND a.running_number = #{runningNumber} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM sys_express_queue a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO sys_express_queue( id, member_code, member_name, province, city, area, street, running_number, phone, item_name, update_by, update_date, create_date, remarks, del_flag, create_by, receiver, postcode, express_send_id, business_table, business_id, charge_item_id ) VALUES ( #{id}, #{memberCode}, #{memberName}, #{province}, #{city}, #{area}, #{street}, #{runningNumber}, #{phone}, #{itemName}, #{updateBy.id}, #{updateDate}, #{createDate}, #{remarks}, #{delFlag}, #{createBy.id}, #{receiver}, #{postcode}, #{expressSendId}, #{businessTable}, #{businessId}, #{chargeItemId} ) UPDATE sys_express_queue SET member_code = #{memberCode}, member_name = #{memberName}, province = #{province}, city = #{city}, area = #{area}, street = #{street}, running_number = #{runningNumber}, phone = #{phone}, item_name = #{itemName}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, receiver = #{receiver}, postcode = #{postcode}, express_send_id = #{expressSendId}, business_table = #{businessTable}, business_id = #{businessId}, charge_item_id = #{chargeItemId} WHERE id = #{id} DELETE from sys_express_queue WHERE id = #{id} update sys_express_queue set del_flag = '1', update_date = now() business_id = #{id} SELECT FROM sys_express_queue a WHERE a.id in #{item} update sys_express_queue set del_flag = '1', update_date = now() where business_id in #{item}