Добавил:
Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз: Предмет: Файл:
Отчёт по лабораторным.docx
Скачиваний:
2
Добавлен:
18.11.2022
Размер:
1.41 Mб
Скачать

InitializeComponent();

}

private void регистрацияТовараToolStripMenuItem_Click(object sender, EventArgs e)

{

Form f2 = new Form2();

f2.Show();

}

private void вводПокупателейToolStripMenuItem_Click(object sender, EventArgs e)

{

Form f3 = new Form3();

f3.Show();

}

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

{

Form f4 = new Form4();

f4.Show();

}

private void компанииToolStripMenuItem_Click(object sender, EventArgs e)

{

Form f5 = new Form5();

f5.Show();

}

private void заказыПокупателяToolStripMenuItem_Click(object sender, EventArgs e)

{

Form f6 = new Form6();

f6.Show();

}

private void заказыТовараToolStripMenuItem_Click(object sender, EventArgs e)

{

Form f7 = new Form7();

f7.Show();

}

private void заказыНаЗаданнуюДатуToolStripMenuItem_Click(object sender, EventArgs e)

{

Form f8 = new Form8();

f8.Show();

}

private void заказыНаЗаданнуюДатуToolStripMenuItem1_Click(object sender, EventArgs e)

{

Form f9 = new Form9();

f9.Show();

}

private void заказыВИнтервалеДатToolStripMenuItem_Click(object sender, EventArgs e)

{

Form f10 = new Form10();

f10.Show();

}

private void заказыПокупателяToolStripMenuItem1_Click(object sender, EventArgs e)

{

Form f11 = new Form11();

f11.Show();

}

private void заказыТовараToolStripMenuItem1_Click(object sender, EventArgs e)

{

Form f12 = new Form12();

f12.Show();

}

}

}

Форма Заказы на заданную дату:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace Проектирование_интерфесов__10

{

public partial class Form9 : Form

{

public Form9()

{

InitializeComponent();

}

private void dateTimePicker1_ValueChanged(object sender, EventArgs e)

{

dataView1.RowFilter = "[Дата продажи]=" + "'" + System.Convert.ToString(dateTimePicker1.Value).Substring(0, 10) + "'";

dataSet11.Clear();

sqlDataAdapter1.Fill(dataSet11.OrderPerDate);

}

}

}

Форма Заказы в интервале дат:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace Проектирование_интерфесов__10

{

public partial class Form10 : Form

{

public Form10()

{

InitializeComponent();

}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

{

switch(comboBox1.SelectedIndex)

{

case 0:

dateTimePicker2.Visible = false;

break;

case 1:

dateTimePicker2.Visible = true;

break;

case 2:

dateTimePicker2.Visible = false;

break;

}

}

private void dateTimePicker1_ValueChanged(object sender, EventArgs e)

{

switch (comboBox1.SelectedIndex)

{

case 0:

dataView1.RowFilter = "[Дата продажи]<" + "'" + System.Convert.ToString(dateTimePicker1.Value).Substring(0, 10) + "'";

dataSet21.Clear();

sqlDataAdapter1.Fill(dataSet21.OrderPerDate);

break;

case 2:

dataView1.RowFilter = "[Дата продажи]>" + "'" + System.Convert.ToString(dateTimePicker1.Value).Substring(0, 10) + "'";

dataSet21.Clear();

sqlDataAdapter1.Fill(dataSet21.OrderPerDate);

break;

}

}

private void dateTimePicker2_ValueChanged(object sender, EventArgs e)

{

if(comboBox1.SelectedIndex == 1)

{

dataView1.RowFilter = "[Дата продажи]>=" + "'" + System.Convert.ToString(dateTimePicker1.Value).Substring(0, 10) + "' And " + "[Дата продажи]<= '" + System.Convert.ToString(dateTimePicker2.Value).Substring(0, 10) + "'";

dataSet21.Clear();

sqlDataAdapter1.Fill(dataSet21.OrderPerDate);

}

}

}

}

Форма Заказы покупателя:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace Проектирование_интерфесов__10

{

public partial class Form11 : Form

{

public Form11()

{