Shulou(Shulou.com)06/01 Report--

CO Code:

/ / get the currently modified row

String rowReference = pageContext.getParameter (OAWebBeanConstants.EVENT_SOURCE_ROW_REFERENCE)

Serializable [] param = {rowReference}

Am.invokeMethod ("checkItemCategoryExists", param)

AM Code:

Public void checkItemCategoryExists (String rowReference) {

OARow row = (OARow) findRowByRef (rowReference)

If (row! = null) {

OADBTransaction txn = getOADBTransaction ()

CallableStatement cstmt = null

String result

String sq1 =

"BEGIN: = cux_srm_category_pkg.check_item_cat_exists (?,?); END;"

Try {

Cstmt = txn.createCallableStatement (sq1, 1)

Cstmt.registerOutParameter (1, OracleTypes.VARCHAR)

Cstmt.setString (2

Row.getAttribute ("CategorySetId") .toString ()

Cstmt.setString (3

Row.getAttribute ("OrganizationId") .toString ()

Cstmt.setString (4

Row.getAttribute ("InventoryItemId") .toString ()

Cstmt.setString (5

Row.getAttribute ("ItemCategoryId") .toString ()

Cstmt.execute ()

Result = cstmt.getString (1)

If (result.equals ("Y"))

Throw new OAException ("this item already exists, please re-enter", OAException.ERROR)

} catch (Exception e) {

Throw OAException.wrapperException (e)

} finally {

If (cstmt! = null) {

Try {

Cstmt.close ()

} catch (Exception e) {

E.printStackTrace ()

}

}

}

}

} / / end checkItemCategoryExists ()

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.