public bool CheckExists(DeviceConnection objDeviceConnection) { string sql = null; List<DbParameter> parameterList = new List<DbParameter>(); sql = " select count(1) from tbl_device_connection where DeviceNumber=:DeviceNumber "; parameterList.Add(new OracleParameter(":DeviceNumber", objDeviceConnection.DeviceNumber)); return int.Parse(DbHelper.ExecuteScalar(sql, CommandType.Text, parameterList.ToArray()).ToString()) > 0; }
public void Save(DeviceConnection objDeviceConnection) { string sql = null; List<DbParameter> parameterList = new List<DbParameter>(); if (objDeviceConnection.PkId == 0) { sql = " insert into tbl_device_connection(PkId, DeviceNumber, DeviceIp, OrgId, CollectorName, CollectorIp, ConnectTime, DisconnectTime, ConnectionStatus, UploadCount) " + " values(TDC_PKID.NEXTVAL, :DeviceNumber, :DeviceIp, :OrgId, :CollectorName, :CollectorIp, :ConnectTime, :DisconnectTime, :ConnectionStatus, :UploadCount) "; parameterList.Add(new OracleParameter(":DeviceNumber", objDeviceConnection.DeviceNumber)); parameterList.Add(new OracleParameter(":DeviceIp", objDeviceConnection.DeviceIp)); parameterList.Add(new OracleParameter(":OrgId", objDeviceConnection.OrgId)); parameterList.Add(new OracleParameter(":CollectorName", objDeviceConnection.CollectorName)); parameterList.Add(new OracleParameter(":CollectorIp", objDeviceConnection.CollectorIp)); parameterList.Add(new OracleParameter(":ConnectTime", objDeviceConnection.ConnectTime)); parameterList.Add(new OracleParameter(":DisconnectTime", objDeviceConnection.DisconnectTime)); parameterList.Add(new OracleParameter(":ConnectionStatus", objDeviceConnection.ConnectionStatus)); parameterList.Add(new OracleParameter(":UploadCount", objDeviceConnection.UploadCount)); } else { sql = " update tbl_device_connection set DeviceIp=:DeviceIp, OrgId=:OrgId, CollectorName=:CollectorName, CollectorIp=:CollectorIp, " + " ConnectTime=:ConnectTime, DisconnectTime=:DisconnectTime, ConnectionStatus=:ConnectionStatus, UploadCount=:UploadCount " + " where DeviceNumber=:DeviceNumber "; parameterList.Add(new OracleParameter(":DeviceIp", objDeviceConnection.DeviceIp)); parameterList.Add(new OracleParameter(":OrgId", objDeviceConnection.OrgId)); parameterList.Add(new OracleParameter(":CollectorName", objDeviceConnection.CollectorName)); parameterList.Add(new OracleParameter(":CollectorIp", objDeviceConnection.CollectorIp)); parameterList.Add(new OracleParameter(":ConnectTime", objDeviceConnection.ConnectTime)); parameterList.Add(new OracleParameter(":DisconnectTime", objDeviceConnection.DisconnectTime)); parameterList.Add(new OracleParameter(":ConnectionStatus", objDeviceConnection.ConnectionStatus)); parameterList.Add(new OracleParameter(":UploadCount", objDeviceConnection.UploadCount)); parameterList.Add(new OracleParameter(":DeviceNumber", objDeviceConnection.DeviceNumber)); } DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray()); }
public static void UpdateDeviceState(DeviceInfo deviceinfo, Device device, bool disconnected) { if (device.Updated && !disconnected) { return; } try { if (string.IsNullOrEmpty(device.Number)) { return; } var service = ServiceFactory.GetService<IDeviceService>(); if (deviceinfo != null && deviceinfo.PkId == 0) { deviceinfo.RegisterIp = device.RemoteIP; service.Save_Info(deviceinfo); } var item = service.GetObjectByDeviceNumber_Connection(device.Number); if (item == null) { item = new DeviceConnection(); } item.CollectorName = CurrencyStore.Common.Configration.CurrencyStoreSection.Instance.Name; item.ConnectTime = device.ConnectionDate; item.DisconnectTime = device.DisconnectionDate; item.UploadCount = device.Counter; item.DeviceIp = device.RemoteIP; item.DeviceNumber = device.Number; item.CollectorIp = device.LocalIP; item.ConnectionStatus = (byte)(device.Connected ? 1 : 2); service.Save_Connection(item); device.Updated = true; } catch (Exception ex) { logger.Error("更新连接状态错误.", ex); } }
public void Save(DeviceConnection objDeviceConnection) { string sql = null; List<DbParameter> parameterList = new List<DbParameter>(); if (objDeviceConnection.PkId == 0) { sql = " insert into tbl_device_connection(DeviceNumber, DeviceIp, OrgId, CollectorName, CollectorIp, ConnectTime, DisconnectTime, ConnectionStatus, UploadCount) " + " values(@DeviceNumber, @DeviceIp, @OrgId, @CollectorName, @CollectorIp, @ConnectTime, @DisconnectTime, @ConnectionStatus, @UploadCount) "; parameterList.Add(new MySqlParameter("@DeviceNumber", objDeviceConnection.DeviceNumber)); parameterList.Add(new MySqlParameter("@DeviceIp", objDeviceConnection.DeviceIp)); parameterList.Add(new MySqlParameter("@OrgId", objDeviceConnection.OrgId)); parameterList.Add(new MySqlParameter("@CollectorName", objDeviceConnection.CollectorName)); parameterList.Add(new MySqlParameter("@CollectorIp", objDeviceConnection.CollectorIp)); parameterList.Add(new MySqlParameter("@ConnectTime", objDeviceConnection.ConnectTime)); parameterList.Add(new MySqlParameter("@DisconnectTime", objDeviceConnection.DisconnectTime)); parameterList.Add(new MySqlParameter("@ConnectionStatus", objDeviceConnection.ConnectionStatus)); parameterList.Add(new MySqlParameter("@UploadCount", objDeviceConnection.UploadCount)); } else { sql = " update tbl_device_connection set DeviceIp=@DeviceIp, OrgId=@OrgId, CollectorName=@CollectorName, CollectorIp=@CollectorIp, " + " ConnectTime=@ConnectTime, DisconnectTime=@DisconnectTime, ConnectionStatus=@ConnectionStatus, UploadCount=@UploadCount " + " where DeviceNumber=@DeviceNumber "; parameterList.Add(new MySqlParameter("@DeviceNumber", objDeviceConnection.DeviceNumber)); parameterList.Add(new MySqlParameter("@DeviceIp", objDeviceConnection.DeviceIp)); parameterList.Add(new MySqlParameter("@OrgId", objDeviceConnection.OrgId)); parameterList.Add(new MySqlParameter("@CollectorName", objDeviceConnection.CollectorName)); parameterList.Add(new MySqlParameter("@CollectorIp", objDeviceConnection.CollectorIp)); parameterList.Add(new MySqlParameter("@ConnectTime", objDeviceConnection.ConnectTime)); parameterList.Add(new MySqlParameter("@DisconnectTime", objDeviceConnection.DisconnectTime)); parameterList.Add(new MySqlParameter("@ConnectionStatus", objDeviceConnection.ConnectionStatus)); parameterList.Add(new MySqlParameter("@UploadCount", objDeviceConnection.UploadCount)); } DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray()); }
public bool CheckExists_Connection(DeviceConnection objDeviceConnection) { var repository = ServiceFactory.GetService<IDeviceConnectionRepository>(); return repository.CheckExists(objDeviceConnection); }
public void Save_Info(DeviceInfo objDeviceInfo) { var deviceInfoRepository = ServiceFactory.GetService<IDeviceInfoRepository>(); var deviceConnectionRepository = ServiceFactory.GetService<IDeviceConnectionRepository>(); if (objDeviceInfo.PkId == 0) { DeviceInfo diTemp = deviceInfoRepository.GetObjectByDeviceNumber(objDeviceInfo.DeviceNumber); if (diTemp != null) { objDeviceInfo.PkId = diTemp.PkId; } } deviceInfoRepository.Save(objDeviceInfo); var objDeviceConnection = deviceConnectionRepository.GetObjectByDeviceNumber(objDeviceInfo.DeviceNumber); if (objDeviceConnection == null) { objDeviceConnection = new DeviceConnection() { DeviceNumber = objDeviceInfo.DeviceNumber, DeviceIp = objDeviceInfo.RegisterIp, OrgId = objDeviceInfo.OrgId, CollectorName = String.Empty, CollectorIp = String.Empty, ConnectTime = DateTime.MinValue, DisconnectTime = DateTime.MinValue, ConnectionStatus = (int)DeviceConnection.ConnectionStatusEnum.Disconnect, UploadCount = 0 }; } else { objDeviceConnection.OrgId = objDeviceInfo.OrgId; } deviceConnectionRepository.Save(objDeviceConnection); DeviceCache.Current.Set(objDeviceInfo); }
public void Save_Connection(DeviceConnection objDeviceConnection) { var repository = ServiceFactory.GetService<IDeviceConnectionRepository>(); repository.Save(objDeviceConnection); }