正宇財(cái)務(wù)管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)畢業(yè)論文(編輯修改稿)
2025-07-25 04:46 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 [科目代碼] [char] (20) NOT NULL, [科目名稱] [char] (20) NULL, [科目類別] [char] (20) NULL, [是否存貨科目] [char] (10) NULL, [余額方向] [char] (4) NULL [數(shù)量單位] [char] (10) NULL) ON [PRIMARY]GO創(chuàng)建“帳簿初始化表”數(shù)據(jù)表CREATE TABLE [dbo].[帳簿初始化表] ( [科目代碼] [char] (20) NOT NULL , [科目名稱] [char] (20) NULL , [累計(jì)借方] [money] NULL , [累計(jì)貸方] [money] NULL , [期初余額] [money] NULL , [余額方向] [char] (4) NULL ) ON [PRIMARY]GO創(chuàng)建“憑證表”和“憑證表歷史”數(shù)據(jù)表CREATE TABLE [dbo].[憑證表]( [憑證編號(hào)] [char] (10) NOT NULL, [憑證字號(hào)] [char] (2) NULL, [附單據(jù)] [int] NULL, [制單] [char] (20) NULL, [借方合計(jì)] [money] NULL, [貸方合計(jì)] [money] NULL, [憑證狀態(tài)] [char] (10) NULL) ON [PRIMARY]GOCREATE TABLE [dbo].[憑證表歷史] ( [憑證編號(hào)] [char] (10) NOT NULL , [憑證字號(hào)] [char] (2) NULL , [附單據(jù)] [int] NULL , [制單] [char] (20) NULL , [借方合計(jì)] [money] NULL , [貸方合計(jì)] [money] NULL , [憑證狀態(tài)] [char] (10) NULL ) ON [PRIMARY]GO創(chuàng)建“分錄表”和“分錄表歷史”數(shù)據(jù)表CREATE TABLE [dbo].[分錄表]( [編號(hào)] [int] IDENTITY (1,1) NOT NULL, [憑證編號(hào)] [char] (10) NOT NULL, [科目代碼] [char] (20) NULL, [借方] [money] NULL, [貸方] [money] NULL, [單價(jià)] [money] NULL, [結(jié)算方式] [char] (10) NULL,) ON [PRIMARY]GOCREATE TABLE [dbo].[分錄表歷史] ( [編號(hào)] [int] NOT NULL , [憑證編號(hào)] [char] (10) NOT NULL , [科目代碼] [char] (20) NULL , [借方] [money] NULL , [貸方] [money] NULL , [單價(jià)] [money] NULL , [結(jié)算方式] [char] (10) NULL ,) ON [PRIMARY]GO創(chuàng)建“科目余額表”數(shù)據(jù)表CREATE TABLE [dbo].[科目余額表] ( [科目代碼] [char] (20) NULL , [期初借方余額] [money] NULL , [期初貸方余額] [money] NULL , [本期借方發(fā)生額] [money] NULL , [本期貸方發(fā)生額] [money] NULL ,ben [本期借方余額] [money] NULL , [本期貸方余額] [money] NULL , [最后結(jié)算分錄](méi) [int] NULL , [余額方向] [char] (4) NULL ,) ON [PRIMARY]GO創(chuàng)建“本期明細(xì)帳簿”數(shù)據(jù)表CREATE TABLE [dbo].[本期明細(xì)帳簿] ( [內(nèi)部編號(hào)] [int] IDENTITY (1, 1) NOT NULL , [分錄編號(hào)] [int] NULL , [憑證字號(hào)] [char] (4) NULL , [憑證編號(hào)] [char] (10) NULL , [科目代碼] [char] (20) NULL , [借方] [money] NULL , [貸方] [money] NULL , [余額方向] [char] (4) NULL , [單價(jià)] [money] NULL , [結(jié)算方式] [char] (10) NULL ,) ON [PRIMARY]GO 創(chuàng)建“本期匯總帳簿”數(shù)據(jù)表CREATE TABLE [dbo].[本期匯總帳簿] ( [科目代碼] [char] (20) NOT NULL , [會(huì)計(jì)期間] [int] NULL , [期初余額] [money] NULL , [本期借方合計(jì)] [money] NULL , [本期貸方合計(jì)] [money] NULL , [本年借方累計(jì)] [money] NULL , [本年貸方累計(jì)] [money] NULL , [余額] [money] NULL , [余額方向] [char] (4) NULL ) ON [PRIMARY]GO創(chuàng)建“資產(chǎn)負(fù)債表”數(shù)據(jù)表CREATE TABLE [dbo].[資產(chǎn)負(fù)債表] (流動(dòng)資產(chǎn)總計(jì)] [money] NULL , [固定資產(chǎn)總計(jì)] [money] NULL , [其他資產(chǎn)] [money] NULL , [資產(chǎn)總計(jì)] [money] NULL , [應(yīng)付帳款] [money] NULL , [其他負(fù)債] [money] NULL , [負(fù)債總計(jì)] [money] NULL , [實(shí)收資本總計(jì)] [money] NULL , [負(fù)債及所有者權(quán)益總計(jì)] [money] NULL) ON [PRIMARY]GO創(chuàng)建“系統(tǒng)參數(shù)表”數(shù)據(jù)表CREATE TABLE [dbo].[系統(tǒng)參數(shù)表] ( [編號(hào)] [int] IDENTITY (1, 1) NOT NULL , [參數(shù)名稱] [char] (20) NULL , [取值] [int] NULL ) ON [PRIMARY]GO本模塊主要就是一個(gè)簡(jiǎn)單的界面視圖，：圖417財(cái)務(wù)管理系統(tǒng)主界面圖418 管理員登陸界面員工管理的權(quán)限屬于經(jīng)理。以“admin”帳號(hào)登陸系統(tǒng)。選擇“員工管理”，可以進(jìn)行“創(chuàng)建員工帳號(hào)”、“修改員工密碼”、“修改員工資料”等操作。也可以點(diǎn)取“員工帳號(hào)管理”啟動(dòng)如圖417所示界面進(jìn)行員工帳號(hào)的集中統(tǒng)一管理。圖419財(cái)務(wù)管理系統(tǒng)子界面本模塊的功能是對(duì)基礎(chǔ)財(cái)務(wù)的設(shè)定、使工作人員易于工作，做到數(shù)據(jù)不易丟失，根據(jù)各種基本情況設(shè)定界面。圖420 填寫憑證界面本模塊的功能主要用于查詢財(cái)務(wù)相關(guān)賬目及信息，分別有總分類查詢和各賬目的明細(xì)查詢，圖421 總分類賬目查詢?cè)O(shè)計(jì)界面 明細(xì)賬查詢界面第五章 財(cái)務(wù)管理系統(tǒng)詳細(xì)設(shè)計(jì)及編碼圖51 管理員登陸界面員工管理的權(quán)限屬于經(jīng)理。以“admin”帳號(hào)登陸系統(tǒng)。選擇“員工管理”，可以進(jìn)行“創(chuàng)建員工帳號(hào)”、“修改員工密碼”、“修改員工資料”等操作。也可以點(diǎn)取“員工帳號(hào)管理”啟動(dòng)如下圖所示界面進(jìn)行員工帳號(hào)的集中統(tǒng)一管理。主要代碼如下：Private Sub Command1_Click()Dim Uname As StringDim Pd As StringDim Sql As StringUname = 39。存放用戶名Pd = 39。存放密碼Sql = select * from pwd where 用戶名=39。 39。存放一SQL字符串If = 1 Then 39。判斷記錄集對(duì)象的狀態(tài) Sql amp。 Uname amp。 39。 and 密碼=39。 amp。 Pd amp。 39。, Con, 1, 3 39。判斷返回的記錄條數(shù)是否為0如果不為0則表示在表中存在這樣一個(gè)用戶名和密碼，否則則不存在If 0 ThenQx = (權(quán)限)Unload Form1ElseMsgBox 用戶名或者密碼錯(cuò)誤End IfEnd SubPrivate Sub Form_Load()39。設(shè)置數(shù)據(jù)庫(kù)連接對(duì)象，使其連接到數(shù)據(jù)庫(kù) driver=sql server。server=。database=student = adUseClient pwd, Con, 1, 3For i = 0 To 1 (用戶名)Next iEnd Sub圖52 員工管理界面主要代碼如下：Dim Flag As Boolean 39。記錄點(diǎn)擊確定前所進(jìn)
數(shù)學(xué)相關(guān)推薦
鄂ICP備17016276號(hào)-1