コード例 #1
0
        public DataTable BangTaiKhoan()
        {
            ConvertClass convert = new ConvertClass();
            var          query   = doiCTXH.fu_Ds_TaiKhoan();

            return(convert.ToDataTable(doiCTXH, query));
        }
コード例 #2
0
        public DataTable TimKiemDoiVien(string hoten)
        {
            ConvertClass convert = new ConvertClass();
            var          query   = doiCTXH.fu_TimKiemDoiVien_TheoTen(hoten);

            return(convert.ToDataTable(doiCTXH, query));
        }
コード例 #3
0
        public DataTable BangDoiVien()
        {
            ConvertClass convert = new ConvertClass();
            var          query   = doiCTXH.fu_ds_Doivien();

            return(convert.ToDataTable(doiCTXH, query));
        }
コード例 #4
0
        public DataTable DanhsachNhiemky()
        {
            ConvertClass convert = new ConvertClass();
            var          query   = doiCTXH.fu_Ds_Nhiemki();

            return(convert.ToDataTable(doiCTXH, query));
        }
コード例 #5
0
        public DataTable XemBDHTheoNhiemKy(int nhiemki)
        {
            ConvertClass convert = new ConvertClass();
            var          query   = doiCTXH.fu_ds_BDH_Nhiemky(nhiemki);

            return(convert.ToDataTable(doiCTXH, query));
        }
コード例 #6
0
        public DataTable BangVatDung()
        {
            ConvertClass convert = new ConvertClass();
            var          query   = doiCTXH.fu_Ds_KhoVatDung();

            return(convert.ToDataTable(doiCTXH, query));
        }
コード例 #7
0
        public DataTable LoadDsThamgiaCT(string MaCT)
        {
            ConvertClass convert = new ConvertClass();
            var          query   = doiCTXH.fu_DS_SVthamgiaCT(MaCT);

            return(convert.ToDataTable(doiCTXH, query));
        }
コード例 #8
0
        public DataTable BangChuongTrinh()
        {
            ConvertClass convert = new ConvertClass();
            var          query   = doiCTXH.fu_Ds_Chuongtrinh();

            return(convert.ToDataTable(doiCTXH, query));
        }
コード例 #9
0
        //public DataTable LocTheoKhoaDV(string makhoadv)
        //{
        //    ConvertClass convert = new ConvertClass();
        //    var query = doiCTXH.fu_Loc_TheoKhoaDV(makhoadv);
        //    return convert.ToDataTable(doiCTXH, query);
        //}

        //public DataTable LocTheoKhoa(string khoadaotao)
        //{
        //    ConvertClass convert = new ConvertClass();
        //    var query = doiCTXH.fu_Loc_TheoKhoahoc(khoadaotao);
        //    return convert.ToDataTable(doiCTXH, query);
        //}

        //public DataTable LocTheoNamSinh(string namsinh)
        //{
        //    int temp = int.Parse(namsinh);
        //    ConvertClass convert = new ConvertClass();
        //    var query = doiCTXH.fu_Loc_TheoNamsinh(temp);
        //    return convert.ToDataTable(doiCTXH, query);
        //}
        //Hàm dùng xóa Toàn bộ thông tin của một sinh viên, trừ BĐH

        public DataTable LocDoiVien(string Namsinh, string MaKhoa, string MaKhoaDV)
        {
            ConvertClass convert = new ConvertClass();

            if (Namsinh != "")
            {
                var query = doiCTXH.fu_Loc_DoiVien(int.Parse(Namsinh), MaKhoa, MaKhoaDV);
                return(convert.ToDataTable(doiCTXH, query));
            }
            else
            {
                var query = doiCTXH.fu_Loc_DoiVien(null, MaKhoa, MaKhoaDV);
                return(convert.ToDataTable(doiCTXH, query));
            }
        }