public static void BOFHeatInfo_Ini(ref BOFHeatInfo lst)
{
lst.heat_id = " "; lst.treatpos = " "; lst.plan_no = " "; lst.pono = " "; lst.steel_grade = " ";
lst.promodecode = " "; lst.bof_campaign = " "; lst.bof_life = " "; lst.tappinghole = " "; lst.tap_hole_campaign = " ";
lst.tap_hole_life = " "; lst.mainlance_id = " "; lst.mainlance_life = " "; lst.sublance_id = " "; lst.sublance_life = " ";
lst.bath_level = " "; lst.steelladleid = " "; lst.slag_cal_weight = " "; lst.slag_net_weight = " "; lst.weight_cal = " ";
lst.weight_act = " "; lst.weighting_time = " "; lst.tem_act = " "; lst.tem_time = " ";
lst.bofc_act = " "; lst.o2ppm_act = " "; lst.ladleid = " "; lst.hmw_act = " ";
lst.hm_tem = " "; lst.hm_c = " "; lst.hm_si = " "; lst.hm_mn = " "; lst.hm_p = " ";
lst.hm_s = " "; lst.bucketid = " "; lst.scrw_act = " "; lst.pi_act = " "; lst.return_act = " ";
lst.metal_act = " "; lst.cao_weight = " "; lst.dolo_weight = " "; lst.rdolo_weight = " ";
lst.mgo_weight = " "; lst.caf2_weight = " "; lst.iron_weight = " "; lst.o2_act = " "; lst.ar_act = " ";
lst.n2_act = " "; lst.tsc_tem = " "; lst.tsc_c = " "; lst.tsc_duration = " ";
lst.tso_tem = " "; lst.tso_c = " "; lst.tso_o2ppm = " "; lst.tso_duration = " ";
lst.o2_duration = " "; lst.ar_duration = " "; lst.n2_duration = " "; lst.after_stiring_duration = " ";
lst.reblow_num = " "; lst.reblow1_tem = " "; lst.reblow2_tem = " "; lst.deslag_num = " ";
lst.slag_splash_n2 = " "; lst.ready_time = " "; lst.charging_starttime = " "; lst.hm_time = " ";
lst.scrap_time = " "; lst.charging_endtime = " "; lst.blow_starttime = " "; lst.blow_endtime = " ";
lst.reblow1_starttime = " "; lst.reblow1_endtime = " "; lst.reblow1_duration = " "; lst.reblow2_starttime = " ";
lst.reblow2_endtime = " "; lst.reblow2_duration = " "; lst.slag_nr = " "; lst.tapping_starttime = " ";
lst.tapping_endtime = " "; lst.tapping_duration = " "; lst.slag_starttime = " "; lst.slag_endtime = " ";
lst.slag_duration = " "; lst.product_day = " "; lst.shift_id = " "; lst.crew_id = " ";
lst.operator_c = " "; lst.checkdate = " "; lst.checkoperator = " "; lst.checkflag = " "; lst.ge_no = " ";
lst.tsc_starttime = " "; lst.tsc_endtime = " "; lst.tso_starttime = " "; lst.tso_endtime = " ";
lst.splash_starttime = " "; lst.splash_endtime = " "; lst.splash_duration = " ";
lst.o2_press = " "; lst.o2_flux = " "; lst.n2_press = " "; lst.n2_flux = " "; lst.sheetiron_wgt = " ";
lst.restrin_wgt = " "; lst.alloycao_wgt = " "; lst.cadd_wgt = " "; lst.fesi_wgt = " "; lst.al_wgt = " ";
lst.mnsi_wgt = " "; lst.femn_wgt = " "; lst.fenb_wgt = " "; lst.hscrw_wgt = " "; lst.lscrw_wgt = " ";
lst.sscrw_wgt = " "; lst.mfemn_wgt = " "; lst.lfemn_wgt = " "; lst.duststeam_vol = " ";
lst.dustwater_vol = " "; lst.recyclesteam_vol = " "; lst.outsteam_vol = " "; lst.mainlance_id1 = " ";
lst.mainlance_life1 = " "; lst.ladlear_act = " "; lst.ironid = " "; lst.rdolo_wgt = " ";
lst.change_wgt = " "; lst.burnslag_wgt = " "; lst.lfslag_wgt = " "; lst.sicabei_wgt = " ";
lst.sialfe_wgt = " "; lst.mn_wgt = " ";
lst.IRON_LADLE_ID = " "; lst.IRON_ID = " "; lst.HM_WEIGHT = " "; lst.HM_TRPMTURE = " ";
lst.HM_TIME = " "; lst.HM_SOUREC = " ";
lst.SCRAP_BUCKET_ID = " "; lst.SCRAP_ID = " "; lst.SCRAP_WEIGHT = " "; lst.HSCRW_WEIGHT = " ";
lst.LSCRW_WEIGHT = " "; lst.SSCRW_WEIGHT = " ";
}
public static List<BOFHeatInfo> GetBOFHeatInfo(string HeatID)
{
List<BOFHeatInfo> LST = new List<BOFHeatInfo>();
BOFHeatInfo lst = new BOFHeatInfo(); BOFHeatInfo_Ini(ref lst);
object obj = new object();
string str = "";
string strSQL = "SELECT * FROM bof_heat WHERE heat_id>'" + HeatID + "'";
DataTable dt = GetDataFromOledb(strSQL, lyqstr);
for (int RowIndex = 0; RowIndex < dt.Rows.Count; RowIndex++)
{
lst = new BOFHeatInfo(); BOFHeatInfo_Ini(ref lst);
obj = dt.Rows[RowIndex]["heat_id"]; if (obj.ToString().Length > 0) lst.heat_id = obj.ToString();
obj = dt.Rows[RowIndex]["station"]; if (obj.ToString().Length > 0) lst.treatpos = obj.ToString();
obj = dt.Rows[RowIndex]["plan_no"]; if (obj.ToString().Length > 0) lst.plan_no = obj.ToString();
obj = dt.Rows[RowIndex]["pono"]; if (obj.ToString().Length > 0) lst.pono = obj.ToString();
obj = dt.Rows[RowIndex]["steel_grade"]; if (obj.ToString().Length > 0) lst.steel_grade = obj.ToString();
obj = dt.Rows[RowIndex]["promodecode"]; if (obj.ToString().Length > 0) lst.promodecode = obj.ToString();
obj = dt.Rows[RowIndex]["bof_campaign"]; if (obj.ToString().Length > 0) lst.bof_campaign = obj.ToString();
obj = dt.Rows[RowIndex]["bof_life"]; if (obj.ToString().Length > 0) lst.bof_life = obj.ToString();
obj = dt.Rows[RowIndex]["tappinghole"]; if (obj.ToString().Length > 0) lst.tappinghole = obj.ToString();
obj = dt.Rows[RowIndex]["tap_hole_campaign"]; if (obj.ToString().Length > 0) lst.tap_hole_campaign = obj.ToString();
obj = dt.Rows[RowIndex]["tap_hole_life"]; if (obj.ToString().Length > 0) lst.tap_hole_life = obj.ToString();
obj = dt.Rows[RowIndex]["mainlance_id"]; if (obj.ToString().Length > 0) lst.mainlance_id = obj.ToString();
obj = dt.Rows[RowIndex]["mainlance_life"]; if (obj.ToString().Length > 0) lst.mainlance_life = obj.ToString();
obj = dt.Rows[RowIndex]["sublance_id"]; if (obj.ToString().Length > 0) lst.sublance_id = obj.ToString();
obj = dt.Rows[RowIndex]["sublance_life"]; if (obj.ToString().Length > 0) lst.sublance_life = obj.ToString();
obj = dt.Rows[RowIndex]["bath_level"]; if (obj.ToString().Length > 0) lst.bath_level = obj.ToString();
obj = dt.Rows[RowIndex]["STEEL_LADLE_ID"]; if (obj.ToString().Length > 0) lst.steelladleid = obj.ToString();
obj = dt.Rows[RowIndex]["slag_net_weight"]; if (obj.ToString().Length > 0) lst.slag_net_weight = obj.ToString();
obj = dt.Rows[RowIndex]["weight_act"]; if (obj.ToString().Length > 0) lst.weight_act = obj.ToString();
obj = dt.Rows[RowIndex]["weighting_time"]; if (obj.ToString().Length > 0) lst.weighting_time = obj.ToString();
//obj=dt.Rows[RowIndex]["metal_act"];if (obj.ToString().Length>0) lst.metal_act=obj.ToString();
obj = dt.Rows[RowIndex]["cao_weight"]; if (obj.ToString().Length > 0) lst.cao_weight = obj.ToString();
obj = dt.Rows[RowIndex]["dolo_weight"]; if (obj.ToString().Length > 0) lst.dolo_weight = obj.ToString();
obj = dt.Rows[RowIndex]["rdolo_weight"]; if (obj.ToString().Length > 0) lst.o2_act = obj.ToString();
obj = dt.Rows[RowIndex]["mgo_weight"]; if (obj.ToString().Length > 0) lst.mgo_weight = obj.ToString();
obj = dt.Rows[RowIndex]["caf2_weight"]; if (obj.ToString().Length > 0) lst.caf2_weight = obj.ToString();
obj = dt.Rows[RowIndex]["iron_weight"]; if (obj.ToString().Length > 0) lst.iron_weight = obj.ToString();
obj = dt.Rows[RowIndex]["O2_ConSUM_VOlume"]; if (obj.ToString().Length > 0) lst.o2_act = obj.ToString();
obj = dt.Rows[RowIndex]["ar_act"]; if (obj.ToString().Length > 0) lst.ar_act = obj.ToString();
obj = dt.Rows[RowIndex]["n2_act"]; if (obj.ToString().Length > 0) lst.n2_act = obj.ToString();
obj = dt.Rows[RowIndex]["tsc_tem"]; if (obj.ToString().Length > 0) lst.tsc_tem = obj.ToString();
obj = dt.Rows[RowIndex]["tsc_c"]; if (obj.ToString().Length > 0) lst.tsc_c = obj.ToString();
obj = dt.Rows[RowIndex]["tso_tem"]; if (obj.ToString().Length > 0) lst.tso_tem = obj.ToString();
obj = dt.Rows[RowIndex]["tso_c"]; if (obj.ToString().Length > 0) lst.tso_c = obj.ToString();
obj = dt.Rows[RowIndex]["tso_o2ppm"]; if (obj.ToString().Length > 0) lst.tso_o2ppm = obj.ToString();
obj = dt.Rows[RowIndex]["o2_duration"]; if (obj.ToString().Length > 0) lst.o2_duration = obj.ToString();
obj = dt.Rows[RowIndex]["ar_duration"]; if (obj.ToString().Length > 0) lst.ar_duration = obj.ToString();
obj = dt.Rows[RowIndex]["n2_duration"]; if (obj.ToString().Length > 0) lst.n2_duration = obj.ToString();
obj = dt.Rows[RowIndex]["after_stiring_duration"]; if (obj.ToString().Length > 0) lst.after_stiring_duration = obj.ToString();
obj = dt.Rows[RowIndex]["reblow_num"]; if (obj.ToString().Length > 0) lst.reblow_num = obj.ToString();
obj = dt.Rows[RowIndex]["reblow1_tem"]; if (obj.ToString().Length > 0) lst.reblow1_tem = obj.ToString();
obj = dt.Rows[RowIndex]["reblow2_tem"]; if (obj.ToString().Length > 0) lst.reblow2_tem = obj.ToString();
obj = dt.Rows[RowIndex]["deslag_num"]; if (obj.ToString().Length > 0) lst.deslag_num = obj.ToString();
obj = dt.Rows[RowIndex]["slag_splash_n2"]; if (obj.ToString().Length > 0) lst.slag_splash_n2 = obj.ToString();
obj = dt.Rows[RowIndex]["ready_time"]; if (obj.ToString().Length > 0) lst.ready_time = obj.ToString();
obj = dt.Rows[RowIndex]["charging_starttime"]; if (obj.ToString().Length > 0) lst.charging_starttime = obj.ToString();
obj = dt.Rows[RowIndex]["charging_endtime"]; if (obj.ToString().Length > 0) lst.charging_endtime = obj.ToString();
obj = dt.Rows[RowIndex]["blow_starttime"]; if (obj.ToString().Length > 0) lst.blow_starttime = obj.ToString();
obj = dt.Rows[RowIndex]["blow_endtime"]; if (obj.ToString().Length > 0) lst.blow_endtime = obj.ToString();
obj = dt.Rows[RowIndex]["reblow1_starttime"]; if (obj.ToString().Length > 0) lst.reblow1_starttime = obj.ToString();
obj = dt.Rows[RowIndex]["reblow1_endtime"]; if (obj.ToString().Length > 0) lst.reblow1_endtime = obj.ToString();
obj = dt.Rows[RowIndex]["reblow1_duration"]; if (obj.ToString().Length > 0) lst.reblow1_duration = obj.ToString();
obj = dt.Rows[RowIndex]["reblow2_starttime"]; if (obj.ToString().Length > 0) lst.reblow2_starttime = obj.ToString();
obj = dt.Rows[RowIndex]["reblow2_endtime"]; if (obj.ToString().Length > 0) lst.reblow2_endtime = obj.ToString();
obj = dt.Rows[RowIndex]["reblow2_duration"]; if (obj.ToString().Length > 0) lst.reblow2_duration = obj.ToString();
obj = dt.Rows[RowIndex]["slag_nr"]; if (obj.ToString().Length > 0) lst.slag_nr = obj.ToString();
obj = dt.Rows[RowIndex]["tapping_starttime"]; if (obj.ToString().Length > 0) lst.tapping_starttime = obj.ToString();
obj = dt.Rows[RowIndex]["tapping_endtime"]; if (obj.ToString().Length > 0) lst.tapping_endtime = obj.ToString();
obj = dt.Rows[RowIndex]["tapping_duration"]; if (obj.ToString().Length > 0) lst.tapping_duration = obj.ToString();
obj = dt.Rows[RowIndex]["slag_starttime"]; if (obj.ToString().Length > 0) lst.slag_starttime = obj.ToString();
obj = dt.Rows[RowIndex]["slag_endtime"]; if (obj.ToString().Length > 0) lst.slag_endtime = obj.ToString();
obj = dt.Rows[RowIndex]["slag_duration"]; if (obj.ToString().Length > 0) lst.slag_duration = obj.ToString();
obj = dt.Rows[RowIndex]["product_day"]; if (obj.ToString().Length > 0) lst.product_day = obj.ToString();
obj = dt.Rows[RowIndex]["shift_id"]; if (obj.ToString().Length > 0) lst.shift_id = obj.ToString();
obj = dt.Rows[RowIndex]["crew_id"]; if (obj.ToString().Length > 0) lst.crew_id = obj.ToString();
obj = dt.Rows[RowIndex]["ge_no"]; if (obj.ToString().Length > 0) lst.ge_no = obj.ToString();
obj = dt.Rows[RowIndex]["tsc_starttime"]; if (obj.ToString().Length > 0) lst.tsc_starttime = obj.ToString();
obj = dt.Rows[RowIndex]["tsc_endtime"]; if (obj.ToString().Length > 0) lst.tsc_endtime = obj.ToString();
obj = dt.Rows[RowIndex]["tso_starttime"]; if (obj.ToString().Length > 0) lst.tso_starttime = obj.ToString();
obj = dt.Rows[RowIndex]["tso_endtime"]; if (obj.ToString().Length > 0) lst.tso_endtime = obj.ToString();
obj = dt.Rows[RowIndex]["splash_starttime"]; if (obj.ToString().Length > 0) lst.splash_starttime = obj.ToString();
obj = dt.Rows[RowIndex]["splash_endtime"]; if (obj.ToString().Length > 0) lst.splash_endtime = obj.ToString();
obj = dt.Rows[RowIndex]["splash_duration"]; if (obj.ToString().Length > 0) lst.splash_duration = obj.ToString();
obj = dt.Rows[RowIndex]["o2_press"]; if (obj.ToString().Length > 0) lst.o2_press = obj.ToString();
obj = dt.Rows[RowIndex]["o2_flux"]; if (obj.ToString().Length > 0) lst.o2_flux = obj.ToString();
obj = dt.Rows[RowIndex]["n2_press"]; if (obj.ToString().Length > 0) lst.n2_press = obj.ToString();
obj = dt.Rows[RowIndex]["n2_flux"]; if (obj.ToString().Length > 0) lst.n2_flux = obj.ToString();
obj = dt.Rows[RowIndex]["sheetiron_wgt"]; if (obj.ToString().Length > 0) lst.sheetiron_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["restrin_wgt"]; if (obj.ToString().Length > 0) lst.restrin_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["alloycao_wgt"]; if (obj.ToString().Length > 0) lst.alloycao_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["cadd_wgt"]; if (obj.ToString().Length > 0) lst.cadd_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["fesi_wgt"]; if (obj.ToString().Length > 0) lst.fesi_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["al_wgt"]; if (obj.ToString().Length > 0) lst.al_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["mnsi_wgt"]; if (obj.ToString().Length > 0) lst.mnsi_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["femn_wgt"]; if (obj.ToString().Length > 0) lst.femn_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["fenb_wgt"]; if (obj.ToString().Length > 0) lst.fenb_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["hscrw_wgt"]; if (obj.ToString().Length > 0) lst.hscrw_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["lscrw_wgt"]; if (obj.ToString().Length > 0) lst.lscrw_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["sscrw_wgt"]; if (obj.ToString().Length > 0) lst.sscrw_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["mfemn_wgt"]; if (obj.ToString().Length > 0) lst.mfemn_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["lfemn_wgt"]; if (obj.ToString().Length > 0) lst.lfemn_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["duststeam_vol"]; if (obj.ToString().Length > 0) lst.duststeam_vol = obj.ToString();
obj = dt.Rows[RowIndex]["dustwater_vol"]; if (obj.ToString().Length > 0) lst.dustwater_vol = obj.ToString();
obj = dt.Rows[RowIndex]["recyclesteam_vol"]; if (obj.ToString().Length > 0) lst.recyclesteam_vol = obj.ToString();
obj = dt.Rows[RowIndex]["outsteam_vol"]; if (obj.ToString().Length > 0) lst.outsteam_vol = obj.ToString();
obj = dt.Rows[RowIndex]["ladlear_act"]; if (obj.ToString().Length > 0) lst.ladlear_act = obj.ToString();
obj = dt.Rows[RowIndex]["rdolo_wgt"]; if (obj.ToString().Length > 0) lst.rdolo_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["change_wgt"]; if (obj.ToString().Length > 0) lst.change_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["burnslag_wgt"]; if (obj.ToString().Length > 0) lst.burnslag_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["lfslag_wgt"]; if (obj.ToString().Length > 0) lst.lfslag_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["sicabei_wgt"]; if (obj.ToString().Length > 0) lst.sicabei_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["sialfe_wgt"]; if (obj.ToString().Length > 0) lst.sialfe_wgt = obj.ToString();
obj = dt.Rows[RowIndex]["mn_wgt"]; if (obj.ToString().Length > 0) lst.mn_wgt = obj.ToString();
str = dt.Rows[RowIndex]["IRON_LADLE_ID"].ToString(); if (str.Length > 0) lst.IRON_LADLE_ID = str;
str = dt.Rows[RowIndex]["IRON_ID"].ToString(); if (str.Length > 0) lst.IRON_ID = str;
str = dt.Rows[RowIndex]["HM_WEIGHT"].ToString(); if (str.Length > 0) lst.HM_WEIGHT = str;
str = dt.Rows[RowIndex]["HM_TRPMTURE"].ToString(); if (str.Length > 0) lst.HM_TRPMTURE = str;
str = dt.Rows[RowIndex]["HM_TIME"].ToString(); if (str.Length > 0) lst.HM_TIME = str;
str = dt.Rows[RowIndex]["HM_SOUREC"].ToString(); if (str.Length > 0) lst.HM_SOUREC = str;
str = dt.Rows[RowIndex]["SCRAP_BUCKET_ID"].ToString(); if (str.Length > 0) lst.SCRAP_BUCKET_ID = str;
str = dt.Rows[RowIndex]["SCRAP_ID"].ToString(); if (str.Length > 0) lst.SCRAP_ID = str;
str = dt.Rows[RowIndex]["SCRAP_WEIGHT"].ToString(); if (str.Length > 0) lst.SCRAP_WEIGHT = str;
str = dt.Rows[RowIndex]["HSCRW_WEIGHT"].ToString(); if (str.Length > 0) lst.HSCRW_WEIGHT = str;
str = dt.Rows[RowIndex]["LSCRW_WEIGHT"].ToString(); if (str.Length > 0) lst.LSCRW_WEIGHT = str;
str = dt.Rows[RowIndex]["SSCRW_WEIGHT"].ToString(); if (str.Length > 0) lst.SSCRW_WEIGHT = str;
LST.Add(lst);
}
dt.Dispose();
return LST;
}
