鎽樿锛�鏈枃浠嬬垂鐨勬槸InTouch鍦ㄦ煇閱嬮吀绾栫董鏈夐檺鍏徃銆婂嫊鍔涘伐娈佃嚜鎺х郴绲�(t菕ng)鏀归€犮€嬮爡鐩腑鐨勬噳(y墨ng)鐢ㄣ€� 闂�(gu膩n)閸佃锛歩ntouch 銆€ 1. 绯荤当(t菕ng)绨′粙 銆婂嫊鍔涘伐娈佃嚜鎺х郴绲�(t菕ng)鏀归€犮€嬮爡鐩槸灏嶅崡绾栧叕鍙稿師鏈夊嫊鍔涘伐娈电殑鑷帶绯荤当(t菕ng)閫�(j矛n)琛屾敼閫犲拰鍎�(y艒u)鍖�銆傜洰妯�(bi膩o)鏄厖鍒嗗埄鐢ㄥ師鏈夎粺纭欢璩囨簮锛岀敤鏈€灏戠殑鎶曞叆鐛插緱楂樻晥銆佸畨鍏ㄧ殑绯荤当(t菕ng)鎬ц兘銆� 鍘熷嫊鍔涘伐娈靛寘鎷細鍖栨按杌婇枔銆佸喎鍑嶇┖澹撹粖闁擄紙绨＄ū鍕曞姏杌婇枔锛�銆佽粺姘寸珯鍙婁竴浜屾车鎴胯粖闁�锛屽悇鑷搧鏈夎嚜宸辩殑鎺у埗瀹�銆傛敼閫犲墠锛屽寲姘磋粖闁撳凡閲囩敤浜嗕竴濂桽IEMENS TI545 PLC 鍜屽叐鑷哄叏榛炵殑INTOUCH 鎿嶄綔绔欏鐝�(xi脿n)鐩�(ji膩n)鎺�锛屾车鎴胯粖闁撲篃宸查噰鐢ㄤ簡涓€濂桽IEMENS TI545 PLC 鍜屽叐鑷�256 榛炵殑INTOUCH 鎿嶄綔绔欏鐝�(xi脿n)鐩�(ji膩n)鎺э紝鍕曞姏杌婇枔闄�5 鑷哄绺┖姘ｅ共鐕ュ櫒閲囩敤GE 90-30PLC 鎺у埗澶栧叾浣欒ō(sh猫)鍌欑殑鐩�(ji膩n)鎺у潎鐢ㄧ洡瑁濆剙琛ㄥ鐝�(xi脿n)銆傚師鍕曞姏宸ユ绯荤当(t菕ng)绲�(ji茅)妲�(g貌u)濡備笅鍦栨墍绀恒€� 銆€銆€銆€銆€ 绯荤当(t菕ng)鏀归€犲悗锛屾车鎴胯粖闁撳拰鍕曞姏杌婇枔鐢卞師娉垫埧杌婇枔鐨凷IEMENS TI545 PLC 鎺у埗锛堥渶澧炲姞涓€浜涘崱浠讹級锛屽寲姘磋粖闁撳湪鍘熺郴绲�(t菕ng)鍩虹(ch菙)涓婂鍔犱竴浜涘姛鑳�銆傚皣鍘熸湁鐨勫叐鑷哄叏榛濱NTOUCH 鍜屼竴鑷�256 榛濱NTOUCH 绉诲叆鏂拌ō(sh猫)鐨勯泦涓帶鍒跺锛屽鐝�(xi脿n)涓夊€嬭粖闁撶殑闆嗕腑鐩�(ji膩n)鎺э紝鍦ㄥ寲姘磋粖闁撹ō(sh猫)涓€鑷�256 榛濱NTOUCH 鎿嶄綔绔�锛屼緵鐝�(xi脿n)鍫村贰鍥炴鏌ユ檪浣跨敤銆� 鍚屾檪绯荤当(t菕ng)閫氶亷涓€鑷烘柊瑷�(sh猫)鐨勬暩(sh霉)鎿�(j霉)鍙奧eb 鏈嶅嫏(w霉)鍣ㄨ垏鍏徃绠＄悊缍�(w菐ng)閫ｆ帴锛屽叕鍙稿拰宸ユ绠＄悊鑰呭彲閫氶亷鍏徃鍗€(q奴)鍩熺恫(w菐ng)鐛插彇鐢熺敘(ch菐n)閬庣▼鐨勬暩(sh霉)鎿�(j霉)鍜屽牨琛�銆� 銆€銆€銆€銆€ 2锛� 绯荤当(t菕ng)鍔熻兘鍙婄壒榛� 2.1鍐椾綑鐨勭附绶氬強鎿嶄綔绔� 绯荤当(t菕ng)鍖呭惈2 鑷哄叏榛炵殑INTOUCH锛圫ERVER1銆丼ERVER2锛夊拰2 鑷�256 榛炵殑INTOUCH锛圕LIENT1銆丆LIENT2锛�锛孲ERVER1銆丼ERVER2 鍒嗗垾閫氶亷鍚勮嚜鐨凾IWAY 鍗¤垏鍖栨按銆佹车鎴跨殑PLC 妲�(g貌u)鎴愬叐姊濆啑浣欑殑TIWAY 绺界窔銆侰LIENT1銆丆LIENT2 鍓囬€氶亷閬�(yu菐n)绋嬭畩閲忚í鍟忔煇鑷哄叏榛濱NTOUCH 涓婄殑鏁�(sh霉)鎿�(j霉)寰炶€屽鐝�(xi脿n)灏嶇従(xi脿n)鍫寸殑鐩�(ji膩n)鎺�銆傞€氬父CLIENT1銆丆LIENT2鍙垏SERVER1銆丼ERVE2 涓殑涓€鑷洪€氳▕锛岀暥(d膩ng)鐧�(f膩)鐢熼€氳▕鏁呴殰鏅傛渻鑷嫊鍢楄│鑸囧彟涓€鑷篠ERVER 閫ｆ帴銆侷NTOUCH 涓殑鈥滈€氳▕鐙€鎱�(t脿i)鈥濈暙闈㈤’绀轰簡鍚勫伐浣滅珯銆丳LC 鍙婄附绶氱殑鐣�(d膩ng)鍓嶇媭鎱�(t脿i)銆� 鍦栦腑绱呯窔琛ㄧず鎿嶄綔绔欏湪绶�锛岄粦鑹茶〃绀洪洟绶氥€傚湪CLIENT1銆丆LIENT2 鐨勨€滈€氳▕鐙€鎱�(t脿i)鈥濈暙闈腑锛屽伐绋嬪斧鍙互鎵嬪嫊鍒囨彌CLIENT 鑸嘢ERVER 鐨勯€ｆ帴銆� 2.2鈥滅槮鈥濇搷浣滅珯妯″紡 256 榛炵殑CLIENT 閫氶亷閬�(yu菐n)绋嬭畩閲忚í鍟忓叏榛炵殑SERVER 寰炶€岃í鍟廝LC锛岄€欐ǎCLIENT鐨勮畩閲忛厤缃笉瓒呴亷256榛�銆傚悓鏅傜郴绲�(t菕ng)閬嬬敤浜嗏€滃垎甯冨紡鍫辫鈥濆拰鈥滃垎甯冨紡姝峰彶瓒ㄥ嫝鈥濈瓑鍔熻兘锛屾墍鏈夌殑鍫辫瑷橀寗鍙婃鍙茶定鍕㈤兘瀛樺劜鍦ㄥ叏榛炵殑SERVER涓�锛孋LIENT涓婇’绀虹殑鍫辫鍜屾鍙茶定鍕㈡槸寰濻ERVER涓婄嵅寰楃殑?锛熸ⅱ鍝塮锛孲ERVER鍏呯暥(d膩ng)浜咺NTOUCH鏈嶅嫏(w霉)鍣ㄨ€孋LIENT鏄竴鍊婭NTOUCH 瀹㈡埗绔�锛屽彧闇€杓冧綆鐨勯厤缃嵆鍙€傜暥(d膩ng)鍒囨彌SERVER鏅�锛屸€滃垎甯冨紡鍫辫鈥濆拰鈥滃垎甯冨紡姝峰彶瓒ㄥ嫝鈥濅篃璺熻憲鑷嫊鍒囨彌銆� 1锛庘€滃垎甯冨紡鍫辫鈥濈殑瑷�(sh猫)缃� 鍦↖NTOUCH 绲勬厠(t脿i)涓渶鐢ㄢ€滃垎甯冨紡鍫辫鈥濇帶浠�锛屽湪鎺т欢鐨勫牨璀︽煡瑭㈡瑒涓几鍏モ€淺\SERVER1\INTOUCH!DONGLI鈥�锛孲ERVER1 鐐虹己鐪侀€ｆ帴鐨勮▓绠楁鍚�锛孌ONGLI 琛ㄧずINTOUCH 涓殑DONGLI 鍫辫绲勶紙鍫辫绲勫寘鎷珼ONGLI銆丠S锛夈€傚湪SERVER 鐨勮▓绠楁灞€ч渶閬镐腑鈥滄湰姗熷皣鎻愪緵鍫辫鈥�锛涜€屽湪CLIENT 鐨勮▓绠楁灞€т腑闇€閬镐腑鈥滄湰姗熷皣椤ず鍫辫鈥濄€傞亱琛屾檪CLIENT 灏囬€氶亷鍑芥暩(sh霉)鍒囨彌鑸嘢ERVER 鐨勯€ｆ帴銆� 鐐轰簡绲�(t菕ng)涓€鍫辫瑷�(sh猫)缃�锛屾垜鍊戝皣鍫辫鍋氬湪PLC 鐨勫牨璀︽ā濉婁腑閫氶亷灏峆LC 璁婇噺鈥淎HA锛堝牨璀︿笂闄愶級銆丄HHA锛堝牨璀︿笂涓婇檺锛�銆丄LA锛堝牨璀︿笅闄愶級銆丄LLA锛堝牨璀︿笅涓嬮檺锛�銆丄PV锛堝牨璀﹂亷绋嬪€硷級銆丄VF锛堝牨璀︾媭鎱�(t脿i)瀛楋級鈥濈殑璁€瀵締鍒ゆ柗鍜岃ō(sh猫)缃牨璀�銆傛湁鍫辫鐧�(f膩)鐢熸檪锛屽彧鏈塖ERVER 鏈冨皣鍫辫淇℃伅瀵叆鍫辫瑷橀寗锛孲ERVER2 鍦ㄥ鍫辫淇℃伅鍓嶅厛鍒ゆ柗SERVER1鏄惁鍦ㄩ亱琛�锛屼互鍏嶉噸寰�(f霉)瀵叆銆� 2锛庘€滃垎甯冨紡姝峰彶瓒ㄥ嫝鈥濈殑瑷�(sh猫)缃紙浠ERVER1 鐐轰緥锛� 鍦⊿ERVER 鐨処NTOUCH 绲勬厠(t脿i)涓渶灏囨鍙叉暩(sh霉)鎿�(j霉)鐨勫瓨鏀捐矾寰戣ō(sh猫)鐐篒NTOUCH 榛樿獚(r猫n)璺緫銆侰LIENT 鐨処NTOUCH 绲勬厠(t脿i)闇€鍦ㄢ€滃垎甯冨紡鍚嶇ū绠＄悊鍣ㄢ€濅腑鐨勨€滃垎甯冨紡姝峰彶鈥濋噷娣诲姞涓€闋�锛屼緵鎳�(y墨ng)鍣ㄥ悕绋辩偤鈥淪ERVER1鈥�锛岃矾寰戠偤鈥淺\SERVER1\D\NCFC2000S1鈥濓紙宸ョ▼璺緫锛夊嵆鍙�銆傚湪CLIENT 涓í鍟廠ERVER1 鐨勬鍙叉暩(sh霉)鎿�(j霉)闇€瀵垚鈥淪ERVER1.TAGNAME鈥�銆係ERVER2 鐨勮ō(sh猫)缃垏SERVER1 鐩稿悓銆� 3锛庨仩(yu菐n)绋嬭畩閲忕殑寮曠敤 鍦–LIENT 涓婁娇鐢ㄩ仩(yu菐n)绋嬭畩閲忓彧闇€鍦ㄨ畩閲忓悕鍓嶅姞瑷堢畻姗� 鍚嶅嵆鍙�锛岀劇闇€鍦ㄦ(bi膩o)瑷樺悕瀛楀吀涓柊寤鸿畩閲忥紝鎵€浠ヤ笉鍗犻粸鏁�(sh霉)銆傦紙SERVER锛歍AGNAME锛� 4锛庤嚜鍕曞垏鎻涘姛鑳� CLIENT 閫氶亷閬�(yu菐n)绋嬭畩閲忚瀵烻ERVER 涓婄殑$Second 璁婇噺锛岃嫢瀹冨湪鍦ㄤ竴娈垫檪闁撳収(n猫i)鐒¤畩鍖栧墖琛ㄦ槑鑸嘢ERVER 鐨勯€ｆ帴鍑虹従(xi脿n)鍟忛锛岄€欐檪鍙€氶亷SetAccessName 鍑芥暩(sh霉)灏嘋LIENT 涓婄殑閬�(yu菐n)绋嬭畩閲忓垏鎻涘埌鍙︿竴鑷篠ERVER 涓娿€� 2.3鍏敤鐨勬搷浣滅獥鍙� 绯荤当(t菕ng)涓皪浜庡叿鏈夌浉鍚屾搷浣滄帴鍙ｈō(sh猫)鍌欎娇鐢ㄤ簡鍏敤鐨勬搷浣滅獥鍙�锛岃€屼笉鏄皪鎳�(y墨ng)姣忓€嬭ō(sh猫)鍌欓兘鍓�(chu脿ng)寤轰竴鍊嬫搷浣滅獥鍙�锛岄€欐ǎ澶уぇ娓涘皯浜嗙獥鍙ｇ殑鏁�(sh霉)閲�銆傚鐝�(xi脿n)瀹冮渶瑕佺敤鍒伴枔鎺ヨ畩閲忥紝鍙互灏囬枔鎺ヨ畩閲忕湅浣滀竴鍊嬫寚閲�锛岀暥(d膩ng)灏嶆煇鍊嬭ō(sh猫)鍌欐搷浣滄檪锛屽埄鐢ㄩ枔鎺ヨ畩閲忔寚鍚戞搷浣滆畩閲�锛岄€欐ǎ锛屽皪闁撴帴璁婇噺鐨勮肠鍊煎氨鏈冧綔鐢ㄥ埌鎿嶄綔璁婇噺涓�锛屾搷浣滆畩閲忕殑璁婂寲涔熸渻鍙嶆噳(y墨ng)鍒伴枔鎺ヨ畩閲忎笂銆� 浠ラ亷婵炬按娉电偤渚�锛屽湪閬庢烤姘磋檿鐞嗙郴绲�(t菕ng)涓紝榛炴搳3#閬庢烤娉�锛屽綀鍑烘搷浣滅獥鍙�锛屽涓嬪湒鎵€绀猴細 3#閬庢烤娉电殑鎿嶄綔璁婇噺鐐衡€淩UN-3#GLB锛堝暉鍕曪級鈥濄€佲€淪TOP-3#GLB锛堝仠姝級鈥�銆佲€淩L-3#GLB锛堝弽楗嬶級鈥�銆佲€淎UTO-3#GLB锛堣嚜鍕曪級鈥濄€佲€淩EPAIR-3#GLB锛堟淇級鈥濋粸鎿婇亷婵炬车鏅傚煼(zh铆)琛岃獮鍙ワ細 DL_START.NAME=RUN-3#GLB.NAME锛� DL_STOP.NAME=STOP-3#GLB.NAME锛� DL_RL.NAME = RL-3#GLB.NAME锛� AUTO.NAME = AUTO-3#GLB.NAME锛� DL_REPAIR.NAME=REPAIR-3#GLB.NAME锛� 鈥淒L_XXX鈥濈偤闁撴帴璁婇噺銆傚湪鎿嶄綔绐楀彛涓彧闇€灏嶉枔鎺ヨ畩閲忚肠鍊煎嵆鍙€備緥濡傚湪鈥滃暉鍕曗€濇寜閳曠殑鍕曚綔灞€т腑瀵埌锛� IF DL_START.Name<>"NULL" AND DL_STOP.Name<>"NULL" THEN DL_START=1; DL_STOP=0; Record=DL_START.Comment; SQLInsert锛� ConnectionId, "CortrolLog", "CortrolLog" 锛�; //瀵搷浣滅磤(j矛)閷� ELSE IF DL_START.Name = = "NULL" THEN DL_STOP=0; Record=StringLeft锛� DL_STOP.Comment, StringLe锛圖L_STOP.Comment 锛�/2 锛�; SQLInsert锛� ConnectionId, "CortrolLog", "CortrolLog" 锛�; ELSE DL_START=1; Record=StringLeft锛� DL_START.Comment, StringLen锛圖L_START.Comment 锛�/2 锛�; SQLInsert锛� ConnectionId, "CortrolLog", "CortrolLog" 锛�; ENDIF; ENDIF; 鍥犵偤瑷�(sh猫)鍌欑殑鍟熷仠涓€鑸湁鍏╃ó锛�1.鍟熷嫊鑸囧仠姝㈡槸涓€鍊嬭几鍑�锛�2.鍟熷嫊鑸囧仠姝㈡槸鍏╁€嬭几鍑�銆傜偤涓€鍊嬭几鍑烘檪鎴戝€戝皣杓稿嚭璁婇噺鐨凜OMMENT 灞€у鐐衡€淴XX 鍟熷嫊XXX 鍋滄鈥濋€欐ǎ锛屽湪瀵搷浣滆閷勬檪闇€鍙朇OMMENT 鐨勫乏涓€鍗婃垨鍙充竴鍗�锛涜嫢鐐哄叐鍊嬭几鍑烘檪锛岃畩閲忕殑COMMENT 灏囩偤鈥淴XX 鍟熷嫊鈥濇垨鈥淴XX 鍋滄鈥�锛屽瑷橀寗鏅傚彇灏嶆噳(y墨ng)璁婇噺鐨凜OMMENT鍗冲彲銆� CLIENT 鐨勬儏娉佹瘮杓冪壒娈�锛屽洜鐐篊LIENT 闇€鐢ㄩ枔鎺ヨ畩閲忔寚鍚戦仩(yu菐n)绋嬭畩閲�锛岃€岄仩(yu菐n)绋嬭畩閲忕殑COMMENT 鐒℃硶璩︾郸闁撴帴璁婇噺鐨凜OMMENT锛屾墍浠ョ偤浜嗗湪鍏敤绐楀彛涓嵅寰楅仩(yu菐n)绋嬭畩閲忕殑COMMENT 鎴戝€戝彧鑳藉埄鐢ㄩ枔鎺ヨ畩閲忕殑NAME锛堝嵆閬�(yu菐n)绋嬭畩閲忕殑NAME锛夊湪鏁�(sh霉)鎿�(j霉)搴腑鏌ユ壘鍒癈OMMENT锛屽啀瀵搷浣滆閷�銆傝獮鍙ュ涓嬶細锛堝瑷橀寗鐨勬搷浣滃弮瑕嬧€滄暩(sh霉)鎿�(j霉)搴殑鎳�(y墨ng)鐢ㄢ€�銆傦級 IF DL_START.Name<>"NULL" AND DL_STOP.Name<>"NULL" THEN DL_START=1; DL_STOP=0; Record=StringRight锛� DL_START.Name ,StringLen锛� DL_START.Name 锛�-7 锛�; SQLSelect锛� ConnectionId, "COMM", "COMMENT", "device_id="+"鈥�"+Record + "鈥�" , "" 锛�; //鏌ユ壘COMMENT SQLFirst锛� ConnectionId 锛�; Record=StringTrim锛� COM, 3 锛�; SQLEnd锛� ConnectionId 锛�; SQLInsert锛� ConnectionId, "CortrolLog", "CortrolLog" 锛�; //瀵搷浣滅磤(j矛)閷� ELSE IF DL_START.Name=="NULL" THEN DL_STOP=0; Record=StringRight锛� DL_STOP.Name ,StringLen锛� DL_STOP.Name 锛�-7 锛�; SQLSelect锛� ConnectionId, "COMM", "COMMENT", "device_id="+"鈥�"+Record + "鈥�" , "" 锛�; SQLFirst锛� ConnectionId 锛�; Record=StringTrim锛� COM, 3 锛�; Record=StringLeft锛� Record, StringLen锛� Record 锛�/2 锛�; SQLEnd锛� ConnectionId 锛�; www.it168.com SQLInsert锛� ConnectionId, "CortrolLog", "CortrolLog" 锛�; ELSE DL_START=1; Recor d=StringRight锛� DL_START.Name ,StringLen锛� DL_START.Name 锛�-7 锛�; SQLSelect锛� ConnectionId, "COMM", "COMMENT", "device_id="+"鈥�"+Record + "鈥�" , "" 锛�; SQLFirst锛� ConnectionId 锛�; Record=StringTrim锛� COM, 3 锛�; Record=StringLeft锛� Record, StringLen锛� Record 锛�/2 锛�; SQLEnd锛� ConnectionId 锛�; SQLInsert锛� ConnectionId, "CortrolLog", "CortrolLog" 锛�; ENDIF; ENDIF; 2.4鏁�(sh霉)鎿�(j霉)搴殑鎳�(y墨ng)鐢� 绯荤当(t菕ng)涓殑IBM 鏈嶅嫏(w霉)鍣ㄤ綔鐐烘暩(sh霉)鎿�(j霉)瀛樺劜鍜岀櫦(f膩)甯冪殑鏈嶅嫏(w霉)鍣紝瀹夎浜哠QL SERVER 2000锛岀郴绲�(t菕ng)鐨勫牨璀︽鍙茶閷勫拰鎿嶄綔瑷橀寗浠ュ強瑷�(sh猫)鍌欐獢妗堥兘瀛樻斁鍦ㄥ悕鐐衡€淒L鈥� 鐨勬暩(sh霉)鎿�(j霉)搴腑銆� 2.4.1 ODBC鐨勯€ｆ帴 INTOUCH 閫氶亷ODBC 瑷晱SQL SERVER锛屽湪ODBC 涓缓绔嬪悕鐐衡€淒L鈥濈殑鐢ㄦ埗DSN锛屽湪INTOUCH 涓敤瑾炲彞锛� SQLConnect锛� ConnectionId, "DSN=DL"锛�锛� 寤虹珛閫ｆ帴锛岃嫢閫ｆ帴鎴愬姛鍓嘋onnectionId > 0 銆傚湪鍩�(zh铆)琛屾瘡涓€姊漇QL 瑾炲彞鏅傞兘鏈冩湁涓€鍊嬭繑鍥炲€�锛岃嫢杩斿洖鍊肩偤0 鍓囪〃绀哄煼(zh铆)琛屾垚鍔燂紝鍚﹀墖琛ㄧず鑸囨暩(sh霉)鎿�(j霉)搴€ｆ帴涓嶆甯�锛岄渶閲嶆柊寤虹珛閫ｆ帴銆傜偤浜嗘檪鍒绘娓垏鏁�(sh霉)鎿�(j霉)搴湇鍕�(w霉)鍣ㄧ殑閫ｆ帴鎯呮硜锛屽湪鎳�(y墨ng)鐢ㄧ▼搴忚叧鏈腑姣�5 绉掗悩鍩�(zh铆)琛屼竴姊濇煡瑭㈣獮鍙ワ細 IF ResultCode = = 0 THEN ResultCode = SQLSelect锛圕onnectionId , "SYSUSERS" ,"SYSUSERS","UID=0", "" 锛�锛� ENDIF锛� 鍚屾檪鍦ㄦ浠惰叧鏈腑鍒ゆ柗ResultCode 锛堝嵆杩斿洖鍊硷級鑻esultCode <> 0 鍓囨柗闁嬮€ｆ帴锛� SQLDisconnect锛� ConnectionId 锛夛紱 ConnectionId = 0锛� SHOW 鈥滈€氳▕鐙€鎱�(t脿i)鈥�锛� 鎵撻枊鈥滈€氳▕鐙€鎱�(t脿i)鈥濈暙闈�锛岄’绀轰俊鎭€滆垏鏈嶅嫏(w霉)鍣ㄩ€ｆ帴澶�?銆傘€€濂斿晩鐖稿崷鍤�?銆佲€滃彇娑堚€濆叐鍊嬫寜閳�銆傛寜鈥滈噸瑭︹€�锛岀疆浣嶇郴绲�(t菕ng)灏囨瘡20 绉掗€�(j矛n)琛屼竴娆″槜瑭﹂€ｆ帴锛� IF RETRY = = 1 THEN ResultCode = SQLConnect锛� ConnectionId, "DSN=DL"锛�锛� ENDIF锛� 鐩村埌ResultCode = 0 鐐烘銆� 鍢楄│閫ｆ帴鏅傜郴绲�(t菕ng)灏囪畩寰楀緢蹇欍€傝嫢鎯冲彇娑堥€ｆ帴锛屽墖鎸夆€滃彇娑堚€濇寜閳曪紝绯荤当(t菕ng)灏囦笉鍐嶈垏鏈嶅嫏(w霉)鍣ㄩ€ｆ帴锛屽皪鐝�(xi脿n)鍫� 鐨勭洠(ji膩n)鎺у彲浠ユ甯搁€�(j矛n)琛岋紝浣嗘搷浣滆垏鍫辫瑷橀寗閮藉皣涓嶅鍏ユ湇鍕�(w霉)鍣紙鏁�(sh霉)鎿�(j霉)鐧�(f膩)甯冧笉鍙楀奖闊匡級銆傚笇鏈涢噸鏂伴€ｆ帴鏈嶅嫏(w霉)鍣ㄦ檪锛屽彧闇€鍦ㄢ€滈€氳▕鐙€鎱�(t脿i)鈥濈暙闈笅鎸夆€滈噸瑭︹€濇寜閳曞嵆鍙�銆� 2.4.2 缍佸畾鍒楄〃 鍦ㄥ叏榛濱NTOUCH 涓渶寤虹珛鍥涘€嬬秮瀹氬垪琛細鈥渁larmhis鈥�锛屸€渃ortrolog鈥�锛屸€渄evice鈥濓紝鈥渟ysusers鈥濆垎鍒ュ皪鎳�(y墨ng)鏁�(sh霉)鎿�(j霉)搴腑鐨勮〃鏍�?锛佺殜ysusers鈥濆彧鏄偤浜嗘鏌DBC 閫ｆ帴鐢ㄧ殑锛屽苟鐒″叾浠栫敤铏�銆傚湪姣忓€嬪垪琛ㄤ腑鐢ㄨ畩閲忚垏鍚勫瓧娈电浉灏嶆噳(y墨ng)锛屽鈥渃ortrolog鈥� 涓畩閲忊€淒ATETIME鈥� 灏嶆噳(y墨ng)瀛楁鈥淒ATETIME鈥� 锛涜畩閲忊€�$OPERATER鈥濆皪鎳�(y墨ng)瀛楁鈥淯SERNAME鈥� 锛涜畩閲忊€淩ECORD鈥濆皪鎳�(y墨ng)瀛楁鈥淩ECORD鈥濈瓑銆傚湪瀵閷勫墠锛屽彧闇€鍏堝皪璁婇噺寰�(f霉)鍊�锛屽啀鍩�(zh铆)琛岃獮鍙ワ細 SQLInsert锛� ConnectionId, "CortrolLog", "CortrolLog" 锛�锛� 鍗冲彲銆� 鏌ヨ瑷橀寗鏅�锛岄鍏堟簴(zh菙n)鍌欎竴鍊嬫煡瑭㈡浠讹紝渚嬪鍦ㄢ€滅█绀睜娑蹭綅鈥濈殑鍕曚綔鑵虫湰涓湁浠ヤ笅瑾炲彞 DEVICE_ID= LT51027.Name; ShowAt锛�"瑷�(sh猫)鍌欐獢妗�",$ObjHor +200, $ObjVer +50锛�; SQLSelect锛� ConnectionId , "DevICE" , "DevICE" , "Device_ID=" + "鈥�"+ device_id +"鈥�" , "" 锛�; SQLFirst锛� ConnectionId 锛�; 棣栧厛灏囪鏌ヨ鐨勮ō(sh猫)鍌欏悕锛圠T51027锛夎肠绲EVICE_ID銆� 鈥淪QLSelect鈥濊獮鍙ュ闅涗笂鍩�(zh铆)琛屼簡涓€姊漇QL 瑾炲彞锛� SELECT 锛� FROM DEVICE WHERE DEVICE_ID = 鈥楲T51027鈥� 鍚庡皣鏌ヨ鍒扮殑瑷橀寗鐨勫瓧娈靛€艰肠绲︾秮瀹氬垪琛ㄤ腑鐨勮畩閲忋€傞€欐ǎ鍦ㄨō(sh猫)鍌欐獢妗堜腑閲�锛屽彧瑕佹斁涓婄秮瀹� 鍒楄〃涓殑璁婇噺灏辫兘椤ず鏌ヨ鐨勭祼(ji茅)鏋滀簡銆備笅鍦栫偤寰炴暩(sh霉)鎿�(j霉)搴腑鏌ュ埌鐨勮ō(sh猫)鍌欌€� LT51027鈥欑殑淇℃伅銆� 3 绠＄悊灞ゆ噳(y墨ng)鐢ㄧ▼搴� 鏈変簡鏁�(sh霉)鎿�(j霉)搴腑鐨勨€滄搷浣滆閷勨€�銆佲€滃牨璀﹁閷勨€濆拰鈥滆ō(sh猫)鍌欐獢妗堚€濓紝鍙互鏂逛究鐨勯枊鐧�(f膩)绠＄悊灞ゆ噳(y墨ng)鐢ㄧ▼搴�銆備笅鍦栨槸鐢―elphi 闁嬬櫦(f膩)鐨勪竴鍊嬪鎴剁杌熶欢锛岀敤渚嗘煡瑭㈣閷勫強缍(h霉)瑷�(sh猫)鍌欐獢妗�锛屽畠鍙互閬嬭鍦ㄥ伐绋嬪斧鐨凱C 涓娿€� 鍙﹀锛屽埄鐢↖ntouch 鐨凬ETDDE 鍔熻兘锛屽彲灏囩敓鐢�(ch菐n)鏁�(sh霉)鎿�(j霉)瀵︽檪鍦伴€氶亷绗笁鏂硅粺浠堕€�(j矛n)琛岀櫦(f膩)甯�锛岄€欓噷娑夊強鏇村鐨勮粺浠剁法绋嬫妧琛�(sh霉)锛屽氨涓嶅湪娣卞叆浜�銆備笅鍦栫偤灏囨暩(sh霉)鎿�(j霉)浠EB 鐨勬柟寮忛€�(j矛n)琛岀櫦(f膩)甯冦€� 绲�(ji茅)鏉熻獮 浠ヤ笂鐨勬暩(sh霉)鎿�(j霉)搴強WEB 鍔熻兘涔熷彲浠ラ€氶亷IndustrialSQL Sever 鍜孲uiteVoyager 瀵︾従(xi脿n)锛屼互涓婄殑鎳�(y墨ng)鐢ㄥ彲浠ヨ鏄嶪nTouch 鐒¤珫鍦ㄨ叧鏈拰绗笁鏂硅粺浠剁殑鎺ュ彛鏂归潰閮芥槸闈炲父闈堟椿鐨�銆傚湪閬庡幓锛岀祫鎱�(t脿i)杌熶欢寰€寰€鍙嚌灏嶄笅浣嶆锛屼竴鍊嬫帶鍒剁郴绲�(t菕ng)閫氬父鑸囧鐣岄殧闆�锛屾垚鐐轰俊鎭宄�锛屼娇鐢↖ntouch 鍙互鍋氬埌杌婇枔灞よ垏绠＄悊灞ょ殑绶婂瘑绲�(ji茅)鍚�锛岀鐞嗚€呭彲浠ュ湪杈﹀叕瀹ら噷鐎忚鍒扮敓鐢�(ch菐n)涓€绶氱殑鏁�(sh霉)鎿�(j霉)锛屼娇浼佹キ(y猫)浠ユ洿楂樼殑鏁堢巼閫�(j矛n)琛岀敓鐢�(ch菐n)鍜岀鐞�銆�