DB car service. ACCESS database car service. List of used literature

 Examine the specifics of the selected subject area.

 Develop information - logical model DB "Autoservice"

 Implement it in MS Access DBMS.

 Create a "explanatory note" to the term project in accordance with the following plan:

Database assignment

Database "" Auto service " Designed to implement the reception and registration of orders for work in the enterprise of car service.

On the high rankings of ASU - certainly does not pretend. Due to the lack of whole blocks needed for a comprehensive automated control system:

 Accounting,

 Economic bloc

 planned

 Supply

 And a number of other blocks.

Only one of the ACS blocks is being implemented - the workplace "Receiving Orders": Work with customers: Reception and fixation of orders, the organization of their implementation, reporting on the results of work.

Performance of the database function

The database performs the following functions.

1. Accounting and storage of information about car service staff. "MECHANIC.s.»

2. Enter and storing information about the types of work performed. "Orders.»

3. Entering information about customers, about customer cars and data about them. "Requests.»

4. The form "Entering orders" shape provides input actually Order, choosing a customer's name (from the list), choosing a car type of the customer and input about it.

In the same place - the composition of the work performed and the FIO of the service of the car service, which performs them. And also - information about the composition and quantity of parts used.

5. Different reports are provided in the database to analyze the state of affairs at the auto service enterprise.

User category

The base is intended primarily for service staff, carrying out the reception and design of repairs for repair, and maintenance of cars.

And the reports provided for in it - and for other enterprise divisions, as well as for its leaders.

Design database

We introduce the following concepts and legend :

Essence

Essence - Real or represented an object The information about which should be saved and available. In the ER-model diagrams, the entity is presented as a rectangle containing the name of the entity.

Essence We will denote rectangles,

Attributes of essence

Attribute - Renovated characteristics of essence . Its name must be unique for a particular type of entity, but may be the same for various types of entities. The entity attribute is any part that serves to clarify, identify, classify, numerical characteristic or expression of the essence state.

Essence

Attributes

Attribute nameswe will put into a rectangle,

denoted essence, under the name of the entity, and write

small letters.

Reconciliation

Communication - this is a graphically depicted association , installed between two entities. This association is always binary and can exist between two different entities or between the essence and it itself (recursive).

Communication- Denote the lines over which we will be lighted degree of communication (« 1 » or « ∞ » , denoting "a lot") and its characteristics.

Key fields

We define the concept primary and external keys

Key - This is the minimum set of attributes, by the values \u200b\u200bof which you can unambiguously find the required instance of the entity. The minimum indicates that the exception from the set of any attribute does not allow to identify the essence of the remaining. Each entity has at least one possible key.

One of them is taken for primary key .

When choosing primary key Preference should be given invalid keys or keys composed of a minimum number of attributes. It is impractical to also use keys with long textual values \u200b\u200b(it is preferable to use integere attributes).

It is not allowed to ensure that the primary key of the essence (any attribute participating in the primary vein) took uncertain value. Otherwise, the situation will arise: there will be no individuality, and, therefore, not existing instance of entity. For the same reasons you need to provide uniqueness primary key.

External keys

If essentiality FROM Binds essence BUT and INthen it should include external keys corresponding to the primary keys of entities A and V.

If essentiality IN Indicates essence BUTthen it should include an external key corresponding to the primary essence key BUT.

Note:

1. Because DBMS developers MS Access initially Accounting problems arising from primary and external keysIn Access, a special field type was entered - a key field. Its type - counter.

Access does not require Its mandatory inclusion in the table. But ultimately offer.

Features of this type of fields are:

When entering a new record, a new one is automatically formed in this field, unique, non-repeating numeric value.

The field can not take uncertain value.

Field - automatically indexed.

Manual change of the value of this field impossible.

Therefore, the problem is key fields and external keys ACCESS is solved simply:

In the main table (entity) Create special key field. It will be with us primary key .

In the subordinate tables enter its copy (with the same title). It will be them external key .

We associate the main and subordinate table over these fields. That's all. Communication is implemented!

2. Introduced in Access developers and a tool called « Data scheme »

Which allows not only to tie Tables, but also specify for each connection:

her a type ("One - to - one", "one - to many", etc.)

and her characteristics: ensuring integrity, as well as cascading updates and delete information from related tables and fields.

What needs to be specified and when building ER - Models Database.

In particular, that's why Access is ideal as a programming system for implementing ER models.

When implementing oursER - Models B.Access We will use all these opportunities.

Technology of creating a database "Auto service"

To create a database, the targets and tasks of the "Auto service" database were delivered:

? Provide customer satisfaction with both service and firm;
? Provide the best service in the area
? warranty repair sold new and used machines;
? Commercial preventive service (adjustment, etc.);
? Commercial rehabilitation service (repair);
? Repair of used components and units for the Restored Spare Parts Foundation.

? people,
? materials,
? computers,
? Machines,
? building.

The developed and created database "Auto service" is a set of interrelated components and displays various directions of car repair.

Figure 14. Database "Car service"

The system is divided into two subsystems and one extension:

? Repair of the technical part of the car.
? Expansion - repair of the car's salon.

The main system "Repair of the technical part of the car" consists of four tables (see Fig. 15):

« Order"- includes the necessary information about the order for repair and diagnostics of the car, that is:

? Car.
? Owner.
? Reason to appeal to a hundred.

« Repairs"- a table that describes the process of repairing technical parts of the car, namely, the parts of which are needed in the near future. This table includes items:

? Engine repair.
? Repair PPC.
? Repair of the chassis.
? Repair of the fuel system.

Figure 15. Order for repair of technical parts

Table " Diagnostics"Is associated with" Order"And distributes cars to the diagnosis of certain parts of the car, i.e. Engine, checkpoint, chassis and fuel system.

IN " Diagnostics»Store information about cars that need a diagnosis of one or another part.

? Engine diagnostics.
? Diagnosis of PPC.
? Diagnosis of the chassis.
? Diagnostics of the fuel system.

Basic system works on the based "Cascade models " and refers on the standard GOST 21624 -76

GOST 18507 -73

The operation of the system comes from the collection of information about the order, then the diagnosis occurs, which determines the need for repairing the machine. Each stage (except for the initial) cannot begin until the other is completed, excluding the case if the car does not need a repair.

The IT service subsystem was created in order to provide a guarantee of repair, applying for a warranty with a claim and purchase of spare parts for repair.

1) complaint treatment
2) warranty design,
3) Order parts, and includes 11 tables, one of which is common to IT service. (see Fig. 16).

Figure 16. IT service

IT service - divides all service for 3 parts:

? Handiculation under warranty
? warranty design
? Order spare parts.

Data 1 and 2 - contain information about customers.

Obtaining 1 table contains data on the time of appeal and the price provided.

Cause of circulation is a table that contains information about the reason for the cost of a hundred under warranty. It has a connection with the tables: the consent of the service station 1 and the total of 1, where data on the consent of the service station with the claim and the possibility of solving the problem, respectively, are noted.

The extension is a kind of increase in car repair services. Now the system has a body repair and repair of the cabin, which also engaged in a hundred.

The extension subsystem consists of two tables and affects the 2-tables from the main system. (see Fig. 17)

Figure 17. Extension

Tables "Body Repair and Repair Salon" include information on services.

Body repair:

? Replacement details.
? Putty.
? Painting.
? Varnish.
? Polishing.

Salon repair:

? Replacing components.
? Repair of components.

From these tables flow tackle " Cost»To secure prices for services.

Functional:

? Outfit orders
? work,
? services
? brigades
? Norm-clock.

Database Resources:

? people,
? equipment,
? materials,
? computers,
? Machines,
? building.

The cascade model shown in Figure 18 provides a sequential execution of all stages of the project in a strictly fixed order. The transition to the next step means full completion of the work at the previous stage.

In the database, this is presented in this way:

? Repair order
? Car diagnostics,
? car repair,
? Release car with a hundred.

Figure 18. Database model

Phase Analysis

The application for repair of the car for a hundred is being implemented here. The customer is filled with a document where the customer points out the service that he needs.

Phase design

At this stage, the car is sent to the diagnosis, which determines the cause of the vehicle breakdown. In the following customer's choice, the car goes to repair.

Phase of implementation and implementation

At this phase, repair, parts of the car, which, according to the diagnostic result, need to be repaired or replaced. Also without any checks, at this stage can repair the outer part of cars and the cabin.

Phase accompaniment

At this stage, it is written out a guarantee for repair and counting funds that were spent on the diagnosis and repair of the car, after which they pay the machine to the owner.

Properties of the system

Integrability - The system is integrable, since it has the ability to interact with various banks (payment of services through these banks), with a tax company (selling spare parts outside the region). The system is also associated with various car dealers (under the contract) and insurance companies that insure the auto service itself, as well as the firm where the purchase of spare parts occurs.

Divisibility - The system consists of a variety of subsystems that perform certain functions and have the ability to operate offline.

Integrity - Despite the fact that the system is divisible, with complete performance, it will not work if you break the functionality of one of its subsystems.

Structural - distribution over the levels and hierarchies of the elements of the system, i.e. The system will not be able to continue working if you skip one of the steps (without warranty design, the customer will not be able to refer to a hundred).

Standards

GOST 21624 -76 - This standard establishes requirements for products to ensure the specified level of operational technological (ET) and maintainability (RP), as well as the values \u200b\u200bof ET and RP indicators, provided for by GOST 20334-81, for automotive equipment - full drive and incomplete driving vehicles (freight, passenger and buses), trailers and semi-trailers (hereinafter - products).

GOST 18507 -73 - This standard applies to buses and cars (hereinafter - cars) and establishes methods of their control tests after the overhaul produced by auto repair enterprises.

The standard does not apply to passenger cars, the overhaul of which is made on orders of individual owners.

Technical tasks

1. Make a common database of all services for a hundred for a particular car.

Figure 19. Total base of all services for a hundred

2. Data on the necessary tools and materials.

Figure 20. Data on tools and materials

3. Communication with third-party systems.

Figure 21. Third-party systems

Figure 22. Autocentra

Figure 23. Insurers

Figure 24. Field of insurers

4. Comments on quality quality.

Figure 25. Comments

Figure 26. Visitor reviews

Figure 27. Reviews

During the work, a database was created in the MS Access database management system. The paper displays a step-by-step technology for creating a database. An example of the "Auto service" database is given. This base was tested for a service station. The system was tested. In the course of work, adjustments are made and the final version of the "Auto service" database is submitted.

You need to create a database of Aksss "Auto service"

Fig. 1 main push-button form of the finished database "Auto service"

Form "Owners" with the subordinate form of "Cars"

Fig. 2 Form "Cars"

Form "Employees"

Fig. 4 Form "Service"

Fig. 5 Page "Requests"

Request "Grouping on Work and Employees"

Request "By the Surname Mechanics"

Request "Search for Gosnomer"

Fig. 6 reports

Report "Grouping on Work and Employees"

Fig.7 Report "Search for Gosnomer"

Fig. 8 Report "By the Surname Mechanics"

Fig. 9 Data diagram of the finished database "Auto service" displays tables of tables: owners, cars, service, work category, employees.

Structure of the "Cars" table: state. Room, brand, owner.

Structure of the table "Owners": Owner's №, FULL NAME, Cell phone, driver's license.

Structure of the "Service" table: service number, car, work category, order availability date, employee.

Structure of the "Employees" table: employee No., cell phone, address, full name.

or here:

Download Database Report with Screen Forms for FREE

Approximate price 763 rub.

The exact price depends on the payment method.

Payment Methods Access: Webmoney Database, Payment Terminals, Russian Post, Qiwi, Beeline, MTC, MegaFon, Debit Credit Card, Wechat Pay, Alipay (China), Unionpay, Yandex.Money, Gift Certificate and others.

Download Access Database Similar Subject:

ACCESS Database Car Service 2
Formation of bills for payment in the car service
Car accounting in a motor transport enterprise.
ATP (motor transport enterprise).
ATP 2007 (Motor Transport Enterprise)
Automatic workshops
"Accounting for transportation of vehicles"
"Accounting for road accidents"
Accounting automatic executors in the traffic police.
"Accounting of violations of traffic rules"
"Replacing auto parts for a hundred"
Urban transport
"Sale tickets"
"Bus station"
"Car rental"
Car rental 2.
Driving school
Spare Parts Firm
car showroom
Accounting for automobile depreciation for mall and groups of motor vehicles
Taxi
Passenger automotive enterprise
Route schedule
Accounting for road transport by car brands

Keywords: database download; Database program; database; Course database; Download the Access database; Access; Pre-Database Access; Databases in Access; An example of the Access database; Create a database in Access; Examples of Access databases; Creating a database in Access; Access databases; requests to Access; Access reports; Access tables; Macros in Access; Access coursework; examples of the associate database; ACCESS form; Microsoft Access database; buy a database; creating database; examples of database; Download database; Coursework on DBMS; Database examples; Finished term paper database. Course database "Auto service" was created in Access 2010 and transformed into Access 2003, so opens in Access 2003, 2007, 2010.

You must create a database of Aksss "Auto service". The main button form of the finished database "Car service". The form "Owners" with the subordinate form of "Cars". Form "Cars". The form of "work category". Form "Employees". Form "Service". "Requests" page. Request "Grouping on Works and Employees". Request "By the surname Mechanics". Request "Search for Gosnomer". Report "Grouping on Works and Employees." Report "By the Surname Mechanics". Report "By the Surname Mechanics". Data diagram of the finished database "Auto service" displays tables of tables: owners, cars, service, work category, employees. Structure of the "Cars" table: state. Room, brand, owner. Structure of the table "Owners": Owner's №, FULL NAME, Cell phone, driver's license. Structure of the table "Work category": work code, work name, description, cost of work. Structure of the "Service" table: service number, car, work category, order availability date, employee. Structure of the "Employees" table: employee No., cell phone, address, full name. The "Grouping on Work and Employees" query structure in the constructor mode. The structure of the query "by the name of the mechanic" in the constructor mode. The "Search for Gos Room" query structure in the constructor mode. Macros in constructor mode.

Automation of technology for the formation of documents on the end of the university within the framework of ACS Mitita

Database "Auto Service"

Table communication: Table Custumers is associated with the MASTERS table using 1: n over the VIN_NUMBER field The Customs table is associated with the Calculation table by connection 1: 1 by field ...

Database "Students"

The program begins with connecting libraries necessary for the operation of certain functions. #Include. - To work with files, structures and functions. #Include. - For the STRCMP () function. #Include. - For screen cleaning function. ...

Database traffic police

The table is in the first normal form, then and only if no one of its lines contains more than one value in any field and none of its key fields is empty. The attitude is in the second normal form ...

Database for accounting for metal products on the SQL Server platform

The process of designing an automated system is to build a model written in graphical notation. In this case, the general principles of structural design are complied: downward development, hierarchical construction of the model ...

Organization of the introduction of the information system LLC "MENSFORMAT"

Designing the data processing unit in the K1804VS2 Structural Base

The control device (UU) is a combination circuit having seven inputs. It converts external control signals and an internal signal with FPN to a set of control signals for microcircuit blocks ...

Development of automated information systems for accounting for calculations by joining oil wells

To create a database, the DBMS MYSQL Manager is used. Since we live in Russia, it was decided to select CP_1251 encoding. What would be the opportunity to use external keys will be used Innodb engine ...

Development of the information and reference system "Department of Frames of Sharkovshchinsky ROO"

The Department of Education, Sports and Tourism of the Sharkovshchinsky District Executive Committee is located in the urban village of Sharkovshchina, ul. Komsomolskaya, 15. Department of Education ...

Development of the software "Facilities department"

Structural scheme - a diagram reflecting the composition and interaction on the control of parts of the product being developed. When object decomposition, objects are objects (Figure 6.1). Figure 6 ...

Development of a system of accounting and movement of personnel in the enterprise

Before using the program, you need to conduct a data initialization process that can be divided into several stages: 1. Filling information about the organization ...

Development of learning accounting system by students

For the creation of the database will be used by the DBMS of Microsoft SQL Server 2005 Express Edition. We carry out the following actions: The implementation of this stage will be performed using Microsoft Visual Studio 2005. When you click on the Tools button in the menu bar, the list of commands will fall out ...

Site creation on the example of the registry office of the Elovsky district

There are several basic site structures: - Linear - Web pages are located in a specific order. The transition from one web page to another is strictly defined. Such a structure is justified, for example, when learning ...

Electronic class magazine

In designed according to the task, the technical task of the database turned 3 tables: profile, performance, subject ...

Send your good work in the knowledge base is simple. Use the form below

Students, graduate students, young scientists who use the knowledge base in their studies and work will be very grateful to you.

Posted on http://www.allbest.ru/

First higher technical institution of Russia

Ministry of Education and Science of the Russian Federation

Federal State Budgetary Educational Institution of Higher Professional Education

"National Mineral Raw Material University" Mountain "

Course work

"Database - Auto Service"

By discipline: Application programming

Performed: Stepanova K.A.

Checked: Matyukhin S.A.

St. Petersburg 2013 year

Introduction

1. Description of the subject area

2. Description of the structure of the database

3. Tables

4. Technical task

5. Description of the program

6. Components

7. User Scheme

8. Interface

Conclusion

Bibliography

application

Introduction

In our age, a century of digital technology, computer play a crucial role. Now in every organization - whether state institutions or private firms are all computerized, and this is due to a very high computing power. The calculation of even the most complex processes and tasks is carried out in the shortest possible time, and the time factor often plays a crucial role in most tasks. The computational power and the memory of the computer in recent years have become incredibly large, and the prices of them have declined significantly, this contributed to the mass computerization of absolutely all industries of human activity. It is now difficult to imagine life without a smart car that simplifies and speeds up a huge amount of tasks. The usefulness of the computer is reduced by no in the absence of specialized software, without which the "Iron Assistant" becomes useless. This work will be discussed about creating such an important, and in most organizations and the main program whose name is the database. In this particular case, the car service database.

1. Description of the subject area

The purpose of the task is to obtain a software product that allows you to store information about the services of the service, the defects of their auto, ensuring the efficiency and reliability of data processing.

The car service database is designed for car service operators and provides access to car brand information, a visit, fault date, a VIN room, also customer information: phone number, etc.

The effectiveness of the program is to reduce the processing time, search for the necessary information.

The need to automate this task is related to the fact that the sample of the necessary data for reports and accounting of engineers is usually manually made or Excel, spending a considerable amount of time. This program also provides search capabilities, filtering and data sorting.

No special knowledge for working with the program in the field of programming is required.

2. Description of the structure of the BD

Table communication:

CUSTUMERS table is associated with Masters table using 1: N connection via the VIN_NUMBER field

CUSTUMERS table is associated with Calculation table by connection 1: 1 via the VIN_NUMBER field

3. Tables

Table 1: Customers (leading table)

Table 2: Masters (led)

Table 3: Masters (led)

software auto repair base editing

4. Technical task

Base for development:

The task of the teacher for practical training and the execution of the course work.

Development assignment:

The program is designed to automate the operation of car service operators.

Requirements for the program:

· Must automate the operation of the auto service operator

· Information should be constantly stored on a computer hard disk

· You must view the database with the possibility of removing this information from it.

Requirements for reliability:

· The program must handle user erroneous actions and report it.

· The program must ensure control of input information.

5. Program description

private Void Form1_Load (Object Sender, Eventargs E) () // Loading the main components

private Void B_Add_Click (Object Sender, Eventargs E) () // Adding a new entry

private Void B_replace_Click (Object Sender, Eventargs E) () // Editing Record

private Void B_Cancel1_Click (Object Sender, Eventargs E) () // Cancel

private Void B_Save_Click (Object Sender, Eventargs E) () // Saving changes

private Void B_Record1_Click (Object Sender, Eventargs E) () // Write Data

private Void B_Delete_Click (Object Sender, Eventargs E) () // Delete data

private Void B_exit_Click (Object Sender, Eventargs E) () // Exit the program

6. Components

7. Scheme for User

Table 1 "Clients" and Table 2 "Masters" are associated with the "one-to-many" attitude via the VIN_NUMBER field.

Table 1 "Customers" and Table 3 "Cost" are associated with the "one-to-one" attitude via the VIN_NUMBER field.

8. Interface

Adding a new entry

Editing an old entry

Removing recording

Sort by date

Signed tables

The main table of the "Auto service" program includes:

1. List of client cars

2. Date of car owner

3. Fault

4. Phone client

5. Vin room

6. Customer list management is carried out with buttons (add / replace / delete)

7. Display and write cabin clients

8. Sort

10. Choice of Masters

11. Name of tables

12. Exit the program

Conclusion

The result of work was the creation of software serving the workplace of the auto service operator.

In the course of the course work, skills in the field of building and programming databases in the C # programming language were purchased.

Bibliography

1. Matyukhin S.A. "Programming on C # object-oriented approach" - Teaching Methodical Complex 2013

2. A. Halesberg, M. Torgsensen, S. Viltamut, P. Gold C # Programming Language. Classic COMPUTERS SCIENCE. 4th edition \u003d C # Programming Language (Covering C # 4.0), 4th Ed. - St. Petersburg: "Peter", 2012. - 784 p. - ISBN 978-5-459-00283-6

3. E. Stillman, J. Green Learn C #. 2nd Edition \u003d Head First C #, 2ED. - St. Petersburg: "Peter", 2012. - 704 p. - ISBN 978-5-4461-0105-4

4. Andrew Troelysen Programming Language C # 5.0 and Platform.net 4.5, 6th edition \u003d Pro C # 5.0 and the .NET 4.5 Framework, 6th Edition. - M.: Williams, 2013. - 1312 p. - ISBN 978-5-8459-1814-7

5. Joseph Albahari, Ben Albahari C # 5.0. Directory. Full language description \u003d C # 5.0 in a Nutshell: The Definitive Reference. - M.: "Williams", 2013. - 1008 p. - ISBN 978-5-8459-1819-2

6. Herbert Shildt. C # 4.0: Full Guide \u003d C # 4.0 The Complete Reference. - M.: "Williams", 2010. - P. 1056. - ISBN 978-5-8459-1684-6

application. The codeprograms

using system.collections.Genic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.linq;

using System.Text;

using system.threading.tasks;

using System.Windows.Forms;

public Partial Class Form1: Form

Initializecomponent ();

groupbox1.visible \u003d false;

groupbox2.visible \u003d false;

private Void CustomersBindingNavigatorsaveItem_Click_1 (Object Sender, Eventargs E)

this.Validate ();

this.customersbindingsource.edditit ();

this.TableAdapterManager.Updateall (this.db_autodataset);

private Void Form1_Load (Object Sender, Eventargs E)

// TODO: This Line of Code Loads Data Into The "db_autodataset.masters" table. You can Move, or Remove it, as needed.

this.masterstableadapter.fill (this.db_autodataset.masters);

// TODO: This Line of Code Loads Data Into The "db_autodataset.calculation" table. You can Move, or Remove it, as needed.

this.calculationTableAdapter.fill (this.db_autodataset.calculation);

// TODO: This Line of Code Loads Data Into The "db_autodataset.customers" table. You can Move, or Remove it, as needed.

this.customerstableadapter.fill (this.db_autodataset.customers);

private Void B_Exit_Click (Object Sender, Eventargs E)

private Void Button5_Click_1 (Object Sender, Eventargs E)

private Void B_ADD_CLICK (Object Sender, Eventargs E)

groupbox1.visible \u003d True;

b_replace.visible \u003d false;

b_delete.visible \u003d false;

b_exit.visible \u003d false;

b_add.visible \u003d false;

b_exit2.visible \u003d false;

b_save.visible \u003d false;

textBox1.Text \u003d "";

textBox2.Text \u003d "";

textBox3.Text \u003d "";

textBox4.Text \u003d "";

textBox5.Text \u003d "";

private Void B_replace_Click (Object Sender, Eventargs E)

textbox10.text \u003d customers datagridview.currentrow.cells.value.tostring ();

textbox9.text \u003d customers datagridview.currentrow.cells.value.tostring ();

textbox8.text \u003d customers datagridview.currentrow.cells.value.tostring ();

textbox7.text \u003d customers datagridview.currentrow.cells.value.tostring ();

textbox6.text \u003d customers datagridview.currentrow.cells.value.tostring ();

textBox6.Readonly \u003d True;

groupbox2.visible \u003d true;

b_add.visible \u003d false;

b_delete.visible \u003d false;

b_exit.visible \u003d false;

b_exit2.visible \u003d false;

b_replace.visible \u003d false;

b_save.visible \u003d false;

private Void B_Cancel1_Click (Object Sender, Eventargs E)

b_ADD.VISIBLE \u003d TRUE;

b_delete.visible \u003d True;

b_exit.visible \u003d True;

b_exit2.visible \u003d true;

b_replace.visible \u003d True;

b_save.visible \u003d true;

groupbox1.visible \u003d false;

private Void B_Cancel2_Click (Object Sender, Eventargs E)

b_ADD.VISIBLE \u003d TRUE;

b_delete.visible \u003d True;

b_exit.visible \u003d True;

b_exit2.visible \u003d true;

b_replace.visible \u003d True;

b_save.visible \u003d true;

groupbox2.visible \u003d false;

private Void B_Save_Click (Object Sender, Eventargs E)

customersBindingNavigatorsaveItem_Click_1 (Sender, E);

private Void B_Record1_Click (Object Sender, Eventargs E)

DataTable Table \u003d DB_AutodataSet.Tables;

DataRow Row \u003d Table.NewRow ();

rOW \u003d TextBox1.Text;

row \u003d convert.todatetime (textbox2.text);

row \u003d TextBox3.Text;

rOW \u003d TextBox4.Text;

rOW \u003d TextBox5.Text;

table.rows.add (ROW);

groupbox1.hide ();

b_replace.visible \u003d True;

b_delete.visible \u003d True;

b_exit.visible \u003d True;

b_ADD.VISIBLE \u003d TRUE;

b_exit2.visible \u003d true;

b_save.visible \u003d true;

private Void B_Record2_Click (Object Sender, Eventargs E)

DataTable Table \u003d DB_AutodataSet.Tables; // 12 Tied Duchs. Table. Table with the first database file

vinrab \u003d convert.TOINT64 (customersdatagridview.currentrow.cells.value.tostring ()); // 13 Received VIN current record

DataRow Row \u003d table.rows.find (Vinrab); // 14 compatible dynamic. Row Row with VIN C Recording SHIFRRAB and transferred dataset data to "edit" status in which it allows you to change field values

row \u003d TextBox10.Text; // 15 Scribed to the second Row field of Row this type of window

row \u003d convert.todatetime (textbox9.text); // 15 recorded the Row line in the third field

rOW \u003d TextBox8.Text; // 15 recorded in the fourth line Row Row \u003d TextBox7.Text;

rOW \u003d TextBox6.Text;

table.acceptchanges (); // 15 ACCEPTCHANGES command allows you to make changed field values

groupbox2.hide (); // 16

b_replace.visible \u003d True;

b_delete.visible \u003d True;

b_exit.visible \u003d True;

b_ADD.VISIBLE \u003d TRUE;

b_exit2.visible \u003d true;

b_save.visible \u003d true;

private Void B_Delete_Click (Object Sender, Eventargs E)

// Delete a string under the cursor

// First build a warning so as not to make erroneous removal

string S1, S2, S3, S4, S5, Message;

Dialogresult Result; // 18

int ind \u003d customersdatagridview.currentRow.Index;

s1 \u003d customersdatagridview.currentrow.cells.value.tostring ();

s2 \u003d customersdatagridview.currentRow.cells.Value.Tostring ();

s3 \u003d customersdatagridview.currentrow.cells.value.tostring ();

s4 \u003d customersdatagridview.currentRow.cells.Value.Tostring ();

s5 \u003d customersdatagridview.currentRow.cells.Value.Tostring ();

message \u003d "Mark Auto \u003d" + S1 + "\\ NDA visit \u003d" + S2 + "\\ n Malfunction \u003d" + S3 + "\\ N Tel. Customer \u003d" + S4 + "\\ N Vin number" + S5;

// RESULT variable can make values \u200b\u200beither dialogresult.yes or dialogresult.no

result \u003d MessageBox.Show (Message, "Delete the next record?",

MessageBoxButtons.yesno, MessageBoxicon.Question);

if (result \u003d\u003d dialogresult.yes) // Row is removed

(// 20 In the buffer table, the current table from CustomersDataGridView type DataGrid is written

CURRENCYMANAGER CURMNG \u003d (CURRENCYMANAGER) CustomersDataGridView.BindingContext;

if (curmng.count\u003e 0) // if the table is not empty

Curmng.Removeat (curmng.position); // Delete marked position

// here result \u003d\u003d dialogresult.no and removing rejected

// come out of the procedure

Posted on Allbest.ru.