From b51ed3cea777b1809afe07db7314b0e0a8c0e9b8 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期三, 22 二月 2023 11:15:25 +0800
Subject: [PATCH] 工序出站-保存屏蔽包装标识，员工同步更改
---
WebAPI/Controllers/基础资料/基础资料/Gy_StaffController.cs | 90 ++++++++++++++++++++++++---------------------
WebAPI/Controllers/Sc_ProcessMangementController.cs | 2
2 files changed, 49 insertions(+), 43 deletions(-)
diff --git a/WebAPI/Controllers/Sc_ProcessMangementController.cs b/WebAPI/Controllers/Sc_ProcessMangementController.cs
index 9a71202..53cbe50 100644
--- a/WebAPI/Controllers/Sc_ProcessMangementController.cs
+++ b/WebAPI/Controllers/Sc_ProcessMangementController.cs
@@ -519,7 +519,7 @@
FentityModel.Add("FCostRate", dr1["FCostRate"].ToString());// 鎴愭湰鏉冮噸
FentityModel.Add("FISBACKFLUSH", dr1["FISBACKFLUSH"].ToString() == "1" ? true : false);// 鍊掑啿棰嗘枡
FentityModel.Add("FMOMAINENTRYID", dr1["FMOENTRYID"].ToString());//
- FentityModel.Add("F_bsv_Base1", new JObject() { ["Fnumber"] = dr1["FPREBDONENUMBER"].ToString() }); //鍖呰鏍囪瘑
+ //FentityModel.Add("F_bsv_Base1", new JObject() { ["Fnumber"] = dr1["FPREBDONENUMBER"].ToString() }); //鍖呰鏍囪瘑
FentityModel.Add("FLot", new JObject() { ["FNumber"] = dr1["FBATCHNO"].ToString() }); //鎵瑰彿
FentityModel.Add("F_bsv_Text", dr1["宸ュ簭娴佽浆鍗″彿"].ToString()); //娴佽浆鍗″彿
JArray Fentity2 = new JArray();
diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_StaffController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_StaffController.cs"
index 1eb6be7..d33ec4a 100644
--- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_StaffController.cs"
+++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_StaffController.cs"
@@ -496,52 +496,58 @@
{
}
+ // 鏄庣粏鍒椾俊鎭�
+ var _saveEntry = _saveObj["Result"]["Result"]["PostEntity"];
#region [琛ㄦ暟鎹祴鍊糫
- var jsonData = new
+ foreach (var oSub in _saveEntry)
{
- HItemID = _saveObj["Result"]["Result"]["Id"],
- HNumber = _saveObj["Result"]["Result"]["Number"],
- HName = _saveObj["Result"]["Result"]["Name"][0]["Value"],
- HShortNumber = _saveObj["Result"]["Result"]["Number"],
- HParentID = 0,
- HLevel = 1,
- HEndFlag = 1,
- HStopflag = _saveObj["Result"]["Result"]["ForbidStatus"].ToString() == "A" ? 0 : 1,
- HRemark = "CLD-ERP瀵煎叆",
- HUseFlag = "宸蹭娇鐢�",
- HCREATEORGID = _saveObj["Result"]["Result"]["CreateOrgId_Id"],
- HUSEORGID = _saveObj["Result"]["Result"]["UseOrgId_Id"],
- HPERSONID = _saveObj["Result"]["Result"]["PersonId_Id"],
- HPOSTID = _saveObj["Result"]["Result"]["FPostId_Id"],
- HFIRSTCARDID = _saveObj["Result"]["Result"]["FirstCardID_Id"],
- HDeptID = _saveObj["Result"]["Result"]["PostEntity"][0]["Post"]["FDept_Id"],
- HSTAFFNUMBER = _saveObj["Result"]["Result"]["FStaffNumber"]
- };
+ var jsonData = new
+ {
+ HItemID = oSub["StaffDetails"],
+ HNumber = _saveObj["Result"]["Result"]["Number"],
+ HName = _saveObj["Result"]["Result"]["Name"][0]["Value"],
+ HShortNumber = _saveObj["Result"]["Result"]["Number"],
+ HParentID = 0,
+ HLevel = 1,
+ HEndFlag = 1,
+ HStopflag = _saveObj["Result"]["Result"]["ForbidStatus"].ToString() == "A" ? 0 : 1,
+ HRemark = "CLD-ERP瀵煎叆",
+ HUseFlag = "宸蹭娇鐢�",
+ HCREATEORGID = _saveObj["Result"]["Result"]["CreateOrgId_Id"],
+ HUSEORGID = _saveObj["Result"]["Result"]["UseOrgId_Id"],
+ HPERSONID = _saveObj["Result"]["Result"]["PersonId_Id"],
+ HPOSTID = _saveObj["Result"]["Result"]["FPostId_Id"],
+ HFIRSTCARDID = _saveObj["Result"]["Result"]["FirstCardID_Id"],
+ HDeptID = oSub["PostDept_Id"],
+ HSTAFFNUMBER = _saveObj["Result"]["Result"]["FStaffNumber"]
+ };
+
+ // 鍒犻櫎涓昏〃瀵瑰簲鏁版嵁
+ sql = $"delete from Gy_Staff where HItemID = " + jsonData.HItemID + " and HNumber = '" + Number + "'";
+ oCN.RunProc(sql);
+
+ sql = "set identity_insert Gy_Staff on";
+ oCN.RunProc(sql);
+
+ //鎻掑叆琛�
+ sql = $@"
+ insert into Gy_Staff
+ (HItemID,HNumber,HName,HShortNumber,HParentID,HLevel
+ ,HEndFlag,HStopflag,HRemark,HUseFlag,HCREATEORGID,HUSEORGID
+ ,HPERSONID,HPOSTID,HFIRSTCARDID,HDeptID,HSTAFFNUMBER
+ )
+ values
+ ({jsonData.HItemID},'{jsonData.HNumber}','{jsonData.HName}',
+ '{jsonData.HShortNumber}',{jsonData.HParentID},{jsonData.HLevel},{jsonData.HEndFlag},{jsonData.HStopflag},'{jsonData.HRemark}','{jsonData.HUseFlag}',{jsonData.HCREATEORGID},{jsonData.HUSEORGID},
+ {jsonData.HPERSONID},{jsonData.HPOSTID},{jsonData.HFIRSTCARDID},{jsonData.HDeptID},'{jsonData.HSTAFFNUMBER}')";
+
+ oCN.RunProc(sql);
+
+ sql = "set identity_insert Gy_Staff off";
+ oCN.RunProc(sql);
+ }
#endregion
- // 鍒犻櫎涓昏〃瀵瑰簲鏁版嵁
- sql = $"delete from Gy_Staff where HItemID = " + jsonData.HItemID + " and HNumber = '" + Number + "'";
- oCN.RunProc(sql);
-
- sql = "set identity_insert Gy_Staff on";
- oCN.RunProc(sql);
-
- //鎻掑叆琛�
- sql = $@"
- insert into Gy_Staff
- (HItemID,HNumber,HName,HShortNumber,HParentID,HLevel
- ,HEndFlag,HStopflag,HRemark,HUseFlag,HCREATEORGID,HUSEORGID
- ,HPERSONID,HPOSTID,HFIRSTCARDID,HDeptID,HSTAFFNUMBER
- )
- values
- ({jsonData.HItemID},'{jsonData.HNumber}','{jsonData.HName}',
- '{jsonData.HShortNumber}',{jsonData.HParentID},{jsonData.HLevel},{jsonData.HEndFlag},{jsonData.HStopflag},'{jsonData.HRemark}','{jsonData.HUseFlag}',{jsonData.HCREATEORGID},{jsonData.HUSEORGID},
- {jsonData.HPERSONID},{jsonData.HPOSTID},{jsonData.HFIRSTCARDID},{jsonData.HDeptID},'{jsonData.HSTAFFNUMBER}')";
-
- oCN.RunProc(sql);
-
- sql = "set identity_insert Gy_Staff off";
- oCN.RunProc(sql);
objJsonResult.code = "1";
objJsonResult.count = 1;
--
Gitblit v1.9.1