protected override void InsertingItem(PREPreferentialLog info, ParkDataContext parking)
{
if (info.Operator != null)
{
if (!parking.GetTable <PREOperatorInfo>().Contains(info.Operator))
{
parking.GetTable <PREOperatorInfo>().Attach(info.Operator);//不需要在插入优惠信息时同时插入操作员的角色
}
}
base.InsertingItem(info, parking);
}
protected override void InsertingItem(OperatorInfo info, ParkDataContext parking)
{
if (info.Role != null)
{
parking.GetTable <RoleInfo>().Attach(info.Role); //不需要在插入操作员时同时插入操作员的角色
}
if (info.Dept != null)
{
parking.GetTable <DeptInfo>().Attach(info.Dept); //不需要在插入操作员时同时插入操作员的部门
}
base.InsertingItem(info, parking);
}
protected override List <APMLog> GetingItems(ParkDataContext parking, SearchCondition search)
{
if (search is APMLogSearchCondition)
{
IQueryable <APMLog> result = parking.GetTable <APMLog>();
APMLogSearchCondition condition = search as APMLogSearchCondition;
result = result.Where(item => item.LogDateTime >= condition.RecordDateTimeRange.Begin &&
item.LogDateTime <= condition.RecordDateTimeRange.End);
if (!string.IsNullOrEmpty(condition.SerialNum))
{
result = result.Where(item => item.SerialNumber == condition.SerialNum);
}
if (!string.IsNullOrEmpty(condition.MID))
{
result = result.Where(item => item.MID == condition.MID);
}
if (!string.IsNullOrEmpty(condition.CardID))
{
result = result.Where(item => item.CardID == condition.CardID);
}
if (!string.IsNullOrEmpty(condition.Description))
{
result = result.Where(item => item.Description.Contains(condition.Description));
}
if (condition.Types != null && condition.Types.Count > 0)
{
result = result.Where(item => condition.Types.Contains(item.LogType));
}
return(result.ToList());
}
return(new List <APMLog>());
}
protected override List <ETCPaymentRecord> GetingItems(ParkDataContext parking, SearchCondition search)
{
if (search is ETCPaymentRecordSearchCondition)
{
ETCPaymentRecordSearchCondition con = search as ETCPaymentRecordSearchCondition;
IQueryable <ETCPaymentRecord> result = parking.GetTable <ETCPaymentRecord>();
if (con.AddTime != null)
{
result = result.Where(it => it.AddTime >= con.AddTime.Begin && it.AddTime <= con.AddTime.End);
}
if (!string.IsNullOrEmpty(con.LaneNo))
{
result = result.Where(it => it.LaneNo == con.LaneNo);
}
if (con.WaitingUpload.HasValue)
{
if (con.WaitingUpload.Value)
{
result = result.Where(it => it.UploadTime == null);
}
else
{
result = result.Where(it => it.UploadTime != null);
}
}
return(result.ToList());
}
return(new List <ETCPaymentRecord>());
}
protected override List <EntranceInfo> GetingItems(ParkDataContext parking, SearchCondition search)
{
if (search is EntranceSearchCondition)
{
EntranceSearchCondition con = search as EntranceSearchCondition;
var result = parking.GetTable <EntranceInfo>() as IQueryable <EntranceInfo>;
if (con.ParkID > 0)
{
result = result.Where(e => e.ParkID == con.ParkID);
}
if (con.EntranceID > 0)
{
result = result.Where(e => e.EntranceID == con.EntranceID);
}
if (!string.IsNullOrEmpty(con.EntranceName))
{
result = result.Where(e => e.EntranceName.Contains(con.EntranceName));
}
return(result.ToList());
}
else
{
return(new List <EntranceInfo>());
}
}
protected override void InsertingItem(WorkStationInfo info, ParkDataContext parking)
{
if (info.Dept != null)
{
parking.GetTable <DeptInfo>().Attach(info.Dept); //不需要在插入工作站时同时插入工作站的部门
}
base.InsertingItem(info, parking);
}
protected override SpeedingLog GetingItemByID(Guid id, ParkDataContext parking)
{
DataLoadOptions opt = new DataLoadOptions();
opt.LoadWith <SpeedingLog>(l => l.DealOperator);
parking.LoadOptions = opt;
return(parking.GetTable <SpeedingLog>().SingleOrDefault(r => r.SpeedingID == id));
}
protected override void InsertingItem(SpeedingLog info, ParkDataContext parking)
{
if (info.DealOperator != null)
{
parking.GetTable <OperatorInfo>().Attach(info.DealOperator); //不需要在插入已处理违章记录时同时插入处理的操作员
}
base.InsertingItem(info, parking);
}
protected override List <SpeedingLog> GetingAllItems(ParkDataContext parking)
{
DataLoadOptions opt = new DataLoadOptions();
opt.LoadWith <SpeedingLog>(l => l.DealOperator);
parking.LoadOptions = opt;
return(parking.GetTable <SpeedingLog>().ToList());
}
protected override void InsertingItem(OperatorSettleLog info, ParkDataContext parking)
{
if (info.Dept != null)
{
parking.GetTable <DeptInfo>().Attach(info.Dept); //不需要在插入操作员结算记录时同时插入操作员的部门
}
base.InsertingItem(info, parking);
}
protected override List <ParkCarPort> GetingItems(ParkDataContext parking, SearchCondition search)
{
IQueryable <ParkCarPort> ret = parking.GetTable <ParkCarPort>();
if (search is ParkCarPortSearchCondition)
{
ParkCarPortSearchCondition con = search as ParkCarPortSearchCondition;
if (con.ParkID > 0)
{
ret = ret.Where(item => item.ParkID == con.ParkID);
}
}
return(ret.ToList());
}
protected override List <ECardRecord> GetingItems(ParkDataContext parking, SearchCondition search)
{
List <ECardRecord> items = new List <ECardRecord>();
IQueryable <ECardRecord> result = parking.GetTable <ECardRecord>();
if (search is RecordSearchCondition)
{
RecordSearchCondition condition = search as RecordSearchCondition;
if (!string.IsNullOrEmpty(condition.CardID))
{
result = result.Where(c => c.CardID == condition.CardID);
}
items = result.ToList();
}
return(items);
}
protected override List <YangChenTongLog> GetingItems(ParkDataContext parking, SearchCondition search)
{
if (search is RecordSearchCondition)
{
IQueryable <YangChenTongLog> result = parking.GetTable <YangChenTongLog>();
RecordSearchCondition condition = search as RecordSearchCondition;
result = result.Where(item => item.LogDateTime >= condition.RecordDateTimeRange.Begin &&
item.LogDateTime <= condition.RecordDateTimeRange.End);
if (!string.IsNullOrEmpty(condition.CardID))
{
result = result.Where(item => item.CardID == condition.CardID);
}
return(result.ToList());
}
return(new List <YangChenTongLog>());
}
protected override List <YCTPaymentRecord> GetingItems(ParkDataContext parking, SearchCondition search)
{
IQueryable <YCTPaymentRecord> result = parking.GetTable <YCTPaymentRecord>();
if (search is YCTPaymentRecordSearchCondition)
{
YCTPaymentRecordSearchCondition con = search as YCTPaymentRecordSearchCondition;
if (con.PaymentDateTimeRange != null)
{
result = result.Where(item => item.TIM >= con.PaymentDateTimeRange.Begin && item.TIM <= con.PaymentDateTimeRange.End);
}
if (!string.IsNullOrEmpty(con.PID))
{
result = result.Where(item => item.PID == con.PID);
}
if (con.PSN.HasValue)
{
result = result.Where(item => item.PSN == con.PSN.Value);
}
if (con.TIM.HasValue)
{
result = result.Where(item => item.TIM == con.TIM.Value);
}
if (!string.IsNullOrEmpty(con.LCN))
{
result = result.Where(item => item.LCN == con.LCN);
}
if (con.WalletType.HasValue)
{
result = result.Where(item => item.WalletType == con.WalletType.Value);
}
if (con.State.HasValue)
{
result = result.Where(item => (int)item.State == con.State.Value);
}
if (!string.IsNullOrEmpty(con.UploadFile))
{
result = result.Where(item => item.UploadFile == con.UploadFile);
}
if (con.UnUploaded)
{
result = result.Where(item => item.UploadFile == null);
}
return(result.ToList());
}
return(new List <YCTPaymentRecord>());
}
protected override List <CardDeleteRecord> GetingItems(ParkDataContext parking, SearchCondition search)
{
if (search is RecordSearchCondition)
{
RecordSearchCondition con = search as RecordSearchCondition;
IQueryable <CardDeleteRecord> result = parking.GetTable <CardDeleteRecord>();
if (con.RecordDateTimeRange != null)
{
result = result.Where(c => c.DeleteDateTime >= con.RecordDateTimeRange.Begin).AsQueryable();
result = result.Where(c => c.DeleteDateTime <= con.RecordDateTimeRange.End).AsQueryable();
}
if (con.Operator != null)
{
result = result.Where(c => c.OperatorID == con.Operator.OperatorName);
}
if (con.StationID != null && con.StationID != "")
{
result = result.Where(c => c.StationID == con.StationID);
}
if (!string.IsNullOrEmpty(con.CardID))
{
result = result.Where(c => c.CardID.Contains(con.CardID));
}
if (!string.IsNullOrEmpty(con.CardCertificate))
{
result = result.Where(c => c.CardCertificate.Contains(con.CardCertificate));
}
if (!string.IsNullOrEmpty(con.OwnerName))
{
result = result.Where(c => c.OwnerName.Contains(con.OwnerName));
}
if (!string.IsNullOrEmpty(con.CarPlate))
{
result = result.Where(c => c.CarPlate.Contains(con.CarPlate));
}
List <CardDeleteRecord> items = result.ToList();
if (con.CardType != null)
{
items = items.Where(c => c.CardType == con.CardType).ToList();
}
return(items);
}
return(new List <CardDeleteRecord>());
}
protected override List <APMCheckOutRecord> GetingItems(ParkDataContext parking, SearchCondition search)
{
if (search is APMCheckOutRecordSearchCondition)
{
IQueryable <APMCheckOutRecord> result = parking.GetTable <APMCheckOutRecord>();
APMCheckOutRecordSearchCondition condition = search as APMCheckOutRecordSearchCondition;
result = result.Where(item => item.CheckOutDateTime >= condition.RecordDateTimeRange.Begin &&
item.CheckOutDateTime <= condition.RecordDateTimeRange.End);
if (!string.IsNullOrEmpty(condition.MID))
{
result = result.Where(item => item.MID == condition.MID);
}
if (!string.IsNullOrEmpty(condition.APMOperator))
{
result = result.Where(item => item.APMOperator == condition.APMOperator);
}
return(result.ToList());
}
return(new List <APMCheckOutRecord>());
}
protected override List <SpeedingRecord> GetingItems(ParkDataContext parking, SearchCondition search)
{
if (search is RecordSearchCondition)
{
RecordSearchCondition con = search as RecordSearchCondition;
IQueryable <SpeedingRecord> result = parking.GetTable <SpeedingRecord>().AsQueryable();
if (con.RecordDateTimeRange != null)
{
result = result.Where(c => c.SpeedingDateTime >= con.RecordDateTimeRange.Begin);
result = result.Where(c => c.SpeedingDateTime <= con.RecordDateTimeRange.End);
}
if (!string.IsNullOrEmpty(con.CarPlate))
{
//由于超速记录是以车牌号码关联的，所以这里的车牌必须一致
result = result.Where(c => c.PlateNumber == con.CarPlate);
}
result = result.OrderByDescending(c => c.SpeedingDateTime);
return(result.ToList());
}
return(new List <SpeedingRecord>());
}
protected override List <YCTBlacklist> GetingItems(ParkDataContext parking, SearchCondition search)
{
IQueryable <YCTBlacklist> result = parking.GetTable <YCTBlacklist>();
if (search is YCTBlacklistSearchCondition)
{
YCTBlacklistSearchCondition con = search as YCTBlacklistSearchCondition;
if (con.WalletType != null)
{
result = result.Where(item => item.WalletType == con.WalletType.Value);
}
if (con.OnlyCatched)
{
result = result.Where(item => item.CatchAt != null);
}
if (con.OnlyUnUploaded)
{
result = result.Where(item => item.CatchAt != null && item.UploadFile == null);
}
}
return(result.ToList());
}
protected override YangChenTongLog GetingItemByID(int id, ParkDataContext parking)
{
return(parking.GetTable <YangChenTongLog>().SingleOrDefault(item => item.LogID == id));
}
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 CardPaymentInfo GetingItemByID(int id, ParkDataContext parking)
{
return(parking.GetTable <CardPaymentInfo>().SingleOrDefault(c => c.ID == id));
}
protected override WorkStationInfo GetingItemByID(string id, ParkDataContext parking)
{
return(parking.GetTable <WorkStationInfo>().SingleOrDefault(w => w.StationID == id));
}
protected virtual void DeletingItem(TInfo info, ParkDataContext parking)
{
//如果删除实体时要删除其关联数据,就得重写这个方法
parking.GetTable <TInfo>().Attach(info);
parking.GetTable <TInfo>().DeleteOnSubmit(info);
}
protected virtual void UpdatingItem(TInfo newVal, TInfo original, ParkDataContext parking)
{
//所有实体都可以用这个方法来更新数据
parking.GetTable <TInfo>().Attach(newVal, original);
}
protected virtual void InsertingItem(TInfo info, ParkDataContext parking)
{
parking.GetTable <TInfo>().InsertOnSubmit(info);
}
protected override RoadWayInfo GetingItemByID(int id, ParkDataContext parking)
{
return(parking.GetTable <RoadWayInfo>().SingleOrDefault(item => item.RoadID == id));
}
protected override ETCPaymentRecord GetingItemByID(int id, ParkDataContext parking)
{
return(parking.GetTable <ETCPaymentRecord>().SingleOrDefault(it => it.ID == id));
}
protected override ECardRecord GetingItemByID(int id, ParkDataContext parking)
{
return(parking.GetTable <ECardRecord>().SingleOrDefault(c => c.ID == id));
}
protected virtual List <TInfo> GetingAllItems(ParkDataContext parking)
{
//如果实体类要加载其关联数据,就重写此方法
return(parking.GetTable <TInfo>().Select(t => t).ToList());
}
protected override List <WaitingCommandInfo> GetingAllItems(ParkDataContext parking)
{
return(parking.GetTable <WaitingCommandInfo>().Select(t => t).OrderBy(t => t.EntranceID).ToList());
}
