|
- <%@ language=vbscript codepage="65001" %>
- <!--#include file="conn.asp"-->
- <!--#include file="function.asp"-->
- <%
- Response.Charset = "UTF-8"
-
- c_prodcode = deal_str_beforesql(request("prodcode"))
- c_rtn = ""
-
- csql = "SP_GET_CIRCUITRY_DETAIL '" & c_prodcode & "'"
- set rs=conn.execute(csql)
- if not rs.eof then
- c_rtn = c_rtn & "{""code"":""0"",""info"":"""",""openid"":""" & request.cookies("m_openid") & """," & vbcrlf
- c_rtn = c_rtn & " ""show_type"":""" & rs("circuitry_type") & """," & vbcrlf
- c_rtn = c_rtn & " ""prod_img"":""" & rs("bimg") & """," & vbcrlf
- c_rtn = c_rtn & " ""prod_name"":""" & rs("prod_name") & """," & vbcrlf
- c_rtn = c_rtn & " ""start_area"":""" & rs("start_area") & """," & vbcrlf
- c_rtn = c_rtn & " ""end_area"":""" & rs("end_area") & """," & vbcrlf
- c_rtn = c_rtn & " ""price"":""" & rs("price") & """," & vbcrlf
- c_rtn = c_rtn & " ""run_info"":""" & rs("go_run_info") & """," & vbcrlf
- c_rtn = c_rtn & " ""back_run_info"":""" & rs("back_run_info") & """," & vbcrlf
- c_rtn = c_rtn & " ""run_count"":""" & rs("run_count") & """," & vbcrlf
- c_rtn = c_rtn & " ""direction"":""" & rs("direction") & """," & vbcrlf
- c_rtn = c_rtn & " ""if_bus"":""" & rs("if_bus") & """," & vbcrlf
- c_rtn = c_rtn & " ""if_hotel"":""" & rs("if_hotel") & """," & vbcrlf
- c_rtn = c_rtn & " ""if_sightspot"":""" & rs("if_sightspot") & """," & vbcrlf
- c_rtn = c_rtn & " ""run_days"":""" & rs("run_days") & """," & vbcrlf
- c_rtn = c_rtn & " ""circuitry_intro"":""" & rs("Description") & """," & vbcrlf
- c_rtn = c_rtn & " ""station_intro"":""" & rs("Description2") & """," & vbcrlf
- c_rtn = c_rtn & " ""price_intro"":""" & rs("Description3") & """," & vbcrlf
- c_rtn = c_rtn & " ""hotel_intro"":""" & rs("hotel_intro") & """," & vbcrlf
- c_rtn = c_rtn & " ""park_intro"":""" & rs("park_intro") & """," & vbcrlf
- c_rtn = c_rtn & " ""show_intro"":""" & rs("show_intro") & """," & vbcrlf
- c_rtn = c_rtn & " ""cir_img"":""" & rs("circuitry_img") & """," & vbcrlf
- c_rtn = c_rtn & " ""refund_intro"":""" & rs("refund_intro") & """," & vbcrlf
-
- if c_prodcode = "NSPTSM01" then
- csql1 = "SP_GET_CIRCUITRY_FIRST_RUN_INFO 3435,'" & c_prodcode & "'"
- 'response.write csql1
- set rs1=conn.execute(csql1)
- if not rs1.eof then
- c_rtn = c_rtn & " ""f_runid"":""" & rs1("run_id") & """," & vbcrlf
- c_rtn = c_rtn & " ""f_godate"":""" & rs1("go_date") & """," & vbcrlf
- c_rtn = c_rtn & " ""f_gotime"":""" & rs1("go_time") & """," & vbcrlf
- c_rtn = c_rtn & " ""f_backdate"":""" & rs1("back_date") & """," & vbcrlf
- c_rtn = c_rtn & " ""f_backtime"":""" & rs1("back_time") & """," & vbcrlf
- end if
- rs1.close
- end if
- c_rtn = c_rtn & " ""bus_list"":["
- c_rtn = c_rtn & " {""bus_code"":""123"",""bus_title"":""德国尼奥普兰"",""bus_img"":""img/bus001.jpg"",""bus_info"":""电动座椅,半躺坐姿,视野宽阔,头等舱的享受""}"
- c_rtn = c_rtn & " ],"
- c_rtn = c_rtn & " ""recommand_list"":[]"
- ' c_rtn = c_rtn & " ""recommand_list"":["
- ' c_rtn = c_rtn & " {"
- ' c_rtn = c_rtn & " ""recommand_type_id"":""1"","
- ' c_rtn = c_rtn & " ""recommand_type_name"":""推荐船票"","
- ' c_rtn = c_rtn & " ""recoomand_prod_list"":["
- ' c_rtn = c_rtn & " {"
- ' c_rtn = c_rtn & " ""re_prod_code"":""abc"","
- ' c_rtn = c_rtn & " ""re_prod_img"":""prod_img/004.jpg"","
- ' c_rtn = c_rtn & " ""re_prod_title"":""不肯去观音号"","
- ' c_rtn = c_rtn & " ""re_prod_price"":""560"""
- ' c_rtn = c_rtn & " },"
- ' c_rtn = c_rtn & " {"
- ' c_rtn = c_rtn & " ""re_prod_code"":""abd"","
- ' c_rtn = c_rtn & " ""re_prod_img"":""prod_img/005.jpg"","
- ' c_rtn = c_rtn & " ""re_prod_title"":""嵊泗号"","
- ' c_rtn = c_rtn & " ""re_prod_price"":""430"""
- ' c_rtn = c_rtn & " }"
- ' c_rtn = c_rtn & " ]"
- ' c_rtn = c_rtn & " },"
- ' c_rtn = c_rtn & " {"
- ' c_rtn = c_rtn & " ""recommand_type_id"":""2"","
- ' c_rtn = c_rtn & " ""recommand_type_name"":""推荐酒店"","
- ' c_rtn = c_rtn & " ""recoomand_prod_list"":["
- ' c_rtn = c_rtn & " {"
- ' c_rtn = c_rtn & " ""re_prod_code"":""abe"","
- ' c_rtn = c_rtn & " ""re_prod_img"":""prod_img/006.jpg"","
- ' c_rtn = c_rtn & " ""re_prod_title"":""宾馆名称1"","
- ' c_rtn = c_rtn & " ""re_prod_price"":""900"""
- ' c_rtn = c_rtn & " },"
- ' c_rtn = c_rtn & " {"
- ' c_rtn = c_rtn & " ""re_prod_code"":""abf"","
- ' c_rtn = c_rtn & " ""re_prod_img"":""prod_img/007.jpg"","
- ' c_rtn = c_rtn & " ""re_prod_title"":""宾馆名称2"","
- ' c_rtn = c_rtn & " ""re_prod_price"":""2000"""
- ' c_rtn = c_rtn & " }"
- ' c_rtn = c_rtn & " ]"
- ' c_rtn = c_rtn & " },"
- ' c_rtn = c_rtn & " {"
- ' c_rtn = c_rtn & " ""recommand_type_id"":""3"","
- ' c_rtn = c_rtn & " ""recommand_type_name"":""推荐门票"","
- ' c_rtn = c_rtn & " ""recoomand_prod_list"":["
- ' c_rtn = c_rtn & " {"
- ' c_rtn = c_rtn & " ""re_prod_code"":""acc"","
- ' c_rtn = c_rtn & " ""re_prod_img"":""prod_img/008.jpg"","
- ' c_rtn = c_rtn & " ""re_prod_title"":""普济寺门票"","
- ' c_rtn = c_rtn & " ""re_prod_price"":""5"""
- ' c_rtn = c_rtn & " },"
- ' c_rtn = c_rtn & " {"
- ' c_rtn = c_rtn & " ""re_prod_code"":""aec"","
- ' c_rtn = c_rtn & " ""re_prod_img"":""prod_img/009.jpg"","
- ' c_rtn = c_rtn & " ""re_prod_title"":""南海观音门票"","
- ' c_rtn = c_rtn & " ""re_prod_price"":""6"""
- ' c_rtn = c_rtn & " }"
- ' c_rtn = c_rtn & " ]"
- ' c_rtn = c_rtn & " }"
- ' c_rtn = c_rtn & " ]"
- c_rtn = c_rtn & "}"
-
- else
- c_rtn = "{""code"":""998"",""info"":""查无信息""}"
- end if
- rs.close
-
- response.write c_rtn
- %>
|