internal static Station GetByCode(int code) { const string strSql = "SELECT Id, Code, Name, StationTypeId, OpcStatusDataChangeAddress, OpcPalletCodeAddress, OpcOperationCodeAddress, OpcMoldCodeAddress, OpcAlarmCodeAddress, OpcResultCodeAddress FROM Stations WHERE Code = @Code"; var station = new Station(); try { using (var connection = SqlServer.OpenConnection()) { using (var command = new SqlCommand(strSql, connection)) { command.Parameters.AddWithValue("@Code", code); using (var reader = command.ExecuteReader()) { while (reader.Read()) { station.Id = Convert.ToInt32(reader["Id"]); station.Code = Convert.ToInt32(reader["Code"]); station.Name = reader["Name"].ToString(); station.StatusDataChangeAddress = reader["OpcStatusDataChangeAddress"].ToString(); station.Type = StationTypeRepository.GetById(Convert.ToInt32(reader["StationTypeId"])); } } } } } catch (Exception ex) { } return(station); }
internal static List <Station> GetAll() { const string strSql = "SELECT Id, Code, Name, StationTypeId, StatusDataChangeAddress, StatusDataChangeAddressAck, DataAddress FROM Stations"; var stations = new List <Station>(); try { using (var connection = SqlServer.OpenConnection()) { using (var command = new SqlCommand(strSql, connection)) { using (var reader = command.ExecuteReader()) { while (reader.Read()) { stations.Add(new Station() { Id = Convert.ToInt32(reader["Id"]), Code = Convert.ToInt32(reader["Code"]), Name = reader["Name"].ToString(), Type = StationTypeRepository.GetById(Convert.ToInt32(reader["StationTypeId"])), StatusDataChangeAddress = reader["StatusDataChangeAddress"].ToString(), StatusDataChangeAddressAck = reader["StatusDataChangeAddressAck"].ToString(), DataAddress = reader["DataAddress"].ToString() }); } } } } } catch (Exception ex) { // ReSharper disable once PossibleIntendedRethrow throw ex; } return(stations); }
internal static Station GetById(int id) { const string strSql = "SELECT Id, Code, Name, StationTypeId, StatusDataChangeAddress, StatusDataChangeAddressAck, DataAddress FROM Stations WHERE Id = @Id"; var station = new Station(); try { using (var connection = SqlServer.OpenConnection()) { using (var command = new SqlCommand(strSql, connection)) { command.Parameters.AddWithValue("@Id", id); using (var reader = command.ExecuteReader()) { while (reader.Read()) { station.Id = Convert.ToInt32(reader["Id"]); station.Code = Convert.ToInt32(reader["Code"]); station.Name = reader["Name"].ToString(); station.Type = StationTypeRepository.GetById(Convert.ToInt32(reader["StationTypeId"])); station.StatusDataChangeAddress = reader["StatusDataChangeAddress"].ToString(); station.StatusDataChangeAddressAck = reader["StatusDataChangeAddressAck"].ToString(); station.DataAddress = reader["DataAddress"].ToString(); } } } } } catch (Exception ex) { throw ex; } return(station); }