?? 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 + -