【導(dǎo)讀】本論文描述了《服裝專賣店店管理系統(tǒng)》的設(shè)計(jì)與實(shí)現(xiàn)。在我國(guó)數(shù)量眾多的企業(yè)中，中小企業(yè)占了絕大多數(shù)。這些企業(yè)也不可避免地要加入國(guó)。際化企業(yè)的競(jìng)爭(zhēng)行列，而實(shí)現(xiàn)企業(yè)信息化是參與挑戰(zhàn)的必要條件。實(shí)際上大部分中小企業(yè)需要的只是能解決服裝專賣店店管理、財(cái)務(wù)管理等的基礎(chǔ)軟件。本文所設(shè)計(jì)的服裝專賣。隨著經(jīng)濟(jì)的全球化以及中國(guó)經(jīng)濟(jì)改革的逐漸深化，制造業(yè)面臨著越來(lái)越激烈的競(jìng)爭(zhēng)，源計(jì)劃系統(tǒng)是被實(shí)踐證明了的提高企業(yè)競(jìng)爭(zhēng)力的最有效的方法之一。源進(jìn)行計(jì)劃、調(diào)度、控制、衡量、改進(jìn)的管理技術(shù)和信息系統(tǒng)。如果一個(gè)ERP系統(tǒng)真正想要最大限度地提高其生產(chǎn)能力，它必須能。夠非常融洽地和其他關(guān)鍵性的商務(wù)領(lǐng)域進(jìn)行交流。新需求和市場(chǎng)新機(jī)遇的能力，是中國(guó)企業(yè)贏得競(jìng)爭(zhēng)勝利的決定性因素。系統(tǒng)設(shè)計(jì)基本的目標(biāo)是盡可能實(shí)現(xiàn)物流控制自動(dòng)化，長(zhǎng)遠(yuǎn)目標(biāo)是實(shí)現(xiàn)ERP. 應(yīng)鏈各個(gè)環(huán)節(jié)的管理、調(diào)度及資源配置，使得管理合理規(guī)范。和進(jìn)貨，以免增加庫(kù)存，造成物資和資金的積壓。

　　

【正文】 ADO 和 OLE DB 數(shù)據(jù)訪問(wèn)模式。 在 中包含了數(shù)據(jù)綁定、可視化設(shè)計(jì)工具以及 OLE DB 數(shù)據(jù)源書寫模板等新的內(nèi)容。在 Visual 中， ADO 的數(shù)據(jù)環(huán)境設(shè)計(jì)器 (Data Environment Designer)取代了 Visual Basic 中的 RDO 的用戶連接設(shè)計(jì)器 (User Connection Designer)。 User Connection 對(duì)象只支持 ODBC 數(shù)據(jù)源，而 Data Environment 對(duì)象可以連接所有的 OLE DB 數(shù)據(jù)源 o ADO 對(duì)象模型定義了一個(gè)可編程的分層的對(duì)象集合，它支持部件對(duì)象模型(COM)和 OLE DB 數(shù)據(jù)源。與其他的數(shù)據(jù)訪問(wèn)對(duì)象相比，包含在 ADO 的對(duì)象少得多，也更加容易 使用。 ADO 對(duì)象模型中包含了 3 個(gè)一般用途的對(duì)象： Connection、 Command 和Recordset。程序開(kāi)發(fā)人員可以創(chuàng)建這些對(duì)象并且使用這些對(duì)象訪問(wèn)數(shù)據(jù)庫(kù)。在ADO 對(duì)象模型中還有其他幾個(gè)對(duì)象，例如 Field、 Property、 Error 和 Parameter，它們是作為前面 3 個(gè)對(duì)象的子對(duì)象進(jìn)行訪問(wèn)的。 （ 1）、 ADO 數(shù)據(jù)控件的功能 ADO data 控件使用 ActiveX 數(shù)據(jù)對(duì)象（ ADO）來(lái)快速建立數(shù)據(jù)約束控件和數(shù)據(jù)提供者之間的連接，并快速創(chuàng)建記錄集，然后將數(shù)據(jù)通過(guò)數(shù)據(jù)約束控件提供畢業(yè)論文 27 給用戶，其中數(shù)據(jù)約束控 件可以是任何具有“數(shù)據(jù)源”屬性的控件，而數(shù)據(jù)提供者可以是符合 OLE DB 規(guī)范的數(shù)據(jù)源。使用 Visual Basic 的類模塊也可以很方便的創(chuàng)建子集的數(shù)據(jù)提供者。在 Visual 中，可以使用 ADO 數(shù)據(jù)控件實(shí)現(xiàn)下面一些功能： ? 連接一個(gè)本地?cái)?shù)據(jù)庫(kù)或遠(yuǎn)程數(shù)據(jù)庫(kù)。 ? 打開(kāi)一個(gè)指定的數(shù)據(jù)庫(kù)表，或定義一個(gè)基于結(jié)構(gòu)化查詢語(yǔ)言 (SQL)的查詢、存儲(chǔ)過(guò)程或者是該數(shù)據(jù)庫(kù)中表的視圖的記錄集合。 ? 將數(shù)據(jù)字段的數(shù)值傳遞給數(shù)據(jù)綁定的控件，可以在這些控件中顯示或更改這些數(shù)值。 ? 添加新的記錄，或者根據(jù)對(duì)顯示在綁定的控件中的數(shù)據(jù)的 任何更改來(lái)更新一個(gè)數(shù)據(jù)庫(kù)。 （ 2）、 ADO 數(shù)據(jù)控件的屬性 ADO 數(shù)據(jù)控件與 Visual Basic 的內(nèi)部數(shù)據(jù)控件 (Data)和遠(yuǎn)程數(shù)據(jù)控件 (RDC)很相似，它允許使用 ADO 快速地創(chuàng)建與數(shù)據(jù)庫(kù)的連接。 與 Data 控件類似，為了實(shí)現(xiàn)對(duì)數(shù)據(jù)庫(kù)的訪問(wèn)， ADO 數(shù)據(jù)控件提供了幾個(gè)屬性，這些屬性定義了怎樣連接數(shù)據(jù)庫(kù)以及同什么樣的數(shù)據(jù)庫(kù)相連接。 Connection String 屬性：是一個(gè)字符串，可以包含進(jìn)行一個(gè)連接所需的所有設(shè)置值，在該字符串中所傳遞的參數(shù)是與驅(qū)動(dòng)程序相關(guān)的。例如， ODBC 驅(qū)動(dòng)程序允許該字符串包含驅(qū)動(dòng)程序、提供者、默認(rèn)的數(shù)據(jù)庫(kù)、服務(wù)器、用戶名稱以及密碼等。 ADO 支持 Connection String 屬性的 4 個(gè)參數(shù)，而且這 4 個(gè)參數(shù)將不經(jīng)過(guò) ADO的處理直接送到數(shù)據(jù)源。這四個(gè)參數(shù)的屬性如表 所示： 表 Connection String 屬性的 4 個(gè)參數(shù)表 參數(shù) 描述 Provider 指定數(shù)據(jù)源的名稱 File Name 指定基于數(shù)據(jù)源的文件名稱 Remote Server 指定在打開(kāi)一個(gè)客戶端連接時(shí)使用的數(shù)據(jù)源名稱 Remote Server 指定打開(kāi)客戶端連接時(shí)使 用的服務(wù)器的路徑與名稱 畢業(yè)論文 28 畢業(yè)論文 29 sounds that were a lot like laughter. 39。You think it39。s funny, huh?39。 Weary inquired. He walked around to Billy39。s back. Billy39。s jacket and shirt and undershirt had been hauled up around his shoulders by the violence, so his back was naked. There, inches from the tips of Weary39。s bat boots, were the pitiful buttons of Billy39。s spine. Weary drew back his right boot, aimed a kick at the spine, at the tube which had so many of Billy39。s important wires in it. We ary was going to break that tube. But then Weary saw that he had an audience. Five German soldiers and a police dog on a leash were looking dow n into the bed of the creek. The soldiers39。 blue eyes were filled with bleary civilian curiosity as to why one American would try to murder another one so far from home, and why the victim should laugh. Three The Germans and the dog were engaged in a military operation which had an amusingly selfexplanatory name, a human enterprise which is seldom described in detail, whose name alone, when reported as news or history, gives many war enthusiasts a sort of postcoital satisfaction. It is, in the imagination of bat39。s fans, the divinely listless loveplay that follows the asm of victory. It is called 39。mopping up.39。 The dog, who had sounded so ferocious in the winter distances, was a female German shepherd. She was shivering. Her tail was between her legs. She had been borrowed that morning from a farmer. She had never been to war before. She had no idea what game was being played. Her mine wa s Princess. Two of the Germans were boys in their early teens. Two were ramshackle old me droolers as toothless as carp. They were irregulars, armed and clothed fragmentarily with junk taken from real soldiers who were newly dead. So it goes. They were farmers from just across the German border, not far away. Their manander was a middleaged corporalredeyed., scrawny, tough as dried beef, sic k of war. He had been wounded four timesand patched up, and sent back to war. He was a very good soldierabout to quit, about to find somebody to surrender to. His bandy legs were thrust into golden cavalry boots which he had take n from a dead Hungarian colonel on the Russian front. So it goes. Those boots were almost all he owned in this world. They were his home. An anecdote: One time a recruit was watching him bone and wax those golden boots, and he held one up to the recruit and said, 39。If you look in there deeply enough, you39。ll see Adam and Eve.39。 Billy Pilgrim had not heard this anecdote. But, lying on the blac k ice there, Billy stared into the patina of the corporal39。s boots, saw Adam and Eve in the golden depths. They were naked. They were so innocent, so vulnerable, so eager to behave decently. Billy Pilgrim loved them. Next to the golden boots were a pair of feet which were swaddled in rags. They were crisscrossed by canvas straps, were shod with hinged wooden clogs. Billy looked up at the face that went with the clogs. It was the face of a blond angel of fifteenyearold boy. The boy was as beautiful as Eve. Billy was helped to his feet by the lovely boy, by the heavenly androgyne. And the others came forward to dust the snow off Billy., and then they searched him for weapons. He didn39。t have any. The most dangerous thing they found on his person was a twoinch pencil stub. Three inoffensive bangs came from far away. They came from German rifles. The two scouts who had ditched Billy and Weary had just been shot. They had been lying in ambush for Germans. They had been discovered and shot from behind. Now they were dying in the snow, feeling nothing, turning the snow to the color of raspberry sherbet. So it goes. So Roland Weary was the last of the Three Musketeers. And Weary, bugeyed with terror, was being disarmed. The corporal gave Weary39。s pistol to the pretty boy. He marveled at Weary39。s cruel trench knife, said in German that Weary would no doubt like to use the knife on him, to tear his face off with the spiked knuckles, to stick the blade into his belly or throat. He spoke no English, and Billy and Weary understood no German. 39。Nice playthings you have, the corporal told Weary, and he handed the knife to an old man. 39。Isn39。t that a pretty thing? Hmmm? He tore open Weary39。s overcoa