Администрирование, базы данных

   and ID_obrabotka=ID_obrabotka1

   group by Imya_proekta,Proekt_nomer,Srok,Stadiya

   order by Imya_proekta;

 

 

select distinct Li4nuy_ID_sotrydnika,Familiya,Symma

  From Dolgnosti,Sotrydniki,Zar_plata,Otdelu

   where ID_dolg=ID_dolgnosti

   and ID_otd=ID_otdel2

         and ID_otd=ID_otdel3

   order by Familiya desc;

 

ДОДАТОК В

 

Лістинг В.1 –Усі форми, задіянні у проекті інтерфейсу

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

    {

 

        public Form1()

        {

            InitializeComponent();

       }

 

        public System.Data.SqlClient.SqlConnection connect;

 

            private void Form1_load(object sender,EventArgs e)

            {

                String connectionString = "Data Source=RI;Initial Catalog=Form1;Integrated Security=True";

                        connect = new

                        System.Data.SqlClient.SqlConnection(connectionString);

                connect.Open();

            }

 

Продовження лістингу В.1

        private void dolgnostiToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form2 form2 = new Form2();

            form2.Show();

        }

 

        private void klientToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form3 form3 = new Form3();

            form3.Show();

        }

 

        private void komitetToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form4 form4 = new Form4();

            form4.Show();

        }

 

        private void magazinToolStripMenuItem_Click(object sender, EventArgs e)

       {

            Form5 form5 = new Form5();

            form5.Show();

        }

 

        private void otdeluToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form6 form6 = new Form6();

            form6.Show();

        }

Продовження лістингу В.1

        private void prodykziyaToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form7 form7 = new Form7();

            form7.Show();

        }

 

        private void proektuToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form8 form8 = new Form8();

            form8.Show();

        }

 

        private void sotrydnikiToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form9 form9 = new Form9();

            form9.Show();

       }

 

        private void zarplataToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form10 form10 = new Form10();

            form10.Show();

        }

 

        private void zentrobrabotkiToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form11 form11 = new Form11();

            form11.Show();

Продовження лістингу В.1

   }

 

        private void pictureBox1_Click(object sender, EventArgs e)

        {

 

        }

 

        private void запросыToolStripMenuItem_Click(object sender, EventArgs e)

        {

            Form12 form12 = new Form12();

            form12.Show();

        }

    }

}