臺灣博碩士論文加值系統

為解決威龍公司ERP系統Microsoft Dynamics NAV 2013無法提供各所需資訊，且無法直接產出EXCEL報表，造成行政作業上諸多不便，本銷售與財務輔助系統特別以Visual Studio 2010搭建相關的網路平台而建構，用以達到簡化工作流程、降低錯誤率及快速查詢公司內部資訊的目的。
本輔助系統與原系統比較：可用裝置新增行動裝置、系統登入無登入上限、報表輸出新增EXCEL、進貨進度登錄/查詢更彈性。本輔助系統功能：新增發票登錄功能、未完工報告登錄與系統首頁公告。經實際驗證本輔助系統的確提升了該公司在行政作業上的效能，除了可以提供該公司相關人員於網頁上查詢處理過後的資料，並可輕鬆的下載相關需要的報表。

The ERP system of DWP company- Microsoft Dynamics NAV 2013 it can not provide the various information required by different departments, and it can not produce EXCEL reports directly, causing a lot of inconvenience on administration operations, this sales and financial assist system is built with relevant network platform and constructed by Visual Studio 2010. This assist system is made to simplify the procedure in work, to decrease the mistakes, and the staff can find the internal information on it quickly.
Compared to the original system, this assist system can be used in mobile device, no limit number of login, report output in excel format, and more flexible in query purchase info and update. The new feature of the system：invoice number log in function, recording of unfinished work, and bulletin board in homepage. After the testing, we can confirm this assist system is enhanced the performance in administration operations. Company staff can easily find the information and download the reports they need.

摘 要 i
ABSTRACT ii
目錄 iii
圖目錄 v
表目錄 viii
第一章 緒論 1
1.1引言 1
1.2 研究動機與目的 1
1.3章節說明 2
第二章 系統探討及介紹 3
2.1企業資源規劃系統(Enterprise Resource Planning) 3
2.2 Microsoft Dynamics ERP系統介紹 6
2.3資料庫管理系統介紹 9
2.4 Microsoft Visual Studio介紹 12
2.5 威龍公司系統介紹 17
第三章 系統功能規劃 25
3.1系統功能規劃 25
3.2系統流程圖 29
第四章 系統測試 31
4.1帳號登入作業 31
4.2資料維護 33
4.3報表功能 37
4.4其他功能 39
4.5系統管理功能 42
第五章 結果與討論 44

1. Swaminathan, J. M., and Tayur. S. R. (2003) “Models for supply chains in e-business, “Management Science, 49(10), 1387-1406.
2. Grant Norris, James R. Hurley, Kenneth M. Hartley, John R. Dunleavy, John D. Balls (2000) E-Business and ERP: Transforming the Enterprise
3. Davenport, T. H. (1998). Putting the enterprise into the enterprise systems. Harvard Business Review, 76(4), 121-131.
4. Gould, L. (1997). Planning and scheduling today’s automotive enterprises, Automative Manufacturing & Production, 109(4), 62-66.
5. Mabert, V .A., Soni, A.,& Venkataraman, M.A. (2000). Enterprise resource planning: survey of US manufacturing firms. Production and Inventory Management, 41(2),52-58.
6. ERP簡介. 長榮大學企業管理學系 ERP研究中心. [2015-10-26]
7. Shaul, L.; Tauber, D. Critical Success Factors in Enterprise Resource Planning Systems: Review of the Last Decade. ACM Computing Surveys. 2013, 45
8. Kenneth C. Laudon / Jane P. Laudon, Management Information Systems. 2002
9. 林東清. 資訊管理：e化企業的核心競爭能力. 臺北市: 智勝文化. 2005: 180–181
10. 林震岩、柯福富：企業資源規劃ERP--SAP 與ORACLE 之解析與應用(2007)
11. History of Enterprise Resource Management (ERP). BizCanvas. [2015-10-25]
12. 資策會：資訊與電腦MIC ITIS 計畫(1999)
13. Microsoft acquires Navision (2002)，取自Microsoft website：
https://news.microsoft.com/2002/07/11/microsoft-acquires-navision/#p5dDsHUGCoSqxLmT.97
14. Harpst, Gary, Charles Babbage Institute, 2004
15. NAV之導入成功案例之一，取自Tectura Taiwan：
http://www.tecturatw.com/what_nav_Customer.aspx
16. NAV之導入成功案例之二，取自天微資訊：
http://www.ksinform.com/case.htm
17. Codd, Edgar Frank: "Does Your DBMS Run By the Rules?", ComputerWorld, 21. October 1985
18. Chamberlin, Donald D; Boyce, Raymond F (1974), SEQUEL: A Structured English Query Language.
19. D. C. Tsichritzis and A. Klug, The ANSI/X3/SPARC DBMS framework report of the study group on database management systems. Information Systems, 3(3):173-191, 1978.
20. Chien Yu and Teri Brandenburg, Multimedia database applications: issues and concerns for classroom teaching, 2011
21. West's Encyclopedia of American Law (definition)
22. Visual Studio簡介，取自：
https://msdn.microsoft.com/zh-tw/library/fx6bk1f4(v=vs.100).aspx
23. Visual Studio 2010 IDE改良內容，取自：
https://msdn.microsoft.com/zh-tw/library/dd547188(v=vs.100).aspx
24. 整合式開發環境(IDE)，取自：
https://vinayakgarg.wordpress.com/2011/08/27/features-missing-in-visual-studio-2010-express/