Разработка программного продукта для автоматизации учёта заправки картриджей

Заказать уникальную курсовую работу
Тип работы: Курсовая работа
Предмет: Программирование
  • 86 86 страниц
  • 5 + 5 источников
  • Добавлена 01.05.2024
1 496 руб.
  • Содержание
  • Часть работы
  • Список литературы
СОДЕРЖАНИЕ 2
ВВЕДЕНИЕ 4
1. ТЕХНИЧЕСКОЕ ЗАДАНИЕ 6
1.1. Наименование продукта 6
1.2. Краткая характеристика области применения 6
1.3. Основание для разработки 6
1.4. Назначение разработки 7
1.5. Требования к разработке 7
1.5.1. Требования к функциональным характеристикам 7
1.5.2. Требования к надежности. 8
1.5.3. Требования к составу и параметрам технических средств. 8
1.5.4. Требования к информационной и программной совместимости. 9
1.6. Требования к программной документации. 9
1.7. Технико-экономические показатели. 9
1.8. Порядок контроля и приемки. 10
1.9. Анализ технического задания. 11
1.9.1. Выбор системы управления базой данных. 11
1.9.2. Выбор средств разработки. 12
1.9.3. Технико-экономическое обоснование. 14
2. РАЗРАБОТКА ИНФОРМАЦИОННОЙ СИСТЕМЫ. 15
2.1. Разработка архитектуры системы. 15
2.2. Модель прецедентов использования системы. 15
2.3. Разработка модели IDEF0 16



2.4. Разработка объектов базы данных для обеспечения работы отдельных подсистем и функций приложения. 21
2.5. Разработка структуры информационной системы. 25
2.6. Разработка интерфейса приложения. 26
2.7. Разработка программных модулей. 28
2.8. Разработка руководства пользователя. 37
3. РАСЧЕТЫ И ОЦЕНКИ. 40
4. РАЗРАБОТКА РУКОВОДСТВА ДЛЯ СИСТЕМНОГО АДМИНИСТРАТОРА 42
ЗАКЛЮЧЕНИЕ 43
СПИСОК ИСПОЛЬЗОВАННОЙ ЛИТЕРАТУРЫ 44
ПРИЛОЖЕНИЕ 1 – Текст программы. 45

Фрагмент для ознакомления

h#pragma oncenamespace Project3 {using namespace System;using namespace System::ComponentModel;using namespace System::Collections;using namespace System::Windows::Forms;using namespace System::Data;using namespace System::Drawing;///

/// Сводка для MyForm/// public ref class MyForm : public System::Windows::Forms::Form{public:MyForm(void){InitializeComponent();////TODO: добавьте код конструктора//}protected:/// /// Освободить все используемые ресурсы./// ~MyForm(){if (components){delete components;}}private: System::Windows::Forms::TabPage^ tabPage3;private: System::Windows::Forms::TabPage^ tabPage4;private: System::Windows::Forms::TabPage^ tabPage1;private: System::Windows::Forms::Label^ label7;private: System::Windows::Forms::TextBox^ textBox1;private: System::Windows::Forms::Label^ label4;private: System::Windows::Forms::ComboBox^ comboBox4;private: System::Windows::Forms::Label^ label5;private: System::Windows::Forms::ComboBox^ comboBox5;private: System::Windows::Forms::Label^ label6;private: System::Windows::Forms::ComboBox^ comboBox6;private: System::Windows::Forms::Label^ label3;private: System::Windows::Forms::ComboBox^ comboBox3;private: System::Windows::Forms::Label^ label2;private: System::Windows::Forms::ComboBox^ comboBox2;private: System::Windows::Forms::Label^ label1;private: System::Windows::Forms::ComboBox^ comboBox1;private: System::Windows::Forms::TabControl^ tabControl1;private: System::Windows::Forms::Label^ label8;private: System::Windows::Forms::GroupBox^ groupBox1;private: System::Windows::Forms::DateTimePicker^ dateTimePicker1;private: System::Windows::Forms::Button^ button2;private: System::Windows::Forms::GroupBox^ groupBox2;private: System::Windows::Forms::DateTimePicker^ dateTimePicker2;private: System::Windows::Forms::Label^ label10;private: System::Windows::Forms::Label^ label9;private: System::Windows::Forms::TextBox^ textBox2;private: System::Windows::Forms::Button^ button3;private: System::Windows::Forms::DateTimePicker^ dateTimePicker3;private: System::Windows::Forms::Label^ label16;private: System::Windows::Forms::DataGridView^ dataGridView2;private: System::Windows::Forms::GroupBox^ groupBox3;private: System::Windows::Forms::ComboBox^ comboBox10;private: System::Windows::Forms::ComboBox^ comboBox9;private: System::Windows::Forms::Label^ label12;private: System::Windows::Forms::Label^ label11;private: System::Windows::Forms::Label^ label13;private: System::Windows::Forms::ComboBox^ comboBox7;private: System::Windows::Forms::ComboBox^ comboBox8;private: System::Windows::Forms::Label^ label14;private: System::Windows::Forms::Label^ label15;private: System::Windows::Forms::ComboBox^ comboBox11;private: System::Windows::Forms::Button^ button4;private: System::Windows::Forms::GroupBox^ groupBox4;private: System::Windows::Forms::Label^ label23;private: System::Windows::Forms::ComboBox^ comboBox18;private: System::Windows::Forms::Label^ label22;private: System::Windows::Forms::ComboBox^ comboBox13;private: System::Windows::Forms::Label^ label19;private: System::Windows::Forms::ComboBox^ comboBox16;private: System::Windows::Forms::Label^ label20;private: System::Windows::Forms::Label^ label21;private: System::Windows::Forms::Button^ button5;private: System::Windows::Forms::Button^ button6;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn1;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn2;private: System::Windows::Forms::DataGridViewTextBoxColumn^ Column1;private: System::Windows::Forms::DataGridViewTextBoxColumn^ Column2;private: System::Windows::Forms::DataGridViewTextBoxColumn^ Column3;private: System::Windows::Forms::DataGridViewTextBoxColumn^ Column4;private: System::Windows::Forms::DataGridViewTextBoxColumn^ Column5;private: System::Windows::Forms::DataGridViewTextBoxColumn^ Column6;private: System::Windows::Forms::DataGridViewTextBoxColumn^ Column7;private: System::Windows::Forms::DataGridViewTextBoxColumn^ Column8;private: System::Windows::Forms::DataGridViewTextBoxColumn^ Column9;private: System::Windows::Forms::DataGridView^ dataGridView1;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn3;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn4;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn5;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn6;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn7;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn8;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn9;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn10;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn11;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn12;private: System::Windows::Forms::DataGridViewTextBoxColumn^ dataGridViewTextBoxColumn13;private: System::Windows::Forms::DateTimePicker^ dateTimePicker5;private: System::Windows::Forms::DateTimePicker^ dateTimePicker4;private:/// /// Обязательная переменная конструктора./// System::ComponentModel::Container ^components;#pragma region Windows Form Designer generated code/// /// Требуемый метод для поддержки конструктора — не изменяйте /// содержимое этого метода с помощью редактора кода./// void InitializeComponent(void){this->tabPage3 = (gcnew System::Windows::Forms::TabPage());this->dataGridView1 = (gcnew System::Windows::Forms::DataGridView());this->dataGridViewTextBoxColumn3 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->dataGridViewTextBoxColumn4 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->dataGridViewTextBoxColumn5 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->dataGridViewTextBoxColumn6 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->dataGridViewTextBoxColumn7 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->dataGridViewTextBoxColumn8 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->dataGridViewTextBoxColumn9 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->dataGridViewTextBoxColumn10 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->dataGridViewTextBoxColumn11 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->dataGridViewTextBoxColumn12 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->dataGridViewTextBoxColumn13 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->button4 = (gcnew System::Windows::Forms::Button());this->groupBox4 = (gcnew System::Windows::Forms::GroupBox());this->dateTimePicker5 = (gcnew System::Windows::Forms::DateTimePicker());this->dateTimePicker4 = (gcnew System::Windows::Forms::DateTimePicker());this->label23 = (gcnew System::Windows::Forms::Label());this->comboBox18 = (gcnew System::Windows::Forms::ComboBox());this->label22 = (gcnew System::Windows::Forms::Label());this->comboBox13 = (gcnew System::Windows::Forms::ComboBox());this->label19 = (gcnew System::Windows::Forms::Label());this->comboBox16 = (gcnew System::Windows::Forms::ComboBox());this->label20 = (gcnew System::Windows::Forms::Label());this->label21 = (gcnew System::Windows::Forms::Label());this->tabPage4 = (gcnew System::Windows::Forms::TabPage());this->button6 = (gcnew System::Windows::Forms::Button());this->button3 = (gcnew System::Windows::Forms::Button());this->dateTimePicker3 = (gcnew System::Windows::Forms::DateTimePicker());this->label16 = (gcnew System::Windows::Forms::Label());this->dataGridView2 = (gcnew System::Windows::Forms::DataGridView());this->dataGridViewTextBoxColumn1 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->dataGridViewTextBoxColumn2 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->Column1 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->Column2 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->Column3 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->Column4 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->Column5 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->Column6 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->Column7 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->Column8 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->Column9 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());this->groupBox3 = (gcnew System::Windows::Forms::GroupBox());this->comboBox11 = (gcnew System::Windows::Forms::ComboBox());this->comboBox10 = (gcnew System::Windows::Forms::ComboBox());this->comboBox9 = (gcnew System::Windows::Forms::ComboBox());this->label12 = (gcnew System::Windows::Forms::Label());this->label11 = (gcnew System::Windows::Forms::Label());this->label13 = (gcnew System::Windows::Forms::Label());this->comboBox7 = (gcnew System::Windows::Forms::ComboBox());this->comboBox8 = (gcnew System::Windows::Forms::ComboBox());this->label14 = (gcnew System::Windows::Forms::Label());this->label15 = (gcnew System::Windows::Forms::Label());this->tabPage1 = (gcnew System::Windows::Forms::TabPage());this->button5 = (gcnew System::Windows::Forms::Button());this->button2 = (gcnew System::Windows::Forms::Button());this->groupBox2 = (gcnew System::Windows::Forms::GroupBox());this->dateTimePicker2 = (gcnew System::Windows::Forms::DateTimePicker());this->label10 = (gcnew System::Windows::Forms::Label());this->label9 = (gcnew System::Windows::Forms::Label());this->textBox2 = (gcnew System::Windows::Forms::TextBox());this->label5 = (gcnew System::Windows::Forms::Label());this->comboBox5 = (gcnew System::Windows::Forms::ComboBox());this->dateTimePicker1 = (gcnew System::Windows::Forms::DateTimePicker());this->comboBox4 = (gcnew System::Windows::Forms::ComboBox());this->label8 = (gcnew System::Windows::Forms::Label());this->label4 = (gcnew System::Windows::Forms::Label());this->groupBox1 = (gcnew System::Windows::Forms::GroupBox());this->label1 = (gcnew System::Windows::Forms::Label());this->comboBox1 = (gcnew System::Windows::Forms::ComboBox());this->comboBox2 = (gcnew System::Windows::Forms::ComboBox());this->label7 = (gcnew System::Windows::Forms::Label());this->label2 = (gcnew System::Windows::Forms::Label());this->textBox1 = (gcnew System::Windows::Forms::TextBox());this->comboBox3 = (gcnew System::Windows::Forms::ComboBox());this->label3 = (gcnew System::Windows::Forms::Label());this->comboBox6 = (gcnew System::Windows::Forms::ComboBox());this->label6 = (gcnew System::Windows::Forms::Label());this->tabControl1 = (gcnew System::Windows::Forms::TabControl());this->tabPage3->SuspendLayout();(cli::safe_cast(this->dataGridView1))->BeginInit();this->groupBox4->SuspendLayout();this->tabPage4->SuspendLayout();(cli::safe_cast(this->dataGridView2))->BeginInit();this->groupBox3->SuspendLayout();this->tabPage1->SuspendLayout();this->groupBox2->SuspendLayout();this->groupBox1->SuspendLayout();this->tabControl1->SuspendLayout();this->SuspendLayout();// // tabPage3// this->tabPage3->Controls->Add(this->dataGridView1);this->tabPage3->Controls->Add(this->button4);this->tabPage3->Controls->Add(this->groupBox4);this->tabPage3->Location = System::Drawing::Point(4, 22);this->tabPage3->Name = L"tabPage3";this->tabPage3->Padding = System::Windows::Forms::Padding(3);this->tabPage3->Size = System::Drawing::Size(798, 356);this->tabPage3->TabIndex = 2;this->tabPage3->Text = L"Менеджмент";this->tabPage3->UseVisualStyleBackColor = true;// // dataGridView1// this->dataGridView1->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;this->dataGridView1->Columns->AddRange(gcnew cli::array< System::Windows::Forms::DataGridViewColumn^ >(11) {this->dataGridViewTextBoxColumn3,this->dataGridViewTextBoxColumn4, this->dataGridViewTextBoxColumn5, this->dataGridViewTextBoxColumn6, this->dataGridViewTextBoxColumn7,this->dataGridViewTextBoxColumn8, this->dataGridViewTextBoxColumn9, this->dataGridViewTextBoxColumn10, this->dataGridViewTextBoxColumn11,this->dataGridViewTextBoxColumn12, this->dataGridViewTextBoxColumn13});this->dataGridView1->Location = System::Drawing::Point(269, 6);this->dataGridView1->Name = L"dataGridView1";this->dataGridView1->Size = System::Drawing::Size(523, 335);this->dataGridView1->TabIndex = 24;// // dataGridViewTextBoxColumn3// this->dataGridViewTextBoxColumn3->HeaderText = L"Номер заказа";this->dataGridViewTextBoxColumn3->Name = L"dataGridViewTextBoxColumn3";// // dataGridViewTextBoxColumn4// this->dataGridViewTextBoxColumn4->HeaderText = L"ФИО заказчика";this->dataGridViewTextBoxColumn4->Name = L"dataGridViewTextBoxColumn4";// // dataGridViewTextBoxColumn5// this->dataGridViewTextBoxColumn5->HeaderText = L"Отделение";this->dataGridViewTextBoxColumn5->Name = L"dataGridViewTextBoxColumn5";// // dataGridViewTextBoxColumn6// this->dataGridViewTextBoxColumn6->HeaderText = L"Вид работы";this->dataGridViewTextBoxColumn6->Name = L"dataGridViewTextBoxColumn6";// // dataGridViewTextBoxColumn7// this->dataGridViewTextBoxColumn7->HeaderText = L"Принтер";this->dataGridViewTextBoxColumn7->Name = L"dataGridViewTextBoxColumn7";// // dataGridViewTextBoxColumn8// this->dataGridViewTextBoxColumn8->HeaderText = L"Картридж";this->dataGridViewTextBoxColumn8->Name = L"dataGridViewTextBoxColumn8";// // dataGridViewTextBoxColumn9// this->dataGridViewTextBoxColumn9->HeaderText = L"Акция";this->dataGridViewTextBoxColumn9->Name = L"dataGridViewTextBoxColumn9";// // dataGridViewTextBoxColumn10// this->dataGridViewTextBoxColumn10->HeaderText = L"Дата оформления";this->dataGridViewTextBoxColumn10->Name = L"dataGridViewTextBoxColumn10";// // dataGridViewTextBoxColumn11// this->dataGridViewTextBoxColumn11->HeaderText = L"Дата выдачи заказа";this->dataGridViewTextBoxColumn11->Name = L"dataGridViewTextBoxColumn11";// // dataGridViewTextBoxColumn12// this->dataGridViewTextBoxColumn12->HeaderText = L"Сумма";this->dataGridViewTextBoxColumn12->Name = L"dataGridViewTextBoxColumn12";// // dataGridViewTextBoxColumn13// this->dataGridViewTextBoxColumn13->HeaderText = L"Примечание";this->dataGridViewTextBoxColumn13->Name = L"dataGridViewTextBoxColumn13";// // button4// this->button4->Location = System::Drawing::Point(6, 318);this->button4->Name = L"button4";this->button4->Size = System::Drawing::Size(257, 23);this->button4->TabIndex = 23;this->button4->Text = L"Очистить форму поиска";this->button4->UseVisualStyleBackColor = true;this->button4->Click += gcnew System::EventHandler(this, &MyForm::button4_Click);// // groupBox4// this->groupBox4->Controls->Add(this->dateTimePicker5);this->groupBox4->Controls->Add(this->dateTimePicker4);this->groupBox4->Controls->Add(this->label23);this->groupBox4->Controls->Add(this->comboBox18);this->groupBox4->Controls->Add(this->label22);this->groupBox4->Controls->Add(this->comboBox13);this->groupBox4->Controls->Add(this->label19);this->groupBox4->Controls->Add(this->comboBox16);this->groupBox4->Controls->Add(this->label20);this->groupBox4->Controls->Add(this->label21);this->groupBox4->Location = System::Drawing::Point(6, 6);this->groupBox4->Name = L"groupBox4";this->groupBox4->Size = System::Drawing::Size(257, 296);this->groupBox4->TabIndex = 22;this->groupBox4->TabStop = false;// // dateTimePicker5// this->dateTimePicker5->Format = System::Windows::Forms::DateTimePickerFormat::Short;this->dateTimePicker5->Location = System::Drawing::Point(6, 270);this->dateTimePicker5->Name = L"dateTimePicker5";this->dateTimePicker5->Size = System::Drawing::Size(239, 20);this->dateTimePicker5->TabIndex = 31;this->dateTimePicker5->ValueChanged += gcnew System::EventHandler(this, &MyForm::comboBox13_SelectedIndexChanged);// // dateTimePicker4// this->dateTimePicker4->Format = System::Windows::Forms::DateTimePickerFormat::Short;this->dateTimePicker4->Location = System::Drawing::Point(6, 212);this->dateTimePicker4->Name = L"dateTimePicker4";this->dateTimePicker4->Size = System::Drawing::Size(239, 20);this->dateTimePicker4->TabIndex = 30;this->dateTimePicker4->Value = System::DateTime(2000, 1, 1, 0, 1, 0, 0);this->dateTimePicker4->ValueChanged += gcnew System::EventHandler(this, &MyForm::comboBox13_SelectedIndexChanged);// // label23// this->label23->AutoSize = true;this->label23->Location = System::Drawing::Point(3, 128);this->label23->Name = L"label23";this->label23->Size = System::Drawing::Size(38, 13);this->label23->TabIndex = 28;this->label23->Text = L"Акция";// // comboBox18// this->comboBox18->FormattingEnabled = true;this->comboBox18->Location = System::Drawing::Point(6, 153);this->comboBox18->Name = L"comboBox18";this->comboBox18->Size = System::Drawing::Size(239, 21);this->comboBox18->TabIndex = 29;this->comboBox18->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox13_SelectedIndexChanged);// // label22// this->label22->AutoSize = true;this->label22->Location = System::Drawing::Point(3, 244);this->label22->Name = L"label22";this->label22->Size = System::Drawing::Size(128, 13);this->label22->TabIndex = 26;this->label22->Text = L"Дата окончания поиска";// // comboBox13// this->comboBox13->FormattingEnabled = true;this->comboBox13->Location = System::Drawing::Point(6, 37);this->comboBox13->Name = L"comboBox13";this->comboBox13->Size = System::Drawing::Size(239, 21);this->comboBox13->TabIndex = 23;this->comboBox13->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox13_SelectedIndexChanged);// // label19// this->label19->AutoSize = true;this->label19->Location = System::Drawing::Point(3, 70);this->label19->Name = L"label19";this->label19->Size = System::Drawing::Size(66, 13);this->label19->TabIndex = 11;this->label19->Text = L"Вид работы";// // comboBox16// this->comboBox16->FormattingEnabled = true;this->comboBox16->Location = System::Drawing::Point(6, 95);this->comboBox16->Name = L"comboBox16";this->comboBox16->Size = System::Drawing::Size(239, 21);this->comboBox16->TabIndex = 12;this->comboBox16->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox13_SelectedIndexChanged);// // label20// this->label20->AutoSize = true;this->label20->Location = System::Drawing::Point(3, 186);this->label20->Name = L"label20";this->label20->Size = System::Drawing::Size(110, 13);this->label20->TabIndex = 17;this->label20->Text = L"Дата начала поиска";// // label21// this->label21->AutoSize = true;this->label21->Location = System::Drawing::Point(3, 12);this->label21->Name = L"label21";this->label21->Size = System::Drawing::Size(62, 13);this->label21->TabIndex = 13;this->label21->Text = L"Отделение";// // tabPage4// this->tabPage4->Controls->Add(this->button6);this->tabPage4->Controls->Add(this->button3);this->tabPage4->Controls->Add(this->dateTimePicker3);this->tabPage4->Controls->Add(this->label16);this->tabPage4->Controls->Add(this->dataGridView2);this->tabPage4->Controls->Add(this->groupBox3);this->tabPage4->Location = System::Drawing::Point(4, 22);this->tabPage4->Name = L"tabPage4";this->tabPage4->Padding = System::Windows::Forms::Padding(3);this->tabPage4->Size = System::Drawing::Size(798, 356);this->tabPage4->TabIndex = 1;this->tabPage4->Text = L"Выдача заказов";this->tabPage4->UseVisualStyleBackColor = true;this->tabPage4->Enter += gcnew System::EventHandler(this, &MyForm::button6_Click);// // button6// this->button6->Location = System::Drawing::Point(6, 262);this->button6->Name = L"button6";this->button6->Size = System::Drawing::Size(257, 34);this->button6->TabIndex = 26;this->button6->Text = L"Очистить форму поиска";this->button6->UseVisualStyleBackColor = true;this->button6->Click += gcnew System::EventHandler(this, &MyForm::button6_Click);// // button3// this->button3->BackColor = System::Drawing::Color::FromArgb(static_cast(static_cast(128)), static_cast(static_cast(255)),static_cast(static_cast(128)));this->button3->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 20.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point,static_cast(204)));this->button3->Location = System::Drawing::Point(514, 302);this->button3->Name = L"button3";this->button3->Size = System::Drawing::Size(278, 38);this->button3->TabIndex = 25;this->button3->Text = L"ВЫДАНО";this->button3->UseVisualStyleBackColor = false;this->button3->Click += gcnew System::EventHandler(this, &MyForm::button3_Click);// // dateTimePicker3// this->dateTimePicker3->Format = System::Windows::Forms::DateTimePickerFormat::Short;this->dateTimePicker3->Location = System::Drawing::Point(269, 320);this->dateTimePicker3->Name = L"dateTimePicker3";this->dateTimePicker3->Size = System::Drawing::Size(239, 20);this->dateTimePicker3->TabIndex = 24;// // label16// this->label16->AutoSize = true;this->label16->Location = System::Drawing::Point(266, 302);this->label16->Name = L"label16";this->label16->Size = System::Drawing::Size(112, 13);this->label16->TabIndex = 23;this->label16->Text = L"Дата выдачи заказа";// // dataGridView2// this->dataGridView2->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;this->dataGridView2->Columns->AddRange(gcnew cli::array< System::Windows::Forms::DataGridViewColumn^ >(11) {this->dataGridViewTextBoxColumn1,this->dataGridViewTextBoxColumn2, this->Column1, this->Column2, this->Column3, this->Column4, this->Column5, this->Column6, this->Column7,this->Column8, this->Column9});this->dataGridView2->Location = System::Drawing::Point(269, 6);this->dataGridView2->Name = L"dataGridView2";this->dataGridView2->Size = System::Drawing::Size(523, 290);this->dataGridView2->TabIndex = 22;// // dataGridViewTextBoxColumn1// this->dataGridViewTextBoxColumn1->HeaderText = L"Номер заказа";this->dataGridViewTextBoxColumn1->Name = L"dataGridViewTextBoxColumn1";// // dataGridViewTextBoxColumn2// this->dataGridViewTextBoxColumn2->HeaderText = L"ФИО заказчика";this->dataGridViewTextBoxColumn2->Name = L"dataGridViewTextBoxColumn2";// // Column1// this->Column1->HeaderText = L"Отделение";this->Column1->Name = L"Column1";// // Column2// this->Column2->HeaderText = L"Вид работы";this->Column2->Name = L"Column2";// // Column3// this->Column3->HeaderText = L"Принтер";this->Column3->Name = L"Column3";// // Column4// this->Column4->HeaderText = L"Картридж";this->Column4->Name = L"Column4";// // Column5// this->Column5->HeaderText = L"Акция";this->Column5->Name = L"Column5";// // Column6// this->Column6->HeaderText = L"Дата оформления";this->Column6->Name = L"Column6";// // Column7// this->Column7->HeaderText = L"Дата выдачи заказа";this->Column7->Name = L"Column7";// // Column8// this->Column8->HeaderText = L"Сумма";this->Column8->Name = L"Column8";// // Column9// this->Column9->HeaderText = L"Примечание";this->Column9->Name = L"Column9";// // groupBox3// this->groupBox3->Controls->Add(this->comboBox11);this->groupBox3->Controls->Add(this->comboBox10);this->groupBox3->Controls->Add(this->comboBox9);this->groupBox3->Controls->Add(this->label12);this->groupBox3->Controls->Add(this->label11);this->groupBox3->Controls->Add(this->label13);this->groupBox3->Controls->Add(this->comboBox7);this->groupBox3->Controls->Add(this->comboBox8);this->groupBox3->Controls->Add(this->label14);this->groupBox3->Controls->Add(this->label15);this->groupBox3->Location = System::Drawing::Point(6, 6);this->groupBox3->Name = L"groupBox3";this->groupBox3->Size = System::Drawing::Size(257, 235);this->groupBox3->TabIndex = 21;this->groupBox3->TabStop = false;// // comboBox11// this->comboBox11->FormatString = L"d";this->comboBox11->FormattingEnabled = true;this->comboBox11->Location = System::Drawing::Point(9, 201);this->comboBox11->Name = L"comboBox11";this->comboBox11->Size = System::Drawing::Size(239, 21);this->comboBox11->TabIndex = 24;this->comboBox11->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox7_SelectedIndexChanged);// // comboBox10// this->comboBox10->FormattingEnabled = true;this->comboBox10->Location = System::Drawing::Point(9, 33);this->comboBox10->Name = L"comboBox10";this->comboBox10->Size = System::Drawing::Size(239, 21);this->comboBox10->TabIndex = 23;this->comboBox10->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox10_SelectedIndexChanged);// // comboBox9// this->comboBox9->FormattingEnabled = true;this->comboBox9->Location = System::Drawing::Point(9, 117);this->comboBox9->Name = L"comboBox9";this->comboBox9->Size = System::Drawing::Size(239, 21);this->comboBox9->TabIndex = 21;this->comboBox9->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox7_SelectedIndexChanged);// // label12// this->label12->AutoSize = true;this->label12->Location = System::Drawing::Point(6, 100);this->label12->Name = L"label12";this->label12->Size = System::Drawing::Size(57, 13);this->label12->TabIndex = 22;this->label12->Text = L"Картридж";// // label11// this->label11->AutoSize = true;this->label11->Location = System::Drawing::Point(6, 16);this->label11->Name = L"label11";this->label11->Size = System::Drawing::Size(80, 13);this->label11->TabIndex = 20;this->label11->Text = L"Номер заказа";// // label13// this->label13->AutoSize = true;this->label13->Location = System::Drawing::Point(6, 58);this->label13->Name = L"label13";this->label13->Size = System::Drawing::Size(43, 13);this->label13->TabIndex = 11;this->label13->Text = L"Клиент";// // comboBox7// this->comboBox7->FormattingEnabled = true;this->comboBox7->Location = System::Drawing::Point(9, 75);this->comboBox7->Name = L"comboBox7";this->comboBox7->Size = System::Drawing::Size(239, 21);this->comboBox7->TabIndex = 10;this->comboBox7->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox7_SelectedIndexChanged);// // comboBox8// this->comboBox8->FormattingEnabled = true;this->comboBox8->Location = System::Drawing::Point(9, 159);this->comboBox8->Name = L"comboBox8";this->comboBox8->Size = System::Drawing::Size(239, 21);this->comboBox8->TabIndex = 12;this->comboBox8->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox7_SelectedIndexChanged);// // label14// this->label14->AutoSize = true;this->label14->Location = System::Drawing::Point(6, 184);this->label14->Name = L"label14";this->label14->Size = System::Drawing::Size(113, 13);this->label14->TabIndex = 17;this->label14->Text = L"Дата приема заказа";// // label15// this->label15->AutoSize = true;this->label15->Location = System::Drawing::Point(6, 142);this->label15->Name = L"label15";this->label15->Size = System::Drawing::Size(62, 13);this->label15->TabIndex = 13;this->label15->Text = L"Отделение";// // tabPage1// this->tabPage1->Controls->Add(this->button5);this->tabPage1->Controls->Add(this->button2);this->tabPage1->Controls->Add(this->groupBox2);this->tabPage1->Controls->Add(this->groupBox1);this->tabPage1->Location = System::Drawing::Point(4, 22);this->tabPage1->Name = L"tabPage1";this->tabPage1->Padding = System::Windows::Forms::Padding(3);this->tabPage1->Size = System::Drawing::Size(798, 356);this->tabPage1->TabIndex = 0;this->tabPage1->Text = L"Прием заказов";this->tabPage1->UseVisualStyleBackColor = true;// // button5// this->button5->Location = System::Drawing::Point(6, 272);this->button5->Name = L"button5";this->button5->Size = System::Drawing::Size(481, 34);this->button5->TabIndex = 24;this->button5->Text = L"Очистить форму поиска";this->button5->UseVisualStyleBackColor = true;this->button5->Click += gcnew System::EventHandler(this, &MyForm::button5_Click);// // button2// this->button2->BackColor = System::Drawing::Color::FromArgb(static_cast(static_cast(128)), static_cast(static_cast(255)),static_cast(static_cast(128)));this->button2->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 20.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point,static_cast(204)));this->button2->Location = System::Drawing::Point(512, 88);this->button2->Name = L"button2";this->button2->Size = System::Drawing::Size(240, 83);this->button2->TabIndex = 21;this->button2->Text = L"ОФОРМИТЬ";this->button2->UseVisualStyleBackColor = false;this->button2->Click += gcnew System::EventHandler(this, &MyForm::button2_Click);// // groupBox2// this->groupBox2->Controls->Add(this->dateTimePicker2);this->groupBox2->Controls->Add(this->label10);this->groupBox2->Controls->Add(this->label9);this->groupBox2->Controls->Add(this->textBox2);this->groupBox2->Controls->Add(this->label5);this->groupBox2->Controls->Add(this->comboBox5);this->groupBox2->Controls->Add(this->dateTimePicker1);this->groupBox2->Controls->Add(this->comboBox4);this->groupBox2->Controls->Add(this->label8);this->groupBox2->Controls->Add(this->label4);this->groupBox2->Location = System::Drawing::Point(219, 6);this->groupBox2->Name = L"groupBox2";this->groupBox2->Size = System::Drawing::Size(268, 247);this->groupBox2->TabIndex = 20;this->groupBox2->TabStop = false;// // dateTimePicker2// this->dateTimePicker2->Format = System::Windows::Forms::DateTimePickerFormat::Short;this->dateTimePicker2->Location = System::Drawing::Point(9, 123);this->dateTimePicker2->Name = L"dateTimePicker2";this->dateTimePicker2->Size = System::Drawing::Size(239, 20);this->dateTimePicker2->TabIndex = 21;this->dateTimePicker2->Visible = false;// // label10// this->label10->AutoSize = true;this->label10->Location = System::Drawing::Point(6, 104);this->label10->Name = L"label10";this->label10->Size = System::Drawing::Size(86, 13);this->label10->TabIndex = 20;this->label10->Text = L"Дата рождения";this->label10->Visible = false;// // label9// this->label9->AutoSize = true;this->label9->Location = System::Drawing::Point(6, 60);this->label9->Name = L"label9";this->label9->Size = System::Drawing::Size(34, 13);this->label9->TabIndex = 17;this->label9->Text = L"ФИО";this->label9->Visible = false;// // textBox2// this->textBox2->Location = System::Drawing::Point(9, 78);this->textBox2->Name = L"textBox2";this->textBox2->Size = System::Drawing::Size(239, 20);this->textBox2->TabIndex = 16;this->textBox2->Visible = false;// // label5// this->label5->AutoSize = true;this->label5->Location = System::Drawing::Point(6, 16);this->label5->Name = L"label5";this->label5->Size = System::Drawing::Size(43, 13);this->label5->TabIndex = 11;this->label5->Text = L"Клиент";// // comboBox5// this->comboBox5->FormattingEnabled = true;this->comboBox5->Location = System::Drawing::Point(9, 34);this->comboBox5->Name = L"comboBox5";this->comboBox5->Size = System::Drawing::Size(239, 21);this->comboBox5->TabIndex = 10;this->comboBox5->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox5_SelectedIndexChanged);// // dateTimePicker1// this->dateTimePicker1->Format = System::Windows::Forms::DateTimePickerFormat::Short;this->dateTimePicker1->Location = System::Drawing::Point(9, 211);this->dateTimePicker1->Name = L"dateTimePicker1";this->dateTimePicker1->Size = System::Drawing::Size(239, 20);this->dateTimePicker1->TabIndex = 18;// // comboBox4// this->comboBox4->FormattingEnabled = true;this->comboBox4->Location = System::Drawing::Point(9, 166);this->comboBox4->Name = L"comboBox4";this->comboBox4->Size = System::Drawing::Size(239, 21);this->comboBox4->TabIndex = 12;// // label8// this->label8->AutoSize = true;this->label8->Location = System::Drawing::Point(6, 192);this->label8->Name = L"label8";this->label8->Size = System::Drawing::Size(113, 13);this->label8->TabIndex = 17;this->label8->Text = L"Дата приема заказа";// // label4// this->label4->AutoSize = true;this->label4->Location = System::Drawing::Point(6, 148);this->label4->Name = L"label4";this->label4->Size = System::Drawing::Size(62, 13);this->label4->TabIndex = 13;this->label4->Text = L"Отделение";// // groupBox1// this->groupBox1->Controls->Add(this->label1);this->groupBox1->Controls->Add(this->comboBox1);this->groupBox1->Controls->Add(this->comboBox2);this->groupBox1->Controls->Add(this->label7);this->groupBox1->Controls->Add(this->label2);this->groupBox1->Controls->Add(this->textBox1);this->groupBox1->Controls->Add(this->comboBox3);this->groupBox1->Controls->Add(this->label3);this->groupBox1->Controls->Add(this->comboBox6);this->groupBox1->Controls->Add(this->label6);this->groupBox1->Location = System::Drawing::Point(6, 6);this->groupBox1->Name = L"groupBox1";this->groupBox1->Size = System::Drawing::Size(194, 247);this->groupBox1->TabIndex = 19;this->groupBox1->TabStop = false;// // label1// this->label1->AutoSize = true;this->label1->Location = System::Drawing::Point(6, 16);this->label1->Name = L"label1";this->label1->Size = System::Drawing::Size(50, 13);this->label1->TabIndex = 3;this->label1->Text = L"Принтер";// // comboBox1// this->comboBox1->FormattingEnabled = true;this->comboBox1->Location = System::Drawing::Point(9, 34);this->comboBox1->Name = L"comboBox1";this->comboBox1->Size = System::Drawing::Size(169, 21);this->comboBox1->TabIndex = 2;this->comboBox1->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox1_SelectedIndexChanged);// // comboBox2// this->comboBox2->FormattingEnabled = true;this->comboBox2->Location = System::Drawing::Point(9, 78);this->comboBox2->Name = L"comboBox2";this->comboBox2->Size = System::Drawing::Size(169, 21);this->comboBox2->TabIndex = 4;this->comboBox2->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox2_SelectedIndexChanged);// // label7// this->label7->AutoSize = true;this->label7->Location = System::Drawing::Point(6, 192);this->label7->Name = L"label7";this->label7->Size = System::Drawing::Size(62, 13);this->label7->TabIndex = 15;this->label7->Text = L"Стоимость";// // label2// this->label2->AutoSize = true;this->label2->Location = System::Drawing::Point(6, 60);this->label2->Name = L"label2";this->label2->Size = System::Drawing::Size(57, 13);this->label2->TabIndex = 5;this->label2->Text = L"Картридж";// // textBox1// this->textBox1->Location = System::Drawing::Point(9, 210);this->textBox1->Name = L"textBox1";this->textBox1->Size = System::Drawing::Size(169, 20);this->textBox1->TabIndex = 14;// // comboBox3// this->comboBox3->FormattingEnabled = true;this->comboBox3->Location = System::Drawing::Point(9, 122);this->comboBox3->Name = L"comboBox3";this->comboBox3->Size = System::Drawing::Size(169, 21);this->comboBox3->TabIndex = 6;this->comboBox3->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox3_SelectedIndexChanged);// // label3// this->label3->AutoSize = true;this->label3->Location = System::Drawing::Point(6, 104);this->label3->Name = L"label3";this->label3->Size = System::Drawing::Size(66, 13);this->label3->TabIndex = 7;this->label3->Text = L"Вид работы";// // comboBox6// this->comboBox6->FormattingEnabled = true;this->comboBox6->Location = System::Drawing::Point(9, 166);this->comboBox6->Name = L"comboBox6";this->comboBox6->Size = System::Drawing::Size(169, 21);this->comboBox6->TabIndex = 8;this->comboBox6->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox3_SelectedIndexChanged);// // label6// this->label6->AutoSize = true;this->label6->Location = System::Drawing::Point(6, 148);this->label6->Name = L"label6";this->label6->Size = System::Drawing::Size(38, 13);this->label6->TabIndex = 9;this->label6->Text = L"Акции";// // tabControl1// this->tabControl1->Controls->Add(this->tabPage1);this->tabControl1->Controls->Add(this->tabPage4);this->tabControl1->Controls->Add(this->tabPage3);this->tabControl1->Location = System::Drawing::Point(12, 12);this->tabControl1->Name = L"tabControl1";this->tabControl1->SelectedIndex = 0;this->tabControl1->Size = System::Drawing::Size(806, 382);this->tabControl1->TabIndex = 3;// // MyForm// this->AutoScaleDimensions = System::Drawing::SizeF(6, 13);this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;this->ClientSize = System::Drawing::Size(821, 398);this->Controls->Add(this->tabControl1);this->MaximizeBox = false;this->Name = L"MyForm";this->StartPosition = System::Windows::Forms::FormStartPosition::CenterScreen;this->Text = L"Автоматизации учёта заправки картдриждей \"ПиринтСервис\" г.Н.Новгород";this->Load += gcnew System::EventHandler(this, &MyForm::MyForm_Load);this->tabPage3->ResumeLayout(false);(cli::safe_cast(this->dataGridView1))->EndInit();this->groupBox4->ResumeLayout(false);this->groupBox4->PerformLayout();this->tabPage4->ResumeLayout(false);this->tabPage4->PerformLayout();(cli::safe_cast(this->dataGridView2))->EndInit();this->groupBox3->ResumeLayout(false);this->groupBox3->PerformLayout();this->tabPage1->ResumeLayout(false);this->groupBox2->ResumeLayout(false);this->groupBox2->PerformLayout();this->groupBox1->ResumeLayout(false);this->groupBox1->PerformLayout();this->tabControl1->ResumeLayout(false);this->ResumeLayout(false);}#pragma endregionprivate: System::Void MyForm_Load(System::Object^ sender, System::EventArgs^ e);private: System::Void button5_Click(System::Object^ sender, System::EventArgs^ e);private: System::Void comboBox1_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e);private: System::Void comboBox2_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e);private: System::Void comboBox3_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e);private: System::Void comboBox5_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e);private: System::Void button2_Click(System::Object^ sender, System::EventArgs^ e);private: System::Void button6_Click(System::Object^ sender, System::EventArgs^ e);private: System::Void comboBox10_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e);private: System::Void comboBox7_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e);private: System::Void button3_Click(System::Object^ sender, System::EventArgs^ e);private: System::Void button4_Click(System::Object^ sender, System::EventArgs^ e);private: System::Void comboBox13_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e);};}

1) Бондаренко, И. С. Базы данных : создание баз данных в среде SQL Server : лабораторный практикум / И. С. Бондаренко. - Москва : Изд. Дом НИТУ «МИСиС», 2019. - 39 с. - Текст : электронный. - URL: https://znanium.com/catalog/product/1232752 (дата обращения: 19.02.2022).
2) Фиайли, К. SQL [Электронный ресурс] / К. Фиайли; Пер. с англ. - Москва : ДМК Пресс, 2008. - 451 с.: ил. - (Серия «Quick Start»). - ISBN 5-94074- 233-5. - Текст : электронный. - URL: https://znanium.com/catalog/product/408817 (дата обращения: 20.02.2022).
3) Уорд, Б. Инновации SQL Server 2019. Использование технологий больших данных и машинного обучения / Боб Уорд ; пер. с англ. Н. Б. Желновой. - Москва : ДМК Пресс, 2020. - 408 с. - ISBN 978-5-97060-595-0. - Текст : электронный. - URL: https://znanium.com/catalog/product/1225362 (дата обращения: 25.02.2022).
4) Иванова Г. С. И 201 Технология программирования: Учебник для вузов. – М.: Изд-во МГТУ им. Н.Э. Баумана, 2002. – 320 с.: ил. (Сер. Информатика в технической университете)
5) Голицына О.Л., Попов И.И. Г 60 Программирование на языках высокого уровня: учебное пособие/ О.Л. Голицына, И.И. Попов. – М.: ФОРУМ, 2010. – 496 с.: ил. – (Профессиональное образование)