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