% CheckAdmin("AspCms_Sort.asp") dim action : action=getForm("action","get") Select case action case "add" : addSort case "quick" : quickAdd case "edit" : editSort case "del" : delSort case "saveall" : saveAll case "on" : onOff "on", "Sort", "SortID", "SortStatus", "", getPageName() case "off" : onOff "off", "Sort", "SortID", "SortStatus", "", getPageName() case "move" : moveSort End Select dim SortID, LanguageID, ParentID, SortOrder, SortType, SortName, SortURL, SortLevel, AddTime, PageTitle, PageKeywords, PageDesc, SortPath, SortTemplate, ContentTemplate, SortFolder, ContentFolder, SortFileName, ContentFileName, SortStatus, TopSortID, GroupID, Exclusive, Content,indeximage,IcoPath,IcoImage dim sql, msg Sub getSort dim id : id=getForm("id","get") if not isnul(ID) then sql ="select * from {prefix}Sort where SortID="&id dim rs : set rs = conn.exec(sql,"r1") if rs.eof then alertMsgAndGo "沒有這條記錄","-1" else SortID=rs("SortID") LanguageID=rs("LanguageID") ParentID=rs("ParentID") SortOrder=rs("SortOrder") SortType=rs("SortType") SortName=rs("SortName") SortURL=rs("SortURL") SortLevel=rs("SortLevel") AddTime=rs("AddTime") PageTitle=rs("PageTitle") PageKeywords=rs("PageKeywords") PageDesc=rs("PageDesc") SortPath=rs("SortPath") SortTemplate=rs("SortTemplate") ContentTemplate=rs("ContentTemplate") SortFolder=rs("SortFolder") ContentFolder=rs("ContentFolder") SortFileName=rs("SortFileName") ContentFileName=rs("ContentFileName") SortStatus=rs("SortStatus") TopSortID=rs("TopSortID") GroupID=rs("GroupID") Exclusive=rs("Exclusive") Content=rs("SortContent") indeximage=rs("indeximage") IcoPath = rs("IcoPath") IcoImage = rs("IcoImage") end if rs.close : set rs=nothing else alertMsgAndGo "沒有這條記錄","-1" end if End Sub Sub moveSort dim id : id=getForm("id","post") if isnul(id) then alertMsgAndGo "請選擇要操作的內容","-1" dim moveSortID moveSortID=getForm("moveSortID","post") dim ids,i ids=split(id,",") for i=0 to ubound(ids) 'if ids(i)>4 then conn.exec "delete from {prefix}UserGroup where IsAdmin=1 and GroupID="&ids(i),"exe" if moveSortID="0" then SortLevel="1" TopSortID=ids(i) SortPath =TopSortID&"," else dim rs : set rs=Conn.Exec("select SortLevel, TopSortID, SortPath from {prefix}Sort where SortID="&moveSortID,"r1") SortLevel=rs(0)+1 TopSortID=rs(1) SortPath=rs(2)&ids(i)&"," end if conn.exec "update {prefix}Sort set ParentID="&moveSortID&", SortLevel="&SortLevel&", TopSortID="&TopSortID&", SortPath='"&trim(SortPath)&"' where LanguageID="&rCookie("languageID")&" and SortID ="&ids(i), "exe" '將此類下的所有子類修改一次 editSubSort(ids(i)) next alertMsgAndGo "移動成功!", getPageName() End Sub Function editSubSort(sortID) dim rs,prs,SortPath,SortLevel set rs=conn.exec("select * from {prefix}Sort where parentID="&sortID,"r1") if not rs.eof then set prs=conn.exec("select * from {prefix}Sort where SortID="&rs("parentID"),"r1") do while not rs.eof if rs("SortLevel")=1 then SortPath = rs("SortID")&"," conn.exec "update {prefix}Sort set TopSortID="&rs("SortID")&",SortPath='"&SortPath&"' where SortID="&rs("SortID"),"exe" else SortPath =trim(prs("SortPath"))&rs("SortID")&"," SortLevel=prs("SortLevel")+1 conn.exec "update {prefix}Sort set TopSortID="&prs("TopSortID")&", SortLevel="&SortLevel&", SortPath='"&SortPath&"' where SortID="&rs("SortID"),"exe" end if editSubSort rs("SortID") rs.movenext loop prs.close : set prs=nothing end if rs.close : set rs=nothing End Function Sub quickAdd dim i,TopSortName,SubSortName LanguageID=cint(rCookie("languageID")) AddTime=now() GroupID=getForm("GroupID", "post") Exclusive=getForm("Exclusive", "post") SortStatus=1 for i=1 to 10 ParentID=0 TopSortName=getForm("TopSortName"&i, "post") if not isnul(TopSortName) then SortOrder=getForm("SortOrder"&i, "post") SortType=getForm("SortType"&i, "post") SubSortName=getForm("SubSortName"&i, "post") SortURL=getForm("SortURL"&i, "post") select case SortType case "1" SortTemplate="about.html" ContentTemplate="" SortFolder="{sitepath}"&setting.languagePath&htmlDir&"about/" ContentFolder="" SortFileName="{sortid}" ContentFileName="" case "2" SortTemplate="newslist.html" ContentTemplate="news.html" SortFolder="{sitepath}"&setting.languagePath&htmlDir&"newslist/" ContentFolder="{sitepath}"&setting.languagePath&htmlDir&"news/" SortFileName="list-{sortid}-{page}" ContentFileName="{id}" case "3" SortTemplate="productlist.html" ContentTemplate="product.html" SortFolder="{sitepath}"&setting.languagePath&htmlDir&"productlist/" ContentFolder="{sitepath}"&setting.languagePath&htmlDir&"product/" SortFileName="list-{sortid}-{page}" ContentFileName="{id}" case "4" SortTemplate="downlist.html" ContentTemplate="down.html" SortFolder="{sitepath}"&setting.languagePath&htmlDir&"downlist/" ContentFolder="{sitepath}"&setting.languagePath&htmlDir&"down/" SortFileName="list-{sortid}-{page}" ContentFileName="{id}" case "5" SortTemplate="joblist.html" ContentTemplate="job.html" SortFolder="{sitepath}"&setting.languagePath&htmlDir&"jobtlist/" ContentFolder="{sitepath}"&setting.languagePath&htmlDir&"job/" SortFileName="list-{sortid}-{page}" ContentFileName="{id}" case "6" SortTemplate="albumlist.html" ContentTemplate="album.html" SortFolder="{sitepath}"&setting.languagePath&htmlDir&"albumtlist/" ContentFolder="{sitepath}"&setting.languagePath&htmlDir&"album/" SortFileName="list-{sortid}-{page}" ContentFileName="{id}" case "8" SortTemplate="videolist.html" ContentTemplate="video.html" SortFolder="{sitepath}"&setting.languagePath&htmlDir&"videolist/" ContentFolder="{sitepath}"&setting.languagePath&htmlDir&"video/" SortFileName="list-{sortid}-{page}" ContentFileName="{id}" end select conn.exec "insert into {prefix}Sort(ParentID, SortOrder, SortType, SortName, SortURL, SortTemplate, ContentTemplate, SortFolder, ContentFolder, SortFileName, ContentFileName, SortStatus, LanguageID, AddTime, GroupID, Exclusive,IcoPath,IcoImage) values("&ParentID&", "&SortOrder&", "&SortType&", '"&TopSortName&"', '"&SortURL&"', '"&SortTemplate&"', '"&ContentTemplate&"', '"&SortFolder&"', '"&ContentFolder&"', '"&SortFileName&"', '"&ContentFileName&"', "&SortStatus&", "&LanguageID&", '"&AddTime&"', "&GroupID&", '"&Exclusive&"','"&IcoPath&"','"&IcoImage&"')", "exe" SortID=Conn.Exec("select @@identity","r1")(0) SortLevel="1" TopSortID=SortID SortPath = TopSortID&"," conn.exec "update {prefix}Sort set SortLevel="&SortLevel&", TopSortID="&TopSortID&", SortPath='"&SortPath&"', IcoPath='"&IcoPath&", IcoImage='"&IcoImage&" where SortID="&SortID, "exe" ParentID=SortID if not isnul(SubSortName) then SubSortName=split(SubSortName,",") dim j for j=0 to ubound(SubSortName) if not isnul(SubSortName(j)) then conn.exec "insert into {prefix}Sort(ParentID, SortOrder, SortType, SortName, SortURL, SortTemplate, ContentTemplate, SortFolder, ContentFolder, SortFileName, ContentFileName, SortStatus, LanguageID, AddTime, GroupID, Exclusive) values("&ParentID&", "&SortOrder&", "&SortType&", '"&SubSortName(j)&"', '"&SortURL&"', '"&SortTemplate&"', '"&ContentTemplate&"', '"&SortFolder&"', '"&ContentFolder&"', '"&SortFileName&"', '"&ContentFileName&"', "&SortStatus&", "&LanguageID&", '"&AddTime&"', "&GroupID&", '"&Exclusive&"')", "exe" end if next end if editSubSort(sortID) end if next alertMsgAndGo "保存成功","AspCms_Sort.asp" End Sub Sub saveAll Dim ids : ids=split(getForm("SortIDs","post"),",") Dim SortNames : SortNames=split(getForm("SortNames","post"),",") Dim SortURLs : SortURLs=split(getForm("SortURLs","post"),",") 'Dim SortTypes : SortTypes=split(getForm("SortTypes","post"),",") Dim SortOrders : SortOrders=split(getForm("SortOrders","post"),",") If Ubound(ids)=-1 Then '防止有值為空時下標越界 ReDim ids(0) ids(0)="" End If If Ubound(SortNames)=-1 Then ReDim SortNames(0) SortNames(0)="" End If If Ubound(SortURLs)=-1 Then ReDim SortURLs(0) SortURLs(0)="" End If 'If Ubound(SortTypes)=-1 Then ' ReDim SortTypes(0) ' SortStyles(0)="" 'End If If Ubound(SortOrders)=-1 Then ReDim SortOrders(0) SortOrders(0)=0 End If Dim i For i=0 To Ubound(ids) if not isnum(SortOrders(i)) then SortOrders(i)=0 Conn.Exec "update {prefix}Sort Set SortName='"&trim(SortNames(i))&"',SortURL='"&trim(SortURLs(i))&"',SortOrder='"&trim(SortOrders(i))&"' Where SortID="&trim(ids(i)),"exe" Next alertMsgAndGo "保存成功","AspCms_Sort.asp" End Sub function sortList(ParentID) Dim rs :set rs =Conn.Exec ("select *,(select count(*) from {prefix}Sort where ParentID=t.SortID) as c from AspCms_Sort t where LanguageID="&rCookie("languageID")&" and ParentID="&ParentID&" order by Sortorder,Sortorder ","r1") dim sortTypenames : sortTypenames=split(sortTypes,",") dim showtype IF rs.eof or rs.bof Then echo "
| "&vbcrlf echo " | "&rs("SortID")&" | "&vbcrlf echo ""&getLevel(rs("SortLevel"))&showtype&" | "&vbcrlf echo "" echo sortTypenames(rs("SortType")-1) 'echo makeSortTypeSelect("SortTypes",rs("SortType"),"") 'echo rs("SortType") echo " | "&vbcrlf echo ""&vbcrlf echo " | " echo "" echo " | "&vbcrlf echo ""&getStr(rs("SortStatus")," | "&vbcrlf
echo "