public List <MaNV_DTO> GetListMaNV()
        {
            List <MaNV_DTO> maNVList = new List <MaNV_DTO>();
            DataTable       data     = DataProvider.Instance.ExecuteQuery("SELECT MANV FROM dbo.NHANVIEN");

            foreach (DataRow item in data.Rows)
            {
                MaNV_DTO maNV = new MaNV_DTO(item);
                maNVList.Add(maNV);
            }
            return(maNVList);
        }
Beispiel #2
0
        /// <summary>
        /// Lấy ra list mã nhân viên
        /// </summary>
        /// <returns>Danh sách mã nhân viên</returns>
        public List <MaNV_DTO> GetListMaNhanVien()
        {
            List <MaNV_DTO> maNhanVienList = new List <MaNV_DTO>();


            try
            {
                DataTable data = DataProvider.Instance.ExecuteQuery("SELECT MANV FROM dbo.NHANVIEN");
                foreach (DataRow item in data.Rows)
                {
                    MaNV_DTO ma = new MaNV_DTO(item);
                    maNhanVienList.Add(ma);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine("Load ma nhan vien loi. Thu lai!", e);
            }

            return(maNhanVienList);
        }