Winform中如何使用SqlSugar

在 Winform 中使用 SqlSugar 首先需要安装 SqlSugar 包，可以通过 NuGet 包管理器搜索并安装 SqlSugar。

using SqlSugar;

public class DatabaseContext
{
    private SqlSugarClient db;

    public DatabaseContext()
    {
        db = new SqlSugarClient(new ConnectionConfig()
        {
            ConnectionString = "YourConnectionString",
            DbType = DbType.SqlServer,
            IsAutoCloseConnection = true
        });
    }

    public List<T> GetAll<T>() where T : class, new()
    {
        return db.Queryable<T>().ToList();
    }

    public T GetById<T>(object id) where T : class, new()
    {
        return db.Queryable<T>().InSingle(id);
    }

    public void Insert<T>(T entity) where T : class, new()
    {
        db.Insertable(entity).ExecuteCommand();
    }

    public void Update<T>(T entity) where T : class, new()
    {
        db.Updateable(entity).ExecuteCommand();
    }

    public void Delete<T>(T entity) where T : class, new()
    {
        db.Deleteable(entity).ExecuteCommand();
    }
}

在 Winform 窗体中使用 DatabaseContext 类来进行数据库操作：

private void btnGetAll_Click(object sender, EventArgs e)
{
    DatabaseContext dbContext = new DatabaseContext();
    var data = dbContext.GetAll<YourEntity>();
    dataGridView.DataSource = data;
}

private void btnInsert_Click(object sender, EventArgs e)
{
    DatabaseContext dbContext = new DatabaseContext();
    YourEntity entity = new YourEntity { Name = "Test" };
    dbContext.Insert(entity);
}

private void btnUpdate_Click(object sender, EventArgs e)
{
    DatabaseContext dbContext = new DatabaseContext();
    YourEntity entity = dbContext.GetById<YourEntity>(1);
    entity.Name = "Updated";
    dbContext.Update(entity);
}

private void btnDelete_Click(object sender, EventArgs e)
{
    DatabaseContext dbContext = new DatabaseContext();
    YourEntity entity = dbContext.GetById<YourEntity>(1);
    dbContext.Delete(entity);
}

在上面的代码中，需要将 “YourConnectionString” 替换为实际的数据库连接字符串，以及将 “YourEntity” 替换为实际的实体类名称。通过 DatabaseContext 类的方法实现数据库的增删改查操作，并在 Winform 窗体的按钮点击事件中调用这些方法来操作数据库。