基于.NET的ERP沙盤輔助教學系統的開發

論文字數:19649,頁數:51

基于.NET的ERP沙盤輔助教學系統的開發

摘  要

 ERP沙盤模擬是一種體驗式學習方式，不過由于目前仍處于手工階段，手工操作導致低效率和高錯誤率。并且任課老師的工作量會異常繁重。基于上述原因，我利用ADO.NET提供的強大的數據庫管理功能、界面優化等方便之處，給用戶提供一個功能完善且操作簡易高效率的ERP沙盤模擬輔助管理系統。該系統是運用Visual C# 2005進行編寫，以.NET數據庫訪問技術為核心，以SQL Server 2005數據庫為后臺。
 本系統改變了以往單機操作的現狀，B/S模式實現了教師和學生操作的實時互動。學生通過本系統可以進行沙盤模擬的各種數據的提交和報表的自動運算，免去平帳的煩惱，教師可管理用戶，實時監控教學過程，采用本系統將會使ERP沙盤模擬教學過程更為流暢、高效率。
關鍵詞：ERP 沙盤模擬 信息系統 .NET

Based on. NET's ERP Simulation Game instruction system

ABSTRACT

 ERP experience is a sand table simulation-based learning methods, but still in the hand as a result of the current phase, resulting in low efficiency of manual and high ERPor rate. And classroom teachers will be exceptionally heavy workload. For these reasons, I use ADO.NET to provide a powerful database management features, optimizing the interface between convenience to the users with a fully functional and efficient operation of simple sand table simulation supporting ERP management system. The system is shipped with a powerful programming tool - Visual C # 2005, to prepare to. NET technology as the core database access to SQL Server 2005 database for the background.
 The system has changed the status of the previous stand-alone operation, B / S mode operation of teachers and students interact in real time. Students through the sand table of the system can simulate a variety of data and reports submitted to the automatic operation, replacing the current account of the annoyance level, teachers can manage users, real-time monitoring of the teaching process, using the ERP system will enable the simulation of the teaching process more sand table smooth and efficient.
Key words：ERP  Simulation Game  Information System  .NET

目  錄

 摘要 I
 ABSTRACT II
 1緒論 1
 1.1序言 1
 1.2ADO.NET簡介 1
 1.3信息系統概述 1
 1.4ERP沙盤輔助教學系統簡介 2
 1.5ERP沙盤輔助教學系統的目標 2
 2系統分析 4
 2.1系統的開發背景 4
2.1.1系統目標 4
2.1.2系統功能 5
2.1.3系統的投入影響分析 5
 2.2系統可行性分析 5
 2.3需求分析 7
2.3.1非功能性需求 8
2.3.2功能性需求 8
 2.4業務流程分析 9
2.4.1業務流程圖 9
 2.5數據流程分析 11
2.5.1數據流程圖 12
 2.6數據字典 15
 3系統設計 23
 3.1總體設計 23
 3.2 IPO圖 26
 3.3數據庫設計 28
3.3.1概念模型 28
3.3.2邏輯數據模型 30
 3.4界面設計 34
 4系統實施 37
 4.1平臺設計 37
4.1.1硬件平臺環境 37
4.1.2軟件平臺環境 37
 4.2數據庫構建 37
4.2.1數據庫的創建 37
4.2.2數據庫的連接 38
 4.3代碼設計 39
4.3.1登陸界面代碼實現 39
4.3.2清除歷史記錄代碼實現 41
4.3.3資產負債表代碼實現 42
 5系統總結 44
 5.1系統特點 44
5.1.1技術先進性 44
5.1.2安全性能好 44
5.1.3操作便捷性 44
 5.2待解決問題 45
 參考文獻 46
 謝辭 47