/// <summary> /// 添加文章 /// </summary> /// <param name="article"></param> /// <returns></returns> public bool Add(ArticleInfo article) { StringBuilder sql = new StringBuilder(); sql.Append("insert into BigDog_Article(Title,Type_Id,Father_Id,Image_Url,Content,Description,Enabled)"); sql.Append("values(@Title,@Type_Id,@Father_Id@Image_Url,@Content,@Description,@Enabled)"); SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@Title",SqlDbType.NVarChar,50), new SqlParameter("@Type_Id",SqlDbType.Int), new SqlParameter("@Father_Id",SqlDbType.Int), new SqlParameter("@Image_Url",SqlDbType.NVarChar,200), new SqlParameter("@Content",SqlDbType.NVarChar,4000), new SqlParameter("@Description",SqlDbType.NVarChar,200), new SqlParameter("@Enabled",SqlDbType.NVarChar,1) }; parms[0].Value = article.Title; parms[1].Value = article.Type_Id; parms[2].Value = article.Father_Id; parms[3].Value = article.Image_Url; parms[4].Value = article.Content; parms[5].Value = article.Description; parms[6].Value = article.Enabled; return SQLHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0; }
/// <summary> ///根据Id获取文章实体 /// </summary> /// <param name="id"></param> /// <returns></returns> public ArticleInfo GetById(int id) { ArticleInfo article = new ArticleInfo(); StringBuilder sql = new StringBuilder(); sql.Append("select Id,Type_Id,Title,Father_Id,Content,Image_Url,Description,Enabled from BigDog_Article"); sql.Append(" where Id=@Id"); SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@Id",SqlDbType.Int) }; parms[0].Value = id; DataTable dt = new DataTable(); dt = SQLHelper.GetDs(sql.ToString(), parms).Tables[0]; if (dt.Rows.Count > 0) { article.Id = Convert.ToInt32(dt.Rows[0]["Id"]); article.Title = dt.Rows[0]["Title"].ToString(); article.Father_Id = Convert.ToInt32(dt.Rows[0]["Father_Id"].ToString()); article.Image_Url = dt.Rows[0]["Image_Url"].ToString(); article.Enabled = dt.Rows[0]["Enabled"].ToString(); article.Content = dt.Rows[0]["Content"].ToString(); article.Description = dt.Rows[0]["Description"].ToString(); return article; } return null; }
public bool Update(ArticleInfo article) { return Dal.Update(article); }
/// <summary> /// 更新文章实体 /// </summary> /// <param name="article"></param> /// <returns></returns> public bool Update(ArticleInfo article) { StringBuilder sql = new StringBuilder(); sql.Append("upate BigDog_Article set Title=@Title,Father_Id=@Father_Id,Image_Url=@Image_Url,Content=@Content,Description=@Description,Enabled=@Enabled"); sql.Append(" where Id=@Id"); SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@Title",SqlDbType.NVarChar,100), new SqlParameter("@Father_Id",SqlDbType.Int), new SqlParameter("@Image_Url",SqlDbType.VarChar,200), new SqlParameter("@Content",SqlDbType.VarChar,200), new SqlParameter("@Description",SqlDbType.VarChar,200), new SqlParameter("@Enabled",SqlDbType.Date) }; parms[0].Value = article.Title; parms[1].Value = article.Father_Id; parms[2].Value = article.Image_Url; parms[3].Value = article.Content; parms[4].Value = article.Description; parms[5].Value = article.Enabled; return SQLHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0; }
public bool Add(ArticleInfo article) { return Dal.Add(article); }