Mybatis 代码优化：筛选条件 'isPost' 处理

• 日期: 2028-03-20
• 标签: 常规

SELECT pso.id,pso.create_time,pso.material_document, pso.material_document_item,pso.posting_date,pso.material, p.ProductDescription AS materialName,pso.quantity,pso.unit,pso.batch, pso.goods_movement_type,pso.plant,pso.storage_location, pso.manufacturing_order,pso.is_system_post,pso.is_hand_post FROM pure_silver_order pso LEFT JOIN ods_product p ON p.Product = pso.material WHERE 1=1 AND (pso.is_system_post = 'Y' OR pso.is_hand_post = 'Y') AND pso.is_system_post = 'N' AND pso.is_hand_post = 'N' ORDER BY create_time ASC

原文地址: https://www.cveoy.top/t/topic/dppd 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录