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) { 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 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 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); } }
private void DoKeyWord(W_KeyWord keyWord) { if (string.Equals(keyWord.ResponseType, "viewPage", StringComparison.OrdinalIgnoreCase) == true) { W_ViewPageBLL bll = new W_ViewPageBLL(); W_ViewPage viewPage = bll.GetByResourcesID(keyWord.ResourcesID); DoViewPage(viewPage); } else { W_ResourcesBLL bll = new W_ResourcesBLL(); W_Resources resources = bll.GetByResourcesID(keyWord.ResourcesID); DoResources(resources); } }
public List <W_ViewPageItem> GetByViewPage(W_ViewPage viewPage) { return(GetAll().Where(temp => temp.VPID == viewPage.VPID).ToList()); }
// 改 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)); }