今天替换掉的程序

  • 主页面两个预测
复制代码
public void ShowPredictCurve()
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"F:/data.xlsx");
            Worksheet sheetPxA = workbook.Worksheets[0];
            Worksheet sheetPxB = workbook.Worksheets[1];
            Worksheet sheetPxC = workbook.Worksheets[2];
            Worksheet sheetPxD = workbook.Worksheets[3];
            Worksheet sheetPyA = workbook.Worksheets[4];
            Worksheet sheetPyB = workbook.Worksheets[5];
            Worksheet sheetPyC = workbook.Worksheets[6];
            Worksheet sheetPyD = workbook.Worksheets[7];

            CellRange rangePxA = sheetPxA.Range[sheetPxA.FirstRow, sheetPxA.FirstColumn, sheetPxA.LastRow, sheetPxA.LastColumn];
            DataTable dtPxA = sheetPxA.ExportDataTable(rangePxA, true, true);
            CellRange rangePxB = sheetPxB.Range[sheetPxB.FirstRow, sheetPxB.FirstColumn, sheetPxB.LastRow, sheetPxB.LastColumn];
            DataTable dtPxB = sheetPxB.ExportDataTable(rangePxB, true, true);
            CellRange rangePxC = sheetPxC.Range[sheetPxC.FirstRow, sheetPxC.FirstColumn, sheetPxC.LastRow, sheetPxC.LastColumn];
            DataTable dtPxC = sheetPxC.ExportDataTable(rangePxC, true, true);
            CellRange rangePxD = sheetPxD.Range[sheetPxD.FirstRow, sheetPxD.FirstColumn, sheetPxD.LastRow, sheetPxD.LastColumn];
            DataTable dtPxD = sheetPxD.ExportDataTable(rangePxD, true, true);

            CellRange rangePyA = sheetPyA.Range[sheetPyA.FirstRow, sheetPyA.FirstColumn, sheetPyA.LastRow, sheetPyA.LastColumn];
            DataTable dtPyA = sheetPyA.ExportDataTable(rangePyA, true, true);
            CellRange rangePyB = sheetPyB.Range[sheetPyB.FirstRow, sheetPyB.FirstColumn, sheetPyB.LastRow, sheetPyB.LastColumn];
            DataTable dtPyB = sheetPyB.ExportDataTable(rangePyB, true, true);
            CellRange rangePyC = sheetPyC.Range[sheetPyC.FirstRow, sheetPyC.FirstColumn, sheetPyC.LastRow, sheetPyC.LastColumn];
            DataTable dtPyC = sheetPyC.ExportDataTable(rangePyC, true, true);
            CellRange rangePyD = sheetPyD.Range[sheetPyD.FirstRow, sheetPyD.FirstColumn, sheetPyD.LastRow, sheetPyD.LastColumn];
            DataTable dtPyD = sheetPyD.ExportDataTable(rangePyD, true, true);

            int len = dtPxA.Columns.Count;
            string[] cellValuePxA = new string[len];
            string[] cellValuePxB = new string[len];
            string[] cellValuePxC = new string[len];
            string[] cellValuePxD = new string[len];

            string[] cellValuePyA = new string[len];
            string[] cellValuePyB = new string[len];
            string[] cellValuePyC = new string[len];
            string[] cellValuePyD = new string[len];

            chartPredictCurveWater.Series[0].Points.Clear();
            chartPredictCurveWater.Series[1].Points.Clear();
            chartPredictCurveWater.Series[2].Points.Clear();
            chartPredictCurveWater.Series[3].Points.Clear();

            chartPredictCurveOrganic.Series[0].Points.Clear();
            chartPredictCurveOrganic.Series[1].Points.Clear();
            chartPredictCurveOrganic.Series[2].Points.Clear();
            chartPredictCurveOrganic.Series[3].Points.Clear();

            for (int i = 0; i <= len - 1; i++)
            {
                cellValuePxA[i] = (string)dtPxA.Rows[0][i];
                chartPredictCurveWater.Series[0].Points.AddXY(i, cellValuePxA[i]);
                cellValuePxB[i] = (string)dtPxB.Rows[0][i];
                chartPredictCurveWater.Series[1].Points.AddXY(i, cellValuePxB[i]);
                cellValuePxC[i] = (string)dtPxC.Rows[0][i];
                chartPredictCurveWater.Series[2].Points.AddXY(i, cellValuePxC[i]);
                cellValuePxD[i] = (string)dtPxD.Rows[0][i];
                chartPredictCurveWater.Series[3].Points.AddXY(i, cellValuePxD[i]);

                cellValuePyA[i] = (string)dtPyA.Rows[0][i];
                chartPredictCurveOrganic.Series[0].Points.AddXY(i, cellValuePyA[i]);
                cellValuePyB[i] = (string)dtPyB.Rows[0][i];
                chartPredictCurveOrganic.Series[1].Points.AddXY(i, cellValuePyB[i]);
                cellValuePyC[i] = (string)dtPyC.Rows[0][i];
                chartPredictCurveOrganic.Series[2].Points.AddXY(i, cellValuePyC[i]);
                cellValuePyD[i] = (string)dtPyD.Rows[0][i];
                chartPredictCurveOrganic.Series[3].Points.AddXY(i, cellValuePyD[i]);
            }
        }
复制代码
  •  智能控制界面四个图
复制代码
public void ShowActualCurve()
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"F:/datawrite.xlsx");
            Worksheet sheetPxA = workbook.Worksheets[0];
            Worksheet sheetPxB = workbook.Worksheets[1];
            Worksheet sheetPxC = workbook.Worksheets[2];
            Worksheet sheetPxD = workbook.Worksheets[3];
            Worksheet sheetPyA = workbook.Worksheets[4];
            Worksheet sheetPyB = workbook.Worksheets[5];
            Worksheet sheetPyC = workbook.Worksheets[6];

            CellRange rangePxA = sheetPxA.Range[sheetPxA.FirstRow, sheetPxA.FirstColumn, sheetPxA.LastRow, sheetPxA.LastColumn];
            DataTable dtPxA = sheetPxA.ExportDataTable(rangePxA, true, true);
            CellRange rangePxB = sheetPxB.Range[sheetPxB.FirstRow, sheetPxB.FirstColumn, sheetPxB.LastRow, sheetPxB.LastColumn];
            DataTable dtPxB = sheetPxB.ExportDataTable(rangePxB, true, true);
            CellRange rangePxC = sheetPxC.Range[sheetPxC.FirstRow, sheetPxC.FirstColumn, sheetPxC.LastRow, sheetPxC.LastColumn];
            DataTable dtPxC = sheetPxC.ExportDataTable(rangePxC, true, true);
            CellRange rangePxD = sheetPxD.Range[sheetPxD.FirstRow, sheetPxD.FirstColumn, sheetPxD.LastRow, sheetPxD.LastColumn];
            DataTable dtPxD = sheetPxD.ExportDataTable(rangePxD, true, true);

            CellRange rangePyA = sheetPyA.Range[sheetPyA.FirstRow, sheetPyA.FirstColumn, sheetPyA.LastRow, sheetPyA.LastColumn];
            DataTable dtPyA = sheetPyA.ExportDataTable(rangePyA, true, true);
            CellRange rangePyB = sheetPyB.Range[sheetPyB.FirstRow, sheetPyB.FirstColumn, sheetPyB.LastRow, sheetPyB.LastColumn];
            DataTable dtPyB = sheetPyB.ExportDataTable(rangePyB, true, true);
            CellRange rangePyC = sheetPyC.Range[sheetPyC.FirstRow, sheetPyC.FirstColumn, sheetPyC.LastRow, sheetPyC.LastColumn];
            DataTable dtPyC = sheetPyC.ExportDataTable(rangePyC, true, true);

            int len = dtPxA.Columns.Count;
            string[] cellValuePxA = new string[len];
            string[] cellValuePxB = new string[len];
            string[] cellValuePxC = new string[len];
            string[] cellValuePxD = new string[len];

            string[] cellValuePyA = new string[len];
            string[] cellValuePyB = new string[len];
            string[] cellValuePyC = new string[len];

            chartActualCurveWater.Series[0].Points.Clear();
            chartActualCurveWater.Series[1].Points.Clear();
            chartActualCurveWater.Series[2].Points.Clear();
            chartActualCurveWater.Series[3].Points.Clear();

            chartActualCurveOrganic.Series[0].Points.Clear();
            chartActualCurveOrganic.Series[1].Points.Clear();
            chartActualCurveOrganic.Series[2].Points.Clear();

            for (int i = 0; i <= len - 1; i++)
            {
                cellValuePxA[i] = (string)dtPxA.Rows[0][i];
                chartActualCurveWater.Series[0].Points.AddXY(i, cellValuePxA[i]);
                cellValuePxB[i] = (string)dtPxB.Rows[0][i];
                chartActualCurveWater.Series[1].Points.AddXY(i, cellValuePxB[i]);
                cellValuePxC[i] = (string)dtPxC.Rows[0][i];
                chartActualCurveWater.Series[2].Points.AddXY(i, cellValuePxC[i]);
                cellValuePxD[i] = (string)dtPxD.Rows[0][i];
                chartActualCurveWater.Series[3].Points.AddXY(i, cellValuePxD[i]);

                cellValuePyA[i] = (string)dtPyA.Rows[0][i];
                chartActualCurveOrganic.Series[0].Points.AddXY(i, cellValuePyA[i]);
                cellValuePyB[i] = (string)dtPyB.Rows[0][i];
                chartActualCurveOrganic.Series[1].Points.AddXY(i, cellValuePyB[i]);
                cellValuePyC[i] = (string)dtPyC.Rows[0][i];
                chartActualCurveOrganic.Series[2].Points.AddXY(i, cellValuePyC[i]);
            }
        }
        
        public void ShowPredictCurve()
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"F:/data.xlsx");
            Worksheet sheetPxA = workbook.Worksheets[0];
            Worksheet sheetPxB = workbook.Worksheets[1];
            Worksheet sheetPxC = workbook.Worksheets[2];
            Worksheet sheetPxD = workbook.Worksheets[3];
            Worksheet sheetPyA = workbook.Worksheets[4];
            Worksheet sheetPyB = workbook.Worksheets[5];
            Worksheet sheetPyC = workbook.Worksheets[6];
            Worksheet sheetPyD = workbook.Worksheets[7];

            CellRange rangePxA = sheetPxA.Range[sheetPxA.FirstRow, sheetPxA.FirstColumn, sheetPxA.LastRow, sheetPxA.LastColumn];
            DataTable dtPxA = sheetPxA.ExportDataTable(rangePxA, true, true);
            CellRange rangePxB = sheetPxB.Range[sheetPxB.FirstRow, sheetPxB.FirstColumn, sheetPxB.LastRow, sheetPxB.LastColumn];
            DataTable dtPxB = sheetPxB.ExportDataTable(rangePxB, true, true);
            CellRange rangePxC = sheetPxC.Range[sheetPxC.FirstRow, sheetPxC.FirstColumn, sheetPxC.LastRow, sheetPxC.LastColumn];
            DataTable dtPxC = sheetPxC.ExportDataTable(rangePxC, true, true);
            CellRange rangePxD = sheetPxD.Range[sheetPxD.FirstRow, sheetPxD.FirstColumn, sheetPxD.LastRow, sheetPxD.LastColumn];
            DataTable dtPxD = sheetPxD.ExportDataTable(rangePxD, true, true);

            CellRange rangePyA = sheetPyA.Range[sheetPyA.FirstRow, sheetPyA.FirstColumn, sheetPyA.LastRow, sheetPyA.LastColumn];
            DataTable dtPyA = sheetPyA.ExportDataTable(rangePyA, true, true);
            CellRange rangePyB = sheetPyB.Range[sheetPyB.FirstRow, sheetPyB.FirstColumn, sheetPyB.LastRow, sheetPyB.LastColumn];
            DataTable dtPyB = sheetPyB.ExportDataTable(rangePyB, true, true);
            CellRange rangePyC = sheetPyC.Range[sheetPyC.FirstRow, sheetPyC.FirstColumn, sheetPyC.LastRow, sheetPyC.LastColumn];
            DataTable dtPyC = sheetPyC.ExportDataTable(rangePyC, true, true);
            CellRange rangePyD = sheetPyD.Range[sheetPyD.FirstRow, sheetPyD.FirstColumn, sheetPyD.LastRow, sheetPyD.LastColumn];
            DataTable dtPyD = sheetPyD.ExportDataTable(rangePyD, true, true);

            int len = dtPxA.Columns.Count;
            string[] cellValuePxA = new string[len];
            string[] cellValuePxB = new string[len];
            string[] cellValuePxC = new string[len];
            string[] cellValuePxD = new string[len];

            string[] cellValuePyA = new string[len];
            string[] cellValuePyB = new string[len];
            string[] cellValuePyC = new string[len];
            string[] cellValuePyD = new string[len];

            chartPredictCurveWater.Series[0].Points.Clear();
            chartPredictCurveWater.Series[1].Points.Clear();
            chartPredictCurveWater.Series[2].Points.Clear();
            chartPredictCurveWater.Series[3].Points.Clear();

            chartPredictCurveOrganic.Series[0].Points.Clear();
            chartPredictCurveOrganic.Series[1].Points.Clear();
            chartPredictCurveOrganic.Series[2].Points.Clear();
            chartPredictCurveOrganic.Series[3].Points.Clear();

            for (int i = 0; i <= len - 1; i++)
            {
                cellValuePxA[i] = (string)dtPxA.Rows[0][i];
                chartPredictCurveWater.Series[0].Points.AddXY(i, cellValuePxA[i]);
                cellValuePxB[i] = (string)dtPxB.Rows[0][i];
                chartPredictCurveWater.Series[1].Points.AddXY(i, cellValuePxB[i]);
                cellValuePxC[i] = (string)dtPxC.Rows[0][i];
                chartPredictCurveWater.Series[2].Points.AddXY(i, cellValuePxC[i]);
                cellValuePxD[i] = (string)dtPxD.Rows[0][i];
                chartPredictCurveWater.Series[3].Points.AddXY(i, cellValuePxD[i]);

                cellValuePyA[i] = (string)dtPyA.Rows[0][i];
                chartPredictCurveOrganic.Series[0].Points.AddXY(i, cellValuePyA[i]);
                cellValuePyB[i] = (string)dtPyB.Rows[0][i];
                chartPredictCurveOrganic.Series[1].Points.AddXY(i, cellValuePyB[i]);
                cellValuePyC[i] = (string)dtPyC.Rows[0][i];
                chartPredictCurveOrganic.Series[2].Points.AddXY(i, cellValuePyC[i]);
                cellValuePyD[i] = (string)dtPyD.Rows[0][i];
                chartPredictCurveOrganic.Series[3].Points.AddXY(i, cellValuePyD[i]);
            }

        }
View Code
复制代码
  • 生产数据里两个历史预测
复制代码
public void ShowHistoryCurve()
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"F:/data.xlsx");
            Worksheet sheetPxA = workbook.Worksheets[0];
            Worksheet sheetPxB = workbook.Worksheets[1];
            Worksheet sheetPxC = workbook.Worksheets[2];
            Worksheet sheetPxD = workbook.Worksheets[3];
            Worksheet sheetPyA = workbook.Worksheets[4];
            Worksheet sheetPyB = workbook.Worksheets[5];
            Worksheet sheetPyC = workbook.Worksheets[6];
            Worksheet sheetPyD = workbook.Worksheets[7];

            CellRange rangePxA = sheetPxA.Range[sheetPxA.FirstRow, sheetPxA.FirstColumn, sheetPxA.LastRow, sheetPxA.LastColumn];
            DataTable dtPxA = sheetPxA.ExportDataTable(rangePxA, true, true);
            CellRange rangePxB = sheetPxB.Range[sheetPxB.FirstRow, sheetPxB.FirstColumn, sheetPxB.LastRow, sheetPxB.LastColumn];
            DataTable dtPxB = sheetPxB.ExportDataTable(rangePxB, true, true);
            CellRange rangePxC = sheetPxC.Range[sheetPxC.FirstRow, sheetPxC.FirstColumn, sheetPxC.LastRow, sheetPxC.LastColumn];
            DataTable dtPxC = sheetPxC.ExportDataTable(rangePxC, true, true);
            CellRange rangePxD = sheetPxD.Range[sheetPxD.FirstRow, sheetPxD.FirstColumn, sheetPxD.LastRow, sheetPxD.LastColumn];
            DataTable dtPxD = sheetPxD.ExportDataTable(rangePxD, true, true);

            CellRange rangePyA = sheetPyA.Range[sheetPyA.FirstRow, sheetPyA.FirstColumn, sheetPyA.LastRow, sheetPyA.LastColumn];
            DataTable dtPyA = sheetPyA.ExportDataTable(rangePyA, true, true);
            CellRange rangePyB = sheetPyB.Range[sheetPyB.FirstRow, sheetPyB.FirstColumn, sheetPyB.LastRow, sheetPyB.LastColumn];
            DataTable dtPyB = sheetPyB.ExportDataTable(rangePyB, true, true);
            CellRange rangePyC = sheetPyC.Range[sheetPyC.FirstRow, sheetPyC.FirstColumn, sheetPyC.LastRow, sheetPyC.LastColumn];
            DataTable dtPyC = sheetPyC.ExportDataTable(rangePyC, true, true);
            CellRange rangePyD = sheetPyD.Range[sheetPyD.FirstRow, sheetPyD.FirstColumn, sheetPyD.LastRow, sheetPyD.LastColumn];
            DataTable dtPyD = sheetPyD.ExportDataTable(rangePyD, true, true);

            int len = dtPxA.Columns.Count;
            string[] cellValuePxA = new string[len];
            string[] cellValuePxB = new string[len];
            string[] cellValuePxC = new string[len];
            string[] cellValuePxD = new string[len];

            string[] cellValuePyA = new string[len];
            string[] cellValuePyB = new string[len];
            string[] cellValuePyC = new string[len];
            string[] cellValuePyD = new string[len];

            chartHistoryPredictCurveWater.Series[0].Points.Clear();
            chartHistoryPredictCurveWater.Series[1].Points.Clear();
            chartHistoryPredictCurveWater.Series[2].Points.Clear();
            chartHistoryPredictCurveWater.Series[3].Points.Clear();

            chartHistoryPredictCurveOrganic.Series[0].Points.Clear();
            chartHistoryPredictCurveOrganic.Series[1].Points.Clear();
            chartHistoryPredictCurveOrganic.Series[2].Points.Clear();
            chartHistoryPredictCurveOrganic.Series[3].Points.Clear();

            for (int i = 0; i <= len - 1; i++)
            {
                cellValuePxA[i] = (string)dtPxA.Rows[32][i];
                chartHistoryPredictCurveWater.Series[0].Points.AddXY(i, cellValuePxA[i]);
                cellValuePxB[i] = (string)dtPxB.Rows[32][i];
                chartHistoryPredictCurveWater.Series[1].Points.AddXY(i, cellValuePxB[i]);
                cellValuePxC[i] = (string)dtPxC.Rows[032][i];
                chartHistoryPredictCurveWater.Series[2].Points.AddXY(i, cellValuePxC[i]);
                cellValuePxD[i] = (string)dtPxD.Rows[032][i];
                chartHistoryPredictCurveWater.Series[3].Points.AddXY(i, cellValuePxD[i]);

                cellValuePyA[i] = (string)dtPyA.Rows[32][i];
                chartHistoryPredictCurveOrganic.Series[0].Points.AddXY(i, cellValuePyA[i]);
                cellValuePyB[i] = (string)dtPyB.Rows[32][i];
                chartHistoryPredictCurveOrganic.Series[1].Points.AddXY(i, cellValuePyB[i]);
                cellValuePyC[i] = (string)dtPyC.Rows[32][i];
                chartHistoryPredictCurveOrganic.Series[2].Points.AddXY(i, cellValuePyC[i]);
                cellValuePyD[i] = (string)dtPyD.Rows[32][i];
                chartHistoryPredictCurveOrganic.Series[3].Points.AddXY(i, cellValuePyD[i]);
            }
        }
View Code
复制代码

还有好多， 都已经删了

posted @   橘子Jane  阅读(35)  评论(0)  编辑  收藏  举报
编辑推荐：
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· Linux系列：如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
阅读排行：
· 阿里最新开源QwQ-32B，效果媲美deepseek-r1满血版，部署成本又又又降低了！
· 开源Multi-agent AI智能体框架aevatar.ai，欢迎大家贡献代码
· Manus重磅发布：全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后，我竟然真的恢复了删除的微信聊天记录！
· AI技术革命，工作效率10个最佳AI工具
点击右上角即可分享
微信分享提示
AI IDE Trae