updateord.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 totorder = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("totorder"));
    String premiumpr = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("premiumpr"));
    String metalpr = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("metalpr"));
    String fabpr = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("fabpr"));
    String worksno = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("worksno"));
    String txtInvBLNo = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("txtInvBLNo"));
    String nvalue  = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("nvalue"));

    String sUpdSql = "update ord_item set totorder=" + PrintAddPN.rep0(totorder)
             + "', premiumpr=" + PrintAddPN.rep0(premiumpr)
            + "', fabpr=" + PrintAddPN.rep0(fabpr)
             + "', metalpr=" +  PrintAddPN.rep0(metalpr)

            + " where worksno='" + worksno  + "'";
    String sUpdSql1 = "update packnote set nvalue =" + PrintAddPN.rep0(nvalue)
                          + " where worksno='" + worksno  + "' and blno ='"+txtInvBLNo +"'" ;
    try {
//        Sqlca.conn.setAutoCommit(false);
        Sqlca.executeSQL(sUpdSql);
        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" %>