{"id":20,"date":"2010-05-21T23:57:23","date_gmt":"2010-05-21T23:57:23","guid":{"rendered":"http:\/\/blog.yyhcw.com\/post\/20.html"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T07:54:17","slug":"Kesion","status":"publish","type":"post","link":"http:\/\/blog.yyhcw.com\/post\/20.html","title":{"rendered":"\u8be6\u89e3\u79d1\u8bafCMS(KesionCMS) \u7684\u76f8\u5173\u6587\u7ae0"},"content":{"rendered":"

\u4f7f\u7528\u79d1\u8bafCMS \u81f3\u5c11\u5728\u73b0\u5728\u7684\u4f7f\u7528\u4e2d\u611f\u89c9\u8fd8\u662f\u4e2a\u4e0d\u9519\u7684CMS \u53ef\u662f \u4e0d\u77e5\u9053\u4e3a\u4ec0\u4e48 \u7cfb\u7edf\u81ea\u5e26\u7684\u76f8\u5173\u4fe1\u606f \u611f\u89c9\u7528\u7740\u5f88\u4e0d\u8212\u670d\uff0c\u4e8e\u662f\u81ea\u5df1\u52a8\u624b\u5199\u4e86\u4e00\u4e2a“\u76f8\u5173\u6587\u7ae0”\u7684\uff1b\u867d\u7136\u5df2\u7ecf\u53ef\u4ee5\u4f7f\u7528\u4e86\uff0c\u4f46\u662f\u73b0\u5728\u8fd8\u6709\u4e9b\u95ee\u9898\u672a\u80fd\u5b8c\u5168\u660e\u767d\uff0c\u53ea\u597d\u8fd9\u6837\u5148\u7528\u7740\u4e86\uff0c\u81f3\u5c11\u5df2\u7ecf\u51fa\u6765\u6548\u679c\u4e86\uff01<\/p>\n

\u4e0b\u9762\u662f\u6211\u5199\u7684\u4e00\u4e2a Function \u51fd\u6570 \u5927\u5bb6\u53ef\u4ee5\u770b\u770b \u53ea\u662f\u629b\u7816\u5f15\u7389\u800c\u5df2 \u81f3\u4eca\u8fd8\u6709\u4e2a\u95ee\u9898\u6ca1\u80fd\u9886\u609f(url\u5730\u5740\u8fd9\u4e2a) \u5e0c\u671b\u53ef\u4ee5\u6709\u9ad8\u4eba\u6307\u70b9\u4e00\u4e0b \u8c22\u8c22\u4e86\uff01<\/p>\n

------------------------------------\u534e\u4e3d\u7684\u5206\u5272\u7ebf--------------------------------------------<\/p>\n

'\u663e\u793a\u76f8\u5173\u6587\u7ae0
'ChannelID
'Y_ArticleID:\u6570\u503c\u578b\uff0c\u5f53\u524d\u6587\u7ae0ID
'Y_Key:\u5b57\u7b26\u578b\uff0c\u5f53\u524d\u6587\u7ae0\u5173\u5065\u5b57
'Num:\u6570\u503c\u578b\uff0c\u8981\u663e\u793a\u76f8\u5173\u6587\u7ae0\u7684\u6761\u6570
'Y_Time:\u6570\u503c\u578b\uff0c\u663e\u793a\u65f6\u95f4\uff0c\uff10\u4e3a\u4e0d\u663e\u793a\uff0c\u5426\u5219\u4e3a\u65f6\u95f4\u683c\u5f0f<\/p>\n

Function ShowMutualityArticle(ChannelID,Y_ID,Y_Key,Num,Y_Time)
    dim pSql,Y_DTime
 dim i,TempKeyWord
 ShowMutualityArticle = ""
 if Num > 0 then
  pSql = "Select TOP "& Num
 else
  pSql = "Select "
 end if
 pSql = pSql & " ID,Tid,Title,Fname,AddDate From [KS_Article] Where ID <> "& Y_ID &" And " 
 if Instr(Y_Key,"|") > 0 then
  Y_Key = Split(Y_Key,"|")
  TempKeyWord = TempKeyWord &"("
  For i = 0 to Ubound(Y_Key)
   TempKeyWord = TempKeyWord &" KeyWords like '%"& Y_Key(i) &"%' or KeyWords like '%,"& Y_Key(i) &",%' or KeyWords like '%"& Y_Key(i) &",%' or KeyWords like '%,"& Y_Key(i) &"%' "
   if i = Ubound(Y_Key) then
    TempKeyWord = TempKeyWord &") And "
   else
    TempKeyWord = TempKeyWord &" Or "
   end if
  Next
 else
  TempKeyWord = TempKeyWord &" KeyWord like '%"& Y_Key &"%' And "
 end if
 pSql = pSql & TempKeyWord &" Verific = 1 And DelTF = 0 Order By ID Desc"
    dim rs:set rs=conn.execute(pSql)
 If rs.eof and rs.bof then
  ShowMutualityArticle = "<li>\u6ca1\u6709\u76f8\u5173\u6587\u7ae0<\/li>"
 Else
  do while not (rs.eof or rs.bof)
'   LinkUrl = KS.GetItemURL(ChannelID,rs(1),rs(0),rs(3))       \u5c31\u662f\u8fd9\u4e2a\u5f97\u5230\u6587\u7ae0\u5730\u5740\u7684\u8001\u662f\u51fa\u9519\uff01\u770b\u4e86\u4e0a\u4e00\u7bc7\u4e0b\u4e00\u7bc7\u7684\u5c31\u662f\u8fd9\u4e48\u5199\u7684\uff0c\u4e0d\u77e5\u9053\u4e3a\u4ec0\u4e48\u5230\u6211\u8fd9\u91cc\u5c31\u51fa\u9519\uff01<\/span>
   If Y_Time>0 then
    Y_DTime = "<span>"&rs(4)&"<\/span>"
   End If
   ShowMutualityArticle = ShowMutualityArticle &"<li>"& Y_DTime &"<a href=""\/?"& GCls.StaticPreContent &"-"& rs(0) &"-1.html"">"&rs(2)&"<\/a><\/li>"
   rs.movenext
  loop
 End If
 rs.close:set rs = nothing
End Function<\/p>\n

----------------------------------------------------------------\u534e\u4e3d\u7684\u5206\u5272\u7ebf\u7ed3\u675f----------------------------------------------------------------<\/p>\n

\u518d\u8be6\u7ec6\u9875\u9762\u53ef\u4ee5\u7528\uff1a{=ShowMutualityArticle({$channelid},{$InfoID},{$yGetArticleKeyWord},10,0)} <\/span>\u8c03\u7528
\u6548\u679c\u5df2\u7ecf\u5b9e\u73b0 \u5177\u4f53\u7684 \u6709\u7a7a\u4e86\u518d\u505a\u8be6\u7ec6\u8bf4\u660e \u4e0d\u80fd\u518d\u5199\u4e86 \u8981\u4e0d\u5c31\u6709\u4e8b\u4e86\uff01\u5475\u5475\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"\u4f7f\u7528\u79d1\u8bafCMS \u81f3\u5c11\u5728\u73b0\u5728\u7684\u4f7f\u7528\u4e2d\u611f\u89c9\u8fd8\u662f\u4e2a\u4e0d\u9519\u7684CMS \u53ef\u662f \u4e0d\u77e5\u9053\u4e3a\u4ec0\u4e48 \u7cfb\u7edf\u81ea\u5e26\u7684\u76f8\u5173\u4fe1\u606f \u611f\u89c9\u7528\u7740\u5f88\u4e0d \u00b7\u00b7\u00b7","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"views":323,"_links":{"self":[{"href":"http:\/\/blog.yyhcw.com\/api\/wp\/v2\/posts\/20"}],"collection":[{"href":"http:\/\/blog.yyhcw.com\/api\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.yyhcw.com\/api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.yyhcw.com\/api\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.yyhcw.com\/api\/wp\/v2\/comments?post=20"}],"version-history":[{"count":0,"href":"http:\/\/blog.yyhcw.com\/api\/wp\/v2\/posts\/20\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.yyhcw.com\/api\/wp\/v2\/media?parent=20"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.yyhcw.com\/api\/wp\/v2\/categories?post=20"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.yyhcw.com\/api\/wp\/v2\/tags?post=20"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}