2017-05-05 17:37
@JFinal sql 语句先奉上. Long stock_count = Db.queryLong("select count(p.stock_state) as stock_count from t_series_rel_product as r LEFT JOIN product_detail as p ON r.sap_code=p.sap_code where r.series_id=? and p.stock_state!=1 ",id); 具体 就是判断 然后修改状态 .