public JsonResult GetProductsSku(string productIds)
{
var pros = productIds.Split(',').Select(a => long.Parse(a));
var skus = _iProductService.GetSKUs(pros);
var groupSkus = skus.GroupBy(a => a.ProductId);
List <ProductSkuModel> model = new List <ProductSkuModel>();
foreach (var s in groupSkus)
{
ProductSkuModel m = new ProductSkuModel();
m.productId = s.Key;
m.SKUs = s.Select(a => new SKUModel()
{
Id = a.Id,
SalePrice = a.SalePrice,
Size = a.Size,
Stock = a.Stock,
Version = a.Version,
Color = a.Color,
Sku = a.Sku,
AutoId = a.AutoId,
ProductId = a.ProductId
}).ToList();
model.Add(m);
}
return(Json(model));
}
/// <summary>
/// 更新信息
/// </summary>
public int UpdateInfo(SqlTransaction trans, ProductSkuModel proSkuModel, long SN)
{
string key = "Cache_ProductSku_Model_" + SN;
CacheHelper.RemoveCache(key);
return(proSkuDAL.UpdateInfo(trans, proSkuModel, SN));
}
/// <summary>
/// 从缓存读取信息
/// </summary>
public ProductSkuModel GetCacheInfo(SqlTransaction trans, long SN)
{
string key = "Cache_ProductSku_Model_" + SN;
object value = CacheHelper.GetCache(key);
if (value != null)
{
return((ProductSkuModel)value);
}
else
{
ProductSkuModel proSkuModel = proSkuDAL.GetInfo(trans, SN);
CacheHelper.AddCache(key, proSkuModel, null, Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(20), CacheItemPriority.Normal, null);
return(proSkuModel);
}
}
public JsonResult GetProductSKU(long productId)
{
var skus = _iProductService.GetSKUs(productId).ToList();
ProductSkuModel m = new ProductSkuModel();
m.productId = productId;
m.SKUs = skus.Select(a => new SKUModel()
{
Id = a.Id,
SalePrice = a.SalePrice,
Size = a.Size,
Stock = a.Stock,
Version = a.Version,
Color = a.Color,
Sku = a.Sku,
AutoId = a.AutoId,
ProductId = a.ProductId
}).ToList();
// var model=skus.Select(a=>new{a.ProductId,a.SalePrice,a.Size,a.Sku,a.Stock,a.Version});
return(Json(m));
}
public JsonResult GetProductsSku(string productIds)
{
char[] chrArray = new char[] { ',' };
IEnumerable <long> nums =
from a in productIds.Split(chrArray)
select long.Parse(a);
IQueryable <SKUInfo> sKUs = ServiceHelper.Create <IProductService>().GetSKUs(nums);
IQueryable <IGrouping <long, SKUInfo> > productId =
from a in sKUs
group a by a.ProductId;
List <ProductSkuModel> productSkuModels = new List <ProductSkuModel>();
foreach (IGrouping <long, SKUInfo> nums1 in productId)
{
ProductSkuModel productSkuModel = new ProductSkuModel()
{
productId = nums1.Key,
SKUs = (
from a in nums1
select new SKUModel()
{
Id = a.Id,
SalePrice = a.SalePrice,
Size = a.Size,
Stock = a.Stock,
Version = a.Version,
Color = a.Color,
Sku = a.Sku,
AutoId = a.AutoId,
ProductId = a.ProductId
}).ToList()
};
productSkuModels.Add(productSkuModel);
}
return(Json(productSkuModels));
}
public JsonResult GetProductSKU(long productId)
{
List <SKUInfo> list = ServiceHelper.Create <IProductService>().GetSKUs(productId).ToList();
ProductSkuModel productSkuModel = new ProductSkuModel()
{
productId = productId,
SKUs = (
from a in list
select new SKUModel()
{
Id = a.Id,
SalePrice = a.SalePrice,
Size = a.Size,
Stock = a.Stock,
Version = a.Version,
Color = a.Color,
Sku = a.Sku,
AutoId = a.AutoId,
ProductId = a.ProductId
}).ToList()
};
return(Json(productSkuModel));
}
/// <summary>
/// 插入信息
/// </summary>
public int InsertInfo(SqlTransaction trans, ProductSkuModel proSkuModel)
{
return(proSkuDAL.InsertInfo(trans, proSkuModel));
}
public void CartAdd(string DistributorId, long SessionMemberId, string ProductSpuId, string ProductSkuId, int Quantity, string PortfolioId, out int code, out string msg)
{
ProductSpuModel spuModel = Factory.ProductSpu().GetModel(null, ProductSpuId);
if (spuModel != null)
{
if (spuModel.Status == EnumList.ProductSpuStatus.架.ToInt() && (spuModel.OnShelfDate != null && spuModel.OnShelfDate <= DateTimeOffset.Now) && (spuModel.OffShelfDate != null && spuModel.OffShelfDate >= DateTimeOffset.Now))
{
ProductSkuModel skuModel = Factory.ProductSku().GetModel(null, ProductSkuId);
if (skuModel != null)
{
int result = 0;
//判断购物车中是否存在
CartModel cart = null;
if (spuModel.Type == EnumList.ProductProcessType.UploadProcess.ToInt())
{
cart = Factory.Cart().GetModel(null, SessionMemberId, ProductSkuId);
}
else if (spuModel.Type == EnumList.ProductProcessType.DiyProcess.ToInt() && !string.IsNullOrEmpty(PortfolioId))
{
cart = Factory.Cart().GetModelByPortfolioId(null, SessionMemberId, PortfolioId);
}
if (cart != null)
{
cart.Quantity = Math.Min(cart.Quantity + 1, 5000);
cart.LastUpdateDate = DateTimeOffset.Now;
result = Factory.Cart().UpdateInfo(null, cart, cart.CartId);
}
else
{
CartModel carModel = new CartModel()
{
CreationDate = DateTimeOffset.Now,
DistributorId = DistributorId,
IsInvalid = EnumList.IsStatus.No.ToInt(),
IsSelectOrder = EnumList.IsStatus.Yes.ToInt(),
LastUpdateDate = DateTimeOffset.Now,
MemberId = SessionMemberId,
Price = skuModel.Price,
ProductProcessType = spuModel.Type,
ProductSkuId = ProductSkuId,
ProductSpuId = ProductSpuId,
Quantity = Quantity,
Weight = 0,
PortfolioId = PortfolioId
};
result = Factory.Cart().InsertInfo(null, carModel);
}
if (result > 0)
{
code = 1;
msg = "加入成功!";
}
else
{
code = 0;
msg = "加入失败!";
}
}
else
{
code = 0;
msg = "加入失败!";
}
}
else
{
code = 0;
msg = "商品已下架!";
}
}
else
{
code = 0;
msg = "商品信息不存在!";
}
}
