/// <summary> /// 从IDataReader创建BrandInfo /// </summary> public static BrandInfo BuildBrandFromReader(IDataReader reader) { BrandInfo brandInfo = new BrandInfo(); brandInfo.BrandId = TypeHelper.ObjectToInt(reader["brandid"]); brandInfo.DisplayOrder = TypeHelper.ObjectToInt(reader["displayorder"]); brandInfo.Name = reader["name"].ToString(); brandInfo.Logo = reader["logo"].ToString(); return brandInfo; }
/// <summary> /// 创建品牌 /// </summary> /// <param name="brandInfo"></param> public void CreateBrand(BrandInfo brandInfo) { DbParameter[] parms = { GenerateInParam("@displayorder", SqlDbType.Int,4,brandInfo.DisplayOrder), GenerateInParam("@name", SqlDbType.NChar, 20, brandInfo.Name), GenerateInParam("@logo", SqlDbType.NChar,100,brandInfo.Logo) }; string commandText = string.Format("INSERT INTO [{0}brands]([displayorder],[name],[logo]) VALUES(@displayorder,@name,@logo)", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 更新品牌 /// </summary> /// <param name="brandInfo"></param> public void UpdateBrand(BrandInfo brandInfo) { DbParameter[] parms = { GenerateInParam("@displayorder", SqlDbType.Int,4,brandInfo.DisplayOrder), GenerateInParam("@name", SqlDbType.NChar, 20, brandInfo.Name), GenerateInParam("@logo", SqlDbType.NChar,100,brandInfo.Logo), GenerateInParam("@brandid", SqlDbType.Int, 4, brandInfo.BrandId) }; string commandText = string.Format("UPDATE [{0}brands] SET [displayorder]=@displayorder,[name]=@name,[logo]=@logo WHERE [brandid]=@brandid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 创建品牌 /// </summary> /// <param name="brandInfo"></param> public static void CreateBrand(BrandInfo brandInfo) { BrnMall.Core.BMAData.RDBS.CreateBrand(brandInfo); }
/// <summary> /// 创建品牌 /// </summary> /// <param name="brandInfo"></param> public static void CreateBrand(BrandInfo brandInfo) { BrnMall.Data.Brands.CreateBrand(brandInfo); }
/// <summary> /// 更新品牌 /// </summary> /// <param name="brandInfo"></param> public static void UpdateBrand(BrandInfo brandInfo) { BrnMall.Data.Brands.UpdateBrand(brandInfo); BrnMall.Core.BMACache.Remove(CacheKeys.MALL_BRAND_INFO + brandInfo.BrandId); }
/// <summary> /// 获得分类品牌列表 /// </summary> /// <param name="cateId">分类id</param> /// <param name="keyword">关键词</param> /// <returns></returns> public List<BrandInfo> GetCategoryBrandListByKeyword(int cateId, string keyword) { DbParameter[] parms = { GenerateInParam("@cateid", SqlDbType.Int,4,cateId), GenerateInParam("@keyword", SqlDbType.NChar,40,keyword) }; List<BrandInfo> brandList = new List<BrandInfo>(); IDataReader reader = RDBSHelper.ExecuteReader(CommandType.StoredProcedure, string.Format("{0}getcategorybrandlistbykeyword", RDBSHelper.RDBSTablePre), parms); while (reader.Read()) { BrandInfo brandInfo = new BrandInfo(); brandInfo.BrandId = TypeHelper.ObjectToInt(reader["brandid"]); brandInfo.DisplayOrder = TypeHelper.ObjectToInt(reader["displayorder"]); brandInfo.Name = reader["name"].ToString(); brandInfo.Logo = reader["logo"].ToString(); brandList.Add(brandInfo); } reader.Close(); return brandList; }
public ActionResult Add(BrandModel model) { if (AdminBrands.GetBrandIdByName(model.BrandName) > 0) ModelState.AddModelError("BrandName", "名称已经存在"); if (ModelState.IsValid) { BrandInfo brandInfo = new BrandInfo() { DisplayOrder = model.DisplayOrder, Name = model.BrandName, Logo = model.Logo }; AdminBrands.CreateBrand(brandInfo); AddMallAdminLog("添加品牌", "添加品牌,品牌为:" + model.BrandName); return PromptView("品牌添加成功"); } Load(); return View(model); }