Question

I would like to "combine" to linq queries into the same gridview. Though I don t think I could use innerjoin on this. The queries get orders from the database, and I have 2 tables with orders from different places. In the gridview I want to display all orders from first table and second table. Like this:

OrderID - Item - Amount etc ---From table 1
OrderID - Item - Amount etc ---From table 2
etc..

我目前从第一个桌上接到命令的问询是:

var query = from o in db.Orders
            join y in db.OrderLines on o.OrderID equals y.OrderID
            join x in db.Products on y.ItemNumber equals x.ItemNumber
            where o.AccountNumber == AppSession.CurrentLoginTicket.AccountNumber
            select new
            {
                o.OrderID,
                o.AxaptaSalesId,
                y.ItemNumber,
                x.Name,
                x.ProductFormatName,
                y.Quantity,
                y.Price,
                Status = dltRep.getOrderStatus(o.OrderID, o.AxaptaSalesId, y.ItemNumber).Substring(0, dltRep.getOrderStatus(o.OrderID, o.AxaptaSalesId, y.ItemNumber).LastIndexOf("|")),
                Levering = dltRep.getOrderStatus(o.OrderID, o.AxaptaSalesId, y.ItemNumber).Substring(dltRep.getOrderStatus(o.OrderID, o.AxaptaSalesId, y.ItemNumber).LastIndexOf("|")).Replace("|", "")
            };

另一表将有相同的资料。它叫AxSale。

我希望这一点是可能的,有人可以帮助我:

<>strong>EDIT:新的“问题”

I wan t to get the variable createdDate to be the first element x.CreatedDate in either the first linq seq. or the second. How do I do this?

var created = purchases.OrderByDescending(x => x.CreatedDate).
                Select(x => new { x.CreatedDate, x.LineSupplierAccountNO }).
                GroupBy(x => x.LineSupplierAccountNO);

if (created.Count() > 1)
{
    created = purchases.OrderBy(x => x.CreatedDate).
                Select(x => new { x.CreatedDate, x.LineSupplierAccountNO }).
                GroupBy(x => x.LineSupplierAccountNO);
}

var createdDate = created.FirstOrDefault();

Solution code:

var created = purchases.OrderBy(x => x.CreatedDate).Select(x => x);

if (created.GroupBy(x => x.LineSupplierAccountNO).Count() > 1)
{
    created = purchases.OrderByDescending(x => x.CreatedDate).Select(x => x);
}

var createdDate = created.First().CreatedDate;

Answer 1

使用<代码>UNION的操作者与相同领域合并结果。 http://code.msdn.microsoft.com/windowsdesktop/101-LINQ-Samples-3fb9811b"rel=“nofollow” http://code.msdn.microsoft.com/windowsdesktop/101-LINQ-Samples-3fb9811b

public void Linq49() 
{ 
    List<Product> products = GetProductList(); 
    List<Customer> customers = GetCustomerList(); 

    var productFirstChars = 
        from p in products 
        select p.ProductName[0]; 
    var customerFirstChars = 
        from c in customers 
        select c.CompanyName[0]; 

    var uniqueFirstChars = productFirstChars.Union(customerFirstChars); 

    Console.WriteLine("Unique first letters from Product names and Customer names:"); 
    foreach (var ch in uniqueFirstChars) 
    { 
        Console.WriteLine(ch); 
    } 
}

Answer 2

我认为,你正在寻找 http://msdn.microsoft.com/en-us/library/bb386993.aspx” rel=“nofollow”

http://weblogs.asp.net/zeeshanhirani/archive/2008/04/11/union-operator-part-12.aspx”rel=“nofollow”

Solution code:

友情链接