lanyun/HH.YiDaSyncNC/DataSync/KP_Dev_SyncService.cs

using HH.YiDaSyncNC.Dtos;
using HH.YiDaSyncNC.Dtos.NC;
using HH.YiDaSyncNC.Helper;
using HH.YiDaSyncNC.Models;
using Newtonsoft.Json;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Xml.Linq;

namespace HH.YiDaSyncNC.DataSync
{
    class KP_Dev_SyncService
    {
        public string _AppType;
        public string _SystemToken;
        public string _UserId;
        public string _FormId;
        public SqlSugarClient _db;
        public SqlSugarClient _db_nc;
        public string _NCApiUrl;

        public static string _Static_PK_so_saleorder = ConfigurationManager.AppSettings["so_saleorder"];
        public static string _Static_PK_so_saleorder_b = ConfigurationManager.AppSettings["so_saleorder_b"];
        public static string _Static_pk_org_jt = ConfigurationManager.AppSettings["pk_org_jt"];

        public KP_Dev_SyncService(string AppType, string SystemToken, string UserId, string FormId, SqlSugarClient db, SqlSugarClient db_nc, string NCApiUrl)
        {
            _AppType = AppType;
            _SystemToken = SystemToken;
            _UserId = UserId;
            _FormId = FormId;
            _db = db;
            _db_nc = db_nc;
            _NCApiUrl = NCApiUrl;
        }

        public class IdCodeModel
        {
            public int sourceId { get; set; }
            public string Id { get; set; }
        }

        public class FormItem
        {
            public string title { get; set; }
        }

        public class AA
        {
            public string id { get; set; }
            public string ncCode { get; set; }
        }

        public void DataSync()
        {
            DingTalkService _dingTalkService = new DingTalkService(_AppType, _SystemToken, _UserId, _FormId);

            // 宜搭全量数据Id
            //var idList = _dingTalkService.GetFormIdList("{\"radioField_lycrvvtk\":\"Y\",\"selectField_lvituew9\":\"正常\"}");
            //var idList = _dingTalkService.GetFormIdList("{\"textField_lvdosccc\":\"KP_2024071700252\"}");

            //var idList = _dingTalkService.GetFormIdList("{\"radioField_lycrvvtk\":\"Y\"}");

            var idList = new List<AA>();

            //idList.Add(new AA() { id = "FINST-3MA66T81W0F29R38JF5DW6NBRMVD245E2HKKM3IA" });
            idList.Add(new AA() { id = "FINST-APD66U61PMB2Z5JOLG6KLDAAUYJV23OEUJGKM5I8" });
            idList.Add(new AA() { id = "FINST-JSC66VB1ALA2ILPKITTO5D5U2HW83X3LB7GKM39A" });
            idList.Add(new AA() { id = "FINST-E7B66LC1BMD28597LT8G7CC5UJVX2I4GR6GKMCE1" });
            idList.Add(new AA() { id = "FINST-DZ966471IMD2T1OCMJJ24CUB462F2AJCG6GKMX9" });
            idList.Add(new AA() { id = "FINST-C7D661B1FMD2B374IHA1U8Z0LWZR2YU0E6GKMWB" });
            idList.Add(new AA() { id = "FINST-2MA66S71B9B267JUJL5YKBO599I62NUGB6GKM4U4" });
            idList.Add(new AA() { id = "FINST-Z2D66AC1C9B2Q12UH1026AC9Z2AH3F88R6FKM8D2" });
            idList.Add(new AA() { id = "FINST-3MA66281P9B2OQIKO7PLIDZPLE7R3J3PO6FKME2F" });
            idList.Add(new AA() { id = "FINST-DEA66BB1KAD2TYYFL2OZX9V05G9I3VK4F6FKM3H" });
            idList.Add(new AA() { id = "FINST-6UD66VA1OAD2IULRNWSKD61VZNZM24JJ36FKMMO" });
            idList.Add(new AA() { id = "FINST-OC666271F562DZ43OBB4J72XE3M2348GC5FKM07B" });
            idList.Add(new AA() { id = "FINST-MYA66EC1D2B2TGX6N3M9WB96H3KB3LLQE4FKMMGB" });
            idList.Add(new AA() { id = "FINST-7PD666B1PMB2XUZIOWI24DQC5WZ32KMY14FKM2N2" });
            idList.Add(new AA() { id = "FINST-3MA66281Q9B2ZG49MR3MY5GWEVLA2ACCY3FKM6Z5" });
            idList.Add(new AA() { id = "FINST-3TE66TC1NJC21PWKICINL9RFB3WW2F99S3FKME33" });
            idList.Add(new AA() { id = "FINST-6UD66VA1D462J8ZLP7N7K55RRWAR38Z8NUEKM6BR" });
            idList.Add(new AA() { id = "FINST-NSC66W81R462KDICIXJMX9PUL1U83UR9HUEKMJP01" });
            idList.Add(new AA() { id = "FINST-43D66ND1A9B2A8URNBU3A6JN5W812PGSAUEKMJU6" });
            idList.Add(new AA() { id = "FINST-HRD66W91VLA20VG0J5BV1BB4IUZ53LIWVTEKMXXF" });
            idList.Add(new AA() { id = "FINST-Z2D66DD1I562EB9MOUYPT7USLERX2A0UTTEKM3TO" });
            idList.Add(new AA() { id = "FINST-I0A665C1TLB2877EOOOHF9YIQWGK2VWQRTEKM512" });
            idList.Add(new AA() { id = "FINST-WC666HB1F562STRMOZ9919K2GVPN3TCQPTEKMAE31" });
            idList.Add(new AA() { id = "FINST-CW866J71ELA2QS33LTBW38GID2822W3EKTEKMUB8" });
            idList.Add(new AA() { id = "FINST-WC666QC1F562IE63JP6I592V7OI03KVNSQEKMYKB" });
            idList.Add(new AA() { id = "FINST-O7G66671E462DRDVO9X2QD3KTTUO3J3YZSDKMLE5" });
            idList.Add(new AA() { id = "FINST-Z2D66PC1G562DIAKIH1D551ES9HH3HKQNSDKMMEI" });
            idList.Add(new AA() { id = "FINST-1PD66L91D4623HK5PXTIB6MXSZYY2SPKNQDKMO26" });
            idList.Add(new AA() { id = "FINST-Z2D66MC1G562920QIDF044YA0LF320CS5PDKMWGM" });
            idList.Add(new AA() { id = "FINST-IRD66PB1746255WGGHHIK45STD2C2EWOPFDKMIHM" });
            idList.Add(new AA() { id = "FINST-K0H66571F562O0PJLHB3DD5J5KRO3H6QLFDKMROP" });
            idList.Add(new AA() { id = "FINST-3DC66Z81F2B2BHS8HTVSY8X2G62T3CNJ4FDKMN94" });
            idList.Add(new AA() { id = "FINST-C8766P91B9B2TEAXH1YKF9L4YWOW3EI2AEDKMLK7" });
            idList.Add(new AA() { id = "FINST-53D66981Q562PJIUKB5GVA5BJ4BG31FNXDDKMAEK" });
            idList.Add(new AA() { id = "FINST-B7D66CC10462Z7F8NE6DK6L1SWBX3RBDW8CKMVQD" });
            idList.Add(new AA() { id = "FINST-XJG66ZB1FKA2WEBAHAH5V5DOTRYW2ZSEQ5CKMTX" });
            idList.Add(new AA() { id = "FINST-MIA66FB1J462PAYCO3PAJ6IB920624RRA5CKMXAE" });
            idList.Add(new AA() { id = "FINST-SBD66771JLA2PHBSMCNF3A155I2Z2V2445CKMMV1" });
            idList.Add(new AA() { id = "FINST-NSC66W81U462YJ9NG1G0R4KTE3SZ1BBOZ4CKMFCF" });
            idList.Add(new AA() { id = "FINST-B7D66CC1Z362I3NLK5WVO9J3OZLX24JXS4CKMFSB" });
            idList.Add(new AA() { id = "FINST-8WF665A1L4625UTRP9XRUDI4UQIG2TC1Q4CKM405" });
            idList.Add(new AA() { id = "FINST-Z2D66MC1G562920QIDF044YA0LF32LP3J4CKMR2K" });
            idList.Add(new AA() { id = "FINST-1MA66LC1U362Q571JA9266ROIR0T3TK03XBKMF7D" });
            idList.Add(new AA() { id = "FINST-F1A66381U3628H9YLN26862B64Z83Z0R0XBKM4DB" });
            idList.Add(new AA() { id = "FINST-RPA66P81P462RWR2HPD2U7K7RA4B22Q9YWBKMVDH" });
            idList.Add(new AA() { id = "FINST-XWC66081V462HCJSGJ1ZQ5YH94Z32BCSUWBKMXG4" });
            idList.Add(new AA() { id = "FINST-ARB66Y91J462ONVFOZU8T4KSZDHA2LBVLWBKM0BE" });
            idList.Add(new AA() { id = "FINST-L3D66981F562101CGU7TA8EP14O53M85IWBKMEHD" });
            idList.Add(new AA() { id = "FINST-IRD66PB1646238I8OT71C94ALHUR3H5JEWBKM3IA" });
            idList.Add(new AA() { id = "FINST-AT566YC1L462ZALPJEF219PGLRDK3SCB7WBKMDQ5" });
            idList.Add(new AA() { id = "FINST-C7D66WA1S462Q164GPBSI6JT8RGE3NJ52WBKMFCG" });
            idList.Add(new AA() { id = "FINST-JSC66VB1BLA2C8Q6GX5Y18PYUVBU2S1EXVBKMM3" });
            idList.Add(new AA() { id = "FINST-MY966W91X362INC6HQES36XZA5213QAN5KAKMKT4" });
            idList.Add(new AA() { id = "FINST-LN666OC1G562RTQBH2WIC8HBRHFD2F220KAKM1WI" });
            idList.Add(new AA() { id = "FINST-K0H66DD1F562PXJNMSUFV4C4G5WF3TN4XJAKMNAE" });
            idList.Add(new AA() { id = "FINST-WC666QC1H562H76FIC4HY3XMDX9T2KOYJJAKMR9A" });
            idList.Add(new AA() { id = "FINST-S8E66381P462W3T2PIOYY4OPZCF72QT7IJAKMAIA" });
            idList.Add(new AA() { id = "FINST-DEA66BB1O462DI9OGNEOF5EJIMH03A6EEJAKMFO6" });
            idList.Add(new AA() { id = "FINST-DEA66BB1L4625HT5IEGY944Q7UFE3N4S6JAKMB9E" });
            idList.Add(new AA() { id = "FINST-K7D66PB1Z362H18WNCFNB5CMUE123SH80JAKM5MD" });
            idList.Add(new AA() { id = "FINST-6IG66EA1Z36215OHKQA066AFFAM63Y8VXIAKMU04" });
            idList.Add(new AA() { id = "FINST-IRD66GC154623EJVGLI908SZOK9J260XSIAKMFT8" });
            idList.Add(new AA() { id = "FINST-VX9662B1R362EIY7PDEHQDGVW3NV351SMIAKMYI4" });
            idList.Add(new AA() { id = "FINST-I0A665C1W3624FYQME4LEDE2R45533J9JIAKMZ53" });
            idList.Add(new AA() { id = "FINST-VX966K916462OBINOS8RE5SX0FIM364GEIAKMZC3" });
            idList.Add(new AA() { id = "FINST-K7D66PB10462MUASHLZJWC887YAH3KD9AIAKMY98" });
            idList.Add(new AA() { id = "FINST-1MA66LC1U362Q571JA9266ROIR0T3TC85IAKMQQ8" });
            idList.Add(new AA() { id = "FINST-L3D66981H562676MHLSG488FALRX2JM00IAKM1D9" });
            idList.Add(new AA() { id = "FINST-HZ966JB13562QI5VMCSSPA81LSFV3U3YUHAKMDUB" });
            idList.Add(new AA() { id = "FINST-Z2D664D1W46247OQNRM537I5O1DK3QMP0HAKM1Q9" });
            idList.Add(new AA() { id = "FINST-69G66AB1Z362WY2SLA5ZHB4S5NOK3MD3BK6KMSY9" });
            idList.Add(new AA() { id = "FINST-Z2D66DD1I562EB9MOUYPT7USLERX2P4V6K6KMXO6" });
            idList.Add(new AA() { id = "FINST-B7D66CC1Z362I3NLK5WVO9J3OZLX2S1UYJ6KMT52" });
            idList.Add(new AA() { id = "FINST-WC666CD1G462JPBOKK9DND86MBOO3IAXMJ6KMQ93" });
            idList.Add(new AA() { id = "FINST-J4E66XC1G5625HMGOT9ELAUNOASE2CFELJ6KMNYD" });
            idList.Add(new AA() { id = "FINST-F3D66D91U462L7ZPOD2M595T2V7B3YS0IJ6KMFF2" });
            idList.Add(new AA() { id = "FINST-E7B66LC1Q462LYZGMJEQ97ITC4P2304IDJ6KM861" });
            idList.Add(new AA() { id = "FINST-39D66KB1Q462UBN2PJ5OW6SULCSP2P4B3J6KMOC1" });
            idList.Add(new AA() { id = "FINST-QUA66M818462XP8SNILKX6B6NGJ524AKA76KM0G1" });
            idList.Add(new AA() { id = "FINST-CN96618104621P0THAX4176ZTXJ72H7EI15KM59" });
            idList.Add(new AA() { id = "FINST-KN666SC1W4623EACIG7EUB5992JV3VU2QZ4KMSB" });
            idList.Add(new AA() { id = "FINST-2MA66S710462JSKIGNCEND69LZM627S2LZ4KM79" });
            idList.Add(new AA() { id = "FINST-F1A66381U362SW4ILTRGN7OUAAX13MAZHZ4KM5G" });
            idList.Add(new AA() { id = "FINST-39D66KB1I462EQZEGTBWJCODASKU3IJ6EZ4KMS9" });
            idList.Add(new AA() { id = "FINST-HZ966M81W462WBS7NHZWNAF6JVHL2SQN6Z4KM92" });
            idList.Add(new AA() { id = "FINST-GRD66LC1K462QPC1OWO4UDDXCNGO3UD53Z4KM99" });
            idList.Add(new AA() { id = "FINST-F9D667D1Z36214PIJQFZV7TM35OI2MNE0Z4KMV71" });
            idList.Add(new AA() { id = "FINST-HRG667D16362VADBIZOCC73S4UOT2FKHXY4KM8W" });
            idList.Add(new AA() { id = "FINST-B7D66CC1Z3626BYUKYLB54S6MJFZ2574VY4KMD4" });
            idList.Add(new AA() { id = "FINST-4HD66571M3620JOGPUHAZ34L8ENF3R2IWW4KMH8" });
            idList.Add(new AA() { id = "FINST-SPA66HA1J4627S17HPGQD7J9ACY53MEGVW4KMR2" });
            idList.Add(new AA() { id = "FINST-F8G66HC1Z462XALAMMEZT6B1BBXP3VJGRW4KMK4" });
            idList.Add(new AA() { id = "FINST-WC6668B1V4621N0CNYNJB67FI2TQ3WUPKW4KMU4" });
            idList.Add(new AA() { id = "FINST-SBD66771436275T4G4I5V4U8SUY62JHBIW4KMM1" });
            idList.Add(new AA() { id = "FINST-1PD66M91O362ARZOGLI3S5RXXFJV2ZIYEW4KMH2" });
            idList.Add(new AA() { id = "FINST-R8E66381W462GWWJM7ZIVBOP4BR6379W5W4KM84" });
            idList.Add(new AA() { id = "FINST-K7D66PB1Z362H18WNCFNB5CMUE123M1PXV4KMJ8" });
            idList.Add(new AA() { id = "FINST-B7D66JC1Q462IZ20J4E7I5OUOJ602B1PZU4KM1" });
            idList.Add(new AA() { id = "FINST-GRD66LC1E4628POEPEUJ55K6JUJP24D6UU4KMJ" });
            idList.Add(new AA() { id = "FINST-RZ966AA1CCW1KQUDNAID343CZ6D53268DC3KMO8M" });
            idList.Add(new AA() { id = "FINST-Z2D66QC1FCW188AYILOPYC8I9L0F3FARRA2KMU0X" });
            idList.Add(new AA() { id = "FINST-F9D667D19PX1AUR7L3HKM4UFIELD2IJKOA2KMMYF" });
            idList.Add(new AA() { id = "FINST-1PD66L911CW13EU5OHOPQAUFFS6J293NJA2KMVAE" });
            idList.Add(new AA() { id = "FINST-VX966K913CW105SLLIBIF70EJP953CNGDA2KM2ZM" });
            idList.Add(new AA() { id = "FINST-TWG66U91LD32RIHZNNMJ5DK0ENJX2OKQ9A2KMJU5" });
            idList.Add(new AA() { id = "FINST-1MA66LC1XAW1G052NADNB696OL4B3Q127A2KMWVL" });
            idList.Add(new AA() { id = "FINST-VPA66TA11CW1RZAMOBIGF6DE1KDT2YLI6A2KM77Y" });
            idList.Add(new AA() { id = "FINST-RZ966AA1KCW1H7RRLEW5T5I5ZH073VDX4A2KMG7C" });
            idList.Add(new AA() { id = "FINST-WC666CD12CW1JOMGHB5VIDT5VL572ELV3A2KMG6R" });
            idList.Add(new AA() { id = "FINST-DZ9664719CW1E5XQJG8FH85G1B5H355W2A2KMG1W" });
            idList.Add(new AA() { id = "FINST-2MA66M81ZAW1ZLP9HDYW06DXB9WW2M4N1A2KMEBQ" });
            idList.Add(new AA() { id = "FINST-B7D66CC1UAW1HSLVI1PKD6OLMWK63WTG0A2KMJ7X" });
            idList.Add(new AA() { id = "FINST-Z2D66PC1CCW1Q7AXJIJ2Z9VP0AQ8378AW92KMZEW" });
            idList.Add(new AA() { id = "FINST-3MA66T812CW1E02VKCXF5D0QXOKH34V6V92KMD4U" });
            idList.Add(new AA() { id = "FINST-3MA66T812CW1E02VKCXF5D0QXOKH34V6V92KMD4U" });
            idList.Add(new AA() { id = "FINST-3MA66T812CW1E02VKCXF5D0QXOKH34V6V92KMD4U" });
            idList.Add(new AA() { id = "FINST-D7B66KA19CW1PP8ZG9QMCBH15ZTJ2DJRT92KMN4E" });
            idList.Add(new AA() { id = "FINST-D7B66KA19CW1PP8ZG9QMCBH15ZTJ2DJRT92KMN4E" });
            idList.Add(new AA() { id = "FINST-D7B66KA19CW1PP8ZG9QMCBH15ZTJ2DJRT92KMN4E" });
            idList.Add(new AA() { id = "FINST-MYA66EC1WAW1BCDFM3LQ7DMS7KTK21GBGV1KM1NK" });
            idList.Add(new AA() { id = "FINST-AT566YC1FCW1P2JOM4FM2A3T1CNQ2QJITV0KMG58" });
            idList.Add(new AA() { id = "FINST-AK966K91LCX1UB2IKLH7KCXSCH712NGMFJ0KMEPJ" });
            idList.Add(new AA() { id = "FINST-1MA66LC1YAW1JZ9OMTBAL4KK01CV3YOJ0I0KMKZJ" });
            idList.Add(new AA() { id = "FINST-WC666CD12CW1JOMGHB5VIDT5VL5729VJZFZJMHVI" });
            idList.Add(new AA() { id = "FINST-6IG66EA12CW1RG9ZMPHP65MU95RT2PV9XFZJMUKC" });
            idList.Add(new AA() { id = "FINST-C7D661B1ACW10KV4NSISUCAKWHNU2FXXKFZJMRJD" });
            idList.Add(new AA() { id = "FINST-C7D661B1ACW10KV4NSISUCAKWHNU2FXXKFZJMRJD" });
            idList.Add(new AA() { id = "FINST-C7D661B1ACW10KV4NSISUCAKWHNU2FXXKFZJMRJD" });
            idList.Add(new AA() { id = "FINST-GRD66LC12CW1S9FYIGY7C6ZJNX3W2EM3HFZJMQXO" });
            idList.Add(new AA() { id = "FINST-1MA663C1XAW13EMFM0EHOA4NOE043EAKDFZJM5OG" });
            idList.Add(new AA() { id = "FINST-KPA66V911CW1LZOSMI3MRB0261JV25T5BFZJMIQF" });
            idList.Add(new AA() { id = "FINST-1MA66LC1XAW15TZEHS50U57FDUE03TKV8FZJMMAN" });
            idList.Add(new AA() { id = "FINST-Y2D66JB1HDW14GJ0PQWV287MLUFJ32VNYEZJM2W4" });
            idList.Add(new AA() { id = "FINST-RPA66P811DW1XX9BKSE98B4LPH3Y2WIOVEZJMCSI" });
            idList.Add(new AA() { id = "FINST-1MA663C1VAW1HMSDHE9OT9KYNPE93Y2PSEZJMF2J" });
            idList.Add(new AA() { id = "FINST-K7D66PB1XAW1X41PNVBESDNNCE413QHFNEZJMETE" });
            idList.Add(new AA() { id = "FINST-QNB668C10BW1V5WNONJ8CB92MH662NHOKEZJM1WG" });
            idList.Add(new AA() { id = "FINST-VX966K91VCW1L0ZXKYME6CLNZ0QF3AAAGEZJMHT5" });
            idList.Add(new AA() { id = "FINST-RZ966AA1ACW1U7NJGKXQ57X61SKE36PDAEZJMEW7" });
            idList.Add(new AA() { id = "FINST-B7D66JC17CW17IZLL42MOD31GXE92BYP7EZJMMPO" });
            idList.Add(new AA() { id = "FINST-GRD667C13CW19DAIO6SGAAN11BWT2FOE5EZJMTSA" });
            idList.Add(new AA() { id = "FINST-GRD667C13CW19DAIO6SGAAN11BWT2FOE5EZJMTSA" });
            idList.Add(new AA() { id = "FINST-GRD667C13CW19DAIO6SGAAN11BWT2FOE5EZJMTSA" });
            idList.Add(new AA() { id = "FINST-RPA66P811DW1XX9BKSE98B4LPH3Y2E5JYDZJM32H" });
            idList.Add(new AA() { id = "FINST-MYA66EC1YAW13IHFL5OJ0AGUGPMN2BM1VDZJMIMD" });
            idList.Add(new AA() { id = "FINST-03D66KA18BW16FPPLFXET9SYQ6EO2CZPPDZJMO1I" });
            idList.Add(new AA() { id = "FINST-AK966K91RCX1W4O8MK60N603XALH2YSBBDZJMD89" });
            idList.Add(new AA() { id = "FINST-XWC660819CW192VCK57UW4DSARDA36S47DZJMJT5" });
            idList.Add(new AA() { id = "FINST-NO566GC1YAW11MNWHHA1ZBF75SLM3VZEZCZJMLN9" });
            idList.Add(new AA() { id = "FINST-APD66U613CW1434FGLUGR9HFQTGQ3C4JVCZJMHAF" });
            idList.Add(new AA() { id = "FINST-L3D66Z818CW1H1IELFOXI7V15DZ63MSMPCZJM6WI" });
            idList.Add(new AA() { id = "FINST-93D668C188Q1AOUOKXTRR7LLTLLX3OC4J0LJMY691" });
            idList.Add(new AA() { id = "FINST-K0H66DD1K8K128ECHDAPWBJFCOX93TSE41BJMR71" });
            idList.Add(new AA() { id = "FINST-K0H66DD1K8K128ECHDAPWBJFCOX93TSE41BJMR71" });
            idList.Add(new AA() { id = "FINST-K0H66DD1K8K128ECHDAPWBJFCOX93TSE41BJMR71" });
            idList.Add(new AA() { id = "FINST-OC666271Z8K1B3O5G1SW3BN1Q08U3U5OZ0BJMXM" });
            idList.Add(new AA() { id = "FINST-OC666271Z8K1B3O5G1SW3BN1Q08U3U5OZ0BJMXM" });
            idList.Add(new AA() { id = "FINST-OC666271Z8K1B3O5G1SW3BN1Q08U3U5OZ0BJMXM" });
            idList.Add(new AA() { id = "FINST-43D66ND142E10B2GM7OIQ6QH53TV30O1VZ7JMGIE" });
            idList.Add(new AA() { id = "FINST-K0H66DD192E1IDLJIBALT4HNX5162K4MYJ2JMYD2" });
            idList.Add(new AA() { id = "FINST-Z2D664D152E1VR4LLECX2CWP2CQW341DBB2JMA11" });
            idList.Add(new AA() { id = "FINST-2MA66S71OL51Q4ZDI9FUCA4L21V03M6FNJSIM5PC" });
            idList.Add(new AA() { id = "FINST-GRD66LC1PT51H3OJGZAJ19DZYASZ2C8E6JSIM5J4" });
            idList.Add(new AA() { id = "FINST-71F66S81UTX0HKFKKIJG693CEYNN2BW6HLMIMTYN" });
            idList.Add(new AA() { id = "FINST-CW966Y71FDF0U4EHMVFRCANWJXAR2NM8QSSHMJO9" });


            var idListNC = new List<string>();
            //idListNC.Add("1001G1100000000FEZWJ");
            idListNC.Add("1001G1100000000FEZ5I");
            idListNC.Add("1001G1100000000FEXM0");
            idListNC.Add("1001G1100000000FEXKI");
            idListNC.Add("1001G1100000000FEXKU");
            idListNC.Add("1001G1100000000FEXL6");
            idListNC.Add("1001G1100000000FEXLI");
            idListNC.Add("1001G1100000000FEWX8");
            idListNC.Add("1001G1100000000FEWW7");
            idListNC.Add("1001G1100000000FEWWJ");
            idListNC.Add("1001G1100000000FEWWV");
            idListNC.Add("1001G1100000000FEWVU");
            idListNC.Add("1001G1100000000FEWUH");
            idListNC.Add("1001G1100000000FEWUT");
            idListNC.Add("1001G1100000000FEWV5");
            idListNC.Add("1001G1100000000FEWVH");
            idListNC.Add("1001G1100000000FEU1V");
            idListNC.Add("1001G1100000000FEU27");
            idListNC.Add("1001G1100000000FEU2J");
            idListNC.Add("1001G1100000000FEU00");
            idListNC.Add("1001G1100000000FEU0C");
            idListNC.Add("1001G1100000000FEU0O");
            idListNC.Add("1001G1100000000FEU10");
            idListNC.Add("1001G1100000000FEU1C");
            idListNC.Add("1001G1100000000FETXG");
            idListNC.Add("1001G1100000000FETRB");
            idListNC.Add("1001G1100000000FETRN");
            idListNC.Add("1001G1100000000FETQQ");
            idListNC.Add("1001G1100000000FETPD");
            idListNC.Add("1001G1100000000FETCT");
            idListNC.Add("1001G1100000000FETD5");
            idListNC.Add("1001G1100000000FETDH");
            idListNC.Add("1001G1100000000FEQLK");
            idListNC.Add("1001G1100000000FEQLW");
            idListNC.Add("1001G1100000000FEOFH");
            idListNC.Add("1001G1100000000FEO75");
            idListNC.Add("1001G1100000000FEN1Y");
            idListNC.Add("1001G1100000000FEN2A");
            idListNC.Add("1001G1100000000FEN2M");
            idListNC.Add("1001G1100000000FEN2Y");
            idListNC.Add("1001G1100000000FEN3A");
            idListNC.Add("1001G1100000000FEN3M");
            idListNC.Add("1001G1100000000FEKRF");
            idListNC.Add("1001G1100000000FEKRR");
            idListNC.Add("1001G1100000000FEKS3");
            idListNC.Add("1001G1100000000FEKOX");
            idListNC.Add("1001G1100000000FEKP9");
            idListNC.Add("1001G1100000000FEKPL");
            idListNC.Add("1001G1100000000FEKPX");
            idListNC.Add("1001G1100000000FEKQ9");
            idListNC.Add("1001G1100000000FEKQL");
            idListNC.Add("1001G1100000000FEKQX");
            idListNC.Add("1001G1100000000FEKH0");
            idListNC.Add("1001G1100000000FEKHC");
            idListNC.Add("1001G1100000000FEKHO");
            idListNC.Add("1001G1100000000FEKDK");
            idListNC.Add("1001G1100000000FEKDW");
            idListNC.Add("1001G1100000000FEKE8");
            idListNC.Add("1001G1100000000FEKEK");
            idListNC.Add("1001G1100000000FEKEW");
            idListNC.Add("1001G1100000000FEKF8");
            idListNC.Add("1001G1100000000FEKFK");
            idListNC.Add("1001G1100000000FEKFW");
            idListNC.Add("1001G1100000000FEKG8");
            idListNC.Add("1001G1100000000FEKBM");
            idListNC.Add("1001G1100000000FEKBY");
            idListNC.Add("1001G1100000000FEKCA");
            idListNC.Add("1001G1100000000FEKCM");
            idListNC.Add("1001G1100000000FEKCY");
            idListNC.Add("1001G1100000000FEKB3");
            idListNC.Add("1001G1100000000FEJXY");
            idListNC.Add("1001G1100000000FEJYA");
            idListNC.Add("1001G1100000000FEJVG");
            idListNC.Add("1001G1100000000FEJVS");
            idListNC.Add("1001G1100000000FEJW4");
            idListNC.Add("1001G1100000000FEJWG");
            idListNC.Add("1001G1100000000FEJWS");
            idListNC.Add("1001G1100000000FEJX4");
            idListNC.Add("1001G1100000000FEJSD");
            idListNC.Add("1001G1100000000FEJKW");
            idListNC.Add("1001G1100000000FEJIB");
            idListNC.Add("1001G1100000000FEJIN");
            idListNC.Add("1001G1100000000FEJIZ");
            idListNC.Add("1001G1100000000FEJJB");
            idListNC.Add("1001G1100000000FEJJN");
            idListNC.Add("1001G1100000000FEJGV");
            idListNC.Add("1001G1100000000FEJH7");
            idListNC.Add("1001G1100000000FEJHJ");
            idListNC.Add("1001G1100000000FEJHV");
            idListNC.Add("1001G1100000000FEJED");
            idListNC.Add("1001G1100000000FEJEP");
            idListNC.Add("1001G1100000000FEJF1");
            idListNC.Add("1001G1100000000FETRT");
            idListNC.Add("1001G1100000000FEJFP");
            idListNC.Add("1001G1100000000FEJG1");
            idListNC.Add("1001G1100000000FEJGD");
            idListNC.Add("1001G1100000000FEJCQ");
            idListNC.Add("1001G1100000000FEJD2");
            idListNC.Add("1001G1100000000FEJBR");
            idListNC.Add("1001G1100000000FEHZV");
            idListNC.Add("1001G1100000000FEHQW");
            idListNC.Add("1001G1100000000FEHJS");
            idListNC.Add("1001G1100000000FEHK4");
            idListNC.Add("1001G1100000000FEHKG");
            idListNC.Add("1001G1100000000FEHKS");
            idListNC.Add("1001G1100000000FEHL4");
            idListNC.Add("1001G1100000000FEHLG");
            idListNC.Add("1001G1100000000FEHLS");
            idListNC.Add("1001G1100000000FEHM4");
            idListNC.Add("1001G1100000000FEHMG");
            idListNC.Add("1001G1100000000FEHMS");
            idListNC.Add("1001G1100000000FEHN4");
            idListNC.Add("1001G1100000000FEHNG");
            idListNC.Add("1001G1100000000FEHNY");
            idListNC.Add("1001G1100000000FEHNY");
            idListNC.Add("1001G1100000000FEHNY");
            idListNC.Add("1001G1100000000FEHOI");
            idListNC.Add("1001G1100000000FEHOI");
            idListNC.Add("1001G1100000000FEHOI");
            idListNC.Add("1001G1100000000FEFGZ");
            idListNC.Add("1001G1100000000FEFD1");
            idListNC.Add("1001G1100000000FEF75");
            idListNC.Add("1001G1100000000FEF69");
            idListNC.Add("1001G1100000000FE81X");
            idListNC.Add("1001G1100000000FE829");
            idListNC.Add("1001G1100000000FE7DD");
            idListNC.Add("1001G1100000000FE7DD");
            idListNC.Add("1001G1100000000FE7DD");
            idListNC.Add("1001G1100000000FE7DR");
            idListNC.Add("1001G1100000000FE7E3");
            idListNC.Add("1001G1100000000FE7EF");
            idListNC.Add("1001G1100000000FE7ER");
            idListNC.Add("1001G1100000000FE7F3");
            idListNC.Add("1001G1100000000FE7FF");
            idListNC.Add("1001G1100000000FE7FR");
            idListNC.Add("1001G1100000000FE79G");
            idListNC.Add("1001G1100000000FE79S");
            idListNC.Add("1001G1100000000FE7A4");
            idListNC.Add("1001G1100000000FE7AG");
            idListNC.Add("1001G1100000000FE7AS");
            idListNC.Add("1001G1100000000FE7BA");
            idListNC.Add("1001G1100000000FE7BA");
            idListNC.Add("1001G1100000000FE7BA");
            idListNC.Add("1001G1100000000FE7BO");
            idListNC.Add("1001G1100000000FE7C0");
            idListNC.Add("1001G1100000000FE7CC");
            idListNC.Add("1001G1100000000FE76W");
            idListNC.Add("1001G1100000000FE778");
            idListNC.Add("1001G1100000000FE77K");
            idListNC.Add("1001G1100000000FE77W");
            idListNC.Add("1001G1100000000FE788");
            idListNC.Add("1001G1100000000FEJRR");
            idListNC.Add("1001G1100000000FEHIX");
            idListNC.Add("1001G1100000000FEHIX");
            idListNC.Add("1001G1100000000FEHIX");
            idListNC.Add("1001G1100000000FEHJ7");
            idListNC.Add("1001G1100000000FEHJ7");
            idListNC.Add("1001G1100000000FEHJ7");
            idListNC.Add("1001G1100000000FETQB");
            idListNC.Add("1001G1100000000FETPJ");
            idListNC.Add("1001G1100000000FEKAN");
            idListNC.Add("1001G1100000000FETT4");
            idListNC.Add("1001G1100000000FEO55");
            idListNC.Add("1001G1100000000FEZWP");
            idListNC.Add("1001G1100000000FETQW");


            LogHelper.WriteLog(JsonConvert.SerializeObject(idList.Count), "idList");

            #region 获取NC中选项数据的Id
            var bd_customerDic = _db_nc.Queryable<bd_customer>().ToList();
            var bd_incomeDic = _db_nc.Queryable<bd_income>().ToList();
            var org_orgsDic = _db_nc.Queryable<org_orgs>().ToList();
            var bd_projectDic = _db_nc.Queryable<bd_project>().ToList();
            var bd_materialDic = _db_nc.Queryable<bd_material>().ToList();
            var bd_measdocDic = _db_nc.Queryable<bd_measdoc>().ToList();
            var org_deptDic = _db_nc.Queryable<org_dept>().ToList();
            var bd_psndocDic = _db_nc.Queryable<bd_psndoc>().ToList();
            var sm_userDic = _db_nc.Queryable<sm_user>().ToList();
            var bd_defdoc_kplx = _db_nc.Queryable<bd_defdoc>().Where(w => w.pk_defdoclist == "1001G1100000000016FV").ToList(); // 开票类型
            var bd_defdoc_htywlx = _db_nc.Queryable<bd_defdoc>().Where(w => w.pk_defdoclist == "1001G1100000000010PV").ToList(); // 合同业务类型
            #endregion

            #region 接口方式
            // 向NC插入数据


            //foreach (var item in idList)
            for (int i = 0; i < idList.Count; i++)
            {
                string createTime = "";
                string modifyTime = "";

                var ydDataSource = _dingTalkService.GetFormDataById(idList[i].id, out createTime, out modifyTime);



                // -------------------------------销售发票同步完，开始同步应收  （新版）应收不同步，改为调用审核接口，让NC自动取生成应收单

                var ncCode = idListNC[i]; //ydDataSource.FirstOrDefault(f => f.Key == "textField_ltxyt75m").Value.ToString();

                LogHelper.WriteLog("id:" + idList[i].id + "  ||  ncCode:" + ncCode, "results_销售发票审核参数");

                var results_销售发票审核 = HttpRequestHelper.ApporeNCCSOBill(ncCode);

                LogHelper.WriteLog(JsonConvert.SerializeObject(results_销售发票审核), "results_销售发票审核");

                if (results_销售发票审核.state == 0)
                {
                    if (ydDataSource["selectField_lvc9x4vp"].ToString() == "增值税普票")
                    {
                        _db_nc.Ado.ExecuteCommand($"UPDATE SO_SALEINVOICE SET VTRANTYPECODE='32-Cxx-01',CTRANTYPEID='1001G11000000000036J' WHERE CSALEINVOICEID='{ncCode}'");

                        LogHelper.WriteLog("执行更新sql", "results_销售发票");
                    }
                }
                else
                {
                }

                var finalResData = new YiDaResDto();

                finalResData.bSuccess = true;
                finalResData.syncTime = DateTime.Now;
                finalResData.log = "同步成功！ || 同步成功！ || 同步成功！";

                var ydRes = _dingTalkService.UpdateFormDataSyncDataById(finalResData, idList[i].id);
            }

            #endregion
        }
    }
}