From 9dc7eda7f6fadd2a4377f0c4b2f908206d9d1e62 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期五, 14 十一月 2025 20:25:38 +0800
Subject: [PATCH] 代码提交
---
StandardPda/MES.Service/service/Warehouse/WomdaaManager.cs | 11 ++++-------
1 files changed, 4 insertions(+), 7 deletions(-)
diff --git a/StandardPda/MES.Service/service/Warehouse/WomdaaManager.cs b/StandardPda/MES.Service/service/Warehouse/WomdaaManager.cs
index 4abff66..0e4d2c6 100644
--- a/StandardPda/MES.Service/service/Warehouse/WomdaaManager.cs
+++ b/StandardPda/MES.Service/service/Warehouse/WomdaaManager.cs
@@ -235,19 +235,16 @@
// 1. 涓昏〃鎻掑叆
var sql1 = @"
- INSERT INTO MES_SN_STATUS_DETAILS
- (ID, TICKET_NO, SN_NO, WORKSTATION_NO, SN_STATE, LOGIN_ID, TURNOVER_CODE, LINE_NO)
- SELECT SEQ_MES_SN_STATUS_DETAILS_ID.NEXTVAL,
+ INSERT INTO MES_SN_STATUS_DETAILS
+ (ID, TICKET_NO, SN_NO, WORKSTATION_NO, SN_STATE, LOGIN_ID, TURNOVER_CODE, LINE_NO) values (
+ SEQ_MES_SN_STATUS_DETAILS_ID.NEXTVAL,
:ticketNo,
:snNo,
:workstationNo,
:snState,
:loginId,
:turnoverCode,
- :LINE_NO
- FROM WOMDAA
- WHERE DAA001 = :ticketNo
- AND ROWNUM = 1";
+ :LINE_NO)";
var parameters1 = new[]
{
new OracleParameter("ticketNo", asnInfo.tickeNo ?? (object)DBNull.Value),
--
Gitblit v1.9.3