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