this.dataSource = ds;
CVDal dl = new CVDal(ds);
try
{
ItemLines itemLines = purchaseorderVO.getItemLines();
itemLines.calculate();
dl.setSql("purchaseorder.addpurchaseorder");
dl.setInt(1,purchaseorderVO.getBillToId());//billaddress
dl.setInt(2,purchaseorderVO.getShipToId());//shipaddress
dl.setInt(3,purchaseorderVO.getStatusId()); // statusid
dl.setInt(4,purchaseorderVO.getTermId());// termid