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