李建辉
2020-02-24 17:17
采纳率: 87.5%
浏览 443

C# 获取ACCESS数据实行曲线图且能拖动后将值保存

1、使用C# 创建 客户端程序;

2、程序能够实现创建如上图带有x轴和Y轴的坐标,能够读取ACCESS中坐标系中8个点的坐标位置初始值,并绘制8个点连成的曲线(如上图示)。

3、要求能够用鼠标左键来调整坐标中的点,来改变曲线的形态,同时修改点在坐标中的位置,并将修改后的点的位置保存到本地ACCESS中。

4、对话框中的坐标能够随着对话框的放大、缩小,同比例变化 。

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • blownewbee 2020-02-24 18:32
    已采纳

    帮你完整做了一个,留下email,采纳本回答,发给你

    其他人如果需要,可以从 https://download.csdn.net/download/caozhy/12188699 下载

    图片说明

    using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Data.OleDb;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Windows.Forms;
    
    namespace Q1055754
    {
        public partial class Form1 : Form
        {
    
            private List<DataPoint> Points = new List<DataPoint>();
    
            private int SelectedPointID = -1;
    
            private bool isInsert = false;
    
            public Form1()
            {
                InitializeComponent();
            }
    
            private void pictureBox1_Paint(object sender, PaintEventArgs e)
            {
                e.Graphics.FillRectangle(Brushes.White, pictureBox1.ClientRectangle);
                var pts = Points.OrderBy(x => x.X).ToList();
                if (pts.Count > 0)
                {
                    e.Graphics.DrawEllipse(pts[0].ID == SelectedPointID ? Pens.Red : Pens.Black,
                        (int)(pts[0].X * pictureBox1.ClientSize.Width) - 5,
                        (int)(pts[0].Y * pictureBox1.ClientSize.Height) - 5,
                        10, 10);
                    for (int i = 1; i < pts.Count; i++)
                    {
                        e.Graphics.DrawLine(Pens.Blue,
                            (float)(pts[i - 1].X * pictureBox1.ClientSize.Width),
                            (float)(pts[i - 1].Y * pictureBox1.ClientSize.Height),
                            (float)(pts[i].X * pictureBox1.ClientSize.Width),
                            (float)(pts[i].Y * pictureBox1.ClientSize.Height));
                        e.Graphics.DrawEllipse(pts[i].ID == SelectedPointID ? Pens.Red : Pens.Black,
                           (int)(pts[i].X * pictureBox1.ClientSize.Width) - 5,
                           (int)(pts[i].Y * pictureBox1.ClientSize.Height) - 5,
                           10, 10);
                    }
                }
            }
    
            private void button2_Click(object sender, EventArgs e)
            {
                isInsert = true;
            }
    
            private void pictureBox1_MouseEnter(object sender, EventArgs e)
            {
                if (isInsert)
                    Cursor = Cursors.Cross;
                else
                    Cursor = Cursors.Arrow;
            }
    
            private void pictureBox1_MouseLeave(object sender, EventArgs e)
            {
                Cursor = Cursors.Arrow;
            }
    
            private void pictureBox1_MouseDown(object sender, MouseEventArgs e)
            {
                if (e.Button == System.Windows.Forms.MouseButtons.Left)
                {
                    if (isInsert)
                    {
                        int newid = Points.Count == 0 ? 0 : Points.Select(x => x.ID).Max() + 1;
                        var point = new DataPoint()
                        {
                            ID = newid,
                            X = e.X / (double)pictureBox1.ClientSize.Width,
                            Y = e.Y / (double)pictureBox1.ClientSize.Height
                        };
                        Points.Add(point);
                        SelectedPointID = newid;
                        isInsert = false;
                        Cursor = Cursors.Arrow;
                        pictureBox1.Refresh();
                    }
                    else
                    {
                        var point = Points.Where(x => Math.Abs(x.X * (double)pictureBox1.ClientSize.Width - e.X) < 5 &&
                            Math.Abs(x.Y * (double)pictureBox1.ClientSize.Height - e.Y) < 5).FirstOrDefault();
                        if (point == null) SelectedPointID = -1; else SelectedPointID = point.ID;
                        pictureBox1.Refresh();
                    }
                }
            }
    
            private void pictureBox1_MouseMove(object sender, MouseEventArgs e)
            {
                if (!isInsert) Cursor = Cursors.Arrow;
                if (e.Button == System.Windows.Forms.MouseButtons.Left && !isInsert)
                {
                    var point = Points.FirstOrDefault(x => x.ID == SelectedPointID);
                    if (point != null)
                    {
                        point.X = e.X / (double)pictureBox1.ClientSize.Width;
                        point.Y = e.Y / (double)pictureBox1.ClientSize.Height;
                        pictureBox1.Refresh();
                    }
                }
            }
    
            private void button3_Click(object sender, EventArgs e)
            {
                var point = Points.FirstOrDefault(x => x.ID == SelectedPointID);
                if (point != null)
                    Points.Remove(point);
                SelectedPointID = -1;
                pictureBox1.Refresh();
            }
    
            private void pictureBox1_Resize(object sender, EventArgs e)
            {
                pictureBox1.Refresh();
            }
    
            private void button1_Click(object sender, EventArgs e)
            {
                OpenFileDialog ofn = new OpenFileDialog();
                if (ofn.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""" + ofn.FileName + @"""");
                    conn.Open();
                    OleDbCommand cmd = new OleDbCommand("select * from tb_Points", conn);
                    var reader = cmd.ExecuteReader();
                    Points.Clear();
                    SelectedPointID = -1;
                    while (reader.Read())
                    {
                        Points.Add(new DataPoint()
                        { 
                            ID = (int)reader["ID"],
                            X = (double)reader["X"],
                            Y = (double)reader["Y"]
                        });
                    }
                    pictureBox1.Refresh();
                    reader.Close();
                    conn.Close();
                }
            }
    
            private void button4_Click(object sender, EventArgs e)
            {
                SaveFileDialog sfd = new SaveFileDialog();
                if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""" + sfd.FileName + @"""");
                    conn.Open();
                    OleDbCommand cmd = new OleDbCommand("delete * from tb_Points", conn);
                    cmd.ExecuteNonQuery();
                    foreach (var item in Points)
                    {
                        cmd.CommandText = string.Format("insert into tb_Points(id, x, y) values({0}, {1}, {2})", item.ID, item.X, item.Y);
                        cmd.ExecuteNonQuery();
                    }
                    conn.Close();
                }
            }
    
        }
    }
    
    
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    
    namespace Q1055754
    {
        class DataPoint
        {
            public int ID { get; set; }
            public double X { get; set; }
            public double Y { get; set; }
        }
    }
    
    
    点赞 评论

相关推荐 更多相似问题