public static void CCHeatInfo_Ini(ref CCHeatInfo lst)
{
lst.report_counter = "-"; lst.task_counter = "-";
lst.heat_id = "-"; lst.CCM = "-"; lst.po_id = "-"; lst.area_id = "-"; lst.station_code = "-"; lst.steel_grade_id = "-"; lst.final_steel_grade_id = "-";
lst.alteration_reason_code = "-"; lst.route_id = "-"; lst.practice_id = "-";
lst.team_id = "-"; lst.shift_code = "-"; lst.shift_responsible = "-";
lst.start_date = "-"; lst.start_wgt = "-"; lst.start_slag_wgt = "-";
lst.stop_date = "-";
lst.final_wgt = "-"; lst.final_slag_wgt = "-";
lst.tapped_wgt = "-"; lst.final_temp = "-";
lst.task_note = "-";
lst.foreman_id = "-"; lst.scheduled_start_date = "-";
lst.hot_heel = "-"; lst.avgel1current = "-"; lst.avgel2current = "-"; lst.avgel3current = "-";
lst.avgactpower = "-"; lst.tap_to_tap = "-"; lst.heat_notes = "-"; lst.l3_heat_id = "-";
lst.profile_model = "-"; lst.eaf_electrode_consumption = "-";
lst.liquidus_temp = "-";
lst.seq_counter = "-"; lst.seq_heat_counter = "-"; lst.seq_total_heats = "-"; lst.seq_sched_heats = "-";
lst.ladle_id = "-"; lst.ladle_life = "-"; lst.ladle_tare_wgt = "-"; lst.ladle_turret_arm_code = "-";
lst.ladle_arrival_date = "-"; lst.ladle_opening_date = "-"; lst.ladle_close_date = "-"; lst.ladle_arrival_wgt = "-";
lst.ladle_opening_wgt = "-"; lst.ladle_close_wgt = "-";
lst.tundish_id = "-"; lst.tundish_life = "-";
lst.tundish_car_code = "-"; lst.tundish_preheat_time = "-"; lst.tundish_preheat_temperature = "-";
lst.tundish_at_ladle_open_wgt = "-"; lst.tundish_skull_wgt = "-"; lst.tundish_powder_type = "-"; lst.tundish_powder_wgt = "-";
}
public static List<CCHeatInfo> GetCCHeatInfo(string HeatID)
{
List<CCHeatInfo> LST = new List<CCHeatInfo>();
CCHeatInfo lst = new CCHeatInfo(); CCHeatInfo_Ini(ref lst);
string str = "";
string strSQL = "SELECT * FROM ccm_heat WHERE heat_id>'" + HeatID + "'";
DataTable dt = GetDataFromOledb(strSQL, lyqstr);
for (int RowIndex = 0; RowIndex < dt.Rows.Count; RowIndex++)
{
lst = new CCHeatInfo(); CCHeatInfo_Ini(ref lst);
lst.heat_id = dt.Rows[RowIndex]["heat_id"].ToString();
lst.CCM = dt.Rows[RowIndex]["ccm"].ToString();
lst.station_code = dt.Rows[RowIndex]["station_code"].ToString();
lst.steel_grade_id = dt.Rows[RowIndex]["steel_grade_id"].ToString();
lst.final_steel_grade_id = dt.Rows[RowIndex]["final_steel_grade_id"].ToString();
lst.alteration_reason_code = dt.Rows[RowIndex]["alteration_reason_code"].ToString();
lst.shift_code = dt.Rows[RowIndex]["shift_code"].ToString();
lst.shift_responsible = dt.Rows[RowIndex]["shift_responsible"].ToString();
lst.team_id = dt.Rows[RowIndex]["team_id"].ToString();
lst.liquidus_temp = dt.Rows[RowIndex]["liquidus_temp"].ToString();
lst.route_id = dt.Rows[RowIndex]["route_id"].ToString();
lst.practice_id = dt.Rows[RowIndex]["practice_id"].ToString();
lst.seq_counter = dt.Rows[RowIndex]["seq_counter"].ToString();
lst.seq_heat_counter = dt.Rows[RowIndex]["seq_heat_counter"].ToString();
lst.seq_total_heats = dt.Rows[RowIndex]["seq_total_heats"].ToString();
lst.ladle_id = dt.Rows[RowIndex]["ladle_id"].ToString();
lst.ladle_life = dt.Rows[RowIndex]["ladle_life"].ToString();
lst.ladle_arrival_date = dt.Rows[RowIndex]["ladle_arrival_date"].ToString();
str = dt.Rows[RowIndex]["ladle_arrival_wgt"].ToString(); lst.ladle_arrival_wgt = str.Split(new char[] { '.' })[0];
str = dt.Rows[RowIndex]["ladle_tare_wgt"].ToString(); lst.ladle_tare_wgt = str.Split(new char[] { '.' })[0];
lst.ladle_opening_date = Convert.ToDateTime(dt.Rows[RowIndex]["ladle_opening_date"]).ToString("yyyy/MM/dd HH:mm:ss");
str = dt.Rows[RowIndex]["ladle_opening_wgt"].ToString(); lst.ladle_opening_wgt = str.Split(new char[] { '.' })[0];
lst.ladle_close_date = dt.Rows[RowIndex]["ladle_close_date"].ToString();
str = dt.Rows[RowIndex]["ladle_close_wgt"].ToString(); lst.ladle_close_wgt = str.Split(new char[] { '.' })[0];
lst.start_date = dt.Rows[RowIndex]["start_date"].ToString();
str = dt.Rows[RowIndex]["start_wgt"].ToString(); lst.start_wgt = str;//lst.start_wgt= Convert.ToInt32 (str).ToString();
lst.stop_date = dt.Rows[RowIndex]["stop_date"].ToString();
str = dt.Rows[RowIndex]["tapped_wgt"].ToString(); lst.tapped_wgt = str;//lst.tapped_wgt = Convert.ToInt32(str).ToString();
lst.task_counter = dt.Rows[RowIndex]["task_counter"].ToString();
str = dt.Rows[RowIndex]["tundish_at_ladle_open_wgt"].ToString(); lst.tundish_at_ladle_open_wgt = str.Split(new char[] { '.' })[0];
lst.tundish_car_code = dt.Rows[RowIndex]["tundish_car_code"].ToString();
lst.tundish_life = dt.Rows[RowIndex]["tundish_life"].ToString();
str = dt.Rows[RowIndex]["tundish_id"].ToString(); lst.tundish_id = str;
str = dt.Rows[RowIndex]["tundish_preheat_time"].ToString(); lst.tundish_preheat_time = str;
str = dt.Rows[RowIndex]["tundish_preheat_temperature"].ToString(); lst.tundish_preheat_temperature = str;
str = dt.Rows[RowIndex]["tundish_skull_wgt"].ToString(); lst.tundish_skull_wgt = str.Split(new char[] { '.' })[0];
str = dt.Rows[RowIndex]["tundish_powder_type"].ToString(); lst.tundish_powder_type = str;
str = dt.Rows[RowIndex]["tundish_powder_wgt"].ToString(); lst.tundish_powder_wgt = str.Split(new char[] { '.' })[0];
LST.Add(lst);
}
dt.Dispose();
return LST;
}
