系统版本升级示例如下:
- 在后端
AppServer.cs的UseApplication中添加升级方法
static class AppServer
{
internal static void UseApplication(this WebApplication app)
{
app.UseKnown();
_ = AppMigrate.UpdateVersionAsync(); // 更新版本
}
}
- 在后端项目中添加
AppMigrate.cs类文件,示例如下:
class AppMigrate
{
public static Task UpdateVersionAsync()
{
using var database = Database.Create();
var time = DateTime.Parse("2025-10-02 10:00:00");
return database.UpdateVersionAsync("UpdateTime", time, Update20251002Async);
}
public static async Task Update20251002Async(Database db)
{
var isAddField = await db.AddTableFieldAsync<XXTable>(c => c.XXField); // 添加表字段
if (isAddField)
{
// 更新表数据
await db.ExecuteAsync($"update XXTable set XXField='XX' where Status<>'TT'");
}
await db.CreateTableAsync<TableXX>(); // 添加新表TableXX
}
}