/// <summary> /// 获得商品的sku列表 /// </summary> /// <param name="skuGid">sku组id</param> /// <returns></returns> public static List <ExtProductSKUItemInfo> GetProductSKUListBySKUGid(int skuGid) { List <ExtProductSKUItemInfo> productSKUList = null; if (_productnosql != null) { productSKUList = _productnosql.GetProductSKUListBySKUGid(skuGid); if (productSKUList == null) { productSKUList = new List <ExtProductSKUItemInfo>(); IDataReader reader = BrnShop.Core.BSPData.RDBS.GetProductSKUListBySKUGid(skuGid); while (reader.Read()) { ExtProductSKUItemInfo extProductSKUItemInfo = BuildExtProductSKUItemFromReader(reader); productSKUList.Add(extProductSKUItemInfo); } reader.Close(); _productnosql.CreateProductSKUList(skuGid, productSKUList); } } else { productSKUList = new List <ExtProductSKUItemInfo>(); IDataReader reader = BrnShop.Core.BSPData.RDBS.GetProductSKUListBySKUGid(skuGid); while (reader.Read()) { ExtProductSKUItemInfo extProductSKUItemInfo = BuildExtProductSKUItemFromReader(reader); productSKUList.Add(extProductSKUItemInfo); } reader.Close(); } return(productSKUList); }
/// <summary> /// 从IDataReader创建ExtProductSKUItemInfo /// </summary> public static ExtProductSKUItemInfo BuildExtProductSKUItemFromReader(IDataReader reader) { ExtProductSKUItemInfo extProductSKUItemInfo = new ExtProductSKUItemInfo(); extProductSKUItemInfo.RecordId = TypeHelper.ObjectToInt(reader["recordid"]); extProductSKUItemInfo.SKUGid = TypeHelper.ObjectToInt(reader["skugid"]); extProductSKUItemInfo.Pid = TypeHelper.ObjectToInt(reader["pid"]); extProductSKUItemInfo.AttrId = TypeHelper.ObjectToInt(reader["attrid"]); extProductSKUItemInfo.AttrValueId = TypeHelper.ObjectToInt(reader["attrvalueid"]); extProductSKUItemInfo.InputValue = reader["inputvalue"].ToString(); extProductSKUItemInfo.AttrValue = reader["attrvalue"].ToString(); extProductSKUItemInfo.IsInput = TypeHelper.ObjectToInt(reader["isinput"]); extProductSKUItemInfo.AttrName = reader["attrname"].ToString(); extProductSKUItemInfo.AttrShowType = TypeHelper.ObjectToInt(reader["attrshowtype"]); extProductSKUItemInfo.ShowImg = reader["showimg"].ToString(); return(extProductSKUItemInfo); }