HashMap hm;
hm=insChequeRetunrProcDbPkg(appM,comp_code,unit_code,tender_cntrl_no,payment_amt,empl_code,empl_id,
cheque_Return_chg,loginUser,CommonCode.getClientIpAddress());
System.out.println("Err No="+hm.get("ErrNo"));
BigDecimal errNo=(BigDecimal)hm.get("ErrNo");
=====================
public HashMap insChequeRetunrProcDbPkg(AppModuleAMImpl appM, String compCode, String unitCode,
BigDecimal tenderCntrlNo,BigDecimal payAmt,
String emplCode, BigDecimal emplId,Double retCharges,
String loginUser,String ipAddress) {
System.out.println("Ins_Cheque from pos_ins_cheque_pkg ");
String sqlproc2 =
"{call Pos_Ins_Account_Trans_Pkg.Ins_cheque_return(?,?,?,?,sysdate,?,?,?,?,?,?,?)}";
CallableStatement sqlProcStmt2 = appM.getDBTransaction().createCallableStatement(sqlproc2, 0);
BigDecimal bigDecimalZero = new BigDecimal(0.0);
HashMap hm = new HashMap<String, Object>();
try {
System.out.println("inside try");
sqlProcStmt2.setString(1, compCode);
sqlProcStmt2.setString(2, unitCode);
sqlProcStmt2.setBigDecimal(3, tenderCntrlNo);
sqlProcStmt2.setBigDecimal(4, payAmt);
sqlProcStmt2.setString(5, emplCode);
System.out.println("after 5");
System.out.println("compCode=" + compCode + " unitCode=" + unitCode + " tenderCntrlNo=" + tenderCntrlNo +
" payAmt=" + payAmt + " emplCode=" + emplCode);
sqlProcStmt2.setBigDecimal(6, emplId);
sqlProcStmt2.setDouble(7, retCharges);
sqlProcStmt2.setString(8, loginUser);
sqlProcStmt2.setString(9, ipAddress);
System.out.println("after 9");
System.out.println("emplId=" + emplId + " retCharges=" + retCharges
+ " loginUser=" + loginUser+"ipAddress: "+ipAddress);
sqlProcStmt2.registerOutParameter(10, Types.INTEGER);
sqlProcStmt2.registerOutParameter(11, Types.VARCHAR);
System.out.println(" before execute");
System.out.println("before proc execute");
sqlProcStmt2.execute();
System.out.println("after proc execute");
bigDecimalZero = sqlProcStmt2.getBigDecimal(10);
String errMsg= sqlProcStmt2.getString(11);
System.out.println("after getting errno");
hm.put("ErrNo", bigDecimalZero);
hm.put("ErrMsg",errMsg);
} catch (SQLException e) {
System.out.println(e.getMessage());
}
return hm;
}
hm=insChequeRetunrProcDbPkg(appM,comp_code,unit_code,tender_cntrl_no,payment_amt,empl_code,empl_id,
cheque_Return_chg,loginUser,CommonCode.getClientIpAddress());
System.out.println("Err No="+hm.get("ErrNo"));
BigDecimal errNo=(BigDecimal)hm.get("ErrNo");
=====================
public HashMap insChequeRetunrProcDbPkg(AppModuleAMImpl appM, String compCode, String unitCode,
BigDecimal tenderCntrlNo,BigDecimal payAmt,
String emplCode, BigDecimal emplId,Double retCharges,
String loginUser,String ipAddress) {
System.out.println("Ins_Cheque from pos_ins_cheque_pkg ");
String sqlproc2 =
"{call Pos_Ins_Account_Trans_Pkg.Ins_cheque_return(?,?,?,?,sysdate,?,?,?,?,?,?,?)}";
CallableStatement sqlProcStmt2 = appM.getDBTransaction().createCallableStatement(sqlproc2, 0);
BigDecimal bigDecimalZero = new BigDecimal(0.0);
HashMap hm = new HashMap<String, Object>();
try {
System.out.println("inside try");
sqlProcStmt2.setString(1, compCode);
sqlProcStmt2.setString(2, unitCode);
sqlProcStmt2.setBigDecimal(3, tenderCntrlNo);
sqlProcStmt2.setBigDecimal(4, payAmt);
sqlProcStmt2.setString(5, emplCode);
System.out.println("after 5");
System.out.println("compCode=" + compCode + " unitCode=" + unitCode + " tenderCntrlNo=" + tenderCntrlNo +
" payAmt=" + payAmt + " emplCode=" + emplCode);
sqlProcStmt2.setBigDecimal(6, emplId);
sqlProcStmt2.setDouble(7, retCharges);
sqlProcStmt2.setString(8, loginUser);
sqlProcStmt2.setString(9, ipAddress);
System.out.println("after 9");
System.out.println("emplId=" + emplId + " retCharges=" + retCharges
+ " loginUser=" + loginUser+"ipAddress: "+ipAddress);
sqlProcStmt2.registerOutParameter(10, Types.INTEGER);
sqlProcStmt2.registerOutParameter(11, Types.VARCHAR);
System.out.println(" before execute");
System.out.println("before proc execute");
sqlProcStmt2.execute();
System.out.println("after proc execute");
bigDecimalZero = sqlProcStmt2.getBigDecimal(10);
String errMsg= sqlProcStmt2.getString(11);
System.out.println("after getting errno");
hm.put("ErrNo", bigDecimalZero);
hm.put("ErrMsg",errMsg);
} catch (SQLException e) {
System.out.println(e.getMessage());
}
return hm;
}
No comments:
Post a Comment