private void LoadDulieuBaoCao_BieuMau14()
{
List <BaoCaoBieuMau14> ListBC14 = new List <BaoCaoBieuMau14>();
// lay danh muc xe
List <Xe> listXes = new List <Xe>();
Xe objXe = new Xe();
listXes = objXe.GetListXes();
DateTime timeServer = DieuHanhTaxi.GetTimeServer();
// lay trang thai cua tung xe insert vao bieu 14
if (listXes != null)
{
foreach (Xe xe in listXes)
{
DataTable dt = new DataTable();
BaoCaoBieuMau14 objBC14 = new BaoCaoBieuMau14();
dt = TimKiem_BaoCao.GetTrangThaiBaoRa_Ve_GanNhat(xe.SoHieuXe);
if ((dt != null) && (dt.Rows.Count > 0))
{
// [SoHieuXe]
//,[ThoiDiemBao]
//,[MaLaiXe]
//,[ViTriDiemBao]
//,[ViTriDiemDen]
//,[LoaiChoKhach]
//,[TrangThaiLaiXeBao]
//,[GhiChu]
//,[IsHoatDong]
objBC14.Sohieutaxi = xe.SoHieuXe;
objBC14.Tenlaixe = dt.Rows[0]["MaLaiXe"].ToString();
if (dt.Rows[0]["IsHoatDong"].ToString() == "1")
{
objBC14.Is_Hoatdong = true;
objBC14.Khonghoatdong = false;
objBC14.Giorahoatdong = DateTime.Parse(dt.Rows[0]["ThoiDiemBao"].ToString());
objBC14.GioveGara = DateTime.MinValue;
if (timeServer.Day != objBC14.Giorahoatdong.Day)
{
TimeSpan timeSpan = timeServer - objBC14.Giorahoatdong;
objBC14.Ghichu = timeSpan.Days + " ngày";
}
}
else
{
objBC14.Is_Hoatdong = false;
objBC14.Khonghoatdong = true;
objBC14.Giorahoatdong = DateTime.MinValue;
objBC14.GioveGara = DateTime.Parse(dt.Rows[0]["ThoiDiemBao"].ToString());
}
}
else // xe chua hoat dong va chua ve
{
objBC14.Sohieutaxi = xe.SoHieuXe;
objBC14.Is_Hoatdong = false;
objBC14.Khonghoatdong = false;
objBC14.Giorahoatdong = DateTime.MinValue;
objBC14.GioveGara = DateTime.MinValue;
objBC14.Ghichu = "xe cần kiểm tra";
}
if (objBC14.Is_Hoatdong)
{
ListBC14.Add(objBC14);
}
}
}
gridBaoCaoBieuMau1.DataSource = ListBC14;
}
