|
楼主 |
发表于 2012-12-3 20:51:17
|
显示全部楼层
cpuer 发表于 2012-12-3 20:37
比如连接方式
/incs/setup.asp- <%
- if not application("websiteini") then
- conn.open constr
- menuini = ""
- query = "select pt_id,pt_tag,pt_nme from pdttpe where pt_shw=1 order by pt_odr"
- set rs4=server.CreateObject("adodb.recordset")
- set rs3=server.CreateObject("adodb.recordset")
- rs4.Open query, conn, 1, 1
- temppdttpe = ""
- While Not rs4.EOF
- tempclstpe = ""
- ''$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$'
- tempptid = rs4("pt_id")
- query = "select pc_id,pc_nme from v_pdtcls where pc_tid=" & tempptid & " and (pc_shw=1) order by pt_odr,pc_odr"
- rs3.Open query, conn, 1, 1
- While Not rs3.EOF
- temppcnme = Trim(rs3("pc_nme"))
- tempclstpe = tempclstpe & rs3("pc_id") & ":" & temppcnme & ":" & CStr(rs4("pt_id")) & ";"
- rs3.MoveNext
- Wend
- rs3.Close
- If Right(tempclstpe, 1) = ";" Then
- tempclstpe = Left(tempclstpe, Len(tempclstpe) - 1)
- End If
- application("pl_menu_" & rs4("pt_tag"))=split(tempclstpe,";")
- ''$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$'
- tempptnme = Trim(rs4("pt_nme"))
- temppdttpe = temppdttpe & rs4("pt_tag") & ":" & tempptnme & ":" & CStr(rs4("pt_id")) & ";"
- rs4.MoveNext
- Wend
- rs4.Close
- set rs3=nothing
- set rs4=nothing
- If Right(temppdttpe, 1) = ";" Then
- temppdttpe = Left(temppdttpe, Len(temppdttpe) - 1)
- End If
- application("pl_menutpe")=split(temppdttpe,";")
- query="select * from pltcfg"
- set rs3=server.CreateObject("adodb.recordset")
- rs3.open query,conn,3,1
- if not rs3.eof then
- application("pl_prccnt")=rs3("pl_prccnt")
- application("pl_modid")=rs3("pl_modid")
- application("pl_modadr")=rs3("pl_modadr")
- application("pl_agtsys")=rs3("pl_agtsys")
- application("pl_modrot")=trim(rs3("pl_modadr"))&"/webmod"&rs3("pl_modid")
- application("pl_hst_freedme")=trim(rs3("pl_hst_freedme"))
- application("pl_stetag")=trim(rs3("pl_stetag"))
- application("pl_stenme")=trim(rs3("pl_stenme"))
- application("pl_steurl")=trim(rs3("pl_steurl"))
- application("pl_usrnme")=trim(rs3("pl_usrnme"))
- application("pl_usrnme_gst")=trim(rs3("pl_usrnme_gst"))
- application("pl_usrpss_gst")=trim(rs3("pl_usrpss_gst"))
- application("pl_dftprc")=trim(rs3("pl_dftprc"))
- application("pl_dftpwr")=trim(rs3("pl_dftpwr"))
- application("pl_dmectr_url")=trim(rs3("pl_dmectr_url"))
- application("pl_hstctr_url")=trim(rs3("pl_hstctr_url"))
- application("pl_ftpctr_url")=trim(rs3("pl_ftpctr_url"))
- application("pl_emlctr_url")=trim(rs3("pl_emlctr_url"))
- application("pl_sqlctr_url")=trim(rs3("pl_sqlctr_url"))
- application("pl_pay_url")=trim(rs3("pl_pay_url"))
- application("pl_onlpay_url")=trim(rs3("pl_onlpay_url"))
- application("pl_copnme_cn")=trim(rs3("pl_copnme_cn"))
- application("pl_copnme_en")=trim(rs3("pl_copnme_en"))
- application("pl_adr_cn")=trim(rs3("pl_adr_cn"))
- application("pl_cde")=trim(rs3("pl_cde"))
- application("pl_emlask")=trim(rs3("pl_emlask"))
- application("pl_emlfnc")=trim(rs3("pl_emlfnc"))
- application("pl_emlsup")=trim(rs3("pl_emlsup"))
- application("pl_emljob")=trim(rs3("pl_emljob"))
- application("pl_tel_lng")=trim(rs3("pl_tel_lng"))
- application("pl_tel_sht")=trim(rs3("pl_tel_sht"))
- application("pl_fax")=trim(rs3("pl_fax"))
- application("pl_oicq")=trim(rs3("pl_oicq"))
- application("pl_emlsvr")=trim(rs3("pl_emlsvr"))
- application("pl_emlath")=trim(rs3("pl_emlath"))
- application("pl_emlmbx")=trim(rs3("pl_emlmbx"))
- application("pl_emlpss")=trim(rs3("pl_emlpss"))
- application("pl_emlnme")=trim(rs3("pl_emlnme"))
- application("pl_ifsecnum")=trim(rs3("pl_ifsecnum"))
- application("pl_newifcrd")=trim(rs3("pl_newifcrd"))
- application("pl_newifcfm")=trim(rs3("pl_newifcfm"))
- application("pl_emlsgl")=trim(rs3("pl_emlsgl"))
- application("pl_usrnme_sys")=trim(rs3("pl_usrnme_sys"))
- application("pl_tstcnt")=trim(rs3("pl_tstcnt"))
- end if
- rs3.close
- query="select pl_ipsfttms,pl_iphrdtms,pl_ipsftday,pl_ifuse,pl_atornw_day from atosys"
- rs3.open query,conn,3,1
- if not rs3.eof then
- application("pl_ipsfttms")=trim(rs3("pl_ipsfttms"))
- application("pl_iphrdtms")=trim(rs3("pl_iphrdtms"))
- application("pl_ipsftday")=trim(rs3("pl_ipsftday"))
- application("pl_ifuse")=trim(rs3("pl_ifuse"))
- application("pl_atornw_day")=trim(rs3("pl_atornw_day"))
- end if
- rs3.close
- set rs3=nothing
- conn.close
- application("websiteini")=true
- if instr(application("pl_onlpay_url"),"//") then
- pl_onlpay_url_2=right(application("pl_onlpay_url"),len(application("pl_onlpay_url"))-(instr(application("pl_onlpay_url"),"//")+1))
- pl_onlpay_url_2=right(pl_onlpay_url_2,len(pl_onlpay_url_2)-instr(pl_onlpay_url_2,"/")+1)
- application("pl_onlpay_url_2")=pl_onlpay_url_2
- end if
- end if
- '################################################################################
- %>
复制代码 |
|