1 Overview 1.1 Application Scenarios
Despite the rapid development of the Internet and the growing number of Internet software, desktop applications are irreplaceable in some areas, such as software products such as MIS,ERP,CRM, and include common features such as database operations, log management, rights management, etc.
This framework refers to solving these problems and extracting and implementing common functionality. Enables more focus on business logic in the development process
1.2 Object-oriented
NET program Developers
1.3 Development environment
Solution Solutions |
Development environment |
Describe |
NaviSoft20 |
VS2010 or above |
The entire framework has only one solution. NET class library contains 2 kinds. Net4.0 and Net4.5, respectively. |
1.4 Framework Features
L Classic three-layer architecture, easy to get started
L Operation database supports ORM and ADO two ways. Flexible
n supports multiple databases, including sqlserver,oracle,sqlite,access, and can operate multiple databases concurrently in the project
N adopts entityframework framework. Lightweight ORM Framework, Microsoft original, trustworthy
L main interface supports three kinds of navigation menus, outlookbar,tree and TabPage, respectively.
L multi-lingual, including English, Chinese Simplified, Chinese Traditional
L Skin change, support up to 60 kinds of skins
L built-in various common components
N Auto-Upgrade components
Ø in LAN, just send the upgrade file to the server, the client can update automatically
N Chart Components
Øfusionchart charts. WebForm and WEBMVC can be used to provide an operational help class for the component
Ømschart charts, currently only available in the WinForm version of the simple Operation example (note: If in-depth study, please refer to Microsoft's Official sample Demo)
N Database Operations Components
Ø includes database operations on Sqlserver,oracle,sqlite and Mysql,oledb (not currently implemented). Accessible as an interface for easy switching
Ø support SQL statement Access, support stored procedure access
Ø Insert,update,delete and SELECT statements for database tables can be generated in batches
N Log Components
Ø log types include: Login log, operation log, DB table column value change log, Exception Log, database operation (record Insert,update,delete statement)
Ø log storage media including data and txt text files
N Message Components
Ø message types include email messages, SMS messages, IM instant messages
Ø e-mail messaging function based on aspose.network components
Øsms service to send text messages and MMS (need to contact the supplier)
Øim Instant Messaging, pure database mode, not socket (currently not implemented)
N Office Components
Ø data export. Can be exported to excel,word,csv,txt etc.
Ø data import, support import from Excel,txt and other files
Ø operation of CSV,EXCEL,PDF,PDM (Power Designer), Txt,word and other documents
Ø document Preview. Supports previews of frequently used files. Include: Excel,word,visio,powerpoint,flash,mp3 audio files, MP4 video files, sql,xml and other code files
N Permission Components
Ø includes three layer structure: Organization (also called department), role, user
Ø a permission component that provides only the relationships between queries. Find all users under a role. List of roles owned by a user
Ø Data deletion and modification function, implemented in other function modules of the framework, no longer available in this component
N Print Components
Ø embedded LODAP-based component printing, supports WebForm and WEBMVC two scene printing
In the øwinform scene
Embedded in a simple package based on the PrintDocument class
Print encapsulation of the DataGridView control
N Report Components
Ø based on Fastreport components, currently supports WebForm and WinForm, two application scenarios
Ø provides designers and examples of fastreport components in the WinForm scene demo
ØWEBMVC scenario, you can use the Lodap component as the print component
N Resource File components
Ø Embedded Multi-language parsing, currently supports three kinds: English, Chinese Simplified, Chinese Traditional
Ø Provide resource file designer (Sports WinForm page only)
N WebService components
Ø built-in ADO basic method, such as Execute SQL statement, get single row column data, get table data, etc.
Ø built-in file download function for automatic update of component usage
2 Function List 2.1 Base Code 2.1.1 Auxiliary encoding
Describe
L tree Control on the left, showing the secondary encoding type. You can add, modify, and delete the top toolbar. Note: Deleting the encoding type simultaneously, the encoding itself is deleted synchronously
L The top of the right is the search area, providing common search conditions
L The middle part of the right is the toolbar, which provides the addition and deletion of the auxiliary code. Also, right-click the grid control, the right-click menu appears, enabling the grid control to print
L Grid Control supports paging
2.1.2Db Data Dictionary
Describe
L Top provides database type selection and connection string entry
Select the database type and connection string and click the Load button to load the database structure into the list of DB objects on the left. Also, select the row, and the corresponding DB object content will be displayed on the right
L Provide data dictionary export function, export the right DB object contents to Excel file
2.2 Development Platform 2.2.1 function system
Describe
L top is the data retrieval area, provides the retrieval function
L Central is a tool bar for adding and removing functional systems.
The bottom is the data display area, which supports paging. And can export data to Excel
2.2.2 Function Module
Describe
The top part is the data retrieval area, which provides the retrieval of the function module.
L The middle part is the tool bar, provides the function module's additions and deletions to change
N Open Mode
Execute: Open External file
Show: Non-modal open, load to frame
Showdialog: Modal Open
Shownotinframe: Non-modal open, not dependent on frame
N Access rights
When the user opens the Frame home page, the left navigation menu is configured according to permissions. Access is the identifier of this feature module in function permissions
The bottom is the data display area, which supports paging. And can export data to Excel
2.2.3 Coding Rules
Describe
The top is a data retrieval area that provides retrieval of the encoding rules
L The middle part is the tool bar, provides the function module's additions and deletions to change
N Prefix type: Includes constants and variables. The variable takes this entity class, a property value
N Year format: includes both 4-bit (2014) and 2-bit (14) formats
N-month format: Includes month capitalization (January with 01) and month lowercase (January with 1, not padded)
N-day Geon: Including day caps (1th with 01) and day lowercase (1th numbers are 1, not filled)
The bottom is the data display area, which supports paging. And can export data to Excel
2.3 System Management 2.3.1 system options
Describe
The top is a data retrieval area that provides retrieval of system options
The middle section is a toolbar that provides additions and deletions to the system options.
n If the system initial option is not allowed to delete
The bottom is the data display area, which supports paging. And can export data to Excel
2.3.2 Attachment Management
Describe
The top is a data retrieval area that provides retrieval of attachments
L The middle part is the tool bar, provides the add and delete changes to the attachment
The bottom is the data display area, which supports paging. And can export data to Excel
n attachment function, more in the business module, as a document attachment in the form of the existence. As shown
N file supports preview feature. In the list of files, double-click to select a row, as shown in
Flash file Preview
PDF file Preview
SQL file Preview
Word file Preview
2.3.3 Data Center
Describe
L Support data import and export. Currently only support for interacting with Excel files
L top to select the database type and connection string and select Import Export File
N Using Microsoft Self-control to implement database connection string input
L Middle left side is DB object list or Excel file content
L The middle right is the DB table data for generating SQL statements
2.3.4 Report Center
Describe
L built-in designer for Fastreport report components. Note: embedded in frame, no additional opening required
2.3.5 Message Center
Describe
L provide the function of sending and receiving email. Based on Aspose.network components
L Provide SMS SMS function (interface call completed, need to ask the vendor for the account password and recharge)
2.4 Log Management 2.4.1 login log
Describe
Log login and logout time of logged-in user, and also record customer's IP address and physical MAC address
L provide retrieval, and can export the log to Excel
2.4.2 Operation Log
Describe
L provide all kinds of operation to the function module, including operation result and creation time, etc.
L provide retrieval, and can export the log to Excel
2.4.3 Status Log
Describe
L provide the value change record of the DB table column
L provide retrieval, and can export the log to Excel
2.4.4 Database log
Describe
L RECORD the SQL statement of the logged-on user in the UI page operations database, including the Insert,update,delete statement
L provide retrieval, and can export the log to Excel
2.4.5 Exception Log
Describe
L LOG the application for abnormal error, for developers to find errors
L provide retrieval, and can export the log to Excel
2.5 Authority Management 2.5.1 Organization
Describe
L top is the data retrieval area, provides the retrieval function
L Central is a tool bar for adding and removing functional systems.
The bottom is the data display area, which supports paging. And can export data to Excel
L Data Display control supports tree state structure
2.5.2 role
Describe
L top is the data retrieval area, provides the retrieval function
L Central is a tool bar for adding and removing functional systems.
The bottom is the data display area, which supports paging. And can export data to Excel
2.5.3 Users
Describe
L top is the data retrieval area, provides the retrieval function
L Central is a tool bar for adding and removing functional systems.
N provides initialization password functionality. Note: Multi-user password initialization is not supported at this stage.
The bottom is the data display area, which supports paging. And can export data to Excel
2.5.4 User Roles
Describe
L Maintain user and role relationship data
L Select the left role data and the right side shows the list of users owned by this role
2.5.5 User Organization
Describe
L Maintain user and organization relationship data
• Select the organization data on the left and the list of users owned by this organization on the right
2.5.6 function Permissions
Describe
L top is the data retrieval area, provides the retrieval function
L Central is a tool bar for adding and removing functional systems.
n new function privileges, support batch new operation
The bottom is the data display area, which supports paging. And can export data to Excel
2.5.7 Control permissions
Describe
L top is the data retrieval area, provides the retrieval function
L Central is a tool bar for adding and removing functional systems.
The bottom is the data display area, which supports paging. And can export data to Excel
2.5.8 Data Permissions
Describe
Data permissions, refers to the data for permission filtering. Precise to an attribute in an entity class
L top is the data retrieval area, provides the retrieval function
L Central is a tool bar for adding and removing functional systems.
The bottom is the data display area, which supports paging. And can export data to Excel
2.5.9 Role Function permissions
Describe
L Maintain role and function permission relationships
L Select the left role ID, the right side belongs to the feature in this role, is selected
2.5.10 Role Control permissions
Describe
L Maintain role and control permission relationships
L Select the role ID on the left and the control permission data in this role ID on the right is selected
2.5.11 Role Data permissions
Describe
L Maintain role and control permission relationships
L Select the role ID on the left and the data right in this role ID is selected
2.6 Auxiliary Tools 2.6.1 Explorer
Describe
L Generate resource files for controls on WinForm pages, including English, Chinese Simplified, Chinese Traditional
When the build succeeds, the data is stored to the XML file
2.6.2DLL Viewer
L Find DLL file contents. Note: only support for C # compiled DLL files is viewed, and there is no encryption
2.6.3 Formatting objects
Describe
l support formatting XML format strings
Describe
L format JSON format string, which generates a JSON object as shown in
2.6.4 formatting strings
Describe
L Format the string, the SQL statement will be generated, C # string, as shown in
3 Solution 3.1qh.core Project
Describe
L Entire Framework Core class library
n various common operation helper classes. such as Datetime,datatable,xml,file, etc.
N Framework-based operations. such as the DateTimeFormat format string
N DB table entity class, based on domain-driven principles, including entity classes and extended entity classes
N each component interface and implementation factory
UI control interface and common UI control action base class
3.2QH. Utility Project Set
Describe
L This project set is used for encapsulation of various technologies, such as mongodb,memcached, etc. after encapsulation, and then by the component layer
n comprovider project for loading COM components, all of the framework COM components are loaded here, and then referred to by other projects
n EF6 project, is the encapsulation of Microsoft's Entiryframework framework
n Flexpaper project for online preview function in WebForm. This project is to take all kinds of documents, all to the SWF file, for the WebForm project to use
n memcached project, which is the encapsulation of third-party cache controls
N Office projects are actions on Office documents and other common documents. such as: Csv,txt,word,excel,pdf, etc.
3.3qh.component.log Project
Describe
L Boogloger is when the application system is loaded, when various components are created, the record component is created successfully, output to txt text document
L Logservice is the implementation class for the Log component interface
3.4qh.component.message Project
Describe
L Messageservice is the message component interface implementation class
L Formsendemailbill, send mail Document page
L Formsendimbill, send instant Message Document page
L Formsendsmsbill, send SMS Document page
L Emailhelper, common method of mail operation, implemented by static method
3.5qh.component.permission Project
Describe
L Permissionservice is a permission component interface implementation class
3.6QH. Control.webform Project
Describe
L Pagebase is the base class of the WebForm page, built in a variety of common operations. such as obtaining address parameter values, common component encapsulation, etc.
L Helper folder, encapsulating a variety of common operations, static method implementation
3.7QH. Control.WebForm.MVC3 Project
Describe
L Common packages based on MVC3 projects
3.8QH. Control.winform Project
Describe
L Common packages based on WinForm projects
L control folder, store various controls
N Some controls taken from the network, there is a copyright, please contact me!
3.9QH. Control.WinForm.Assist Project
Describe
L Common page encapsulation based on WinForm project
n assisttoolform folder, storage Accessibility Common page
n Manageplatform folder, storage development Platform Common page
n permissionform folder, storage Rights Center common pages
N UserForm folder, store custom pages. such as the main frame left navigation menu page, import export generic page, data center page, etc.
n Workflowform folder, storing the workflow component common pages
3.10QH. Kernel Project Set
Describe
L Ef6models project, storing EF6 generated DB table entity class
L Ef6dal Project, store EF6 operation classes that interact with the database, and all classes of all DB tables
L Ef6service Project, for business layer, called by UI page
L Ef6webui and Ef6winui projects, store UI pages,
4 parsing and parsing of source code 1
Service Layer Code
Parsing 2
form data loading
Parsing 3
form data saving
5faq1. COM Component References
The project references several COM components, including the PDF document preview component, the Office Document preview component, and the video playback component. The framework itself has been provided by the installer in the \packages\tools\ folder (Storm AV installer not provided)
Navi.Soft20.WinForm Operating Manual