加上条件分支就不继续循环了,求教下是什么问题??

satoshi 2020-9-29 948

如题,这个加上后面的条件分支后就不循环了,运行结束停住不动了,删除条件分支就正常循环,请问下哪里出问题了??

_加上条件分支就不继续循环了,求教下是什么问题??


dim arrayRet = ""
dim bRet = ""
dim objExcelWorkBook = ""

objExcelWorkBook = Excel.BindBook("电视固话拆机单.xlsx")
arrayRet = Excel.ReadRange(objExcelWorkBook,"固话调度中心","A28:B2219")
For Each value In arrayRet
#icon("@res:pkbj5ds6-q9ao-d4gf-mf8n-c05a2vrlrjdc.png")
UiElement.SetValue({"html":[{"name":"queryParam.orderSerialNo","tag":"INPUT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},value[0],{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:jlvoet5r-t1tp-lbms-b3q3-cmsnmqq2kbjt.png")
Mouse.Action({"html":[{"tag":"INPUT","type":"submit"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
Delay(1000)
#icon("@res:92edvftf-v830-l94c-igqm-44ta27mp6um2.png")
Mouse.Action({"html":[{"aaname":"*_业务拆除_*","parentid":"listsListContainer","tag":"TD"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:7n6bthkj-dvgd-8hf2-c2on-bomuanur2lfv.png")
UiElement.SetValue({"html":[{"name":"sgWorkTicket.sgWorkTicketAttrValues.orderTel","tag":"INPUT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},value[1],{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
Delay(1000)
#icon("@res:puktq89f-s20p-u82b-el0j-fgfhs33ej2st.png")
Mouse.Action({"html":[{"id":"_doActionId","tag":"INPUT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:jr1tsf8q-jmmi-4295-j9hg-5kvurb0hsfso.png")
UiElement.Wait({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"}],"ctrl":[{"role":"ROLE_SYSTEM_DIALOG","name":"来自网页的消息"}]},"show",10000000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:bspoj8rr-fuh0-nvtb-icha-gs0f14l6jcdt.png")
Mouse.Action({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"},{"cls":"Button","title":"确定","ctrlid":1,"aaname":"确定"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
Delay(3000)
#icon("@res:jlvoet5r-t1tp-lbms-b3q3-cmsnmqq2kbjt.png")
Mouse.Action({"html":[{"tag":"INPUT","type":"submit"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
Delay(1000)
#icon("@res:92edvftf-v830-l94c-igqm-44ta27mp6um2.png")
Mouse.Action({"html":[{"aaname":"*_业务拆除_*","parentid":"listsListContainer","tag":"TD"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
Delay(2000)
#icon("@res:0o53abl5-sbcs-bcfs-493r-32kl6ved09dm.png")
Mouse.Action({"html":[{"id":"_sign","tag":"INPUT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:iajitnb6-haah-7s7l-stso-bcnm52tttbsu.png")
UiElement.Wait({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"}],"ctrl":[{"role":"ROLE_SYSTEM_DIALOG","name":"来自网页的消息"}]},"show",10000000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:7gk64qtt-bc8k-k706-o8s0-r0t8gkj650mk.png")
Mouse.Action({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"},{"cls":"Button","title":"确定","ctrlid":1,"aaname":"确定"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:6gsrrlr6-tn97-gkcm-ju4j-rf41ulif144p.png")
UiElement.Wait({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"}],"ctrl":[{"role":"ROLE_SYSTEM_DIALOG","name":"来自网页的消息"}]},"show",100000000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:fnab2s94-bdav-jh03-pvr4-mtmrj0hba9gg.png")
Mouse.Action({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"},{"cls":"Button","title":"确定","ctrlid":2,"aaname":"确定"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
Delay(3000)
#icon("@res:bgjve5v3-31e7-9218-p1io-ahh6j40p112l.png")
Mouse.Action({"html":[{"name":"XCalendarNmeCtrl21","tag":"INPUT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:sn275sd8-rdrd-h99j-1f4d-22qn95v4noru.png")
Mouse.Action({"html":[{"id":"meizzDay38","idx":3,"tag":"TD"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:r2009sto-2vgr-4is1-e9b7-etde67id19lp.png")
UiElement.SetSelect({"html":[{"name":"sgWorkTicket.sgWorkTicketAttrValues.appointStaues","tag":"SELECT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"未预约","text",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:cu1vidad-7sde-kruf-846m-9p5eci5o71o3.png")
UiElement.SetSelect({"html":[{"name":"sgWorkTicket.sgWorkTicketAttrValues.SMSSYQ","tag":"SELECT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"其他","text",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:8par12ot-72dh-hnci-tqpa-nj7f2qfe8tn3.png")
Mouse.Action({"html":[{"id":"_doActionId","tag":"INPUT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:i6fbfbcb-idie-8vqg-qdea-udhj4l77ad3u.png")
UiElement.Wait({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"}],"ctrl":[{"role":"ROLE_SYSTEM_DIALOG","name":"来自网页的消息"}]},"show",10000000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:ca3c5dv2-eqf9-t8d9-58o1-4fuudpq6rc7v.png")
Mouse.Action({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"},{"cls":"Button","title":"确定","ctrlid":1,"aaname":"确定"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
Delay(3000)
#icon("@res:o5oicqf4-9alc-tn8u-4489-gbrlihcr0oot.png")
Mouse.Action({"html":[{"tag":"INPUT","type":"submit"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:92edvftf-v830-l94c-igqm-44ta27mp6um2.png")
Mouse.Action({"html":[{"aaname":"*_业务拆除_*","parentid":"listsListContainer","tag":"TD"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
Delay(2000)
#icon("@res:4qi72701-56ob-80b1-2tlo-0b9h394rkb95.png")
Mouse.Action({"html":[{"name":"sgWorkTicket.sgWorkTicketAttrValues.SFHSONU","tag":"SELECT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
Keyboard.Press("Down", "press", [],{"iDelayAfter":300,"iDelayBefore":200,"sSimulate":"simulate"})
Keyboard.Press("Down", "press", [],{"iDelayAfter":300,"iDelayBefore":200,"sSimulate":"simulate"})
Keyboard.Press("Down", "press", [],{"iDelayAfter":300,"iDelayBefore":200,"sSimulate":"simulate"})
Keyboard.Press("Enter", "press", [],{"iDelayAfter":300,"iDelayBefore":200,"sSimulate":"simulate"})
#icon("@res:4qncedbv-m3ft-m68o-70lp-8rsp0dcpvomp.png")
Mouse.Action({"html":[{"name":"sgWorkTicket.sgWorkTicketAttrValues.BigReplycontent","tag":"TEXTAREA"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
Mouse.Wheel(5,"down", [],{"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:mgdjshjn-mr83-lggp-s6pt-7sm6itr93kja.png")
Mouse.Action({"html":[{"id":"_doActionId","tag":"INPUT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:6d4q0ns0-4cs5-togs-nq2i-jc3n84uag9aa.png")
bRet = UiElement.Exists({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"}],"ctrl":[{"role":"ROLE_SYSTEM_DIALOG","name":"来自网页的消息"}]},{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
If bRet=true
#icon("@res:7f2nkod7-a2su-g73u-svsj-akre8i8k5r11.png")
Mouse.Action({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"},{"cls":"Button","title":"确定","ctrlid":2,"aaname":"确定"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:qg6lev25-gi09-otds-socf-n393016gkn64.png")
UiElement.SetValue({"html":[{"name":"sgWorkTicket.sgWorkTicketAttrValues.JOLTPONKMC","tag":"INPUT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"1111",{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:4qncedbv-m3ft-m68o-70lp-8rsp0dcpvomp.png")
Mouse.Action({"html":[{"name":"sgWorkTicket.sgWorkTicketAttrValues.BigReplycontent","tag":"TEXTAREA"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
Mouse.Wheel(5,"down", [],{"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:96ma7vv3-v6c2-cpq4-4efc-d1nltc0eukb6.png")
Mouse.Action({"html":[{"id":"_doActionId","tag":"INPUT"}],"wnd":[{"app":"360chrome","cls":"Chrome_WidgetWin_1","title":"*"},{"cls":"Internet Explorer_Server"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
#icon("@res:g9toutn3-kc29-d2r4-it57-kt5usb3f9ktd.png")
UiElement.Wait({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"}],"ctrl":[{"role":"ROLE_SYSTEM_DIALOG","name":"来自网页的消息"}]},"show",10000000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:nvnhtmlr-jgrc-2a5e-ej7k-d3n29916dv7c.png")
Mouse.Action({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"},{"cls":"Button","title":"确定","ctrlid":1,"aaname":"确定"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
TracePrint(value[1])
File.Append("F:\\固话电视.txt",value[1] & "\n","utf-8")
Else
End If
#icon("@res:g9toutn3-kc29-d2r4-it57-kt5usb3f9ktd.png")
UiElement.Wait({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"}],"ctrl":[{"role":"ROLE_SYSTEM_DIALOG","name":"来自网页的消息"}]},"show",10000000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200})
#icon("@res:nvnhtmlr-jgrc-2a5e-ej7k-d3n29916dv7c.png")
Mouse.Action({"wnd":[{"app":"360chrome","cls":"#32770","title":"来自网页的消息"},{"cls":"Button","title":"确定","ctrlid":1,"aaname":"确定"}]},"left","click",10000,{"bContinueOnError":false,"iDelayAfter":300,"iDelayBefore":200,"bSetForeground":true,"sCursorPosition":"Center","iCursorOffsetX":0,"iCursorOffsetY":0,"sKeyModifiers":[],"sSimulate":"simulate"})
TracePrint(value[1])
File.Append("F:\\固话电视.txt",value[1] & "\n","utf-8")
Next

最新回复 (2)
  • xuewushu 2022-1-26
    2
    同问,希望高手解答
  • 果子哩 2022-1-26
    3

    有报错吗?把下面的代码放到否则里面试试

    ,然后可以添加一下变量,来记录并且输出一下循环的次数,看一下循环是否正常进行

返回
发新帖