/// <summary> /// 根据标签名获取标签 /// </summary> /// <param name="labelTitle"></param> /// <returns></returns> public static ArticleLabel GetLabelByTitle(string labelTitle) { ArticleLabel articleLabel = null; using (BlogEntities blogEntities = new BlogEntities()) { articleLabel = (from label in blogEntities.ArticleLabel.Include("Article") where label.Title == labelTitle select label).FirstOrDefault(); } return(articleLabel); }
public int Add(int articleId, int lableId) { var model = new ArticleLabel(); model.ArticleId = articleId; model.LabelId = lableId; if (ContextUser.IsLogined) { model.CreateUser = ContextUser.Email; } var time = DateTime.Now; model.CreateTime = time; model.UpdateTime = time; model.Enable = 1; var id = _articleLabelRepository.Add(model); return(id); }
public int Add(ArticleLabel model) { string cmdText = "insert into ArticleLabel values(?,?,?,?,?,?);select last_insert_rowid() newid;"; object[] paramList = { model.LabelId, model.ArticleId, model.CreateUser, model.CreateTime, model.UpdateTime, model.Enable }; object result = SQLiteHelper.ExecuteScalar(cmdText, paramList); int intResult; if (int.TryParse(result.ToString(), out intResult)) { return(intResult); } return(0); }