protected void Page_Load(object sender, EventArgs e)
{
TopRecipeID = new RecipeDB().getTopRecipe();
if (TopRecipeID != 0)
{
TopRecipeDiv.Visible = true;
RecipeClass TopRecipeClass = new RecipeDB().GetRecipe(TopRecipeID);
TopRecipeName = TopRecipeClass.RecipeName;
TopRecipeImage = TopRecipeClass.ImagePath;
}
else
TopRecipeDiv.Visible = false;
DataTable AllRecipesTable = (new RecipeDB()).GetLatestRecipes();
if (AllRecipesTable.Rows.Count > 0)
{
DataView ListView = new DataView();
ListView.Table = AllRecipesTable;
AllRecipeList.DataSource = ListView;
}
DataTable LatestArticles = new ArticleDB().GetLatestArticles();
ArticlesRepeater.DataSource = LatestArticles;
this.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable articlesTable = new ArticleDB().GetAllVerifiedArticles();
if (articlesTable.Rows.Count > 0)
{
DataView articlesView = new DataView();
articlesView.Table = articlesTable;
if (Sort.SelectedItem.Value == "Latest")
articlesView.Sort = "PostedTime DESC";
else if (Sort.SelectedItem.Value == "Popular")
articlesView.Sort = "ArticleViews DESC";
if (articlesView.Count == 0)
PagerDiv.Visible = false;
else
PagerDiv.Visible = true;
articlesList.DataSource = articlesView;
NoArticleLbl.Visible = false;
ArticlesDiv.Visible = true;
}
else
{
ArticlesDiv.Visible = false;
NoArticleLbl.Visible = true;
}
}
public ActionResult GetArticlePage(int page, int limit)
{
List <Articles> lis = ArticleDB.GetArticle(page, limit);
int num = ArticleDB.GetArticleSum();
return(Json(new UIResult(0, "查询成功", lis, num), JsonRequestBehavior.AllowGet));
}
public ActionResult AddArticle(Articles art)
{
int num = ArticleDB.AddArticleAll(art);
if (num > 0)
{
return(Json(new UIResult(200, "发布成功")));
}
else
{
return(Json(new UIResult(400, "发布失败")));
}
}
public static List <Article> GetArticles()
{
DataTable dataTable = ArticleDB.GetArticles();
List <Article> Article = new List <Article>();
foreach (DataRow article in dataTable.Rows)
{
Article artcl = new Article(article);
Article.Add(artcl);
}
return(Article);
}
public static int AddArticle(string writer, string picture, string article, DateTime publishDate, string visitDate, bool visible, bool family, bool romantic, bool pregnancy, bool disabled, bool nature, string title)
{
int res = ArticleDB.AddArticle(writer, picture, article, publishDate, visitDate, visible, family, romantic, pregnancy, disabled, nature, title);
return(res);
}
