<%@page contentType="text/html;charset=utf-8" import="java.sql.*,java.util.*,jerehnet.jsp.database.*,jerehnet.jsp.util.*,java.text.SimpleDateFormat,java.util.regex.Matcher,java.util.regex.Pattern"%> <% PoolManager pool = new PoolManager(); if (pool == null) { pool = new PoolManager(); } DataManager db = new DataManager(); String maptypeSelect = Common.getFormatPara(request.getParameter("maptype")); String productCataSelect = Common.getFormatPara(request.getParameter("pro")); String provinceSelect = Common.getFormatPara(request.getParameter("province")); String searchContent = Common.getFormatPara(request.getParameter("keywords")); if(maptypeSelect.trim().equals("制造基地")){ maptypeSelect="1"; }else if(maptypeSelect.trim().equals("销售|代理商网点")){ maptypeSelect="2"; }else if(maptypeSelect.trim().equals("服务网点")){ maptypeSelect="3"; } Connection conn = null; ResultSet maptype = null; ResultSet proCata = null; ResultSet provinces = null; ResultSet areaNation = null; ResultSet network = null; try { conn = pool.getConnection(); //调取网点类别信息 maptype = db.executeQuery(conn,"select keyv,name from jrcms_param where no = '101015' and is_show = '1' order by orderno,id"); //调取产品类别信息 proCata = db.executeQuery(conn," select * from jrcms_website_channel where website_no='20150623163145344' and parent_no='20150623172454151' and is_show=1 order by orderno"); //调取省份信息 provinces = db.executeQuery(conn," select no,name from jrcms_province where is_show = 1 order by no asc,id"); //调取国家区域信息 areaNation = db.executeQuery(conn," select distinct code from jrcms_network where place!='0' and website_no='20150619082201914' "); //调取网点信息 network = db.executeQuery(conn," select * from jrcms_network where website_no='20150619082201914' and channel_node='20150619091848390' and is_show=1 order by orderno desc"); %> 销售/服务网点_服务_天津奥特泵业

您当前的位置： 首页 > 服务 > 销售/服务网点

服务
解决方案
技术支持
常见问题
资料下载
移动社交
在线投稿
产品配件
配件订购
销售/服务网点

销售/服务网点

全球营销网点查询：
请选择产品类别
请选择产品类别 <%while(proCata!=null&&proCata.next()){%> " > <%=Common.getFormatStr(proCata.getString("name"))%> <%if(Common.getFormatStr(proCata.getString("name")).equals(productCataSelect)){%> <%}}%>
请选择区域
请选择区域 <%while(provinces!=null&&provinces.next()){%> " > <%=Common.getFormatStr(provinces.getString("name"))%> <%if(!provinceSelect.equals("")&&Common.getFormatStr(provinces.getString("name")).indexOf(provinceSelect)>=0){%> <%}}%>
请选择网点类型
请选择网点类型 <%while(maptype!=null && maptype.next()){%> " > <%=Common.getFormatStr(maptype.getString("name"))%> <%if(Common.getFormatStr(maptype.getString("keyv")).equals(maptypeSelect)){%> <%}}%>
搜索
<% maptype.beforeFirst(); while(maptype!=null &&maptype.next()){%> "><%=Common.getFormatStr(maptype.getString("name"))%><%}%>
  • 国家
  • 地区
  • 名称
    温馨提示：

    想更便捷地了解产品？联系我们时遇到问题？请提交在线产品订购，相关人员将在半小时内为您服务。

    关联信息推荐
    <% } catch (Exception e) { out.println(e); e.printStackTrace(); } finally { pool.freeConnection(conn); } %>