changeshipmenttowarehouse.jsp

财务说明的管理

<%--
  Created by IntelliJ IDEA.
  User: RuiLei
  Date: 2006-5-21
  Time: 20:35:38
  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" %>
<%@ page import="com.hexiesoft.utils.StringUtils" %>
<%
    String sCode = DataConvert.toRealString(iPostChange, CurPage.getParameter("Code"));
    String ordertype = DataConvert.toRealString(iPostChange, CurPage.getParameter("sWarehouseCode"));

    String promptConfirmChange = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("PROMPT_CONFIRM_CHANGE");
    String submit_change = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("SUBMIT_CHANGE");
    String submit_abort = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("SUBMIT_ABORT");
    String page_code = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("PAGE_CODE");
    String page_name = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("PAGE_NAME");
    String page_billing_address = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("PAGE_BILLING_ADDRESS");
    String page_shipping_address = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("PAGE_SHIPPING_ADDRESS");
    String page_specins = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("PAGE_SPECINS");
    String page_othins = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("PAGE_OTHINS");
    String page_type = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("PAGE_TYPE");
    String page_cust_po = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("PAGE_CUST_PO");
    String page_cust_order_dt = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").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_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 hdr_ordertype = "REG";
    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()) {
        hdr_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 (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))='" + 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 changeShipmentToWarehouse() {
        if (confirm("<%= promptConfirmChange %>")) {
            OpenComp("changeShipmentToWarehouse", "/Billing/changeShipmentToWarehouse/ChangeShipmentToWarehouseDo.jsp", "Code=<%= sCode  %>&wCode=<%=ordertype%>&rand=" + randomNumber(), "right", "");
        }
    }
</script>
<br>
<br>

<table width="75%" border="1" cellspacing="0" cellpadding="0">
    <tr>
        <td><%=page_code%>:</td>
        <td><%=db_account + "    " + db_subacct %>
        </td>
        <td><%=page_name%>:</td>
        <td><%=db_name  %>
        </td>
    </tr>
    <tr>
        <td colspan="2"><%=page_billing_address%>:</td>
        <% if (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"><%= db_maddress %>
        </td>
        <td colspan="2"><%= db_maddress_covert %>

        </td>
    </tr>
    <tr>
        <td colspan="2"><%= db_mcitypcde %>
        </td>
        <td colspan="2"><%= db_mcitypcde_covert %>
        </td>
    </tr>
    <tr>
        <td><%=page_specins%>:</td>
        <td><%= db_specinstr %>
        </td>
        <td></td>

    </tr>
    <tr>
        <td><%=page_othins%>:</td>
        <td><%= db_othrinstr %>
        </td>
        <td><%=page_cust_po%>:</td>
        <td><%= db_custpo  %>
        </td>
    </tr>
    <tr>
        <td><%=page_type%>:</td>
        <td><%= hdr_ordertype %>
        </td>
        <td><%=page_cust_order_dt%>:</td>
        <td><%= StringUtils.to_Date(db_podate)%>
        </td>
    </tr>
    <tr>
         <TD colspan="4"><input type="button" name="next"
                               value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("SUBMIT")%>"
                               onclick="javascript:changeShipmentToWarehouse();"
                               style="font-size:9pt;padding-top:3;padding-left:5;padding-right:5;background-image:url(../../Resources/functionbg.gif); border: #DCDCDC;  border-style: outset; border-top-width: 1px; border-right-width: 1px;  border-bottom-width: 1px; border-left-width: 1px"
                               border='1'
                >
            <input type="button" name="Cancel"
                   value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("CANCEL")%>"
                   onClick="javascript:OpenPage('/Blank.jsp?TextToShow=please click on right', 'right','');"
                   style="font-size:9pt;padding-top:3;padding-left:5;padding-right:5;background-image:url(../../Resources/functionbg.gif); border: #DCDCDC;  border-style: outset; border-top-width: 1px; border-right-width: 1px;  border-bottom-width: 1px; border-left-width: 1px"
                   border='1'>
        
    </tr>
</table>

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