From 70332ced875cd4afaad7c31dc83f863eb1bd1a9f Mon Sep 17 00:00:00 2001
From: lu <123456>
Date: 星期三, 22 十月 2025 09:58:49 +0800
Subject: [PATCH] 排产工单搜索
---
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