public List<FutureOrderInfo> GetMyFutureOrders(MyOrderQry aMyOrderQry) { logger.InfoFormat("GetMyFutureOrders {0}", aMyOrderQry.ToString()); List<BOC.Entities.OrderData> lOrders = _BOCWebDBContext.OrderDatas.Where(e => e.SendCompanyName == aMyOrderQry.username && e.FutureOrSpot == 0) .OrderByDescending(e => e.PostDate) .Skip(aMyOrderQry.pagesize * (aMyOrderQry.page - 1)) .Take(aMyOrderQry.pagesize).ToList(); List<FutureOrderInfo> FutureOrderList = new List<FutureOrderInfo>(); foreach (BOC.Entities.OrderData orderdata in lOrders) { FutureOrderInfo lFutureOrderInfo = new FutureOrderInfo(); lFutureOrderInfo.OrderDataID = orderdata.OrderDataID; lFutureOrderInfo.Cuts = orderdata.Cuts; lFutureOrderInfo.SubCuts = orderdata.SubCuts; lFutureOrderInfo.Grade = orderdata.Grade; lFutureOrderInfo.SubGrade = orderdata.SubGrade; lFutureOrderInfo.Origin = orderdata.Origin; lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; lFutureOrderInfo.Halal = orderdata.Halal; lFutureOrderInfo.Packing = orderdata.Packing; lFutureOrderInfo.Packedon = orderdata.Packedon; lFutureOrderInfo.ExpirationDate = orderdata.ExpirationDate; lFutureOrderInfo.Quantity = orderdata.Quantity; lFutureOrderInfo.ShippingTerm = orderdata.ShippingTerm; lFutureOrderInfo.TargetPriceNegotiate = orderdata.TargetPriceNegotiate; lFutureOrderInfo.TargetPrice = orderdata.TargetPrice.ToString().Trim('0').Trim('.'); lFutureOrderInfo.PhoneContact = orderdata.PhoneContact; lFutureOrderInfo.Payment = orderdata.Payment; lFutureOrderInfo.Shipment = orderdata.Shipment; lFutureOrderInfo.Validity = orderdata.Validity; lFutureOrderInfo.PostDate = orderdata.PostDate; lFutureOrderInfo.Status = orderdata.Status; lFutureOrderInfo.PicLink = orderdata.PicLink; lFutureOrderInfo.SendCompanyName = orderdata.SendCompanyName; lFutureOrderInfo.PhoneContact = orderdata.PhoneContact; lFutureOrderInfo.IsOpen = orderdata.IsOpen; lFutureOrderInfo.BoneinOrLess = orderdata.BoneinOrLess; lFutureOrderInfo.OxType = orderdata.OxType; lFutureOrderInfo.OxAge = orderdata.OxAge; lFutureOrderInfo.RaiseType = orderdata.RaiseType; lFutureOrderInfo.RaiseDays = orderdata.RaiseDays; lFutureOrderInfo.IsPaymentTT = orderdata.IsPaymentTT; lFutureOrderInfo.PaymentFirstPercentage = orderdata.PaymentFirstPercentage; lFutureOrderInfo.PaymentFirst = orderdata.PaymentFirst; lFutureOrderInfo.PaymentSecondPercentage = orderdata.PaymentSecondPercentage; lFutureOrderInfo.PaymentSecond = orderdata.PaymentSecond; lFutureOrderInfo.BoneinOrLess = orderdata.BoneinOrLess; lFutureOrderInfo.ShowCount = _BOCWebDBContext.ShowOrderInfos.Where(e => e.OrderDataID == orderdata.OrderDataID).Count(); int lShowInterestCount = 0; int lReturnInterestCount = 0; int lNotReturnsInterestCount = 0; int lNotShowIntrerestCount = 0; List<BOC.Entities.OrderReturn> lOrderReturns = _BOCWebDBContext.OrderReturns.Where(e => e.OrderDataID == orderdata.OrderDataID).ToList(); foreach (BOC.Entities.OrderReturn orderreturn in lOrderReturns) { lShowInterestCount++; if (orderreturn.RetrurnStatus == 1) { lReturnInterestCount++; } if (orderreturn.RetrurnStatus == 0) { lNotReturnsInterestCount++; } if (!orderreturn.HasShowed) { lNotShowIntrerestCount++; } } lFutureOrderInfo.ShowInterestCount = lShowInterestCount; lFutureOrderInfo.ReturnInterestCount = lReturnInterestCount; lFutureOrderInfo.NotReturnsInterestCount = lNotReturnsInterestCount; lFutureOrderInfo.NotShowIntrerestCount = lNotShowIntrerestCount; FutureOrderList.Add(lFutureOrderInfo); } return FutureOrderList; }
public List<FutureOrderInfo> GetFutureOrders(OrderQry aOrderQry) { List<BOC.Entities.OrderData> lOrders = _BOCWebDBContext.OrderDatas .Where(e => e.BuyOrSell == aOrderQry.OrderSide && e.FutureOrSpot == aOrderQry.OrderType) .OrderByDescending(e => e.PostDate) .Skip(aOrderQry.pagesize * (aOrderQry.page - 1)) .Take(aOrderQry.pagesize).ToList(); List<FutureOrderInfo> FutureOrderList = new List<FutureOrderInfo>(); foreach (BOC.Entities.OrderData orderdata in lOrders) { FutureOrderInfo lFutureOrderInfo = new FutureOrderInfo(); lFutureOrderInfo.OrderDataID = orderdata.OrderDataID; lFutureOrderInfo.Cuts = orderdata.Cuts; lFutureOrderInfo.SubCuts = orderdata.SubCuts; lFutureOrderInfo.Grade = orderdata.Grade; lFutureOrderInfo.SubGrade = orderdata.SubGrade; lFutureOrderInfo.Origin = orderdata.Origin; if (aOrderQry.ShowEstablishmentNumber) { //lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; switch (aOrderQry.UserRoleID) { case 1: break; case 2: if (aOrderQry.UserName == orderdata.SendCompanyName) { lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { BOC.Entities.OrderReturn lOrderReturn = _BOCWebDBContext.OrderReturns.Where(e => e.OrderDataID == orderdata.OrderDataID && e.UserName == aOrderQry.UserName).FirstOrDefault(); if (lOrderReturn != null) { if (lOrderReturn.RetrurnStatus == 1) { lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { if (orderdata.IsOpen) { lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { if (orderdata.EstablishmentNumber != null && orderdata.EstablishmentNumber != "") { lFutureOrderInfo.EstablishmentNumber = "******"; } else { lFutureOrderInfo.EstablishmentNumber = ""; } } } } else { if (orderdata.IsOpen) { lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { if (orderdata.EstablishmentNumber != null && orderdata.EstablishmentNumber != "") { lFutureOrderInfo.EstablishmentNumber = "******"; } else { lFutureOrderInfo.EstablishmentNumber = ""; } } } } break; case 3: if (orderdata.IsOpen) { lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { if (orderdata.EstablishmentNumber != null && orderdata.EstablishmentNumber != "") { lFutureOrderInfo.EstablishmentNumber = "******"; } else { lFutureOrderInfo.EstablishmentNumber = ""; } } break; case 4: if (aOrderQry.UserName == orderdata.SendCompanyName) { lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { BOC.Entities.OrderReturn lOrderReturn = _BOCWebDBContext.OrderReturns.Where(e => e.OrderDataID == orderdata.OrderDataID && e.UserName == aOrderQry.UserName).FirstOrDefault(); if (lOrderReturn != null) { if (lOrderReturn.RetrurnStatus == 1) { lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { if (orderdata.IsOpen) { lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { if (orderdata.EstablishmentNumber != null && orderdata.EstablishmentNumber != "") { lFutureOrderInfo.EstablishmentNumber = "******"; } else { lFutureOrderInfo.EstablishmentNumber = ""; } } } } else { if (orderdata.IsOpen) { lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { if (orderdata.EstablishmentNumber != null && orderdata.EstablishmentNumber != "") { lFutureOrderInfo.EstablishmentNumber = "******"; } else { lFutureOrderInfo.EstablishmentNumber = ""; } } } } break; case 5: if (orderdata.EstablishmentNumber != null && orderdata.EstablishmentNumber != "") { if (orderdata.IsOpen) { lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { lFutureOrderInfo.EstablishmentNumber = "******"; } } else { lFutureOrderInfo.EstablishmentNumber = ""; } break; } } else { if (orderdata.IsOpen) { switch (aOrderQry.UserRoleID) { case 1: break; case 2: lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; break; case 3: lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; break; case 4: lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; break; case 5: lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; break; } //lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { if (aOrderQry.UserName == orderdata.SendCompanyName) { lFutureOrderInfo.EstablishmentNumber = orderdata.EstablishmentNumber; } else { lFutureOrderInfo.EstablishmentNumber = "******"; } } } lFutureOrderInfo.Halal = orderdata.Halal; lFutureOrderInfo.Packing = orderdata.Packing; lFutureOrderInfo.Packedon = orderdata.Packedon; lFutureOrderInfo.ExpirationDate = orderdata.ExpirationDate; lFutureOrderInfo.Quantity = orderdata.Quantity; lFutureOrderInfo.ShippingTerm = orderdata.ShippingTerm; lFutureOrderInfo.TargetPriceNegotiate = orderdata.TargetPriceNegotiate; if(aOrderQry.UserName != null && aOrderQry.UserName != "") { if(aOrderQry.UserName == orderdata.SendCompanyName) { lFutureOrderInfo.TargetPrice = orderdata.TargetPrice.ToString().Trim('0').Trim('.'); } else { switch(aOrderQry.UserRoleID) { case 1: break; case 2: if (aOrderQry.OrderSide == 1) { if (orderdata.IsOpen) { lFutureOrderInfo.TargetPrice = orderdata.TargetPrice.ToString().Trim('0').Trim('.'); } else { lFutureOrderInfo.TargetPrice = "******"; } } else { lFutureOrderInfo.TargetPrice = orderdata.TargetPrice.ToString().Trim('0').Trim('.'); } break; case 3: if (aOrderQry.OrderSide == 1) { if (orderdata.IsOpen) { lFutureOrderInfo.TargetPrice = orderdata.TargetPrice.ToString().Trim('0').Trim('.'); } else { lFutureOrderInfo.TargetPrice = "******"; } } else { lFutureOrderInfo.TargetPrice = orderdata.TargetPrice.ToString().Trim('0').Trim('.'); } break; case 4: if (aOrderQry.OrderSide == 1) { lFutureOrderInfo.TargetPrice = orderdata.TargetPrice.ToString().Trim('0').Trim('.'); } else { if (orderdata.IsOpen) { lFutureOrderInfo.TargetPrice = orderdata.TargetPrice.ToString().Trim('0').Trim('.'); } else { lFutureOrderInfo.TargetPrice = "******"; } } break; case 5: if (orderdata.IsOpen) { lFutureOrderInfo.TargetPrice = orderdata.TargetPrice.ToString().Trim('0').Trim('.'); } else { lFutureOrderInfo.TargetPrice = "******"; } //lFutureOrderInfo.TargetPrice = "******"; break; } } } else { lFutureOrderInfo.TargetPrice = "******"; } /* if (aOrderQry.ShowPrice) { lFutureOrderInfo.TargetPrice = orderdata.TargetPrice.ToString(); } else { lFutureOrderInfo.TargetPrice = "******"; } */ lFutureOrderInfo.Payment = orderdata.Payment; lFutureOrderInfo.Shipment = orderdata.Shipment; lFutureOrderInfo.Validity = orderdata.Validity; lFutureOrderInfo.PostDate = orderdata.PostDate; lFutureOrderInfo.Status = orderdata.Status; lFutureOrderInfo.PicLink = orderdata.PicLink; lFutureOrderInfo.SendCompanyName = orderdata.SendCompanyName; lFutureOrderInfo.IsPaymentTT = orderdata.IsPaymentTT; lFutureOrderInfo.PaymentFirstPercentage = orderdata.PaymentFirstPercentage; lFutureOrderInfo.PaymentFirst = orderdata.PaymentFirst; lFutureOrderInfo.PaymentSecondPercentage = orderdata.PaymentSecondPercentage; lFutureOrderInfo.PaymentSecond = orderdata.PaymentSecond; lFutureOrderInfo.BoneinOrLess = orderdata.BoneinOrLess; lFutureOrderInfo.PhoneContact = orderdata.PhoneContact; lFutureOrderInfo.IsOpen = orderdata.IsOpen; lFutureOrderInfo.OxType = orderdata.OxType; lFutureOrderInfo.OxAge = orderdata.OxAge; lFutureOrderInfo.RaiseType = orderdata.RaiseType; lFutureOrderInfo.RaiseDays = orderdata.RaiseDays; lFutureOrderInfo.ShowCount = _BOCWebDBContext.ShowOrderInfos.Where(e => e.OrderDataID == orderdata.OrderDataID).Count(); int lShowInterestCount = 0; int lReturnInterestCount = 0; int lNotReturnInterestCount = 0; List<BOC.Entities.OrderReturn> lOrderReturns = _BOCWebDBContext.OrderReturns.Where(e => e.OrderDataID == orderdata.OrderDataID).ToList(); foreach (BOC.Entities.OrderReturn orderreturn in lOrderReturns) { lShowInterestCount++; if (orderreturn.RetrurnStatus == 1) { lReturnInterestCount++; } if (orderreturn.RetrurnStatus == 0) { lNotReturnInterestCount++; } } lFutureOrderInfo.ShowInterestCount = lShowInterestCount; lFutureOrderInfo.ReturnInterestCount = lReturnInterestCount; lFutureOrderInfo.NotReturnsInterestCount = lNotReturnInterestCount; FutureOrderList.Add(lFutureOrderInfo); } return FutureOrderList; }