这段代码可以让我将本地时间添加到SQL数据库中。我已经创建了一个默认的Blazor应用程序示例，并添加了一个Add Time页面。

#我的目录

BlazorApp1/
│
├── models/
│ ├── Model.cs
|
├── Data/
│ ├── Adddbcontext.cs
│ ├── ...
│ 
├── Pages/
│ ├── Index.razor
│ ├── Counter.razor
│ ├── FetchData.razor
│ └── AddTime.razor
| ├── ...
│
├── Shared/
│ ├── MainLayout.razor
│ ├── NavMenu.razor
│ └── ...
│
├── App.razor
├── Program.cs
└── ...

字符串

adddbcontext.cs

using BlazorApp1.models;
using Microsoft.EntityFrameworkCore;
namespace BlazorApp1.Data
{
    public class Adddbcontext : DbContext
    {
        private readonly IConfiguration Config;
        public Adddbcontext(IConfiguration configuration) 
        { 
            Config = configuration; 
        }
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlServer(Config.GetConnectionString("Dbconnectionstring"));
            
        }
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Model>().HasKey(e => e.Id);
        }
        public DbSet<Model> Time {  get; set; }
    }
}

型

Model.cs

namespace BlazorApp1.models
{
    public class Model
    {
        public int Id { get; set; }
        public string Timein { get; set; }
        public string TimeOut { get; set; }
    }
}

型

AddTime.razor

@page "/addtime"
@using BlazorApp1.models;
@inject Data.Adddbcontext Dbcontext;
<PageTitle>AddTime</PageTitle>
<h3>savetime</h3>
<EditForm Model="@newtime" OnValidSubmit="test">
    <InputText type="time" class="form-control form-control-sm" @bind-Value="newtime.Timein"/>
    <InputText type="time" class="form-control form-control-sm" @bind-Value="newtime.TimeOut" />
    <button type="submit">Save</button>
    @if(save)
    {
        <p>Time is saved</p>
    }
</EditForm>
@code {
    public Model newtime = new Model();
    public bool save = false;
    private async Task test()
    {
        try
        {
            Dbcontext.Time.Add(newtime);
            await Dbcontext.SaveChangesAsync();
            save = true;
        }
        catch
        {
            throw;
        }
    }
}

型
在脚本中将此添加到NavMenu.razor现有代码中以获取Add Time菜单。

<div class="nav-item px-3">
            <NavLink class="nav-link" href="addtime">
                <span class="oi oi-list-rich" aria-hidden="true"></span> Add Time
            </NavLink>
        </div>

型

OUTPUT：

本地时间以.

的形式显示

的

时间在SQL数据库中保存为24小时格式

的