private void InsertDecl() { string json_decl = db.ListLeftPop("Redis_Declare"); if (!string.IsNullOrEmpty(json_decl)) { JObject jo_decl = (JObject)JsonConvert.DeserializeObject(json_decl); try { if (JudgeIsJiShiOrder(jo_decl)) { string sql = "delete from list_declaration where code='" + jo_decl.Value <string>("CODE") + "'"; //先删除已经存在的预制报关单号 DBMgr.ExecuteNonQuery(sql); sql = "delete from list_decllist where PREDECLCODE='" + jo_decl.Value <string>("CODE") + "'"; //删除报关单明细 DBMgr.ExecuteNonQuery(sql); //添加到报关单表 sql = @"insert into list_declaration(id , code, codetype, ordercode, declarationcode, unitycode, currentcode, customareacode, declway, decltype, portcode, contractno , recordcode, channel, conshippercode , conshippername, busiunitcode, busiunitname, repunitcode, repunitname, transmodel, transname , voyageno, blno, exemptioncode, tradecode, tradecountrycode, secountrycode, seportcode , seplacecode, goodsnum, packagecode , licenseno, goodsgw, goodsnw, tradetermscode, fgcode, freight, fgunitcode, ipcode, insurancepremium, ipunitcode , aecode, additionalexpenses, aeunitcode, specialrelation, priceimpact, paypoyalties, taxrate, taxunitcode, taxunitname, listinfo , remark, isinvalid, ispause, moedit, coedit, mostarttime, moendtime, mostartid, mostartname, moendid , moendname, costarttime, coendtime, costartid, costartname, coendid, coendname, prestarttime, preendtime, prestartid , prestartname, preendid, preendname, ckfinishtime, ckid , ckname, repstarttime, repid, repname, relatedtime , relateduserid, relatedusername, rependtime, rependid, rependname, repovertime, repoverid, repovername, conshippernum, busiunitnum , repunitnum, isneedclearance, ishaveclearance, isforcelaw, issplit, warehouseno, yardcode, status, sheetnum, presheetnum , commoditynum, isaccept, modifyflag, checkflag, preedit, wpid, wpname, wptime, cusno, dataconfirm , relatedflag, repoverflag, preacctime, preaccuserid, preaccusername, repwayid, customsstatus, prependtime, prependuserid, prependusername , totalnw, totalmoney, totalnum, isprint, printtime, printnum, preedituserid, preeditusername, preedittime, listtype , formatauto, busitype, associatepedeclno, associatedeclno, declcodesource, declremark, pauseuserid, pauseusername, specialdecl, dataconfirmuserid , dataconfirmusername, dataconfirmusertime, mocurrentid, cocurrentid ) values (list_declaration_id.nextval ,'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}' ,'{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}' ,'{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}' ,'{31}','{32}','{33}','{34}','{35}','{36}','{37}','{38}','{39}','{40}' ,'{41}','{42}','{43}','{44}','{45}','{46}','{47}','{48}','{49}','{50}' ,'{51}','{52}','{53}','{54}','{55}',{56},{57},'{58}','{59}','{60}' ,'{61}',{62},{63},'{64}','{65}','{66}','{67}',{68},{69},'{70}' ,'{71}','{72}','{73}',{74},'{75}','{76}',{77},'{78}','{79}',{80} ,'{81}','{82}',{83},'{84}','{85}',{86},'{87}','{88}','{89}','{90}' ,'{91}','{92}','{93}','{94}','{95}','{96}','{97}','{98}','{99}','{100}' ,'{101}','{102}','{103}','{104}','{105}','{106}','{107}',{108},'{109}','{110}' ,'{111}','{112}',{113},'{114}','{115}','{116}','{117}',{118},'{119}','{120}' ,'{121}','{122}','{123}','{124}',{125},'{126}','{127}','{128}',{129},'{130}' ,'{131}','{132}','{133}','{134}','{135}','{136}','{137}','{138}','{139}','{140}' ,'{141}',{142},'{143}','{144}' )"; sql = string.Format(sql , jo_decl.Value <string>("CODE"), jo_decl.Value <string>("CODETYPE"), jo_decl.Value <string>("ORDERCODE"), jo_decl.Value <string>("DECLARATIONCODE"), jo_decl.Value <string>("UNITYCODE"), jo_decl.Value <string>("CURRENTCODE"), jo_decl.Value <string>("CUSTOMAREACODE"), jo_decl.Value <string>("DECLWAY"), jo_decl.Value <string>("DECLTYPE"), jo_decl.Value <string>("PORTCODE"), jo_decl.Value <string>("CONTRACTNO") , jo_decl.Value <string>("RECORDCODE"), jo_decl.Value <string>("CHANNEL"), jo_decl.Value <string>("CONSHIPPERCODE"), jo_decl.Value <string>("CONSHIPPERNAME"), jo_decl.Value <string>("BUSIUNITCODE"), jo_decl.Value <string>("BUSIUNITNAME"), jo_decl.Value <string>("REPUNITCODE"), jo_decl.Value <string>("REPUNITNAME"), jo_decl.Value <string>("TRANSMODEL"), jo_decl.Value <string>("TRANSNAME ") , jo_decl.Value <string>("VOYAGENO"), jo_decl.Value <string>("BLNO"), jo_decl.Value <string>("EXEMPTIONCODE"), jo_decl.Value <string>("TRADECODE"), jo_decl.Value <string>("TRADECOUNTRYCODE"), jo_decl.Value <string>("SECOUNTRYCODE"), jo_decl.Value <string>("SEPORTCODE"), jo_decl.Value <string>("SEPLACECODE"), jo_decl.Value <string>("GOODSNUM"), jo_decl.Value <string>("PACKAGECODE") , jo_decl.Value <string>("LICENSENO"), jo_decl.Value <string>("GOODSGW"), jo_decl.Value <string>("GOODSNW"), jo_decl.Value <string>("TRADETERMSCODE"), jo_decl.Value <string>("FGCODE"), jo_decl.Value <string>("FREIGHT"), jo_decl.Value <string>("FGUNITCODE"), jo_decl.Value <string>("IPCODE"), jo_decl.Value <string>("INSURANCEPREMIUM"), jo_decl.Value <string>("IPUNITCODE") , jo_decl.Value <string>("AECODE"), jo_decl.Value <string>("ADDITIONALEXPENSES"), jo_decl.Value <string>("AEUNITCODE"), jo_decl.Value <string>("SPECIALRELATION"), jo_decl.Value <string>("PRICEIMPACT"), jo_decl.Value <string>("PAYPOYALTIES"), jo_decl.Value <string>("TAXRATE"), jo_decl.Value <string>("TAXUNITCODE"), jo_decl.Value <string>("TAXUNITNAME"), jo_decl.Value <string>("LISTINFO") , jo_decl.Value <string>("REMARK"), jo_decl.Value <string>("ISINVALID"), jo_decl.Value <string>("ISPAUSE"), jo_decl.Value <string>("MOEDIT"), jo_decl.Value <string>("COEDIT"), "TO_DATE('" + jo_decl.Value <string>("MOSTARTTIME") + "','yyyy-MM-dd HH24:mi:ss')", "TO_DATE('" + jo_decl.Value <string>("MOENDTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("MOSTARTID"), jo_decl.Value <string>("MOSTARTNAME"), jo_decl.Value <string>("MOENDID") , jo_decl.Value <string>("MOENDNAME"), "TO_DATE('" + jo_decl.Value <string>("COSTARTTIME") + "','yyyy-MM-dd HH24:mi:ss')", "TO_DATE('" + jo_decl.Value <string>("COENDTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("COSTARTID"), jo_decl.Value <string>("COSTARTNAME"), jo_decl.Value <string>("COENDID"), jo_decl.Value <string>("COENDNAME"), "TO_DATE('" + jo_decl.Value <string>("PRESTARTTIME") + "','yyyy-MM-dd HH24:mi:ss')", "TO_DATE('" + jo_decl.Value <string>("PREENDTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("PRESTARTID") , jo_decl.Value <string>("PRESTARTNAME"), jo_decl.Value <string>("PREENDID"), jo_decl.Value <string>("PREENDNAME"), "TO_DATE('" + jo_decl.Value <string>("CKFINISHTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("CKID"), jo_decl.Value <string>("CKNAME"), "TO_DATE('" + jo_decl.Value <string>("REPSTARTTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("REPID"), jo_decl.Value <string>("REPNAME"), "TO_DATE('" + jo_decl.Value <string>("RELATEDTIME") + "','yyyy-MM-dd HH24:mi:ss')" , jo_decl.Value <string>("RELATEDUSERID"), jo_decl.Value <string>("RELATEDUSERNAME"), "TO_DATE('" + jo_decl.Value <string>("REPENDTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("REPENDID"), jo_decl.Value <string>("REPENDNAME"), "TO_DATE('" + jo_decl.Value <string>("REPOVERTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("REPOVERID"), jo_decl.Value <string>("REPOVERNAME"), jo_decl.Value <string>("CONSHIPPERNUM"), jo_decl.Value <string>("BUSIUNITNUM") , jo_decl.Value <string>("REPUNITNUM"), jo_decl.Value <string>("ISNEEDCLEARANCE"), jo_decl.Value <string>("ISHAVECLEARANCE"), jo_decl.Value <string>("ISFORCELAW"), jo_decl.Value <string>("ISSPLIT"), jo_decl.Value <string>("WAREHOUSENO"), jo_decl.Value <string>("YARDCODE"), jo_decl.Value <string>("STATUS"), jo_decl.Value <string>("SHEETNUM"), jo_decl.Value <string>("PRESHEETNUM") , jo_decl.Value <string>("COMMODITYNUM"), jo_decl.Value <string>("ISACCEPT"), jo_decl.Value <string>("MODIFYFLAG"), jo_decl.Value <string>("CHECKFLAG"), jo_decl.Value <string>("PREEDIT"), jo_decl.Value <string>("WPID"), jo_decl.Value <string>("WPNAME"), "TO_DATE('" + jo_decl.Value <string>("WPTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("CUSNO"), jo_decl.Value <string>("DATACONFIRM") , jo_decl.Value <string>("RELATEDFLAG"), jo_decl.Value <string>("REPOVERFLAG"), "TO_DATE('" + jo_decl.Value <string>("PREACCTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("PREACCUSERID"), jo_decl.Value <string>("PREACCUSERNAME"), jo_decl.Value <string>("REPWAYID"), jo_decl.Value <string>("CUSTOMSSTATUS"), "TO_DATE('" + jo_decl.Value <string>("PREPENDTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("PREPENDUSERID"), jo_decl.Value <string>("PREPENDUSERNAME") , jo_decl.Value <string>("TOTALNW"), jo_decl.Value <string>("TOTALMONEY"), jo_decl.Value <string>("TOTALNUM"), jo_decl.Value <string>("ISPRINT"), "TO_DATE('" + jo_decl.Value <string>("PRINTTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("PRINTNUM"), jo_decl.Value <string>("PREEDITUSERID"), jo_decl.Value <string>("PREEDITUSERNAME"), "TO_DATE('" + jo_decl.Value <string>("PREEDITTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("LISTTYPE") , jo_decl.Value <string>("FORMATAUTO"), jo_decl.Value <string>("BUSITYPE"), jo_decl.Value <string>("ASSOCIATEPEDECLNO"), jo_decl.Value <string>("ASSOCIATEDECLNO"), jo_decl.Value <string>("DECLCODESOURCE"), jo_decl.Value <string>("DECLREMARK"), jo_decl.Value <string>("PAUSEUSERID"), jo_decl.Value <string>("PAUSEUSERNAME"), jo_decl.Value <string>("SPECIALDECL"), jo_decl.Value <string>("DATACONFIRMUSERID") , jo_decl.Value <string>("DATACONFIRMUSERNAME"), "TO_DATE('" + jo_decl.Value <string>("DATACONFIRMUSERTIME") + "','yyyy-MM-dd HH24:mi:ss')", jo_decl.Value <string>("MOCURRENTID"), jo_decl.Value <string>("COCURRENTID") ); DBMgr.ExecuteNonQuery(sql); db.ListRightPush("jishi_synced_decl", json_decl); } else//如果不是吉时的单子 { db.ListRightPush("unsync_decl", json_decl); } } catch (Exception ex) { db.ListRightPush("redis_declare", json_decl); this.button1.Text = ex.Message; } } }