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