/**
* Return Order statuses of Reports
*
* @ejb.interface-method
* @ejb.transaction type="Supports"
*/
public List findOrderStates() throws LocalException {
OrderStatesValue object = null;
String sql =
"select ID,ORDER_STATES,ICC_OR_UP_ISENABLED,MNR_ISENABLED from Order_States_For_Reports";
Connection con = null;
PreparedStatement ps = null;
ResultSet result = null;
List l = new ArrayList();
try {
con = getConnection();
ps = con.prepareStatement(sql);
result = ps.executeQuery();
while (result.next()) {
object = new OrderStatesValue();
object.setId(result.getInt(1));
object.setOrder_states((result.getString(2)));
object.setIcc_or_up_iseditable(result.getBoolean(3));
object.setMnr_iseditable((result.getBoolean(4)));
l.add(object);
}
} catch (Exception e) {
// getLog().warn("####EX:" + e.getMessage());
throw new LocalException(e);
} finally {
closeQuietly(result, ps, con);
}
return l;
}
/**
* @ejb.interface-method
* @ejb.transaction type="Supports"
*/
public OrderStatesValue findByPrimaryKey(PrimaryKey primaryKey) throws LocalException {
OrderStatesPK opk = (OrderStatesPK) primaryKey;
int id = opk.getId();
OrderStatesValue object = null;
String sql =
"select ID,ORDER_STATES,ICC_OR_UP_ISENABLED,MNR_ISENABLED from Order_States_For_Reports where ID=? ";
Connection con = null;
PreparedStatement ps = null;
ResultSet result = null;
try {
con = getConnection();
ps = con.prepareStatement(sql);
ps.setInt(1, id);
result = ps.executeQuery();
if (result.next()) {
object = new OrderStatesValue();
object.setId(result.getInt(1));
object.setOrder_states(result.getString(2));
object.setIcc_or_up_iseditable(result.getBoolean(3));
object.setMnr_iseditable(result.getBoolean(4));
}
} catch (Exception e) {
// getLog().warn("####EX:" + e.getMessage());
throw new LocalException(e);
} finally {
closeQuietly(result, ps, con);
}
return object;
}
/**
* update icc order update report interface statuses
*
* @ejb.interface-method
* @ejb.transaction type="Supports"
*/
public void updateIccOrderStates(OrderStatesValue object) throws LocalException {
String sql = "update Order_States_For_Reports set ICC_OR_UP_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.isIcc_or_up_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);
}
}