/// <summary> /// 插入文章明细 /// </summary> /// <param name="artdetail"></param> /// <returns></returns> public int InsertArticleDetail(ArticleDetail artdetail) { int rowcount = 0; string sqltxt = @"INSERT INTO qds157425440_db.dbo.ArticleDetail ( AID , CategoryID , CategoryName , AContent , Summary , Authorname , ADetailtext ) VALUES ( @AID , @CategoryID , @CategoryName , @AContent , @Summary , @Authorname , @ADetailtext )"; SqlParameter[] paramter = { new SqlParameter("@AID",artdetail.AID), new SqlParameter("@CategoryID",artdetail.CategoryID), new SqlParameter("@CategoryName",artdetail.CategoryName), new SqlParameter("@AContent",artdetail.AContent), new SqlParameter("@Summary",artdetail.Summary), new SqlParameter("@Authorname",artdetail.Authorname), new SqlParameter("@ADetailtext",artdetail.ADetailtext) }; rowcount = helper.ExecuteSql(sqltxt, paramter); return rowcount; }
/// <summary> /// 根据ID查找文章 /// </summary> /// <param name="artid"></param> /// <returns></returns> public ArticleInfo GetArticleinfoByID(int artid) { ArticleInfo model = new ArticleInfo(); string sqltxt = @"SELECT AID , TitleName , ViceTitleName , AuthorID , AuthorName , PublishTime , Astatus , MainPicURL , PicWidth , PicHeight , Addtime , Updatetime , CategoryID , CategoryName , Tags , Summary , DSummary , ClickCount , IsTop , SourceUrl , AFrom FROM qds157425440_db.dbo.ArticleInfo WITH(NOLOCK) WHERE AID=@id AND Astatus=30"; SqlParameter[] paramter = { new SqlParameter("@id", artid) }; DataSet ds = helper.Query(sqltxt, paramter); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { model.AID = int.Parse(ds.Tables[0].Rows[0]["AID"].ToString()); model.TitleName = ds.Tables[0].Rows[0]["TitleName"].ToString(); model.ViceTitleName = ds.Tables[0].Rows[0]["ViceTitleName"].ToString(); model.AuthorID = int.Parse(ds.Tables[0].Rows[0]["AuthorID"].ToString()); model.AuthorName = ds.Tables[0].Rows[0]["AuthorName"].ToString(); model.PublishTime = DateTime.Parse(ds.Tables[0].Rows[0]["PublishTime"].ToString()); model.Astatus = int.Parse(ds.Tables[0].Rows[0]["Astatus"].ToString()); model.MainPicURL = ds.Tables[0].Rows[0]["MainPicURL"].ToString(); model.PicWidth = int.Parse(ds.Tables[0].Rows[0]["PicWidth"].ToString()); model.PicHeight = int.Parse(ds.Tables[0].Rows[0]["PicHeight"].ToString()); model.Addtime = DateTime.Parse(ds.Tables[0].Rows[0]["Addtime"].ToString()); model.Updatetime = DateTime.Parse(ds.Tables[0].Rows[0]["Updatetime"].ToString()); model.CategoryID = int.Parse(ds.Tables[0].Rows[0]["CategoryID"].ToString()); model.CategoryName = ds.Tables[0].Rows[0]["CategoryName"].ToString(); model.Tags = ds.Tables[0].Rows[0]["Tags"].ToString(); model.Summary = ds.Tables[0].Rows[0]["Summary"].ToString(); model.DSummary = ds.Tables[0].Rows[0]["DSummary"].ToString(); model.ClickCount = int.Parse(ds.Tables[0].Rows[0]["ClickCount"].ToString()); model.IsTop = int.Parse(ds.Tables[0].Rows[0]["IsTop"].ToString()); model.SourceUrl = ds.Tables[0].Rows[0]["SourceUrl"].ToString(); model.AFrom = ds.Tables[0].Rows[0]["AFrom"].ToString(); } else { return null; } } sqltxt = @"SELECT AID , CategoryID , CategoryName , AContent , Summary , Authorname , ADetailtext FROM qds157425440_db.dbo.ArticleDetail WITH(NOLOCK) WHERE AID=@id"; ds = helper.Query(sqltxt, paramter); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { ArticleDetail details = new ArticleDetail(); details.AID = int.Parse(ds.Tables[0].Rows[0]["AID"].ToString()); details.AContent = ds.Tables[0].Rows[0]["AContent"].ToString(); details.Authorname = ds.Tables[0].Rows[0]["Authorname"].ToString(); details.CategoryID = int.Parse(ds.Tables[0].Rows[0]["CategoryID"].ToString()); details.CategoryName = ds.Tables[0].Rows[0]["CategoryName"].ToString(); details.Summary = ds.Tables[0].Rows[0]["Summary"].ToString(); details.ADetailtext = ds.Tables[0].Rows[0]["ADetailtext"].ToString(); model.Details = details; } } return model; }