/// <summary>
        /// 
        /// </summary>
        /// <param name="model"></param>
        public void Add(BrandCategoryRelationModel model)
        {
            DbCommand Command = dbw.GetStoredProcCommand("UP_pdBrandCategoryRelation_Add");

            dbw.AddInParameter(Command, "@brandid", DbType.Int32, model.BrandID);
            dbw.AddInParameter(Command, "@cateid", DbType.Int32, model.CategoryID);
            dbw.AddInParameter(Command, "@catepath", DbType.String, model.CategoryPath);

            dbw.ExecuteNonQuery(Command);
        }
        private void AddRelation(int CateID, int BrandID)
        {
            CategoryModel cate = cbll.GetModel(CateID);

            BrandCategoryRelationModel Relation = new BrandCategoryRelationModel()
            {
                BrandID = BrandID,
                CategoryID = CateID,
                CategoryPath = cate.CatePath
            };

            rbll.Add(Relation);

            DataTable sonCates=cbll.GetList(" parentid="+CateID).Tables[0];
            if(sonCates.Rows.Count>0)
            {
                foreach (DataRow row in sonCates.Rows) AddRelation(Convert.ToInt32(row["cateid"]), BrandID);
            }
        }
 /// <summary>
 /// 
 /// </summary>
 /// <param name="model"></param>
 public void Add(BrandCategoryRelationModel model)
 {
     dal.Add(model);
 }