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('人口管理-群防信息管理:编辑功能正常')