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(); //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(); //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().ToList(); var bd_incomeDic = _db_nc.Queryable().ToList(); var org_orgsDic = _db_nc.Queryable().ToList(); var bd_projectDic = _db_nc.Queryable().ToList(); var bd_materialDic = _db_nc.Queryable().ToList(); var bd_measdocDic = _db_nc.Queryable().ToList(); var org_deptDic = _db_nc.Queryable().ToList(); var bd_psndocDic = _db_nc.Queryable().ToList(); var sm_userDic = _db_nc.Queryable().ToList(); var bd_defdoc_kplx = _db_nc.Queryable().Where(w => w.pk_defdoclist == "1001G1100000000016FV").ToList(); // 开票类型 var bd_defdoc_htywlx = _db_nc.Queryable().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 } } }