查询调用批次和子批次 [英] Query calling batches and sub batches

问题描述

我想知道是否有人可以帮助我使用下面的代码我正在尝试调用批次和子目录，但子批次为空。我知道我只返回批次查看，但我怎么称他们为

Hi was wondering can someone help me with this code below I am trying call the batches and subbatches but sub batches are null . I know I am only returning batches to view but how would I call them both

public ActionResult Index()
        {
            var batchesQuery = db.Batches;

            var Batches = batchesQuery.Select(batch => new BatchInfoView
            {
                BatchID = batch.BatchID,
                BatchName = batch.Name
            }).ToList();

            var SubBatches = batchesQuery.Select(subBatch => new SubBatchInfoView
            {
                SubBatchID = subBatch.SubBatches.Select(sbi => sbi.SubBatchID),
                SubBatchName = subBatch.SubBatches.Select(sbn => sbn.Code),
                SubBatchCount = subBatch.SubBatches.Select(sbc => sbc.SubBatchID).Count()
            }).ToList();

            return View(Batches);
        }

BatchInfoView

BatchInfoView

namespace SIMCardAdmin.Web.Models.Batch
{
    public class BatchInfoView
    {
        /// <summary>
        /// Flag to determine if this model is new.
        /// </summary>
        public bool IsNew { get; set; }

        /// <summary>
        /// The ID of the Batch.
        /// </summary>
        public int BatchID { get; set; }

        /// <summary>
        /// The name of the Batch, for display purposes.
        /// </summary>
        public string BatchName { get; set; }

        public List<SubBatchInfoView> SubBatches { get; set; }
    }
}

SubBatchInfoView

SubBatchInfoView

public class SubBatchInfoView
    {
        /// <summary>
        /// The ID of the SubBatch, use this to jump to a list for this SubBatch.
        /// </summary>
        public IEnumerable<int> SubBatchID { get; set; }

        /// <summary>
        /// The name of the SubBatch, for display purposes.
        /// </summary>
        public IEnumerable<string> SubBatchName { get; set; }

        /// <summary>
        /// The count of the SubBatch, for display purposes.
        /// </summary>
        public int SubBatchCount { get; set; }
    }

推荐答案

你的视图模型真的没有任何意义。每个批次都有一个子批次列表，但是每个子批次都有一个ID列表，一个名称列表和一个子批次数量。



我怀疑你想要的东西如下：

Your view models really don't make any sense. Each batch has a list of sub-batches, but then each sub-batch has a list of IDs, a list of names, and a count of the number of sub-batches.

I suspect you want something that looks like this:

public class BatchInfoView
{
    public bool IsNew { get; set; }
    public int BatchID { get; set; }
    public string BatchName { get; set; }
    public List<SubBatchInfoView> SubBatches { get; set; }

    public int SubBatchCount
    {
        get { return SubBatches == null ? 0 : SubBatches.Count; }
    }
}

public class SubBatchInfoView
{
    public int SubBatchID { get; set; }
    public string SubBatchName { get; set; }
}

然后你需要加载子批次作为查询的一部分来加载批次：

Then you'll need to load the sub-batches as part of the query to load the batches:

var batches = db.Batches
    .Include(batch => batch.SubBatches)
    .Select(batch => new BatchInfoView
    {
        BatchID = batch.BatchID,
        BatchName = batch.Name,
        SubBatches = batch.SubBatches.Select(sb => new SubBatchInfoView
        {
            SubBatchID = sb.SubBatchID,
            SubBatchName = sb.Code,
        }).ToList()
    })
    .ToList();

这篇关于查询调用批次和子批次的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！