public void Xoa_Int(MauBaoCaoDaiLyInternet_InFo maubaocaoInt)
        {
            SqlCommand s = new SqlCommand("Delete from MauBaoCaoDaiLyInternet where MaBCDaiLyInternet = @maInt");

            s.Parameters.Add("@maInt", SqlDbType.Int).Value = maubaocaoInt.MaMauBaoCaoDaiLyInt;

            ds.Execute(s);
        }
        public void Sua_Int(MauBaoCaoDaiLyInternet_InFo maubaocaoInt)
        {
            SqlCommand s = new SqlCommand("Update MauBaoCaoDaiLyInternet set TenBCDaiLyInternet=@tenInt, MaLoaiBaoCao=@maloaiInt, Nam=@namInt where MaBCDaiLyInternet=@maInt");

            s.Parameters.Add("@maInt", SqlDbType.Int).Value            = maubaocaoInt.MaMauBaoCaoDaiLyInt;
            s.Parameters.Add("@tenInt", SqlDbType.NVarChar, 200).Value = maubaocaoInt.TenbaocaoInt;
            s.Parameters.Add("@maloaiInt", SqlDbType.Int).Value        = maubaocaoInt.LoaibaocaoInt.MaLoaiBaoCao;
            s.Parameters.Add("@namInt", SqlDbType.Int).Value           = maubaocaoInt.NambaocaoInt;
            ds.Execute(s);
        }
        public void Them_Int(MauBaoCaoDaiLyInternet_InFo maubaocaoInt)
        {
            SqlCommand s = new SqlCommand("INSERT INTO MauBaoCaoDaiLyInternet(MaBCDaiLyInternet, TenBCDaiLyInternet, MaLoaiBaoCao, Nam) VALUES(@maInt, @tenInt, @maloaiInt, @namInt)");

            s.Parameters.Add("@maInt", SqlDbType.Int).Value            = maubaocaoInt.MaMauBaoCaoDaiLyInt;
            s.Parameters.Add("@tenInt", SqlDbType.NVarChar, 200).Value = maubaocaoInt.TenbaocaoInt;
            s.Parameters.Add("@maloaiInt", SqlDbType.Int).Value        = maubaocaoInt.LoaibaocaoInt.MaLoaiBaoCao;
            s.Parameters.Add("@namInt", SqlDbType.Int).Value           = maubaocaoInt.NambaocaoInt;

            ds.Execute(s);
        }
Beispiel #4
0
 public void Sua_Int(MauBaoCaoDaiLyInternet_InFo maubaocaoInt)
 {
     dbmaubaocaoInt.Sua_Int(maubaocaoInt);
 }
Beispiel #5
0
 public void Them_Int(MauBaoCaoDaiLyInternet_InFo maubaocaoInt)
 {
     dbmaubaocaoInt.Them_Int(maubaocaoInt);
 }