1

zrg

2025-05-17 c56f2e4192649d55ffc22e174ab0f2ce7b5dd03f

 WebAPI/Controllers/Êý¾Ýͬ²½/¶¤¶¤Í¬²½/DD_DataSynchronizationController.cs

@@ -74,9 +74,12 @@
        }

        #region å˜é‡
        private string AppKey = "dingiokapm2dvjrhzl2g";                                                                             //已创建的企业内部应用的AppKey。
        private string AppSecret = "dPUD7tN3BGVYAC4lDzhpcBH7O4FWFDdjLJWa6cVRBQj5U7GJ4Gwr7Vohnv0oPBOr";                             //已创建的企业内部应用的AppSecret。
        private long AgentID = 3188176952;                                                                                          //应用的AgentId
        //private string AppKey = "dingiokapm2dvjrhzl2g";                                                                             //已创建的企业内部应用的AppKey。
        //private string AppSecret = "dPUD7tN3BGVYAC4lDzhpcBH7O4FWFDdjLJWa6cVRBQj5U7GJ4Gwr7Vohnv0oPBOr";                             //已创建的企业内部应用的AppSecret。
        //private long AgentID = 3188176952;                                                                                          //应用的AgentId
        private string AppKey = "dingj3hskhwk8jioofub";                                                                             //已创建的企业内部应用的AppKey。
        private string AppSecret = "qGPbXJGJtFI__FYGdzZPIjHZP_o1jI1KnM4_bbKx9AUuXcYqr3UN6nkQeSe8GcT7";                             //已创建的企业内部应用的AppSecret。
        private long AgentID = 3553515838;                                                                                          //应用的AgentId
        public string accessToken = "";                                                                                           //调用该接口的访问凭证。
        private string ProcessInstanceId = "";                                                                                     //审批实例ID。
        #endregion
@@ -593,6 +596,7 @@
        #region èŽ·å– å®œæ­æŒ‡å®šå•æ®çš„实例ID列表--指定分页的数据
        public bool getInstanceIDList_Page_YiDa(string appType, string systemToken, string userID, string formUuid, int pageNumber, int pageSize, ref YD_GetInstanceIDListResponse response, ref string msg)
        {
            LogService.Write("查看4-传递参数:appType=" + appType + ",systemToken=" + systemToken + ",formUuid=" + formUuid + ",userID=" + userID + ",pageSize=" + pageSize + ",pageNumber=" + pageNumber+ ",accessToken="+ this.accessToken);
            AlibabaCloud.SDK.Dingtalkyida_1_0.Client client = CreateClient4();
            AlibabaCloud.SDK.Dingtalkyida_1_0.Models.GetInstanceIdListHeaders getInstanceIdListHeaders = new AlibabaCloud.SDK.Dingtalkyida_1_0.Models.GetInstanceIdListHeaders();
            getInstanceIdListHeaders.XAcsDingtalkAccessToken = this.accessToken;
@@ -639,7 +643,9 @@
                {
                    // err ä¸­å«æœ‰ code å’Œ message å±žæ€§ï¼Œå¯å¸®åŠ©å¼€å‘定位问题
                }
             
                msg = "错误代码" + err.Code + "：" + err.Message;
                LogService.Write("查看4-报错信息1:"+ msg);
                return false;

            }
@@ -654,6 +660,7 @@
                    // err ä¸­å«æœ‰ code å’Œ message å±žæ€§ï¼Œå¯å¸®åŠ©å¼€å‘定位问题
                }
                msg = "错误代码" + err.Code + "：" + err.Message;
                LogService.Write("查看4-报错信息2:" + msg);
                return false;
            }
        }
@@ -662,6 +669,7 @@
        #region èŽ·å– å®œæ­æŒ‡å®šå•æ®çš„实例ID列表
        public bool getInstanceIDList_YiDa(string appType, string systemToken, string userID, string formUuid, int pageNumber, int pageSize, ref List<string> IDList, ref string msg)
        {
            LogService.Write("查看4-1查询");
            YD_GetInstanceIDListResponse response = new YD_GetInstanceIDListResponse();
            do
            {
@@ -980,7 +988,7 @@
                        return false;
                    }


                    LogService.Write("查看1-数据查询1");
                    for (int i = 0; i < response.Body.Result.Count; i++)
                    {
                        try
@@ -1028,6 +1036,7 @@
                            //    oItem.HEmployeeID = ((List<object>)response.Body.Result[i].FormData["employeeField_lo6w37hf_id"])[0].ToString().Replace("'", "");
                            //}

                            LogService.Write("查看1-数据查询-循环里面2:"+ oItem.HInstanceID);

                            //签到表
                            if (keys.Contains("dateField_ls9ma7h3"))
@@ -1056,7 +1065,7 @@
                                oItem.HEmployeeID = ((List<object>)response.Body.Result[i].FormData["employeeField_ls9ma7h5_id"])[0].ToString().Replace("'", "");
                            }


                            LogService.Write("查看1-数据查询-循环里面3:获取实例状态:"+ oItem.HInstanceStatus);

                            //获取实例状态
                            GetInstanceByIdResponse response1 = new GetInstanceByIdResponse();
@@ -1097,7 +1106,7 @@
                                oItem.HApprovedResult = "";
                            }


                            LogService.Write("查看1-数据查询-循环里面4:数据新增:" + oItem.HApprovedResult);

                            lsmain.Add(oItem);
                        }catch(Exception e)
@@ -1156,7 +1165,8 @@

            try
            {
              oCN.BeginTran();
                LogService.Write("查看1-新增数据");
                oCN.BeginTran();
                foreach (YD_FenCengShenHeQianDaoBiao oItem in lsmain)
                {
                    string sql_searchRepeat = "select * from DD_FenCengShenHeQianDaoBiao where HInstanceID = '" + oItem.HInstanceID + "'";
@@ -1194,10 +1204,12 @@
                    oCN.RunProc(sql_main);
                }
                oCN.Commit();
                LogService.Write("查看1-新增数据结束");
                return true;
            }catch(Exception e)
            {
                msg = e.Message;
                LogService.Write("查看1-报错" + msg);
                oCN.RollBack();
                return false;
            }
@@ -1759,7 +1771,7 @@
                        return false;
                    }

                    
                    LogService.Write("查看4-循环-查询数据");
                    for (int i = 0; i < response.Body.Result.Count; i++)
                    {
                        try
@@ -1775,6 +1787,8 @@
                            oItem.HUpdateDate = response.Body.Result[i].ModifiedTimeGMT.Replace("T", " ").Replace("Z", "").Replace("'", ""); ;
                            oItem.HInstanceID = response.Body.Result[i].FormInstanceId.Replace("'", ""); ;
                            oItem.HOriginator = response.Body.Result[i].Originator.Name.NameInChinese.Replace("'", ""); ;

                            LogService.Write("查看4-循环-获取id-查询数据"+ oItem.HInstanceID);

                            int startindex = response.Body.Result[i].Title.IndexOf("zh_CN") + 8;
                            oItem.HTitle = startIndex + response.Body.Result[i].Title.Substring(startindex).Replace("\"}", "").Replace("'", "");
@@ -1795,6 +1809,8 @@
                            {
                                return false;
                            }

                            LogService.Write("查看4-循环-获取状态-查询数据" + oItem.HInstanceStatus);

                            oItem.HInstanceStatus = response1.Body.InstanceStatus;
                            if (oItem.HInstanceStatus == "RUNNING")
@@ -1916,6 +1932,8 @@
                            
                            oItem.HQuestion_Duty = sub2List;

                            LogService.Write("查看4-循环-新增结束-查询数据" + oItem.HQuestion_Duty.Count);

                            lsmain.Add(oItem);
                        }
                        catch (Exception e)
@@ -1957,9 +1975,10 @@
            List<string> IDList = new List<string>();
            if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false)
            {
                LogService.Write("查看4-1-返回");
                return false;
            }

            LogService.Write("查看4-1");
            //获取详细信息并附加到列表lsmain中
            List<YD_QRQCWenTiTiJiaoBiao> lsmain = new List<YD_QRQCWenTiTiJiaoBiao>();
            if (getInstanceDetailList_QRQCWenTiTiJiaoBiao__YiDa(appType, systemToken, userID, formUuid, IDList, ref lsmain, ref msg) == false)
@@ -1969,6 +1988,7 @@

            try
            {
                LogService.Write("查看4-新增");
                oCN.BeginTran();
                foreach (YD_QRQCWenTiTiJiaoBiao oItem in lsmain)
                {
@@ -2055,11 +2075,13 @@

                }
                oCN.Commit();
                LogService.Write("查看4-新增结束");
                return true;
            }
            catch (Exception e)
            {
                msg = e.Message;
                LogService.Write("查看4-新增报错:"+ msg);
                oCN.RollBack();
                return false;
            }
@@ -3587,14 +3609,14 @@
            string msg = "";
            try
            {
                if (getData_ErrWorkTimesRequest(startTime,endTime,ref msg) == false)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "Exception！" + msg;
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //if (getData_ErrWorkTimesRequest(startTime,endTime,ref msg) == false)
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "Exception！" + msg;
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                objJsonResult.code = "1";
                objJsonResult.count = 1;