select order_sn,(case when (order_state = 0 ) then '已取消' when (order_state = 10 ) then '待发货' else order_state end) as 'order_state' from shop_order