?? mxdqmodifysmall.asp
字號:
<!--#Include file="../Common/Inc_DatConn.asp"-->
<!--#Include file="Common/Inc_Config.asp"-->
<!--#Include file="Common/Inc_Function.asp"-->
<%
'┌─ 風云ASP在線 ────────────────────────┐
'│ │
'│ 作者：趙振波. http://www.fyasp.com │
'│ │
'│ Q Q：176189168 │
'│ │
'│ Email：fy96@163.com │
'│ │
'│ 程序定做，系統開發，網站制作，提供高質量的網絡產品、技術和服務！│
'│ │
'│【版權聲明】 │
'│ │
'│ 本程序版權歸坐看風云所有，未經授權擅自修改、復制或散布本程序│
'│ │
'│的部分或全部，將承受嚴厲的民事和刑事處罰，對已知的違反者將給予法 │
'│ │
'│律范圍內的全面制裁。對非法使用此程序所造成的一切后果本人概不負責!│
'│ │
'└─────────────────── http://www.fyasp.com ──┘
%>
<%if IsTimeOut(Session("strAccount"),Session("strPassWord")) then Response.Redirect "index.asp"%>
<%
dim SmallClassID,Action,BigClassName, SmallClassName, OldSmallClassName,rs,FoundErr,ErrMsg
SmallClassID=trim(Request("smallmxdqID"))
Action=trim(Request("Action"))
dl=trim(Request.form("dl"))
odl=trim(Request("odl"))
SmallClassName=trim(Request.form("SmallClassName"))
OldSmallClassName=trim(request.form("OldSmallClassName"))
if SmallClassID="" then
response.Redirect("mxdq.asp")
end if
Set rs=Server.CreateObject("Adodb.RecordSet")
rs.Open "Select * from fysmallmxdq where ID="&SmallClassID&"",conn,1,3
if rs.Bof or rs.EOF then
FoundErr=True
ErrMsg=ErrMsg & "此小類不存在！"
else
if Action="Modify" then
if SmallClassName="" then
FoundErr=True
ErrMsg=ErrMsg & "小類名不能為空！"
end if
if FoundErr<>True then
if dl<>odl then
rs("dl")=dl
end if
rs("SmallClassName")=SmallClassName
rs.update
rs.Close
set rs=Nothing
if dl<>odl then
conn.execute "Update Dat_Information set smalldq='" &SmallClassName& "' where smalldq='" &OldSmallClassName& "'"
end if
conn.close
set conn=nothing
Response.Redirect "mxdq.asp"
end if
end if
if FoundErr=True then
response.write"<SCRIPT language=JavaScript>alert("""&ErrMsg&""");"
response.write"javascript:history.go(-1) ;</SCRIPT>"
Response.end
else
%>
<html>
<head>
<title><% = strSiteName%> - 網站后臺管理系統</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="Common/Site.css" type="text/css">
</head>
<body leftMargin="0" topMargin="2">
<!--#Include file="Common/inc_Top.asp"-->
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="105" valign="top" style="border-left: 1px solid rgb(0,0,0); border-right: 1px solid rgb(0,0,0)" class="bottom"><br>
<!--#Include file="Common/Inc_Button.asp"-->
</td>
<td valign="top" style="border-right: 1px solid rgb(0,0,0)" align="center" class="banma2">
<table width="96%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="50">當前位置：<a href="Main.asp">管理首頁</a> -> 修改地區小類</td>
</tr>
</table>
<table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="100%"><table width="100%" border="0" cellspacing="0" cellpadding="6" height="248">
<tr>
<td align="center" height="236" valign="top">
<table border="0" cellspacing="1" cellpadding="4" bgcolor="#000000" width="524">
<tr>
<td class="bottom" colspan="2">
</td>
</tr><form name="form1" method="post" action="?">
<tr>
<td class="banma1" align="right" width="203">
<strong>所屬大類：</strong></td>
<td class="banma1" width="302">
<select name="dl">
<%
dl=rs("dl")
dim rsBigClass
set rsBigClass=server.CreateObject("adodb.recordset")
sqlInfod = "Select * From mxdq order by sj desc"
rsBigClass.Open sqlInfod,Conn,1,1
do while not rsBigClass.eof
if cstr(rsBigClass("id"))=odl then
response.write "<option value='"& rsBigClass("Name") & "' selected>" & rsBigClass("Name") & "</option>"
else
response.write "<option value='"& rsBigClass("Name") & "'>" & rsBigClass("Name") & "</option>"
end if
rsBigClass.movenext
loop
rsBigClass.close
set rsBigClass=nothing
%>
</select></td>
</tr>
<tr>
<td class="banma1" align="right" width="203">
<strong>小類名稱：</strong></td>
<td class="banma1" width="302">
<input name="odl" type="hidden" value="<%=request("odl")%>">
<input name="smallmxdqID" type="hidden" value="<%=request("smallmxdqID")%>">
<input name="Action" type="hidden" id="Action" value="Modify">
<input name="SmallClassName" type="text" id="SmallClassName" value="<%=rs("SmallClassName")%>" size="20" maxlength="30"></td>
</tr>
<tr>
<td class="bottom" align="left" width="505" colspan="2">
<p align="center"><input name="add" type='submit' value='確定修改此地區' class="button"></td>
</tr></form>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
<br>
</td>
</tr>
</table>
<!--#Include file="Common/Inc_Bottom.asp"-->
</body>
</html><%
end if
end if
conn.close
set conn=nothing
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -