// tìm kiếm quầy hàng public List <quayhang> SearchQuayHang(string ma, string ten) { List <quayhang> list = new List <quayhang>(); string query = string.Format("select * from quayhang a where a.ma like N'%{0}%' and a.ten like N'%{1}%'", ma, ten); DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow i in data.Rows) { quayhang mh = new quayhang(i); list.Add(mh); } return(list); }
// xem quầy hàng public List <quayhang> XemQuayHang() { List <quayhang> list = new List <quayhang>(); string query = "select ma,ten,vitri from quayhang"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { quayhang qh = new quayhang(item); list.Add(qh); } return(list); }