docancel.jsp

财务说明的管理

<%@ page contentType="text/html;charset=GBK" %>
<%@ include file="/IncludeBegin.jsp" %>

<%
    //先从URL取得参数
    String blno = DataConvert.toRealString(iPostChange, CurPage.getParameter("blno"));
    String reason = DataConvert.toRealString(iPostChange, CurPage.getParameter("reason"));
    String failed_operation = (String) Configure.getConfigure(sIe_Language, "Common").get("FAILED_OPERATION");

    String cancelSql = "delete from invoice where blno = '" + blno + "'";

    int count1 = Sqlca.executeSQL(cancelSql);
    cancelSql = "update packnote set finblno='" + blno + "' where finblno='" + blno + "'";
    int count2 = Sqlca.executeSQL(cancelSql);
    cancelSql = "delete from shipment where blno = '" + blno + "'";
    int count3 = Sqlca.executeSQL(cancelSql);
    if (count1 > 0 || count2 > 0 || count3 > 0) {
%>
<script language="javascript">
    if (confirm('删除成功！')) {
        parent.OpenPage("/Blank.jsp?TextToShow=删除操作成功", "right", "");
    }
</script>
<%
} else {
%>
<script language="javascript">
    alert('<%= failed_operation %>');
    parent.OpenPage("/Blank.jsp?TextToShow=<%=failed_operation%>", "right", "");
</script>
<%
    }
%>

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