updateroutesoption.jsp

运输模块代码

<%--
  Created by IntelliJ IDEA.
  User: jtgao
  Date: 2006-5-18
  Time: 17:26:40
  To change this template use File | Settings | File Templates.//
--%>
<%@page contentType="text/html;charset=GBK"%>

<%@ include file="/IncludeBeginMD.jsp"%>
<%
	boolean isUpdOk = false;

    String sAccount = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Account"));
    String sSubacct = DataConvert.toRealString(iPostChange, (String) CurPage.getParameter("Subacct"));
    //out.println(sSubacct);

    String sgeocode=DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("geocode"));
    String sgeomiles=DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("geomiles"));
    String sroute=DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("route"));
    String stravel=DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("travel"));
    String slabcopies=DataConvert.toRealString(iPostChange,(String)CurPage.getParameter("labcopies"));




    //Update the table ord_item
    String sSql = "update  customer set geocode='"+sgeocode+"',labcopies="+slabcopies+",geomiles="+sgeomiles+",travel="+stravel+",route='"+sroute+"' where Account='"+sAccount+"' and subacct = '" + sSubacct+"'";
    //out.println(sSql);
    try{
        Sqlca.executeSQL(sSql);
        isUpdOk=true;
    }   catch (Exception e) {
        e.printStackTrace();
        //out.println(e.toString());
        isUpdOk = false;
    }
    //out.println(isUpdOk);




    //isEmpty = !rs.next();
%>
<script language=javascript>
	self.returnValue = "<%=isUpdOk%>";
	self.close();
</script>
<%@ include file="/IncludeEnd.jsp"%>