def test_login_zhaobingcheng(self):
logging.info('=========test_login_zhaobingcheng============')
l = LoginView(self.driver)
data = l.get_csv_data(self.csv_file, 1)
l.login_action(data[0], data[1])
time.sleep(2)
self.driver.find_element(*self.ywglBtn).click()
time.sleep(2)
self.driver.find_element(*self.gxzygl).click()
time.sleep(2)
self.driver.find_element(*self.gddgl).click()
l.join_iframe()
time.sleep(3)
# 获取该模块数据条数
be_string_num = self.driver.find_element(*self.string).text
be_nums = re.findall('\d+\.?', be_string_num)
be_num = be_nums[2]
be_NUM = int(be_num)
logging.info('导入前当前页共有数据%s条' % be_NUM)
# 导出模板并写入内容
self.driver.find_element(*self.importBtn).click()
WebDriverWait(self.driver,
5).until(lambda x: x.find_element(*self.download))
self.driver.find_element(*self.download).click()
time.sleep(2)
workbook = openpyxl.load_workbook(self.slavepath) # 读取excel
sheet = workbook['Sheet1']
# 写入实际内容（第二行）
logging.info("系统即将执行Excel写入...")
sheet['D2'] = self.excel_start_name
sheet['F2'] = self.excel_end_name
sheet['Q2'] = self.excel_province
sheet['R2'] = self.excel_city
sheet['S2'] = self.excel_county
workbook.save(self.slavepath) # 保存
logging.info("写入完成，即将上传")
self.driver.find_element(*self.file_select).click()
time.sleep(2)
l.win32_pick_slave(self.slavepath)
time.sleep(2)
WebDriverWait(self.driver,
5).until(lambda x: x.find_element(*self.submitBtn))
self.driver.find_element(*self.submitBtn).click()
time.sleep(2)
self.driver.find_element(*self.close_alert).click()
self.driver.find_element(*self.resetBtn).click()
time.sleep(2)
# 获取导入一条数据后该模块数据条数
af_string_num = self.driver.find_element(*self.string).text
af_nums = re.findall('\d+\.?', af_string_num)
af_num = af_nums[2]
af_NUM = int(af_num)
logging.info('导入后当前页共有数据%s条' % af_NUM)
time.sleep(1)
try:
assert af_NUM == be_NUM + 1
logging.info('管道段信息管理导入成功')
except:
logging.info('管道段信息管理导入失败')
l.getScreenShot('管道段信息管理导入失败')
time.sleep(1)
# 删除该导入数据
self.driver.find_element(*self.deleteBtn).click()
self.driver.find_element(*self.certain).click()
time.sleep(2)
self.driver.find_element(*self.resetBtn).click()
time.sleep(1)
string_num = self.driver.find_element(*self.string).text
nums = re.findall('\d+\.?', string_num)
num = nums[2]
NUM = int(num)
logging.info('删除后当前页共有数据%s条' % NUM)
time.sleep(1)
try:
assert NUM == be_NUM
logging.info('导入的数据删除成功')
except:
logging.info('导入的数据删除失败')
l.getScreenShot('导入的数据删除失败')
time.sleep(1)
os.remove(self.slavepath)
time.sleep(1)
l.quit_iframe()
k = QuitView(self.driver)
k.quit_action()
def test_login_zhaobingcheng(self):
logging.info('=========test_login_zhaobingcheng============')
l = LoginView(self.driver)
data = l.get_csv_data(self.csv_file, 1)
l.login_action(data[0], data[1])
time.sleep(2)
self.driver.find_element(*self.swglBtn).click()
self.driver.find_element(*self.bzjBtn).click()
l.join_iframe()
time.sleep(1)
# 获取该模块数据条数
be_string_num = self.driver.find_element(*self.string).text
be_nums = re.findall('\d+\.?', be_string_num)
be_num = be_nums[2]
be_NUM = int(be_num)
logging.info('导入前当前页共有数据%s条' % be_NUM)
# 导出模板并写入内容
self.driver.find_element(*self.importBtn).click()
WebDriverWait(self.driver,
5).until(lambda x: x.find_element(*self.download))
self.driver.find_element(*self.download).click()
time.sleep(2)
workbook = openpyxl.load_workbook(self.slavepath) # 读取excel
sheet = workbook['Sheet1']
# 写入实际内容（第二行）
logging.info("系统即将执行Excel写入...")
sheet['A2'] = self.text_smmc
sheet['B2'] = self.text_skr
sheet['C2'] = '111.11'
sheet['D2'] = '2018-11-19'
sheet['E2'] = '2018-11-20'
sheet['F2'] = '100.00'
sheet['G2'] = '13655554444'
sheet['H2'] = '1'
sheet['I2'] = self.text_OA
sheet['J2'] = '1'
sheet['K2'] = '111'
workbook.save(self.slavepath) # 保存
logging.info("写入完成，即将上传")
self.driver.find_element(*self.file_select).click()
time.sleep(2)
l.win32_pick_slave(self.slavepath)
time.sleep(2)
WebDriverWait(self.driver,
5).until(lambda x: x.find_element(*self.submitBtn))
self.driver.find_element(*self.submitBtn).click()
time.sleep(2)
self.driver.find_element(*self.close_alert).click()
self.driver.find_element(*self.resetBtn).click()
time.sleep(2)
# 获取导入一条数据后该模块数据条数
af_string_num = self.driver.find_element(*self.string).text
af_nums = re.findall('\d+\.?', af_string_num)
af_num = af_nums[2]
af_NUM = int(af_num)
logging.info('导入后当前页共有数据%s条' % af_NUM)
time.sleep(1)
try:
assert af_NUM == be_NUM + 1
logging.info('===保证金导入成功===')
except:
logging.info('===保证金导入失败===')
l.getScreenShot('保证金导入失败')
time.sleep(1)
#删除该导入数据
self.driver.find_element(*self.smmc).send_keys(self.text_smmc)
self.driver.find_element(*self.skr).send_keys(self.text_skr)
self.driver.find_element(*self.OA).send_keys(self.text_OA)
self.driver.find_element(*self.searchBtn).click()
time.sleep(2)
self.driver.find_element(*self.deleteBtn).click()
self.driver.find_element(*self.certain).click()
time.sleep(2)
self.driver.find_element(*self.resetBtn).click()
time.sleep(1)
string_num = self.driver.find_element(*self.string).text
nums = re.findall('\d+\.?', string_num)
num = nums[2]
NUM = int(num)
logging.info('删除后当前页共有数据%s条' % NUM)
time.sleep(1)
try:
assert NUM == be_NUM
logging.info('===导入数据删除成功===')
except:
logging.info('===导入数据删除失败===')
l.getScreenShot('导入数据删除失败')
time.sleep(1)
os.remove(self.slavepath)
l.quit_iframe()
k = QuitView(self.driver)
k.quit_action()
def test_login_zhaobingcheng(self):
logging.info('=========test_login_zhaobingcheng============')
l = LoginView(self.driver)
data = l.get_csv_data(self.csv_file, 1)
l.login_action(data[0], data[1])
time.sleep(2)
self.driver.find_element(*self.ywglBtn).click()
time.sleep(2)
self.driver.find_element(*self.gxzygl).click()
time.sleep(2)
self.driver.find_element(*self.dglr).click()
l.join_iframe()
time.sleep(3)
# 新增
self.driver.find_element(*self.addBtn).click()
time.sleep(1)
self.driver.find_element(*self.pole_name_input).send_keys(
*self.pole_name_text)
self.driver.find_element(*self.pull_line_input).send_keys(
*self.pull_line_num)
self.driver.find_element(*self.pole_type).click()
self.driver.find_element(*self.pole_type_select).click()
self.driver.find_element(*self.pole_material).click()
self.driver.find_element(*self.pole_material_select).click()
self.driver.find_element(*self.province).click()
self.driver.find_element(*self.province_select).click()
self.driver.find_element(*self.city).click()
self.driver.find_element(*self.city_select).click()
self.driver.find_element(*self.pole_height).send_keys(
*self.pole_height_num)
self.driver.find_element(*self.property_unit).click()
self.driver.find_element(*self.property_select).click()
self.driver.find_element(*self.province_nature).click()
self.driver.find_element(*self.nature_select).click()
self.driver.find_element(*self.longitude_input).send_keys(
*self.longitude_text)
self.driver.find_element(*self.latitude_input).send_keys(
*self.latitude_text)
self.driver.find_element(*self.uphold_method).click()
self.driver.find_element(*self.uphold_select).click()
self.driver.find_element(*self.select_file).click()
time.sleep(2)
l.win32_pick_slave(self.slavepath)
self.driver.find_element(*self.submitBtn).click()
time.sleep(3)
self.driver.find_element(*self.resetBtn).click()
time.sleep(2)
first_pole_text = self.driver.find_element(*self.first_pole_name).text
try:
assert self.pole_name_text == first_pole_text
logging.info('电杆录入新增成功')
except:
logging.info('电杆录入新增失败')
l.getScreenShot('电杆录入新增失败')
# 删除
be_PageNum = self.driver.find_element(*self.pageNum).text
be_nums = re.findall(r'\d+\.?', be_PageNum)
be_num = be_nums[2]
be_NUM = int(be_num)
logging.info('删除前共有数据%s条' % be_NUM)
time.sleep(1)
self.driver.find_element(*self.dele_firstBtn).click()
self.driver.find_element(*self.dele_certainBtn).click()
self.driver.find_element(*self.resetBtn).click()
time.sleep(1)
af_PageNum = self.driver.find_element(*self.pageNum).text
af_nums = re.findall(r'\d+\.?', af_PageNum)
af_num = af_nums[2]
af_NUM = int(af_num)
logging.info('删除后共有数据%s条' % af_NUM)
time.sleep(1)
try:
assert af_NUM == be_NUM - 1
logging.info('电杆录入删除成功')
except:
logging.info('电杆录入删除失败')
l.getScreenShot('电杆录入删除失败')
self.driver.find_element(*self.resetBtn).click()
time.sleep(1)
# 批量删除
be_PageNum = self.driver.find_element(*self.pageNum).text
be_nums = re.findall(r'\d+\.?', be_PageNum)
be_num = be_nums[2]
be_NUM = int(be_num)
logging.info('批量删除前共有数据%s条' % be_NUM)
time.sleep(1)
self.driver.find_element(*self.first_sele).click()
self.driver.find_element(*self.batch_dele).click()
self.driver.find_element(*self.batch_dele_certainBtn).click()
time.sleep(1)
self.driver.find_element(*self.resetBtn).click()
time.sleep(1)
af_PageNum = self.driver.find_element(*self.pageNum).text
af_nums = re.findall(r'\d+\.?', af_PageNum)
af_num = af_nums[2]
af_NUM = int(af_num)
logging.info('批量删除后共有数据%s条' % af_NUM)
time.sleep(1)
try:
assert af_NUM == be_NUM - 1
logging.info('电杆录入批量删除成功')
except:
logging.info('电杆录入批量删除失败')
l.getScreenShot('电杆录入批量删除失败')
time.sleep(1)
l.quit_iframe()
k = QuitView(self.driver)
k.quit_action()
def test_login_zhaobingcheng(self):
logging.info('=========test_login_zhaobingcheng============')
l = LoginView(self.driver)
data = l.get_csv_data(self.csv_file, 1)
l.login_action(data[0], data[1])
time.sleep(2)
self.driver.find_element(*self.ywglBtn).click()
time.sleep(2)
self.driver.find_element(*self.gzlgl).click()
time.sleep(2)
self.driver.find_element(*self.xgzl_maintain).click()
l.join_iframe()
time.sleep(3)
# 获取该模块数据条数
be_string_num = self.driver.find_element(*self.string).text
be_nums = re.findall('\d+\.?', be_string_num)
be_num = be_nums[2]
be_NUM = int(be_num)
logging.info('导入前当前页共有数据%s条' % be_NUM)
# 导出模板并写入内容
self.driver.find_element(*self.importBtn).click()
WebDriverWait(self.driver,
5).until(lambda x: x.find_element(*self.download))
self.driver.find_element(*self.download).click()
time.sleep(2)
workbook = openpyxl.load_workbook(self.slavepath) # 读取excel
sheet = workbook['Sheet1']
# 写入实际内容（第二行）
logging.info("系统即将执行Excel写入...")
sheet['A2'] = sheet['A3'] = sheet['A4'] = self.A
sheet['B2'] = sheet['C2'] = sheet['D2'] = sheet['E2'] = sheet[
'F2'] = self.row2
sheet['B3'] = sheet['C3'] = sheet['D3'] = sheet['E3'] = sheet[
'F3'] = self.row3
sheet['B4'] = sheet['C4'] = sheet['D4'] = sheet['E4'] = sheet[
'F4'] = self.row4
sheet['H2'] = sheet['H3'] = sheet['H4'] = self.cell_H
workbook.save(self.slavepath) # 保存
logging.info("写入完成，即将上传")
self.driver.find_element(*self.file_select).click()
time.sleep(2)
l.win32_pick_slave(self.slavepath)
time.sleep(2)
WebDriverWait(self.driver,
5).until(lambda x: x.find_element(*self.submitBtn))
self.driver.find_element(*self.submitBtn).click()
time.sleep(2)
self.driver.find_element(*self.close_alert).click()
self.driver.find_element(*self.resetBtn).click()
time.sleep(2)
# 获取导入3条数据后该模块数据条数
af_string_num = self.driver.find_element(*self.string).text
af_nums = re.findall('\d+\.?', af_string_num)
af_num = af_nums[2]
af_NUM = int(af_num)
logging.info('导入后当前页共有数据%s条' % af_NUM)
time.sleep(1)
try:
assert af_NUM == be_NUM + 3
logging.info('新工作量数据维护批量导入成功')
except:
logging.info('新工作量数据维护批量导入失败')
l.getScreenShot('新工作量数据维护批量导入失败')
time.sleep(1)
#判断批量导入的数据内容
self.driver.find_element(*self.region_search).click()
self.driver.find_element(*self.region_search_select).click()
self.driver.find_element(*self.searchBtn).click()
time.sleep(1)
first_operator_text = self.driver.find_element(
*self.first_operator).text
second_operator_text = self.driver.find_element(
*self.second_operator).text
third_operator_text = self.driver.find_element(
*self.third_operator).text
time.sleep(1)
try:
assert first_operator_text == self.row2 and second_operator_text == self.row3 \
and third_operator_text == self.row4
logging.info('新工作量数据维护批量导入成功')
except:
logging.info('新工作量数据维护批量导入失败')
l.getScreenShot('新工作量数据维护批量导入失败')
time.sleep(1)
#批量删除导入的数据
self.driver.find_element(*self.first_select).click()
self.driver.find_element(*self.second_select).click()
self.driver.find_element(*self.third_select).click()
self.driver.find_element(*self.batch_dele).click()
self.driver.find_element(*self.batch_dele_certainBtn).click()
time.sleep(1)
self.driver.find_element(*self.resetBtn).click()
time.sleep(1)
string_num = self.driver.find_element(*self.string).text
nums = re.findall('\d+\.?', string_num)
num = nums[2]
NUM = int(num)
logging.info('删除后当前页共有数据%s条' % NUM)
time.sleep(1)
try:
assert NUM == be_NUM
logging.info('===导入数据删除成功===')
except:
logging.info('===导入数据删除失败===')
l.getScreenShot('导入数据删除失败')
time.sleep(1)
os.remove(self.slavepath)
l.quit_iframe()
k = QuitView(self.driver)
k.quit_action()
