Exemplo n.º 1
0
        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);
        }