Esempio n. 1
0
        /// <summary>
        /// 插入标签
        /// </summary>
        /// <param name="targTitle"></param>
        /// <param name="fid"></param>
        public static void AddTarg(string targTitle, int fid)
        {
            using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection"))
            {
                Models.Targs tag = db.SingleOrDefault<Models.Targs>("WHERE tag_title=@0", targTitle);
                if (tag == null)
                {
                    tag = new Models.Targs();
                    tag.Forums = fid;
                    tag.Title = targTitle;
                    db.Save(tag);
                }

                Models.TargsRelation tagr = new Models.TargsRelation();
                tagr.TagID = tag.TagID;
                tagr.ForumsId = fid;
                db.Insert(tagr);
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 插入标签
        /// </summary>
        /// <param name="targTitle"></param>
        /// <param name="fid"></param>
        public static void AddTarg(string targTitle, int fid)
        {
            using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection"))
            {
                Models.Targs tag = db.SingleOrDefault <Models.Targs>("WHERE tag_title=@0", targTitle);
                if (tag == null)
                {
                    tag        = new Models.Targs();
                    tag.Forums = fid;
                    tag.Title  = targTitle;
                    db.Save(tag);
                }

                Models.TargsRelation tagr = new Models.TargsRelation();
                tagr.TagID    = tag.TagID;
                tagr.ForumsId = fid;
                db.Insert(tagr);
            }
        }