[Keywords:] enterprise website ASP.NET database ADO.NET
I. Introduction
Enterprise website is an indispensable part of an enterprise. It can introduce enterprise culture, business philosophy, special services and the distribution of enterprise outlets all over the country, broaden the customer market, increase the contact between enterprises and customers, shorten the distance between them, improve the visibility of enterprises, and open up a good social environment for the future business development of enterprises. Using online shopping to realize e-commerce and complete the value exchange of finance, goods, services and information is the latest method to carry out various business activities quickly and effectively. Building a fully functional enterprise website with fast retrieval, convenient search, high reliability, large storage capacity, good confidentiality, long service life, low cost, simple maintenance and strong real-time information can greatly improve the work efficiency of enterprises, and it is also an important condition for enterprises to move towards science and integrate information with the world.
Second, the system design of enterprise website
1. Design of front desk customer function module
(1) Home Page
Also known as corporate image page, it includes corporate name, corporate logo, menu or icon, which is used to simply and effectively navigate the content of the website, highlight the most important news or modified content, and the address, telephone number, fax number and account number of customers who contact the company. The homepage should follow the principles of quickness, conciseness, attractiveness, strong information generalization ability and easy navigation, and the navigation menu or icon on the homepage should be able to link to other pages of the enterprise website. A press release can release information about a new product or project, including a list of services and products, news bulletins, activity schedules, etc.
(2) Member customer registration and login
Member registration, providing corresponding member information, including user name, contact name, password, city, contact address, postal code, contact phone number, email address, etc. When the member logs in, enter the user name and password, and the system will verify the user name and password. If it is invalid, the corresponding prompt information will be given. If it works, enter the system. After logging in, members can order products and modify user information.
(3) product and service browsing and searching
The product service page displays enterprise products or services in a hierarchical and detailed way. The main contents of the product service page include product name, type, characteristics, specifications, price, etc. It also includes customer service items and contact numbers. Establish hyperlinks to individual product pages through product names; You can also search for product information by product name, type or price.
(4) Order and shopping cart management
Non-member customers cannot enter the interface of orders and shopping carts. When member customers are willing to buy products, they can place an order for formal purchase. The goods on the order will be displayed on the shopping cart in the form of goods, or the goods can be put into or taken out of the shopping cart, and the system will automatically fill in or remove them from the order. When submitting an order, the system saves the order information submitted by member customers and stores it in the background database.
(5) Market research
Network is a powerful market research tool because of its interactive nature. Enterprises can collect information such as customers and their opinions and suggestions on products and services through the production of market research pages, so as to establish a market information database as a quantitative basis for marketing decisions.
(6) Advertising and other contents
Adding some advertising content to the enterprise website can increase the attraction of the website and promote the enterprise. In addition to the above basic contents, enterprise websites can also design other contents according to their own characteristics and needs.
2. Design of background system management module
(1) system administrator login module
The name of the initial Administrator of the system is Administrator, and the password is greentide, the symbol of Henan Gleiter Technology Co., Ltd. After logging in, the system administrator can maintain the whole system and make it run normally.
(2) Member customer information management module
You can check the name, company address, telephone number, e-mail address and other information of member customers, regularly sort out the information of member customers and let salesmen contact in time to stabilize sales channels. (3) Order information processing module
You can check the order information of member customers, feed it back to the salesman in time, sign a sales contract, collect payment and distribute the goods; Arrange technicians for installation, debugging and operation; After the transaction is completed, modify the order flag to the processed status.
(4) Product information management module
Store the new product name, type, characteristics, specifications, price and other information in the database, and carry out product information query, modification, deletion and other maintenance work.
(5) news articles and research information processing module
Handle news articles in time, and carry out maintenance work such as adding, querying, modifying and deleting; Summarize, classify and sort out research information in time.
(6) advertising information processing module
Handle advertising information in time and maintain it by adding, querying, modifying and deleting.
Third, the system implementation and key technologies
The website of Lvchao Group Henan Gleiter Technology Co., Ltd. is built on the Windows Server 2003 operating system, with ASP.NET as the development tool and SQL Server 2005 as the background database, and adopts a system architecture based on the combination of browser/server mode and multi-layer structure design idea.
1. System security and user rights design
Because the system adopts B/S mode, the security of the system is very important. In order to improve the security of the system, in addition to the data security, authentication and authorization mechanisms of ASP.NET, IIS and SQL Server 2005, the system has multiple protections from the user level and database level.
User level: clearly divide the rights of system users. Users are divided into three levels, and system administrators are responsible for the maintenance of the system and the management of various databases, mainly in the background. Member customers (registered customers) are allowed to modify some data, especially order data and their own information data, and have the right to upload data; General customers are all people who visit this website through the web and can browse and query general information.
Database level: the backup and recovery of the database adopts the database strategy of incremental backup, and dumps important data regularly, so that the data can resume normal operation in time when the system is damaged.
2. Display advertisements through the AdRotator control.
The AdRotator control is used to randomly display an advertisement picture in an advertisement set, which is specified by an XML-based advertisement file. In the process of displaying the advertisement picture, the AdRotator control automatically plays the advertisement in the file in a loop. When the page is refreshed, the displayed advertisements will change randomly. The advertisement file contains a node for each specified advertisement, which contains the address node of the advertisement image to be displayed. Click the URL of the image navigation address, and the text will be displayed when the image does not exist. The percentage of the advertisement rotating display time to the total time and any keywords related to the advertisement.
Application of 3.3. XML control
XML control is a special control used to display XML code on web pages, but in ASP.NET Web Forms, the original XML code is not displayed, and only with the help of XML control can the XML code be displayed. Control takes an XML file and a transformation style file as input, and then sends the resulting code to the browser. XML controls can read XML from string URLs or XML document objects.
4. Use ADO.NET to access the database.
ADO.NET is an important part of the database in the. NET framework, and ADO.NET provides an efficient data access mechanism for the. NET framework. At the same time, there is no integration with XML, which makes it a sword for Web application development. ADO.NET provides consistent access to data sources such as Microsoft SQL Server.
Four. Concluding remarks
With the popularization of Internet application, it is more and more urgent and necessary for enterprises to use their own websites to display their corporate image and carry out e-commerce activities. At the same time, corporate websites also build an information bridge between consumers and operating companies, which will surely become the main operating mode of enterprises in the future.