powershell-使用WPF填充数据网格并添加复选框以应用过滤器

postanote 2020-11-29 08:50:51

我没有尝试使用SQL的环境，但是数据就是数据。

因此，这是一个利用Datagrid的简单WPF示例，其中复选框通过PowerShell执行。它加载表单，等待按钮单击，然后在Datagrid中填充数据以及已选中和未选中的复选框。

Function Show-DataGrid 
{
[xml]$XAML = @"
<Window xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
  Title="Services List" Height="261.541" Width="423.299" ResizeMode="NoResize" BorderBrush="Black" Background="White">
    <Window.Effect>
        <DropShadowEffect/>
    </Window.Effect>
    <Grid>
        <DataGrid Name="dataGrid" AutoGenerateColumns="False" AlternationCount="1" SelectionMode="Single" IsReadOnly="True" HeadersVisibility="Column" Margin="10,32,10,10" AlternatingRowBackground="#FFD8D8D8" CanUserResizeRows="False" >
            <DataGrid.Columns>
                <DataGridCheckBoxColumn Binding="{Binding checkboxChecked, UpdateSourceTrigger=PropertyChanged}">
                    <DataGridCheckBoxColumn.ElementStyle>
                        <Style TargetType="CheckBox"/>
                    </DataGridCheckBoxColumn.ElementStyle>
                </DataGridCheckBoxColumn>
                <DataGridTextColumn Header="Common Name" Width="125" Binding="{Binding CName}"/>
                <DataGridTextColumn Header="Service Name" Width="125" Binding="{Binding SName}"/>
                <DataGridTextColumn Header="Current Status" Width="125"  Binding="{Binding Status}"/>
            </DataGrid.Columns>
        </DataGrid>
        <Button Name="GenerateButton" Content="Generate" HorizontalAlignment="Left" Margin="10,7,0,0" VerticalAlignment="Top" Width="75"/>
    </Grid>
</Window>
"@
    
Add-Type -AssemblyName  System.Drawing,
                        PresentationCore,
                        PresentationFramework,
                        System.Windows.Forms,
                        microsoft.VisualBasic
[System.Windows.Forms.Application]::EnableVisualStyles()

$reader = (New-Object System.Xml.XmlNodeReader $xaml)
$Form   = [Windows.Markup.XamlReader]::Load( $reader )

$xaml.SelectNodes("//*[@Name]") | 
ForEach-Object {Set-Variable -Name "WPF_$($_.Name)" -Value $Form.FindName($_.Name) -Scope Script}

$CurrServices = Get-Service | 
                Select DisplayName, Name, StartType

[System.Collections.ArrayList]$CBNameList = @()

$WPF_GenerateButton.Add_Click(
{ 
$DataGridList = @"
checkboxChecked,CName,SName,Status
$true,Test,Checked,Checked
$true,Test 2,Checked 2,Checked 2
$false,Test 3,NOT Checked,Checked
$false,Test 4,NOT Checked,Checked
$true,Test 5,Checked!,Checked
"@ | 
ConvertFrom-Csv

    $WPF_dataGrid.ItemsSource = $DataGridList
    $WPF_dataGrid.items.Refresh()

})

$Form.ShowDialog() | 
Out-Null
}

Show-DataGrid