updatelast.jsp

财务说明的管理

<%--
  Created by IntelliJ IDEA.
  User: jtgao
  Date: 2006-5-26
  Time: 11:57:45
  To change this template use File | Settings | File Templates.//
--%>
<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="com.hexiesoft.utils.PrintAddPN" %>
<%@ include file="/IncludeBeginMD.jsp" %>

<%
    String strpnno = null;

    String Carrier = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Carrier"));
    String Broker = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Broker"));
    String FrghtFrwd = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("FrghtFrwd"));
    String coils = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("coils"));
 String gross = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("gross"));
   String Customer = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Customer"));
     String invextend = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("invextend"));
    String txtInvBLNo = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("txtInvBLNo"));
    String duty  = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("duty"));

    String sUpdSql1 = "update invoice set duty =" + PrintAddPN.rep0(duty)
            + " and Broker="+ PrintAddPN.rep0(Broker)
             + " and Carrier="+ PrintAddPN.rep0(Carrier)
             + " and forward="+ PrintAddPN.rep0(FrghtFrwd)
             + " and coils="+ PrintAddPN.rep0(coils)
              + " and name="+ PrintAddPN.rep0(Customer)
             + " and gross="+ PrintAddPN.rep0(gross)
             + " and invextend="+ PrintAddPN.rep0(invextend)
                          + " where  blno ='"+txtInvBLNo +"'" ;
    try {
//        Sqlca.conn.setAutoCommit(false);

        Sqlca.executeSQL(sUpdSql1);


       Sqlca.conn.commit();
    } catch (Exception e) {
        e.printStackTrace();
        Sqlca.conn.rollback();
        out.println(e.toString());
        strpnno = null;
   }

%>
<script language=javascript>
    self.returnValue = "<%=strpnno%>";
    self.close();
</script>
<%@ include file="/IncludeEnd.jsp" %>