public static T_Bearing ConvertToDB(BearingClass bear)
{
T_Bearing t_bear = new T_Bearing();
t_bear.id = bear.id;
t_bear.Name = bear.Name;
t_bear.Guid = bear.Guid;
t_bear.Designation = bear.Designation;
t_bear.PitchDiameter = bear.PitchDiameter;
t_bear.RollerDiameter = bear.RollerDiameter;
t_bear.ContactAngle = bear.ContactAngle;
t_bear.NumberOfRoller = bear.NumberOfRoller;
t_bear.OuterRingDiameter = bear.OuterRingDiameter;
t_bear.InnerRingDiameter = bear.InnerRingDiameter;
t_bear.NumberOfColumns = bear.NumberOfColumns;
t_bear.InnerRingFrequency = bear.InnerRingFrequency;
t_bear.OuterRingFrequency = bear.OuterRingFrequency;
t_bear.MaintainsFrequency = bear.MaintainsFrequency;
t_bear.RollerFrequency = bear.RollerFrequency;
t_bear.BearingSeries = bear.BearingSeries;
t_bear.BearingSeriesID = bear.BearingSeriesID;
t_bear.RPM = bear.RPM;
return(t_bear);
}
public static BearingClass ConvertFromDB(T_Bearing t_bear)
{
BearingClass bear = new BearingClass();
bear.id = t_bear.id;
bear.Name = t_bear.Name;
bear.Guid = t_bear.Guid ?? new Guid();
bear.Designation = t_bear.Designation;
bear.PitchDiameter = t_bear.PitchDiameter ?? 0;
bear.RollerDiameter = t_bear.RollerDiameter ?? 0;
bear.ContactAngle = t_bear.ContactAngle ?? 0;
bear.NumberOfRoller = t_bear.NumberOfRoller ?? 0;
bear.OuterRingDiameter = t_bear.OuterRingDiameter ?? 0;
bear.InnerRingDiameter = t_bear.InnerRingDiameter ?? 0;
bear.NumberOfColumns = t_bear.NumberOfColumns ?? 0;
bear.InnerRingFrequency = t_bear.InnerRingFrequency ?? 0;
bear.OuterRingFrequency = t_bear.OuterRingFrequency ?? 0;
bear.RollerFrequency = t_bear.RollerFrequency ?? 0;
bear.MaintainsFrequency = t_bear.MaintainsFrequency ?? 0;
bear.BearingSeries = t_bear.BearingSeries;
bear.BearingSeriesID = t_bear.BearingSeriesID ?? 0;
bear.RPM = t_bear.RPM ?? 0;
return(bear);
}
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);
}
}
}
