updateship.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 FrghtFrwd = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("FrghtFrwd"));
    String Exitpt = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Exitpt"));
    String Broker = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Broker"));
    String Carrier = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Carrier"));
    String Customer = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Customer"));
    String ExitFreight = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("ExitFreight"));
    String txtInvBLNo = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("txtInvBLNo"));


    String sUpdSql = "update shipment set broker=" + PrintAddPN.rep0(Broker)
            + ",carrier= " + PrintAddPN.rep0(Carrier)
            + ", customer='" +  Customer
            + "', ExitFreight=" + PrintAddPN.rep0(ExitFreight)

            + ", Exitpt='" +  Exitpt
            + "', FrghtFrwd=" +  PrintAddPN.rep0(FrghtFrwd)

            + " where blno='" + txtInvBLNo  + "'";


    try {
//        Sqlca.conn.setAutoCommit(false);
        Sqlca.executeSQL(sUpdSql);


       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" %>