Exemplo n.º 1
0
        public bool DeleteResultFromDB(MeasurementResults obj)
        {
            bool isSuccess = false;

            try
            {
                /// Create new record in YXbsMeastask
                YXbsMeasurementres measRes = new YXbsMeasurementres(ConnectDB.Connect_Main_);
                measRes.Format("*");
                if (obj != null)
                {
                    if ((obj.Id.MeasTaskId != null) && (obj.StationMeasurements != null) && (obj.Id.SubMeasTaskId != ConnectDB.NullI) && (obj.Id.SubMeasTaskStationId != ConnectDB.NullI))
                    {
                        if (obj.StationMeasurements.StationId != null)
                        {
                            if (measRes.Fetch(string.Format(" (meastaskid={0}) and (sensorid={1}) and (submeastaskid={2}) and (submeastaskstationid={3})", obj.Id.MeasTaskId.Value, obj.StationMeasurements.StationId.Value, obj.Id.SubMeasTaskId, obj.Id.SubMeasTaskStationId)))
                            {
                                foreach (FrequencyMeasurement dt_param in obj.FrequenciesMeasurements.ToArray())
                                {
                                    YXbsFrequencymeas dtr = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                                    dtr.Format("*");
                                    if (dt_param != null)
                                    {
                                        if (dtr.Fetch(string.Format("id_xbs_measurementres={0}", measRes.m_id)))
                                        {
                                            dtr.Delete();
                                        }
                                    }
                                    dtr.Close();
                                    dtr.Dispose();
                                }
                                foreach (LocationSensorMeasurement dt_param in obj.LocationSensorMeasurement.ToArray())
                                {
                                    YXbsLocationsensorm dtr = new YXbsLocationsensorm(ConnectDB.Connect_Main_);
                                    dtr.Format("*");
                                    if (dt_param != null)
                                    {
                                        if (dtr.Fetch(string.Format("id_xbs_measurementres={0}", measRes.m_id)))
                                        {
                                            dtr.Delete();
                                        }
                                    }
                                    dtr.Close();
                                    dtr.Dispose();
                                }
                                foreach (MeasurementResult dt_param in obj.MeasurementsResults.ToArray())
                                {
                                    if (obj.TypeMeasurements == MeasurementType.Level)
                                    {
                                        YXbsLevelmeasres dtr = new YXbsLevelmeasres(ConnectDB.Connect_Main_);
                                        dtr.Format("*");
                                        if (dt_param != null)
                                        {
                                            if (dtr.Fetch(string.Format("id_xbs_measurementres={0}", measRes.m_id)))
                                            {
                                                dtr.Delete();
                                            }
                                        }
                                        dtr.Close();
                                        dtr.Dispose();
                                    }
                                    else if (obj.TypeMeasurements == MeasurementType.SpectrumOccupation)
                                    {
                                        YXbsSpectoccupmeas dtr = new YXbsSpectoccupmeas(ConnectDB.Connect_Main_);
                                        dtr.Format("*");
                                        if (dt_param != null)
                                        {
                                            if (dtr.Fetch(string.Format("id_xbs_measurementres={0}", measRes.m_id)))
                                            {
                                                dtr.Delete();
                                            }
                                        }
                                        dtr.Close();
                                        dtr.Dispose();
                                    }
                                }
                                isSuccess = true;
                                measRes.Delete();
                            }
                        }
                    }
                    else if (obj.Id.MeasTaskId != null)
                    {
                        {
                            measRes.Filter = string.Format(" (meastaskid={0}) ", obj.Id.MeasTaskId.Value);
                            for (measRes.OpenRs(); !measRes.IsEOF(); measRes.MoveNext())
                            {
                                foreach (FrequencyMeasurement dt_param in obj.FrequenciesMeasurements.ToArray())
                                {
                                    YXbsFrequencymeas dtr = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                                    dtr.Format("*");
                                    if (dt_param != null)
                                    {
                                        dtr.Filter = string.Format("id_xbs_measurementres={0}", measRes.m_id);
                                        for (dtr.OpenRs(); !dtr.IsEOF(); dtr.MoveNext())
                                        {
                                            dtr.Delete();
                                        }
                                    }
                                    dtr.Close();
                                    dtr.Dispose();
                                }

                                foreach (LocationSensorMeasurement dt_param in obj.LocationSensorMeasurement.ToArray())
                                {
                                    YXbsLocationsensorm dtr = new YXbsLocationsensorm(ConnectDB.Connect_Main_);
                                    dtr.Format("*");
                                    if (dt_param != null)
                                    {
                                        dtr.Filter = string.Format("id_xbs_measurementres={0}", measRes.m_id);
                                        for (dtr.OpenRs(); !dtr.IsEOF(); dtr.MoveNext())
                                        {
                                            dtr.Delete();
                                        }
                                    }
                                    dtr.Close();
                                    dtr.Dispose();
                                }

                                foreach (MeasurementResult dt_param in obj.MeasurementsResults.ToArray())
                                {
                                    if (obj.TypeMeasurements == MeasurementType.Level)
                                    {
                                        YXbsLevelmeasres dtr = new YXbsLevelmeasres(ConnectDB.Connect_Main_);
                                        dtr.Format("*");
                                        if (dt_param != null)
                                        {
                                            dtr.Filter = string.Format("id_xbs_measurementres={0}", measRes.m_id);
                                            for (dtr.OpenRs(); !dtr.IsEOF(); dtr.MoveNext())
                                            {
                                                dtr.Delete();
                                            }
                                        }
                                        dtr.Close();
                                        dtr.Dispose();
                                    }
                                    else if (obj.TypeMeasurements == MeasurementType.SpectrumOccupation)
                                    {
                                        YXbsSpectoccupmeas dtr = new YXbsSpectoccupmeas(ConnectDB.Connect_Main_);
                                        dtr.Format("*");
                                        if (dt_param != null)
                                        {
                                            dtr.Filter = string.Format("id_xbs_measurementres={0}", measRes.m_id);
                                            for (dtr.OpenRs(); !dtr.IsEOF(); dtr.MoveNext())
                                            {
                                                dtr.Delete();
                                            }
                                        }
                                        dtr.Close();
                                        dtr.Dispose();
                                    }
                                }
                                isSuccess = true;
                                measRes.Delete();
                            }
                        }
                    }
                    measRes.Close();
                    measRes.Dispose();
                }
            }
            catch (Exception)
            { isSuccess = false; }
            return(isSuccess);
        }
Exemplo n.º 2
0
        public int SaveResultToDB(MeasurementResults obj)
        {
            int ID = ConnectDB.NullI;

            if (((obj.TypeMeasurements == MeasurementType.SpectrumOccupation) && (obj.Status == "C")) || (obj.TypeMeasurements != MeasurementType.SpectrumOccupation))
            {
                //Task tsk = new Task(() =>
                //{
                try
                {
                    /// Create new record in YXbsMeastask
                    if (obj != null)
                    {
                        if ((obj.Id.MeasTaskId != null) && (obj.StationMeasurements != null) && (obj.Id.SubMeasTaskId != ConnectDB.NullI) && (obj.Id.SubMeasTaskStationId != ConnectDB.NullI))
                        {
                            if (obj.StationMeasurements.StationId != null)
                            {
                                YXbsMeasurementres measRes = new YXbsMeasurementres(ConnectDB.Connect_Main_);
                                measRes.Format("*");
                                measRes.Filter = "[ID]=-1";
                                measRes.New();
                                ID = measRes.AllocID();
                                obj.Id.MeasSdrResultsId = ID;
                                if (obj.AntVal != null)
                                {
                                    measRes.m_antval = obj.AntVal.GetValueOrDefault();
                                }
                                if (obj.DataRank != null)
                                {
                                    measRes.m_datarank = obj.DataRank.GetValueOrDefault();
                                }
                                measRes.m_status     = obj.Status;
                                measRes.m_meastaskid = obj.Id.MeasTaskId.Value;
                                if (obj.N != null)
                                {
                                    measRes.m_n = obj.N.GetValueOrDefault();
                                }
                                measRes.m_sensorid             = obj.StationMeasurements.StationId.Value;
                                measRes.m_submeastaskid        = obj.Id.SubMeasTaskId;
                                measRes.m_submeastaskstationid = obj.Id.SubMeasTaskStationId;
                                measRes.m_timemeas             = obj.TimeMeas;
                                measRes.m_typemeasurements     = obj.TypeMeasurements.ToString();
                                measRes.Save();
                                measRes.Close();
                                measRes.Dispose();
                            }
                        }
                        if (ID != ConnectDB.NullI)
                        {
                            if (obj.LocationSensorMeasurement != null)
                            {
                                foreach (LocationSensorMeasurement dt_param in obj.LocationSensorMeasurement.ToArray())
                                {
                                    if (dt_param != null)
                                    {
                                        YXbsLocationsensorm dtr = new YXbsLocationsensorm(ConnectDB.Connect_Main_);
                                        dtr.Format("*");
                                        dtr.Filter = "[ID]=-1";
                                        dtr.New();
                                        int ID_DT_params = dtr.AllocID();
                                        if (dt_param.ASL != null)
                                        {
                                            dtr.m_asl = dt_param.ASL.GetValueOrDefault();
                                        }
                                        if (dt_param.Lon != null)
                                        {
                                            dtr.m_lon = dt_param.Lon.GetValueOrDefault();
                                        }
                                        if (dt_param.Lat != null)
                                        {
                                            dtr.m_lat = dt_param.Lat.GetValueOrDefault();
                                        }
                                        dtr.m_id_xbs_measurementres = ID;
                                        dtr.Save();
                                        dtr.Close();
                                        dtr.Dispose();
                                    }
                                }
                            }
                            if (obj.MeasurementsResults != null)
                            {
                                int idx_cnt = 0;
                                foreach (MeasurementResult dt_param in obj.MeasurementsResults.ToArray())
                                {
                                    if ((obj.TypeMeasurements == MeasurementType.Level) && (obj.Status != "O"))
                                    {
                                        if (dt_param != null)
                                        {
                                            if (dt_param is LevelMeasurementResult)
                                            {
                                                YXbsLevelmeasres dtrR = new YXbsLevelmeasres(ConnectDB.Connect_Main_);
                                                dtrR.Format("*");
                                                dtrR.Filter = "[ID]=-1";
                                                dtrR.New();
                                                int ID_DT_params = dtrR.AllocID();
                                                if ((dt_param as LevelMeasurementResult).Value != null)
                                                {
                                                    dtrR.m_value = (dt_param as LevelMeasurementResult).Value.GetValueOrDefault();
                                                }
                                                if ((dt_param as LevelMeasurementResult).PMax != null)
                                                {
                                                    dtrR.m_pmax = (dt_param as LevelMeasurementResult).PMax.GetValueOrDefault();
                                                }
                                                if ((dt_param as LevelMeasurementResult).PMin != null)
                                                {
                                                    dtrR.m_pmin = (dt_param as LevelMeasurementResult).PMin.GetValueOrDefault();
                                                }
                                                dtrR.m_id_xbs_measurementres = ID;
                                                dtrR.Save();
                                                dtrR.Close();
                                                dtrR.Dispose();

                                                if (obj.FrequenciesMeasurements != null)
                                                {
                                                    List <FrequencyMeasurement> Fr_e = obj.FrequenciesMeasurements.ToList().FindAll(t => t.Id == dt_param.Id.Value);
                                                    if (Fr_e != null)
                                                    {
                                                        if (Fr_e.Count > 0)
                                                        {
                                                            foreach (FrequencyMeasurement dt_param_freq in Fr_e.ToArray())
                                                            {
                                                                if (dt_param_freq != null)
                                                                {
                                                                    YXbsFrequencymeas dtr_freq = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                                                                    dtr_freq.Format("*");
                                                                    dtr_freq.Filter = "[ID]=-1";
                                                                    dtr_freq.New();
                                                                    int ID_DT_params_freq = dtr_freq.AllocID();
                                                                    dtr_freq.m_freq = dt_param_freq.Freq;
                                                                    dtr_freq.m_id_xbs_measurementres = ID;
                                                                    dtr_freq.m_num = ID_DT_params;
                                                                    dtr_freq.Save();
                                                                    dt_param_freq.Id = ID_DT_params;
                                                                    dtr_freq.Close();
                                                                    dtr_freq.Dispose();
                                                                }
                                                            }
                                                        }
                                                    }
                                                }
                                                dt_param.Id       = new MeasurementResultIdentifier();
                                                dt_param.Id.Value = ID_DT_params;
                                            }
                                        }
                                    }
                                    else if ((obj.TypeMeasurements == MeasurementType.SpectrumOccupation) && (obj.Status == "C"))
                                    {
                                        if (dt_param != null)
                                        {
                                            if (dt_param is SpectrumOccupationMeasurementResult)
                                            {
                                                YXbsSpectoccupmeas dtr = new YXbsSpectoccupmeas(ConnectDB.Connect_Main_);
                                                dtr.Format("*");
                                                dtr.Filter = "[ID]=-1";
                                                dtr.New();
                                                int ID_DT_params = dtr.AllocID();
                                                if ((dt_param as SpectrumOccupationMeasurementResult).Value != null)
                                                {
                                                    dtr.m_value = (dt_param as SpectrumOccupationMeasurementResult).Value.GetValueOrDefault();
                                                }
                                                if ((dt_param as SpectrumOccupationMeasurementResult).Occupancy != null)
                                                {
                                                    dtr.m_occupancy = (dt_param as SpectrumOccupationMeasurementResult).Occupancy.GetValueOrDefault();
                                                }
                                                dtr.m_id_xbs_measurementres = ID;
                                                dtr.Save();
                                                dtr.Close();
                                                dtr.Dispose();


                                                if (obj.FrequenciesMeasurements != null)
                                                {
                                                    List <FrequencyMeasurement> Fr_e = obj.FrequenciesMeasurements.ToList().FindAll(t => t.Id == dt_param.Id.Value);
                                                    if (Fr_e != null)
                                                    {
                                                        if (Fr_e.Count > 0)
                                                        {
                                                            foreach (FrequencyMeasurement dt_param_freq in Fr_e.ToArray())
                                                            {
                                                                if (dt_param_freq != null)
                                                                {
                                                                    YXbsFrequencymeas dtr_freq = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                                                                    dtr_freq.Format("*");
                                                                    dtr_freq.Filter = "[ID]=-1";
                                                                    dtr_freq.New();
                                                                    int ID_DT_params_freq = dtr_freq.AllocID();
                                                                    dtr_freq.m_freq = dt_param_freq.Freq;
                                                                    dtr_freq.m_id_xbs_measurementres = ID;
                                                                    dtr_freq.m_num = ID_DT_params;
                                                                    dtr_freq.Save();
                                                                    dt_param_freq.Id = ID_DT_params;
                                                                    dtr_freq.Close();
                                                                    dtr_freq.Dispose();
                                                                }
                                                            }
                                                        }
                                                    }
                                                }
                                                dt_param.Id       = new MeasurementResultIdentifier();
                                                dt_param.Id.Value = ID_DT_params;
                                            }
                                        }
                                    }
                                    //else
                                    {
                                        if (dt_param != null)
                                        {
                                            if (dt_param is LevelMeasurementOnlineResult)
                                            {
                                                YXbsLevelmeasonlres dtr = new YXbsLevelmeasonlres(ConnectDB.Connect_Main_);
                                                dtr.Format("*");
                                                dtr.Filter = "[ID]=-1";
                                                dtr.New();
                                                int ID_DT_params = dtr.AllocID();
                                                if ((dt_param as LevelMeasurementOnlineResult).Value != ConnectDB.NullD)
                                                {
                                                    dtr.m_value = (dt_param as LevelMeasurementOnlineResult).Value;
                                                }
                                                dtr.m_id_xbs_measurementres = ID;
                                                dtr.Save();
                                                dt_param.Id       = new MeasurementResultIdentifier();
                                                dt_param.Id.Value = ID_DT_params;
                                                dtr.Close();
                                                dtr.Dispose();
                                            }
                                        }
                                    }
                                    idx_cnt++;
                                }
                            }
                        }
                    }
                }
                catch (Exception ex)
                {
                    System.Console.WriteLine("SaveResultToDB: " + ex.Message);
                }
                //});
                //tsk.Start();
                //tsk.Wait(30000);
            }
            return(ID);
        }
Exemplo n.º 3
0
        public List <ClassSDRResults> ReadlResultFromDB(int ID)
        {
            // Список объектов в рамках конкретного адаптера ICSM
            List <ClassSDRResults> L_IN = new List <ClassSDRResults>();

            try
            {
                Task tsk = new Task(() => {
                    YXbsMeasurementres res_val = new YXbsMeasurementres(ConnectDB.Connect_Main_);
                    res_val.Format("*");
                    // выбирать только таски, для которых STATUS не NULL
                    res_val.Filter = string.Format("(ID={0})", ID);
                    for (res_val.OpenRs(); !res_val.IsEOF(); res_val.MoveNext())
                    {
                        ClassSDRResults ICSM_T  = new ClassSDRResults();
                        ICSM_T.freq_meas        = new List <YXbsFrequencymeas>();
                        ICSM_T.level_meas_res   = new List <YXbsLevelmeasres>();
                        ICSM_T.loc_sensorM      = new List <YXbsLocationsensorm>();
                        ICSM_T.meas_res         = new YXbsMeasurementres();
                        ICSM_T.spect_occup_meas = new List <YXbsSpectoccupmeas>();

                        ICSM_T.meas_res = new YXbsMeasurementres();
                        var m_fr        = new YXbsMeasurementres(ConnectDB.Connect_Main_);
                        m_fr.CopyDataFrom(res_val);
                        ICSM_T.meas_res = m_fr;

                        /*
                         * YXbsFrequencymeas XbsYXbsFrequencymeas_ = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                         * XbsYXbsFrequencymeas_.Format("*");
                         * XbsYXbsFrequencymeas_.Filter = string.Format("(id_xbs_measurementres={0})", res_val.m_id);
                         * for (XbsYXbsFrequencymeas_.OpenRs(); !XbsYXbsFrequencymeas_.IsEOF(); XbsYXbsFrequencymeas_.MoveNext())
                         * {
                         *  var m_fr_ = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                         *  m_fr_.CopyDataFrom(XbsYXbsFrequencymeas_);
                         *  ICSM_T.freq_meas.Add(m_fr_);
                         *  m_fr_.Close();
                         *  m_fr_.Dispose();
                         * }
                         * XbsYXbsFrequencymeas_.Close();
                         * XbsYXbsFrequencymeas_.Dispose();
                         */

                        YXbsLevelmeasres XbsYXbsLevelmeasres_ = new YXbsLevelmeasres(ConnectDB.Connect_Main_);
                        XbsYXbsLevelmeasres_.Format("*");
                        XbsYXbsLevelmeasres_.Filter = string.Format("(id_xbs_measurementres={0})", res_val.m_id);
                        for (XbsYXbsLevelmeasres_.OpenRs(); !XbsYXbsLevelmeasres_.IsEOF(); XbsYXbsLevelmeasres_.MoveNext())
                        {
                            var m_fr_ = new YXbsLevelmeasres(ConnectDB.Connect_Main_);
                            m_fr_.CopyDataFrom(XbsYXbsLevelmeasres_);
                            ICSM_T.level_meas_res.Add(m_fr_);

                            //////// получить частоты
                            YXbsFrequencymeas XbsYXbsFrequencymeas_ = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                            XbsYXbsFrequencymeas_.Format("*");
                            XbsYXbsFrequencymeas_.Filter = string.Format("(id_xbs_measurementres={0}) and (Num={1})", res_val.m_id, m_fr_.m_id);
                            for (XbsYXbsFrequencymeas_.OpenRs(); !XbsYXbsFrequencymeas_.IsEOF(); XbsYXbsFrequencymeas_.MoveNext())
                            {
                                var m_fr_f = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                                m_fr_f.CopyDataFrom(XbsYXbsFrequencymeas_);
                                ICSM_T.freq_meas.Add(m_fr_f);
                                m_fr_f.Close();
                                m_fr_f.Dispose();
                            }
                            XbsYXbsFrequencymeas_.Close();
                            XbsYXbsFrequencymeas_.Dispose();
                            /////////

                            m_fr_.Close();
                            m_fr_.Dispose();
                        }
                        XbsYXbsLevelmeasres_.Close();
                        XbsYXbsLevelmeasres_.Dispose();

                        YXbsLevelmeasonlres XbsYXbsLevelmeasonlres_ = new YXbsLevelmeasonlres(ConnectDB.Connect_Main_);
                        XbsYXbsLevelmeasonlres_.Format("*");
                        XbsYXbsLevelmeasonlres_.Filter = string.Format("(id_xbs_measurementres={0})", res_val.m_id);
                        for (XbsYXbsLevelmeasonlres_.OpenRs(); !XbsYXbsLevelmeasonlres_.IsEOF(); XbsYXbsLevelmeasonlres_.MoveNext())
                        {
                            var m_fr_ = new YXbsLevelmeasonlres(ConnectDB.Connect_Main_);
                            m_fr_.CopyDataFrom(XbsYXbsLevelmeasonlres_);
                            ICSM_T.level_meas_onl_res.Add(m_fr_);

                            //////// получить частоты
                            YXbsFrequencymeas XbsYXbsFrequencymeas_ = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                            XbsYXbsFrequencymeas_.Format("*");
                            XbsYXbsFrequencymeas_.Filter = string.Format("(id_xbs_measurementres={0}) and (Num={1})", res_val.m_id, m_fr_.m_id);
                            for (XbsYXbsFrequencymeas_.OpenRs(); !XbsYXbsFrequencymeas_.IsEOF(); XbsYXbsFrequencymeas_.MoveNext())
                            {
                                var m_fr_f = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                                m_fr_f.CopyDataFrom(XbsYXbsFrequencymeas_);
                                ICSM_T.freq_meas.Add(m_fr_f);
                                m_fr_f.Close();
                                m_fr_f.Dispose();
                            }
                            XbsYXbsFrequencymeas_.Close();
                            XbsYXbsFrequencymeas_.Dispose();
                            /////////

                            m_fr_.Close();
                            m_fr_.Dispose();
                        }
                        XbsYXbsLevelmeasonlres_.Close();
                        XbsYXbsLevelmeasonlres_.Dispose();

                        YXbsSpectoccupmeas XbsYXbsSpectoccupmeas_ = new YXbsSpectoccupmeas(ConnectDB.Connect_Main_);
                        XbsYXbsSpectoccupmeas_.Format("*");
                        XbsYXbsSpectoccupmeas_.Filter = string.Format("(id_xbs_measurementres={0})", res_val.m_id);
                        for (XbsYXbsSpectoccupmeas_.OpenRs(); !XbsYXbsSpectoccupmeas_.IsEOF(); XbsYXbsSpectoccupmeas_.MoveNext())
                        {
                            var m_fr_ = new YXbsSpectoccupmeas(ConnectDB.Connect_Main_);
                            m_fr_.CopyDataFrom(XbsYXbsSpectoccupmeas_);
                            ICSM_T.spect_occup_meas.Add(m_fr_);

                            //////// получить частоты
                            YXbsFrequencymeas XbsYXbsFrequencymeas_ = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                            XbsYXbsFrequencymeas_.Format("*");
                            XbsYXbsFrequencymeas_.Filter = string.Format("(id_xbs_measurementres={0}) and (Num={1})", res_val.m_id, m_fr_.m_id);
                            for (XbsYXbsFrequencymeas_.OpenRs(); !XbsYXbsFrequencymeas_.IsEOF(); XbsYXbsFrequencymeas_.MoveNext())
                            {
                                var m_fr_f = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
                                m_fr_f.CopyDataFrom(XbsYXbsFrequencymeas_);
                                ICSM_T.freq_meas.Add(m_fr_f);
                                m_fr_f.Close();
                                m_fr_f.Dispose();
                            }
                            XbsYXbsFrequencymeas_.Close();
                            XbsYXbsFrequencymeas_.Dispose();
                            /////////

                            m_fr_.Close();
                            m_fr_.Dispose();
                        }
                        XbsYXbsSpectoccupmeas_.Close();
                        XbsYXbsSpectoccupmeas_.Dispose();

                        YXbsLocationsensorm XbsYXbsLocationsensorm_ = new YXbsLocationsensorm(ConnectDB.Connect_Main_);
                        XbsYXbsLocationsensorm_.Format("*");
                        XbsYXbsLocationsensorm_.Filter = string.Format("(id_xbs_measurementres={0})", res_val.m_id);
                        for (XbsYXbsLocationsensorm_.OpenRs(); !XbsYXbsLocationsensorm_.IsEOF(); XbsYXbsLocationsensorm_.MoveNext())
                        {
                            var m_fr_ = new YXbsLocationsensorm(ConnectDB.Connect_Main_);
                            m_fr_.CopyDataFrom(XbsYXbsLocationsensorm_);
                            ICSM_T.loc_sensorM.Add(m_fr_);
                            m_fr_.Close();
                            m_fr_.Dispose();
                        }
                        XbsYXbsLocationsensorm_.Close();
                        XbsYXbsLocationsensorm_.Dispose();
                        L_IN.Add(ICSM_T);
                        m_fr.Close();
                        m_fr.Dispose();
                    }
                    res_val.Close();
                    res_val.Dispose();
                });
                tsk.Start();
                //tsk.Wait();
                Console.WriteLine("Readl Result From DB Objects ...");
            }
            catch (Exception)
            {
            }
            return(L_IN);
        }