📄 mxdqmodifysmall.asp

📁 北方供求 V3.3 Sql 版 §V3.3更新功能 1、首页（自动生成静态
💻 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> -&gt; 修改地区小类</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 + -