public void Xoa(MauBaoCaoDaiLyBuuDien_InFo maubaocao)
{
SqlCommand s = new SqlCommand("Delete from MauBaoCaoDaiLyBuuDien where MaBCDaiLyBuuDien = @ma");
s.Parameters.Add("@ma", SqlDbType.Int).Value = maubaocao.MaMauBaoCaoDaiLyBuuDien;
ds.Execute(s);
}
public void Sua(MauBaoCaoDaiLyBuuDien_InFo maubaocao)
{
SqlCommand s = new SqlCommand("Update MauBaoCaoDaiLyBuuDien set TenBCDaiLyBuuDien=@ten, MaLoaiBaoCao=@maloai, Nam=@nam where MaBCDaiLyBuuDien=@ma");
s.Parameters.Add("@ma", SqlDbType.Int).Value = maubaocao.MaMauBaoCaoDaiLyBuuDien;
s.Parameters.Add("@ten", SqlDbType.NVarChar, 200).Value = maubaocao.Tenbaocao;
s.Parameters.Add("@maloai", SqlDbType.Int).Value = maubaocao.Loaibaocao.MaLoaiBaoCao;
s.Parameters.Add("@nam", SqlDbType.Int).Value = maubaocao.Nambaocao;
ds.Execute(s);
}
public void Them(MauBaoCaoDaiLyBuuDien_InFo maubaocao)
{
SqlCommand s = new SqlCommand("INSERT INTO MauBaoCaoDaiLyBuuDien(MaBCDaiLyBuuDien, TenBCDaiLyBuuDien, MaLoaiBaoCao, Nam) VALUES(@ma, @ten, @maloai, @nam)");
s.Parameters.Add("@ma", SqlDbType.Int).Value = maubaocao.MaMauBaoCaoDaiLyBuuDien;
s.Parameters.Add("@ten", SqlDbType.NVarChar, 200).Value = maubaocao.Tenbaocao;
s.Parameters.Add("@maloai", SqlDbType.Int).Value = maubaocao.Loaibaocao.MaLoaiBaoCao;
s.Parameters.Add("@nam", SqlDbType.Int).Value = maubaocao.Nambaocao;
ds.Execute(s);
}
public void Sua(MauBaoCaoDaiLyBuuDien_InFo maubaocao)
{
dbmaubaocao.Sua(maubaocao);
}
public void Them(MauBaoCaoDaiLyBuuDien_InFo maubaocao)
{
dbmaubaocao.Them(maubaocao);
}
