97
Приложение 7
Программный код добавления записей в таблицу «Арендованные
автомобили»(RentedAdd.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;
using System.Data.OleDb;
namespaceАИС_Учёт_2
{
///<summary>
///</summary>
publicpartialclassRentedAdd : Window
{
publicRentedAdd()
{
InitializeComponent();
}
privatevoid Window_Loaded(object sender, RoutedEventArgs e)
{
АИС_Учёт_2.DBDataSet dBDataSet =
((АИС_Учёт_2.DBDataSet)(this.FindResource("dBDataSet")));
АИС_Учёт_2.DBDataSetTableAdapters.КлиентыTableAdapter dBDataSetКлиентыTableAdapter =
newАИС_Учёт_2.DBDataSetTableAdapters.КлиентыTableAdapter();
dBDataSetКлиентыTableAdapter.Fill(dBDataSet.Клиенты);
System.Windows.Data.CollectionViewSource клиентыViewSource =
((System.Windows.Data.CollectionViewSource)(this.FindResource("клиентыViewSource")));
клиентыViewSource.View.MoveCurrentToFirst();
АИС_Учёт_2.DBDataSet1 dBDataSet1 =
((АИС_Учёт_2.DBDataSet1)(this.FindResource("dBDataSet1")));
АИС_Учёт_2.DBDataSet1TableAdapters.АвтомобилиTableAdapter
dBDataSet1АвтомобилиTableAdapter =
newАИС_Учёт_2.DBDataSet1TableAdapters.АвтомобилиTableAdapter();
dBDataSet1АвтомобилиTableAdapter.Fill(dBDataSet1.Автомобили);
System.Windows.Data.CollectionViewSource автомобилиViewSource =
((System.Windows.Data.CollectionViewSource)(this.FindResource("автомобилиViewSource")));
автомобилиViewSource.View.MoveCurrentToFirst();
АИС_Учёт_2.DBDataSet1TableAdapters.Условия_арендыTableAdapter
dBDataSet1Условия_арендыTableAdapter =
newАИС_Учёт_2.DBDataSet1TableAdapters.Условия_арендыTableAdapter();
dBDataSet1Условия_арендыTableAdapter.Fill(dBDataSet1.Условия_аренды);
System.Windows.Data.CollectionViewSource условия_арендыViewSource =
((System.Windows.Data.CollectionViewSource)(this.FindResource("условия_арендыViewSource")
));
условия_арендыViewSource.View.MoveCurrentToFirst();
}
98
privatevoid Back_Click(object sender, RoutedEventArgs e)
{
this.Close();
}
publicvoid Add_Click(object sender, RoutedEventArgs e)
{
Cars main = this.Owner as Cars;
if (main != null)
{
int ic = main.RentGrid.Items.Count + 1;
main.RentGrid.Items.Add(new { Id_аренды = ic, ID_клиента = ClID.Text,
ID_авто = CarID.Text, Код_договора = RentId.Text, Сумма = Cost.Text });
this.Close();
}
}
}
}
99
Приложение 8
Вид добавления записей в таблицу «Арендованные
автомобили»(RentedAdd.xaml)
<Window x:Class="АИС_Учёт_2.RentedAdd"
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="Добавитьзапись" Loaded="Window_Loaded" Height="323.606" Width="320.181">
<Window.Resources>
<local:DBDataSet x:Key="dBDataSet"/>
<CollectionViewSource x:Key="клиентыViewSource" Source="{BindingКлиенты,
Source={StaticResource dBDataSet}}"/>
<local:DBDataSet1 x:Key="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}">
<GroupBox Header="Добавлениезаписи" HorizontalAlignment="Left" Height="283"
Margin="10,0,0,0" VerticalAlignment="Top" Width="292">
</GroupBox>
<Label Content="Клиент:" HorizontalAlignment="Left" VerticalAlignment="Top"
Margin="193,23,0,0" Height="23"/>
<Label Content="Автомобиль:" HorizontalAlignment="Left" Margin="181,73,0,0"
VerticalAlignment="Top"/>
<Label Content="Договораренды:" HorizontalAlignment="Left" VerticalAlignment="Top"
Margin="168,123,0,0"/>
<Label Content="Сумма:" HorizontalAlignment="Left" VerticalAlignment="Top"
Margin="130,181,0,0"/>
<ComboBox x:Name="Clients" HorizontalAlignment="Left" VerticalAlignment="Top" Width="120"
Margin="160,46,0,0" Height="22" ItemsSource="{Binding}" SelectedValuePath="ID клиента">
<ComboBox.ItemTemplate>
<DataTemplate>
<TextBlock>
<TextBlock.Text>
<MultiBinding StringFormat="{}{0} {1}">
<Binding Path="Фамилия"/>
<Binding Path="Имя"/>
</MultiBinding>
</TextBlock.Text>
</TextBlock>
</DataTemplate>
</ComboBox.ItemTemplate>
</ComboBox>
<ComboBox x:Name="Car" HorizontalAlignment="Left" VerticalAlignment="Top" Width="120"
Margin="160,96,0,0" ItemsSource="{Binding Source={StaticResourceавтомобилиViewSource}}"
SelectedValuePath="ID автомобиля">
<ComboBox.ItemTemplate>
<DataTemplate>
<TextBlock>
<TextBlock.Text>
<MultiBinding StringFormat="{}{0} {1} {2}">
<Binding Path="Марка"/>
<Binding Path="Модель"/>
<Binding Path="Стоимость 1 суток"/>
</MultiBinding>
100
</TextBlock.Text>
</TextBlock>
</DataTemplate>
</ComboBox.ItemTemplate>
</ComboBox>
<ComboBox x:Name="Term" HorizontalAlignment="Left" VerticalAlignment="Top" Width="120"
Margin="160,149,0,0" ItemsSource="{Binding
Source={StaticResourceусловия_арендыViewSource}}" SelectedValuePath="Коддоговора">
<ComboBox.ItemTemplate>
<DataTemplate>
<TextBlock>
<TextBlock.Text>
<MultiBinding StringFormat="{}{0} {1}">
<Binding Path="Датавыдачи"/>
<Binding Path="Дата конца аренды"/>
</MultiBinding>
</TextBlock.Text>
</TextBlock>
</DataTemplate>
</ComboBox.ItemTemplate>
</ComboBox>
<TextBox x:Name="Cost" HorizontalAlignment="Left" Height="23" TextWrapping="Wrap"
VerticalAlignment="Top" Width="120" Margin="93,207,0,0"/>
<Button x:Name="Add" Content="Добавить" HorizontalAlignment="Left"
VerticalAlignment="Top" Width="76" Margin="46,261,0,0" Click="Add_Click"/>
<Button x:Name="Back" Content="Назад" HorizontalAlignment="Left" VerticalAlignment="Top"
Width="75" Margin="205,261,0,0" Click="Back_Click"/>
<TextBox x:Name="ClID" HorizontalAlignment="Left" Height="22" TextWrapping="Wrap"
Text="{Binding ElementName=Clients, Path=SelectedValue}" VerticalAlignment="Top"
Width="120" IsReadOnly="True" Margin="17,46,0,0"/>
<Label Content="ID клиента:" HorizontalAlignment="Left" VerticalAlignment="Top"
Margin="34,23,0,0"/>
<TextBox x:Name="CarID" HorizontalAlignment="Left" Height="22" TextWrapping="Wrap"
Text="{Binding ElementName=Car, Path=SelectedValue}" VerticalAlignment="Top" Width="120"
Margin="17,96,0,0"/>
<Label Content="ID авто:" HorizontalAlignment="Left" VerticalAlignment="Top"
Margin="46,70,0,0"/>
<TextBox x:Name="RentId" HorizontalAlignment="Left" Height="23" TextWrapping="Wrap"
Text="{Binding ElementName=Term, Path=SelectedValue}" VerticalAlignment="Top" Width="120"
Margin="17,149,0,0"/>
<Label Content="Коддоговора" HorizontalAlignment="Left" VerticalAlignment="Top"
Margin="34,123,0,0"/>
</Grid>
</Window>