<!--#include file="ljconn.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%
id=request("id")
action=request.QueryString("action")
select case action
case "add"
'检查排序是否被占用开始－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from jl",conn,1,3
rs.AddNew
rs("jgid")=request.Form("jgid")'
rs("img")=request.Form("img")'
rs("xm")=request.Form("xm")'
rs("xb")=request.Form("xb")'
rs("ll")=request.Form("ll")'
rs("dz")=request.Form("dz")'
rs("yb")=request.Form("yb")'
rs("dw")=request.Form("dw")'
rs("xw")=request.Form("xw")'
rs("zc")=request.Form("zc")'
rs("zyw")=request.Form("zyw")'
rs("bgdh")=request.Form("bgdh")'
rs("yddh")=request.Form("yddh")'
rs("email")=request.Form("email")'
rs("rz")=request.Form("rz")'
rs("yjly")=request.Form("yjly")'
rs("content")=request.Form("content")'
rs("sftj")=request.Form("sftj")'
rs("px")=request.Form("px")'

rs.Update
rs.Close
response.Write "<script language=javascript>alert('添加成功！');location.href='addjl.asp';</script>"
response.End
case "edit"
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from jl where id="&id&"",conn,1,3
rs("jgid")=request.Form("jgid")'
rs("img")=request.Form("img")'
rs("xm")=request.Form("xm")'
rs("xb")=request.Form("xb")'
rs("ll")=request.Form("ll")'
rs("dz")=request.Form("dz")'
rs("yb")=request.Form("yb")'
rs("dw")=request.Form("dw")'
rs("xw")=request.Form("xw")'
rs("zc")=request.Form("zc")'
rs("zyw")=request.Form("zyw")'
rs("bgdh")=request.Form("bgdh")'
rs("yddh")=request.Form("yddh")'
rs("email")=request.Form("email")'
rs("rz")=request.Form("rz")'
rs("yjly")=request.Form("yjly")'
rs("content")=request.Form("content")'
rs("sftj")=request.Form("sftj")'
rs("px")=request.Form("px")'
rs.Update
rs.Close
set rs=nothing
conn.close
set conn=nothing
response.Write "<script language=javascript>alert('修改成功！');location.href='managejl.asp';</script>"
response.End
end select
%>