static void SaveComputerProcessors(int DepartmentID, lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc, AssetComputerData data)
{
var lds = (
from d in dc.AssetComputerProcessors
where d.DepartmentId == DepartmentID && d.AssetId == data.AssetNumber
select d
).ToList();
var NeedDel = lds.Where(d1 => !data.Processors.Select(d2 => d2.DeviceID).Contains(d1.DeviceID)).ToList();
dc.AssetComputerProcessors.DeleteAllOnSubmit(NeedDel);
var NeedInsert = data.Processors.Where(d1 => !lds.Select(d2 => d2.DeviceID).Contains(d1.DeviceID)).ToList();
foreach (AssetComputerProcessorData i in NeedInsert)
{
var New = new lib.bwa.bigWebDesk.LinqBll.Context.AssetComputerProcessors();
CopyComputerProcessor(i, New, DepartmentID, data.AssetNumber);
dc.AssetComputerProcessors.InsertOnSubmit(New);
}
var NeedUpdate = lds.Where(d1 => data.Processors.Select(d2 => d2.DeviceID).Contains(d1.DeviceID)).ToList();
foreach (var i in NeedUpdate)
{
var source = data.Processors.Where(d => d.DeviceID == i.DeviceID).FirstOrDefault();
if (source == null || source.DeviceID == null)
{
continue;
}
CopyComputerProcessor(source, i, DepartmentID, data.AssetNumber);
}
}
private static void CopyProcessors(lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc, int DepartmentId, int OldAssetId, int NewAssetId)
{
var OldProcessors = (from d in dc.AssetComputerProcessors where d.DepartmentId == DepartmentId && d.AssetId == OldAssetId select d).ToList();
foreach (var d in OldProcessors)
{
var NewD = new lib.bwa.bigWebDesk.LinqBll.Context.AssetComputerProcessors()
{
DepartmentId = DepartmentId,
AssetId = NewAssetId,
CPUType = d.CPUType,
CPUSerial = d.CPUSerial,
CPUVendor = d.CPUVendor,
CPUSpeedMHz = d.CPUSpeedMHz,
CPUClass = d.CPUClass,
CurrentClockSpeed = d.CurrentClockSpeed,
UniqueId = d.UniqueId,
Description = d.Description,
Version = d.Version,
L2CachSize = d.L2CachSize,
ExtClock = d.ExtClock,
CurrentVoltage = d.CurrentVoltage,
DeviceID = d.DeviceID
};
dc.AssetComputerProcessors.InsertOnSubmit(NewD);
}
}
static void CopyComputerProcessor(AssetComputerProcessorData source, lib.bwa.bigWebDesk.LinqBll.Context.AssetComputerProcessors dest, int DepartmentID, int AssetID)
{
dest.AssetId = AssetID;
dest.CPUClass = source.CPUClass;
dest.CPUSerial = source.CPUSerial;
dest.CPUSpeedMHz = source.CPUSpeedMHz;
dest.CPUType = source.CPUType;
dest.CPUVendor = source.CPUVendor;
dest.CurrentClockSpeed = source.CurrentClockSpeed;
dest.CurrentVoltage = source.CurrentVoltage;
dest.DepartmentId = DepartmentID;
dest.Description = source.Description;
dest.DeviceID = source.DeviceID;
dest.ExtClock = source.ExtClock;
dest.L2CachSize = source.L2CachSize;
dest.UniqueId = source.UniqueId;
dest.Version = source.Version;
}
static void SaveComputerProcessors(int DepartmentID, lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc, AssetComputerData data)
{
var lds = (
from d in dc.AssetComputerProcessors
where d.DepartmentId == DepartmentID && d.AssetId == data.AssetNumber
select d
).ToList();
var NeedDel = lds.Where(d1 => !data.Processors.Select(d2 => d2.DeviceID).Contains(d1.DeviceID)).ToList();
dc.AssetComputerProcessors.DeleteAllOnSubmit(NeedDel);
var NeedInsert = data.Processors.Where(d1 => !lds.Select(d2 => d2.DeviceID).Contains(d1.DeviceID)).ToList();
foreach (AssetComputerProcessorData i in NeedInsert)
{
var New = new lib.bwa.bigWebDesk.LinqBll.Context.AssetComputerProcessors();
CopyComputerProcessor(i, New, DepartmentID, data.AssetNumber);
dc.AssetComputerProcessors.InsertOnSubmit(New);
}
var NeedUpdate = lds.Where(d1 => data.Processors.Select(d2 => d2.DeviceID).Contains(d1.DeviceID)).ToList();
foreach (var i in NeedUpdate)
{
var source = data.Processors.Where(d => d.DeviceID == i.DeviceID).FirstOrDefault();
if (source == null || source.DeviceID == null) continue;
CopyComputerProcessor(source, i, DepartmentID, data.AssetNumber);
}
}
private static void CopyProcessors(lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc, int DepartmentId, int OldAssetId, int NewAssetId)
{
var OldProcessors = (from d in dc.AssetComputerProcessors where d.DepartmentId == DepartmentId && d.AssetId == OldAssetId select d).ToList();
foreach (var d in OldProcessors)
{
var NewD = new lib.bwa.bigWebDesk.LinqBll.Context.AssetComputerProcessors()
{
DepartmentId = DepartmentId,
AssetId = NewAssetId,
CPUType = d.CPUType,
CPUSerial = d.CPUSerial,
CPUVendor = d.CPUVendor,
CPUSpeedMHz = d.CPUSpeedMHz,
CPUClass = d.CPUClass,
CurrentClockSpeed = d.CurrentClockSpeed,
UniqueId = d.UniqueId,
Description = d.Description,
Version = d.Version,
L2CachSize = d.L2CachSize,
ExtClock = d.ExtClock,
CurrentVoltage = d.CurrentVoltage,
DeviceID = d.DeviceID
};
dc.AssetComputerProcessors.InsertOnSubmit(NewD);
}
}
