[go: up one dir, main page]

CN116664221A - A method for e-commerce procurement based on intelligent software robots - Google Patents

A method for e-commerce procurement based on intelligent software robots Download PDF

Info

Publication number
CN116664221A
CN116664221A CN202310435767.6A CN202310435767A CN116664221A CN 116664221 A CN116664221 A CN 116664221A CN 202310435767 A CN202310435767 A CN 202310435767A CN 116664221 A CN116664221 A CN 116664221A
Authority
CN
China
Prior art keywords
add
component
capture
send
hotkey
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310435767.6A
Other languages
Chinese (zh)
Inventor
邵霞
李瑾
赵国波
吴迪
雷钰
刘凯
陈明山
戴振华
李博
骆林峰
程卓
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ezhou Power Supply Co of State Grid Hubei Electric Power Co Ltd
Original Assignee
Ezhou Power Supply Co of State Grid Hubei Electric Power Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ezhou Power Supply Co of State Grid Hubei Electric Power Co Ltd filed Critical Ezhou Power Supply Co of State Grid Hubei Electric Power Co Ltd
Priority to CN202310435767.6A priority Critical patent/CN116664221A/en
Publication of CN116664221A publication Critical patent/CN116664221A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • G06Q30/0641Electronic shopping [e-shopping] utilising user interfaces specially adapted for shopping

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Stored Programmes (AREA)

Abstract

The application relates to the technical field of electric power and intelligent software robots, and discloses a method for purchasing an electronic commerce based on an intelligent software robot. The method comprises the steps of operating information in a demand document, judging whether the demand document is demand materials or not by an intelligent robot, and simultaneously carrying out purchasing operation on an e-commerce page. The application greatly solves the problems of high manual error rate and longer working time required to be carried out. The application has the following effects: the method can operate for 7 x 24 hours, replaces manual simple repeated operation by simulating the operation of service personnel on a national network e-commerce platform, the identification of image two-dimensional codes, the recording of tables and the like, shortens the order flow finished in 10 minutes to 2-3 minutes to finish one, keeps the accuracy to 100%, and improves the single material processing rate by 80%.

Description

一种基于智能软件机器人进行电商采购的方法A method for e-commerce procurement based on intelligent software robots

技术领域technical field

本申请属于智能机器人及电力相结合的技术领域,尤其是公开了一种基于智能软件机器人进行电商采购的方法。The application belongs to the technical field of the combination of intelligent robots and electric power, and in particular discloses a method for e-commerce procurement based on intelligent software robots.

背景技术Background technique

电子商务采购简称电商采购,电商采购直接影响着企业的生产经营过程、企业效益,并构成企业竞争力的重要方面。电子商务采购是一种适应时代发展的先进采购模式,具有公开、透明、快捷和低成本等特点,能够有效地避免采购过程中的腐败和风险,提高采购效率。E-commerce procurement is referred to as e-commerce procurement for short. E-commerce procurement directly affects the production and operation process and enterprise benefits of enterprises, and constitutes an important aspect of enterprise competitiveness. E-commerce procurement is an advanced procurement model that adapts to the development of the times. It has the characteristics of openness, transparency, speed and low cost. It can effectively avoid corruption and risks in the procurement process and improve procurement efficiency.

采购作为满足社会需求的一种重要手段,对整个社会的生产与生活产生了极其重要的影响。对企业来说,采购直接影响着生产经营过程、企业效益,并构成企业竞争力的重要方面。采购也会带来很大的经济风险,存在着所谓的采购黑洞,如何控制这些漏洞,成了摆在现代企业面前的一项重要任务。电子商务采购作为一种新的采购模式,充分利用了现代网络的开放性,信息的多样性,交易的快捷性和低成本等特点,可以有效地解决企业和政府所面临的这些问题。Purchasing, as an important means to meet social needs, has an extremely important impact on the production and life of the whole society. For enterprises, procurement directly affects the production and operation process and enterprise benefits, and constitutes an important aspect of enterprise competitiveness. Procurement will also bring great economic risks. There are so-called black holes in procurement. How to control these loopholes has become an important task for modern enterprises. As a new procurement model, e-commerce procurement makes full use of the openness of modern networks, the diversity of information, the quickness of transactions and low cost, and can effectively solve these problems faced by enterprises and governments.

现有技术中,进行电商采购时,需要人工进入电商平台,对照“电商请购表”中的专区数据逐条搜索商品编号,且进入请购页面后也需对应表格中的“工厂”、“采购组”、“WBS元素”等维护ERP信息进行手动录入且不能出错,最后需手动将最后结果的PR号重新录入进表格里。In the prior art, when conducting e-commerce purchases, it is necessary to manually enter the e-commerce platform, search for product numbers one by one against the data in the special area in the "e-commerce purchase requisition form", and also need to correspond to the "factory" in the form after entering the purchase requisition page , "Purchasing Group", "WBS Elements" and other maintenance ERP information are entered manually without error, and finally the PR number of the final result needs to be manually entered into the form again.

传统的采购模式存在下列问题:采购、供应双方为了各自利益互相封锁消息,进行非对称信息博弈,采购很容易发展成为一种盲目行为;供需关系一般为临时或短期行为,竞争多于合作,容易造成双输后果;信息交流不畅,无法对供应商产品质量、交货期进行跟踪;响应用户需求的能力不足,无法面对快速变化的市场;利益驱动造成暗箱操作,舍好求次、舍贱求贵、舍近求远,产生腐败温床;设计部门、生产部门与采购部门联系脱节,造成库存积压,占用大量流动资金。The traditional procurement model has the following problems: the procurement and supply sides block information from each other for their own interests, and engage in an asymmetric information game. Procurement can easily develop into a blind behavior; the relationship between supply and demand is generally a temporary or short-term behavior, and competition is more than cooperation. Causes lose-lose consequences; poor information exchange, unable to track the supplier's product quality and delivery date; insufficient ability to respond to user needs, unable to face the rapidly changing market; profit-driven results in black-box operations Pursuing low price for high price and abandoning the near for the far away creates a hotbed of corruption; the design department, production department and purchasing department are out of touch, resulting in a backlog of inventory and occupying a large amount of working capital.

传统的采购还存在以下缺点:一是效率较低:请购单量大、人工执行时需逐步将数据录入到系统里;二是质量不高:人员长时间工作视觉疲劳,容易出现数据错误,难以保障100%准确。The traditional procurement also has the following disadvantages: First, the efficiency is low: the quantity of purchase requisitions is large, and the data needs to be entered into the system gradually during manual execution; second, the quality is not high: the personnel are visually fatigued after working for a long time, and data errors are prone to occur. It is difficult to guarantee 100% accuracy.

发明内容Contents of the invention

为解决上述问题,本发明的目的在于提供一种基于智能软件机器人进行电商采购的方法,本发明是采用以下技术方案来实现的。In order to solve the above problems, the object of the present invention is to provide a method for e-commerce procurement based on intelligent software robots, and the present invention is realized by adopting the following technical solutions.

一种基于智能机器人进行电商采购的方法,其特征在于所述的采购方法包含有依次进行的以下步骤:A method for purchasing e-commerce based on an intelligent robot, characterized in that the purchasing method includes the following steps in sequence:

第一步:预先生成电商请购表及外部参数表,其中,电商请购表用于请购物料信息,外部参数表用于储存网页信息和账号密码信息;Step 1: Pre-generate the e-commerce purchase requisition form and external parameter table, wherein the e-commerce purchase requisition form is used to requisition material information, and the external parameter table is used to store webpage information and account password information;

第二步:进行RPA软件下载及授权;Step 2: Download and authorize the RPA software;

第三步:下载完成并获取授权后进入Cyclone Starter软件进行流程开发和发布;所述流程开发和发布是指添加流程块;Step 3: After downloading and obtaining authorization, enter the Cyclone Starter software for process development and release; the process development and release refers to adding process blocks;

第四步:通过Cyclone Starter软件读取之前配置好的电商请购表与外部参数表中的数据,并将其中的信息储存在Cyclone Starter软件内部变量中;Step 4: Read the data in the previously configured e-commerce purchase requisition table and external parameter table through the Cyclone Starter software, and store the information in the internal variables of the Cyclone Starter software;

第五步:打开国网电商平台,并通过Cyclone Starter软件内部的组件进行页面数据抓取;Cyclone Starter识别页面信息并捕获输入账号密码栏,将提前储存好的变量信息自动输入,然后添加验证码自动识别,自动识别验证码并点击登陆;当成功登陆页面加载出时,继续添加循环流程和条件判断流程;当登陆成功时则跳出循环登陆,不成功时则继续循环登陆;调用第三步的流程;当物料信息存在时则进入物料请购页面,且通过读取请购表中的需求信息,把读取到的信息填入需求板块中,然后点击提交请购;提交请购完成后,进入购物车中,通过读取数据表中的地址信息数据将其填入对应的信息位置;Step 5: Open the State Grid e-commerce platform, and capture the page data through the components inside the Cyclone Starter software; Cyclone Starter identifies the page information and captures the input account password column, automatically enters the variable information stored in advance, and then adds verification Code automatic identification, automatic identification of the verification code and click to log in; when the successful login page is loaded, continue to add the loop process and condition judgment process; When the material information exists, enter the material requisition page, and fill in the read information in the demand section by reading the demand information in the purchase requisition form, and then click Submit Purchase Requisition; after submitting the purchase requisition , enter the shopping cart, and fill in the corresponding information position by reading the address information data in the data table;

第六步:通过判断条件和循环条件与数组遍历条件,Cyclone Starter软件将内部变量中的信息一一去提交请购,循环判断电商请购表中的数据是否存在不存在则退出页面并关闭所有程序;完成采购。Step 6: Through the judgment condition, loop condition and array traversal condition, the Cyclone Starter software submits the information in the internal variables one by one to submit the purchase requisition, and loops to judge whether the data in the e-commerce purchase requisition table exists or not, then exits the page and closes All procedures; complete purchase.

本申请中,进入国网电商平台主页面后,继续添加判断流程来判断“一级专区”和“二级专区”是否存在,当页面元素存在时则通过电商请购数据表中的信息来判断进入哪一个专区中;当物料信息时属于汽车采购时则进入其他流程块。In this application, after entering the main page of the State Grid e-commerce platform, continue to add a judgment process to judge whether the "first-level special area" and "secondary special area" exist, and when the page elements exist, use the information in the e-commerce requisition data table To determine which special area to enter; when the material information belongs to automobile procurement, enter other process blocks.

例:进入“二区专区”后自动识别数据表中的商品编码列,输入需求物料的商品编码并点击搜索(此处添加数组遍历流程:当一个物料请购完成后自动回到搜索页面当中并获取下一个物料信息继续后续流程)。当搜索出物料信息时进入判断流程,是否存在需求页面元素信息。当信息出现时则进入该物料信息当中,当页面加载完成时也要加入条件判断来判断该需求物料是否存在(信息不存在时则进入下一物料信息,信息存在时则进入一下步流程操作)当物料信息存在时则进入物料请购页面,且通过读取Excel读取请购表中的需求信息,把读取到的信息填入需求板块中,最后点击提交请购。Example: After entering the "Second Zone", automatically identify the commodity code column in the data table, enter the commodity code of the required material and click Search (add an array traversal process here: when a material requisition is completed, it will automatically return to the search page and search Get the next material information to continue the subsequent process). When the material information is searched out, it enters the judgment process, whether there is element information on the demand page. When the information appears, it enters the material information, and when the page is loaded, a conditional judgment is also added to determine whether the required material exists (if the information does not exist, it will enter the next material information, and if the information exists, it will enter the next step of the process operation) When the material information exists, enter the material purchase requisition page, and read the demand information in the purchase requisition form by reading Excel, fill in the read information in the demand section, and finally click Submit Purchase Requisition.

上述所述的一种基于智能机器人进行电商采购的方法,其特征在于智能机器人对应的英文为:Robotic Process Automation,简称RPA;RPA软件通过进入弘玑Cyclone软件官网进行下载,网址为:https://www.cyclone-robotics.com/。The above-mentioned method for purchasing e-commerce based on intelligent robots is characterized in that the English corresponding to intelligent robots is: Robotic Process Automation, referred to as RPA; RPA software is downloaded by entering the official website of Hongji Cyclone Software, the URL is: https: //www.cyclone-robotics.com/.

上述所述的一种基于智能机器人进行电商采购的方法,其特征在于国网电商平台的网址为:http://b.esgcc.com.cn。The above-mentioned method for purchasing e-commerce based on intelligent robots is characterized in that the website of the State Grid e-commerce platform is: http://b.esgcc.com.cn.

本申请具有以下主要有益技术效果:通过智能机器人来识别电商页面并自动进行操作,极大地解决了人工错误率高且需要进行的工作时间较长的问题,而且能够7*24小时运作,通过模拟业务人员在国网电商平台的操作、图像二维码识别和表格记录等行为,代替人工进行简单重复操作,处理量大易错环节,将原先10分钟完成的订单流程缩短到2-3分钟完成一个,准确率保持100%,单个物料处理率提高了80%以上。The application has the following main beneficial technical effects: the intelligent robot is used to identify the e-commerce page and automatically operate it, which greatly solves the problems of high manual error rate and long working hours, and can operate 7*24 hours, through Simulate the operations of business personnel on the State Grid e-commerce platform, image QR code recognition and form recording, etc., instead of manual simple and repetitive operations, with a large amount of processing and error-prone links, shortening the order process that was originally completed in 10 minutes to 2-3 Complete one in minutes, the accuracy rate remains 100%, and the processing rate of a single material has increased by more than 80%.

附图说明Description of drawings

图1是全流程的简略图。Figure 1 is a schematic diagram of the whole process.

图2是子流程“新标签进入购物车”的流程示意图。Fig. 2 is a flow diagram of the sub-process "new label enters the shopping cart".

图3是“维护ERP信息并加购”的流程示意图的第一部分。Fig. 3 is the first part of the flowchart of "maintaining ERP information and adding purchase".

图4是“维护ERP信息并加购”的流程示意图的第二部分。Fig. 4 is the second part of the flowchart of "maintain ERP information and add purchase".

图5是子流程“备注”的流程示意图。Fig. 5 is a flow diagram of the sub-process "remark".

图6是子流程“输入资产号”的流程示意图。Fig. 6 is a flow diagram of the sub-process "input asset number".

具体实施方式Detailed ways

请见图1至图6,图1中,进入国网电商平台后,进入某专区(如具有一级专区、二级专区、科创专区)后,自动获取电商请购需求表中每个工作表的"商品物料编码"列中的数据来填入搜索框内并点击搜索,当搜索出物料信息时则进入该物料主页面,进入该物料页面后通过“等待元素出现”组件等待“请维护ERP”出现,出现时点击该元素进入维护页面,通过“读取行列数据”组件获取的行列数据,例如:WBS元素、交货时间、资产编号等,并通过“输入文本”输入进指定位置当中,当维护完成ERP信息后点击退出并点击提交请购,“点击”购物车并在添加“判断元素是否存在”组件判断提交请购的文件是否存在,如果存在则“点击”进入填写收货人地址页面并通过电商请购信息表中的收货人信息通过“读取行列数据”组件与“输入文本”将数据写入进指定位置,并提交该物料信息,然后循环下一项物料;当未搜索出物料信息时,则跳过这一项需求物料进入下一项物料。Please see Figures 1 to 6. In Figure 1, after entering the State Grid e-commerce platform and entering a special area (such as a first-level special area, a second-level special area, and a science and technology innovation area), each item in the e-commerce purchase request form will be automatically obtained. Fill in the data in the "Commodity Material Code" column of the worksheet and click Search. When the material information is searched out, you will enter the main page of the material. After entering the material page, use the "wait for element to appear" component to wait for " Please maintain ERP" appears. When it appears, click this element to enter the maintenance page. The row and column data obtained through the "Read Row and Column Data" component, such as: WBS elements, delivery time, asset number, etc., and input into the specified through "Input Text" In the location, when the maintenance of ERP information is completed, click exit and click submit purchase requisition, "click" the shopping cart and add the "judging whether the element exists" component to judge whether the file submitted for purchase requisition exists, and if it exists, "click" to enter to fill in the receipt On the consignee address page, write the data into the specified location through the consignee information in the e-commerce requisition information table through the "Read Row and Column Data" component and "Input Text", and submit the material information, and then cycle to the next item Material; when no material information is found, skip this required material and enter the next item.

一种基于智能机器人进行电商采购的方法,其特征在于所述的采购方法包含有依次进行的以下步骤:A method for purchasing e-commerce based on an intelligent robot, characterized in that the purchasing method includes the following steps in sequence:

第一步:预先生成电商请购表及外部参数表,其中,电商请购表用于请购物料信息,外部参数表用于储存网页信息和账号密码信息;Step 1: Pre-generate the e-commerce purchase requisition form and external parameter table, wherein the e-commerce purchase requisition form is used to requisition material information, and the external parameter table is used to store webpage information and account password information;

第二步:进行RPA软件下载及授权;Step 2: Download and authorize the RPA software;

第三步:下载完成并获取授权后进入Cyclone Starter软件进行流程开发和发布;所述流程开发和发布是指添加流程块;Step 3: After downloading and obtaining authorization, enter the Cyclone Starter software for process development and release; the process development and release refers to adding process blocks;

第四步:通过Cyclone Starter软件读取之前配置好的电商请购表与外部参数表中的数据,并将其中的信息储存在Cyclone Starter软件内部变量中;Step 4: Read the data in the previously configured e-commerce purchase requisition table and external parameter table through the Cyclone Starter software, and store the information in the internal variables of the Cyclone Starter software;

第五步:打开国网电商平台,并通过Cyclone Starter软件内部的组件进行页面数据抓取;Cyclone Starter识别页面信息并捕获输入账号密码栏,将提前储存好的变量信息自动输入,然后添加验证码自动识别,自动识别验证码并点击登陆;当成功登陆页面加载出时,继续添加循环流程和条件判断流程;当登陆成功时则跳出循环登陆,不成功时则继续循环登陆;调用第三步的流程;当物料信息存在时则进入物料请购页面,且通过读取请购表中的需求信息,把读取到的信息填入需求板块中,然后点击提交请购;提交请购完成后,进入购物车中,通过读取数据表中的地址信息数据将其填入对应的信息位置;Step 5: Open the State Grid e-commerce platform, and capture the page data through the components inside the Cyclone Starter software; Cyclone Starter identifies the page information and captures the input account password column, automatically enters the variable information stored in advance, and then adds verification Code automatic identification, automatic identification of the verification code and click to log in; when the successful login page is loaded, continue to add the loop process and condition judgment process; When the material information exists, enter the material requisition page, and fill in the read information in the demand section by reading the demand information in the purchase requisition form, and then click Submit Purchase Requisition; after submitting the purchase requisition , enter the shopping cart, and fill in the corresponding information position by reading the address information data in the data table;

第六步:通过判断条件和循环条件与数组遍历条件,Cyclone Starter软件将内部变量中的信息一一去提交请购,循环判断电商请购表中的数据是否存在不存在则退出页面并关闭所有程序;完成采购。Step 6: Through the judgment condition, loop condition and array traversal condition, the Cyclone Starter software submits the information in the internal variables one by one to submit the purchase requisition, and loops to judge whether the data in the e-commerce purchase requisition table exists or not, then exits the page and closes All procedures; complete purchase.

请见图2,“新标签进入购物车”的流程为:添加子流程“新标签进入购物车”,在子流程中添加组件1“鼠标悬停”悬停位置如下,添加组件2“点击”按住Ctrl+左键捕获“去购物车结算”文字同时在组件下方设置右键点击。添加组件3“点击”按住Ctrl+左键捕获“在新标签页中打开文本”,添加组件4“点击”捕获目标为下图新标签页。Please see Figure 2, the process of "new label enters shopping cart" is: add sub-process "new label enters shopping cart", add component 1 "mouse hover" hovering position in the sub-process as follows, add component 2 "click" Hold down Ctrl+left button to capture the "go to cart checkout" text while setting right click below the component. Add component 3 "click" and hold down Ctrl+left button to capture "open text in a new tab", add component 4 "click" to capture the target as the new tab page in the figure below.

请见图3和图4,维护ERP信息并加购”的流程为:维护ERP信息并加购,添加组件1“变量赋值”右侧输入值为科目类别分配_str,输出值为科目分配引用_str,添加组件2“输入文本”按住Ctrl+左键捕获电商平台商品编号输入栏,下侧输入信息为array_element。继续添加组件3“点击”捕获页面元素中的搜索元素,添加组件4“判断元素是否存在”判断元素为搜索商品编码后是否出现“关于商品编号*没有搜到相关结果”如果条件表达式为“没有结果_bool==ture”在否则中添加组件“brake跳出循环”,添加组件5“for计次循环“在计次循环组件组件中添加组件6“等待元素出现"捕获一个页面固定元素,添加组件7“鼠标悬停"同样按住Ctrl+左键捕获一个页面固定元素。添加组件8“判断元素是否存在"捕获页面元素为"没有搜到相关结果"并在右侧储存为一个布尔的变量值。添加组件9"if条件判断"如果的条件表达公式为没有结果_bool==ture。在如果下方添加组件10"点击"捕获的页面元素为搜索。在否则下添加组件"break跳出循环",添加组件11"if条件判断"如果下的条件表达式为没有结果_bool==ture。在如果下添加组件12"变量赋值"输入值为"未查找到结果"输出值为"新请购单编号_str"。在否则处添加组件13"for计次循环"在计次循环组件中添加组件14"等待元素出现"捕获页面固定元素,添加组件15"等待元素出现"捕获的页面元素为"请维护ERP信息",添加组件"流程块"设置备注名称为判断是否为汽车采购,添加组件"if条件循环"如果的条件表达式为存在_bool==ture,添加组件"for计次循环"同时在计次循环下新增一个组件"TryCatch异常处理"在异常处理的try中添加组件“点击”点击的信息为“请维护ERP信息”进入维护页面后新增组件“发送热键”捕获目标为内部订单并在下方空白处填写热键为“Tap”继续添加组件“发送热键”无捕获目标,填写热键为“Delete”。添加组件“点击”捕获点击目标为添加修改,继续添加组件“点击”捕获目标为添加修改页面当中的列号后“X”,继续添加组件“点击”捕获目标为确定。添加组件“流程块”在流程块组件中添加组件1“字符串去空格”待处理字符为工厂_arr[array_index],输出为工厂_arr[array_index]。添加组件2“发送热键”捕获目标为“工厂”发送热键为“Tap”添加组件3“发送热键”发送目标为无,发送热键为“Enter”添加组件4“输入文本”捕获目标为交货方式及地点旁的输入栏,输入文本为“工厂_arr[array_index]”添加组件5“发送热键”发送目标为无,发送热键为“Enter”添加组件6“发送热键”发送目标为科目分配类别,发送热键为“Tap”添加组件7“发送热键”发送目标为无,发送热键为“Enter”添加组件8“if条件判断”如果的条件表达式为“科目类别分配引用_str=="_-(空白)"||科目类别分配引用_str=="K-成本中心"”在否则处添加组件“if条件判断”如果的条件表达式为“科目分配引用_str=="A-资产"”在如果中添加组件“点击”捕获目标为“A-资产”。在否则中添加组件“点击”捕获目标为“Q-项目生成订单”在if条件判断下添加组件“输入文本”捕获目标为“项目/WBS”旁的文本框,输入文本为“WBS元素_arr[array_index]”。回到组件8“if条件判断”中的如果流程中添加组件“if条件判断”如果的条件表达式为“科目分配引用_str=="_-空白"”在如果流程下添加组件1“点击”捕获目标为_-空白,添加组件2“输入文本”捕获目标为项目/WBS旁的输入栏,输入文本为“WBS元素_arr[array_index]”添加组件3“输入文本”捕获目标为内部订单旁的输入栏,输入文本为“工单号_arr[array_index]”在否则流程下添加组件1“点击”捕获目标为“K-成本中心”添加组件2“流程块”在流程块中天添加组件1“字符串去空格”输入值为“[总账科目_arr[array_index],0]”输出值为“[总账科目_arr[array_index]]”添加组件2“发送热键”捕获目标为“总账科目”发送热键为“Tap”添加组件3“发送热键”捕获目标为无,发送热键为“Enter”添加组件4“输入文本”捕获目标为成本中心旁的输入栏,输入文本为“总账科目_arr[array_index]”添加组件5“发送热键”捕获目标为无,发送热键为“Enter”。在组件5“发送热键”下添加组件“流程块”在流程块中添加组件1“发送热键”捕获目标为“成本中心”发送热键为“Tap”添加组件2“发送热键”捕获目标为无,发送热键为”Enter”添加组件3“输入文本”捕获目标为“资产号”旁的输入栏,输入文本为“成本中心_arr[array_index]”添加组件4“发送热键”捕获目标为无,发送热键为“Enter”。在“if条件判断#18”下添加组件“if条件判断”如果的条件表达式为“科目分配引用_str==“A-资产”||科目分配引用_str==“空白”||科目分配引用_str==“K-成本中心””在如果中添加组件1“点击”捕获目标为“添加修改”添加组件2“字符串去空格”输入值为“[资产号_arr[array_index],3]”输出值为[资产号_str],添加组件3“查找字符串”输入值为[资产号_str,string,",",0,ture,false],输出值为“[结果_num]”,添加组件4“执行流程”执行子流程为“输入资产号”。在“if条件判断#25”流程下添加组件“流程块”在流程块中添加组件1“字符串去空格”输入值为“交货地点及方式_arr[array_index],0”输出值为“交货地点及方式_arr[array_index]”添加组件2“字符串分割”输入值为“交货地点及方式_arr[array_index],"-",999”输出值为“交货地点及方式_arr”。添加组件3“发送热键”捕获目标为“交货地点及方式”发送热键为“Tap”添加组件4“发送热键”捕获目标为无,发送热键为“Enter”添加组件5“输入文本”捕获目标为“到货日期”右侧输入栏,输入文本为“交货地点及方式_arr[0]”添加组件6“发送热键”捕获目标为无,发送热键为“Enter”。添加组件“流程块”在流程块中添加组件1“字符串去空格”输入值为“采购组_arr[array_index],0”输出值为“采购组_arr[array_index]”添加组件2“发送热键”捕获目标为“采购组”发送热键为“Tap”,添加组件3“发送热键”捕获目标为无,发送热键为“Enter”添加组件4“输入文本”捕获目标为“数量”右侧输入栏,输入文本为“采购组_arr[array_index]”添加组件5“发送热键”捕获目标为无,发送热键为“Enter”。添加组件“流程块”在流程块中添加组件1“获取当前日期&时间”输出值为“当前日期_dat”添加组件2“日期计算”输入值为“当前日期_aat,+,day.28”输出值为“到货日期_dat”添加组件3“格式化日期”输入值为“到货日期_dat,yyyy-mm-dd”输出值为“到货日期_str”。流程块下添加新组件“输入文本”捕获目标为“到货日期”右侧输入栏,输入文本为“到货日期_str”,添加组件“点击”捕获目标为“到货日期”添加组件“输入文本”捕获目标为“数量”右侧输入栏,输入文本为“采购数量_arr[array_index]”添加组件“break跳出循环”。添加组件1“判断元素是否存在”捕获目标为“加入进货单”在右侧是否存在中添加“加购_bool”的变量,添加组件2“if条件判断”如果的条件表达式为“加购_bool==ture”在如果流程下添加组件1“for计次循环”在计次循环组件中添加组件1“点击”捕获目标为“加入进货单”添加组件2“判断元素是否存在”捕获目标为“添加成功”在右侧添加“加购成功_bool”的变量,添加组件4“if条件判断”如果的条件表达式为“加购成功_bool==ture”。在如果流程中添加组件“break跳出循环”,在否则流程下添加组件1“判断元素是否存在”捕获目标为“显示”新增变量为“提示框_bool”添加组件2“if条件判断”如果的条件表达式为“提示框_bool==ture”,在如果流程中添加组件1“点击”捕获目标为“确定”,添加组件2“break跳出循环”在“if条件判断#467”的如果流程下添加组件“变量赋值”输入值为““已加购””输出值为“新请购单编号_str”。Please see Figure 3 and Figure 4, the process of "maintain ERP information and add purchase" is: maintain ERP information and add purchase, add component 1 "Variable Assignment" right input value is account category assignment _str, output value is account assignment reference _str, add component 2 "input text" and hold down Ctrl+left button to capture the item number input field of the e-commerce platform, and the input information on the lower side is array_element. Continue to add component 3 "click" to capture the search element in the page element, add component 4" Judging whether the element exists" Judging whether the element appears after searching for the product code "About the product number * no relevant results found" If the conditional expression is "no result_bool==ture", otherwise add the component "brake to jump out of the loop", Add component 5 "for counting cycle" Add component 6 "wait for element to appear" to capture a page fixed element in the counting cycle component component, add component 7 "mouse hovering" also hold down Ctrl + left button to capture a page fixed element. Add component 8 "judging whether the element exists" to capture the page element as "no relevant results found" and store it as a Boolean variable value on the right. Add component 9 "if conditional judgment" if the conditional expression formula is no result_bool ==true. Add component 10 "click" to capture the page element below if is search. Add component "break out of loop" under otherwise, add component 11 "if conditional judgment" if the conditional expression under is no result_bool ==true. Add component 12 "variable value assignment" if the input value is "no result found" and the output value is "new purchase requisition number_str". Otherwise, add component 13 "for counting cycle" in the counting Add component 14 "waiting for element to appear" in the sub-cycle component to capture fixed elements on the page, add component 15 "wait for element to appear" to capture the page element as "Please maintain ERP information", add component "process block" and set the remark name to determine whether it is For car purchase, add the component "if conditional loop" if the conditional expression exists_bool==true, add the component "for counting loop" and add a component "TryCatch exception handling" under the counting loop at the exception handling Add the component "click" in the try, and the clicked information is "Please maintain ERP information". After entering the maintenance page, add a new component "send hotkey" to capture the target as an internal order and fill in the hotkey in the blank space below as "Tap" to continue adding components" Send hotkey" without capture target, fill in the hotkey as "Delete". Add component "click" to capture click target to add modification, continue to add component "click" capture target to add "X" after the column number in the modified page, continue Add component "Click" to capture the target as OK. Add component "Process block" Add component 1 "String to remove spaces" in the process block component. The character to be processed is factory _arr[array_index], and the output is factory _arr[array_index]. Add Component 2 "Send Hotkey" Capture Target as "Factory" Send Hotkey as "Tap" Add Component 3 "Send Hotkey" Send Target as None, Send Hotkey as "Enter" Add Component 4 "Enter Text" Capture Target It is the input field next to the delivery method and location, the input text is "factory_arr[array_index]", add component 5 "send hotkey", the send target is None, and the send hotkey is "Enter", add component 6 "send hotkey" The sending target is the subject assignment category, the sending hotkey is "Tap", add component 7 "sending hotkey", the sending target is none, the sending hotkey is "Enter", add component 8 "if conditional judgment" if the conditional expression is "subject Category allocation reference _str=="_-(blank)"||Account category allocation reference_str=="K-Cost Center"" Otherwise, add the component "if condition judgment" if the conditional expression is "account allocation Reference _str=="A-asset"" Add component "click" capture target to "A-asset" in if. Otherwise, add the component "Click" to capture the target as "Q-Project Generate Order" and add the component "Input Text" to capture the target as the text box next to "Project/WBS" under the if condition, and the input text is "WBS element_arr [array_index]". Go back to the if process in component 8 "if conditional judgment" and add the component "if conditional judgment" if the conditional expression is "subject assignment reference_str=="_-blank"" Add component 1 under the if process and click "Capture target is _-blank, add component 2 "Input text" capture target is the input field next to project/WBS, input text is "WBS element_arr[array_index]" Add component 3 "Input text" capture target is internal order In the input field next to it, the input text is "work order number_arr[array_index]", otherwise, add component 1 under the process, "click" to capture the target as "K-cost center", add component 2 "process block", add it in the process block Component 1 "String to remove spaces" input value is "[General Ledger Account_arr[array_index],0]" Output value is "[General Ledger Account_arr[array_index]]" Add Component 2 "Send Hotkey" capture target is " General ledger account" send hotkey as "Tap" add component 3 "send hotkey" capture target is none, send hotkey as "Enter" add component 4 "input text" capture target is the input field next to the cost center, input text is "General ledger account_arr[array_index]" add component 5 "send hotkey" capture target is None, send hotkey is "Enter". Add Component "Process Block" under Component 5 "Send Hotkey" Add Component 1 "Send Hotkey" Capture Target as "Cost Center" Send Hotkey as "Tap" Add Component 2 "Send Hotkey" Capture to "Tap" The target is None, the sending hotkey is "Enter" Add component 3 "Input Text" The capture target is the input field next to "Asset Number", the input text is "Cost Center_arr[array_index]" Add component 4 "Send Hotkey" The capture target is None and the send hotkey is "Enter". Add the component "if condition judgment" under "if condition judgment #18" if the condition expression is "subject assignment reference_str=="A-asset" || Assign reference_str == "K-cost center"" Add component 1 "click" capture target as "add modification" add component 2 "string remove spaces" input value "[asset number_arr[array_index] in if ,3]" output value is [asset number _str], add component 3 "search string" input value is [asset number _str,string,",",0,ture,false], output value is "[result _num]", add component 4 "execution process" to execute the sub-process as "input asset number". Add component "process block" under the process of "if condition judgment #25" Add component 1 "string remove spaces" in the process block, the input value is "delivery location and method_arr[array_index], 0" output value is " Delivery place and method _arr[array_index]" add component 2 "string split" input value is "delivery place and method _arr[array_index],"-",999" output value is "delivery place and method_ arr". Add Component 3 "Send Hotkey" Capture Target as "Delivery Place and Method" Send Hotkey as "Tap" Add Component 4 "Send Hotkey" Capture Target as None, Send Hotkey as "Enter" Add Component 5 "Enter The capture target of "Text" is the input field on the right of "Date of arrival", and the input text is "Delivery location and method_arr[0]" Add component 6 "Send hotkey" The capture target is None, and the send hotkey is "Enter" . Add component "Process block" Add component 1 "String to remove spaces" in the process block Input value is "Purchasing group_arr[array_index],0" Output value is "Purchasing group_arr[array_index]" Add component 2 "Send "Hotkey" Capture Target is "Purchase Group" Send Hotkey as "Tap", Add Component 3 "Send Hotkey" Capture Target as None, Send Hotkey as "Enter" Add Component 4 "Enter Text" Capture Target as "Quantity "In the input field on the right, the input text is "purchasing group_arr[array_index]" Add component 5 "send hotkey" capture target is None, and send hotkey is "Enter". Add component "Process block" Add component 1 "Get current date & time" output value in process block "Current date_dat" Add component 2 "Date calculation" Input value "Current date_aat,+,day.28 "The output value is "Date of Arrival_dat" Add component 3 "Date Format" The input value is "Date of Arrival_dat,yyyy-mm-dd" The output value is "Date of Arrival_str". Add a new component under the process block "input text" capture target is "arrival date" input column on the right, input text is "arrival date_str", add component "click" capture target is "arrival date" add component" Enter the text "The capture target is the input column on the right side of "Quantity", and the input text is "Purchase Quantity_arr[array_index]" and add the component "break out of the loop". Add component 1 "judging whether the element exists" to capture the target as "adding to the purchase order" and add the variable "add purchase_bool" to the right whether it exists, and add component 2 "if condition judgment" if the conditional expression is "add purchase _bool==true" Add component 1 under the if process "for counting cycle" Add component 1 in the counting cycle component "click" capture target is "add to purchase order" add component 2 "judging whether the element exists" capture target Add the variable of "addition success_bool" to the right side for "add success", and add component 4 "if condition judgment" if the conditional expression is "add purchase success_bool==true". Add the component "break out of the loop" in the if process, and add component 1 "judging whether the element exists" in the otherwise process. The capture target is "display". The conditional expression is "prompt box_bool==true", add component 1 "click" capture target as "OK" in the if process, add component 2 "break out of the loop" in the if of "if condition judgment #467" The input value of the component "Variable Assignment" added under the process is ""Purchased"" and the output value is "New purchase requisition number_str".

请见图5,“备注”的流程为:引入参数结果_num和资产号_str,添加组件“if条件判断”如果的条件表达式为“结果_num==-1”在如果流程下添加组件“输入文本”捕获目标为“1”右侧输入栏,输入文本为“资产号_str”,添加组件“if条件判断”如果的条件表达式为“结果_num==-1”在如果流程下添加组件“输入文本”捕获目标为“1”右侧输入栏,输入文本为“资产号_str”,添加组件“if条件判断”如果的条件表达式为“结果_num==-1”在如果流程下添加组件“输入文本”捕获目标为“1”右侧输入栏,输入文本为“资产号_str”,在否则中添加组件1“字符串分割”输入值为“资产号_str,customize,","ture”输出值为“资产号_arr”,添加组件2“数组遍历”在右侧输入中数组为“资产号_arr”元素下标为array_index,数组元素为array_element。在数组遍历组件中添加组件1“输入文本”捕获目标为“2”右侧输入栏,输入文本为array_element。添加组件2“点击”捕获目标为“添加”,在“if条件判断#5”下添加组件“点击”捕获目标为确定。Please see Figure 5, the process of "remarks" is: introduce the parameters result_num and asset number_str, add the component "if condition judgment" if the conditional expression is "result_num==-1" and add it under the if process The component "input text" captures the target as "1" in the input field on the right, and the input text is "asset number_str", add the component "if condition judgment" if the conditional expression is "result_num==-1" in the if Add the component "input text" under the process to capture the target as "1" in the input column on the right, the input text is "asset number_str", add the component "if conditional judgment" if the conditional expression is "result_num==-1 Add the component "Input Text" under the process if the capture target is "1" in the right input column, and the input text is "asset number_str", otherwise add component 1 "string split" and the input value is "asset number_ The output value of str,customize,","ture" is "asset number _arr", add component 2 "array traversal" in the input on the right, the array is "asset number _arr", the subscript of the element is array_index, and the array element is array_element. Add component 1 "input text" to the array traversal component. The capture target is "2" in the input field on the right, and the input text is array_element. Add component 2 "click" capture target as "add", add component "click" capture target as OK under "if condition judgment #5".

请见图6,输入资产号”的流程为:引入参数array_index、申请表_excel、新请购单编号_str、请购单编号列号_str、工作表名称_str,添加组件1“写入单元格数据”右侧Excel文件对象为“申请表_excel”工作表为“工作表名称_str”单元格位置按行和列,行为“array_index+5”,列为“请购单编号列号_str”待写入数据为“新请购单编号_str”,添加组件2“保存Excel工作薄”右侧Excel文件对象为“申请表_excel”保存方式为原路径保存。Please see Figure 6, the process of inputting the asset number" is as follows: import parameters array_index, application form_excel, new purchase requisition number_str, purchase requisition number column number_str, worksheet name_str, add component 1 "write Enter cell data", the object of the Excel file on the right is "Application Form_excel", the worksheet is "Worksheet Name_str", the cell position is row and column, the row is "array_index+5", and the column is "Purchase Requisition Number Column" Number _str" to be written data is "new purchase requisition number _str", and the Excel file object on the right side of Add Component 2 "Save Excel Workbook" is "Application Form_excel" and the saving method is the original path.

本申请中,一种基于智能软件机器人进行电商采购的方法,具体实施方式为:In this application, a method for e-commerce procurement based on intelligent software robots, the specific implementation method is:

第一步:打开Cyclone Starter软件,添加第一项子流程文件“登陆电商平台”,在子流程文件中添加组件1,“打开浏览器”,并在其中设置需要打开的任意一种浏览器,浏览器为Cyclone或Chrome或IE或Firefox;在下方输入国网电商平台的网址继续添加组件2,“点击”通过模拟鼠标点击去点击国网电商平台登陆页面中用户名角色信息,按住Ctrl+左键进行定位;添加组件3,“点击”继续模拟鼠标点击去点击“采购用户”;添加组件4,“输入文本”在登陆页面的账号栏按住Ctrl+左键进行定位,定位完成后在组件下方输入需要登陆的账号信息;添加组件5,“输入文本”步骤与上一步一样,在组件下方输入登陆账号的密码信息;添加组件6,“OCR验证码识别”在登陆页面中验证码框按住Ctrl+左键进行定位并在右侧识别结果栏中设置一个String类型的变量;添加组件7,“输入文本”在验证码栏按住Ctrl+左键进行定位,定位完成后在组件下方输入上一步设置的变量信息;添加组件8,“点击”在登陆页面捕获登陆并按住Ctrl+左键进行定位;Step 1: Open the Cyclone Starter software, add the first sub-process file "login to the e-commerce platform", add component 1 in the sub-process file, "open browser", and set any browser that needs to be opened in it , the browser is Cyclone or Chrome or IE or Firefox; enter the URL of the State Grid e-commerce platform below to continue adding component 2, "click" to click on the username and role information on the State Grid e-commerce platform login page by simulating a mouse click, and press Press and hold Ctrl + left button to locate; add component 3, "click" to continue simulating mouse clicks to click on "purchase user"; add component 4, "input text" in the account column of the login page and hold down Ctrl + left button to locate, after the positioning is completed Enter the account information that needs to be logged in under the component; add component 5, the "input text" step is the same as the previous step, enter the password information of the login account under the component; add component 6, "OCR verification code recognition" verification code on the login page Hold down Ctrl+left button in the box to locate and set a variable of String type in the recognition result column on the right; add component 7, "input text" in the verification code bar and hold down Ctrl+left button to locate, after the positioning is completed, enter under the component The variable information set in the previous step; add component 8, "click" to capture the login on the login page and hold down Ctrl+left button to locate;

第二步:添加第二项子流程“提取列数据”添加组件1“查找获取位置和数据”在右侧输入栏中输入提前输入的参数信息(注:参数信息为提前储存好的其他子流程的变量值)在输出栏中输出目标单元格位置为“请购单编号行列_arr”的变量添加组件2“变量赋值”为请购单编号行列_arr赋值为一个String类型的变量值;添加组件3“读取行列数”在右侧输入栏中Excle文件对象中输入申请表_excel在工作表中输入工作表名称_str并选择“行”行号4,起始位置1,并输出读取结果为列头_arr;添加组件4和5“获取行列数”右侧输入与上一组件相同的输入信息,并输出获取为列数_num和行数_num的变量值;添加组件6“读取范围数据”右侧输入栏中输入组件4和5获取的行列位置并输出为申请表_dtb的变量值;添加组件6-19“提取列数据”在右侧输入数据表位置填写申请表_dtb并输出工厂_arr(后续提取数据表中的WBS元素、采购组、物料编码、供应商、采购数量、交货时间、交货地点及方式、收货人电话、资产号、成本中心、总账科目、工单号)并将这些设置为输出参数(输出类型为数组);Step 2: Add the second sub-process "Extract column data" Add component 1 "Find and obtain location and data" and enter the parameter information entered in advance in the input field on the right (Note: The parameter information is other sub-processes stored in advance variable value) in the output column, output the variable whose target cell position is "Purchase Requisition Number Rows and Columns_arr" Add component 2 "Variable Value Assignment" to assign a String type variable value to the purchase requisition number row and column _arr; add Component 3 "Read Rows and Columns" Enter the application form_excel in the Excel file object in the input column on the right, enter the worksheet name_str in the worksheet and select "row" row number 4, start position 1, and output the read Take the result as the column header _arr; add components 4 and 5 "get the number of rows and columns" and enter the same input information as the previous component on the right, and output the variable values obtained as column number_num and row number_num; add component 6 Input the row and column positions obtained by components 4 and 5 in the input column on the right of "read range data" and output it as the variable value of the application form _dtb; add component 6-19 "extract column data" and fill in the application at the input data table position on the right Table_dtb and output factory_arr (subsequent extraction of WBS elements in the data table, purchasing group, material code, supplier, purchasing quantity, delivery time, delivery place and method, consignee phone number, asset number, cost center , G/L account, work order number) and set these as output parameters (the output type is an array);

第三步:添加第三项子流程“二级专区”添加组件1“等待元素出现”(因:此流程链接第一项子流程)所以等待的元素是登陆成功后说显示的二级专区页面,同时按住Ctrl+左键来定位页面固定因素;添加组件2-3“点击”分别点击二级专区(各单位二级集中采购)和本单位物资选购;添加组件4“等待元素出现”按住Ctrl+左键捕获页面固定元素(防止页面卡顿导致Cyclone Starter报错);添加组件5-6“点击”按住Ctrl+左键捕获商品名称,然后捕获商品编码;添加组件7“获取目录下文件”右侧输入栏中打开电商请购表文件位置并输出为申请表名称;添加组件8“获取数组元素”获取申请表_arr的数据并输出为申请表名称_any;添加组件9“字符串查找”右侧输入中字符串输入为申请表名称_any,查找目标为“~$”,查找方式为支持通配符;添加组件10“if条件判断”在判断条件如果条件表达式中输入查找结果_num==-1;否则添加组件11“字符串分割”分割符为“$”且设置的最多保留项为“999”添加组件12“获取数组元素”右侧输入中数组输入为申请表名称_arr,目标元素下标为“1”,输出获取结果为申请表名称_any;添加组件13“字符串拼接”右侧输入字符串组为["D:\\RPA\\外部文件\\电商采购申请\\电商采购申请表\\",申请表表名称_any],输出字符串为申请表位置_str;添加组件14“打开Excel工作簿”,右侧输入文件路径为申请表位置_str,输出为申请表_excel;Step 3: Add the third sub-process "Second-level special area" Add component 1 "Wait for element to appear" (because: this process is linked to the first sub-process), so the waiting element is the second-level special area page displayed after successful login , hold down Ctrl + left button at the same time to locate the fixed factors on the page; add component 2-3 "click" to click on the second-level special area (secondary centralized procurement of each unit) and the unit's material purchase; add component 4 "wait for the element to appear" press Hold Ctrl + left button to capture fixed elements on the page (to prevent the page from being stuck and cause Cyclone Starter to report an error); add component 5-6 "click" and hold down Ctrl + left button to capture the product name, and then capture the product code; add component 7 "Get files under the directory" Open the file location of the e-commerce purchase requisition form in the input column on the right and output it as the name of the application form; add component 8 "get array element" to obtain the data of the application form _arr and output it as the name of the application form _any; add component 9 "string The character string input on the right side of "Find" is the name of the application form _any, the search target is "~$", and the search method supports wildcards; add component 10 "if condition judgment" and enter the search result_ in the judgment condition if condition expression num==-1; otherwise, add component 11 "String Separation" and the separator is "$" and set the maximum reserved items to "999". Add component 12 "Get Array Elements" and the array input in the input on the right is the name of the application form_ arr, the subscript of the target element is "1", and the output result is the name of the application form _any; the input string group on the right side of the added component 13 "string splicing" is ["D:\\RPA\\external file\\electricity Supplier purchase application\\e-commerce purchase application form\\", application form name_any], the output string is the application form location_str; add component 14 "open Excel workbook", the input file path on the right is the application form Position _str, the output is application form _excel;

添加组件“流程块”并设置名称为“Q-项目生成订单”;Add the component "Process Block" and set the name to "Q-Item Generate Order";

添加组件1“变量赋值”输入值为Q-项目生成订单,输出值为工作表_str,添加组件2“获取行列数”输入文件为申请表_excel,工作表为工作表名称_str,选择获取行数,指定列号为“G”输出结果为Q-行数_num;添加组件3“if条件判断”设置如果条件表达式为Q-行数_num==-1,在否则里添加组件4“执行流程”执行子流程“提取列数据”;添加组件5“获取数组长度”输入数组为物料编码_arr,输出数组长度为商品条数_num;添加组件6“数组遍历”输入遍历数组为物料编码_arr,元素下标为array_index,数组元素为array_element;在数组遍历组件内添加组件1“if条件判断”在如果判断条件表达式中填入array_element==""||array_element=="",同时在如果组件中添加组件“continue继续循环”;在数据遍历组件中的添加组件2“读取单元格数据”Excel文件对象为申请表_excel,工作表为工作表名称_str,设置单元格位置为按行和列,行为array_index+5,列为请购单编号列号_str,读取选项为显示值,输出读取结果为请购单编号_str;在数组遍历组件中添加组件3“if条件判断”如果条件表达式为请购单编号_str!=“已加购”,在否则中添加组件1“变量赋值”输入值为“Q-项目生成订单”输出变量名称为科目分配类别_str,添加组件2“变量赋值”输入值为“已加购”输出变量名称为判断条件_str;添加组件3“if条件判断”如果中的条件表达式为array_index<商品条数_num-1&&供应商_arr[array_index]==供应商_arr[array_index+1]&&工厂_arr[array_index]==工厂_arr[array_index+1]&&WBS元素_arr[array_index]==WBS元素_arr[array_index+1];条件满足时执行组件“变量赋值”输入值为“同下”输出变量名称为新请购单编号_str然后执行组件“continue继续循环”;条件不满足时,在否则中添加组件1“执行流程”执行子流程“新标签进入购物车”;在否则中添加组件2“执行流程”执行子流程“提交请购”;回到组件“数组遍历”中的组件第二个“if条件判断”组件,刚刚填写完如果条件表达式下的组件,现在填写否则下的组件;在否则中填写组件1“变量赋值”输入值为Q-项目生成订单,输出值为科目类别分配_str;添加组件2“if条件判断”如果条件表达式为array_index<商品条数_num-1,并在如果下继续添加组件“if条件判断”其中如果的条件表达式为:供应商_arr[array_index]==供应商_arr[array_index+1]&&工厂_arr[array_index]==工厂_arr[array_index+1]&&WBS元素_arr[array_index]==WBS元素_arr[array_index+1],并在如果下添加组件1“执行流程”执行子流程为“维护ERP信息并加购”;添加组件2“if条件判断”如果的条件表达式为“新请购单编号_str=="未查找到结果"”,在如果流程下添加组件1“执行流程”执行子流程为“备注”,添加组件2“continue继续循环”;在“if条件判断#655”下添加组件1“变量赋值”输入值为“同下”输出值为“新请购单编号_str”,添加组件2“点击”捕获目标为标签页的“x”,添加组件3“执行流程”执行子流程为“备注”;在“if条件判断#222”的否则流程中添加组件1“执行流程”执行子流程为“维护ERP信息并加购”,添加组件2“执行流程”执行子流程为“备注”;添加组件3“if条件判断”如果的条件表达式为“请购单编号_str==“未查找到结果””,在如果流程中添加组件“continue继续循环”;跳出“if条件判断#650”,在下添加组件1“执行流程”执行子流程为“提交请购”,添加组件2“执行流程”执行子流程为“备注”;在“if条件判断#222”否则流程下添加组件1“执行流程”执行子流程为“维护ERP信息并加购”,添加组件2“执行流程”执行子流程为“备注”,添加组件3“if条件判断”如果的条件表达式为“请购单编号_str==“未查找到结果””,在否则中添加组件1“执行流程”执行子流程为“提交请购”,添加组件2“执行流程”执行子流程为“备注”;Add component 1 "Variable Assignment" input value is Q-item to generate order, output value is worksheet_str, add component 2 "get the number of rows and columns" input file is application form _excel, worksheet is worksheet name _str, select Get the number of rows, specify the column number as "G" and output the result as Q-number of rows_num; add component 3 "if condition judgment" to set if the conditional expression is Q-number of rows_num==-1, otherwise add it Component 4 "execute process" executes sub-process "extract column data"; add component 5 "get array length" input array is material code_arr, output array length is item number_num; add component 6 "array traversal" input traversal The array is the material code _arr, the subscript of the element is array_index, and the array element is array_element; Add component 1 "if condition judgment" in the array traversal component and fill in array_element=""||array_element== in the if judgment condition expression "", at the same time, add the component "continue to continue looping" in the if component; add component 2 "read cell data" in the data traversal component. The object of the Excel file is the application form_excel, and the worksheet is the worksheet name_str, Set the cell position to be by row and column, the row is array_index+5, the column is the purchase requisition number column number _str, the read option is the display value, and the output read result is the purchase requisition number _str; in the array traversal component Add component 3 "if conditional judgment" if the conditional expression is purchase requisition number _str! = "Purchased", otherwise add component 1 "Variable Assignment" input value "Q-Item Generate Order" output variable name is account assignment category_str, add component 2 "Variable Assignment" input value "Added Purchase" output variable name is judgment condition_str; add component 3 "if condition judgment" if the conditional expression in is array_index<commodity number_num-1&&supplier_arr[array_index]==supplier_arr[array_index] +1]&&factory_arr[array_index]==factory_arr[array_index+1]&&WBS element_arr[array_index]==WBS element_arr[array_index+1]; when the condition is met, execute the component "variable assignment" input value The output variable name for "same below" is the new purchase requisition number _str and then execute the component "continue to continue the loop"; if the condition is not met, add component 1 "execute process" to execute the sub-process "new label enters the shopping cart" otherwise ; Otherwise, add component 2 "execution process" to execute the sub-process "submit purchase requisition"; return to the component "array traversal" in the second "if condition judgment" component, just fill in the components under the if condition expression , now fill in the components under otherwise; fill in component 1 "Variable Assignment" in Otherwise, the input value is Q-item to generate an order, and the output value is account category assignment_str; add component 2 "if conditional judgment" if the conditional expression is array_index <Number of items_num-1, and continue to add the component "if condition judgment" under if, where the condition expression of if is: supplier_arr[array_index]==supplier_arr[array_index+1]&&factory_ arr[array_index]==factory_arr[array_index+1]&&WBS element_arr[array_index]==WBS element_arr[array_index+1], and add component 1 "execution process" under "maintenance" Add Component 2 "if Condition Judgment" if the conditional expression is "new purchase requisition number_str = "no result found"", add component 1 "execution process" under the if process Execute the sub-process as "remarks", add component 2 "continue to continue looping"; add component 1 "variable assignment" under "if condition judgment #655", the input value is "same as below", the output value is "new purchase requisition number_ str", add component 2 "click" to capture the target as "x" of the label page, add component 3 "execution process" and execute sub-process as "remarks"; add component 1 in the otherwise process of "if condition judgment #222" The execution sub-process of "execution process" is "maintain ERP information and add purchase", add component 2 "execution process" and the execution sub-process is "remarks"; add component 3 "if condition judgment" if the conditional expression is "purchase order number _str== "No result found"", add component "continue to continue loop" in the if process; jump out of "if condition judgment #650", add component 1 "execute process" and execute the sub-process as "submit purchase requisition" , add component 2 "execution process" and execute the sub-process as "remarks"; add component 1 "execution process" under the "if condition judgment #222" otherwise process, add component 1 "execution process" and execute the sub-process as "maintain ERP information and add purchase", add component 2 "Execution process" executes the sub-process as "remarks", add component 3 "if condition judgment" if the conditional expression is "requisition number_str=="no result found"", otherwise add component 1" The execution sub-process of "Execution Process" is "Submit Purchase Requisition", and the execution sub-process of Add Component 2 "Execution Process" is "Remarks";

后续新增流程块_-空白、A-资产、K-成本中心中除组件“变量赋值”与“获取行列数”需修改以外其余与Q-项目生成订单基本一致;(流程块_-空白的变量赋值修改为_-(空白)二级,获取行列数中的指定列号为“E”,输出为空白_行数_num;流程块A-资产的变量赋值修改为A-资产二级,获取行列数中指定列号为“G”,输出为A_行数_num。流程块K-成本中心的变量赋值修改为K-成本中心二级,获取行列数中指定列号为“F”,输出为A_行数_num);二级专区数据处理完后,通过组件1“点击”捕获目标为左上角国家电商电子商务平台;添加组件2“等待元素出现”捕获目标为“专区首页”,添加组件3“点击”捕获目标为“商品名称”,添加组件4“点击”捕获目标为“商品编号”;添加组件5“输入文本”捕获目标为“商品编号”右侧输入栏,输入文本为“1”;添加组件6“点击”捕获目标为“搜索”;添加组件7“获取目录下文件”右侧输入栏中打开电商请购表文件位置并输出为申请表名称;添加组件8“获取数组元素”在右侧输入中数组栏输入“申请表名称_arr”,查找元素下表为0,并输出为申请表名称_any;添加组件9“字符串查找”右侧输入中字符串输入为申请表名称_any,查找目标为“~$”,查找方式为支持通配符;添加组件10“字符串拼接”输入值为"D:\\RPA\\外部文件\\电商采购申请\\电商采购申请表\\",申请表表名称_any输出值为“申请表位置_str”。添加组件11“打开工作薄”右侧输入的文件路径为“申请表位置_str”,输出为“申请表_excel”。Subsequent newly added process blocks_-blank, A-assets, K-cost centers are basically consistent with the Q-project generation order except for the components "variable assignment" and "obtaining the number of rows and columns" that need to be modified; (process block_-blank Modify the variable assignment to _-(blank) level 2, get the specified column number in the number of rows and columns as "E", and output it as blank_number of rows_num; modify the variable assignment of process block A-asset to A-asset level 2, The specified column number in Get Rows and Columns is "G", and the output is A_Number of Rows_num. The variable assignment of process block K-Cost Center is changed to K-Cost Center Level 2, and the specified column number in Get Rows and Columns is "F" , the output is A_number of rows_num); after the data processing of the secondary special area, the capture target through component 1 "click" is the national e-commerce e-commerce platform in the upper left corner; add component 2 "wait for the element to appear" to capture the target as "special area Homepage", add component 3 "click" to capture the target as "product name", add component 4 "click" to capture the target as "product number"; add component 5 "input text" to capture the target as "product number" in the right input column, The input text is "1"; add component 6 "click" to capture the target as "search"; add component 7 "get files under the directory" to open the file location of the e-commerce purchase requisition form in the right input column and output it as the name of the application form; add Component 8 "Get Array Elements" enter "Application Form Name_arr" in the array column on the right side of the input, find the following table of elements as 0, and output it as Application Form Name_any; add component 9 "String Search" to the right input The character string input in middle is the name of the application form _any, the search target is "~$", and the search method supports wildcards; add component 10 "string splicing" and the input value is "D:\\RPA\\external file\\e-commerce Purchasing application\\e-commerce procurement application form\\", the output value of the application form name_any is "application form location_str". The file path input on the right side of Add Component 11 "Open Workbook" is "Application Form Position_str", and the output is "Application Form_excel".

一级专区流程块中流程与二级专区大致相同,在Q-项目生成订单流程块组件中的第一个组件“变量赋值”中需将“二级”更改为“一级”。The process in the process block of the first-level special area is roughly the same as that of the second-level special area. In the first component "variable assignment" in the Q-project generation order process block component, "secondary" needs to be changed to "first level".

本申请具有以下主要有益技术效果:通过智能机器人来识别电商页面并自动进行操作,极大地解决了人工错误率高且需要进行的工作时间较长的问题,而且能够7*24小时运作,通过模拟业务人员在国网电商平台的操作、图像二维码识别和表格记录等行为,代替人工进行简单重复操作,处理量大易错环节,将原先10分钟完成的订单流程缩短到2-3分钟完成一个,准确率保持100%,单个物料处理率提高了80%以上。The application has the following main beneficial technical effects: the intelligent robot is used to identify the e-commerce page and automatically operate it, which greatly solves the problems of high manual error rate and long working hours, and can operate 7*24 hours, through Simulate the operations of business personnel on the State Grid e-commerce platform, image QR code recognition and form recording, etc., instead of manual simple and repetitive operations, with a large amount of processing and error-prone links, shortening the order process that was originally completed in 10 minutes to 2-3 Complete one in minutes, the accuracy rate remains 100%, and the processing rate of a single material has increased by more than 80%.

本申请中,预先生成电商请购表及外部参数表,通过RPA软件下载及授权,再实现RPA采购流程开发和发布(或者说规划),RPA将预先生成的数据入内部变量中,RPA读取/释放内部变量中数据,并从国网电商平台进行页面数据抓取,并调用流程,并提高单个请购交,通过判断条件和循环条件与数组遍历条件实现全部的采购;减少了人员的参与,而且精确、快速。In this application, the e-commerce purchase requisition form and external parameter table are pre-generated, downloaded and authorized by RPA software, and then the development and release (or planning) of the RPA procurement process is realized. RPA puts the pre-generated data into internal variables, and RPA reads Fetch/release the data in the internal variables, and grab the page data from the State Grid e-commerce platform, and call the process, and improve the single purchase requisition, and realize all the purchases by judging conditions, loop conditions and array traversal conditions; reducing personnel Participation, and accurate, fast.

上述的实施例仅为本发明的优选技术方案,而不应视为对于本发明的限制。本发明的保护范围应以权利要求记载的技术方案,包括权利要求记载的技术方案中技术特征的等同替换方案为保护范围。即在此范围内的等同替换改进,也在本发明的保护范围之内。The above-mentioned embodiments are only preferred technical solutions of the present invention, and should not be regarded as limitations on the present invention. The scope of protection of the present invention shall be the technical solution described in the claims, including equivalent replacements for the technical features in the technical solution described in the claims. That is, equivalent replacement and improvement within this range are also within the protection scope of the present invention.

Claims (8)

1.一种基于智能机器人进行电商采购的方法,其特征在于:所述的采购方法包含有依次进行的以下步骤:1. A method for carrying out electricity supplier procurement based on an intelligent robot, characterized in that: the procurement method includes the following steps carried out in sequence: 第一步:预先生成电商请购表及外部参数表,其中,电商请购表用于请购物料信息,外部参数表用于储存网页信息和账号密码信息;Step 1: Pre-generate the e-commerce purchase requisition form and external parameter table, wherein the e-commerce purchase requisition form is used to requisition material information, and the external parameter table is used to store webpage information and account password information; 第二步:进行RPA软件下载及授权;Step 2: Download and authorize the RPA software; 第三步:下载完成并获取授权后进入Cyclone Starter软件进行流程开发和发布;所述流程开发和发布是指添加流程块;Step 3: After downloading and obtaining authorization, enter the Cyclone Starter software for process development and release; the process development and release refers to adding process blocks; 第四步:通过Cyclone Starter软件读取之前配置好的电商请购表与外部参数表中的数据,并将其中的信息储存在Cyclone Starter软件内部变量中;Step 4: Read the data in the previously configured e-commerce purchase requisition table and external parameter table through the Cyclone Starter software, and store the information in the internal variables of the Cyclone Starter software; 第五步:打开国网电商平台,并通过Cyclone Starter软件内部的组件进行页面数据抓取;Cyclone Starter识别页面信息并捕获输入账号密码栏,将提前储存好的变量信息自动输入,然后添加验证码自动识别,自动识别验证码并点击登陆;当成功登陆页面加载出时,继续添加循环流程和条件判断流程;当登陆成功时则跳出循环登陆,不成功时则继续循环登陆;调用第三步的流程;当物料信息存在时则进入物料请购页面,且通过读取请购表中的需求信息,把读取到的信息填入需求板块中,然后点击提交请购;提交请购完成后,进入购物车中,通过读取数据表中的地址信息数据将其填入对应的信息位置;Step 5: Open the State Grid e-commerce platform, and capture the page data through the components inside the Cyclone Starter software; Cyclone Starter identifies the page information and captures the input account password column, automatically enters the variable information stored in advance, and then adds verification Code automatic identification, automatic identification of the verification code and click to log in; when the successful login page is loaded, continue to add the loop process and condition judgment process; When the material information exists, enter the material requisition page, and fill in the read information in the demand section by reading the demand information in the purchase requisition form, and then click Submit Purchase Requisition; after submitting the purchase requisition , enter the shopping cart, and fill in the corresponding information position by reading the address information data in the data table; 第六步:通过判断条件和循环条件与数组遍历条件,Cyclone Starter软件将内部变量中的信息一一去提交请购,循环判断电商请购表中的数据是否存在不存在则退出页面并关闭所有程序;完成采购。Step 6: Through the judgment condition, loop condition and array traversal condition, the Cyclone Starter software submits the information in the internal variables one by one to submit the purchase requisition, and loops to judge whether the data in the e-commerce purchase requisition table exists or not, then exits the page and closes All procedures; complete purchase. 2.根据权利要求1所述的一种基于智能机器人进行电商采购的方法,其特征在于:第三步中添加的流程块包含有:“新标签进入购物车”子流程、“维护ERP信息并加购”的流程、“备注”的流程、“输入资产号”的流程。2. A method for purchasing e-commerce based on intelligent robots according to claim 1, characterized in that: the process blocks added in the third step include: "new label enters the shopping cart" sub-process, "maintain ERP information Merge and purchase" process, "remarks" process, and "input asset number" process. 3.根据权利要求2所述的一种基于智能机器人进行电商采购的方法,其特征在于:添加子流程“新标签进入购物车”的方法为:在子流程中添加组件1“鼠标悬停”悬停位置如下,添加组件2“点击”按住Ctrl+左键捕获“去购物车结算”文字同时在组件下方设置右键点击;添加组件3“点击”按住Ctrl+左键捕获“在新标签页中打开文本”,添加组件4“点击”捕获目标为下图新标签页。3. A method for purchasing e-commerce based on an intelligent robot according to claim 2, characterized in that: the method of adding the sub-process "new label enters the shopping cart" is: adding component 1 "mouse-over" in the sub-process "Hover position is as follows, add component 2 "click" and hold down Ctrl + left button to capture the text "go to shopping cart checkout" and set right click under the component; add component 3 "click" and hold down Ctrl + left button to capture" in the new tab page Open text in ", add component 4 "click" to capture the target as the new tab page in the figure below. 4.根据权利要求2所述的一种基于智能机器人进行电商采购的方法,其特征在于:“维护ERP信息并加购”的流程为:添加组件1“变量赋值”右侧输入值为科目类别分配_str,输出值为科目分配引用_str,添加组件2“输入文本”按住Ctrl+左键捕获电商平台商品编号输入栏,下侧输入信息为array_element;继续添加组件3“点击”捕获页面元素中的搜索元素,添加组件4“判断元素是否存在”判断元素为搜索商品编码后是否出现“关于商品编号*没有搜到相关结果”如果条件表达式为“没有结果_bool==ture”在否则中添加组件“brake跳出循环”,添加组件5“for计次循环“在计次循环组件组件中添加组件6“等待元素出现"捕获一个页面固定元素,添加组件7“鼠标悬停"同样按住Ctrl+左键捕获一个页面固定元素;添加组件8“判断元素是否存在"捕获页面元素为"没有搜到相关结果"并在右侧储存为一个布尔的变量值;添加组件9"if条件判断"如果的条件表达公式为没有结果_bool==ture在如果下方添加组件10"点击"捕获的页面元素为搜索;在否则下添加组件"break跳出循环",添加组件11"if条件判断"如果下的条件表达式为没有结果_bool==ture;在如果下添加组件12"变量赋值"输入值为"未查找到结果"输出值为"新请购单编号_str";在否则处添加组件13"for计次循环"在计次循环组件中添加组件14"等待元素出现"捕获页面固定元素,添加组件15"等待元素出现"捕获的页面元素为"请维护ERP信息",添加组件"流程块"设置备注名称为判断是否为汽车采购,添加组件"if条件循环"如果的条件表达式为存在_bool==ture,添加组件"for计次循环"同时在计次循环下新增一个组件"TryCatch异常处理"在异常处理的try中添加组件“点击”点击的信息为“请维护ERP信息”进入维护页面后新增组件“发送热键”捕获目标为内部订单并在下方空白处填写热键为“Tap”继续添加组件“发送热键”无捕获目标,填写热键为“Delete”;添加组件“点击”捕获点击目标为添加修改,继续添加组件“点击”捕获目标为添加修改页面当中的列号后“X”,继续添加组件“点击”捕获目标为确定;添加组件“流程块”在流程块组件中添加组件1“字符串去空格”待处理字符为工厂_arr[array_index],输出为工厂_arr[array_index];添加组件2“发送热键”捕获目标为“工厂”发送热键为“Tap”添加组件3“发送热键”发送目标为无,发送热键为“Enter”添加组件4“输入文本”捕获目标为交货方式及地点旁的输入栏,输入文本为“工厂_arr[array_index]”添加组件5“发送热键”发送目标为无,发送热键为“Enter”添加组件6“发送热键”发送目标为科目分配类别,发送热键为“Tap”添加组件7“发送热键”发送目标为无,发送热键为“Enter”添加组件8“if条件判断”如果的条件表达式为“科目类别分配引用_str=="_-(空白)"||科目类别分配引用_str=="K-成本中心"”在否则处添加组件“if条件判断”如果的条件表达式为“科目分配引用_str=="A-资产"”在如果中添加组件“点击”捕获目标为“A-资产”;在否则中添加组件“点击”捕获目标为“Q-项目生成订单”在if条件判断下添加组件“输入文本”捕获目标为“项目/WBS”旁的文本框,输入文本为“WBS元素_arr[array_index]”;回到组件8“if条件判断”中的如果流程中添加组件“if条件判断”如果的条件表达式为“科目分配引用_str=="_-空白"”在如果流程下添加组件1“点击”捕获目标为_-空白,添加组件2“输入文本”捕获目标为项目/WBS旁的输入栏,输入文本为“WBS元素_arr[array_index]”添加组件3“输入文本”捕获目标为内部订单旁的输入栏,输入文本为“工单号_arr[array_index]”在否则流程下添加组件1“点击”捕获目标为“K-成本中心”添加组件2“流程块”在流程块中天添加组件1“字符串去空格”输入值为“[总账科目_arr[array_index],0]”输出值为“[总账科目_arr[array_index]]”添加组件2“发送热键”捕获目标为“总账科目”发送热键为“Tap”添加组件3“发送热键”捕获目标为无,发送热键为“Enter”添加组件4“输入文本”捕获目标为成本中心旁的输入栏,输入文本为“总账科目_arr[array_index]”添加组件5“发送热键”捕获目标为无,发送热键为“Enter”;在组件5“发送热键”下添加组件“流程块”在流程块中添加组件1“发送热键”捕获目标为“成本中心”发送热键为“Tap”添加组件2“发送热键”捕获目标为无,发送热键为”Enter”添加组件3“输入文本”捕获目标为“资产号”旁的输入栏,输入文本为“成本中心_arr[array_index]”添加组件4“发送热键”捕获目标为无,发送热键为“Enter”;在“if条件判断#18”下添加组件“if条件判断”如果的条件表达式为“科目分配引用_str==“A-资产”||科目分配引用_str==“空白”||科目分配引用_str==“K-成本中心””在如果中添加组件1“点击”捕获目标为“添加修改”添加组件2“字符串去空格”输入值为“[资产号_arr[array_index],3]”输出值为[资产号_str],添加组件3“查找字符串”输入值为[资产号_str,string,",",0,ture,false],输出值为“[结果_num]”,添加组件4“执行流程”执行子流程为“输入资产号”;在“if条件判断#25”流程下添加组件“流程块”在流程块中添加组件1“字符串去空格”输入值为“交货地点及方式_arr[array_index],0”输出值为“交货地点及方式_arr[array_index]”添加组件2“字符串分割”输入值为“交货地点及方式_arr[array_index],"-",999”输出值为“交货地点及方式_arr”;添加组件3“发送热键”捕获目标为“交货地点及方式”发送热键为“Tap”添加组件4“发送热键”捕获目标为无,发送热键为“Enter”添加组件5“输入文本”捕获目标为“到货日期”右侧输入栏,输入文本为“交货地点及方式_arr[0]”添加组件6“发送热键”捕获目标为无,发送热键为“Enter”;添加组件“流程块”在流程块中添加组件1“字符串去空格”输入值为“采购组_arr[array_index],0”输出值为“采购组_arr[array_index]”添加组件2“发送热键”捕获目标为“采购组”发送热键为“Tap”,添加组件3“发送热键”捕获目标为无,发送热键为“Enter”添加组件4“输入文本”捕获目标为“数量”右侧输入栏,输入文本为“采购组_arr[array_index]”添加组件5“发送热键”捕获目标为无,发送热键为“Enter”;添加组件“流程块”在流程块中添加组件1“获取当前日期&时间”输出值为“当前日期_dat”添加组件2“日期计算”输入值为“当前日期_aat,+,day.28”输出值为“到货日期_dat”添加组件3“格式化日期”输入值为“到货日期_dat,yyyy-mm-dd”输出值为“到货日期_str”;流程块下添加新组件“输入文本”捕获目标为“到货日期”右侧输入栏,输入文本为“到货日期_str”,添加组件“点击”捕获目标为“到货日期”添加组件“输入文本”捕获目标为“数量”右侧输入栏,输入文本为“采购数量_arr[array_index]”添加组件“break跳出循环”;添加组件1“判断元素是否存在”捕获目标为“加入进货单”在右侧是否存在中添加“加购_bool”的变量,添加组件2“if条件判断”如果的条件表达式为“加购_bool==ture”在如果流程下添加组件1“for计次循环”在计次循环组件中添加组件1“点击”捕获目标为“加入进货单”添加组件2“判断元素是否存在”捕获目标为“添加成功”在右侧添加“加购成功_bool”的变量,添加组件4“if条件判断”如果的条件表达式为“加购成功_bool==ture”;在如果流程中添加组件“break跳出循环”,在否则流程下添加组件1“判断元素是否存在”捕获目标为“显示”新增变量为“提示框_bool”添加组件2“if条件判断”如果的条件表达式为“提示框_bool==ture”,在如果流程中添加组件1“点击”捕获目标为“确定”,添加组件2“break跳出循环”在“if条件判断#467”的如果流程下添加组件“变量赋值”输入值为““已加购””输出值为“新请购单编号_str”。4. A kind of method for carrying out e-commerce procurement based on intelligent robot according to claim 2, characterized in that: the flow process of "maintaining ERP information and adding purchase" is: add component 1 "variable assignment" right input value is subject Category allocation_str, the output value is subject allocation reference_str, add component 2 "input text", hold down Ctrl + left button to capture the item number input column of the e-commerce platform, and the input information on the lower side is array_element; continue to add component 3 "click" to capture For the search element in the page element, add component 4 "judging whether the element exists" to judge whether the element appears after the code of the searched product "About the product number * no relevant results were found" if the conditional expression is "no result_bool==ture" Otherwise, add the component "brake jump out of the loop", add component 5 "for counting cycle", add component 6 "wait for the element to appear" in the counting cycle component component to capture a fixed element on the page, add component 7 "mouse hover" as well Press and hold Ctrl + left button to capture a fixed element on the page; add component 8 "judging whether the element exists" to capture the page element as "no relevant results found" and store it as a Boolean variable value on the right; add component 9 "if conditional judgment "If the conditional expression formula has no result_bool==ture, add component 10 below if" click" to capture the page element as search; otherwise add component "break out of the loop" and add component 11 "if condition judgment" if The conditional expression below is no result_bool==true; add component 12 "Variable Assignment" input value "no result found" output value "new purchase requisition number_str" under if; otherwise add Component 13 "for counting cycle" Add component 14 "wait for element to appear" to capture page fixed element, add component 15 "wait for element to appear" to capture page element as "please maintain ERP information", add component" Set the remark name of the "process block" to judge whether it is a car purchase, add the component "if conditional loop" if the conditional expression exists_bool==true, add the component "for counting cycle" and add a new one under the counting cycle The component "TryCatch Exception Handling" adds the component "Click" to the try of exception handling, and the information clicked is "Please maintain ERP information". After entering the maintenance page, add the component "Send Hotkey" to capture the target as an internal order and fill in the blank space below The hotkey is "Tap" and continue to add the component "Send Hotkey" without capture target, fill in the hotkey as "Delete"; add the component "Click" to capture the click target to add and modify, continue to add the component "Click" to capture the target to add and modify the page After the column number "X", continue to add the component "click" to capture the target as OK; add the component "process block" to the process block component and add component 1 "string to remove spaces" and the character to be processed is the factory_arr[array_index] , output is factory_arr[array_index]; add component 2 "send hotkey" capture target as "Factory" send hotkey as "Tap" add component 3 "send hotkey" send target as None, send hotkey as "Enter "Add Component 4 "Input Text" to capture the target as the input field next to the delivery method and location, and the input text is "factory_arr[array_index]" Add Component 5 "Send Hotkey" to send the target to None, and to send the hotkey to " "Enter" add component 6 "send hotkey" send target as subject assignment category, send hotkey as "Tap" add component 7 "send hotkey" send target as None, send hotkey as "Enter" add component 8 "if condition Judgment "if the conditional expression is "subject category assignment reference_str=="_-(blank)"||subject category assignment reference_str=="K-cost center"", otherwise add the component "if condition judgment "If the conditional expression is "Account Assignment Reference_str=="A-Asset"" add the component "click" capture target to "A-asset" in if; otherwise add the component "click" capture target to " Q-Project Generate Order" add the component "Input Text" under the judgment of the if condition to capture the target as the text box next to "Project/WBS", and the input text is "WBS element_arr[array_index]"; return to component 8 "if condition Add the component "if condition judgment" in the "Judgement" process if the conditional expression is "subject assignment reference_str="_-blank"" Add component 1 under the if process "click" to capture the target as _-blank , add component 2 "input text" capture target is the input column next to the project/WBS, input text is "WBS element_arr[array_index]" add component 3 "input text" capture target is the input column next to the internal order, input text For "work order number_arr[array_index]", add component 1 "click" capture target for "K-Cost Center" add component 2 "process block" in the process block add component 1 "string to remove spaces "Input value is "[General Ledger Account_arr[array_index],0]" Output value is "[General Ledger Account_arr[array_index]]" Add component 2 "Send hotkey" Capture target is "General Ledger account" Send hotkey as "Tap" add component 3 "send hotkey" capture target is none, send hotkey as "Enter" add component 4 "input text" capture target is the input field next to the cost center, input text is "general ledger account_arr[array_index ]" add component 5 "send hotkey" capture target as None, send hotkey as "Enter"; add component "process block" under component 5 "send hotkey" add component 1 "send hotkey" in the process block Capture Target is "Cost Center" Send Hotkey as "Tap" Add Component 2 "Send Hotkey" Capture Target is None, Send Hotkey as "Enter" Add Component 3 "Enter Text" Capture Target is next to "Asset Number" In the input field, the input text is "cost center_arr[array_index]" Add component 4 "Send hotkey" capture target is None, send hotkey is "Enter"; add component "if condition" under "if condition judgment #18" Judgment" If the conditional expression is "Account Allocation Reference_str == "A-Asset"||Account Allocation Reference_str == "Blank" ||Account Allocation Reference_str = "K-Cost Center"" in If add component 1 "click" capture target is "add modification" add component 2 "string remove spaces" input value is "[asset number_arr[array_index],3]" output value is [asset number_str], Add component 3 "search string" input value is [asset number_str,string,",",0,ture,false], output value is "[result_num]", add component 4 "execution process" execution child The process is "input asset number"; add the component "process block" under the "if condition judgment #25" process, add component 1 "string remove spaces" in the process block, and the input value is "delivery location and method_arr[array_index ],0" output value is "delivery location and method_arr[array_index]" add component 2 "string split" input value is "delivery location and method_arr[array_index],"-",999" output value For "delivery location and method_arr"; add component 3 "send hotkey" capture target as "delivery location and method" send hotkey as "Tap" add component 4 "send hotkey" capture target as none, send The hotkey is "Enter" Add component 5 "Input text" capture target is "arrival date" right input column, input text is "delivery place and method_arr[0]" Add component 6 "Send hotkey" capture The target is None, and the sending hotkey is "Enter"; Add component "Process Block" Add component 1 in the process block "String despace" input value is "purchasing group_arr[array_index], 0" output value is "purchasing group_arr[array_index]" add component 2 "send hotkey" capture target as "Purchase group" send hotkey as "Tap", add component 3 "send hotkey" capture target as None, send hotkey as "Enter" Add component 4 "input text" to capture the target as "quantity" in the input field on the right, input text as "purchasing_group_arr[array_index]" add component 5 "send hotkey" capture target to None, send hotkey to "Enter" ;Add component "process block" Add component 1 "get current date & time" output value "current date_dat" in the process block Add component 2 "date calculation" input value "current date_aat,+,day. 28" output value is "arrival date_dat" add component 3 "formatted date" input value is "arrival date_dat,yyyy-mm-dd" output value is "arrival date_str"; process block Add a new component "Input Text" to capture the target as the input field on the right of "Date of Arrival", input the text as "Date of Arrival_str", add a component "Click" to capture the target as "Date of Arrival" Add a component "Input Text" The capture target is the input field on the right side of "Quantity", and the input text is "Purchase Quantity_arr[array_index]", add the component "break out of the loop"; add component 1 "judging whether the element exists" and the capture target is "Add to the purchase order" on the right Add the variable of "add_purchase_bool" in whether the side exists, add component 2 "if condition judgment" if the conditional expression is "add_purchase_bool==true", add component 1 "for counting cycle" under the if process Add component 1 "Click" to the counting loop component to capture the target as "add to the purchase order" add component 2 "judging whether the element exists" capture target to "add successfully" and add the variable "add_success_bool" to the right, Add component 4 "if conditional judgment" if the conditional expression is "purchase success_bool==true"; add component "break out of the loop" in the if process, and add component 1 "judging whether the element exists" in the otherwise process The capture target is "display", the new variable is "prompt box_bool", add component 2 "if condition judgment", if the conditional expression is "prompt box_bool==true", add component 1 "click" in the if process The capture target is "OK", add component 2 "break out of the loop" and add the component "variable assignment" under the if process of "if condition judgment #467", the input value is ""added purchase"" and the output value is "new purchase requisition" single number_str'. 5.根据权利要求2所述的一种基于智能机器人进行电商采购的方法,其特征在于:“备注”的流程为:引入参数结果_num和资产号_str,添加组件“if条件判断”如果的条件表达式为“结果_num==-1”在如果流程下添加组件“输入文本”捕获目标为“1”右侧输入栏,输入文本为“资产号_str”,添加组件“if条件判断”如果的条件表达式为“结果_num==-1”在如果流程下添加组件“输入文本”捕获目标为“1”右侧输入栏,输入文本为“资产号_str”,添加组件“if条件判断”如果的条件表达式为“结果_num==-1”在如果流程下添加组件“输入文本”捕获目标为“1”右侧输入栏,输入文本为“资产号_str”,在否则中添加组件1“字符串分割”输入值为“资产号_str,customize,","ture”输出值为“资产号_arr”,添加组件2“数组遍历”在右侧输入中数组为“资产号_arr”元素下标为array_index,数组元素为array_element;在数组遍历组件中添加组件1“输入文本”捕获目标为“2”右侧输入栏,输入文本为array_element;添加组件2“点击”捕获目标为“添加”,在“if条件判断#5”下添加组件“点击”捕获目标为确定。5. A method for e-commerce procurement based on intelligent robots according to claim 2, characterized in that: the process of "remarks" is: import parameter result_num and asset number_str, and add component "if condition judgment" If the conditional expression is "result_num==-1", add the component "input text" under the if process to capture the target as "1" in the input column on the right, the input text is "asset number_str", add the component "if Condition Judgment" If the conditional expression is "result_num==-1", add the component "input text" under the if process to capture the target as "1" in the input field on the right, and the input text is "asset number_str", add Component "if conditional judgment" If the conditional expression is "result_num==-1", add the component "input text" under the if process to capture the target as "1" in the right input column, and the input text is "asset number_str ", otherwise add component 1 "string segmentation" input value "asset number_str,customize,","ture" output value is "asset number_arr", add component 2 "array traversal" input on the right The array in the center is "asset number_arr", the element subscript is array_index, and the array element is array_element; add component 1 "input text" to the array traversal component, and the capture target is "2" in the right input column, and the input text is array_element; add the component 2 The "click" capture target is "Add", and the component "click" capture target is OK under the "if condition judgment #5". 6.根据权利要求2所述的一种基于智能机器人进行电商采购的方法,其特征在于:“输入资产号”的流程为:引入参数array_index、申请表_excel、新请购单编号_str、请购单编号列号_str、工作表名称_str,添加组件1“写入单元格数据”右侧Excel文件对象为“申请表_excel”工作表为“工作表名称_str”单元格位置按行和列,行为“array_index+5”,列为“请购单编号列号_str”待写入数据为“新请购单编号_str”,添加组件2“保存Excel工作薄”右侧Excel文件对象为“申请表_excel”保存方式为原路径保存。6. A method for e-commerce procurement based on intelligent robots according to claim 2, characterized in that: the process of "inputting the asset number" is: introducing parameters array_index, application form_excel, new purchase requisition number_str , Purchase requisition number column number _str, worksheet name _str, add component 1 "write cell data" right side Excel file object is "application form_excel" worksheet is "worksheet name_str" cell The position is by row and column, the row is "array_index+5", the column is "Purchase Requisition No. Column No._str", the data to be written is "New Purchase Requisition No._str", add component 2 "Save Excel Workbook" to the right The object of the Excel file on the side is "Application Form_excel" and the saving method is the original path. 7.一种用于基于智能机器人进行电商采购的“输入资产号”的流程的规划方法,其特征在于:规划过程为:引入参数array_index、申请表_excel、新请购单编号_str、请购单编号列号_str、工作表名称_str,添加组件1“写入单元格数据”右侧Excel文件对象为“申请表_excel”工作表为“工作表名称_str”单元格位置按行和列,行为“array_index+5”,列为“请购单编号列号_str”待写入数据为“新请购单编号_str”,添加组件2“保存Excel工作薄”右侧Excel文件对象为“申请表_excel”保存方式为原路径保存。7. A planning method for the flow process of "input asset number" that is used to carry out e-commerce procurement based on intelligent robots, characterized in that: the planning process is: the introduction of parameters array_index, application form _excel, new purchase requisition numbering _str, Purchase requisition number, column number_str, worksheet name_str, add component 1 "Write cell data", the Excel file object on the right side is "application form_excel", the worksheet is "worksheet name_str" cell position By row and column, the row is "array_index+5", the column is "requisition number column number_str", the data to be written is "new purchase requisition number_str", add component 2 to the right of "Save Excel Workbook" The object of the Excel file is "Application Form_excel" and the saving method is the original path. 8.一种用于基于智能机器人进行电商采购的“维护ERP信息并加购”的流程的规划方法,其特征在于:规划过程为:添加组件1“变量赋值”右侧输入值为科目类别分配_str,输出值为科目分配引用_str,添加组件2“输入文本”按住Ctrl+左键捕获电商平台商品编号输入栏,下侧输入信息为array_element;继续添加组件3“点击”捕获页面元素中的搜索元素,添加组件4“判断元素是否存在”判断元素为搜索商品编码后是否出现“关于商品编号*没有搜到相关结果”如果条件表达式为“没有结果_bool==ture”在否则中添加组件“brake跳出循环”,添加组件5“for计次循环“在计次循环组件组件中添加组件6“等待元素出现"捕获一个页面固定元素,添加组件7“鼠标悬停"同样按住Ctrl+左键捕获一个页面固定元素;添加组件8“判断元素是否存在"捕获页面元素为"没有搜到相关结果"并在右侧储存为一个布尔的变量值;添加组件9"if条件判断"如果的条件表达公式为没有结果_bool==ture在如果下方添加组件10"点击"捕获的页面元素为搜索;在否则下添加组件"break跳出循环",添加组件11"if条件判断"如果下的条件表达式为没有结果_bool==ture;在如果下添加组件12"变量赋值"输入值为"未查找到结果"输出值为"新请购单编号_str";在否则处添加组件13"for计次循环"在计次循环组件中添加组件14"等待元素出现"捕获页面固定元素,添加组件15"等待元素出现"捕获的页面元素为"请维护ERP信息",添加组件"流程块"设置备注名称为判断是否为汽车采购,添加组件"if条件循环"如果的条件表达式为存在_bool==ture,添加组件"for计次循环"同时在计次循环下新增一个组件"TryCatch异常处理"在异常处理的try中添加组件“点击”点击的信息为“请维护ERP信息”进入维护页面后新增组件“发送热键”捕获目标为内部订单并在下方空白处填写热键为“Tap”继续添加组件“发送热键”无捕获目标,填写热键为“Delete”;添加组件“点击”捕获点击目标为添加修改,继续添加组件“点击”捕获目标为添加修改页面当中的列号后“X”,继续添加组件“点击”捕获目标为确定;添加组件“流程块”在流程块组件中添加组件1“字符串去空格”待处理字符为工厂_arr[array_index],输出为工厂_arr[array_index];添加组件2“发送热键”捕获目标为“工厂”发送热键为“Tap”添加组件3“发送热键”发送目标为无,发送热键为“Enter”添加组件4“输入文本”捕获目标为交货方式及地点旁的输入栏,输入文本为“工厂_arr[array_index]”添加组件5“发送热键”发送目标为无,发送热键为“Enter”添加组件6“发送热键”发送目标为科目分配类别,发送热键为“Tap”添加组件7“发送热键”发送目标为无,发送热键为“Enter”添加组件8“if条件判断”如果的条件表达式为“科目类别分配引用_str=="_-(空白)"||科目类别分配引用_str=="K-成本中心"”在否则处添加组件“if条件判断”如果的条件表达式为“科目分配引用_str=="A-资产"”在如果中添加组件“点击”捕获目标为“A-资产”;在否则中添加组件“点击”捕获目标为“Q-项目生成订单”在if条件判断下添加组件“输入文本”捕获目标为“项目/WBS”旁的文本框,输入文本为“WBS元素_arr[array_index]”;回到组件8“if条件判断”中的如果流程中添加组件“if条件判断”如果的条件表达式为“科目分配引用_str=="_-空白"”在如果流程下添加组件1“点击”捕获目标为_-空白,添加组件2“输入文本”捕获目标为项目/WBS旁的输入栏,输入文本为“WBS元素_arr[array_index]”添加组件3“输入文本”捕获目标为内部订单旁的输入栏,输入文本为“工单号_arr[array_index]”在否则流程下添加组件1“点击”捕获目标为“K-成本中心”添加组件2“流程块”在流程块中天添加组件1“字符串去空格”输入值为“[总账科目_arr[array_index],0]”输出值为“[总账科目_arr[array_index]]”添加组件2“发送热键”捕获目标为“总账科目”发送热键为“Tap”添加组件3“发送热键”捕获目标为无,发送热键为“Enter”添加组件4“输入文本”捕获目标为成本中心旁的输入栏,输入文本为“总账科目_arr[array_index]”添加组件5“发送热键”捕获目标为无,发送热键为“Enter”;在组件5“发送热键”下添加组件“流程块”在流程块中添加组件1“发送热键”捕获目标为“成本中心”发送热键为“Tap”添加组件2“发送热键”捕获目标为无,发送热键为”Enter”添加组件3“输入文本”捕获目标为“资产号”旁的输入栏,输入文本为“成本中心_arr[array_index]”添加组件4“发送热键”捕获目标为无,发送热键为“Enter”;在“if条件判断#18”下添加组件“if条件判断”如果的条件表达式为“科目分配引用_str==“A-资产”||科目分配引用_str==“空白”||科目分配引用_str==“K-成本中心””在如果中添加组件1“点击”捕获目标为“添加修改”添加组件2“字符串去空格”输入值为“[资产号_arr[array_index],3]”输出值为[资产号_str],添加组件3“查找字符串”输入值为[资产号_str,string,",",0,ture,false],输出值为“[结果_num]”,添加组件4“执行流程”执行子流程为“输入资产号”;在“if条件判断#25”流程下添加组件“流程块”在流程块中添加组件1“字符串去空格”输入值为“交货地点及方式_arr[array_index],0”输出值为“交货地点及方式_arr[array_index]”添加组件2“字符串分割”输入值为“交货地点及方式_arr[array_index],"-",999”输出值为“交货地点及方式_arr”;添加组件3“发送热键”捕获目标为“交货地点及方式”发送热键为“Tap”添加组件4“发送热键”捕获目标为无,发送热键为“Enter”添加组件5“输入文本”捕获目标为“到货日期”右侧输入栏,输入文本为“交货地点及方式_arr[0]”添加组件6“发送热键”捕获目标为无,发送热键为“Enter”;添加组件“流程块”在流程块中添加组件1“字符串去空格”输入值为“采购组_arr[array_index],0”输出值为“采购组_arr[array_index]”添加组件2“发送热键”捕获目标为“采购组”发送热键为“Tap”,添加组件3“发送热键”捕获目标为无,发送热键为“Enter”添加组件4“输入文本”捕获目标为“数量”右侧输入栏,输入文本为“采购组_arr[array_index]”添加组件5“发送热键”捕获目标为无,发送热键为“Enter”;添加组件“流程块”在流程块中添加组件1“获取当前日期&时间”输出值为“当前日期_dat”添加组件2“日期计算”输入值为“当前日期_aat,+,day.28”输出值为“到货日期_dat”添加组件3“格式化日期”输入值为“到货日期_dat,yyyy-mm-dd”输出值为“到货日期_str”;流程块下添加新组件“输入文本”捕获目标为“到货日期”右侧输入栏,输入文本为“到货日期_str”,添加组件“点击”捕获目标为“到货日期”添加组件“输入文本”捕获目标为“数量”右侧输入栏,输入文本为“采购数量_arr[array_index]”添加组件“break跳出循环”;添加组件1“判断元素是否存在”捕获目标为“加入进货单”在右侧是否存在中添加“加购_bool”的变量,添加组件2“if条件判断”如果的条件表达式为“加购_bool==ture”在如果流程下添加组件1“for计次循环”在计次循环组件中添加组件1“点击”捕获目标为“加入进货单”添加组件2“判断元素是否存在”捕获目标为“添加成功”在右侧添加“加购成功_bool”的变量,添加组件4“if条件判断”如果的条件表达式为“加购成功_bool==ture”;在如果流程中添加组件“break跳出循环”,在否则流程下添加组件1“判断元素是否存在”捕获目标为“显示”新增变量为“提示框_bool”添加组件2“if条件判断”如果的条件表达式为“提示框_bool==ture”,在如果流程中添加组件1“点击”捕获目标为“确定”,添加组件2“break跳出循环”在“if条件判断#467”的如果流程下添加组件“变量赋值”输入值为““已加购””输出值为“新请购单编号_str”。8. A planning method for the process of "maintaining ERP information and adding purchases" for e-commerce procurement based on intelligent robots, characterized in that: the planning process is: add component 1 "variable assignment" right input value is subject category Assign _str, the output value is subject assignment reference _str, add component 2 "input text", press and hold Ctrl + left button to capture the item number input column of the e-commerce platform, and the input information on the lower side is array_element; continue to add component 3 "click" to capture the page For the search element in the element, add component 4 "judging whether the element exists" to judge whether the element appears after the code of the searched product "about the product number * no relevant results found" if the conditional expression is "no result_bool==ture" in Otherwise, add the component "brake out of the loop", add component 5 "for counting cycle", add component 6 "wait for the element to appear" in the counting cycle component component to capture a page fixed element, add component 7 "mouse hover" and press the same Hold Ctrl + left button to capture a page fixed element; add component 8 "judging whether the element exists" to capture the page element as "no relevant results found" and store it as a Boolean variable value on the right; add component 9 "if condition judgment" If the conditional expression formula is no result_bool==ture, add component 10 below if "click" to capture the page element as search; otherwise add component "break out of the loop", add component 11 "if condition judgment" if below The conditional expression is no result_bool==true; if add component 12 "variable assignment" input value is "no result found" output value is "new purchase requisition number_str"; otherwise add component 13 "for counting cycle" add component in the counting cycle component 14 "wait for element to appear" capture page fixed element, add component 15 "wait for element to appear" capture page element is "please maintain ERP information", add component" process Block "Set the remark name to judge whether it is a car purchase, add the component "if conditional loop" if the conditional expression exists_bool==true, add the component "for counting cycle" and add a new component under the counting cycle "TryCatch Exception Handling" Add the component "Click" in the try of exception handling, and the clicked information is "Please maintain ERP information". After entering the maintenance page, add a new component "Send Hotkey" to capture the target as an internal order and fill in the hotkey in the blank space below The key is "Tap" and continue to add the component "Send Hotkey" without capture target, fill in the hotkey as "Delete"; add the component "Click" to capture the click target to add and modify, continue to add the component "Click" to capture the target to add and modify the page After the column number "X", continue to add the component "click" to capture the target as OK; add the component "process block" and add component 1 "string to remove spaces" in the process block component. The character to be processed is factory _arr[array_index], output as factory_arr[array_index]; add component 2 "send hotkey" capture target as "factory" send hotkey as "Tap" add component 3 "send hotkey" send target as None, send hotkey as "Enter" Add component 4 "input text" capture target is the input field next to the delivery method and location, input text is "factory_arr[array_index]" add component 5 "send hotkey" send target is None, send hotkey is "Enter "Add Component 6 "Send Hotkey" Send target is subject assignment category, send hotkey is "Tap" Add Component 7 "Send Hotkey" send target is None, send hotkey is "Enter" Add Component 8 "if condition judgment "If the conditional expression is "Account Category Assignment Reference_str=="_-(blank)"||Account Category Assignment Reference_str="K-Cost Center"", otherwise add the component "if condition judgment" If the conditional expression is "Account Assignment Reference_str=="A-Asset"", add the component "click" to capture the target as "A-asset"; otherwise add the component "click" to capture the target as "Q -Project Generate Order" add the component "Input Text" under the if condition judgment to capture the target as the text box next to "Project/WBS", and the input text is "WBS element_arr[array_index]"; return to component 8 "if condition judgment In "if process, add component "if condition judgment" if the conditional expression is "subject assignment reference_str=="_-blank"" Add component 1 under if process "click" capture target is _-blank, Add component 2 "input text" capture target is the input column next to project/WBS, input text is "WBS element_arr[array_index]" Add component 3 "input text" capture target is input column next to internal order, input text is "Work order number_arr[array_index]" Add component 1 under the otherwise process "Click" capture target is "K-cost center" Add component 2 "Process block" Add component 1 "String to remove spaces" in the process block The input value is "[General Ledger Account_arr[array_index],0]" and the output value is "[General Ledger Account_arr[array_index]]" Add component 2 "Send Hotkey" to capture the target as "General Ledger Account" and send the hotkey to " Tap" add component 3 "send hotkey" capture target is none, send hotkey as "Enter" add component 4 "input text" capture target is the input field next to the cost center, input text is "general ledger account_arr[array_index] Add Component 5 "Send Hotkey" capture target as None, Send Hotkey as "Enter"; Add component "Process Block" under Component 5 "Send Hotkey" Add Component 1 "Send Hotkey" Capture in Process Block Target is "Cost Center" Send Hotkey is "Tap" Add Component 2 "Send Hotkey" Capture Target is None, Send Hotkey is "Enter" Add Component 3 "Enter Text" Capture Target is Enter next to "Asset Number" column, input text as "cost center_arr[array_index]" add component 4 "send hotkey" to capture target as none, send hotkey as "Enter"; add component "if conditional judgment" under "if conditional judgment #18" "If the conditional expression is "Account Allocation Reference_str=="A-Asset"||Account Allocation Reference_str=="Blank"||Account Allocation Reference_str="K-Cost Center"" in if Add component 1 "click" to capture the target as "add modification" add component 2 "string remove spaces" input value is "[asset number_arr[array_index],3]" output value is [asset number_str], add The input value of component 3 "search string" is [asset number_str,string,",",0,ture,false], the output value is "[result_num]", add component 4 "execution process" to execute the sub-process It is "input asset number"; add component "process block" under the process of "if condition judgment #25" Add component 1 "string remove spaces" in the process block and input value is "delivery location and method_arr[array_index] ,0" output value is "delivery location and method_arr[array_index]", add component 2 "string segmentation" input value is "delivery location and method_arr[array_index],"-",999" output value "Delivery place and method_arr"; Add component 3 "Send hotkey" Capture target is "Delivery place and method" Send hotkey as "Tap" Add component 4 "Send hotkey" Capture target is None, Send hotkey The key is "Enter" Add component 5 "Input text" capture target is "arrive date" right input column, input text is "delivery location and method_arr[0]" Add component 6 "Send hotkey" capture target If it is none, send the hotkey as "Enter"; Add component "Process Block" Add component 1 in the process block "String despace" input value is "purchasing group_arr[array_index], 0" output value is "purchasing group _arr[array_index]" add component 2 "send hotkey" capture target is "purchasing group" send hotkey as "Tap", add component 3 "send hotkey" capture target as None, send hotkey as "Enter" add The capture target of component 4 "input text" is the input column on the right side of "quantity", the input text is "purchasing group_arr[array_index]", and the capture target of component 5 "send hotkey" is None, and the send hotkey is "Enter"; Add component "Process block" Add component 1 "Get current date & time" output value in process block "Current date_dat" Add component 2 "Date calculation" Input value "Current date_aat,+,day.28 "The output value is "arrival date_dat" add component 3 "formatted date" input value is "arrival date_dat,yyyy-mm-dd" output value is "arrival date_str"; add under the process block The new component "input text" captures the target as the input field on the right side of "arrival date", and the input text is "arrival_date_str", and adds the component "click" to capture the target as "arrival date" and adds the component "input text" to capture The target is the input field on the right of "Quantity", and the input text is "Purchase Quantity_arr[array_index]" Add component "break out of the loop"; Add component 1 "Judge whether the element exists" Capture target is "Add to purchase order" on the right Add the variable of "add_purchase_bool" to whether it exists, add component 2 "if condition judgment" if the conditional expression is "add_purchase_bool==true" add component 1 "for counting cycle" under the if process Add component 1 "Click" to the counting cycle component, and the capture target is "add to the purchase order", add component 2 "judging whether the element exists", and the capture target is "add success", add the variable "add purchase success_bool" to the right, add Component 4 "if conditional judgment" If the conditional expression is "purchase success_bool==true"; add component "break out of loop" in the if process, add component 1 "judging whether the element exists" capture in the otherwise process The target is "display" and the new variable is "prompt box_bool" Add component 2 "if condition judgment" If the conditional expression is "prompt box_bool==true", add component 1 "click" capture in the if process The goal is "OK", add component 2 "break out of the loop" and add the component "variable assignment" under the if process of "if condition judgment #467", the input value is ""added purchase"" and the output value is "new purchase requisition" number_str'.
CN202310435767.6A 2023-04-22 2023-04-22 A method for e-commerce procurement based on intelligent software robots Pending CN116664221A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310435767.6A CN116664221A (en) 2023-04-22 2023-04-22 A method for e-commerce procurement based on intelligent software robots

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310435767.6A CN116664221A (en) 2023-04-22 2023-04-22 A method for e-commerce procurement based on intelligent software robots

Publications (1)

Publication Number Publication Date
CN116664221A true CN116664221A (en) 2023-08-29

Family

ID=87726939

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310435767.6A Pending CN116664221A (en) 2023-04-22 2023-04-22 A method for e-commerce procurement based on intelligent software robots

Country Status (1)

Country Link
CN (1) CN116664221A (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20020143692A1 (en) * 2000-08-22 2002-10-03 Heimermann Scott Allen Fully automated, requisition-driven, competing authorized suppliers, web site-based, real-time, reverse-auction, centralized e-procurement system for government, with bifurcated internal and external modules, requisition pooling, order formulation and management, consolidated in-bound shipment and distributed J.I.T. delivery, procurement-needs prediction, centralized catalog management and numerous additional features
CN110689223A (en) * 2019-08-22 2020-01-14 深圳市全通数码科技有限公司 Robot batch management system based on RPA control
CN111754310A (en) * 2020-06-30 2020-10-09 北京来也网络科技有限公司 Online shopping method, device, equipment and medium combining RPA and AI
CN113765898A (en) * 2021-08-20 2021-12-07 北京来也网络科技有限公司 Login method, device, equipment and medium based on AI and RPA

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20020143692A1 (en) * 2000-08-22 2002-10-03 Heimermann Scott Allen Fully automated, requisition-driven, competing authorized suppliers, web site-based, real-time, reverse-auction, centralized e-procurement system for government, with bifurcated internal and external modules, requisition pooling, order formulation and management, consolidated in-bound shipment and distributed J.I.T. delivery, procurement-needs prediction, centralized catalog management and numerous additional features
CN110689223A (en) * 2019-08-22 2020-01-14 深圳市全通数码科技有限公司 Robot batch management system based on RPA control
CN111754310A (en) * 2020-06-30 2020-10-09 北京来也网络科技有限公司 Online shopping method, device, equipment and medium combining RPA and AI
CN113765898A (en) * 2021-08-20 2021-12-07 北京来也网络科技有限公司 Login method, device, equipment and medium based on AI and RPA

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
木槿向南工作室: "1688自助下单RPA机器人", pages 1, Retrieved from the Internet <URL:https://store.uibot.com.cn/robots/detail/18.html> *

Similar Documents

Publication Publication Date Title
CN111695805B (en) Intelligent contract model construction method and system for legal contracts
CN112001594B (en) A robot management system based on material contract management and management method thereof
CN102760267A (en) An ERP electronic commerce system and its application method
CN112199735B (en) Vertical e-commerce trading platform based on blockchain
CN103500418A (en) Financial commodity real-time trading system and trading method thereof based on network
CN101470865A (en) Quotation information collecting system and collecting method thereof
CN106548326A (en) Linking accepts scene and handles the method and its system of the workflow engine of scene
CN119295007A (en) A bid evaluation method and system based on artificial intelligence
Agboola et al. Development of a web-based platform for automating an inventory management of a small and medium enterprise
CN115619512A (en) Reconciliation processing method, device, computer readable medium and computer program product
CN116664221A (en) A method for e-commerce procurement based on intelligent software robots
CN212460603U (en) Robot management system based on material contract management
US20070179642A1 (en) System and method for interactive process management
Kajba et al. Process Optimization of the Selected Business Using a Process Approach.
WO2025149849A1 (en) Machine learning techniques for improving context and understanding of user interaction-based data
CN104318375B (en) A Product Information Management System for Small Supermarkets
Huang et al. Informatization design of raw material purchase and payment for feed processing enterprises under ERP system environment
Shwetha et al. From MongoDB to React: Unleashing the Power of MERN in E-commerce
Wang et al. Dynamic modeling and simulation of how information sharing influences supply chain performance
TWI492173B (en) Order system pricing method
CN115934515A (en) A method for testing the whole process of Internet financial business
CN109242550B (en) Steel process cost prediction system
Miftakhudin et al. Use of the Codeigniter Framework in the Design and Development of the Balance Sheet-Based" Sikmajo" Financial Information System.
Towner CASE: concepts and implementation
Zhang et al. Development And Application of Electronic Tax Declaration Robot for Individual Income Tax Based on Uipath

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination