设计数据库及其开发方法 [英] Design database and how to develop method

问题描述

我的应用程序任务是在这种情况下开发一个超级市场应用程序.用户输入产品代码和用户说明
开始日期和结束日期，产品费率和数量.我的问题是基于日期的产品费率.
范例:我们将在10月15日至11月7日获得皂产品Rs.20/-.同一产品11月8日至12月Rs.23/-之间.12月15日相同产品至1月12日Rs.19/-之间更改.如何为此应用程序设计数据库以及如何为此应用程序编写类和方法.

Hi,

My application task is I am going to develop one super market application in this scenario. The user enter product code and user description
start date and end date, product rate, and quantity. My question is product rate based on date in varies rates.
Example: we will get soap this product 15th October to Nov 7th Rs.20/-. The same product Nov 8th between Dec Rs.23/- The same product change for Dec 15th Between Jan 12th Rs.19/- . How design database for this application and how to write class and method for this application.

推荐答案

Nueman是正确的.您的问题太笼统了.太笼统了.您没有提供足够的信息.在不了解您的应用程序要求的情况下，很难为您提供帮助.您为该应用程序请求一个类或方法...但是一个做什么的类或方法呢?您是否要在产品表中添加或更新产品?您是在向客户下订单吗?您要向供应商下订单吗?如果您需要真正的帮助，则需要更加具体.

如果您甚至不知道从哪里开始，都应该向Google索取一些基本教程. ^ ]

最初的结果是一个Code Project文章:初学者访问指南通过C#的SQL Server [ ^ ]

这应该可以帮助您入门.希望对您有所帮助.

Nueman is right. Your question is too broad. Too general. You do not provide enough information. Without knowing the requirements of your application it''s very hard to help you. You ask for a class or method for this application...but a class or method that does what? Are you adding or updating products in your product table? Are you placing an order from a customer? Are you placing an order to a supplier? You need to be much more specific if you want real help.

If you don''t even know where to start, you should google for some basic tutorials. Google Results[^]

The very first result is a Code Project article:Beginners guide to accessing SQL Server through C#[^]

This should get you started. Hope it helps.

您好，

经过深思熟虑，我得出了一个解决方案.这是我的个人观点，您可以通过许多其他方式来做到这一点.

您需要创建一个可能包含
的表 ProductID -您的产品标识值<​​br/> ProductVariationPercentage -您需要计算将产品价值从20增加到23所需的百分比.
AffectedDate -该百分比应增加的日期.

注意:您的基本价格将在您的产品数据库中.

尽管这确实是非常基础的东西，但是我认为您对开发来说是一个新手，并且我希望您能从上述提示中开发此功能.

您还需要在BusinessLayer中进行大量验证和其他工作(如果您遵循3Tier/NTier Architecture).像是，产品价格应具有某个阈值，即使定义了阈值也不应越过(应生成警报).

希望我回答了你的问题
谢谢
-Amit Gajjar

Hi,

After giving some thought i come to one solution. this is my personal view, you can do this with many other ways.

You need to create one table which may contain
ProductID - your product identity value
ProductVariationPercentage - you need to calculate what percentage you required to increase your product value from 20 to 23.
AffectedDate - The date from when this percentage should increase.

Note : your base price will be in your product database itself.

Although this is really very basic stuff but i think you are very new with development, And i hope you will develop this functionality from above hint.

You also need to do a lot of validation and other work in your BusinessLayer(if you are following 3Tier/NTier Architecture). Like, product price should have some threshold value, threshold value should not cross even if defined(Alert should be generated).

Hope i answered your question
Thanks
-Amit Gajjar

这篇关于设计数据库及其开发方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！