📄 do.jsp

📁 财务说明的管理
💻 JSP
字号:
<%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2006-11-1
  Time: 16:22:54
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html; charset=GBK" %>
<%@ include file="/IncludeBegin.jsp" %>

<%@ page import="com.hexiesoft.are.sql.ASResultSet" %>
<%@ page import="com.hexiesoft.utils.Consts" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFCell" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFRow" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook" %>
<%@ page import="com.hexiesoft.utils.StringUtils" %>

<%

    String pnno = DataConvert.toRealString(iPostChange, CurPage.getParameter("pnno"));
    String newpnno = DataConvert.toRealString(iPostChange, CurPage.getParameter("newpnno"));
    String snewnet = DataConvert.toRealString(iPostChange, CurPage.getParameter("newnet"));
    float newnet = Float.parseFloat(snewnet);
    String snewlot = DataConvert.toRealString(iPostChange, CurPage.getParameter("newlot"));
    float newlot = Float.parseFloat(snewlot);
    String desc = DataConvert.toRealString(iPostChange, CurPage.getParameter("desc"));
    String name = DataConvert.toRealString(iPostChange, CurPage.getParameter("name"));
    String add1 = DataConvert.toRealString(iPostChange, CurPage.getParameter("add1"));
    String add2 = DataConvert.toRealString(iPostChange, CurPage.getParameter("add2"));

    ASResultSet rs;
    String sql = "update packnote set net=" + newnet + " , [desc]='" + desc + "', name='" + name +"',  add1='" + add1 + "',add2='" + add2 + "' where pnno='" + pnno + "'";
    Sqlca.executeSQL(sql);
    sql="select * from packnote where pnno='"+pnno+"'";
    rs=Sqlca.getASResultSet(sql);
    rs.first();
    sql="insert into packnote  (plant,worksno,blno,pnno,pndate,[desc],mt_gauge,mt_width,custpo,custspec,custprod,account," +
            "subacct,name,add1,add2,gross,coils,standno,standwgt,insertwgt,dividerwgt,ctrno,ctrwgt,paltno," +
            "paltwgt,caseno,casewgt,tare,net,islbs,ordertype,finblno,dpaid,npaid,nvalue,skid)  values('"+rs.getString("plant")+
            "','"+rs.getString("worksno")+"','"+rs.getString("blno")+"','"+newpnno+"','"+rs.getString("pndate")+"','"+rs.getString("desc")+
            "',"+rs.getFloat("mt_gauge")+","+rs.getFloat("mt_width")+",'"+rs.getString("custpo")+"','"+rs.getString("custspec")+
            "','"+rs.getString("custprod")+"','"+rs.getString("account")+"','"+rs.getString("subacct")+"','"+rs.getString("name")+
            "','"+rs.getString("add1")+"','"+rs.getString("add2")+"',"+rs.getFloat("gross")+","+rs.getFloat("coils")+",'"+rs.getString("standno")+
            "',"+rs.getFloat("standwgt")+","+rs.getFloat("insertwgt")+","+rs.getFloat("dividerwgt")+",'"+rs.getString("ctrno")+
            "',"+rs.getFloat("ctrwgt")+",'"+rs.getString("paltno")+"',"+rs.getFloat("paltwgt")+",'"+rs.getString("caseno")+
            "',"+rs.getFloat("casewgt")+","+rs.getFloat("tare")+","+newlot+","+rs.getString("islbs")+",'"+rs.getString("ordertype")+
            "','"+rs.getString("finblno")+"','"+rs.getString("dpaid")+"',"+rs.getFloat("npaid")+","+rs.getFloat("nvalue")+",'"+rs.getString("skid")+"')";
     Sqlca.executeSQL(sql);
%>
<script type="text/javascript">
    alert("success!");
    OpenPage('/Blank.jsp?TextToShow=blank', 'right', '');
    self.close();
</script>
<body>
</body>
<%@ include file="/IncludeEnd.jsp" %>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -