ASP。NET MVC表之间的数据库ID关联

Question

• 主键：Rev/Exp ID

这是我的模型的一个示例：

public class Revenue
{
    [Key]
    public int RevenueId { get; set; }
    public int Year { get; set; }
    public double Source1 { get; set; } = 0;
    public double Source2 { get; set; } = 0;
    public double Source3 { get; set; } = 0;
    public double Source4 { get; set; } = 0;

    public string UserId { get; set; }
    public virtual Organization Organization { get; set; }
}

public class User
{
    public ICollection<Revenue> Revenues { get; set; }
    public ICollection<Expense> Expenses { get; set; }
}

这是DBContext：公共类AppDbContext：标识符DbContext{公共AppDbContext（DbContextOptions选项）： base（选项）{}

    // Create tables in DB
    public DbSet<Organization > Organization { get; set; }
    public DbSet<Revenue> Revenue { get; set; }
    public DbSet<Expense> Expense { get; set; }
    public DbSet<User> User { get; set; }
}

以下是控制器中的创建操作：

    // GET: Revenue/Create
    public IActionResult Create()
    {
        return View();
    }

    // POST: Revenue/Create
    // To protect from overposting attacks, enable the specific properties you want to bind to.
    // For more details, see http://go.microsoft.com/fwlink/?LinkId=317598.
    [HttpPost]
    [ValidateAntiForgeryToken]
    public async Task<IActionResult> Create([Bind("RevenueId,Year,ByGovernment,ByInsurance,ByDirectPayment,ByExternalProject,ByOthers,EntityId")] Revenue revenue)
    {
        if (ModelState.IsValid)
        {
            _context.Add(revenue);
            await _context.SaveChangesAsync();
            return RedirectToAction(nameof(Index));
        }
        return View(revenue);
    }

最后，创建视图：

@{
    ViewData["Title"] = "Create";
}

<h1>Create</h1>

<h4>Revenue</h4>
<hr />
<div class="row">
    <div class="col-md-4">
        <form asp-action="Create">
            <div asp-validation-summary="ModelOnly" class="text-danger"></div>
            <div class="form-group">
                <label asp-for="Year" class="control-label"></label>
                <input asp-for="Year" class="form-control" />
                <span asp-validation-for="Year" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="Source1" class="control-label"></label>
                <input asp-for="Source1" class="form-control" />
                <span asp-validation-for="Source1" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="Source2" class="control-label"></label>
                <input asp-for="Source2" class="form-control" />
                <span asp-validation-for="Source2" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="Source3" class="control-label"></label>
                <input asp-for="Source3" class="form-control" />
                <span asp-validation-for="Source3" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="Source4" class="control-label"></label>
                <input asp-for="Source4" class="form-control" />
                <span asp-validation-for="Source4" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="EntityId" class="control-label"></label>
                <input asp-for="EntityId" class="form-control" />
                <span asp-validation-for="EntityId" class="text-danger"></span>
            </div>
            <div class="form-group">
                <input type="submit" value="Create" class="btn btn-primary" />
            </div>
        </form>
    </div>
</div>

<div>
    <a asp-action="Index">Back to List</a>
</div>

@section Scripts {
    @{await Html.RenderPartialAsync("_ValidationScriptsPartial");}
}

我的问题是如何关联用户和他们输入的数据？因此，Rev或Exp中的记录必须有一列，其中包含输入该数据的用户的ID，以便捕获这些数据。

Answer 1

您没有真正指定有关身份验证的任何内容。如果您使用的是典型的ASP。Net身份验证，您可能可以使用User。身份名称，如下所示：

        if (ModelState.IsValid)
        {
            revenue.UserId = User.Identity.Name
            _context.Add(revenue);
            ...