2952 lines
116 KiB
C#
2952 lines
116 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Data;
|
||
using System.Drawing;
|
||
using System.Drawing.Drawing2D;
|
||
using System.IO;
|
||
using System.Reflection;
|
||
using System.Text;
|
||
using System.Threading;
|
||
using System.Windows.Forms;
|
||
using System.Windows.Forms.DataVisualization.Charting;
|
||
using MySqlConnector;
|
||
|
||
namespace MysqlChart
|
||
{
|
||
static class Program
|
||
{
|
||
[STAThread]
|
||
static void Main()
|
||
{
|
||
AppDomain.CurrentDomain.AssemblyResolve += OnAssemblyResolve;
|
||
Application.EnableVisualStyles();
|
||
Application.SetCompatibleTextRenderingDefault(false);
|
||
if (HasArg("--selftest"))
|
||
{
|
||
SelfTest();
|
||
return;
|
||
}
|
||
if (HasArg("--drawtest"))
|
||
{
|
||
MainForm mf = new MainForm();
|
||
mf.Show();
|
||
Application.DoEvents();
|
||
mf.RunDrawTest();
|
||
Application.DoEvents();
|
||
Thread.Sleep(2000);
|
||
return;
|
||
}
|
||
Application.Run(new MainForm());
|
||
}
|
||
|
||
static bool HasArg(string name)
|
||
{
|
||
string[] args = Environment.GetCommandLineArgs();
|
||
foreach (string a in args)
|
||
if (a.Equals(name, StringComparison.OrdinalIgnoreCase)) return true;
|
||
return false;
|
||
}
|
||
|
||
static void SelfTest()
|
||
{
|
||
StringBuilder log = new StringBuilder();
|
||
try
|
||
{
|
||
string configPath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "config.ini");
|
||
ConfigData config = ConfigData.Load(configPath);
|
||
log.AppendLine("config: host=" + config.Host + " db=" + config.Database);
|
||
MySqlConnectionStringBuilder b = new MySqlConnectionStringBuilder();
|
||
b.Server = config.Host;
|
||
b.Port = uint.Parse(config.Port);
|
||
b.UserID = config.User;
|
||
b.Password = config.Password;
|
||
b.Database = config.Database;
|
||
b.CharacterSet = config.Charset;
|
||
b.ConnectionTimeout = 10;
|
||
using (MySqlConnection conn = new MySqlConnection(b.ConnectionString))
|
||
{
|
||
conn.Open();
|
||
log.AppendLine("1. 连接成功");
|
||
List<string> tableList = new List<string>();
|
||
using (MySqlCommand cmd = new MySqlCommand("SHOW TABLES", conn))
|
||
using (IDataReader r = cmd.ExecuteReader())
|
||
{
|
||
while (r.Read()) tableList.Add(r.GetString(0));
|
||
log.AppendLine("2. 表列表: " + string.Join(", ", tableList.ToArray()));
|
||
}
|
||
string table = "mixer_runtime";
|
||
if (!tableList.Contains("mixer_runtime") && tableList.Count > 0) table = tableList[0];
|
||
List<string> cols = new List<string>();
|
||
using (MySqlCommand cmd = new MySqlCommand(
|
||
"SELECT * FROM `" + table + "` LIMIT 0", conn))
|
||
using (IDataReader r = cmd.ExecuteReader())
|
||
{
|
||
for (int i = 0; i < r.FieldCount; i++) cols.Add(r.GetName(i));
|
||
log.AppendLine("3. 列列表: " + string.Join(", ", cols.ToArray()));
|
||
}
|
||
string xc = cols.Count > 0 ? cols[0] : "1";
|
||
string yc = cols.Count > 1 ? cols[1] : xc;
|
||
string qx = "`" + xc.Replace("`", "``") + "`";
|
||
string qy = "`" + yc.Replace("`", "``") + "`";
|
||
using (MySqlCommand cmd = new MySqlCommand(
|
||
"SELECT " + qx + ", " + qy + " FROM `" + table + "` ORDER BY " + qx + " ASC LIMIT 100", conn))
|
||
using (IDataReader r = cmd.ExecuteReader())
|
||
{
|
||
int count = 0;
|
||
object[] first = null;
|
||
object[] last = null;
|
||
while (r.Read())
|
||
{
|
||
object[] vals = new object[r.FieldCount];
|
||
r.GetValues(vals);
|
||
if (first == null) first = vals;
|
||
last = vals;
|
||
count++;
|
||
}
|
||
log.AppendLine("4. 查询100行成功, 行数=" + count);
|
||
if (first != null)
|
||
log.AppendLine(" 首行: x=" + first[0] + " y=" + first[1]);
|
||
if (last != null)
|
||
log.AppendLine(" 末行: x=" + last[0] + " y=" + last[1]);
|
||
}
|
||
using (MySqlCommand cmd = new MySqlCommand(
|
||
"SELECT COUNT(*) FROM `" + table + "`", conn))
|
||
{
|
||
object c = cmd.ExecuteScalar();
|
||
log.AppendLine("5. 全表行数: " + c);
|
||
}
|
||
}
|
||
log.AppendLine("SELFTEST PASS");
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
log.AppendLine("SELFTEST FAIL: " + ex.Message);
|
||
log.AppendLine(ex.StackTrace);
|
||
try
|
||
{
|
||
string configPath2 = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "config.ini");
|
||
ConfigData cfg2 = ConfigData.Load(configPath2);
|
||
MySqlConnectionStringBuilder b2 = new MySqlConnectionStringBuilder();
|
||
b2.Server = cfg2.Host;
|
||
b2.Port = uint.Parse(cfg2.Port);
|
||
b2.UserID = cfg2.User;
|
||
b2.Password = cfg2.Password;
|
||
b2.CharacterSet = cfg2.Charset;
|
||
b2.ConnectionTimeout = 10;
|
||
using (MySqlConnection conn2 = new MySqlConnection(b2.ConnectionString))
|
||
{
|
||
conn2.Open();
|
||
log.AppendLine("(无库连接成功, 服务器上数据库列表:)");
|
||
using (MySqlCommand cmd = new MySqlCommand("SHOW DATABASES", conn2))
|
||
using (IDataReader r = cmd.ExecuteReader())
|
||
{
|
||
while (r.Read()) log.AppendLine(" DB: " + r.GetString(0));
|
||
}
|
||
}
|
||
}
|
||
catch (Exception ex2)
|
||
{
|
||
log.AppendLine("(无法列出数据库: " + ex2.Message + ")");
|
||
}
|
||
}
|
||
string outFile = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "selftest_result.txt");
|
||
File.WriteAllText(outFile, log.ToString(), new UTF8Encoding(false));
|
||
}
|
||
|
||
static Assembly OnAssemblyResolve(object sender, ResolveEventArgs args)
|
||
{
|
||
string simpleName = new AssemblyName(args.Name).Name;
|
||
string resName = simpleName + ".dll";
|
||
Assembly asm = Assembly.GetExecutingAssembly();
|
||
string[] names = asm.GetManifestResourceNames();
|
||
foreach (string n in names)
|
||
{
|
||
if (n.EndsWith(resName, StringComparison.OrdinalIgnoreCase))
|
||
{
|
||
using (Stream s = asm.GetManifestResourceStream(n))
|
||
{
|
||
if (s == null) return null;
|
||
byte[] buf = new byte[s.Length];
|
||
s.Read(buf, 0, buf.Length);
|
||
return Assembly.Load(buf);
|
||
}
|
||
}
|
||
}
|
||
return null;
|
||
}
|
||
}
|
||
|
||
class ConfigData
|
||
{
|
||
public string Host = "127.0.0.1";
|
||
public string Port = "3306";
|
||
public string User = "root";
|
||
public string Password = "";
|
||
public string Database = "";
|
||
public string Charset = "utf8mb4";
|
||
|
||
public static ConfigData Load(string path)
|
||
{
|
||
ConfigData c = new ConfigData();
|
||
if (!File.Exists(path)) return c;
|
||
string[] lines = File.ReadAllLines(path, Encoding.UTF8);
|
||
bool inMysql = false;
|
||
foreach (string line in lines)
|
||
{
|
||
string t = line.Trim();
|
||
if (t.Length == 0 || t.StartsWith(";") || t.StartsWith("#")) continue;
|
||
if (t.StartsWith("[") && t.EndsWith("]"))
|
||
{
|
||
inMysql = t.Equals("[mysql]", StringComparison.OrdinalIgnoreCase);
|
||
continue;
|
||
}
|
||
if (!inMysql) continue;
|
||
int idx = t.IndexOf('=');
|
||
if (idx <= 0) continue;
|
||
string key = t.Substring(0, idx).Trim().ToLowerInvariant();
|
||
string val = t.Substring(idx + 1).Trim();
|
||
switch (key)
|
||
{
|
||
case "host": c.Host = val; break;
|
||
case "port": c.Port = val; break;
|
||
case "user": c.User = val; break;
|
||
case "password": c.Password = val; break;
|
||
case "database": c.Database = val; break;
|
||
case "charset": c.Charset = val; break;
|
||
}
|
||
}
|
||
return c;
|
||
}
|
||
|
||
public void Save(string path)
|
||
{
|
||
StringBuilder sb = new StringBuilder();
|
||
sb.AppendLine("[mysql]");
|
||
sb.AppendLine("host = " + Host);
|
||
sb.AppendLine("port = " + Port);
|
||
sb.AppendLine("user = " + User);
|
||
sb.AppendLine("password = " + Password);
|
||
sb.AppendLine("database = " + Database);
|
||
sb.AppendLine("charset = " + Charset);
|
||
File.WriteAllText(path, sb.ToString(), new UTF8Encoding(false));
|
||
}
|
||
}
|
||
|
||
class MainForm : Form
|
||
{
|
||
ConfigData config;
|
||
string configPath;
|
||
|
||
TextBox txtHost, txtPort, txtUser, txtPassword;
|
||
ComboBox cmbDatabase, cmbTable, cmbX, cmbXType, cmbOrder, cmbCalc, cmbCalcTarget;
|
||
TextBox txtLimit, txtOffset, txtTailOffset, txtCalcParam;
|
||
Label lblCalcParam;
|
||
ListBox lbY;
|
||
DataGridView dgvFilter;
|
||
Button btnConnect, btnAddRule, btnDelRule, btnPlot, btnClear, btnSave;
|
||
Button btnCollapse, btnPin, btnExpand, btnApplyCalc, btnClearCalc, btnLegend, btnSettings, btnCross;
|
||
Label lblChartTitle, lblStatus;
|
||
Chart chart;
|
||
Panel left, right, splitterRef;
|
||
|
||
List<string> allColumns = new List<string>();
|
||
List<string> calcSeriesNames = new List<string>();
|
||
List<object[]> lastRows;
|
||
string lastXcol = "";
|
||
List<string> lastYcols = new List<string>();
|
||
string lastTable = "";
|
||
bool loadingDbs = false;
|
||
bool pinned = false;
|
||
int paletteCounter = 0;
|
||
bool draggingLegend = false;
|
||
Point dragStart = Point.Empty;
|
||
PointF crossPos = new PointF(-1, -1);
|
||
Form floatTip;
|
||
bool showCross = true;
|
||
bool legendHiddenByUser = false;
|
||
Panel legendBar;
|
||
FlowLayoutPanel legendFlow;
|
||
|
||
static readonly Color ThemeBlue = Color.FromArgb(41, 101, 173);
|
||
static readonly Color PanelBg = Color.FromArgb(246, 248, 251);
|
||
static readonly Color BorderLine = Color.FromArgb(214, 221, 230);
|
||
|
||
public MainForm()
|
||
{
|
||
configPath = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "config.ini");
|
||
config = ConfigData.Load(configPath);
|
||
InitUI();
|
||
FillConnFields();
|
||
Shown += delegate { FitWindowToScreen(); };
|
||
}
|
||
|
||
void FitWindowToScreen()
|
||
{
|
||
try
|
||
{
|
||
Screen scr = Screen.FromControl(this);
|
||
int w = (int)(scr.WorkingArea.Width * 0.92);
|
||
int h = (int)(scr.WorkingArea.Height * 0.92);
|
||
if (w < 1000) w = 1000;
|
||
if (h < 700) h = 700;
|
||
this.Width = w;
|
||
this.Height = h;
|
||
this.StartPosition = FormStartPosition.CenterScreen;
|
||
}
|
||
catch { }
|
||
}
|
||
|
||
void InitUI()
|
||
{
|
||
Text = "趋势分析预测工具";
|
||
Size = new Size(1240, 820);
|
||
MinimumSize = new Size(1000, 700);
|
||
StartPosition = FormStartPosition.CenterScreen;
|
||
Font = new Font("Microsoft YaHei UI", 9F);
|
||
BackColor = PanelBg;
|
||
try
|
||
{
|
||
using (Stream s = Assembly.GetExecutingAssembly().GetManifestResourceStream("hamster.ico"))
|
||
{
|
||
if (s != null)
|
||
this.Icon = new Icon(s);
|
||
}
|
||
}
|
||
catch { }
|
||
|
||
left = new Panel();
|
||
left.Width = 380;
|
||
left.BackColor = PanelBg;
|
||
left.AutoScroll = true;
|
||
Controls.Add(left);
|
||
|
||
Panel right = new Panel();
|
||
right.BackColor = Color.White;
|
||
Controls.Add(right);
|
||
this.right = right;
|
||
|
||
Panel splitter = new Panel();
|
||
splitter.BackColor = BorderLine;
|
||
splitter.Cursor = Cursors.SizeWE;
|
||
Controls.Add(splitter);
|
||
splitterRef = splitter;
|
||
SetupSplitterDrag(splitter);
|
||
|
||
this.Resize += delegate { LayoutPanels(left, right, splitter); };
|
||
LayoutPanels(left, right, splitter);
|
||
left.Resize += delegate { LayoutLeftPanel(); };
|
||
|
||
int x2 = 8;
|
||
int iw = 406;
|
||
int y = 4;
|
||
|
||
btnCollapse = MakeIconButton("折叠", 0);
|
||
btnCollapse.Location = new Point(x2, y);
|
||
btnCollapse.Size = new Size(200, 30);
|
||
btnCollapse.Click += delegate
|
||
{
|
||
left.Visible = false;
|
||
LayoutPanels(left, right, splitterRef);
|
||
btnExpand.Visible = true;
|
||
btnExpand.BringToFront();
|
||
};
|
||
left.Controls.Add(btnCollapse);
|
||
|
||
btnPin = MakeIconButton("钉住", 1);
|
||
btnPin.Location = new Point(x2 + 208, y);
|
||
btnPin.Size = new Size(206, 30);
|
||
btnPin.Click += delegate { TogglePin(); };
|
||
left.Controls.Add(btnPin);
|
||
y += 40;
|
||
|
||
Label title1 = new Label();
|
||
title1.Text = "服务器连接";
|
||
title1.Font = new Font("Microsoft YaHei UI", 10F, FontStyle.Bold);
|
||
title1.ForeColor = ThemeBlue;
|
||
title1.Location = new Point(x2, y);
|
||
title1.AutoSize = true;
|
||
left.Controls.Add(title1);
|
||
y += 30;
|
||
|
||
AddLabel(left, "主机地址:", x2, y);
|
||
txtHost = AddText(left, config.Host, x2 + 88, y, 132);
|
||
AddLabel2(left, "端口:", x2 + 226, y);
|
||
txtPort = AddText(left, config.Port, x2 + 270, y, 144);
|
||
y += 36;
|
||
|
||
AddLabel(left, "用户名:", x2, y);
|
||
txtUser = AddText(left, config.User, x2 + 88, y, 132);
|
||
AddLabel2(left, "密码:", x2 + 226, y);
|
||
txtPassword = AddText(left, config.Password, x2 + 270, y, 144, true);
|
||
y += 36;
|
||
|
||
AddLabel(left, "DB:", x2, y);
|
||
cmbDatabase = MakeCombo();
|
||
cmbDatabase.DropDownStyle = ComboBoxStyle.DropDown;
|
||
cmbDatabase.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
|
||
cmbDatabase.AutoCompleteSource = AutoCompleteSource.ListItems;
|
||
cmbDatabase.Location = new Point(x2 + 88, y);
|
||
cmbDatabase.Size = new Size(iw - 88, 28);
|
||
cmbDatabase.SelectedIndexChanged += delegate { DatabaseSelected(); };
|
||
cmbDatabase.KeyDown += delegate(object s, KeyEventArgs e)
|
||
{
|
||
if (e.KeyCode == Keys.Enter)
|
||
{
|
||
e.SuppressKeyPress = true;
|
||
DatabaseSelected();
|
||
}
|
||
};
|
||
left.Controls.Add(cmbDatabase);
|
||
y += 38;
|
||
|
||
btnConnect = new Button();
|
||
btnConnect.Text = "连 接";
|
||
btnConnect.Location = new Point(x2, y);
|
||
btnConnect.Size = new Size(iw, 34);
|
||
btnConnect.FlatStyle = FlatStyle.Flat;
|
||
btnConnect.FlatAppearance.BorderSize = 0;
|
||
btnConnect.BackColor = ThemeBlue;
|
||
btnConnect.ForeColor = Color.White;
|
||
btnConnect.Font = new Font("Microsoft YaHei UI", 10F, FontStyle.Bold);
|
||
btnConnect.Cursor = Cursors.Hand;
|
||
btnConnect.Click += delegate { ConnectAndLoad(); };
|
||
left.Controls.Add(btnConnect);
|
||
y += 46;
|
||
|
||
Label titleQ = new Label();
|
||
titleQ.Text = "排序规则";
|
||
titleQ.Font = new Font("Microsoft YaHei UI", 10F, FontStyle.Bold);
|
||
titleQ.ForeColor = ThemeBlue;
|
||
titleQ.Location = new Point(x2, y);
|
||
titleQ.AutoSize = true;
|
||
left.Controls.Add(titleQ);
|
||
y += 30;
|
||
|
||
AddLabel(left, "方向:", x2, y);
|
||
cmbOrder = MakeCombo();
|
||
cmbOrder.Location = new Point(x2 + 88, y);
|
||
cmbOrder.Size = new Size(156, 28);
|
||
cmbOrder.Items.Add("正序 (最早在前)");
|
||
cmbOrder.Items.Add("倒序 (最新在前)");
|
||
cmbOrder.SelectedIndex = 0;
|
||
left.Controls.Add(cmbOrder);
|
||
|
||
AddLabel2(left, "条数:", x2 + 246, y);
|
||
txtLimit = AddText(left, "2000", x2 + 288, y, 126);
|
||
y += 36;
|
||
|
||
AddLabel(left, "偏移:", x2, y);
|
||
txtOffset = AddText(left, "0", x2 + 88, y, 156);
|
||
Label tipL = new Label();
|
||
tipL.Text = "跳过前 N 行";
|
||
tipL.Font = new Font("Microsoft YaHei UI", 8.5F);
|
||
tipL.ForeColor = Color.FromArgb(140, 150, 160);
|
||
tipL.Location = new Point(x2 + 250, y + 6);
|
||
tipL.AutoSize = true;
|
||
left.Controls.Add(tipL);
|
||
y += 42;
|
||
|
||
AddLabel(left, "起点:", x2, y);
|
||
txtTailOffset = AddText(left, "0", x2 + 88, y, 156);
|
||
y += 22;
|
||
Label tipT = new Label();
|
||
tipT.Text = "从最新数据往回数 N 条作为查询起点";
|
||
tipT.Font = new Font("Microsoft YaHei UI", 8.5F);
|
||
tipT.ForeColor = Color.FromArgb(140, 150, 160);
|
||
tipT.Location = new Point(x2 + 88, y);
|
||
tipT.AutoSize = true;
|
||
left.Controls.Add(tipT);
|
||
y += 20;
|
||
|
||
Label title2 = new Label();
|
||
title2.Text = "存储表与坐标轴";
|
||
title2.Font = new Font("Microsoft YaHei UI", 10F, FontStyle.Bold);
|
||
title2.ForeColor = ThemeBlue;
|
||
title2.Location = new Point(x2, y);
|
||
title2.AutoSize = true;
|
||
left.Controls.Add(title2);
|
||
y += 30;
|
||
|
||
AddLabel(left, "存储表:", x2, y);
|
||
cmbTable = MakeCombo();
|
||
cmbTable.Location = new Point(x2 + 88, y);
|
||
cmbTable.Size = new Size(iw - 88, 28);
|
||
cmbTable.SelectedIndexChanged += delegate { TableSelected(); };
|
||
left.Controls.Add(cmbTable);
|
||
y += 36;
|
||
|
||
AddLabel(left, "横坐标:", x2, y);
|
||
cmbX = MakeCombo();
|
||
cmbX.Location = new Point(x2 + 88, y);
|
||
cmbX.Size = new Size(iw - 88, 28);
|
||
left.Controls.Add(cmbX);
|
||
y += 36;
|
||
|
||
AddLabel(left, "横轴类型:", x2, y);
|
||
cmbXType = MakeCombo();
|
||
cmbXType.Location = new Point(x2 + 88, y);
|
||
cmbXType.Size = new Size(iw - 88, 28);
|
||
cmbXType.Items.Add("自动识别");
|
||
cmbXType.Items.Add("时间");
|
||
cmbXType.Items.Add("数值");
|
||
cmbXType.Items.Add("文本");
|
||
cmbXType.SelectedIndex = 0;
|
||
left.Controls.Add(cmbXType);
|
||
y += 36;
|
||
|
||
AddLabel(left, "纵坐标:", x2, y);
|
||
lbY = new ListBox();
|
||
lbY.BorderStyle = BorderStyle.FixedSingle;
|
||
lbY.Location = new Point(x2 + 88, y);
|
||
lbY.Size = new Size(iw - 88, 96);
|
||
lbY.HorizontalScrollbar = true;
|
||
lbY.SelectionMode = SelectionMode.MultiExtended;
|
||
lbY.BackColor = Color.White;
|
||
lbY.IntegralHeight = false;
|
||
left.Controls.Add(lbY);
|
||
y += 104;
|
||
|
||
Label tipY = new Label();
|
||
tipY.Text = "提示: 按住 Ctrl 键可多选纵坐标";
|
||
tipY.Font = new Font("Microsoft YaHei UI", 8.5F);
|
||
tipY.ForeColor = Color.FromArgb(140, 150, 160);
|
||
tipY.Location = new Point(x2 + 88, y);
|
||
tipY.AutoSize = true;
|
||
left.Controls.Add(tipY);
|
||
y += 24;
|
||
|
||
Label title3 = new Label();
|
||
title3.Text = "过滤规则 (多行按 AND/OR 连接)";
|
||
title3.Font = new Font("Microsoft YaHei UI", 10F, FontStyle.Bold);
|
||
title3.ForeColor = ThemeBlue;
|
||
title3.Location = new Point(x2, y);
|
||
title3.AutoSize = true;
|
||
left.Controls.Add(title3);
|
||
y += 30;
|
||
|
||
dgvFilter = new DataGridView();
|
||
dgvFilter.Location = new Point(x2, y);
|
||
dgvFilter.Size = new Size(iw, 140);
|
||
dgvFilter.AllowUserToAddRows = false;
|
||
dgvFilter.AllowUserToDeleteRows = false;
|
||
dgvFilter.AllowUserToResizeRows = false;
|
||
dgvFilter.RowHeadersVisible = false;
|
||
dgvFilter.BackgroundColor = Color.White;
|
||
dgvFilter.BorderStyle = BorderStyle.FixedSingle;
|
||
dgvFilter.EnableHeadersVisualStyles = false;
|
||
dgvFilter.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(52, 73, 94);
|
||
dgvFilter.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
|
||
dgvFilter.ColumnHeadersDefaultCellStyle.Font = new Font("Microsoft YaHei UI", 8.5F, FontStyle.Bold);
|
||
dgvFilter.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
|
||
dgvFilter.ColumnHeadersHeight = 24;
|
||
dgvFilter.DefaultCellStyle.Font = new Font("Microsoft YaHei UI", 8.5F);
|
||
dgvFilter.DefaultCellStyle.SelectionBackColor = Color.FromArgb(191, 215, 245);
|
||
dgvFilter.DefaultCellStyle.SelectionForeColor = Color.Black;
|
||
dgvFilter.AlternatingRowsDefaultCellStyle.BackColor = Color.FromArgb(244, 247, 251);
|
||
dgvFilter.GridColor = Color.FromArgb(221, 228, 236);
|
||
dgvFilter.RowTemplate.Height = 22;
|
||
|
||
DataGridViewComboBoxColumn colCol = new DataGridViewComboBoxColumn();
|
||
colCol.HeaderText = "列";
|
||
colCol.Width = 132;
|
||
colCol.FlatStyle = FlatStyle.Flat;
|
||
dgvFilter.Columns.Add(colCol);
|
||
|
||
DataGridViewComboBoxColumn colOp = new DataGridViewComboBoxColumn();
|
||
colOp.HeaderText = "操作符";
|
||
colOp.Width = 92;
|
||
colOp.FlatStyle = FlatStyle.Flat;
|
||
colOp.Items.Add("=");
|
||
colOp.Items.Add("!=");
|
||
colOp.Items.Add(">");
|
||
colOp.Items.Add(">=");
|
||
colOp.Items.Add("<");
|
||
colOp.Items.Add("<=");
|
||
colOp.Items.Add("LIKE");
|
||
colOp.Items.Add("BETWEEN");
|
||
colOp.Items.Add("IS NULL");
|
||
colOp.Items.Add("IS NOT NULL");
|
||
dgvFilter.Columns.Add(colOp);
|
||
|
||
DataGridViewTextBoxColumn colVal = new DataGridViewTextBoxColumn();
|
||
colVal.HeaderText = "值";
|
||
colVal.Width = 120;
|
||
colVal.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
|
||
colVal.ToolTipText = "BETWEEN 用逗号分隔两个值";
|
||
dgvFilter.Columns.Add(colVal);
|
||
|
||
DataGridViewComboBoxColumn colLogic = new DataGridViewComboBoxColumn();
|
||
colLogic.HeaderText = "逻辑";
|
||
colLogic.Width = 60;
|
||
colLogic.FlatStyle = FlatStyle.Flat;
|
||
colLogic.Items.Add("AND");
|
||
colLogic.Items.Add("OR");
|
||
dgvFilter.Columns.Add(colLogic);
|
||
|
||
left.Controls.Add(dgvFilter);
|
||
y += 148;
|
||
|
||
btnAddRule = MakeSmallButton("+ 添加规则");
|
||
btnAddRule.Location = new Point(x2, y);
|
||
btnAddRule.Size = new Size(130, 28);
|
||
btnAddRule.BackColor = Color.FromArgb(39, 174, 96);
|
||
btnAddRule.Click += delegate { AddRule(); };
|
||
left.Controls.Add(btnAddRule);
|
||
|
||
btnDelRule = MakeSmallButton("- 删除");
|
||
btnDelRule.Location = new Point(x2 + 138, y);
|
||
btnDelRule.Size = new Size(130, 28);
|
||
btnDelRule.BackColor = Color.FromArgb(192, 57, 43);
|
||
btnDelRule.Click += delegate { DelRule(); };
|
||
left.Controls.Add(btnDelRule);
|
||
|
||
btnClear = MakeSmallButton("清空");
|
||
btnClear.Location = new Point(x2 + 276, y);
|
||
btnClear.Size = new Size(138, 28);
|
||
btnClear.BackColor = Color.FromArgb(127, 140, 141);
|
||
btnClear.Click += delegate { dgvFilter.Rows.Clear(); };
|
||
left.Controls.Add(btnClear);
|
||
y += 38;
|
||
|
||
btnPlot = new Button();
|
||
btnPlot.Text = "绘制曲线";
|
||
btnPlot.Location = new Point(x2, y);
|
||
btnPlot.Size = new Size(204, 42);
|
||
btnPlot.FlatStyle = FlatStyle.Flat;
|
||
btnPlot.FlatAppearance.BorderSize = 0;
|
||
btnPlot.BackColor = Color.FromArgb(39, 174, 96);
|
||
btnPlot.ForeColor = Color.White;
|
||
btnPlot.Font = new Font("Microsoft YaHei UI", 11F, FontStyle.Bold);
|
||
btnPlot.Cursor = Cursors.Hand;
|
||
btnPlot.Click += delegate { Plot(); };
|
||
left.Controls.Add(btnPlot);
|
||
|
||
btnSave = new Button();
|
||
btnSave.Text = "保存图片";
|
||
btnSave.Location = new Point(x2 + 210, y);
|
||
btnSave.Size = new Size(204, 42);
|
||
btnSave.FlatStyle = FlatStyle.Flat;
|
||
btnSave.FlatAppearance.BorderSize = 0;
|
||
btnSave.BackColor = ThemeBlue;
|
||
btnSave.ForeColor = Color.White;
|
||
btnSave.Font = new Font("Microsoft YaHei UI", 11F, FontStyle.Bold);
|
||
btnSave.Cursor = Cursors.Hand;
|
||
btnSave.Click += delegate { SaveImage(); };
|
||
left.Controls.Add(btnSave);
|
||
y += 52;
|
||
|
||
lblStatus = new Label();
|
||
lblStatus.Text = "请填写服务器连接信息后点击连接";
|
||
lblStatus.Location = new Point(x2, y);
|
||
lblStatus.Size = new Size(iw, 18);
|
||
lblStatus.ForeColor = Color.FromArgb(120, 130, 140);
|
||
left.Controls.Add(lblStatus);
|
||
|
||
lblChartTitle = new Label();
|
||
lblChartTitle.Dock = DockStyle.Top;
|
||
lblChartTitle.Height = 36;
|
||
lblChartTitle.TextAlign = ContentAlignment.MiddleCenter;
|
||
lblChartTitle.Font = new Font("Microsoft YaHei UI", 12F, FontStyle.Bold);
|
||
lblChartTitle.ForeColor = ThemeBlue;
|
||
lblChartTitle.Text = "";
|
||
right.Controls.Add(lblChartTitle);
|
||
|
||
legendBar = new Panel();
|
||
legendBar.Dock = DockStyle.Top;
|
||
legendBar.Height = 30;
|
||
legendBar.BackColor = Color.FromArgb(250, 250, 252);
|
||
legendBar.Visible = false;
|
||
right.Controls.Add(legendBar);
|
||
|
||
legendFlow = new FlowLayoutPanel();
|
||
legendFlow.Dock = DockStyle.Fill;
|
||
legendFlow.BackColor = Color.FromArgb(250, 250, 252);
|
||
legendFlow.Padding = new Padding(10, 4, 10, 4);
|
||
legendBar.Controls.Add(legendFlow);
|
||
|
||
Panel bar = new Panel();
|
||
bar.Dock = DockStyle.Top;
|
||
bar.Height = 44;
|
||
bar.BackColor = Color.FromArgb(240, 243, 247);
|
||
right.Controls.Add(bar);
|
||
|
||
Label lTarget = new Label();
|
||
lTarget.Text = "曲线:";
|
||
lTarget.Location = new Point(12, 14);
|
||
lTarget.AutoSize = true;
|
||
lTarget.ForeColor = Color.FromArgb(60, 70, 80);
|
||
bar.Controls.Add(lTarget);
|
||
|
||
cmbCalcTarget = new ComboBox();
|
||
cmbCalcTarget.DropDownStyle = ComboBoxStyle.DropDownList;
|
||
cmbCalcTarget.FlatStyle = FlatStyle.Flat;
|
||
cmbCalcTarget.Location = new Point(52, 8);
|
||
cmbCalcTarget.Size = new Size(86, 26);
|
||
bar.Controls.Add(cmbCalcTarget);
|
||
|
||
Label lCalc = new Label();
|
||
lCalc.Text = "运算:";
|
||
lCalc.Location = new Point(142, 14);
|
||
lCalc.AutoSize = true;
|
||
lCalc.ForeColor = Color.FromArgb(60, 70, 80);
|
||
bar.Controls.Add(lCalc);
|
||
|
||
cmbCalc = new ComboBox();
|
||
cmbCalc.DropDownStyle = ComboBoxStyle.DropDownList;
|
||
cmbCalc.FlatStyle = FlatStyle.Flat;
|
||
cmbCalc.Location = new Point(184, 8);
|
||
cmbCalc.Size = new Size(160, 26);
|
||
cmbCalc.Items.Add("贝叶斯回归 (AI)");
|
||
cmbCalc.Items.Add("常用对数 (log10)");
|
||
cmbCalc.Items.Add("对数 (ln)");
|
||
cmbCalc.Items.Add("多项式拟合 (Polyfit) (AI)");
|
||
cmbCalc.Items.Add("二次变换 (a*y²+b) (AI)");
|
||
cmbCalc.Items.Add("积分 (累积)");
|
||
cmbCalc.Items.Add("开方 (sqrt)");
|
||
cmbCalc.Items.Add("平滑曲线 (滑动平均)");
|
||
cmbCalc.Items.Add("梯度下降 (AI)");
|
||
cmbCalc.Items.Add("微分 (差分)");
|
||
cmbCalc.Items.Add("线性回归 (AI)");
|
||
cmbCalc.Items.Add("线性变换 (a*y+b) (AI)");
|
||
cmbCalc.Items.Add("指数 (exp)");
|
||
int defCalc = cmbCalc.Items.IndexOf("平滑曲线 (滑动平均)");
|
||
cmbCalc.SelectedIndex = defCalc >= 0 ? defCalc : 0;
|
||
cmbCalc.SelectedIndexChanged += delegate { UpdateCalcParamUI(); };
|
||
bar.Controls.Add(cmbCalc);
|
||
|
||
Label lParam = new Label();
|
||
lParam.Text = "无参数";
|
||
lParam.Location = new Point(350, 14);
|
||
lParam.AutoSize = true;
|
||
lParam.ForeColor = Color.FromArgb(60, 70, 80);
|
||
bar.Controls.Add(lParam);
|
||
this.lblCalcParam = lParam;
|
||
|
||
txtCalcParam = new TextBox();
|
||
txtCalcParam.Text = "5";
|
||
txtCalcParam.Location = new Point(398, 8);
|
||
txtCalcParam.Width = 50;
|
||
txtCalcParam.BorderStyle = BorderStyle.FixedSingle;
|
||
txtCalcParam.Enabled = false;
|
||
bar.Controls.Add(txtCalcParam);
|
||
UpdateCalcParamUI();
|
||
|
||
btnApplyCalc = MakeSmallButton("生成运算曲线");
|
||
btnApplyCalc.Location = new Point(456, 6);
|
||
btnApplyCalc.Size = new Size(104, 30);
|
||
btnApplyCalc.BackColor = ThemeBlue;
|
||
btnApplyCalc.Click += delegate { ApplyCalc(); };
|
||
bar.Controls.Add(btnApplyCalc);
|
||
|
||
btnClearCalc = MakeSmallButton("清除运算");
|
||
btnClearCalc.Location = new Point(490, 6);
|
||
btnClearCalc.Size = new Size(92, 30);
|
||
btnClearCalc.BackColor = Color.FromArgb(127, 140, 141);
|
||
btnClearCalc.Click += delegate { ClearCalcSeries(); };
|
||
bar.Controls.Add(btnClearCalc);
|
||
|
||
btnLegend = MakeSmallButton("隐藏图例");
|
||
btnLegend.Location = new Point(588, 6);
|
||
btnLegend.Size = new Size(92, 30);
|
||
btnLegend.BackColor = Color.FromArgb(52, 73, 94);
|
||
btnLegend.Click += delegate { ToggleLegend(); };
|
||
bar.Controls.Add(btnLegend);
|
||
|
||
btnSettings = MakeSmallButton("图表设置");
|
||
btnSettings.Location = new Point(686, 6);
|
||
btnSettings.Size = new Size(92, 30);
|
||
btnSettings.BackColor = Color.FromArgb(52, 73, 94);
|
||
btnSettings.Click += delegate { OpenChartSettings(); };
|
||
bar.Controls.Add(btnSettings);
|
||
|
||
btnCross = MakeSmallButton("隐藏十字线");
|
||
btnCross.Location = new Point(786, 6);
|
||
btnCross.Size = new Size(104, 30);
|
||
btnCross.BackColor = Color.FromArgb(52, 73, 94);
|
||
btnCross.Click += delegate { ToggleCross(); };
|
||
bar.Controls.Add(btnCross);
|
||
|
||
chart = new Chart();
|
||
chart.Dock = DockStyle.Fill;
|
||
chart.BackColor = Color.White;
|
||
chart.BorderlineColor = BorderLine;
|
||
chart.BorderlineWidth = 1;
|
||
ChartArea area = new ChartArea("main");
|
||
area.BackColor = Color.White;
|
||
area.AxisX.MajorGrid.LineColor = Color.FromArgb(235, 238, 242);
|
||
area.AxisY.MajorGrid.LineColor = Color.FromArgb(235, 238, 242);
|
||
area.AxisX.LineColor = BorderLine;
|
||
area.AxisY.LineColor = BorderLine;
|
||
area.AxisX.LabelStyle.Font = new Font("Microsoft YaHei UI", 9F);
|
||
area.AxisY.LabelStyle.Font = new Font("Microsoft YaHei UI", 9F);
|
||
area.AxisX.TitleFont = new Font("Microsoft YaHei UI", 9F, FontStyle.Bold);
|
||
area.AxisY.TitleFont = new Font("Microsoft YaHei UI", 9F, FontStyle.Bold);
|
||
area.AxisX.TitleForeColor = ThemeBlue;
|
||
area.AxisY.TitleForeColor = ThemeBlue;
|
||
chart.ChartAreas.Add(area);
|
||
chart.Legends.Add(new Legend("legend"));
|
||
chart.Legends["legend"].Enabled = false;
|
||
chart.Legends["legend"].Font = new Font("Microsoft YaHei UI", 9F);
|
||
chart.Legends["legend"].BackColor = Color.FromArgb(250, 250, 252);
|
||
chart.Legends["legend"].BorderColor = BorderLine;
|
||
chart.Legends["legend"].BorderWidth = 1;
|
||
chart.Legends["legend"].Alignment = StringAlignment.Near;
|
||
right.Controls.Add(chart);
|
||
|
||
SetupLegendDrag();
|
||
chart.MouseMove += Chart_MouseMove;
|
||
chart.MouseClick += Chart_MouseClick;
|
||
chart.MouseLeave += delegate { crossPos = new PointF(-1, -1); chart.Invalidate(); };
|
||
chart.PostPaint += Chart_PostPaint;
|
||
|
||
btnExpand = MakeIconButton("展开配置", 2);
|
||
btnExpand.Location = new Point(4, 50);
|
||
btnExpand.Size = new Size(110, 32);
|
||
btnExpand.FlatStyle = FlatStyle.Flat;
|
||
btnExpand.FlatAppearance.BorderSize = 0;
|
||
btnExpand.BackColor = ThemeBlue;
|
||
btnExpand.ForeColor = Color.White;
|
||
btnExpand.Font = new Font("Microsoft YaHei UI", 9F, FontStyle.Bold);
|
||
btnExpand.Cursor = Cursors.Hand;
|
||
btnExpand.Visible = false;
|
||
btnExpand.Click += delegate
|
||
{
|
||
left.Visible = true;
|
||
LayoutPanels(left, right, splitterRef);
|
||
btnExpand.Visible = false;
|
||
}; right.Controls.Add(btnExpand);
|
||
btnExpand.BringToFront();
|
||
LayoutLeftPanel();
|
||
}
|
||
|
||
void SetupLegendDrag()
|
||
{
|
||
chart.MouseDown += delegate(object s, MouseEventArgs e)
|
||
{
|
||
if (e.Button != MouseButtons.Left) return;
|
||
try
|
||
{
|
||
Legend lg = chart.Legends["legend"];
|
||
if (!lg.Enabled) return;
|
||
HitTestResult hr = chart.HitTest(e.X, e.Y);
|
||
if (hr != null && hr.ChartElementType == ChartElementType.LegendArea)
|
||
{
|
||
draggingLegend = true;
|
||
dragStart = e.Location;
|
||
chart.Cursor = Cursors.Hand;
|
||
}
|
||
}
|
||
catch { }
|
||
};
|
||
chart.MouseMove += delegate(object s, MouseEventArgs e)
|
||
{
|
||
if (!draggingLegend) return;
|
||
try
|
||
{
|
||
if (chart.Width <= 0 || chart.Height <= 0) return;
|
||
Legend lg = chart.Legends["legend"];
|
||
ElementPosition p = lg.Position;
|
||
p.Auto = false;
|
||
float dx = e.X - dragStart.X;
|
||
float dy = e.Y - dragStart.Y;
|
||
p.X += dx / chart.Width * 100f;
|
||
p.Y += dy / chart.Height * 100f;
|
||
if (p.X < -p.Width) p.X = -p.Width + 2;
|
||
if (p.X > 100) p.X = 98;
|
||
if (p.Y < 0) p.Y = 0;
|
||
if (p.Y > 100) p.Y = 98;
|
||
dragStart = e.Location;
|
||
chart.Invalidate();
|
||
}
|
||
catch { draggingLegend = false; }
|
||
};
|
||
chart.MouseUp += delegate(object s, MouseEventArgs e)
|
||
{
|
||
draggingLegend = false;
|
||
chart.Cursor = Cursors.Default;
|
||
};
|
||
}
|
||
|
||
void Chart_MouseMove(object sender, MouseEventArgs e)
|
||
{
|
||
if (draggingLegend) return;
|
||
try
|
||
{
|
||
ChartArea area = chart.ChartAreas["main"];
|
||
bool inside = IsInPlotArea(e.Location, area);
|
||
PointF np = inside ? new PointF(e.X, e.Y) : new PointF(-1, -1);
|
||
if (np.X != crossPos.X || np.Y != crossPos.Y)
|
||
{
|
||
crossPos = np;
|
||
chart.Invalidate();
|
||
}
|
||
}
|
||
catch { }
|
||
}
|
||
|
||
void Chart_MouseClick(object sender, MouseEventArgs e)
|
||
{
|
||
if (e.Button != MouseButtons.Left) return;
|
||
try
|
||
{
|
||
HitTestResult hr = chart.HitTest(e.X, e.Y);
|
||
if (hr != null && hr.ChartElementType == ChartElementType.DataPoint &&
|
||
hr.Series != null && hr.PointIndex >= 0 &&
|
||
hr.PointIndex < hr.Series.Points.Count)
|
||
{
|
||
ShowFloatTip(e.Location, hr.Series.Name, hr.Series.Points[hr.PointIndex], hr.PointIndex);
|
||
}
|
||
else
|
||
{
|
||
CloseFloatTip();
|
||
}
|
||
}
|
||
catch { }
|
||
}
|
||
|
||
void Chart_PostPaint(object sender, ChartPaintEventArgs e)
|
||
{
|
||
if (e.ChartElement != chart || !showCross || crossPos.X < 0) return;
|
||
try
|
||
{
|
||
ChartArea area = chart.ChartAreas["main"];
|
||
RectangleF pa = GetPlotAreaRect(area);
|
||
if (pa.Width <= 0 || pa.Height <= 0) return;
|
||
if (!pa.Contains(crossPos)) return;
|
||
using (Pen pen = new Pen(Color.FromArgb(150, 90, 90, 90)))
|
||
{
|
||
pen.DashStyle = DashStyle.Dash;
|
||
Graphics g = e.ChartGraphics.Graphics;
|
||
g.DrawLine(pen, pa.Left, crossPos.Y, pa.Right, crossPos.Y);
|
||
g.DrawLine(pen, crossPos.X, pa.Top, crossPos.X, pa.Bottom);
|
||
}
|
||
}
|
||
catch { }
|
||
}
|
||
|
||
RectangleF GetPlotAreaRect(ChartArea area)
|
||
{
|
||
ElementPosition areaPos = area.Position;
|
||
ElementPosition inner = area.InnerPlotPosition;
|
||
if (areaPos == null || inner == null || inner.Width <= 0 || inner.Height <= 0)
|
||
return RectangleF.Empty;
|
||
float ax = chart.Width * areaPos.X / 100f;
|
||
float ay = chart.Height * areaPos.Y / 100f;
|
||
float aw = chart.Width * areaPos.Width / 100f;
|
||
float ah = chart.Height * areaPos.Height / 100f;
|
||
return new RectangleF(
|
||
ax + aw * inner.X / 100f,
|
||
ay + ah * inner.Y / 100f,
|
||
aw * inner.Width / 100f,
|
||
ah * inner.Height / 100f);
|
||
}
|
||
|
||
bool IsInPlotArea(Point p, ChartArea area)
|
||
{
|
||
RectangleF pa = GetPlotAreaRect(area);
|
||
return pa.Width > 0 && pa.Height > 0 && pa.Contains(p);
|
||
}
|
||
|
||
void ShowFloatTip(Point chartPoint, string seriesName, DataPoint dp, int pointIndex)
|
||
{
|
||
CloseFloatTip();
|
||
string xStr;
|
||
if (!string.IsNullOrEmpty(dp.AxisLabel))
|
||
xStr = dp.AxisLabel;
|
||
else if (dp.XValue > 1000 && dp.XValue < 400000)
|
||
{
|
||
try { xStr = DateTime.FromOADate(dp.XValue).ToString("yyyy-MM-dd HH:mm:ss"); }
|
||
catch { xStr = dp.XValue.ToString("0.####"); }
|
||
}
|
||
else
|
||
xStr = dp.XValue.ToString("0.####");
|
||
string yStr = dp.YValues.Length > 0 ? dp.YValues[0].ToString("0.####") : "N/A";
|
||
string idxStr = pointIndex.ToString();
|
||
|
||
Form f = new Form();
|
||
f.FormBorderStyle = FormBorderStyle.None;
|
||
f.ShowInTaskbar = false;
|
||
f.TopMost = true;
|
||
f.StartPosition = FormStartPosition.Manual;
|
||
f.BackColor = Color.FromArgb(48, 56, 66);
|
||
f.AutoSize = true;
|
||
f.Padding = new Padding(10, 8, 10, 8);
|
||
f.Font = new Font("Microsoft YaHei UI", 9F);
|
||
|
||
TableLayoutPanel tbl = new TableLayoutPanel();
|
||
tbl.AutoSize = true;
|
||
tbl.AutoSizeMode = AutoSizeMode.GrowAndShrink;
|
||
tbl.ColumnCount = 2;
|
||
tbl.RowCount = 4;
|
||
tbl.Dock = DockStyle.Fill;
|
||
f.Controls.Add(tbl);
|
||
|
||
AddTipCell(tbl, 0, 0, "曲线:", true, Color.White);
|
||
AddTipCell(tbl, 1, 0, seriesName, false, Color.FromArgb(110, 190, 255));
|
||
AddTipCell(tbl, 0, 1, "X:", true, Color.White);
|
||
AddTipCell(tbl, 1, 1, xStr, false, Color.White);
|
||
AddTipCell(tbl, 0, 2, "Y:", true, Color.White);
|
||
AddTipCell(tbl, 1, 2, yStr, false, Color.FromArgb(255, 220, 120));
|
||
AddTipCell(tbl, 0, 3, "序号:", true, Color.White);
|
||
AddTipCell(tbl, 1, 3, idxStr, false, Color.White);
|
||
|
||
Point sp = chart.PointToScreen(chartPoint);
|
||
f.Location = new Point(sp.X + 16, sp.Y + 16);
|
||
f.Deactivate += delegate { CloseFloatTip(); };
|
||
f.Show();
|
||
floatTip = f;
|
||
Screen sc = Screen.FromPoint(sp);
|
||
if (f.Location.X + f.Width > sc.WorkingArea.Right)
|
||
f.Location = new Point(sp.X - f.Width - 16, f.Location.Y);
|
||
if (f.Location.Y + f.Height > sc.WorkingArea.Bottom)
|
||
f.Location = new Point(f.Location.X, sp.Y - f.Height - 16);
|
||
}
|
||
|
||
void AddTipCell(TableLayoutPanel tbl, int col, int row, string text, bool bold, Color color)
|
||
{
|
||
Label l = new Label();
|
||
l.Text = text;
|
||
l.AutoSize = true;
|
||
l.Margin = new Padding(2);
|
||
l.ForeColor = color;
|
||
l.Font = new Font("Microsoft YaHei UI", 9F, bold ? FontStyle.Bold : FontStyle.Regular);
|
||
l.BackColor = Color.Transparent;
|
||
tbl.Controls.Add(l, col, row);
|
||
}
|
||
|
||
void CloseFloatTip()
|
||
{
|
||
if (floatTip != null)
|
||
{
|
||
Form f = floatTip;
|
||
floatTip = null;
|
||
try { f.Close(); }
|
||
catch { }
|
||
}
|
||
}
|
||
|
||
Button MakeToolButton(string text)
|
||
{
|
||
Button b = new Button();
|
||
b.Text = text;
|
||
b.FlatStyle = FlatStyle.Flat;
|
||
b.FlatAppearance.BorderColor = BorderLine;
|
||
b.FlatAppearance.BorderSize = 1;
|
||
b.BackColor = Color.White;
|
||
b.ForeColor = Color.FromArgb(60, 70, 80);
|
||
b.Font = new Font("Microsoft YaHei UI", 9F);
|
||
b.Cursor = Cursors.Hand;
|
||
return b;
|
||
}
|
||
|
||
Button MakeIconButton(string text, int iconType)
|
||
{
|
||
Button b = new Button();
|
||
b.Text = "";
|
||
b.Tag = text;
|
||
b.FlatStyle = FlatStyle.Flat;
|
||
b.FlatAppearance.BorderColor = BorderLine;
|
||
b.FlatAppearance.BorderSize = 1;
|
||
b.BackColor = Color.White;
|
||
b.ForeColor = Color.FromArgb(60, 70, 80);
|
||
b.Font = new Font("Microsoft YaHei UI", 9F);
|
||
b.Cursor = Cursors.Hand;
|
||
b.Paint += delegate(object s, PaintEventArgs e)
|
||
{
|
||
Button bb = (Button)s;
|
||
Graphics g = e.Graphics;
|
||
g.SmoothingMode = SmoothingMode.AntiAlias;
|
||
g.TextRenderingHint = System.Drawing.Text.TextRenderingHint.ClearTypeGridFit;
|
||
string t = bb.Tag as string;
|
||
if (string.IsNullOrEmpty(t)) return;
|
||
SizeF ts = g.MeasureString(t, bb.Font);
|
||
int totalW = 16 + 6 + (int)Math.Ceiling(ts.Width);
|
||
int x0 = (bb.ClientSize.Width - totalW) / 2;
|
||
if (x0 < 2) x0 = 2;
|
||
int y0 = (bb.ClientSize.Height - 16) / 2;
|
||
using (Pen p = new Pen(bb.ForeColor, 2))
|
||
{
|
||
p.StartCap = LineCap.Round;
|
||
p.EndCap = LineCap.Round;
|
||
if (iconType == 0)
|
||
{
|
||
g.DrawLine(p, x0 + 13, y0 + 8, x0 + 3, y0 + 8);
|
||
g.DrawLine(p, x0 + 3, y0 + 8, x0 + 8, y0 + 3);
|
||
g.DrawLine(p, x0 + 3, y0 + 8, x0 + 8, y0 + 13);
|
||
}
|
||
else if (iconType == 1)
|
||
{
|
||
g.DrawEllipse(p, x0 + 5, y0 + 1, 6, 6);
|
||
g.DrawLine(p, x0 + 8, y0 + 7, x0 + 8, y0 + 13);
|
||
g.DrawLine(p, x0 + 4, y0 + 13, x0 + 12, y0 + 13);
|
||
}
|
||
else
|
||
{
|
||
g.DrawLine(p, x0 + 3, y0 + 8, x0 + 13, y0 + 8);
|
||
g.DrawLine(p, x0 + 13, y0 + 8, x0 + 8, y0 + 3);
|
||
g.DrawLine(p, x0 + 13, y0 + 8, x0 + 8, y0 + 13);
|
||
}
|
||
}
|
||
using (SolidBrush br = new SolidBrush(bb.ForeColor))
|
||
{
|
||
g.DrawString(t, bb.Font, br, x0 + 22, (bb.ClientSize.Height - ts.Height) / 2f);
|
||
}
|
||
};
|
||
return b;
|
||
}
|
||
|
||
ComboBox MakeCombo()
|
||
{
|
||
ComboBox c = new ComboBox();
|
||
c.DropDownStyle = ComboBoxStyle.DropDownList;
|
||
c.FlatStyle = FlatStyle.Flat;
|
||
c.BackColor = Color.White;
|
||
return c;
|
||
}
|
||
|
||
Button MakeSmallButton(string text)
|
||
{
|
||
Button b = new Button();
|
||
b.Text = text;
|
||
b.FlatStyle = FlatStyle.Flat;
|
||
b.FlatAppearance.BorderSize = 0;
|
||
b.ForeColor = Color.White;
|
||
b.Font = new Font("Microsoft YaHei UI", 9F, FontStyle.Bold);
|
||
b.Cursor = Cursors.Hand;
|
||
return b;
|
||
}
|
||
|
||
void AddLabel(Control parent, string text, int x, int y)
|
||
{
|
||
Label l = new Label();
|
||
l.Text = text;
|
||
l.Location = new Point(x, y + 4);
|
||
l.AutoSize = false;
|
||
l.Width = 84;
|
||
l.Height = 24;
|
||
l.TextAlign = ContentAlignment.MiddleRight;
|
||
l.ForeColor = Color.FromArgb(60, 70, 80);
|
||
parent.Controls.Add(l);
|
||
}
|
||
|
||
void AddLabel2(Control parent, string text, int x, int y)
|
||
{
|
||
Label l = new Label();
|
||
l.Text = text;
|
||
l.Location = new Point(x, y + 4);
|
||
l.AutoSize = false;
|
||
l.Width = 38;
|
||
l.Height = 24;
|
||
l.TextAlign = ContentAlignment.MiddleRight;
|
||
l.ForeColor = Color.FromArgb(60, 70, 80);
|
||
parent.Controls.Add(l);
|
||
}
|
||
|
||
void AddLabel3(Control parent, string text, int x, int y)
|
||
{
|
||
Label l = new Label();
|
||
l.Text = text;
|
||
l.Location = new Point(x, y + 4);
|
||
l.AutoSize = false;
|
||
l.Width = 90;
|
||
l.Height = 24;
|
||
l.TextAlign = ContentAlignment.MiddleRight;
|
||
l.ForeColor = Color.FromArgb(60, 70, 80);
|
||
parent.Controls.Add(l);
|
||
}
|
||
|
||
TextBox AddText(Control parent, string text, int x, int y, int width)
|
||
{
|
||
return AddText(parent, text, x, y, width, false);
|
||
}
|
||
|
||
TextBox AddText(Control parent, string text, int x, int y, int width, bool password)
|
||
{
|
||
TextBox t = new TextBox();
|
||
t.Text = text;
|
||
t.Location = new Point(x, y);
|
||
t.Width = width;
|
||
t.BorderStyle = BorderStyle.FixedSingle;
|
||
t.UseSystemPasswordChar = password;
|
||
parent.Controls.Add(t);
|
||
return t;
|
||
}
|
||
|
||
void LayoutPanels(Panel leftP, Panel rightP, Panel splitterP)
|
||
{
|
||
int w = ClientSize.Width;
|
||
int h = ClientSize.Height;
|
||
if (w < 100 || h < 100) return;
|
||
int lw = leftP.Visible ? leftP.Width : 0;
|
||
if (lw > 0)
|
||
{
|
||
leftP.Location = new Point(0, 0);
|
||
leftP.Size = new Size(lw, h);
|
||
leftP.Padding = new Padding(12, 8, 12, 8);
|
||
splitterP.Location = new Point(lw, 0);
|
||
splitterP.Size = new Size(5, h);
|
||
splitterP.Visible = true;
|
||
rightP.Location = new Point(lw + 5, 0);
|
||
}
|
||
else
|
||
{
|
||
splitterP.Visible = false;
|
||
rightP.Location = new Point(0, 0);
|
||
}
|
||
rightP.Size = new Size(w - rightP.Location.X, h);
|
||
}
|
||
|
||
const int MinLeftLayoutW = 380;
|
||
|
||
void LayoutLeftPanel()
|
||
{
|
||
try
|
||
{
|
||
int layW = Math.Max(left.ClientSize.Width, MinLeftLayoutW);
|
||
int x2 = 8;
|
||
int availW = layW - 12 - x2;
|
||
int inputX = x2 + 88;
|
||
int inputW = availW - 88;
|
||
int gap = 12;
|
||
|
||
int leftColW = (int)(availW * 0.54);
|
||
int w1 = leftColW - 88 - gap;
|
||
if (w1 < 100) w1 = 100;
|
||
int rightLabelX = x2 + leftColW;
|
||
int rightInputX = rightLabelX + 38 + gap;
|
||
int w2 = availW - leftColW - 38 - gap;
|
||
if (w2 < 90) w2 = 90;
|
||
|
||
int bw2 = (availW - 8) / 2;
|
||
|
||
btnCollapse.Location = new Point(x2, 4);
|
||
btnCollapse.Size = new Size(bw2, 30);
|
||
btnPin.Location = new Point(x2 + bw2 + 8, 4);
|
||
btnPin.Size = new Size(availW - bw2 - 8, 30);
|
||
|
||
txtHost.Location = new Point(inputX, 74);
|
||
txtHost.Width = w1;
|
||
txtPort.Location = new Point(rightInputX, 74);
|
||
txtPort.Width = w2;
|
||
txtUser.Location = new Point(inputX, 110);
|
||
txtUser.Width = w1;
|
||
txtPassword.Location = new Point(rightInputX, 110);
|
||
txtPassword.Width = w2;
|
||
|
||
cmbDatabase.Location = new Point(inputX, 146);
|
||
cmbDatabase.Width = inputW;
|
||
btnConnect.Location = new Point(x2, 184);
|
||
btnConnect.Width = availW;
|
||
|
||
cmbOrder.Location = new Point(inputX, 260);
|
||
cmbOrder.Width = w1;
|
||
txtLimit.Location = new Point(rightInputX, 260);
|
||
txtLimit.Width = w2;
|
||
|
||
txtOffset.Location = new Point(inputX, 296);
|
||
txtOffset.Width = inputW;
|
||
txtTailOffset.Location = new Point(inputX, 338);
|
||
txtTailOffset.Width = inputW;
|
||
|
||
cmbTable.Location = new Point(inputX, 410);
|
||
cmbTable.Width = inputW;
|
||
cmbX.Location = new Point(inputX, 446);
|
||
cmbX.Width = inputW;
|
||
cmbXType.Location = new Point(inputX, 482);
|
||
cmbXType.Width = inputW;
|
||
lbY.Location = new Point(inputX, 518);
|
||
lbY.Width = inputW;
|
||
|
||
dgvFilter.Location = new Point(x2, 676);
|
||
dgvFilter.Width = availW;
|
||
|
||
int bw3 = (availW - 16) / 3;
|
||
btnAddRule.Location = new Point(x2, 824);
|
||
btnAddRule.Width = bw3;
|
||
btnDelRule.Location = new Point(x2 + bw3 + 8, 824);
|
||
btnDelRule.Width = bw3;
|
||
btnClear.Location = new Point(x2 + bw3 * 2 + 16, 824);
|
||
btnClear.Width = availW - bw3 * 2 - 16;
|
||
|
||
btnPlot.Location = new Point(x2, 862);
|
||
btnPlot.Width = bw2;
|
||
btnSave.Location = new Point(x2 + bw2 + 8, 862);
|
||
btnSave.Width = availW - bw2 - 8;
|
||
|
||
lblStatus.Location = new Point(x2, 914);
|
||
lblStatus.Width = availW;
|
||
|
||
SetLabelX("端口:", rightLabelX);
|
||
SetLabelX("密码:", rightLabelX);
|
||
SetLabelX("条数:", rightLabelX);
|
||
SetLabelX("跳过前 N 行", inputX + inputW + 8);
|
||
SetLabelX("从最新数据往回数 N 条作为查询起点", inputX);
|
||
}
|
||
catch { }
|
||
}
|
||
|
||
Label FindLabel(string text)
|
||
{
|
||
foreach (Control c in left.Controls)
|
||
{
|
||
if (c is Label && c.Text == text) return (Label)c;
|
||
}
|
||
return null;
|
||
}
|
||
|
||
void SetLabelX(string text, int x)
|
||
{
|
||
Label l = FindLabel(text);
|
||
if (l != null) l.Location = new Point(x, l.Location.Y);
|
||
}
|
||
|
||
void TogglePin()
|
||
{
|
||
pinned = !pinned;
|
||
if (pinned)
|
||
{
|
||
btnPin.BackColor = ThemeBlue;
|
||
btnPin.ForeColor = Color.White;
|
||
btnPin.Tag = "已钉住";
|
||
}
|
||
else
|
||
{
|
||
btnPin.BackColor = Color.White;
|
||
btnPin.ForeColor = Color.FromArgb(60, 70, 80);
|
||
btnPin.Tag = "钉住";
|
||
}
|
||
}
|
||
|
||
void SetupSplitterDrag(Panel splitterP)
|
||
{
|
||
bool dragging = false;
|
||
int startX = 0;
|
||
int startWidth = 0;
|
||
splitterP.MouseDown += delegate(object s, MouseEventArgs e)
|
||
{
|
||
if (pinned) return;
|
||
dragging = true;
|
||
startX = e.X;
|
||
startWidth = left.Width;
|
||
splitterP.Capture = true;
|
||
};
|
||
splitterP.MouseMove += delegate(object s, MouseEventArgs e)
|
||
{
|
||
if (!dragging) return;
|
||
int newWidth = startWidth + (e.X - startX);
|
||
if (newWidth < 380) newWidth = 380;
|
||
if (newWidth > 800) newWidth = 800;
|
||
left.Width = newWidth;
|
||
LayoutPanels(left, (Panel)right, splitterP);
|
||
};
|
||
splitterP.MouseUp += delegate(object s, MouseEventArgs e)
|
||
{
|
||
dragging = false;
|
||
splitterP.Capture = false;
|
||
};
|
||
}
|
||
|
||
void FillConnFields()
|
||
{
|
||
txtHost.Text = config.Host;
|
||
txtPort.Text = config.Port;
|
||
txtUser.Text = config.User;
|
||
txtPassword.Text = config.Password;
|
||
cmbDatabase.Items.Clear();
|
||
if (!string.IsNullOrEmpty(config.Database))
|
||
{
|
||
cmbDatabase.Items.Add(config.Database);
|
||
cmbDatabase.SelectedIndex = 0;
|
||
}
|
||
}
|
||
|
||
void SaveConfigFromFields()
|
||
{
|
||
config.Host = txtHost.Text.Trim();
|
||
config.Port = txtPort.Text.Trim();
|
||
config.User = txtUser.Text.Trim();
|
||
config.Password = txtPassword.Text;
|
||
string db = cmbDatabase.SelectedItem as string;
|
||
if (string.IsNullOrEmpty(db)) db = cmbDatabase.Text.Trim();
|
||
config.Database = db == null ? "" : db;
|
||
try { config.Save(configPath); }
|
||
catch { }
|
||
}
|
||
|
||
void SetStatus(string text, bool error)
|
||
{
|
||
lblStatus.Text = text;
|
||
lblStatus.ForeColor = error ? Color.FromArgb(192, 57, 43) : Color.FromArgb(39, 120, 60);
|
||
}
|
||
|
||
MySqlConnection OpenConn()
|
||
{
|
||
SaveConfigFromFields();
|
||
return OpenConn(config.Database);
|
||
}
|
||
|
||
MySqlConnection OpenConn(string db)
|
||
{
|
||
try
|
||
{
|
||
MySqlConnectionStringBuilder b = new MySqlConnectionStringBuilder();
|
||
b.Server = config.Host;
|
||
b.Port = uint.Parse(config.Port);
|
||
b.UserID = config.User;
|
||
b.Password = config.Password;
|
||
if (!string.IsNullOrEmpty(db)) b.Database = db;
|
||
b.CharacterSet = config.Charset;
|
||
b.ConnectionTimeout = 10;
|
||
MySqlConnection conn = new MySqlConnection(b.ConnectionString);
|
||
conn.Open();
|
||
return conn;
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
SetStatus("连接失败: " + ex.Message, true);
|
||
MessageBox.Show(this, "无法连接数据库:\n" + ex.Message, "连接失败",
|
||
MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
return null;
|
||
}
|
||
}
|
||
|
||
void ConnectAndLoad()
|
||
{
|
||
SaveConfigFromFields();
|
||
MySqlConnection conn = OpenConn("");
|
||
if (conn == null) return;
|
||
try
|
||
{
|
||
List<string> dbs = new List<string>();
|
||
using (MySqlCommand cmd = new MySqlCommand("SHOW DATABASES", conn))
|
||
using (IDataReader r = cmd.ExecuteReader())
|
||
{
|
||
while (r.Read()) dbs.Add(r.GetString(0));
|
||
}
|
||
string prevDb = config.Database;
|
||
loadingDbs = true;
|
||
cmbDatabase.Items.Clear();
|
||
foreach (string d in dbs) cmbDatabase.Items.Add(d);
|
||
int sel = dbs.IndexOf(prevDb);
|
||
if (sel >= 0) cmbDatabase.SelectedIndex = sel;
|
||
else if (dbs.Count > 0) cmbDatabase.SelectedIndex = 0;
|
||
loadingDbs = false;
|
||
config.Database = cmbDatabase.SelectedItem as string;
|
||
if (string.IsNullOrEmpty(config.Database))
|
||
{
|
||
SetStatus("连接成功，但没有可用数据库", true);
|
||
return;
|
||
}
|
||
try { config.Save(configPath); } catch { }
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
SetStatus("读取数据库列表失败: " + ex.Message, true);
|
||
return;
|
||
}
|
||
finally
|
||
{
|
||
conn.Close();
|
||
}
|
||
MySqlConnection conn2 = OpenConn(config.Database);
|
||
if (conn2 == null) return;
|
||
try { LoadTables(conn2); }
|
||
finally { conn2.Close(); }
|
||
}
|
||
|
||
void DatabaseSelected()
|
||
{
|
||
if (loadingDbs) return;
|
||
string db = cmbDatabase.SelectedItem as string;
|
||
if (string.IsNullOrEmpty(db)) db = cmbDatabase.Text.Trim();
|
||
if (string.IsNullOrEmpty(db)) return;
|
||
SaveConfigFromFields();
|
||
config.Database = db;
|
||
try { config.Save(configPath); } catch { }
|
||
MySqlConnection conn = OpenConn(db);
|
||
if (conn == null) return;
|
||
try { LoadTables(conn); }
|
||
finally { conn.Close(); }
|
||
}
|
||
|
||
void LoadTables(MySqlConnection conn)
|
||
{
|
||
try
|
||
{
|
||
List<string> tables = new List<string>();
|
||
using (MySqlCommand cmd = new MySqlCommand("SHOW TABLES", conn))
|
||
using (IDataReader r = cmd.ExecuteReader())
|
||
{
|
||
while (r.Read()) tables.Add(r.GetString(0));
|
||
}
|
||
cmbTable.Items.Clear();
|
||
foreach (string t in tables) cmbTable.Items.Add(t);
|
||
if (tables.Count > 0) cmbTable.SelectedIndex = 0;
|
||
SetStatus("已连接，共 " + tables.Count + " 张表", false);
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
SetStatus("读取表列表失败: " + ex.Message, true);
|
||
}
|
||
}
|
||
|
||
void TableSelected()
|
||
{
|
||
string table = cmbTable.SelectedItem as string;
|
||
if (string.IsNullOrEmpty(table)) return;
|
||
MySqlConnection conn = OpenConn();
|
||
if (conn == null) return;
|
||
try
|
||
{
|
||
List<string> cols = new List<string>();
|
||
using (MySqlCommand cmd = new MySqlCommand(
|
||
"SELECT * FROM `" + EscapeIdent(table) + "` LIMIT 0", conn))
|
||
using (IDataReader r = cmd.ExecuteReader())
|
||
{
|
||
for (int i = 0; i < r.FieldCount; i++)
|
||
cols.Add(r.GetName(i));
|
||
}
|
||
allColumns = cols;
|
||
cmbX.Items.Clear();
|
||
foreach (string c in cols) cmbX.Items.Add(c);
|
||
if (cols.Count > 0) cmbX.SelectedIndex = 0;
|
||
lbY.Items.Clear();
|
||
foreach (string c in cols) lbY.Items.Add(c);
|
||
DataGridViewComboBoxColumn colCol = (DataGridViewComboBoxColumn)dgvFilter.Columns[0];
|
||
colCol.Items.Clear();
|
||
foreach (string c in cols) colCol.Items.Add(c);
|
||
dgvFilter.Rows.Clear();
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
SetStatus("读取列失败: " + ex.Message, true);
|
||
}
|
||
finally
|
||
{
|
||
conn.Close();
|
||
}
|
||
}
|
||
|
||
static string EscapeIdent(string name)
|
||
{
|
||
return name.Replace("`", "``");
|
||
}
|
||
|
||
void AddRule()
|
||
{
|
||
if (allColumns.Count == 0)
|
||
{
|
||
MessageBox.Show(this, "请先连接并选择存储表", "提示");
|
||
return;
|
||
}
|
||
int idx = dgvFilter.Rows.Add();
|
||
dgvFilter.Rows[idx].Cells[0].Value = allColumns[0];
|
||
dgvFilter.Rows[idx].Cells[1].Value = "=";
|
||
dgvFilter.Rows[idx].Cells[3].Value = "AND";
|
||
}
|
||
|
||
void DelRule()
|
||
{
|
||
if (dgvFilter.SelectedRows.Count > 0)
|
||
dgvFilter.Rows.Remove(dgvFilter.SelectedRows[0]);
|
||
else if (dgvFilter.Rows.Count > 0)
|
||
dgvFilter.Rows.RemoveAt(dgvFilter.Rows.Count - 1);
|
||
}
|
||
|
||
string BuildFilterCondition(DataGridViewRow row)
|
||
{
|
||
string col = (row.Cells[0].Value == null ? "" : row.Cells[0].Value.ToString().Trim());
|
||
string op = (row.Cells[1].Value == null ? "" : row.Cells[1].Value.ToString().Trim());
|
||
string val = (row.Cells[2].Value == null ? "" : row.Cells[2].Value.ToString().Trim());
|
||
if (col.Length == 0 || op.Length == 0) return null;
|
||
string colId = "`" + EscapeIdent(col) + "`";
|
||
string esc = val.Replace("'", "''");
|
||
switch (op)
|
||
{
|
||
case "IS NULL": return colId + " IS NULL";
|
||
case "IS NOT NULL": return colId + " IS NOT NULL";
|
||
case "BETWEEN":
|
||
string[] parts = val.Split(',');
|
||
if (parts.Length != 2) return null;
|
||
return colId + " BETWEEN '" + parts[0].Trim().Replace("'", "''")
|
||
+ "' AND '" + parts[1].Trim().Replace("'", "''") + "'";
|
||
case "LIKE":
|
||
if (val.Length == 0) return null;
|
||
return colId + " LIKE '" + esc + "'";
|
||
default:
|
||
if (val.Length == 0) return null;
|
||
return colId + " " + op + " '" + esc + "'";
|
||
}
|
||
}
|
||
|
||
class FilterItem
|
||
{
|
||
public string Cond;
|
||
public bool IsOr;
|
||
}
|
||
|
||
List<FilterItem> CollectFilterItems()
|
||
{
|
||
List<FilterItem> items = new List<FilterItem>();
|
||
foreach (DataGridViewRow row in dgvFilter.Rows)
|
||
{
|
||
if (row.IsNewRow) continue;
|
||
string cond = BuildFilterCondition(row);
|
||
if (cond == null) continue;
|
||
FilterItem it = new FilterItem();
|
||
it.Cond = cond;
|
||
object lv = row.Cells[3].Value;
|
||
it.IsOr = (lv != null && lv.ToString().Trim().Equals("OR", StringComparison.OrdinalIgnoreCase));
|
||
items.Add(it);
|
||
}
|
||
return items;
|
||
}
|
||
|
||
string BuildWhere(List<FilterItem> items)
|
||
{
|
||
if (items.Count == 0) return "";
|
||
StringBuilder sb = new StringBuilder(" WHERE ");
|
||
for (int i = 0; i < items.Count; i++)
|
||
{
|
||
if (i > 0) sb.Append(items[i - 1].IsOr ? " OR " : " AND ");
|
||
sb.Append(items[i].Cond);
|
||
}
|
||
return sb.ToString();
|
||
}
|
||
|
||
string BuildOrderLimit(string xcol)
|
||
{
|
||
bool desc = cmbOrder.SelectedIndex == 1;
|
||
int limit = 0, offset = 0, tail = 0;
|
||
int.TryParse(txtLimit.Text.Trim(), out limit);
|
||
int.TryParse(txtOffset.Text.Trim(), out offset);
|
||
int.TryParse(txtTailOffset.Text.Trim(), out tail);
|
||
StringBuilder sb = new StringBuilder();
|
||
if (tail > 0)
|
||
{
|
||
sb.Append(" ORDER BY `").Append(EscapeIdent(xcol)).Append("` DESC");
|
||
if (limit > 0)
|
||
{
|
||
sb.Append(" LIMIT ").Append(limit);
|
||
sb.Append(" OFFSET ").Append(tail);
|
||
}
|
||
return sb.ToString();
|
||
}
|
||
sb.Append(" ORDER BY `").Append(EscapeIdent(xcol)).Append("` ");
|
||
sb.Append(desc ? "DESC" : "ASC");
|
||
if (limit > 0)
|
||
{
|
||
sb.Append(" LIMIT ").Append(limit);
|
||
if (offset > 0)
|
||
sb.Append(" OFFSET ").Append(offset);
|
||
}
|
||
return sb.ToString();
|
||
}
|
||
|
||
void Plot()
|
||
{
|
||
string table = cmbTable.SelectedItem as string;
|
||
string xcol = cmbX.SelectedItem as string;
|
||
List<string> ycols = new List<string>();
|
||
foreach (object o in lbY.SelectedItems) ycols.Add(o.ToString());
|
||
if (string.IsNullOrEmpty(table) || string.IsNullOrEmpty(xcol))
|
||
{
|
||
MessageBox.Show(this, "请先选择存储表和横坐标", "提示");
|
||
return;
|
||
}
|
||
if (ycols.Count == 0)
|
||
{
|
||
MessageBox.Show(this, "请至少选择一条 Y 轴曲线列", "提示");
|
||
return;
|
||
}
|
||
List<FilterItem> filters = CollectFilterItems();
|
||
btnPlot.Enabled = false;
|
||
Thread t = new Thread(delegate () { DoPlot(table, xcol, ycols, filters); });
|
||
t.IsBackground = true;
|
||
t.Start();
|
||
}
|
||
|
||
void DoPlot(string table, string xcol, List<string> ycols, List<FilterItem> filters)
|
||
{
|
||
MySqlConnection conn = null;
|
||
try
|
||
{
|
||
conn = OpenConn();
|
||
if (conn == null) return;
|
||
StringBuilder sb = new StringBuilder();
|
||
sb.Append("SELECT `").Append(EscapeIdent(xcol)).Append("`");
|
||
foreach (string y in ycols)
|
||
sb.Append(", `").Append(EscapeIdent(y)).Append("`");
|
||
sb.Append(" FROM `").Append(EscapeIdent(table)).Append("`");
|
||
sb.Append(BuildWhere(filters));
|
||
sb.Append(BuildOrderLimit(xcol));
|
||
List<object[]> rows = new List<object[]>();
|
||
using (MySqlCommand cmd = new MySqlCommand(sb.ToString(), conn))
|
||
using (IDataReader r = cmd.ExecuteReader())
|
||
{
|
||
while (r.Read())
|
||
{
|
||
object[] vals = new object[r.FieldCount];
|
||
r.GetValues(vals);
|
||
rows.Add(vals);
|
||
}
|
||
}
|
||
BeginInvoke(new Action(delegate ()
|
||
{
|
||
lastRows = rows;
|
||
lastXcol = xcol;
|
||
lastYcols = ycols;
|
||
lastTable = table;
|
||
int tailOfs = 0;
|
||
int.TryParse(txtTailOffset.Text.Trim(), out tailOfs);
|
||
if (cmbOrder.SelectedIndex == 1 || tailOfs > 0)
|
||
rows.Reverse();
|
||
RenderPlot(rows, xcol, ycols, table);
|
||
}));
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
BeginInvoke(new Action(delegate ()
|
||
{
|
||
SetStatus("查询失败: " + ex.Message, true);
|
||
MessageBox.Show(this, "查询失败:\n" + ex.Message, "错误",
|
||
MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
}));
|
||
}
|
||
finally
|
||
{
|
||
if (conn != null) conn.Close();
|
||
BeginInvoke(new Action(delegate () { btnPlot.Enabled = true; }));
|
||
}
|
||
}
|
||
|
||
void RenderPlot(List<object[]> rows, string xcol, List<string> ycols, string table)
|
||
{
|
||
CloseFloatTip();
|
||
chart.Series.Clear();
|
||
calcSeriesNames.Clear();
|
||
paletteCounter = 0;
|
||
lblChartTitle.Text = table + " 曲线图";
|
||
if (rows.Count == 0)
|
||
{
|
||
SetStatus("没有符合条件的数据", true);
|
||
return;
|
||
}
|
||
cmbCalcTarget.Items.Clear();
|
||
foreach (string y in ycols) cmbCalcTarget.Items.Add(y);
|
||
if (cmbCalcTarget.Items.Count > 0) cmbCalcTarget.SelectedIndex = 0;
|
||
XAxisInfo xa = AnalyzeXAxis(rows);
|
||
bool xNumeric = xa.Numeric;
|
||
bool xIsTime = xa.IsTime;
|
||
bool xSparseTime = xa.Sparse;
|
||
bool hasTime = xa.HasTime;
|
||
DateTime[] xTimes = xa.Times;
|
||
bool[] xTimeOk = xa.Ok;
|
||
foreach (string y in ycols)
|
||
{
|
||
Series s = new Series(y);
|
||
s.ChartType = SeriesChartType.Line;
|
||
s.BorderWidth = 2;
|
||
s.Color = NextColor();
|
||
for (int i = 0; i < rows.Count; i++)
|
||
{
|
||
object[] row = rows[i];
|
||
object xv = row[0];
|
||
object yv = row[1 + ycols.IndexOf(y)];
|
||
double yNum;
|
||
if (yv == null || yv == DBNull.Value || !TryToDouble(yv, out yNum))
|
||
continue;
|
||
if (xIsTime)
|
||
{
|
||
if (xSparseTime)
|
||
{
|
||
string xStr = xv == null ? "" : xv.ToString();
|
||
s.Points.AddXY(xStr, yNum);
|
||
}
|
||
else
|
||
{
|
||
if (!xTimeOk[i]) continue;
|
||
s.Points.AddXY(xTimes[i], yNum);
|
||
}
|
||
}
|
||
else if (xNumeric)
|
||
{
|
||
double xNum;
|
||
if (xv == null || xv == DBNull.Value || !TryToDouble(xv, out xNum))
|
||
continue;
|
||
s.Points.AddXY(xNum, yNum);
|
||
}
|
||
else
|
||
{
|
||
string xStr = xv == null ? "" : xv.ToString();
|
||
s.Points.AddXY(xStr, yNum);
|
||
}
|
||
}
|
||
chart.Series.Add(s);
|
||
}
|
||
ChartArea area = chart.ChartAreas["main"];
|
||
area.AxisX.Title = xcol;
|
||
area.AxisY.Title = "数值";
|
||
area.AxisX.LabelStyle.Angle = xNumeric ? 0 : -45;
|
||
if (xIsTime)
|
||
{
|
||
if (xSparseTime)
|
||
{
|
||
area.AxisX.LabelStyle.Format = "";
|
||
area.AxisX.LabelStyle.Angle = -45;
|
||
area.AxisX.IntervalAutoMode = IntervalAutoMode.VariableCount;
|
||
SetStatus("绘制完成: 表 " + table + ", X 轴 " + xcol + " (批次时间轴)", false);
|
||
}
|
||
else
|
||
{
|
||
area.AxisX.LabelStyle.Format = hasTime ? "yyyy-MM-dd HH:mm:ss" : "yyyy-MM-dd";
|
||
area.AxisX.IntervalAutoMode = IntervalAutoMode.VariableCount;
|
||
SetStatus("绘制完成: 表 " + table + ", X 轴 " + xcol + ", 曲线 " + ycols.Count + " 条", false);
|
||
}
|
||
}
|
||
else
|
||
{
|
||
area.AxisX.LabelStyle.Format = "";
|
||
SetStatus("绘制完成: 表 " + table + ", X 轴 " + xcol + ", 曲线 " + ycols.Count + " 条", false);
|
||
}
|
||
RenderLegend();
|
||
}
|
||
|
||
class XAxisInfo
|
||
{
|
||
public bool Numeric;
|
||
public bool IsTime;
|
||
public bool Sparse;
|
||
public bool HasTime;
|
||
public DateTime[] Times;
|
||
public bool[] Ok;
|
||
}
|
||
|
||
XAxisInfo AnalyzeXAxis(List<object[]> rows)
|
||
{
|
||
XAxisInfo info = new XAxisInfo();
|
||
int n = rows.Count;
|
||
info.Times = new DateTime[n];
|
||
info.Ok = new bool[n];
|
||
int mode = cmbXType.SelectedIndex;
|
||
if (mode < 0) mode = 0;
|
||
if (mode == 2)
|
||
{
|
||
info.Numeric = true;
|
||
return info;
|
||
}
|
||
if (mode == 3)
|
||
{
|
||
info.Numeric = false;
|
||
return info;
|
||
}
|
||
bool forceTime = (mode == 1);
|
||
bool xNumeric = true;
|
||
int timeCount = 0, badCount = 0;
|
||
for (int i = 0; i < n; i++)
|
||
{
|
||
object xv = rows[i][0];
|
||
if (xv == null || xv == DBNull.Value) continue;
|
||
if (xv is DateTime)
|
||
{
|
||
timeCount++;
|
||
info.Times[i] = (DateTime)xv;
|
||
info.Ok[i] = true;
|
||
if (((DateTime)xv).TimeOfDay != TimeSpan.Zero) info.HasTime = true;
|
||
}
|
||
else
|
||
{
|
||
string s = xv as string;
|
||
if (s != null)
|
||
{
|
||
DateTime dt;
|
||
if (TryParseTime(s, out dt))
|
||
{
|
||
timeCount++;
|
||
info.Times[i] = dt;
|
||
info.Ok[i] = true;
|
||
if (dt.TimeOfDay != TimeSpan.Zero) info.HasTime = true;
|
||
continue;
|
||
}
|
||
badCount++;
|
||
}
|
||
else if (!IsNumeric(xv))
|
||
{
|
||
badCount++;
|
||
}
|
||
if (!forceTime && !IsNumeric(xv)) xNumeric = false;
|
||
}
|
||
}
|
||
if (timeCount > 0)
|
||
{
|
||
if (!forceTime && badCount > 0 && (double)timeCount / (timeCount + badCount) < 0.8)
|
||
{
|
||
info.Numeric = false;
|
||
return info;
|
||
}
|
||
info.IsTime = true;
|
||
info.Numeric = true;
|
||
info.Sparse = IsTimeSparse(info.Times, info.Ok, n);
|
||
return info;
|
||
}
|
||
info.Numeric = xNumeric;
|
||
return info;
|
||
}
|
||
|
||
bool IsTimeSparse(DateTime[] times, bool[] ok, int count)
|
||
{
|
||
List<double> gaps = new List<double>();
|
||
bool hasPrev = false;
|
||
DateTime prev = DateTime.MinValue;
|
||
for (int i = 0; i < count; i++)
|
||
{
|
||
if (!ok[i]) continue;
|
||
if (hasPrev) gaps.Add((times[i] - prev).TotalSeconds);
|
||
prev = times[i];
|
||
hasPrev = true;
|
||
}
|
||
if (gaps.Count < 5) return false;
|
||
double[] sorted = new double[gaps.Count];
|
||
gaps.CopyTo(sorted);
|
||
Array.Sort(sorted);
|
||
double median = sorted[sorted.Length / 2];
|
||
double maxGap = sorted[sorted.Length - 1];
|
||
if (median <= 0) return false;
|
||
return maxGap > median * 30 && maxGap > 3600;
|
||
}
|
||
|
||
void RenderLegend()
|
||
{ try
|
||
{
|
||
legendFlow.Controls.Clear();
|
||
foreach (Series s in chart.Series)
|
||
{
|
||
Panel item = new Panel();
|
||
item.AutoSize = true;
|
||
item.BackColor = Color.Transparent;
|
||
item.Margin = new Padding(0, 0, 12, 0);
|
||
|
||
Label sw = new Label();
|
||
sw.AutoSize = false;
|
||
sw.Width = 14;
|
||
sw.Height = 14;
|
||
sw.BackColor = s.Color;
|
||
sw.Location = new Point(0, 3);
|
||
|
||
Label nm = new Label();
|
||
nm.Text = s.Name;
|
||
nm.AutoSize = true;
|
||
nm.Font = new Font("Microsoft YaHei UI", 9F);
|
||
nm.ForeColor = Color.FromArgb(60, 70, 80);
|
||
nm.Location = new Point(18, 1);
|
||
|
||
item.Controls.Add(sw);
|
||
item.Controls.Add(nm);
|
||
legendFlow.Controls.Add(item);
|
||
}
|
||
int lines = 1;
|
||
float totalW = 0;
|
||
float availW = Math.Max(200, right.ClientSize.Width - 30);
|
||
foreach (Control c in legendFlow.Controls)
|
||
{
|
||
Label nm = (Label)c.Controls[1];
|
||
totalW += 18 + nm.PreferredSize.Width + 12;
|
||
}
|
||
if (totalW > availW && chart.Series.Count > 0)
|
||
lines = Math.Max(1, (int)Math.Ceiling(totalW / availW));
|
||
legendBar.Height = lines * 26 + 8;
|
||
legendBar.Visible = chart.Series.Count > 0 && !legendHiddenByUser;
|
||
}
|
||
catch { }
|
||
}
|
||
|
||
Color NextColor()
|
||
{
|
||
Color[] palette = {
|
||
Color.RoyalBlue, Color.OrangeRed, Color.ForestGreen, Color.Purple,
|
||
Color.DarkOrange, Color.Teal, Color.Crimson, Color.DarkGreen,
|
||
Color.SteelBlue, Color.IndianRed, Color.Olive, Color.MediumVioletRed,
|
||
Color.SlateBlue, Color.SeaGreen, Color.Chocolate, Color.CadetBlue
|
||
};
|
||
Color c = palette[paletteCounter % palette.Length];
|
||
paletteCounter++;
|
||
return c;
|
||
}
|
||
|
||
public void RunDrawTest()
|
||
{
|
||
try
|
||
{
|
||
StringBuilder log = new StringBuilder();
|
||
MySqlConnection conn = OpenConn();
|
||
if (conn == null) return;
|
||
string table = "";
|
||
using (MySqlCommand cmd = new MySqlCommand("SHOW TABLES", conn))
|
||
using (IDataReader r = cmd.ExecuteReader())
|
||
{
|
||
List<string> tables = new List<string>();
|
||
while (r.Read()) tables.Add(r.GetString(0));
|
||
if (tables.Count == 0) throw new Exception("数据库中没有表");
|
||
table = tables[0];
|
||
}
|
||
List<string> cols = new List<string>();
|
||
using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM `" + EscapeIdent(table) + "` LIMIT 0", conn))
|
||
using (IDataReader r = cmd.ExecuteReader())
|
||
{
|
||
for (int i = 0; i < r.FieldCount; i++) cols.Add(r.GetName(i));
|
||
}
|
||
string xcol = cols.IndexOf("Time") >= 0 ? "Time" : (cols.Count > 0 ? cols[0] : "");
|
||
List<string> ycols = new List<string>();
|
||
if (cols.IndexOf("DataValue") >= 0) ycols.Add("DataValue");
|
||
if (ycols.Count == 0 && cols.Count > 1) ycols.Add(cols[1]);
|
||
if (xcol.Length == 0 || ycols.Count == 0) throw new Exception("无法确定横/纵坐标列");
|
||
StringBuilder sb = new StringBuilder();
|
||
sb.Append("SELECT `").Append(EscapeIdent(xcol)).Append("`");
|
||
foreach (string y in ycols)
|
||
sb.Append(", `").Append(EscapeIdent(y)).Append("`");
|
||
sb.Append(" FROM `").Append(EscapeIdent(table)).Append("`");
|
||
sb.Append(" ORDER BY `").Append(EscapeIdent(xcol)).Append("` ASC");
|
||
sb.Append(" LIMIT 300");
|
||
List<object[]> rows = new List<object[]>();
|
||
using (MySqlCommand cmd = new MySqlCommand(sb.ToString(), conn))
|
||
using (IDataReader r = cmd.ExecuteReader())
|
||
{
|
||
while (r.Read())
|
||
{
|
||
object[] vals = new object[r.FieldCount];
|
||
r.GetValues(vals);
|
||
rows.Add(vals);
|
||
}
|
||
}
|
||
conn.Close();
|
||
log.AppendLine("查询行数: " + rows.Count);
|
||
lastRows = rows;
|
||
lastXcol = xcol;
|
||
lastYcols = ycols;
|
||
lastTable = table;
|
||
RenderPlot(rows, xcol, ycols, table);
|
||
Application.DoEvents();
|
||
Thread.Sleep(500);
|
||
lblChartTitle.Text = table + " 曲线图 (drawtest)";
|
||
chart.SaveImage(Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "drawtest.png"), ChartImageFormat.Png);
|
||
log.AppendLine("图表已保存 drawtest.png, 系列数=" + chart.Series.Count + ", 图例启用=" + chart.Legends["legend"].Enabled);
|
||
log.AppendLine("DRAWTEST PASS");
|
||
File.WriteAllText(Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "selftest_result.txt"), log.ToString(), new UTF8Encoding(false));
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
try
|
||
{
|
||
string outFile = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "selftest_result.txt");
|
||
File.WriteAllText(outFile, "DRAWTEST FAIL: " + ex.Message + "\n" + ex.StackTrace, new UTF8Encoding(false));
|
||
}
|
||
catch { }
|
||
}
|
||
Application.Exit();
|
||
}
|
||
|
||
void UpdateCalcParamUI()
|
||
{
|
||
string sel = cmbCalc.SelectedItem as string;
|
||
if (sel == "平滑曲线 (滑动平均)")
|
||
{
|
||
lblCalcParam.Text = "窗口:";
|
||
txtCalcParam.Enabled = true;
|
||
txtCalcParam.Text = "5";
|
||
}
|
||
else if (sel == "多项式拟合 (Polyfit) (AI)")
|
||
{
|
||
lblCalcParam.Text = "阶数:";
|
||
txtCalcParam.Enabled = true;
|
||
txtCalcParam.Text = "3";
|
||
}
|
||
else if (sel == "梯度下降 (AI)")
|
||
{
|
||
lblCalcParam.Text = "迭代:";
|
||
txtCalcParam.Enabled = true;
|
||
txtCalcParam.Text = "200";
|
||
}
|
||
else if (sel == "贝叶斯回归 (AI)")
|
||
{
|
||
lblCalcParam.Text = "α:";
|
||
txtCalcParam.Enabled = true;
|
||
txtCalcParam.Text = "1";
|
||
}
|
||
else if (sel == "线性变换 (a*y+b) (AI)" || sel == "二次变换 (a*y²+b) (AI)")
|
||
{
|
||
lblCalcParam.Text = "a,b:";
|
||
txtCalcParam.Enabled = true;
|
||
txtCalcParam.Text = "1,0";
|
||
}
|
||
else
|
||
{
|
||
lblCalcParam.Text = "无参数";
|
||
txtCalcParam.Enabled = false;
|
||
}
|
||
cmbCalcTarget.Enabled = (sel == "线性变换 (a*y+b) (AI)" || sel == "二次变换 (a*y²+b) (AI)");
|
||
}
|
||
|
||
void ToggleCross()
|
||
{
|
||
showCross = !showCross;
|
||
btnCross.Text = showCross ? "隐藏十字线" : "显示十字线";
|
||
btnCross.BackColor = showCross ? Color.FromArgb(52, 73, 94) : Color.FromArgb(127, 140, 141);
|
||
if (!showCross) crossPos = new PointF(-1, -1);
|
||
chart.Invalidate();
|
||
}
|
||
|
||
void ToggleLegend()
|
||
{
|
||
legendHiddenByUser = !legendHiddenByUser;
|
||
legendBar.Visible = chart.Series.Count > 0 && !legendHiddenByUser;
|
||
btnLegend.Text = legendBar.Visible ? "隐藏图例" : "显示图例";
|
||
btnLegend.BackColor = legendBar.Visible ? Color.FromArgb(52, 73, 94) : Color.FromArgb(127, 140, 141);
|
||
}
|
||
|
||
void OpenChartSettings()
|
||
{
|
||
ChartSettingsForm f = new ChartSettingsForm(chart, lblChartTitle, this);
|
||
f.ShowDialog(this);
|
||
}
|
||
|
||
void ApplyCalc()
|
||
{
|
||
if (lastRows == null || lastRows.Count == 0)
|
||
{
|
||
MessageBox.Show(this, "请先绘制曲线", "提示");
|
||
return;
|
||
}
|
||
int param = 5;
|
||
int.TryParse(txtCalcParam.Text.Trim(), out param);
|
||
string calcName = cmbCalc.SelectedItem as string;
|
||
bool singleCurve = (calcName == "线性变换 (a*y+b) (AI)" || calcName == "二次变换 (a*y²+b) (AI)");
|
||
double a = 1, b = 0;
|
||
string target = "";
|
||
if (singleCurve)
|
||
{
|
||
target = cmbCalcTarget.SelectedItem as string;
|
||
if (string.IsNullOrEmpty(target))
|
||
{
|
||
MessageBox.Show(this, "请先在\"曲线\"下拉框选择目标曲线", "提示");
|
||
return;
|
||
}
|
||
string[] ab = txtCalcParam.Text.Replace("，", ",").Split(',');
|
||
if (ab.Length >= 2)
|
||
{
|
||
double.TryParse(ab[0].Trim(), System.Globalization.NumberStyles.Float, System.Globalization.CultureInfo.InvariantCulture, out a);
|
||
double.TryParse(ab[1].Trim(), System.Globalization.NumberStyles.Float, System.Globalization.CultureInfo.InvariantCulture, out b);
|
||
}
|
||
}
|
||
if (calcName == "平滑曲线 (滑动平均)")
|
||
{
|
||
if (param < 3) param = 3;
|
||
if (param > 101) param = 101;
|
||
}
|
||
else if (calcName == "多项式拟合 (Polyfit) (AI)")
|
||
{
|
||
if (param < 1) param = 1;
|
||
if (param > 10) param = 10;
|
||
}
|
||
else if (calcName == "梯度下降 (AI)")
|
||
{
|
||
if (param < 1) param = 1;
|
||
if (param > 5000) param = 5000;
|
||
}
|
||
else if (calcName == "贝叶斯回归 (AI)")
|
||
{
|
||
if (param < 1) param = 1;
|
||
if (param > 1000) param = 1000;
|
||
}
|
||
else
|
||
{
|
||
param = 1;
|
||
}
|
||
XAxisInfo xa = AnalyzeXAxis(lastRows);
|
||
bool xNumeric = xa.Numeric;
|
||
bool xSparseTime = xa.Sparse;
|
||
foreach (string y in lastYcols)
|
||
{
|
||
if (singleCurve && y != target) continue;
|
||
double[] xs = new double[lastRows.Count];
|
||
double[] ys = new double[lastRows.Count];
|
||
int[] srcIdx = new int[lastRows.Count];
|
||
int n = 0;
|
||
for (int i = 0; i < lastRows.Count; i++)
|
||
{
|
||
object[] row = lastRows[i];
|
||
double xv = n;
|
||
double yv;
|
||
if (!TryToDouble(row[1 + lastYcols.IndexOf(y)], out yv)) continue;
|
||
if (xNumeric && !TryToDouble(row[0], out xv))
|
||
{
|
||
string sx = row[0] as string;
|
||
if (sx == null) continue;
|
||
DateTime dt;
|
||
if (!TryParseTime(sx, out dt)) continue;
|
||
xv = dt.ToOADate();
|
||
}
|
||
xs[n] = xv;
|
||
ys[n] = yv;
|
||
srcIdx[n] = i;
|
||
n++;
|
||
}
|
||
double[] nx = new double[n];
|
||
double[] ny = new double[n];
|
||
Array.Copy(xs, nx, n);
|
||
Array.Copy(ys, ny, n);
|
||
if (n == 0) continue;
|
||
string seriesName = "";
|
||
double[] outY = ComputeCalc(calcName, nx, ny, param, a, b, out seriesName);
|
||
if (outY == null) continue;
|
||
Series s = new Series(seriesName + "(" + y + ")");
|
||
s.ChartType = SeriesChartType.Line;
|
||
s.BorderWidth = 2;
|
||
s.Color = NextColor();
|
||
for (int i = 0; i < n; i++)
|
||
{
|
||
if (double.IsNaN(outY[i])) continue;
|
||
if (xSparseTime || !xNumeric)
|
||
s.Points.AddXY(lastRows[srcIdx[i]][0] == null ? "" : lastRows[srcIdx[i]][0].ToString(), outY[i]);
|
||
else s.Points.AddXY(nx[i], outY[i]);
|
||
}
|
||
chart.Series.Add(s);
|
||
calcSeriesNames.Add(s.Name);
|
||
}
|
||
if (calcSeriesNames.Count > 0)
|
||
SetStatus("已生成运算曲线: " + calcName, false);
|
||
}
|
||
|
||
double[] ComputeCalc(string calcName, double[] xs, double[] ys, int param, double a, double b, out string seriesName)
|
||
{
|
||
int n = ys.Length;
|
||
double[] outY = new double[n];
|
||
for (int i = 0; i < n; i++) outY[i] = double.NaN;
|
||
if (calcName == "对数 (ln)")
|
||
{
|
||
seriesName = "ln";
|
||
for (int i = 0; i < n; i++)
|
||
if (ys[i] > 0) outY[i] = Math.Log(ys[i]);
|
||
}
|
||
else if (calcName == "常用对数 (log10)")
|
||
{
|
||
seriesName = "log10";
|
||
for (int i = 0; i < n; i++)
|
||
if (ys[i] > 0) outY[i] = Math.Log10(ys[i]);
|
||
}
|
||
else if (calcName == "指数 (exp)")
|
||
{
|
||
seriesName = "exp";
|
||
for (int i = 0; i < n; i++)
|
||
outY[i] = Math.Exp(ys[i]);
|
||
}
|
||
else if (calcName == "开方 (sqrt)")
|
||
{
|
||
seriesName = "sqrt";
|
||
for (int i = 0; i < n; i++)
|
||
if (ys[i] >= 0) outY[i] = Math.Sqrt(ys[i]);
|
||
}
|
||
else if (calcName == "微分 (差分)")
|
||
{
|
||
seriesName = "dy/dx";
|
||
for (int i = 1; i < n; i++)
|
||
{
|
||
double dx = xs[i] - xs[i - 1];
|
||
if (dx != 0) outY[i - 1] = (ys[i] - ys[i - 1]) / dx;
|
||
}
|
||
}
|
||
else if (calcName == "积分 (累积)")
|
||
{
|
||
seriesName = "∫ydx";
|
||
double sum = 0;
|
||
for (int i = 1; i < n; i++)
|
||
{
|
||
double dx = xs[i] - xs[i - 1];
|
||
sum += (ys[i] + ys[i - 1]) / 2.0 * dx;
|
||
outY[i] = sum;
|
||
}
|
||
outY[0] = 0;
|
||
}
|
||
else if (calcName == "线性回归 (AI)")
|
||
{
|
||
seriesName = "reg";
|
||
double sx = 0, sy = 0, sxx = 0, sxy = 0;
|
||
for (int i = 0; i < n; i++)
|
||
{
|
||
sx += xs[i]; sy += ys[i]; sxx += xs[i] * xs[i]; sxy += xs[i] * ys[i];
|
||
}
|
||
double denom = n * sxx - sx * sx;
|
||
double coefA = 0, coefB = 0;
|
||
if (Math.Abs(denom) > 1e-12)
|
||
{
|
||
coefA = (n * sxy - sx * sy) / denom;
|
||
coefB = (sy - coefA * sx) / n;
|
||
}
|
||
for (int i = 0; i < n; i++)
|
||
outY[i] = coefA * xs[i] + coefB;
|
||
}
|
||
else if (calcName == "梯度下降 (AI)")
|
||
{
|
||
seriesName = "gd";
|
||
int iters = Math.Max(1, param);
|
||
double mx = 0, my = 0;
|
||
for (int i = 0; i < n; i++) { mx += xs[i]; my += ys[i]; }
|
||
mx /= n; my /= n;
|
||
double xstd = 0, ystd = 0;
|
||
for (int i = 0; i < n; i++)
|
||
{
|
||
xstd += (xs[i] - mx) * (xs[i] - mx);
|
||
ystd += (ys[i] - my) * (ys[i] - my);
|
||
}
|
||
xstd = Math.Sqrt(xstd / n);
|
||
ystd = Math.Sqrt(ystd / n);
|
||
if (xstd < 1e-12) xstd = 1e-12;
|
||
if (ystd < 1e-12) ystd = 1e-12;
|
||
double w = 0, bias = 0;
|
||
double lr = 0.1;
|
||
for (int it = 0; it < iters; it++)
|
||
{
|
||
double gw = 0, gb = 0;
|
||
for (int i = 0; i < n; i++)
|
||
{
|
||
double xn = (xs[i] - mx) / xstd;
|
||
double yn = (ys[i] - my) / ystd;
|
||
double pred = w * xn + bias;
|
||
gw += (pred - yn) * xn;
|
||
gb += (pred - yn);
|
||
}
|
||
gw = 2.0 * gw / n;
|
||
gb = 2.0 * gb / n;
|
||
w -= lr * gw;
|
||
bias -= lr * gb;
|
||
}
|
||
for (int i = 0; i < n; i++)
|
||
{
|
||
double xn = (xs[i] - mx) / xstd;
|
||
outY[i] = (w * xn + bias) * ystd + my;
|
||
}
|
||
}
|
||
else if (calcName == "贝叶斯回归 (AI)")
|
||
{
|
||
seriesName = "bayes";
|
||
double alpha = Math.Max(1e-6, param);
|
||
double a00 = alpha + n, a01 = 0, a11 = alpha, b0 = 0, b1 = 0;
|
||
for (int i = 0; i < n; i++)
|
||
{
|
||
a01 += xs[i];
|
||
a11 += xs[i] * xs[i];
|
||
b0 += ys[i];
|
||
b1 += xs[i] * ys[i];
|
||
}
|
||
double det = a00 * a11 - a01 * a01;
|
||
double w0 = 0, w1 = 0;
|
||
if (Math.Abs(det) > 1e-15)
|
||
{
|
||
w0 = (b0 * a11 - a01 * b1) / det;
|
||
w1 = (a00 * b1 - a01 * b0) / det;
|
||
}
|
||
for (int i = 0; i < n; i++)
|
||
outY[i] = w0 + w1 * xs[i];
|
||
}
|
||
else if (calcName == "多项式拟合 (Polyfit) (AI)")
|
||
{
|
||
int degree = param;
|
||
if (degree < 1) degree = 1;
|
||
if (degree > 10) degree = 10;
|
||
seriesName = "poly" + degree;
|
||
double[] coeff = PolyFit(xs, ys, n, degree);
|
||
for (int i = 0; i < n; i++)
|
||
{
|
||
double v = 0;
|
||
for (int k = 0; k <= degree; k++)
|
||
v += coeff[k] * Math.Pow(xs[i], k);
|
||
outY[i] = v;
|
||
}
|
||
}
|
||
else if (calcName == "平滑曲线 (滑动平均)")
|
||
{
|
||
seriesName = "smooth";
|
||
for (int i = 0; i < n; i++)
|
||
{
|
||
int half = (param - 1) / 2;
|
||
int start = Math.Max(0, i - half);
|
||
int end = Math.Min(n - 1, i + half);
|
||
double sum = 0;
|
||
int cnt = 0;
|
||
for (int k = start; k <= end; k++)
|
||
{
|
||
if (!double.IsNaN(ys[k])) { sum += ys[k]; cnt++; }
|
||
}
|
||
if (cnt > 0) outY[i] = sum / cnt;
|
||
}
|
||
}
|
||
else if (calcName == "线性变换 (a*y+b) (AI)")
|
||
{
|
||
seriesName = "a*y+b";
|
||
for (int i = 0; i < n; i++)
|
||
if (!double.IsNaN(ys[i])) outY[i] = a * ys[i] + b;
|
||
}
|
||
else if (calcName == "二次变换 (a*y²+b) (AI)")
|
||
{
|
||
seriesName = "a*y²+b";
|
||
for (int i = 0; i < n; i++)
|
||
if (!double.IsNaN(ys[i])) outY[i] = a * ys[i] * ys[i] + b;
|
||
}
|
||
else
|
||
{
|
||
seriesName = "";
|
||
return null;
|
||
}
|
||
return outY;
|
||
}
|
||
|
||
double[] PolyFit(double[] xs, double[] ys, int n, int degree)
|
||
{
|
||
int m = degree + 1;
|
||
double[,] a = new double[m, m];
|
||
double[] bvec = new double[m];
|
||
for (int i = 0; i < n; i++)
|
||
{
|
||
double xp = 1;
|
||
for (int j = 0; j < m; j++)
|
||
{
|
||
for (int k = 0; k < m; k++)
|
||
a[j, k] += xp * Math.Pow(xs[i], k);
|
||
bvec[j] += xp * ys[i];
|
||
xp *= xs[i];
|
||
}
|
||
}
|
||
return GaussSolve(a, bvec, m);
|
||
}
|
||
|
||
double[] GaussSolve(double[,] a, double[] b, int m)
|
||
{
|
||
for (int col = 0; col < m; col++)
|
||
{
|
||
int pivot = col;
|
||
double maxv = Math.Abs(a[col, col]);
|
||
for (int r = col + 1; r < m; r++)
|
||
{
|
||
if (Math.Abs(a[r, col]) > maxv)
|
||
{
|
||
maxv = Math.Abs(a[r, col]);
|
||
pivot = r;
|
||
}
|
||
}
|
||
if (maxv < 1e-15)
|
||
{
|
||
double[] zero = new double[m];
|
||
return zero;
|
||
}
|
||
if (pivot != col)
|
||
{
|
||
for (int k = col; k < m; k++)
|
||
{
|
||
double t = a[col, k]; a[col, k] = a[pivot, k]; a[pivot, k] = t;
|
||
}
|
||
double tb = b[col]; b[col] = b[pivot]; b[pivot] = tb;
|
||
}
|
||
double diag = a[col, col];
|
||
for (int k = col; k < m; k++) a[col, k] /= diag;
|
||
b[col] /= diag;
|
||
for (int r = 0; r < m; r++)
|
||
{
|
||
if (r == col) continue;
|
||
double f = a[r, col];
|
||
if (Math.Abs(f) < 1e-15) continue;
|
||
for (int k = col; k < m; k++) a[r, k] -= f * a[col, k];
|
||
b[r] -= f * b[col];
|
||
}
|
||
}
|
||
return b;
|
||
}
|
||
|
||
void ClearCalcSeries()
|
||
{
|
||
foreach (string name in calcSeriesNames)
|
||
{
|
||
for (int i = chart.Series.Count - 1; i >= 0; i--)
|
||
{
|
||
if (chart.Series[i].Name == name)
|
||
{
|
||
chart.Series.RemoveAt(i);
|
||
break;
|
||
}
|
||
}
|
||
}
|
||
calcSeriesNames.Clear();
|
||
SetStatus("已清除运算曲线", false);
|
||
}
|
||
|
||
static readonly string[] TimeFormats = {
|
||
"yyyy-MM-dd HH:mm:ss.fff", "yyyy/MM/dd HH:mm:ss.fff",
|
||
"yyyy-MM-dd HH:mm:ss", "yyyy/MM/dd HH:mm:ss",
|
||
"yyyy-M-d H:m:s", "yyyy/M/d H:m:s",
|
||
"yyyy-MM-dd HH:mm", "yyyy/MM/dd HH:mm",
|
||
"yy-MM-dd HH:mm:ss", "yy/MM/dd HH:mm:ss",
|
||
"yy-M-d H:m:s", "yy/M/d H:m:s",
|
||
"yy-MM-dd HH:mm", "yy/MM/dd HH:mm",
|
||
"yyyy-MM-dd", "yyyy/MM/dd", "yy-MM-dd", "yy/MM/dd",
|
||
"yyyyMMddHHmmss", "yyMMddHHmmss", "yyyyMMddHHmm", "yyMMddHHmm",
|
||
"yyyyMMdd", "yyMMdd"
|
||
};
|
||
|
||
static bool TryParseTime(string s, out DateTime dt)
|
||
{
|
||
dt = DateTime.MinValue;
|
||
string t = s.Trim();
|
||
if (t.Length < 6) return false;
|
||
return DateTime.TryParseExact(t, TimeFormats,
|
||
System.Globalization.CultureInfo.InvariantCulture,
|
||
System.Globalization.DateTimeStyles.None, out dt);
|
||
}
|
||
|
||
static bool IsNumeric(object o)
|
||
{
|
||
double d;
|
||
return TryToDouble(o, out d);
|
||
}
|
||
|
||
static bool TryToDouble(object o, out double val)
|
||
{
|
||
val = 0;
|
||
if (o is double) { val = (double)o; return true; }
|
||
if (o is float) { val = (float)o; return true; }
|
||
if (o is int) { val = (int)o; return true; }
|
||
if (o is long) { val = (long)o; return true; }
|
||
if (o is decimal) { val = (double)(decimal)o; return true; }
|
||
if (o is sbyte) { val = (sbyte)o; return true; }
|
||
if (o is byte) { val = (byte)o; return true; }
|
||
if (o is short) { val = (short)o; return true; }
|
||
if (o is ushort) { val = (ushort)o; return true; }
|
||
if (o is uint) { val = (uint)o; return true; }
|
||
if (o is ulong) { val = (ulong)o; return true; }
|
||
if (o is DateTime) { val = ((DateTime)o).ToOADate(); return true; }
|
||
if (o is TimeSpan) { val = ((TimeSpan)o).TotalSeconds; return true; }
|
||
return double.TryParse(o.ToString(), System.Globalization.NumberStyles.Any,
|
||
System.Globalization.CultureInfo.InvariantCulture, out val);
|
||
}
|
||
|
||
void SaveImage()
|
||
{
|
||
if (chart.Series.Count == 0)
|
||
{
|
||
MessageBox.Show(this, "请先绘制曲线", "提示");
|
||
return;
|
||
}
|
||
SaveFileDialog dlg = new SaveFileDialog();
|
||
dlg.Filter = "PNG 图片|*.png|JPEG 图片|*.jpg|BMP 图片|*.bmp";
|
||
dlg.FileName = "chart.png";
|
||
if (dlg.ShowDialog(this) == DialogResult.OK)
|
||
{
|
||
try
|
||
{
|
||
chart.SaveImage(dlg.FileName, ChartImageFormat.Png);
|
||
MessageBox.Show(this, "图片已保存到:\n" + dlg.FileName, "完成");
|
||
}
|
||
catch (Exception ex)
|
||
{
|
||
MessageBox.Show(this, "保存失败: " + ex.Message, "错误",
|
||
MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
class ChartSettingsForm : Form
|
||
{
|
||
Chart chart;
|
||
Label lblTitleTarget;
|
||
MainForm owner;
|
||
|
||
TextBox txtTitle, txtXTitle, txtYTitle;
|
||
TextBox txtXMin, txtXMax, txtYMin, txtYMax;
|
||
TextBox txtXGrid, txtYGrid, txtMinorDiv;
|
||
CheckBox chkXLog, chkYLog, chkMinor, chkGridX, chkGridY;
|
||
DataGridView dgvSeries;
|
||
|
||
public ChartSettingsForm(Chart ch, Label lblTitle, MainForm ownerForm)
|
||
{
|
||
chart = ch;
|
||
lblTitleTarget = lblTitle;
|
||
owner = ownerForm;
|
||
Text = "图表设置";
|
||
FormBorderStyle = FormBorderStyle.FixedDialog;
|
||
MaximizeBox = false;
|
||
MinimizeBox = false;
|
||
StartPosition = FormStartPosition.CenterParent;
|
||
Font = new Font("Microsoft YaHei UI", 9F);
|
||
ClientSize = new Size(560, 480);
|
||
|
||
TabControl tabs = new TabControl();
|
||
tabs.Location = new Point(10, 10);
|
||
tabs.Size = new Size(540, 410);
|
||
Controls.Add(tabs);
|
||
|
||
TabPage pgGeneral = new TabPage("常规");
|
||
tabs.TabPages.Add(pgGeneral);
|
||
TabPage pgAxis = new TabPage("坐标轴");
|
||
tabs.TabPages.Add(pgAxis);
|
||
TabPage pgSeries = new TabPage("曲线样式");
|
||
tabs.TabPages.Add(pgSeries);
|
||
|
||
ChartArea area = chart.ChartAreas["main"];
|
||
|
||
AddRow(pgGeneral, "标题:", 16, lblTitle.Text, out txtTitle);
|
||
AddRow(pgGeneral, "横轴名称:", 52, area.AxisX.Title, out txtXTitle);
|
||
AddRow(pgGeneral, "纵轴名称:", 88, area.AxisY.Title, out txtYTitle);
|
||
|
||
AddLabelTo(pgGeneral, "图例位置:", 16, 128);
|
||
Label lLegendFixed = new Label();
|
||
lLegendFixed.Text = "固定于标题下方 (不可调)";
|
||
lLegendFixed.Location = new Point(110, 124);
|
||
lLegendFixed.AutoSize = true;
|
||
lLegendFixed.ForeColor = Color.FromArgb(140, 150, 160);
|
||
pgGeneral.Controls.Add(lLegendFixed);
|
||
|
||
AddLabelTo(pgGeneral, "横轴网格:", 16, 164);
|
||
chkGridX = new CheckBox();
|
||
chkGridX.Text = "显示";
|
||
chkGridX.Location = new Point(110, 160);
|
||
chkGridX.Checked = area.AxisX.MajorGrid.Enabled;
|
||
pgGeneral.Controls.Add(chkGridX);
|
||
|
||
AddLabelTo(pgGeneral, "纵轴网格:", 16, 196);
|
||
chkGridY = new CheckBox();
|
||
chkGridY.Text = "显示";
|
||
chkGridY.Location = new Point(110, 192);
|
||
chkGridY.Checked = area.AxisY.MajorGrid.Enabled;
|
||
pgGeneral.Controls.Add(chkGridY);
|
||
|
||
AddLabelTo(pgGeneral, "横轴网格间距:", 16, 232);
|
||
txtXGrid = AddSmallText(pgGeneral, 110, 228, 220);
|
||
txtXGrid.Text = area.AxisX.MajorGrid.Interval == 0 ? "" : area.AxisX.MajorGrid.Interval.ToString();
|
||
|
||
AddLabelTo(pgGeneral, "纵轴网格间距:", 16, 268);
|
||
txtYGrid = AddSmallText(pgGeneral, 110, 264, 220);
|
||
txtYGrid.Text = area.AxisY.MajorGrid.Interval == 0 ? "" : area.AxisY.MajorGrid.Interval.ToString();
|
||
|
||
AddLabelTo(pgGeneral, "次网格细分数:", 16, 304);
|
||
txtMinorDiv = AddSmallText(pgGeneral, 110, 300, 220);
|
||
double minorDiv = 4;
|
||
if (area.AxisX.MinorGrid.Enabled && area.AxisX.MajorGrid.Interval > 0)
|
||
minorDiv = area.AxisX.MajorGrid.Interval / area.AxisX.MinorGrid.Interval;
|
||
txtMinorDiv.Text = minorDiv.ToString("0.#");
|
||
|
||
chkMinor = new CheckBox();
|
||
chkMinor.Text = "加密网格线 (启用次网格线)";
|
||
chkMinor.Location = new Point(16, 334);
|
||
chkMinor.AutoSize = true;
|
||
chkMinor.Checked = area.AxisX.MinorGrid.Enabled;
|
||
pgGeneral.Controls.Add(chkMinor);
|
||
|
||
AddLabelTo(pgAxis, "横轴最小值 (留空=自动):", 16, 24);
|
||
txtXMin = AddSmallText(pgAxis, 190, 20, 150);
|
||
if (!double.IsNaN(area.AxisX.Minimum) && area.AxisX.Minimum != double.NegativeInfinity)
|
||
txtXMin.Text = area.AxisX.Minimum.ToString();
|
||
|
||
AddLabelTo(pgAxis, "横轴最大值 (留空=自动):", 16, 60);
|
||
txtXMax = AddSmallText(pgAxis, 190, 56, 150);
|
||
if (!double.IsNaN(area.AxisX.Maximum) && area.AxisX.Maximum != double.PositiveInfinity)
|
||
txtXMax.Text = area.AxisX.Maximum.ToString();
|
||
|
||
AddLabelTo(pgAxis, "纵轴最小值 (留空=自动):", 16, 96);
|
||
txtYMin = AddSmallText(pgAxis, 190, 92, 150);
|
||
if (!double.IsNaN(area.AxisY.Minimum) && area.AxisY.Minimum != double.NegativeInfinity)
|
||
txtYMin.Text = area.AxisY.Minimum.ToString();
|
||
|
||
AddLabelTo(pgAxis, "纵轴最大值 (留空=自动):", 16, 132);
|
||
txtYMax = AddSmallText(pgAxis, 190, 128, 150);
|
||
if (!double.IsNaN(area.AxisY.Maximum) && area.AxisY.Maximum != double.PositiveInfinity)
|
||
txtYMax.Text = area.AxisY.Maximum.ToString();
|
||
|
||
chkXLog = new CheckBox();
|
||
chkXLog.Text = "横轴使用对数刻度 (Log)";
|
||
chkXLog.Location = new Point(16, 176);
|
||
chkXLog.AutoSize = true;
|
||
chkXLog.Checked = area.AxisX.IsLogarithmic;
|
||
pgAxis.Controls.Add(chkXLog);
|
||
|
||
chkYLog = new CheckBox();
|
||
chkYLog.Text = "纵轴使用对数刻度 (Log)";
|
||
chkYLog.Location = new Point(16, 208);
|
||
chkYLog.AutoSize = true;
|
||
chkYLog.Checked = area.AxisY.IsLogarithmic;
|
||
pgAxis.Controls.Add(chkYLog);
|
||
|
||
Label lTip = new Label();
|
||
lTip.Text = "提示: 对数刻度要求数据均为正值";
|
||
lTip.Font = new Font("Microsoft YaHei UI", 8.5F);
|
||
lTip.ForeColor = Color.FromArgb(140, 150, 160);
|
||
lTip.Location = new Point(16, 240);
|
||
lTip.AutoSize = true;
|
||
pgAxis.Controls.Add(lTip);
|
||
|
||
dgvSeries = new DataGridView();
|
||
dgvSeries.Dock = DockStyle.Fill;
|
||
dgvSeries.Padding = new Padding(6);
|
||
dgvSeries.AllowUserToAddRows = false;
|
||
dgvSeries.AllowUserToDeleteRows = false;
|
||
dgvSeries.RowHeadersVisible = false;
|
||
dgvSeries.BackgroundColor = Color.White;
|
||
dgvSeries.BorderStyle = BorderStyle.FixedSingle;
|
||
dgvSeries.EnableHeadersVisualStyles = false;
|
||
dgvSeries.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(52, 73, 94);
|
||
dgvSeries.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
|
||
dgvSeries.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
|
||
dgvSeries.ColumnHeadersHeight = 26;
|
||
dgvSeries.DefaultCellStyle.Font = new Font("Microsoft YaHei UI", 8.5F);
|
||
dgvSeries.GridColor = Color.FromArgb(221, 228, 236);
|
||
dgvSeries.RowTemplate.Height = 26;
|
||
pgSeries.Controls.Add(dgvSeries);
|
||
|
||
DataGridViewTextBoxColumn cName = new DataGridViewTextBoxColumn();
|
||
cName.HeaderText = "曲线名称";
|
||
cName.Width = 130;
|
||
cName.ReadOnly = true;
|
||
dgvSeries.Columns.Add(cName);
|
||
|
||
DataGridViewComboBoxColumn cColor = new DataGridViewComboBoxColumn();
|
||
cColor.HeaderText = "颜色";
|
||
cColor.Width = 90;
|
||
cColor.FlatStyle = FlatStyle.Flat;
|
||
foreach (KnownColor kc in Enum.GetValues(typeof(KnownColor)))
|
||
{
|
||
Color cc = Color.FromKnownColor(kc);
|
||
if (cc.IsSystemColor || cc.A != 255) continue;
|
||
cColor.Items.Add(kc.ToString());
|
||
}
|
||
dgvSeries.Columns.Add(cColor);
|
||
|
||
DataGridViewComboBoxColumn cWidth = new DataGridViewComboBoxColumn();
|
||
cWidth.HeaderText = "线宽";
|
||
cWidth.Width = 60;
|
||
cWidth.FlatStyle = FlatStyle.Flat;
|
||
for (int i = 1; i <= 8; i++) cWidth.Items.Add(i.ToString());
|
||
dgvSeries.Columns.Add(cWidth);
|
||
|
||
DataGridViewComboBoxColumn cStyle = new DataGridViewComboBoxColumn();
|
||
cStyle.HeaderText = "线型";
|
||
cStyle.Width = 80;
|
||
cStyle.FlatStyle = FlatStyle.Flat;
|
||
cStyle.Items.Add("实线");
|
||
cStyle.Items.Add("虚线");
|
||
cStyle.Items.Add("点线");
|
||
cStyle.Items.Add("点划线");
|
||
dgvSeries.Columns.Add(cStyle);
|
||
|
||
DataGridViewComboBoxColumn cMarker = new DataGridViewComboBoxColumn();
|
||
cMarker.HeaderText = "标记";
|
||
cMarker.Width = 80;
|
||
cMarker.FlatStyle = FlatStyle.Flat;
|
||
cMarker.Items.Add("无");
|
||
cMarker.Items.Add("圆点");
|
||
cMarker.Items.Add("方块");
|
||
cMarker.Items.Add("三角");
|
||
cMarker.Items.Add("菱形");
|
||
dgvSeries.Columns.Add(cMarker);
|
||
|
||
RefreshSeriesGrid();
|
||
|
||
Button ok = new Button();
|
||
ok.Text = "应用";
|
||
ok.Location = new Point(250, 432);
|
||
ok.Size = new Size(120, 34);
|
||
ok.FlatStyle = FlatStyle.Flat;
|
||
ok.FlatAppearance.BorderSize = 0;
|
||
ok.BackColor = Color.FromArgb(41, 101, 173);
|
||
ok.ForeColor = Color.White;
|
||
ok.Font = new Font("Microsoft YaHei UI", 10F, FontStyle.Bold);
|
||
ok.Click += delegate { ApplyAndClose(); };
|
||
Controls.Add(ok);
|
||
|
||
Button cancel = new Button();
|
||
cancel.Text = "取消";
|
||
cancel.Location = new Point(385, 432);
|
||
cancel.Size = new Size(120, 34);
|
||
cancel.DialogResult = DialogResult.Cancel;
|
||
Controls.Add(cancel);
|
||
AcceptButton = ok;
|
||
CancelButton = cancel;
|
||
}
|
||
|
||
void RefreshSeriesGrid()
|
||
{
|
||
dgvSeries.Rows.Clear();
|
||
foreach (Series s in chart.Series)
|
||
{
|
||
int idx = dgvSeries.Rows.Add();
|
||
dgvSeries.Rows[idx].Cells[0].Value = s.Name;
|
||
dgvSeries.Rows[idx].Cells[1].Value = s.Color.Name;
|
||
dgvSeries.Rows[idx].Cells[2].Value = s.BorderWidth.ToString();
|
||
dgvSeries.Rows[idx].Cells[3].Value = StyleToCn(s.BorderDashStyle);
|
||
dgvSeries.Rows[idx].Cells[4].Value = MarkerToCn(s.MarkerStyle);
|
||
}
|
||
}
|
||
|
||
static string StyleToCn(ChartDashStyle st)
|
||
{
|
||
switch (st)
|
||
{
|
||
case ChartDashStyle.Dash: return "虚线";
|
||
case ChartDashStyle.Dot: return "点线";
|
||
case ChartDashStyle.DashDot: return "点划线";
|
||
default: return "实线";
|
||
}
|
||
}
|
||
|
||
static string MarkerToCn(MarkerStyle m)
|
||
{
|
||
switch (m)
|
||
{
|
||
case MarkerStyle.Circle: return "圆点";
|
||
case MarkerStyle.Square: return "方块";
|
||
case MarkerStyle.Triangle: return "三角";
|
||
case MarkerStyle.Diamond: return "菱形";
|
||
default: return "无";
|
||
}
|
||
}
|
||
|
||
static ChartDashStyle CnToStyle(string s)
|
||
{
|
||
if (s == "虚线") return ChartDashStyle.Dash;
|
||
if (s == "点线") return ChartDashStyle.Dot;
|
||
if (s == "点划线") return ChartDashStyle.DashDot;
|
||
return ChartDashStyle.Solid;
|
||
}
|
||
|
||
static MarkerStyle CnToMarker(string s)
|
||
{
|
||
if (s == "圆点") return MarkerStyle.Circle;
|
||
if (s == "方块") return MarkerStyle.Square;
|
||
if (s == "三角") return MarkerStyle.Triangle;
|
||
if (s == "菱形") return MarkerStyle.Diamond;
|
||
return MarkerStyle.None;
|
||
}
|
||
|
||
void AddLabelTo(Control parent, string text, int x, int y)
|
||
{
|
||
Label l = new Label();
|
||
l.Text = text;
|
||
l.Location = new Point(x, y + 4);
|
||
l.AutoSize = true;
|
||
l.ForeColor = Color.FromArgb(60, 70, 80);
|
||
parent.Controls.Add(l);
|
||
}
|
||
|
||
void AddRow(Control parent, string label, int y, string value, out TextBox box)
|
||
{
|
||
AddLabelTo(parent, label, 16, y);
|
||
box = new TextBox();
|
||
box.Location = new Point(110, y);
|
||
box.Width = 220;
|
||
box.BorderStyle = BorderStyle.FixedSingle;
|
||
box.Text = value;
|
||
parent.Controls.Add(box);
|
||
}
|
||
|
||
TextBox AddSmallText(Control parent, int x, int y, int width)
|
||
{
|
||
TextBox t = new TextBox();
|
||
t.Location = new Point(x, y);
|
||
t.Width = width;
|
||
t.BorderStyle = BorderStyle.FixedSingle;
|
||
parent.Controls.Add(t);
|
||
return t;
|
||
}
|
||
|
||
void ApplyAndClose()
|
||
{
|
||
ChartArea area = chart.ChartAreas["main"];
|
||
lblTitleTarget.Text = txtTitle.Text.Trim();
|
||
area.AxisX.Title = txtXTitle.Text.Trim();
|
||
area.AxisY.Title = txtYTitle.Text.Trim();
|
||
|
||
double xGrid = 0, yGrid = 0;
|
||
if (double.TryParse(txtXGrid.Text.Trim(), out xGrid) && xGrid > 0)
|
||
area.AxisX.MajorGrid.Interval = xGrid;
|
||
else
|
||
area.AxisX.MajorGrid.Interval = 0;
|
||
if (double.TryParse(txtYGrid.Text.Trim(), out yGrid) && yGrid > 0)
|
||
area.AxisY.MajorGrid.Interval = yGrid;
|
||
else
|
||
area.AxisY.MajorGrid.Interval = 0;
|
||
|
||
area.AxisX.MajorGrid.Enabled = chkGridX.Checked;
|
||
area.AxisY.MajorGrid.Enabled = chkGridY.Checked;
|
||
|
||
double xMin, xMax, yMin, yMax;
|
||
if (double.TryParse(txtXMin.Text.Trim(), out xMin))
|
||
area.AxisX.Minimum = xMin;
|
||
else
|
||
area.AxisX.Minimum = double.NaN;
|
||
if (double.TryParse(txtXMax.Text.Trim(), out xMax))
|
||
area.AxisX.Maximum = xMax;
|
||
else
|
||
area.AxisX.Maximum = double.NaN;
|
||
if (double.TryParse(txtYMin.Text.Trim(), out yMin))
|
||
area.AxisY.Minimum = yMin;
|
||
else
|
||
area.AxisY.Minimum = double.NaN;
|
||
if (double.TryParse(txtYMax.Text.Trim(), out yMax))
|
||
area.AxisY.Maximum = yMax;
|
||
else
|
||
area.AxisY.Maximum = double.NaN;
|
||
|
||
area.AxisX.IsLogarithmic = chkXLog.Checked;
|
||
area.AxisY.IsLogarithmic = chkYLog.Checked;
|
||
|
||
bool minor = chkMinor.Checked;
|
||
double div = 4;
|
||
double.TryParse(txtMinorDiv.Text.Trim(), out div);
|
||
if (div < 2) div = 2;
|
||
area.AxisX.MinorGrid.Enabled = minor;
|
||
area.AxisY.MinorGrid.Enabled = minor;
|
||
if (minor)
|
||
{
|
||
Color minorColor = Color.FromArgb(215, 220, 228);
|
||
if (xGrid > 0)
|
||
area.AxisX.MinorGrid.Interval = xGrid / div;
|
||
else
|
||
area.AxisX.MinorGrid.Interval = 0;
|
||
if (yGrid > 0)
|
||
area.AxisY.MinorGrid.Interval = yGrid / div;
|
||
else
|
||
area.AxisY.MinorGrid.Interval = 0;
|
||
area.AxisX.MinorGrid.LineColor = minorColor;
|
||
area.AxisY.MinorGrid.LineColor = minorColor;
|
||
area.AxisX.MinorGrid.LineDashStyle = ChartDashStyle.Dash;
|
||
area.AxisY.MinorGrid.LineDashStyle = ChartDashStyle.Dash;
|
||
}
|
||
|
||
foreach (DataGridViewRow row in dgvSeries.Rows)
|
||
{
|
||
if (row.IsNewRow) continue;
|
||
string sname = row.Cells[0].Value == null ? "" : row.Cells[0].Value.ToString();
|
||
if (chart.Series.IndexOf(sname) < 0) continue;
|
||
Series s = chart.Series[sname];
|
||
string colorName = row.Cells[1].Value == null ? "" : row.Cells[1].Value.ToString();
|
||
if (colorName.Length > 0)
|
||
{
|
||
try { s.Color = Color.FromName(colorName); }
|
||
catch { }
|
||
}
|
||
int bw = 2;
|
||
int.TryParse(row.Cells[2].Value == null ? "2" : row.Cells[2].Value.ToString(), out bw);
|
||
s.BorderWidth = bw;
|
||
string style = row.Cells[3].Value == null ? "" : row.Cells[3].Value.ToString();
|
||
if (style.Length > 0) s.BorderDashStyle = CnToStyle(style);
|
||
string marker = row.Cells[4].Value == null ? "" : row.Cells[4].Value.ToString();
|
||
if (marker.Length > 0)
|
||
{
|
||
s.MarkerStyle = CnToMarker(marker);
|
||
s.MarkerSize = 6;
|
||
s.MarkerColor = s.Color;
|
||
}
|
||
}
|
||
chart.Invalidate();
|
||
DialogResult = DialogResult.OK;
|
||
Close();
|
||
}
|
||
}
|
||
}
|