partial void ProductReceivePurchaseOrderDetails_Inserted(ProductReceivePurchaseOrderDetail entity)
{
var queryReceive = (from rcvPO in ProductReceivePurchaseOrderDetails
where rcvPO.Product.Id == (entity.PurchaseOrderDetail.Product.Id) &&
rcvPO.PurchaseOrderDetail.Id == entity.PurchaseOrderDetail.Id
group rcvPO by rcvPO.PurchaseOrderDetail.Id into g
select new
{
sumReceive = g.Sum(rcvPO => rcvPO.ReceiveQuantity)
,
sumTotalCost = g.Sum(rcvPO => rcvPO.ReceiveTotalCost)
}).FirstOrDefault();
var sumData = queryReceive;
entity.PurchaseOrderDetail.ReceiveQuantity = sumData.sumReceive;
entity.PurchaseOrderDetail.ReceiveUnitCost = sumData.sumTotalCost / System.Convert.ToDecimal(sumData.sumReceive);
entity.PurchaseOrderDetail.ReceiveTotalCost = sumData.sumTotalCost;
updateStockOnHand(entity.Location, entity.Product, entity.LotNo, entity.ReceiveQuantity, entity.ReceiveTotalCost);
}
public void AddToProductReceivePurchaseOrderDetails(ProductReceivePurchaseOrderDetail productReceivePurchaseOrderDetail)
{
base.AddObject("ProductReceivePurchaseOrderDetails", productReceivePurchaseOrderDetail);
}
partial void ProductReceivePurchaseOrderDetails_Inserting(ProductReceivePurchaseOrderDetail entity)
{
if (entity.ReceiveDate != null)
{
string receiveType = getPOTransactionType(entity.Product);
entity.LotNo = getNewLotFromStockOnhand(receiveType, entity.ReceiveDate, entity.Product, "");
}
}
public static ProductReceivePurchaseOrderDetail CreateProductReceivePurchaseOrderDetail(int ID, string receiveNumber, global::System.DateTime receiveDate, int productReceivePurchaseOrderDet_PurchaseOrderDetail, int productReceivePurchaseOrderDet_Location, double receiveQuantity, decimal receiveUnitCost, decimal receiveTotalCost, int productReceivePurchaseOrderDet_Product, byte[] rowVersion)
{
ProductReceivePurchaseOrderDetail productReceivePurchaseOrderDetail = new ProductReceivePurchaseOrderDetail();
productReceivePurchaseOrderDetail.Id = ID;
productReceivePurchaseOrderDetail.ReceiveNumber = receiveNumber;
productReceivePurchaseOrderDetail.ReceiveDate = receiveDate;
productReceivePurchaseOrderDetail.ProductReceivePurchaseOrderDet_PurchaseOrderDetail = productReceivePurchaseOrderDet_PurchaseOrderDetail;
productReceivePurchaseOrderDetail.ProductReceivePurchaseOrderDet_Location = productReceivePurchaseOrderDet_Location;
productReceivePurchaseOrderDetail.ReceiveQuantity = receiveQuantity;
productReceivePurchaseOrderDetail.ReceiveUnitCost = receiveUnitCost;
productReceivePurchaseOrderDetail.ReceiveTotalCost = receiveTotalCost;
productReceivePurchaseOrderDetail.ProductReceivePurchaseOrderDet_Product = productReceivePurchaseOrderDet_Product;
productReceivePurchaseOrderDetail.RowVersion = rowVersion;
return productReceivePurchaseOrderDetail;
}
