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); }