public M_Articles GetArticleDetail(int ArticleId)
{
DataTable dt = new DataTable();
Execute Exec = new Execute(DatabaseType.DBType1);
dt = Exec.ExecuteQuery <DataTable>("SELECT * FROM Article WHERE ArticleId = " + ArticleId, 0, CommandType.Text);
M_Articles A = new M_Articles(dt.Rows[0]);
return(A);
}
public List <M_Articles> GetAllArticlesWithCondition(int top, string condition)
{
List <M_Articles> lst = new List <M_Articles>();
DataTable dt = new DataTable();
Execute Exec = new Execute(DatabaseType.DBType1);
dt = Exec.ExecuteQuery <DataTable>("SELECT TOP " + top + " * FROM Article WHERE " + condition + " ORDER BY ArticleId DESC", 0, CommandType.Text);
foreach (DataRow dr in dt.Rows)
{
M_Articles A = new M_Articles(dr);
lst.Add(A);
}
return(lst);
}
public string Index2()
{
M_Articles entity = new M_Articles();
entity.articles = new List <M_MaterialNews>();
entity.articles.Add(new M_MaterialNews()
{
author = "neekey", content = "test", content_source_url = "www.baidu.com", title = "图文消息测试", show_cover_pic = 1, digest = "",
need_open_comment = 0, only_fans_can_comment = 0, thumb_media_id = "9esnqWhnAq2hOWtSkGD37V6uq4-1TAvxjNDrqy9NY2M"
});
var result = MateriaHelper.PostNewsAsync(entity);
return(result.Result.Data);
}
public string BatchNews()
{
M_Articles entity = new M_Articles();
entity.articles = new List <M_MaterialNews>();
entity.articles.Add(new M_MaterialNews()
{
author = "neekey",
content = "test",
content_source_url = "www.baidu.com",
title = "图文消息测试",
show_cover_pic = 1,
digest = "",
need_open_comment = 0,
only_fans_can_comment = 0,
thumb_media_id = "uc_4UZM-fWBuUlHiXsWTMDnOzUDuwJ4lECSSJqgO7qA6WhGEfeIUROTs1KtCi5NI"
});
var result = MateriaHelper.PostBatchNewsAsync(entity);
return(result.Result.Data);
}
