// 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);
}
