庫(kù)存管理系統(tǒng)課程設(shè)計(jì)-文庫(kù)吧資料
2025-04-14 22:54本頁(yè)面
【正文】 mand(getinsertID, conn)Dim dr As OleDbDataReaderdr = ()Dim vargid As IntegerIf (dr(0).ToString = ) Thenvargid = 1Elsevargid = (dr(0).ToString) + 1End IfDim sqlstr As StringDim gprice As Doublegprice = ()sqlstr = insert into Goods(GID,GName,GPrice,GProvider1,GProvider2,GDescribe) values(39。User ID=sa。Password=1234。 where GID = + strcmd = New OleDbCommand(sqlstr, conn)()()()//重新綁定 = 1bindgrid()圖 33 貨物添加界面點(diǎn)擊添加新貨按鈕，進(jìn)入此頁(yè)面。,GProvider2=39。,GProvider1=39。,GPrice=39。Data Source=.) Dim cmd As OleDbCommand Dim sqlstr As String sqlstr = update Goods set GName = 39。User ID=sa。Password=1234。根據(jù)導(dǎo)航條可以跳轉(zhuǎn)到個(gè)人信息維護(hù)、倉(cāng)庫(kù)信息維護(hù)、存放規(guī)則維護(hù)等界面進(jìn)行查詢、修改、刪除等操作。表21 貨物表序號(hào)字段名數(shù)據(jù)類(lèi)型數(shù)據(jù)長(zhǎng)度NULLPrimarykey描述1GIDInt4NY貨物號(hào)2GNamevarchar50YN貨物名3GPricemoney10YN當(dāng)前價(jià)格4GProvider1varchar50YN主提供商5GProvider2varchar50YN次提供商6GDescribevarchar50YN描述表22 管理員表序號(hào)字段名數(shù)據(jù)類(lèi)型數(shù)據(jù)長(zhǎng)度NULLPrimarykey描述1UIDint4NY用戶號(hào)2UNamevarchar50YN姓名3UPasswordvarchar50YN密碼4UPowervarchar50YN權(quán)限6USexchar2YN性別7UAddressvarchar50YN地址8UTelvarchar50YN電話9UEmailvarchar50YN電郵10UDepint4YN負(fù)責(zé)人表23 記錄表序號(hào)字段名數(shù)據(jù)類(lèi)型數(shù)據(jù)長(zhǎng)度NULLPrimarykey描述1RIDint4NY表號(hào)2RGIDint4YN貨物號(hào)3RWIDintr4YN 倉(cāng)庫(kù)號(hào)4RQuantityfloat8YN所需量5RTypechar10YN類(lèi)型6RManagerint4YN管理人號(hào)7RHandlervarchar50YN提(送)貨人8UIDint4YN用戶號(hào)9RMaxInfloat8YN最大進(jìn)貨量10RMaxOutfloat8YN最大出貨量 表25存儲(chǔ)表序號(hào)字段名數(shù)據(jù)類(lèi)型數(shù)據(jù)長(zhǎng)度NULLPrimarykey描述1SIDint4NY存儲(chǔ)表號(hào)2SGIDint4YN貨物號(hào)3SWIDint4YN倉(cāng)庫(kù)號(hào)4STopLinefloat8YN存儲(chǔ)上限5SbaseLinefloat8YN存儲(chǔ)下限6SQuantityfloat8YN存儲(chǔ)量 表26倉(cāng)庫(kù)表序號(hào)字段名數(shù)據(jù)類(lèi)型數(shù)據(jù)長(zhǎng)度NULLPrimarykey描述1WIDint4NY倉(cāng)庫(kù)號(hào)2WNamevarchar50YN倉(cāng)庫(kù)名3WAreafloat8YN容量4WAddressvarchar50YN地址5WDescribeVarchar50YN描述6UIDint4YN用戶號(hào)第3章 系統(tǒng)實(shí)現(xiàn)填寫(xiě)正確的用戶名和密碼，點(diǎn)擊登錄按鈕，然后根據(jù)權(quán)限進(jìn)入不同的頁(yè)面進(jìn)行管理[3]。本系統(tǒng)是以Windows XP系統(tǒng)為操作平臺(tái)。對(duì)于分倉(cāng)庫(kù)總管來(lái)說(shuō)，根據(jù)自己的權(quán)限進(jìn)入貨品進(jìn)出維護(hù)界面，查看一種貨品的數(shù)量、最大存儲(chǔ)量、當(dāng)前數(shù)量等信息，同時(shí)又可以插入某種貨物的進(jìn)貨出貨狀況等；還可以根據(jù)導(dǎo)航條查看貨品需求，進(jìn)行個(gè)人密碼修改、注銷(xiāo)等操作。根據(jù)不同
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1