//public static ArticleDAL Instance()
//{
// if (arDal == null)
// {
// arDal = new ArticleDAL();
// }
// return arDal;
//}
public void GetAll(Paginate arPage)
{
dalBase.sql = "SELECT COUNT(*) FROM db_article WHERE ispass=1 AND publishTime <= CURDATE()";
dalBase.Run(Behavious.SELECT_WITHOUT_PARAM, false);
dalBase.DataRead.Read();
arPage.TotalRecords = int.Parse(dalBase.DataRead[0].ToString());
int start = arPage.StartRow;
int perPageSize = arPage.PageSize;
dalBase.sql = string.Format("SELECT * FROM db_article WHERE ispass=1 AND publishTime <= CURDATE() ORDER BY id DESC LIMIT {0},{1}", start, perPageSize);
dalBase.Run(Behavious.SELECT_WITHOUT_PARAM, false);
list_ArticleInfo.Clear();
while (dalBase.DataRead.Read())
{
articleInfo = new Article()
{
ID = Convert.ToInt32(dalBase.DataRead["id"]),
Title = dalBase.DataRead["title"].ToString(),
Summary = dalBase.DataRead["summary"].ToString(),
//Body = dalBase.MySqldr["body"].ToString(),
PublishTime = Convert.ToDateTime(dalBase.DataRead["publishTime"].ToString()),
Author = dalBase.DataRead["author"].ToString(),
//ReprintName = mySqldr["reprintName"].ToString(),
//ReprintAdress = mySqldr["reprintAdress"].ToString()
};
list_ArticleInfo.Add(articleInfo);
}
dalBase.CloseConnect();
}
public Article GetDetail(int id)
{
dalBase.sql = "SELECT * FROM db_article WHERE id=@id";
dalBase.Param = new MySqlParameter("@id", id);
dalBase.Run(Behavious.SELECT_WITH_SINGLEPARAM, false);
Article article = new Article();
while (dalBase.DataRead.Read())
{
article = new Article()
{
ID = Convert.ToInt32(dalBase.DataRead["id"]),
Title = dalBase.DataRead["title"].ToString(),
//Summary = dalBase.MySqldr["summary"].ToString(),
Body = dalBase.DataRead["body"].ToString(),
PublishTime = Convert.ToDateTime(dalBase.DataRead["publishTime"].ToString()),
Author = dalBase.DataRead["author"].ToString(),
//ReprintName = mySqldr["reprintName"].ToString(),
//ReprintAdress = mySqldr["reprintAdress"].ToString()
};
}
dalBase.CloseConnect();
return article;
}
