From e81cbb4c978bec283c58629156c07106aaa46943 Mon Sep 17 00:00:00 2001
From: lx <ex_lixiang17@cosl.com.cn>
Date: 星期二, 18 十一月 2025 15:35:58 +0800
Subject: [PATCH] update 1.3.1

---
 ErrorAnalysis.Service/COMergeCalcService.cs |  155 +++++++++++++++++++++++++++++++++++++++++++++------
 1 files changed, 137 insertions(+), 18 deletions(-)

diff --git a/ErrorAnalysis.Service/COMergeCalcService.cs b/ErrorAnalysis.Service/COMergeCalcService.cs
index 7ac3ad8..42bd463 100644
--- a/ErrorAnalysis.Service/COMergeCalcService.cs
+++ b/ErrorAnalysis.Service/COMergeCalcService.cs
@@ -1,4 +1,5 @@
 锘縰sing ErrorAnalysis.Repository;
+using ErrorAnalysis.Repository.Entity;
 using Microsoft.VisualBasic;
 using System;
 using System.Collections.Generic;
@@ -36,14 +37,14 @@
             var oilLineValArr = oilLine.CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
             var waterLineValArr = waterLine.CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
 
-            var oilLineCR = oilLineValArr.Skip(_cWinStartIndex).Take(cWinLength).Sum() / oilLineValArr.Sum();
-            var oilLineOR = oilLineValArr.Skip(_oWinStartIndex).Take(oWinLength).Sum() / oilLineValArr.Sum();
+            var oilLineCR = oilLineValArr.Skip(_cWinStartIndex - 1).Take(cWinLength).Sum() / oilLineValArr.Skip(17).Take(237).Sum();
+            var oilLineOR = oilLineValArr.Skip(_oWinStartIndex - 1).Take(oWinLength).Sum() / oilLineValArr.Skip(17).Take(237).Sum();
 
             var oilLineC = 36d / 160d * oilLineCR * yieldCounting / speed * depth * 0.0762d;
             var oilLineO = 36d / 160d * oilLineOR * yieldCounting / speed * depth * 0.0762d;
 
-            var waterLineCR = waterLineValArr.Skip(_cWinStartIndex).Take(cWinLength).Sum() / waterLineValArr.Sum();
-            var waterLineOR = waterLineValArr.Skip(_oWinStartIndex).Take(oWinLength).Sum() / waterLineValArr.Sum();
+            var waterLineCR = waterLineValArr.Skip(_cWinStartIndex - 1).Take(cWinLength).Sum() / waterLineValArr.Skip(17).Take(237).Sum();
+            var waterLineOR = waterLineValArr.Skip(_oWinStartIndex - 1).Take(oWinLength).Sum() / waterLineValArr.Skip(17).Take(237).Sum();
             var waterLineC = 36d / 160d * waterLineCR * yieldCounting / speed * depth * 0.0762d;
             var waterLineO = 36d / 160d * waterLineOR * yieldCounting / speed * depth * 0.0762d;
 
@@ -77,13 +78,13 @@
             var oilLineValArr = oilLine.CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
             var waterLineValArr = waterLine.CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
 
-            var oilLineCR = oilLineValArr.Skip(_cWinStartIndex).Take(cWinLength).Sum() / oilLineValArr.Sum();
-            var oilLineOR = oilLineValArr.Skip(_oWinStartIndex).Take(oWinLength).Sum() / oilLineValArr.Sum();
+            var oilLineCR = oilLineValArr.Skip(_cWinStartIndex - 1).Take(cWinLength).Sum() / oilLineValArr.Skip(17).Take(237).Sum();
+            var oilLineOR = oilLineValArr.Skip(_oWinStartIndex - 1).Take(oWinLength).Sum() / oilLineValArr.Skip(17).Take(237).Sum();
             var oilLineC = (36d / 160d) * oilLineCR * yieldCounting / speed * depth * 0.0762d;
             var oilLineO = (36d / 160d) * oilLineOR * yieldCounting / speed * depth * 0.0762d;
 
-            var waterLineCR = waterLineValArr.Skip(_cWinStartIndex).Take(cWinLength).Sum() / waterLineValArr.Sum();
-            var waterLineOR = waterLineValArr.Skip(_oWinStartIndex).Take(oWinLength).Sum() / waterLineValArr.Sum();
+            var waterLineCR = waterLineValArr.Skip(_cWinStartIndex - 1).Take(cWinLength).Sum() / waterLineValArr.Skip(17).Take(237).Sum();
+            var waterLineOR = waterLineValArr.Skip(_oWinStartIndex - 1).Take(oWinLength).Sum() / waterLineValArr.Skip(17).Take(237).Sum();
             var waterLineC = (36d / 160d) * waterLineCR * yieldCounting / speed * depth * 0.0762d;
             var waterLineO = (36d / 160d) * waterLineOR * yieldCounting / speed * depth * 0.0762d;
 
@@ -107,7 +108,7 @@
         }
 
         /// <summary>
-        /// 鑾峰彇杩滄帰澶碈鎴朞鍊�
+        /// 鑾峰彇杩滄帰澶碈鎴朞鍊硷紙搴熷純锛�
         /// </summary>
         /// <param name="connectionString">鏁版嵁搴撹繛鎺ュ瓧绗︿覆</param>
         /// <param name="modelId">绠℃煴ID</param>
@@ -143,7 +144,7 @@
         }
 
         /// <summary>
-        /// 鑾峰彇杩戞帰澶碈鎴朞鍊�
+        /// 鑾峰彇杩戞帰澶碈鎴朞鍊硷紙搴熷純锛�
         /// </summary>
         /// <param name="connectionString">鏁版嵁搴撹繛鎺ュ瓧绗︿覆</param>
         /// <param name="modelId">绠℃煴ID</param>
@@ -178,6 +179,124 @@
             return result;
         }
 
+        public static List<double[]> GetFarSpectrum(string modelId, double porosity, double sw)
+        {
+            var result = new List<double[]>();
+            if (porosity > 40)
+                throw new InvalidDataException("Porosity value out of range!");
+
+            double[] oilLineSpec;
+            double[] waterLineSpec;
+
+            if (porosity % 5 == 0)
+            {
+                oilLineSpec = RepositoryInstance.Instance.COFarResultRepository.GetCOFarResult(modelId, (int)porosity, 0).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+                waterLineSpec = RepositoryInstance.Instance.COFarResultRepository.GetCOFarResult(modelId, (int)porosity, 100).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+            }
+            else
+            {
+                var ceilingPorosity = Math.Ceiling(porosity / 5) * 5;
+                double[] ceilingOilLineSpec = RepositoryInstance.Instance.COFarResultRepository.GetCOFarResult(modelId, (int)ceilingPorosity, 0).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+                double[] ceilingWaterLineSpec = RepositoryInstance.Instance.COFarResultRepository.GetCOFarResult(modelId, (int)ceilingPorosity, 100).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+
+                var floorPorosity = Math.Floor(porosity / 5) * 5;
+                double[] floorOilLineSpec = RepositoryInstance.Instance.COFarResultRepository.GetCOFarResult(modelId, (int)floorPorosity, 0).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+                double[] floorWaterLineSpec = RepositoryInstance.Instance.COFarResultRepository.GetCOFarResult(modelId, (int)floorPorosity, 100).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+
+                oilLineSpec = ceilingOilLineSpec;
+                waterLineSpec = ceilingWaterLineSpec;
+
+                for (int i = 0; i < ceilingOilLineSpec.Length; i++)
+                {
+                    oilLineSpec[i] = Utility.Interpolate(porosity, floorPorosity, floorOilLineSpec[i], ceilingPorosity, ceilingOilLineSpec[i]);
+                    waterLineSpec[i] = Utility.Interpolate(porosity, floorPorosity, floorWaterLineSpec[i], ceilingPorosity, ceilingWaterLineSpec[i]);
+                }
+            }
+            if (sw == 0)
+            {
+                for (int i = 0; i < oilLineSpec.Length; i++)
+                {
+                    result.Add([i, oilLineSpec[i]]);
+                }
+            }
+            else if (sw == 100)
+            {
+                for (int i = 0; i < waterLineSpec.Length; i++)
+                {
+                    result.Add([i, waterLineSpec[i]]);
+                }
+            }
+            else if (sw > 0 && sw < 100)
+            {
+                for (int i = 0; i < waterLineSpec.Length; i++)
+                {
+                    var val = Utility.Interpolate(sw, 0, oilLineSpec[i], 100, waterLineSpec[i]);
+                    result.Add([i, val]);
+                }
+            }
+
+            return result;
+        }
+
+        public static List<double[]> GetNearSpectrum(string modelId, double porosity, double sw)
+        {
+            var result = new List<double[]>();
+            if (porosity > 40)
+                throw new InvalidDataException("Porosity value out of range!");
+
+            double[] oilLineSpec;
+            double[] waterLineSpec;
+
+            if (porosity % 5 == 0)
+            {
+                oilLineSpec = RepositoryInstance.Instance.CONearResultRepository.GetCONearResult(modelId, (int)porosity, 0).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+                waterLineSpec = RepositoryInstance.Instance.CONearResultRepository.GetCONearResult(modelId, (int)porosity, 100).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+            }
+            else
+            {
+                var ceilingPorosity = Math.Ceiling(porosity / 5) * 5;
+                double[] ceilingOilLineSpec = RepositoryInstance.Instance.CONearResultRepository.GetCONearResult(modelId, (int)ceilingPorosity, 0).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+                double[] ceilingWaterLineSpec = RepositoryInstance.Instance.CONearResultRepository.GetCONearResult(modelId, (int)ceilingPorosity, 100).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+
+                var floorPorosity = Math.Floor(porosity / 5) * 5;
+                double[] floorOilLineSpec = RepositoryInstance.Instance.CONearResultRepository.GetCONearResult(modelId, (int)floorPorosity, 0).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+                double[] floorWaterLineSpec = RepositoryInstance.Instance.CONearResultRepository.GetCONearResult(modelId, (int)floorPorosity, 100).CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
+
+                oilLineSpec = ceilingOilLineSpec;
+                waterLineSpec = ceilingWaterLineSpec;
+
+                for (int i = 0; i < ceilingOilLineSpec.Length; i++)
+                {
+                    oilLineSpec[i] = Utility.Interpolate(porosity, floorPorosity, floorOilLineSpec[i], ceilingPorosity, ceilingOilLineSpec[i]);
+                    waterLineSpec[i] = Utility.Interpolate(porosity, floorPorosity, floorWaterLineSpec[i], ceilingPorosity, ceilingWaterLineSpec[i]);
+                }
+            }
+            if (sw == 0)
+            {
+                for (int i = 0; i < oilLineSpec.Length; i++)
+                {
+                    result.Add([i, oilLineSpec[i]]);
+                }
+            }
+            else if (sw == 100)
+            {
+                for (int i = 0; i < waterLineSpec.Length; i++)
+                {
+                    result.Add([i, waterLineSpec[i]]);
+                }
+            }
+            else if (sw > 0 && sw < 100)
+            {
+                for (int i = 0; i < waterLineSpec.Length; i++)
+                {
+                    var val = Utility.Interpolate(sw, 0, oilLineSpec[i], 100, waterLineSpec[i]);
+                    result.Add([i, val]);
+                }
+            }
+
+            return result;
+        }
+
         public static (double, double) GetFarCROR(string modelId, double porosity, double sw)
         {
             var cWinLength = _cWinEndIndex - _cWinStartIndex + 1;
@@ -189,11 +308,11 @@
             var oilLineValArr = oilLine.CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
             var waterLineValArr = waterLine.CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
 
-            var oilLineCR = oilLineValArr.Skip(_cWinStartIndex).Take(cWinLength).Sum() / oilLineValArr.Sum();
-            var oilLineOR = oilLineValArr.Skip(_oWinStartIndex).Take(oWinLength).Sum() / oilLineValArr.Sum();
+            var oilLineCR = oilLineValArr.Skip(_cWinStartIndex - 1).Take(cWinLength).Sum() / oilLineValArr.Skip(17).Take(237).Sum();
+            var oilLineOR = oilLineValArr.Skip(_oWinStartIndex - 1).Take(oWinLength).Sum() / oilLineValArr.Skip(17).Take(237).Sum();
 
-            var waterLineCR = waterLineValArr.Skip(_cWinStartIndex).Take(cWinLength).Sum() / waterLineValArr.Sum();
-            var waterLineOR = waterLineValArr.Skip(_oWinStartIndex).Take(oWinLength).Sum() / waterLineValArr.Sum();
+            var waterLineCR = waterLineValArr.Skip(_cWinStartIndex - 1).Take(cWinLength).Sum() / waterLineValArr.Skip(17).Take(237).Sum();
+            var waterLineOR = waterLineValArr.Skip(_oWinStartIndex - 1).Take(oWinLength).Sum() / waterLineValArr.Skip(17).Take(237).Sum();
 
             double cRes = 0, oRes = 0;
             if (sw == 0)
@@ -225,11 +344,11 @@
             var oilLineValArr = oilLine.CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
             var waterLineValArr = waterLine.CInelasticSpec.Split(',').Select(v => Convert.ToDouble(v)).ToArray();
 
-            var oilLineCR = oilLineValArr.Skip(_cWinStartIndex).Take(cWinLength).Sum() / oilLineValArr.Sum();
-            var oilLineOR = oilLineValArr.Skip(_oWinStartIndex).Take(oWinLength).Sum() / oilLineValArr.Sum();
+            var oilLineCR = oilLineValArr.Skip(_cWinStartIndex - 1).Take(cWinLength).Sum() / oilLineValArr.Skip(17).Take(237).Sum();
+            var oilLineOR = oilLineValArr.Skip(_oWinStartIndex - 1).Take(oWinLength).Sum() / oilLineValArr.Skip(17).Take(237).Sum();
 
-            var waterLineCR = waterLineValArr.Skip(_cWinStartIndex).Take(cWinLength).Sum() / waterLineValArr.Sum();
-            var waterLineOR = waterLineValArr.Skip(_oWinStartIndex).Take(oWinLength).Sum() / waterLineValArr.Sum();
+            var waterLineCR = waterLineValArr.Skip(_cWinStartIndex - 1).Take(cWinLength).Sum() / waterLineValArr.Skip(17).Take(237).Sum();
+            var waterLineOR = waterLineValArr.Skip(_oWinStartIndex - 1).Take(oWinLength).Sum() / waterLineValArr.Skip(17).Take(237).Sum();
 
             double crRes = 0, orRes = 0;
             if (sw == 0)

--
Gitblit v1.9.3