private object ThongTinBenXe(int idben)
{
GetBaoCaoHD bc = new GetBaoCaoHD();
var ooo = bc.Get_ThongTinBenXe_TheoIdBen(idben);
var ob = new
{
ooo.BX_IdBenXe,
ooo.CoQuanQuanLy,
ooo.DiaChi,
ooo.DienTich_NhaCho,
ooo.DienTich_PhuongTienKhac,
ooo.DienTich_XeKhach,
ooo.GhiChu,
ooo.LoaiBenXe,
ooo.MaBen,
ooo.SDT,
ooo.SoLuotXuatBenDangKy,
ooo.SoLuotXuatBenQuyHoach,
ooo.SoTuyenQuyHoach,
ooo.TenBenXe,
ooo.TongDienTich,
ooo.TS_IdTinh_So,
ooo.TS_TT_IdTrangThai
};
return(ob);
}
private List <object> Get_List_DVVT()
{
GetBaoCaoHD bc = new GetBaoCaoHD();
List <object> list1 = new List <object>();
var tatca = new
{
CT_IdCongTyVT = -1,
MaCongTy = -1,
TenCongTy = "Tất Cả",
TS_IdTinh_So = -1
};
list1.Add(tatca);
foreach (var item in bc.Get_DanhSachAll_DVVT())
{
var ob = new
{
CT_IdCongTyVT = item.CT_IdCongTyVT,
MaCongTy = item.MaCongTy,
TenCongTy = item.TenCongTy,
TS_IdTinh_So = item.TS_IdTinh_So
};
list1.Add(ob);
}
return(list1);
}
private object ThongTinDVVT(int dvvt)
{
GetBaoCaoHD bc = new GetBaoCaoHD();
var ooo = bc.Get_ThongTinDVVT_TheoIdDVVT(dvvt);
var ob = new
{
ooo.CT_IdCongTyVT,
ooo.CT_TT_IdTrangThai,
ooo.DiaChi,
ooo.MaCongTy,
ooo.SoLuongXe,
ooo.TenCongTy,
ooo.TS_IdTinh_So
};
return(ob);
}
/*=================================Function Lấy List Sở/Tuyến/Đơn Vị Vận Tải/Bến=================================*/
#region [Dùng chung]
private List <object> Get_List_So()
{
GetBaoCaoHD bc = new GetBaoCaoHD();
List <object> list1 = new List <object>();
foreach (var item in bc.Get_DanhSachAll_So())
{
var ob = new
{
TS_IdTinh_So = item.TS_IdTinh_So,
TS_TenTinh = item.TS_TenTinh,
TS_IdMaTinh = item.TS_IdMaTinh,
TS_TT_IdTrangThai = item.TS_TT_IdTrangThai
};
list1.Add(ob);
}
return(list1);
}
private List <object> Get_List_DVVT_TheoIDSo(int idso)
{
GetBaoCaoHD bc = new GetBaoCaoHD();
List <object> list1 = new List <object>();
foreach (var item in bc.LayDonViVanTaiCuaSo(idso))
{
var ob = new
{
CT_IdCongTyVT = item.CT_IdCongTyVT,
MaCongTy = item.MaCongTy,
TenCongTy = item.TenCongTy,
TS_IdTinh_So = item.TS_IdTinh_So
};
list1.Add(ob);
}
return(list1);
}
private List <object> Get_List_Ben()
{
GetBaoCaoHD bc = new GetBaoCaoHD();
List <object> list1 = new List <object>();
foreach (var item in bc.Get_DanhSachAll_Ben())
{
var ob = new
{
BX_IdBenXe = item.BX_IdBenXe,
TenBenXe = item.TenBenXe,
LoaiBenXe = item.LoaiBenXe,
MaBen = item.MaBen,
TS_IdTinh_So = item.TS_IdTinh_So
};
list1.Add(ob);
}
return(list1);
}
private List <object> Get_List_Ben_TheoIDSo(int idso)
{
GetBaoCaoHD bc = new GetBaoCaoHD();
List <object> list1 = new List <object>();
foreach (var item in bc.Get_DanhSachBenXe_CuaSoGiaoThong(idso))
{
var ob = new
{
BX_IdBenXe = item.BX_IdBenXe,
TenBenXe = item.TenBenXe,
LoaiBenXe = item.LoaiBenXe,
MaBen = item.MaBen,
TS_IdTinh_So = item.TS_IdTinh_So
};
list1.Add(ob);
}
return(list1);
}
private List <object> Get_List_Tuyen()
{
GetBaoCaoHD bc = new GetBaoCaoHD();
return(bc.Get_DanhSachAll_Tuyen());
}
private List <object> Get_List_DVVT_TheoIDTuyen(long idtuyen)
{
GetBaoCaoHD bc = new GetBaoCaoHD();
return(bc.Get_DanhSachCongTyVanTai_TrenTuyen_TheoIdTuyen(idtuyen));
}
