shengSet.asp
上传用户:btntkt
上传日期:2021-04-16
资源大小:5296k
文件大小:2k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

DOS

  1. <!--#include file="conn.asp"-->
  2. <%if session("admin")="" then
  3. response.Write "<script language='javascript'>alert('网络超时或您还没有登陆!');window.location.href='login.asp';</script>"
  4. response.End
  5. end if
  6. dim shengid,shengorder,shengname,shengno,i
  7. if request("action")="update" then
  8.     for i=1 to request.form("shengid").count
  9. shengid=replace(request.form("shengid")(i),"'","")
  10. shengorder=replace(request.form("shengorder")(i),"'","")
  11. shengname=replace(request.form("shengname")(i),"'","")
  12. shengno=replace(request.form("shengno")(i),"'","")
  13. if replace(request.form("shengorder")(i),"'","")="" then
  14. %>
  15. <script language=javascript>
  16. history.back()
  17. alert("请填写省的显示排序!")
  18. </script>
  19. <%
  20. Response.End
  21. end if
  22. conn.execute("update province set shengorder="&shengorder&",shengname='"&shengname&"',shengno='"&shengno&"' where id="&shengid)
  23.     next
  24. conn.close
  25. set conn=nothing
  26. response.write "<script language=javascript>alert('省设置成功!');window.location.href='shengmanage.asp';</script>"
  27. end if
  28. if request("action")="add" then
  29. shengno=request.form("shengno")
  30. shengname=trim(request("shengname"))
  31. shengorder=request.form("shengorder")
  32. If shengname="" Then
  33. response.write "省名称不能为空!请<a href=javascript:history.go(-1)>返回重新填写</a>!"
  34. response.end
  35. end if
  36. If shengno="" Then
  37. response.write "省编号名称不能为空!请<a href=javascript:history.go(-1)>返回重新填写</a>!"
  38. response.end
  39. end if
  40. If shengorder="" Then
  41. response.write "排序不能为空!请<a href=javascript:history.go(-1)>返回重新填写</a>!"
  42. response.end
  43. end if
  44. Set rs = Server.CreateObject("ADODB.Recordset")
  45. rs.open "select * from province",conn,1,3
  46. rs.addnew
  47. rs("shengname")=shengname
  48. rs("shengno")=shengno
  49. rs("shengorder")=shengorder
  50. rs.update
  51. rs.close
  52. set rs=nothing
  53. conn.close
  54. set conn=nothing
  55. response.write "<script language=javascript>alert('省添加成功!');window.location.href='shengmanage.asp';</script>"
  56. end if
  57. %>