public List <QLKS> LoadData()
{
List <QLKS> list = new List <QLKS>();
DataTable data = DataProvider.Instance.ExecuteQuery("select * from PHONG");
foreach (DataRow item in data.Rows)
{
QLKS fl = new QLKS(item);
list.Add(fl);
}
return(list);
}
public List <QLKS> Load_Type_Status(string type, string status)
{
List <QLKS> list = new List <QLKS>();
DataTable data = DataProvider.Instance.ExecuteQuery("select * from PHONG where LoaiPhong = '" + type + "' and TinhTrang = N'" + status + "'");
foreach (DataRow item in data.Rows)
{
QLKS fl = new QLKS(item);
list.Add(fl);
}
return(list);
}
public List <QLKS> Load_RoomCode(string type)
{
List <QLKS> list = new List <QLKS>();
DataTable data = DataProvider.Instance.ExecuteQuery("select * from PHONG where MaPhong = '" + type + "'");
foreach (DataRow item in data.Rows)
{
QLKS fl = new QLKS(item);
list.Add(fl);
}
return(list);
}
