changeshipmenttowarehousedo.jsp

财务说明的管理

<%--
  Created by IntelliJ IDEA.
  User: RuiLei
  Date: 2006-5-21
  Time: 20:35:59
  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 wCode = DataConvert.toRealString(iPostChange, CurPage.getParameter("wCode"));
    String alertConfirmChangeAnother = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").get("PROMPT_CHANGE_DONE");
    String alertErrorWrongOperation = (String) Configure.getConfigure(sIe_Language, "BillingChangeShipmentToWarehouse").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 whouse_wname = Consts.STR_EMPTY;
    String whouse_shadd1 = Consts.STR_EMPTY;
    String whouse_shadd2 = Consts.STR_EMPTY;
    String whouse_shcity = Consts.STR_EMPTY;
    String whouse_shprovst = Consts.STR_EMPTY;
    String whouse_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");
        }
    }

    querySql = "select * from whouse where wcode='" + wCode + "'";
    rs = Sqlca.getASResultSet(querySql);
    if (rs != null && rs.next()) {
        if (rs.getString("wname") != null) {
            whouse_wname = rs.getString("wname");
        }
        if (rs.getString("shadd1") != null) {
            whouse_shadd1 = rs.getString("shadd1");
        }
        if (rs.getString("shadd2") != null) {
            whouse_shadd2 = rs.getString("shadd2");
        }
        if (rs.getString("shcity") != null) {
            whouse_shcity = rs.getString("shcity");
        }
        if (rs.getString("shprovst") != null) {
            whouse_shprovst = rs.getString("shprovst");
        }
        if (rs.getString("shcountry") != null) {
            whouse_shcountry = rs.getString("shcountry");
        }
    }
    String add1 = whouse_shadd1.trim() + whouse_shadd2.trim();
    String add2 = whouse_shcity.trim() + whouse_shprovst.trim() + whouse_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='" + wCode + "',";
    changeSql += " name='" + whouse_wname + "',";
    changeSql += " add1='" + add1 + "',";
    changeSql += " add2='" + add2 + "' ";
    changeSql += " where blno='" + sCode + "'";
    Sqlca.executeSQL(changeSql);

    changeSql = "update ord_hdr set ";
    changeSql += " ordertype='" + wCode + "' ";
    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='" + wCode + "',";
    changeSql += " name='" + whouse_wname + "',";
    changeSql += " add1='" + add1 + "',";
    changeSql += " add2='" + add2 + "' ";
    changeSql += " where blno='" + sCode + "'";
    Sqlca.executeSQL(changeSql);

    Sqlca.conn.commit();
%>
<script language="javascript">
    if (confirm('<%= alertConfirmChangeAnother %>')) {
        sReturnValue = PopPage("/Billing/changeShipmentToWarehouse/EnterCode.jsp", "", "dialogWidth=30;dialogHeight=10;center:yes;status:no;statusbar:no");
        self.close();
    }
</script>

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