C# DataStore.Disconnect方法代码示例

        /// <summary>Get the base data that is in scope.</summary>
        public DataTable GetBaseData(string tableName)
        {
            if (tables.ContainsKey(tableName))
                return tables[tableName];

            else if (tableName != null)
            {
                Simulation parentSimulation = Apsim.Parent(this, typeof(Simulation)) as Simulation;
                Zone parentZone = Apsim.Parent(this, typeof(Zone)) as Zone;
                Experiment parentExperiment = Apsim.Parent(this, typeof(Experiment)) as Experiment;

                string baseFilter = null;
                // If the graph is in a zone then just graph the zone.
                if (parentZone != null && !(parentZone is Simulation))
                {
                    // in a zone.
                    baseFilter = string.Format("SimulationName='{0}' and ZoneName='{1}'", parentSimulation.Name, parentZone.Name);
                }
                else
                {
                    List<string> simulationNames = new List<string>();
                    if (parentSimulation != null)
                        simulationNames.Add(parentSimulation.Name);  // in a simulation.

                    else if (parentExperiment != null)
                        simulationNames.AddRange(parentExperiment.Names());

                    else
                    {
                        // Must be in a folder at the top level or at the top level of the .apsimx file.
                        IModel parentOfGraph = this.Parent;

                        // Look for experiments.
                        foreach (Experiment experiment in Apsim.ChildrenRecursively(parentOfGraph, typeof(Experiment)))
                            simulationNames.AddRange(experiment.Names());

                        // Look for simulations if we didn't find any experiments.
                        foreach (Simulation simulation in Apsim.ChildrenRecursively(parentOfGraph, typeof(Simulation)))
                        {
                            if (simulation.Parent is Experiment)
                            { }
                            else
                                simulationNames.Add(simulation.Name);
                        }
                    }

                    // convert simulationNames to a filter.
                    foreach (string simulationName in simulationNames)
                    {
                        if (baseFilter != null)
                            baseFilter += ",";
                        baseFilter += "'" + simulationName + "'";
                    }
                    baseFilter = "SimulationName IN (" + baseFilter + ")";
                }

                DataStore dataStore = new DataStore(this);
                DataTable data = dataStore.GetFilteredData(tableName, baseFilter);
                dataStore.Disconnect();
                tables.Add(tableName, data);
                return data;
            }

            return null;
        }

        private void OnSimulationCompleted(object sender, EventArgs e)
        {
            // Get rid of old data in .db
            DataStore dataStore = new DataStore(this);
            if (this.simulation != null)
            {
                dataStore.DeleteOldContentInTable(this.simulation.Name, this.Name);
            }
            // Write and store a table in the DataStore
            if (this.columns != null && this.columns.Count > 0)
            {
                DataTable table = new DataTable();

                foreach (ReportColumn variable in this.columns)
                    variable.AddColumnsToTable(table);

                foreach (ReportColumn variable in this.columns)
                    variable.AddRowsToTable(table);

                dataStore.WriteTable(this.simulation.Name, this.Name, table);

                this.columns.Clear();
                this.columns = null;
            }

            dataStore.Disconnect();
            dataStore = null;
        }

        /// <summary>Main run method for performing our calculations and storing data.</summary>
        /// <param name="dataStore">The data store.</param>
        /// <exception cref="ApsimXException">
        /// Could not find model data table:  + ObservedTableName
        /// or
        /// Could not find observed data table:  + ObservedTableName
        /// </exception>
        public void Run(DataStore dataStore)
        {
            if (PredictedTableName != null && ObservedTableName != null)
            {
                dataStore.DeleteTable(this.Name);

                DataTable predictedDataNames = dataStore.RunQuery("PRAGMA table_info(" + PredictedTableName + ")");
                DataTable observedDataNames  = dataStore.RunQuery("PRAGMA table_info(" + ObservedTableName + ")");

                if (predictedDataNames == null)
                    throw new ApsimXException(this, "Could not find model data table: " + ObservedTableName);

                if (observedDataNames == null)
                    throw new ApsimXException(this, "Could not find observed data table: " + ObservedTableName);

                IEnumerable<string> commonCols = from p in predictedDataNames.AsEnumerable()
                                               join o in observedDataNames.AsEnumerable() on p["name"] equals o["name"]
                                               select p["name"] as string;

                StringBuilder query = new StringBuilder("SELECT ");
                foreach (string s in commonCols)
                {
                    if (s == FieldNameUsedForMatch || s == FieldName2UsedForMatch || s == FieldName3UsedForMatch)
                        query.Append("I.'@field', ");
                    else
                        query.Append("I.'@field' AS '[email protected]', R.'@field' AS '[email protected]', ");

                    query.Replace("@field", s);
                }

                query.Append("FROM " + ObservedTableName + " I INNER JOIN " + PredictedTableName + " R USING (SimulationID) WHERE I.'@match1' = R.'@match1'");
                if (FieldName2UsedForMatch != null)
                    query.Append(" AND I.'@match2' = R.'@match2'");
                if (FieldName3UsedForMatch != null)
                    query.Append(" AND I.'@match3' = R.'@match3'");
                query.Replace(", FROM", " FROM"); // get rid of the last comma
                query.Replace("I.'SimulationID' AS 'Observed.SimulationID', R.'SimulationID' AS 'Predicted.SimulationID'", "I.'SimulationID' AS 'SimulationID'");

                query = query.Replace("@match1", FieldNameUsedForMatch);
                query = query.Replace("@match2", FieldName2UsedForMatch);
                query = query.Replace("@match3", FieldName3UsedForMatch);

                DataTable predictedObservedData = dataStore.RunQuery(query.ToString());

                if (predictedObservedData != null)
                    dataStore.WriteTable(null, this.Name, predictedObservedData);
                dataStore.Disconnect();
            }
        }