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