public void Xoa(BaoCaoTHTHCLDV_InFo baocao)
{
SqlCommand cmd = new SqlCommand("delete from BaoCaoTHTHCLDV where MaBCTHTHCLDV=@mabaocao and MaDichVuBuuChinhVT=@madichvu");
cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value = baocao.Maubaocao.Mamaubaocao;
cmd.Parameters.Add("madichvu", SqlDbType.Int).Value = baocao.Dichvubuuchinh.MaDichVuBuuChinhVT;
ds.Execute(cmd);
}
public void Sua(BaoCaoTHTHCLDV_InFo baocao)
{
SqlCommand cmd = new SqlCommand("Update BaoCaoTHTHCLDV set ThuocDanhMucBuuChinh=@thuocdanhmuc, MaTieuChuanCL = @matieuchuan, VanBanCongBo = @vanban, TenDoanhNghiepCongBo=@tendoanhnghiep, GhiChu = @ghichu where MaBCTHTHCLDV = @mabaocao and MaDichVuBuuChinhVT = @madichvu");
cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value = baocao.Maubaocao.Mamaubaocao;
cmd.Parameters.Add("madichvu", SqlDbType.Int).Value = baocao.Dichvubuuchinh.MaDichVuBuuChinhVT;
cmd.Parameters.Add("thuocdanhmuc", SqlDbType.NVarChar, 50).Value = baocao.Thuocdanhmucbuuchinh;
cmd.Parameters.Add("matieuchuan", SqlDbType.Int).Value = baocao.Tieuchuanchatluong.MaTieuChuanCL;
cmd.Parameters.Add("vanban", SqlDbType.NVarChar, 255).Value = baocao.Vanbancongbo;
cmd.Parameters.Add("tendoanhnghiep", SqlDbType.NVarChar, 255).Value = baocao.Doanhnghiepcongbo;
cmd.Parameters.Add("ghichu", SqlDbType.NVarChar, 255).Value = baocao.Ghichu;
ds.Execute(cmd);
}
public void Them(BaoCaoTHTHCLDV_InFo baocao)
{
SqlCommand cmd = new SqlCommand("insert into BaoCaoTHTHCLDV(MaBCTHTHCLDV, MaDichVuBuuChinhVT, ThuocDanhMucBuuChinh, MaTieuChuanCL, VanBanCongBo, TenDoanhNghiepCongBo, GhiChu) values(@mabaocao, @madichvu, @thuocdanhmuc, @matieuchuan, @vanban, @tendoanhnghiep, @ghichu)");
cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value = baocao.Maubaocao.Mamaubaocao;
cmd.Parameters.Add("madichvu", SqlDbType.Int).Value = baocao.Dichvubuuchinh.MaDichVuBuuChinhVT;
cmd.Parameters.Add("thuocdanhmuc", SqlDbType.NVarChar, 50).Value = baocao.Thuocdanhmucbuuchinh;
cmd.Parameters.Add("matieuchuan", SqlDbType.Int).Value = baocao.Tieuchuanchatluong.MaTieuChuanCL;
cmd.Parameters.Add("vanban", SqlDbType.NVarChar, 255).Value = baocao.Vanbancongbo;
cmd.Parameters.Add("tendoanhnghiep", SqlDbType.NVarChar, 255).Value = baocao.Doanhnghiepcongbo;
cmd.Parameters.Add("ghichu", SqlDbType.NVarChar, 255).Value = baocao.Ghichu;
ds.Execute(cmd);
}
public void Sua(BaoCaoTHTHCLDV_InFo baocao)
{
dbbaocao.Sua(baocao);
}
public void Xoa(BaoCaoTHTHCLDV_InFo baocao)
{
dbbaocao.Xoa(baocao);
}
public void Them(BaoCaoTHTHCLDV_InFo baocao)
{
dbbaocao.Them(baocao);
}
