From 51cdb1b659a6648bb410bad30f5027d93fc8658c Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期二, 25 十一月 2025 17:21:09 +0800
Subject: [PATCH] 增加桌面端 多行生产订单批量下推 增加工序流转卡查询 打印小标签 修复一些基础资料导入报错
---
WebAPI/Controllers/SCGL/日计划管理/JIT_DayPlanPlatFormImportController.cs | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diff --git "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormImportController.cs" "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormImportController.cs"
index 008b8fc..bc8613a 100644
--- "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormImportController.cs"
+++ "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormImportController.cs"
@@ -1826,6 +1826,7 @@
var HProdORGID = list[i]["HProdORGID"].ToString();
var HWorkShopID = list[i]["HWorkShopID"].ToString();
var HSourceID = "0";
+ var HSourceName = list[i]["鐢熶骇璧勬簮"].ToString();
var HWorkQty = DBUtility.ClsPub.isDoule(list[i]["浜ц兘"]);
var HYX = list[i]["浼樺厛绾�"].ToString();
var HEmpID = list[i]["HEmpID"].ToString();
@@ -1844,6 +1845,10 @@
var HSeOrderBillNo = list[i]["HSeOrderBillNo"].ToString();
var HVersion_Import = list[i]["HVersion_Import"].ToString();
+
+ var ds = oCN.RunProcReturn($@"select * from Gy_Source where HName= '{HSourceName}'", "Gy_Source");
+ HSourceID = ds.Tables[0].Rows[0]["HItemID"].ToString();
+
string sql = $"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" +
$" and HMainSourceEntryID={HMainSourceEntryID} and HICMOBillNo='{HICMOBillNo}' and HICMOEntrySEQ={HICMOEntrySEQ} and HSourceID={HSourceID} and ISNULL(HDeleteMan,'') = ''";
LogService.Write("sql:" + sql);
--
Gitblit v1.9.1