鎮ㄧ従(xi脿n)鍦ㄧ殑浣嶇疆锛� 涓湅(gu贸)鍌冲嫊(d貌ng)缍�(w菐ng) > 鎶€琛�(sh霉)闋婚亾 > 鎳�(y墨ng)鐢ㄦ柟妗� > 涓栫磤(j矛)鏄熺祫鎱�(t脿i)杌熶欢寮�(qi谩ng)澶х殑鏁�(sh霉)鎿�(j霉)搴煡瑭㈠嚱鏁�(sh霉)

涓栫磤(j矛)鏄熺祫鎱�(t脿i)杌熶欢寮�(qi谩ng)澶х殑鏁�(sh霉)鎿�(j霉)搴煡瑭㈠嚱鏁�(sh霉)

鏅�(sh铆)闁擄細2010-08-06 14:40:43渚嗘簮锛歾hangting

灏�(d菐o)瑾烇細?鍦ㄧ祫鎱�(t脿i)杌熶欢涓�锛屾垜鍊戝悓妯ｅ彲浠ュ(sh铆)鐝�(xi脿n)灏�(du矛)鏁�(sh霉)鎿�(j霉)鐨勫瓨鍎�(ch菙)锛屾煡瑭�锛屼慨鏀�锛岀董璀�(h霉)绛夋搷浣�锛岀啛鎮変笘绱€(j矛)鏄熻粺浠剁殑澶у鎳�(y墨ng)瑭插皪(du矛)閫欏€�(g猫)鍑芥暩(sh霉)姣旇純鐔熸倝

銆€銆€鏁�(sh霉)鎿�(j霉)搴紝鐩镐俊澶у閮戒笉闄岀敓锛屾暩(sh霉)鎿�(j霉)瀛樺劜(ch菙)锛屾煡瑭紝淇敼锛岀董璀�(h霉)锛岄€欎簺閮芥槸鎴戝€戣缍�(j墨ng)甯稿皪(du矛)鏁�(sh霉)鎿�(j霉)鎿嶄綔鐨�锛屽湪绲勬厠(t脿i)杌熶欢涓紝鎴戝€戝悓妯ｅ彲浠ュ(sh铆)鐝�(xi脿n)灏�(du矛)鏁�(sh霉)鎿�(j霉)鐨勫瓨鍎�(ch菙)锛屾煡瑭紝淇敼锛岀董璀�(h霉)绛夋搷浣�锛岀啛鎮変笘绱€(j矛)鏄熻粺浠剁殑澶у鎳�(y墨ng)瑭插皪(du矛)閫欏€�(g猫)鍑芥暩(sh霉)姣旇純鐔熸倝锛寊dbQueryData( 鈥淐ontrolName鈥�, Fields, TableName, Condition );鏁�(sh霉)鎿�(j霉)搴〃鏍兼姊濅欢鏌ヨ鍑芥暩(sh霉)锛屾垜鍊戝彲浠ラ€氶亷閫欏€�(g猫)鍑芥暩(sh霉)锛�

銆€銆€鎸囧畾鎺т欢鍚嶏紙鈥淐ontrolName鈥濓級锛�
銆€銆€鎸囧畾鎴戝€戣椤ず鐨勮〃闋紙Fields锛夛紝鈥溾€�
銆€銆€鎸囧畾鎴戝€戣鏌ヨ鏁�(sh霉)鎿�(j霉)搴腑鐨勮〃锛圱ableName锛�
銆€銆€鎸囧畾鏌ヨ姊濅欢锛圕ondition锛�锛�

銆€銆€鐛插緱鎴戝€戦渶瑕佺殑鏌ヨ鏁�(sh霉)鎿�(j霉)鍏�(n猫i)瀹癸細
銆€銆€渚嬪锛歾dbQueryData (鈥滄暩(sh霉)鎿�(j霉)搴〃鏍兼帶浠垛€�,鈥滄棩鏈熸檪(sh铆)闁�,璁婇噺鍚嶇ū,鏁�(sh霉)鎿�(j霉)鈥�,鈥淗istDataTable鈥�,鈥滆畩閲忓悕绋�=鈥樺弽鎳�(y墨ng)缃愭韩搴︹€� AND 鏃ユ湡鏅�(sh铆)闁撱€�=鈥�1996骞�08鏈�15鏃� 08鏅�(sh铆)30鍒�00绉掆€� AND 鏃ユ湡鏅�(sh铆)闁撱€�=鈥�1996骞�08鏈�15鏃� 10鏅�(sh铆)30鍒�00绉掆€欌€�);

銆€銆€鎴戝€戜締鐪嬩竴涓嬫煡瑭㈡浠讹細
璁婇噺鍚嶇ū=鈥樺弽鎳�(y墨ng)缃愭韩搴︹€� AND 鏃ユ湡鏅�(sh铆)闁撱€�=鈥�1996骞�08鏈�15鏃� 08鏅�(sh铆)30鍒�00绉掆€� AND 鏃ユ湡鏅�(sh铆)闁撱€�=鈥�1996骞�08鏈�15鏃� 10鏅�(sh铆)30鍒�00绉掆€�

銆€銆€鏌ヨ姊濅欢鏈�3鍊�(g猫)绱勬潫璁婇噺鍚嶇ū=鈥樺弽鎳�(y墨ng)缃愭韩搴︹€�
銆€銆€鏃ユ湡鏅�(sh铆)闁撱€�=鈥�1996骞�08鏈�15鏃� 08鏅�(sh铆)30鍒�00绉掆€�
銆€銆€鏃ユ湡鏅�(sh铆)闁撱€�=鈥�1996骞�08鏈�15鏃� 10鏅�(sh铆)30鍒�00绉掆€�

銆€銆€鐝�(xi脿n)鍦ㄥ鏋滄垜鍊戞兂鍐嶆坊鍔犱竴鍊�(g猫)鏌ヨ姊濅欢鏈�(hu矛)鎬庝箞妯�锛熷彲鑳藉ぇ瀹舵渻(hu矛)瑾紝灏卞湪鏌ヨ姊濅欢鐨勪綅缃湪鍔犱竴鍊�(g猫)锛屽ソ澶у鍕�(d貌ng)鎵嬭│椹�(y脿n)涓€涓嬪惂锛�

銆€銆€澶у蹇界暐浜嗕竴鍊�(g猫)鍟忛锛屼笘绱€(j矛)鏄熺殑瀛楃涓查鍨嬭畩閲忕殑闀�(zh菐ng)搴﹀彧鏈�131鍊�(g猫)瀛楃瘈(ji茅)锛屽湪涓栫磤(j矛)鏄熼噷闈㈡墍浣跨敤鐨勬墍鏈夌殑瀛楃涓茬殑闀�(zh菐ng)搴︿篃鏄�131鍊�(g猫)瀛楃銆傚墰鎵嶄笂闈㈢殑鏌ヨ姊濅欢绲�(t菕ng)瑷�(j矛)涓€涓�锛屽ぇ绱勬湁100鍊�(g猫)瀛楃鐨勬ǎ瀛愶紝閭ｄ箞锛屾垜鍊�?c猫)鍋爲鍙崇矉鈧�(g猫)澶т竴榛�(di菐n)鐨勬煡瑭㈡浠朵笂鍘伙紝杌熶欢灏辨渻(hu矛)鍫�(b脿o)閷�(cu貌)鎻愮ず瀛楃涓查暦(zh菐ng)搴﹁秴閬�131鍊�(g猫)瀛楃锛�

銆€銆€涓栫磤(j矛)鏄熸湰钁椾互浜虹偤鏈�銆佺鎶€鍓�(chu脿ng)鏂�銆佽拷姹傚崜瓒婄殑淇″康锛岄枊鐧�(f膩)鍑轰簡鏇村姞寮�(qi谩ng)澶х殑鏁�(sh霉)鎿�(j霉)搴煡瑭㈠嚱鏁�(sh霉)zdbQueryData2锛�

銆€銆€zdbQueryData2鍑芥暩(sh霉)鏄笘绱€(j矛)闀�(zh菐ng)绉嬬鎶€鏈夐檺鍏徃閲濆皪(du矛)zdbQueryData鍑芥暩(sh霉)鏌ヨ姊濅欢鍙兘闄愬埗鍦�131鍊�(g猫)瀛楃鐨勫晱椤屽張鐛�(d煤)鍏峰尃蹇冪殑闁嬬櫦(f膩)鍑虹殑寮�(qi谩ng)澶х殑鏁�(sh霉)鎿�(j霉)搴煡瑭㈠嚱鏁�(sh霉)銆備笅闈㈣畵鎴戝€戜締鐪嬩竴涓嬪嚱鏁�(sh霉)鐨勬牸寮忋€�

銆€銆€zdbQueryData2(鈥淐ontrolName鈥�, Fields, TableName,鈥淐dt1鈥�,鈥淐dt2鈥�,鈥淐dt3鈥�,鈥淐dt4鈥�,鈥淐dt5鈥�,鈥淐dt6鈥�,鈥淐dt7鈥�,鈥淐dt8鈥�);

銆€銆€绱�(x矛)蹇冧箣浜轰竴瀹氭渻(hu矛)鐧�(f膩)鐝�(xi脿n)瑭插嚱鏁�(sh霉)鍜寊dbQueryData鍙婂叾鐩镐技锛屽彧鏄湪鏌ヨ姊濅欢涓婃垜鍊戞斁浜�8鍊�(g猫)锛屽彲瑕嬫垜鍊戠殑闁嬬櫦(f膩)浜哄摗鐨勮壇鑻︾敤蹇�锛岄€欐ǎ澶у鍦ㄦ帴瑙告柊鍑芥暩(sh霉)鏅�(sh铆)灏遍潪甯稿鏄撲笂鎵嬶紝鍜屼箣鍓嶇殑鍑芥暩(sh霉)淇濇寔涓€鑷�锛�

涓嬮潰璁撴垜绲﹀ぇ瀹惰垑鍊�(g猫)渚嬪瓙锛�

銆€銆€Cdt1鈥�(璁婇噺鍚嶇ū=鈥樺弽鎳�(y墨ng)缃愭韩搴︹€橭R鈥�;
銆€銆€Cdt2=鈥滆畩閲忓悕绋�=鈥樺弽鎳�(y墨ng)缃愭恫浣嶁€�) AND鈥�;
銆€銆€Cdt3=鈥淎ND鏃ユ湡鏅�(sh铆)闁撱€�=鈥�1996骞�08鏈�15鏃� 08鏅�(sh铆)30鍒�00绉掆€欌€�;
銆€銆€Cdt4=鈥淎ND鏃ユ湡鏅�(sh铆)闁撱€�=鈥�1996骞�08鏈�15鏃� 10鏅�(sh铆)30鍒�00绉掆€欌€�;
銆€銆€zdbQueryData2(鈥滄暩(sh霉)鎿�(j霉)搴〃鏍兼帶浠垛€�,鈥滄棩鏈熸檪(sh铆)闁�,璁婇噺鍚嶇ū,鏁�(sh霉)鎿�(j霉)鈥�,鈥淗istDataTable鈥�, Cdt1, Cdt2, Cdt3, Cdt4,鈥溾€�,鈥溾€�,鈥溾€�,鈥溾€�);

銆€銆€澶у姛鍛婃垚锛�
銆€銆€浠ュ悗灏辨槸鍐嶅鐨勬煡瑭㈡浠朵篃涓嶆槸鍟忛鍟︼紒鍝堝搱锛�

娉ㄦ剰锛�
銆€銆€鏌ヨ姊濅欢鐨勫煼(zh铆)琛岄爢搴�锛屽姊濅欢鏌ヨ姊濅欢鍩�(zh铆)琛岀殑闋嗗簭寰堥噸瑕�锛屽緢瀹规槗鏌ヨ鍑轰締鐨勫収(n猫i)瀹逛笉鏄偍闇€瑕佺殑鍏�(n猫i)瀹�锛屽彲浠ヤ娇鐢ㄢ€滐紙锛夆€濅締鏀硅畩鏌ヨ姊濅欢鐨勫煼(zh铆)琛岄爢搴�銆�
銆€銆€瑭插嚱鏁�(sh霉)鐐烘渶鏂板嚱鏁�(sh霉)锛屽鏋滄兂浣跨敤锛屾渶鏂扮殑CenturyStar V7.50涔熸矑鏈夊摝锛佹湁闇€瑕佸彲浠ヨ伅(li谩n)绯绘垜锛佹垜鏈�(hu矛)鐧�(f膩)閮典欢绲︿綘鍊戠殑锛佸樋鍢�?銆�?/p>

妯�(bi膩o)绨斤細

鍒嗕韩鍒帮細

涓婁竴绡囷細Korenix绉戞礇鐞嗘€濓紙鍖楃埦闆诲瓙闆�...

涓嬩竴绡囷細寰兘WIN-V63鐭㈤噺鎺у埗璁婇牷鍣ㄥ湪...

涓湅(gu贸)鍌冲嫊(d貌ng)缍�(w菐ng)鐗堟瑠(qu谩n)鑸囧厤璨�(z茅)鑱叉槑锛氬嚒鏈恫(w菐ng)娉ㄦ槑[渚嗘簮锛氫腑鍦�(gu贸)鍌冲嫊(d貌ng)缍�(w菐ng)]鐨勬墍鏈夋枃瀛�銆佸湒鐗囥€侀煶瑕栧拰瑕栭牷鏂囦欢锛岀増娆�(qu谩n)鍧囩偤涓湅(gu贸)鍌冲嫊(d貌ng)缍�(w菐ng)(www.wangxinlc.cn)鐛�(d煤)瀹舵墍鏈夈€傚闇€杞�(zhu菐n)杓夎珛(q菒ng)鑸�0755-82949061鑱�(li谩n)绯�銆備换浣曞獟楂斻€佺恫(w菐ng)绔欐垨鍊�(g猫)浜鸿綁(zhu菐n)杓変娇鐢ㄦ檪(sh铆)闋堟敞鏄庝締婧愨€滀腑鍦�(gu贸)鍌冲嫊(d貌ng)缍�(w菐ng)鈥�锛岄仌鍙嶈€呮湰缍�(w菐ng)灏囪拷绌跺叾娉曞緥璨�(z茅)浠汇€�

鏈恫(w菐ng)杞�(zhu菐n)杓夊苟娉ㄦ槑鍏朵粬渚嗘簮鐨勭ǹ浠�锛屽潎渚嗚嚜浜掕伅(li谩n)缍�(w菐ng)鎴栨キ(y猫)鍏�(n猫i)鎶曠ǹ浜哄＋锛岀増娆�(qu谩n)灞簬鍘熺増娆�(qu谩n)浜�銆傝綁(zhu菐n)杓夎珛(q菒ng)淇濈暀绋夸欢渚嗘簮鍙婁綔鑰�锛岀姝㈡搮鑷鏀�锛岄仌鑰呰嚜璨�(f霉)鐗堟瑠(qu谩n)娉曞緥璨�(z茅)浠�銆�

鐩搁棞(gu膩n)璩囪▕

鎶€琛�(sh霉)鐔遍粸(di菐n)

鐢�(ch菐n)鍝佹柊鑱�

鏇村>

鎺ㄨ枽灏堥

鏇村>

鎶€琛�(sh霉)瑕栭牷

鏇村>