物流管理信息系統(tǒng)綜合設(shè)計(jì)實(shí)踐報(bào)告-wenkub.com
2025-01-17 03:47 本頁面
【正文】 本系統(tǒng)是針對超市進(jìn)行供銷管理而設(shè)計(jì)的，在這個(gè)系統(tǒng)中，超市進(jìn)銷存管理系統(tǒng)研究的內(nèi)容涉及超市進(jìn)銷存管理的全過程，包括入庫、出庫、退貨、訂貨、超市統(tǒng)計(jì)查詢等等。第七章 總結(jié)在此次設(shè)計(jì)當(dāng)中認(rèn)我認(rèn)識(shí)到開發(fā)一項(xiàng)好的軟件不是某一個(gè)人就能完成的任務(wù)。改變測試方案來變換另一個(gè)角度進(jìn)行測試，發(fā)現(xiàn)錯(cuò)誤并記錄，修改代碼，測試條件使程序通過多層分支，判別運(yùn)行結(jié)果從而完成模塊測試。Set = Adodc1End SubPrivate Sub Form_Load() 0, 0, , End Sub圖531 商品庫存查詢界面FORM 14（庫存查詢）Private Sub Command4_Click()Unload 庫存查詢 End SubPrivate Sub Form_Load() 0, 0, , End Subl 交易視圖(v_Dealing)——用于查詢交易情況的視圖；CREATE VIEW [dbo].v_DealingASSELECT AS Expr1, AS Expr2, , , , , , FROM CROSS JOIN GOl 計(jì)劃進(jìn)貨視圖(v_PlanStock)——用于查詢進(jìn)貨計(jì)劃的視圖；CREATE VIEW [dbo].v_PlanStockASSELECT , , , , , AS Expr1, , AS Expr2, , , , FROM CROSS JOIN CROSS JOIN GOl 銷售視圖(v_Sale)——用于查詢銷售明細(xì)記錄的視圖；CREATE VIEW [dbo].v_SaleASSELECT , , , , , , , , , .[desc], , dbo.[User].UserID, dbo.[User].UserNameFROM CROSS JOIN CROSS JOIN CROSS JOIN dbo.[User]GOl 入庫視圖(v_Stock)——用于查詢?nèi)霂烨闆r的視圖。 = select * from 按出庫查 where 職工號=39。 = select * from 按出庫查 where 備注=39。 = select * from 按出庫查 where 出庫日期=39。 = select * from 按出庫查 where 商品數(shù)量=39。 = select * from 按出庫查 where 商品名稱=39。Set = Adodc1End SubPrivate Sub Form_Load() 0, 0, , End Sub圖524 入庫商品查詢界面FORM 6（入庫產(chǎn)品查詢）Private Sub Command1_Click()Unload Form6 End SubPrivate Sub Form_Load() 0, 0, , End Sub圖525 商品出庫查詢界面FORM 7（商品出庫查詢）Private Sub Command1_Click()Unload Form7 End SubPrivate Sub Form_Load() 0, 0, , End Sub圖526 過期商品查詢界面FORM 8（過期商品查詢）Private Sub Command4_Click()Unload Form8 End SubPrivate Sub Form_Load() 0, 0, , End Sub圖527 缺貨查詢界面FORM 9（缺貨查詢）Private Sub Command4_Click()Unload Form9 End SubPrivate Sub Form_Load() 0, 0, , End Sub圖528 報(bào)表統(tǒng)計(jì)界面FORM 10（報(bào)表統(tǒng)計(jì)）Private Sub Command4_Click()Unload Form9 End SubPrivate Sub Form_Load() 0, 0, , End Sub圖529 商品錄入界面FORM 12（商品錄入）Private Sub Command1_Click() = select * from 按產(chǎn)品名稱查詢(商品編號) = Trim()(商品名稱) = Trim()(商品數(shù)量) = Trim()(備注) = Trim()(職工號) = Trim()(商品規(guī)格) = Trim()(商品進(jìn)價(jià)) = Trim()(商品售價(jià)) = Trim()(供貨商(編號)) = Trim()answer = MsgBox(用戶添加成功?。。? 1 + 48 + 0, 信息提示！)End SubPrivate Sub Command4_Click()Unload 商品錄入 End SubPrivate Sub Command5_Click()answer = MsgBox(是否刪除記錄？, 1 + 48 + 0, 信息提示！) = select * from 按產(chǎn)品名稱查詢 = TrueEnd SubPrivate Sub Form_Load() 0, 0, , End Sub圖530 商品出庫界面FORM 13（商品出庫）Private Sub Command1_Click() = select * from 按出庫查(商品編號) = Trim()(商品名稱) = Trim()(商品數(shù)量) = Trim()(出庫日期) = Trim()(備注) = Trim()(職工號) = Trim()answer = MsgBox(用戶添加成功！?。? 1 + 48 + 0, 信息提示！)End SubPrivate Sub Command3_Click()Unload 商品出庫 End SubPrivate Sub Command4_Click()answer = MsgBox(是否刪除記錄？, 1 + 48 + 0, 信息提示！) = select * from 按出庫查 = TrueEnd SubPrivate Sub Command5_Click() = select * from 按出庫查 where 商品編號=39。Set = Adodc1End SubPrivate Sub Command2_Click()Unload Form4 End SubPrivate Sub Form_Load() 0, 0, , End Sub圖523 產(chǎn)品編號查詢界面FORM 5（按產(chǎn)品編號查詢）Private Sub Command1_Click()Unload Form5 End SubPrivate Sub Command2_Click() = select * from 按產(chǎn)品名稱查詢 where 商品編號=39。圖519 用戶登
公司管理相關(guān)推薦
鄂ICP備17016276號-1