SELECT TOP {count} * FROM (SELECT co.orderid,co.orderStatusId, co.paymenttransactionstatusid, (SELECT Count(IdProductSelect) FROM orderproductselect ops WHERE ops.orderid = co.orderid AND co.orderstatusid IN ( 2, 9 ) AND ops.quantity - ops.splitquantity > 1) AS LineItemsCount FROM ci_orders co) AS temp WHERE lineitemscount > 1 AND paymenttransactionstatusid = 1 AND orderid NOT IN (SELECT orderid FROM ordersplit) AND orderid Not IN (SELECT ChildOrderId FROM ordersplit) ORDER BY LineItemsCount
public static List<ci_orders> GetOrdersWithMultipleLineItemAndQTY(int count) { using (var context = GetDbContext()) { var jobList = context.Orders .OrderByDescending(x => x.orderId) .Take(count).ToList(); return jobList; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)