コード例 #1
0
        private void ParsePlanVersion(XmlReader rdr, WellInfo wi, string planName)
        {
            while (rdr.Read())
            {
                if (rdr.IsStartElement())
                {
                    if (rdr.Name == "VersionInfo")
                    {
                        PlanVersionInfo pvi = new PlanVersionInfo
                        {
                            PlanName      = planName,
                            VersionName   = rdr.GetAttribute("versionName"),
                            Comment       = rdr.GetAttribute("comment"),
                            IsCurrentPlan = false
                        };

                        DateTime.TryParse(rdr.GetAttribute("versionDateCreated"), out var creationDate);
                        pvi.CreationDate = creationDate;

                        bool.TryParse(rdr.GetAttribute("isDefinitivePlan"), out bool isDefinitivePlan);
                        pvi.IsDefinitivePlan = isDefinitivePlan;

                        wi.PlanVersionList.Add(pvi);
                    }
                }
            }
        }
コード例 #2
0
        private List <PlanVersionInfo> GetPlanDataByWellID(int wellID)
        {
            var recordList = new List <PlanVersionInfo>();

            using (var conn = new SQLiteConnection(ConnectionString, true))
            {
                conn.Open();

                using (var cmd = new SQLiteCommand(conn))
                {
                    cmd.CommandText = "SELECT * FROM [PlanVersions]  WHERE [WellID]=$wellID ORDER BY [CreationDate] DESC, [VersionName] DESC ";
                    cmd.Parameters.AddWithValue("$wellID", wellID);

                    using (var rdr = cmd.ExecuteReader())
                    {
                        while (rdr.Read())
                        {
                            var record = new PlanVersionInfo
                            {
                                PlanName         = rdr["PlanName"].ToString(),
                                VersionName      = rdr["VersionName"].ToString(),
                                Comment          = rdr["Comment"].ToString(),
                                CreationDate     = DateTime.Parse(rdr["CreationDate"].ToString()),
                                IsCurrentPlan    = Convert.ToInt32(rdr["IsCurrent"]) != 0,
                                IsDefinitivePlan = Convert.ToInt32(rdr["IsDefinitive"]) != 0
                            };

                            recordList.Add(record);
                        }
                    }
                }
            }
            return(recordList);
        }