Database Table relational model resolution 6-Multi-to-multi-data model

Document directory

• View code in MVC
• Controller code in MVC
• Model Code in MVC

The multi-data model list page and the add, delete, modify, and query page are recorded in detail.
The langben code generator can automatically generate ASP. NET pages and background code.
The technologies used by the generated project include jquery + MVC + Entity Framework.

In practical development, we use powerdesigner to design a database model. The langben code generator reads the database model designed by powerdesigner, analyzes the relationship model between the table and the table, and analyzes the keywords in the description information of the table and field, different pages are automatically generated.

The relational models between tables include:

1. Single Table Data Model
2. Self-connection data model
3. One-to-one Data Model
4. One-to-Multiple Data Models
5. One table in the one-to-multiple data model is self-join.
6. Multi-to-multi-data model
   
7. One table in the many-to-many data model is self-join.
   

Keywords include

1. Query
2. Status
3. Upload
4. Workflow

 

Architecture Diagram

Component Description

Chart 1 project component description

1. App-page display Layer

   The MVC framework is used, the jquery script library is used, and easyui is used for the control.

2. Wcfhost -- service host (post-extension)

   Provides a host for external services, using the WCF technology and HTTPS communication protocol.

3. Ibll-business interface layer

   APIs and service contracts exposed by methods at the business logic layer.

4. Bll-business logic layer

   Business logic operations, including business processing, transactions, and logs.

5. Dal-data access layer

   Database Access operations, data entities, business entities, data validation, using Entity Framework.

6. Common -- public component layer

   Common auxiliary methods used by the entire application.

7. Wfactivitys -- workflow activity layer (post-extension)

   Defines the activities required by the workflow and uses Microsoft WF technology.

8. Wfdesigner-workflow designer (later extension)

   It allows implementers to freely configure the workflow designer and use Microsoft WPF technology.

    

Functions of procurement plan details and distribution

Business Requirements: distribute materials in the procurement plan details to different sites

There is an associated table between the purchase plan details and distribution. These three tables constitute a typical "Multi-to-multi-data model"

The following uses distribution as an example to analyze the "Multi-to-multi-data model" data model. The code is already in the generated file and annotated for details. This article will not go into details.

Data Model

There is a many-to-many relationship between purchase plan details and distribution.

Query

When designing a table, write "query" in the comment of the "quantity distributed" field, and the "quantity distributed" field is of the int type. Therefore, two input boxes are displayed and the input range is

 

List

View code in appmvc on the page display Layer

Controller code in MVC

 

Model Code in MVC

Model is the entity automatically generated by Entity Framework.

Business interface layer ibll

This layer serves as the interface of the business logic layer method and is also a contract exposed by WCF.

Business logic layer BLL

The business logic of the data dictionary class is written in the BLL class library. The transaction uses the transactionscope object. The fenfabll. CS class file encapsulates the operation methods of the business logic and inherits the basebll base class.

The entire project should follow the following principles: fat Bll, thin MVC

Data access layer dal

The fenfa. CS file is used to verify the object and object metadata of the table, while the fenfarepository. CS file is used to access the database.

The business entity is in fenfa. the fenfa class in the CS file. It is a partial class that can be customized internally. The metadatatype attribute specifies the validation class fenfametadata for this object attribute, and it inherits the ibaseentity interface (this interface does not have any members at the moment );

The fenfa. CS file also contains a fenfametadata class for verifying the members in the fenfa class. Note that the verification class must reference using system. componentmodel. dataannotations; namespace.

Service Layer

(Extension later)

Delete

Select one, and then click Delete.

Create

Select Distribution

Modify

View Details