public ActionResult BaoCaoDoanhNghiep(int?So, int?Ben, int?DonVi, long?Tuyen, string TuNgay, string DenNgay)
{
if (string.IsNullOrEmpty(DenNgay))
{
return(BaoCaoDoanhNghiepDefault());
}
else
{
QLVanTai_2017 dbc = new QLVanTai_2017();
Dictionary <string, dynamic> DataDefault = new Dictionary <string, dynamic>();
DataDefault["So"] = Convert.ToInt32(So);
DataDefault["TuNgay"] = TuNgay;
DataDefault["DenNgay"] = DenNgay;
ViewBag.LstSo = Get_List_So();
ViewBag.LstBen = Get_List_Ben_TheoIDSo(DataDefault["So"]);
DataDefault["Ben"] = Convert.ToInt32(Ben);
ViewBag.LstTuyen = Get_List_Tuyen_TheoBen(DataDefault["Ben"]);
DataDefault["Tuyen"] = Convert.ToInt64(Tuyen);
ViewBag.LstDonVi = Get_List_DVVT_TheoIDTuyen(DataDefault["Tuyen"]);;
DataDefault["DonVi"] = Convert.ToInt32(DonVi);
ViewBag.DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_DonViVanTai(DataDefault["TuNgay"], DataDefault["DenNgay"], DataDefault["Ben"], DataDefault["Tuyen"], DataDefault["DonVi"]);
ViewBag.DataDefault = DataDefault;
ViewBag.ThongTinTuyen = GetThongTinTuyen_TheoID(DataDefault["Tuyen"]);
ViewBag.ThongTinBenXe = ThongTinBenXe(DataDefault["Ben"]);
return(View());
}
}
public JsonResult GetBaoCaoDoanhNghiep(string TuNgay, string DenNgay, int?Ben, long?Tuyen, int?DonVi)
{
try
{
QLVanTai_2017 dbc = new QLVanTai_2017();
var DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_DonViVanTai(TuNgay, DenNgay, Ben,
Tuyen, DonVi);
var ThongTinBen = ThongTinBenXe(Convert.ToInt32(Ben));
var ThongTinDonVi = ThongTinDVVT(Convert.ToInt32(DonVi));
var DataDefault = new
{
TuNgay,
DenNgay,
Ben = Convert.ToInt32(Ben),
Tuyen = Convert.ToInt64(Tuyen),
DonVi = Convert.ToInt32(DonVi)
};
var data = new
{
DataGrid,
ThongTinBen,
ThongTinDonVi,
DataDefault
};
return(Json(new { status = true, message = "Lấy dữ liệu thành công", data }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { status = false, message = "Lấy dữ liệu thất bại", data = "" }, JsonRequestBehavior.AllowGet));
}
}
private ActionResult BaoCaoDoanhNghiepDefault()
{
QLVanTai_2017 dbc = new QLVanTai_2017();
Dictionary <string, dynamic> DataDefault = new Dictionary <string, dynamic>();
DataDefault["So"] = 55;
DataDefault["TuNgay"] = "01/" + DateTime.Now.ToString("MM/yyyy");
DataDefault["DenNgay"] = DateTime.Now.ToString("dd/MM/yyyy");
ViewBag.LstSo = Get_List_So();
ViewBag.LstBen = Get_List_Ben_TheoIDSo(DataDefault["So"]);
DataDefault["Ben"] = ViewBag.LstBen[0].BX_IdBenXe;
ViewBag.LstTuyen = Get_List_Tuyen_TheoBen(DataDefault["Ben"]);
DataDefault["Tuyen"] = ViewBag.LstTuyen[0].LT_IdLuongTuyen;
ViewBag.LstDonVi = Get_List_DVVT_TheoIDTuyen(DataDefault["Tuyen"]);;
DataDefault["DonVi"] = ViewBag.LstDonVi[0].CT_IdCongTyVT;
ViewBag.DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_DonViVanTai(DataDefault["TuNgay"], DataDefault["DenNgay"], DataDefault["Ben"], DataDefault["Tuyen"], DataDefault["DonVi"]);
ViewBag.DataDefault = DataDefault;
ViewBag.ThongTinTuyen = GetThongTinTuyen_TheoID(DataDefault["Tuyen"]);
ViewBag.ThongTinBenXe = ThongTinBenXe(DataDefault["Ben"]);
return(View());
}