public void Xoa(BaoCaoTHTHDT_InFo baocao)
{
SqlCommand cmd = new SqlCommand("delete from BaoCaoTHTHDT where MaBCTHTHDT=@mabaocao and MaDuAn=@maduan");
cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value = baocao.Maubaocao.Mamaubaocao;
cmd.Parameters.Add("maduan", SqlDbType.Int).Value = baocao.Duan.MaDuAn;
ds.Execute(cmd);
}
public void Sua(BaoCaoTHTHDT_InFo baocao)
{
SqlCommand cmd = new SqlCommand("update BaoCaoTHTHDT set VonDauTu=@vondautu,LuyKeVonDauTu=@luykevon,GhiChu=@ghichu where MaBCTHTHDT=@mabaocao and MaDuAn=@maduan");
cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value = baocao.Maubaocao.Mamaubaocao;
cmd.Parameters.Add("maduan", SqlDbType.Int).Value = baocao.Duan.MaDuAn;
cmd.Parameters.Add("vondautu", SqlDbType.Int).Value = baocao.Vondautu;
cmd.Parameters.Add("luykevon", SqlDbType.Int).Value = baocao.Luykevon;
cmd.Parameters.Add("ghichu", SqlDbType.NVarChar, 200).Value = baocao.Ghichu;
ds.Execute(cmd);
}
public void Them(BaoCaoTHTHDT_InFo baocao)
{
SqlCommand cmd = new SqlCommand("insert into BaoCaoTHTHDT(MaBCTHTHDT,MaDuAn,VonDauTu,LuyKeVonDauTu,GhiChu) values(@mabaocao,@maduan,@vondautu,@luykevon,@ghichu)");
cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value = baocao.Maubaocao.Mamaubaocao;
cmd.Parameters.Add("maduan", SqlDbType.Int).Value = baocao.Duan.MaDuAn;
cmd.Parameters.Add("vondautu", SqlDbType.Int).Value = baocao.Vondautu;
cmd.Parameters.Add("luykevon", SqlDbType.Int).Value = baocao.Luykevon;
cmd.Parameters.Add("ghichu", SqlDbType.NVarChar, 200).Value = baocao.Ghichu;
ds.Execute(cmd);
}
public void Sua(BaoCaoTHTHDT_InFo baocao)
{
dbbaocao.Sua(baocao);
}
public void Xoa(BaoCaoTHTHDT_InFo baocao)
{
dbbaocao.Xoa(baocao);
}
public void Them(BaoCaoTHTHDT_InFo baocao)
{
dbbaocao.Them(baocao);
}