//获取司机排队名次（[email protected]） public async Task <TData <int> > GetLineNo(VehicleListParam param) { int iShippingDock = await vehicleService.GetShippingDock(param); param.ShippingDock = iShippingDock; TData <List <VehicleEntity> > obj = await GetList(param); List <VehicleEntity> VehicleEntityList = obj.Data.Where(p => p.Status >= 2 && p.Status <= 3).ToList(); VehicleEntityList = VehicleEntityList.OrderByDescending(p => p.Status).OrderBy(q => q.CheckTime).ToList(); TData <int> objNo = new TData <int>(); objNo.Data = 0; int iRow = 0; foreach (VehicleEntity item in VehicleEntityList) { iRow++; string sDriverName = item.DriverName == null ? "" : item.DriverName.ToString(); string sDriverPhone = item.DriverPhone == null ? "" : item.DriverPhone.ToString(); string sVehicleNo = item.VehicleNo == null ? "" : item.VehicleNo.ToString(); if (string.IsNullOrEmpty(sDriverName) && string.IsNullOrEmpty(sDriverPhone) && string.IsNullOrEmpty(sVehicleNo)) { break; } if (item.DriverName.Contains(sDriverName) || item.DriverPhone.Contains(sDriverPhone) || item.VehicleNo.Contains(sVehicleNo)) { objNo.Data = iRow; break; } } return(objNo); }
public async Task <List <VehicleEntity> > GetPageList(VehicleListParam param, Pagination pagination)
{
var expression = ListFilter(param);
var list = await this.BaseRepository().FindList(expression, pagination);
return(list.ToList());
}
public async Task <TData <List <VehicleEntity> > > GetPageList(VehicleListParam param, Pagination pagination)
{
TData <List <VehicleEntity> > obj = new TData <List <VehicleEntity> >();
obj.Data = await vehicleService.GetPageList(param, pagination);
obj.Total = pagination.TotalCount;
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <VehicleEntity> > > GetList(VehicleListParam param)
{
TData <List <VehicleEntity> > obj = new TData <List <VehicleEntity> >();
obj.Data = await vehicleService.GetList(param);
obj.Total = obj.Data.Count;
obj.Tag = 1;
return(obj);
}
//获取司机排队名次（[email protected]） //参数：VehicleListParam param（条件参数） //返回obj，其中obj.data为排队名次 public async Task <IActionResult> GetLineNo(VehicleListParam param) { TData <int> obj = new TData <int>(); if (!string.IsNullOrEmpty(param.DriverName) || !string.IsNullOrEmpty(param.DriverPhone) || !string.IsNullOrEmpty(param.VehicleNo)) { obj = await vehicleBLL.GetLineNo(param); } return(Json(obj)); }
//按条件获取码头编码（[email protected]） public async Task <int> GetShippingDock(VehicleListParam param) { int iRtn = 0; var expression = ListFilter(param); expression = expression.And(t => t.Status == 2 || t.Status == 3); var list = await this.BaseRepository().FindList(expression); foreach (VehicleEntity item in list) { iRtn = (int)item.ShippingDock; break; } return(iRtn); }
private Expression <Func <VehicleEntity, bool> > ListFilter(VehicleListParam param)
{
var expression = LinqExtensions.True <VehicleEntity>();
if (param != null)
{
if (!param.DriverName.IsEmpty())
{
expression = expression.And(t => t.DriverName.Contains(param.DriverName));
}
if (!param.DriverIdentityNo.IsEmpty())
{
expression = expression.And(t => t.DriverIdentityNo.Contains(param.DriverIdentityNo));
}
if (!param.DriverPhone.IsEmpty())
{
expression = expression.And(t => t.DriverPhone.Contains(param.DriverPhone));
}
if (!param.VehicleNo.IsEmpty())
{
expression = expression.And(t => t.VehicleNo.Contains(param.VehicleNo));
}
if (!param.OrderNo.IsEmpty())
{
expression = expression.And(t => t.OrderNo.Contains(param.OrderNo));
}
if (param.MissonType > -1)
{
expression = expression.And(t => t.MissonType == param.MissonType);
}
if (param.GoodsType > -1)
{
expression = expression.And(t => t.GoodsType == param.GoodsType);
}
if (param.Status > -1)
{
expression = expression.And(t => t.Status == param.Status);
}
if (param.ShippingDock > -1)
{
expression = expression.And(t => t.ShippingDock == param.ShippingDock);
}
if (!string.IsNullOrEmpty(param.StartStatus.ParseToString()))
{
expression = expression.And(t => t.Status >= param.StartStatus);
}
if (!string.IsNullOrEmpty(param.EndStatus.ParseToString()))
{
expression = expression.And(t => t.Status <= param.EndStatus);
}
if (!string.IsNullOrEmpty(param.StartTime.ParseToString()))
{
expression = expression.And(t => t.CheckTime >= param.StartTime);
}
if (!string.IsNullOrEmpty(param.EndTime.ParseToString()))
{
param.EndTime = param.EndTime.Value.Date.Add(new TimeSpan(23, 59, 59));
expression = expression.And(t => t.CheckTime <= param.EndTime);
}
}
return(expression);
}
public async Task <ActionResult> GetPageListJson(VehicleListParam param, Pagination pagination)
{
TData <List <VehicleEntity> > obj = await vehicleBLL.GetPageList(param, pagination);
return(Json(obj));
}
