需要在C#中使用opps db desig的示例程序 [英] Need a Sample program in c# with opps db desig

问题描述

我想开发一个小型应用程序，我需要如何设计应用程序概念的帮助.

以下是表格的详细信息.我只想要这种方法，这样我就可以开始设计数据库和用户信息.

1)表:ServiceCategoryMaster

感想:

SerCatId，SerCatCode，SerCatDescription，isActive，UEmpId，CrnDate，UpdatedDateTime

2)表格:SubCategoryMaster

感想:

SerSubCatId，SerSubCatCode，SerSubCatDescription，SerCatId，isActive，UEmpd，CrnDate，UpdatedDateTime

3)表格:ItemMaster

感想:

ItemId，ItemCode，ItemDescription，ItemSerSubCatId，ItemSerCatId，ItemUomId，ItemQuantity，ItemMinRate，ItemPercentageRate，IsActive，UEmpId，CrnDate，UpdatedDateTime


谢谢与问候
Ram

Hi,

I want to develop a small app, i need help how to design the app sing oops concept.

The following are the table details. i just want the approach so that i can start off with designing db & user inf.

1) Table : ServiceCategoryMaster

Feilds :

SerCatId, SerCatCode, SerCatDescription, isActive, UEmpId, CrnDate, UpdatedDateTime

2) Table : SubCategoryMaster

Feilds :

SerSubCatId, SerSubCatCode, SerSubCatDescription, SerCatId, isActive, UEmpd, CrnDate, UpdatedDateTime

3) Table : ItemMaster

Feilds :

ItemId, ItemCode, ItemDescription, ItemSerSubCatId, ItemSerCatId, ItemUomId, ItemQuantity, ItemMinRate, ItemPercentageRate, IsActive, UEmpId, CrnDate, UpdatedDateTime


Thanks & Regards
Ram

推荐答案

除非有人知道您应用程序的功能，否则将无法判断.尽管处于较高级别，但它应具有:

1.表单/网页的UI层.
2.检查业务规则的业务层.
3.执行数据库操作的数据访问层.

Unless someone knows the functionality of your application, would not be able to tell. Although at a higher level, it should have:

1. UI layer for the forms/webpages.
2. A business layer to check for business rules.
3. A data access layer to perform database operations.

这篇关于需要在C#中使用opps db desig的示例程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！