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