【正文】
SLintNNDanjiaDJdecimal(18,2)NNJineJEdecimal(18,2)NN(5)操作員資料表 表45操作員資料表數(shù)據(jù)項數(shù)據(jù)項(英文)列類型長度是否必須是否主鍵IdIDintYYxingmingXMvarchar50NNmimaMMvarchar50NN5 應(yīng)用程序設(shè)計(1)庫存管理系統(tǒng)的處理流程圖如圖51所示。(4)當前庫存報表模塊顯示各個倉庫中貨品存儲情況,可直接導(dǎo)出數(shù)據(jù),在Excel中編輯另保存打印。6 詳細設(shè)計系統(tǒng)流程圖(1)主界面: 圖61主界面截圖(2)出庫登記模塊流程圖圖62 出庫登記流程圖(3)入庫登記模塊流程圖圖63 入庫登記流程圖7總結(jié)本軟件的設(shè)計目的是為了提高平遙國際金融家俱樂部酒店庫存管理效率,減輕庫管員的工作量。(3)預(yù)警性:對于超出或者少于庫存量設(shè)置的貨品,系統(tǒng)將報警提示。s transaction record is carried on the registration in the account book. However, this method not only consume a large amount of human and financial resources, and also easily make mistakes. Furthermore, present warehouse operations and inventory control operations are quite diversified and plex, which only rely on artificial memory and processing will be very difficult. High error rate of transaction record can cause time wasting and capital increasing. Therefore, modern management concept and system are necessary for a hotel whom want survive in this intense petition conditions.So, this article chooses a modern hotel warehouse management system as the design topic. This system is based on puter information technology, and use Excel software to store the records which has many convenience and advantages. It can quickly reflect the information for transaction record, save human and material recourses, improve the working conditions, reduced the labor intensity, and print conveniently. Keywords Inventory management, C, SQL2005, Information management system9