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