C#根据数据量自动排版标签的样例

这是一个C#根据数据量自动排版标签的样例

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Windows.Forms;
using HslCommunication.Profinet;namespace WindowsFormsApp1
{public partial class Form1 : Form{private CancellationTokenSource _cancellationTokenSource;private Dictionary<string, string> fieldMappings;public Form1(){InitializeComponent();InitializeFieldMappings();}private void Form1_Load(object sender, EventArgs e){}private void InitializeFieldMappings(){fieldMappings = new Dictionary<string, string>{{ "pltid", "平台ID" },{ "basketcode", "篮子编码" },{ "code", "编码" },{ "productCode", "产品编码" },{ "productName", "产品名称" },{ "customerCode", "客户编码" },{ "customerName", "客户名称" },{ "workordernumber", "工单编号" },{ "way", "方式" },{ "matnr", "物料编码" },{ "specs", "规格" },{ "dimension", "尺寸" },{ "equipmentnum", "设备编号" },{ "djBusCode", "业务代码" },{ "degEmCode", "异常代码" },{ "fqty", "数量" },{ "dinsert", "插入时间" },{ "lkstatus", "锁定状态" },{ "viewstatus", "查看状态" },{ "mst", "主状态" },{ "change_time", "变更时间" },{ "lgid", "lg的编号" },{ "lgmsg", "lg的信息" },{ "lgtime", "lg的时间" }};}private async void button1_Click(object sender, EventArgs e){_cancellationTokenSource = new CancellationTokenSource();string connectionString = "Server=ip;Database=root;User Id=1;Password=1;";string query = "SELECT * FROM [1].[1] where viewstatus=1";bool isConnected = await Task.Run(() => TestDatabaseConnection(connectionString));if (isConnected){textBox2.BackColor = Color.Green;label1.Text = "已连接";await Task.Run(() => MonitorDatabase(connectionString, query, _cancellationTokenSource.Token));}else{textBox2.BackColor = Color.Red;label1.Text = "连接失败";}}private bool TestDatabaseConnection(string connectionString){try{using (SqlConnection connection = new SqlConnection(connectionString)){connection.Open();return true;}}catch{return false;}}private void MonitorDatabase(string connectionString, string query, CancellationToken token){DateTime lastCheck = DateTime.Now;while (!token.IsCancellationRequested){using (SqlConnection connection = new SqlConnection(connectionString)){SqlCommand command = new SqlCommand(query, connection);command.Parameters.AddWithValue("@lastCheck", lastCheck);try{connection.Open();SqlDataReader reader = command.ExecuteReader();if (reader.HasRows){while (reader.Read()){StringBuilder result = new StringBuilder();for (int i = 0; i < reader.FieldCount; i++){string fieldName = reader.GetName(i);string fieldValue = reader[i].ToString();if (fieldMappings.ContainsKey(fieldName)){result.AppendLine($"{fieldMappings[fieldName]}: {fieldValue}");}else{result.AppendLine($"{fieldName}: {fieldValue}");}}UpdateUIWithResult(result.ToString(), reader);}lastCheck = DateTime.Now;}reader.Close();}catch (Exception ex){UpdateUIWithResult("Error: " + ex.Message, null);}}Thread.Sleep(1000); // 1 second interval}}private void UpdateUIWithResult(string text, SqlDataReader reader){if (InvokeRequired){Invoke(new Action(() => CreateLabelsForData(reader)));}else{CreateLabelsForData(reader);}}private void CreateLabelsForData(SqlDataReader reader){flowLayoutPanel1.Controls.Clear(); // 清空之前的控件int yOffset = 0; // 纵向偏移量for (int i = 0; i < reader.FieldCount; i++){string fieldName = reader.GetName(i);string fieldValue = reader[i].ToString();// 创建标题标签Label titleLabel = new Label{AutoSize = false,Width = 200,Height = 40,Location = new Point(0, yOffset),ForeColor = Color.Red,BackColor = Color.Black,Padding = new Padding(5),Font = new Font("Arial", 18, FontStyle.Bold),Text = fieldMappings.ContainsKey(fieldName) ? fieldMappings[fieldName] : fieldName};// 创建内容标签Label valueLabel = new Label{AutoSize = false,Width = 200,Height = 40,Location = new Point(210, yOffset),ForeColor = Color.Green,BackColor = Color.Black,Padding = new Padding(5),Font = new Font("Arial", 18, FontStyle.Regular),Text = fieldValue};// 将标题和内容标签添加到PanelflowLayoutPanel1.Controls.Add(titleLabel);flowLayoutPanel1.Controls.Add(valueLabel);yOffset += 50; // 更新纵向偏移量}}private void Form1_FormClosing(object sender, FormClosingEventArgs e){_cancellationTokenSource?.Cancel();}private void label1_Click(object sender, EventArgs e){}private void label2_Click(object sender, EventArgs e){}private void button5_Click(object sender, EventArgs e){_cancellationTokenSource?.Cancel();textBox2.BackColor = Color.WhiteSmoke; // 或者其他颜色表示断开连接label1.Text = "未连接";}private void flowLayoutPanel1_Paint(object sender, PaintEventArgs e){}}
}