/**
* update MNR report interface statuses
*
* @ejb.interface-method
* @ejb.transaction type="Supports"
*/
public void updateMnrOrderStates(OrderStatesValue object) throws LocalException {
String sql = "update Order_States_For_Reports set MNR_ISENABLED=? where ORDER_STATES=?";
Connection con = null;
PreparedStatement ps = null;
ResultSet result = null;
int i;
try {
con = getConnection();
ps = con.prepareStatement(sql);
ps.setBoolean(1, object.isMnr_iseditable());
ps.setString(2, object.getOrder_states());
i = ps.executeUpdate();
} catch (Exception e) {
// getLog().warn("####EX:" + e.getMessage());
throw new LocalException(e);
} finally {
closeQuietly(result, ps, con);
}
}
