public OrderRemainItem(OrderRemainItem refObj) { this.Delivery = refObj.Delivery; this.LineNumber = refObj.LineNumber; this.Note = refObj.Note; this.OrderQuantity = refObj.OrderQuantity; this.PartNameEn = refObj.PartNameEn; this.PartNameVn = refObj.PartNameVn; this.PackUnit = refObj.PackUnit; this.PartCode = refObj.PartCode; this.QuotationQuantity = refObj.QuotationQuantity; this.UnitPrice = refObj.UnitPrice; }
public static OrderRemainItem SumRemainOrders(string dCode, string issueNo, string orderNo, string oFrom, string oTo, string iFrom, string iTo) { var dc = VDMS.II.Linq.DCFactory.GetDataContext<VDMS.II.Linq.PartDataContext>(); var oF = DataFormat.DateFromString(oFrom); var oT = DataFormat.DateFromString(oTo); var iF = DataFormat.DateFromString(iFrom); var iT = DataFormat.DateFromString(iTo); var q = GetBaseQuery(dc, dCode, issueNo, oF, oT, iF, iT); if (!string.IsNullOrEmpty(orderNo)) { q = q.Where(p => p.OrderHeader.TipTopNumber == orderNo); } var res = new OrderRemainItem() { OrderQuantity = q.Sum(p => p.OrderQuantity), QuotationQuantity = q.Sum(p => p.QuotationQuantity), Delivery = q.Sum(p => p.DelivaryQuantity), UnitPrice = q.Sum(p => (long)p.UnitPrice * (p.QuotationQuantity - (p.DelivaryQuantity == null ? 0 : p.DelivaryQuantity.Value))), }; return res; }