def test_dstaff_management(self): u'''测试员工管理''' excel = excelHandle() logger.info("开始回放脚本员工管理") filename = r'D:\PycharmProjects\AutoTestEinvoice\script\税务云-正式环境fapiao\3.应用设置\员工管理-正.xlsx' sheetname = 'Sheet1' tables = excel.read_excel(unicode(filename, "utf-8"), sheetname) # 公共部分,读取表格 util = Utils(BasePage) util.util(self.driver, tables) logger.info("结束回放脚本员工管理") logger.info("结束回放脚本员工管理") logger.info("结束回放脚本员工管理") logger.info("结束回放脚本员工管理")
def test_fkhda_management(self): u'''测试客户档案''' excel = excelHandle() logger.info("开始回放脚本客户档案") # filename = r'D:\PycharmProjects\AutoTestEinvoice\script\税务云-正式环境fapiao\3.应用设置\客户档案-正.xlsx' filename = r'C:\Users\Administrator\Desktop\Demo.xlsx' sheetname = 'Sheet1' tables = excel.read_excel(unicode(filename, "utf-8"), sheetname) # 公共部分,读取表格 util = Utils(BasePage) util.util(self.driver, tables) logger.info("结束回放脚本客户档案") logger.info("结束回放脚本客户档案") logger.info("结束回放脚本客户档案") logger.info("结束回放脚本客户档案")
def test_dhistorical_records(self): u'''查验历史记录''' excel = excelHandle() logger.info("开始回放脚本查验历史记录") logger.info("开始回放脚本查验历史记录") filename = r'D:\PycharmProjects\AutoTestEinvoice\script\税务云-正式环境fapiao\5.企业受票\查验历史记录-正.xlsx' sheetname = 'Sheet1' tables = excel.read_excel(unicode(filename, "utf-8"), sheetname) # 公共部分,读取表格 util = Utils(BasePage) util.util(self.driver, tables) logger.info("结束回放脚本查验历史记录") logger.info("结束回放脚本查验历史记录")
def util(self, driver, tables): self.driver = driver for i in range(len(tables)): row_list = tables[i] strTips = '行号:' + str(i + 1) + ',内容:[' logger.info(strTips + ','.join("'" + str(element).decode('utf-8') + "'" for element in row_list) + ']') norun = row_list[4].decode('utf-8') # 如果表格中的第5列是 *,表示此行不运行,跳过。row_list[0]:要执行的动作值(如click) # row_list[1]:定位方式(如 xpath) # row_list[2]:定位值(如 //a[text()="保存"]) # row_list[3]:输入值或需要校验的值(如 请输入编码) # row_list[4]:此行是否运行 * 不运行,否则运行 # row_list[5]:备注信息 if norun == "*": continue elif row_list[0] == "click": # if row_list[3] is not None: self.click(row_list[1], row_list[2], row_list[3], row_list[5]) # self.sleep(2000) elif row_list[0] == "input": strTel = str(row_list[3]) self.input(row_list[1], row_list[2], strTel, row_list[5]) elif row_list[0] == "mousemove": self.mouse_move(row_list[1], row_list[2], row_list[5]) elif row_list[0] == "select": self.select(row_list[1], row_list[2], str(row_list[3]), row_list[5]) elif row_list[0] == "wait": self.sleep(row_list[3]) elif row_list[0] == "checkpoint": self.checkpoint(row_list[1], row_list[2], row_list[3], row_list[5]) elif row_list[0] == "contentclick": self.context_click(row_list[1], row_list[2], row_list[5]) elif row_list[0] == "key": key_list = tables[i - 1] self.key(key_list[1], key_list[2], row_list[3],row_list[5]) elif row_list[0] == "back": self.back() self.sleep(2000)
def test_dnot_open(self): u'''未开票''' excel = excelHandle() logger.info("开始回放脚本未开票") logger.info("开始回放脚本未开票") filename = r'D:\PycharmProjects\AutoTestEinvoice\script\税务云-正式环境fapiao\4.企业开票\未开票-正.xlsx' # filename = r'C:\Users\Administrator\Desktop\Demo.xlsx' sheetname = 'Sheet1' tables = excel.read_excel(unicode(filename, "utf-8"), sheetname) # 公共部分,读取表格 util = Utils(BasePage) util.util(self.driver, tables) logger.info("结束回放脚本未开票") logger.info("结束回放脚本未开票") logger.info("结束回放脚本未开票") logger.info("结束回放脚本未开票")
def test_code_open(self): u'''码上开票''' excel = excelHandle() logger.info("开始回放脚本码上开票") logger.info("开始回放脚本码上开票") filename = r'D:\PycharmProjects\AutoTestEinvoice\script\税务云-正式环境fapiao\4.企业开票\码上开票-正.xlsx' sheetname = 'Sheet1' tables = excel.read_excel(unicode(filename, "utf-8"), sheetname) # 公共部分,读取表格 util = Utils(BasePage) util.util(self.driver, tables) logger.info("结束回放脚本码上开票") logger.info("结束回放脚本码上开票") logger.info("结束回放脚本码上开票") logger.info("结束回放脚本码上开票")
def test_reimbursement_statistics(self): u'''测试报销统计表''' excel = excelHandle() logger.info("开始回放脚本报销统计表") logger.info("开始回放脚本报销统计表") filename = r'D:\PycharmProjects\AutoTestEinvoice\script\税务云-正式环境fapiao\7.进项统计\报销统计表-正.xlsx' sheetname = 'Sheet1' tables = excel.read_excel(unicode(filename, "utf-8"), sheetname) # 公共部分,读取表格 util = Utils(BasePage) util.util(self.driver, tables) logger.info("结束回放脚本报销统计表") logger.info("结束回放脚本报销统计表") logger.info("结束回放脚本报销统计表") logger.info("结束回放脚本报销统计表")
def test_dpersonal_center(self): u'''测试个人中心''' excel = excelHandle() logger.info("开始回放脚本个人中心") logger.info("开始回放脚本个人中心") filename = r'D:\PycharmProjects\AutoTestEinvoice\script\税务云-正式环境fapiao\11.个人用户操作\个人中心-正.xlsx' sheetname = 'Sheet1' tables = excel.read_excel(unicode(filename, "utf-8"), sheetname) # 公共部分,读取表格 util = Utils(BasePage) util.util(self.driver, tables) logger.info("结束回放脚本个人中心") logger.info("结束回放脚本个人中心") logger.info("结束回放脚本个人中心") logger.info("结束回放脚本个人中心")
def test_other_operation(self): u'''测试修改企业密码,在线客服,帮助文档''' excel = excelHandle() logger.info("开始回放脚本首页") logger.info("开始回放脚本首页") filename = r'D:\PycharmProjects\AutoTestEinvoice\script\税务云-正式环境fapiao\2.首页\其他操作.xlsx' sheetname = 'Sheet1' tables = excel.read_excel(unicode(filename, "utf-8"), sheetname) # 公共部分,读取表格 util = Utils(BasePage) util.util(self.driver, tables) logger.info("结束回放脚本首页") logger.info("结束回放脚本首页") logger.info("结束回放脚本首页") logger.info("结束回放脚本首页")
def test_caigou_account(self): u'''采购台账''' excel = excelHandle() logger.info("开始回放脚本采购台账") logger.info("开始回放脚本采购台账") filename = r'D:\PycharmProjects\AutoTestEinvoice\script\税务云-正式环境fapiao\5.企业受票\采购台账-正.xlsx' sheetname = 'Sheet1' tables = excel.read_excel(unicode(filename, "utf-8"), sheetname) # 公共部分,读取表格 util = Utils(BasePage) util.util(self.driver, tables) logger.info("结束回放脚本采购台账") logger.info("结束回放脚本采购台账") logger.info("结束回放脚本采购台账") logger.info("结束回放脚本采购台账")