public void Xoa_Int(BaoCaoDaiLyInternet_InFo baocaoInt)
{
SqlCommand cmd = new SqlCommand("delete from BaoCaoDaiLyInternet where MaBCDaiLyInternet=@mabaocaoInt and MaDaiLyInt=@madailyInt");
cmd.Parameters.Add("mabaocaoInt", SqlDbType.Int).Value = baocaoInt.MaubaocaoInt.MaMauBaoCaoDaiLyInt;
cmd.Parameters.Add("madailyInt", SqlDbType.Int).Value = baocaoInt.DaiLyInt.MaDaiLyInt;
ds.Execute(cmd);
}
public void Sua_Int(BaoCaoDaiLyInternet_InFo baocaoInt)
{
SqlCommand cmd = new SqlCommand("update BaoCaoDaiLyInternet set MaThueBao=@thuebao,DienThoai=@dienthoaiInt,GhiChu=@ghichuInt where MaBCDaiLyInternet=@mabaocaoInt and MaDaiLyInt=@madailyInt");
cmd.Parameters.Add("mabaocaoInt", SqlDbType.Int).Value = baocaoInt.MaubaocaoInt.MaMauBaoCaoDaiLyInt;
cmd.Parameters.Add("madailyInt", SqlDbType.Int).Value = baocaoInt.DaiLyInt.MaDaiLyInt;
cmd.Parameters.Add("thuebao", SqlDbType.Int).Value = baocaoInt.ThueBao.MaThueBao;
cmd.Parameters.Add("dienthoaiInt", SqlDbType.VarChar).Value = baocaoInt.DienThoaiInt;
cmd.Parameters.Add("ghichuInt", SqlDbType.NVarChar, 200).Value = baocaoInt.GhichuInt;
ds.Execute(cmd);
}
public void Them_Int(BaoCaoDaiLyInternet_InFo baocaoInt)
{
SqlCommand cmd = new SqlCommand("insert into BaoCaoDaiLyInternet(MaBCDaiLyInternet,MaDaiLyInt,MaThueBao,DienThoai,GhiChu) values(@mabaocaoInt,@madailyInt,@thuebao,@dienthoaiInt,@ghichuInt)");
cmd.Parameters.Add("mabaocaoInt", SqlDbType.Int).Value = baocaoInt.MaubaocaoInt.MaMauBaoCaoDaiLyInt;
cmd.Parameters.Add("madailyInt", SqlDbType.Int).Value = baocaoInt.DaiLyInt.MaDaiLyInt;
cmd.Parameters.Add("thuebao", SqlDbType.Int).Value = baocaoInt.ThueBao.MaThueBao;
cmd.Parameters.Add("dienthoaiInt", SqlDbType.VarChar).Value = baocaoInt.DienThoaiInt;
cmd.Parameters.Add("ghichuInt", SqlDbType.NVarChar, 200).Value = baocaoInt.GhichuInt;
ds.Execute(cmd);
}
public void Sua_Int(BaoCaoDaiLyInternet_InFo baocaoInt)
{
dbbaocaoInt.Sua_Int(baocaoInt);
}
public void Them_Int(BaoCaoDaiLyInternet_InFo baocaoInt)
{
dbbaocaoInt.Them_Int(baocaoInt);
}
