public static T_Motor ConvertToDB(MotorClass motor)
{
T_Motor t_motor = new T_Motor();
t_motor.id = motor.id;
t_motor.Name = motor.Name;
t_motor.Guid = motor.Guid;
t_motor.LineFrequency = motor.LineFrequency;
t_motor.Poles = motor.Poles;
t_motor.RotorBars = motor.RotorBars;
t_motor.StatorCoils = motor.StatorCoils;
t_motor.WindingSlots = motor.WindingSlots;
t_motor.SCRs = motor.SCRs;
t_motor.MotorType = (int)(motor.MotorType);
return(t_motor);
}
public static MotorClass ConvertFromDB(T_Motor t_motor)
{
MotorClass motor = new MotorClass();
motor.id = t_motor.id;
motor.Name = t_motor.Name;
motor.Guid = t_motor.Guid ?? new Guid();
motor.LineFrequency = t_motor.LineFrequency ?? 0;
motor.Poles = t_motor.Poles ?? 0;
motor.RotorBars = t_motor.RotorBars ?? 0;
motor.StatorCoils = t_motor.StatorCoils ?? 0;
motor.WindingSlots = t_motor.WindingSlots ?? 0;
motor.SCRs = t_motor.SCRs ?? 0;
motor.MotorType = (MotorType)(t_motor.MotorType ?? 0);
return(motor);
}
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);
}
}
}