From 113a2edc689d008e65af8b1c0d264c7b911a41f2 Mon Sep 17 00:00:00 2001
From: llj <132905093+newwwwwwtree@users.noreply.github.com>
Date: 星期三, 21 一月 2026 17:17:33 +0800
Subject: [PATCH] 1
---
WebAPI/DLL/ClsQC_PatrolProcCheckBill.cs | 4 ++--
WebAPI/Controllers/SCGL/日计划管理/JIT_DayPlanPlatFormImportController.cs | 8 +++++++-
2 files changed, 9 insertions(+), 3 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();
diff --git a/WebAPI/DLL/ClsQC_PatrolProcCheckBill.cs b/WebAPI/DLL/ClsQC_PatrolProcCheckBill.cs
index 521976c..a130ae3 100644
--- a/WebAPI/DLL/ClsQC_PatrolProcCheckBill.cs
+++ b/WebAPI/DLL/ClsQC_PatrolProcCheckBill.cs
@@ -258,8 +258,8 @@
"," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
"," + oSub.HQCCheckItemID.ToString() + ",'" + oSub.HQCStd + "','" + oSub.HQCNote1 + "','" + oSub.HQCNote2 + "','" + oSub.HQCNote3 + "','" + oSub.HQCNote4 + "'" +
",'" + oSub.HQCNote5 + "','" + oSub.HQCNote6 + "','" + oSub.HQCNote7 + "','" + oSub.HQCNote8 + "','" + oSub.HQCNote9 + "','" + oSub.HQCNote10 + "','" + oSub.HQCNote1_SN + "','" + oSub.HQCNote2_SN + "','" + oSub.HQCNote3_SN + "','" + oSub.HQCNote4_SN + "','" + oSub.HQCNote5_SN + "','" + oSub.HQCNote6_SN + "','" + oSub.HQCNote7_SN + "','" + oSub.HQCNote8_SN + "','" + oSub.HQCNote9_SN + "','" + oSub.HQCNote10_SN + "'" +
- ","+ oSub.HTargetVal+","+ oSub.HInspectMethodID+","+ oSub.HDownLimit+","+ oSub.HUpLimit + ",'"+ oSub.HAnalysisMethod+"'"+
- "," + oSub.HTargetVal2 + "," + oSub.HTargetVal3 + "," + oSub.HTargetVal4 + "," + oSub.HTargetVal5 + "," + oSub.HTargetVal6 +
+ ",'"+ oSub.HTargetVal+"',"+ oSub.HInspectMethodID+",'"+ oSub.HDownLimit+"','"+ oSub.HUpLimit + "','"+ oSub.HAnalysisMethod+"'"+
+ ",'" + oSub.HTargetVal2 + "','" + oSub.HTargetVal3 + "','" + oSub.HTargetVal4 + "','" + oSub.HTargetVal5 + "','" + oSub.HTargetVal6 + "'" +
") ");
}
//鎻掑叆瀛愯〃2
--
Gitblit v1.9.1