public List <xethangDTO> timkiemtheobien(string bien)
{
String Query = "select * from XE where bienSo like'%" + bien + "%'";
DataTable data = new DataTable();
data = dataprovider.Instance.ExcuteQuery(Query);
List <xethangDTO> listadmin = new List <xethangDTO>();
foreach (DataRow item in data.Rows)
{
xethangDTO dt = new xethangDTO(item);
listadmin.Add(dt);
}
return(listadmin);
}
public List <xethangDTO> hienthivethang()
{
String Query = "select * from XE where loaiVe='Vé tháng'";
DataTable data = new DataTable();
data = dataprovider.Instance.ExcuteQuery(Query);
List <xethangDTO> listxe = new List <xethangDTO>();
foreach (DataRow item in data.Rows)
{
xethangDTO dt = new xethangDTO(item);
string bien = item["bienSo"].ToString();
string query = "delete from XE where (DATEDIFF(DAY,(SELECT ngayDangky from XE where bienSo=N'" + bien + "'),(SELECT ngayHetHan from XE where bienSo=N'" + bien + "'))=0) and bienSo='" + bien + "'";
dataprovider.Instance.ExcuteNonQuery(query);
listxe.Add(dt);
}
return(listxe);
}
