Разработка АРМ менеджера по продажам автомобилей в автосалоне

Автор работы: Пользователь скрыл имя, 28 Февраля 2014 в 14:11, курсовая работа

Краткое описание

Целью данной курсовой работы является разработка приложения для учета поступлений и продаж автомобилей в автосалоне.
С помощью созданного приложения работники (менеджеры) автосалона смогут вести учет поступления и реализации автомобилей.

Содержание

ВВЕДЕНИЕ 3
1) ОПИСАНИЕ ПРЕДМЕТНОЙ ОБЛАСТИ 4
2) ИНФОЛОГИЧЕСКАЯ МОДЕЛЬ ДАННЫХ 6
3) ЛОГИЧЕСКАЯ МОДЕЛЬ БАЗЫ ДАННЫХ 7
4) ФИЗИЧЕСКАЯ МОДЕЛЬ ДАННЫХ 9
5) РАЗРАБОТКА ОБЪЕКТОВ БАЗЫ ДАННЫХ (ПРЕДСТАВЛЕНИЙ, ПОЛЬЗОВАТЕЛЬСКИХ ФУНКЦИЙ, ХРАНИМЫХ ПРОЦЕДУР, ТРАНЗАКЦИЙ, ТРИГГЕРОВ) И ОТДЕЛЬНЫХ ЗАПРОСОВ К БАЗЕ ДАННЫХ 17
6) ОПИСАНИЕ ПРОЕКТА 20
7) ДЕМОНСТРАЦИЯ РАБОТАЮЩЕГО ПРОЕКТА 27
ЗАКЛЮЧЕНИЕ 30
СПИСОК ИСПОЛЬЗОВАННОЙ ЛИТЕРАТУРЫ 31

Прикрепленные файлы: 1 файл

8100_06_Информатика_01.doc

— 1.92 Мб (Скачать документ)

            this.toolStripButton17,

            this.toolStripButton22});

            this.bindingNavigator4.Location = new System.Drawing.Point(3, 3);

            this.bindingNavigator4.MoveFirstItem = this.toolStripButton18;

            this.bindingNavigator4.MoveLastItem = this.toolStripButton21;

            this.bindingNavigator4.MoveNextItem = this.toolStripButton20;

            this.bindingNavigator4.MovePreviousItem = this.toolStripButton19;

            this.bindingNavigator4.Name = "bindingNavigator4";

            this.bindingNavigator4.PositionItem = this.toolStripTextBox3;

            this.bindingNavigator4.Size = new System.Drawing.Size(729, 25);

            this.bindingNavigator4.TabIndex = 1;

            this.bindingNavigator4.Text = "bindingNavigator4";

            //

            // toolStripButton16

            //

            this.toolStripButton16.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton16.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton16.Image")));

            this.toolStripButton16.Name = "toolStripButton16";

            this.toolStripButton16.RightToLeftAutoMirrorImage = true;

            this.toolStripButton16.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton16.Text = "Add new";

            //

            // toolStripLabel3

            //

            this.toolStripLabel3.Name = "toolStripLabel3";

            this.toolStripLabel3.Size = new System.Drawing.Size(33, 22);

            this.toolStripLabel3.Text = "of {0}";

            this.toolStripLabel3.ToolTipText = "Total number of items";

            //

            // toolStripButton17

            //

           this.toolStripButton17.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton17.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton17.Image")));

            this.toolStripButton17.Name = "toolStripButton17";

            this.toolStripButton17.RightToLeftAutoMirrorImage = true;

            this.toolStripButton17.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton17.Text = "Delete";

            //

            // toolStripButton18

            //

            this.toolStripButton18.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton18.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton18.Image")));

            this.toolStripButton18.Name = "toolStripButton18";

            this.toolStripButton18.RightToLeftAutoMirrorImage = true;

            this.toolStripButton18.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton18.Text = "Move first";

            //

            // toolStripButton19

            //

            this.toolStripButton19.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton19.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton19.Image")));

            this.toolStripButton19.Name = "toolStripButton19";

            this.toolStripButton19.RightToLeftAutoMirrorImage = true;

            this.toolStripButton19.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton19.Text = "Move previous";

            //

            // toolStripSeparator7

            //

            this.toolStripSeparator7.Name = "toolStripSeparator7";

            this.toolStripSeparator7.Size = new System.Drawing.Size(6, 25);

            //

            // toolStripTextBox3

            //

            this.toolStripTextBox3.AccessibleName = "Position";

            this.toolStripTextBox3.AutoSize = false;

            this.toolStripTextBox3.Name = "toolStripTextBox3";

            this.toolStripTextBox3.Size = new System.Drawing.Size(50, 20);

            this.toolStripTextBox3.Text = "0";

            this.toolStripTextBox3.ToolTipText = "Current position";

            //

            // toolStripSeparator8

            //

            this.toolStripSeparator8.Name = "toolStripSeparator8";

            this.toolStripSeparator8.Size = new System.Drawing.Size(6, 25);

            //

            // toolStripButton20

            //

            this.toolStripButton20.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton20.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton20.Image")));

            this.toolStripButton20.Name = "toolStripButton20";

            this.toolStripButton20.RightToLeftAutoMirrorImage = true;

            this.toolStripButton20.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton20.Text = "Move next";

            //

            // toolStripButton21

            //

            this.toolStripButton21.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton21.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton21.Image")));

            this.toolStripButton21.Name = "toolStripButton21";

            this.toolStripButton21.RightToLeftAutoMirrorImage = true;

            this.toolStripButton21.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton21.Text = "Move last";

            //

            // toolStripSeparator9

            //

            this.toolStripSeparator9.Name = "toolStripSeparator9";

            this.toolStripSeparator9.Size = new System.Drawing.Size(6, 25);

            //

            // toolStripButton22

            //

            this.toolStripButton22.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton22.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton22.Image")));

            this.toolStripButton22.ImageTransparentColor = System.Drawing.Color.Magenta;

            this.toolStripButton22.Name = "toolStripButton22";

            this.toolStripButton22.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton22.Text = "toolStripButton1";

            this.toolStripButton22.Click += new System.EventHandler(this.toolStripButton22_Click);

            //

            // bindingNavigator5

            //

            this.bindingNavigator5.AddNewItem = this.toolStripButton23;

            this.bindingNavigator5.BindingSource = this.менеджерыBindingSource;

            this.bindingNavigator5.CountItem = this.toolStripLabel4;

            this.bindingNavigator5.DeleteItem = this.toolStripButton24;

            this.bindingNavigator5.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {

            this.toolStripButton25,

            this.toolStripButton26,

            this.toolStripSeparator10,

            this.toolStripTextBox4,

            this.toolStripLabel4,

            this.toolStripSeparator11,

            this.toolStripButton27,

            this.toolStripButton28,

            this.toolStripSeparator12,

            this.toolStripButton23,

            this.toolStripButton24,

            this.toolStripButton29});

            this.bindingNavigator5.Location = new System.Drawing.Point(3, 3);

            this.bindingNavigator5.MoveFirstItem = this.toolStripButton25;

            this.bindingNavigator5.MoveLastItem = this.toolStripButton28;

            this.bindingNavigator5.MoveNextItem = this.toolStripButton27;

            this.bindingNavigator5.MovePreviousItem = this.toolStripButton26;

            this.bindingNavigator5.Name = "bindingNavigator5";

            this.bindingNavigator5.PositionItem = this.toolStripTextBox4;

            this.bindingNavigator5.Size = new System.Drawing.Size(729, 25);

            this.bindingNavigator5.TabIndex = 1;

            this.bindingNavigator5.Text = "bindingNavigator5";

            //

            // toolStripButton23

            //

            this.toolStripButton23.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton23.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton23.Image")));

            this.toolStripButton23.Name = "toolStripButton23";

            this.toolStripButton23.RightToLeftAutoMirrorImage = true;

            this.toolStripButton23.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton23.Text = "Add new";

            //

            // toolStripLabel4

            //

            this.toolStripLabel4.Name = "toolStripLabel4";

            this.toolStripLabel4.Size = new System.Drawing.Size(33, 22);

            this.toolStripLabel4.Text = "of {0}";

            this.toolStripLabel4.ToolTipText = "Total number of items";

            //

            // toolStripButton24

            //

            this.toolStripButton24.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton24.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton24.Image")));

            this.toolStripButton24.Name = "toolStripButton24";

            this.toolStripButton24.RightToLeftAutoMirrorImage = true;

            this.toolStripButton24.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton24.Text = "Delete";

            //

            // toolStripButton25

            //

            this.toolStripButton25.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton25.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton25.Image")));

            this.toolStripButton25.Name = "toolStripButton25";

            this.toolStripButton25.RightToLeftAutoMirrorImage = true;

            this.toolStripButton25.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton25.Text = "Move first";

            //

            // toolStripButton26

            //

            this.toolStripButton26.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton26.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton26.Image")));

            this.toolStripButton26.Name = "toolStripButton26";

            this.toolStripButton26.RightToLeftAutoMirrorImage = true;

            this.toolStripButton26.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton26.Text = "Move previous";

            //

            // toolStripSeparator10

            //

            this.toolStripSeparator10.Name = "toolStripSeparator10";

            this.toolStripSeparator10.Size = new System.Drawing.Size(6, 25);

            //

            // toolStripTextBox4

            //

            this.toolStripTextBox4.AccessibleName = "Position";

            this.toolStripTextBox4.AutoSize = false;

            this.toolStripTextBox4.Name = "toolStripTextBox4";

            this.toolStripTextBox4.Size = new System.Drawing.Size(50, 20);

            this.toolStripTextBox4.Text = "0";

            this.toolStripTextBox4.ToolTipText = "Current position";

            //

            // toolStripSeparator11

            //

            this.toolStripSeparator11.Name = "toolStripSeparator11";

            this.toolStripSeparator11.Size = new System.Drawing.Size(6, 25);

            //

            // toolStripButton27

            //

            this.toolStripButton27.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton27.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton27.Image")));

            this.toolStripButton27.Name = "toolStripButton27";

            this.toolStripButton27.RightToLeftAutoMirrorImage = true;

            this.toolStripButton27.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton27.Text = "Move next";

            //

            // toolStripButton28

            //

            this.toolStripButton28.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton28.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton28.Image")));

            this.toolStripButton28.Name = "toolStripButton28";

            this.toolStripButton28.RightToLeftAutoMirrorImage = true;

            this.toolStripButton28.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton28.Text = "Move last";

            //

            // toolStripSeparator12

            //

            this.toolStripSeparator12.Name = "toolStripSeparator12";

            this.toolStripSeparator12.Size = new System.Drawing.Size(6, 25);

            //

            // toolStripButton29

            //

            this.toolStripButton29.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;

            this.toolStripButton29.Image = ((System.Drawing.Image)(resources.GetObject("toolStripButton29.Image")));

            this.toolStripButton29.ImageTransparentColor = System.Drawing.Color.Magenta;

            this.toolStripButton29.Name = "toolStripButton29";

            this.toolStripButton29.Size = new System.Drawing.Size(23, 22);

            this.toolStripButton29.Text = "toolStripButton1";

            this.toolStripButton29.Click += new System.EventHandler(this.toolStripButton29_Click);

            //

            // dataGridView1

            //

            this.dataGridView1.AutoGenerateColumns = false;

            this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;

            this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {

            this.idмаркиDataGridViewTextBoxColumn,

            this.названиеDataGridViewTextBoxColumn});

            this.dataGridView1.DataSource = this.маркиBindingSource;

            this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill;

            this.dataGridView1.Location = new System.Drawing.Point(3, 28);

            this.dataGridView1.Name = "dataGridView1";

            this.dataGridView1.Size = new System.Drawing.Size(603, 287);

            this.dataGridView1.TabIndex = 1;

            //

            // автосалонDataSet

            //

            this.автосалонDataSet.DataSetName = "АвтосалонDataSet";

            this.автосалонDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;

            //

            // маркиBindingSource

            //

            this.маркиBindingSource.DataMember = "Марки";

            this.маркиBindingSource.DataSource = this.автосалонDataSet;

            //

            // маркиTableAdapter

            //

            this.маркиTableAdapter.ClearBeforeFill = true;

            //

            // idмаркиDataGridViewTextBoxColumn

            //

            this.idмаркиDataGridViewTextBoxColumn.DataPropertyName = "id_марки";

            this.idмаркиDataGridViewTextBoxColumn.HeaderText = "id_марки";

            this.idмаркиDataGridViewTextBoxColumn.Name = "idмаркиDataGridViewTextBoxColumn";

            this.idмаркиDataGridViewTextBoxColumn.ReadOnly = true;

            this.idмаркиDataGridViewTextBoxColumn.Visible = false;

            //

            // названиеDataGridViewTextBoxColumn

            //

            this.названиеDataGridViewTextBoxColumn.DataPropertyName = "название";

            this.названиеDataGridViewTextBoxColumn.HeaderText = "название";

            this.названиеDataGridViewTextBoxColumn.Name = "названиеDataGridViewTextBoxColumn";

            this.названиеDataGridViewTextBoxColumn.Width = 250;

            //

            // panel1

            //

            this.panel1.Controls.Add(this.pictureBox1);

            this.panel1.Controls.Add(this.panel2);

            this.panel1.Dock = System.Windows.Forms.DockStyle.Right;

            this.panel1.Location = new System.Drawing.Point(463, 28);

            this.panel1.Name = "panel1";

            this.panel1.Size = new System.Drawing.Size(269, 287);

            this.panel1.TabIndex = 2;

            //

            // splitter1

            //

            this.splitter1.Dock = System.Windows.Forms.DockStyle.Right;

            this.splitter1.Location = new System.Drawing.Point(460, 28);

           this.splitter1.Name = "splitter1";

            this.splitter1.Size = new System.Drawing.Size(3, 287);

            this.splitter1.TabIndex = 3;

            this.splitter1.TabStop = false;

            //

            // dataGridView2

            //

            this.dataGridView2.AutoGenerateColumns = false;

            this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;

            this.dataGridView2.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {

            this.МаркаАвто,

            this.idмоделиDataGridViewTextBoxColumn,

Информация о работе Разработка АРМ менеджера по продажам автомобилей в автосалоне