savestand.jsp

运输模块代码

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

<%
    //先从URL取得参数
    String sCode = DataConvert.toRealString(iPostChange, CurPage.getParameter("Code"));
    String weight = DataConvert.toRealString(iPostChange, CurPage.getParameter("weight"));
    String blno = DataConvert.toRealString(iPostChange, CurPage.getParameter("blno"));
    String shipdt = DataConvert.toRealString(iPostChange, CurPage.getParameter("shipdt"));
    String account = DataConvert.toRealString(iPostChange, CurPage.getParameter("account"));
    String subacct = DataConvert.toRealString(iPostChange, CurPage.getParameter("subacct"));
    String worksno = DataConvert.toRealString(iPostChange, CurPage.getParameter("worksno"));

    String alert1 = (String) Configure.getConfigure(sIe_Language,"Shipping_IM").get("ERROR_WRONG_OPERATION");
    String alert2 = (String) Configure.getConfigure(sIe_Language,"Shipping_IM").get("ERROR_CUSTOMER_NOT_FOUND");
    String alert3 = (String) Configure.getConfigure(sIe_Language,"Shipping_IM").get("CONFIRM_EDIT_ANOTHER");
    if (sCode == null || sCode.length() == 0 || weight == null || weight.length() == 0) {
%>
<script language="javascript">
    alert('<%= alert1 %>');

</script>
<%
        return;
    }

    //检查account和subaccount是否存在
    ASResultSet customerRS = Sqlca.getASResultSet("select top 1 * from customer where account='"+account+"' and subacct='"+subacct+"'");
    if (customerRS==null || !customerRS.next()){
        //没有找到customer记录
        %>
    <script language="javascript">
        alert('<%=alert2%>');
        OpenComp("ExitStands","/ShippingManager/InventoryMaintenance/editStand/editStand.jsp","Code="+<%= sCode %>+"&rand="+randomNumber(),"right","");
    </script>
<%
        return;
    }
    String editSql = "update stands set ";
     editSql+= "standwgt="+weight;
      editSql+=",blno='"+blno+"'";
      if (shipdt!=null && shipdt.length()>0){
     editSql+=",shipdt='"+shipdt+"'";
     } else {
       editSql+=",shipdt=null";
     }
     editSql+=",account='"+account+"'";
     editSql+=",subacct='"+subacct+"'";
     editSql+=",worksno='"+worksno+"'";
     editSql+=" where rtrim(standno) = '"+sCode+"'";

    System.out.println("editSql = " + editSql);
    int count = Sqlca.executeSQL(editSql);
    if (count > 0) {
%>
<script language="javascript">
    if (confirm('<%=alert3%>')) {
        sReturn_isEmpty = PopPage("/ShippingManager/InventoryMaintenance/editStand/EnterCode.jsp?rand=" + randomNumber(),"","dialogWidth=30;dialogHeight=8;center:yes;status:no;statusbar:no");
    } else {
    OpenComp("ExitStands","/Blank.jsp","rand="+randomNumber(),"right","");
    }


</script>
<%
    }


%>


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