protected override List <SnapShot> GetingItems(ParkDataContext parking, Ralid.Park.BusinessModel.SearchCondition.SearchCondition search)
{
List <SnapShot> items = new List <SnapShot>();
if (search is SnapShotSearchCondition)
{
SnapShotSearchCondition con = search as SnapShotSearchCondition;
IQueryable <SnapShot> result = parking.SnapShot;
if (con.ShotDateTime != null)
{
DateTime shotdatetime = new DateTime(con.ShotDateTime.Value.Year,
con.ShotDateTime.Value.Month,
con.ShotDateTime.Value.Day,
con.ShotDateTime.Value.Hour,
con.ShotDateTime.Value.Minute,
con.ShotDateTime.Value.Second);
//只精确到秒，因为脱机模式时，卡片的进场时间只保存到秒部分
result = result.Where(s => s.ShotAt >= shotdatetime && s.ShotAt < shotdatetime.AddSeconds(1));
//result = result.Where(s => s.ShotAt == con.ShotDateTime.Value);
}
if (!string.IsNullOrEmpty(con.CardID))
{
result = result.Where(s => s.CardID == con.CardID);
}
items = result.ToList();
}
return(items);
}
protected override List <SnapShot> GetingItems(ParkDataContext parking, Ralid.Park.BusinessModel.SearchCondition.SearchCondition search)
{
List <SnapShot> items = new List <SnapShot>();
if (search is SnapShotSearchCondition)
{
SnapShotSearchCondition con = search as SnapShotSearchCondition;
IQueryable <SnapShot> result = parking.SnapShot;
if (con.ShotDateTime != null)
{
result = result.Where(s => s.ShotAt == con.ShotDateTime.Value);
}
items = result.ToList();
}
return(items);
}
protected override List <CardPaymentInfo> GetingItems(ParkDataContext parking, Ralid.Park.BusinessModel.SearchCondition.SearchCondition search)
{
List <CardPaymentInfo> items = null;
IQueryable <CardPaymentInfo> result = parking.GetTable <CardPaymentInfo>();
if (search is RecordSearchCondition)
{
RecordSearchCondition condition = search as RecordSearchCondition;
if (condition.RecordDateTimeRange != null)
{
result = result.Where(c => c.ChargeDateTime >= condition.RecordDateTimeRange.Begin);
result = result.Where(c => c.ChargeDateTime <= condition.RecordDateTimeRange.End);
}
if (!string.IsNullOrEmpty(condition.CardID))
{
result = result.Where(c => c.CardID == condition.CardID);
}
if (condition.PaymentMode != null)
{
result = result.Where(c => c.PaymentMode == condition.PaymentMode.Value);
}
if (condition.Operator != null)
{
result = result.Where(c => c.OperatorID == condition.Operator.OperatorName);
}
if (!string.IsNullOrEmpty(condition.StationID))
{
result = result.Where(c => c.StationID == condition.StationID);
}
if (condition.IsUnSettled != null)
{
if (condition.IsUnSettled.Value)
{
result = result.Where(c => c.SettleDateTime == null);
}
else
{
result = result.Where(c => c.SettleDateTime != null);
}
}
if (condition.SettleDateTime != null)
{
result = result.Where(c => c.SettleDateTime == condition.SettleDateTime.Value);
}
if (!string.IsNullOrEmpty(condition.CarPlate))
{
result = result.Where(c => c.CarPlate.Contains(condition.CarPlate));
}
if (condition.CarType != null)
{
result = result.Where(c => c.CarType == condition.CarType.Value);
}
if (!string.IsNullOrEmpty(condition.OwnerName))
{
result = result.Where(c => c.OwnerName.Contains(condition.OwnerName));
}
if (!string.IsNullOrEmpty(condition.CardCertificate))
{
result = result.Where(c => c.CardCertificate.Contains(condition.CardCertificate));
}
if (condition.UpdateFlag != null)
{
result = result.Where(c => c.UpdateFlag == condition.UpdateFlag);
}
if (condition.StationIDs != null && condition.StationIDs.Count > 0)
{
result = result.Where(c => condition.StationIDs.Contains(c.StationID));
}
if (condition.OperatorIDs != null && condition.OperatorIDs.Count > 0)
{
result = result.Where(c => condition.OperatorIDs.Contains(c.OperatorID));
}
if (condition.StationDeptID.HasValue)
{
result = result.Where(c => c.StationDeptID.HasValue && c.StationDeptID.Value == condition.StationDeptID.Value);
}
if (condition.OperatorDeptID.HasValue)
{
result = result.Where(c => c.OperatorDeptID.HasValue && c.OperatorDeptID.Value == condition.OperatorDeptID.Value);
}
if (search is CardPaymentRecordSearchCondition)
{
CardPaymentRecordSearchCondition condition1 = search as CardPaymentRecordSearchCondition;
if (condition1.EnterDateTime != null)
{
result = result.Where(c => c.EnterDateTime == condition1.EnterDateTime.Value);
}
if (condition1.EnterDateTimeRange != null)
{
result = result.Where(c => c.EnterDateTime >= condition1.EnterDateTimeRange.Begin && c.EnterDateTime <= condition1.EnterDateTimeRange.End);
}
if (condition1.IsCenterCharge != null && condition1.IsCenterCharge.Value)
{
result = result.Where(c => c.IsCenterCharge == true);
}
if (condition1.IsCenterCharge != null && !condition1.IsCenterCharge.Value)
{
result = result.Where(c => c.IsCenterCharge == false);
}
if (condition1.ChargeDateTime != null)
{
result = result.Where(c => c.ChargeDateTime == condition1.ChargeDateTime.Value);
}
if (condition1.PaymentCode != null)
{
result = result.Where(c => c.PaymentCode == condition1.PaymentCode.Value);
}
if (!string.IsNullOrEmpty(condition1.OperatorCardID))
{
result = result.Where(c => c.OperatorCardID == condition1.OperatorCardID);
}
}
items = result.ToList();
if (condition.CardType != null)
{
items = items.Where(c => c.CardType == condition.CardType).ToList();
}
}
else
{
items = new List <CardPaymentInfo>();
}
return(items);
}
protected override List <CardPaymentInfo> GetingItems(ParkDataContext parking, Ralid.Park.BusinessModel.SearchCondition.SearchCondition search)
{
List <CardPaymentInfo> items = null;
IQueryable <CardPaymentInfo> result = parking.GetTable <CardPaymentInfo>();
if (search is CardPaymentRecordSearchCondition)
{
CardPaymentRecordSearchCondition condition = search as CardPaymentRecordSearchCondition;
if (condition.RecordDateTimeRange != null)
{
result = result.Where(c => c.ChargeDateTime >= condition.RecordDateTimeRange.Begin);
result = result.Where(c => c.ChargeDateTime <= condition.RecordDateTimeRange.End);
}
if (!string.IsNullOrEmpty(condition.CardID))
{
result = result.Where(c => c.CardID == condition.CardID);
}
if (condition.EnterDateTime != null)
{
result = result.Where(c => c.EnterDateTime == condition.EnterDateTime.Value);
}
if (condition.PaymentMode != null)
{
result = result.Where(c => c.PaymentMode == condition.PaymentMode.Value);
}
if (condition.Operator != null)
{
result = result.Where(c => c.OperatorID == condition.Operator.OperatorID);
}
if (!string.IsNullOrEmpty(condition.StationID))
{
result = result.Where(c => c.StationID == condition.StationID);
}
if (!string.IsNullOrEmpty(condition.CarPalte))
{
result = result.Where(c => c.CarPlate.Contains(condition.CarPalte));
}
if (condition.PaymentMode != null)
{
result = result.Where(c => c.PaymentMode == condition.PaymentMode);
}
items = result.ToList();
if (condition.CardType != null)
{
items = items.Where(c => c.CardType == condition.CardType).ToList();
}
}
else if (search is RecordSearchCondition)
{
RecordSearchCondition condition = search as RecordSearchCondition;
if (condition.RecordDateTimeRange != null)
{
result = result.Where(c => c.ChargeDateTime >= condition.RecordDateTimeRange.Begin);
result = result.Where(c => c.ChargeDateTime <= condition.RecordDateTimeRange.End);
}
if (!string.IsNullOrEmpty(condition.CardID))
{
result = result.Where(c => c.CardID == condition.CardID);
}
if (condition.PaymentMode != null)
{
result = result.Where(c => c.PaymentMode == condition.PaymentMode.Value);
}
if (condition.Operator != null)
{
result = result.Where(c => c.OperatorID == condition.Operator.OperatorID);
}
if (!string.IsNullOrEmpty(condition.StationID))
{
result = result.Where(c => c.StationID == condition.StationID);
}
items = result.ToList();
if (condition.CardType != null)
{
items = items.Where(c => c.CardType == condition.CardType).ToList();
}
}
else
{
items = new List <CardPaymentInfo>();
}
return(items);
}
