public static List <KhachHangDTO> TimKhachHangTheoTuKhoa(string tukhoa) { List <KhachHangDTO> lkh = new List <KhachHangDTO>(); try { SqlDataReader reader = DataProvider.TimKhachHangTheoTuKhoa("TimKhachHangTheoTuKhoa", tukhoa); while (reader.Read()) { KhachHangDTO kh = new KhachHangDTO(); kh.MaKH = reader.GetString(0).Trim(); kh.HoTen = reader.GetString(1); kh.NgaySinh = reader.GetDateTime(2); kh.Cmnd = reader.GetString(3).Trim(); kh.Sdt = reader.GetString(4).Trim(); kh.DiaChi = reader.GetString(5); kh.NgayDK = reader.GetDateTime(6); kh.Loai = reader.GetString(7); kh.DoanhSo = (uint)reader.GetDecimal(8); lkh.Add(kh); } reader.Close(); } catch { } return(lkh); }