//lấy ra ngày bắt đầu thống kê
public DateTime ngaybatdau()
{
DateTime ngay = DateTime.Now;
String Query = "select * from THONGKE where id=1";
DataTable data = new DataTable();
data = dataprovider.Instance.ExcuteQuery(Query);
foreach (DataRow item in data.Rows)
{
thongkeDTO b = new thongkeDTO(item);
ngay = b.Tgvaoben;
}
return(ngay);
}
public List <thongkeDTO> hienthi()
{
String Query = "select * from THONGKE where maSoVe!='Vé tháng'";
DataTable data = new DataTable();
data = dataprovider.Instance.ExcuteQuery(Query);
List <thongkeDTO> listadmin = new List <thongkeDTO>();
foreach (DataRow item in data.Rows)
{
thongkeDTO dt = new thongkeDTO(item);
listadmin.Add(dt);
}
return(listadmin);
}
//tìm xe
public List <thongkeDTO> timkiem(string ma)
{
String Query = "select * from THONGKE where bienSo like'%" + ma + "%'";
DataTable data = new DataTable();
data = dataprovider.Instance.ExcuteQuery(Query);
List <thongkeDTO> listadmin = new List <thongkeDTO>();
foreach (DataRow item in data.Rows)
{
thongkeDTO dt = new thongkeDTO(item);
listadmin.Add(dt);
}
return(listadmin);
}