| | |
|---|
| | | |
|---|
| | | |
|---|
| | | <update id="clearDirtyFlowCardData"> |
|---|
| | | update tempering_glass_relation_info |
|---|
| | | set shelf_order = null |
|---|
| | | , state = 0 |
|---|
| | | update hollow_glass_relation_info |
|---|
| | | set glass_id = null, |
|---|
| | | tempering_layout_id = null, |
|---|
| | | tempering_feed_sequence = null, |
|---|
| | | engineer_id = null, |
|---|
| | | state = 0 |
|---|
| | | where flow_card_id = #{flowCardId} |
|---|
| | | and layer = #{layer} |
|---|
| | | and shelf_order not in ( |
|---|
| | | select shelf_order |
|---|
| | | from vertical_sheet_cage_details |
|---|
| | | and glass_id not in ( |
|---|
| | | select glass_id |
|---|
| | | from hollow_big_storage_cage_details |
|---|
| | | where flow_card_id = #{flowCardId} |
|---|
| | | and layer = #{layer} |
|---|
| | | and state in (100, 102, 103, 104) |
|---|
