public BindingList<GoodsBalanceObj> GetOrderList()
{
if (_currentOrderHeader != null)
{
using (OrderDataContext oc = UnityContainer.Resolve<OrderDataContext>())
{
List<vOrderDayAll> orders = oc.DataBaseContext.vOrderDayAll.Where(
or => (((or.id_OrderHeader == _currentOrderHeader.IdOrderHeader)
))).ToList();
BindingList<GoodsBalanceObj> balance = new BindingList<GoodsBalanceObj>();
balance.AllowEdit = _currentOrderHeader.IdOrderState == 1;
foreach (var vo in orders)
{
GoodsBalanceObj bl = new GoodsBalanceObj()
{
Barcode = vo.Barcode,
Code = vo.Code,
Date = vo.Date,
FreeBalance = vo.FreeBalance.GetValueOrDefault(),
Group = vo.GoodsGroup,
id = vo.id_GoodsBalance,
Measure = vo.Measure,
MinOrder = vo.MinOrder.GetValueOrDefault(),
Name = vo.Name,
Price = vo.Price.GetValueOrDefault(),
ReqQuantity = vo.ReqQuantity,
Ordered = vo.Ordered,
Quantity = vo.Balance,
QuantityInPack = vo.QuantityInPack.GetValueOrDefault(),
Reserved = vo.Reserved.GetValueOrDefault(),
Supplier = vo.Supplier
};
balance.Add(bl);
}
return balance;
}
}
return null;
}
void SaveOrder(GoodsBalanceObj goodsObj)
{
{
using (var oc = UnityContainer.Resolve<OrderDataContext>())
{
oc.DataBaseContext.spCreateOrderNew(goodsObj.id, IdOrderHeader, goodsObj.ReqQuantity);
UnityContainer.Resolve<IDBLogger>().InsertLog(string.Format("Позиция заказа. товар = '{0}' колво = {1}", goodsObj.id, goodsObj.ReqQuantity), IdOrderHeader.ToString().ToUpper());
var gods = oc.DataBaseContext.sp_sel_OrderBalanceRefresh(IdOrderHeader, goodsObj.id).Single();
goodsObj.Ordered = gods.Ordered;
goodsObj.Quantity = gods.Balance.GetValueOrDefault(0);
goodsObj.Quota = gods.Quota;
}
}
}
private BindingList<GoodsBalanceObj> GetCommitList(IEnumerable<sp_sel_PreOrderCommitGoodsByHeaderResult> commitOrders, Guid idPreOrder)
{
var list = commitOrders.Where(x => x.id_PreOrder == idPreOrder).ToList();
if ((list.Count > 0))
{
var ret = new BindingList<GoodsBalanceObj>() { AllowEdit = false, AllowNew = false, AllowRemove = false };
foreach (var i in list)
{
var gb = new GoodsBalanceObj()
{
Barcode = i.Barcode,
Code = i.Code,
Date = i.Date,
Group = i.GoodsGroup,
Measure = i.Measure,
Supplier = i.Supplier,
SelfImport = i.SelfImport.GetValueOrDefault(false),
Quantity = i.Ordered.GetValueOrDefault(0),
Price = i.Price.GetValueOrDefault(0),
QuantityInPack = i.QuantityInPack.GetValueOrDefault(0),
Name = i.Name,
MinOrder = i.MinOrder.GetValueOrDefault(0),
};
ret.Add(gb);
}
return ret;
}
return null;
}
private BindingList<GoodsBalanceObj> GetOrderList()
{
if (_currentOrderHeader != null)
{
using (var oc = UnityContainer.Resolve<OrderDataContext>())
{
var orders = oc.DataBaseContext.sp_sel_OrderGoodsByHeader(_currentOrderHeader.IdOrderHeader).ToList();
var balance = new BindingList<GoodsBalanceObj>
{
AllowEdit = _currentOrderHeader.IdOrderState == 1
};
foreach (var vo in orders)
{
var bl = new GoodsBalanceObj
{
Barcode = vo.Barcode,
Code = vo.Code,
Date = vo.Date,FreeBalance = vo.FreeBalance.GetValueOrDefault(),
Group = vo.GoodsGroup,
id = vo.id_GoodsBalance,
Measure = vo.Measure,
MinOrder = vo.MinOrder.GetValueOrDefault(),
Name = vo.Name,
Price = vo.Price.GetValueOrDefault(),
ReqQuantity = vo.ReqQuantity,
Ordered = vo.Ordered,
Quantity = vo.Balance,
QuantityInPack = vo.QuantityInPack.GetValueOrDefault(),
Reserved = vo.Reserved.GetValueOrDefault(),
Supplier = vo.Supplier,
SelfImport = vo.SelfImport.GetValueOrDefault(false)
};
balance.Add(bl);
}
return balance;
}
}
return null;
}
public BindingList<GoodsBalanceObj> GetOrderList()
{
if (_currentOrderHeader != null)
{
using (OrderDataContext oc = UnityContainer.Resolve<OrderDataContext>())
{
List<vGoodsBalanceOrder> orders;
if(StoreHouseType)
{
orders = oc.DataBaseContext.vGoodsBalanceOrder.Where(
or => (((or.id_OrderHeader == _currentOrderHeader.IdOrderHeader)
|| (or.id_OrderHeader == null)) && (or.GoodsGroup != @"АЛКОГОЛЬНЫЕ НАПИТКИ"))).ToList();
}
else
{
orders = oc.DataBaseContext.vGoodsBalanceOrder.Where(
or => (((or.id_OrderHeader == _currentOrderHeader.IdOrderHeader)
|| (or.id_OrderHeader == null)) && (or.GoodsGroup == @"АЛКОГОЛЬНЫЕ НАПИТКИ"))).ToList();
}
BindingList<GoodsBalanceObj> balance = new BindingList<GoodsBalanceObj>();
balance.AllowEdit = _currentOrderHeader.IdOrderState == 1;
foreach (var vo in orders)
{
GoodsBalanceObj bl = new GoodsBalanceObj()
{
Barcode = vo.Barcode,
Code = vo.Code,
Date = vo.Date,
FreeBalance = vo.FreeBalance.GetValueOrDefault(),
Group = vo.GoodsGroup,
id = vo.id_GoodsBalance,
Measure = vo.Measure,
MinOrder = vo.MinOrder.GetValueOrDefault(),
Name = vo.Name,
Price = vo.Price.GetValueOrDefault(),
ReqQuantity = vo.ReqQuantity,
Ordered = vo.Ordered.GetValueOrDefault(),
Quantity = vo.Balance.GetValueOrDefault(),
QuantityInPack = vo.QuantityInPack.GetValueOrDefault(),
Reserved = vo.Reserved.GetValueOrDefault(),
Supplier = vo.Supplier
};
bl.ChangeReqQuantity += new ChangeReqQuantity(bl_ChangeReqQuantity);
balance.Add(bl);
}
return balance;
}
}
return null;
}
void SaveOrder(GoodsBalanceObj goodsObj)
{
{
using (OrderDataContext oc = UnityContainer.Resolve<OrderDataContext>())
{
oc.DataBaseContext.spCreateOrderNew(goodsObj.id, IdOrderHeader, goodsObj.ReqQuantity);
IQueryable<vGoodsBalanceOrder> gods = from gd in oc.DataBaseContext.vGoodsBalanceOrder
where (gd.id_OrderHeader == IdOrderHeader &&
gd.id_GoodsBalance == goodsObj.id)
select gd;
foreach (var gd in gods)
{
goodsObj.Ordered = gd.Ordered.GetValueOrDefault(0);
goodsObj.Quantity = gd.Balance.GetValueOrDefault(0);
}
}
}
}
