BLL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
///SortInfoManager 的摘要说明
/// </summary>
public class SortInfoManager
{
public static List<Sort> GetSortsBig()//获取大类信息
{
return SortInfo.GetSortsBig();
}
public static List<Sort> GetSortId(string fatherId)//通过父类Id获取其下面的小类
{
return SortInfo.GetSortId(fatherId);
}
public static Sort GetsortBig(string sortId)//通过小类Id获取大类
{
return SortInfo.GetsortBig(sortId);
}
#region 通过小类Id获取其中类
public static Sort GetmSortBysSortId(string sortId)
{
return SortInfo.GetmSortBysSortId(sortId);
}
#endregion
#region 通过类别Id获取其类别
public static Sort GetSortBySortId(string sortId)
{
return SortInfo.GetSortBySortId(sortId);
}
#endregion
public static List<Sort> GetZhongSorts(string sortId) //通过小类Id获取所有中类信息
{
return SortInfo.GetZhongSorts(sortId);
}
public static List<Brand> GetBrandBySortId(string sortId)//通过小类SortId获取小类下面的品牌信息
{
return SortInfo.GetBrandBySortId(sortId);
}
#region 通过中类Id获取其下面的品牌
public static List<Brand> GetBrandByMSortId(string sortId)
{
return SortInfo.GetBrandByMSortId(sortId);
}
#endregion
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
///RegistrationInfoManager 的摘要说明
/// </summary>
public class RegistrationInfoManager
{
public static int InsertRegistration(string registerEmail, string registerPassword, bool isActive, DateTime registerTime)
{
int isOk = RegistrationInfo.InsertRegistration(registerEmail, registerPassword, isActive, registerTime);
return isOk;
}
public static Registration GetRegistrationByName(string registerEmail)
{
return RegistrationInfo.GetRegistrationByName(registerEmail);
}
public static Registration GetuserWordMatching(string registerEmail, string passWord)
{
return RegistrationInfo.GetuserWordMatching(registerEmail, passWord);
}
#region 求出最新插入的用户Id
public static void GetMaxRegistrationId(out int registrationId)
{
RegistrationInfo.GetMaxRegistrationId(out registrationId);
}
#endregion
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
///CommodityInfoManager 的摘要说明
/// </summary>
public class CommodityInfoManager
{
//-- 通过小类SortId 获取热卖推荐商品
public static List<HotRecommendDetail> GetRecommentSkuDetaiBySordId(string sortId)
{
return CommodityInfo.GetRecommentSkuDetaiBySordId(sortId);
}

/// <summary>
/// 通过商品ID获取热销商品
/// </summary>
/// <param name="a">要添加的商品</param>
/// <returns>返回热销商品</returns>
public static List<HotRecommendDetail> GetHotSaleCommodityById(string commodityId)
{
return CommodityInfo.GetHotSaleCommodityById(commodityId);
}
//通过小类SortId获取小类下面的品牌信息
public static List<Brand> GetBrandBySortId(string sortId)
{
return CommodityInfo.GetBrandBySortId(sortId);
}
//通过小类Id获取其筛选属性
public static List<Selection> GetSelectionBySortId(string sortId)
{
return CommodityInfo.GetSelectionBySortId(sortId);
}
//通过筛选属性Id获取其筛选属性值
public static List<SelectionValue> GetSelectionValuesBySortId(string selectionId)
{
return CommodityInfo.GetSelectionValuesBySortId(selectionId);
}
#region 通过商品筛选属性值Id获取其商品筛选属性
public static Selection GetSelectionBySelectionValueId(string selectionValueId)
{
return CommodityInfo.GetSelectionBySelectionValueId(selectionValueId);
}
#endregion
#region 通过筛选属性值Id获取其筛选值类别
public static SelectionValue GetSelectionVlaueBySelectionValueId(string selectionValueId)
{
return CommodityInfo.GetSelectionVlaueBySelectionValueId(selectionValueId);
}
#endregion
//通过小类SortId获取商品
public static List<Commodity> GetCommodityBySortId(string sortId)
{
return CommodityInfo.GetCommodityBySortId(sortId);
}
//通过商品CommodityId获取SKU
public static List<Sku> GetSkuByCommodityId(string commodityId)
{
return CommodityInfo.GetSkuByCommodityId(commodityId);
}
//通过SkuAttributeValueId 获取SKu属性值
public static SkuAttributeValue GetSkuAttributeValueById(string skuAttributeValueId)
{
return CommodityInfo.GetSkuAttributeValueById(skuAttributeValueId);
}
//--通过SkuId获取相册表中一张小图片--
public static SkuPicture GetPictureBySkuId(string skuId)
{
return CommodityInfo.GetPictureBySkuId(skuId);
}
// ----通过商品Id获取中类集合
public static List<Sort> GetMiddleSortsByCommodityId(string commodityId)
{
return CommodityInfo.GetMiddleSortsByCommodityId(commodityId);
}
//----通过skuId获取商品浏览记录
public static VisitedSku GetSkuCommodityInfoBySkuId(string skuId)
{
return CommodityInfo.GetSkuCommodityInfoBySkuId(skuId);
}
// ----通过商品Id获取大类
public static Sort GetBigSortByCommodityId(string commodityId)
{
return CommodityInfo.GetBigSortByCommodityId(commodityId);
}
//通过商品Id获取中类
public static Sort GetMiddleSortByCommodityId(string commodityId)
{
return CommodityInfo.GetMiddleSortByCommodityId(commodityId);
}
//----通过商品Id获取小类
public static Sort GetSmallSortByCommodityId(string commodityId)
{
return CommodityInfo.GetSmallSortByCommodityId(commodityId);
}
//通过商品Id获取品牌
public static Brand GetBrandByCommodityId(string commodityId)
{
return CommodityInfo.GetBrandByCommodityId(commodityId);
}
#region 通过品牌Id获取其品牌
public static Brand GetBrandByBrandId(string brandId)
{
return CommodityInfo.GetBrandByBrandId(brandId);
}
#endregion
//---通过SkuId获取商品与SKu码----
public static CommoditySku GetCommoditySkuByCommodityId(string skuId)
{
return CommodityInfo.GetCommoditySkuByCommodityId(skuId);
}
//---通过商品ID获取商品下面的Skus集合----
public static List<Sku> GetSkusByCommodityId(string commodityId)
{
return CommodityInfo.GetSkusByCommodityId(commodityId);
}
//-- 通过SkuId获取相册集合
public static List<SkuPicture> GetSkuPictureBySkuId(string skuId)
{
return CommodityInfo.GetSkuPictureBySkuId(skuId);
}
//**** 通过skuId获取其对应的一个Sku***
public static Sku GetSkuOneBySkuId(string skuId)
{
return CommodityInfo.GetSkuOneBySkuId(skuId);
}
//---***通过商品Id和skuCode获取SKU***
public static Sku GetSkuByCommodityIdAndSkuCode(string commodityId, string skuCode)
{
return CommodityInfo.GetSkuByCommodityIdAndSkuCode(commodityId, skuCode);
}
//---***通过属性SkuAttributeId其SkuAttribute属性**
public static SkuAttribute GetSkuAttributeBySkuAttributeId(string skuAttributeId)
{
return CommodityInfo.GetSkuAttributeBySkuAttributeId(skuAttributeId);
}
#region 通过商品筛选条件提取商品
public static List<SelectCommodity> GetSelectionConditionCommodities(string sortId, string brandId, string priceA, string priceB, string strSelectionValueId, out int howManyCommodities)
{
return CommodityInfo.GetSelectionConditionCommodities(sortId, brandId, priceA, priceB, strSelectionValueId,out howManyCommodities);
}
#endregion
#region 用Ajax提取分页商品
public static string GetExtractCommodityAjax(string sortId, string brandId, string pageNumber, out int howManyPages)
{
return CommodityInfo.GetExtractCommodityAjax(sortId, brandId, pageNumber, out howManyPages);
}
#endregion
#region 商品分页用Ajax分页
public static List<SelectCommodity> GetExtractCommodity(string sortId, string brandId, string pageNumber, out int howManyPages)
{
return CommodityInfo.GetExtractCommodity(sortId, brandId, pageNumber, out howManyPages);
}
#endregion
#region 商品分页用刷新筛选
public static List<SelectCommodity> GetExtractCommodityRefresh(string sortId, string brandId, string priceA, string priceB, string pageNumber, string strSelectionValueId, string orderAse, out int howManyPages, out int howManyCommodities)
{
return CommodityInfo.GetExtractCommodityRefresh(sortId, brandId, priceA, priceB, pageNumber, strSelectionValueId,orderAse, out howManyPages,out howManyCommodities);
}
#endregion
}