From fe5bb447bbc9d325246cf99b980556af62955254 Mon Sep 17 00:00:00 2001
From: lx <ex_lixiang17@cosl.com.cn>
Date: 星期五, 18 七月 2025 17:32:19 +0800
Subject: [PATCH] plot
---
ErrorAnalysis.UI/FrmMain.cs | 424 ++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 375 insertions(+), 49 deletions(-)
diff --git a/ErrorAnalysis.UI/FrmMain.cs b/ErrorAnalysis.UI/FrmMain.cs
index d6a053c..02cbec4 100644
--- a/ErrorAnalysis.UI/FrmMain.cs
+++ b/ErrorAnalysis.UI/FrmMain.cs
@@ -1,5 +1,16 @@
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;
namespace ErrorAnalysis.UI
@@ -8,16 +19,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,13 +56,15 @@
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);
+ 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;
@@ -73,9 +85,83 @@
}
}
+ 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 (!double.TryParse(nudSoPrecisionRequired.Value.ToString(), out double targetErrorRatio) || nudSoPrecisionRequired.Value <= 0)
+ {
+ MessageBox.Show("Please enter a reasonable so precision required");
+ return;
+ }
+
+ if (cmbLithology.SelectedIndex == -1)
+ {
+ MessageBox.Show("Please select a lithology");
+ return;
+ }
+ if (curModels.Count == 0)
+ {
+ MessageBox.Show("Parameters error!");
+ return;
+ }
+
+ if (curModels.Count == 1)
+ _model = curModels[0];
+ _model = curModels.FirstOrDefault(m => m.GravelFillPercent == nudGravelFIllPercent.Value.ToString());
+ if (_model == null)
+ _model = curModels.First();
+
+ if (rdoLockSpeed.Checked)
+ {
+ if (!double.TryParse(nudSpeed.Value.ToString(), out double speed) || nudSpeed.Value <= 0)
+ {
+ 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);
+ Plot(result);
+
+ }
+ 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 +176,310 @@
}
}
- 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();
+ _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;
}
- 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();
+ cmbCasingHoldUp.Items.Clear();
+ _filters.Remove("CasingFluid");
+ cmbScreenHoldUp.Items.Clear();
+ _filters.Remove("ScreenFluid");
+ cmbTubeHoldUp.Items.Clear();
+ _filters.Remove("TubeFluid");
+ cmbLithology.Items.Clear();
+ _filters.Remove("Lithology");
- 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 allCmb = parentControl.Controls.OfType<Control>().Where(c => c is ComboBox).Select(c => c as ComboBox).ToList();
+ switch (control.Name)
{
- _curModel = selectedModels[0];
+ 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()
+ {
+ 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;
+
+ 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")
+ {
+ cmbCasingHoldUp.Enabled = false;
+ nudCasingHoldUp.Enabled = false;
+ }
+ else
+ {
+ cmbCasingHoldUp.Enabled = true;
+ nudCasingHoldUp.Enabled = true;
+
+ 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.Enabled = false;
+ nudScreenHoldUp.Enabled = false;
+ }
+ else
+ {
+ cmbScreenHoldUp.Enabled = true;
+ nudScreenHoldUp.Enabled = true;
+ 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.Enabled = false;
+ nudTubeHoldUp.Enabled = false;
+ }
+ else
+ {
+ cmbTubeHoldUp.Enabled = true;
+ nudTubeHoldUp.Enabled = true;
+ cmbTubeHoldUp.Items.AddRange(tubeFluids);
+ }
+
+ var lithology = curModels.Select(x => x.Lithology).Distinct().ToArray();
+ var curLithology = cmbLithology.Text;
+ cmbLithology.Items.AddRange(lithology);
+ cmbLithology.Text = curLithology;
+
+ if (lithology.Length == 1)
+ cmbLithology.SelectedIndex = 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);
+ }
+
+ 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" };
+
+ 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);
+
}
}
}
--
Gitblit v1.9.3