protected override WorkStationInfo GetingItemByID(string id, ParkDataContext parking)
{
return(parking.GetTable <WorkStationInfo>().SingleOrDefault(w => w.StationID == id));
}
protected override SysparameterInfo GetingItemByID(string id, ParkDataContext parking)
{
return(parking.Sysparameter.SingleOrDefault(s => s.Parameter == id));
}
protected override ParkInfo GetingItemByID(int id, ParkDataContext parking)
{
return(parking.Park.Single(p => p.ParkID == id));
}
protected override CardEventRecord GetingItemByID(RecordID id, ParkDataContext parking)
{
return(parking.CardEvent.SingleOrDefault(c => c.CardID == id.CardID && c.EventDateTime == id.RecordDateTime));
}
protected override OperatorSettleLog GetingItemByID(DateTime id, ParkDataContext parking)
{
return(parking.OperatorLog.SingleOrDefault(o => o.SettleDateTime == id));
}
protected override WaitingCommandInfo GetingItemByID(WaitingCommandID id, ParkDataContext parking)
{
return(parking.GetTable <WaitingCommandInfo>().SingleOrDefault(w => w.EntranceID == id.EntranceID && w.Command == id.Command && w.CardID == id.CardID));
}
protected override void DeletingItem(WaitingCommandInfo info, ParkDataContext parking)
{
string cmd = @"delete WaitingCommand where EntranceID=@p0 and Command=@p1 and CardID=@p2";
parking.ExecuteCommand(cmd, info.EntranceID, info.Command, info.CardID);
}
protected virtual List <TInfo> GetingAllItems(ParkDataContext parking)
{
//如果实体类要加载其关联数据,就重写此方法
return(parking.GetTable <TInfo>().Select(t => t).ToList());
}
protected virtual List <TInfo> GetingItems(ParkDataContext parking, SearchCondition search)
{
//如果要实现这个功能,子类一定要重写这个方法
throw new NotImplementedException("子类没有重写GetingItems方法");
}
protected override EntranceInfo GetingItemByID(int id, ParkDataContext Parking)
{
return(Parking.Entrance.SingleOrDefault(e => e.EntranceID == id));
}
protected virtual TInfo GetingItemByID(TID id, ParkDataContext parking)
{
//每一个子类都要重写这个方法
throw new Exception("子类没有重写GetingItemByID方法!");
}
protected override void DeletingItem(PRERoleInfo info, ParkDataContext parking)
{
parking.PRERole.Attach(info);
parking.PRERole.DeleteOnSubmit(info);
}
protected override PRERoleInfo GetingItemByID(string id, ParkDataContext parking)
{
return(parking.PRERole.SingleOrDefault(r => r.RoleID == id));
}
protected override ServerSwitchRecord GetingItemByID(int id, ParkDataContext parking)
{
return(parking.ServerSwitchRecord.SingleOrDefault(s => s.RecordID == id));
}
protected override PREBusinesses GetingItemByID(string id, ParkDataContext parking)
{
return(parking.PREBusinesses.SingleOrDefault(r => r.BusinessesID.ToString() == id));
}
protected virtual void InsertingItem(TInfo info, ParkDataContext parking)
{
parking.GetTable <TInfo>().InsertOnSubmit(info);
}
protected override void DeletingItem(PREBusinesses info, ParkDataContext parking)
{
parking.PREBusinesses.Attach(info);
parking.PREBusinesses.DeleteOnSubmit(info);
}
protected virtual void UpdatingItem(TInfo newVal, TInfo original, ParkDataContext parking)
{
//所有实体都可以用这个方法来更新数据
parking.GetTable <TInfo>().Attach(newVal, original);
}
protected override List <WaitingCommandInfo> GetingAllItems(ParkDataContext parking)
{
return(parking.GetTable <WaitingCommandInfo>().Select(t => t).OrderBy(t => t.EntranceID).ToList());
}
protected virtual void DeletingItem(TInfo info, ParkDataContext parking)
{
//如果删除实体时要删除其关联数据,就得重写这个方法
parking.GetTable <TInfo>().Attach(info);
parking.GetTable <TInfo>().DeleteOnSubmit(info);
}
protected override SnapShot GetingItemByID(SnapShotID id, ParkDataContext parking)
{
return(parking.SnapShot.SingleOrDefault(s => s.ShotAt == id.ShotAt && s.VideoSourceID == id.VideoSourceID));
}
protected override YCTBlacklist GetingItemByID(string id, ParkDataContext parking)
{
return(parking.GetTable <YCTBlacklist>().SingleOrDefault(item => item.LCN == id));
}
protected override List <CardEventRecord> GetingItems(ParkDataContext parking, SearchCondition search)
{
List <CardEventRecord> items = new List <CardEventRecord>();
IQueryable <CardEventRecord> result = parking.CardEvent;
if (search is RecordSearchCondition)
{
RecordSearchCondition condition = search as RecordSearchCondition;
if (condition.RecordDateTimeRange != null)
{
result = result.Where(c => c.EventDateTime >= condition.RecordDateTimeRange.Begin).AsQueryable();
result = result.Where(c => c.EventDateTime <= condition.RecordDateTimeRange.End).AsQueryable();
}
if (!string.IsNullOrEmpty(condition.CardID))
{
result = result.Where(c => c.CardID == condition.CardID);
}
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 (!string.IsNullOrEmpty(condition.OwnerName))
{
result = result.Where(c => c.OwnerName.Contains(condition.OwnerName));
}
if (!string.IsNullOrEmpty(condition.Department))
{
result = result.Where(c => c.Department == condition.Department);
}
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 (condition.CarType != null)
{
result = result.Where(c => c.CarType == condition.CarType);
}
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 (search is CardEventSearchCondition)
{
CardEventSearchCondition s = search as CardEventSearchCondition;
if (s.CarType != null)
{
result = result.Where(item => item.CarType == s.CarType);
}
if (!string.IsNullOrEmpty(s.CarPlate))
{
result = result.Where(c => c.CarPlate.Contains(s.CarPlate));
}
if (s.OnlyExitEvent)
{
result = result.Where(item => item.IsExitEvent == true);
}
if (s.OnlyEnterEvent)
{
result = result.Where(item => item.IsExitEvent == false);
}
}
items = result.ToList();
if (condition.CardType != null)
{
items = items.Where(c => c.CardType == condition.CardType).ToList();
}
if (search is CardEventSearchCondition)
{
CardEventSearchCondition s = search as CardEventSearchCondition;
if (s.Source != null && s.Source.Count > 0)
{
items = (from c in items join e in s.Source on c.EntranceID equals e.EntranceID select c).ToList();
}
}
}
return(items);
}
protected override APMLog GetingItemByID(int id, ParkDataContext parking)
{
return(parking.GetTable <APMLog>().SingleOrDefault(item => item.ID == id));
}
protected override YCTPaymentRecord GetingItemByID(int id, ParkDataContext parking)
{
return(parking.GetTable <YCTPaymentRecord>().SingleOrDefault(item => item.ID == id));
}
protected override DeptInfo GetingItemByID(string id, ParkDataContext parking)
{
return(parking.Dept.SingleOrDefault(r => r.DeptID.ToString() == id));
}
protected override VideoSourceInfo GetingItemByID(int id, ParkDataContext parking)
{
return(parking.VideoSource.SingleOrDefault(v => v.VideoID == id));
}
protected override void DeletingItem(DeptInfo info, ParkDataContext parking)
{
parking.Dept.Attach(info);
parking.Dept.DeleteOnSubmit(info);
}
public UnitWork(string connStr)
{
_Parking = ParkDataContextFactory.CreateParking(connStr);
}
protected override CardInfo GetingItemByID(string id, ParkDataContext parking)
{
CardInfo info = parking.Card.SingleOrDefault(c => c.CardID == id);
return(info);
}