📄 aa_sells.asp
字号:
<%@ LANGUAGE = VBScript CodePage = 936%>
<%
'***********************************************************************************' 产品名称:台讯企业全站管理系统(V2006简体中文版)' 程序开发:HECHENn(QQ:34103037 Emial:hechenn@126.com)' Copyright 2006 txcodes.com - All Rights Reserved. '***********************************************************************************
PageName="Admin,0"
%>
<!--#include file="Inc/Const.asp"-->
<!--#include file="Inc/System.asp"-->
<!--#include file="Inc/Design.asp"-->
<%
Call Page_formBody()
Call Page_Spane(5)
Page_HeadName="<A HREF=Aa_Sells.asp?Action=Add>添加营销网络</A> | <A HREF=Aa_Sells.asp?Action=Manage>营销网络列表</A>"
Select Case Action
Case "Add"
Call Page_AdminFlag(23)
Page_BootmName="添加营销网络"
Page_BootName="您现在的位置:<A HREF=A_Right.asp>管理首页</A> >> " & Page_BootmName
strIfa = "<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=1>"&_
"<Form NAME=Form method=post action=Aa_Sells.asp?Action=sAdd onSubmit='return checkdata()'>"&_
"<TR>"&_
"<TD WIDTH=20% HEIGHT=30 CLASS=Table8>营销网络名称:</TD>"&_
"<TD CLASS=Table8><INPUT NAME=Sells_Name TYPE=text id=Sells_Name size=40> <FONT COLOR=ff0000>*</FONT></TD>"&_
"</TR>"&_
"<TR>"&_
"<TD HEIGHT=30 CLASS=Table8>营销网络内容:</TD>"&_
"<TD>"
strIfb = "</TD>"&_
"</TR>"&_
"<TR>"&_
"<TD HEIGHT=30 CLASS=Table8>营销网络审核:</TD>"&_
"<TD CLASS=Table8><INPUT TYPE=radio CLASS=radio_all NAME=Sells_Flag VALUE='1' checked> 通过审核 <INPUT TYPE=radio CLASS=radio_all NAME=Sells_Flag VALUE='0'>取消审核</TD>"&_
"</TR>"&_
"<TR ALIGN=center>"&_
"<TD HEIGHT=35 colspan=2 CLASS=Table8>"&_
"<INPUT NAME=Ok TYPE=submit CLASS=submit_all id=Ok VALUE='提交资料' onClick='document.Form.Content.value = frames.message.document.body.innerHTML;document.Form.PicUrl.value = frames.PicUrl.document.body.innerHTML;'> "&_
"<INPUT TYPE=submit CLASS=submit_all NAME=Cel VALUE=重新输入 onClick=" & CHR(34) & "this.form.action='vbscript:location.reload';this.form.submit()" & CHR(34) & "> "&_
"<INPUT TYPE=hidden NAME=Content VALUE=''>"&_
"<INPUT TYPE=hidden NAME=PicUrl VALUE=''></TD>"&_
"</TR>"&_
"</form>"&_
"</TABLE>"
Call Page_aTable(1,0)
Case "Edit"
Call Page_AdminFlag(23)
Set Rs_edit=server.Createobject("Adodb.Recordset")
Sql="Select * From Tx_Sells Where Sells_Id=" & Id
Rs_edit.open Sql,Conn,1,1
Table_List1="Tx_Sells"
OldId="Sells_Id"
OldContent="Sells_Content"
Page_BootmName="营销网络修改 > " & Rs_edit("Sells_Name")
Page_BootName="您现在的位置:<A HREF=A_Right.asp>管理首页</A> >> " & Page_BootmName
IF Rs_edit("Sells_Flag")=1 THEN
checked1="checked"
Else
checked2="checked"
End IF
strIfa = "<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=1>"&_
"<Form NAME=Form method=post action=Aa_Sells.asp?Action=sEdit&Id=" & Id & " onSubmit='return checkdata()'>"&_
"<TR>"&_
"<TD WIDTH=20% HEIGHT=30 CLASS=Table8>营销网络名称:</TD>"&_
"<TD CLASS=Table8><INPUT NAME=Sells_Name TYPE=text id=Sells_Name VALUE=" & Rs_edit("Sells_Name") & " size=40> <FONT COLOR=ff0000>*</FONT></TD>"&_
"</TR>"&_
"<TR>"&_
"<TD HEIGHT=30 CLASS=Table8>营销网络内容:</TD>"&_
"<TD>"
strIfb = "</TD>"&_
"</TR>"&_
"<TR>"&_
"<TD HEIGHT=30 CLASS=Table8>营销网络审核:</TD>"&_
"<TD CLASS=Table8><INPUT TYPE=radio CLASS=radio_all NAME=Sells_Flag VALUE='1' " & checked1 & "> 通过审核 <INPUT CLASS=radio_all TYPE=radio NAME=Sells_Flag VALUE='0' " & checked2 & ">取消审核</TD>"&_
"</TR>"&_
"<TR ALIGN=center>"&_
"<TD HEIGHT=35 colspan=2 CLASS=Table8>"&_
"<INPUT NAME=Ok TYPE=submit CLASS=submit_all id=Ok VALUE='提交资料' onClick='document.Form.Content.value = frames.message.document.body.innerHTML;document.Form.PicUrl.value = frames.PicUrl.document.body.innerHTML;'> "&_
"<INPUT TYPE=submit NAME=Cel CLASS=submit_all VALUE=重新输入 onClick=" & CHR(34) & "this.form.action='vbscript:location.reload';this.form.submit()" & CHR(34) & "> "&_
"<INPUT TYPE=hidden NAME=Content VALUE=''>"&_
"<INPUT TYPE=hidden NAME=PicUrl VALUE=''></TD>"&_
"</TR>"&_
"</form>"&_
"</TABLE>"
Call Page_aTable(1,0)
Rs_edit.Close
Set Rs_edit=Nothing
Case "Manage"
Call Page_AdminFlag(24)
Page_BootmName="营销网络列表"
Page_BootName="您现在的位置:<A HREF=A_Right.asp>管理首页</A> >> " & Page_BootmName
Set Rs_Manage=server.Createobject("Adodb.Recordset")
Sql="Select * From Tx_Sells order by Sells_Id desc"
Rs_Manage.open Sql,Conn,1,1
strIfa = "<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=1><TR ALIGN=center><TD WIDTH=6% HEIGHT=23 CLASS=Table6>ID</TD><TD CLASS=Table6>营销网络名称</TD><TD WIDTH=22% CLASS=Table6>操作</TD></TR>"
Rs_Manage.PageSize = 25
totalrec=Rs_Manage.RecordCount
iPageSize=Rs_Manage.PageSize
currentPage=Request("page")
IF currentpage="" THEN
currentpage=1
Else
IF Not isChkInteger(currentPage) THEN
response.Redirect "javascript:history.go(-1);"
End IF
currentpage=clng(currentpage)
End IF
IF totalrec mod Cint(iPageSize)=0 THEN
n= totalrec \ Cint(iPageSize)
Else
n= totalrec \ Cint(iPageSize)+1
End IF
IF not (Rs_Manage.bof and Rs_Manage.eof) THEN
Rs_Manage.MoveFirst
IF currentpage > n THEN currentpage = n
IF currentpage<1 THEN currentpage=1
Rs_Manage.Move (currentpage-1) * Cint(iPageSize)
While Not Rs_Manage.Eof and page_count<Cint(iPageSize)
page_count=page_count+1
IF Rs_Manage("Sells_Flag")=1 THEN
TitleFlag="<FONT COLOR=006600>取消</FONT>"
Else
TitleFlag="<FONT COLOR=ff0000>审核</FONT>"
End IF
strIfa = strIfa & "<Form NAME=inbox method=post action='Aa_Sells.asp?Action=Delall'>"&_
"<TR CLASS=Table8 onmouseout=" & CHR(34) & "this.style.backgroundColor=''" & CHR(34) & " onmouseover=" & CHR(34) & "this.style.backgroundColor='#799ae1'" & CHR(34) & ">"&_
"<TD HEIGHT=25 ALIGN=center>" & Rs_Manage("Sells_Id") & "</TD>"&_
"<TD><A HREF=Aa_Sells.asp?Action=S&Id=" & Rs_Manage("Sells_Id") & ">" & Rs_Manage("Sells_Name") & "</A></TD>"&_
"<TD ALIGN=center>"&_
"<A HREF=Aa_Sells.asp?Action=Edit&Id=" & Rs_Manage("Sells_Id") & ">修改</A> | "&_
"<A HREF=Aa_Sells.asp?Action=Flag&Id=" & Rs_Manage("Sells_Id") & ">" & TitleFlag & "</A> | "&_
"<A HREF=Aa_Sells.asp?Action=Del&Id=" & Rs_Manage("Sells_Id") & " onclick='{if(confirm(" & CHR(34) & "删除后将无法恢复,您真的要删除么?" & CHR(34) & ")){return true;}return false;}'>删除</A> | "&_
"<INPUT CLASS=radio_all TYPE=checkbox NAME=Id VALUE=" & Rs_Manage("Sells_Id") & ">"&_
"</TD>"&_
"</TR>"
Rs_Manage.movenext
wEnd
End IF
Rs_Manage.Close
Set Rs_Manage=Nothing
strIfa = strIfa & "<TR>"&_
"<TD HEIGHT=30 colspan=6 ALIGN=center CLASS=Table9><INPUT CLASS=radio_all TYPE=checkbox NAME=chkall VALUE=on onclick=CheckAll(this.form)>"&_
" 选择全部 "&_
"<INPUT TYPE=submit CLASS=submit_all NAME=Submit VALUE=' 删除 ' onclick='{if(confirm(" & CHR(34) & "删除后将无法恢复,您真的要删除么?" & CHR(34) & ")){return true;}return false;}'> "&_
"<INPUT TYPE=submit CLASS=submit_all NAME=FlagOk VALUE=通过审核 onClick=" & CHR(34) & "this.form.action='Aa_Sells.asp?Action=FlagallOk';this.form.submit()" & CHR(34) & "> "&_
"<INPUT TYPE=submit CLASS=submit_all NAME=FlagNo VALUE=取消审核 onClick=" & CHR(34) & "this.form.action='Aa_Sells.asp?Action=FlagallNo';this.form.submit()" & CHR(34) & ">"&_
"</TD>"&_
"</TR>"&_
"</form>"&_
"<TR>"&_
"<TD HEIGHT=25 colspan=6 ALIGN=center CLASS=Table8>"
strIfb = "</TD></TR>"&_
"</TABLE>"
Call Page_aTable(0,1)
Case "S"
Set Rs_edit=server.Createobject("Adodb.Recordset")
Sql="Select * from Tx_Sells Where Sells_Id=" & Id
Rs_edit.open Sql,Conn,1,1
Page_BootmName="查看营销网络 > " & Rs_edit("Sells_Name")
Page_BootName="您现在的位置:<A HREF=A_Right.asp>管理首页</A> >> " & Page_BootmName
IF Rs_edit("Sells_Flag")=1 THEN
TitleFlag="<FONT COLOR=006600>取消审核</FONT>"
Else
TitleFlag="<FONT COLOR=ff0000>通过审核</FONT>"
End IF
strIfa = "<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=1>"&_
"<TR>"&_
"<TD ALIGN=center CLASS=Table8>"&_
"<TABLE WIDTH=570 BORDER=0 CELLPADDING=0 CELLSPACING=0>"&_
"<TR>"&_
"<TD ALIGN=center CLASS=Table15><B>" & Rs_edit("Sells_Name") & "</B></TD>"&_
"</TR>"&_
"<TR>"&_
"<TD HEIGHT=1 background=Skins/Blue/Ar2.gIF></TD>"&_
"</TR>"&_
"<TR>"&_
"<TD CLASS=Table15>" & Rs_edit("Sells_Content") & "</TD>"&_
"</TR>"&_
"<TR>"&_
"<TD HEIGHT=1 background=Skins/Blue/Ar2.gIF></TD>"&_
"</TR>"&_
"<TR>"&_
"<TD HEIGHT=30></TD>"&_
"</TR>"&_
"</TABLE></TD>"&_
"</TR>"&_
"<TR>"&_
"<TD HEIGHT=25 ALIGN=center CLASS=Table8>『 <A HREF=Aa_Sells.asp?Action=Add>添加营销网络</A> 』『 <A HREF=Aa_Sells.asp?Action=Edit&Id=" & Rs_edit("Sells_Id") & ">修改</A> 』『 <A HREF=Aa_Sells.asp?Action=Flag&Id=" & Rs_edit("Sells_Id") & ">" & TitleFlag & "</A> 』『 <a onclick='{if(confirm(" & CHR(34) & "删除后将无法恢复,您真的要删除么?" & CHR(34) & ")){return true;}return false;}' href=Aa_Sells.asp?Action=Del&Id=" & Rs_edit("Sells_Id") & ">删除</A> 』『 <A HREF=Aa_Sells.asp?Action=Manage>营销网络列表</A> 』</TD>"&_
"</TR>"&_
"</TABLE>"
Rs_edit.Close
Set Rs_edit=Nothing
Call Page_aTable(0,0)
Case "sAdd"
IF Request.form("Sells_Name")="" THEN
Errorst="请输入营销网络名称!"
founderr=True
ElseIF Request.form("Content")="" THEN
Errorst="请选输入营销网络内容!"
founderr=True
End IF
IF founderr=True THEN
Call Form_Error()
Else
ContentFile=Replace(Request.form("PicUrl"),"../","")
ContentFile=split(ContentFile,"|")
For intTemp=0 to ubound(ContentFile)
IF instr(Request.form("Content"),ContentFile(intTemp)) and ContentFile(intTemp)<>"" THEN
UploadFile=ContentFile(intTemp) & "|" & UploadFile
End IF
next
Set Rs=server.createobject("adodb.recordset")
Sql="Select * From Tx_Sells"
Rs.open Sql,Conn,1,3
Rs.addnew
Rs("Sells_Name")=Request.form("Sells_Name")
Rs("Sells_Content")=replace(request.form("Content"),replace(ToHistorys,"Aa_Sells.asp",""),"")
Rs("Sells_Flag")=Request.form("Sells_Flag")
Rs("UploadFiles")=UploadFile
Rs.update
session("Content")=""
ToHistory="Aa_Sells.asp?Action=S&Id=" & Rs("Sells_Id")
Rs.Close
Set Rs=Nothing
saveok="营销网络:[ " & Request.form("Sells_Name") & " ] 添加成功!"
Call Form_Saveok()
End IF
Case "sEdit"
IF Request.form("Sells_Name")="" THEN
Errorst="请输入营销网络名称!"
founderr=True
ElseIF Request.form("Content")="" THEN
Errorst="请选输入营销网络内容!"
founderr=True
End IF
IF founderr=True THEN
Call Form_Error()
Else
Set Rs=server.createobject("adodb.recordset")
Sql="Select * From Tx_Sells Where Sells_Id=" & Id
Rs.open Sql,Conn,1,1
ContentFile=Rs("UploadFiles")
Rs.Close
Set Rs=Nothing
ContentFile=Replace(Request.form("PicUrl"),"../","") & ContentFile
ContentFile=split(ContentFile,"|")
For intTemp=0 to ubound(ContentFile)
IF instr(Request.form("Content"),ContentFile(intTemp)) and ContentFile(intTemp)<>"" THEN
UploadFile=ContentFile(intTemp) & "|" & UploadFile
End IF
Next
Set Rs=server.createobject("adodb.recordset")
Sql="Select * From Tx_Sells where Sells_Id=" & Id
Rs.open Sql,Conn,1,3
Rs("Sells_Name")=Request.form("Sells_Name")
Rs("Sells_Content")=replace(request.form("Content"),replace(ToHistorys,"Aa_Sells.asp",""),"")
Rs("Sells_Flag")=Request.form("Sells_Flag")
Rs("UploadFiles")=UploadFile
Rs.update
session("Content")=""
Rs.Close
Set Rs=Nothing
ToHistory="Aa_Sells.asp?Action=Edit&Id=" & Id
saveok="营销网络:[ " & Request.form("Sells_Name") & " ] 修改成功!"
Call Form_Saveok()
End IF
Case "Del"
Conn.Execute "Delete From Tx_Sells Where Sells_Id=" & Id
ToHistory="Aa_Sells.asp?Action=Manage"
saveok="删除成功!"
Call Form_Saveok()
Case "Flag"
Set Rs=server.createobject("adodb.recordset")
Sql="Select * From Tx_Sells where Sells_Id=" & Id
Rs.open Sql,Conn,1,3
IF Rs("Sells_Flag")=1 THEN
Rs("Sells_Flag")=0
saveok=":[ " & Rs("Sells_Name") & " ] 已取消审核!"
Else
Rs("Sells_Flag")=1
saveok="营销网络:[ " & Rs("Sells_Name") & " ] 已通过审核!"
End IF
Rs.update
Rs.Close
Set Rs=Nothing
ToHistory=VisitorsForm
Call Form_Saveok()
Case "Delall"
IF Request.form("Id")="" THEN
Errorst="请选择要删除的对象!"
founderr=True
End IF
IF founderr=True THEN
Call Form_Error()
Else
Conn.Execute "Delete From Tx_Sells Where Sells_Id in (" & Request.form("Id") & ")"
ToHistory=VisitorsForm
saveok="删除成功!"
Call Form_Saveok()
End IF
Case "FlagallOk"
IF Request.form("Id")="" THEN
Errorst="请选择要审核的对象!"
founderr=True
End IF
IF founderr=True THEN
Call Form_Error()
Else
Conn.Execute "upDate Tx_Sells Set Sells_Flag=1 Where Sells_Id in (" & Request.form("Id") & ")"
ToHistory=VisitorsForm
saveok="已通过审核!"
Call Form_Saveok()
End IF
Case "FlagallNo"
IF Request.form("Id")="" THEN
Errorst="请选择要取消审核的对象!"
founderr=True
End IF
IF founderr=True THEN
Call Form_Error()
Else
Conn.Execute "upDate Tx_Sells Set Sells_Flag=0 Where Sells_Id in (" & Request.form("Id") & ")"
ToHistory=VisitorsForm
saveok="已取消审核!"
Call Form_Saveok()
End IF
End Select
Call Page_Spane(5)
Call CloseConn()
Call Page_EndBody()
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -