public List <SellingBills> LoadSellingBillsByCustomerPhone(string customerphone)
{
List <SellingBills> sellingBillsList = new List <SellingBills>();
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM SellingBills WHERE CUSTOMERPHONE = N'" + customerphone + "'");
foreach (DataRow item in data.Rows)
{
SellingBills orderbills = new SellingBills(item);
sellingBillsList.Add(orderbills);
}
return(sellingBillsList);
}
// Xuất danh sách SellingBills
public List <SellingBills> LoadSellingBills()
{
List <SellingBills> sellingBillsList = new List <SellingBills>();
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM SellingBills");
foreach (DataRow item in data.Rows)
{
SellingBills orderbills = new SellingBills(item);
sellingBillsList.Add(orderbills);
}
return(sellingBillsList);
}
