Office中國論壇/Access中國論壇 › 標(biāo)簽 › vbRichClient5

標(biāo)簽: vbRichClient5

相關(guān)帖子	版塊	作者	回復(fù)/查看	最后發(fā)表

沒有相關(guān)內(nèi)容

相關(guān)日志

分享 vbRichClient5的StringBuilder及StringCompare對(duì)象參考: 熱度 1 ganlinlao 2013-10-26 23:16; StringBuilder 簡介：創(chuàng)建字符串構(gòu)造器對(duì)象，快速組合字符串原型：Function StringBuilder() As cStringBuilder 方法 Append() 原型：Sub Append(NextPart As String) 說明：添加字符串 AppendNL() 原型：Sub AppendNL(NextPart As String, ) 說明：添加字符串，并在末尾加上軟回車 AppendXMLAttribute() 原型：Sub AppendXMLAttribute(AttrName As String, AttrContent As String) AppendXMLNodeContent() 原型：Sub AppendXMLNodeContent(NodeContent As String) Clear() 原型：Sub Clear() 屬性 length 原型：Property length As Long ToString 原型：Property ToString As String ToUTF8 原型：Property ToUTF8 As Byte() StringCompare 簡介：創(chuàng)建字符串比較器對(duì)象，支持多種方式比較原型：Function StringCompare() As cStringCompare 方法 CompareString() 原型：Function CompareString(S1 As String, S2 As String, , ) As Long MakeLCID() 原型：Function MakeLCID(LangID As LangIDs, ) As Long; 2568 次閱讀|1 個(gè)評(píng)論

分享 vbRichClient5的SortedDictionary對(duì)象參考: ganlinlao 2013-10-26 23:08; SortedDictionary 簡介：創(chuàng)建有序字典對(duì)象原型：Function SortedDictionary( , ) As cSortedDictionary 方法 Add() 原型：Sub Add(Key, ) Count() 原型：Function Count() As Long Exists() 原型：Function Exists(Key) As Boolean ItemExists() 原型：Function ItemExists(ItemValue, , ) As Boolean Remove() 原型：Sub Remove(Key) RemoveAll() 原型：Sub RemoveAll() RemoveByIndex() 原型：Sub RemoveByIndex(IdxZeroBased As Long) SetStringCompareFlags() 原型：Sub SetStringCompareFlags(Flags As CmpFlags, , ) 屬性 IndexByKey 原型：Property IndexByKey(Key, ) As Long Item 原型：Property Item(Key) 缺省 ItemByIndex 原型：Property ItemByIndex(IdxZeroBased As Long) KeyByIndex 原型：Property KeyByIndex(IdxZeroBased As Long) 只讀 StringCompareMode 原型：Property StringCompareMode As StringCompareModeEnum UniqueKeys 原型：Property UniqueKeys As Boolean; 個(gè)人分類: vb入門|2250 次閱讀|0 個(gè)評(píng)論

分享 vbRichClient5的Crypt加解密對(duì)象參考: ganlinlao 2013-10-22 12:00; Crypt加解密對(duì)象方法： AESDecrypt() 原型：Function AESDecrypt(B() As Byte, KeyStringOrByteArray, , , ) As Boolean AESEncrypt() 原型：Function AESEncrypt(B() As Byte, KeyStringOrByteArray, , , ) As Boolean ArcFour() 原型：Sub ArcFour(B() As Byte, BK() As Byte, ) Base64Dec() 原型：Function Base64Dec(Base64Str As String, ) 說明：解密Base64，這個(gè)是比較常用的。很多東西常以base64加密的。如ie的mht文件，word2003的xml文件對(duì)圖像以base64加密（這個(gè)構(gòu)思真的很棒）。必須在access數(shù)據(jù)庫中儲(chǔ)存圖像，建議以Base64加密后再存儲(chǔ)。(純屬個(gè)人建議） Base64Enc() 原型：Function Base64Enc(Data) As String 說明：加密Base64 CheckPrime() 原型：Function CheckPrime(Prime As String) As Boolean CreateRandomNumber() 原型：Function CreateRandomNumber( ) As String DiffieHellmanCreatePublicKey() 原型：Function DiffieHellmanCreatePublicKey() As String DiffieHellmanCreateSharedSecret() 原型：Function DiffieHellmanCreateSharedSecret() As String FastLZCompress() 原型：Sub FastLZCompress(BSrc() As Byte, BDst() As Byte) FastLZDecompress() 原型：Sub FastLZDecompress(BSrc() As Byte, BDst() As Byte) GenPrime() 原型：Function GenPrime( , , , , ) As String GetHashedPassword() 原型：Function GetHashedPassword(PassWord As String) As String GzCompress() 原型：Function GzCompress(Src() As Byte, Dst() As Byte) As Long 說明：常用于網(wǎng)絡(luò)，壓縮減少網(wǎng)絡(luò)傳輸量，IIS支持對(duì)整個(gè)網(wǎng)站的Gz壓縮。IE支持對(duì)Gz文件的自動(dòng)解壓 GzDecompress() 原型：Function GzDecompress(Src() As Byte, Dst() As Byte) As Long HMAC_MD5() 原型：Function HMAC_MD5(Message, Key, ) HMAC_SHA1() 原型：Function HMAC_SHA1(Message, Key, ) LZMAComp() 原型：Sub LZMAComp(BSrc() As Byte, BDst() As Byte, , ) LZMADeComp() 原型：Sub LZMADeComp(BSrc() As Byte, BDst() As Byte) MD5() 原型：Function MD5(Message, ) 說明：MD5加密，常用。不用到處找MD5的vba代碼了。 SHA1() 原型：Function SHA1(Message, ) SHA256() 原型：Function SHA256(Message, ) URLDecode() 原型：Function URLDecode(U As String) As String 說明：非常常用。 URLEncode() 原型：Function URLEncode(U As String) As String UTF8ToVBString() 原型：Function UTF8ToVBString(B() As Byte) As String 說明：網(wǎng)絡(luò)數(shù)據(jù)基本是以UTF8作為標(biāo)準(zhǔn)，跟網(wǎng)絡(luò)數(shù)據(jù)打交道，這個(gè)太常用了。 UTF8ToVBStringFromPtr() 原型：Function UTF8ToVBStringFromPtr(pUTF8 As Long, ByteLen As Long) As String 說明：以字符串指針進(jìn)行字符串轉(zhuǎn)換。對(duì)于大數(shù)據(jù)的String轉(zhuǎn)換，性能會(huì)顯著提高。 VBStringToUTF8() 原型：Function VBStringToUTF8(S As String) As Byte() 說明：轉(zhuǎn)成UTF8。 ZlibCompress() Sub ZlibCompress(BSrc() As Byte, BDst() As Byte) 說明：常用，標(biāo)準(zhǔn)Zip加解壓。docx，xlsx，pptx不就是Zip文件嗎？ ZLibDecompress() 原型：Sub ZLibDecompress(BSrc() As Byte, BDst() As Byte) 屬性 DiffieHellmanBase 原型：Property DiffieHellmanBase As String DiffieHellmanPrime 原型：Property DiffieHellmanPrime As String DiffieHellmanPrivate 原型：Property DiffieHellmanPrivate As String DiffieHellmanSharedSecret 原型：Property DiffieHellmanSharedSecret As String; 個(gè)人分類: vb入門|2259 次閱讀|0 個(gè)評(píng)論

分享 vbRichClient5的ClipBoard對(duì)象參考: ganlinlao 2013-10-22 11:07; ClipBoard 簡介：創(chuàng)建剪切板對(duì)象，比VB自帶的對(duì)象好用。備注：這個(gè)對(duì)于使用Office的VBA的人來說，絕對(duì)是一個(gè)福音。在vba中要使用剪切板，得翻山越嶺才能使用，而且相當(dāng)艱難。對(duì)于Office各個(gè)程序間傳遞數(shù)據(jù)，在某些場(chǎng)合下，使用好剪切板，性能會(huì)成百倍增強(qiáng)，而且方便。原型：Function ClipBoard() As cUniClipBoard 方法 Clear() 原型：Sub Clear() GetData() 原型：Function GetData( ) As StdPicture GetFiles() 原型：Function GetFiles() As cDataObjectFiles GetFormat() 原型：Function GetFormat(Format As Integer) As Boolean GetFormats() 原型：Function GetFormats() GetFormatString() 原型：Function GetFormatString(Format As Long) As String GetImageSurface() 原型：Function GetImageSurface() As cCairoSurface GetText() 原型：Function GetText( ) As String SetData() 原型：Sub SetData(Picture As StdPicture, ) SetFiles() 原型：Sub SetFiles(FileList As cDataObjectFiles) SetImageSurface() 原型：Sub SetImageSurface(ImageSrf As cCairoSurface) SetText() 原型：Sub SetText(S As String, ); 個(gè)人分類: vb入門|2369 次閱讀|0 個(gè)評(píng)論

分享 vbRichClient5的Collection對(duì)象參考: 熱度 1 ganlinlao 2013-10-22 00:22; Collection對(duì)象簡介：創(chuàng)建集合對(duì)象，該對(duì)象比VB自帶的Collection和Scripting.Dictionary有更多的功能原型：Function Collection( , , , ) As cCollection 方法 Add() 原型：Sub Add(Item, , , ) Count() 原型：Function Count() As Long Exists() 原型：Function Exists(Key) As Boolean ItemExists() 原型：Function ItemExists(ItemValue, , ) As Boolean MakeLCID() 原型：Function MakeLCID(LangID As LangIDs, ) As Long Remove() 原型：Sub Remove(Key) RemoveAll() 原型：Sub RemoveAll() RemoveByIndex() 原型：Sub RemoveByIndex(IdxZeroBased As Long) SerializeToJSONString() 原型：Function SerializeToJSONString() As String SerializeToJSONUTF8() 原型：Function SerializeToJSONUTF8() As Byte() SetStringCompareFlags() 原型：Sub SetStringCompareFlags(Flags As CmpFlags, , ) SortKeysCount() 原型：Function SortKeysCount() As Long 屬性 CompatibleToVBCollection 原型：Property CompatibleToVBCollection As Boolean Content 原型：Property Content As Byte() IndexByKey 原型：Property IndexByKey(Key, ) As LongIndexBySortKeyIndex IndexBySortKeyIndex 原型：Property IndexBySortKeyIndex(IdxZeroBased As Long) As Long IsJSONArray 原型：Property IsJSONArray As Boolean IsJSONObject 原型：Property IsJSONObject As Boolean Item 原型：Property Item(Key) 缺省成員 ItemByIndex 原型：Property ItemByIndex(IdxZeroBased As Long) ItemBySortKeyIndex 原型：Property ItemBySortKeyIndex(IdxZeroBased As Long) KeyByIndex 原型：Property KeyByIndex(IdxZeroBased As Long) 只讀 KeyBySortKeyIndex 原型：Property KeyBySortKeyIndex(IdxZeroBased As Long) 只讀 Prop 原型：Property Prop(Key) SortKeyIndexByIndex 原型：Property SortKeyIndexByIndex(IdxZeroBased As Long) As Long 只讀 SortKeyIndexByKey 原型：Property SortKeyIndexByKey(Key, ) As Long 只讀 StringCompareMode 原型：Property StringCompareMode As StringCompareModeEnum UniqueKeys 原型：Property UniqueKeys As Boolean; 個(gè)人分類: vb入門|2750 次閱讀|1 個(gè)評(píng)論

分享 vbRichClient5的AarriayList對(duì)象參考: 熱度 1 ganlinlao 2013-10-21 23:44; ArrayList對(duì)象簡介：創(chuàng)建數(shù)組列表對(duì)象，支持動(dòng)態(tài)添加、移除，也可以當(dāng)隊(duì)列或者棧來用，支持排序原型：Function ArrayList(vType As VbVarType, ParamArray P() As Variant) As cArrayList 簡介：什么是ArrayList？使用大小會(huì)根據(jù)需要?jiǎng)討B(tài)增加的數(shù)組。什么是隊(duì)列？隊(duì)列用來保持?jǐn)?shù)據(jù)項(xiàng)目的先進(jìn)先出(FIFO)順序。什么是棧？棧是一種特殊的表，這種表只在表頭進(jìn)行插入和刪除操作。因此，表頭對(duì)于棧來說具有特殊的意義，稱為棧頂。相應(yīng)地，表尾稱為棧底。不含任何元素的棧稱為空棧。保持項(xiàng)目的后進(jìn)先出順序方法： add 原型：Sub Add(V, ) 說明：V 支持vb能支持的所有數(shù)據(jù)類型，可以把一個(gè)object或數(shù)組當(dāng)成一個(gè)元素添加進(jìn)去。 BeforeIndex 已存在某個(gè)數(shù)據(jù)的index之前插入，此時(shí)add方法變成insert。例子： Option Explicit Sub mytest() Dim arr1(1 To 10, 1 To 10), arr2, myarralist As New cArrayList, i, j, k k = 0 For i = 1 To 10 For j = 1 To 10 arr1(i, j) = k k = k + 1 Next Next i myarralist.Init vbVariant myarralist.Add arr1 For i = 1 To 100 myarralist.Add i, 1 '這里用的是倒序插入。如果參數(shù)-1則是正序 Next i Debug.Print myarralist.Count arr2 = myarralist.Item(0) Debug.Print arr2(9, 9) debug.print myarralist.item(100) set myarralist=Nothing End Sub AddElements 原型：Function AddElements(SrcArray, , , ) As Long 說明： BindToArray 原型：Function BindToArray(Arr, ) As Boolean Clone 原型：Function Clone() As cArrayList CopyToArray 原型：Function CopyToArray(Arr, ) As Boolean DeQueue 原型：Function DeQueue() 說明：從ArrayList對(duì)象中移除第一個(gè)元素，并返回該元素。 Init 原型：Sub Init(vType As VbVarType, ParamArray P() As Variant) 說明：初始化。任何時(shí)候使用AarrayList都必須先初始化。 MakeLCID 原型：Function MakeLCID(LangID As LangIDs, ) As Long Pop 原型：Function Pop() Push 原型：Sub Push(V) Queue 原型：Sub Queue(V) ReleaseArrayBinding 原型：Sub ReleaseArrayBinding(Arr) Remove 原型：Sub Remove(ZeroBasedIndex As Long) RemoveAll 原型：Sub RemoveAll() RemoveElements 原型：Function RemoveElements(FromZeroBasedIndex, ElementsToRemove As Long) As Long Sort 原型：Sub Sort( , , ) 屬性 Content 原型：Property Content As Byte() Count Property Count As Long ElementSize 原型： Property ElementSize As Long 只讀 Item 原型：Property Item(ZeroBasedIndex As Long) vType 原型：Property vType As VbVarType 只讀; 個(gè)人分類: vb入門|2764 次閱讀|1 個(gè)評(píng)論

更多...

帳號(hào)		自動(dòng)登錄	找回密碼
密碼			注冊(cè)

標(biāo)簽: vbRichClient5

相關(guān)帖子

相關(guān)日志