WPF 绑定数据自动生成按钮

开发工具与关键技术： Visual Studio 2017、C#语言、WPF、SQL Server
作者：邓李庆
撰写时间： 2019年9月18日
下面给大家讲一个WPF中的绑定SQL Server 数据在后端生成按钮。 先在布局上给一个框的面给Name 名。见图代码：

然后给一个 Loaded 加载事件。在里面进行查询SQL Server 里面的数据查询，查询完后使用For 循环进行循环每一条数据，在循环里面声明Button 按钮，给宽和高、字体颜色、还有鼠标左键、右键事件。

 //自动加载
        private void UserControl_Loaded(object sender, RoutedEventArgs e)
        {
            try
            {
                int Reserveds = 0, Leisures = 0, Tourists = 0, CleanRooms = 0, Inactives = 0;
                //每次都清空WrapPanel：环绕面板的内容 
                Seat.Children.Clear();
                var mySeat = (from dtSeat in myModels.PW_Seat
                              join dtGenreup in myModels.PW_Genreup on dtSeat.GenreupID equals dtGenreup.GenreupID
                              join dtEmployee in myModels.PW_Employee on dtSeat.EmployeeID equals dtEmployee.EmployeeID
                              select new
                              {
                                  dtSeat.SeatName,
                                  dtSeat.Platform,
                                  dtSeat.NumberPeople,
                                  dtSeat.GenreupID,
                                  dtGenreup.GenreupName,
                                  dtEmployee.EmployeeName,
                              }).ToList();
                for (int i = 0; i < mySeat.Count; i++)
                {
                    Button button = new Button();
                    button.Height = 100;
                    button.Width = 100;
                    button.Margin = new Thickness(5);
                    button.Foreground = new SolidColorBrush(Colors.White);
                    button.BorderBrush = new SolidColorBrush(Colors.Transparent);
                    button.Click += new RoutedEventHandler(btn_Click);//鼠标左键
                    button.MouseRightButtonUp += new MouseButtonEventHandler(btn_MouseRightButtonDown);//鼠标右键
                    if (mySeat[i].GenreupID == 1)//预订
                    {
                        button.Content = mySeat[i].Platform;
                        button.ToolTip = "★状   态：" + mySeat[i].GenreupName + "n★容纳数：" + mySeat[i].NumberPeople + "n★服务员：" + mySeat[i].EmployeeName;
                        button.Background = new SolidColorBrush(Colors.Blue);
                        Reserveds++;
                    }
                    else if (mySeat[i].GenreupID == 2)//空闲
                    {
                        button.Content = mySeat[i].Platform;
                        button.ToolTip = "★状   态：" + mySeat[i].GenreupName + "n★容纳数：" + mySeat[i].NumberPeople + "n★服务员：" + mySeat[i].EmployeeName;
                        button.Background = new SolidColorBrush(Colors.Green);
                        Leisures++;
                    }
                    else if (mySeat[i].GenreupID == 3)//使用
                    {
                        button.Content = mySeat[i].Platform + "nn" + mySeat[i].SeatName;
                        button.ToolTip = "★状   态：" + mySeat[i].GenreupName + "n★容纳数：" + mySeat[i].NumberPeople + "n★服务员：" + mySeat[i].EmployeeName;
                        button.Background = new SolidColorBrush(Colors.Orange);
                        Tourists++;
                    }
                    else if (mySeat[i].GenreupID == 4)//清理
                    {
                        button.Content = mySeat[i].Platform + "nn" + mySeat[i].SeatName;
                        button.ToolTip = "★状   态：" + mySeat[i].GenreupName + "n★容纳数：" + mySeat[i].NumberPeople + "n★服务员：" + mySeat[i].EmployeeName;
                        button.Background = new SolidColorBrush(Colors.Gray);
                        CleanRooms++;
                    }
                    else if (mySeat[i].GenreupID == 5)//停用
                    {
                        button.Content = mySeat[i].Platform + "nn" + mySeat[i].SeatName;
                        button.ToolTip = "★状   态：" + mySeat[i].GenreupName + "n★容纳数：" + mySeat[i].NumberPeople + "n★服务员：" + mySeat[i].EmployeeName;
                        button.Background = new SolidColorBrush(Colors.Red);
                        Inactives++;
                    }
                    Reserved.Text = Reserveds + "间";
                    Leisure.Text = Leisures + "间";
                    Tourist.Text = Tourists + "间";
                    CleanRoom.Text = CleanRooms + "间";
                    Inactive.Text = Inactives + "间";
                    //给WrapPanel：环绕面板添加子集
                    Seat.Children.Add(button);
                }
            }
            catch (Exception)
            {
                MessageBox.Show("计算机网络连接失败!", "提示", MessageBoxButton.OK, MessageBoxImage.Stop);
            }
        }

进行判断鼠标左键还是右键

  //鼠标单击键
        private void btn_Click(object sender, RoutedEventArgs e)
        {

        }
        //鼠标右键
        private void btn_MouseRightButtonDown(object sender, MouseButtonEventArgs e)
        {

        }