}   // end if (listItemid.intValue() == intToken)

            }   // end while (itr.hasNext())

          }   // end while (st.hasMoreTokens())

          orderForm.setJurisdictionVec(taxJurisdiction);

          orderForm.setItemLines(itemLines);

        }   // end if (newItemID != null)

       

        request.setAttribute("orderform",orderForm);

        request.setAttribute("ItemLines",orderForm.getItemLines());

              }

            }

          }

          orderForm.setJurisdictionVec(taxJurisdiction);

          orderForm.setItemLines(itemLines);

        }

      }

      request.setAttribute("orderform",orderForm);

    CVDal dl = new CVDal(ds);

    try

    {

      ItemLines itemLines =  invoiceVO.getItemLines();

      dl.setSql("invoice.addinvoice");

      dl.setInt(1,invoiceVO.getOrderId()); //orderID

      dl.setInt(2,invoiceVO.getBillToId());//billaddress

      dl.setInt(3,invoiceVO.getShipToId());//shipaddress

      dl.setInt(4,invoiceVO.getStatusId()); // statusid

      CVDal dl = new CVDal(this.dataSource);

      try

      {

        ItemLines itemLines =  invoiceVO.getItemLines();

        dl.setSql("invoice.updateinvoice");

        dl.setInt(1,this.invoiceVO.getBillToId());//bill address

        dl.setInt(2,this.invoiceVO.getShipToId()); //ship address

        dl.setInt(3,this.invoiceVO.getStatusId());// status

    CVDal dl = new CVDal(ds);

    try

    {

      ItemLines itemLines =  purchaseorderVO.getItemLines();

      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

      CVDal dl = new CVDal(this.dataSource);

      try

      {

        ItemLines itemLines =  purchaseorderVO.getItemLines();

        dl.setSql("purchaseorder.updatepurchaseorder");

        dl.setInt(1,this.purchaseorderVO.getBillToId());//bill address

        dl.setInt(2,this.purchaseorderVO.getShipToId()); //ship address

        dl.setInt(3,this.purchaseorderVO.getStatusId());// status

    try

    {

      ItemLines itemLines =  expenseVO.getItemLines();

      cvdal.setSql("account.expense.addexpense");

      cvdal.setInt(1,expenseVO.getGlAccountIDValue());

      cvdal.setFloat(2,expenseVO.getAmount());

      cvdal.setString(3,expenseVO.getTitle());

      cvdal.setString(4,expenseVO.getExpenseDescription());

    this.dataSource = ds;

    CVDal dl = new CVDal(ds);

    try {

      ItemLines itemLines = orderForm.getItemLines();

      dl.setSql("order.addorder");

      // insert into cvorder

      // (entityid,billaddress,shipaddress,status,terms,accountmgr,project,ponumber,creator,orderdate,created,subtotal,tax,total,description,invoiceIsGenerated)

      // values (?,?,?,?,?,?,?,?,?,?,concat(CURRENT_DATE,

      CVDal dl = new CVDal(dataSource);

      try

      {

        ItemLines itemLines =  expenseVO.getItemLines();

        dl.setSql("account.expense.updateexpense");

        //ALLSQL.put("account.expense.updateexpense","update expense set glaccountsid = ?,amount = ?,title = ?,description = ?,entityid = ?,status = ?,created = CONCAT(CURRENT_DATE),owner = ?,project = ?,opportunity = ?,ticket = ? where expenseid = ?");

        dl.setInt(1,expenseVO.getGlAccountIDValue());

        dl.setFloat(2,expenseVO.getAmount());

    if (isDirty) {

      CVDal dl = new CVDal(this.dataSource);

      try {

        ItemLines itemLines = orderForm.getItemLines();

        dl.setSql("order.updateorder");

        dl.setInt(1, this.orderForm.getCustomerIdValue()); // entityid

        dl.setInt(2, this.orderForm.getBillToAddIdValue());// bill address

        dl.setInt(3, this.orderForm.getShipToAddIdValue()); // ship address