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