| src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/java/com/nanometer/smartlab/dao/SysReagentDao.xml
@@ -386,13 +386,15 @@ sr.safetynum, sr.name, sr.main_metering, sr.productSn, sr.cas, bm1.meta_value reagent_unit, bm2.meta_value reagent_type, bm3.meta_value reagent_format, bm4.meta_value product_home, ss.meta_value as product_home_name, bm.meta_value as control_products_name, supplier.name as supplierName bm.meta_value as control_products_name, supplier.name as supplierName from sys_reagent as sr left join base_meta as ss on sr.product_home = ss.id left join base_meta bm on bm.id = sr.control_products
