public void Xoa(MauBaoCaoTHTHCLDV_InFo maubaocao) { SqlCommand s = new SqlCommand("Delete from MauBaoCaoTHTHCLDV where MaBCTHTHCLDV = @ma"); s.Parameters.Add("@ma", SqlDbType.Int).Value = maubaocao.Mamaubaocao; ds.Execute(s); }
public void Sua(MauBaoCaoTHTHCLDV_InFo maubaocao) { SqlCommand s = new SqlCommand("Update MauBaoCaoTHTHCLDV set TenBCTHTHCLDV=@ten, MaLoaiBaoCao=@maloai, Nam=@nam where MaBCTHTHCLDV=@ma"); s.Parameters.Add("@ma", SqlDbType.Int).Value = maubaocao.Mamaubaocao; s.Parameters.Add("@ten", SqlDbType.NVarChar, 200).Value = maubaocao.Tenbaocao; s.Parameters.Add("@maloai", SqlDbType.Int).Value = maubaocao.Loaibaocao.MaLoaiBaoCao; s.Parameters.Add("@nam", SqlDbType.Int).Value = maubaocao.Nambaocao; ds.Execute(s); }
public void Them(MauBaoCaoTHTHCLDV_InFo maubaocao) { SqlCommand s = new SqlCommand("INSERT INTO MauBaoCaoTHTHCLDV(MaBCTHTHCLDV, TenBCTHTHCLDV, MaLoaiBaoCao, Nam) VALUES(@ma, @ten, @maloai, @nam)"); s.Parameters.Add("@ma", SqlDbType.Int).Value = maubaocao.Mamaubaocao; s.Parameters.Add("@ten", SqlDbType.NVarChar, 200).Value = maubaocao.Tenbaocao; s.Parameters.Add("@maloai", SqlDbType.Int).Value = maubaocao.Loaibaocao.MaLoaiBaoCao; s.Parameters.Add("@nam", SqlDbType.Int).Value = maubaocao.Nambaocao; ds.Execute(s); }
public void Sua(MauBaoCaoTHTHCLDV_InFo maubaocao) { dbmaubaocao.Sua(maubaocao); }
public void Them(MauBaoCaoTHTHCLDV_InFo maubaocao) { dbmaubaocao.Them(maubaocao); }