upload

lx

2025-07-25 94ed3edb9e96c8bfa24d808dfc690cbd111a60e6

 ErrorAnalysis.UI/FrmMain.cs

@@ -21,28 +21,30 @@
        private List<COModelTable> _models;
        private Dictionary<string, string> _filters;
        private COModelTable _model;
        private ReportModel _reportModel;

        public FrmMain()
        {
            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();
@@ -84,7 +86,6 @@
                });
            }
        }

        private void btnAnalysis_Click(object sender, EventArgs e)
        {
            var curModels = GetFilterResult();
@@ -118,6 +119,12 @@
                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");
@@ -129,11 +136,25 @@
                return;
            }

            if (!decimal.TryParse(nudOilDensity.Value.ToString(), out decimal oilDensity) || nudOilDensity.Value <= 0)
            {
                MessageBox.Show("Please select a oil density");
                return;
            }

            if (curModels.Count == 1)
                _model = curModels[0];
            _model = curModels.FirstOrDefault(m => m.GravelFillPercent == nudGravelFIllPercent.Value.ToString());

            _model = curModels.FirstOrDefault(m => m.GravelFillPercent == nudGravelFIllPercent.Value.ToString() && m.OilDensity == oilDensity);

            if (_model == null)
                _model = curModels.First();

            nudOilDensity.Value = _model.OilDensity.Value;
            nudGravelFIllPercent.Value = Convert.ToDecimal(_model.GravelFillPercent);

            if (cmbTargetLoggingIntervalUnit.Text == "ft")
                targetLoggingInterval = UnitConvert.Ft2M(targetLoggingInterval);

            if (rdoLockSpeed.Checked)
            {
@@ -144,9 +165,13 @@
                }
                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);
                var result = ErrorRatioCalc.GetErrorRatioResult(_model.ModelID, porosity, sw, depth, true, calcSpeed, targetErrorRatio / 100, out _);
                Plot(result);

                double totalTime = Math.Round((targetLoggingInterval / calcSpeed / 60), 2);
                var errorRate = Math.Round(result.ErrorRatios.Min(r => r.ErrorRatioValue) * 100, 2);
                txtAnalysisResult.Text = $"A total of {result.ErrorRatios.Count} passes are recommended to maintain a {errorRate}% error rate. With the tool operating at {speed} {cmbSpeedUnit.Text}, the estimated total job duration is {totalTime.ToString()} hours.";
                _reportModel = CreateReportModel(totalTime.ToString(), result.ErrorRatios.Count.ToString(), Math.Round(UnitConvert.MMin2FtHr(calcSpeed), 2).ToString(), errorRate.ToString());
            }
            else
            {
@@ -155,27 +180,28 @@
                    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);
                var errorRate = Math.Round(result.ErrorRatios.Min(r => r.ErrorRatioValue) * 100, 2);
                var speedFr = Math.Round(UnitConvert.MMin2FtHr(speed), 2);

                txtAnalysisResult.Text = $"A total of {result.ErrorRatios.Count} passes are recommended to maintain a {errorRate}% error rate. With the tool operating at {speedFr} ft/hr, the estimated total job duration is {totalTime.ToString()} hours.";

                _reportModel = CreateReportModel(totalTime.ToString(), result.ErrorRatios.Count.ToString(), speedFr.ToString(), errorRate.ToString());
            }


        }
        private void FrmMain_Load(object sender, EventArgs e)
        private void btnReport_Click(object sender, EventArgs e)
        {
            cmbSpeedUnit.SelectedIndex = 0;
            cmbTargetLoggingIntervalUnit.SelectedIndex = 0;
            new Report(_reportModel).ShowDialog();
        }
        #endregion

        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());
            }
        }

        #region Input event
        private void borehole_cmb_SelectedIndexChanged(object sender, EventArgs e)
        {
            var control = (sender as ComboBox);
@@ -248,88 +274,10 @@
                    cmb.Text = currentItems[0];

            }

            holdCmbInit();
            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 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)
                    cmb.Enabled = false;

                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 LinkageModelProperty()
        private void holdCmbInit()
        {
            cmbCasingHoldUp.Items.Clear();
            _filters.Remove("CasingFluid");
@@ -339,34 +287,10 @@
            _filters.Remove("TubeFluid");
            cmbLithology.Items.Clear();
            _filters.Remove("Lithology");

            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();

@@ -409,26 +333,119 @@
                nudTubeHoldUp.Enabled = true;
                cmbTubeHoldUp.Items.AddRange(tubeFluids);
            }
        }
        private void LinkageModelProperty()
        {
            var curLithology = cmbLithology.Text;
            cmbLithology.Items.Clear();
            _filters.Remove("Lithology");

            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 lithology = curModels.Select(x => x.Lithology).Distinct().ToArray();
            var curLithology = cmbLithology.Text;
            cmbLithology.Items.AddRange(lithology);
            cmbLithology.Text = curLithology;
            if (cmbLithology.Items.Contains(curLithology))
                cmbLithology.Text = curLithology;

            if (lithology.Length == 1)
                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;
                }

            }
            LinkageModelProperty();
            //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);

            //    }
            //}
        }

        private void cmbLithology_SelectedIndexChanged(object sender, EventArgs e)
        {
            var control = (sender as ComboBox);
@@ -441,7 +458,29 @@
            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();
@@ -449,6 +488,8 @@

            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);
@@ -470,7 +511,7 @@
            // 可视化代码
            // 创建 Windows 窗体以显示图表
            var plotView = new PlotView { Model = plotModel };
            

            plotView.Width = 600;
            plotView.Height = 450;
            var bitmap = new Bitmap(plotView.Width, plotView.Height);
@@ -479,7 +520,69 @@

            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);
        }

        private ReportModel CreateReportModel(string duration, string pass, string speed, string soPrecision)
        {
            return new ReportModel
            {
                BHSalinity = nudBHSalinity.Value.ToString(),
                BIT = cmbBit.Text,
                CasingFluid = cmbCasingHoldUp.Text,
                CasingHoldUp = nudCasingHoldUp.Value.ToString(),
                CasingID = cmbCasingID.Text,
                CasingOD = cmbCasingOD.Text,
                CementBond = nudCementBond.Text,
                DepthAveraging = nudDepth.Value.ToString(),
                Duration = duration,
                GasSalinity = nudGasDensity.Value.ToString(),
                GravelFillPercent = nudGravelFIllPercent.Value.ToString(),
                Lithology = cmbLithology.Text,
                OilSalinity = nudOilDensity.Value.ToString(),
                Pass = pass,
                Porosity = nudPorosity.Value.ToString(),
                ReserviorSalinity = nudReservoirSalinity.Value.ToString(),
                ScreenFluid = cmbScreenHoldUp.Text,
                ScreenHoldUp = nudScreenHoldUp.Value.ToString(),
                ScreenID = cmbScreenID.Text,
                ScreenOD = cmbScreenOD.Text,
                SoPrecisionRequired = soPrecision,
                Speed = speed,
                TargetLoggingInterval = nudTargetLoggingInterval.Value.ToString(),
                TubeFluid = cmbTubeHoldUp.Text,
                TubeHoldUp = nudTubeHoldUp.Value.ToString(),
                TubeID = cmbTubeID.Text,
                TubeOD = cmbTubeOD.Text,
                VSH = nudVSH.Value.ToString(),
                WaterSaturation = nudSw.Value.ToString()
            };
        }


    }
}