changeshipmenttodriect.jsp

财务说明的管理

<%--
  Created by IntelliJ IDEA.
  User: RuiLei
  Date: 2006-5-20
  Time: 14:43:23
  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" %>
<%
    String sCode = DataConvert.toRealString(iPostChange, CurPage.getParameter("Code"));

    String promptConfirmChange = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("PROMPT_CONFIRM_CHANGE");
    String submit_change = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("SUBMIT_CHANGE");
    String submit_abort = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("SUBMIT_ABORT");
    String page_code = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("PAGE_CODE");
    String page_name = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("PAGE_NAME");
    String page_billing_address = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("PAGE_BILLING_ADDRESS");
    String page_shipping_address = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("PAGE_SHIPPING_ADDRESS");
    String page_specins = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("PAGE_SPECINS");
    String page_othins = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("PAGE_OTHINS");
    String page_type = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("PAGE_TYPE");
    String page_cust_po = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("PAGE_CUST_PO");
    String page_cust_order_dt = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToDirect").get("PAGE_CUST_ORDER_DT");

    String db_account = Consts.STR_EMPTY;
    String db_subacct = Consts.STR_EMPTY;
    String db_name = Consts.STR_EMPTY;
    String db_bladd1 = Consts.STR_EMPTY;
    String db_bladd2 = Consts.STR_EMPTY;
    String db_blcity = Consts.STR_EMPTY;
    String db_blprovst = Consts.STR_EMPTY;
    String db_blcountry = Consts.STR_EMPTY;
    String db_wname = Consts.STR_EMPTY;
    String db_specinstr = Consts.STR_EMPTY;
    String db_othrinstr = Consts.STR_EMPTY;
    String db_ordertype = Consts.STR_EMPTY;
    String db_custpo = Consts.STR_EMPTY;
    String db_podate = Consts.STR_EMPTY;
    String db_worksno = Consts.STR_EMPTY;
    String db_internal = Consts.STR_EMPTY;
    String db_customer_shadd1 = Consts.STR_EMPTY;
    String db_customer_shadd2 = Consts.STR_EMPTY;
    String db_customer_shcity = Consts.STR_EMPTY;
    String db_customer_shprovst = Consts.STR_EMPTY;
    String db_customer_shcountry = Consts.STR_EMPTY;
    String db_whouse_shadd1 = Consts.STR_EMPTY;
    String db_whouse_shadd2 = Consts.STR_EMPTY;
    String db_whouse_shcity = Consts.STR_EMPTY;
    String db_whouse_shprovst = Consts.STR_EMPTY;
    String db_whouse_shcountry = Consts.STR_EMPTY;
    String db_maddress;
    String db_mcitypcde;
    String db_maddress_covert;
    String db_mcitypcde_covert;

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

    querySql = "select * from customer where account='" + db_account + "' and subacct='" + db_subacct + "'";
    rs = Sqlca.getASResultSet(querySql);
    if (rs != null && rs.next()) {
        if (rs.getString("bladd1") != null) {
            db_bladd1 = rs.getString("bladd1");
        }
        if (rs.getString("bladd2") != null) {
            db_bladd2 = rs.getString("bladd2");
        }
        if (rs.getString("blcity") != null) {
            db_blcity = rs.getString("blcity");
        }
        if (rs.getString("blprovst") != null) {
            db_blprovst = rs.getString("blprovst");
        }
        if (rs.getString("blcountry") != null) {
            db_blcountry = rs.getString("blcountry");
        }
        if (rs.getString("name") != null) {
            db_name = rs.getString("name");
        }
        if (rs.getString("shadd1") != null) {
            db_customer_shadd1 = rs.getString("shadd1");
        }
        if (rs.getString("shadd2") != null) {
            db_customer_shadd2 = rs.getString("shadd2");
        }
        if (rs.getString("shcity") != null) {
            db_customer_shcity = rs.getString("shcity");
        }
        if (rs.getString("shprovst") != null) {
            db_customer_shprovst = rs.getString("shprovst");
        }
        if (rs.getString("shcountry") != null) {
            db_customer_shcountry = rs.getString("shcountry");
        }
    }

    db_maddress = db_bladd1.trim() + "," + db_bladd2.trim();
    db_mcitypcde = db_blcity.trim() + "," + db_blprovst.trim() + "," + db_blcountry.trim();

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

    querySql = "select * from ord_hdr where internal=" + db_internal;
    rs = Sqlca.getASResultSet(querySql);
    if (rs != null && rs.next()) {
        if (rs.getString("ordertype") != null) {
            db_ordertype = rs.getString("ordertype");
        }
        if (rs.getString("specinstr") != null) {
            db_specinstr = rs.getString("specinstr");
        }
        if (rs.getString("othrinstr") != null) {
            db_othrinstr = rs.getString("othrinstr");
        }
        if (rs.getString("custpo") != null) {
            db_custpo = rs.getString("custpo");
        }
        if (rs.getString("podate") != null) {
            db_podate = rs.getString("podate");
        }
    }

    if (db_ordertype.trim().equals(Consts.ORDER_TYPE_REG)) {
        db_maddress_covert = db_customer_shadd1.trim() + "," + db_customer_shadd2.trim();
        db_mcitypcde_covert = db_customer_shcity.trim() + "," + db_customer_shprovst.trim() + "," + db_customer_shcountry.trim();
    } else {
        querySql = "select * from whouse where rtrim(ltrim(wcode))='" + db_ordertype + "'";
        rs = Sqlca.getASResultSet(querySql);
        if (rs != null && rs.next()) {
            if (rs.getString("shadd1") != null) {
                db_whouse_shadd1 = rs.getString("shadd1");
            }
            if (rs.getString("shadd2") != null) {
                db_whouse_shadd2 = rs.getString("shadd2");
            }
            if (rs.getString("shcity") != null) {
                db_whouse_shcity = rs.getString("shcity");
            }
            if (rs.getString("shprovst") != null) {
                db_whouse_shprovst = rs.getString("shprovst");
            }
            if (rs.getString("shcountry") != null) {
                db_whouse_shcountry = rs.getString("shcountry");
            }
            if (rs.getString("wname") != null) {
                db_wname = rs.getString("wname");
            }
        }
        db_maddress_covert = db_whouse_shadd1.trim() + "," + db_whouse_shadd2.trim();
        db_mcitypcde_covert = db_whouse_shcity.trim() + "," + db_whouse_shprovst.trim() + "," + db_whouse_shcountry.trim();
    }
%>
<script language="javascript">
    function changeShipmentToDirect() {
        if (confirm("<%= promptConfirmChange %>")) {
            OpenComp("changeShipmentToDirect", "/Billing/changeShipmentToDirect/ChangeShipmentToDriectDo.jsp", "Code=<%= sCode  %>&rand=" + randomNumber(), "right", "");
        }
    }
</script>
<br>
<br>

<table width="75%" border="1" cellspacing="0" cellpadding="0">
    <tr>
        <td><%=page_code%>:</td>
        <td><input name="account" type="text" id="account" value="<%=db_account + "    " + db_subacct %>" readonly>
        </td>
        <td><%=page_name%>:</td>
        <td><input name="name" type="text" id="name" value="<%=db_name  %>" readonly>
        </td>
    </tr>
    <tr>
        <td colspan="2"><%=page_billing_address%>:</td>
        <% if (db_ordertype.trim().equals(Consts.ORDER_TYPE_REG)) {%>
        <td colspan="2"><%=page_shipping_address%>:</td>
        <%} else { %>
        <td colspan="2"><%=db_wname%>:</td>
        <%} %>
    </tr>
    <tr>
        <td colspan="2"><input name="maddress" type="text" id="maddress" value="<%= db_maddress %>" readonly>
        </td>
        <td colspan="2"><input name="maddress_covert" type="text" id="maddress_covert" value="<%= db_maddress_covert %>"
                               readonly>
        </td>
    </tr>
    <tr>
        <td colspan="2"><input name="mcitypcde" type="text" id="mcitypcde" value="<%= db_mcitypcde %>" readonly>
        </td>
        <td colspan="2"><input name="mcitypcde_covert" type="text" id="mcitypcde_covert"
                               value="<%= db_mcitypcde_covert %>" readonly>
        </td>
    </tr>
    <tr>
        <td><%=page_specins%>:</td>
        <td><input name="specinstr" type="text" id="specinstr" value="<%= db_specinstr %>" readonly>
        </td>
        <td></td>

    </tr>
    <tr>
        <td><%=page_othins%>:</td>
        <td><input name="othrinstr" type="text" id="othrinstr" value="<%= db_othrinstr %>" readonly>
        </td>
        <td><%=page_cust_po%>:</td>
        <td><input name="custpo" type="text" id="custpo" value="<%= db_custpo  %>" readonly>
        </td>
    </tr>
    <tr>
        <td><%=page_type%>:</td>
        <td><input name="ordertype" type="text" id="ordertype" value="<%= db_ordertype %>" readonly>
        </td>
        <td><%=page_cust_order_dt%>:</td>
        <td><input name="podate" type="text" id="podate" value="<%= db_podate  %>" readonly>
        </td>
    </tr>
    <tr>
        <td colspan="4"><input type="button" name="change" value="<%= submit_change %>"
                               onclick="javascript:changeShipmentToDirect()">
            <input name="Abort" type="button" id="Abort" value="<%= submit_abort %>"  onClick="javascript:OpenPage('/Blank.jsp?TextToShow=Please click the list on left','right','');">
        </td>
    </tr>
</table>

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