From 7b82df0f292753396d0112b63cffedf9c25d885b Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期二, 18 十一月 2025 15:53:35 +0800
Subject: [PATCH] 添康钉钉同步,更改班组获取方式

---
 WebAPI/Controllers/数据同步/钉钉同步/DD_DataSynchronizationController.cs |   22 +++++++++++++++++++---
 1 files changed, 19 insertions(+), 3 deletions(-)

diff --git "a/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\351\222\211\351\222\211\345\220\214\346\255\245/DD_DataSynchronizationController.cs" "b/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\351\222\211\351\222\211\345\220\214\346\255\245/DD_DataSynchronizationController.cs"
index 0a6bfe8..de12a8f 100644
--- "a/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\351\222\211\351\222\211\345\220\214\346\255\245/DD_DataSynchronizationController.cs"
+++ "b/WebAPI/Controllers/\346\225\260\346\215\256\345\220\214\346\255\245/\351\222\211\351\222\211\345\220\214\346\255\245/DD_DataSynchronizationController.cs"
@@ -3336,14 +3336,30 @@
                         HDeptID = ds.Tables[0].Rows[0]["HDeptID"].ToString();
                     }
                     oItem.HDeptID = int.Parse(HDeptID);
-                    ds = oCN.RunProcReturn("select * from Gy_Group with(nolock)  where HName='" + oItem.HGroupName + "'", "Gy_Group");
+                    //鐝粍涓烘彁浜や汉鐨勭彮缁�
+                    //ds = oCN.RunProcReturn("select * from Gy_Group with(nolock)  where HName='" + oItem.HGroupName + "'", "Gy_Group");
+                    //string HGroupID = "0";
+                    //if (ds.Tables[0].Rows.Count > 0)
+                    //{
+                    //    HGroupID = ds.Tables[0].Rows[0]["HItemID"].ToString();
+                    //}
+                    //oItem.HGroupID = int.Parse(HGroupID);
+                    string input = getProcessInstanceResponse.Body.Result.Title;
+                    int index = input.IndexOf("鎻愪氦");
+                    string HGroupEmpName = "";
+                    if (index > 0)
+                    {
+                        HGroupEmpName = input.Substring(0, index).Trim();//鎴彇鎻愪氦浜哄悕绉板嵆鐝粍闀垮悕绉�
+                    }
+                    ds = oCN.RunProcReturn("select * from Gy_Employee with(nolock)  where HName='" + HGroupEmpName + "'", "Gy_Employee");
                     string HGroupID = "0";
                     if (ds.Tables[0].Rows.Count > 0)
                     {
-                        HGroupID = ds.Tables[0].Rows[0]["HItemID"].ToString();
+                        HGroupID = ds.Tables[0].Rows[0]["HGroupID"].ToString();
                     }
                     oItem.HGroupID = int.Parse(HGroupID);
-                    
+
+
                     //鍙嶅簭鍒楀寲鏄庣粏鍐呭
                     string tableFieldValue = getProcessInstanceResponse.Body.Result.FormComponentValues[11].Value;
                     List<Row> rows = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Row>>(tableFieldValue);

--
Gitblit v1.9.1