changeshipmenttodriectdo.jsp

财务说明的管理

<%--
  Created by IntelliJ IDEA.
  User: RuiLei
  Date: 2006-5-20
  Time: 14:43:48
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=GBK" %>
<%@ include file="/IncludeBegin.jsp" %>
<%@ page import="com.hexiesoft.utils.Consts" %>
<%
    //先从URL取得参数
    String sCode = DataConvert.toRealString(iPostChange, CurPage.getParameter("Code"));
    String alertConfirmChangeAnother = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("PROMPT_CHANGE_DONE");
    String alertErrorWrongOperation = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("ERROR_WRONG_OPERATION");

    if (sCode == null || sCode.length() == 0) {
%>
<script language="javascript">
    alert('<%= alertErrorWrongOperation %>');

</script>
<%
        return;
    }


    String worksno = Consts.STR_EMPTY;
    String internal = Consts.STR_EMPTY;
    String account = Consts.STR_EMPTY;
    String subacct = Consts.STR_EMPTY;
    String customer_name = Consts.STR_EMPTY;
    String customer_shadd1 = Consts.STR_EMPTY;
    String customer_shadd2 = Consts.STR_EMPTY;
    String customer_shcity = Consts.STR_EMPTY;
    String customer_shprovst = Consts.STR_EMPTY;
    String customer_shcountry = Consts.STR_EMPTY;

    String querySql = "select * from shipment where rtrim(blno) = '" + sCode + "'";
    ASResultSet rs = Sqlca.getASResultSet(querySql);
    if (rs != null && rs.next()) {
        if (rs.getString("worksno") != null) {
            worksno = rs.getString("worksno");
        }
        if (rs.getString("account") != null) {
            account = rs.getString("account");
        }
        if (rs.getString("subacct") != null) {
            subacct = rs.getString("subacct");
        }
    }

    querySql = "select * from customer where account='" + account + "' and subacct='" + subacct + "'";
    rs = Sqlca.getASResultSet(querySql);
    if (rs != null && rs.next()) {
        if (rs.getString("name") != null) {
            customer_name = rs.getString("name");
        }
        if (rs.getString("shadd1") != null) {
            customer_shadd1 = rs.getString("shadd1");
        }
        if (rs.getString("shadd2") != null) {
            customer_shadd2 = rs.getString("shadd2");
        }
        if (rs.getString("shcity") != null) {
            customer_shcity = rs.getString("shcity");
        }
        if (rs.getString("shprovst") != null) {
            customer_shprovst = rs.getString("shprovst");
        }
        if (rs.getString("shcountry") != null) {
            customer_shcountry = rs.getString("shcountry");
        }
    }
    String add1 = customer_shadd1.trim() + customer_shadd2.trim();
    String add2 = customer_shcity.trim() + customer_shprovst.trim() + customer_shcountry.trim();

    querySql = "select * from ord_item where worksno = " + worksno;
    rs = Sqlca.getASResultSet(querySql);
    if (rs != null && rs.next()) {
        if (rs.getString("internal") != null) {
            internal = rs.getString("internal");
        }
    }

    Sqlca.conn.setAutoCommit(false);

    String changeSql = "update shipment set ";
    changeSql += " ordertype='" + Consts.ORDER_TYPE_REG + "',";
    changeSql += " name='" + customer_name + "',";
    changeSql += " add1='" + add1 + "',";
    changeSql += " add2='" + add2 + "' ";
    changeSql += " where blno='" + sCode + "'";
    Sqlca.executeSQL(changeSql);

    changeSql = "update ord_hdr set ";
    changeSql += " ordertype='" + Consts.ORDER_TYPE_REG + "' ";
    changeSql += " where internal=" + internal;
    Sqlca.executeSQL(changeSql);

    changeSql = "update invoice set ";
    changeSql += " shadd1='" + add1 + "',";
    changeSql += " shadd2='" + add2 + "' ";
    changeSql += " where blno='" + sCode + "'";
    Sqlca.executeSQL(changeSql);

    changeSql = "update packnote set ";
    changeSql += " ordertype='" + Consts.ORDER_TYPE_REG + "',";
    changeSql += " name='" + customer_name + "',";
    changeSql += " add1='" + add1 + "',";
    changeSql += " add2='" + add2 + "' ";
    changeSql += " where blno='" + sCode + "'";    
    Sqlca.executeSQL(changeSql);

    Sqlca.conn.commit();
%>
<script language="javascript">
    if (confirm('<%= alertConfirmChangeAnother %>')) {
        OpenComp("ExistOrder", "/Billing/changeShipmentToDirect/EnterCode.jsp", "rand=" + randomNumber(), "right", "");        
    }
</script>

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