public DTOBill GetBillById(int idbill)
{
string query = string.Format("SELECT idbill,daycheck,totalbill,total,exchange,idaccount FROM TableBill WHERE idbill={0}", idbill);
DataTable dt = DataProvider.Instance.ExecuteQuery(query);
DTOBill gv = new DTOBill(dt.Rows[0]);
return(gv);
}
public List <DTOBill> GetListBill()
{
List <DTOBill> list = new List <DTOBill>();
string query = string.Format("SELECT * FROM TableImport ");
DataTable dt = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in dt.Rows)
{
DTOBill bill = new DTOBill(item);
list.Add(bill);
}
return(list);
}
