@Override
public ResultMessage updateReceiptsPO(ReceiptsPO receipts) throws RemoteException {
// TODO Auto-generated method stub
ResultMessage resultMessage = deleteReceiptsPO(receipts.getDate(), receipts.getCourier());
if (resultMessage.equals(ResultMessage.FAIL)) return ResultMessage.FAIL;
else return insertReceiptsPO(receipts);
}
@Override
public ResultMessage insertReceiptsPO(ReceiptsPO receipts) {
// TODO Auto-generated method stub
String sql =
"insert into receiptspo values('"
+ receipts.getDate()
+ "',"
+ receipts.getFee()
+ ",'"
+ receipts.getCourier()
+ "',?,'"
+ receipts.getOffice()
+ "','"
+ receipts.getdCondition()
+ "');";
try {
Helper.pStatement = Helper.conn.prepareStatement(sql);
Helper.pStatement.setObject(1, IOObject.toByteArray(receipts.getOrdernumbers()));
Helper.pStatement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
return ResultMessage.FAIL;
}
return ResultMessage.SUCCESS;
}
