臺灣博碩士論文加值系統

近年來全球各地不時發生許多有關於食品安全的問題，不僅對社會大眾造成恐慌，也對相關的食品產業連帶造成相當大的衝擊。為了改善此類問題，許多國家無不積極推動其食品產銷履歷制度，台灣亦不例外；但液蛋生產並未列入擬進行之產銷履歷食品項目中。基於此，本研究之目的即在嘗試設計可於線上操作之台灣液蛋產銷履歷資訊系統。藉由網際網路與伺服器連結，讓液蛋產業供應鏈中之飼料業者、蛋雞場業者和液蛋生產業者進行產銷記錄，並提供液蛋之消費者查詢液蛋履歷之服務。本系統採用Windows Server 2003作業系統，以動態網頁程式 ASP.NET 2.0連結伺服器之Microsoft Access 2007 資料庫撰寫而成，建置於中興大學動物科學系之伺服器中。主要架構包括最終消費者之一般查詢、供應鏈中各階段業者之產銷記錄、使用說明及聯絡程式設計者等四項。其中之產銷記錄，使用者必須註冊後才能登入使用。藉由完整履歷之建置，可提高蛋品加工廠對購買產品之信心，更能提高業者之產品競爭力。期望藉由本系統之建立，可作為未來政府機關建置類似產品產銷履歷制度之參考。且在系統發展上可以更進一步加入如檢驗機構，或是其他有參與該生產鏈之業者，使履歷記錄更完整、可供查詢之資料更詳細。

Lots of problems concerning food safety take place frequently around the world in recent years. These problems cause not only the people scare but also large shocks to related food industries. In order to improve these similar problems, many countries actively promote their food traceability system, so does Taiwan. However, liquid egg production is not one item of the food traceability products at the moment. Therefore, this study was made to design a traceability system for liquid eggs which could be operated online. The feed manufacturer, layer farmer and liquid egg manufacturer in liquid egg industry of supply chain could thus connect through Internet to record their production and sale data, and offer consumer of liquid egg manufacturers to trace their product data. This system was designed by adopting Windows Server 2003 operating system, and was written with ASP.NET 2.0 (Active Server Pages.Net 2.0) coordinated with Microsoft Access 2007 databases. This system was installed on the Server of the Department of Animal Science, National Chung Hsing University. The main function includes four sections regarding consumers'' (ex. egg product processing factory) general inquiry, production record for members at different stage of supply chain, operation instructions and contact system designer. After registration and login, the user could handle the section of the production record for members at different stage of supply chain. With the installation of complete traceability and random inspection, the consumers of egg product processing factory could increase their confidence to the liquid eggs they bought; the businessmen also could improve their product competitiveness. It is expected that this system might act as a reference to the traceability system of similar product for the government agency in the future. Also may the further joins like the testing organization in the development of the system, or other participant in enterprise of the supply chain, to make the traceability record more complete, the data for inquiry more detailed.

壹、前言...................................................1
貳、文獻檢討...............................................3
一、 產銷履歷制度的起源與發展概況......................3
(一) 產銷履歷制度的起源...........................3
(二) 台灣推行產銷履歷制度之概況...................4
(三) 各國的產銷履歷執行情況.......................7
(四) 我國產銷履歷之執行..........................10
二、 產銷履歷之定義與價值.............................15
(一) 產銷履歷之定義..............................15
(二) 產銷履歷對於生產者和消費者之影響與價值......15
三、 產銷履歷系統模型.................................22
(一) 系統之結構..................................22
(二) 系統之核心實體..............................22
(三) 可追溯資源單位的概念........................23
(四) 追溯性分析..................................23
四、 台灣液蛋產業發展概況.............................23
(一) 液蛋的製造..................................24
(二) 液蛋之微生物污染............................25
(三) 液蛋之殺菌處理..............................26
五、 產銷履歷相關資訊與網際網路.......................32
(一) 網際網路與產銷履歷結合之必要性..............34
(二) 產銷履歷相關線上系統之實例..................34
參、材料與方法............................................42
一、 硬體與作業系統...................................42
二、 系統程式語言與軟體...............................42
(一) 網頁設計語言................................42
(二) 資料庫管理系統..............................42
(三) 網頁撰寫軟體................................42
三、 液蛋產銷履歷系統.................................42
(一) 系統之設計..................................42
(二) 系統資料庫..................................43
(三) 系統設計圖..................................43
(四) 系統流程圖..................................44
肆、結果與討論............................................46
一、 本系統之架構.....................................46
二、 液蛋產品之生產流程圖與風險管理表.................47
(一) 生產流程圖..................................47
(二) 風險管理表..................................48
三、 液蛋產銷履歷系統主程式...........................49
(一) 飼料廠功能區塊..............................52
(二) 畜牧場功能區塊..............................59
(三) 液蛋廠功能區塊..............................70
四、 本系統之特色與檢討...............................78
伍、結論..................................................79
陸、參考文獻..............................................80
柒、附錄..................................................84

中央畜產會。2008。認識CAS殺菌液蛋廠。Online Available: http://www.naif.org.tw /egg/toknow.html. Accessed May. 2008.
中華穀類食品工業技術研究所。2005。殺菌液蛋的認識與應用。行政院農業委員會。
木村彰利。2005。訪台報告。畜產品產銷履歷制度講習會。
行政院農業委員會。2005。行政院農業委員會農業e化領域策略規劃報告。Online Available: http://kmintra.coa.gov.tw/coa/InternetDownloadFileServlet?file_id=454 &actor_info_id=001. Accessed May, 2008.
行政院農業委員會。2008a。96年畜牧農情概況分析。Online Available: http:// www.coa.gov.tw/view.php?catid=13922. Accessed May, 2008.
行政院農業委員會。2008b。農產品生產及驗證管理法。
林貞。2006。台灣農產品安全鏈資訊化發展現況與趨勢。行政院農業委員會。 Online Available: http://bulletin.coa.gov.tw/files/web_articles_files/9455/1181.pdf. Accessed May, 2008.
胡忠一。2005a。安全農產e 指搞定 從日本立法推動可追溯性制度談產銷履歷。農訓 22(8)：11-14。
胡忠一。2005b。農產品衛生安全與產銷追蹤系統。農產品衛生安全與市場消費研討會。國立中興大學。
財團法人資訊工業策進會。2008。資策會IDEAS-FIND╱經濟部技術處「創新資訊應用研究計畫」。Online Available: http://www.find.org.tw/。Accessed May, 2008.
張勝善。1986。蛋品加工學。華香園出版社。
張靜文。2005。加拿大牛隻生產履歷制度之介紹。農政與農情 160。Online Available: http://www.coa.gov.tw/view.php?catid=10339. Accessed May, 2008.
陳世芳。2006a。上農產品安全追溯資訊網查有身份證的農產品。台中區農情月刊 77。Online Available: http://www.tdais.gov.tw/search/book4/77/re771.htm. Accessed May, 2008.
陳明造。2006b。蛋品加工理論與應用（第二版）。藝軒圖書出版社。
陳雅琴。2005。美國農業部籌建全國動物標識系統。行政院農業委員會。 Online Available: http://www.coa.gov.tw/htmlarea_file/web_articles/4881/0403.pdf. Accessed May, 2008.
陳雅琴。2006c。美國食品安全的制度體系與法令規定。農政與農情 164。Online Available: http://www.coa.gov.tw/view.php?catid=10586. Accessed May, 2008.
黃培訓。2004。日本食品生產履歷制度對台灣的啟示。農政與農情 145。Online Available: http://www.coa.gov.tw/view.php?catid=7562. Accessed May, 2008.
黃萬傳。2000。台灣液蛋生產調查及市場潛力評估。美國穀物協會補助研究計畫報告。國立中興大學。
臺灣農產品安全追溯資訊網。2008。QA問答集。Online Available: http://taft. coa.gov.tw/index.asp?a=ctx&xItem=1196&ctNode=175。Accessed May, 2008.
龔榮太。2007。世界各國農畜產品積極導入產銷履歷之探討中央畜產會。Online Available: http://www.naif.org.tw/livestock/20071042.doc. Accessed May. 2008.
Bai, L., C. Ma, S. Gong, and Y. Yang. 2007. Food safety assurance systems in China. Food Control 18: 480-484.
Caporale, V., A. Giovannini, C. Di Francesco and P. Calistri. 2001. Importance of the traceability of animals and animal products in epidemiology. Rev. Sci. Tech. Off. Int. Epiz. 20 (2): 372-378.
Cheng, M. J., and J. E. L. Simmons. 1994. Traceability in manufacturing systems. Int. J. Oper. Prod. Man 14(10): 4-16.
Clemens, R. 2003. Meat traceability and consumer assurance in Japan. MATRIC Briefing Paper 03-MBP 5. Midwest Agribusiness Trade Research and Information Center, Iowa State University. Online Available: http://www.card.iastate.edu/　publications/DBS/ PDFFiles/03mbp5.pdf. Accessed Nov. 22, 2006.
Dickinson, D. L., and D. V. Bailey. 2002. Meat traceability: are US consumers willing to pay for it. J. Agr. Res. Econ. 27(2): 348–364.
Dupuy, C., V. Botta-Genoulaz, and A. Guinet. 2005. Batch dispersion model to optimise traceability in food industry. J. Food Eng. 70: 333-339.
Early, R. 1995. Guide to Quality Management Systems for the Food Industry, Blackie Academic and Professional. pp. 160-161,
Gledhill, J. 2002. Tracing the line - Using information technology to reduce costs while meeting industry requirements. Food Proc. 63(2): 48-56.
Golan, E., B. Krissoff, F. Kuchler, L. Calvin, K. Nelson, and G. Price. 2004. Traceability in the U.S. Food Supply: Economic Theory and Industry Studies. United States Department of Agriculture, E.R.S., Agricultural Economic Report Number 830.
Harlow, M. 2004. FOODTRACE concerted action programme generic framework for traceability. FOODTRACE Generic Framework. 34pp.
Jansen-Vullers M. H., J. C. Wortmann, and A. J. M. Beulens. 2004. Application of labels to trace material flows in multi-echelon supply chains. Prod. Plan Control 15(3): 303-312.
Kim, H. M., M. S. Fox, and M. Gruninger. 1995. An ontology of quality for enterprise modeling. In Proceedings of WET-ICE, Los Albamitos, CA, USA, pp.105-116.
McMeekin, T. A., J. Baranyi, J. Bowman, P. Dalgaard, M. Kirk, T. Ross, S. Schmid, and M.H. Zwietering. 2006. Inform. Syst. Food Safety Manage. 112: 181-194.
Moe, T. 1998. Perspectives on traceability in food manufacture. Trends Food Sci. Tech. 9: 211-214.
Noll, M., and M. Evelyn. 2005. Controlling the sustainability of food supply chains. Supply Chain Manage. 10(1): 7-10.
Pettitt, R. G. 2001. Traceability in the food animal industry and supermarket chains. Rev. Sci. Tech. Off. Int. Epiz. 20(2): 584-597.
Pinto, D. B., I. Castro, and A. A. Vicente. 2006. The use of TIC`s as a managing tool for traceability in the food industry. Food Res. Int. 39(7): 772-781.
Qu, X. H., Z. Da-fang, and Q. Dong-sheng. 2007. Studies on GIS based tracing and traceability of safe crop product in China. Agr. Sci. China 6(6): 724-731.
Regattieri, A., M. Gamberi, and R. Manzini. 2007. Traceability of food products: General framework and experimental evidence. J. Food Eng. 81: 347-35.
Schwägele, F. 2005. Traceability from a European perspective. Meat Sci. 71: 164-173.
Smith, G. C., J. D. Tatum, K. E. Belk, J. A. Scanga, T. Grandin, and J. N. Sofos. 2005. Traceability from a US perspective. Meat Sci. 71: 174-193.
The European Parliament and the Council of the European Union. 2002. Regulation (EC) No 178/2002 of the European parliament and of the council. Official Journal of the European Communities.
Thompson, M., G. Sylvia, and M. T. Morrissey. 2005. Seafood traceability in the United States: Current trends, system design, and potential applications. Compr. Rev. Food Sci. Food Safety 1:3-6.
Verbeke, W., and R. W. Ward. 2006. Consumer interest in information cues denoting quality, traceability and origin: An application of ordered probit models to beef labels. Food Qual. Prefer. 17: 453–467.
Viaene, J., and W. Verbeke. 1998. Traceability as a key instrument towards supply chain and quality management in the Belgian poultry meat chain. Supply Chain Manage. 3(3): 139-141.
Wilson, T. P., and W. R. Clarke. 1998. Food safety and traceability in the agricultural supply chain: using the Internet to deliver traceability. Supply Chain Manage. 3(3): 127-133.