public static void LFHeatInfo_Ini(ref LFHeatInfo lst)
 {
     lst.heat_id = " "; lst.treatpos = " "; lst.strttime = " "; lst.endtime = " "; lst.station = " ";
     lst.route = " "; lst.strtgrade = " "; lst.endgrade = " "; lst.strtsteeltemp = " "; lst.endsteeltemp = " ";
     lst.strtsteelwei = " "; lst.endsteelwei = " "; lst.endslagwei = " "; lst.ladleno = " ";
     lst.ladlestatus = " "; lst.ladlewei = " "; lst.pon = " "; lst.slidgatelife = " ";
     lst.slidgatebrname = " "; lst.porozlife = " "; lst.porozbrname = " "; lst.emptydur = " ";
     lst.eletrdholdtm = " "; lst.totprieng = " "; lst.totseceng = " "; lst.gastype = " ";
     lst.totgas = " "; lst.shiftnr = " "; lst.shiftteam = " "; lst.monitor = " "; lst.mainoptr1 = " ";
     lst.mainoptr2 = " ";
 }
        public static List<LFHeatInfo> GetLFHeatInfo(string HeatID)
        {
            List<LFHeatInfo> LST = new List<LFHeatInfo>();
            LFHeatInfo lst;
            string str = "";

            string strSQL = "SELECT * FROM LF_HEAT WHERE heat_id>'" + HeatID + "'";
            DataTable dt = GetDataFromOledb(strSQL, lyqstr);

            for (int RowIndex = 0; RowIndex < dt.Rows.Count; RowIndex++)
            {
                lst = new LFHeatInfo(); LFHeatInfo_Ini(ref lst);

                str = dt.Rows[RowIndex]["heat_id"].ToString(); if (str.Length > 0) lst.heat_id = str;
                str = dt.Rows[RowIndex]["treatpos"].ToString(); if (str.Length > 0) lst.treatpos = str;
                str = dt.Rows[RowIndex]["strttime"].ToString(); if (str.Length > 0) lst.strttime = str;
                str = dt.Rows[RowIndex]["endtime"].ToString(); if (str.Length > 0) lst.endtime = str;
                str = dt.Rows[RowIndex]["station"].ToString(); if (str.Length > 0) lst.station = str;
                str = dt.Rows[RowIndex]["route"].ToString(); if (str.Length > 0) lst.route = str;

                str = dt.Rows[RowIndex]["strtgrade"].ToString(); if (str.Length > 0) lst.strtgrade = str;
                str = dt.Rows[RowIndex]["endgrade"].ToString(); if (str.Length > 0) lst.endgrade = str;
                str = dt.Rows[RowIndex]["strtsteeltemp"].ToString(); if (str.Length > 0) lst.strtsteeltemp = str;

                str = dt.Rows[RowIndex]["endsteeltemp"].ToString(); if (str.Length > 0) lst.endsteeltemp = str;
                str = dt.Rows[RowIndex]["strtsteelwei"].ToString(); if (str.Length > 0) lst.strtsteelwei = str;
                str = dt.Rows[RowIndex]["endsteelwei"].ToString(); if (str.Length > 0) lst.endsteelwei = str;

                str = dt.Rows[RowIndex]["endslagwei"].ToString(); if (str.Length > 0) lst.endslagwei = str;
                str = dt.Rows[RowIndex]["ladleno"].ToString(); if (str.Length > 0) lst.ladleno = str;
                str = dt.Rows[RowIndex]["ladlestatus"].ToString(); if (str.Length > 0) lst.ladlestatus = str;
                str = dt.Rows[RowIndex]["ladlewei"].ToString(); if (str.Length > 0) lst.ladlewei = str;

                str = dt.Rows[RowIndex]["pon"].ToString(); if (str.Length > 0) lst.pon = str;

                str = dt.Rows[RowIndex]["slidgatelife"].ToString(); if (str.Length > 0) lst.slidgatelife = str;
                str = dt.Rows[RowIndex]["slidgatebrname"].ToString(); if (str.Length > 0) lst.slidgatebrname = str;
                str = dt.Rows[RowIndex]["porozlife"].ToString(); if (str.Length > 0) lst.porozlife = str;
                str = dt.Rows[RowIndex]["porozbrname"].ToString(); if (str.Length > 0) lst.porozbrname = str;
                str = dt.Rows[RowIndex]["emptydur"].ToString(); if (str.Length > 0) lst.emptydur = str;
                str = dt.Rows[RowIndex]["eletrdholdtm"].ToString(); if (str.Length > 0) lst.eletrdholdtm = str;
                str = dt.Rows[RowIndex]["totprieng"].ToString(); if (str.Length > 0) lst.totprieng = str;
                str = dt.Rows[RowIndex]["totseceng"].ToString(); if (str.Length > 0) lst.totseceng = str;
                str = dt.Rows[RowIndex]["gastype"].ToString(); if (str.Length > 0) lst.gastype = str;
                str = dt.Rows[RowIndex]["totgas"].ToString(); if (str.Length > 0) lst.totgas = str;
                str = dt.Rows[RowIndex]["shiftnr"].ToString(); if (str.Length > 0) lst.shiftnr = str;
                str = dt.Rows[RowIndex]["shiftteam"].ToString(); if (str.Length > 0) lst.shiftteam = str;
                str = dt.Rows[RowIndex]["monitor"].ToString(); if (str.Length > 0) lst.monitor = str;
                str = dt.Rows[RowIndex]["mainoptr1"].ToString(); if (str.Length > 0) lst.mainoptr1 = str;
                str = dt.Rows[RowIndex]["mainoptr2"].ToString(); if (str.Length > 0) lst.mainoptr2 = str;

                LST.Add(lst);

            }
            dt.Dispose();

            return LST;
        }