public HeatAttributes() { Number = -1; // Плавка не началась Planned = new SteelAttributes(); Actual = new SteelAttributes(); HotMetalAttributes = new HotMetalAttributes(); HotMetalAnalysyses = new List<HotMetalAnalysys>(); Additions = new List<Addition>(); ScrapBuckets = new List<ScrapBucket>(); SlagAnalysys = new List<SlagAnalysys>(); SteelAnalysys = new List<SteelAnalysys>(); Sublances = new List<Sublance>(); }
public HotMetalAttributes GetHotMetalAttributes(int heatID) { var sql = "SELECT HML.HM_TEMP, HML.HM_WEIGHT "; sql += "FROM SMK.HEATS H, SMK.HEAT_HOTMETAL HHM, SMK.HOTMETAL_LADLES HML "; sql += "WHERE HHM.HEAT_ID = H.HEAT_ID AND HML.CHGL_ID = HHM.CHGL_ID AND H.HEAT_ID = :HeatID "; var reader = Execute(sql, new[] { new OracleParameter { OracleDbType = OracleDbType.Int32, ParameterName = "HeatID", Direction= System.Data.ParameterDirection.Input, Value = heatID } }); var hotMetal = new HotMetalAttributes(); if (reader.Read()) { hotMetal.Temperature = int.Parse(CheckNubmerForNull(reader[0].ToString())); hotMetal.Weight = int.Parse(CheckNubmerForNull(reader[1].ToString())); } reader.Close(); return hotMetal; }