From 58725ea40b93a10099cac826c4d7912f21975f4d Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期三, 16 七月 2025 09:17:45 +0800
Subject: [PATCH] 快速过滤方案保存删除异常里面的回滚；自动获取校验方案修改提示信息；
---
WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs | 23 ++++++++++++-----------
1 files changed, 12 insertions(+), 11 deletions(-)
diff --git a/WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs b/WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs
index eb7a166..d8ef724 100644
--- a/WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs
+++ b/WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs
@@ -536,7 +536,7 @@
foreach (Gy_RoutingBillSub oSub in DetailColl)
{
i++;
- if (oSystemParameter.omodel.WMS_CampanyName != "榫欏北姹介厤" && oSystemParameter.omodel.WMS_CampanyName != "娣诲悍绉戞妧" && oSystemParameter.omodel.WMS_CampanyName != "瀹濆伐")
+ if (oSystemParameter.omodel.WMS_CampanyName != "榫欏北姹介厤" && oSystemParameter.omodel.WMS_CampanyName != "娣诲悍绉戞妧" && oSystemParameter.omodel.WMS_CampanyName != "瀹濆伐" && oSystemParameter.omodel.WMS_CampanyName != "涓夊崌")
{
if (oSub.HWorkQty <= 0)
{
@@ -563,7 +563,7 @@
",HPackStd,HPack,HPutArea,HMyWorkDays,HMyFixWorkDays,HPassRate" +
",HTechnologyParameter,HPicNum,HProcCheckNote" +
",HOverRate,HProcWorkNum,HBadWHID,HWasterWHID, HWHID,HIsTime,HEstimate " +
- ",HWorkTimes_S,HSortProcFlag,HSubStdEmpAvg_S" +
+ ",HWorkTimes_S,HSortProcFlag,HSubStdEmpAvg_S,HYDCoefficient" +
") values("
+ HInterID + "," + i + "," + oSub.HProcID.ToString() + ",'" + oSub.HProcNo + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" +
"," + oSub.HWorkQty.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HTimeUnit.ToString() + "'," + oSub.HUnitTime.ToString() +
@@ -577,6 +577,7 @@
",'" + oSub.HTechnologyParameter.ToString() + "','" + oSub.HPicNum.ToString() + "','" + oSub.HProcCheckNote.ToString() +
"', " + oSub.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'," + oSub.HBadWHID.ToString() + "," + oSub.HWasterWHID.ToString() + "," + oSub.HWHID.ToString() + "," + Convert.ToString(oSub.HIsTime ? 1 : 0) + "," + oSub.HEstimate.ToString() +
", " + oSub.HWorkTimes_S.ToString() + "," + Convert.ToString(oSub.HSortProcFlag ? 1 : 0) + "," + oSub.HSubStdEmpAvg_S +
+ "," + oSub.HYDCoefficient +
") ");
//璁′环鏂瑰紡涓嶄负璁℃椂锛屽垯鎶婅鏃舵殏浼板瓧娈垫洿鏂颁负绌�
if (oSub.HIsTime == false)
@@ -606,7 +607,7 @@
",HTechnologyParameter,HPicNum,HProcCheckNote" +
",HOverRate,HProcWorkNum,HBadWHID,HWasterWHID, HWHID,HEstimate,HIsTime" +
",HQCSchemeID_Fst,HQCSchemeID_Proc,HQCSchemeID_Patrol" +
- ",HWorkTimes_S,HSortProcFlag,HSNCtrl,HQCFst,HQCProc,HQCPatrol,HMaterToSourceCtrl,HSubStdEmpAvg_S" +
+ ",HWorkTimes_S,HSortProcFlag,HSNCtrl,HQCFst,HQCProc,HQCPatrol,HMaterToSourceCtrl,HSubStdEmpAvg_S,HYDCoefficient" +
") values("
+ HInterID + "," + i + "," + oSub.HProcID.ToString() + ",'" + oSub.HProcNo + "'," + oSub.HSupID.ToString() + "," + Convert.ToString(oSub.HSupFlag ? 1 : 0) + "" +
"," + oSub.HWorkQty.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HTimeUnit.ToString() + "'," + oSub.HUnitTime.ToString() +
@@ -620,7 +621,7 @@
",'" + oSub.HTechnologyParameter.ToString() + "','" + oSub.HPicNum.ToString() + "','" + oSub.HProcCheckNote.ToString() +
"', " + oSub.HOverRate.ToString() + ",'" + oSub.HProcWorkNum.ToString() + "'," + oSub.HBadWHID.ToString() + "," + oSub.HWasterWHID.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HEstimate.ToString() + "," + Convert.ToString(oSub.HIsTime ? 1 : 0) + "," + oSub.HQCSchemeID_Fst + "," +
oSub.HQCSchemeID_Proc + "," + oSub.HQCSchemeID_Patrol +
- ", " + oSub.HWorkTimes_S.ToString() + "," + Convert.ToString(oSub.HSortProcFlag ? 1 : 0) + "," + Convert.ToString(oSub.HSNCtrl ? 1 : 0) + "," + Convert.ToString(oSub.HQCFst ? 1 : 0) + "," + Convert.ToString(oSub.HQCProc ? 1 : 0) + "," + Convert.ToString(oSub.HQCPatrol ? 1 : 0) + "," + Convert.ToString(oSub.HMaterToSourceCtrl ? 1 : 0) + "," + oSub.HSubStdEmpAvg_S +
+ ", " + oSub.HWorkTimes_S.ToString() + "," + Convert.ToString(oSub.HSortProcFlag ? 1 : 0) + "," + Convert.ToString(oSub.HSNCtrl ? 1 : 0) + "," + Convert.ToString(oSub.HQCFst ? 1 : 0) + "," + Convert.ToString(oSub.HQCProc ? 1 : 0) + "," + Convert.ToString(oSub.HQCPatrol ? 1 : 0) + "," + Convert.ToString(oSub.HMaterToSourceCtrl ? 1 : 0) + "," + oSub.HSubStdEmpAvg_S + "," + oSub.HYDCoefficient +
") ");
//璁′环鏂瑰紡涓嶄负璁℃椂锛屽垯鎶婅鏃舵殏浼板瓧娈垫洿鏂颁负绌�
if (oSub.HIsTime == false)
@@ -1821,7 +1822,7 @@
{
for(int i=0;i< dsMain.Tables[0].Rows.Count; i++)
{
- string HMaterNumber = DBUtility.ClsPub.isStrNull(dsMain.Tables[0].Rows[0]["浜у搧浠ｇ爜"]);
+ string HMaterNumber = DBUtility.ClsPub.isStrNull(dsMain.Tables[0].Rows[i]["浜у搧浠ｇ爜"]);
if (!oMaterHlp.GetInfoByNumber(HMaterNumber))
{
string sMsg = "鐗╂枡銆�" + HMaterNumber + "銆戜笉瀛樺湪锛�";
@@ -1909,14 +1910,14 @@
DataSet dsSub = oCN.RunProcReturn("select * from diyipi_WorkQty where 浜у搧浠ｇ爜 = '" + HMaterNumber + "' order by 宸ュ簭搴忓彿", "diyipi_WorkQty");
for(int j = 0; j < dsSub.Tables[0].Rows.Count; j++)
{
- string HProcNumber = DBUtility.ClsPub.isStrNull(dsSub.Tables[0].Rows[j]["宸ュ簭浠ｇ爜"]);
+ string HProcName = DBUtility.ClsPub.isStrNull(dsSub.Tables[0].Rows[j]["宸ュ簭"]);
//寰楀埌宸ュ簭鍐呯爜
- if (!oProcHlp.GetInfoByNumber(HProcNumber))
+ if (!oProcHlp.GetInfoByName(HProcName))
{
- string sMsg = "宸ュ簭銆�" + HProcNumber + "銆戜笉瀛樺湪锛�";
+ string sMsg = "宸ュ簭銆�" + HProcName + "銆戜笉瀛樺湪锛�";
if (finalErrMsg.Contains(sMsg) == false)
{
- finalErrMsg = finalErrMsg + "宸ュ簭銆�" + HProcNumber + "銆戜笉瀛樺湪锛乗r\n";
+ finalErrMsg = finalErrMsg + "宸ュ簭銆�" + HProcName + "銆戜笉瀛樺湪锛乗r\n";
}
continue;
}
@@ -1947,10 +1948,10 @@
//寰楀埌鐢熶骇璧勬簮鍐呯爜
if (!oSourceHlp.GetInfoByNumber(sHNumberSourceList[t]))
{
- string sMsg = "鐢熶骇璧勬簮銆�" + HProcNumber + "銆戜笉瀛樺湪锛�";
+ string sMsg = "鐢熶骇璧勬簮銆�" + sHNumberSourceList[t] + "銆戜笉瀛樺湪锛�";
if (finalErrMsg.Contains(sMsg) == false)
{
- finalErrMsg = finalErrMsg + "鐢熶骇璧勬簮銆�" + HProcNumber + "銆戜笉瀛樺湪锛乗r\n";
+ finalErrMsg = finalErrMsg + "鐢熶骇璧勬簮銆�" + sHNumberSourceList[t] + "銆戜笉瀛樺湪锛乗r\n";
}
continue;
}
--
Gitblit v1.9.1