bool IDeviceDBServiceTest.AddDevice(LoopModel loop)
{
try
{
List <DeviceInfo8036> lstDevices = loop.GetDevices <DeviceInfo8036>();
foreach (var device in lstDevices)
{
device.Loop.ID = loop.ID;
device.LoopID = loop.ID;
//StringBuilder sbDeviceInfoSQL = new StringBuilder("REPLACE INTO DeviceInfo8036");
//sbDeviceInfoSQL.Append("(ID,");
//sbDeviceInfoSQL.Append("Code ,");
//sbDeviceInfoSQL.Append("Disable,");
//sbDeviceInfoSQL.Append("LinkageGroup1,");
//sbDeviceInfoSQL.Append("LinkageGroup2,");
//sbDeviceInfoSQL.Append("AlertValue ,");
//sbDeviceInfoSQL.Append("ForcastValue ,");
//sbDeviceInfoSQL.Append("DelayValue ,");
//sbDeviceInfoSQL.Append("BuildingNo ,");
//sbDeviceInfoSQL.Append("ZoneNo ,");
//sbDeviceInfoSQL.Append("FloorNo ,");
//sbDeviceInfoSQL.Append("RoomNo ,");
//sbDeviceInfoSQL.Append("Location ,");
//sbDeviceInfoSQL.Append("LoopID,");
//sbDeviceInfoSQL.Append("TypeCode");
//sbDeviceInfoSQL.Append(") VALUES(");
//sbDeviceInfoSQL.Append(device.ID + ",'");
//sbDeviceInfoSQL.Append(device.Code + "','");
//sbDeviceInfoSQL.Append(device.Disable + "','");
//sbDeviceInfoSQL.Append(device.LinkageGroup1 + "','");
//sbDeviceInfoSQL.Append(device.LinkageGroup2 + "','");
//sbDeviceInfoSQL.Append(device.AlertValue + "','");
//sbDeviceInfoSQL.Append(device.ForcastValue + "','");
//sbDeviceInfoSQL.Append(device.DelayValue + "','");
//sbDeviceInfoSQL.Append(device.BuildingNo + "','");
//sbDeviceInfoSQL.Append(device.ZoneNo + "','");
//sbDeviceInfoSQL.Append(device.FloorNo + "','");
//sbDeviceInfoSQL.Append(device.RoomNo + "','");
//sbDeviceInfoSQL.Append(device.Location + "','");
//sbDeviceInfoSQL.Append(device.LoopID + "','");
//sbDeviceInfoSQL.Append(device.TypeCode + "');");
//_databaseService.ExecuteBySql(sbDeviceInfoSQL);
_dbFileVersionService.AddDeviceForControllerType8036(device);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
