// 改 public bool Update(W_ViewPage viewPage) { using (SqlHelper helper = WechatDataBaseHelper.Create()) { int rows = helper.ExecuteNonQuery("update [W_ViewPage] set CataID=@CataID,VPTYpe=@VPTYpe,VPTitle=@VPTitle,VPDescription=@VPDescription,VPURL=@VPURL,ImgURL=@ImgURL,CreateTime=@CreateTime,IsDelete=@IsDelete where VPID=@VPID", new SqlParameter("@VPID", viewPage.VPID), new SqlParameter("@CataID", viewPage.CataID), new SqlParameter("@VPTYpe", viewPage.VPTYpe), new SqlParameter("@VPTitle", viewPage.VPTitle), new SqlParameter("@VPDescription", viewPage.VPDescription), new SqlParameter("@VPURL", viewPage.VPURL), new SqlParameter("@ImgURL", viewPage.ImgURL), new SqlParameter("@CreateTime", viewPage.CreateTime), new SqlParameter("@IsDelete", viewPage.IsDelete)); return rows > 0; } }
// 增 public bool Add(W_ViewPage viewPage) { using (SqlHelper helper = WechatDataBaseHelper.Create()) { int rows = helper.ExecuteNonQuery("insert into [W_ViewPage] values (@VPID,@CataID,@VPTYpe,@VPTitle,@VPDescription,@VPURL,@ImgURL,@CreateTime,@IsDelete)", new SqlParameter("@VPID", viewPage.VPID), new SqlParameter("@CataID", viewPage.CataID), new SqlParameter("@VPTYpe", viewPage.VPTYpe), new SqlParameter("@VPTitle", viewPage.VPTitle), new SqlParameter("@VPDescription", viewPage.VPDescription), new SqlParameter("@VPURL", viewPage.VPURL), new SqlParameter("@ImgURL", viewPage.ImgURL), new SqlParameter("@CreateTime", viewPage.CreateTime), new SqlParameter("@IsDelete", viewPage.IsDelete)); return rows > 0; } }
// 删 public bool Delete(W_ViewPage viewPage) { using (SqlHelper helper = WechatDataBaseHelper.Create()) { int rows = helper.ExecuteNonQuery("delete from [W_ViewPage] where VPID=@VPID", new SqlParameter("@VPID", viewPage.VPID)); return rows > 0; } }
public List<W_ViewPageItem> GetByViewPage(W_ViewPage viewPage) { return GetAll().Where(temp => temp.VPID == viewPage.VPID).ToList(); }
private void DoViewPage(W_ViewPage viewPage) { NewsResult result = new NewsResult(); result.Articles.Add(new NewsArticle() { Title = viewPage.VPTitle, Description = viewPage.VPDescription, Url = viewPage.VPURL, PicUrl = viewPage.ImgURL }); if (viewPage.VPTYpe == "single") { this.Response = result; return; } W_ViewPageItemBLL bll = new W_ViewPageItemBLL(); List<W_ViewPageItem> childArticles = bll.GetByViewPage(viewPage); foreach (W_ViewPageItem viewPageItem in childArticles) { result.Articles.Add(new NewsArticle() { Title = viewPageItem.VPItemTitle, Description = viewPageItem.VPItemDescription, Url = viewPageItem.VPItemUrl, PicUrl = viewPageItem.VPItemPicUrl }); } this.Response = result; }
// 改 public bool Update(W_ViewPage viewPage) { return new W_ViewPageDAL().Update(viewPage); }
// 删 public bool Delete(W_ViewPage viewPage) { return new W_ViewPageDAL().Delete(viewPage); }
// 增 public bool Add(W_ViewPage viewPage) { return new W_ViewPageDAL().Add(viewPage); }