| | |
| | | * 新增 VoucherDetail 表 |
| | | */ |
| | | public boolean insertVoucherDetail(VoucherDetail voucherDetail){ |
| | | String sql = "update VoucherDetail set LastUpdatedDate = ''{1}'' where VoucherID = ''{0}''"; |
| | | sql = MessageFormat.format(sql, voucherID, DateUtils.convert(new Date())); |
| | | String sql = "insert [VoucherDetail] ([VoucherID], [Barcode], [PickID], [LastUpdatedDate]) values (''{0}'', ''{1}'', ''{2}'', ''{3}'');"; |
| | | sql = MessageFormat.format(sql |
| | | , voucherDetail.getVoucherID() |
| | | , voucherDetail.getBarcode() |
| | | , voucherDetail.getPickID() |
| | | , voucherDetail.getLastUpdatedDate()); |
| | | return erpSqlServer.update(sql) > 0; |
| | | } |
| | | |