13,346
社区成员




datagrid.ItemsSource = GetTicketHistoryByOrder(2).ToList();
public static IEnumerable<Counter> GetTicketHistoryByOrder(string tellerId)
{
var ticketHistoryMapper = MapBuilder<Counter>.BuildAllProperties();
var command = DbOperation.GetDbCommand(string.Format("select * from FES_QUEUE_TicketHistory where TellerID='{0}'", tellerId));
var results = DbOperation.ExecuteAstSqlStringAccessor<Counter>(command, ticketHistoryMapper);
}
MainPage.xaml内容:
<UserControl x:Class="SL1015.MainPage"
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"
mc:Ignorable="d"
d:DesignHeight="300" d:DesignWidth="400" xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk" Loaded="UserControl_Loaded">
<sdk:DataGrid Name="dataGrid1" AutoGenerateColumns="False" GridLinesVisibility="All">
<sdk:DataGrid.Columns>
<sdk:DataGridTextColumn Header="UserID" Binding="{Binding UserID}" IsReadOnly="True"></sdk:DataGridTextColumn>
<sdk:DataGridTextColumn Header="UserName" Binding="{Binding UserName}" IsReadOnly="True"></sdk:DataGridTextColumn>
<sdk:DataGridTemplateColumn Header="管理">
<sdk:DataGridTemplateColumn.CellTemplate>
<DataTemplate>
<TextBlock Text="删除"></TextBlock>
</DataTemplate>
</sdk:DataGridTemplateColumn.CellTemplate>
</sdk:DataGridTemplateColumn>
</sdk:DataGrid.Columns>
</sdk:DataGrid>
</UserControl>
MainPage.xaml.cs的内容如下:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
namespace SL1015
{
public partial class MainPage : UserControl
{
public MainPage()
{
InitializeComponent();
dataGrid1.ItemsSource = GetDataList();
}
private List<Student> GetDataList()
{
List<Student> list = new List<Student>();
list.Add(new Student(1, "张三"));
list.Add(new Student(2, "李四"));
list.Add(new Student(3, "王二"));
list.Add(new Student(4, "麻子"));
return list;
}
}
}
实体类Student.cs内容如下:
using System;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Ink;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
namespace SL1015
{
public class Student
{
public Student(int id, string name)
{
this.UserID = id;
this.UserName = name;
}
public int UserID { get; set; }
public string UserName { get; set; }
}
}