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