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()); }