//Lấy thông báo có Hiệu lực
public List <ThongBao1> TBCOHIEULUC()
{
string sql = "select * from THONGBAO where TRANGTHAI=N'Có hiệu lực' order by IDTB desc";
dah.KetNoi();
DataTable dt = dah.LoadDuLieu(sql);
dah.NgatKetNoi();
List <ThongBao1> ds = new List <ThongBao1>();
foreach (DataRow dr in dt.Rows)
{
ThongBao1 tb = new ThongBao1();
tb.IDTB = int.Parse(dr[0].ToString());
tb.TieuDeTB = dr[1].ToString();
tb.NoiDungTB = dr[2].ToString();
tb.NgayTB = DateTime.Parse(dr[3].ToString());
tb.TrangThai = dr[4].ToString();
ds.Add(tb);
}
this.DanhSachThongBao = ds;
return(ds);
}
public void SuaTB(ThongBao1 tb)
{
dal.SuaTB(tb);
}
public void ThemTB(ThongBao1 tb)
{
dal.ThemTB(tb);
}
public void SuaTB(ThongBao1 tb)
{
string sql = "update THONGBAO set TIEUDETB=N'" + tb.TieuDeTB + "', NOIDUNGTB=N'" + tb.NoiDungTB + "', NGAYTB='" + tb.NgayTB + "',TRANGTHAI=N'" + tb.TrangThai + "' where IDTB=" + tb.IDTB + "";
dah.ThucThi(sql);
}
public void ThemTB(ThongBao1 tb)
{
string sql = "insert into THONGBAO values (N'" + tb.TieuDeTB + "',N'" + tb.NoiDungTB + "','" + tb.NgayTB + "',N'" + tb.TrangThai + "')";
dah.ThucThi(sql);
}
