创建一个应用程序 [英] create an application

问题描述

我正在考虑为餐馆创建一个应用程序。该应用程序将接收订单作为外卖客户进来，并将通知厨房厨师有关订单。这样就没有必要从前面走到厨房，告诉厨师订单。我不希望在Web上访问该应用程序，因为如果你愿意的话，订单是私密的。


我在争论哪个数据库和哪种编码语言使用。有什么建议？我不想使用Oracle，因为你必须购买。餐厅数据很小，无需具备Oracle提供的容量。 MS Access数据库是免费的，但不确定它是否足够灵活或易于使用。我需要生成报告并计算一些关于这些订单的数字，例如以现金，签证支付多少外卖订单......


ASP很好但不确定正确的选择。

I''m thinking about creating an application for a restaurant. The application will take orders as takeout-customers come in and will notify the chef in the kitchen about the orders. This way there is no need to physically walk from the front to the kitchen to tell the chef about the orders. I don''t want the application to be accessible on the Web because the orders are kind of private, if you will.

I''m debating about which database and what coding language to use. Any suggestions? I don''t want to use Oracle because you have to purchase. The restaurant data will be small and no need to have the capacity that Oracle provides. MS Access database is free but not sure if it''s flexible enough or that easy to use. I need to generate reports and calculate some numbers about those orders, like how much takeout orders were paid in cash, visa...

ASP is good but not sure the right choice.

推荐答案

MS访问非常灵活，你可以让它做任何事情，它有很多内置的报告功能。如果你想要更多的功能，你总是可以尝试MS-SQL Server（快速版本是免费的，但仍然相当强大）或MySQL - 免费，超级强大（维基百科和谷歌都使用MySQL），并且有一些安装也不是设置好了。


ASP在内联网上仍然非常有用，但不使用它的最大原因是它被弃用以支持新技术。你可能想尝试PHP - MySQL。功能强大且仍然受到支持。


Jared

MS access is pretty flexible, you can get it to do just about anything, and it has a lot of built in reporting capability. If you want more power, you can always try MS-SQL Server (express version is free and still pretty strong) or MySQL - free, super powerful (wikipedia and Google both use MySQL) and there are some installs that aren''t too hairy to set up.

ASP is still pretty useful over an intranet, but the biggest reason to not use it is that it is deprecated in favor of new technologies. you might want to try PHP - MySQL. Powerful and still being supported.

Jared

Jared，感谢您的回复。嗯......我想知道PHP和MySQL的学习曲线是什么。我从来没有用过它们。我很了解Oracle。


我同意你的ASP，并且它的另一个缺点是代码没有被用户屏蔽（也就是说，无法生成用于在用户机器上实现的二进制文件） 。


由于它不是一个Web应用程序，如何在前门的计算机上运行的程序进行通信并将命令发送到运行在厨房中的相同应用程序的计算机？

Jared, thanks for the response. Hmm... I''m wondering what''s the learning curve for PHP and MySQL. I''ve never used them. I know Oracle well.

I agree with you about ASP, and another drawback with it is the codes are not shielded with users (that is, cannot generate binaries for implementing on user machine).

Since it''s not a Web application, how can the program running in the computer at the front door communicate and send the orders to the computer running the same application in the kitchen?

你好pinky8，

首先，因为它不是一个网络应用程序（而不是与ASP有关的），我是''已将您的主题移至软件开发论坛。


其次，您的两台计算机应连接到Intranet上，其中一台应安装数据库。因为它只有两台电脑（让我们假设，为了争论，你还想要第三台电脑进行电子表格和会计，比如每日销售数字），你需要一个局域网 - 如果你的餐厅在占地空间方面相当大，那么考虑使用受WPA保护的无线网络（WEP太弱）。


第三，就数据库而言 - 考虑预算和规模。每天会有多少订单通过这个数据库运行？如果它是数百个，请查看Microsoft SQL Server Express Edition，或考虑为标准版付款，因为那时您还可以考虑复制，然后通过网站在线预订订单（Express Edition复制功能非常有限）。

但是，如果它是一个低容量的餐厅，那么看看MySQL。 Microsoft Access是可以的，但在报告功能方面可能非常有限。我的观点有偏见，但在低容量餐厅，我会使用带有高级服务的Microsoft SQL Server Express Edition（包括报告），并构建一个ASP.NET网站，与面向Web的数据库进行通信，然后用餐馆里的数据库复制，然后使用VB.NET（你可以免费获得Visual Basic Express Edition）为厨房构建一个应用程序，并为前台处理卡付款和访客提供应用程序他们到了。


希望这会有所帮助。


祝你好运，


medicineworker

PS我可以进行咨询工作:-D

Hi pinky8,

Firstly, since it''s not a web app (and not specifically ASP-related), I''ve moved your thread to the Software Development forum.

Secondly, your two computers should be hooked up onto an intranet and one of them should have the database installed on it. As it''s only two computers (let''s assume, for the sake of argument, you also want a third computer to do spreadsheets and accounting, like daily sales figures), you''d need a LAN - if your restaurant is quite large in terms of floor space then consider using a WPA-protected wireless network (WEP is too weak).

Thirdly, in terms of databases - think about budget and size. How many orders will be run through this database every day? If it''s in the hundreds, look at Microsoft SQL Server Express Edition, or consider paying money for the Standard Edition, because then you can also consider replication and then have orders booked online through a website (Express Edition replication features are very limited).
If, however, it''s a low-volume restaurant, then look at MySQL. Microsoft Access is OK but can be very limiting in terms of reporting capabilites. My opinion is biased, but on a low-volume restaurant, I''d use Microsoft SQL Server Express Edition with Advanced Services (includes Reporting), and build an ASP.NET website, to communicate with a web-facing database, which would then be replicated with the database in the restaurant, and then use VB.NET (you can get Visual Basic Express Edition for free) to build an app for the kitchen and an app for front-of-house to process card payments and guests as they arrive.

Hope this helps.

Best regards,

medicineworker

P.S. I am available for consultative work :-D

这篇关于创建一个应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！