/// <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); } }
/// <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); } }