📄 domark.jsp

📁 财务说明的管理
💻 JSP
字号:
<%--  Created by IntelliJ IDEA.  User: Administrator  Date: 2006-10-31  Time: 12:12:04  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 blno = DataConvert.toRealString(iPostChange, CurPage.getParameter("blno"));    String sSubtot = DataConvert.toRealString(iPostChange, CurPage.getParameter("subtot"));    String sinvgst = DataConvert.toRealString(iPostChange, CurPage.getParameter("invgst"));    String sdeclared = DataConvert.toRealString(iPostChange, CurPage.getParameter("declared"));    String sinvamt = DataConvert.toRealString(iPostChange, CurPage.getParameter("invamt"));    String sinvdate = DataConvert.toRealString(iPostChange, CurPage.getParameter("invdate"));    String sprepaid = DataConvert.toRealString(iPostChange, CurPage.getParameter("prepaid"));    String scollect = DataConvert.toRealString(iPostChange, CurPage.getParameter("collect"));    String sotherfees = DataConvert.toRealString(iPostChange, CurPage.getParameter("otherfees"));    String reason1;    String reason2;    reason1 = DataConvert.toRealString(iPostChange, CurPage.getParameter("reason1"));    reason2 = DataConvert.toRealString(iPostChange, CurPage.getParameter("reason2"));    String glacct = DataConvert.toRealString(iPostChange, CurPage.getParameter("glacct"));    String ssundry = DataConvert.toRealString(iPostChange, CurPage.getParameter("sundry"));    String sunreason1;    String sunreason2;    sunreason1 = DataConvert.toRealString(iPostChange, CurPage.getParameter("sunreason1"));    sunreason2 = DataConvert.toRealString(iPostChange, CurPage.getParameter("sunreason2"));    String sfreight = DataConvert.toRealString(iPostChange, CurPage.getParameter("freight"));    float subtot = Float.parseFloat(sSubtot);    float invgst = Float.parseFloat(sinvgst);    float declared = Float.parseFloat(sdeclared);    float invamt = Float.parseFloat(sinvamt);    float collect = Float.parseFloat(scollect);    if (sotherfees == null || sotherfees.equals("")) {        sotherfees = "0";    }    float otherfees = Float.parseFloat(sotherfees);    if (ssundry == null || ssundry.equals("")) {        ssundry = "0";    }    float sundry = Float.parseFloat(ssundry);    float freight = Float.parseFloat(sfreight);    float prepaid = Float.parseFloat(sprepaid);    String sql = "update invoice set subtot=" + subtot + " , invgst=" + invgst + ", declared=" + declared +            ",  invamt=" + invamt + ",collect=" + collect + ",otherfees=" + otherfees + " ,sundry=" + sundry +            " ,freight=" + freight + " ,prepaid=" + prepaid + ",invdate='" + sinvdate + "',reason1='" + reason1 + "'" +            " ,reason2='" + reason2 + "' ,sunreason1='" + sunreason1 + "' ,sunreason2='" + sunreason2 + "'" +            " ,glacct='" + glacct + "'  where blno='" + blno + "'";    Sqlca.executeSQL(sql);%><script type="text/javascript">    alert("success!");    OpenPage('/Blank.jsp?TextToShow=please click on the right...', 'right', '');    self.close();</script><body></body><%@ include file="/IncludeEnd.jsp" %>
⌨️ 快捷键说明

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