器具状态：审核/反审核

duhe

2025-05-30 19c5b6ade28e4ee6f26371fc1cd80a148ee85203

 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
@@ -536,25 +539,29 @@
        #region èŽ·å– é’‰é’‰-智能人事 èŽ·å–在职员工ID列表
        public bool getEmployeeIDList_DingDing(long offset, long size, ref List<string> IDList, ref string msg)
        {
            LogService.Write("查看5-1-1");
            OapiSmartworkHrmEmployeeQueryonjobResponse response = new OapiSmartworkHrmEmployeeQueryonjobResponse();
            do
            {
                if (getEmployeeIDList_Page_DingDing(offset, size, ref response, ref msg) == false)
                {
                    LogService.Write("查看5-1-2");
                    return false;
                }

                LogService.Write("查看5-1-3");
                for (int i = 0; i < response.Result.DataList.Count; i++)
                {
                    IDList.Add(response.Result.DataList[i]);
                }

                LogService.Write("查看5-1-4");
                if (response.Result.NextCursor != 0)
                {
                    LogService.Write("查看5-1-4-1");
                    offset = response.Result.NextCursor;
                }
                else
                {
                    LogService.Write("查看5-1-5");
                    break;
                }
            } while (true);
@@ -589,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;
@@ -635,7 +643,9 @@
                {
                    // err ä¸­å«æœ‰ code å’Œ message å±žæ€§ï¼Œå¯å¸®åŠ©å¼€å‘定位问题
                }
             
                msg = "错误代码" + err.Code + "：" + err.Message;
                LogService.Write("查看4-报错信息1:"+ msg);
                return false;

            }
@@ -650,6 +660,7 @@
                    // err ä¸­å«æœ‰ code å’Œ message å±žæ€§ï¼Œå¯å¸®åŠ©å¼€å‘定位问题
                }
                msg = "错误代码" + err.Code + "：" + err.Message;
                LogService.Write("查看4-报错信息2:" + msg);
                return false;
            }
        }
@@ -658,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
            {
@@ -976,7 +988,7 @@
                        return false;
                    }


                    LogService.Write("查看1-数据查询1");
                    for (int i = 0; i < response.Body.Result.Count; i++)
                    {
                        try
@@ -1024,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"))
@@ -1052,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();
@@ -1093,11 +1106,12 @@
                                oItem.HApprovedResult = "";
                            }


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

                            lsmain.Add(oItem);
                        }catch(Exception e)
                        {
                            LogService.Write("查看1" + e.Message);
                            continue;
                        }
                    }
@@ -1134,7 +1148,7 @@
            string formUuid = "FORM-A01FFB0B63A34F18B7753F695F49190DJEY7";              //签到表
            int pageNumber = 1;
            int pageSize = 100;

            LogService.Write("查看1");
            //获取分层审核表的实例ID列表
            List<string> IDList = new List<string>();
            if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false)
@@ -1151,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 + "'";
@@ -1189,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;
            }
@@ -1341,6 +1358,7 @@
                            lsmain.Add(oItem);
                        }catch(Exception e)
                        {
                            LogService.Write("查看2"+e.Message);
                            continue;
                        }
                    }
@@ -1372,7 +1390,7 @@
            string formUuid = "FORM-E3DFC12364514330A836DD3056C15668UGG7";
            int pageNumber = 1;
            int pageSize = 100;

            LogService.Write("查看2");
            //获取实例ID列表
            List<string> IDList = new List<string>();
            if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false)
@@ -1610,6 +1628,7 @@
                        }
                        catch (Exception e)
                        {
                            LogService.Write("查看3"+e.Message);
                            continue;
                        }
                    }
@@ -1641,7 +1660,7 @@
            string formUuid = "FORM-K5766HA1CKZB4E1L64Y1KBWCJTQF2HWJ3NDJL4";
            int pageNumber = 1;
            int pageSize = 100;

            LogService.Write("查看3");
            //获取实例ID列表
            List<string> IDList = new List<string>();
            if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false)
@@ -1752,7 +1771,7 @@
                        return false;
                    }

                    
                    LogService.Write("查看4-循环-查询数据");
                    for (int i = 0; i < response.Body.Result.Count; i++)
                    {
                        try
@@ -1768,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("'", "");
@@ -1788,6 +1809,8 @@
                            {
                                return false;
                            }

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

                            oItem.HInstanceStatus = response1.Body.InstanceStatus;
                            if (oItem.HInstanceStatus == "RUNNING")
@@ -1909,10 +1932,13 @@
                            
                            oItem.HQuestion_Duty = sub2List;

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

                            lsmain.Add(oItem);
                        }
                        catch (Exception e)
                        {
                            LogService.Write("查看4"+e.Message);
                            continue;
                        }
                    }
@@ -1944,14 +1970,15 @@
            string formUuid = "FORM-65AD77453E7F44EA847166C3AB5A1F04IPSS";
            int pageNumber = 1;
            int pageSize = 100;

            LogService.Write("查看4");
            //获取实例ID列表
            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)
@@ -1961,6 +1988,7 @@

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

                }
                oCN.Commit();
                LogService.Write("查看4-新增结束");
                return true;
            }
            catch (Exception e)
            {
                msg = e.Message;
                LogService.Write("查看4-新增报错:"+ msg);
                oCN.RollBack();
                return false;
            }
@@ -2158,6 +2188,7 @@
                        }
                        catch (Exception e)
                        {
                            LogService.Write("查看5"+e.Message);
                            continue;
                        }
                    }
@@ -2189,14 +2220,16 @@
        {
            long offset = 0;
            long size = 50;

            LogService.Write("查看5");
            LogService.Write("查看5.1");
            //获取花名册职员ID列表
            List<string> IDList = new List<string>();
            if (getEmployeeIDList_DingDing(offset, size, ref IDList, ref msg) == false)
            {
                LogService.Write("查看5-1"+ msg);
                return false;
            }

            LogService.Write("查看5-2");
            //获取详细信息并附加到列表lsmain中
            List<DD_HuaMingCe> lsmain = new List<DD_HuaMingCe>();
            if (getEmployeeDetailList_HuaMingCe__DingDing(IDList, ref lsmain, ref msg) == false)
@@ -2205,6 +2238,7 @@
            }
            try
            {
                LogService.Write("查看5-3");
                oCN.BeginTran();
                foreach (DD_HuaMingCe oItem in lsmain)
                {
@@ -2229,12 +2263,14 @@

                    oCN.RunProc(sql_main);
                }
                LogService.Write("查看5-4");
                oCN.Commit();
                return true;
            }
            catch (Exception e)
            {
                msg = e.Message;
                LogService.Write("查看5报错:" + e.Message);
                oCN.RollBack();
                return false;
            }
@@ -2294,11 +2330,88 @@
                            {
                                continue;
                            }
                            string HStaus = "";

                            switch (getInstanceByIdResponse.Body.InstanceStatus)
                            {
                                case "COMPLETED":
                                    HStaus = "维修结束";
                                    break;
                                case "RUNNING":
                                    HStaus = "维修进行中";
                                    break;
                                case "TERMINATED":
                                    HStaus = "维修终止";
                                    break;
                            }

                            LogService.Write("状态:" + HStaus);

                            if (getInstanceByIdResponse.Body.InstanceStatus != "COMPLETED")
                            {
                                //模具编码
                                if (keys.Contains("selectField_lq3idkvg"))
                                {
                                    string HDate_Temp = response.Body.Result[i].FormData["selectField_lq3idkvg"].ToString();
                                    LogService.Write("模具:" + HDate_Temp);
                                    DataSet ds = oCN.RunProcReturn("select * from Gy_MouldFileMain with(nolock)  where HMouldNo='" + HDate_Temp + "'", "Gy_MouldFileMain");
                                    string HMouldID = "0";
                                    if (ds.Tables[0].Rows.Count > 0)
                                    {
                                        LogService.Write("测试1:" + ds.Tables[0].Rows[0]["HCloseDate"].ToString());
                                        string HUpdateDate = ds.Tables[0].Rows[0]["HCloseDate"].ToString() == "" ? "1900-01-01 00:00:00" : ds.Tables[0].Rows[0]["HCloseDate"].ToString();
                                        string HMouldStaus = ds.Tables[0].Rows[0]["HMouldStatus"].ToString();
                                        LogService.Write("模具:" + HDate_Temp + ",状态:" + HMouldStaus + ",时间:" + HUpdateDate);
                                        HMouldID = ds.Tables[0].Rows[0]["HInterID"].ToString();
                                        if (HMouldStaus != HStaus && DateTime.Parse(HUpdateDate) <= DateTime.Parse(oItem.HUpdateDate)) {
                                            //修改模具的状态和时间
                                            oCN.RunProc("update Gy_MouldFileMain set HMouldUseStatus='" + HStaus + "',HCloseDate='" + oItem.HUpdateDate + "' WHERE HInterID =" + HMouldID);
                                        }
                                    }
                                }

                                continue;
                            }

                            //模具编码
                            if (keys.Contains("selectField_lq3idkvg"))
                            {
                                string HDate_Temp = response.Body.Result[i].FormData["selectField_lq3idkvg"].ToString();
                                LogService.Write("模具:" + HDate_Temp);
                                DataSet ds = oCN.RunProcReturn("select * from Gy_MouldFileMain with(nolock)  where HMouldNo='" + HDate_Temp + "'", "Gy_MouldFileMain");
                                string HMouldID = "0";
                                if (ds.Tables[0].Rows.Count > 0)
                                {
                                    LogService.Write("测试2:" + ds.Tables[0].Rows[0]["HCloseDate"].ToString());
                                    HMouldID = ds.Tables[0].Rows[0]["HInterID"].ToString();
                                    string HUpdateDate = ds.Tables[0].Rows[0]["HCloseDate"].ToString() == "" ? "1900-01-01 00:00:00" : ds.Tables[0].Rows[0]["HCloseDate"].ToString();
                                
                                    string HMouldStaus = ds.Tables[0].Rows[0]["HMouldStatus"].ToString();
                                  
                                    LogService.Write("模具:" + HDate_Temp+ ",状态:" + HMouldStaus + ",时间:" + HUpdateDate);
                                    if (HMouldStaus != HStaus && DateTime.Parse(HUpdateDate) <= DateTime.Parse(oItem.HUpdateDate))
                                    {
                                        //修改模具的状态和时间
                                        oCN.RunProc("update Gy_MouldFileMain set HMouldUseStatus='" + HStaus + "',HCloseDate='" + oItem.HUpdateDate + "' WHERE HInterID =" + HMouldID);
                                    }
                                }
                                oItem.HMouldID = long.Parse(HMouldID);
                                oItem.HRemark = HDate_Temp;
                                //LogService.Write("测试3:" + HMouldID);

                                //查询保养计划
                                ds = oCN.RunProcReturn(@"select  a.HInterID,a.HBillNo from  Sc_MouldMaintainPlanBillMain a
                                    inner join Sc_MouldMaintainPlanBillSub b on a.HInterID = b.HInterID
                                    where a.HMouldID =" + oItem.HMouldID+ " order by a.HMakeDate desc", "Sc_MouldMaintainPlanBillMain");
                                //LogService.Write("测试4:");
                                oItem.HPlanInterID = "";
                                if (ds.Tables[0].Rows.Count > 0)
                                {
                                    oItem.HPlanInterID = ds.Tables[0].Rows[0]["HInterID"].ToString();
                                    oItem.HPlanNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();
                                }
                            }
                            LogService.Write("模具编码:" + oItem.HMouldID);

                            //开单日期
                            if (keys.Contains("dateField_lq0v65sv"))
@@ -2306,6 +2419,7 @@
                                double HDate_Temp = double.Parse(response.Body.Result[i].FormData["dateField_lq0v65sv"].ToString());
                                oItem.HDate = convertFromMillisecondsToDateString(HDate_Temp, "yyyy-MM-dd HH:mm");
                            }
                            LogService.Write("开单日期:" + oItem.HDate);

                            //模具保养级别
                            if (keys.Contains("selectField_m1ip9j31"))
@@ -2330,6 +2444,7 @@
                              
                                oItem.HMaintainLevID = HDate_Temp;
                            }
                            LogService.Write("模具保养级别:" + oItem.HMaintainLevID);

                            //修模开始时间
                            if (keys.Contains("dateField_lq4gf2ih"))
@@ -2337,6 +2452,7 @@
                                double HDate_Temp = double.Parse(response.Body.Result[i].FormData["dateField_lq4gf2ih"].ToString());
                                oItem.HRepairBeginDate = DateTime.Parse(convertFromMillisecondsToDateString(HDate_Temp, "yyyy-MM-dd HH:mm"));
                            }
                            LogService.Write("修模开始时间:" + oItem.HRepairBeginDate);

                            //修模结束时间
                            if (keys.Contains("dateField_lq4gf2ii"))
@@ -2344,6 +2460,7 @@
                                double HDate_Temp = double.Parse(response.Body.Result[i].FormData["dateField_lq4gf2ii"].ToString());
                                oItem.HRepairEndDate = DateTime.Parse(convertFromMillisecondsToDateString(HDate_Temp, "yyyy-MM-dd HH:mm"));
                            }
                            LogService.Write("修模结束时间:" + oItem.HRepairEndDate);

                            //模具单据号
                            if (keys.Contains("serialNumberField_lqaak4ts"))
@@ -2351,6 +2468,7 @@
                                string HDate_Temp = response.Body.Result[i].FormData["serialNumberField_lqaak4ts"].ToString();
                                oItem.HBillNo = HDate_Temp;
                            }
                            LogService.Write("模具单据号:" + oItem.HBillNo);

                            //要求完成日期
                            if (keys.Contains("dateField_lq3idkvd"))
@@ -2358,6 +2476,7 @@
                                double HDate_Temp = double.Parse(response.Body.Result[i].FormData["dateField_lq3idkvd"].ToString());
                                oItem.HRequestComDate = DateTime.Parse(convertFromMillisecondsToDateString(HDate_Temp, "yyyy-MM-dd HH:mm:ss"));
                            }
                            LogService.Write("要求完成日期:" + oItem.HRequestComDate);

                            //维修受理日期
                            if (keys.Contains("dateField_lq4gf2ih"))
@@ -2365,6 +2484,7 @@
                                double HDate_Temp = double.Parse(response.Body.Result[i].FormData["dateField_lq4gf2ih"].ToString());
                                oItem.HRepairAccepDate = DateTime.Parse(convertFromMillisecondsToDateString(HDate_Temp, "yyyy-MM-dd HH:mm:ss"));
                            }
                            LogService.Write("维修受理日期:" + oItem.HRepairAccepDate);

                            //最近保养模数
                            if (keys.Contains("numberField_lq3idkvi"))
@@ -2372,6 +2492,7 @@
                                string HDate_Temp = response.Body.Result[i].FormData["numberField_lq3idkvi"].ToString();
                                oItem.HRecentMainModule = double.Parse(HDate_Temp);
                            }
                            LogService.Write("最近保养模数:" + oItem.HRecentMainModule);

                            //累计模数
                            if (keys.Contains("numberField_lq3idkvj"))
@@ -2379,6 +2500,7 @@
                                string HDate_Temp = response.Body.Result[i].FormData["numberField_lq3idkvj"].ToString();
                                oItem.HCumulativeModule = double.Parse(HDate_Temp);
                            }
                            LogService.Write("累计模数:" + oItem.HCumulativeModule);

                            //本次生产模数
                            if (keys.Contains("textField_lq4vdvgh"))
@@ -2386,32 +2508,7 @@
                                string HDate_Temp = response.Body.Result[i].FormData["textField_lq4vdvgh"].ToString();
                                oItem.HProductionModule = double.Parse(HDate_Temp);
                            }
                            
                            //模具编码
                            if (keys.Contains("selectField_lq3idkvg"))
                            {
                                string HDate_Temp = response.Body.Result[i].FormData["selectField_lq3idkvg"].ToString();
                                DataSet ds = oCN.RunProcReturn("select * from Gy_MouldFileMain with(nolock)  where HMouldNo='" + HDate_Temp + "'", "Gy_MouldFileMain");
                                string HMouldID = "0";
                                if (ds.Tables[0].Rows.Count > 0)
                                {
                                    HMouldID = ds.Tables[0].Rows[0]["HInterID"].ToString();
                                }
                                oItem.HMouldID = long.Parse(HMouldID);
                                oItem.HRemark = HDate_Temp;


                                //查询保养计划
                                ds = oCN.RunProcReturn(@"select  a.HInterID,a.HBillNo from  Sc_MouldMaintainPlanBillMain a
                                    inner join Sc_MouldMaintainPlanBillSub b on a.HInterID = b.HInterID
                                    where a.HMouldID =" + oItem.HMouldID + " and a.HMaintainLevID = " + oItem.HMaintainLevID, "Sc_MouldMaintainPlanBillMain");
                                oItem.HPlanInterID = "";
                                if (ds.Tables[0].Rows.Count > 0) {
                                    oItem.HPlanInterID = ds.Tables[0].Rows[0]["HInterID"].ToString();
                                    oItem.HPlanNo = ds.Tables[0].Rows[0]["HInterID"].ToString();
                                }
                            }

                            LogService.Write("累计模数:" + oItem.HProductionModule);

                            //维修部门
                            if (keys.Contains("selectField_lq3idkva"))
@@ -2425,6 +2522,7 @@
                                }
                                oItem.HDeptID = long.Parse(HDeptID);
                            }
                            LogService.Write("维修部门:" + oItem.HDeptID);

                            //新设计寿命
                            oItem.HNewDesignLife = 30000;
@@ -2441,6 +2539,7 @@
                                }
                                oItem.HEmpID = long.Parse(HEmpID);
                            }
                            LogService.Write("维修人:" + oItem.HEmpID);

                            //维修时间
                            if (keys.Contains("numberField_lq3ixr9j"))
@@ -2450,6 +2549,7 @@
                                oItem.HTimes = long.Parse(HDate_Temp);
                                oItem.HPlanTimes = long.Parse(HDate_Temp);
                            }
                            LogService.Write("维修时间:" + oItem.HTimes);

                            //子表 ç»´ä¿®è¦æ±‚ ç»´ä¿®å¤‡æ³¨(问题描述)
                            if (keys.Contains("tableField_lq3ixr9b"))
@@ -2466,15 +2566,19 @@
                                    {
                                        oItemSub.HRepairExplanation = dic[ij]["textareaField_lq3ixr9e"].ToString();
                                    }
                                    LogService.Write("维修要求:" + oItemSub.HRepairExplanation);

                                    //备注
                                    if (keys_Sub.Contains("textField_lq3ixr9d"))
                                    {
                                        oItemSub.HRemark = dic[ij]["textField_lq3ixr9d"].ToString();
                                    }
                                    LogService.Write("备注:" + oItemSub.HRemark);

                                    oItem.DetailColMouldRepair.Add(oItemSub);
                                }
                            }
                           

                            string HRemark = "";
                            //子表 ä¿å…»å¤‡æ³¨(问题描述)
@@ -2496,9 +2600,10 @@
                                    oItemSub.HClaim = HDate_Temp[ij];
                                    oItemSub.HMaintainResult = HRemark;
                                    oItem.DetailColMouldMaintain.Add(oItemSub);
                                    LogService.Write("具体要求:" + oItemSub.HClaim);
                                }

                            }
                           

                            int startindex = response.Body.Result[i].Title.IndexOf("zh_CN") + 8;
                            oItem.HTitle = startIndex + response.Body.Result[i].Title.Substring(startindex).Replace("\"}", "").Replace("'", "");
@@ -2533,6 +2638,7 @@
                        }
                        catch (Exception e)
                        {
                            LogService.Write("报错:" + e.Message);
                            continue;
                        }
                    }
@@ -2568,7 +2674,7 @@
            string formUuid = "FORM-30C78F46E77E46A9AA8778214CEFE6B5J0AN";
            int pageNumber = 1;
            int pageSize = 100;

            LogService.Write("查看7");
            //获取模具维修保养表的实例ID列表
            List<string> IDList = new List<string>();
            if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false)
@@ -2780,8 +2886,45 @@
                                continue;
                            }

                            string HStaus = "";

                            switch (getInstanceByIdResponse.Body.InstanceStatus)
                            {
                                case "COMPLETED":
                                    HStaus = "维修结束";
                                    break;
                                case "RUNNING":
                                    HStaus = "维修进行中";
                                    break;
                                case "TERMINATED":
                                    HStaus = "维修终止";
                                    break;
                            }
                            LogService.Write("状态:" + HStaus);
                            if (getInstanceByIdResponse.Body.InstanceStatus != "COMPLETED")
                            {
                                //设备编码
                                if (keys.Contains("textField_lfg9hgys"))
                                {
                                    string HDate_Temp = response.Body.Result[i].FormData["textField_lfg9hgys"].ToString();
                                    DataSet ds = oCN.RunProcReturn("select * from Gy_EquipFileBillMain with(nolock)  where HEquipFileNo='" + HDate_Temp + "'", "Gy_EquipFileBillMain");
                                    string HEquipID = "0";
                                    if (ds.Tables[0].Rows.Count > 0)
                                    {
                                        HEquipID = ds.Tables[0].Rows[0]["HInterID"].ToString();
                                        oItem.HEquipID = long.Parse(HEquipID);
                                        oItem.HRemark2 = HDate_Temp;

                                        string HUpdateDate = ds.Tables[0].Rows[0]["HCloseDate"].ToString()==""?"1900-01-01 00:00:00": ds.Tables[0].Rows[0]["HCloseDate"].ToString();
                                        string HMouldStaus = ds.Tables[0].Rows[0]["HStatus"].ToString();
                                        LogService.Write("设备:" + HDate_Temp + ",状态:" + HMouldStaus + ",时间:" + HUpdateDate);
                                        if (HMouldStaus != HStaus && DateTime.Parse(HUpdateDate) <= DateTime.Parse(oItem.HUpdateDate))
                                        {
                                            //修改设备的状态和时间
                                            oCN.RunProc("update Gy_EquipFileBillMain set HStatus='" + HStaus + "',HCloseDate='" + oItem.HUpdateDate + "' WHERE HInterID =" + HEquipID);
                                        }
                                    }
                                }
                                continue;
                            }

@@ -2794,18 +2937,28 @@
                            {
                                string HDate_Temp = response.Body.Result[i].FormData["textField_lfg9hgys"].ToString();
                                DataSet ds = oCN.RunProcReturn("select * from Gy_EquipFileBillMain with(nolock)  where HEquipFileNo='" + HDate_Temp + "'", "Gy_EquipFileBillMain");
                                LogService.Write("设备无:" + HDate_Temp);
                                string HEquipID = "0";
                                if (ds.Tables[0].Rows.Count > 0)
                                {
                                    HEquipID = ds.Tables[0].Rows[0]["HInterID"].ToString();
                                    oItem.HEquipID = long.Parse(HEquipID);
                                    oItem.HRemark2 = HDate_Temp;
                                    string HUpdateDate = ds.Tables[0].Rows[0]["HCloseDate"].ToString() == "" ? "1900-01-01 00:00:00" : ds.Tables[0].Rows[0]["HCloseDate"].ToString();
                                    string HMouldStaus = ds.Tables[0].Rows[0]["HStatus"].ToString();
                                    LogService.Write("设备:" + HDate_Temp + ",状态:" + HMouldStaus + ",时间:" + HUpdateDate);
                                    if (HMouldStaus != HStaus && DateTime.Parse(HUpdateDate) <= DateTime.Parse(oItem.HUpdateDate))
                                    {
                                        //修改设备的状态和时间
                                        oCN.RunProc("update Gy_EquipFileBillMain set HStatus='" + HStaus + "',HCloseDate='" + oItem.HUpdateDate + "' WHERE HInterID =" + HEquipID);
                                    }
                                }
                                else
                                {
                                    continue;
                                }
                            }
                            LogService.Write("设备:" + oItem.HEquipID);

                            //维修部门
                            if (keys.Contains("selectField_kzgkw10a"))
@@ -2824,6 +2977,7 @@
                                }

                            }
                            LogService.Write("维修部门:" + oItem.HDeptID);

                            //维修人
                            if (keys.Contains("employeeField_lthwkdh2"))
@@ -2842,6 +2996,7 @@
                                }

                            }
                            LogService.Write("维修人:" + oItem.HEmpID);

                            //维修内容
                            if (keys.Contains("textField_l2r9bvwk"))
@@ -2850,6 +3005,7 @@

                                oItem.HRepairContent = HDate_Temp;
                            }
                            LogService.Write("维修内容:" + oItem.HRepairContent);

                            //报修类别
                            if (keys.Contains("multiSelectField_lfg9hgyv"))
@@ -2858,7 +3014,7 @@

                                oItem.HRepairCategory = HDate_Temp[0];
                            }

                            LogService.Write("报修类别:" + oItem.HRepairCategory);
                            //紧急程度
                            if (keys.Contains("radioField_kzgkw10c"))
                            {
@@ -2866,6 +3022,7 @@

                                oItem.HUrgenLevel = HDate_Temp;
                            }
                            LogService.Write("紧急程度:" + oItem.HUrgenLevel);

                            //报修人
                            if (keys.Contains("employeeField_lkasesrk"))
@@ -2874,6 +3031,7 @@

                                oItem.HRepairer = HDate_Temp[0];
                            }
                            LogService.Write("报修人:" + oItem.HRepairer);

                            //是否有产能影响
                            if (keys.Contains("textField_lyjddw0r"))
@@ -2882,7 +3040,8 @@

                                oItem.HIsCapacityImpact = HDate_Temp;
                            }
                         
                            LogService.Write("是否有产能影响:" + oItem.HIsCapacityImpact);

                            //维修时间
                            if (keys.Contains("textField_l2r95oo2"))
                            {
@@ -2898,6 +3057,8 @@
                                oItem.HTimes = int.Parse(new string(HDate_Temp.Where(char.IsDigit).ToArray()));
                                oItem.HPlanTimes = int.Parse(new string(HDate_Temp.Where(char.IsDigit).ToArray()));
                            }
                            LogService.Write("维修时间:" + oItem.HTimes);


                            //子表 ç»´ä¿®è¦æ±‚ ç»´ä¿®å¤‡æ³¨(问题描述)

@@ -2910,6 +3071,7 @@
                                oItem.HExplanation = HDate_Temp;
                                sub.HRepairExplanation = HDate_Temp;
                            }
                            LogService.Write("维修要求:" + oItem.HExplanation);

                            //备注
                            if (keys.Contains("textField_l2r95oo0"))
@@ -2918,6 +3080,8 @@

                                sub.HRemark = HDate_Temp;
                            }
                            LogService.Write("备注:" + oItem.HRemark);

                            oItem.DetailColMouldRepair.Add(sub);

                            int startindex = response.Body.Result[i].Title.IndexOf("zh_CN") + 8;
@@ -2953,7 +3117,7 @@
                        }
                        catch (Exception e)
                        {
                            LogService.Write(e.Message);
                            LogService.Write("报错:" + e.Message);
                            a = "";
                            continue;
                        }
@@ -2989,7 +3153,7 @@
            string formUuid = "FORM-OM566O7177LW0ARJ5IMFF63NTFKA34G9RL2YKN1";
            int pageNumber = 1;
            int pageSize = 100;

            LogService.Write("查看6");
            //获取设备维修保养表的实例ID列表
            List<string> IDList = new List<string>();
            if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false)
@@ -3445,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;