public static bool DelCable(CableInfo cable)
{
TmpCables.Remove(cable);
TmpCircuits.RemoveAll(circuit => circuit.ParentCableId == cable.CableId);
TmpDots.RemoveAll(dot => dot.ParentCableId == cable.CableId);
return(true);
}
public static bool CopyCable(CableInfo cable, string username)
{
var newCbale = new CableInfo(cable)
{
CableName = cable.CableName + " 副本",
CreateUser = username,
ModifyDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
};
TmpCables.Add(newCbale);
var circuits = TmpCircuits.Where(circuit => circuit.ParentCableId == cable.CableId).ToList();
foreach (var srcCircuit in circuits)
{
var circuit = new CircuitInfo(srcCircuit)
{
ParentCableId = newCbale.CableId,
};
TmpCircuits.Add(circuit);
}
var dots = TmpDots.Where(dot => dot.ParentCableId == cable.CableId).ToList();
foreach (var srcDot in dots)
{
var dot = new DotInfo(srcDot)
{
ParentCableId = newCbale.CableId
};
TmpDots.Add(dot);
}
return(true);
}
public static bool CacheCopyCable()
{
var newCables = TmpCables.Except(DbCables).ToList();
if (newCables.Count > 0)
{
DbCables.AddRange(newCables);
DbGraph.InsertCables(newCables);
}
var newCircusts = TmpCircuits.Except(DbCircuits).ToList();
if (newCircusts.Count > 0)
{
DbCircuits.AddRange(newCircusts);
DbGraph.InsertCircuits(newCircusts);
}
var newDots = TmpDots.Except(DbDots).ToList();
if (newDots.Count > 0)
{
DbDots.AddRange(newDots);
DbGraph.InsertDots(newDots);
}
return(true);
}
public static int GetMaxCableId()
{
if (TmpCables == null || TmpCables.Count <= 0)
{
return(0);
}
return(TmpCables.Max(x => x.CableId));
}
public static bool IsCableNameExist(CableInfo cmpCable, string cableName, out bool isCableNameExist)
{
if (TmpCables.Any(cable => cable.CableName == cableName.Trim() && cable != cmpCable))
{
isCableNameExist = true;
return(true);
}
isCableNameExist = false;
return(true);
}
public static bool GetCablesByName(out List <CableInfo> cableList, string cableName)
{
if (!string.IsNullOrWhiteSpace(cableName))
{
cableList = TmpCables.Where(cable => cable.CableName.Contains(cableName)).ToList();
return(true);
}
cableList = TmpCables;
return(true);
}
public static bool AddCable(CableInfo cable)
{
TmpCables.Add(cable);
var circuitInfo = new CircuitInfo
{
ParentCableId = cable.CableId,
CircuitId = 0,
Name = "空点"
};
AddCircuit(circuitInfo);
return(true);
}
public static bool CacheAddCable()
{
var updataCables = TmpCables.Intersect(DbCables).ToList();
if (updataCables.Count > 0)
{
DbGraph.UpdateCables(updataCables);
}
var newCables = TmpCables.Except(DbCables).ToList();
if (newCables.Count > 0)
{
DbCables.AddRange(newCables);
DbGraph.InsertCables(newCables);
}
var newCircusts = TmpCircuits.Except(DbCircuits).ToList();
if (newCircusts.Count > 0)
{
DbCircuits.AddRange(newCircusts);
DbGraph.InsertCircuits(newCircusts);
}
return(true);
}
//更新所有样线记录
public static bool CacheSaveCable()
{
//cable
var updataCables = TmpCables.Intersect(DbCables).ToList();
if (updataCables.Count > 0)
{
DbGraph.UpdateCables(updataCables);
}
var newCables = TmpCables.Except(DbCables).ToList();
if (newCables.Count > 0)
{
DbCables.AddRange(newCables);
DbGraph.InsertCables(newCables);
}
var delCables = DbCables.Except(TmpCables).ToList();
if (delCables.Count > 0)
{
foreach (var cable in delCables)
{
DbCables.Remove(cable);
}
DbGraph.DelCables(delCables);
}
//circuit
var updataCircuits = TmpCircuits.Intersect(DbCircuits).ToList();
if (updataCircuits.Count > 0)
{
DbGraph.UpdataCircuits(updataCircuits);
}
var newCircusts = TmpCircuits.Except(DbCircuits).ToList();
if (newCircusts.Count > 0)
{
DbCircuits.AddRange(newCircusts);
DbGraph.InsertCircuits(newCircusts);
}
var delCircuits = DbCircuits.Except(TmpCircuits).ToList();
if (delCircuits.Count > 0)
{
foreach (var circuit in delCircuits)
{
DbCircuits.Remove(circuit);
}
DbGraph.DelCircuits(delCircuits);
}
//dot
var updataDots = TmpDots.Intersect(DbDots).ToList();
if (updataDots.Count > 0)
{
DbGraph.UpdataDots(updataDots);
}
var newDots = TmpDots.Except(DbDots).ToList();
if (newDots.Count > 0)
{
DbDots.AddRange(newDots);
DbGraph.InsertDots(newDots);
}
var delDots = DbDots.Except(TmpDots).ToList();
if (delDots.Count > 0)
{
foreach (var dot in delDots)
{
DbDots.Remove(dot);
}
DbGraph.DelDots(delDots);
}
return(true);
}
