/// <summary> /// In danh sách xe tuyến cố định /// </summary> /// <param name="t">Điều kiện lọc</param> /// <returns></returns> protected DataTable SelectForPrint(TermForFixed t) { try { var res = from s in _db.Tra_Vehicles where s.Fixed == true orderby s.Tariff.Text select new { s.Code, Region = s.Tariff.Group.Parent.Parent.Text, Area = s.Tariff.Group.Parent.Text, Province = s.Tariff.Group.Text, Station = s.Tariff.Text, Transport = s.Transport.Text, RegionCode = s.Tariff.Group.Parent.Parent.Code, AreaCode = s.Tariff.Group.Parent.Code, ProvinceCode = s.Tariff.Group.Code, StationCode = s.Tariff.Code, TransportCode = s.Transport.Code, Seats = s.Seats ?? 0, Beds = s.Beds ?? 0, s.Tariff.Price1, s.Tariff.Price2, s.Tariff.Rose1, s.Tariff.Rose2, Clc = s.High == true ? "x" : null, Xt = s.High == true ? null : "x", Tp = s.City == true ? "x" : null, Dp = s.City == true ? null : "x", s.ProductionYear, s.LimitedRegistration, s.TermInsurance, s.TermFixedRoutes, s.TermDriverLicense, s.Node, s.Driver, s.Birth, s.Address, s.Phone, s.Text, s.Note, s.More, s.Order, s.Show }; var dt = Global.Session.Current.AddDays(1); switch (t) { case TermForFixed.Registration: res = res.Where(p => p.LimitedRegistration <= dt); break; case TermForFixed.DriverLicense: res = res.Where(p => p.TermDriverLicense <= dt); break; case TermForFixed.FixedRoutes: res = res.Where(p => p.TermFixedRoutes <= dt); break; case TermForFixed.Insurance: res = res.Where(p => p.TermInsurance <= dt); break; default: break; } return res.ToDataTable(); } catch { return _tb; } }
/// <summary> /// Print list vehicle fixed /// </summary> /// <param name="t">Filter</param> /// <returns></returns> public new DataTable SelectForPrint(TermForFixed t) { var tb = base.SelectForPrint(t); return Xuli(tb); }
/// <summary> /// Danh sách xe tuyến cố định /// </summary> /// <param name="t">Điều kiện lọc</param> /// <returns></returns> protected DataTable SelectForFixed(TermForFixed t) { try { var res = from s in _db.Tra_Vehicles where s.Fixed == true orderby s.Tariff.Text select new { s.Id, s.Code, s.CreatorId, Creator = s.Creator.Name, s.CreateDate, s.TransportId, s.TariffId, Tariff = s.Tariff.Text, Transport = s.Transport.Text, s.Seats, s.Beds, s.High, s.City, s.ProductionYear, s.LimitedRegistration, s.TermInsurance, s.TermFixedRoutes, s.TermDriverLicense, s.Node, s.Driver, s.Birth, s.Address, s.Phone, s.Text, s.Note, s.More, s.Order, s.Show }; if (!Global.Session.User.CheckAdmin() && !Global.Session.User.CheckOperator()) res = res.Where(k => k.CreatorId == Global.Session.User.Id); var dt = Global.Session.Current.AddDays(1); switch (t) { case TermForFixed.Registration: res = res.Where(p => p.LimitedRegistration <= dt); break; case TermForFixed.DriverLicense: res = res.Where(p => p.TermDriverLicense <= dt); break; case TermForFixed.FixedRoutes: res = res.Where(p => p.TermFixedRoutes <= dt); break; case TermForFixed.Insurance: res = res.Where(p => p.TermInsurance <= dt); break; default: break; } return res.ToDataTable(); } catch { return _tb; } }