VC倉庫管理系統(tǒng)

倉庫管理系統(tǒng)摘要本系統(tǒng)主要完成對(duì)倉庫的庫存管理，包括入庫、出庫、庫存，員工信息，供應(yīng)商信息以及密碼管理等六個(gè)方面。系統(tǒng)可以完成對(duì)各類信息的瀏覽、查詢、添加、刪除、修改等功能。系統(tǒng)的核心是入庫、庫存和出庫三者之間的聯(lián)系，每一個(gè)表的修改都將聯(lián)動(dòng)的影響其它的表，當(dāng)完成入庫或出庫操作時(shí)系統(tǒng)會(huì)自動(dòng)地完成庫存的修改。查詢功能也是系統(tǒng)的核心之一，在系統(tǒng)中即有單條件查詢和多條件查詢，也有精確查詢和模糊查詢，系統(tǒng)不僅有靜態(tài)的條件查詢，也有動(dòng)態(tài)生成的條件查詢，其目的都是為了方便用戶使用。系統(tǒng)有完整的用戶添加、刪除和密碼修改功能，并具備報(bào)表打印功能。系統(tǒng)采用Microsoft中的SQLserver2000來設(shè)計(jì)數(shù)據(jù)庫，并使用當(dāng)前優(yōu)秀的開發(fā)工具—VC++，它有著最為靈活的數(shù)據(jù)庫結(jié)構(gòu)，對(duì)數(shù)據(jù)庫應(yīng)用有著良好的支持。論文主要介紹了本課題的開發(fā)背景，所要完成的功能和開發(fā)的過程。重點(diǎn)的說明了系統(tǒng)設(shè)計(jì)的重點(diǎn)、設(shè)計(jì)思想、難點(diǎn)技術(shù)和解決方案。關(guān)鍵字：數(shù)據(jù)庫，SQL語言，vc++，數(shù)據(jù)庫組件，倉庫管理[英文摘要]SummaryThissystemchieflyaccomplishesthestockmanagementtothestorehouse,includesbeingputinstorage,goesoutthewarehouseandstocks,andstaff’sinformation,sixaspectssuchassupplier'sinformationaswellascryptogrammanagementetc.Whatthesystemcanaccomplishtovariouskindtheinformationglancesoverandthefunctionsuchasinquiresabout,adds,deletesandmodificationetc.Thesystematicnucleusisisputinstorage,stocksandgoesoutthecontactbetweenthewarehouse,andwhenaccomplishesbeingputinstorageorgoingoutawarehouse,thesystemcanaccomplishvoluntarilythemodificationofstocktoothertableofinfluencethatthemodificationofeverytableallwillbelinkageedwhenoperating.Inquiringaboutthefunctionalsoisoneofsystematicnucleus,namelyhavingthewallscrollsparetoinquireaboutandinquiresaboutwithmanyconditionsinthesystem,alsohavingaccuratelythequerytoinquireaboutwithbluring,notonlythereistheconditionqueryofstaticstateinthesystem,alsohavingtheconditionqueryoftrendsformations,hispurposeallisusingforconvenientuser.Thesystemhascompleteusertoadd,deletesandtheciphermodificationfunction,andhasthereportformandprintsthefunction.TheSQLserver2000thatthesystemadoptedamongMicrosoftcomesthedesigndatawarehouse,andusebeforeonezorchdevelopmenttool–VC++,ithasthemostnimbledatabasestructure,andtheapplicationhasthegoodsupporttothedatawarehouses.Thedevelopmentbackgroundofthisthesubject,courseoffunctionandthedevelopmentthatwillbeaccomplishedwerechieflyintroducedtothesis.Theemphaticexplanationfocalpointofsystemsdesign,designthoughtanddifficultpointtechnologyandsettlementscheme.Thekeyword:thedatabase,SQL'slanguage,vc++,'sdatabasepackage,theWarehousemanagement.板目嘆恐錄兼第一廣章：柿引言菠1．團(tuán)1課周題來慶源座1．籮2．象開發(fā)灶工具單的選滑擇碗1．諷3所勒做的讓主要案工作鎮(zhèn)第二躲章蒼數(shù)據(jù)抄庫的紹概論墓親2．厭1數(shù)照據(jù)庫套的發(fā)隸展嫂斜2.嘴1.捉1溝半數(shù)榜據(jù)庫競(jìng)的發(fā)盼展隙晨2撈.1過.2呆趨數(shù)拖據(jù)庫瞇階段陰的特等點(diǎn)酒雕2頑.1扇.3門運(yùn)數(shù)勾據(jù)庫臟技術(shù)較2.丈2泰聰數(shù)歉據(jù)庫君理論需基礎(chǔ)虧銷水2誦.2眠.1案磚數(shù)總據(jù)庫抖模型那剃仆2內(nèi).2聯(lián).2升杰數(shù)拉據(jù)庫楊體系錦結(jié)構(gòu)宰井緩爛2凡.2吉.3鼠搭數(shù)彼據(jù)的肌獨(dú)立夢(mèng)性化楊缺2后.2豐.4鋤悔范匹式織梅2.青3三定S盡QL云語言茂基礎(chǔ)漏府蹄2色.3伸.1臂創(chuàng)S嫁QL嘆簡(jiǎn)介夫積梢2恥.3互.2典葛S煉QL疾查詢昏姨供贈(zèng)2.危3.義3饒?zhí)襍把QL方數(shù)據(jù)起更新必鑒第三劣章野VC爽++磁下的掃控件休所實(shí)襲現(xiàn)的直功能細(xì)3雁．燃1貞實(shí)現(xiàn)設(shè)菜單循選項(xiàng)旬3秘．涌2情實(shí)現(xiàn)簽工具必欄溝3述．獵3車幫助頸3.弟4趣敗關(guān)于主版本毛第四籠章裙系統(tǒng)鬧總體騙規(guī)劃稍4．既1流系統(tǒng)煉功能亭4．道2繳系統(tǒng)蟲功能拾結(jié)構(gòu)茄圖尋4拋.傾3塔具體薪操作祥步驟并一覽銀表槳第五駁章儀系統(tǒng)掏具體體實(shí)現(xiàn)猜5．舅1崗用戶討界面斥的實(shí)堡現(xiàn)揀5．江2竟數(shù)據(jù)曲庫的處實(shí)現(xiàn)抵5．蹈2慧．境1碑庫存泛數(shù)據(jù)遣庫悠5．蜜2升．脊2斑用戶首管理繡庫岸5．斥3市與村VC貓++暫的連屠接消第六匪章愛結(jié)束禿語朝疊跟迎捎第七鄰章飯參考森文獻(xiàn)從翻閱悄笨第八象章滿程序鑰源代繳碼、閣各功劇能模歉塊的索界面界圖雖5盈.1己用戶畝界面猜的實(shí)朱現(xiàn)桂__建_錫主界猛面具蛇體實(shí)突現(xiàn)見籮下圖勾在主板界面巷中可袋以對(duì)亦基礎(chǔ)伏資料鏟進(jìn)行俯設(shè)置婚，單糞據(jù)處督理，頭統(tǒng)計(jì)紗查詢蘋，系救統(tǒng)維沙護(hù)，棗退出礦系統(tǒng)盡幾項(xiàng)堂進(jìn)行狗操作鬧。具課體詳資細(xì)操襪作在終各界慰面中爛有詳尊細(xì)說盲明。含蟻基礎(chǔ)小資料繁設(shè)置絮的實(shí)京現(xiàn)秀還有橋物品列信息岸表，紐入庫簽表，撥出庫