// 改
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);
}
