public static void KRHeatInfo_Ini(ref KRHeatInfo lst)
{
lst.HEAT_ID = " "; lst.IRON_ID = " "; lst.DES_STATION_NO = " "; lst.PLAN_NO = " ";
lst.PONO = " "; lst.STEEL_GRADE = " "; lst.AIM_S = " "; lst.DES_STEP_NUM = " ";
lst.IRON_LADLE_ID = " "; lst.INI_TEMP = " "; lst.INI_WGT = " "; lst.INI_C = " ";
lst.INI_SI = " "; lst.INI_MN = " "; lst.INI_P = " "; lst.INI_S = " ";
lst.INI_TI = " "; lst.FIN_TEMP = " "; lst.FIN_WGT = " "; lst.MATERIALID_ACT = " ";
lst.ADDWGT_ACT = " "; lst.STIRRER_DURATION = " "; lst.STIRRER_SPEED_MAX = " "; lst.STIRRER_SPEED_MIN = " ";
lst.STIRRER_SPEED_AVG = " "; lst.STIRRER_HEIGHT_MAX = " "; lst.STIRRER_HEIGHT_MIN = " ";
lst.STIRRER_HEIGHT_AVG = " "; lst.STIRRER_ID = " "; lst.STIRRER_TIMES = " "; lst.LADLE_ARRIVE = " ";
lst.LADLE_LEAVE = " "; lst.DES_START = " "; lst.DES_END = " "; lst.RESIDUE_FIRST_S = " ";
lst.RESIDUE_FIRST_E = " "; lst.RESIDUE_FIRST_DURATION = " "; lst.RESIDUE_FIRST_SLAG_WGT = " ";
lst.RESIDUE_LAST_S = " "; lst.RESIDUE_LAST_E = " "; lst.RESIDUE_LAST_DURATION = " ";
lst.RESIDUE_LAST_SLAG_WGT = " "; lst.CALEFACIENT_USED = " "; lst.DES_DURATION = " ";
lst.PRODUCE_DATE = " "; lst.CREW_ID = " "; lst.SHIFT_ID = " ";
lst.VALID_FLAG = " "; lst.PERIOD_ID = " "; lst.LADLE_WEIGHT = " "; lst.TEMP_TIME_F = " ";
lst.TEMP_TIME_E = " ";
}
public static List<KRHeatInfo> GetKRHeatInfo(string HeatID)
{
List<KRHeatInfo> LST = new List<KRHeatInfo>();
KRHeatInfo lst = new KRHeatInfo(); KRHeatInfo_Ini(ref lst);
object obj = new object();
/////// 各种事件/////////////////
string strSQL = "SELECT * FROM KR_Heat WHERE Heat_ID> '" + HeatID + "'";
DataTable dt = GetDataFromOledb(strSQL, lyqstr);
for (int RowIndex = 0; RowIndex < dt.Rows.Count; RowIndex++)
{
lst = new KRHeatInfo(); KRHeatInfo_Ini(ref lst);
obj = dt.Rows[RowIndex]["Heat_ID"]; if (obj.ToString().Length > 0) lst.HEAT_ID = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["IRON_ID"]; if (obj.ToString().Length > 0) lst.IRON_ID = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["DES_STATION_NO"]; if (obj.ToString().Length > 0) lst.DES_STATION_NO = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["PLAN_NO"]; if (obj.ToString().Length > 0) lst.PLAN_NO = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["PONO"]; if (obj.ToString().Length > 0) lst.PONO = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["STEEL_GRADE"]; if (obj.ToString().Length > 0) lst.STEEL_GRADE = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["AIM_S"]; if (obj.ToString().Length > 0) lst.AIM_S = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["DES_STEP_NUM"]; if (obj.ToString().Length > 0) lst.DES_STEP_NUM = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["IRON_LADLE_ID"]; if (obj.ToString().Length > 0) lst.IRON_LADLE_ID = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["INI_TEMP"]; if (obj.ToString().Length > 0) lst.INI_TEMP = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["INI_WGT"]; if (obj.ToString().Length > 0) lst.INI_WGT = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["INI_C"]; if (obj.ToString().Length > 0) lst.INI_C = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["INI_SI"]; if (obj.ToString().Length > 0) lst.INI_SI = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["INI_MN"]; if (obj.ToString().Length > 0) lst.INI_MN = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["INI_P"]; if (obj.ToString().Length > 0) lst.INI_P = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["INI_S"]; if (obj.ToString().Length > 0) lst.INI_S = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["INI_TI"]; if (obj.ToString().Length > 0) lst.INI_TI = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["FIN_TEMP"]; if (obj.ToString().Length > 0) lst.FIN_TEMP = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["FIN_WGT"]; if (obj.ToString().Length > 0) lst.FIN_WGT = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["MATERIALID_ACT"]; if (obj.ToString().Length > 0) lst.MATERIALID_ACT = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["ADDWGT_ACT"]; if (obj.ToString().Length > 0) lst.ADDWGT_ACT = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["STIRRER_DURATION"]; if (obj.ToString().Length > 0) lst.STIRRER_DURATION = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["STIRRER_SPEED_MAX"]; if (obj.ToString().Length > 0) lst.STIRRER_SPEED_MAX = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["STIRRER_SPEED_MIN"]; if (obj.ToString().Length > 0) lst.STIRRER_SPEED_MIN = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["STIRRER_SPEED_AVG"]; if (obj.ToString().Length > 0) lst.STIRRER_SPEED_AVG = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["STIRRER_HEIGHT_MAX"]; if (obj.ToString().Length > 0) lst.STIRRER_HEIGHT_MAX = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["STIRRER_HEIGHT_MIN"]; if (obj.ToString().Length > 0) lst.STIRRER_HEIGHT_MIN = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["STIRRER_HEIGHT_AVG"]; if (obj.ToString().Length > 0) lst.STIRRER_HEIGHT_AVG = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["STIRRER_ID"]; if (obj.ToString().Length > 0) lst.STIRRER_ID = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["STIRRER_TIMES"]; if (obj.ToString().Length > 0) lst.STIRRER_TIMES = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["LADLE_ARRIVE"]; if (obj.ToString().Length > 0) lst.LADLE_ARRIVE = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["LADLE_LEAVE"]; if (obj.ToString().Length > 0) lst.LADLE_LEAVE = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["DES_START"]; if (obj.ToString().Length > 0) lst.DES_START = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["DES_END"]; if (obj.ToString().Length > 0) lst.DES_END = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["RESIDUE_FIRST_S"]; if (obj.ToString().Length > 0) lst.RESIDUE_FIRST_S = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["RESIDUE_FIRST_E"]; if (obj.ToString().Length > 0) lst.RESIDUE_FIRST_E = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["RESIDUE_FIRST_DURATION"]; if (obj.ToString().Length > 0) lst.RESIDUE_FIRST_DURATION = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["RESIDUE_FIRST_SLAG_WGT"]; if (obj.ToString().Length > 0) lst.RESIDUE_FIRST_SLAG_WGT = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["RESIDUE_LAST_S"]; if (obj.ToString().Length > 0) lst.RESIDUE_LAST_S = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["RESIDUE_LAST_E"]; if (obj.ToString().Length > 0) lst.RESIDUE_LAST_E = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["RESIDUE_LAST_DURATION"]; if (obj.ToString().Length > 0) lst.RESIDUE_LAST_DURATION = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["RESIDUE_LAST_SLAG_WGT"]; if (obj.ToString().Length > 0) lst.RESIDUE_LAST_SLAG_WGT = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["CALEFACIENT_USED"]; if (obj.ToString().Length > 0) lst.CALEFACIENT_USED = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["DES_DURATION"]; if (obj.ToString().Length > 0) lst.DES_DURATION = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["PRODUCE_DATE"]; if (obj.ToString().Length > 0) lst.PRODUCE_DATE = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["CREW_ID"]; if (obj.ToString().Length > 0) lst.CREW_ID = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["SHIFT_ID"]; if (obj.ToString().Length > 0) lst.SHIFT_ID = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["VALID_FLAG"]; if (obj.ToString().Length > 0) lst.VALID_FLAG = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["PERIOD_ID"]; if (obj.ToString().Length > 0) lst.PERIOD_ID = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["LADLE_WEIGHT"]; if (obj.ToString().Length > 0) lst.LADLE_WEIGHT = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["TEMP_TIME_F"]; if (obj.ToString().Length > 0) lst.TEMP_TIME_F = Convert.ToString(obj);
obj = dt.Rows[RowIndex]["TEMP_TIME_E"]; if (obj.ToString().Length > 0) lst.TEMP_TIME_E = Convert.ToString(obj);
LST.Add(lst);
}
dt.Dispose();
return LST;
}
