/// <summary>
/// 删除操作
/// </summary>
public void Del(SecondAttribute secondAttribute)
{
ContextSession contextSession = ContextFactory.CurrentThreadContext;
secondAttribute.EntityState = System.Data.EntityState.Deleted;
contextSession.Delete(secondAttribute);
contextSession.SaveChange();
}
/// <summary>
/// 修改操作
/// </summary>
public void Updates(SecondAttributeDTO secondAttributeDTO)
{
SecondAttribute secondAttribute = new SecondAttribute().FromEntityData(secondAttributeDTO);
ContextSession contextSession = ContextFactory.CurrentThreadContext;
secondAttribute.EntityState = System.Data.EntityState.Modified;
contextSession.SaveObject(secondAttribute);
contextSession.SaveChanges();
}
/// <summary>
/// 查询卖家所有已存在尺寸/颜色
/// </summary>
/// <param name="sellerID">卖家ID</param>
/// <param name="attributeid">属性ID</param>
/// <returns></returns>
public System.Collections.Generic.IEnumerable <Jinher.AMP.BTP.Deploy.CustomDTO.ColorAndSizeAttributeVM> GetAttributeBySellerID(System.Guid sellerID, Guid attributeid)
{
var query = from n in Jinher.AMP.BTP.BE.Attribute.ObjectSet()
join m in SecondAttribute.ObjectSet().Where(n => n.IsDel == false).OrderBy(n => n.SubTime) on n.Id equals m.AttributeId
where m.AppId == sellerID && n.Id == attributeid
select new ColorAndSizeAttributeVM
{
AppId = n.AppId,
AttributeId = n.Id,
SecondAttributeId = m.Id,
AttributeName = n.Name,
SecondAttributeName = m.Name,
};
return(query);
}
/// <summary>
/// 查询订单下商品
/// </summary>
/// <param name="commodityOrderId"></param>
/// <returns></returns>
public List <OrderItemsVM> SelectOrderItemsByOrderId(Guid commodityOrderId, Guid appId)
{
CommodityCategory cc = new CommodityCategory();
IEnumerable <OrderItemsVM> query = from data in OrderItem.ObjectSet()
join data1 in Commodity.ObjectSet() on data.CommodityId equals data1.Id
where (data.CommodityOrderId == commodityOrderId && data1.CommodityType == 0)
select new OrderItemsVM
{
CommodityOrderId = data.CommodityOrderId,
CommodityId = data.CommodityId,
CommodityIdName = data1.Name,
PicturesPath = data1.PicturesPath,
Price = data.CurrentPrice, //取订单商品列表中的价格
Number = data.Number,
SizeAndColorId = data.ComAttributeIds,
//CommodityCategorys = cc.GetCommodityCategory(data1.Id).Select(n => n.Name).ToList(),
};
query = query.ToList();
//遍历查询商品的类别信息 ps:真的要这么做么？
foreach (var item in query)
{
var category = (from data in CommodityCategory.ObjectSet()
join data1 in Category.ObjectSet() on data.CategoryId equals data1.Id
where data.CommodityId == item.CommodityId && data.AppId == appId
select data1.Name).ToList();
item.CommodityCategorys = category;
}
//获取订单商品的一些信息
List <OrderItemsVM> orderItemsVMList = query.ToList <OrderItemsVM>();
SecondAttribute secondAttribute = new SecondAttribute();
Jinher.AMP.BTP.BE.Attribute attribute = new Jinher.AMP.BTP.BE.Attribute();
//获取app的所有次级属性
List <SecondAttributeDTO> secondAttributeDTOList = secondAttribute.GetSecondAttributeBySellerID(appId);
//获取app的所有属性(目前只有颜色和尺寸两种)
List <Attribute> attributeDTOList = Attribute.ObjectSet().ToList();
List <OrderItemsVM> orderItemslist = new List <OrderItemsVM>();
Collection collect = new Collection();
//遍历商品信息，获取每个商品对应的颜色、尺寸属性
foreach (OrderItemsVM model in orderItemsVMList)
{
List <ComAttibuteDTO> comAlist = new List <ComAttibuteDTO>();
string attributeString = model.SizeAndColorId;
if (!string.IsNullOrWhiteSpace(attributeString))
{
string[] attributeStringArray = attributeString.Split(',');
for (int i = 0; i < attributeStringArray.Length; i++)
{
SecondAttributeDTO tempSecondDTO = secondAttributeDTOList.Where(p => p.Id == Guid.Parse(attributeStringArray[i])).FirstOrDefault();
if (tempSecondDTO != null)
{
Attribute tempDTO = attributeDTOList.Where(p => p.Id == tempSecondDTO.AttributeId).FirstOrDefault();
ComAttibuteDTO comA = new ComAttibuteDTO();
comA.AttributeId = tempDTO.Id;
comA.Code = "1";
comA.SubTime = DateTime.Now;
comA.AttributeName = tempDTO.Name;
comA.CommodityId = model.CommodityId;
comA.SecondAttributeName = tempSecondDTO.Name;
comA.SecondAttributeId = tempSecondDTO.Id;
comAlist.Add(comA);
}
}
}
model.SelectedComAttibutes = comAlist;
orderItemslist.Add(model);
}
return(orderItemslist);
}
public List <SecondAttribute> GetAttributeValueById(List <Guid> attrid, Guid appId)
{
return(SecondAttribute.ObjectSet().Where(n => attrid.Contains(n.AttributeId) && n.AppId == appId).ToList());
}
/// <summary>
/// 查询卖家所有已存在的次级属性
/// </summary>
/// <param name="sellerID">卖家ID</param>
/// <returns></returns>
public List <Jinher.AMP.BTP.Deploy.SecondAttributeDTO> GetSecondAttributeBySellerID(System.Guid sellerID)
{
var query = SecondAttribute.ObjectSet().Where(i => i.AppId == sellerID).OrderBy(n => n.SubTime).ToList();
return(new SecondAttribute().ToEntityDataList(query));
}
