From 2e44301eda2efb4b61e6dc53d4fff668229f7321 Mon Sep 17 00:00:00 2001 From: lu <123456> Date: 星期三, 17 九月 2025 22:05:27 +0800 Subject: [PATCH] bug --- DevApp/Gs.DevApp/XtraForm1.cs | 76 ++++++++++++++++++++++++++++++++++++-- 1 files changed, 72 insertions(+), 4 deletions(-) diff --git a/DevApp/Gs.DevApp/XtraForm1.cs b/DevApp/Gs.DevApp/XtraForm1.cs index b7fc7a0..7ecc96b 100644 --- a/DevApp/Gs.DevApp/XtraForm1.cs +++ b/DevApp/Gs.DevApp/XtraForm1.cs @@ -1,7 +1,9 @@ 锘縰sing DevExpress.XtraEditors; +using Newtonsoft.Json; using Newtonsoft.Json.Linq; using NModbus; using System; +using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; @@ -23,7 +25,6 @@ public XtraForm1() { InitializeComponent(); - } private void simpleButton2_Click(object sender, EventArgs e) @@ -172,7 +173,9 @@ private void simpleButton1_Click(object sender, EventArgs e) { - DataTable dataTable1 = this.GetDataTable($"select MIG004,MIG005 from BASMIG(nolock) where MIG001='ShuiJianZhanWei01' and MIG003='{((BaseEdit)this.txtGWM).EditValue.ToString()}'", "tmpBASMIG2"); + System.Text.StringBuilder sbSql1 = new StringBuilder(); + sbSql1.Append($"select MIG004,MIG005 from BASMIG(nolock) where MIG001='ShuiJianZhanWei01' and MIG003='{((BaseEdit)this.txtGWM).EditValue.ToString()}'"); + DataTable dataTable1 = this.GetDataTable(sbSql1.ToString(), "tmpBASMIG2"); if (dataTable1 == null || dataTable1.Rows.Count <= 0) { MessageBox.Show("璇ユ按妫�绔欎綅鐮佷笉瀛樺湪锛岃纭锛�"); @@ -183,7 +186,9 @@ ModbusFactory modbusFactory = new ModbusFactory(); byte num1 = byte.Parse("1"); ushort num2 = ushort.Parse("1"); - DataTable dataTable2 = GetDataTable(string.Format($"select case when MIG006='D' then MIG003+{dataTable1.Rows[0][0]} else MIG003+{dataTable1.Rows[0][1]} end MIG003,MIG004 from BASMIG(nolock) where MIG001 = 'ShuiJianAddress01' order by MIG005"), "tmpBASMIG3"); + System.Text.StringBuilder sbSql2 = new StringBuilder(); + sbSql2.Append(string.Format($"select case when MIG006='D' then MIG003+{dataTable1.Rows[0][0]} else MIG003+{dataTable1.Rows[0][1]} end MIG003,MIG004 from BASMIG(nolock) where MIG001 = 'ShuiJianAddress01' order by MIG005")); + DataTable dataTable2 = GetDataTable(sbSql2.ToString(), "tmpBASMIG3"); if (dataTable2 == null || dataTable2.Rows.Count <= 0) { MessageBox.Show("姘存鍦板潃涓嶅瓨鍦紝璇风‘璁わ紒"); @@ -251,10 +256,73 @@ { throw new Exception(ex.Message); } - return ds.Tables[0]; } } + private void btnEdit_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) + { + MessageBox.Show("d"); + } + + private void button1_Click(object sender, EventArgs e) + { + string json = @"{ + ""100鈩�"": { + ""temp"": ""94"", + ""150ml"": ""143"", + ""250ml"": ""241"", + ""500ml"": ""482"", + ""750ml"": ""732"" + }, + ""85鈩�"": { + ""temp"": ""86"", + ""150ml"": ""146"", + ""250ml"": ""238"", + ""500ml"": ""495"", + ""750ml"": ""739"" + }, + ""60鈩�"": { + ""temp"": ""62"", + ""150ml"": ""152"", + ""250ml"": ""244"", + ""500ml"": ""499"", + ""750ml"": ""745"" + }, + ""45鈩�"": { + ""temp"": ""48"", + ""150ml"": ""158"", + ""250ml"": ""246"", + ""500ml"": ""506"", + ""750ml"": ""778"" + }, + ""甯告俯姘�"": { + ""temp"": ""29"", + ""150ml"": ""161"", + ""250ml"": ""249"", + ""500ml"": ""504"", + ""750ml"": ""781"" + } + }"; + System.Text.StringBuilder sbLine = new StringBuilder(); + var data = JsonConvert.DeserializeObject<Dictionary<string, Dictionary<string, string>>>(json); + List<string> resultLines = new List<string>(); + foreach (var entry in data) + { + string key = entry.Key; + var values = entry.Value; + string temp = values["temp"]; + sbLine.Append(key + "/" + temp + "锛�"); + System.Text.StringBuilder dbdb = new StringBuilder(); + foreach (var dddddd in values) + { + if (dddddd.Key == "temp") + continue; + dbdb.Append(dddddd.Key+"-"+ dddddd.Value + "銆�"); + } + sbLine.Append(dbdb.ToString()+"\n"); + } + richTextBox1.Text = sbLine.ToString(); + } } } \ No newline at end of file -- Gitblit v1.9.3