def test06_fahui_edit(self):
self.fahui_search()
search_value_name = sheet.col_values(1, 0, 1)[0]
name_path = sheet.col_values(1, 1, 2)[0]
self.dr.find_element_by_xpath(name_path).send_keys(search_value_name)
search_value_address = sheet.col_values(1, 2, 3)[0]
address_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(address_path).send_keys(
search_value_address)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 2, 3)[0]).text
self.pagination_num(paginal_number, search_value_address, 4)
self.pagination_num(paginal_number, search_value_name, 3)
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr/td[9]/a').click()
self.dr.find_element_by_xpath('//*[@id="ceremonyName"]').clear()
self.dr.find_element_by_xpath('//*[@id="ceremonyName"]').send_keys(
sheet.col_values(2, 0, 1)[0])
self.dr.find_element_by_xpath('//*[@id="ceremonyArea"]').clear()
self.dr.find_element_by_xpath('//*[@id="ceremonyArea"]').send_keys(
sheet.col_values(2, 2, 3)[0])
self.dr.find_element_by_xpath('//*[@id="organizateMonkNum"]').clear()
self.dr.find_element_by_xpath(
'//*[@id="organizateMonkNum"]').send_keys(
sheet.col_values(2, 4, 5)[0])
self.dr.find_element_by_xpath('//*[@id="realityMonkNum"]').clear()
self.dr.find_element_by_xpath('//*[@id="realityMonkNum"]').send_keys(
sheet.col_values(2, 5, 6)[0])
self.dr.find_element_by_xpath('//*[@id="conscientiousPolice"]').clear()
self.dr.find_element_by_xpath(
'//*[@id="conscientiousPolice"]').send_keys(
sheet.col_values(2, 6, 7)[0])
self.dr.find_element_by_xpath('//*[@id="telephone"]').clear()
self.dr.find_element_by_xpath('//*[@id="telephone"]').send_keys(
sheet.col_values(2, 7, 8)[0])
self.dr.find_element_by_xpath('//*[@id="remarks"]').clear()
self.dr.find_element_by_xpath('//*[@id="remarks"]').send_keys(
sheet.col_values(2, 8, 9)[0])
self.dr.find_element_by_xpath(sheet_setting.col_values(6, 2,
3)[0]).click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(2)
self.assertEqual(
sheet_prompt_message.col_values(1, 4, 5)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'编辑修改成功提示信息校验')
print('人口管理-701数据库-法会：编辑修改功能正常')
def bfz_search(self):
self.login(login_name, login_password)
time.sleep(5)
self.dr.find_element_by_xpath(sheet_menu.col_values(1,2,3)[0]).click()
time.sleep(2)
self.assertEqual('人口管理', self.dr.find_element_by_xpath(sheet_setting.col_values(0,1,2)[0]).text, '人口管理')
self.dr.find_element_by_xpath(sheet_menu.col_values(3,2,3)[0]).click()
time.sleep(2)
self.dr.find_element_by_xpath(sheet_menu.col_values(5,2,3)[0]).click()
time.sleep(2)
self.dr.switch_to.frame('iframeb')
self.assertEqual('边防证列表', self.dr.find_element_by_xpath(sheet_setting.col_values(1,1,2)[0]).text,
'边防证办理情况')
def test03_qianke_search_all(self):
self.qianke_search()
search_value_name = sheet.col_values(1, 0, 1)[0]
name_path = sheet.col_values(1, 1, 2)[0]
self.dr.find_element_by_xpath(name_path).send_keys(search_value_name)
search_value_cardid = sheet.col_values(1, 2, 3)[0]
cardid_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(cardid_path).send_keys(
search_value_cardid)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(10)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
self.pagination_num(paginal_number, search_value_cardid, 1)
self.pagination_num(paginal_number, search_value_name, 2)
self.dr.find_element_by_xpath(reset).click()
self.dr.implicitly_wait(10)
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.assertEqual('',
self.dr.find_element_by_xpath(cardid_path).text,
'身份证号码-重置功能异常')
self.assertEqual('',
self.dr.find_element_by_xpath(name_path).text,
'姓名-重置功能异常')
print('人口管理-部局七类库-前科人员：条件查询功能正常')
def test06_zzrk_search_liveState(self):
self.zzrk_search()
liveState = Select(
self.dr.find_element_by_xpath('//*[@id="form"]/div[6]/div/select'))
for i in range(1, 3):
liveState.select_by_index(i)
search_value_liveState = liveState.all_selected_options[0].text
# print(search_value_liveState)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 13
self.pagination_num(paginal_number, search_value_liveState, column)
self.dr.find_element_by_xpath(reset).click()
self.dr.implicitly_wait(10)
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.assertEqual(
'--全部--',
self.dr.find_element_by_xpath(
'//*[@id="form"]/div[6]/div/select/option[1]').
get_attribute('text'), '居住状态-重置功能异常')
print('人口管理-人员基本信息-暂住人口:居住状态条件查询功能正常')
def test05_zaitaorenyuan_search_all(self):
self.zaitaorenyuan_search()
search_value_name = sheet.col_values(1, 0, 1)[0]
name_path = sheet.col_values(1, 1, 2)[0]
self.dr.find_element_by_xpath(name_path).send_keys(search_value_name)
search_value_cardid = sheet.col_values(1, 2, 3)[0]
cardid_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(cardid_path).send_keys(search_value_cardid)
search_value_rybh = sheet.col_values(1, 4, 5)[0]
rybh_path = sheet.col_values(1, 5, 6)[0]
self.dr.find_element_by_xpath(rybh_path).send_keys(search_value_rybh)
search_value_ajbh = sheet.col_values(1, 6, 7)[0]
ajbh_path = sheet.col_values(1, 7, 8)[0]
self.dr.find_element_by_xpath(ajbh_path).send_keys(search_value_ajbh)
self.dr.find_element_by_xpath(search).click()
time.sleep(180)
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(sheet_setting.col_values(4, 1, 2)[0]).text
self.pagination_num(paginal_number, search_value_name, 2)
self.pagination_num(paginal_number, search_value_cardid, 3)
self.pagination_num(paginal_number, search_value_rybh, 6)
self.pagination_num(paginal_number, search_value_ajbh, 7)
self.dr.find_element_by_xpath(reset).click()
self.dr.implicitly_wait(10)
self.dr.find_element_by_xpath(search).click()
time.sleep(2)
self.assertEqual('', self.dr.find_element_by_xpath(name_path).get_attribute('value'), '姓名-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(cardid_path).get_attribute('value'), '身份证号码-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(rybh_path).get_attribute('value'), '人员编号-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(ajbh_path).get_attribute('value'), '案件编号-重置功能异常')
print('人口管理-在逃人员：条件查询功能正常')
def test07_sihei_details(self):
self.sihei_search()
search_value_cardid = sheet.col_values(1, 2, 3)[0]
cardid_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(cardid_path).send_keys(
search_value_cardid)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(2)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 4
self.pagination_num(paginal_number, search_value_cardid, column)
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr/td[9]/a').click()
self.assertEqual(
sheet.col_values(1, 0, 1)[0],
self.dr.find_element_by_xpath(
'//*[@id="personName"]').get_attribute('value'), '')
self.assertEqual(
sheet.col_values(1, 2, 3)[0],
self.dr.find_element_by_xpath('//*[@id="idCard"]').get_attribute(
'value'), '')
self.assertEqual(
sheet.col_values(1, 4, 5)[0],
self.dr.find_element_by_xpath(
'//*[@id="dutyPerson"]').get_attribute('value'), '')
time.sleep(1)
self.dr.find_element_by_xpath(goback).click()
self.assertEqual(
'四黑人员列表',
self.dr.find_element_by_xpath('/html/body/div[1]/p').text, '四黑人员')
print('人口管理-部局七类库-四黑人员：详情功能正常')
def test04_fahui_search_all(self):
self.fahui_search()
search_value_name = sheet.col_values(1, 0, 1)[0]
name_path = sheet.col_values(1, 1, 2)[0]
self.dr.find_element_by_xpath(name_path).send_keys(search_value_name)
search_value_address = sheet.col_values(1, 2, 3)[0]
address_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(address_path).send_keys(
search_value_address)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 2, 3)[0]).text
self.pagination_num(paginal_number, search_value_address, 4)
self.pagination_num(paginal_number, search_value_name, 3)
self.dr.find_element_by_xpath(reset).click()
time.sleep(2)
self.dr.find_element_by_xpath(search).click()
self.assertEqual(
'',
self.dr.find_element_by_xpath(name_path).get_attribute('value'),
'姓名-重置功能异常')
self.assertEqual(
'',
self.dr.find_element_by_xpath(address_path).get_attribute('value'),
'法会所在地-重置功能异常')
print('人口管理-701数据库-法会：条件查询功能正常')
def test04_rkgl_bjqlk_1_search_age(self):
self.shebian_search()
search_value_1 = sheet.col_values(1, 4, 5)[0]
search_value_2 = sheet.col_values(1, 6, 7)[0]
self.dr.find_element_by_xpath(sheet.col_values(
1, 5, 6)[0]).send_keys(search_value_1)
self.dr.find_element_by_xpath(sheet.col_values(
1, 7, 8)[0]).send_keys(search_value_2)
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 7
self.pagination_num(paginal_number, search_value_1, column)
self.dr.find_element_by_xpath(reset).click()
self.dr.implicitly_wait(10)
self.dr.find_element_by_xpath(search).click()
self.assertEqual(
'',
self.dr.find_element_by_xpath(sheet.col_values(
1, 5, 6)[0]).get_attribute('value'), '年龄段-重置功能异常')
self.assertEqual(
'',
self.dr.find_element_by_xpath(sheet.col_values(
1, 7, 8)[0]).get_attribute('value'), '年龄段-重置功能异常')
print('涉边|涉恐|涉稳|涉外人员-年龄条件查询')
def test06_qunfangxinxiguanli_search_all(self):
self.qunfangxinxiguanli_search()
search_value_infoLabel = sheet.col_values(1, 0, 1)[0]
infoLabel_path = sheet.col_values(1, 1, 2)[0]
self.dr.find_element_by_xpath(infoLabel_path).send_keys(search_value_infoLabel)
search_value_infoKeyword = sheet.col_values(1, 2, 3)[0]
infoKeyword_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(infoKeyword_path).send_keys(search_value_infoKeyword)
search_value_infoSort = sheet.col_values(1, 4, 5)[0]
infoSort_path = sheet.col_values(1, 5, 6)[0]
self.dr.find_element_by_xpath(infoSort_path).send_keys(search_value_infoSort)
search_value_infoValueEvaluate = sheet.col_values(1, 13, 14)[0]
infoValueEvaluate_path = sheet.col_values(1, 14, 15)[0]
self.dr.find_element_by_xpath(infoValueEvaluate_path).send_keys(search_value_infoValueEvaluate)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(sheet_setting.col_values(4, 1, 2)[0]).text
self.pagination_num(paginal_number, search_value_infoValueEvaluate, 3)
self.pagination_num(paginal_number, search_value_infoSort, 4)
self.pagination_num(paginal_number, search_value_infoKeyword, 5)
self.pagination_num(paginal_number, search_value_infoLabel, 6)
self.dr.find_element_by_xpath(reset).click()
time.sleep(2)
self.dr.find_element_by_xpath(search).click()
self.assertEqual('', self.dr.find_element_by_xpath(infoValueEvaluate_path).get_attribute('value'),
'信息价值评估-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(infoSort_path).get_attribute('value'), '信息类别-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(infoKeyword_path).get_attribute('value'), '信息关键词-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(infoLabel_path).get_attribute('value'), '信息标注-重置功能异常')
print('人口管理-群防信息管理：条件查询功能正常')
def test03_jsyxx_search_all(self):
self.jsyxx_search()
search_value_idcard = sheet.col_values(1, 2, 3)[0]
idcard_path = sheet.col_values(1, 3, 4)[0]
search_value_name = sheet.col_values(1, 0, 1)[0]
name_path = sheet.col_values(1, 1, 2)[0]
self.dr.find_element_by_xpath(name_path).send_keys(search_value_name)
self.dr.find_element_by_xpath(idcard_path).send_keys(
search_value_idcard)
self.dr.find_element_by_xpath(search).click()
time.sleep(180)
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
self.pagination_num(paginal_number, search_value_idcard, 3)
self.pagination_num(paginal_number, search_value_name, 2)
self.dr.find_element_by_xpath(reset).click()
self.dr.implicitly_wait(10)
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.assertEqual(
'',
self.dr.find_element_by_xpath(idcard_path).get_attribute('value'),
'重置功能')
self.assertEqual(
'',
self.dr.find_element_by_xpath(name_path).get_attribute('value'),
'姓名-重置功能异常')
print('人口管理-人员基本信息-驾驶员信息:条件查询功能正常')
def test05_exz_search_time(self):
self.exz_search()
self.dr.find_element_by_xpath(sheet.col_values(9, 1, 2)[0]).send_keys(
sheet.col_values(8, 1, 2)[0])
self.dr.find_element_by_xpath(sheet.col_values(11, 1, 2)[0]).send_keys(
sheet.col_values(10, 1, 2)[0])
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 7
self.pagination_num(paginal_number,
sheet.col_values(8, 1, 2)[0], column)
self.dr.find_element_by_xpath(reset).click()
self.dr.implicitly_wait(10)
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.assertEqual(
'',
self.dr.find_element_by_xpath(sheet.col_values(
9, 1, 2)[0]).get_attribute('value'), '开始日期-重置功能异常')
self.assertEqual(
'',
self.dr.find_element_by_xpath(sheet.col_values(
11, 1, 2)[0]).get_attribute('value'), '结束日期-重置功能异常')
print('二线站过往记录：时间条件查询功能正常')
def test04_zhibanguanli_search_all(self):
self.zhibanguanli_search()
option_chioce = Select(
self.dr.find_element_by_xpath('//*[@id="form"]/div[2]/div/select'))
option_chioce.select_by_value('1')
option_chioce_value = option_chioce.first_selected_option.text
time_now = now = time.strftime("%Y-%m-%d", time.localtime(time.time()))
self.dr.find_element_by_xpath('//*[@id="dutyDates"]').send_keys(
time_now)
self.dr.find_element_by_xpath('//*[@id="search"]').click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
self.pagination_num(paginal_number, option_chioce_value, 5)
self.pagination_num(paginal_number, time_now, 4)
self.dr.find_element_by_xpath(reset).click()
time.sleep(1)
self.dr.find_element_by_xpath(search).click()
self.assertEqual(
'',
self.dr.find_element_by_xpath(
'//*[@id="dutyDates"]').get_attribute('value'), '日期-重置功能异常')
self.assertEqual(
'全部',
self.dr.find_element_by_xpath(
'//*[@id="form"]/div[2]/div/select/option[1]').text,
'值班类型-重置功能异常')
print('勤务管理-值班管理：查询功能正常')
def test04_zidingyicheliang_edit(self):
self.zidingyicheliang_search()
search_value_cphm = sheet.col_values(1, 0, 1)[0]
cphm_path = sheet.col_values(1, 1, 2)[0]
self.dr.find_element_by_xpath(cphm_path).send_keys(search_value_cphm)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(2)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 3
self.pagination_num(paginal_number, search_value_cphm, column)
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr[1]/td[11]/a').click()
self.dr.find_element_by_xpath('//*[@id="monitorReason"]').send_keys(
sheet.col_values(2, 2, 3)[0])
self.dr.find_element_by_xpath('//*[@id="modifyBy"]').send_keys(
sheet.col_values(2, 3, 4)[0])
self.dr.find_element_by_xpath(saveBtn).click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(1)
self.assertEqual(
sheet_prompt_message.col_values(1, 1, 2)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'新增成功提示信息校验')
print('车辆管理-自定义车辆：新增功能正常')
def test02_czrk_search_cardid(self):
self.czrk_search()
self.dr.implicitly_wait(30)
self.dr.find_element_by_xpath(sheet.col_values(1, 3, 4)[0]).send_keys(
sheet.col_values(1, 2, 3)[0])
self.dr.find_element_by_xpath(search).click()
time.sleep(240)
# WebDriverWait(self.dr, 240).until(
# self.bj(sheet.col_values(1, 2, 3)[0], self.dr.find_element_by_xpath('//*[@id="list"]/tbody/tr/td[2]').text))
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 2
self.pagination_num(paginal_number,
sheet.col_values(1, 2, 3)[0], column)
self.dr.find_element_by_xpath(reset).click()
self.dr.implicitly_wait(10)
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.assertEqual(
'',
self.dr.find_element_by_xpath(sheet.col_values(
1, 3, 4)[0]).get_attribute('value'), '身份证号码-重置功能异常')
print('人口管理-人员基本信息-常住人口:身份证号条件查询功能正常')
def test06_shebian_details(self):
self.shebian_search()
search_value_cardid = sheet.col_values(1, 2, 3)[0]
cardid_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(cardid_path).send_keys(
search_value_cardid)
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 3
self.pagination_num(paginal_number, search_value_cardid, column)
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr/td[10]/a').click()
time.sleep(2)
self.assertEqual(
search_value_cardid,
self.dr.find_element_by_xpath('//*[@id="gmsfhm"]').get_attribute(
'value'), '详情页-身份证号')
self.assertEqual(
sheet.col_values(1, 0, 1)[0],
self.dr.find_element_by_xpath('//*[@id="xm"]').text, '详情页-姓名')
self.dr.find_element_by_xpath(goback).click()
self.assertEqual('涉边/涉稳/涉恐/涉外人员',
self.dr.find_element_by_xpath(page_title).text,
'返回功能异常')
print('涉边|涉恐|涉稳|涉外人员-详情功能正常')
def test04_zidingyi_search_age(self):
self.zidingyi_search()
search_value_age1 = sheet.col_values(1, 4, 5)[0]
search_value_age2 = sheet.col_values(1, 6, 7)[0]
self.dr.find_element_by_xpath(sheet.col_values(
1, 5, 6)[0]).send_keys(search_value_age1)
self.dr.find_element_by_xpath(sheet.col_values(
1, 7, 8)[0]).send_keys(search_value_age2)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(10)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 7
self.pagination_num(paginal_number, search_value_age1, column)
self.dr.find_element_by_xpath(reset).click()
time.sleep(2)
self.dr.find_element_by_xpath(search).click()
self.assertEqual(
'',
self.dr.find_element_by_xpath(sheet.col_values(
1, 5, 6)[0]).get_attribute('value'), '年龄段-重置功能异常')
self.assertEqual(
'',
self.dr.find_element_by_xpath(sheet.col_values(
1, 7, 8)[0]).get_attribute('value'), '年龄段-重置功能异常')
print('人口管理-自定义人员：年龄条件查询')
def test08_qunfangxinxiguanli_delete(self):
self.qunfangxinxiguanli_search()
search_value_infoLabel='宗教'
search_value_infoLabel = sheet.col_values(1, 0, 1)[0]
infoLabel_path = sheet.col_values(1, 1, 2)[0]
self.dr.find_element_by_xpath(infoLabel_path).send_keys(search_value_infoLabel)
search_value_infoKeyword = sheet.col_values(1, 2, 3)[0]
infoKeyword_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(infoKeyword_path).send_keys(search_value_infoKeyword)
search_value_infoSort = sheet.col_values(1, 4, 5)[0]
infoSort_path = sheet.col_values(1, 5, 6)[0]
self.dr.find_element_by_xpath(infoSort_path).send_keys(search_value_infoSort)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(sheet_setting.col_values(4, 1, 2)[0]).text
self.pagination_num(paginal_number, search_value_infoSort, 4)
self.pagination_num(paginal_number, search_value_infoKeyword, 5)
self.pagination_num(paginal_number, search_value_infoLabel, 6)
self.dr.find_element_by_xpath('//*[@id="list"]/thead/tr/th[1]/div[1]/input').click()
self.dr.find_element_by_xpath('/html/body/div[3]/div[1]/div[2]/a[1]').click()
self.dr.switch_to.default_content()
time.sleep(2)
self.dr.find_element_by_xpath('/html/body/div[3]/div[3]/div/button[2]/span').click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(1)
self.assertEqual(sheet_prompt_message.col_values(1, 3, 4)[0],
self.dr.find_element_by_xpath('//*[@id="gritter-item-1"]/div[2]/div[2]/p').text, '校验删除成功提示信息')
print('人口管理-群防信息管理：删除功能正常')
def test06_zidingyi_details(self):
self.zidingyi_search()
search_value_cardid = sheet.col_values(1, 2, 3)[0]
cardid_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(cardid_path).send_keys(
search_value_cardid)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(10)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 4
self.pagination_num(paginal_number, search_value_cardid, column)
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr/td[11]/a').click()
self.assertEqual(
search_value_cardid,
self.dr.find_element_by_xpath('//*[@id="gmsfhm"]').get_attribute(
'value'), '详情页面校验身份证号异常')
self.assertEqual(
sheet.col_values(1, 0, 1)[0],
self.dr.find_element_by_xpath('//*[@id="xm"]').text, '详情页面校验姓名异常')
self.assertEqual(
sheet.col_values(1, 8, 9)[0],
self.dr.find_element_by_xpath(
'//*[@id="personsType"]').get_attribute('value'), '详情页面校验类别异常')
self.dr.find_element_by_xpath(goback).click()
self.assertEqual('自定义人员监控',
self.dr.find_element_by_xpath(page_title).text,
'自定义人员')
print('人口管理-自定义人员：详情功能正常')
def test07_fahui_delete(self):
self.fahui_search()
search_value_name = sheet.col_values(2, 0, 1)[0]
name_path = sheet.col_values(1, 1, 2)[0]
self.dr.find_element_by_xpath(name_path).send_keys(search_value_name)
search_value_address = sheet.col_values(2, 2, 3)[0]
address_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(address_path).send_keys(
search_value_address)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 2, 3)[0]).text
self.pagination_num(paginal_number, search_value_address, 4)
self.pagination_num(paginal_number, search_value_name, 3)
self.dr.find_element_by_xpath(
'//*[@id="list"]/thead/tr/th[1]/div[1]/input').click()
self.dr.find_element_by_xpath(
'/html/body/div[4]/div[1]/div[2]/a[1]').click()
self.dr.switch_to.default_content()
time.sleep(2)
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[3]/div/button[2]/span').click()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
self.assertEqual(
'没有找到匹配的记录',
self.dr.find_element_by_xpath('//*[@id="list"]/tbody/tr/td').text,
'校验删除是否成功')
print('人口管理-701数据库-法会：删除功能正常')
def test09_simiao_delete(self):
self.simiao_search()
search_value_name = sheet.col_values(2, 0, 1)[0]
name_path = sheet.col_values(1, 1, 2)[0]
self.dr.find_element_by_xpath(name_path).send_keys(search_value_name)
search_value_address = sheet.col_values(2, 2, 3)[0]
address_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(address_path).send_keys(
search_value_address)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
self.pagination_num(paginal_number, search_value_name, 2)
self.pagination_num(paginal_number, search_value_address, 3)
self.dr.find_element_by_xpath(
'//*[@id="list"]/thead/tr/th[1]/div[1]/input').click()
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[1]/div[2]/a[1]').click()
self.dr.switch_to.default_content()
time.sleep(2)
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[3]/div/button[2]/span').click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(1)
self.assertEqual(
sheet_prompt_message.col_values(1, 3, 4)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'校验删除成功提示信息')
print('人口管理-701数据库-寺庙：删除功能正常')
def test04_jingshenbing_search_age(self):
self.jingshenbing_search()
search_value_1 = sheet.col_values(1, 4, 5)[0]
search_value_2 = sheet.col_values(1, 6, 7)[0]
self.dr.find_element_by_xpath(sheet.col_values(
1, 5, 6)[0]).send_keys(search_value_1)
self.dr.find_element_by_xpath(sheet.col_values(
1, 7, 8)[0]).send_keys(search_value_2)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 7
self.pagination_num(paginal_number, search_value_1, column)
self.dr.find_element_by_xpath(reset).click()
self.dr.implicitly_wait(10)
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.assertEqual(
'',
self.dr.find_element_by_xpath(sheet.col_values(
1, 5, 6)[0]).get_attribute('value'), '重置功能')
self.assertEqual(
'',
self.dr.find_element_by_xpath(sheet.col_values(
1, 7, 8)[0]).get_attribute('value'), '重置功能')
print('人口管理-部局七类库-精神病人员：年龄段条件查询功能正常')
def test07_sanfei_search_details(self):
self.sanfei_search()
search_value_carid = sheet.col_values(1, 4, 5)[0]
cardid_path = sheet.col_values(1, 5, 6)[0]
self.dr.find_element_by_xpath(cardid_path).send_keys(
search_value_carid)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 5
self.pagination_num(paginal_number, search_value_carid, column)
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr[1]/td[8]/a').click()
self.assertEqual(
sheet.col_values(1, 0, 1)[0],
self.dr.find_element_by_xpath(
'//*[@id="personName"]').get_attribute('value'), '详情页面校验姓名异常')
self.assertEqual(
sheet.col_values(1, 4, 5)[0],
self.dr.find_element_by_xpath('//*[@id="idNumber"]').get_attribute(
'value'), '详情页面校验身份证号码异常')
time.sleep(1)
self.dr.find_element_by_xpath(goback).click()
self.assertEqual(
'三非人员信息列表',
self.dr.find_element_by_xpath('/html/body/div[1]/p').text, '三非人员')
print('人口管理-部局七类库-三非人员：详情页面功能正常')
def test06_exz_search_all(self):
self.exz_search()
self.dr.find_element_by_xpath(sheet.col_values(1, 1, 2)[0]).send_keys(sheet.col_values(0, 1, 2)[0])
self.dr.find_element_by_xpath(sheet.col_values(3, 1, 2)[0]).send_keys(sheet.col_values(2, 1, 2)[0])
self.dr.find_element_by_xpath(sheet.col_values(5, 1, 2)[0]).send_keys(sheet.col_values(4, 1, 2)[0])
self.dr.find_element_by_xpath(sheet.col_values(9, 1, 2)[0]).send_keys(sheet.col_values(8, 1, 2)[0])
self.dr.find_element_by_xpath(sheet.col_values(11, 1, 2)[0]).send_keys(sheet.col_values(10, 1, 2)[0])
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(sheet_setting.col_values(4, 1, 2)[0]).text
self.pagination_num(paginal_number, sheet.col_values(0, 1, 2)[0], 2)
self.pagination_num(paginal_number, sheet.col_values(2, 1, 2)[0], 3)
self.pagination_num(paginal_number, sheet.col_values(4, 1, 2)[0], 4)
self.pagination_num(paginal_number, sheet.col_values(8, 1, 2)[0], 7)
self.pagination_num(paginal_number, sheet.col_values(10, 1, 2)[0], 7)
self.dr.find_element_by_xpath(reset).click()
self.dr.implicitly_wait(10)
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.assertEqual('', self.dr.find_element_by_xpath(sheet.col_values(1, 1, 2)[0]).get_attribute('value'),
'姓名-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(sheet.col_values(3, 1, 2)[0]).get_attribute('value'),
'身份证号-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(sheet.col_values(5, 1, 2)[0]).get_attribute('value'),
'通行证编号-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(sheet.col_values(9, 1, 2)[0]).get_attribute('value'),
'通行证编号-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(sheet.col_values(11, 1, 2)[0]).get_attribute('value'),
'通行证编号-重置功能异常')
print('二线站过往记录：条件查询功能正常')
def test01_fahui_add(self):
self.fahui_search()
self.dr.find_element_by_xpath(
'/html/body/div[4]/div[1]/div[2]/a[2]').click()
self.dr.find_element_by_xpath('//*[@id="ceremonyName"]').send_keys(
sheet.col_values(1, 0, 1)[0])
self.dr.find_element_by_xpath('//*[@id="ceremonyArea"]').send_keys(
sheet.col_values(1, 2, 3)[0])
self.dr.find_element_by_xpath(
'//*[@id="organizateMonkNum"]').send_keys(
sheet.col_values(1, 4, 5)[0])
self.dr.find_element_by_xpath('//*[@id="realityMonkNum"]').send_keys(
sheet.col_values(1, 5, 6)[0])
self.dr.find_element_by_xpath(
'//*[@id="conscientiousPolice"]').send_keys(
sheet.col_values(1, 6, 7)[0])
self.dr.find_element_by_xpath('//*[@id="telephone"]').send_keys(
sheet.col_values(1, 7, 8)[0])
self.dr.find_element_by_xpath('//*[@id="remarks"]').send_keys(
sheet.col_values(1, 8, 9)[0])
self.dr.find_element_by_xpath(sheet_setting.col_values(6, 2,
3)[0]).click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(2)
self.assertEqual(
sheet_prompt_message.col_values(1, 4, 5)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'新增成功提示信息校验')
print('人口管理-701数据库-法会：新增功能正常')
def test06_bfz_search_all(self):
self.bfz_search()
self.dr.find_element_by_xpath(sheet.col_values(1, 1, 2)[0]).send_keys(sheet.col_values(1, 0, 1)[0])
self.dr.find_element_by_xpath(sheet.col_values(1, 3, 4)[0]).send_keys(sheet.col_values(1, 2, 3)[0])
self.dr.find_element_by_xpath(sheet.col_values(1, 5, 6)[0]).send_keys(sheet.col_values(1, 4, 5)[0])
self.dr.find_element_by_xpath(sheet.col_values(1, 9, 10)[0]).send_keys(sheet.col_values(1, 8, 9)[0])
self.dr.find_element_by_xpath(sheet.col_values(1, 11, 12)[0]).send_keys(sheet.col_values(1, 10, 11)[0])
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(sheet_setting.col_values(4, 1, 2)[0]).text
self.pagination_num(paginal_number, sheet.col_values(1, 0, 1)[0], 2)
self.pagination_num(paginal_number, sheet.col_values(1, 2, 3)[0], 3)
self.pagination_num(paginal_number, sheet.col_values(1, 4, 5)[0], 4)
self.pagination_num(paginal_number, sheet.col_values(1, 8, 9)[0], 8)
self.pagination_num(paginal_number, sheet.col_values(1, 10, 11)[0], 8)
self.dr.find_element_by_xpath(reset).click()
self.dr.implicitly_wait(10)
self.dr.find_element_by_xpath(search).click()
time.sleep(5)
self.assertEqual('', self.dr.find_element_by_xpath(sheet.col_values(1, 1, 2)[0]).get_attribute('value'),
'姓名-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(sheet.col_values(1, 3, 4)[0]).get_attribute('value'),
'身份证号码-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(sheet.col_values(1, 5, 6)[0]).get_attribute('value'),
'姓名-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(sheet.col_values(1, 9, 10)[0]).get_attribute('value'),
'开始日期-重置功能异常')
self.assertEqual('', self.dr.find_element_by_xpath(sheet.col_values(1, 11, 12)[0]).get_attribute('value'),
'结束日期-重置功能异常')
def test06_shebao_details(self):
self.shebao_search()
search_value_cardid = sheet.col_values(1, 2, 3)[0]
cardid_path = sheet.col_values(1, 3, 4)[0]
self.dr.find_element_by_xpath(cardid_path).send_keys(
search_value_cardid)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 3
self.pagination_num(paginal_number, search_value_cardid, column)
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr/td[8]/a').click()
time.sleep(2)
self.assertEqual(
search_value_cardid,
self.dr.find_element_by_xpath('//*[@id="gmsfhm"]').get_attribute(
'value'), '详情页身份证号校验异常')
self.assertEqual(
sheet.col_values(1, 0, 1)[0],
self.dr.find_element_by_xpath('//*[@id="xm"]').text, '详情页面姓名校验异常')
self.assertEqual(
sheet.col_values(1, 4, 5)[0],
self.dr.find_element_by_xpath('//*[@id="zyzbh"]').get_attribute(
'value'), '详情页面作业证编号校验异常')
self.dr.find_element_by_xpath(goback).click()
self.assertEqual('涉爆人员',
self.dr.find_element_by_xpath(page_title).text,
'涉爆人员')
print('人口管理-局部七类库-涉爆人员：详情功能正常')
def test07_qunfangxinxiguanli_edit(self):
self.qunfangxinxiguanli_search()
search_value_infoLabel = sheet.col_values(1, 0, 1)[0]
infoLabel_path = sheet.col_values(1, 1, 2)[0]
self.dr.find_element_by_xpath(infoLabel_path).send_keys(
search_value_infoLabel)
self.dr.find_element_by_xpath(search).click()
self.dr.switch_to.default_content()
time.sleep(5)
self.dr.switch_to.frame('iframeb')
paginal_number = self.dr.find_element_by_xpath(
sheet_setting.col_values(4, 1, 2)[0]).text
column = 6
self.pagination_num(paginal_number, search_value_infoLabel, column)
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr[1]/td[7]/a').click()
self.dr.find_element_by_xpath('//*[@id="infoValueEvaluate"]').clear()
self.dr.find_element_by_xpath(
'//*[@id="infoValueEvaluate"]').send_keys('良好')
self.dr.find_element_by_xpath('//*[@id="saveBtn"]').click()
time.sleep(3)
self.dr.find_element_by_xpath('/html/body/a').click()
self.dr.implicitly_wait(2)
self.assertEqual(
'林峰',
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr[1]/td[2]').text, '校验编辑、返回和默认排序')
self.assertEqual(
'良好',
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr[1]/td[3]').text, '校验编辑、返回和默认排序')
print('人口管理-群防信息管理：编辑功能正常')
