예제 #1
0
        public void Xoa(BaoCaoTKTHKD_InFo baocao)
        {
            SqlCommand cmd = new SqlCommand("delete from BaoCaoTKTHKD where MaBCTKTHKD=@mabaocao and MaCongTrinh=@macongtrinh");

            cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value    = baocao.Maubaocao.Mamaubaocao;
            cmd.Parameters.Add("macongtrinh", SqlDbType.Int).Value = baocao.Congtrinh.MaCongTrinh;
            ds.Execute(cmd);
        }
예제 #2
0
        public void Sua(BaoCaoTKTHKD_InFo baocao)
        {
            SqlCommand cmd = new SqlCommand("Update BaoCaoTKTHKD set SoLuong=@soluong,GhiChu=@ghichu where MaBCTKTHKD=@mabaocao and MaCongTrinh=@macongtrinh");

            cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value         = baocao.Maubaocao.Mamaubaocao;
            cmd.Parameters.Add("macongtrinh", SqlDbType.Int).Value      = baocao.Congtrinh.MaCongTrinh;
            cmd.Parameters.Add("soluong", SqlDbType.Int).Value          = baocao.Soluong;
            cmd.Parameters.Add("ghichu", SqlDbType.NVarChar, 200).Value = baocao.Ghichu;
            ds.Execute(cmd);
        }
예제 #3
0
        public void Them(BaoCaoTKTHKD_InFo baocao)
        {
            SqlCommand cmd = new SqlCommand("insert into BaoCaoTKTHKD(MaBCTKTHKD,MaCongTrinh,SoLuong,GhiChu) values(@mabaocao,@macongtrinh,@soluong,@ghichu)");

            cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value         = baocao.Maubaocao.Mamaubaocao;
            cmd.Parameters.Add("macongtrinh", SqlDbType.Int).Value      = baocao.Congtrinh.MaCongTrinh;
            cmd.Parameters.Add("soluong", SqlDbType.Int).Value          = baocao.Soluong;
            cmd.Parameters.Add("ghichu", SqlDbType.NVarChar, 200).Value = baocao.Ghichu;
            ds.Execute(cmd);
        }
 public void Sua(BaoCaoTKTHKD_InFo baocao)
 {
     dbbaocao.Sua(baocao);
 }
 public void Xoa(BaoCaoTKTHKD_InFo baocao)
 {
     dbbaocao.Xoa(baocao);
 }
        //

        public void Them(BaoCaoTKTHKD_InFo baocao)
        {
            dbbaocao.Them(baocao);
        }