public static List <OrderSearchEntity> SearchOrder(IQueryable <OrderSearchEntity> billData, IEnumerable <IFilterDescriptor> billFilters, IEnumerable <IFilterDescriptor> detailsFilters, int pageIndex, int pageSize, ref int totalCount)
{
var lp = _query.LinqOP;
var orderDetailsContext = lp.GetDataContext <BillOrderDetails>();
var brands = VMGlobal.PoweredBrands;
var brandIDs = brands.Select(b => b.ID);
billData = billData.Where(o => brandIDs.Contains(o.BrandID));
if (FilterConditionHelper.IsConditionSetted(detailsFilters, "StyleCode"))
{
var productContext = lp.GetDataContext <ViewProduct>();
var pdata = from p in productContext
where brandIDs.Contains(p.BrandID)
select new { ProductID = p.ProductID, StyleCode = p.StyleCode };
IEnumerable <int> pIDs = ((IQueryable <dynamic>)pdata.Where(detailsFilters)).ToList().Select(p => (int)p.ProductID);
if (pIDs.Count() == 0)
{
return(null);
}
else
{
billData = from d in billData
where orderDetailsContext.Any(od => od.BillID == d.BillID && pIDs.Contains(od.ProductID))
select d;
}
}
var filtedData = (IQueryable <OrderSearchEntity>)billData.Where(billFilters);
totalCount = filtedData.Count();
//var datas = new QueryableCollectionView(filtedData.OrderBy(o => o.BillID).Skip(pageIndex * pageSize).Take(pageSize).ToList()); //filtedData.ToList();
var orders = filtedData.OrderBy(o => o.BillID).Skip(pageIndex * pageSize).Take(pageSize).ToList();//(List<OrderSearchEntity>)datas.SourceCollection;
var bIDs = orders.Select(o => (int)o.BillID);
var sum = orderDetailsContext.Where(o => bIDs.Contains(o.BillID) && o.IsDeleted == false).GroupBy(o => o.BillID).Select(g => new { BillID = g.Key, OrderQuantity = g.Sum(o => o.Quantity), CancelQuantity = g.Sum(o => o.QuaCancel), DeliveredQuantity = g.Sum(o => o.QuaDelivered) }).ToList();
orders.ForEach(d =>
{
d.BrandName = brands.Find(o => d.BrandID == o.ID).Name;
var order = sum.Find(o => o.BillID == d.BillID);
if (order != null)
{
d.订货数量 = order.OrderQuantity;
d.取消量 = order.CancelQuantity;
d.已发数量 = order.DeliveredQuantity;
var realOrderQuantity = d.订货数量 - d.取消量;
d.发货状态 = realOrderQuantity == d.已发数量 ? "已完成" : (d.已发数量 == 0 ? "未发货" : (realOrderQuantity > d.已发数量 ? "部分已发货" : "数据有误"));
}
});
return(orders);
}
private List <BillSubcontractSearchEntity> SearchSubcontract(IQueryable <BillSubcontractSearchEntity> billData)
{
var lp = VMGlobal.ManufacturingQuery.LinqOP;
var detailsContext = lp.GetDataContext <BillSubcontractDetails>();
var brands = VMGlobal.PoweredBrands;
var brandIDs = brands.Select(b => b.ID);
billData = billData.Where(o => brandIDs.Contains(o.BrandID));
if (FilterConditionHelper.IsConditionSetted(DetailsDescriptors, "StyleCode") || FilterConditionHelper.IsConditionSetted(DetailsDescriptors, "DeliveryDate"))
{
var productContext = lp.GetDataContext <ViewProduct>();
var detailFilter = from detail in detailsContext
from p in productContext
where detail.ProductID == p.ProductID && brandIDs.Contains(p.BrandID)
select new DetailsFiltetEntity {
ProductID = p.ProductID, StyleCode = p.StyleCode, DeliveryDate = detail.DeliveryDate
};
detailFilter = (IQueryable <DetailsFiltetEntity>)detailFilter.Where(DetailsDescriptors);
var pIDs = detailFilter.ToList().Select(p => p.ProductID);
if (pIDs.Count() == 0)
{
return(null);
}
billData = from d in billData
where detailsContext.Any(od => od.BillID == d.ID && pIDs.Contains(od.ProductID))
select d;
}
var filtedData = (IQueryable <BillSubcontractSearchEntity>)billData.Where(FilterDescriptors);
TotalCount = filtedData.Count();
//var datas = new QueryableCollectionView(filtedData.OrderBy(o => o.BillID).Skip(pageIndex * pageSize).Take(pageSize).ToList()); //filtedData.ToList();
var subcontracts = filtedData.OrderBy(o => o.ID).Skip(PageIndex * PageSize).Take(PageSize).ToList();//(List<OrderSearchEntity>)datas.SourceCollection;
var bIDs = subcontracts.Select(o => (int)o.ID);
var sum = detailsContext.Where(o => bIDs.Contains(o.BillID) && o.IsDeleted == false).GroupBy(o => o.BillID).Select(g => new { BillID = g.Key, Quantity = g.Sum(o => o.Quantity), QuaCancel = g.Sum(o => o.QuaCancel), QuaCompleted = g.Sum(o => o.QuaCompleted) }).ToList();
subcontracts.ForEach(d =>
{
d.BrandName = brands.Find(o => d.BrandID == o.ID).Name;
var subcontract = sum.Find(o => o.BillID == d.ID);
d.Quantity = subcontract.Quantity;
d.QuaCancel = subcontract.QuaCancel;
d.QuaCompleted = subcontract.QuaCompleted;
var realOrderQuantity = d.Quantity - d.QuaCancel;
d.StatusName = realOrderQuantity == d.QuaCompleted ? "已完成" : (d.QuaCompleted == 0 ? "未交货" : (realOrderQuantity > d.QuaCompleted ? "部分已交货" : "数据有误"));
});
return(subcontracts);
}
public static IEnumerable <int> GetProductIDArrayWithCondition(IEnumerable <IFilterDescriptor> filterDescriptors, IEnumerable <int> brandIDs = null)
{
if (FilterConditionHelper.IsConditionSetted(filterDescriptors, "StyleCode"))
{
if (brandIDs == null)
{
brandIDs = VMGlobal.PoweredBrands.Select(b => b.ID);
}
var productContext = VMGlobal.SysProcessQuery.LinqOP.GetDataContext <ViewProduct>();
var pdata = from p in productContext
where brandIDs.Contains(p.BrandID)
select new { ProductID = p.ProductID, StyleCode = p.StyleCode };
//注意IQueryable<dynamic>类型的对象调用Where(filters)将产生0<>0的恒假条件
IEnumerable <int> pIDs = ((IQueryable <dynamic>)pdata.Where(filterDescriptors)).ToList().Select(p => (int)p.ProductID);
//if (pIDs.Count() == 0)
// return null;
return(pIDs);
}
return(null);
}
protected override IEnumerable <VIPCard> SearchData()
{
List <VIPCardBO> vips = null;
if (!FilterConditionHelper.IsConditionSetted(FilterDescriptors, "KindID"))
{
vips = base.SearchData().Select(o => new VIPCardBO(o)).ToList();
}
else
{
var cards = LinqOP.GetDataContext <VIPCard>();
var maps = LinqOP.GetDataContext <VIPCardKindMapping>();
var data = from card in cards
from map in maps
where card.ID == map.CardID
select new VIPCardEntityForSearch
{
Birthday = card.Birthday,
Code = card.Code,
CustomerName = card.CustomerName,
KindID = map.KindID,
Sex = card.Sex,
MobilePhone = card.MobilePhone,
ID = card.ID
};
var filteredData = (IQueryable <VIPCardEntityForSearch>)data.Where(FilterDescriptors);
var vids = filteredData.Select(o => o.ID).Distinct().ToArray();
var result = cards.Where(o => vids.Contains(o.ID));
TotalCount = result.Count();
vips = result.OrderBy(o => o.ID).Skip(PageIndex * PageSize).Take(PageSize).Select(o => new VIPCardBO(o)).ToList();
}
VIPCardVM.ApplyVIPKind(vips);
vips.ForEach(o =>
{
if (!DownHierarchyOrganizationIDArray.Contains(o.OrganizationID))
{
o.MobilePhone = "不可见";
}
});
return(vips);
}
