Пример #1
0
        private List <DanhSachXeModel> getdanhSachXeModels(string kw)
        {
            tongSoXe = 0;
            List <DanhSachXeModel> danhSachXeModels = new List <DanhSachXeModel>();

            conn.Open();
            string     sql = "select * from Xe where tenXe like '%" + kw + "%'";
            SqlCommand cmd = new SqlCommand(sql, conn);

            using (DbDataReader reader = cmd.ExecuteReader())
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        int    maXe   = Convert.ToInt32(reader.GetValue(0));
                        int    bienSo = Convert.ToInt32(reader.GetValue(1));
                        string tenXe  = reader.GetString(2);
                        string imageUrl;
                        try
                        {
                            imageUrl = link + reader.GetString(3);
                        }
                        catch (Exception ex)
                        {
                            imageUrl = "";
                        }
                        bool            trangThai = Convert.ToBoolean(reader.GetValue(4));
                        DanhSachXeModel temp      = new DanhSachXeModel(maXe, bienSo, tenXe, imageUrl, trangThai);
                        danhSachXeModels.Add(temp);
                        tongSoXe++;
                    }
                }
            }
            conn.Close();
            return(danhSachXeModels);
        }
Пример #2
0
 public ThueXe(DanhSachXeModel model)
 {
     InitializeComponent();
     md = model;
 }