Design And Analysis Of Management And Information System For Coal Sales Based On CRM

The 17th National Congress of the CPC submits the exact location of promoting industrialization with information technology to integrate, which makes us understand the relations of industrialization and information gradually, simultaneously grasps mutual development, closely interdependent nature of logic of industrialization and information. The 17th National Congress of the CPC suggests Using information technology to transform traditional industries, using information technology to stimulate industrialization of coal production, coal enterprises to achieve comprehensive development.However, how to build a information management systems suitable for coal enterprise,how to make information management system function effectively, which make us think deeply.Economic globalization and the rapid development of information technology has changed the pattern of competition in the coal business, changed the pressure of the price competitiveness to the value of customers around the competition, who holds the needs of customers, retains customers, who can win the competition of brutal Campaign. This situation has also changed the nature of the work of the coal sales, sales to customers must make rapid response to the problem and demand, saleman should have the ability to build customer relations,must be "customer-centric" and "market-oriented" in order to attract more new customers and retain existing customers to get greater profits.Integrated coal enterprises need to focus on market segmentation, to use CRM (customer relationship management system) to enhance sales management capabilities to deal with the ever-changing customer demands of the market. The core of CRM is its difference, coal companies need to find out the difference between the customers so as to provide different services.This article tries to unite the concept of CRM (customer relationship management) with traditional coal sales process, According to the actual situation and specific requirements of a small and medium-sized coal enterprises, combined with the management norms and standards of the coal industry, utilize the current popular system framework B / S (Browser / Sever) to build a model of the system architecture. This article is Based on the development of the traditional MIS system theory, describes the details of coal-based CRM sales management Information system analysis and design process combined with CRM (customer relationship management) theory, software engineering theory, object-oriented database as well as the principles of Web programming languages. During the entire business process of the coal enterprises such as production, sales, quality control, inventory, planning, pricing, human resources, transportation, scheduling, services, finance and so on. As a complete enterprise value chain, production and sales is the core business, while core business is good or bad depends on the market, depends on the customer. As a result, customers become an important resource, customer relationship management become an important and indispensable part in the business process. The system design target is based on the customer relationship management as a leader, is based on contract management and sales management program as the core, supplemented with the price management, production planning price management, inventory management, form the integrity of the small and medium-sized coal enterprises Sales Management Information System based on CRM. basic achieve clientsâ†'important customerâ†'sales ordersâ†'sales planningâ†'production planningâ†'salesâ†'a complete inventory of the business process.System functions include:â‘ Customer Relationship Management: regularly update Customer Information, dig large customers and potential customers often, master the level of credit of customers, assess the level of customers, enhance the customer, improve the Customer loyalty and customer yield;â‘¡coal marketing plan management: price,contract, plan management,plan management includes sales planning and production planning, planning management is divided into production planning,inventory information and Actual production and sales of the day. In the form of data of all mine companies, through the month table , according to sales order, in the light of last month's sales plans, sales department makes production and marketing plans, inventory is based on the actual production and sales statistics obtained, use day unit statistics to achieve;â‘¢systems management is divided into management, password management, purview management. the user management includes the main users basic information, users examination function, system administrators have the authority to modify and delete. Password management provide user modifying password and querying password. Rights Management provides the system administrator to set and modify user permissions, the general users can only view their own purview and can not amend.System development is based on ASP.NET technology, ASP.NET (Active Sever Page Dot Net), is NET Frame work library, which provides a WEB application model, is composed of controls and a basic Structure, with it WEB applications program is built very easily. Developers can use the ASP.NET control set, these sets have various pieces of group (such as text boxes, pull-down menu, etc. ) which is public for Hypertext Markup Language (HTML) user interface. In fact, these controls run on the network server, the user interface that will be converted to HTML format and then sent to the browser. On the server, the space will be responsible for object-oriented programming model presented to the WEB developers. Programming model can provide various object-oriented programming features. ASP.NET technology is a three-tier architecture with strictly hierarchical approach, that is, the data access layer can only be visited by operation Logic, the operation Logic become some operation formula and logic, and access the database to obtain data, and in accordance with the contrary order to return the data list in denote layer. Three-tier structure makes the application of reliability and security improved.System database uses SQL Server 2000 database application model ADO.NET interfaces, in accordance with the SQL Server 2000 to provide a better user authentication, operate purview management; with a variety of data backup strategy to ensure data integrity, reliability; to provide a good Data Import Export function of the system management module in a detailed set of operation management function, system management carry out strict management at different levels to ensure data security for data entry, modify, delete.