public List <IssueBillInfo> GetListById(int id)
{
List <IssueBillInfo> list = new List <IssueBillInfo>();
string query = "select * from IssueBillInfo where idIssueBill = " + id;
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
IssueBillInfo issuebillinfo = new IssueBillInfo(item);
list.Add(issuebillinfo);
}
return(list);
}
public int GetTotalById(int id)
{
int total = 0;
string query = "select * from IssueBillInfo where idIssueBill = " + id;
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
IssueBillInfo issuebillinfo = new IssueBillInfo(item);
total += Convert.ToInt32((issuebillinfo.Amount * issuebillinfo.Price) * (1 - issuebillinfo.Discount / 100.0));
}
return(total);
}
