//获取司机排队名次([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)); }