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