public List<AnnouncementEntity> getAllAnnouncements() { var cmd = buildCommand("select * from announcement order by time desc"); var reader = cmd.ExecuteReader(); var result = new List<AnnouncementEntity>(); while (reader.Read()) { AnnouncementEntity tmp = new AnnouncementEntity(); tmp.id = reader.GetInt32(0); tmp.content = reader.GetString(1); tmp.title = reader.GetString(2); tmp.display = reader.GetInt32(3); tmp.time = reader.GetDateTime(4); result.Add(tmp); } return result; }
public AnnouncementEntity[] getAnnouncements(int start=0,int end=5) { var cmd = buildCommand("select * from announcement where display=1 order by time desc limit ?,?"); cmd.AddIntParam("start", start); cmd.AddIntParam("end", end); var reader = cmd.ExecuteReader(); var result = new List<AnnouncementEntity>(); while(reader.Read()) { AnnouncementEntity tmp = new AnnouncementEntity(); tmp.id = reader.GetInt32(0); tmp.content = reader.GetString(1); tmp.title = reader.GetString(2); tmp.display = reader.GetInt32(3); tmp.time = reader.GetDateTime(4); result.Add(tmp); } return result.ToArray(); }
public AnnouncementEntity getAnnouncementByID(int id) { var cmd = buildCommand("select * from announcement where id=?"); cmd.AddIntParam("id", id); var reader = cmd.ExecuteReader(); if (!reader.HasRows) return null; reader.Read(); AnnouncementEntity tmp = new AnnouncementEntity(); tmp.id = reader.GetInt32(0); tmp.content = reader.GetString(1); tmp.title = reader.GetString(2); tmp.display = reader.GetInt32(3); tmp.time = reader.GetDateTime(4); return tmp; }