public static void GetMall_ShipRateDetailByCardIDList(int ProductID, List <int> CartIDList, int OrderID, out List <Dictionary <string, object> > list, int ProvinceID = 0, int Quantity = 0, int UserID = 0)
{
list = new List <Dictionary <string, object> >();
var ship_rate_list = Mall_ShipRate.GetMall_ShipRates().ToArray();
if (ProductID > 0)
{
var data = Mall_Product.GetMall_Product(ProductID);
CalculateRateByProductOutDic(ship_rate_list, out list, ProvinceID: ProvinceID, Quantity: Quantity, BusinessID: data.BusinessID);
return;
}
if (OrderID > 0)
{
var orderitem_list = Mall_OrderItem.GetMall_OrderItemListByOrderID(OrderID);
if (orderitem_list.Length == 0)
{
return;
}
var product_list = Mall_Product.GetMall_ProductListByIDList(orderitem_list.Select(p => p.ProductID).ToList());
int TotalQuantity = orderitem_list.Sum(p => p.Quantity);
CalculateRateByProductOutDic(ship_rate_list, out list, ProvinceID: ProvinceID, Quantity: TotalQuantity, BusinessID: orderitem_list[0].BusinessID);
return;
}
if (CartIDList.Count > 0)
{
var cart_list = Foresight.DataAccess.Mall_ShoppingCart.GetMall_ShoppingCartListByIDList(CartIDList, UserID);
var product_list = Foresight.DataAccess.Mall_ProductDetail.GetMall_ProductDetailListByIDList(cart_list.Select(p => p.ProductID).ToList());
var variant_list = Foresight.DataAccess.Mall_Product_VariantDetail.GetMall_Product_VariantDetailListByIDList(cart_list.Select(p => p.VariantID).ToList());
var business_list = Foresight.DataAccess.Mall_Business.GetMall_BusinessListByIDList(product_list.Select(p => p.BusinessID).ToList());
decimal totalprice = 0;
int totalsalepoint = 0;
int TotalQuantity = 0;
string totalpricedesc = string.Empty;
var productlist = Mall_ShoppingCart.getshoppingcartitems(cart_list, product_list, variant_list, 0, string.Empty, out totalprice, out totalsalepoint, out TotalQuantity, out totalpricedesc);
var my_list = new List <Dictionary <string, object> >();
CalculateRateByProductOutDic(ship_rate_list, out my_list, ProvinceID: ProvinceID, Quantity: TotalQuantity, BusinessID: 0);
list.AddRange(my_list);
foreach (var business in business_list)
{
totalprice = 0;
totalsalepoint = 0;
TotalQuantity = 0;
totalpricedesc = string.Empty;
productlist = Mall_ShoppingCart.getshoppingcartitems(cart_list, product_list, variant_list, business.ID, string.Empty, out totalprice, out totalsalepoint, out TotalQuantity, out totalpricedesc);
my_list = new List <Dictionary <string, object> >();
CalculateRateByProductOutDic(ship_rate_list, out my_list, ProvinceID: ProvinceID, Quantity: TotalQuantity, BusinessID: business.ID);
list.AddRange(my_list);
}
}
return;
}
public static void GetMall_ShipRateDetailByKeywords(int ProductID, List <int> CartIDList, int OrderID, out string RateTitle, out decimal RateAmount, out int RateID, out int RateType, int ProvinceID = 0, int Quantity = 0, int UserID = 0)
{
RateTitle = "快递 免邮";
RateAmount = 0;
RateID = 0;
RateType = 0;
if (ProductID > 0)
{
var data = Mall_Product.GetMall_Product(ProductID);
CalculateRateByProduct(data, out RateTitle, out RateAmount, out RateID, out RateType, ProvinceID: ProvinceID, Quantity: Quantity);
return;
}
if (OrderID > 0)
{
var orderitem_list = Mall_OrderItem.GetMall_OrderItemListByOrderID(OrderID);
var product_list = Mall_Product.GetMall_ProductListByIDList(orderitem_list.Select(p => p.ProductID).ToList());
foreach (var item in orderitem_list)
{
var product = product_list.FirstOrDefault(p => p.ID == item.ProductID);
decimal my_rate_amount = 0;
string my_rate_title = string.Empty;
CalculateRateByProduct(product, out my_rate_title, out my_rate_amount, out RateID, out RateType, ProvinceID: ProvinceID, Quantity: item.Quantity);
RateAmount += my_rate_amount;
RateTitle += my_rate_title + " ";
}
return;
}
if (CartIDList.Count > 0)
{
var cartitem_list = Mall_ShoppingCart.GetMall_ShoppingCartListByIDList(CartIDList, UserID);
var product_list = Mall_Product.GetMall_ProductListByIDList(cartitem_list.Select(p => p.ProductID).ToList());
foreach (var item in cartitem_list)
{
var product = product_list.FirstOrDefault(p => p.ID == item.ProductID);
decimal my_rate_amount = 0;
string my_rate_title = string.Empty;
CalculateRateByProduct(product, out my_rate_title, out my_rate_amount, out RateID, out RateType, ProvinceID: ProvinceID, Quantity: item.Quantity);
RateAmount += my_rate_amount;
RateTitle += my_rate_title + " ";
}
return;
}
}
public static Mall_OrderItemDetail[] GetMall_OrderItemDetailListByOrderIDList(List <int> OrderIDList)
{
if (OrderIDList.Count == 0)
{
return(new Mall_OrderItemDetail[] { });
}
List <SqlParameter> parameters = new List <SqlParameter>();
List <string> conditions = new List <string>();
conditions.Add("[OrderID] in (" + string.Join(",", OrderIDList.ToArray()) + ")");
conditions.Add("[ProductTypeID]!=10");
string Statement = @"select ID,OrderID,Quantity,Price,ProductTypeID,ProductID,VariantID from Mall_OrderItem where " + string.Join(" and ", conditions);
var list = GetList <Mall_OrderItemDetail>(Statement, parameters).ToArray();
if (list.Length == 0)
{
return(new Mall_OrderItemDetail[] { });
}
var myList1 = list.Where(p => p.ProductTypeID != 5).ToArray();
var myList2 = list.Where(p => p.ProductTypeID == 5).ToArray();
var ProductIDList = myList1.Select(p => p.ProductID).ToList();
var VariantIDList = myList1.Select(p => p.VariantID).ToList();
var HouseServiceIDList = myList2.Select(p => p.ProductID).ToList();
var HouseServiceTypeIDList = myList2.Select(p => p.VariantID).ToList();
var productList = new Mall_Product[] { };
var variantList = new Mall_Product_Variant[] { };
var houseServiceTypeList = new Wechat_HouseServiceType[] { };
if (ProductIDList.Count > 0)
{
productList = Mall_Product.GetMall_ProductListByIDList(ProductIDList);
}
if (VariantIDList.Count > 0)
{
variantList = Mall_Product_Variant.GetMall_Product_VariantListByIDList(VariantIDList);
}
if (HouseServiceTypeIDList.Count > 0)
{
houseServiceTypeList = Wechat_HouseServiceType.GetWechat_HouseServiceTypes().ToArray();
}
foreach (var item in list)
{
if (item.ProductTypeID == 5)
{
var myType = houseServiceTypeList.FirstOrDefault(p => p.ID == item.VariantID);
if (myType != null)
{
item.BasicPrice = myType.BasicPrice > 0 ? myType.BasicPrice : 0;
continue;
}
}
if (item.ProductTypeID != 5)
{
var myVariant = variantList.FirstOrDefault(p => p.ID == item.VariantID);
if (myVariant != null)
{
item.BasicPrice = myVariant.VariantBasicPrice > 0 ? myVariant.VariantBasicPrice : 0;
continue;
}
var myProduct = productList.FirstOrDefault(p => p.ID == item.ProductID);
if (myProduct != null)
{
item.BasicPrice = myProduct.BasicPrice > 0 ? myProduct.BasicPrice : 0;
continue;
}
}
}
return(list);
}
