开发者

Generic Lists and Findall predicate search child list

From the code below I am able to use a predicate search and find all the merchants that have an Id greater than 4, using a similar approach how would I go about returning all the merchants and their vouchers where the Voucher had a VoucherTypeID of 3 lets say.

Thanks in Advance

class Program
{
    static void Main(string[] args)
    {
        List<Merchant> merchants = new List<Merchant>(10);
        for (int i = 0; i < 10; i++)
        {
             List<Voucher> vcs = new List<Voucher>();
            for (int j = 0; j < 3; j++)
            { 

                vcs.Add(new Voucher(j,"Voucher" + j.ToString(),i, j, "Type_" +j.ToString()));

            }
              merchants.Add(new Merchant(i, i.ToString() + "_Merchant",vcs));
        }

        //This will return all the merchant's where the ID is greater than 4

        Predicate<Merchant> filterByID;
        MerchantFilter filter = new MerchantFilter(4);
        filterByID = new Predicate<Merchant>(filter.FilterByMerchantGT4);
        List<Merchant> filteredMerchants = merchants.FindAll(filterByID);  

    }

    public class MerchantFilter 
    {
        private int idValue;
        public bool FilterByMerchantGT4(Merchant merch) 
        {

            return merch.MerchantID > idValue;
        }
        public MerchantFilter(int value)
        {
            idValue = value; 
        }
    } 

public class Merchant
{
    public int MerchantID { get; set; }
    public string MerchantName { get; set; }
    public List<Voucher> MerchantVouchers { get; set; }
    public Merchant(int id, string Name, List<Voucher> vouchers)
    {
        MerchantID = id;
        MerchantName = Name;
        MerchantVouchers = vouchers;

    }
}
public class Voucher
{
    public int VoucherID { get; set; }
    public string VoucherName { get;开发者_JS百科 set; }
    public int MerchantVoucherID { get; set; }
    public int VoucherTypeID { get; set; }
    public string VoucherTypeName { get; set; }
    public Voucher(int ID, string Name, int merchantID, int typeID, string TypeName)
    {
        VoucherID = ID;
        VoucherName = Name;
        MerchantVoucherID = merchantID;
        VoucherTypeID = typeID;
        VoucherTypeName = TypeName;
    }
}


Using linq, you could do this:

var query = from merchant in merchants
            let filteredVouchers = from voucher in merchant.MerchantVouchers
                                   where voucher.VoucherTypeID == 3
                                   select voucher
            select new { merchant, filteredVouchers };

or, equivalently, this:

var query =
    merchants.Select(
        merchant =>
        new
        {
            merchant,
            filteredVouchers = merchant.MerchantVouchers.Where(voucher => voucher.VoucherTypeID == 3)
        })
        .Select(t => new { t.merchant, t.filteredVouchers });

or, avoiding linq:

foreach(var merchant in merchants)
{
    var filteredVouchers = merchant.MerchantVouchers.FindAll(v => v.VoucherTypeID == 3);
    //...some useful code here
}

Notice how you don't need to define the MerchantFilter class. You can use a lambda expression to define the argument to the FindAll method.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜