public static DeviceDiagnoseClass ConvertFromDB(T_DeviceDiagnose t_device)
{
DeviceDiagnoseClass device = new DeviceDiagnoseClass();
device.id = t_device.id;
device.Name = t_device.Name;
device.Guid = t_device.Guid ?? new Guid();
if (!string.IsNullOrWhiteSpace(t_device.ShaftsJson))
{
device.Shafts = JsonConvert.DeserializeObject <ObservableCollection <ShaftComponent> >(t_device.ShaftsJson);//可能有问题
//修复一些不进行json的字段
foreach (var shaft in device.Shafts)
{
if (shaft.Component != null)
{
shaft.Component.Parent = device;
shaft.Component.InitMachComponents();
}
}
}
else
{
device.Shafts = new ObservableCollection <ShaftComponent>();
}
device.HeadDivFreThreshold = t_device.HeadDivFreThreshold ?? 0;
device.IsDeviceDiagnosis = t_device.IsDeviceDiagnosis ?? false;
device.MeanThreshold = t_device.MeanThreshold ?? 0;
device.KurtosisIndexThreshold = t_device.KurtosisIndexThreshold ?? 0;
device.PeakThreshold = t_device.PeakThreshold ?? 0;
device.PulseIndexThreshold = t_device.PulseIndexThreshold ?? 0;
device.PeakIndexThreshold = t_device.PeakIndexThreshold ?? 0;
device.RMSThreshold = t_device.RMSThreshold ?? 0;
device.FrePeakFilterInterval = t_device.FrePeakFilterInterval ?? 0;
device.FreDiagnosisSetupInterval = t_device.FreDiagnosisSetupInterval ?? 0;
device.IsFaultprobability = t_device.IsFaultprobability ?? false;
device.DiagnosisMethod = (DiagnosisMethod)(t_device.DiagnosisMethod ?? 0);
if (!string.IsNullOrWhiteSpace(t_device.UnAllotItemsJson))
{
device.UnAllotItems = JsonConvert.DeserializeObject <ObservableCollection <ItemInfo> >(t_device.UnAllotItemsJson);
}
else
{
device.UnAllotItems = new ObservableCollection <ItemInfo>();
}
return(device);
}
public static T_DeviceDiagnose ConvertToDB(DeviceDiagnoseClass device)
{
T_DeviceDiagnose t_device = new T_DeviceDiagnose();
t_device.id = device.id;
t_device.Name = device.Name;
t_device.Guid = device.Guid;
if (device.Shafts != null)
{
t_device.ShaftsJson = JsonConvert.SerializeObject(device.Shafts);//可能有问题
}
else
{
t_device.ShaftsJson = null;
}
t_device.HeadDivFreThreshold = device.HeadDivFreThreshold;
t_device.IsDeviceDiagnosis = device.IsDeviceDiagnosis;
t_device.MeanThreshold = device.MeanThreshold;
t_device.KurtosisIndexThreshold = device.KurtosisIndexThreshold;
t_device.PeakThreshold = device.PeakThreshold;
t_device.PulseIndexThreshold = device.PulseIndexThreshold;
t_device.PeakIndexThreshold = device.PeakIndexThreshold;
t_device.RMSThreshold = device.RMSThreshold;
t_device.FrePeakFilterInterval = device.FrePeakFilterInterval;
t_device.FreDiagnosisSetupInterval = device.FreDiagnosisSetupInterval;
t_device.IsFaultprobability = device.IsFaultprobability;
t_device.DiagnosisMethod = (int)device.DiagnosisMethod;
if (device.UnAllotItems != null)
{
t_device.UnAllotItemsJson = JsonConvert.SerializeObject(device.UnAllotItems);
}
else
{
t_device.UnAllotItemsJson = null;
}
return(t_device);
}
private async void ShowWin()
{
if (DevicesIsSelected == true)
{
EditDeviceClassWin win = new EditDeviceClassWin(SelectedDevice);
win.ShowDialog();
T_DeviceDiagnose t_model = DeviceDiagnoseClass.ConvertToDB(SelectedDevice);
if (SelectedDevice.id == -1)
{
var id = await _databaseComponent.Add <T_DeviceDiagnose>(ServerIP, t_model);
if (id == -1)
{
UploadError = true;
}
else
{
SelectedDevice.id = id;
}
}
else
{
UploadError = !await _databaseComponent.Modify <T_DeviceDiagnose>(ServerIP, null, t_model);
}
}
else if (ShaftsIsSelected == true)
{
EditShaftClassWin win = new EditShaftClassWin(SelectedShaft);
win.ShowDialog();
T_Shaft t_model = ShaftClass.ConvertToDB(SelectedShaft);
if (SelectedShaft.id == -1)
{
var id = await _databaseComponent.Add <T_Shaft>(ServerIP, t_model);
if (id == -1)
{
UploadError = true;
}
else
{
SelectedShaft.id = id;
}
}
else
{
UploadError = !await _databaseComponent.Modify <T_Shaft>(ServerIP, null, t_model);
}
}
else if (BearingsIsSelected == true)
{
EditBearingClassWin win = new EditBearingClassWin(SelectedBearing);
win.ShowDialog();
T_Bearing t_model = BearingClass.ConvertToDB(SelectedBearing);
if (SelectedBearing.id == -1)
{
var id = await _databaseComponent.Add <T_Bearing>(ServerIP, t_model);
if (id == -1)
{
UploadError = true;
}
else
{
SelectedBearing.id = id;
}
}
else
{
UploadError = !await _databaseComponent.Modify <T_Bearing>(ServerIP, null, t_model);
}
}
else if (BeltsIsSelected == true)
{
EditBeltClassWin win = new EditBeltClassWin(SelectedBelt);
win.ShowDialog();
T_Belt t_model = BeltClass.ConvertToDB(SelectedBelt);
if (SelectedBelt.id == -1)
{
var id = await _databaseComponent.Add <T_Belt>(ServerIP, t_model);
if (id == -1)
{
UploadError = true;
}
else
{
SelectedBelt.id = id;
}
}
else
{
UploadError = !await _databaseComponent.Modify <T_Belt>(ServerIP, null, t_model);
}
}
else if (GearsIsSelected == true)
{
;
EditGearClassWin win = new EditGearClassWin(SelectedGear);
win.ShowDialog();
T_Gear t_model = GearClass.ConvertToDB(SelectedGear);
if (SelectedGear.id == -1)
{
var id = await _databaseComponent.Add <T_Gear>(ServerIP, t_model);
if (id == -1)
{
UploadError = true;
}
else
{
SelectedGear.id = id;
}
}
else
{
UploadError = !await _databaseComponent.Modify <T_Gear>(ServerIP, null, t_model);
}
}
else if (ImpellersIsSelected == true)
{
EditImpellerClassWin win = new EditImpellerClassWin(SelectedImpeller);
win.ShowDialog();
T_Impeller t_model = ImpellerClass.ConvertToDB(SelectedImpeller);
if (SelectedImpeller.id == -1)
{
var id = await _databaseComponent.Add <T_Impeller>(ServerIP, t_model);
if (id == -1)
{
UploadError = true;
}
else
{
SelectedImpeller.id = id;
}
}
else
{
UploadError = !await _databaseComponent.Modify <T_Impeller>(ServerIP, null, t_model);
}
}
else if (MotorsIsSelected == true)
{
EditMotorClassWin win = new EditMotorClassWin(SelectedMotor);
win.ShowDialog();
T_Motor t_model = MotorClass.ConvertToDB(SelectedMotor);
if (SelectedMotor.id == -1)
{
var id = await _databaseComponent.Add <T_Motor>(ServerIP, t_model);
if (id == -1)
{
UploadError = true;
}
else
{
SelectedMotor.id = id;
}
}
else
{
UploadError = !await _databaseComponent.Modify <T_Motor>(ServerIP, null, t_model);
}
}
}
private async void Delete(object value)
{
#if XBAP
MessageBoxResult result = MessageBox.Show("确定要删除?", "删除", MessageBoxButton.OK, MessageBoxImage.Warning);
#else
MessageBoxResult result = Xceed.Wpf.Toolkit.MessageBox.Show("确定要删除?", "删除", MessageBoxButton.OKCancel, MessageBoxImage.Warning);
#endif
if (result == MessageBoxResult.OK)
{
if (DevicesIsSelected == true)
{
T_DeviceDiagnose t_model = DeviceDiagnoseClass.ConvertToDB(SelectedDevice);
if (t_model.id != -1)
{
await _databaseComponent.Delete <T_DeviceDiagnose>(ServerIP, t_model.id);
}
Devices.Remove(SelectedDevice);
}
else if (ShaftsIsSelected == true)
{
T_Shaft t_model = ShaftClass.ConvertToDB(SelectedShaft);
if (t_model.id != -1)
{
await _databaseComponent.Delete <T_Shaft>(ServerIP, t_model.id);
}
Shafts.Remove(SelectedShaft);
}
else if (BearingsIsSelected == true)
{
T_Bearing t_model = BearingClass.ConvertToDB(SelectedBearing);
if (t_model.id != -1)
{
await _databaseComponent.Delete <T_Bearing>(ServerIP, t_model.id);
}
Bearings.Remove(SelectedBearing);
}
else if (BeltsIsSelected == true)
{
Belts.Remove(SelectedBelt);
T_Belt t_model = BeltClass.ConvertToDB(SelectedBelt);
if (t_model.id != -1)
{
await _databaseComponent.Delete <T_Belt>(ServerIP, t_model.id);
}
}
else if (GearsIsSelected == true)
{
T_Gear t_model = GearClass.ConvertToDB(SelectedGear);
if (t_model.id != -1)
{
await _databaseComponent.Delete <T_Gear>(ServerIP, t_model.id);
}
Gears.Remove(SelectedGear);
}
else if (ImpellersIsSelected == true)
{
T_Impeller t_model = ImpellerClass.ConvertToDB(SelectedImpeller);
if (t_model.id != -1)
{
await _databaseComponent.Delete <T_Impeller>(ServerIP, t_model.id);
}
Impellers.Remove(SelectedImpeller);
}
else if (MotorsIsSelected == true)
{
T_Motor t_model = MotorClass.ConvertToDB(SelectedMotor);
if (t_model.id != -1)
{
await _databaseComponent.Delete <T_Motor>(ServerIP, t_model.id);
}
Motors.Remove(SelectedMotor);
}
}
}
