示例#1
0
        public static List <NhanVienDTO> TimNhanVienTheoMaNV(string manv)
        {
            SqlDataReader      reader = DataProvider.TimNhanVienTheoMaNV("TimNhanVienTheoMaNV", manv);
            List <NhanVienDTO> lnv    = new List <NhanVienDTO>();

            try
            {
                while (reader.Read())
                {
                    NhanVienDTO nv = new NhanVienDTO();
                    nv.MaNV       = reader.GetString(0);
                    nv.HoTen      = reader.GetString(1);
                    nv.NgaySinh   = reader.GetDateTime(2);
                    nv.NgayVaoLam = reader.GetDateTime(3);
                    nv.SDT        = reader.GetString(4);
                    nv.DiaChi     = reader.GetString(5);
                    nv.ChucVu     = reader.GetString(6);
                    nv.CMND       = reader.GetString(7);
                    nv.Anh        = (byte[])reader.GetValue(8);
                    lnv.Add(nv);
                }
            }
            catch
            {
                if (reader.Read())
                {
                    NhanVienDTO nv = new NhanVienDTO();
                    nv.MaNV       = reader.GetString(0);
                    nv.HoTen      = reader.GetString(1);
                    nv.NgaySinh   = reader.GetDateTime(2);
                    nv.NgayVaoLam = reader.GetDateTime(3);
                    nv.SDT        = reader.GetString(4);
                    nv.DiaChi     = reader.GetString(5);
                    nv.ChucVu     = reader.GetString(6);
                    nv.CMND       = reader.GetString(7);
                    nv.Anh        = (byte[])reader.GetValue(8);
                    lnv.Add(nv);
                }
            }
            reader.Close();
            return(lnv);
        }