From 2ffab6b086c6c1343b4703854d16b1650c74bc8d Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期四, 16 四月 2026 14:18:13 +0800
Subject: [PATCH] 增加设备驾驶舱页面查询方法
---
WebAPI/Controllers/SCGL/日计划管理/JIT_DayPlanPlatFormImportController.cs | 8 +++++++-
1 files changed, 7 insertions(+), 1 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 1fe531a..6930aaf 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"
@@ -2110,6 +2110,12 @@
return objJsonResult;
}
+ //瀵煎嚭excel琛ㄦ牸鏃讹紝鍓嶉潰鐨�0娌℃帀浜嗭紝杩欒竟鍋氳ˉ0鐨勫姩浣滐紱
+ if (tb2.Rows[i]["鐢熶骇杞﹂棿缂栫爜"].ToString().Length == 4)
+ {
+ tb2.Rows[i]["鐢熶骇杞﹂棿缂栫爜"] = "0" + tb2.Rows[i]["鐢熶骇杞﹂棿缂栫爜"].ToString();
+ }
+
string sql1 = string.Format("select * from h_v_JIT_ICMOBillList_DR where 鍗曟嵁鍙�='{0}' and 鐢熶骇杞﹂棿浠ｇ爜='{1}' and 浜у搧浠ｇ爜='{2}' " +
"and 鏄庣粏琛屽彿={3} ",tb2.Rows[i]["鐢熶骇璁㈠崟鍙�"].ToString(), tb2.Rows[i]["鐢熶骇杞﹂棿缂栫爜"].ToString(), tb2.Rows[i]["鐗╂枡缂栫爜"].ToString(),
tb2.Rows[i]["鐢熶骇璁㈠崟鏄庣粏琛屽彿"].ToString());
@@ -2331,7 +2337,7 @@
var HProdORGID = list[i]["HProdORGID"].ToString();
var HWorkShopID = list[i]["HWorkShopID"].ToString();
var HSourceID = list[i]["HSourceID"].ToString();
- var HWorkQty = DBUtility.ClsPub.isDoule(list[i]["浜х嚎鎬讳骇鑳�"]);
+ var HWorkQty = DBUtility.ClsPub.isDoule(list[i]["灏忔椂浜ц兘"]);
var HYX = list[i]["浼樺厛绾�"].ToString();
var HEmpID = list[i]["HEmpID"].ToString();
var HMaterID = list[i]["HMaterID"].ToString();
--
Gitblit v1.9.1