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); }