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

Список использованной литературы

1. MicrosoftVisualStudioC# 2008. Базовый курс. Карлин Уотсон, Кристиан Нейгел. 2009 г.
2. Михаил Флёнов Библия C# 2-е издание. СПб. 2011. – 560 с.
3. Программирование баз данных. MicrosoftSQLServer 2008. Базовый курс. Р.Виейра; Пер. с англ.; Под. Ред. С.М.Молявко. – М.: Вильямс, 2010. –816 с.
4. Работа с базами данных на языке C#. Технология ADO.NET. Учебное пособие.

 

 

Приложение 1. Главная форма MainForm

FormMain.Designer.cs

namespace cars

{

    partial class FormMain

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

 

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

        protected override void Dispose(bool disposing)

        {

            if (disposing && (components != null))

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

 

        #region Windows Form Designer generated code

 

        /// <summary>

        /// Required method for Designer support - do not modify

        /// the contents of this method with the code editor.

        /// </summary>

        private void InitializeComponent()

        {

            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FormMain));

            this.panel1 = new System.Windows.Forms.Panel();

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

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

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

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

            this.panel2 = new System.Windows.Forms.Panel();

            this.label1 = new System.Windows.Forms.Label();

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

            this.panel1.SuspendLayout();

            this.panel2.SuspendLayout();

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

            this.SuspendLayout();

            //

            // panel1

            //

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

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

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

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

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

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

            this.panel1.Name = "panel1";

            this.panel1.Size = new System.Drawing.Size(465, 33);

            this.panel1.TabIndex = 0;

            //

            // cbClose

            //

            this.cbClose.FlatStyle = System.Windows.Forms.FlatStyle.Flat;

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

            this.cbClose.Name = "cbClose";

            this.cbClose.Size = new System.Drawing.Size(91, 23);

            this.cbClose.TabIndex = 3;

            this.cbClose.Text = "Выход";

            this.cbClose.UseVisualStyleBackColor = true;

            this.cbClose.Click += new System.EventHandler(this.cbClose_Click);

            //

            // cbRep

            //

            this.cbRep.FlatStyle = System.Windows.Forms.FlatStyle.Flat;

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

            this.cbRep.Name = "cbRep";

            this.cbRep.Size = new System.Drawing.Size(91, 23);

            this.cbRep.TabIndex = 2;

            this.cbRep.Text = "Отчеты";

            this.cbRep.UseVisualStyleBackColor = true;

            this.cbRep.Click += new System.EventHandler(this.cbRep_Click);

            //

            // cbUchet

            //

            this.cbUchet.FlatStyle = System.Windows.Forms.FlatStyle.Flat;

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

            this.cbUchet.Name = "cbUchet";

            this.cbUchet.Size = new System.Drawing.Size(91, 23);

            this.cbUchet.TabIndex = 1;

            this.cbUchet.Text = "Учет";

            this.cbUchet.UseVisualStyleBackColor = true;

            this.cbUchet.Click += new System.EventHandler(this.cbUchet_Click);

            //

            // cbSpr

            //

            this.cbSpr.FlatStyle = System.Windows.Forms.FlatStyle.Flat;

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

            this.cbSpr.Name = "cbSpr";

            this.cbSpr.Size = new System.Drawing.Size(91, 23);

            this.cbSpr.TabIndex = 0;

            this.cbSpr.Text = "Справочники";

            this.cbSpr.UseVisualStyleBackColor = true;

            this.cbSpr.Click += new System.EventHandler(this.cbSpr_Click);

            //

            // panel2

            //

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

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

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

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

            this.panel2.Name = "panel2";

            this.panel2.Size = new System.Drawing.Size(465, 295);

            this.panel2.TabIndex = 1;

            //

            // label1

            //

            this.label1.AutoSize = true;

            this.label1.BackColor = System.Drawing.Color.Black;

            this.label1.FlatStyle = System.Windows.Forms.FlatStyle.Flat;

            this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(204)));

            this.label1.ForeColor = System.Drawing.SystemColors.ActiveCaptionText;

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

            this.label1.Name = "label1";

            this.label1.Size = new System.Drawing.Size(307, 26);

            this.label1.TabIndex = 1;

            this.label1.Text = "АРМ менеджера автосалона";

            //

            // pictureBox1

            //

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

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

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

            this.pictureBox1.Name = "pictureBox1";

            this.pictureBox1.Size = new System.Drawing.Size(465, 295);

            this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage;

            this.pictureBox1.TabIndex = 0;

            this.pictureBox1.TabStop = false;

            //

            // FormMain

            //

            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);

            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

            this.ClientSize = new System.Drawing.Size(465, 328);

            this.Controls.Add(this.panel2);

            this.Controls.Add(this.panel1);

            this.Name = "FormMain";

            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;

            this.Text = "АРМ менеджера по продажам автомобилей в автосалоне";

            this.panel1.ResumeLayout(false);

            this.panel2.ResumeLayout(false);

            this.panel2.PerformLayout();

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

            this.ResumeLayout(false);

 

        }

 

        #endregion

 

        private System.Windows.Forms.Panel panel1;

        private System.Windows.Forms.Button cbClose;

        private System.Windows.Forms.Button cbRep;

        private System.Windows.Forms.Button cbUchet;

        private System.Windows.Forms.Button cbSpr;

        private System.Windows.Forms.Panel panel2;

        private System.Windows.Forms.Label label1;

        private System.Windows.Forms.PictureBox pictureBox1;

    }

}

 

 

 

 

 

 

 

 

 

FormMain.cs

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

 

namespace cars

{

    public partial class FormMain : Form

    {

        public FormMain()

        {

            InitializeComponent();

        }

 

        private void cbClose_Click(object sender, EventArgs e)

        {

            Close();

        }

 

        private void cbSpr_Click(object sender, EventArgs e)

        {

            FormSpr frm =new FormSpr();

            frm.ShowDialog();

        }

 

        private void cbUchet_Click(object sender, EventArgs e)

        {

            FormUchet frm = new FormUchet();

            frm.ShowDialog();

        }

 

        private void cbRep_Click(object sender, EventArgs e)

        {

            FormRep frm = new FormRep();

            frm.Show();

        }

    }

}

 

 

Приложение 2. форма справочников

FormSpr.Designer.cs

namespace cars

{

    partial class FormSpr

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

 

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

        protected override void Dispose(bool disposing)

        {

            if (disposing && (components != null))

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

 

        #region Windows Form Designer generated code

 

        /// <summary>

        /// Required method for Designer support - do not modify

        /// the contents of this method with the code editor.

        /// </summary>

        private void InitializeComponent()

        {

            this.components = new System.ComponentModel.Container();

            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FormSpr));

            this.tabControl1 = new System.Windows.Forms.TabControl();

            this.tabPage1 = new System.Windows.Forms.TabPage();

            this.tabPage2 = new System.Windows.Forms.TabPage();

            this.tabPage3 = new System.Windows.Forms.TabPage();

            this.tabPage4 = new System.Windows.Forms.TabPage();

            this.tabPage5 = new System.Windows.Forms.TabPage();

            this.bindingNavigator1 = new System.Windows.Forms.BindingNavigator(this.components);

            this.bindingNavigatorMoveFirstItem = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigatorMovePreviousItem = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigatorSeparator = new System.Windows.Forms.ToolStripSeparator();

            this.bindingNavigatorPositionItem = new System.Windows.Forms.ToolStripTextBox();

            this.bindingNavigatorCountItem = new System.Windows.Forms.ToolStripLabel();

            this.bindingNavigatorSeparator1 = new System.Windows.Forms.ToolStripSeparator();

            this.bindingNavigatorMoveNextItem = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigatorMoveLastItem = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigatorSeparator2 = new System.Windows.Forms.ToolStripSeparator();

            this.bindingNavigatorAddNewItem = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigatorDeleteItem = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton1 = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigator2 = new System.Windows.Forms.BindingNavigator(this.components);

            this.toolStripButton2 = new System.Windows.Forms.ToolStripButton();

            this.toolStripLabel1 = new System.Windows.Forms.ToolStripLabel();

            this.toolStripButton3 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton4 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton5 = new System.Windows.Forms.ToolStripButton();

            this.toolStripSeparator1 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripTextBox1 = new System.Windows.Forms.ToolStripTextBox();

            this.toolStripSeparator2 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripButton6 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton7 = new System.Windows.Forms.ToolStripButton();

            this.toolStripSeparator3 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripButton8 = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigator3 = new System.Windows.Forms.BindingNavigator(this.components);

            this.toolStripButton9 = new System.Windows.Forms.ToolStripButton();

            this.toolStripLabel2 = new System.Windows.Forms.ToolStripLabel();

            this.toolStripButton10 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton11 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton12 = new System.Windows.Forms.ToolStripButton();

            this.toolStripSeparator4 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripTextBox2 = new System.Windows.Forms.ToolStripTextBox();

            this.toolStripSeparator5 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripButton13 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton14 = new System.Windows.Forms.ToolStripButton();

            this.toolStripSeparator6 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripButton15 = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigator4 = new System.Windows.Forms.BindingNavigator(this.components);

            this.toolStripButton16 = new System.Windows.Forms.ToolStripButton();

            this.toolStripLabel3 = new System.Windows.Forms.ToolStripLabel();

            this.toolStripButton17 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton18 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton19 = new System.Windows.Forms.ToolStripButton();

            this.toolStripSeparator7 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripTextBox3 = new System.Windows.Forms.ToolStripTextBox();

            this.toolStripSeparator8 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripButton20 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton21 = new System.Windows.Forms.ToolStripButton();

            this.toolStripSeparator9 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripButton22 = new System.Windows.Forms.ToolStripButton();

            this.bindingNavigator5 = new System.Windows.Forms.BindingNavigator(this.components);

            this.toolStripButton23 = new System.Windows.Forms.ToolStripButton();

            this.toolStripLabel4 = new System.Windows.Forms.ToolStripLabel();

            this.toolStripButton24 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton25 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton26 = new System.Windows.Forms.ToolStripButton();

            this.toolStripSeparator10 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripTextBox4 = new System.Windows.Forms.ToolStripTextBox();

            this.toolStripSeparator11 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripButton27 = new System.Windows.Forms.ToolStripButton();

            this.toolStripButton28 = new System.Windows.Forms.ToolStripButton();

            this.toolStripSeparator12 = new System.Windows.Forms.ToolStripSeparator();

            this.toolStripButton29 = new System.Windows.Forms.ToolStripButton();

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

            this.автосалонDataSet = new cars.АвтосалонDataSet();

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

            this.маркиTableAdapter = new cars.АвтосалонDataSetTableAdapters.МаркиTableAdapter();

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

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

            this.panel1 = new System.Windows.Forms.Panel();

            this.splitter1 = new System.Windows.Forms.Splitter();

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

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

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