{"id":1461,"date":"2024-06-05T20:42:13","date_gmt":"2024-06-05T12:42:13","guid":{"rendered":"http:\/\/www.jh1999.cn\/?p=1461"},"modified":"2024-11-22T10:42:57","modified_gmt":"2024-11-22T02:42:57","slug":"intraweb%e9%80%9a%e7%94%a8%e6%95%b0%e6%8d%ae%e6%9f%a5%e8%af%a2","status":"publish","type":"post","link":"http:\/\/www.jh1999.cn\/?p=1461","title":{"rendered":"Intraweb\u6570\u636e\u7684\u901a\u7528\u67e5\u8be2\u65b9\u6cd5"},"content":{"rendered":"<div class=\"gb-container gb-container-3310355e\">\n\n<p class=\"wp-block-paragraph\">Intraweb + MSSQL\u63a7\u4ef6\u5f00\u53d1WEB\u5e94\u7528\u670d\u52a1\uff0c\u80fd\u5b8c\u7f8e\u5b9e\u73b0\u6570\u636e\u7684\u589e\u5220\u67e5\u6539\u64cd\u4f5c\u3002\u6570\u636e\u67e5\u627e\u662fWEB\u5e94\u7528\u4e2d\u4f7f\u7528\u6700\u591a\u7684\u529f\u80fd\uff0c\u5f00\u53d1\u4eba\u5458\u9488\u5bf9\u6bcf\u4e2a\u754c\u9762\u8bbe\u8ba1\u67e5\u8be2\u4ee3\u7801\uff0c\u4f1a\u8d39\u65f6\u8d39\u529b\u3002\u5efa\u7acb\u4e00\u4e2a\u6bcdFORM\uff0c\u6bcdFORM\u4e2d\u8bbe\u8ba1\u597d\u6570\u636e\u901a\u7528\u67e5\u8be2\u4ee3\u7801\uff0c\u518d\u7ee7\u627f\u7ed9\u5b9e\u4f8bFORM\uff0c\u5c06\u80fd\u4e8b\u534a\u529f\u500d\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">WEB\u5e94\u7528\u670d\u52a1\u5929\u751f\u5bf9\u7f51\u7edc\u5e26\u5bbd\u654f\u611f\uff0c\u6240\u4ee5\u6bcf\u6b21\u4e0d\u80fd\u53d6\u592a\u591a\u7684\u6570\u636e\uff0c\u5e76\u4e14\u6570\u636e\u8981\u5206\u6bb5\u4e0b\u8f7d\u5206\u9875\u663e\u793a\uff0c\u6267\u884c\u67e5\u8be2\u65f6\u52a8\u6001\u7f16\u8f91SQL\u8bed\u53e5\u91cd\u53d6\u6570\u636e\uff0c\u662f\u6700\u4f73\u65b9\u6848\u3002\u4e0b\u9762\u662f\u5b9e\u9645\u5e94\u7528\u573a\u666f\u7684\u4ee3\u7801\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u52a8\u6001\u751f\u6210\u8fc7\u6ee4\u6761\u4ef6\u7684\u51fd\u6570\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>function TIWUserSession.getWhere(sField,sValue:String):string;\nvar\n  sWhere,sValu2,sSign:String;\n  iPosit:Integer;\nbegin\n  sWhere:='';\n  if (pos(',',sValue)&gt;0) then\n  begin\n    while pos(',',sValue)&gt;0 do\n    begin\n      iPosit:=pos(',',sValue);\n      sValu2:=copy(sValue,1,iPosit-1);\n      if sWhere='' then\n          sWhere:='(&#91;'+sField+']'+'='+''''+sValu2+''''\n      else\n          sWhere:=sWhere+' or '+'&#91;'+sField+']'+'='+''''+sValu2+'''';\n      sValue:=copy(sValue,iPosit+1,length(sValue));\n    end;\n    if sValue&gt;'' then sWhere:=sWhere+' or '+'&#91;'+sField+']'+'='+''''+sValue+'''';\n    sWhere:=sWhere+')';\n  end else\n  begin\n    sValu2:='';\n    if(copy(sValue,1,2)='&gt;=')or(copy(sValue,1,2)='&lt;=') then\n    begin\n      sSign:=copy(sValue,1,2);\n      sValue:=copy(sValue,3,length(sValue)-2);\n    end else if(copy(sValue,1,1)='&gt;')or(copy(sValue,1,1)='&lt;') then\n    begin\n      sSign:=copy(sValue,1,1);\n      sValue:=copy(sValue,2,length(sValue)-1);\n    end else if(pos('..',sValue)&gt;0) then\n    begin\n      iPosit:=pos('..',sValue);\n      sSign:='between';\n      sValu2:=copy(sValue,iPosit+2,length(sValue)-iPosit-1);\n      sValue:=copy(sValue,1,iPosit-1);\n    end else if (pos('Date',sField)&gt;0) or (pos('Qty',sField)&gt;0) or (pos('Price',sField)&gt;0) then\n      sSign:='='\n    else\n      sSign:='like';\n    if sSign='between' then\n      sWhere:=sField+' '+sSign+' '+''''+sValue+''''+' and '+''''+sValu2+''''\n    else if sSign='like' then\n      sWhere:='CharIndex('+''''+sValue+''''+','+sField+')&gt;0' \n    else\n      sWhere:=sField+' '+sSign+''''+sValue+''''; \n  end;\n  Result:=sWhere;\nend;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u6267\u884c\u67e5\u8be2\u7684\u4ee3\u7801\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>procedure TfmwiqInsRep.btnTop1Click(Sender: TObject);\nvar\n  sWhere:String;\nbegin\n  \/\/inherited;\n  \/\/240906\u641c\u7d22\u4e0d\u7528Filter\u6539\u7528\u65b0SQL\u91cd\u53d6\u6570\u636e\n  sWhere:=UserSession.getWhere(cbbField.SelectedValue,trim(edtFind.Text));\n  try\n    qMaster.Close;\n    if rdgStatu.ItemIndex = 0 then\n      qMaster.SQL.Text:=sFixSql+' and IqcStatu&lt;''3'' and '+sWhere+' '+sOrderSql\n    else\n      qMaster.SQL.Text:=sFixSql+' and IqcStatu=''3'' and '+sWhere+' '+sOrderSql;\n    qMaster.Open;\n  except on E:Exception do\n    begin\n      webApplication.ShowMessage(E.Message);\n    end;\n  end;\nend;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">SqlServer2008\u5f00\u59cb\uff0c\u5bf9Decimal\u7c7b\u578b\u7684\u680f\u4f4d\u5f88\u53cb\u597d\uff0c\u4e0b\u8ff0SQL\u90fd\u6b63\u786e\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select * from w_IqcTempCk where ckMax&gt;700\nselect * from w_IqcTempCk where ckMax&gt;'700'\nselect * from w_IqcTempCk where ckMax like '1220%'\nselect * from w_IqcTempCk where CharIndex('1220',ckMax)&gt;0<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"600\" src=\"http:\/\/www.jh1999.cn\/wp-content\/uploads\/2024\/06\/PhotoKit_071104-.png\" alt=\"\" class=\"wp-image-2333\" style=\"width:515px;height:auto\" srcset=\"http:\/\/www.jh1999.cn\/wp-content\/uploads\/2024\/06\/PhotoKit_071104-.png 800w, http:\/\/www.jh1999.cn\/wp-content\/uploads\/2024\/06\/PhotoKit_071104--300x225.png 300w, http:\/\/www.jh1999.cn\/wp-content\/uploads\/2024\/06\/PhotoKit_071104--768x576.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n<\/div>\n<div class=\"gb-shapes\"><div class=\"gb-shape gb-shape-1\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 1200 131\" preserveAspectRatio=\"none\"><path d=\"M1200 0L899 110 687 6 410 75 154.8 20 0 70v61h1200z\"\/><\/svg><\/div><\/div><\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Intraweb + MSSQL\u63a7\u4ef6\u5f00\u53d1WEB\u5e94\u7528\u670d\u52a1\uff0c\u80fd\u5b8c\u7f8e\u5b9e\u73b0\u6570\u636e\u7684\u589e\u5220\u67e5\u6539\u64cd\u4f5c\u3002\u6570\u636e\u67e5\u627e\u662fWEB\u5e94\u7528\u4e2d\u4f7f &#8230; <a title=\"Intraweb\u6570\u636e\u7684\u901a\u7528\u67e5\u8be2\u65b9\u6cd5\" class=\"read-more\" href=\"http:\/\/www.jh1999.cn\/?p=1461\" aria-label=\"Read more about Intraweb\u6570\u636e\u7684\u901a\u7528\u67e5\u8be2\u65b9\u6cd5\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1461","post","type-post","status-publish","format-standard","hentry","category-kfbj"],"_links":{"self":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts\/1461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1461"}],"version-history":[{"count":11,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts\/1461\/revisions"}],"predecessor-version":[{"id":2337,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=\/wp\/v2\/posts\/1461\/revisions\/2337"}],"wp:attachment":[{"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1461"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jh1999.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}