public LoaiTienTrongATM LayLoaiTien(DataRow dr) { LoaiTienTrongATM loaiTien = new LoaiTienTrongATM(); loaiTien.MacuabanghiStock = dr[0].ToString(); loaiTien.SoLuongMoiLoaiTien = int.Parse(dr[1].ToString()); loaiTien.MaATM = dr[2].ToString(); loaiTien.MaTien = dr[3].ToString(); return(loaiTien); }
public List <LoaiTienTrongATM> DanhSachLoaiTien(string maATM) { List <LoaiTienTrongATM> list = new List <LoaiTienTrongATM>(); string query = @"SELECT [MacuabanghiStock] ,[SoLuongMoiLoaiTien] ,[MaATM] ,[MaTien] FROM[M_ATM].[dbo].[LoaiTienTrongATM] where MaATM = @ma"; DataTable dt = DataProvider.Instance.ExcuteQuery(query, new object[] { maATM }); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { LoaiTienTrongATM loai = LayLoaiTien(row); list.Add(loai); } } return(list); }