{"id":502,"date":"2018-01-11T04:14:23","date_gmt":"2018-01-11T04:14:23","guid":{"rendered":"http:\/\/www.nywzjs.com\/?p=502"},"modified":"2018-01-11T04:14:23","modified_gmt":"2018-01-11T04:14:23","slug":"%e6%96%b9%e5%8d%a1%e5%9c%a8%e7%ba%bf%e4%bc%81%e4%b8%9a%e5%bb%ba%e7%ab%99%e7%b3%bb%e7%bb%9f%e5%89%8d%e5%8f%b0%e6%9d%a1%e4%bb%b6%e7%ad%9b%e9%80%89","status":"publish","type":"post","link":"http:\/\/www.nywzjs.com\/?p=502","title":{"rendered":"\u65b9\u5361\u5728\u7ebf\u4f01\u4e1a\u5efa\u7ad9\u7cfb\u7edf\u524d\u53f0\u6761\u4ef6\u7b5b\u9009"},"content":{"rendered":"

\u65b9\u5361\u5728\u7ebfASP\u7cfb\u7edf\u7684\u524d\u53f0\u7b5b\u9009\uff0c\u6548\u679c\u56fe\u5982\u4e0b\uff1a<\/p>\n

\u540e\u53f0\uff1a<\/p>\n

\"\" \u524d\u53f0\uff1a<\/p>\n

\"\"<\/p>\n

\u5b9e\u73b0\u65b9\u6cd5\uff1a<\/p>\n

\u524d\u53f0\u6839\u636e\u6570\u636e\u751f\u6210URL\uff0c\u7136\u540e\u8c03\u7528\u540e\u53f0\u6570\u636e\u3002<\/p>\n

\u6ce8\u610f\uff1a\u672c\u6b21\u4fee\u6539\u662f\u5728ISite\u4f01\u4e1a\u5efa\u7ad9\u7cfb\u7edfV1.2.3\u7684\u57fa\u7840\u4e4b\u4e0a\u4fee\u6539\u7684\u3002<\/span><\/strong><\/p>\n

\u5b9e\u73b0\u8fc7\u7a0b\uff1a<\/p>\n

1\u3001\u521b\u5efa\u5b57\u6bb5\u4e4b\u7c7b\u7684\u5c31\u4e0d\u8bf4\u4e86\uff0c\u53ea\u8bf4\u7a0b\u5e8f\u4fee\u6539\u3002<\/p>\n

2\u3001\u6784\u5efa\u6a21\u677f\u7684\u6211\u5c31\u4e0d\u8bf4\u4e86\u3002\u4e0a\u9762\u5b57\u6bb5\u663e\u793a\u7684\u4ee3\u7801\u4e3a\uff1a{$SearchFieldstr$}<\/p>\n

3\u3001JQ\u4ee3\u7801\u4e3a\uff1a<\/p>\n

$(function(){\t\t\r\n\/\/\u7b5b\u9009\u5f00\u59cb\r\n\t\t$(\"#filter li a\").click(function () {\r\n\t\t\t$(this).parents(\"ul\").children(\"li\").each(function () {\r\n\t\t\t\t$('a',this).removeClass(\"on\");\r\n\t\t\t});\t\r\n\t\t\t$(this).attr(\"class\", \"on\");\r\n\t\t\t{$If(0,{$ModuleId$},=)$}\r\n\t\t\t$(\"#filter_a\").attr(\"href\",\"\/Search\/?SearchType=1\"+RetSelecteds()); \r\n\t\t\t{$Else$}\r\n\t\t\tlocation.href = \"\/Search\/?SearchType=1\"+RetSelecteds();\r\n\t\t\t{$End If$}\t\t\t\t\r\n\t\t});\r\n\t\t\r\n\t\t\/\/\u83b7\u53d6\u4f20\u6765\u7684\u4fe1\u606f\u5e76\u53d8\u8272\r\n\t\t\/\/var fieldlist = getUrlParam('SearchFieldList');\r\n\t\tvar fieldlist = \"{$SearchFieldList$}\";\r\n\t\tvar field = fieldlist.split(\",\");\t\t\r\n\t\tfor (var i=0 ; i< field.length-1 ; i++)\r\n\t\t{\r\n\t\t\tfields = field[i].split(\"||\");\r\n\t\t\t$(\"[date='\"+fields[1]+\"']\").attr(\"class\", \"on\");\r\n\t\t}\r\n\t\t\/\/\u7b5b\u9009\u7ed3\u675f\r\n\uff5d<\/pre>\n
4\u3001\u4fee\u6539ASP\u7a0b\u5e8f\uff0c\u6253\u5f00Class\/Cls_Template.asp\u6587\u4ef6\uff0c\u5728\u7ea6580\u884c\u7684Public Function SearchChange(TemplateCode)\u51fd\u6570\u4e2d\u589e\u52a0<\/p>\n
TemplateCode=ReplaceTag(TemplateCode,\"{$SearchFieldstr$}\",Getfilter(SearchType))<\/pre>\n
\u5e76\u5728\u8be5\u6587\u4ef6\u7ed3\u5c3e\u589e\u52a0\u51fd\u6570<\/p>\n
'==============================\r\n\t'\u51fd \u6570 \u540d\uff1aGetfilter\r\n\t'\u4f5c    \u7528\uff1a\u83b7\u53d6\u7b5b\u9009\u5b57\u6bb5\r\n\t'\u53c2    \u6570\uff1aseachType \u641c\u7d22\u7c7b\u578b\r\n\t'==============================\t\r\n\tPrivate Function Getfilter(SearchType)\r\n\t\tDim sqlstr,Fieldstr,Field_option,search_Temp,SearchTypes\r\n\t\tSelect case SearchType\r\n\t\tcase 0\r\n\t\t\tSearchTypes = 1\r\n\t\tcase 1\r\n\t\t\tSearchTypes = 0\t\r\n\t\tend Select\r\n\t\tSqlstr=\"Select * From [Fk_Field] Where Fk_Field_Isfilter=1 And Fk_Field_Model=\" & SearchTypes\r\n\t\tRs.Open Sqlstr,Conn,1,1\r\n\t\tIf Not Rs.Eof Then\r\n\t\t\tFieldstr = \"\"\r\n\t\t\tWhile (Not Rs.Eof)\r\n\t\t\t\tif Rs(\"Fk_Field_Option\")<>\"\" Then\r\n\t\t\t\t\tFieldstr = Fieldstr & \"<ul id=\"\"\"&Rs(\"Fk_Field_Tag\")&\"\"\"><li> <strong>\" & Rs(\"Fk_Field_Name\") & \"<\/strong><a href=\"\"javascript:void(0);\"\" rel=\"\"\"&Rs(\"Fk_Field_Tag\")&\"\"\" date=\"\"\"\">\u5168\u90e8<\/a>\"\r\n\t\t\t\t\tField_option=Split(Rs(\"Fk_Field_Option\"),\"<br \/>\")\t\t\t\t\r\n\t\t\t\t\tFor Each search_Temp In Field_option\r\n\t\t\t\t\t\tIf Instr(search_Temp,\"||\")>0 Then\r\n\t\t\t\t\t\t\tFieldstr = Fieldstr & \" <a href=\"\"javascript:void(0);\"\" rel=\"\"\"&Rs(\"Fk_Field_Tag\")&\"\"\" date=\"\"\"&Split(search_Temp,\"||\")(0)&\"\"\">\" &Split(search_Temp,\"||\")(1)&\"<\/a>\"\r\n\t\t\t\t\t\tEnd If\r\n\t\t\t\t\tNext\r\n\t\t\t\t\tFieldstr = Fieldstr & \"<\/li><\/ul>\" &vbCrLf\r\n\t\t\t\tEnd if\r\n\t\t\t\tRs.MoveNext\r\n\t\t\tWend\r\n\t\tEnd If\r\n\t\tRs.Close\r\n\t\tGetfilter=Fieldstr\r\n\tEnd Function<\/pre>\n
\u5728\u6587\u4ef6\u7ea6840\u884c<\/p>\n
ElseIf SearchStr<>\"\" Then\r\n\t\t\tSqlstr=Sqlstr&\" And (Fk_Article_Title Like '%%\"&SearchStr&\"%%'\"\r\n\t\t\tIf SearchField<>\"\" Then\r\n\t\t\t\tsearch_TempArr=Split(SearchField,\",\")\r\n\t\t\t\tFor Each search_Temp In search_TempArr\r\n\t\t\t\t\tIf search_Temp=\"IsContent\" Then\r\n\t\t\t\t\t\tSqlstr=Sqlstr&\" Or Fk_Article_Content Like '%%\"&SearchStr&\"%%'\"\r\n\t\t\t\t\tElse\r\n\t\t\t\t\t\tSqlstr=Sqlstr&\" Or Fk_Article_Field Like '%%\"&search_Temp&\"|-Fangka_Field-|%%\"&SearchStr&\"%%'\"\r\n\t\t\t\t\tEnd If\r\n\t\t\t\tNext\r\n\t\t\tEnd If\r\n\t\t\tSqlstr=Sqlstr&\")\"\r\nEnd If<\/pre>\n
\u7684End If\u4e0a\u9762\u65b0\u589e\u52a0<\/p>\n
ElseIf SearchFieldList<>\"\" Then   '20160125\u63d0\u5347IF\u7ed3\u6784\r\n\t\t\tsearch_TempArr=Split(SearchFieldList,\",\")\r\n\t\t\tFor Each search_Temp In search_TempArr\r\n\t\t\t\tIf Instr(search_Temp,\"||\")>0 Then\r\n\t\t\t\t\tSqlstr=Sqlstr&\" And Fk_Article_Field Like '%%\"&Split(search_Temp,\"||\")(0)&\"|-Fangka_Field-|%%\"&Split(search_Temp,\"||\")(1)&\"%%'\"\r\n\t\t\t\tEnd If\r\n\t\t\tNext<\/pre>\n
\u4ee3\u7801\u3002<\/p>\n
\u5728\u7ea61051\u884cSelect Case VauleArr(2)\u4e4b\u4e0a\u4fee\u6539<\/p>\n
if SearchFieldList<>\"\" Then   '20160125\u63d0\u5347IF\u7ed3\u6784\r\n\t\t\tsearch_TempArr=Split(SearchFieldList,\",\")\r\n\t\t\tFor Each search_Temp In search_TempArr\r\n\t\t\t\tIf Instr(search_Temp,\"||\")>0 Then\t\t\t\t\t\r\n\t\t\t\t\tIf Split(search_Temp,\"||\")(0)=\"Module\" Then\r\n\t\t\t\t\t\tModule=Cint(Split(search_Temp,\"||\")(1))\r\n\t\t\t\t\t\tif Module<>0 Then\r\n\t\t\t\t\t\t\tRs.Open \"select Fk_Module_Id From [Fk_Module] Where Fk_Module_Level=\"&Module,Conn,1,1\r\n\t\t\t\t\t\t\tmodulestr=cstr(Module)\r\n\t\t\t\t\t\t\tWhile (Not Rs.Eof)\r\n\t\t\t\t\t\t\t\tmodulestr = modulestr & \",\" & rs(\"Fk_Module_Id\")\r\n\t\t\t\t\t\t\t\tRs.Movenext\r\n\t\t\t\t\t\t\tWend\r\n\t\t\t\t\t\t\tRs.Close\r\n\t\t\t\t\t\t\tSqlstr=Sqlstr&\" And Fk_Product_Module In (\"&modulestr&\")\"\r\n\t\t\t\t\t\tEnd if\r\n\t\t\t\t\tElse\r\n\t\t\t\t\t\tSqlstr=Sqlstr&\" And Fk_Product_Field Like '%%\"&Split(search_Temp,\"||\")(0)&\"|-Fangka_Field-|%%\"&Split(search_Temp,\"||\")(1)&\"%%'\"\r\n\t\t\t\t\tEnd if'20160227\u7ed3\u675f\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\tEnd If\r\n\t\t\tNext\r\n\t\tEnd if<\/pre>\n
\u4ee3\u7801\u3002<\/p>\n
\u5df2\u7ecf\u5c06\u4fee\u6539\u8fc7\u7684Cls_Template.asp\u6587\u4ef6\u4e0a\u4f20\uff0c\u53ef\u4ee5\u5bf9\u7167\u4fee\u6539\u3002<\/p>\n
\u4ee3\u7801\u6700\u7ec8\u7ed3\u679c\u5982\u4e0b\uff1aCls_Template.asp<\/a><\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
\u65b9\u5361\u5728\u7ebfASP\u7cfb\u7edf\u7684\u524d\u53f0\u7b5b\u9009\uff0c\u6548\u679c\u56fe\u5982\u4e0b\uff1a \u540e\u53f0\uff1a \u524d\u53f0\uff1a \u5b9e\u73b0\u65b9\u6cd5\uff1a \u524d\u53f0\u6839\u636e\u6570\u636e\u751f\u6210URL\uff0c\u7136\u540e\u8c03\u7528\u540e\u53f0\u6570 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[44,114,113,112],"_links":{"self":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts\/502"}],"collection":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=502"}],"version-history":[{"count":0,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=\/wp\/v2\/posts\/502\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=502"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nywzjs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}