{"id":7673,"date":"2019-12-12T10:51:10","date_gmt":"2019-12-12T02:51:10","guid":{"rendered":"http:\/\/www.hefeiyu.com\/?p=7673"},"modified":"2020-04-02T13:52:20","modified_gmt":"2020-04-02T05:52:20","slug":"hfy%e6%b3%9b%e5%be%ae%e8%af%ad%e5%8f%a5%e5%b8%b8%e7%94%a8%e8%ae%b0%e5%bd%95","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=7673","title":{"rendered":"hfy\u6cdb\u5fae\u8bed\u53e5\u5e38\u7528\u8bb0\u5f55"},"content":{"rendered":"<p>1\u3001\u680f\u4f4d\u663e\u793a\u56fe\u7247\uff1a\u63d2\u5165-\u56fe\u7247\uff1a\u56fe\u7247\u5730\u5740\uff1a\/images\/logobd.jpg<\/p>\n<p>2\u3001\u5360\u7528\u4e00\u683c\u7684\u4ee3\u7801\uff1a\u63d2\u5165-\u4ee3\u7801\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">&lt;style&gt;\r\ntextarea {\r\n width:98%!important;\r\n}\r\n&lt;\/style&gt; <\/code><\/pre>\n<p>3\u3001\u5b57\u6bb5\u8054\u52a8\u8bbe\u7f6e<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.hefeiyu.com\/wp-content\/uploads\/2019\/12\/f6bd5cfc771735b742271fa1c8c9bfbc.png\" \/><\/p>\n<p>4\u3001\u589e\u52a0JS\u793a\u4f8b\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">&lt;script type=\"text\/javascript\"&gt;\r\n\r\njQuery(document).ready(function(){\r\n\tvar submitFun = window.doSubmit;\r\n\twindow.doSubmit = function(obj) {\r\n            setvalue();\r\n\t\tsubmitFun(obj);\r\n\t};\r\n});\r\n\r\nfunction setvalue(){\r\n\tvar djhj=jQuery(\"#field7162\").val();\/\/\u5355\u4ef7\u5408\u8ba1\r\n\tvar zjhj=jQuery(\"#field7161\").val();\/\/\u603b\u4ef7\u5408\u8ba1\r\n\tif(djhj&lt;300 &amp;&amp; zjhj&lt;2000){\r\n\t\tjQuery(\"#field8365\").val(\"0\");\/\/\r\n\t}else{\r\n\t\tjQuery(\"#field8365\").val(\"1\");\/\/\r\n\t}\r\n}\r\n&lt;\/script&gt;\r\n<\/code><\/pre>\n<p>\u6709\u65f6\uff0c\u6807\u51c6\u529f\u80fd\u201c\u663e\u793a\u5c5e\u6027\u8054\u52a8\u201d\u4e2d\u7684\u8bbe\u7f6e\u5b57\u6bb5\u662f\u5426\u5fc5\u586b\uff0c\u5e76\u4e0d\u80fd\u8fbe\u5230\u9700\u6c42\u6548\u679c\u3002\u8fd9\u65f6\u5c31\u9700\u8981\u501f\u52a9JS\u811a\u672c\u4e86\u3002<\/p>\n<p>\u8f93\u5165\u6846\u548c\u6d4f\u89c8\u6846\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">\/**\r\n * \u8bbe\u7f6e\u5b57\u6bb5\u5fc5\u586b\/\u9009\u586b\r\n * @param {boolean} necessary true-\u5fc5\u586b;false-\u9009\u586b\r\n * @param {string} fieldId \u5b57\u6bb5id\uff0c\u5982field12121\r\n * @param {string} spanImgId \u754c\u9762\u201c\uff01\u201did\uff0c\u901a\u5e38\u4e3afield12121span\uff0c\u6d4f\u89c8\u6846\u4e3afield12121spanimg\r\n *\/\r\nfunction setNecessityOfField(necessary,fieldId, spanImgId){\r\n    var viewtype=necessary?\"1\":\"0\";\r\n    $('#' + fieldId).attr('viewtype', viewtype);\r\n    var oldFieldStr = $('input[name=needcheck]').val();\r\n    if(necessary){\r\n        newFieldStr=oldFieldStr.indexOf(fieldId)!=-1?oldFieldStr:oldFieldStr +',' +fieldId;\r\n    }else{\r\n        newFieldStr=oldFieldStr.replace(','+fieldId, '');\r\n    }\r\n    $('input[name=needcheck]').val(newFieldStr);\r\n    if(necessary&amp;&amp;$('#' + fieldId).val()!=\"\"){\r\n        return;\r\n    }\r\n    var html=necessary?'&lt;img src=\"\/images\/BacoError_wev8.gif\" align=\"absMiddle\"&gt;':'';\r\n    $('#' + spanImgId).html(html);\r\n}\r\n\r\n\u9644\u4ef6\u5b57\u6bb5\uff1a\r\n\/**\r\n * \u8bbe\u7f6e\u9644\u4ef6\u5b57\u6bb5\u5fc5\u586b\/\u9009\u586b\r\n * @param {boolean} neccessary true-\u5fc5\u586b;false-\u9009\u586b\r\n * @param {string} fieldId \u5b57\u6bb5id\uff0c\u5982field12121\r\n * @param {string} spanId \u754c\u9762\u201c\uff08\u5fc5\u586b\uff09\u201did\uff0c\u9644\u4ef6\u5b57\u6bb5\u4e3afield_12121span\r\n *\/\r\nfunction setNecessityOfEnclosureField(neccessary, fieldId) {\r\n var viewtype = neccessary ? \"1\" : \"0\";\r\n $('#' + fieldId).attr('viewtype', viewtype);\r\n var oldFieldStr = $('input[name=needcheck]').val();\r\n if (neccessary) {\r\n newFieldStr = oldFieldStr.indexOf(fieldId) != -1 ? oldFieldStr : oldFieldStr + ',' + fieldId;\r\n } else {\r\n newFieldStr = oldFieldStr.replace(',' + fieldId, '');\r\n }\r\n $('input[name=needcheck]').val(newFieldStr);\r\n if (neccessary &amp;&amp; $('#' + fieldId).val() != \"\") {\r\n return;\r\n }\r\n var spanId = fieldId.replace(\"field\", \"field_\") + \"span\";\r\n var html = neccessary ? \"\uff08\u5fc5\u586b\uff09\" : \"\";\r\n $('#' + spanId).html(html);\r\n}\r\n<\/code><\/pre>\n<p>&nbsp;<\/p>\n<p>5\u3001\u89e6\u53d1\u5668\u5199\u6cd5\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">SET ANSI_NULLS ON\r\nGO\r\nSET QUOTED_IDENTIFIER ON\r\nGO\r\n-- =============================================\r\n-- Author:\t\thefeiyu\r\n-- Create date: 2019-11-22\r\n-- Description:\tHR\u89e6\u53d1\u5668\u540c\u6b65\u7ed9OA\r\n-- =============================================\r\nCREATE TRIGGER JobClass_To_OA\r\n   ON  [dbo].[T_HR_JobClass]\r\n   AFTER INSERT,UPDATE\r\nAS \r\nBEGIN\r\n    DECLARE @OldName NVARCHAR(150)\r\n\tDECLARE @NewName NVARCHAR(150)\r\n    DECLARE @Id INT\r\n    DECLARE @IsHave INT\r\n\t-- SET NOCOUNT ON added to prevent extra result sets from\r\n\t-- interfering with SELECT statements.\r\n\tSET NOCOUNT ON;\r\n\t--\u5224\u65ad\u8be5\u89e6\u53d1\u64cd\u4f5c\u662fInsert \u8fd8\u662fDelete ,\u83b7\u53d6Name,\u6ce8\u610f\u4fee\u6539\u52a8\u4f5c\u662finset delete\u540c\u65f6\u8fdb\u884c\u7684\r\n\tSELECT  @OldName = JobClassName FROM Deleted\r\n    SELECT  @NewName = JobClassName FROM Inserted\r\n    --\u6839\u636e\u5f97\u5230\u7684Name \u83b7\u53d6OA\u4e2d\u662f\u5426\u5b58\u5728\u540c\u6837\u6570\u636e\r\n    --SELECT @IsHave = COUNT(0) FROM  [192.168.0.19].[ecology].[dbo].[HrmJobGroups] WHERE [jobgroupname] = @OldName\r\n\tSELECT @Id = ID FROM  [192.168.0.19].[ecology].[dbo].[HrmJobGroups] WHERE [jobgroupname] = @OldName\r\n\r\n\tIF (@OldName IS NOT NULL and @Id IS NOT NULL)\r\n          BEGIN\r\n                UPDATE [192.168.0.19].[ecology].[dbo].[HrmJobGroups]\r\n                SET [jobgroupname] = @OldName\r\n                WHERE [ID] = @Id \r\n\t      END \r\n     ELSE\r\n         BEGIN\r\n                INSERT INTO [192.168.0.19].[ecology].[dbo].[HrmJobGroups]\r\n                        ([jobgroupname],[jobgroupremark])\r\n                VALUES (@NewName,@NewName)\r\n     END\r\nEND\r\nGO\r\n\r\n\r\n<\/code><\/pre>\n<p>6\u3001OA\u66f4\u65b0\u4eba\u5458\u5f52\u5c5e\u5730<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">--select rygd from formtable_main_73\r\n\r\nupdate formtable_main_104 set rygsd=(select locationid from HrmResource where id=shenqr)\r\n   where shenqr in(select id from HrmResource) and rygsd is null\r\n\r\n--select * from HrmResource\r\n\r\n\r\nselect * from formtable_main_74 where danh='FI04-2019100003'\r\n\r\nselect * from formtable_main_75 where danh='FI05-2019100004'\r\n\r\nupdate formtable_main_74 set fygsd=(select locationid from HrmResource where id=shenqr)\r\n   where danh='FI04-2019100003'<\/code><\/pre>\n<p>7\u3001OA\u66f4\u65b0\u62a5\u9500\u5355\u636e\u6ca1\u6709\u5408\u8ba1\u91d1\u989d<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">select * from formtable_main_64 where danh='FI01-2019080024'\r\n\r\nselect * from formtable_main_64_dt1 where mainid=(select id from formtable_main_64 where danh='FI01-2019080024')\r\n\r\n--\u5dee\u65c5\u8d39\u7528\u62a5\u9500\r\nupdate formtable_main_64_dt1 set bxxj=ISNULL(jpf,0)+ISNULL(hcf,0)+ISNULL(ctqcf,0)+ISNULL(cf,0)+ISNULL(snjt,0)+ISNULL(zsf,0)+ISNULL(ccbz,0)+ISNULL(zdf,0)+ISNULL(qt,0)+ISNULL(cyf,0)\r\n where mainid=(select id from formtable_main_64 where danh='FI01-2019090095')\r\n\r\nupdate formtable_main_64 set \r\nbxje=(select ISNULL(jpf,0)+ISNULL(hcf,0)+ISNULL(ctqcf,0)+ISNULL(cf,0)+ISNULL(snjt,0)+ISNULL(zsf,0)+ISNULL(ccbz,0)+ISNULL(zdf,0)+ISNULL(qt,0)+ISNULL(cyf,0) \r\n      from formtable_main_64_dt1 where mainid=(select id from formtable_main_64 where danh='FI01-2019090095')),\r\njedx=(select ISNULL(jpf,0)+ISNULL(hcf,0)+ISNULL(ctqcf,0)+ISNULL(cf,0)+ISNULL(snjt,0)+ISNULL(zsf,0)+ISNULL(ccbz,0)+ISNULL(zdf,0)+ISNULL(qt,0)+ISNULL(cyf,0) \r\n       from formtable_main_64_dt1 where mainid=(select id from formtable_main_64 where danh='FI01-2019090095')) \r\n\t   where danh='FI01-2019090095'\r\n\r\n--select ISNULL(jpf,0)+ISNULL(hcf,0)+ISNULL(ctqcf,0)+ISNULL(cf,0)+ISNULL(snjt,0)+ISNULL(zsf,0)+ISNULL(ccbz,0)+ISNULL(zdf,0)+ISNULL(qt,0) \r\n--from formtable_main_64_dt1 where mainid=(select id from formtable_main_64 where danh='FI01-2019080024')\r\n\r\nselect * from formtable_main_64_dt1  where mainid=(select id from formtable_main_64 where danh='FI01-2019090095')<\/code><\/pre>\n<p>8\u3001OA\u6539\u5355\u636e\u5404\u79cd\u65e5\u671f<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">select * from formtable_main_59 where danh='FI09-2019080009'\r\n\r\nupdate formtable_main_91 set shenqrq='2019-04-08' where danh='QC03-2019080126'\r\n\r\n\r\nselect * from workflow_requestlog where requestid=52026\r\n\r\nupdate workflow_requestlog set operatedate='2019-04-08' where requestid=49233\r\n\r\nselect * from workflow_requestbase where requestid=52026\r\n\r\nupdate workflow_requestbase set requestname='\u53d7\u63a7\u6587\u4ef6\u4f1a\u7b7e-\u5f20\u7434-2019-04-08',createdate='2019-04-08',\r\n                               lastoperatedate='2019-04-08',requestnamenew='\u53d7\u63a7\u6587\u4ef6\u4f1a\u7b7e-\u5f20\u7434-2019-04-08' where requestid=49233\r\n\r\nselect * from workflow_requestlog where requestid=52026 and nodeid=1473\r\n\r\nupdate workflow_requestlog set remark='\u540c\u610f&lt;br\/&gt;' where requestid=52026 and nodeid=1473<\/code><\/pre>\n<p>9\u3001OA\u629b\u6765\u6570\u636e\u88ab\u5220\u9664\u540e\u91cd\u65b0\u751f\u6210\u8bed\u53e5<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\"> INSERT INTO npp_file(\r\n              nppsys,npp00,npp01,npp011,npp02,\r\n              npp03,npp04,npp05,npp06,npp07,\r\n              nppglno,npptype,npplegal,npp08 \r\n             ) \r\n            SELECT 'OA' nppsys,'2' npp00,tc_apa01 npp01,1 npp011,tc_apa02 npp02,\r\n              NULL npp03,NULL npp04,NULL npp05,tc_apa100 npp06,'00' npp07,\r\n              NULL nppglno,'0' npptype,tc_apa100 npplegal,NULL npp08 \r\n              FROM tc_apa_file \r\n             WHERE tc_apa00 ='OA'\r\n               AND tc_apa01 = 'FI01-2019040084'\r\n\r\n\r\n--#\u5355\u8eabnpq_file:1-\u501f\u65b9:\u8d39\u7528\u79d1\u76ee1\r\nINSERT INTO npq_file(\r\n              npqsys,npq00,npq01,npq011,npq02,\r\n              npq03,npq04,npq05,npq06,npq07f,\r\n             npq07,npq08,npq11,npq12,npq13,\r\n              npq14,npq15,npq21,npq22,npq23,\r\n              npq24,npq25,npq26,npq27,npq28,\r\n              npq29,npq30,npq31,npq32,npq33,\r\n              npq34,npq35,npq36,npq37,npq930,\r\n              npqtype,npqlegal \r\n             ) \r\n             SELECT 'OA' npqsys,'2' npq00,tc_apa01 npq01,1 npq011,1 npq02,\r\n              tc_apa51 npq03,tc_apa25 npq04,CASE WHEN x.aag05='Y' THEN tc_apa22 ELSE NULL END npq05,'1' npq06,tc_apa31 npq07f,\r\n              tc_apa31 npq07,NULL npq08,CASE WHEN TRIM(x.aag15) IS NULL THEN NULL ELSE gen02 END npq11,NULL npq12,NULL npq13,\r\n              NULL npq14,NULL npq15,NULL npq21,NULL npq22,tc_apaud01 npq23,\r\n              tc_apa13 npq24,tc_apa14 npq25,NULL npq26,NULL npq27,NULL npq28, \r\n              NULL npq29,tc_apa100 npq30,NULL npq31,NULL npq32,NULL npq33,\r\n              NULL npq34,NULL npq35,null npq36,NULL npq37,NULL npq930,'0' npqtype,tc_apalegal npqlegal \r\n              FROM tc_apa_file,gen_file,(SELECT aag01,aag05,aag15 FROM aag_file WHERE aag00='00') x \r\n                  WHERE tc_apa00 ='OA'\r\n               AND tc_apa01 = 'FI01-2019040084'\r\n                   AND tc_apa06=gen01(+) AND tc_apa51=x.aag01(+) \r\n\r\n  \r\n-- #\u5355\u8eabnpq_file:1-\u501f\u65b9:\u589e\u503c\u7a0e2\r\n--IF g_tc_apa.tc_apa32&gt;0 THEN\r\n\r\n INSERT INTO npq_file(\r\n              npqsys,npq00,npq01,npq011,npq02,\r\n              npq03,npq04,npq05,npq06,npq07f,\r\n              npq07,npq08,npq11,npq12,npq13,\r\n              npq14,npq15,npq21,npq22,npq23,\r\n              npq24,npq25,npq26,npq27,npq28,\r\n              npq29,npq30,npq31,npq32,npq33,\r\n              npq34,npq35,npq36,npq37,npq930,\r\n              npqtype,npqlegal \r\n             ) \r\n             SELECT 'OA' npqsys,'2' npq00,tc_apa01 npq01,1 npq011,2 npq02,\r\n              tc_apa52 npq03,tc_apa25 npq04,CASE WHEN x.aag05='Y' THEN tc_apa22 ELSE NULL END npq05,'1' npq06,tc_apa32 npq07f,\r\n              tc_apa32 npq07,NULL npq08,CASE WHEN TRIM(x.aag15) IS NULL THEN NULL ELSE gen02 END npq11,NULL npq12,NULL npq13,\r\n              NULL npq14,NULL npq15,NULL npq21,NULL npq22,tc_apaud01 npq23,\r\n              tc_apa13 npq24,tc_apa14 npq25,NULL npq26,NULL npq27,NULL npq28, \r\n              NULL npq29,tc_apa100 npq30,NULL npq31,NULL npq32,NULL npq33,\r\n              NULL npq34,NULL npq35,null npq36,NULL npq37,NULL npq930,'0' npqtype,tc_apalegal npqlegal \r\n              FROM tc_apa_file,gen_file,(SELECT aag01,aag05,aag15 FROM aag_file WHERE aag00='00') x \r\n                  WHERE tc_apa00 ='OA'\r\n               AND tc_apa01 = 'FI01-2019040084'\r\n                   AND tc_apa06=gen01(+) AND tc_apa52=x.aag01(+) and tc_apa32&gt;0\r\n\r\n  \r\n--  #\u5355\u8eabnpq_file:2-\u8d37:\u94f6\u884c\u5b58\u6b3e\r\n INSERT INTO npq_file(\r\n              npqsys,npq00,npq01,npq011,npq02,\r\n              npq03,npq04,npq05,npq06,npq07f,\r\n              npq07,npq08,npq11,npq12,npq13,\r\n              npq14,npq15,npq21,npq22,npq23,\r\n              npq24,npq25,npq26,npq27,npq28,\r\n              npq29,npq30,npq31,npq32,npq33,\r\n              npq34,npq35,npq36,npq37,npq930,\r\n              npqtype,npqlegal \r\n             ) \r\n             SELECT 'OA' npqsys,'2' npq00,tc_apa01 npq01,1 npq011,3 npq02,\r\n              tc_apa101 npq03,tc_apa25 npq04,CASE WHEN x.aag05='Y' THEN tc_apa22 ELSE NULL END npq05,'2' npq06,tc_apa34 npq07f,\r\n              tc_apa34 npq07,NULL npq08,CASE WHEN TRIM(x.aag15) IS NULL THEN NULL ELSE gen02 END npq11,NULL npq12,NULL npq13,\r\n              NULL npq14,NULL npq15,NULL npq21,NULL npq22,tc_apaud01 npq23,\r\n              tc_apa13 npq24,tc_apa14 npq25,NULL npq26,NULL npq27,NULL npq28, \r\n              NULL npq29,tc_apa100 npq30,NULL npq31,NULL npq32,NULL npq33,\r\n              NULL npq34,NULL npq35,null npq36,NULL npq37,NULL npq930,'0' npqtype,tc_apalegal npqlegal \r\n              FROM tc_apa_file,gen_file,(SELECT aag01,aag05,aag15 FROM aag_file WHERE aag00='00') x \r\n                   WHERE tc_apa00 ='OA'\r\n               AND tc_apa01 = 'FI01-2019040084'\r\n                   AND tc_apa06=gen01(+) AND tc_apa101=x.aag01(+)\r\n<\/code><\/pre>\n<p>10\u3001OA\u4fee\u6539\u8bc4\u8bba<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">select * from workflow_requestlog where requestid=46432\r\n\r\nupdate workflow_requestlog set remark='\u5220\u9664\u4e86\u65b9\u592a\u7684\u8d39\u7528' where requestid=46432 and operatetime='12:21:44'\r\n\r\nupdate workflow_requestlog set remark='\u5965\u514b\u65af\u4e5f\u5220\u9664' where requestid=46432 and operatetime='11:53:39'<\/code><\/pre>\n<p>11\u3001OA\u4fee\u6539\u5b57\u6bb5\u7c7b\u578b<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">select * from workflow_billfield where billid=-188 and fieldlabel=-11951\r\n\r\nselect * from htmllabelindex where indexdesc='\u7535\u963b\u526a\u811a-52E\u7535\u963b(\u9f50\u811a)'\r\n-11951\t\u7535\u963b\u526a\u811a-52E\u7535\u963b(\u9f50\u811a)\r\n\r\nselect * from workflow_bill where tablename='formtable_main_188'\r\n\r\nselect * from workflow_browserurl where labelid=-11951\r\n\r\nselect * from formtable_main_188\r\n\r\nselect * from          where billid=13630\r\n\r\n\r\n--\u6539\u7b2c\u4e00\u6b65\r\nalter table formtable_main_188 alter column d1 int;\r\nalter table formtable_main_188 alter column d2 int;\r\nalter table formtable_main_188 alter column d3 int;\r\n\r\n--\u6539\u7b2c\u4e8c\u6b65\r\nupdate workflow_billfield set fielddbtype='int',fieldhtmltype=1,type=2 where billid=-188 and fieldname='d1';\r\nupdate workflow_billfield set fielddbtype='int',fieldhtmltype=1,type=2 where billid=-188 and fieldname='d2';\r\nupdate workflow_billfield set fielddbtype='int',fieldhtmltype=1,type=2 where billid=-188 and fieldname='d3';<\/code><\/pre>\n<p>12\u3001OA\u5458\u5de5\u501f\u6b3e\u5f02\u5e38\u5904\u7406<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">INSERT INTO dgapr.tc_apa_file\r\nSELECT * FROM tc_apa_file WHERE tc_apa01 IN(\r\nSELECT tc_apa01 FROM tc_apa_file WHERE tc_apa01 LIKE 'FI05-%'\r\n  AND tc_apa01 NOT IN(SELECT tc_apa01 FROM dgapr.tc_apa_file)\r\n AND tc_apa01 NOT IN('FI05-2018120002')\r\n) \r\n\r\nSELECT * FROM tc_apb_file WHERE tc_apb01 LIKE 'FI05-2018120002%'\r\n\r\nSELECT * FROM amp.npp_file  WHERE npp01 LIKE 'FI05-2018120002%'\r\n\r\nSELECT * FROM npq_file  WHERE npq01 LIKE 'FI05-2018120002%'\r\n\r\nINSERT INTO dgapr.npp_file\r\nSELECT * FROM npp_file WHERE npp01 IN(\r\nSELECT npp01 FROM tc_apa_file WHERE npp01 LIKE 'FI05-%' AND npp01 NOT IN(SELECT npp01 FROM dgapr.npp_file)\r\n AND npp01 NOT IN('FI05-2018120002')\r\n) \r\n\r\nINSERT INTO dgapr.npq_file\r\nSELECT * FROM npq_file WHERE npq01 IN(\r\nSELECT npq01 FROM npq_file WHERE npq01 LIKE 'FI05-%'\r\n  AND npq01 NOT IN(SELECT npq01 FROM dgapr.npq_file)\r\n AND npq01 NOT IN('FI05-2018120002')\r\n) \r\n\r\n\r\n<\/code><\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a<a href=\"https:\/\/www.hefeiyu.com\">\u8d6b\u975e\u57df<\/a> &raquo; <a href=\"https:\/\/www.hefeiyu.com\/?p=7673\">hfy\u6cdb\u5fae\u8bed\u53e5\u5e38\u7528\u8bb0\u5f55<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>1\u3001\u680f\u4f4d\u663e\u793a\u56fe\u7247\uff1a\u63d2\u5165-\u56fe\u7247\uff1a\u56fe\u7247\u5730\u5740\uff1a\/images\/logobd.jpg 2\u3001\u5360\u7528\u4e00\u683c\u7684\u4ee3\u7801\uff1a\u63d2\u5165-\u4ee3\u7801\uff1a &lt;style&gt; textarea { width:98%!important; } &lt;\/style&gt; 3\u3001\u5b57\u6bb5\u8054\u52a8 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[242,939,940],"class_list":["post-7673","post","type-post","status-publish","format-standard","hentry","category-install_set","tag-function","tag-style","tag-submitfun"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/7673","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7673"}],"version-history":[{"count":2,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/7673\/revisions"}],"predecessor-version":[{"id":7829,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/7673\/revisions\/7829"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}