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