From ae3c361a3f387e9d6963ff4d0a514ebb88ae3e32 Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期三, 25 三月 2026 10:39:46 +0800
Subject: [PATCH] 增加获取金蝶基础资料二开方法，工序流转卡派工时候，如果同意机台模具已派工，不允许二次派工
---
WebAPI/Controllers/基础资料/基础资料/Gy_OperatorGroupController.cs | 30 ++++++++++++++++++------------
1 files changed, 18 insertions(+), 12 deletions(-)
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_OperatorGroupController.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_OperatorGroupController.cs"
index ff3f906..70f0f53 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_OperatorGroupController.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_OperatorGroupController.cs"
@@ -32,28 +32,34 @@
oCN.BeginTran();
LogService.Write("涓氬姟缁� 瀹℃牳鍚屾: " + sMainSub.ToString());
- var sMain = sMainSub["model"]["FENTRY"].ToString();
- List<Model.ClsGy_OperatorGroup> lsmain = new List<Model.ClsGy_OperatorGroup>();
- lsmain = oListModels.getObjectByJson_Gy_OperatorGroup(sMain);
- var sql = string.Empty;
- foreach(var oMain in lsmain)
+ foreach (var oSub in sMainSub["model"]["FENTRY"])
{
- sql = $@"delete from Gy_OperatorGroup where HItemID = {oMain.HItemID}";
- oCN.RunProc(sql);
-
- sql = $@"insert into Gy_OperatorGroup(HItemID
+ oSub["hendflag"] = string.Equals(oSub["hendflag"].ToString(), "1");
+ oSub["hstopflag"] = string.Equals(oSub["hstopflag"].ToString(), "1");
+ oSub["hisuse"] = string.Equals(oSub["hisuse"].ToString(), "1");
+ }
+ var sMain = sMainSub["model"]["FENTRY"].ToString() ;
+ List<Model.ClsGy_OperatorGroup> lsmain = new List<Model.ClsGy_OperatorGroup>();
+ lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_OperatorGroup>>(sMain);
+ var sql = string.Empty;
+ sql = $@"delete from Gy_OperatorGroup where HItemID = {lsmain[0].HItemID}";
+ oCN.RunProc(sql);
+ foreach (var oMain in lsmain)
+ {
+ sql = $@"
+ set identity_insert Gy_OperatorGroup on
+ insert into Gy_OperatorGroup(HItemID
,HNumber ,HName,HShortNumber,HParentID,HLevel,HEndFlag
,HStopflag,HRemark,HHelpCode,HUseFlag,HUSEORGID
,HOperatorGroupId,HOperatorGroupType,HIsUse)
values({oMain.HItemID}, '{oMain.HNumber}', '{oMain.HName}', '{oMain.HShortNumber}',
- {oMain.HParentID}, '{oMain.HLevel}', '{oMain.HEndFlag}', '{oMain.HStopflag}'
+ {oMain.HParentID}, '{oMain.HLevel}', '{oMain.HEndFlag}', '{oMain.HStopflag}',
'{oMain.HRemark}', '{oMain.HHelpCode}' ,'{oMain.HUseFlag}', '{oMain.HUSEORGID}',
'{oMain.HOperatorGroupId}','{oMain.HOperatorGroupType}', '{oMain.HIsUse}'
)
+ set identity_insert Gy_OperatorGroup off
";
-
oCN.RunProc(sql);
-
}
oCN.Commit();
--
Gitblit v1.9.1