public Dictionary <int, decimal> OrderNomenclaturesUnloaded(IUnitOfWork uow, Order order, SelfDeliveryDocument notSavedDoc = null)
{
SelfDeliveryDocumentItem docItemsAlias = null;
ItemInStock inUnload = null;
var unloadedQuery = uow.Session.QueryOver <SelfDeliveryDocument>()
.JoinAlias(d => d.Items, () => docItemsAlias)
.Where(d => d.Order.Id == order.Id);
var unloadedDict = unloadedQuery.SelectList(list => list
.SelectGroup(() => docItemsAlias.Nomenclature.Id).WithAlias(() => inUnload.Id)
.SelectSum(() => docItemsAlias.Amount).WithAlias(() => inUnload.Added)
)
.TransformUsing(Transformers.PassThrough)
.List <object[]>()
.GroupBy(o => (int)o[0], o => (decimal)o[1])
.ToDictionary(g => g.Key, g => g.Sum());
if (notSavedDoc != null && notSavedDoc.Id <= 0)
{
foreach (var i in notSavedDoc.Items)
{
if (unloadedDict.ContainsKey(i.Nomenclature.Id))
{
unloadedDict[i.Nomenclature.Id] += i.Amount;
}
else
{
unloadedDict.Add(i.Nomenclature.Id, i.Amount);
}
}
}
return(unloadedDict);
}
public Dictionary <int, decimal> OrderNomenclaturesLoaded(IUnitOfWork uow, Order order)
{
SelfDeliveryDocument docAlias = null;
SelfDeliveryDocumentItem docItemsAlias = null;
ItemInStock inLoaded = null;
var loadedlist = uow.Session.QueryOver <SelfDeliveryDocument>(() => docAlias)
.Where(d => d.Order.Id == order.Id)
.JoinAlias(d => d.Items, () => docItemsAlias)
.SelectList(list => list
.SelectGroup(() => docItemsAlias.Nomenclature.Id).WithAlias(() => inLoaded.Id)
.SelectSum(() => docItemsAlias.Amount).WithAlias(() => inLoaded.Added)
).TransformUsing(Transformers.PassThrough).List <object[]>();
var result = new Dictionary <int, decimal>();
foreach (var loadedItem in loadedlist)
{
result.Add((int)loadedItem[0], (decimal)loadedItem[1]);
}
return(result);
}
string CalculateAmountColor(SelfDeliveryDocumentItem item)
{
if (item.Amount > item.AmountInStock)
{
return("red");
}
if (item.OrderItem != null)
{
if (item.OrderItem.Count < item.AmountUnloaded + item.Amount)
{
return("orange");
}
if (item.OrderItem.Count == item.AmountUnloaded + item.Amount)
{
return("green");
}
if (item.OrderItem.Count > item.AmountUnloaded + item.Amount)
{
return("blue");
}
}
if (item.OrderEquipment != null)
{
if (item.OrderEquipment.Count < item.AmountUnloaded + item.Amount)
{
return("orange");
}
if (item.OrderEquipment.Count == item.AmountUnloaded + item.Amount)
{
return("green");
}
if (item.OrderEquipment.Count > item.AmountUnloaded + item.Amount)
{
return("blue");
}
}
return("black");
}
string CalculateAmountColor(SelfDeliveryDocumentItem item)
{
if (item.Amount > item.AmountInStock)
return "red";
if(item.OrderItem != null)
{
if (item.OrderItem.Count < item.AmountUnloaded + item.Amount)
return "orange";
if (item.OrderItem.Count == item.AmountUnloaded + item.Amount)
return "green";
if (item.OrderItem.Count > item.AmountUnloaded + item.Amount)
return "blue";
}
if(item.Equipment != null)
{
if (1 < item.AmountUnloaded + item.Amount)
return "orange";
if (1 == item.AmountUnloaded + item.Amount)
return "green";
if (1 > item.AmountUnloaded + item.Amount)
return "blue";
}
return "black";
}
string CalculateAmountColor(SelfDeliveryDocumentItem item)
{
if (item.Amount > item.AmountInStock)
{
return("red");
}
var cnt = item.Document.GetNomenclaturesCountInOrder(item.Nomenclature);
if (cnt < item.AmountUnloaded + item.Amount)
{
return("orange");
}
if (cnt == item.AmountUnloaded + item.Amount)
{
return("green");
}
if (cnt > item.AmountUnloaded + item.Amount)
{
return("blue");
}
return("black");
}
public virtual void AddItem(SelfDeliveryDocumentItem item)
{
item.Document = this;
ObservableItems.Add (item);
}
string GetItemsCount(SelfDeliveryDocumentItem item)
{
decimal cnt = item.Document.GetNomenclaturesCountInOrder(item.Nomenclature);
return(item.Nomenclature.Unit.MakeAmountShortStr(cnt));
}
