​WinForms控件开发：自定义数据网格与ORM集成

using System;
using System.Windows.Forms;

public class CustomDataGridView : DataGridView
{
    public CustomDataGridView()
    {
        // 初始化自定义数据网格
        this.DoubleBuffered = true;
        this.EnableHeadersVisualStyles = false;
        this.ColumnHeadersDefaultCellStyle.BackColor = System.Drawing.Color.LightGray;
    }

    // 自定义列的示例
    public void AddCustomColumn(string headerText, Type columnType)
    {
        DataGridViewColumn column = new DataGridViewColumn();
        column.HeaderText = headerText;
        column.CellTemplate = (DataGridViewCell)Activator.CreateInstance(columnType);
        this.Columns.Add(column);
    }
}

using System;
using System.Windows.Forms;
using System.Linq;
using Microsoft.EntityFrameworkCore;

public class MyDbContext : DbContext
{
    public DbSet<Person> People { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("YourConnectionString");
    }
}

public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
}

public class MainForm : Form
{
    private CustomDataGridView dataGridView;

    public MainForm()
    {
        dataGridView = new CustomDataGridView();
        dataGridView.Dock = DockStyle.Fill;
        this.Controls.Add(dataGridView);

        LoadData();
    }

    private void LoadData()
    {
        using (var context = new MyDbContext())
        {
            var people = context.People.ToList();
            dataGridView.DataSource = people;
        }
    }
}

public class CustomDataGridView : DataGridView
{
    // ... 之前的代码 ...

    public void ApplyCustomSort(Func<Person, object> sortFunc, bool ascending)
    {
        if (this.DataSource is List<Person> people)
        {
            var sortedPeople = ascending 
                ? people.OrderBy(sortFunc).ToList() 
                : people.OrderByDescending(sortFunc).ToList();
            this.DataSource = sortedPeople;
        }
    }

    public void ApplyCustomFilter(Func<Person, bool> filterFunc)
    {
        if (this.DataSource is List<Person> people)
        {
            var filteredPeople = people.Where(filterFunc).ToList();
            this.DataSource = filteredPeople;
        }
    }
}

public class CustomDataGridView : DataGridView
{
    // ... 之前的代码 ...

    public void EnableVirtualMode(int totalRowCount)
    {
        this.VirtualMode = true;
        this.RowCount = totalRowCount;

        this.CellValueNeeded += (sender, e) =>
        {
            // 实现虚拟模式的逻辑
            if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
            {
                // 这里可以从数据源中获取数据
                e.Value = "Sample Data";
            }
        };
    }
}

public class MyDbContext : DbContext
{
    // ... 之前的代码 ...

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Person>()
            .HasMany(p => p.Orders)
            .WithOne(o => o.Person)
            .HasForeignKey(o => o.PersonId)
            .OnDelete(DeleteBehavior.Restrict);
    }
}