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