public static Integer getStock(String strdate, Long orgId, Long productId){
if(strdate==null||orgId==null||productId==null)
throw new IllegalArgumentException();
Integer stock = null;
//DataAccess da = DataAccessFactory.create(BPMConstant.ERP_DATABASE);
Connection conn=null;
CallableStatement fun = null;
try {
String callSQL = "{?=call getstock(?,?,?)} ";
//Connection conn = da.getConnection();
conn=DBUtil.getConnection(BPMConstant.ERP_DATABASE);
fun = conn.prepareCall(callSQL);
fun.registerOutParameter(1, oracle.jdbc.OracleTypes.NUMBER);
fun.setString(2, strdate);
fun.setLong(3, orgId);
fun.setLong(4, productId);
fun.execute();
stock = fun.getInt(1);
}catch(Exception e){
e.printStackTrace();
}finally{
DBUtil.closeCallableStatement(fun);
DBUtil.closeConnection(conn);
}
return stock;