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

Автор работы: Пользователь скрыл имя, 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.panel2 = new System.Windows.Forms.Panel();

            this.cbLoadImage = new System.Windows.Forms.Button();

            this.pictureBox1 = new System.Windows.Forms.PictureBox();

            this.openFileFoto = new System.Windows.Forms.OpenFileDialog();

            this.dataGridView3 = new System.Windows.Forms.DataGridView();

            this.клиентыBindingSource = new System.Windows.Forms.BindingSource(this.components);

            this.клиентыTableAdapter = new cars.АвтосалонDataSetTableAdapters.КлиентыTableAdapter();

            this.dataGridView4 = new System.Windows.Forms.DataGridView();

            this.поставщикиBindingSource = new System.Windows.Forms.BindingSource(this.components);

            this.поставщикиTableAdapter = new cars.АвтосалонDataSetTableAdapters.ПоставщикиTableAdapter();

            this.dataGridView5 = new System.Windows.Forms.DataGridView();

            this.менеджерыBindingSource = new System.Windows.Forms.BindingSource(this.components);

            this.менеджерыTableAdapter = new cars.АвтосалонDataSetTableAdapters.МенеджерыTableAdapter();

            this.маркиBindingSource1 = new System.Windows.Forms.BindingSource(this.components);

            this.МаркаАвто = new System.Windows.Forms.DataGridViewComboBoxColumn();

            this.idмоделиDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.маркаDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.названиеDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.типкузоваDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.модификацияDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.мощностьDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.объемдвигателяDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.годвыпускаDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.цветDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.фамилияDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.idклиентаDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.имяDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.отчествоDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.полDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.телефонDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.emailDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.странаDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.городDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.названиефирмыDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.idпоставщикаDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.телефонDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.emailDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.странаDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.фамилияDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.idменеджераDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.имяDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.отчествоDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.телефонDataGridViewTextBoxColumn2 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.tabControl1.SuspendLayout();

            this.tabPage1.SuspendLayout();

            this.tabPage2.SuspendLayout();

            this.tabPage3.SuspendLayout();

            this.tabPage4.SuspendLayout();

            this.tabPage5.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.bindingNavigator1)).BeginInit();

            this.bindingNavigator1.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.bindingNavigator2)).BeginInit();

            this.bindingNavigator2.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.bindingNavigator3)).BeginInit();

            this.bindingNavigator3.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.bindingNavigator4)).BeginInit();

            this.bindingNavigator4.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.bindingNavigator5)).BeginInit();

            this.bindingNavigator5.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.автосалонDataSet)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.маркиBindingSource)).BeginInit();

            this.panel1.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.моделиBindingSource)).BeginInit();

            this.panel2.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.dataGridView3)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.клиентыBindingSource)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.dataGridView4)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.поставщикиBindingSource)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.dataGridView5)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.менеджерыBindingSource)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.маркиBindingSource1)).BeginInit();

            this.SuspendLayout();

            //

            // tabControl1

            //

            this.tabControl1.Controls.Add(this.tabPage1);

            this.tabControl1.Controls.Add(this.tabPage2);

            this.tabControl1.Controls.Add(this.tabPage3);

            this.tabControl1.Controls.Add(this.tabPage4);

            this.tabControl1.Controls.Add(this.tabPage5);

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

            this.tabControl1.Location = new System.Drawing.Point(0, 0);

            this.tabControl1.Name = "tabControl1";

            this.tabControl1.SelectedIndex = 0;

            this.tabControl1.Size = new System.Drawing.Size(743, 344);

            this.tabControl1.TabIndex = 0;

            //

            // tabPage1

            //

            this.tabPage1.Controls.Add(this.dataGridView1);

            this.tabPage1.Controls.Add(this.bindingNavigator1);

            this.tabPage1.Location = new System.Drawing.Point(4, 22);

            this.tabPage1.Name = "tabPage1";

            this.tabPage1.Padding = new System.Windows.Forms.Padding(3);

            this.tabPage1.Size = new System.Drawing.Size(609, 318);

            this.tabPage1.TabIndex = 0;

            this.tabPage1.Text = "Марки";

            this.tabPage1.UseVisualStyleBackColor = true;

            //

            // tabPage2

            //

            this.tabPage2.Controls.Add(this.dataGridView2);

            this.tabPage2.Controls.Add(this.splitter1);

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

            this.tabPage2.Controls.Add(this.bindingNavigator2);

            this.tabPage2.Location = new System.Drawing.Point(4, 22);

            this.tabPage2.Name = "tabPage2";

            this.tabPage2.Padding = new System.Windows.Forms.Padding(3);

            this.tabPage2.Size = new System.Drawing.Size(735, 318);

            this.tabPage2.TabIndex = 1;

            this.tabPage2.Text = "Модели";

            this.tabPage2.UseVisualStyleBackColor = true;

            //

            // tabPage3

            //

            this.tabPage3.Controls.Add(this.dataGridView3);

            this.tabPage3.Controls.Add(this.bindingNavigator3);

            this.tabPage3.Location = new System.Drawing.Point(4, 22);

            this.tabPage3.Name = "tabPage3";

            this.tabPage3.Padding = new System.Windows.Forms.Padding(3);

            this.tabPage3.Size = new System.Drawing.Size(735, 318);

            this.tabPage3.TabIndex = 2;

            this.tabPage3.Text = "Клиенты";

            this.tabPage3.UseVisualStyleBackColor = true;

            //

            // tabPage4

            //

            this.tabPage4.Controls.Add(this.dataGridView4);

            this.tabPage4.Controls.Add(this.bindingNavigator4);

            this.tabPage4.Location = new System.Drawing.Point(4, 22);

            this.tabPage4.Name = "tabPage4";

            this.tabPage4.Padding = new System.Windows.Forms.Padding(3);

            this.tabPage4.Size = new System.Drawing.Size(735, 318);

            this.tabPage4.TabIndex = 3;

            this.tabPage4.Text = "Поставщики";

            this.tabPage4.UseVisualStyleBackColor = true;

            //

            // tabPage5

            //

            this.tabPage5.Controls.Add(this.dataGridView5);

            this.tabPage5.Controls.Add(this.bindingNavigator5);

            this.tabPage5.Location = new System.Drawing.Point(4, 22);

            this.tabPage5.Name = "tabPage5";

            this.tabPage5.Padding = new System.Windows.Forms.Padding(3);

            this.tabPage5.Size = new System.Drawing.Size(735, 318);

            this.tabPage5.TabIndex = 4;

            this.tabPage5.Text = "Менеджеры";

            this.tabPage5.UseVisualStyleBackColor = true;

            //

            // bindingNavigator1

            //

            this.bindingNavigator1.AddNewItem = this.bindingNavigatorAddNewItem;

            this.bindingNavigator1.BindingSource = this.маркиBindingSource;

            this.bindingNavigator1.CountItem = this.bindingNavigatorCountItem;

            this.bindingNavigator1.DeleteItem = this.bindingNavigatorDeleteItem;

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

            this.bindingNavigatorMoveFirstItem,

            this.bindingNavigatorMovePreviousItem,

            this.bindingNavigatorSeparator,

            this.bindingNavigatorPositionItem,

            this.bindingNavigatorCountItem,

            this.bindingNavigatorSeparator1,

            this.bindingNavigatorMoveNextItem,

            this.bindingNavigatorMoveLastItem,

            this.bindingNavigatorSeparator2,

            this.bindingNavigatorAddNewItem,

            this.bindingNavigatorDeleteItem,

            this.toolStripButton1});

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

            this.bindingNavigator1.MoveFirstItem = this.bindingNavigatorMoveFirstItem;

            this.bindingNavigator1.MoveLastItem = this.bindingNavigatorMoveLastItem;

            this.bindingNavigator1.MoveNextItem = this.bindingNavigatorMoveNextItem;

            this.bindingNavigator1.MovePreviousItem = this.bindingNavigatorMovePreviousItem;

            this.bindingNavigator1.Name = "bindingNavigator1";

            this.bindingNavigator1.PositionItem = this.bindingNavigatorPositionItem;

            this.bindingNavigator1.Size = new System.Drawing.Size(603, 25);

            this.bindingNavigator1.TabIndex = 0;

            this.bindingNavigator1.Text = "bindingNavigator1";

            //

            // bindingNavigatorMoveFirstItem

            //

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

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

            this.bindingNavigatorMoveFirstItem.Name = "bindingNavigatorMoveFirstItem";

            this.bindingNavigatorMoveFirstItem.RightToLeftAutoMirrorImage = true;

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

            this.bindingNavigatorMoveFirstItem.Text = "Move first";

            //

            // bindingNavigatorMovePreviousItem

            //

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

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

            this.bindingNavigatorMovePreviousItem.Name = "bindingNavigatorMovePreviousItem";

            this.bindingNavigatorMovePreviousItem.RightToLeftAutoMirrorImage = true;

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

            this.bindingNavigatorMovePreviousItem.Text = "Move previous";

            //

            // bindingNavigatorSeparator

            //

            this.bindingNavigatorSeparator.Name = "bindingNavigatorSeparator";

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

            //

            // bindingNavigatorPositionItem

            //

            this.bindingNavigatorPositionItem.AccessibleName = "Position";

            this.bindingNavigatorPositionItem.AutoSize = false;

            this.bindingNavigatorPositionItem.Name = "bindingNavigatorPositionItem";

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

            this.bindingNavigatorPositionItem.Text = "0";

            this.bindingNavigatorPositionItem.ToolTipText = "Current position";

            //

            // bindingNavigatorCountItem

            //

            this.bindingNavigatorCountItem.Name = "bindingNavigatorCountItem";

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

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

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

            //

            // bindingNavigatorSeparator1

            //

            this.bindingNavigatorSeparator1.Name = "bindingNavigatorSeparator";

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

            //

            // bindingNavigatorMoveNextItem

            //

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

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

            this.bindingNavigatorMoveNextItem.Name = "bindingNavigatorMoveNextItem";

            this.bindingNavigatorMoveNextItem.RightToLeftAutoMirrorImage = true;

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

            this.bindingNavigatorMoveNextItem.Text = "Move next";

            //

            // bindingNavigatorMoveLastItem

            //

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

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

            this.bindingNavigatorMoveLastItem.Name = "bindingNavigatorMoveLastItem";

            this.bindingNavigatorMoveLastItem.RightToLeftAutoMirrorImage = true;

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

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