adjustvalue.jsp

财务说明的管理

<%
/* Copyright 2006-2009 Hexiesoft, Inc. All Rights Reserved.
 * This software is the proprietary information of Hexiesoft, Inc.
 * Use is subject to license terms.
 * Author:sfcll 2006-04
 * Tester:
 *
 * Content:
 * Input Param:
 *
 *
 *
 * Output param:
 *
 */
%>
<%@page contentType="text/html;charset=GBK"%>
<%@ include file="/IncludeBeginMD.jsp"%>
<%
	boolean isSuccess = false;
    String sqlStatement = "";
    String sCode = DataConvert.toRealString(iPostChange,request.getParameter("Code"));
    String strInsurance=DataConvert.toRealString(iPostChange,request.getParameter("Insurance"));
    String strDeclarins=DataConvert.toRealString(iPostChange,request.getParameter("Declarins"));
    float Insurance=Float.parseFloat(strInsurance);
    float Declarins=Float.parseFloat(strDeclarins);
    ASResultSet rs = Sqlca.getASResultSet("select * from invoice where blno = '"+sCode+"'");
    int RowCount = rs.getRowCount();
    if( RowCount == 1  ){
        try{
            sqlStatement = "update invoice set insurance="+Insurance+",declarins="+Declarins+" where blno='"+sCode+"'";
            Sqlca.executeSQL(sqlStatement);
            isSuccess = true;
        }catch(Exception em){
            System.out.println("Error...: "+em.getMessage());
        }
    }
%>

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