Создание базы данных для парикмахерской

Результат тестирования разработанного ПО показал, что использовании данной программы сокращает время регистрации  услуг и формирования расписания работников, а также позволяет сотрудникам учреждения уйти от бумажных носителей информации.

Данное программное обеспечение  может быть использовано учреждениями бытового обслуживания населения различного профиля.

 

 

Список литературы

Книги

 

1. Гайдамакин Н. А. Автоматизированные информационные системы, базы и банки данных. Вводный курс: Учебное пособие. — М.: Гелиос АРВ, 2002. — 368 с, ил.
2. Блаха М., Рамбо Дж. UML 2.0. Объектно-ориентированное моделирование и разработка. 2-е изд. – СПб.: Питер, 2007.-544 с.: ил.
3. Коннолли Т., Бегг К. Базы данных. Проектирование, реализация и сопровождение. Теория и практика. 3-е издание. : Пер. с англ. — М. : Издательский дом "Вильямс", 2003. — 1440 с.
4. Мацяшек К.Н. Анализ требований и проектирование системы.: Пер. с англ.-М.: Издательский дом «Вильямс», 2002 – 432 с. :ил. – Парал. тит. англ.

Нормативные документы

1. ГОСТ 24.211–82. Система технической документации на АСУ. Требования к содержанию документа «Описание алгоритма». Введ. с 01.01.83.

 

 

 

 

 

 

 

 

 

 

 

Приложение 1 (текст программы)

 

 

Form_add.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 hairdressing

{

    public partial class Form_add : Form

    {

        MyDataSet my_ds;

        MyDataSet my_ds1;

 

        public Form_add()

        {

            InitializeComponent();

        }

 

        private void Form_add_Load(object sender, EventArgs e)

        {

            this.dataGridView1.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText;

            dateTimePicker1.Format = DateTimePickerFormat.Custom;

            dateTimePicker1.CustomFormat = "yyyy-MM-dd";

            dateTimePicker2.Format = DateTimePickerFormat.Custom;

            dateTimePicker2.CustomFormat = "HH:mm:ss";

            my_ds = new MyDataSet();

            my_ds1 = new MyDataSet();

           

           

 

        }

 

        private void button1_Click(object sender, EventArgs e)

        {

            if (this.dataGridView1.GetCellCount(DataGridViewElementStates.Selected) > 0)

            {

                try

                {

 

                    Clipboard.SetDataObject(

                        this.dataGridView1.GetClipboardContent());

 

 

                    this.textBox1.Text = Clipboard.GetText();

                }

                catch (System.Runtime.InteropServices.ExternalException)

                {

                    this.textBox1.Text = "-";

                }

            }

            string date = dateTimePicker1.Value.ToString("yyyy-MM-dd");

            string time = dateTimePicker1.Value.ToString("yyyy-MM-dd")+" "+dateTimePicker2.Value.ToString("HH:mm:ss");

            string request = "insert into timetable (id_staff, data, time, client, serv1) values (" + textBox3.Text + ", '" +date+"', '"+time+"', '"+textBox1.Text+"', "+textBox2.Text+")";

            my_ds1.doInsert(request);

        }

 

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)

        {

            string request = "select s.last_name as 'фамилия', s.first_name as 'имя', g.start_time as 'свободен(на) с', g.end_time as 'до'" +

                 "from grafik as g join staff as s on g.id_staff=s.id_staff where g.data='" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "'";

            my_ds.doRequest(request);

            dataGridView1.DataMember = my_ds.ds.Tables[0].ToString();

            dataGridView1.DataSource = my_ds.ds;

        }

    }

}

 

 

 

 

Form_grafik.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 hairdressing

{

    public partial class Form_frafik : Form

    {

 

        MyDataSet my_ds;

 

        public Form_frafik()

        {

            InitializeComponent();

        }

 

        private void Form_frafik_Load(object sender, EventArgs e)

        {

            my_ds = new MyDataSet();

           

        }

 

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)

        {

            string request = "select s.last_name as 'фамилия', s.first_name as 'имя', g.start_time as 'свободен(на) с', g.end_time as 'до'" +

                "from grafik as g join staff as s on g.id_staff=s.id_staff where g.data='" + dateTimePicker1.Value.ToString("yyyy-MM-dd")+"'";

            my_ds.doRequest(request);

            dataGridView1.DataMember = my_ds.ds.Tables[0].ToString();

            dataGridView1.DataSource = my_ds.ds;

        }

    }

}

 

 

 

 

Form_timetable.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 hairdressing

{

    public partial class Form_timetable : Form

    {

        MyDataSet my_ds;

        MyDataSet my_ds1;

 

        public Form_timetable()

        {

            InitializeComponent();

        }

 

        private void button1_Click(object sender, EventArgs e)

        {

            if (this.dataGridView1.GetCellCount(DataGridViewElementStates.Selected) > 0)

            {

                try

                {

 

                    Clipboard.SetDataObject(

                        this.dataGridView1.GetClipboardContent());

 

 

                    this.textBox1.Text = Clipboard.GetText();

                }

                catch (System.Runtime.InteropServices.ExternalException)

                {

                    this.textBox1.Text = "-";

                }

            }

            string date = dateTimePicker1.Value.ToString("yyyy-MM-dd");

            string request = "select t.time as 'время', t.client as 'клиент', s.name as 'процедура', st.name as 'тип', t.duration as 'продолжительность'"+

 

"from timetable as t join services as s on t.serv1=s.id_serv join serv_types as st on s.type=st.id_type "  + "where (t.id_staff="+textBox1.Text+") and (t.data='"+date+"')";

my_ds1.doRequest(request);

            dataGridView2.DataMember = my_ds1.ds.Tables[0].ToString();

            dataGridView2.DataSource = my_ds1.ds;

 

        }

 

        private void Form_timetable_Load(object sender, EventArgs e)

        {

            this.dataGridView1.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText;

            dateTimePicker1.Format = DateTimePickerFormat.Custom;

            dateTimePicker1.CustomFormat = "yyyy-MM-dd";

            my_ds = new MyDataSet();

            my_ds1 = new MyDataSet();

            string request = "select id_staff as 'номер', last_name as 'фамилия', first_name as 'имя' from  staff ";

            my_ds.doRequest(request);

            dataGridView1.DataMember = my_ds.ds.Tables[0].ToString();

            dataGridView1.DataSource = my_ds.ds;

        }

    }

}

 

 

Form1.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 hairdressing

{

    public partial class Form1 : Form

    {

 

        MyDataSet my_ds;

        Form_frafik f_grafik;

        Form_timetable f_timetable;

 

        Form_add f_add;

 

        public Form1()

        {

            InitializeComponent();

        }

 

        private void Form1_Load(object sender, EventArgs e)

        {

            my_ds = new MyDataSet();

          

        }

 

        private void button2_Click(object sender, EventArgs e)

        {

            f_grafik = new Form_frafik();

            f_grafik.Show();

        }

 

        private void button3_Click(object sender, EventArgs e)

        {

            f_timetable = new Form_timetable();

            f_timetable.Show();

        }

 

        private void button1_Click(object sender, EventArgs e)

        {

            f_add = new Form_add();

            f_add.Show();

        }

 

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)

        {

            string request = "select t.time as 'время', t.client as 'клиент', s.last_name as 'мастер', sr.name as 'услуга'," +

               "t.duration as 'продолжительность' from staff as s join timetable as t on s.id_staff=t.id_staff " +

               "join services as sr on t.serv1=sr.id_serv where t.data='" + dateTimePicker1.Value.ToString("yyyy-MM-dd")+"'";

            my_ds.doRequest(request);

 

            dataGridView1.DataMember = my_ds.ds.Tables[0].ToString();

 

 

            dataGridView1.DataSource = my_ds.ds;

        }

    }

}

 

MyDataSet.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;

using System.Data.Odbc;

 

namespace hairdressing

{

    public class MyDataSet

    {

        public string request = "";

        public string connection = "";

        public DataSet ds;

        OdbcDataAdapter dataAdapter;

        public BindingSource bs;

        OdbcConnection con;

 

 

        public MyDataSet()

        {

            ds = new DataSet();

            try

            {

 

                connection = "Driver={MySQL ODBC 3.51 Driver};" +

                "Server=localhost;" +

                "Port=3306;" +

                "Database=hairdressing_salon;" +

                "User=root; " +

                "Password=070888;" +

                "CharSet=cp1251;" +

                "Option=3";

 

            }

            catch (OdbcException ex)

            {

                MessageBox.Show(ex.ToString(), "Warning!");

            }

            con = new OdbcConnection(connection);

 

        }

 

        public void doRequest(string request_)

 

        {

            request = request_;

            dataAdapter = new OdbcDataAdapter(request, connection);

 

            dataAdapter.Fill(ds);

            bs = new BindingSource(ds, ds.Tables[0].ToString());

        }

 

        public void doInsert(string request_)

        {

            request = request_;

            OdbcCommand cmd = new OdbcCommand(request, con);

            cmd.Connection.Open();

            cmd.ExecuteNonQuery();

            cmd.Connection.Close();

        }

 

        public void update()

        {

            ds.AcceptChanges();

            this.dataAdapter.Update(ds);

            this.bs.ResetBindings(true);

 

        }

 

    }

}

 

Program.cs

 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Windows.Forms;

 

namespace hairdressing

{

    static class Program

    {

        /// <summary>

        /// The main entry point for the application.

        /// </summary>

        [STAThread]

        static void Main()

       {

            Application.EnableVisualStyles();

            Application.SetCompatibleTextRenderingDefault(false);

            Application.Run(new Form1());

        }

    }