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

手机WAP编程

开发平台:

ASP/ASPX

  1. <!--#Include File="../Inc/Head.Asp"--><%
  2. Private FangWen
  3. Set FangWen=New xkon_FangWen
  4. FangWen.FangWen()
  5. FangWen.HuiYuan()
  6. Set FangWen=Nothing
  7. Private c,s
  8. Set c=New xkon_Response
  9. Set s=New xkon_Request
  10. Private Sub x()
  11. Dim Cn1,Cn2,SQL
  12. SQL="Select * From ZhangHao Where ID="&ID
  13. Call OpenData()
  14. Set Cn1=Server.CreateObject("Adodb.Command")
  15. Cn1.ActiveConnection=Conn
  16. Cn1.CommandType=1
  17. Cn1.CommandText=SQL
  18. Set Cn2=Cn1.Execute
  19. If Cn2.Eof Then
  20. Call xkon_Error("该会员不存在")
  21. Else
  22. Dim ZhangHao,MiMa,BiaoShi,NiChen,XingBie,NianLin,GeRenSuoMing,JingBi,ZhuCeShiJian,ZuiHouDenLuShiJian,ZuiHouDenLuIP,ZhuangTai,ShouJiHao,XingMing,ShengFenZhengHao,FuZhi,ZiShu,JiBie,JingYan,YeShu,SuoDing,ZuiHouDenLuDiQu
  23. ZhangHao=Cn2("ZhangHao")
  24. MiMa=Cn2("MiMa")
  25. BiaoShi=Cn2("BiaoShi")
  26. NiChen=Cn2("NiChen")
  27. XingBie=Cn2("XingBie")
  28. NianLin=Cn2("NianLin")
  29. GeRenSuoMing=Cn2("GeRenSuoMing")
  30. JingBi=Cn2("JingBi")
  31. ZhuCeShiJian=Cn2("ZhuCeShiJian")
  32. ZuiHouDenLuShiJian=Cn2("ZuiHouDenLuShiJian")
  33. ZuiHouDenLuIP=Cn2("ZuiHouDenLuIP")
  34. ZuiHouDenLuDiQu=Cn2("ZuiHouDenLuDiQu")
  35. ZhuangTai=Cn2("ZhuangTai")
  36. ShouJiHao=Cn2("ShouJiHao")
  37. XingMing=Cn2("XingMing")
  38. ShengFenZhengHao=Cn2("ShengFenZhengHao")
  39. FuZhi=Cn2("FuZhi")
  40. ZiShu=Cn2("ZiShu")
  41. JiBie=Cn2("JiBie")
  42. JingYan=Cn2("JingYan")
  43. YeShu=Cn2("YeShu")
  44. SuoDing=Cn2("SuoDing")
  45. End If
  46. Set Cn2=Nothing
  47. Set Cn1=Nothing
  48. Call CloseData()
  49. c.Writeln("ID:"&ID)
  50. c.Writeln("账号:"&ZhangHao)
  51. c.Writeln("密码:"&MiMa)
  52. c.Writeln("标识:"&BiaoShi)
  53. c.Writeln("昵称:"&NiChen)
  54. c.Writeln("性别:"&XingBieed(XingBie))
  55. c.Writeln("年龄:"&NianLin)
  56. c.Writeln("个人说明:"&GeRenSuoMing)
  57. c.Writeln("金币:"&JingBi)
  58. c.Writeln("注册时间:"&ZhuCeShiJian)
  59. c.Writeln("最后登陆时间:"&ZuiHouDenLuShiJian)
  60. c.Writeln("最后登陆IP:"&ZuiHouDenLuIP)
  61. c.Writeln("最后登陆地区:"&ZuiHouDenLuDiQu)
  62. c.Writeln("会员状态:"&ZhuangTai)
  63. c.Writeln("手机号:"&ShouJiHao)
  64. c.Writeln("姓名:"&XingMing)
  65. c.Writeln("身份证号:"&ShengFenZhengHao)
  66. c.Writeln("复制板:"&FuZhi)
  67. c.Writeln("字数设置:"&ZiShu)
  68. c.Writeln("级别:"&JiBie)
  69. c.Writeln("经验:"&JingYan)
  70. c.Writeln("记录数:"&YeShu)
  71. c.Writeln("是否锁定:"&SuoDing)
  72. End Sub
  73. Private Sub b()
  74. Dim Cn1,Cn2,SQL
  75. SQL="Select * From ZhangHao Where ID="&ID
  76. Call OpenData()
  77. Set Cn1=Server.CreateObject("Adodb.Command")
  78. Cn1.ActiveConnection=Conn
  79. Cn1.CommandType=1
  80. Cn1.CommandText=SQL
  81. Set Cn2=Cn1.Execute
  82. If Cn2.Eof Then
  83. Call xkon_Error("该会员不存在")
  84. Else
  85. Dim ZhangHao,MiMa,BiaoShi,NiChen,XingBie,NianLin,GeRenSuoMing,JingBi,ZhuCeShiJian,ZuiHouDenLuShiJian,ZuiHouDenLuIP,ZhuangTai,ShouJiHao,XingMing,ShengFenZhengHao,FuZhi,ZiShu,JiBie,JingYan,YeShu,SuoDing,ZuiHouDenLuDiQu
  86. ZhangHao=Cn2("ZhangHao")
  87. MiMa=Cn2("MiMa")
  88. BiaoShi=Cn2("BiaoShi")
  89. NiChen=Cn2("NiChen")
  90. XingBie=Cn2("XingBie")
  91. NianLin=Cn2("NianLin")
  92. GeRenSuoMing=Cn2("GeRenSuoMing")
  93. JingBi=Cn2("JingBi")
  94. ZhuCeShiJian=Cn2("ZhuCeShiJian")
  95. ZuiHouDenLuShiJian=Cn2("ZuiHouDenLuShiJian")
  96. ZuiHouDenLuIP=Cn2("ZuiHouDenLuIP")
  97. ZuiHouDenLuDiQu=Cn2("ZuiHouDenLuDiQu")
  98. ZhuangTai=Cn2("ZhuangTai")
  99. ShouJiHao=Cn2("ShouJiHao")
  100. XingMing=Cn2("XingMing")
  101. ShengFenZhengHao=Cn2("ShengFenZhengHao")
  102. FuZhi=Cn2("FuZhi")
  103. ZiShu=Cn2("ZiShu")
  104. JiBie=Cn2("JiBie")
  105. JingYan=Cn2("JingYan")
  106. YeShu=Cn2("YeShu")
  107. SuoDing=Cn2("SuoDing")
  108. End If
  109. Set Cn2=Nothing
  110. Set Cn1=Nothing
  111. Call CloseData()
  112. c.Writeln("ID:"&ID)
  113. c.Writeln("<form method=""post"" action=""HuiYuan_CaoZuo.Asp?l=b2"">")
  114. c.Writeln("账号:<input type=""text"" name=""ZhangHao"" value="""&ZhangHao&""" />")
  115. c.Writeln("密码:<input type=""text"" name=""MiMa"" value="""&MiMa&""" />")
  116. c.Writeln("标识:<input type=""text"" name=""BiaoShi"" value="""&BiaoShi&""" />")
  117. c.Writeln("昵称:<input type=""text"" name=""NiChen"" value="""&NiChen&""" />")
  118. c.Writeln("性别:<Select name=""XingBie"" ><option value=""1"" "&Selected("1",XingBie)&">女</option><option value=""0"" "&Selected("0",XingBie)&">男</option></select>")
  119. c.Writeln("年龄:<input type=""text"" name=""NianLin"" value="""&NianLin&""" />")
  120. c.Writeln("个人说明:<input type=""text"" name=""GeRenSuoMing"" value="""&GeRenSuoMing&""" />")
  121. c.Writeln("金币:<input type=""text"" name=""JingBi"" value="""&JingBi&""" />")
  122. c.Writeln("注册时间:"&ZhuCeShiJian)
  123. c.Writeln("最后登陆时间:"&ZuiHouDenLuShiJian)
  124. c.Writeln("最后登陆IP:"&ZuiHouDenLuIP)
  125. c.Writeln("最后登陆地区:<input type=""text="" name=""ZuiHouDenLuDiQu"" value="""&ZuiHouDenLuDiQu&""" />")
  126. c.Writeln("会员状态:<select name=""ZhuangTai""><option value=""1"" "&Selected("1",ZhuangTai)&">正式会员</option><option value=""2"" "&Selected("1",ZhuangTai)&">特殊会员</option><option value=""0"" "&Selected("1",ZhuangTai)&">待审会员</option></select>")
  127. c.Writeln("手机号:<input type=""text"" name=""ShouJiHao"" value="""&ShouJiHao&""" />")
  128. c.Writeln("姓名:<input type=""text"" name=""XingMing"" value="""&XingMing&""" />")
  129. c.Writeln("身份证号:<input type=""text"" name=""ShengFenZhengHao"" value="""&ShengFenZhengHao&""" />")
  130. c.Writeln("复制板:<input type=""text"" name=""FuZhi"" value="""&FuZhi&""" />")
  131. c.Writeln("字数设置:<input type=""text"" name=""ZiShu"" value="""&ZiShu&""" />")
  132. c.Writeln("级别:<input type=""text"" name=""JiBie"" value="""&JiBie&""" />")
  133. c.Writeln("经验:<input type=""text"" name=""JingYan"" value="""&JingYan&""" />")
  134. c.Writeln("记录数:<input type=""text"" name=""YeShu"" value="""&YeShu&""" />")
  135. c.Writeln("是否锁定:<select name=""SuoDing""><option value=""0"" "&Selected("0",SuoDing)&">否</option><option value=""1"" "&Selected("1",SuoDing)&">是</option></select>")
  136. c.Write("<input type=""submit"" value=""修改"" />")
  137. c.Writeln("</form>")
  138. End Sub
  139. Private Sub b2()
  140. Dim ZhangHao,MiMa,BiaoShi,NiChen,XingBie,NianLin,GeRenSuoMing,JingBi,ZhuCeShiJian,ZuiHouDenLuShiJian,ZuiHouDenLuIP,ZhuangTai,ShouJiHao,XingMing,ShengFenZhengHao,FuZhi,ZiShu,JiBie,JingYan,YeShu,SuoDing
  141. ZhangHao=s.Form_aa("ZhangHao",1,250)
  142. MiMa=s.Form_aa("MiMa",1,250)
  143. BiaoShi=s.Form("BiaoShi")
  144. NiChen=s.Form_Str("NiChen",1,250)
  145. XingBie=s.Form_Str("XingBie",1,1)
  146. NianLin=s.Form_Long("NianLin")
  147. GeRenSuoMing=s.Form_Str("GeRenSuoMing",1,250)
  148. JingBi=s.Form_Long("JingBi")
  149. ZhuCeShiJian=s.Form("ZhuCeShiJian")
  150. ZuiHouDenLuShiJian=s.Form("ZuiHouDenLuShiJian")
  151. ZuiHouDenLuIP=s.Form("ZuiHouDenLuIP")
  152. ZhuangTai=s.Form_Str("ZhuangTai",1,1)
  153. ShouJiHao=s.Form_Str("ShouJiHao",11,11)
  154. XingMing=s.Form_Str("XingMing",2,100)
  155. ShengFenZhengHao=s.Form_Str("ShengFenZhengHao",15,18)
  156. FuZhi=s.Form_Str("FuZhi",1,10000)
  157. ZiShu=s.Form_Long("ZiShu")
  158. JiBie=s.Form_Long("JiBie")
  159. JingYan=s.Form_Long("JingYan")
  160. YeShu=s.Form_Long("YeShu")
  161. SuoDing=s.Form_Str("SuoDing",1,1)
  162. Call OpenData()
  163. Conn.Execute("Update ZhangHao Set ZhangHao='"&ZhangHao&"',MiMa='"&MiMa&"',BiaoShi='"&BiaoShi&"',NiChen='"&NiChen&"',XingBie='"&XingBie&"',NianLin='"&NianLin&"',GeRenSuoMing='"&GeRenSuoMing&"',JingBi='"&JingBi&"',ZhuangTai='"&ZhuangTai&"',ShouJiHao='"&ShouJiHao&"',XingMing='"&XingMing&"',ShengFenZhengHao='"&ShengFenZhengHao&"',FuZhi='"&FuZhi&"',ZiShu='"&ZiShu&"',JiBie='"&JiBie&"',JingYan='"&JingYan&"',YeShu='"&YeShu&"',SuoDing='"&SuoDing&"' Where ID="&ID)
  164. Call JiLu("编辑会员"&ID)
  165. Call CloseData()
  166. Response.Write("<script language=javascript>location.href=""HuiYuan.Asp"";</script>")
  167. Response.End()
  168. End Sub
  169. Private Sub Delete()
  170. Call OpenData()
  171. Conn.Execute("Delete From ZhangHao Where ID="&ID)
  172. Call JiLu("删除会员"&ID)
  173. Response.Write("<script language=javascript>location.href=""HuiYuan.Asp"";</script>")
  174. Response.End()
  175. Call CloseData()
  176. End Sub
  177. Dim ID
  178. ID=s.QueryString_Long("ID")
  179. Call H_Title("管理会员")
  180. Dim l
  181. l=s.QueryString("l")
  182. Select Case l
  183. Case "x"
  184. Call x()
  185. Case "b"
  186. Call b()
  187. Case "b2"
  188. Call b2()
  189. Case "s"
  190. Call Delete()
  191. End Select
  192. c.Write("<a href=""HuiYuan.Asp"">返回会员管理</a>")
  193. Call H_End()
  194. Set c=Nothing
  195. Set s=Nothing
  196. %>