From a5ac8b421e08d776e9460e2af0541fa385c41dfc Mon Sep 17 00:00:00 2001
From: cdk <2441919651@qq.com>
Date: 星期五, 21 十一月 2025 13:47:31 +0800
Subject: [PATCH] 导出参数调整
---
DevApp/Gs.DevApp/XtraForm1.cs | 134 +++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 131 insertions(+), 3 deletions(-)
diff --git a/DevApp/Gs.DevApp/XtraForm1.cs b/DevApp/Gs.DevApp/XtraForm1.cs
index 7e9f177..0299600 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;
@@ -171,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("璇ユ按妫�绔欎綅鐮佷笉瀛樺湪锛岃纭锛�");
@@ -182,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("姘存鍦板潃涓嶅瓨鍦紝璇风‘璁わ紒");
@@ -250,10 +256,132 @@
{
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();
+ }
+
+ private void simpleButton3_Click(object sender, EventArgs e)
+ {
+ string ddd = "1";
+ try
+ {
+ if (IsValidDate(ddd, "鏃ユ湡"))
+ MessageBox.Show("姝ｅ父");
+ }
+ catch (Exception ex)
+ {
+ MessageBox.Show(ex.Message);
+ }
+
+ }
+
+ /// <summary>
+ /// 鍒ゆ柇鏄惁涓烘棩鏈�
+ /// </summary>
+ /// <param name="dateString"></param>
+ /// <returns></returns>
+ public bool IsValidDate(string dateString, string ziDuan = "")
+ {
+ bool bl = DateTime.TryParse(dateString, out _);
+ if (bl == true)
+ return bl;
+ if (string.IsNullOrEmpty(ziDuan))
+ return bl;
+ throw new Exception(ziDuan + "涓嶆槸鍚堟硶鐨勬棩鏈熺被鍨嬶紒");
+ }
+
+ private void simpleButton4_Click(object sender, EventArgs e)
+ {
+
+ Toast vm = new Toast(0, simpleButton4.Text);
+ vm.Show();
+ return;
+ }
+
+ private void simpleButton5_Click(object sender, EventArgs e)
+ {
+ Toast vm = new Toast(0, simpleButton5.Text);
+ vm.Show();
+ return;
+ }
+
+ private void simpleButton6_Click(object sender, EventArgs e)
+ {
+ Toast vm = new Toast(0, simpleButton6.Text);
+ vm.Show();
+ return;
+ }
+
+ private void simpleButton7_Click(object sender, EventArgs e)
+ {
+ Toast vm = new Toast(0, simpleButton7.Text);
+ vm.Show();
+ return;
+ }
}
}
\ No newline at end of file
--
Gitblit v1.9.3