From cb764c0d0bbd76a3fd14c440e7dc0db612bb8244 Mon Sep 17 00:00:00 2001
From: lx <ex_lixiang17@cosl.com.cn>
Date: 星期二, 22 七月 2025 08:57:24 +0800
Subject: [PATCH] version1

---
 ErrorAnalysis.UI/FrmMain.cs |  346 +++++++++++++++++++++++++++++++++++++++++----------------
 1 files changed, 250 insertions(+), 96 deletions(-)

diff --git a/ErrorAnalysis.UI/FrmMain.cs b/ErrorAnalysis.UI/FrmMain.cs
index 7e35121..ec123bf 100644
--- a/ErrorAnalysis.UI/FrmMain.cs
+++ b/ErrorAnalysis.UI/FrmMain.cs
@@ -1,7 +1,15 @@
 using ErrorAnalysis.Repository;
 using ErrorAnalysis.Repository.Entity;
 using ErrorAnalysis.Service;
+using ErrorAnalysis.Service.Model;
+using ErrorAnalysis.UI.Utility;
+using OxyPlot;
+using OxyPlot.Axes;
+using OxyPlot.Legends;
+using OxyPlot.Series;
+using OxyPlot.WindowsForms;
 using System.ComponentModel.DataAnnotations;
+using System.Security.Cryptography;
 using System.Windows.Forms;
 using static System.Windows.Forms.VisualStyles.VisualStyleElement.Menu;
 
@@ -18,23 +26,24 @@
         {
             InitializeComponent();
         }
-
-
-
-        private void rdoMode_CheckedChanged(object sender, EventArgs e)
+        private void FrmMain_Load(object sender, EventArgs e)
         {
-            if (rdoLockSpeed.Checked)
+            cmbSpeedUnit.SelectedIndex = 0;
+            cmbTargetLoggingIntervalUnit.SelectedIndex = 0;
+        }
+        private void InitInputControl()
+        {
+            foreach (var item in gpBorehole.Controls)
+                if (item is ComboBox cmb)
+                    cmb.Items.Clear();
+
+            if (_models != null)
             {
-                pnlLockPass.Visible = false;
-                pnlLockSpeed.Visible = true;
-            }
-            else
-            {
-                pnlLockPass.Visible = true;
-                pnlLockSpeed.Visible = false;
+                cmbBit.Items.AddRange(_models.Select(m => m.BIT).Distinct().ToArray());
             }
         }
 
+        #region button event
         private void btnSelectDataSource_Click(object sender, EventArgs e)
         {
             var fileDlg = new OpenFileDialog();
@@ -50,12 +59,13 @@
                 txtDataPath.Text = fileDlg.FileName;
                 txtToolType.Text = fileDlg.SafeFileName.Substring(0, fileDlg.SafeFileName.IndexOf("Mcnp"));
                 _connectionString = $"Data Source={fileDlg.FileName};";
-                var modelRepository = new COModelRepository(_connectionString);
+                RepositoryInstance.Instance.ReLoad(_connectionString);
+
                 pbLoadDB.Value = 50;
                 _filters = new Dictionary<string, string>();
                 Task.Run(() =>
                 {
-                    _models = modelRepository.GetCOModels();
+                    _models = RepositoryInstance.Instance.COModelRepository.GetCOModels();
                     BeginInvoke(new System.Action(() =>
                     {
                         pbLoadDB.Value = 80;
@@ -103,9 +113,26 @@
                 return;
             }
 
+            if (!double.TryParse(nudSoPrecisionRequired.Value.ToString(), out double targetErrorRatio) || nudSoPrecisionRequired.Value <= 0)
+            {
+                MessageBox.Show("Please enter a reasonable so precision required");
+                return;
+            }
+
+            if (!double.TryParse(nudTargetLoggingInterval.Value.ToString(), out double targetLoggingInterval) || nudTargetLoggingInterval.Value <= 0)
+            {
+                MessageBox.Show("Please select a target logging interval");
+                return;
+            }
+
             if (cmbLithology.SelectedIndex == -1)
             {
                 MessageBox.Show("Please select a lithology");
+                return;
+            }
+            if (curModels.Count == 0)
+            {
+                MessageBox.Show("Parameters error!");
                 return;
             }
 
@@ -113,9 +140,11 @@
                 _model = curModels[0];
             _model = curModels.FirstOrDefault(m => m.GravelFillPercent == nudGravelFIllPercent.Value.ToString());
             if (_model == null)
-            {
+                _model = curModels.First();
 
-            }
+            if (cmbTargetLoggingIntervalUnit.Text == "ft")
+                targetLoggingInterval = UnitConvert.Ft2M(targetLoggingInterval);
+
             if (rdoLockSpeed.Checked)
             {
                 if (!double.TryParse(nudSpeed.Value.ToString(), out double speed) || nudSpeed.Value <= 0)
@@ -123,7 +152,13 @@
                     MessageBox.Show("Please enter a reasonable speed");
                     return;
                 }
+                var calcSpeed = cmbSpeedUnit.Text == "ft/hr" ? UnitConvert.FtHr2MMin(speed) : UnitConvert.MHR2MMin(speed);
 
+                var result = ErrorRatioCalc.GetErrorRatioResult(_model.ModelID, porosity, sw, depth, true, calcSpeed, targetErrorRatio / 100, out _);
+                Plot(result);
+
+                double totalTime = Math.Round((targetLoggingInterval / calcSpeed / 60), 2);
+                txtAnalysisResult.Text = $"A total of {result.ErrorRatios.Count} passes are recommended to maintain a {Math.Round(result.ErrorRatios.Min(r => r.ErrorRatioValue) * 100, 2)}% error rate. With the tool operating at {speed} {cmbSpeedUnit.Text}, the estimated total job duration is {totalTime.ToString()} hours.";
             }
             else
             {
@@ -132,27 +167,18 @@
                     MessageBox.Show("Please enter a reasonable pass");
                     return;
                 }
+                double speed;
+                var result = ErrorRatioCalc.GetErrorRatioResult(_model.ModelID, porosity, sw, depth, false, 0, targetErrorRatio / 100, out speed, pass);
+                Plot(result);
 
+                double totalTime = Math.Round((targetLoggingInterval / speed / 60), 2);
+                txtAnalysisResult.Text = $"A total of {result.ErrorRatios.Count} passes are recommended to maintain a {Math.Round(result.ErrorRatios.Min(r => r.ErrorRatioValue) * 100, 2)}% error rate. With the tool operating at {Math.Round(UnitConvert.MMin2FtHr(speed), 2)} ft/hr, the estimated total job duration is {totalTime.ToString()} hours.";
             }
-        }
-        private void FrmMain_Load(object sender, EventArgs e)
-        {
-            cmbSpeedUnit.SelectedIndex = 0;
-            cmbTargetLoggingIntervalUnit.SelectedIndex = 0;
-        }
 
-        private void InitInputControl()
-        {
-            foreach (var item in gpBorehole.Controls)
-                if (item is ComboBox cmb)
-                    cmb.Items.Clear();
-
-            if (_models != null)
-            {
-                cmbBit.Items.AddRange(_models.Select(m => m.BIT).Distinct().ToArray());
-            }
         }
+        #endregion
 
+        #region Input event
         private void borehole_cmb_SelectedIndexChanged(object sender, EventArgs e)
         {
             var control = (sender as ComboBox);
@@ -171,27 +197,41 @@
             {
                 case "cmbBit":
                     cmbCasingOD.Items.Clear();
+                    _filters.Remove("CasingOD");
                     goto case "cmbCasingOD";
                 case "cmbCasingOD":
                     cmbCasingID.Items.Clear();
+                    _filters.Remove("CasingID");
                     goto case "cmbCasingID";
                 case "cmbCasingID":
                     cmbScreenOD.Items.Clear();
+                    _filters.Remove("ScreenOD");
                     goto case "cmbScreenOD";
                 case "cmbScreenOD":
                     cmbScreenID.Items.Clear();
+                    _filters.Remove("ScreenID");
                     goto case "cmbScreenID";
                 case "cmbScreenID":
                     cmbTubeOD.Items.Clear();
+                    _filters.Remove("TubeOD");
                     goto case "cmbTubeOD";
                 case "cmbTubeOD":
                     cmbTubeID.Items.Clear();
+                    _filters.Remove("TubeID");
                     break;
                 case "cmbTubeID":
                     break;
                 default:
                     break;
             }
+            cmbCasingHoldUp.Items.Clear();
+            _filters.Remove("CasingFluid");
+            cmbScreenHoldUp.Items.Clear();
+            _filters.Remove("ScreenFluid");
+            cmbTubeHoldUp.Items.Clear();
+            _filters.Remove("TubeFluid");
+            cmbLithology.Items.Clear();
+            _filters.Remove("Lithology");
 
             var unSelectedCmbs = allCmb.Where(c => c.SelectedIndex == -1).ToList();
             var curModels = GetFilterResult();
@@ -206,60 +246,24 @@
                     cmb.Enabled = false;
 
                 cmb.Items.AddRange(currentItems);
+
                 if (currentItems.Length == 1)
                     cmb.Text = currentItems[0];
+
             }
 
             LinkageModelProperty();
         }
-
-        private void holdUp_cmb_SelectedIndexChanged(object sender, EventArgs e)
-        {
-            var control = (sender as ComboBox);
-
-            var parentControl = control.Parent;
-
-            var property = control.Tag.ToString();
-            var filterVal = control.Text == "water" ? "0" : control.Text == "oil" ? "100" : control.Text == "gas" ? "200" : "999";
-            if (_filters.ContainsKey(property))
-                _filters[property] = filterVal;
-            else
-                _filters.Add(property, filterVal);
-
-            var curModels = GetFilterResult();
-
-            var allCmb = parentControl.Controls.OfType<Control>().Where(c => c is ComboBox).Select(c => c as ComboBox).ToList();
-
-            var modelType = typeof(COModelTable);
-
-            //foreach (var cmb in allCmb)
-            //{
-            //    if (cmb.Name != control.Name)
-            //    {
-            //        var curItems = cmb.Items.OfType<string>().ToList();
-            //        var cmbProperty = modelType.GetProperty(cmb.Tag.ToString());
-            //        var curFluids = curModels.Select(x => cmbProperty.GetValue(x).ToString() == "0" ? "water" : cmbProperty.GetValue(x).ToString() == "100" ? "oil" : cmbProperty.GetValue(x).ToString() == "200" ? "gas" : "none").Distinct().ToArray();
-            //        var minusFluids = curItems.Where(i => !curFluids.Contains(i)).ToArray();
-            //        foreach (var item in minusFluids)
-            //            cmb.Items.Remove(item);
-            //        var addFluids = curFluids.Where(i => !curItems.Contains(i)).ToArray();
-            //        cmb.Items.AddRange(addFluids);
-
-            //    }
-            //}
-
-            var lithology = curModels.Select(x => x.Lithology).Distinct().ToArray();
-            var curLithology = cmbLithology.Text;
-            cmbLithology.Items.Clear();
-            cmbLithology.Items.AddRange(lithology);
-            cmbLithology.Text = curLithology;
-
-            if (lithology.Length == 1)
-                cmbLithology.Text = lithology[0];
-        }
-
         private void LinkageModelProperty()
         {
+            cmbCasingHoldUp.Items.Clear();
+            _filters.Remove("CasingFluid");
+            cmbScreenHoldUp.Items.Clear();
+            _filters.Remove("ScreenFluid");
+            cmbTubeHoldUp.Items.Clear();
+            _filters.Remove("TubeFluid");
+            cmbLithology.Items.Clear();
+            _filters.Remove("Lithology");
             var curModels = GetFilterResult();
             if (curModels.Count == 0)
                 return;
@@ -290,9 +294,9 @@
 
 
             var casingFulids = curModels.Select(x => x.CasingFluid == "0" ? "water" : x.CasingFluid == "100" ? "oil" : x.CasingFluid == "200" ? "gas" : "none").Distinct().ToArray();
+
             if (casingFulids.Length == 1 && casingFulids[0] == "999")
             {
-                cmbCasingHoldUp.Items.Clear();
                 cmbCasingHoldUp.Enabled = false;
                 nudCasingHoldUp.Enabled = false;
             }
@@ -301,14 +305,13 @@
                 cmbCasingHoldUp.Enabled = true;
                 nudCasingHoldUp.Enabled = true;
 
-                cmbCasingHoldUp.Items.Clear();
                 cmbCasingHoldUp.Items.AddRange(casingFulids);
             }
 
             var screenFulids = curModels.Select(x => x.ScreenFluid == "0" ? "water" : x.ScreenFluid == "100" ? "oil" : x.ScreenFluid == "200" ? "gas" : "none").Distinct().ToArray();
+
             if (screenFulids.Length == 1 && screenFulids[0] == "none")
             {
-                cmbScreenHoldUp.Items.Clear();
                 cmbScreenHoldUp.Enabled = false;
                 nudScreenHoldUp.Enabled = false;
             }
@@ -316,15 +319,12 @@
             {
                 cmbScreenHoldUp.Enabled = true;
                 nudScreenHoldUp.Enabled = true;
-                cmbScreenHoldUp.Items.Clear();
                 cmbScreenHoldUp.Items.AddRange(screenFulids);
             }
 
             var tubeFluids = curModels.Select(x => x.TubeFluid == "0" ? "water" : x.TubeFluid == "100" ? "oil" : x.TubeFluid == "200" ? "gas" : "none").Distinct().ToArray();
             if (tubeFluids.Length == 1 && tubeFluids[0] == "none")
             {
-
-                cmbTubeHoldUp.Items.Clear();
                 cmbTubeHoldUp.Enabled = false;
                 nudTubeHoldUp.Enabled = false;
             }
@@ -332,31 +332,95 @@
             {
                 cmbTubeHoldUp.Enabled = true;
                 nudTubeHoldUp.Enabled = true;
-
-                cmbTubeHoldUp.Items.Clear();
                 cmbTubeHoldUp.Items.AddRange(tubeFluids);
             }
 
             var lithology = curModels.Select(x => x.Lithology).Distinct().ToArray();
             var curLithology = cmbLithology.Text;
-            cmbLithology.Items.Clear();
             cmbLithology.Items.AddRange(lithology);
             cmbLithology.Text = curLithology;
 
             if (lithology.Length == 1)
-                cmbLithology.Text = lithology[0];
+                cmbLithology.SelectedIndex = 0;
         }
-
-        private List<COModelTable> GetFilterResult()
+        private void holdUp_cmb_SelectedIndexChanged(object sender, EventArgs e)
         {
-            var type = typeof(COModelTable);
-            var result = _models;
-            foreach (var filter in _filters)
-                result = result.Where(c => type.GetProperty(filter.Key).GetValue(c).ToString() == filter.Value).ToList();
+            var control = (sender as ComboBox);
 
-            return result;
+            var parentControl = control.Parent;
+
+            var property = control.Tag.ToString();
+            var filterVal = control.Text == "water" ? "0" : control.Text == "oil" ? "100" : control.Text == "gas" ? "200" : "999";
+            if (_filters.ContainsKey(property))
+                _filters[property] = filterVal;
+            else
+                _filters.Add(property, filterVal);
+
+            var allCmb = parentControl.Controls.OfType<Control>().Where(c => c is ComboBox).Select(c => c as ComboBox).ToList();
+            switch (control.Name)
+            {
+                case "cmbCasingHoldUp":
+                    cmbScreenHoldUp.Items.Clear();
+                    _filters.Remove("ScreenFluid");
+                    goto case "cmbScreenHoldUp";
+                case "cmbScreenHoldUp":
+                    cmbTubeHoldUp.Items.Clear();
+                    _filters.Remove("TubeFluid");
+                    break;
+                default:
+                    break;
+            }
+            var unSelectedCmbs = allCmb.Where(c => c.SelectedIndex == -1).ToList();
+            var curModels = GetFilterResult();
+            var modelType = typeof(COModelTable);
+
+            foreach (var cmb in unSelectedCmbs)
+            {
+                cmb.Items.Clear();
+                cmb.Enabled = true;
+                var cmbProperty = modelType.GetProperty(cmb.Tag.ToString());
+                var currentItems = curModels.Select(c => cmbProperty.GetValue(c).ToString() == "0" ? "water" : cmbProperty.GetValue(c).ToString() == "100" ? "oil" : cmbProperty.GetValue(c).ToString() == "200" ? "gas" : "none").Distinct().ToArray();
+                if (currentItems.Length == 0 || (currentItems.Length == 1 && currentItems[0] == "none"))
+                {
+                    cmb.Enabled = false;
+                    continue;
+                }
+                cmb.Items.AddRange(currentItems);
+                if (_filters.ContainsKey(cmb.Tag.ToString()) && currentItems.Contains(_filters[cmb.Tag.ToString()]))
+                    cmb.Text = _filters[cmb.Tag.ToString()];
+                else
+                {
+                    _filters.Remove(cmb.Tag.ToString());
+                    if (currentItems.Length == 1)
+                        cmb.SelectedIndex = 0;
+                }
+
+            }
+            //foreach (var cmb in allCmb)
+            //{
+            //    if (cmb.Name != control.Name)
+            //    {
+            //        var curItems = cmb.Items.OfType<string>().ToList();
+            //        var cmbProperty = modelType.GetProperty(cmb.Tag.ToString());
+            //        var curFluids = curModels.Select(x => cmbProperty.GetValue(x).ToString() == "0" ? "water" : cmbProperty.GetValue(x).ToString() == "100" ? "oil" : cmbProperty.GetValue(x).ToString() == "200" ? "gas" : "none").Distinct().ToArray();
+            //        var minusFluids = curItems.Where(i => !curFluids.Contains(i)).ToArray();
+            //        foreach (var item in minusFluids)
+            //            cmb.Items.Remove(item);
+            //        var addFluids = curFluids.Where(i => !curItems.Contains(i)).ToArray();
+            //        cmb.Items.AddRange(addFluids);
+
+            //    }
+            //}
+
+            var lithology = curModels.Select(x => x.Lithology).Distinct().ToArray();
+            cmbLithology.Items.Clear();
+            cmbLithology.Items.AddRange(lithology);
+
+            if (_filters.ContainsKey("Lithology") && lithology.Contains(_filters["Lithology"]))
+                cmbLithology.Text = _filters["Lithology"];
+            else
+                _filters.Remove("Lithology");
         }
-
         private void cmbLithology_SelectedIndexChanged(object sender, EventArgs e)
         {
             var control = (sender as ComboBox);
@@ -369,5 +433,95 @@
             else
                 _filters.Add(property, filterVal);
         }
+        private void rdoMode_CheckedChanged(object sender, EventArgs e)
+        {
+            if (rdoLockSpeed.Checked)
+            {
+                pnlLockPass.Visible = false;
+                pnlLockSpeed.Visible = true;
+            }
+            else
+            {
+                pnlLockPass.Visible = true;
+                pnlLockSpeed.Visible = false;
+            }
+        }
+        #endregion
+
+        private List<COModelTable> GetFilterResult()
+        {
+            var type = typeof(COModelTable);
+            var result = _models;
+            foreach (var filter in _filters)
+                result = result.Where(c => type.GetProperty(filter.Key).GetValue(c).ToString() == filter.Value).ToList();
+
+            return result;
+        }
+
+        private void Plot(ErrorRatioResult errorResult)
+        {
+            pnlCOPic.Controls.Clear();
+            var plotModel = new PlotModel();
+
+            var xAxis = new LinearAxis { Position = AxisPosition.Bottom, Title = "Porosity(%)" };
+            var yAxis = new LinearAxis { Position = AxisPosition.Left, Title = "C/O" };
+            xAxis.MajorGridlineStyle = LineStyle.DashDashDotDot;
+            yAxis.MajorGridlineStyle = LineStyle.DashDot;
+
+            plotModel.Axes.Add(xAxis);
+            plotModel.Axes.Add(yAxis);
+
+            // 创建曲线系列
+            var oSeries = new LineSeries { Title = "Water Line", Color = OxyColors.MediumBlue };
+            var cSeries = new LineSeries { Title = "Oil Line", Color = OxyColors.DarkRed };
+
+            foreach (var o in errorResult.OWOL)
+                oSeries.Points.Add(new DataPoint(o[0], o[1]));
+            foreach (var c in errorResult.CWOL)
+                cSeries.Points.Add(new DataPoint(c[0], c[1]));
+
+            plotModel.Legends.Add(new Legend { LegendPosition = LegendPosition.TopLeft });
+            // 添加曲线到图表模型
+            plotModel.Series.Add(oSeries);
+            plotModel.Series.Add(cSeries);
+
+            // 可视化代码
+            // 创建 Windows 窗体以显示图表
+            var plotView = new PlotView { Model = plotModel };
+
+            plotView.Width = 600;
+            plotView.Height = 450;
+            var bitmap = new Bitmap(plotView.Width, plotView.Height);
+            plotView.DrawToBitmap(bitmap, new Rectangle(0, 0, bitmap.Width, bitmap.Height));
+            bitmap.Save(AppDomain.CurrentDomain.BaseDirectory + "co.png", System.Drawing.Imaging.ImageFormat.Png);
+
+            plotView.Dock = DockStyle.Fill;
+            pnlCOPic.Controls.Add(plotView);
+
+
+            pnlErrorRatioPic.Controls.Clear();
+            plotModel = new PlotModel();
+            xAxis = new LinearAxis { Position = AxisPosition.Bottom, Title = "Pass" };
+            xAxis.MajorGridlineStyle = LineStyle.Dash;
+            yAxis = new LinearAxis { Position = AxisPosition.Left, Title = "Error Ratio(%)" };
+            yAxis.MajorGridlineStyle = LineStyle.Dash;
+            plotModel.Axes.Add(xAxis);
+            plotModel.Axes.Add(yAxis);
+
+            var series = new LineSeries { Title = "Error Ratio", Color = OxyColors.DarkRed, MarkerType = MarkerType.Diamond };
+            foreach (var item in errorResult.ErrorRatios)
+                series.Points.Add(new DataPoint(item.Pass, item.ErrorRatioValue * 100));
+
+            plotModel.Series.Add(series);
+            plotView = new PlotView { Model = plotModel };
+
+            plotView.Width = 600;
+            plotView.Height = 450;
+            bitmap = new Bitmap(plotView.Width, plotView.Height);
+            plotView.DrawToBitmap(bitmap, new Rectangle(0, 0, bitmap.Width, bitmap.Height));
+            bitmap.Save(AppDomain.CurrentDomain.BaseDirectory + "er.png", System.Drawing.Imaging.ImageFormat.Png);
+            plotView.Dock = DockStyle.Fill;
+            pnlErrorRatioPic.Controls.Add(plotView);
+        }
     }
 }

--
Gitblit v1.9.3