Netnr.P 0.0.1

Open source project collection（Netnr Project）

Languages
- English
- 简体中文

netnrf responsive framework

.NET Core responsive framework, based on Ace Admin framework menu navigation, Bootstrap layout, fontAwesome icon, embedded Iframe, data binding with EasyUI, dynamic configuration list, dynamic configuration form

Demo: https://rf.netnr.eu.org
Demo: https://rf2.netnr.com

CHANGELOG

Documentation

Netnr.ResponseFramework.SQLServer.pdm

Architecture

The front end adopts jQuery + Bootstrap + EasyUI + AceAdmin + fontAwesome
Backend adopts .NET Core + EF + SQL (SQLServer, MySQL, PostgreSQL, SQLite)
- The database script is placed in the wwwroot/scripts/ directory
- Tools used for database conversion: https://fishcodelib.com/DBMigration.htm
- All use LINQ, cross-database, avoid SQL injection
Visual Studio 2019 Run Project

Project structure

Netnr.ResponseFramework.Data data access and storage (automatically generated by Scaffold-DbContext command)
Netnr.ResponseFramework.Domain entity (automatically generated by Scaffold-DbContext command)
Netnr.ResponseFramework.Application application layer
Netnr.ResponseFramework Web site

Data Table

User (SysUser)
Roles, role permissions (SysRole)
Menu (SysMenu)
Button (SysButton)
Log (SysLog)
Dictionary (SysDictionary)
Table configuration (SysTableConfig)

Functional module

Login: System account login
Permissions: role permissions, control menus and page buttons
Table: Dynamic configuration of title, width, sorting, alignment, formatting, freezing, click sorting, etc.
Forms: dynamically generated forms, custom title, sorting, cross-column, type, required, etc., support multi-form generation
Query: Dynamically generate query panel, customize field query, express query conditions in JSON format
Log: Access log record
Dictionary: General dictionary table
Tools: Display database table information, export the database table structure to Excel with one click
Tasks: execute tasks regularly, clean up the temporary directory, reset the demo database
Export: public export Excel table, custom query body, support condition query, column formatting, support additional operations, etc.
Upload: Universal upload interface
Interface: All non-page requests are standardized into interfaces, and swagger is used to generate visual interface documents

Instructions for use

Create a table (primary key must be set), write field comments (used to generate table configuration)
Generate table configuration, you can use [Toolbox]-[Table Management]-[Generate Table Configuration]
Modify the table configuration, table, form, query, and adjust it to the form that needs to be displayed (title, width, sorting, input type, column formatting, required, default value, etc., according to business development configuration items)
Modify the table configuration, input type configuration, you need to configure the drop-down box, drop-down tree, etc., write the method in the Common controller, and the source of the url points to the address accessed by this method
Modify the table configuration, column formatting configuration, for example, the status needs to be formatted as enabled, disabled, there are commonly used public formatting methods, and you can also configure custom formatting methods col_custom_field lowercase
Add the Controllers, Views, and js generated based on [Table Management] to the project, add this page to the menu table, and configure the operation buttons
Based on the form method encapsulated by z.js (API is consistent with EasyUI, just see the EasyUI document), configure the request address, form type, paging, check, etc. of the query form