Дипломная работа: Автоматизация продажи авиабилетов ООО «Аэропорт Грабцево»

Скачать файл

Заказать новую работу

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам

112

Private Sub AviacompaniyaLabel_Click(sender As Object, e As EventArgs)

End Sub

Private Sub RaspisanieDataGridView_CellContentClick(sender As Object, e

As DataGridViewCellEventArgs) Handles

RaspisanieDataGridView.CellContentClick

End Sub

Private Sub BiletyDataGridView_CellContentClick(sender As Object, e As

DataGridViewCellEventArgs) Handles BiletyDataGridView.CellContentClick

End Sub

Private Sub __reysaLabel_Click(sender As Object, e As EventArgs)

End Sub

Private Sub __reysaTextBox_TextChanged(sender As Object, e As

EventArgs) Handles __reysaTextBox.TextChanged

End Sub

End Class

internal class Resources

private static System.Resources.ResourceManager resourceMan;

private static CultureInfo resourceCulture;

internal Resources()

[EditorBrowsable(EditorBrowsableState.Advanced)]

internal static System.Resources.ResourceManager ResourceManager

get

if (ReferenceEquals(resourceMan, null))

resourceMan = new

System.Resources.ResourceManager("Airport.Properties.Resources",

typeof(Resources).Assembly);

return resourceMan;

[EditorBrowsable(EditorBrowsableState.Advanced)]

internal static CultureInfo Culture

get =>

113

resourceCulture;

set =>

(resourceCulture = value);

internal static Bitmap logo3 =>

((Bitmap) ResourceManager.GetObject("logo3", resourceCulture));

internal static Bitmap password =>

((Bitmap) ResourceManager.GetObject("password", resourceCulture));

internal OleDbConnection Connection

get

if (ReferenceEquals(this._connection, null))

this.InitConnection();

return this._connection;

set

this._connection = value;

if (!ReferenceEquals(this.Adapter.InsertCommand, null))

this.Adapter.InsertCommand.Connection = value;

if (!ReferenceEquals(this.Adapter.DeleteCommand, null))

this.Adapter.DeleteCommand.Connection = value;

if (!ReferenceEquals(this.Adapter.UpdateCommand, null))

this.Adapter.UpdateCommand.Connection = value;

for (int i = 0; i < this.CommandCollection.Length; i++)

if (!ReferenceEquals(this.CommandCollection[i], null))

this.CommandCollection[i].Connection = value;

114

namespace Airport

using Airport.AirportBD1DataSetTableAdapters;

using Airport.Properties;

using System;

using System.ComponentModel;

using System.Drawing;

using System.Windows.Forms;

public class KovrovoAir : Form

private IContainer components = null;

private Button button1;

private Button button2;

private TextBox User;

private TextBox Pass;

private Label label1;

private Label label2;

private AviacompaniyaTableAdapter aviacompaniyaTableAdapter1;

public KovrovoAir()

this.InitializeComponent();

private void button1_Click(object sender, EventArgs e)

if (this.User.Text != "admin")

MessageBox.Show("Неверный логин или пароль!");

else if (this.Pass.Text == "admin")

new Form1().Show();

else

115

MessageBox.Show("Неверный логин или пароль!");

private void button2_Click(object sender, EventArgs e)

new PasPas().Show();

protected override void Dispose(bool disposing)

if (!(!disposing || ReferenceEquals(this.components, null)))

this.components.Dispose();

base.Dispose(disposing);

CREATE TABLE dolzhnost (

ID INTEGER AUTO INCREMENT NOT NULL,

Name char(18) NOT NULL,

Zarplata value NOT NULL,

Obyazanosti char(150) NOT NULL)

ALTER TABLE dolzhnost ADD PRIMARY KEY (ID)

CREATE TABLE Otdely (

N_otdela INTEGER AUTO INCREMENT NOT NULL,

Name char(18) NOT NULL,

Familia_nachalnika char(30) NOT NULL,

Imya_nachalnika char(30) NOT NULL,

Otchestvo_nachalnika char(30))

ALTER TABLE Otdely ADD PRIMARY KEY (N_otdela)

CREATE TABLE Rabotniki (

N_TrudKnizhki char(23) NOT NULL,

ID_pola char(1) NOT NULL,

ID_dolznosti char(18) NOT NULL,

N_otdela char(18)NOT NULL,

Familia char(30) NOT NULL,

116

Imya char(30) NOT NULL,

Otchestvo char(40),

N_pasporta char(10) NOT NULL)

ALTER TABLE Rabotniki ADD PRIMARY KEY (N_TrudKnizhki,

N_pasporta),

FOREIGN KEY (ID_pola, ID_dolznosti, N_otdela)

CREATE TABLE Brigady (

N_brigady INTEGER AUTO INCREMENT NOT NULL,

Name char(18) NULL,

N_otdela char(18)NOT NULL)

ALTER TABLE Brigady ADD PRIMARY KEY (N_brigady)

FOREIGN KEY (N_otdela)

CREATE TABLE Samolety (

N_samoleta char(8)NOT NULL,

ID_modeli integer(18) NOT NULL,

N_brigady char(18) NOT NULL,

ID_aviacompanii integer(4) NOT NULL,

Data_sborki datetime NOT NULL)

ALTER TABLE Samolety ADD PRIMARY KEY (N_samoleta),

FOREIGN KEY (ID_modeli, ID_aviacompanii, N_brigady)

CREATE TABLE Model_samoleta (

ID INTEGER AUTO INCREMENT NOT NULL,

Naimenovanie char(18) NOT NULL,

Vmestimost char(18) NOT NULL,

ID_tipa char(18) NOT NULL,

ID_strany char(18) NOT NULL)

ALTER TABLE Model_samoleta ADD PRIMARY KEY (ID),

Источник: https://baza.diplomsite.ru/previewfile/326

Смотрите также:






Изложение содержания дела, по которому приняты судебные постановления
_-___-~1
_1-тема-СтрМетал
_1966(~1
_files_materials_5053_prog.ntr