do.jsp

来自「财务说明的管理」· JSP 代码 · 共 36 行

<%@ page contentType="text/html;charset=GBK" %>
<%@ include file="/IncludeBegin.jsp" %>
<%@ page import="com.hexiesoft.utils.Consts" %>
<%@ page import="java.util.Date" %>
<%
    //先从URL取得参数
    String alertConfirmChangeAnother = (String) Configure.getConfigure(sIe_Language, "BillingMatchBrokerInvoices").get("SUCCESS");
    String blno = DataConvert.toRealString(iPostChange, CurPage.getParameter("blno"));
    String nchoice = DataConvert.toRealString(iPostChange, CurPage.getParameter("nchoice"));
    String brokerage = DataConvert.toRealString(iPostChange, CurPage.getParameter("brokerage"));
    String duty = DataConvert.toRealString(iPostChange, CurPage.getParameter("duty"));
    String brokerinv = DataConvert.toRealString(iPostChange, CurPage.getParameter("brokerinv"));
    Date date = new Date();
    SimpleDateFormat df=new  SimpleDateFormat("yyy-MM-dd");
    String today=df.format(date);
    System.out.println("$$$$"+blno+"%"+nchoice+"%"+brokerage+"%"+duty+"%"+brokerinv);
    int dutyaccpac = 1;
    if ("2".equals(nchoice)) {
        dutyaccpac = 0;
    }
    String sql = "update invoice set duty=" + duty + ",brokerage="+brokerage+", dutyapprov=" + nchoice + ",dutydate='" + today + "',brokerinv='" + brokerinv + "',dutyaccpac=" + dutyaccpac + " where blno='" + blno + "'";
    Sqlca.executeSQL(sql);

    Sqlca.conn.commit();
%>
<script language="javascript">
    if (confirm('<%= alertConfirmChangeAnother %>')) {
        sReturnValue = PopPage("/Billing/MatchBrokerInvoices/setQuery.jsp", "", "dialogWidth=30;dialogHeight=8;center:yes;status:no;statusbar:no");
        self.close();
    }
    else{
        OpenPage('/Blank.jsp?TextToShow=please click on right', 'right', '');
    }
</script>

<%@ include file="/IncludeEnd.jsp" %>