From 62aecf38e35a8a7fe14a4c8167441ae785cd6681 Mon Sep 17 00:00:00 2001
From: lx <ex_lixiang17@cosl.com.cn>
Date: 星期四, 17 七月 2025 17:36:34 +0800
Subject: [PATCH] upload

---
 ErrorAnalysis.UI/ErrorAnalysis.UI.csproj |    1 
 ErrorAnalysis.Service/ErrorRatioCalc.cs  |    2 
 ErrorAnalysis.UI/FrmMain.cs              |  308 +++++++++++++++++++++++++++++++++++++------
 ErrorAnalysis.UI/FrmMain.Designer.cs     |   35 +++-
 ErrorAnalysis.UI/Utility/UnitConvert.cs  |   19 ++
 5 files changed, 304 insertions(+), 61 deletions(-)

diff --git a/ErrorAnalysis.Service/ErrorRatioCalc.cs b/ErrorAnalysis.Service/ErrorRatioCalc.cs
index 9f0c95b..3adf1d7 100644
--- a/ErrorAnalysis.Service/ErrorRatioCalc.cs
+++ b/ErrorAnalysis.Service/ErrorRatioCalc.cs
@@ -10,7 +10,7 @@
 {
     public class ErrorRatioCalc
     {
-        public static ErrorRatioResult GetErrorRatioResultLockSpeed(string modelID, double porosity, double sw, double depth, bool lockSpeed, double speed, double targetErrorRatio, int pass = 0)
+        public static ErrorRatioResult GetErrorRatioResult(string modelID, double porosity, double sw, double depth, bool lockSpeed, double speed, double targetErrorRatio, int pass = 0)
         {
             var result = new ErrorRatioResult
             {
diff --git a/ErrorAnalysis.UI/ErrorAnalysis.UI.csproj b/ErrorAnalysis.UI/ErrorAnalysis.UI.csproj
index 6c7349f..ca170d0 100644
--- a/ErrorAnalysis.UI/ErrorAnalysis.UI.csproj
+++ b/ErrorAnalysis.UI/ErrorAnalysis.UI.csproj
@@ -10,6 +10,7 @@
 
   <ItemGroup>
     <ProjectReference Include="..\ErrorAnalysis.Repository\ErrorAnalysis.Repository.csproj" />
+    <ProjectReference Include="..\ErrorAnalysis.Service\ErrorAnalysis.Service.csproj" />
   </ItemGroup>
 
   <ItemGroup>
diff --git a/ErrorAnalysis.UI/FrmMain.Designer.cs b/ErrorAnalysis.UI/FrmMain.Designer.cs
index d84f462..070ee79 100644
--- a/ErrorAnalysis.UI/FrmMain.Designer.cs
+++ b/ErrorAnalysis.UI/FrmMain.Designer.cs
@@ -104,7 +104,7 @@
             label36 = new Label();
             label35 = new Label();
             tpFormation = new TabPage();
-            nudReserviorSalinity = new NumericUpDown();
+            nudReservoirSalinity = new NumericUpDown();
             label40 = new Label();
             label41 = new Label();
             label43 = new Label();
@@ -151,7 +151,7 @@
             ((System.ComponentModel.ISupportInitialize)nudGravelFIllPercent).BeginInit();
             ((System.ComponentModel.ISupportInitialize)nudCementBond).BeginInit();
             tpFormation.SuspendLayout();
-            ((System.ComponentModel.ISupportInitialize)nudReserviorSalinity).BeginInit();
+            ((System.ComponentModel.ISupportInitialize)nudReservoirSalinity).BeginInit();
             ((System.ComponentModel.ISupportInitialize)nudVSH).BeginInit();
             ((System.ComponentModel.ISupportInitialize)nudSw).BeginInit();
             ((System.ComponentModel.ISupportInitialize)nudPorosity).BeginInit();
@@ -170,7 +170,7 @@
             btnAnalysis.TabIndex = 0;
             btnAnalysis.Text = "Analysis";
             btnAnalysis.UseVisualStyleBackColor = true;
-            btnAnalysis.Click += btnGetAllPipe_Click;
+            btnAnalysis.Click += btnAnalysis_Click;
             // 
             // label9
             // 
@@ -632,6 +632,8 @@
             cmbScreenHoldUp.Name = "cmbScreenHoldUp";
             cmbScreenHoldUp.Size = new Size(59, 25);
             cmbScreenHoldUp.TabIndex = 1;
+            cmbScreenHoldUp.Tag = "ScreenFluid";
+            cmbScreenHoldUp.SelectedIndexChanged += holdUp_cmb_SelectedIndexChanged;
             // 
             // label44
             // 
@@ -651,6 +653,8 @@
             cmbTubeHoldUp.Name = "cmbTubeHoldUp";
             cmbTubeHoldUp.Size = new Size(59, 25);
             cmbTubeHoldUp.TabIndex = 1;
+            cmbTubeHoldUp.Tag = "TubeFluid";
+            cmbTubeHoldUp.SelectedIndexChanged += holdUp_cmb_SelectedIndexChanged;
             // 
             // cmbCasingHoldUp
             // 
@@ -661,6 +665,8 @@
             cmbCasingHoldUp.Name = "cmbCasingHoldUp";
             cmbCasingHoldUp.Size = new Size(58, 25);
             cmbCasingHoldUp.TabIndex = 1;
+            cmbCasingHoldUp.Tag = "CasingFluid";
+            cmbCasingHoldUp.SelectedIndexChanged += holdUp_cmb_SelectedIndexChanged;
             // 
             // label38
             // 
@@ -868,6 +874,7 @@
             nudCementBond.Name = "nudCementBond";
             nudCementBond.Size = new Size(55, 23);
             nudCementBond.TabIndex = 26;
+            nudCementBond.Value = new decimal(new int[] { 100, 0, 0, 0 });
             // 
             // cmbTubeOD
             // 
@@ -927,7 +934,7 @@
             // 
             // tpFormation
             // 
-            tpFormation.Controls.Add(nudReserviorSalinity);
+            tpFormation.Controls.Add(nudReservoirSalinity);
             tpFormation.Controls.Add(label40);
             tpFormation.Controls.Add(label41);
             tpFormation.Controls.Add(label43);
@@ -948,14 +955,14 @@
             tpFormation.Text = "Formation";
             tpFormation.UseVisualStyleBackColor = true;
             // 
-            // nudReserviorSalinity
+            // nudReservoirSalinity
             // 
-            nudReserviorSalinity.DecimalPlaces = 1;
-            nudReserviorSalinity.Increment = new decimal(new int[] { 5, 0, 0, 65536 });
-            nudReserviorSalinity.Location = new Point(146, 118);
-            nudReserviorSalinity.Name = "nudReserviorSalinity";
-            nudReserviorSalinity.Size = new Size(71, 23);
-            nudReserviorSalinity.TabIndex = 34;
+            nudReservoirSalinity.DecimalPlaces = 1;
+            nudReservoirSalinity.Increment = new decimal(new int[] { 5, 0, 0, 65536 });
+            nudReservoirSalinity.Location = new Point(146, 118);
+            nudReservoirSalinity.Name = "nudReservoirSalinity";
+            nudReservoirSalinity.Size = new Size(71, 23);
+            nudReservoirSalinity.TabIndex = 34;
             // 
             // label40
             // 
@@ -1065,6 +1072,8 @@
             cmbLithology.Name = "cmbLithology";
             cmbLithology.Size = new Size(119, 25);
             cmbLithology.TabIndex = 25;
+            cmbLithology.Tag = "Lithology";
+            cmbLithology.SelectedIndexChanged += cmbLithology_SelectedIndexChanged;
             // 
             // label16
             // 
@@ -1240,7 +1249,7 @@
             ((System.ComponentModel.ISupportInitialize)nudCementBond).EndInit();
             tpFormation.ResumeLayout(false);
             tpFormation.PerformLayout();
-            ((System.ComponentModel.ISupportInitialize)nudReserviorSalinity).EndInit();
+            ((System.ComponentModel.ISupportInitialize)nudReservoirSalinity).EndInit();
             ((System.ComponentModel.ISupportInitialize)nudVSH).EndInit();
             ((System.ComponentModel.ISupportInitialize)nudSw).EndInit();
             ((System.ComponentModel.ISupportInitialize)nudPorosity).EndInit();
@@ -1312,7 +1321,7 @@
         private Label label39;
         private Label label38;
         private ComboBox cmbCasingHoldUp;
-        private NumericUpDown nudReserviorSalinity;
+        private NumericUpDown nudReservoirSalinity;
         private Label label40;
         private Label label41;
         private Label label43;
diff --git a/ErrorAnalysis.UI/FrmMain.cs b/ErrorAnalysis.UI/FrmMain.cs
index d6a053c..7e35121 100644
--- a/ErrorAnalysis.UI/FrmMain.cs
+++ b/ErrorAnalysis.UI/FrmMain.cs
@@ -1,5 +1,8 @@
 using ErrorAnalysis.Repository;
 using ErrorAnalysis.Repository.Entity;
+using ErrorAnalysis.Service;
+using System.ComponentModel.DataAnnotations;
+using System.Windows.Forms;
 using static System.Windows.Forms.VisualStyles.VisualStyleElement.Menu;
 
 namespace ErrorAnalysis.UI
@@ -8,16 +11,15 @@
     {
         private string? _connectionString;
         private List<COModelTable> _models;
-        private COModelTable? _curModel;
+        private Dictionary<string, string> _filters;
+        private COModelTable _model;
+
         public FrmMain()
         {
             InitializeComponent();
         }
-        private void btnGetAllPipe_Click(object sender, EventArgs e)
-        {
-            var modelRepository = new COModelRepository(_connectionString);
-            var models = modelRepository.GetCOModels();
-        }
+
+
 
         private void rdoMode_CheckedChanged(object sender, EventArgs e)
         {
@@ -46,10 +48,11 @@
                 pbLoadDB.Show();
                 pbLoadDB.Value = 0;
                 txtDataPath.Text = fileDlg.FileName;
-                txtToolType.Text = fileDlg.SafeFileName.Replace("DB.db", "").Replace("Mcnp", "");
+                txtToolType.Text = fileDlg.SafeFileName.Substring(0, fileDlg.SafeFileName.IndexOf("Mcnp"));
                 _connectionString = $"Data Source={fileDlg.FileName};";
                 var modelRepository = new COModelRepository(_connectionString);
                 pbLoadDB.Value = 50;
+                _filters = new Dictionary<string, string>();
                 Task.Run(() =>
                 {
                     _models = modelRepository.GetCOModels();
@@ -73,9 +76,69 @@
             }
         }
 
+        private void btnAnalysis_Click(object sender, EventArgs e)
+        {
+            var curModels = GetFilterResult();
+            if (curModels == null || curModels.Count == 0)
+            {
+                MessageBox.Show("Please enter info!");
+                return;
+            }
+
+            if (!double.TryParse(nudPorosity.Value.ToString(), out double porosity) || nudPorosity.Value < 5)
+            {
+                MessageBox.Show("Please enter a reasonable porosity");
+                return;
+            }
+
+            if (!double.TryParse(nudSw.Value.ToString(), out double sw))
+            {
+                MessageBox.Show("Please enter a reasonable water saturation!");
+                return;
+            }
+
+            if (!double.TryParse(nudDepth.Value.ToString(), out double depth) || nudDepth.Value <= 0)
+            {
+                MessageBox.Show("Please enter a reasonable depth");
+                return;
+            }
+
+            if (cmbLithology.SelectedIndex == -1)
+            {
+                MessageBox.Show("Please select a lithology");
+                return;
+            }
+
+            if (curModels.Count == 1)
+                _model = curModels[0];
+            _model = curModels.FirstOrDefault(m => m.GravelFillPercent == nudGravelFIllPercent.Value.ToString());
+            if (_model == null)
+            {
+
+            }
+            if (rdoLockSpeed.Checked)
+            {
+                if (!double.TryParse(nudSpeed.Value.ToString(), out double speed) || nudSpeed.Value <= 0)
+                {
+                    MessageBox.Show("Please enter a reasonable speed");
+                    return;
+                }
+
+            }
+            else
+            {
+                if (!int.TryParse(nudPass.Value.ToString(), out int pass) || nudPass.Value <= 1)
+                {
+                    MessageBox.Show("Please enter a reasonable pass");
+                    return;
+                }
+
+            }
+        }
         private void FrmMain_Load(object sender, EventArgs e)
         {
             cmbSpeedUnit.SelectedIndex = 0;
+            cmbTargetLoggingIntervalUnit.SelectedIndex = 0;
         }
 
         private void InitInputControl()
@@ -90,70 +153,221 @@
             }
         }
 
-        private void btnSelectBore_Click(object sender, EventArgs e)
-        {
-            if (string.IsNullOrEmpty(_connectionString))
-            {
-                MessageBox.Show("Please choose data source first!");
-                return;
-            }
-        }
-
         private void borehole_cmb_SelectedIndexChanged(object sender, EventArgs e)
         {
             var control = (sender as ComboBox);
+            var property = control.Tag.ToString();
+
+            var filterVal = control.Text == "none" ? "0" : control.Text;
+
+            if (_filters.ContainsKey(property))
+                _filters[property] = filterVal;
+            else
+                _filters.Add(property, filterVal);
 
             var parentControl = control.Parent;
             var allCmb = parentControl.Controls.OfType<Control>().Where(c => c is ComboBox).Select(c => c as ComboBox).ToList();
-            if (control.Name == "cmbBit")
+            switch (control.Name)
             {
-                foreach (var item in allCmb)
-                {
-                    if (item.Name != "cmbBit")
-                    {
-                        item.Items.Clear();
-                    }
-                }
+                case "cmbBit":
+                    cmbCasingOD.Items.Clear();
+                    goto case "cmbCasingOD";
+                case "cmbCasingOD":
+                    cmbCasingID.Items.Clear();
+                    goto case "cmbCasingID";
+                case "cmbCasingID":
+                    cmbScreenOD.Items.Clear();
+                    goto case "cmbScreenOD";
+                case "cmbScreenOD":
+                    cmbScreenID.Items.Clear();
+                    goto case "cmbScreenID";
+                case "cmbScreenID":
+                    cmbTubeOD.Items.Clear();
+                    goto case "cmbTubeOD";
+                case "cmbTubeOD":
+                    cmbTubeID.Items.Clear();
+                    break;
+                case "cmbTubeID":
+                    break;
+                default:
+                    break;
             }
-            else if (control.Name.Contains("OD"))
-            {
-                allCmb.FirstOrDefault(a => a.Name == control.Name.Replace("OD", "ID")).Items.Clear();
-            }
-            else if (control.Name == "cmbCasingID")
-            {
-                cmbScreenOD.Items.Clear();
-                cmbScreenID.Items.Clear();
-                cmbTubeOD.Items.Clear();
-                cmbTubeID.Items.Clear();
-            }
-            var selectedCmbs = allCmb.Where(c => c.SelectedIndex != -1).ToList();
-            var unSelectedCmbs = allCmb.Where(c => c.SelectedIndex == -1).ToList();
-            var selectedModels = _models;
-            var modelType = _models[0].GetType();
 
-            foreach (var cmb in selectedCmbs)
-            {
-                selectedModels = selectedModels.Where(c => modelType.GetProperty(cmb.Tag.ToString()).GetValue(c).ToString() == cmb.Text).ToList();
-            }
+            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 currentItems = selectedModels.Where(c => modelType.GetProperty(cmb.Tag.ToString()).GetValue(c).ToString() != "0").Select(c => modelType.GetProperty(cmb.Tag.ToString()).GetValue(c).ToString()).Distinct().ToArray();
+                var currentItems = curModels.Select(c => modelType.GetProperty(cmb.Tag.ToString()).GetValue(c).ToString() == "0" ? "none" : modelType.GetProperty(cmb.Tag.ToString()).GetValue(c).ToString()).Distinct().ToArray();
                 if (currentItems.Length == 0)
                     cmb.Enabled = false;
-
 
                 cmb.Items.AddRange(currentItems);
                 if (currentItems.Length == 1)
                     cmb.Text = currentItems[0];
             }
 
-            if (selectedModels.Count == 1)
+            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()
+        {
+            var curModels = GetFilterResult();
+            if (curModels.Count == 0)
+                return;
+
+            var gravelFills = curModels.Select(x => x.GravelFillPercent).Distinct().ToArray();
+            if (gravelFills.Length == 1)
+                nudGravelFIllPercent.Value = Convert.ToDecimal(gravelFills[0]);
+
+            var cementBonds = curModels.Select(x => x.CementBond).Distinct().ToArray();
+            if (cementBonds.Length == 1)
+                nudCementBond.Value = Convert.ToDecimal(cementBonds[0]);
+
+            var bhSalinities = curModels.Select(x => x.BHSalinity).Distinct().ToArray();
+            if (bhSalinities.Length == 1)
+                nudBHSalinity.Value = Convert.ToDecimal(bhSalinities[0]);
+
+            var oilDensities = curModels.Select(x => x.OilDensity).Distinct().ToArray();
+            if (oilDensities.Length == 1)
+                nudOilDensity.Value = Convert.ToDecimal(oilDensities[0]);
+
+            var reservoirSalinities = curModels.Select(x => x.ReservoirSalinity).Distinct().ToArray();
+            if (reservoirSalinities.Length == 1)
+                nudReservoirSalinity.Value = Convert.ToDecimal(reservoirSalinities[0]);
+
+            var vshs = curModels.Select(x => x.VSH).Distinct().ToArray();
+            if (vshs.Length == 1)
+                nudVSH.Value = Convert.ToDecimal(vshs[0]);
+
+
+            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")
             {
-                _curModel = selectedModels[0];
+                cmbCasingHoldUp.Items.Clear();
+                cmbCasingHoldUp.Enabled = false;
+                nudCasingHoldUp.Enabled = false;
             }
+            else
+            {
+                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;
+            }
+            else
+            {
+                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;
+            }
+            else
+            {
+                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];
+        }
+
+        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 cmbLithology_SelectedIndexChanged(object sender, EventArgs e)
+        {
+            var control = (sender as ComboBox);
+            var property = control.Tag.ToString();
+
+            var filterVal = control.Text == "none" ? "0" : control.Text;
+
+            if (_filters.ContainsKey(property))
+                _filters[property] = filterVal;
+            else
+                _filters.Add(property, filterVal);
         }
     }
 }
diff --git a/ErrorAnalysis.UI/Utility/UnitConvert.cs b/ErrorAnalysis.UI/Utility/UnitConvert.cs
new file mode 100644
index 0000000..bedc825
--- /dev/null
+++ b/ErrorAnalysis.UI/Utility/UnitConvert.cs
@@ -0,0 +1,19 @@
+锘縰sing System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace ErrorAnalysis.UI.Utility
+{
+    public class UnitConvert
+    {
+        public static double Ft2M(double val) => val / 3.281;
+
+        public static double M2Ft(double val) => val * 3.281;
+
+        public static double FtHr2MMin(double val) => val / 3.281 * 60;
+
+        public static double MHR2MMin(double val) => val * 60;
+    }
+}

--
Gitblit v1.9.3