private void guna2TextBox1_TextChanged(object sender, EventArgs e) { if (guna2TextBox1.Text == "") { Load(); } else { flowLayoutPanel1.Controls.Clear(); DataTable a = DAO.HoadonDAO.Instance.Search(guna2TextBox1.Text); for (int i = 0; i < a.Rows.Count; i++) { UC_ItemOrder items = new UC_ItemOrder(); items.tenkh = a.Rows[i]["ten_kh"].ToString(); items.tennv = a.Rows[i]["ten_nv"].ToString(); items.madh = a.Rows[i]["mahd"].ToString(); items.ngayhd = DateTime.Parse(a.Rows[i]["ngay_ban"].ToString()).ToString("dd-MM-yyyy"); items.makh = a.Rows[i]["makh"].ToString(); items.manv = a.Rows[i]["manv"].ToString(); items.tri_gia = Convert.ToDouble(a.Rows[i]["tri_gia"]).ToString("#,##0"); items.Set_UC(); flowLayoutPanel1.Controls.Add(items); } } }
private void Load() { flowLayoutPanel1.Controls.Clear(); DataTable a = DAO.HoadonDAO.Instance.Hoadonlist(); for (int i = 0; i < a.Rows.Count; i++) { UC_ItemOrder items = new UC_ItemOrder(); items.tenkh = a.Rows[i]["ten_kh"].ToString(); items.tennv = a.Rows[i]["ten_nv"].ToString(); items.madh = a.Rows[i]["mahd"].ToString(); items.ngayhd = DateTime.Parse(a.Rows[i]["ngay_ban"].ToString()).ToString("dd-MM-yyyy"); items.makh = a.Rows[i]["makh"].ToString(); items.manv = a.Rows[i]["manv"].ToString(); items.tri_gia = Convert.ToDouble(a.Rows[i]["tri_gia"]).ToString("#,##0"); items.Set_UC(); flowLayoutPanel1.Controls.Add(items); } }