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

手机WAP编程

开发平台:

ASP/ASPX

  1. <!--#Include File="../Inc/Head.Asp"--><%
  2. Private FangWen
  3. Set FangWen=New xkon_FangWen
  4. FangWen.FangWen()
  5. FangWen.Admin_TouXiang()
  6. Set FangWen=Nothing
  7. Private c,s
  8. Set c=New xkon_Response
  9. Set s=New xkon_Request
  10. Private l,ID
  11. l=s.QueryString("l")
  12. ID=s.QueryString_Long("ID")
  13. Private Sub j()
  14. c.Writeln("<form method=""post"" action=""SZ_TouXiang_CaoZuo.Asp?l=j2"">名称:<input name=""mingchen"" />")
  15. c.Writeln("地址:<input name=""dizhi"" />")
  16. c.Writeln("性别:<select name=""XingBie""><option value=""0"">男</option><option value=""1"">女</option></select>")
  17. c.Writeln("金币:<input name=""jingbi"" />")
  18. c.Writeln("需要等级:<input name=""denji"" />")
  19. c.Write("<input type=""submit"" value=""增加"" /></form>")
  20. End Sub
  21. Private Sub j2()
  22. Dim MingChen,DiZhi,XingBie,JingBi,DenJi,J_ID
  23. MingChen=s.Form_Str("MingChen",1,250)
  24. DiZhi=s.Form_Str("DiZhi",4,250)
  25. XingBie=s.Form_Str("XingBie",1,1)
  26. JingBi=s.Form_Long("JingBi")
  27. DenJi=s.Form_Long("DenJi")
  28. If MingChen="" Or DiZhi="" Or JingBi="" Or DenJi="" Then
  29. Call xkon_Error("所有填写项不能为空")
  30. Else
  31. Call OpenData()
  32. Dim Cn1,Cn2
  33. Set Cn1=Server.CreateObject("Adodb.Command")
  34. Cn1.ActiveConnection=Conn
  35. Cn1.CommandType=1
  36. Cn1.CommandText="Select id From TouXiang Order By Id Desc"
  37. Set Cn2=Cn1.Execute
  38. If Cn2.Eof Then
  39. J_ID=1
  40. Else
  41. J_ID=Cn2("ID")+1
  42. End If
  43. Set Cn1=Nothing
  44. Set Cn2=Nothing
  45. Conn.Execute("Insert Into TouXiang(ID,MingChen,DiZhi,XingBie,JingBi,DenJi)values('"&J_ID&"','"&MingChen&"','"&DiZhi&"','"&XingBie&"','"&JingBi&"','"&DenJi&"')")
  46. Call JiLu("增加头像"&J_ID)
  47. Call CloseData()
  48. Response.Write("<script language=javascript>location.href=""SZ_TouXiang.Asp"";</script>")
  49. Response.End()
  50. End If
  51. End Sub
  52. Private Sub b()
  53. Dim Cn1,Cn2
  54. Call OpenData()
  55. Set Cn1=Server.CreateObject("Adodb.Command")
  56. Cn1.ActiveConnection=Conn
  57. Cn1.CommandType=1
  58. Cn1.CommandText="Select * From TouXiang Where ID="&Clng(ID)
  59. Set Cn2=Cn1.Execute
  60. If Cn2.Eof Then
  61. Call xkon_Error("该内容不存在")
  62. Else
  63. c.Writeln("<form method=""post"" action=""SZ_TouXiang_CaoZuo.Asp?l=b2&amp;id="&ID&""">名称:<input name=""mingchen"" value="""&Cn2("MingChen")&""" />")
  64. c.Writeln("地址:<input name=""dizhi"" value="""&Cn2("DiZhi")&""" />")
  65. c.Writeln("性别:<select name=""xingbie"" value="""&Cn2("XingBie")&"""><option value=""0"">男</option><option value=""1"">女</option></select>")
  66. c.Writeln("金币:<input name=""jingbi"" value="""&Cn2("JingBi")&""" />")
  67. c.Writeln("等级:<input name=""denji"" value="""&Cn2("DenJi")&""" />")
  68. c.Write("<input type=""submit"" value=""修改"" /></form>")
  69. End If
  70. Set Cn2=Nothing
  71. Set Cn1=Nothing
  72. Call CloseData()
  73. End Sub
  74. Private Sub b2()
  75. Dim MingChen,DiZhi,XingBie,JingBi,DenJi
  76. MingChen=s.Form_Str("MingChen",1,250)
  77. DiZhi=s.Form_Str("DiZhi",1,250)
  78. XingBie=s.Form_Str("XingBie",1,1)
  79. JingBi=s.Form_Long("JingBi")
  80. DenJi=s.Form_Long("DenJi")
  81. If MingChen="" Or DiZhi="" Or XingBie="" Or JingBi="" Or DenJi="" Then
  82. Call xkon_Error("所有填写项不能为空")
  83. Else
  84. Call OpenData()
  85. Conn.Execute("update TouXiang Set MingChen='"&MingChen&"',DiZhi='"&DiZhi&"',XingBie='"&XingBie&"',JingBi='"&JingBi&"',DenJi='"&DenJi&"' Where ID="&Clng(ID))
  86. Call JiLu("编辑头像"&ID)
  87. Call CloseData()
  88. Response.Write("<script language=javascript>location.href=""SZ_TouXiang.Asp"";</script>")
  89. Response.End()
  90. End If
  91. End Sub
  92. Private Sub Delete()
  93. Call OpenData()
  94. Conn.Execute("Delete From TouXiang Where ID="&Clng(ID))
  95. Call JiLu("删除头像"&ID)
  96. Call CloseData()
  97. Response.Write("<script language=javascript>location.href=""SZ_TouXiang.Asp"";</script>")
  98. Response.End()
  99. End Sub
  100. Call H_Title("头像管理")
  101. Select Case l
  102. Case "j"
  103. Call j()
  104. Case "j2"
  105. Call j2()
  106. Case "b"
  107. Call b()
  108. Case "b2"
  109. Call b2()
  110. Case "s"
  111. Call Delete()
  112. End Select
  113. c.Write("<a href=""SZ_TouXiang.Asp"">返回设置头像</a>")
  114. Call H_End()
  115. Set c=Nothing
  116. Set s=Nothing
  117. %>