public List <Billinfo> GetListBillinfo(int id)
{
List <Billinfo> ListBillinfo = new List <Billinfo>();
DataTable data = dataProvider.Instance.ExecuteQuery("Select * from dbo.Billinfo where idbill =" + id);
foreach (DataRow item in data.Rows)
{
Billinfo info = new Billinfo(item);
ListBillinfo.Add(info);
}
return(ListBillinfo);
}
public List <Billinfo> Getlist(int id)
{
List <Billinfo> Listbillinfo = new List <Billinfo>();
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM dbo.CHITIETHOADON WHERE CHITIETHOADON.IDBILL = " + id);
foreach (DataRow item in data.Rows)
{
Billinfo info = new Billinfo(item);
Listbillinfo.Add(info);
}
return(Listbillinfo);
}
public List <Billinfo> GetlistBillinfo(int MaHD)
{
List <Billinfo> listBillinfo = new List <Billinfo>();
DataTable data = DataProvider.Instance.ExecuteQuery("select * from ChiTietHD where MaHD = " + MaHD);
foreach (DataRow item in data.Rows)
{
Billinfo info = new Billinfo(item);
listBillinfo.Add(info);
}
return(listBillinfo);
}
public List <Billinfo> GetListBillInfo(int id)
{
List <Billinfo> ListBillInfo = new List <Billinfo>();
DataTable data = DataProvider.Instance.ExcuteQuery("SELECT * FROM dbo.BILLINFO WHERE IDBILL = " + id);
foreach (DataRow item in data.Rows)
{
Billinfo info = new Billinfo(item);
ListBillInfo.Add(info);
}
return(ListBillInfo);
}