ShouCang.Asp
资源名称:4.rar [点击查看]
上传用户:zhbanny
上传日期:2020-11-04
资源大小:161k
文件大小:3k
源码类别:

手机WAP编程

开发平台:

ASP/ASPX

  1. <!--#Include File="Inc/xkon.Asp"--><%
  2. Call QuanXian("1",0)
  3. Private c,s
  4. Set c=New xkon_Response
  5. Set s=New xkon_Request
  6. Private Function ShouCang_LieBiao()
  7. Dim ShouCang_LieBiao_Cn1,p,i
  8. p=s.QueryString_Long("p")
  9. Call OpenData()
  10. Set ShouCang_LieBiao_Cn1=Server.CreateObject("Adodb.RecordSet")
  11. ShouCang_LieBiao_Cn1.Open "Select ID,MingChen,DiZhi From ShouCang Where ZhangHao='"&Zi_ZhangHao&"' Order By ID Desc",Conn,1,1
  12. ShouCang_LieBiao_Cn1.PageSize=Const_Page_Ys
  13. If ShouCang_LieBiao_Cn1.Eof Then ShouCang_LieBiao="娌℃湁浠讳綍璁板綍<br/>":ShouCang_LieBiao_Cn1.Close:Set ShouCang_LieBiao_Cn1=Nothing:Call CloseData():Exit Function
  14. ShouCang_LieBiao_Cn1.AbsolutePage=p
  15. For i=1 To Const_Page_Ys
  16. If ShouCang_LieBiao_Cn1.Eof Then Exit For
  17. ShouCang_LieBiao=ShouCang_LieBiao&"<a href="""&ShouCang_LieBiao_Cn1("DiZhi")&""">"&ShouCang_LieBiao_Cn1("MingChen")&"</a>|<a href=""ShouCang?ID="&ShouCang_LieBiao_Cn1("ID")&"{(xkon.cn)閾炬帴}"">鍒犻櫎</a><br/>"
  18. ShouCang_LieBiao_Cn1.MoveNext
  19. Next
  20. ShouCang_LieBiao=ShouCang_LieBiao&CPage(ShouCang_LieBiao_Cn1.PageCount,p,"ShouCang.Asp?n={(xkon.cn)閾炬帴}&amp;")
  21. ShouCang_LieBiao_Cn1.Close
  22. Set ShouCang_LieBiao_Cn1=Nothing
  23. Call CloseData()
  24. End Function
  25. Private Sub Jia()
  26. Dim MingChen,DiZhi,Jia_Cn1,Jia_Cn2,J_ID
  27. MingChen=s.QueryString("MingChen")
  28. DiZhi=s.QueryString("DiZhi")
  29. If DiZhi="" Then Call xkon_Error("鍦板潃涓嶈兘涓虹┖")
  30. Call OpenData()
  31. Set Jia_Cn1=Server.CreateObject("Adodb.Command")
  32. Jia_Cn1.ActiveConnection=Conn
  33. Jia_Cn1.CommandType=1
  34. Jia_Cn1.CommandText="Select ID From ShouCang Order By ID Desc"
  35. Set Jia_Cn2=Jia_Cn1.Execute
  36. If Jia_Cn2.Eof Then
  37. J_ID=1
  38. Else
  39. J_ID=Jia_Cn2("ID")+1
  40. End If
  41. Set Jia_Cn1=Nothing
  42. Set Jia_Cn2=Nothing
  43. Conn.Execute("Insert Into ShouCang(ID,MingChen,DiZhi,ZhangHao)Values('"&J_ID&"','"&MingChen&"','"&DiZhi&"','"&Zi_ZhangHao&"')")
  44. Call CloseData()
  45. Response.Redirect(Replace(xkon_FenXi("ShouCang.Asp?n={(xkon.cn)閾炬帴}"),"&amp;","&"))
  46. End Sub
  47. Private Sub Delete()
  48. Dim ID
  49. ID=s.QueryString_Long("ID")
  50. Call OpenData()
  51. Conn.Execute("Delete From ShouCang Where ID="&ID)
  52. Call CloseData()
  53. Response.Redirect(Replace(xkon_FenXi("ShouCang.Asp?n={(xkon.cn)閾炬帴}"),"&amp;","&"))
  54. End Sub
  55. Call H_Title("鎴戠殑鏀惰棌")
  56. If s.QueryString("ID")<>"" Then Call Delete()
  57. If s.QueryString("MingChen")<>"" Then Call Jia()
  58. c.Write(xkon_FenXi(Replace(Read_Text("ShouCang"),xkon_S("鏀惰棌鍒楄〃"),ShouCang_LieBiao())))
  59. Call H_End()
  60. Set c=Nothing
  61. Set s=Nothing
  62. %>