/// <summary> /// 根据商品组代码获取商品 /// 返回部分列数据 /// </summary> /// <param name="platformType">平台类型</param> /// <param name="groupCode">组代码</param> /// <returns>商品列表</returns> /// <remarks>2013-08-21 周瑜 创建</remarks> public IList <Model.FeProductItem> GetFeProductItems(ForeStatus.商品组平台类型 platformType, string groupCode) { var items = (List <Model.FeProductItem>) CacheManager.Get(CacheKeys.Items.WebProductItem_, groupCode, () => DataAccess.Web.IFeProductItemDao.Instance.GetFeProductItems(platformType, groupCode)); return(items); }
/// <summary> /// 根据商品组编号查询商品组 /// </summary> /// <param name="code">商品组编号</param> /// <param name="platform"></param> /// <returns>商品组</returns> /// <remarks>2013-08-21 周瑜 创建</remarks> public override IList <FeProductGroup> GetModelByGroupcode(string code, ForeStatus.商品组平台类型 platform) { return(Context.Select <FeProductGroup>("*") .From("FeProductGroup") .Where("Code=@Code and PlatformType=@PlatformType and Status=@Status") .Parameter("Code", code) .Parameter("PlatformType", (int)platform) .Parameter("Status", (int)ForeStatus.商品组状态.启用) .OrderBy("DisplayOrder asc") .QueryMany()); }
/// <summary> /// 根据商品组代码获取商品 /// 返回部分列数据 /// </summary> /// <param name="platformType">平台类型</param> /// <param name="groupCode">组代码</param> /// <returns>商品列表</returns> /// <remarks>2013-08-06 黄波 创建</remarks> public override IList <Model.FeProductItem> GetFeProductItems(ForeStatus.商品组平台类型 platformType, string groupCode) { string sql = @" select fi.ProductSysNo,fi.BeginDate,fi.EndDate,fi.DisplayOrder,fi.DispalySymbol,fi.DealerSysNo,fi.Status from FeProductItem fi where fi.GroupSysNo=(select fg.sysno from FeProductGroup fg where fg.code=@Code and fg.Status=@FGStatus and fg.PlatformType=@PlatformType ) and fi.Status=@Status order by fi.DisplayOrder desc "; return(Context.Sql(sql) .Parameter("Code", groupCode) .Parameter("FGStatus", (int)ForeStatus.商品组状态.启用) .Parameter("PlatformType", (int)platformType) .Parameter("Status", (int)ForeStatus.商品项状态.已审) .QueryMany <Model.FeProductItem>()); }
/// <summary> /// 根据商品组编号查询商品组 /// </summary> /// <param name="code">商品组编号</param> /// <param name="platform">商品组平台类型</param> /// <returns>商品组</returns> /// <remarks>2013-08-21 周瑜 创建</remarks> public abstract IList <FeProductGroup> GetModelByGroupcode(string code, ForeStatus.商品组平台类型 platform);
/// <summary> /// 根据商品组代码获取商品 /// 返回部分列数据 /// </summary> /// <param name="platformType">平台类型</param> /// <param name="groupCode">组代码</param> /// <returns>商品列表</returns> /// <remarks>2013-08-06 黄波 创建</remarks> public abstract IList <Model.FeProductItem> GetFeProductItems(ForeStatus.商品组平台类型 platformType, string groupCode);
/// <summary> /// 根据商品组编号查询商品组 /// </summary> /// <param name="code">商品组编号</param> /// <param name="platform">商品组平台类型</param> /// <returns>商品组</returns> /// <remarks>2013-08-21 周瑜 创建</remarks> public IList <FeProductGroup> GetModelByGroupcode(string code, ForeStatus.商品组平台类型 platform) { return(IFeProductGroupDao.Instance.GetModelByGroupcode(code, platform)); }