public static bool UpdateNumberById(int bargainDetialId, int number, out int relNumber)
{
bool result = false;
relNumber = number;
BargainInfo bargainInfoByDetialId = BargainHelper.GetBargainInfoByDetialId(bargainDetialId);
if (bargainInfoByDetialId != null)
{
int purchaseNumber = bargainInfoByDetialId.PurchaseNumber;
int num = bargainInfoByDetialId.ActivityStock - bargainInfoByDetialId.TranNumber;
if (num < relNumber)
{
relNumber = num;
}
if (purchaseNumber < relNumber)
{
relNumber = purchaseNumber;
}
if (relNumber > 0)
{
result = new BargainDao().UpdateNumberById(bargainDetialId, relNumber);
}
}
return(result);
}
public static bool UpdateNumberById(int bargainDetialId, int number, out int relNumber)
{
bool flag = false;
relNumber = number;
BargainInfo bargainInfoByDetialId = GetBargainInfoByDetialId(bargainDetialId);
if (bargainInfoByDetialId != null)
{
int purchaseNumber = bargainInfoByDetialId.PurchaseNumber;
int num2 = bargainInfoByDetialId.ActivityStock - bargainInfoByDetialId.TranNumber;
if (num2 < relNumber)
{
relNumber = num2;
}
if (purchaseNumber < relNumber)
{
relNumber = purchaseNumber;
}
if (relNumber > 0)
{
flag = new BargainDao().UpdateNumberById(bargainDetialId, relNumber);
}
}
return(flag);
}
public static List <ShoppingCartInfo> GetListShoppingCart(string productSkuId, int buyAmount, int bargainDetialId = 0, int limitedTimeDiscountId = 0)
{
List <ShoppingCartInfo> list = new List <ShoppingCartInfo>();
ShoppingCartInfo shoppingCartInfo = new ShoppingCartInfo();
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
List <ShoppingCartInfo> result;
if (bargainDetialId > 0)
{
ShoppingCartItemInfo cartItemInfo = new ShoppingCartDao().GetCartItemInfo(currentMember, productSkuId, buyAmount, 0, bargainDetialId, 0);
if (cartItemInfo == null)
{
result = null;
return(result);
}
BargainDetialInfo bargainDetialInfo = new BargainDao().GetBargainDetialInfo(bargainDetialId);
if (bargainDetialInfo == null)
{
result = null;
return(result);
}
shoppingCartInfo.TemplateId = cartItemInfo.FreightTemplateId.ToString();
shoppingCartInfo.Amount = decimal.Round(bargainDetialInfo.Number * bargainDetialInfo.Price, 2);
shoppingCartInfo.Total = shoppingCartInfo.Amount;
shoppingCartInfo.Exemption = 0m;
shoppingCartInfo.ShipCost = 0m;
shoppingCartInfo.GetPointNumber = cartItemInfo.PointNumber * cartItemInfo.Quantity;
shoppingCartInfo.MemberPointNumber = currentMember.Points;
shoppingCartInfo.LineItems.Add(cartItemInfo);
list.Add(shoppingCartInfo);
}
else
{
ShoppingCartItemInfo cartItemInfo = new ShoppingCartDao().GetCartItemInfo(currentMember, productSkuId, buyAmount, 0, 0, limitedTimeDiscountId);
if (cartItemInfo == null)
{
result = null;
return(result);
}
shoppingCartInfo.TemplateId = cartItemInfo.FreightTemplateId.ToString();
shoppingCartInfo.Amount = decimal.Round(cartItemInfo.SubTotal, 2);
shoppingCartInfo.Total = shoppingCartInfo.Amount;
shoppingCartInfo.Exemption = 0m;
shoppingCartInfo.ShipCost = 0m;
shoppingCartInfo.GetPointNumber = cartItemInfo.PointNumber * cartItemInfo.Quantity;
shoppingCartInfo.MemberPointNumber = currentMember.Points;
shoppingCartInfo.LineItems.Add(cartItemInfo);
list.Add(shoppingCartInfo);
}
result = list;
return(result);
}
public static string InsertHelpBargainDetial(HelpBargainDetialInfo helpBargainDetial)
{
string str2 = new BargainDao().IsCanBuyByBarginId(helpBargainDetial.BargainId);
if (str2 != "1")
{
return(str2);
}
if (new BargainDao().InsertHelpBargainDetial(helpBargainDetial))
{
new BargainDao().UpdateBargainDetial(helpBargainDetial);
}
return("1");
}
public static List <ShoppingCartInfo> GetListShoppingCart(string productSkuId, int buyAmount, int bargainDetialId = 0, int limitedTimeDiscountId = 0)
{
List <ShoppingCartInfo> list = new List <ShoppingCartInfo>();
ShoppingCartInfo item = new ShoppingCartInfo();
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
ShoppingCartItemInfo info3 = null;
if (bargainDetialId > 0)
{
info3 = new ShoppingCartDao().GetCartItemInfo(currentMember, productSkuId, buyAmount, 0, bargainDetialId, 0);
if (info3 == null)
{
return(null);
}
BargainDetialInfo bargainDetialInfo = new BargainDao().GetBargainDetialInfo(bargainDetialId);
if (bargainDetialInfo == null)
{
return(null);
}
item.TemplateId = info3.FreightTemplateId.ToString();
item.Amount = decimal.Round(bargainDetialInfo.Number * bargainDetialInfo.Price, 2);
item.Total = item.Amount;
item.Exemption = 0M;
item.ShipCost = 0M;
item.GetPointNumber = info3.PointNumber * info3.Quantity;
item.MemberPointNumber = currentMember.Points;
item.LineItems.Add(info3);
list.Add(item);
return(list);
}
info3 = new ShoppingCartDao().GetCartItemInfo(currentMember, productSkuId, buyAmount, 0, 0, limitedTimeDiscountId);
if (info3 == null)
{
return(null);
}
item.TemplateId = info3.FreightTemplateId.ToString();
item.Amount = decimal.Round(info3.SubTotal, 2);
item.Total = item.Amount;
item.Exemption = 0M;
item.ShipCost = 0M;
item.GetPointNumber = info3.PointNumber * info3.Quantity;
item.MemberPointNumber = currentMember.Points;
item.LineItems.Add(info3);
list.Add(item);
return(list);
}
public static string InsertHelpBargainDetial(HelpBargainDetialInfo helpBargainDetial)
{
string result = string.Empty;
string text = new BargainDao().IsCanBuyByBarginId(helpBargainDetial.BargainId);
if (text != "1")
{
result = text;
}
else
{
if (new BargainDao().InsertHelpBargainDetial(helpBargainDetial))
{
new BargainDao().UpdateBargainDetial(helpBargainDetial);
}
result = "1";
}
return(result);
}
public ShoppingCartItemInfo GetCartItemInfo(MemberInfo member, string skuId, int quantity, int type = 0, int bargainDetialId = 0, int limitedTimeDiscountId = 0)
{
ShoppingCartItemInfo info = null;
DbCommand storedProcCommand = this.database.GetStoredProcCommand("ss_ShoppingCart_GetItemInfo");
this.database.AddInParameter(storedProcCommand, "Quantity", DbType.Int32, quantity);
this.database.AddInParameter(storedProcCommand, "UserId", DbType.Int32, (member != null) ? member.UserId : 0);
this.database.AddInParameter(storedProcCommand, "SkuId", DbType.String, skuId);
this.database.AddInParameter(storedProcCommand, "GradeId", DbType.Int32, (member != null) ? member.GradeId : 0);
this.database.AddInParameter(storedProcCommand, "Type", DbType.Int32, type);
using (IDataReader reader = this.database.ExecuteReader(storedProcCommand))
{
if (!reader.Read())
{
return(info);
}
info = new ShoppingCartItemInfo {
SkuId = skuId,
Quantity = quantity,
MainCategoryPath = reader["MainCategoryPath"].ToString(),
ProductId = (int)reader["ProductId"]
};
if (DBNull.Value != reader["CubicMeter"])
{
info.CubicMeter = (decimal)reader["CubicMeter"];
}
if (DBNull.Value != reader["FreightWeight"])
{
info.FreightWeight = (decimal)reader["FreightWeight"];
}
if (reader["SKU"] != DBNull.Value)
{
info.SKU = (string)reader["SKU"];
}
info.Name = (string)reader["ProductName"];
if (DBNull.Value != reader["Weight"])
{
info.Weight = (int)reader["Weight"];
}
if (DBNull.Value != reader["FreightTemplateId"])
{
info.FreightTemplateId = (int)reader["FreightTemplateId"];
}
else
{
info.FreightTemplateId = 0;
}
if (DBNull.Value != reader["ThirdCommission"])
{
info.ThirdCommission = (decimal)reader["ThirdCommission"];
}
else
{
info.ThirdCommission = 0M;
}
if (DBNull.Value != reader["SecondCommission"])
{
info.SecondCommission = (decimal)reader["SecondCommission"];
}
else
{
info.SecondCommission = 0M;
}
if (DBNull.Value != reader["FirstCommission"])
{
info.FirstCommission = (decimal)reader["FirstCommission"];
}
else
{
info.FirstCommission = 0M;
}
if (DBNull.Value != reader["IsSetCommission"])
{
info.IsSetCommission = (bool)reader["IsSetCommission"];
}
else
{
info.IsSetCommission = false;
}
BargainDetialInfo bargainDetialInfo = null;
if (bargainDetialId > 0)
{
bargainDetialInfo = new BargainDao().GetBargainDetialInfo(bargainDetialId);
}
if ((bargainDetialId > 0) && (bargainDetialInfo != null))
{
info.MemberPrice = info.AdjustedPrice = bargainDetialInfo.Price;
}
else
{
info.MemberPrice = info.AdjustedPrice = decimal.Round((decimal)reader["SalePrice"], 2);
}
if (limitedTimeDiscountId > 0)
{
LimitedTimeDiscountProductInfo info3 = new LimitedTimeDiscountDao().GetLimitedTimeDiscountProductByLimitIdAndProductIdAndUserId(limitedTimeDiscountId, info.ProductId, (member != null) ? member.UserId : 0);
if (((info3 != null) && (info3.BeginTime <= DateTime.Now)) && (DateTime.Now < info3.EndTime))
{
info.MemberPrice = info.AdjustedPrice = decimal.Round(info3.FinalPrice, 2);
info.LimitedTimeDiscountId = limitedTimeDiscountId;
}
else
{
info.LimitedTimeDiscountId = 0;
}
}
else
{
info.LimitedTimeDiscountId = 0;
}
if (DBNull.Value != reader["ThumbnailUrl40"])
{
info.ThumbnailUrl40 = reader["ThumbnailUrl40"].ToString();
}
if (DBNull.Value != reader["ThumbnailUrl60"])
{
info.ThumbnailUrl60 = reader["ThumbnailUrl60"].ToString();
}
if (DBNull.Value != reader["ThumbnailUrl100"])
{
info.ThumbnailUrl100 = reader["ThumbnailUrl100"].ToString();
}
if (DBNull.Value != reader["IsfreeShipping"])
{
info.IsfreeShipping = Convert.ToBoolean(reader["IsfreeShipping"]);
}
string str = string.Empty;
if (reader.NextResult())
{
while (reader.Read())
{
if (((reader["AttributeName"] != DBNull.Value) && !string.IsNullOrEmpty((string)reader["AttributeName"])) && ((reader["ValueStr"] != DBNull.Value) && !string.IsNullOrEmpty((string)reader["ValueStr"])))
{
object obj2 = str;
str = string.Concat(new object[] { obj2, reader["AttributeName"], "：", reader["ValueStr"], "; " });
}
}
}
info.SkuContent = str;
if (reader.NextResult())
{
while (reader.Read())
{
info.Type = 1;
if (DBNull.Value != reader["ProductNumber"])
{
info.ProductNumber = Convert.ToInt32(reader["ProductNumber"]);
}
if (DBNull.Value != reader["PointNumber"])
{
info.PointNumber = Convert.ToInt32(reader["PointNumber"]);
}
if (DBNull.Value != reader["status"])
{
info.Status = Convert.ToInt32(reader["status"]);
}
if (DBNull.Value != reader["exChangeId"])
{
info.ExchangeId = Convert.ToInt32(reader["exChangeId"]);
}
}
return(info);
}
info.Type = 0;
}
return(info);
}
public ShoppingCartItemInfo GetCartItemInfo(DateTime startSendDate, int quantityPerDay, int sendDays, MemberInfo member, string skuId, int quantity, int type = 0, int bargainDetialId = 0, int limitedTimeDiscountId = 0)
{
ShoppingCartItemInfo shoppingCartItemInfo = null;
System.Data.Common.DbCommand storedProcCommand = this.database.GetStoredProcCommand("ss_ShoppingCart_GetItemInfo");
this.database.AddInParameter(storedProcCommand, "Quantity", System.Data.DbType.Int32, quantity);
this.database.AddInParameter(storedProcCommand, "UserId", System.Data.DbType.Int32, (member != null) ? member.UserId : 0);
this.database.AddInParameter(storedProcCommand, "SkuId", System.Data.DbType.String, skuId);
this.database.AddInParameter(storedProcCommand, "GradeId", System.Data.DbType.Int32, (member != null) ? member.GradeId : 0);
this.database.AddInParameter(storedProcCommand, "Type", System.Data.DbType.Int32, type);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(storedProcCommand))
{
if (dataReader.Read())
{
shoppingCartItemInfo = new ShoppingCartItemInfo();
shoppingCartItemInfo.SkuId = skuId;
ShoppingCartItemInfo arg_E7_0 = shoppingCartItemInfo;
shoppingCartItemInfo.ShippQuantity = quantity;
arg_E7_0.Quantity = quantity;
shoppingCartItemInfo.MainCategoryPath = dataReader["MainCategoryPath"].ToString();
shoppingCartItemInfo.ProductId = (int)dataReader["ProductId"];
if (DBNull.Value != dataReader["CubicMeter"])
{
shoppingCartItemInfo.CubicMeter = (decimal)dataReader["CubicMeter"];
}
if (DBNull.Value != dataReader["FreightWeight"])
{
shoppingCartItemInfo.FreightWeight = (decimal)dataReader["FreightWeight"];
}
if (dataReader["SKU"] != DBNull.Value)
{
shoppingCartItemInfo.SKU = (string)dataReader["SKU"];
}
shoppingCartItemInfo.Name = (string)dataReader["ProductName"];
if (DBNull.Value != dataReader["Weight"])
{
shoppingCartItemInfo.Weight = (int)dataReader["Weight"];
}
if (DBNull.Value != dataReader["FreightTemplateId"])
{
shoppingCartItemInfo.FreightTemplateId = (int)dataReader["FreightTemplateId"];
}
else
{
shoppingCartItemInfo.FreightTemplateId = 0;
}
if (DBNull.Value != dataReader["ThirdCommission"])
{
shoppingCartItemInfo.ThirdCommission = (decimal)dataReader["ThirdCommission"];
}
else
{
shoppingCartItemInfo.ThirdCommission = 0m;
}
if (DBNull.Value != dataReader["SecondCommission"])
{
shoppingCartItemInfo.SecondCommission = (decimal)dataReader["SecondCommission"];
}
else
{
shoppingCartItemInfo.SecondCommission = 0m;
}
if (DBNull.Value != dataReader["FirstCommission"])
{
shoppingCartItemInfo.FirstCommission = (decimal)dataReader["FirstCommission"];
}
else
{
shoppingCartItemInfo.FirstCommission = 0m;
}
if (DBNull.Value != dataReader["IsSetCommission"])
{
shoppingCartItemInfo.IsSetCommission = (bool)dataReader["IsSetCommission"];
}
else
{
shoppingCartItemInfo.IsSetCommission = false;
}
BargainDetialInfo bargainDetialInfo = null;
if (bargainDetialId > 0)
{
bargainDetialInfo = new BargainDao().GetBargainDetialInfo(bargainDetialId);
}
if (bargainDetialId > 0 && bargainDetialInfo != null)
{
shoppingCartItemInfo.MemberPrice = (shoppingCartItemInfo.AdjustedPrice = bargainDetialInfo.Price);
}
else
{
shoppingCartItemInfo.MemberPrice = (shoppingCartItemInfo.AdjustedPrice = decimal.Round((decimal)dataReader["SalePrice"], 2));
}
if (limitedTimeDiscountId > 0)
{
LimitedTimeDiscountProductInfo limitedTimeDiscountProductByLimitIdAndProductIdAndUserId = new LimitedTimeDiscountDao().GetLimitedTimeDiscountProductByLimitIdAndProductIdAndUserId(limitedTimeDiscountId, shoppingCartItemInfo.ProductId, (member != null) ? member.UserId : 0);
if (limitedTimeDiscountProductByLimitIdAndProductIdAndUserId != null && limitedTimeDiscountProductByLimitIdAndProductIdAndUserId.BeginTime <= DateTime.Now && DateTime.Now < limitedTimeDiscountProductByLimitIdAndProductIdAndUserId.EndTime)
{
shoppingCartItemInfo.MemberPrice = (shoppingCartItemInfo.AdjustedPrice = decimal.Round(limitedTimeDiscountProductByLimitIdAndProductIdAndUserId.FinalPrice, 2));
shoppingCartItemInfo.LimitedTimeDiscountId = limitedTimeDiscountId;
}
else
{
shoppingCartItemInfo.LimitedTimeDiscountId = 0;
}
}
else
{
shoppingCartItemInfo.LimitedTimeDiscountId = 0;
}
if (DBNull.Value != dataReader["ThumbnailUrl40"])
{
shoppingCartItemInfo.ThumbnailUrl40 = dataReader["ThumbnailUrl40"].ToString();
}
if (DBNull.Value != dataReader["ThumbnailUrl60"])
{
shoppingCartItemInfo.ThumbnailUrl60 = dataReader["ThumbnailUrl60"].ToString();
}
if (DBNull.Value != dataReader["ThumbnailUrl100"])
{
shoppingCartItemInfo.ThumbnailUrl100 = dataReader["ThumbnailUrl100"].ToString();
}
if (DBNull.Value != dataReader["IsfreeShipping"])
{
shoppingCartItemInfo.IsfreeShipping = Convert.ToBoolean(dataReader["IsfreeShipping"]);
}
string text = string.Empty;
if (dataReader.NextResult())
{
while (dataReader.Read())
{
if (dataReader["AttributeName"] != DBNull.Value && !string.IsNullOrEmpty((string)dataReader["AttributeName"]) && dataReader["ValueStr"] != DBNull.Value && !string.IsNullOrEmpty((string)dataReader["ValueStr"]))
{
object obj = text;
text = string.Concat(new object[]
{
obj,
dataReader["AttributeName"],
"：",
dataReader["ValueStr"],
"; "
});
}
}
}
shoppingCartItemInfo.SkuContent = text;
if (dataReader.NextResult())
{
while (dataReader.Read())
{
shoppingCartItemInfo.Type = 1;
if (DBNull.Value != dataReader["ProductNumber"])
{
shoppingCartItemInfo.ProductNumber = Convert.ToInt32(dataReader["ProductNumber"]);
}
if (DBNull.Value != dataReader["PointNumber"])
{
shoppingCartItemInfo.PointNumber = Convert.ToInt32(dataReader["PointNumber"]);
}
if (DBNull.Value != dataReader["status"])
{
shoppingCartItemInfo.Status = Convert.ToInt32(dataReader["status"]);
}
if (DBNull.Value != dataReader["exChangeId"])
{
shoppingCartItemInfo.ExchangeId = Convert.ToInt32(dataReader["exChangeId"]);
}
}
}
else
{
shoppingCartItemInfo.Type = 0;
}
}
}
return(shoppingCartItemInfo);
}
