@Override
public ResultMessage updateOrderPO(OrderPO order) throws RemoteException {
// TODO Auto-generated method stub
String sql =
"update orderpo set receivetime='"
+ order.getReceivetime()
+ "', timeOfsend='"
+ order.getTimeOfSend()
+ "', dueOfReceive='"
+ order.getDueOfReceive()
+ "', nameOfCourier='"
+ order.getNameOfCourier()
+ "', DocumentCondition='"
+ order.getdCondition()
+ ", Receiver=?,sender=?,bill=?,goods=? where orderNumber='"
+ order.getOrdernumber()
+ "';";
try {
Helper.pStatement = Helper.conn.prepareStatement(sql);
Helper.pStatement.setObject(1, IOObject.toByteArray(order.getReceiver()));
Helper.pStatement.setObject(2, IOObject.toByteArray(order.getSender()));
Helper.pStatement.setObject(3, IOObject.toByteArray(order.getBill()));
Helper.pStatement.setObject(4, IOObject.toByteArray(order.getGoods()));
Helper.pStatement.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return ResultMessage.FAIL;
}
return ResultMessage.SUCCESS;
}
@Override
public ResultMessage insertOrderPO(OrderPO order) {
// TODO Auto-generated method stub
String sql =
"insert into orderpo values(?,?,?,?,'"
+ order.getTimeOfSend()
+ "','"
+ order.getDueOfReceive()
+ "','"
+ order.getOrdernumber()
+ "','"
+ order.getNameOfCourier()
+ "','"
+ order.getReceivetime()
+ "','"
+ order.getdCondition()
+ "');";
try {
Helper.pStatement = Helper.conn.prepareStatement(sql);
Helper.pStatement.setObject(1, IOObject.toByteArray(order.getReceiver()));
Helper.pStatement.setObject(2, IOObject.toByteArray(order.getSender()));
Helper.pStatement.setObject(3, IOObject.toByteArray(order.getBill()));
Helper.pStatement.setObject(4, IOObject.toByteArray(order.getGoods()));
Helper.pStatement.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return ResultMessage.FAIL;
}
return ResultMessage.SUCCESS;
}
@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;
}
