| | |
| | | * @return |
| | | */ |
| | | public List<OutStockBill> syncOutStock() { |
| | | return erpSqlServer.select("SELECT * FROM xtyasrs_dual.dbo.OutStockBill where Fflag_rw=0", OutStockBill.class); |
| | | // return erpSqlServer.select("SELECT * FROM xtyasrs_dual.dbo.OutStockBill where Fflag_rw=0", OutStockBill.class); |
| | | List<OutStockBill> list = erpSqlServer.select("SELECT * FROM xtyasrs_dual.dbo.OutStockBill where Fflag_rw=0", OutStockBill.class); |
| | | log.info("outStock同步来源:ERP库xtyasrs_dual未读出库单数={}", list != null ? list.size() : 0); |
| | | return list; |
| | | } |
| | | |
| | | /** |
| | |
| | | * @return |
| | | */ |
| | | public List<OutStockBillEntry> syncOutStockDetail(Integer FInterID) { |
| | | // String sql = "SELECT * FROM xtyasrs_dual.dbo.OutStockBillEntry where FSourceBillNo!='' and FAuxCommitQty=0 and FInterID=" + FInterID; |
| | | String sql = "SELECT * FROM xtyasrs_dual.dbo.OutStockBillEntry where FAuxCommitQty=0 and FInterID=" + FInterID; |
| | | return erpSqlServer.select(sql, OutStockBillEntry.class); |
| | | List<OutStockBillEntry> list = erpSqlServer.select(sql, OutStockBillEntry.class); |
| | | log.info("outStock同步来源:ERP出库明细 FInterID={}, 条数={}", FInterID, list != null ? list.size() : 0); |
| | | return list; |
| | | } |
| | | |
| | | /** |