如何计算MVC中的百分比

Question

我在数据库中有两个名为ProjectList和TaskList.The TaskList的表，表列是任务名称、描述、开始日期、结束日期、状态、项目。项目列存储了具有No.of Tasks.And的项目name.Each项目我有一个名为ProjectDetails，TaskDetails的两个视图。我得到的ProjectDetails页面动态根据项目名称，它将重定向到TaskDetails page.Now我需要计算的项目百分比为每个任务的基础上(已完成的任务/Total任务的总数)。

我怎样才能做到这一点，请帮帮我。

ProjectDetails页面的代码如下

 @foreach (var item in Model)
 {
   @if (item.ProjectStatus == "OnGoing")
    {
      <div class="col-lg-4 col-md-12 cur-pointer">
        <div class="card">
        <div class="card-header">
        <h5 class="card-title">@Html.DisplayFor(modelItem => item.ProjectName)</h5>
        <div class="card-options">
        <a asp-action="EditProject" asp-route-id="@item.ProjectID">
        <i class="fa fa-edit icon-size icon-align"></i>
        </a>
        <a href="#" class="card-options-collapse" data-toggle="card-collapse"></a>
        </div>
        </div>
        <a asp-action="AllTask" asp-route-id="@item.ProjectName" style="color:#000 !important">
        <div class="card-body cur-pointer">
        <p class="tag tag-blue mb-3">@Html.DisplayFor(modelItem => item.ProjectStatus)</p>
        <p>@Html.DisplayFor(modelItem => item.ProjectDescription)</p>
        <div class="row">
        <div class="col-5 py-1"><strong>Scope:</strong></div>
        <div class="col-7 py-1">@Html.DisplayFor(modelItem => item.ProjectScope)</div>
        <div class="col-5 py-1"><strong>Family:</strong></div>
        <div class="col-7 py-1">@Html.DisplayFor(modelItem => item.ProjectFamily)</div>
        <div class="col-5 py-1"><strong>Bucket:</strong></div>
        <div class="col-7 py-1">@Html.DisplayFor(modelItem => item.ProjectBucket)</div>
        <div class="col-5 py-1"><strong>Manager:</strong></div>
        <div class="col-7 py-1">@Html.DisplayFor(modelItem => item.Manager)</div>
        <div class="col-5 py-1"><strong>Start Date:</strong></div>
        <div class="col-7 py-1">@Html.DisplayFor(modelItem => item.StartDate)</div>
        <div class="col-5 py-1"><strong>End Date:</strong></div>
        <div class="col-7 py-1">@Html.DisplayFor(modelItem => item.EndDate)</div>
        <div class="col-5 py-1"><strong>Cost:</strong></div>
        <div class="col-7 py-1">@Html.DisplayFor(modelItem => item.Budget)</div>
        </div>
        </div>
        <div class="float-left"><strong>**TaskPErcentage**%</strong></div>
        <div class="float-right"><small class="text-muted">Progress</small>'
        </div>

        </a>
        </div>
        </div>
    }
 }

我的控制器是：

 public IActionResult AllProject()
    {
        List<Project> lstProject = new List<Project>();
        lstProject = objproject.GetAllProject().ToList();
        return View(lstProject);
    }

Answer 1

在TaskDetails页面中:您可能正在从ProjectDetails获取与各自ProjectName通信相关的所有任务。所以只需在你的foreach中根据任务状态进行如下操作：

before foreach : $completed = $totalTask = 0;


$totalTask++;

@if(item.ProjectStatus == "completed")
{
     $completed++;
}

$percentage  = ((int)$completed / (int) $totalTask ) * 100