87
MessageBox.Show("Дляпользователя \"Директор\" введенневерныйпароль!",
"Неверныйпароль", MessageBoxButton.OK, MessageBoxImage.Error);
}
elseif (UsList.Text == "Менеджер"&& Pass.Password == "34561")
{
Window1 taskWindow = new Window1();
taskWindow.User.Text = "Менеджер";
taskWindow.Show();
this.Close();
}
elseif (UsList.Text == "Менеджер"&& Pass.Password != "34561")
{
MessageBox.Show("Дляпользователя \"Менеджер\" введенневерныйпароль!",
"Неверныйпароль", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
MessageBox.Show("Что-то пошло не так! Доложите об этом разработчику
системы", "Неизвестная ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}
88
Приложение 2
Вид формы авторизации(MainWindow.xaml)
<Window x:Class="АИС_Учёт_2.MainWindow"
x:Name="Win"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:АИС_Учёт_2"
mc:Ignorable="d"
Title="Авторизация" Height="262.666" Width="396.262">
<Grid HorizontalAlignment="Left" Margin="0,0,-2,-2" Width="390" Background="#FFEAEAEA">
<Canvas HorizontalAlignment="Left" Height="38" VerticalAlignment="Top" Width="390"
Background="#FFCBABAB"/>
<TextBlock HorizontalAlignment="Left" Margin="19,10,0,0" TextWrapping="Wrap"
Text="Авторизация" VerticalAlignment="Top"/>
<Label Content="Выберитепользователя:" HorizontalAlignment="Left" Margin="124,48,0,0"
VerticalAlignment="Top" Width="147"/>
<Label Content="Введитепароль:" HorizontalAlignment="Left" Margin="146,100,0,0"
VerticalAlignment="Top"/>
<Button x:Name="Login" Content="Авторизоваться" HorizontalAlignment="Left"
Margin="146,179,0,0" VerticalAlignment="Top" Width="100" Click="Login_Click"/>
<PasswordBox x:Name="Pass" HorizontalAlignment="Left" Margin="124,131,0,0"
VerticalAlignment="Top" Width="147"/>
<ComboBox x:Name="UsList" HorizontalAlignment="Left" Margin="126,79,0,0"
VerticalAlignment="Top" Width="145">
<TextBlock>ДиректорTextBlock>
<TextBlock>МенеджерTextBlock>
</ComboBox>
<TextBlock x:Name="Forgot" MouseLeftButtonUp="Forgot_MouseLeftButtonUp" Cursor="Hand"
HorizontalAlignment="Left" Margin="276,134,0,0" TextWrapping="Wrap" Text="Забылипароль?"
VerticalAlignment="Top" Width="108" FontFamily="Arial" FontSize="10"
Foreground="{DynamicResource {x:Static SystemColors.HotTrackBrushKey}}"
TextDecorations="Underline"/>
</Grid>
</Window>
89
Приложение 3
Программный код главного меню(Window1.cs)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using System.Windows.Navigation;
namespaceАИС_Учёт_2
{
///<summary>
///Логикавзаимодействиядля Window1.xaml
///</summary>
publicpartialclassWindow1 : Window
{
publicWindow1()
{
InitializeComponent();
}
privatevoid Query_Click(object sender, RoutedEventArgs e)
{
Queries taskWindow = new Queries();
taskWindow.Owner = this;
taskWindow.Show();
}
privatevoid Tabl_Click(object sender, RoutedEventArgs e)
{
Cars taskWindow = new Cars();
taskWindow.Owner = this;
taskWindow.Show();
}
privatevoid Help_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
}
privatevoid Docs_Click(object sender, RoutedEventArgs e)
{
Info taskWindow = new Info();
taskWindow.Owner = this;
taskWindow.Show();
}
privatevoid Hpage_Click(object sender, RoutedEventArgs e)
{
90
MessageBox.Show("Этоглавноеменю, здесьвыможетевыбратьнужнуювамкатегорию.",
"Справкаоглавномменю", MessageBoxButton.OK, MessageBoxImage.Question);
}
privatevoid Exit_Click(object sender, RoutedEventArgs e)
{
this.Close();
}
privatevoid Change_Click(object sender, RoutedEventArgs e)
{
MainWindow taskWindow = new MainWindow();
taskWindow.Show();
this.Close();
}
}
}
91
Приложение 4
Вид главного меню(Window1.xaml)
<Window x:Class="АИС_Учёт_2.Window1"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:АИС_Учёт_2"
mc:Ignorable="d"
Title="Меню" Height="358" Width="322">
<Grid Background="{DynamicResource {x:Static SystemColors.AppWorkspaceBrushKey}}"
Margin="0,0,3,0">
<Grid.ColumnDefinitions>
<ColumnDefinition Width="Auto"/>
<ColumnDefinition/>
</Grid.ColumnDefinitions>
<Canvas Height="75" VerticalAlignment="Top" Grid.ColumnSpan="2"
Background="{DynamicResource {x:Static SystemColors.WindowFrameBrushKey}}"
Margin="0,18,0,0">
<Label Content="Менюсистемы" Canvas.Left="10" FontFamily="Segoe UI Black" FontSize="36"
Height="65" Width="294"/>
</Canvas>
<Button x:Name="Tabl" Content="Аренда" Margin="108,119,105,180" Click="Tabl_Click"
Grid.Column="1"/>
<Button x:Name="Query" Content="Списки" Margin="108,162,105,137" Click="Query_Click"
Grid.Column="1"/>
<Button x:Name="Docs" Content="Информация" Margin="108,205,105,94" Grid.Column="1"
Click="Docs_Click"/>
<Button x:Name="Exit" Content="Выход" Margin="108,288,105,11" Grid.Column="1"
Click="Exit_Click"/>
<TextBlock Grid.Column="1" HorizontalAlignment="Left" Margin="86,98,0,0"
TextWrapping="Wrap" Text="Вывошликак" VerticalAlignment="Top"/>
<Menu Grid.ColumnSpan="2" Height="18" VerticalAlignment="Top"
Background="{DynamicResource {x:Static SystemColors.ControlLightBrushKey}}"
HorizontalAlignment="Left" Width="314" Margin="0,0,-3,0">
<MenuItem Header="Опции">
<MenuItem x:Name="Change" Click="Change_Click" Header="Сменитьпользователя"></MenuItem>
</MenuItem>
<MenuItem Header="Помощь">
<MenuItem x:Name="Hpage" Click="Hpage_Click"
Header="Получитьсправкуостранице"></MenuItem>
</MenuItem>
</Menu>
<TextBlock x:Name="User" Grid.Column="1" HorizontalAlignment="Left" Text=""
Margin="167,98,0,0" TextWrapping="Wrap" VerticalAlignment="Top"/>
</Grid>
</Window>
92
Приложение 5
Программный код общей формы таблиц в категории «Аренда»(Cars.cs)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using System.Data.OleDb;
using System.Data;
namespaceАИС_Учёт_2
{
///<summary>
///</summary>
publicpartialclassCars : Window
{
publicCars()
{
InitializeComponent();
}
privatevoid Change_Click(object sender, RoutedEventArgs e)
{
MainWindow taskWindow = new MainWindow();
taskWindow.Show();
this.Close();
}
privatevoid Hpage_Click(object sender, RoutedEventArgs e)
{
MessageBox.Show("Этоменюсправочников,
здесьвыможетевыбратьнужныйвамсправочник.", "Справкаосправочниках", MessageBoxButton.OK,
MessageBoxImage.Question);
}
privatevoid File_Click(object sender, RoutedEventArgs e)
{
this.Close();
}
publicvoid Tab_SelectionChanged(object sender, RoutedEventArgs e)
{
if (RentedC.IsSelected)
{
OleDbConnection con = new
OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.16.0;Data
Source=C:\Users\username\Desktop\Project\DB.accdb");
con.Open();
93
OleDbDataAdapter da = new OleDbDataAdapter("select * from
`арендованныеавтомобили`", con);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "арендованныеавтомобили");
RentGrid.ItemsSource = ds.Tables["арендованныеавтомобили"].DefaultView;
con.Close();
}
elseif (SupplyC.IsSelected)
{
OleDbConnection con = new
OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.16.0;Data
Source=C:\Users\username\Desktop\Project\DB.accdb");
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from `поставки`",
con);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "поставки");
SuppGrid.ItemsSource = ds.Tables["поставки"].DefaultView;
con.Close();
}
elseif (BodyC.IsSelected)
{
OleDbConnection con = new
OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.16.0;Data
Source=C:\Users\username\Desktop\Project\DB.accdb");
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from
`типавтомобиля`", con);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "типавтомобиля");
BodyGrid.ItemsSource = ds.Tables["типавтомобиля"].DefaultView;
con.Close();
}
elseif (DiscC.IsSelected)
{
OleDbConnection con = new
OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.16.0;Data
Source=C:\Users\username\Desktop\Project\DB.accdb");
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from `скидки`",
con);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "скидки");
DiscGrid.ItemsSource = ds.Tables["скидки"].DefaultView;
con.Close();
94
}
}
privatevoid Add_Click(object sender, RoutedEventArgs e)
{
Window1 main = this.Owner as Window1;
if (RentedC.IsSelected && main.User.Text != "Бухгалтер")
{
RentedAdd taskWindow = new RentedAdd();
taskWindow.Show();
taskWindow.Owner = this;
}
elseif (SupplyC.IsSelected && main.User.Text != "Менеджер")
{
Sup taskWindow = new Sup();
taskWindow.Show();
taskWindow.Owner = this;
}
elseif (BodyC.IsSelected && main.User.Text == "Директор")
{
Bod taskWindow = new Bod();
taskWindow.Show();
taskWindow.Owner = this;
}
elseif (DiscC.IsSelected && main.User.Text != "Бухгалтер")
{
DiscAdd taskWindow = new DiscAdd();
taskWindow.Show();
taskWindow.Owner = this;
}
else
{
MessageBox.Show("Доступавторизованномупользователюзапрещён",
"Доступзапрещён", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
privatevoid Delete_Click(object sender, RoutedEventArgs e)
{
var Rent = RentGrid.SelectedItem;
var Supp = SuppGrid.SelectedItem;
var Body = BodyGrid.SelectedItem;
var Disc = DiscGrid.SelectedItem;
if (Rent != null)
{
RentGrid.Items.Remove(Rent);
}
elseif (Supp != null)
{
SuppGrid.Items.Remove(Supp);
}
elseif (Body != null)
{
BodyGrid.Items.Remove(Body);
}
elseif (Disc != null)
{
DiscGrid.Items.Remove(Disc);
}
else
95
{
MessageBox.Show("Выничегоневыбрали", "Ошибка", MessageBoxButton.OK,
MessageBoxImage.Error);
}
}
publicvoid Save_Click(object sender, RoutedEventArgs e)
{
}
privatevoid RentGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
}
}
}
96
Приложение 6
Вид категории «Аренда»(Cars.xaml)
<Window x:Class="АИС_Учёт_2.Cars"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:АИС_Учёт_2"
mc:Ignorable="d"
Title="Аренда" Height="357" Width="828">
<Window.Resources>
<local:DBDataSet1 x:Key="dBDataSet1"/>
<CollectionViewSource x:Key="арендованные_автомобилиViewSource"
Source="{BindingАрендованные_автомобили, Source={StaticResource dBDataSet1}}"/>
<CollectionViewSource x:Key="поставкиViewSource" Source="{BindingПоставки,
Source={StaticResource dBDataSet1}}"/>
<CollectionViewSource x:Key="тип_автомобиляViewSource" Source="{BindingТип_автомобиля,
Source={StaticResource dBDataSet1}}"/>
<CollectionViewSource x:Key="скидкиViewSource" Source="{BindingСкидки,
Source={StaticResource dBDataSet1}}"/>
</Window.Resources>
<Grid DataContext="{StaticResourceарендованные_автомобилиViewSource}">
<Menu Height="17" VerticalAlignment="Top">
<MenuItem Header="Файл">
<MenuItem x:Name="File" Click="File_Click" Header="Закрытьокно"></MenuItem>
</MenuItem>
<MenuItem Header="Опции">
<MenuItem x:Name="Change" Click="Change_Click" Header="Сменитьпользователя"></MenuItem>
</MenuItem>
<MenuItem Header="Помощь">
<MenuItem x:Name="Hpage" Click="Hpage_Click"
Header="Получитьсправкуостранице"></MenuItem>
</MenuItem>
</Menu>
<TabControl x:Name="Tab" SelectionChanged="Tab_SelectionChanged" Height="274"
Margin="0,17,0,0" VerticalAlignment="Top" HorizontalAlignment="Left" Width="730">
<TabItem x:Name="RentedC" Header="Арендованныеавтомобили">
<DataGrid x:Name="RentGrid" HorizontalAlignment="Left" Height="241" Margin="0,5,-3,-2"
VerticalAlignment="Top" Width="727"/>
</TabItem>
<TabItem x:Name="SupplyC" Header="Поставки">
<DataGrid x:Name="SuppGrid">
</DataGrid>
</TabItem>
<TabItem x:Name="BodyC" Header="Типавтомобиля" Height="22" VerticalAlignment="Bottom">
<DataGrid x:Name="BodyGrid">
</DataGrid>
</TabItem>
<TabItem x:Name="DiscC" Header="Скидки">
<DataGrid x:Name="DiscGrid" HorizontalAlignment="Left" Width="725" Margin="0,0,-1,0">
</DataGrid>
</TabItem>
</TabControl>
<Button x:Name="Add" Content="Добавить" Click="Add_Click" HorizontalAlignment="Left"
Margin="735,41,0,0" VerticalAlignment="Top" Width="75"/>
<Button x:Name="Delete" Content="Удалить" Click="Delete_Click" HorizontalAlignment="Left"
Margin="735,66,0,0" VerticalAlignment="Top" Width="75"/>
<Button x:Name="Save" Content="Сохранить" Click="Save_Click" HorizontalAlignment="Left"
Margin="735,91,0,0" VerticalAlignment="Top" Width="75"/>
</Grid>
</Window>