【正文】 while the C class product is the value of the bottom of the inventory, its value is only 5% of the total value, but it 。s product sales, and warehouse management appears cargo space confusion, some products will be stored in the operating channel and the secure channel, so that is not conducive to our operations, warehouse operations particularly affect the safety of personnel, there are security risks. Because these problems often are especially prominent when the season, so these problems, the author suggested that some of the goods stored in the open yard, but the time to do well in the storage protection. 3 proposed ABC Classified Management Applications To conduct an effective inventory management and control, we must first sort of inventory, only then can we better manage the goods and control. Therefore, I analyzed that in the original storage facilities under the same conditions, using ABC classification of goods for the implementation and management. This can effectively use the original storage space and cargo space. Through the analysis of goods to identify the primary and secondary, classification queue. According to Barrett curve reveals the critical few and minor majority rule should be applied in the management. Therefore, in accordance with product value, sales, shortage cost, or order in advance of other indicators to classify the product. A class of products which are the highest value of inventory, general inventory of its total inventory of 15%, while the value of it is accounted for 70% ~ 80%。s warehouse stocking on the use of the fruit picking type. In this way, the storage requirements of the pany39。s products feature the same features they are not mutually exclusive, this product features from the point of view is they could be put together randomly. In addition, the pany39。s products belong to relatively large seasonal variations in the product, if the maximum amount set in the library space utilization will fall to the warehouse, so wastage of resources. As all the libraries in the digital warehouse are stored with the principles of positioning, in accordance with the current situation of the pany39。 his useless space accounted for about 5%. On the whole, the warehouse space utilization is high, there is a little crowded phenomenon. Analysis: the relative reduction should be the use of some physical space to increase the number of intermittent operations such as space, safety of space use. In addition, space and vertical space from the plane of view, the level of space has been put to good use, but the use of vertical space is not high, it can be considered top shelf, or highlevel automatic threedimensional shelf, to make better use of vertical space. 2 rack management analysis Rack management refers to the goods into warehouse, on the goods handling, how to put, place, etc. where a reasonable and effective planning and management. The disposal of goods, how to place, mainly by the strategic decision taken by the storage of goods of a specific storage location, will have to bine the principles of location assignment related to the decision. The pany39。 work space and accounts for about 10% as the pany39。s warehouse, its physical space accounted for 75% of the warehouse。s warehouse is not very high degree of mechanization, storage, only forklifts, including hand trucks and electric forklift. Warehouse operation methods, generally with a forklift, rarely manpower for the receipt of goods, which are materials used to send and receive cards, every time shipping and receiving cards will be done in the send and receive registration materials, so we usually check very convenient goods such as some of the followup results from the present work seems to still relatively high efficiency, operation is quite easy. So the whole way of operating the pany39。s products sell well. Frequency of a large warehouse storage, goods flow also great. The pany39。s several light sources are stored in the warehouse two groups finished. Three major stored product warehouse specific grid lamps, ceiling lamps, track lights, and some other panies products. 1 An analysis of warehouse storage space Warehouse storage system39。s existing network of integrated customer relationship, across the country set up the 35 operations centers, improve the pany39。s leading enterprises. With excellent product quality, excellent service, the access to the customer39。現(xiàn)在，我對Visual Basic和Access的應用有了更深的認識，計算機知識又有所增長。當一個模塊做完了，感覺良好，可是在運行的時候才發(fā)現(xiàn)諸多的問題，一次次的失敗，一次次的修改。系統(tǒng)采用的是Visual Basic做前臺，Access作為后臺數(shù)據(jù)庫。這個倉庫系統(tǒng)的設計經(jīng)歷了，從創(chuàng)建數(shù)據(jù)庫到系統(tǒng)設計和各個模塊的創(chuàng)建、表單的設計、基本功能如查詢統(tǒng)計的實現(xiàn)、主程序的編寫。這個系統(tǒng)，大大提高了工作效率，減少了倉庫工作人員的工作量和誤差?！秱}庫管理系統(tǒng)》處理數(shù)據(jù)的流程，與人工處理的思維是一樣的，更優(yōu)于人工處理的是將原本繁瑣的業(yè)務處理變的更加快捷，有序，錯誤率下降。) MsgBox 密碼修改成功,請您記住新密碼, , 信息提示 Unload Me End If Else MsgBox 沒有此用戶的信息,請您確認后重新輸入, 48, 信息提示 = = = = End If End IfEnd Sub 退出系統(tǒng)模塊（） 倉庫工作人員從系統(tǒng)中退出的出口，點擊確定即可退出系統(tǒng)，點擊取消，則繼續(xù)留系在統(tǒng)中操作系統(tǒng)。 where M_name=39。如果輸入正確的密碼則修改密碼 Set adoRs = (UPDATE tb_enter SET M_Password= 39。 If 0 Then If Then 39。 and M_name=39。 amp。判斷輸入的用戶名在數(shù)據(jù)庫中是否存在 = select * from tb_enter where M_Password =39。 密碼修改界面實現(xiàn)代碼： Private Sub Command1_Click()rtn = SetWindowPos(, 2, 0, 0, 0, 0, 3) 39。如果數(shù)據(jù)庫中存在該用戶信息，則將其刪除 MsgBox 用戶信息刪除成功, 64, 刪除用戶信息提示 Unload Me Else MsgBox 當前數(shù)據(jù)庫中沒有可刪除的用戶信息, , 信息提示 End If End If End IfEnd Sub 密碼修改 為了安全起見，用戶可以對自己密碼進行修改。 + + 39。運用API函數(shù)SetWindowPos，來實現(xiàn)取消窗體置前的功能 If = Name1 Then 39。)) MsgBox 注冊成功!!, 48, 用戶注冊信息提示