웹, DB를 모두 활용하는 커피전문점 POS 프로그램

소개글

커피전문점 POS 프로그램을 프로젝트로 만들었습니다.
IIS or 아파치 웹서버로 돌리고, mssql을 사용합니다.

패스워드는 암호화하여 저장합니다.

해당 프로젝트 전체를 25만원에 판매한 이력이 있습니다(설치 및 셋팅 포함) - 조금 수정하여 실제 사용

컴파일 실행환경

Microsoft Visual Studio (C#)

본문내용

저희 조는 서울시 이한구에 위치하여 나날이 번창하는 유명 커피전문점 커피자바를 조금 더 효과적으로 관리하기 위하여 주문관리 시스템을 개발하기로 결심했습니다.
고객은 고객 번호로 식별되며 이름과 주소, 휴대폰번호 및 마일리지와 기념일 정보를 가집니다. 하나의 주문은 고객번호, 주문번호, 근무자번호, 지불방식번호 및 날짜를 포함하며 지불방식 번호는 현금, 신용카드, 수표 등의 지불방식을 기록하게 됩니다. 근무자번호 테이블은 근무자 이름을 포함하며 주문을 받은 근무자가 누군지를 알 수 있게 합니다. 각각의 주문은 하나 또는 그 이상의 메뉴항목으로 구성되며 각각의 메뉴 항목 단위로 이루어지고 주문 수량도 기록됩니다. 메뉴항목은 메뉴번호로 식별되며 메뉴 항목의 이름과 가격으로 나눠집니다. 하나의 메뉴항목을 준비하는 데는 양도 다르고 종류도 다른 재료가 한 가지 이상 필요하며 이러한 재료들은 그 이름으로 식별되고, 커피자바는 각각의 재료마다 킬로그램, 리터 같은 단위를 가지고, 하나의 재료는 하나 또는 그 이상의 메뉴 항목에서 사용될 수 있고, 하나의 메뉴항목은 하나 또는 그 이상의 재료로 구성될 수 있습니다. 또한 CEO는 다양한 재료를 제공하는 거래처 목록을 관리해야 하는데 이들 거래처들은 그들의 공급업체 번호로 식별되고, 공급업체 이름과 주소를 가지며 재료의 가격 및 공급단위는 업체마다 다릅니다.

압축파일 내 파일목록

javacoffee_006.xlsm
mysql디비 데이터그램.ter
PosProgram/bin/Debug/path.conf
PosProgram/bin/Debug/PosProgram.exe
PosProgram/bin/Debug/PosProgram.pdb
PosProgram/bin/Debug/PosProgram.vshost.exe
PosProgram/CasherForm.cs
PosProgram/CasherForm.Designer.cs
PosProgram/CasherForm.resx
PosProgram/CompanyManageForm.cs
PosProgram/CompanyManageForm.Designer.cs
PosProgram/CompanyManageForm.resx
PosProgram/EditForm.cs
PosProgram/EditForm.Designer.cs
PosProgram/EditForm.resx
PosProgram/JMenu.cs
PosProgram/MainForm.cs
PosProgram/MainForm.Designer.cs
PosProgram/MainForm.resx
PosProgram/MemberAddForm.cs
PosProgram/MemberAddForm.Designer.cs
PosProgram/MemberAddForm.resx
PosProgram/MemberSearch.cs
PosProgram/MemberSearch.Designer.cs
PosProgram/MemberSearch.resx
PosProgram/MemoForm.cs
PosProgram/MemoForm.Designer.cs
PosProgram/MemoForm.resx
PosProgram/MenuManageForm.cs
PosProgram/MenuManageForm.Designer.cs
PosProgram/MenuManageForm.resx
PosProgram/obj/Debug/PosProgram.CasherForm.resources
PosProgram/obj/Debug/PosProgram.CompanyManageForm.resources
PosProgram/obj/Debug/PosProgram.csproj.FileListAbsolute.txt
PosProgram/obj/Debug/PosProgram.csproj.GenerateResource.Cache
PosProgram/obj/Debug/PosProgram.EditForm.resources
PosProgram/obj/Debug/PosProgram.exe
PosProgram/obj/Debug/PosProgram.MainForm.resources
PosProgram/obj/Debug/PosProgram.MemberAddForm.resources
PosProgram/obj/Debug/PosProgram.MemberSearch.resources
PosProgram/obj/Debug/PosProgram.MemoForm.resources
PosProgram/obj/Debug/PosProgram.MenuManageForm.resources
PosProgram/obj/Debug/PosProgram.pdb
PosProgram/obj/Debug/PosProgram.Properties.Resources.resources
PosProgram/obj/Debug/PosProgram.SourcedisForm.resources
PosProgram/obj/Debug/PosProgram.SourceInputForm.resources
PosProgram/obj/Debug/PosProgram.SourceViewForm.resources
PosProgram/obj/Debug/Refactor/
PosProgram/obj/Debug/TempPE/
PosProgram/PosProgram.csproj
PosProgram/PosProgram.csproj.user
PosProgram/PosProgram.sln
PosProgram/PosProgram.suo
PosProgram/Program.cs
PosProgram/Properties/AssemblyInfo.cs
PosProgram/Properties/Resources.Designer.cs
PosProgram/Properties/Resources.resx
PosProgram/Properties/Settings.Designer.cs
PosProgram/Properties/Settings.settings
PosProgram/SourcedisForm.cs
PosProgram/SourcedisForm.Designer.cs
PosProgram/SourcedisForm.resx
PosProgram/SourceInputForm.cs
PosProgram/SourceInputForm.Designer.cs
PosProgram/SourceInputForm.resx
PosProgram/SourceViewForm.cs
PosProgram/SourceViewForm.Designer.cs
PosProgram/SourceViewForm.resx
PosProgram.zip
PosProgram_ver2/AboutForm.cs
PosProgram_ver2/AboutForm.Designer.cs
PosProgram_ver2/AboutForm.resx
PosProgram_ver2/bin/Debug/path.conf
PosProgram_ver2/bin/Debug/PosProgram.exe
PosProgram_ver2/bin/Debug/PosProgram.pdb
PosProgram_ver2/bin/Debug/PosProgram.vshost.exe
PosProgram_ver2/bin/Debug/PosProgram.vshost.exe.manifest
PosProgram_ver2/bin/Release/app.zip
PosProgram_ver2/bin/Release/path.conf
PosProgram_ver2/bin/Release/PosProgram.exe
PosProgram_ver2/bin/Release/PosProgram.pdb
PosProgram_ver2/bin/Release/PosProgram.vshost.exe
PosProgram_ver2/bin/Release/PosProgram.vshost.exe.manifest
PosProgram_ver2/CardPayForm.cs
PosProgram_ver2/CardPayForm.Designer.cs
PosProgram_ver2/CardPayForm.resx
PosProgram_ver2/CasherForm.cs
PosProgram_ver2/CasherForm.Designer.cs
PosProgram_ver2/CasherForm.resx
PosProgram_ver2/CompanyManageForm.cs
PosProgram_ver2/CompanyManageForm.Designer.cs
PosProgram_ver2/CompanyManageForm.resx
PosProgram_ver2/EditForm.cs
PosProgram_ver2/EditForm.Designer.cs
PosProgram_ver2/EditForm.resx
PosProgram_ver2/InputForm.cs
PosProgram_ver2/InputForm.Designer.cs
PosProgram_ver2/InputForm.resx
PosProgram_ver2/JMenu.cs
PosProgram_ver2/MainForm.cs
PosProgram_ver2/MainForm.Designer.cs
PosProgram_ver2/MainForm.resx
PosProgram_ver2/MemberAddForm.cs
PosProgram_ver2/MemberAddForm.Designer.cs
PosProgram_ver2/MemberAddForm.resx
PosProgram_ver2/MemberSearchForm.cs
PosProgram_ver2/MemberSearchForm.Designer.cs
PosProgram_ver2/MemberSearchForm.resx
PosProgram_ver2/MemoForm.cs
PosProgram_ver2/MemoForm.Designer.cs
PosProgram_ver2/MemoForm.resx
PosProgram_ver2/MenuManageForm.cs
PosProgram_ver2/MenuManageForm.Designer.cs
PosProgram_ver2/MenuManageForm.resx
PosProgram_ver2/obj/Debug/PosProgram.AboutForm.resources
PosProgram_ver2/obj/Debug/PosProgram.CardPayForm.resources
PosProgram_ver2/obj/Debug/PosProgram.CasherForm.resources
PosProgram_ver2/obj/Debug/PosProgram.CompanyManageForm.resources
PosProgram_ver2/obj/Debug/PosProgram.csproj.FileListAbsolute.txt
PosProgram_ver2/obj/Debug/PosProgram.csproj.GenerateResource.Cache
PosProgram_ver2/obj/Debug/PosProgram.EditForm.resources
PosProgram_ver2/obj/Debug/PosProgram.exe
PosProgram_ver2/obj/Debug/PosProgram.InputForm.resources
PosProgram_ver2/obj/Debug/PosProgram.MainForm.resources
PosProgram_ver2/obj/Debug/PosProgram.MemberAddForm.resources
PosProgram_ver2/obj/Debug/PosProgram.MemberSearchForm.resources
PosProgram_ver2/obj/Debug/PosProgram.MemoForm.resources
PosProgram_ver2/obj/Debug/PosProgram.MenuManageForm.resources
PosProgram_ver2/obj/Debug/PosProgram.PaymentCancelForm.resources
PosProgram_ver2/obj/Debug/PosProgram.PaymentForm.resources
PosProgram_ver2/obj/Debug/PosProgram.pdb
PosProgram_ver2/obj/Debug/PosProgram.Properties.Resources.resources
PosProgram_ver2/obj/Debug/PosProgram.SourcedisForm.resources
PosProgram_ver2/obj/Debug/PosProgram.SourceInputForm.resources
PosProgram_ver2/obj/Debug/PosProgram.SourceViewForm.resources
PosProgram_ver2/obj/Debug/Refactor/
PosProgram_ver2/obj/Debug/ResolveAssemblyReference.cache
PosProgram_ver2/obj/Debug/TempPE/
PosProgram_ver2/obj/Release/PosProgram.AboutForm.resources
PosProgram_ver2/obj/Release/PosProgram.CardPayForm.resources
PosProgram_ver2/obj/Release/PosProgram.CasherForm.resources
PosProgram_ver2/obj/Release/PosProgram.CompanyManageForm.resources
PosProgram_ver2/obj/Release/PosProgram.csproj.FileListAbsolute.txt
PosProgram_ver2/obj/Release/PosProgram.csproj.GenerateResource.Cache
PosProgram_ver2/obj/Release/PosProgram.EditForm.resources
PosProgram_ver2/obj/Release/PosProgram.exe
PosProgram_ver2/obj/Release/PosProgram.InputForm.resources
PosProgram_ver2/obj/Release/PosProgram.MainForm.resources
PosProgram_ver2/obj/Release/PosProgram.MemberAddForm.resources
PosProgram_ver2/obj/Release/PosProgram.MemberSearchForm.resources
PosProgram_ver2/obj/Release/PosProgram.MemoForm.resources
PosProgram_ver2/obj/Release/PosProgram.MenuManageForm.resources
PosProgram_ver2/obj/Release/PosProgram.PaymentCancelForm.resources
PosProgram_ver2/obj/Release/PosProgram.PaymentForm.resources
PosProgram_ver2/obj/Release/PosProgram.pdb
PosProgram_ver2/obj/Release/PosProgram.Properties.Resources.resources
PosProgram_ver2/obj/Release/PosProgram.SourcedisForm.resources
PosProgram_ver2/obj/Release/PosProgram.SourceInputForm.resources
PosProgram_ver2/obj/Release/PosProgram.SourceViewForm.resources
PosProgram_ver2/obj/Release/ResolveAssemblyReference.cache
PosProgram_ver2/obj/Release/TempPE/
PosProgram_ver2/PaymentCancelForm.cs
PosProgram_ver2/PaymentCancelForm.Designer.cs
PosProgram_ver2/PaymentCancelForm.resx
PosProgram_ver2/PaymentForm.cs
PosProgram_ver2/PaymentForm.Designer.cs
PosProgram_ver2/PaymentForm.resx
PosProgram_ver2/PosProgram.csproj
PosProgram_ver2/PosProgram.csproj.user
PosProgram_ver2/PosProgram.sln
PosProgram_ver2/PosProgram.suo
PosProgram_ver2/Program.cs
PosProgram_ver2/Properties/AssemblyInfo.cs
PosProgram_ver2/Properties/Resources.Designer.cs
PosProgram_ver2/Properties/Resources.resx
PosProgram_ver2/Properties/Settings.Designer.cs
PosProgram_ver2/Properties/Settings.settings
PosProgram_ver2/SourcedisForm.cs
PosProgram_ver2/SourcedisForm.Designer.cs
PosProgram_ver2/SourcedisForm.resx
PosProgram_ver2/SourceInputForm.cs
PosProgram_ver2/SourceInputForm.Designer.cs
PosProgram_ver2/SourceInputForm.resx
PosProgram_ver2/SourceViewForm.cs
PosProgram_ver2/SourceViewForm.Designer.cs
PosProgram_ver2/SourceViewForm.resx
PosProgram_ver2.zip
www/11.jpg
www/12.jpg
www/a.png
www/aboutus.jpg
www/aboutus최종.jpg
www/b.png
www/best.png
www/c.jpg
www/c.png
www/coffe.png
www/d.jpg
www/d.png
www/e.png
www/homepage2.html
www/homepage2_08.jpg
www/homepage2_namo_js1.js
www/images/homepage2_01.png
www/images/homepage2_02.png
www/images/homepage2_03.png
www/images/homepage2_04.png
www/images/homepage2_05.png
www/images/homepage2_06.png
www/images/homepage2_07.png
www/images/homepage2_08.jpg
www/images/homepage2_09.png
www/images/homepage2_10.png
www/images/icons/100.png
www/images/icons/101.png
www/images/icons/102.png
www/images/icons/103.png
www/images/icons/104.png
www/images/icons/105.png
www/images/icons/106.png
www/images/icons/107.png
www/images/icons/108.png
www/images/icons/109.png
www/images/icons/110.png
www/images/icons/111.png
www/images/icons/112.png
www/images/icons/113.png
www/images/icons/114.png
www/images/icons/115.png
www/images/icons/116.png
www/images/icons/117.png
www/images/icons/118.png
www/images/icons/119.png
www/images/icons/120.png
www/images/icons/121.png
www/images/icons/122.png
www/images/icons/123.png
www/images/icons/124.png
www/images/icons/125.png
www/images/icons/200.png
www/images/icons/201.png
www/images/icons/202.png
www/images/icons/203.png
www/images/icons/204.png
www/images/icons/205.png
www/images/icons/206.png
www/images/icons/207.png
www/images/icons/208.png
www/images/icons/209.png
www/images/icons/210.png
www/images/icons/211.png
www/images/icons/212.png
www/images/icons/213.png
www/images/icons/214.png
www/images/icons/215.png
www/images/icons/216.png
www/images/icons/217.png
www/images/icons/218.png
www/images/icons/219.png
www/images/icons/220.png
www/images/icons/221.png
www/images/icons/222.png
www/images/icons/223.png
www/images/icons/224.png
www/images/icons/225.png
www/images/icons/226.png
www/images/icons/227.png
www/images/icons/228.png
www/images/icons/229.png
www/images/icons/230.png
www/images/icons/231.png
www/images/icons/300.png
www/images/icons/301.png
www/images/icons/302.png
www/images/icons/303.png
www/images/icons/304.png
www/images/icons/305.png
www/images/icons/306.png
www/images/icons/307.png
www/images/icons/308.png
www/images/icons/309.png
www/images/icons/310.png
www/images/icons/311.png
www/images/icons/312.png
www/images/icons/313.png
www/images/icons/314.png
www/images/icons/315.png
www/images/icons/316.png
www/images/icons/317.png
www/images/icons/318.png
www/images/icons/319.png
www/images/icons/320.png
www/images/icons/321.png
www/images/icons/322.png
www/images/icons/323.png
www/images/icons/324.png
www/images/icons/325.png
www/images/icons/326.png
www/images/icons/327.png
www/images/icons/328.png
www/images/icons/329.png
www/images/icons/330.png
www/images/icons/331.png
www/images/icons/332.png
www/images/icons/333.png
www/images/icons/334.png
www/images/icons/335.png
www/images/icons/336.png
www/images/icons/400.png
www/images/icons/401.png
www/images/icons/402.png
www/images/icons/403.png
www/images/icons/404.png
www/images/icons/405.png
www/images/icons/406.png
www/images/icons/407.png
www/images/icons/408.png
www/images/icons/409.png
www/images/icons/410.png
www/images/icons/411.png
www/images/icons/412.png
www/images/icons/413.png
www/images/icons/414.png
www/images/icons/415.png
www/images/icons/416.png
www/images/icons/417.png
www/images/icons/418.png
www/images/icons/419.png
www/images/icons/420.png
www/images/icons/421.png
www/images/icons/422.png
www/images/icons/423.png
www/images/icons/424.png
www/images/icons/425.png
www/images/icons/426.png
www/images/icons/427.png
www/images/icons/428.png
www/images/icons/429.png
www/images/icons/430.png
www/images/icons/431.png
www/images/icons/432.png
www/images/icons/433.png
www/images/icons/434.png
www/images/icons/435.png
www/images/icons/436.png
www/images/icons/437.png
www/images/icons/438.png
www/images/icons/439.png
www/images/icons/440.png
www/images/icons/441.png
www/images/icons/442.png
www/images/icons/443.png
www/images/icons/444.png
www/images/icons/445.png
www/images/icons/446.png
www/images/icons/447.png
www/images/icons/448.png
www/images/icons/449.png
www/images/icons/450.png
www/images/icons/451.png
www/images/icons/452.png
www/images/icons/453.png
www/images/icons/454.png
www/images/icons/455.png
www/images/icons/456.png
www/images/icons/457.png
www/images/icons/458.png
www/images/icons/459.png
www/images/icons/460.png
www/images/icons/461.png
www/images/icons/462.png
www/images/icons/463.png
www/images/icons/464.png
www/images/icons/465.png
www/images/icons/466.png
www/images/icons/467.png
www/images/icons/468.png
www/images/icons/500.png
www/images/icons/501.png
www/images/icons/502.png
www/images/icons/503.png
www/images/icons/504.png
www/images/icons/505.png
www/images/icons/506.png
www/images/icons/507.png
www/images/icons/508.png
www/images/icons/509.png
www/images/icons/510.png
www/images/icons/511.png
www/images/icons/512.png
www/images/icons/513.png
www/images/icons/514.png
www/images/icons/515.png
www/images/icons/516.png
www/images/icons/517.png
www/images/icons/518.png
www/images/icons/519.png
www/images/icons/520.png
www/images/icons/521.png
www/images/icons/522.png
www/images/icons/523.png
www/images/icons/524.png
www/images/icons/525.png
www/images/icons/526.png
www/images/icons/527.png
www/images/icons/528.png
www/images/icons/529.png
www/images/icons/530.png
www/images/icons/600.png
www/images/icons/601.png
www/images/icons/602.png
www/images/icons/603.png
www/images/icons/604.png
www/images/icons/605.png
www/images/icons/606.png
www/images/icons/607.png
www/images/icons/608.png
www/images/icons/609.png
www/images/icons/610.png
www/images/icons/611.png
www/images/icons/612.png
www/images/icons/613.png
www/images/icons/614.png
www/images/icons/615.png
www/images/icons/616.png
www/images/icons/617.png
www/images/icons/618.png
www/images/icons/619.png
www/images/icons/620.png
www/images/icons/621.png
www/images/icons/622.png
www/images/icons/623.png
www/images/icons/624.png
www/images/icons/625.png
www/images/icons/626.png
www/images/icons/627.png
www/images/icons/628.png
www/images/icons/629.png
www/images/icons/630.png
www/images/icons/631.png
www/images/icons/632.png
www/images/icons/633.png
www/images/icons/634.png
www/images/icons/635.png
www/images/icons/636.png
www/images/icons/637.png
www/images/icons/638.png
www/images/icons/639.png
www/images/icons/640.png
www/images/icons/641.png
www/images/icons/642.png
www/images/icons/643.png
www/images/icons/644.png
www/images/icons/645.png
www/images/icons/646.png
www/images/icons/default.png
www/images/spacer.gif
www/index.htm
www/index.html
www/index_namo_js1.js
www/noname10.htm
www/noname10_namo_js1.js
www/noname10_namo_js2.js
www/noname10_namo_js3.js
www/noname10_namo_js4.js
www/noname11.htm
www/noname110.htm
www/noname11_namo_js1.js
www/noname120.htm
www/noname130.htm
www/noname140.htm
www/공지3.png
www/로고.png
www/매장정보.jpg
www/매장정보최종.jpg
www/서비스2.jpg
www/선택.png
www/이벤트1.jpg
www/이벤트최종.jpg
www/프렌차이즈.jpg
www/홈메인.swf
디비기말과제삽입그림.pptx
디비레포트.pdf
디비레포트_제안서.hwp
디비레포트_최종보고서.hwp
멀티미디어데이터설계 4조.zip
소개.txt
엔티티과제그림.pptx
자바커피.pptx
커피자바_mssql.dm2
커피자바_mssql.~m2

전체 목록 보기

참고 자료

없음