/// <summary> /// Deletepages the specified page. /// </summary> /// <param name="page">The page.</param> /// <returns></returns> public int Deletepage(EBlogPage page) { return ExecuteNonQuery( @"Delete TBlogPage WHERE pageID = @pageID;", CreateParameter("@pageID", page.PageID)); }
/// <summary> /// Insertpages the specified page. /// </summary> /// <param name="page">The page.</param> /// <returns></returns> public int Insertpage(EBlogPage page) { return ExecuteInsertQueryReturnID( "TBlogPage", new Dictionary<string, object>() { {"BlogID", page.BlogID}, {"Title", page.Title}, {"Content", page.Content}, {"Summary", page.Summary}, {"PublishDate", page.PublishDate}, {"LastModifiedDate", page.LastModifiedDate}, {"Author", page.Author}, {"IsPublished", page.IsPublished}, {"Visible", page.Visible}, {"ReadCount", page.ReadCount}, {"OrderNo", page.OrderNo}, {"ParentPageID", page.ParentPageID}, }); }
/// <summary> /// Updatepages the specified page. /// </summary> /// <param name="page">The page.</param> /// <returns></returns> public int Updatepage(EBlogPage page) { return ExecuteNonQuery( @"UPDATE TBlogPage SET BlogID = @BlogID, Title = @Title, [Content] = @Content, Summary = @Summary, PublishDate = @PublishDate, LastModifiedDate = @LastModifiedDate, Author = @Author, IsPublished = @IsPublished, Visible = @Visible, ReadCount = @ReadCount, OrderNo = @OrderNo, ParentPageID = @ParentPageID WHERE pageID = @pageID;", CreateParameter("@BlogID", page.BlogID), CreateParameter("@Title", page.Title), CreateParameter("@Content", page.Content), CreateParameter("@Summary", page.Summary), CreateParameter("@PublishDate", page.PublishDate), CreateParameter("@LastModifiedDate", page.LastModifiedDate), CreateParameter("@Author", page.Author), CreateParameter("@IsPublished", page.IsPublished), CreateParameter("@Visible", page.Visible), CreateParameter("@ReadCount", page.ReadCount), CreateParameter("@OrderNo", page.OrderNo), CreateParameter("@ParentPageID", page.ParentPageID), CreateParameter("@pageID", page.PageID)); }
/// <summary> /// Changes the specified page. /// </summary> /// <param name="page">The page.</param> /// <returns></returns> protected BBlogPage Change(EBlogPage page) { return new BBlogPage() { PageID = page.PageID, ParentPageID = page.ParentPageID, Author = page.Author, BlogID = page.BlogID, Content = page.Content, IsPublished = page.IsPublished, LastModifiedDate = page.LastModifiedDate, PublishDate = page.PublishDate, ReadCount = page.ReadCount, Summary = page.Summary, Title = page.Title, Visible = page.Visible, OrderNo = page.OrderNo }; }