protected void ODS_TransportationAddress_Inserting(object sender, ObjectDataSourceMethodEventArgs e) { transportationAddress = (TransportationAddress)e.InputParameters[0]; transportationAddress.Country = transportationAddress.Country.Trim(); transportationAddress.Province = transportationAddress.Province.Trim(); transportationAddress.City = transportationAddress.City.Trim(); transportationAddress.District = transportationAddress.District.Trim(); transportationAddress.Address = transportationAddress.Address.Trim(); }
public virtual void DeleteTransportationAddress(TransportationAddress entity) { Delete(entity); }
public virtual void UpdateTransportationAddress(TransportationAddress entity) { Update(entity); }
public virtual void CreateTransportationAddress(TransportationAddress entity) { Create(entity); }
public TransportPriceListDetail GetLastestTransportPriceListDetail(TransportPriceList priceList, Item item, DateTime effectiveDate, Currency currency, Uom uom, string pricingMethod, TransportationAddress shipFrom, TransportationAddress shipTo, string priceListType, string billingMethod, string vehicleType, string transportMethod) { DetachedCriteria detachedCriteria = DetachedCriteria.For <TransportPriceListDetail>(); detachedCriteria.Add(Expression.Eq("TransportPriceList.Code", priceList.Code)); if (item != null) { detachedCriteria.Add(Expression.Eq("Item.Code", item.Code)); } detachedCriteria.Add(Expression.Eq("Currency.Code", currency.Code)); if (uom != null) { detachedCriteria.Add(Expression.Eq("Uom.Code", uom.Code)); } detachedCriteria.Add(Expression.Le("StartDate", effectiveDate)); detachedCriteria.Add(Expression.Or(Expression.Ge("EndDate", effectiveDate.Date), Expression.IsNull("EndDate"))); if (pricingMethod != null && pricingMethod != string.Empty) { detachedCriteria.Add(Expression.Eq("PricingMethod", pricingMethod)); } if (shipFrom != null) { detachedCriteria.Add(Expression.Eq("ShipFrom.Id", shipFrom.Id)); } if (shipTo != null) { detachedCriteria.Add(Expression.Eq("ShipTo.Id", shipTo.Id)); } if (billingMethod != null && billingMethod != string.Empty) { detachedCriteria.Add(Expression.Eq("BillingMethod", billingMethod)); } if (vehicleType != null && vehicleType != string.Empty) { detachedCriteria.Add(Expression.Eq("VehicleType", vehicleType)); } detachedCriteria.Add(Expression.Eq("Type", priceListType)); if (transportMethod != null && transportMethod != string.Empty) { detachedCriteria.Add(Expression.Eq("TransportMethod", transportMethod)); } detachedCriteria.AddOrder(Order.Desc("StartDate")); //按StartDate降序,取最新的价格 IList <TransportPriceListDetail> priceListDetailList = criteriaMgr.FindAll <TransportPriceListDetail>(detachedCriteria); if (priceListDetailList != null && priceListDetailList.Count > 0) { return(priceListDetailList[0]); } else { return(null); } }
public TransportPriceListDetail GetLastestTransportPriceListDetail(TransportPriceList priceList, DateTime effectiveDate, Currency currency, string pricingMethod, TransportationAddress shipFrom, TransportationAddress shipTo, string priceListType, string vehicleType, string transportMethod) { return(GetLastestTransportPriceListDetail(priceList, null, effectiveDate, currency, null, pricingMethod, shipFrom, shipTo, priceListType, null, vehicleType, transportMethod)); }
public TransportPriceListDetail GetLastestLadderStereTransportPriceListDetail(TransportPriceList priceList, Item item, DateTime effectiveDate, Currency currency, Uom uom, string pricingMethod, TransportationAddress shipFrom, TransportationAddress shipTo, string priceListType, string billingMethod, string vehicleType, decimal qty) { TransportPriceListDetail priceListDetail = null; DetachedCriteria detachedCriteria = DetachedCriteria.For <TransportPriceListDetail>(); detachedCriteria.Add(Expression.Eq("TransportPriceList.Code", priceList.Code)); if (item != null) { detachedCriteria.Add(Expression.Eq("Item.Code", item.Code)); } detachedCriteria.Add(Expression.Eq("Currency.Code", currency.Code)); if (uom != null) { detachedCriteria.Add(Expression.Eq("Uom.Code", uom.Code)); } detachedCriteria.Add(Expression.Le("StartDate", effectiveDate)); detachedCriteria.Add(Expression.Or(Expression.Ge("EndDate", effectiveDate.Date), Expression.IsNull("EndDate"))); if (pricingMethod != null && pricingMethod != string.Empty) { detachedCriteria.Add(Expression.Eq("PricingMethod", pricingMethod)); } if (shipFrom != null) { detachedCriteria.Add(Expression.Eq("ShipFrom.Id", shipFrom.Id)); } if (shipTo != null) { detachedCriteria.Add(Expression.Eq("ShipTo.Id", shipTo.Id)); } if (billingMethod != null && billingMethod != string.Empty) { detachedCriteria.Add(Expression.Eq("BillingMethod", billingMethod)); } if (vehicleType != null && vehicleType != string.Empty) { detachedCriteria.Add(Expression.Eq("VehicleType", vehicleType)); } detachedCriteria.Add(Expression.Eq("Type", priceListType)); detachedCriteria.Add(Expression.IsNotNull("StartQty")); // detachedCriteria.Add(Expression.IsNotNull("EndQty")); detachedCriteria.AddOrder(Order.Desc("StartDate")); //按StartDate降序,取最新的价格 IList <TransportPriceListDetail> priceListDetailList = criteriaMgr.FindAll <TransportPriceListDetail>(detachedCriteria); if (priceListDetailList != null && priceListDetailList.Count > 0) { priceListDetail = priceListDetailList.Where(p => p.StartQty.Value < qty && (p.EndQty == null || p.EndQty.Value >= qty)).FirstOrDefault(); if (priceListDetail == null) { priceListDetail = priceListDetailList.OrderBy(p => p.StartQty.Value).FirstOrDefault(); } } return(priceListDetail); }