记开发个人图书收藏清单小程序开发（七）DB设计

前面的书房初始化的前端信息已经完善，所以现在开始实现DB的Script部分。

新增Action:Shelf_Init.sql

svc.sql

CREATE SCHEMA [svc]
    AUTHORIZATION [dbo];

Shelf_Init.sql

CREATE PROCEDURE [svc].[Shelf$Init](@json nvarchar(max))
WITH ENCRYPTION
AS
BEGIN
    SET    NOCOUNT    ON;
    SET XACT_ABORT ON;
    BEGIN TRY
        BEGIN    TRAN;

        declare    @nickName nvarchar(20), @shelfName nvarchar(20);
        select    @nickName=NickName,     @shelfName=ShelfName
        from    openjson (@json, '$')
        with (
            NickName        nvarchar(20),
            ShelfName        nvarchar(20)
        );

        insert    core._Party(Type, Alias) select k._User, @nickName
        from    core.Party#Type() k;
        declare    @userID int=@@identity;

        
        insert    core._Party(PID, Type, Alias) select @userID, k._Shelf, @shelfName
        from    core.Party#Type() k;

        COMMIT    TRAN;
    END TRY
    BEGIN CATCH
        if (xact_state() = -1) ROLLBACK TRAN; throw;
    END CATCH
END

好了，我去试试前端能不能初始化信息进DB

....

在测试之前，我们需要实现一下Init Razor Pages代码：

Init.cshtml.cs

    using M = Shelf;
    public class InitModel : PageModel
    {
        private readonly IShelfRepo _shelfRepo;
        public InitModel(IShelfRepo shelfRepo)
        {
            _shelfRepo = shelfRepo;
        }
        [BindProperty]
        public InitInputModel Input { get; set; }

        public void OnGet()
        {

        }

        public async Task<IActionResult> OnPostAsync()
        {
            if (ModelState.IsValid)
            {
                await _shelfRepo.InitAsync(new M.InitSpec
                {
                    NickName = Input.NickName.Trim(),
                    ShelfName = Input.ShelfName.Trim()
                });
                return RedirectToPage("New");
            }
            return Page();
        }
    }

页面内容也需要修改一下form部分

Init.cshtml

<form method="post">
    <div class="form-group form-group-lg">
        <label asp-for="Input.NickName"></label>
        <input class="form-control form-control-lg" asp-for="Input.NickName" autocomplete="off">
        <span asp-validation-for="Input.NickName" class="text-danger"></span>
    </div>
    <div class="form-group form-group-lg">
        <label asp-for="Input.ShelfName"></label>
        <input class="form-control form-control-lg" asp-for="Input.ShelfName" autocomplete="off">
        <span asp-validation-for="Input.ShelfName" class="text-danger"></span>
    </div>
    <div class="form-group text-right">
        <button class="btn btn-warning btn-lg" type="submit">Save</button>
    </div>
</form>

填写不动书房的信息：

 点击Save按钮提交，OK，正常提交了并跳转了。

查看下DB有没有数据：

哈哈，看来一切正常。