public int DeleteCheckpoint(DeviceCheckpointSource deviceCheckpointSource)
{
var dataCommandObject = DataCommandObjectManager.Instance.GetDataCommandObject("CheckpointInfo_DeleteCheckpoint");
dataCommandObject.SetParameterValue("@Id", deviceCheckpointSource.Id);
dataCommandObject.ExecuteNonQuery();
return((int)dataCommandObject.GetParameterValue("@RetVal"));
}
public int EditCheckpoint(DeviceCheckpointSource deviceCheckpointSource)
{
var dataCommandObject = DataCommandObjectManager.Instance.GetDataCommandObject("CheckpointInfo_EditCheckpoint");
dataCommandObject.SetParameterValue("@Id", deviceCheckpointSource.Id);
dataCommandObject.SetParameterValue("@Description", deviceCheckpointSource.Description);
dataCommandObject.SetParameterValue("@Remark", deviceCheckpointSource.Remark);
dataCommandObject.ExecuteNonQuery();
return((int)dataCommandObject.GetParameterValue("@RetVal"));
}
public int AddCheckpoint(DeviceCheckpointSource deviceCheckpointSource)
{
var dataCommandObject = DataCommandObjectManager.Instance.GetDataCommandObject("CheckpointInfo_AddCheckpoint");
dataCommandObject.SetParameterValue("@DeviceNumber", deviceCheckpointSource.DeviceInfo.DeviceNumber);
dataCommandObject.SetParameterValue("@Description", deviceCheckpointSource.Description);
dataCommandObject.SetParameterValue("@Flag", deviceCheckpointSource.Flag);
dataCommandObject.SetParameterValue("@UpperLimit", deviceCheckpointSource.UpperLimit);
dataCommandObject.SetParameterValue("@LowerLimit", deviceCheckpointSource.LowerLimit);
dataCommandObject.SetParameterValue("@Remark", deviceCheckpointSource.Remark);
dataCommandObject.ExecuteNonQuery();
return((int)dataCommandObject.GetParameterValue("@RetVal"));
}
public static DeviceCheckpointSource[] BuildDeviceCheckpointSources(DeviceCheckpoint[] deviceCheckpoints)
{
if (deviceCheckpoints == null)
{
return(null);
}
var deviceCheckpointSources = new DeviceCheckpointSource[0];
foreach (var deviceCheckpoint in deviceCheckpoints)
{
deviceCheckpointSources = deviceCheckpointSources.Append(BuildDeviceCheckpointSource(deviceCheckpoint));
}
return(deviceCheckpointSources);
}
public static DeviceCheckpointSource BuildDeviceCheckpointSource(DeviceCheckpoint deviceCheckpoint)
{
if (deviceCheckpoint == null)
{
return(null);
}
var deviceCheckpointSource = new DeviceCheckpointSource();
deviceCheckpointSource.Description = deviceCheckpoint.Description;
deviceCheckpointSource.DeviceInfo = DeviceInfoTransfer.BuildDeviceInfoSource(deviceCheckpoint.DeviceInfo);
deviceCheckpointSource.Flag = typeof(DeviceCheckpointFlag).GetValueByEnum(deviceCheckpoint.Flag);
deviceCheckpointSource.Id = deviceCheckpoint.Id;
deviceCheckpointSource.LowerLimit = deviceCheckpoint.LowerLimit;
deviceCheckpointSource.Remark = deviceCheckpoint.Remark;
deviceCheckpointSource.UpperLimit = deviceCheckpoint.UpperLimit;
return(deviceCheckpointSource);
}
public static DeviceCheckpoint BuildDeviceCheckpoint(DeviceCheckpointSource deviceCheckpointSource)
{
if (deviceCheckpointSource == null)
{
return(null);
}
var deviceCheckpoint = new DeviceCheckpoint();
deviceCheckpoint.CreationDate = Utility.ConvertDateTime(deviceCheckpointSource.CreationDate);
deviceCheckpoint.Description = deviceCheckpointSource.Description;
deviceCheckpoint.DeviceInfo = DeviceInfoTransfer.BuildDeviceInfo(deviceCheckpointSource.DeviceInfo);
deviceCheckpoint.Flag = (DeviceCheckpointFlag)typeof(DeviceCheckpointFlag).GetEnumByValue(deviceCheckpointSource.Flag);
deviceCheckpoint.Id = deviceCheckpointSource.Id;
deviceCheckpoint.LowerLimit = deviceCheckpointSource.LowerLimit;
deviceCheckpoint.Remark = deviceCheckpointSource.Remark;
deviceCheckpoint.UpperLimit = deviceCheckpointSource.UpperLimit;
deviceCheckpoint.ModifiedDate = Utility.ConvertDateTime(deviceCheckpointSource.ModifiedDate);
return(deviceCheckpoint);
}
