Реализация базы данных «Транспортной фирмы»

ALTER PROCEDURE dbo.Ychetzakazov

 

(

@Ychetzakazov_nomerzakazov varchar(50),

@YYchetzakazov_data varchar(50),

@Ychetzakazov_kodzakazchika varchar(50),

@Ychetzakazov_kodmashiny varchar(50),

@Ychetzakazov_sostoyanie varchar(50),

@Ychetzakazov_period varchar(50)

 

)

AS

INSERT INTO[Учет заказов]

([№ заказа],[дата],[код заказчика],[код машины],[состояние],[период])

VALUES

(

@Ychetzakazov_nomerzakazov,

@YYchetzakazov_data,

@Ychetzakazov_kodzakazchika,

@Ychetzakazov_kodmashiny,

@Ychetzakazov_sostoyanie,

@Ychetzakazov_period

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Приложение №22

Формы1

 

 

Формы2

 

 

 

 

 

 

 

 

 

Формы3

 

 

Формы4

 

 

 

Формы5

 

 

Формы6

 

 

 

 

 

 

 

 

 

Формы7

 

 

 

Формы8

 

 

 

 

 

 

 

 

Формы9

 

 

Формы10

 

 

 

 

Формы11

 

 

 

Формы12

 

 

 

 

 

 

 

Формы13

 

Формы14

 

 

 

Формы15

 

 

Формы16

 

Формы17

 

Формы18

 

 

Формы19

 

 

Формы20

 

 

 

 

Формы21

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Приложение №23

Код программы

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 WindowsFormsApplication1

{

    public partial class Form1 : Form

    {

        static public Form9 Form9;

        static public Form2 Form2;

        static public Form10 Form10;

        static public Form15 Form15;

        static public Form16 Form16;

        static public Form17 Form17;

        static public Form18 Form18;

        static public Form19 Form19;

        static public Form4 Form4;

        static public Form14 Form14;

        static public Form5 Form5;

        static public Form13 Form13;

        static public Form7 Form7;

        static public Form11 Form11;

        static public Form3 Form3;

        static public Form8 Form8;

        static public Form6 Form6;

        static public Form12 Form12;

        static public Form20 Form20;

        static public Form21 Form21;

        public Form1()

        {

            InitializeComponent();

        }

    

        private void сотрудникиToolStripMenuItem_Click(object sender, EventArgs e)

        {

 

        }

 

        private void pictureBox1_Click(object sender, EventArgs e)

        {

 

        }

 

        private void pictureBox2_Click(object sender, EventArgs e)

        {

 

        }

 

        private void персоналToolStripMenuItem_Click(object sender, EventArgs e)

        {

          

 

        }

 

        private void водителиToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form9 = new Form9();

            Form9.Visible=true;

 

 

        }

 

        private void весьСоставToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form2 = new Form2();

            Form2.Visible = true;

        }

 

        private void менеджерыToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form10 = new Form10();

            Form10.Visible = true;

        }

 

        private void филиалToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form15 = new Form15();

            Form15.Visible = true;

        }

 

        private void филиалToolStripMenuItem1_Click(object sender, EventArgs e)

        {

            Form16 = new Form16();

            Form16.Visible = true;

        }

 

        private void филиалToolStripMenuItem2_Click(object sender, EventArgs e)

        {

            Form17 = new Form17();

            Form17.Visible = true;

        }

 

        private void должностиToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form18 = new Form18();

            Form18.Visible = true;

         }

 

        private void зарплатаToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form19 = new Form19();

            Form19.Visible = true;

     

       

      

 

        }

 

        private void выходToolStripMenuItem_Click(object sender, EventArgs e)

        {

 

            Application.Exit();

        }

 

        private void учетToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form4 = new Form4();

            Form4.Visible = true;

        }

 

        private void стоимостьАрендыToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form14 = new Form14();

            Form14.Visible = true;

        }

 

        private void учетЗаказовToolStripMenuItem_Click(object sender, EventArgs e)

        {

           Form5 = new Form5();

            Form5.Visible = true;

        }

 

        private void заказчикиToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form13 = new Form13();

            Form13.Visible = true;

        }

 

        private void характеристикаМашинToolStripMenuItem_Click(object sender, EventArgs e)

        {

 

            Form7 = new Form7();

            Form7.Visible = true;

        }

 

        private void расположениеТранспортаПоФилиаламToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form11 = new Form11();

            Form11.Visible = true;

        }

 

        private void путевойЛистToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form3 = new Form3();

            Form3.Visible = true;

        }

 

        private void водителиToolStripMenuItem1_Click(object sender, EventArgs e)

        {

            Form8 = new Form8();

            Form8.Visible = true;

        }

 

        private void адресаФилиаловToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form6 = new Form6();

            Form6.Visible = true;

        }

 

        private void персоналФирмToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form12 = new Form12();

            Form12.Visible = true;

        }

 

        private void контактнаяИнформацияToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form20 = new Form20();

            Form20.Visible = true;

        }

 

        private void контактнаяИнформацияToolStripMenuItem1_Click(object sender, EventArgs e)

        {

            Form21 = new Form21();

            Form21.Visible = true;

        }

 

        }

      }