CO代码: //获取当前修改的行 &n
CO代码:
//获取当前修改的行
String rowReference = pageContext.getParameter(OAWEBBeanConstants.EVENT_SOURCE_ROW_REFERENCE);
Serializable[] param ={ rowReference};
am.invokeMethod("checkItemCateGoryExists",param);
AM代码:
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("该物料已存在,请重新输入", OAException.ERROR);
} catch (Exception e) {
throw OAException.wrapperException(e);
} finally {
if (cstmt != null) {
try {
cstmt.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
} //end checkItemCategoryExists()
--结束END--
本文标题: 获取当前修改的行记录数据
本文链接: https://www.lsjlt.com/news/48570.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0