public List <Nhaphang> SearchNhaphangByName(string Tenhang)
{
List <Nhaphang> list = new List <Nhaphang>();
string query = string.Format("SELECT * FROM PhieuNhap WHERE Tenhang like N'%{0}%'", Tenhang);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
Nhaphang nhaphang = new Nhaphang(item);
list.Add(nhaphang);
}
return(list);
}
public List <Nhaphang> GetListNhaphang()
{
List <Nhaphang> list = new List <Nhaphang>();
string query = "SELECT * FROM PhieuNhap";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
Nhaphang nhaphang = new Nhaphang(item);
list.Add(nhaphang);
}
return(list);
}
