private ActionResult BaoCaoTuyenDefault()
{
//default
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.LstBenXe = Get_List_Ben_TheoIDSo(DataDefault["So"]);
DataDefault["Ben"] = ViewBag.LstBenXe[0].BX_IdBenXe;
ViewBag.LstTuyen = Get_List_Tuyen_TheoBen(DataDefault["Ben"]);
DataDefault["Tuyen"] = ViewBag.LstTuyen[0].LT_IdLuongTuyen;
ViewBag.LstDVTT = Get_List_DVVT_TheoIDTuyen(DataDefault["Tuyen"]);;
string lstCongTy = "";
foreach (var v in ViewBag.LstDVTT)
{
lstCongTy += v.CT_IdCongTyVT;
}
ViewBag.LstDVTT.Insert(0, new { CT_IdCongTyVT = -1, TenCongTy = "Tất cả" });
ViewBag.DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_Tuyen(DataDefault["TuNgay"],
DataDefault["DenNgay"], DataDefault["Ben"], DataDefault["Tuyen"], lstCongTy);
ViewBag.DataDefault = DataDefault;
ViewBag.ThongTinTuyen = GetThongTinTuyen_TheoID(DataDefault["Tuyen"]);
return(View());
}
public JsonResult GetBaoCaoTuyen(long?Tuyen, int?Ben, string LstCongTy, string TuNgay, string DenNgay)
{
try
{
QLVanTai_2017 dbc = new QLVanTai_2017();
LstCongTy = "," + LstCongTy + ",";
var DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_Tuyen(TuNgay,
DenNgay, Convert.ToInt32(Ben), Convert.ToInt64(Tuyen), LstCongTy);
var DataDefault = new
{
So = 0,
Ben = Convert.ToInt32(Ben),
Tuyen = Convert.ToInt64(Tuyen),
TuNgay,
DenNgay
};
return(Json(new { status = true, message = "Lấy dữ liệu thành công", data = new { DataGrid, DataDefault } }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { status = false, message = "Lấy dữ liệu thất bại", data = "" }, JsonRequestBehavior.AllowGet));
}
}