public void Xoa(BaoCaoTKTHKD_InFo baocao)
{
SqlCommand cmd = new SqlCommand("delete from BaoCaoTKTHKD where MaBCTKTHKD=@mabaocao and MaCongTrinh=@macongtrinh");
cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value = baocao.Maubaocao.Mamaubaocao;
cmd.Parameters.Add("macongtrinh", SqlDbType.Int).Value = baocao.Congtrinh.MaCongTrinh;
ds.Execute(cmd);
}
public void Sua(BaoCaoTKTHKD_InFo baocao)
{
SqlCommand cmd = new SqlCommand("Update BaoCaoTKTHKD set SoLuong=@soluong,GhiChu=@ghichu where MaBCTKTHKD=@mabaocao and MaCongTrinh=@macongtrinh");
cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value = baocao.Maubaocao.Mamaubaocao;
cmd.Parameters.Add("macongtrinh", SqlDbType.Int).Value = baocao.Congtrinh.MaCongTrinh;
cmd.Parameters.Add("soluong", SqlDbType.Int).Value = baocao.Soluong;
cmd.Parameters.Add("ghichu", SqlDbType.NVarChar, 200).Value = baocao.Ghichu;
ds.Execute(cmd);
}
public void Them(BaoCaoTKTHKD_InFo baocao)
{
SqlCommand cmd = new SqlCommand("insert into BaoCaoTKTHKD(MaBCTKTHKD,MaCongTrinh,SoLuong,GhiChu) values(@mabaocao,@macongtrinh,@soluong,@ghichu)");
cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value = baocao.Maubaocao.Mamaubaocao;
cmd.Parameters.Add("macongtrinh", SqlDbType.Int).Value = baocao.Congtrinh.MaCongTrinh;
cmd.Parameters.Add("soluong", SqlDbType.Int).Value = baocao.Soluong;
cmd.Parameters.Add("ghichu", SqlDbType.NVarChar, 200).Value = baocao.Ghichu;
ds.Execute(cmd);
}
public void Sua(BaoCaoTKTHKD_InFo baocao)
{
dbbaocao.Sua(baocao);
}
public void Xoa(BaoCaoTKTHKD_InFo baocao)
{
dbbaocao.Xoa(baocao);
}
//
public void Them(BaoCaoTKTHKD_InFo baocao)
{
dbbaocao.Them(baocao);
}