def test01_zidingyicheliang_add(self):
self.zidingyicheliang_search()
add_value_cphm = sheet.col_values(1, 0, 1)[0]
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[1]/div[2]/a[2]').click()
self.dr.find_element_by_xpath('//*[@id="vehicleNo"]').send_keys(
add_value_cphm)
self.dr.find_element_by_xpath(
'//*[@id="veForm"]/div[1]/div[2]/a/span').click()
time.sleep(2)
self.dr.find_element_by_xpath('//*[@id="monitorReason"]').send_keys(
sheet.col_values(1, 2, 3)[0])
self.dr.find_element_by_xpath('//*[@id="modifyBy"]').send_keys(
sheet.col_values(1, 3, 4)[0])
self.dr.find_element_by_xpath('//*[@id="monitorUnit"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="treeSelect_45_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="treeSelect_46_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath('//*[@id="treeSelect_48_span"]').click()
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 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 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 test08_shebian_delete(self):
self.shebian_search()
add_value_cardid = sheet.col_values(1, 2, 3)[0]
self.dr.find_element_by_xpath(sheet.col_values(
1, 3, 4)[0]).send_keys(add_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')
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr/td[2]/input').click()
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[1]/div[2]/a[1]').click()
time.sleep(2)
self.dr.switch_to.default_content()
time.sleep(1)
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 test02_qjgl_add_test(self):
self.qjgl_search_test()
self.dr.find_element_by_xpath('/html/body/div[3]/div[1]/div[2]/a[2]').click()
global add_value_user_test
add_value_user_test=self.dr.find_element_by_xpath('//*[@id="proposer"]').get_attribute('value')
self.dr.find_element_by_xpath('//*[@id="startTime"]').click()
self.dr.find_element_by_xpath('//*[@id="startTime"]').clear()
self.dr.find_element_by_xpath('//*[@id="startTime"]').send_keys('2018-09-13 08:00:00')
self.dr.find_element_by_xpath('//*[@id="endTime"]').click()
self.dr.find_element_by_xpath('//*[@id="endTime"]').clear()
self.dr.find_element_by_xpath('//*[@id="endTime"]').send_keys('2018-09-13 18:00:00')
self.dr.find_element_by_xpath('//*[@id="totalTime"]').click()
self.dr.find_element_by_xpath('//*[@id="totalTime"]').send_keys('8')
Select(self.dr.find_element_by_xpath('//*[@id="wad"]')).select_by_value('1')
self.dr.find_element_by_xpath('//*[@id="reason"]').send_keys('家中老人生病，需要请假到医院陪同看病！')
self.dr.find_element_by_xpath('//*[@id="urgentTel"]').send_keys('15874574587')
self.dr.find_element_by_xpath('//*[@id="director"]').send_keys('包拯')
self.dr.find_element_by_xpath('//*[@id="approval"]').send_keys('情况属实，予以批准')
self.dr.find_element_by_xpath('//*[@id="approvalOpinion"]').send_keys('包拯')
self.dr.find_element_by_xpath('//*[@id="approvalTime"]').click()
Select(self.dr.find_element_by_xpath('//*[@id="approvalResult"]')).select_by_value('1')
self.dr.find_element_by_xpath('//*[@id="save"]').click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(1)
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('勤务管理-人员请假管理：新增功能正常')
def test08_shebao_delete(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[2]/input').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[1]/div[2]/a[1]').click()
time.sleep(2)
self.dr.switch_to.default_content()
time.sleep(1)
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 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 test01_simiao_add(self):
self.simiao_search()
search_add_name = sheet.col_values(1, 0, 1)[0]
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[1]/div[2]/a[2]').click()
self.dr.find_element_by_xpath('//*[@id="name"]').send_keys(
search_add_name)
self.dr.find_element_by_xpath('//*[@id="location"]').send_keys(
sheet.col_values(1, 2, 3)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="category"]')).select_by_value('1')
self.dr.find_element_by_xpath('//*[@id="compilingCount"]').send_keys(
sheet.col_values(1, 8, 9)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="rank"]')).select_by_value('2')
self.dr.find_element_by_xpath('//*[@id="realCount"]').send_keys(
sheet.col_values(1, 9, 10)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="police"]')).select_by_value(
sheet.col_values(1, 12, 13)[0])
self.dr.find_element_by_xpath('//*[@id="contact"]').send_keys(
sheet.col_values(1, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="remark"]').send_keys(
sheet.col_values(1, 11, 12)[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, 4, 5)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'新增成功提示信息校验')
print('人口管理-701数据库-寺庙：新增功能正常')
def test01_jingshenbing_add(self):
self.jingshenbing_search()
self.dr.find_element_by_xpath('/html/body/div[3]/div[1]/div[2]/a[2]').click()
self.dr.switch_to.default_content()
time.sleep(2)
self.dr.switch_to.frame('iframeb')
add_value_cardid =sheet.col_values(1,2,3)[0]
self.dr.find_element_by_xpath('//*[@id="gmsfhm"]').send_keys(add_value_cardid)
self.dr.find_element_by_xpath('//*[@id="mentForm"]/div[1]/div[2]/div/div[1]/div[2]/a').click()
time.sleep(2)
Select(self.dr.find_element_by_xpath('//*[@id="sfyjd"]')).select_by_value('1')
Select(self.dr.find_element_by_xpath('//*[@id="zl"]')).select_by_value('1')
self.dr.find_element_by_xpath('//*[@id="zdfbsjd"]').send_keys(sheet.col_values(1,8,9)[0])
Select(self.dr.find_element_by_xpath('//*[@id="fbswhcd"]')).select_by_value('2')
self.dr.find_element_by_xpath('//*[@id="zrmj"]').send_keys(sheet.col_values(1,9,10)[0])
# print(sheet.col_values(1,10,11)[0])
self.dr.find_element_by_xpath('//*[@id="mjdha"]').send_keys(sheet.col_values(1,10,11)[0])
self.dr.find_element_by_xpath('//*[@id="mjdhb"]').send_keys(sheet.col_values(1,11,12)[0])
self.dr.find_element_by_xpath('//*[@id="sfccjcz"]').send_keys(sheet.col_values(1,12,13)[0])
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').send_keys(sheet.col_values(1,13,14)[0])
self.dr.find_element_by_xpath('//*[@id="supervName"]').send_keys(sheet.col_values(1,14,15)[0])
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').send_keys(sheet.col_values(1,15,16)[0])
self.dr.find_element_by_xpath('//*[@id="supervWx"]').send_keys(sheet.col_values(1,16,17)[0])
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').send_keys(sheet.col_values(1,17,18)[0])
self.dr.find_element_by_xpath('//*[@id="jhrXm"]').send_keys(sheet.col_values(1,18,19)[0])
self.dr.find_element_by_xpath('//*[@id="sqgbXm"]').send_keys(sheet.col_values(1,19,20)[0])
self.dr.find_element_by_xpath('//*[@id="jhrDh"]').send_keys(sheet.col_values(1,20,21)[0])
self.dr.find_element_by_xpath('//*[@id="sqgbDh"]').send_keys(sheet.col_values(1,21,22)[0])
self.dr.find_element_by_xpath('//*[@id="saveBtn"]').click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(2)
self.assertEqual(sheet_prompt_message.col_values(1, 0, 1)[0],
self.dr.find_element_by_xpath('//*[@id="gritter-item-1"]/div[2]/div[2]/p').text, '新增成功提示信息校验')
print('人口管理-部局七类库-精神病人员：新增功能正常')
def test01_qunfangxinxiguanli_add(self):
self.qunfangxinxiguanli_search()
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[1]/div[2]/a[2]').click()
self.dr.find_element_by_xpath('//*[@id="infoCollectIp"]').send_keys(
sheet.col_values(1, 6, 7)[0])
self.dr.find_element_by_xpath(
'//*[@id="infoCollectPerson"]').send_keys(
sheet.col_values(1, 7, 8)[0])
self.dr.find_element_by_xpath('//*[@id="infoSort"]').send_keys(
sheet.col_values(1, 8, 9)[0])
self.dr.find_element_by_xpath('//*[@id="infoKeyword"]').send_keys(
sheet.col_values(1, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="infoLabel"]').send_keys(
sheet.col_values(1, 10, 11)[0])
self.dr.find_element_by_xpath(
'//*[@id="infoValueEvaluate"]').send_keys(
sheet.col_values(1, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="infoRemark"]').send_keys(
sheet.col_values(1, 12, 13)[0])
self.dr.find_element_by_xpath(saveBtn).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('人口管理-群防信息管理：新增功能正常')
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 test01_jcjdj_add(self):
self.jcjdj_search()
self.dr.find_element_by_xpath('/html/body/div[3]/div[1]/div[2]/a[2]').click()
self.dr.find_element_by_xpath('//*[@id="alarmTimeA"]').click()
self.dr.find_element_by_xpath('//*[@id="alarmTimeA"]').clear()
times=time.strftime("%Y-%m-%d-%H-%M-%S", time.localtime(time.time()))
self.dr.find_element_by_xpath('//*[@id="alarmTimeA"]').send_keys(times)
self.dr.find_element_by_xpath('//*[@id="alarmpeopleTel"]').send_keys('15874587458')
Select(self.dr.find_element_by_xpath('//*[@id="reportalarmType"]')).select_by_value('2')
self.dr.find_element_by_xpath('//*[@id="alarmpeople"]').send_keys('马腾')
self.dr.find_element_by_xpath('//*[@id="unitAddress"]').send_keys('北京中路24号')
Select(self.dr.find_element_by_xpath('//*[@id="alertType"]')).select_by_value('5')
self.dr.find_element_by_xpath('//*[@id="alertAddress"]').send_keys('北京中路与康昂多南路十字路口')
self.dr.find_element_by_xpath('//*[@id="contentValidity"]').send_keys('北京中路与康昂多南路十字路口发生交通肇事逃逸，目前摩托车被撞2名人员倒地不起，肇事车辆直接驶离现场')
self.dr.find_element_by_xpath('//*[@id="disposeSituation"]').send_keys('立即出警救援，并已拨打120救援车赶往现场。')
self.dr.find_element_by_xpath('//*[@id="disposePerson"]').send_keys('马辰')
self.dr.find_element_by_xpath('//*[@id="disposeTimeA"]').click()
self.dr.find_element_by_xpath('//*[@id="disposeTimeA"]').clear()
self.dr.find_element_by_xpath('//*[@id="disposeTimeA"]').send_keys(times)
self.dr.find_element_by_xpath('//*[@id="dutyLeader"]').click()
self.dr.find_element_by_xpath('//*[@id="dutyLeader"]').send_keys('包拯')
Select(self.dr.find_element_by_xpath('//*[@id="result"]')).select_by_value('1')
self.dr.find_element_by_xpath('//*[@id="resultRemark"]').send_keys('通过录像查看到肇事车辆车牌号为藏A25478，已经开始抓捕。')
self.dr.find_element_by_xpath('//*[@id="hurtNum"]').send_keys('2')
self.dr.find_element_by_xpath('//*[@id="deathToll"]').send_keys('0')
self.dr.find_element_by_xpath('//*[@id="economicsLoss"]').send_keys('24000')
self.dr.find_element_by_xpath('//*[@id="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, 4, 5)[0],
self.dr.find_element_by_xpath('//*[@id="gritter-item-1"]/div[2]/div[2]/p').text, '新增成功提示信息校验')
print('社区警务-接处警登记：新增功能正常')
def test07_shebao_edit(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()
self.dr.find_element_by_xpath('//*[@id="xjzdz"]').clear()
self.dr.find_element_by_xpath('//*[@id="xjzdz"]').send_keys(
sheet.col_values(2, 6, 7)[0])
self.dr.find_element_by_xpath('//*[@id="zyzbh"]').clear()
self.dr.find_element_by_xpath('//*[@id="zyzbh"]').send_keys(
sheet.col_values(2, 7, 8)[0])
self.dr.find_element_by_xpath('//*[@id="gzdw"]').clear()
self.dr.find_element_by_xpath('//*[@id="gzdw"]').send_keys(
sheet.col_values(2, 8, 9)[0])
option_chioce = Select(
self.dr.find_element_by_xpath('//*[@id="sbzt"]'))
option_chioce.select_by_index(2)
self.dr.find_element_by_xpath('//*[@id="fzjg"]').clear()
self.dr.find_element_by_xpath('//*[@id="fzjg"]').send_keys(
sheet.col_values(2, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="supervName"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervName"]').send_keys(
sheet.col_values(2, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').send_keys(
sheet.col_values(2, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="supervWx"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervWx"]').send_keys(
sheet.col_values(2, 12, 13)[0])
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').clear()
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').send_keys(
sheet.col_values(2, 13, 14)[0])
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').send_keys(
sheet.col_values(2, 14, 15)[0])
self.dr.find_element_by_xpath(saveBtn).click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(2)
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 test01_sihei_add(self):
self.sihei_search()
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[1]/div[2]/a[2]').click()
add_search_carid = sheet.col_values(1, 2, 3)[0]
self.dr.find_element_by_xpath('//*[@id="idCard"]').send_keys(
add_search_carid)
Select(self.dr.find_element_by_xpath(
'//*[@id="personType"]')).select_by_value('1')
self.dr.find_element_by_xpath('//*[@id="mainBusiness"]').send_keys(
sheet.col_values(1, 8, 9)[0])
self.dr.find_element_by_xpath('//*[@id="personName"]').send_keys(
sheet.col_values(1, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="mainTourists"]').send_keys(
sheet.col_values(1, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="activityArea"]').send_keys(
sheet.col_values(1, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="activityTimeSlot"]').send_keys(
sheet.col_values(1, 12, 13)[0])
self.dr.find_element_by_xpath('//*[@id="startBlackDate"]').send_keys(
sheet.col_values(1, 13, 14)[0])
self.dr.find_element_by_xpath('//*[@id="dayTraffic"]').click()
self.dr.find_element_by_xpath('//*[@id="dayTraffic"]').send_keys(
sheet.col_values(1, 14, 15)[0])
self.dr.find_element_by_xpath('//*[@id="averagePrice"]').send_keys(
sheet.col_values(1, 15, 16)[0])
self.dr.find_element_by_xpath('//*[@id="riskAssess"]').send_keys(
sheet.col_values(1, 16, 17)[0])
self.dr.find_element_by_xpath('//*[@id="dutyPerson"]').send_keys(
sheet.col_values(1, 17, 18)[0])
#责任单位
self.dr.find_element_by_xpath('//*[@id="dutyOrg"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="treeSelect_45_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="treeSelect_46_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath('//*[@id="treeSelect_48_span"]').click()
time.sleep(2)
self.dr.find_element_by_xpath('//*[@id="dayTraffic"]').click()
time.sleep(1)
self.dr.find_element_by_xpath('//*[@id="remark"]').send_keys(
sheet.col_values(1, 19, 20)[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, 4, 5)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'新增成功提示信息校验')
print('人口管理-部局七类库-四黑人员：新增功能正常')
def test08_simiao_edit(self):
self.simiao_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, 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"]/tbody/tr[1]/td[9]/a').click()
self.dr.find_element_by_xpath('//*[@id="name"]').clear()
self.dr.find_element_by_xpath('//*[@id="name"]').send_keys(
sheet.col_values(2, 0, 1)[0])
self.dr.find_element_by_xpath('//*[@id="location"]').clear()
self.dr.find_element_by_xpath('//*[@id="location"]').send_keys(
sheet.col_values(2, 2, 3)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="category"]')).select_by_value('5')
self.dr.find_element_by_xpath('//*[@id="compilingCount"]').clear()
self.dr.find_element_by_xpath('//*[@id="compilingCount"]').send_keys(
sheet.col_values(2, 8, 9)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="rank"]')).select_by_value('3')
self.dr.find_element_by_xpath('//*[@id="realCount"]').clear()
self.dr.find_element_by_xpath('//*[@id="realCount"]').send_keys(
sheet.col_values(2, 9, 10)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="police"]')).select_by_value(
sheet.col_values(2, 12, 13)[0])
self.dr.find_element_by_xpath('//*[@id="contact"]').clear()
self.dr.find_element_by_xpath('//*[@id="contact"]').send_keys(
sheet.col_values(2, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="remark"]').clear()
self.dr.find_element_by_xpath('//*[@id="remark"]').send_keys(
sheet.col_values(2, 11, 12)[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, 4, 5)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'编辑修改成功提示信息校验')
print('人口管理-701数据库-寺庙：编辑修改功能正常')
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 test07_sheqiang_edit(self):
self.sheqiang_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('//*[@id="gmsfhm"]').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 = 3
self.pagination_num(paginal_number, search_value_cardid, column)
self.dr.find_element_by_xpath(
'//*[@id="list"]/tbody/tr[1]/td[8]/a').click()
self.dr.find_element_by_xpath('//*[@id="cqzbh"]').clear()
self.dr.find_element_by_xpath('//*[@id="cqzbh"]').send_keys(
sheet.col_values(2, 4, 5)[0])
self.dr.find_element_by_xpath('//*[@id="fzsj"]').clear()
self.dr.find_element_by_xpath('//*[@id="fzsj"]').send_keys(
sheet.col_values(2, 6, 7)[0])
self.dr.find_element_by_xpath('//*[@id="szdw"]').clear()
self.dr.find_element_by_xpath('//*[@id="szdw"]').send_keys(
sheet.col_values(2, 7, 8)[0])
self.dr.find_element_by_xpath('//*[@id="supervName"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervName"]').send_keys(
sheet.col_values(2, 8, 9)[0])
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').send_keys(
sheet.col_values(2, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="supervWx"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervWx"]').send_keys(
sheet.col_values(2, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').clear()
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').send_keys(
sheet.col_values(2, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').send_keys(
sheet.col_values(2, 12, 13)[0])
self.dr.find_element_by_xpath(saveBtn).click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(2)
self.assertEqual(
sheet_prompt_message.col_values(1, 0, 1)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'编辑修改成功提示信息校验')
print('人口管理-局部七类库-涉枪人员：编辑修改功能正常')
def test07_jingshengbing_edit(self):
self.jingshenbing_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[11]/a').click()
self.dr.find_element_by_xpath('//*[@id="zdfbsjd"]').clear()
self.dr.find_element_by_xpath('//*[@id="zdfbsjd"]').send_keys(sheet.col_values(2, 8, 9)[0])
Select(self.dr.find_element_by_xpath('//*[@id="fbswhcd"]')).select_by_value('1')
self.dr.find_element_by_xpath('//*[@id="zrmj"]').clear()
self.dr.find_element_by_xpath('//*[@id="zrmj"]').send_keys(sheet.col_values(2, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="mjdha"]').clear()
self.dr.find_element_by_xpath('//*[@id="mjdha"]').send_keys(sheet.col_values(2, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="mjdhb"]').clear()
self.dr.find_element_by_xpath('//*[@id="mjdhb"]').send_keys(sheet.col_values(2, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="sfccjcz"]').clear()
self.dr.find_element_by_xpath('//*[@id="sfccjcz"]').send_keys(sheet.col_values(2, 12, 13)[0])
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').send_keys(sheet.col_values(2, 13, 14)[0])
self.dr.find_element_by_xpath('//*[@id="supervName"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervName"]').send_keys(sheet.col_values(2, 14, 15)[0])
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').clear()
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').send_keys(sheet.col_values(2, 15, 16)[0])
self.dr.find_element_by_xpath('//*[@id="supervWx"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervWx"]').send_keys(sheet.col_values(2, 16, 17)[0])
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').send_keys(sheet.col_values(2, 17, 18)[0])
self.dr.find_element_by_xpath('//*[@id="jhrXm"]').clear()
self.dr.find_element_by_xpath('//*[@id="jhrXm"]').send_keys(sheet.col_values(2, 18, 19)[0])
self.dr.find_element_by_xpath('//*[@id="sqgbXm"]').clear()
self.dr.find_element_by_xpath('//*[@id="sqgbXm"]').send_keys(sheet.col_values(2, 19, 20)[0])
self.dr.find_element_by_xpath('//*[@id="jhrDh"]').clear()
self.dr.find_element_by_xpath('//*[@id="jhrDh"]').send_keys(sheet.col_values(2, 20, 21)[0])
self.dr.find_element_by_xpath('//*[@id="sqgbDh"]').clear()
self.dr.find_element_by_xpath('//*[@id="sqgbDh"]').send_keys(sheet.col_values(2, 21, 22)[0])
self.dr.find_element_by_xpath(saveBtn).click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(2)
self.assertEqual(sheet_prompt_message.col_values(1, 0, 1)[0],
self.dr.find_element_by_xpath('//*[@id="gritter-item-1"]/div[2]/div[2]/p').text, '编辑修改成功提示信息校验')
print('人口管理-部局七类库-精神病人员：编辑修改功能正常')
def test01_shebian_add(self):
self.shebian_search()
add_value_carid = sheet.col_values(1,2,3)[0]
self.dr.find_element_by_xpath('/html/body/div[3]/div[1]/div[2]/a[2]').click()
self.dr.switch_to.default_content()
time.sleep(2)
self.dr.switch_to.frame('iframeb')
self.dr.find_element_by_xpath('//*[@id="gmsfhm"]').send_keys(add_value_carid)
self.dr.find_element_by_xpath('//*[@id="otherForm"]/div[1]/div[2]/div/div[1]/div[2]/a').click()
time.sleep(2)
self.dr.find_element_by_xpath('//*[@id="xjdz"]').send_keys(sheet.col_values(1,8,9)[0])
self.dr.find_element_by_xpath('//*[@id="tmtz"]').send_keys(sheet.col_values(1,9,10)[0])
option_jz = Select(self.dr.find_element_by_xpath('//*[@id="sfyjz"]'))
option_jz.select_by_index(1)
self.dr.find_element_by_xpath('//*[@id="jzlx"]').send_keys(sheet.col_values(1,10,11)[0])
self.dr.find_element_by_xpath('//*[@id="jzhm"]').send_keys(add_value_carid)
self.dr.find_element_by_xpath('//*[@id="qk"]').send_keys(sheet.col_values(1,12,13)[0])
self.dr.find_element_by_xpath('//*[@id="gddh"]').send_keys(sheet.col_values(1,13,14)[0])
self.dr.find_element_by_xpath('//*[@id="qqorip"]').send_keys(sheet.col_values(1,14,15)[0])
self.dr.find_element_by_xpath('//*[@id="hlwtxhm"]').send_keys(sheet.col_values(1,15,16)[0])
option_gj = Select(self.dr.find_element_by_xpath('//*[@id="gj"]'))
option_gj.select_by_visible_text('中国')
self.dr.find_element_by_xpath('//*[@id="hzhm"]').send_keys(sheet.col_values(1,16,17)[0])
self.dr.find_element_by_xpath('//*[@id="hdqk"]').send_keys(sheet.col_values(1,17,18)[0])
self.dr.find_element_by_xpath('//*[@id="sy"]').send_keys(sheet.col_values(1,18,19)[0])
self.dr.find_element_by_xpath('//*[@id="fs"]').send_keys(sheet.col_values(1,19,20)[0])
self.dr.find_element_by_xpath('//*[@id="jzdlx"]').send_keys(sheet.col_values(1,20,21)[0])
self.dr.find_element_by_xpath('//*[@id="zzzh"]').send_keys(sheet.col_values(1,21,22)[0])
# self.dr.find_element_by_xpath('//*[@id="dbdsj"]').click()
self.dr.find_element_by_xpath('//*[@id="zjhm"]').send_keys(sheet.col_values(1,22,23)[0])
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').send_keys(sheet.col_values(1,23,24)[0])
self.dr.find_element_by_xpath('//*[@id="supervName"]').send_keys(sheet.col_values(1,24,25)[0])
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').send_keys(sheet.col_values(1,25,26)[0])
self.dr.find_element_by_xpath('//*[@id="supervWx"]').send_keys(sheet.col_values(1,26,27)[0])
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').send_keys(sheet.col_values(1,27,28)[0])
time.sleep(2)
self.dr.find_element_by_xpath(saveBtn).click()
# self.dr.find_element_by_xpath(saveBtn).click()
# self.dr.find_element_by_xpath(saveBtn).click()
# self.dr.find_element_by_xpath(saveBtn).click()
# 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,0,1)[0],self.dr.find_element_by_xpath('//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,'新增成功提示信息校验')
print('人口管理-局部七类库-涉爆人员：新增涉边|涉恐|涉稳|涉外人员功能正常')
def test01_shebao_add(self):
self.shebao_search()
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[1]/div[2]/a[2]').click()
self.dr.switch_to.default_content()
time.sleep(2)
self.dr.switch_to.frame('iframeb')
add_value_cardid = sheet.col_values(1, 2, 3)[0]
self.dr.find_element_by_xpath('//*[@id="gmsfhm"]').send_keys(
add_value_cardid)
self.dr.find_element_by_xpath(
'//*[@id="wadeForm"]/div[1]/div[2]/div/div[1]/div[2]/a').click()
time.sleep(2)
self.dr.find_element_by_xpath('//*[@id="xjzdz"]').send_keys(
sheet.col_values(1, 6, 7)[0])
self.dr.find_element_by_xpath('//*[@id="zyzbh"]').send_keys(
sheet.col_values(1, 7, 8)[0])
self.dr.find_element_by_xpath('//*[@id="gzdw"]').send_keys(
sheet.col_values(1, 8, 9)[0])
option_chioce = Select(
self.dr.find_element_by_xpath('//*[@id="sbzt"]'))
option_chioce.select_by_index(1)
self.dr.find_element_by_xpath('//*[@id="fzjg"]').send_keys(
sheet.col_values(1, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="supervName"]').send_keys(
sheet.col_values(1, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').send_keys(
sheet.col_values(1, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="supervWx"]').send_keys(
sheet.col_values(1, 12, 13)[0])
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').send_keys(
sheet.col_values(1, 13, 14)[0])
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').send_keys(
sheet.col_values(1, 14, 15)[0])
time.sleep(2)
self.dr.find_element_by_xpath(saveBtn).click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(2)
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 test01_zhiqindian_add(self):
self.zhiqindian_search()
self.dr.find_element_by_xpath('/html/body/div[4]/div[1]/div[2]/a[2]').click()
add_value_name='色拉崩坚执勤任务'
self.dr.find_element_by_xpath('//*[@id="name"]').send_keys(add_value_name)
global codeid
codeid=self.dr.find_element_by_xpath('//*[@id="code"]').get_attribute('value')
self.dr.find_element_by_xpath('//*[@id="location"]').send_keys('拉萨市城关区色拉路1号')
self.dr.find_element_by_xpath('//*[@id="dailyCheckCount"]').send_keys('999999')
self.dr.find_element_by_xpath('//*[@id="importantPeriod"]').send_keys('00:00-06:00')
self.dr.find_element_by_xpath('//*[@id="entryExitPurpose"]').send_keys('拉萨公安民(辅)警彻夜维持秩序，为朝佛民众提供安全有序便利服务。')
Select(self.dr.find_element_by_xpath('//*[@id="ispassVehicle"]')).select_by_value('1')
Select(self.dr.find_element_by_xpath('//*[@id="ispassNonvehicle"]')).select_by_value('1')
self.dr.find_element_by_xpath('//*[@id="societyChn"]').send_keys('据了解，由于活动持续时间长，沿线设立了12处便民服务点，配置了60辆免费公交车。')
self.dr.find_element_by_xpath('//*[@id="malitarySocietyVn"]').send_keys('据了解，由于活动持续时间长，沿线设立了12处便民服务点，配置了60辆免费公交车。')
self.dr.find_element_by_xpath('//*[@id="riskEvaluation"]').send_keys('设立了医疗救护点，为朝佛民众及时提供紧急救助等便利服务。')
self.dr.find_element_by_xpath('//*[@id="headName"]').send_keys('包涵')
self.dr.find_element_by_xpath('//*[@id="headIdCard"]').send_keys('500107198901218926')
self.dr.find_element_by_xpath('//*[@id="contact"]').send_keys('15874748569')
self.dr.find_element_by_xpath('//*[@id="dutyTel"]').send_keys('13474587458')
self.dr.find_element_by_xpath('//*[@id="isHaveCensorate"]').send_keys('未')
self.dr.find_element_by_xpath('//*[@id="zrdw"]').click()
time.sleep(1)
self.dr.find_element_by_xpath('//*[@id="treeSelect_45_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath('//*[@id="treeSelect_46_span"]').click()
time.sleep(1)
self.dr.find_element_by_xpath('//*[@id="gxdw"]').click()
time.sleep(1)
self.dr.find_element_by_xpath('//*[@id="gxtreeSelect_45_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath('//*[@id="gxtreeSelect_46_span"]').click()
time.sleep(2)
self.dr.find_element_by_xpath('//*[@id="saveDuty"]').click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(1)
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('管理防范-执勤点管理：新增功能正常')
def test01_sheqiang_add(self):
self.sheqiang_search()
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[1]/div[2]/a[2]/span').click()
self.dr.switch_to.default_content()
time.sleep(2)
self.dr.switch_to.frame('iframeb')
add_value_cardid = sheet.col_values(1, 2, 3)[0]
self.dr.find_element_by_xpath('//*[@id="gmsfhm"]').send_keys(
add_value_cardid)
self.dr.find_element_by_xpath(
'//*[@id="gunForm"]/div[1]/div[2]/div/div[1]/div[2]/a').click()
time.sleep(2)
self.dr.find_element_by_xpath('//*[@id="cqzbh"]').send_keys(
sheet.col_values(1, 4, 5)[0])
self.dr.find_element_by_xpath('//*[@id="fzsj"]').send_keys(
sheet.col_values(1, 6, 7)[0])
self.dr.find_element_by_xpath('//*[@id="szdw"]').send_keys(
sheet.col_values(1, 7, 8)[0])
self.dr.find_element_by_xpath('//*[@id="supervName"]').send_keys(
sheet.col_values(1, 8, 9)[0])
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').send_keys(
sheet.col_values(1, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="supervWx"]').send_keys(
sheet.col_values(1, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').send_keys(
sheet.col_values(1, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').send_keys(
sheet.col_values(1, 12, 13)[0])
self.dr.find_element_by_xpath(saveBtn).click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(2)
self.assertEqual(
sheet_prompt_message.col_values(1, 0, 1)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'新增成功提示信息校验')
print('人口管理-部局七类库-涉枪人员：新增涉枪人员功能正常')
def test08_sanfei_edit(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.dr.find_element_by_xpath('//*[@id="personName"]').clear()
self.dr.find_element_by_xpath('//*[@id="personName"]').send_keys(
sheet.col_values(2, 0, 1)[0])
self.dr.find_element_by_xpath('//*[@id="work"]').clear()
self.dr.find_element_by_xpath('//*[@id="work"]').send_keys(
sheet.col_values(2, 18, 19)[0])
self.dr.find_element_by_xpath('//*[@id="workPlace"]').clear()
self.dr.find_element_by_xpath('//*[@id="workPlace"]').send_keys(
sheet.col_values(2, 19, 20)[0])
self.dr.find_element_by_xpath('//*[@id="idNumber"]').clear()
self.dr.find_element_by_xpath('//*[@id="idNumber"]').send_keys(
sheet.col_values(2, 4, 5)[0])
self.dr.find_element_by_xpath('//*[@id="entryPosition"]').clear()
self.dr.find_element_by_xpath('//*[@id="entryPosition"]').send_keys(
sheet.col_values(2, 8, 9)[0])
self.dr.find_element_by_xpath('//*[@id="residentialAddress"]').clear()
self.dr.find_element_by_xpath(
'//*[@id="residentialAddress"]').send_keys(
sheet.col_values(2, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="caseNumber"]').clear()
self.dr.find_element_by_xpath('//*[@id="caseNumber"]').send_keys(
sheet.col_values(2, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="caseSummary"]').clear()
self.dr.find_element_by_xpath('//*[@id="caseSummary"]').send_keys(
sheet.col_values(2, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="connectorName"]').clear()
self.dr.find_element_by_xpath('//*[@id="connectorName"]').send_keys(
sheet.col_values(2, 12, 13)[0])
self.dr.find_element_by_xpath('//*[@id="connectorIdCard"]').clear()
self.dr.find_element_by_xpath('//*[@id="connectorIdCard"]').send_keys(
sheet.col_values(2, 13, 14)[0])
self.dr.find_element_by_xpath('//*[@id="repatriateDate"]').clear()
self.dr.find_element_by_xpath('//*[@id="repatriateDate"]').send_keys(
sheet.col_values(2, 14, 15)[0])
self.dr.find_element_by_xpath('//*[@id="dutyPerson"]').clear()
self.dr.find_element_by_xpath('//*[@id="dutyPerson"]').send_keys(
sheet.col_values(2, 16, 17)[0])
self.dr.find_element_by_xpath('//*[@id="remark"]').clear()
self.dr.find_element_by_xpath('//*[@id="remark"]').send_keys(
sheet.col_values(2, 17, 18)[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, 4, 5)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'编辑修改成功提示信息校验')
print('人口管理-部局七类库-三非人员：编辑修改功能正常')
def test08_sihei_edit(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.dr.find_element_by_xpath('//*[@id="idCard"]').clear()
self.dr.find_element_by_xpath('//*[@id="idCard"]').send_keys(
sheet.col_values(2, 2, 3)[0])
self.dr.find_element_by_xpath('//*[@id="mainBusiness"]').clear()
self.dr.find_element_by_xpath('//*[@id="mainBusiness"]').send_keys(
sheet.col_values(2, 8, 9)[0])
self.dr.find_element_by_xpath('//*[@id="personName"]').clear()
self.dr.find_element_by_xpath('//*[@id="personName"]').send_keys(
sheet.col_values(2, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="mainTourists"]').clear()
self.dr.find_element_by_xpath('//*[@id="mainTourists"]').send_keys(
sheet.col_values(2, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="activityArea"]').clear()
self.dr.find_element_by_xpath('//*[@id="activityArea"]').send_keys(
sheet.col_values(2, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="activityTimeSlot"]').clear()
self.dr.find_element_by_xpath('//*[@id="activityTimeSlot"]').send_keys(
sheet.col_values(2, 12, 13)[0])
self.dr.find_element_by_xpath('//*[@id="startBlackDate"]').clear()
self.dr.find_element_by_xpath('//*[@id="startBlackDate"]').send_keys(
sheet.col_values(2, 13, 14)[0])
self.dr.find_element_by_xpath('//*[@id="dayTraffic"]').click()
self.dr.find_element_by_xpath('//*[@id="dayTraffic"]').clear()
self.dr.find_element_by_xpath('//*[@id="dayTraffic"]').send_keys(
sheet.col_values(2, 14, 15)[0])
self.dr.find_element_by_xpath('//*[@id="averagePrice"]').clear()
self.dr.find_element_by_xpath('//*[@id="averagePrice"]').send_keys(
sheet.col_values(2, 15, 16)[0])
self.dr.find_element_by_xpath('//*[@id="riskAssess"]').clear()
self.dr.find_element_by_xpath('//*[@id="riskAssess"]').send_keys(
sheet.col_values(2, 16, 17)[0])
self.dr.find_element_by_xpath('//*[@id="dutyPerson"]').clear()
self.dr.find_element_by_xpath('//*[@id="dutyPerson"]').send_keys(
sheet.col_values(2, 17, 18)[0])
self.dr.find_element_by_xpath('//*[@id="remark"]').clear()
self.dr.find_element_by_xpath('//*[@id="remark"]').send_keys(
sheet.col_values(2, 19, 20)[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, 4, 5)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'编辑修改成功提示信息校验')
print('人口管理-部局七类库-四黑人员：编辑修改功能正常')
def test01_sanfei_add(self):
self.sanfei_search()
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[1]/div[2]/a[2]').click()
self.dr.switch_to.default_content()
time.sleep(2)
self.dr.switch_to.frame('iframeb')
add_value_name = sheet.col_values(1, 0, 1)[0]
add_value_carid = sheet.col_values(1, 4, 5)[0]
self.dr.find_element_by_xpath('//*[@id="personName"]').send_keys(
add_value_name)
Select(self.dr.find_element_by_xpath(
'//*[@id="personType"]')).select_by_value('1')
self.dr.find_element_by_xpath('//*[@id="work"]').send_keys(
sheet.col_values(1, 18, 19)[0])
self.dr.find_element_by_xpath('//*[@id="workPlace"]').send_keys(
sheet.col_values(1, 19, 20)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="idType"]')).select_by_value('111')
self.dr.find_element_by_xpath('//*[@id="idNumber"]').send_keys(
add_value_carid)
self.dr.find_element_by_xpath('//*[@id="entryPosition"]').send_keys(
sheet.col_values(1, 8, 9)[0])
self.dr.find_element_by_xpath(
'//*[@id="residentialAddress"]').send_keys(
sheet.col_values(1, 9, 10)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="whetherInvolved"]')).select_by_index('0')
Select(self.dr.find_element_by_xpath(
'//*[@id="caseType"]')).select_by_value('010101')
self.dr.find_element_by_xpath('//*[@id="caseNumber"]').send_keys(
sheet.col_values(1, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="caseSummary"]').send_keys(
sheet.col_values(1, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="connectorName"]').send_keys(
sheet.col_values(1, 12, 13)[0])
self.dr.find_element_by_xpath('//*[@id="connectorIdCard"]').send_keys(
sheet.col_values(1, 13, 14)[0])
self.dr.find_element_by_xpath('//*[@id="repatriateDate"]').send_keys(
sheet.col_values(1, 14, 15)[0])
'''责任单位'''
self.dr.find_element_by_xpath('//*[@id="dutyOrg"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="treeSelect_45_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="treeSelect_46_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath('//*[@id="treeSelect_48_span"]').click()
time.sleep(1)
self.dr.find_element_by_xpath('//*[@id="dutyPerson"]').click()
self.dr.find_element_by_xpath('//*[@id="dutyPerson"]').send_keys(
sheet.col_values(1, 16, 17)[0])
self.dr.find_element_by_xpath('//*[@id="remark"]').send_keys(
sheet.col_values(1, 17, 18)[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, 4, 5)[0],
self.dr.find_element_by_xpath(
'//*[@id="gritter-item-1"]/div[2]/div[2]/p').text,
'新增成功提示信息校验')
print('人口管理-部局七类库-三非人员：新增功能正常')
def test07_shebian_edit(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.dr.find_element_by_xpath('//*[@id="xjdz"]').clear()
self.dr.find_element_by_xpath('//*[@id="xjdz"]').send_keys(sheet.col_values(2, 8, 9)[0])
self.dr.find_element_by_xpath('//*[@id="tmtz"]').clear()
self.dr.find_element_by_xpath('//*[@id="tmtz"]').send_keys(sheet.col_values(2, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="jzlx"]').clear()
self.dr.find_element_by_xpath('//*[@id="jzlx"]').send_keys(sheet.col_values(2, 10, 11)[0])
self.dr.find_element_by_xpath('//*[@id="jzhm"]').clear()
self.dr.find_element_by_xpath('//*[@id="jzhm"]').send_keys(sheet.col_values(2,11,12)[0])
self.dr.find_element_by_xpath('//*[@id="qk"]').clear()
self.dr.find_element_by_xpath('//*[@id="qk"]').send_keys(sheet.col_values(2, 12, 13)[0])
self.dr.find_element_by_xpath('//*[@id="gddh"]').clear()
self.dr.find_element_by_xpath('//*[@id="gddh"]').send_keys(sheet.col_values(2, 13, 14)[0])
self.dr.find_element_by_xpath('//*[@id="qqorip"]').clear()
self.dr.find_element_by_xpath('//*[@id="qqorip"]').send_keys(sheet.col_values(2, 14, 15)[0])
self.dr.find_element_by_xpath('//*[@id="hlwtxhm"]').clear()
self.dr.find_element_by_xpath('//*[@id="hlwtxhm"]').send_keys(sheet.col_values(2, 15, 16)[0])
self.dr.find_element_by_xpath('//*[@id="hzhm"]').clear()
self.dr.find_element_by_xpath('//*[@id="hzhm"]').send_keys(sheet.col_values(2, 16, 17)[0])
self.dr.find_element_by_xpath('//*[@id="hdqk"]').clear()
self.dr.find_element_by_xpath('//*[@id="hdqk"]').send_keys(sheet.col_values(2, 17, 18)[0])
self.dr.find_element_by_xpath('//*[@id="sy"]').clear()
self.dr.find_element_by_xpath('//*[@id="sy"]').send_keys(sheet.col_values(2, 18, 19)[0])
self.dr.find_element_by_xpath('//*[@id="fs"]').clear()
self.dr.find_element_by_xpath('//*[@id="fs"]').send_keys(sheet.col_values(2, 19, 20)[0])
self.dr.find_element_by_xpath('//*[@id="jzdlx"]').clear()
self.dr.find_element_by_xpath('//*[@id="jzdlx"]').send_keys(sheet.col_values(2, 20, 21)[0])
self.dr.find_element_by_xpath('//*[@id="zzzh"]').clear()
self.dr.find_element_by_xpath('//*[@id="zzzh"]').send_keys(sheet.col_values(2, 21, 22)[0])
self.dr.find_element_by_xpath('//*[@id="zjhm"]').clear()
self.dr.find_element_by_xpath('//*[@id="zjhm"]').send_keys(sheet.col_values(2, 22, 23)[0])
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').send_keys(sheet.col_values(2, 23, 24)[0])
self.dr.find_element_by_xpath('//*[@id="supervName"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervName"]').send_keys(sheet.col_values(2, 24, 25)[0])
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').clear()
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').send_keys(sheet.col_values(2, 25, 26)[0])
self.dr.find_element_by_xpath('//*[@id="supervWx"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervWx"]').send_keys(sheet.col_values(2, 26, 27)[0])
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').send_keys(sheet.col_values(2, 27, 28)[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, 0, 1)[0],
self.dr.find_element_by_xpath('//*[@id="gritter-item-1"]/div[2]/div[2]/p').text, '校验删除成功提示信息')
print('人口管理-局部七类库-涉爆人员：涉边|涉恐|涉稳|涉外人员编辑功能正常')
def test07_zidingyi_eidt(self):
self.zidingyi_search()
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.dr.find_element_by_xpath('//*[@id="gmsfhm"]').clear()
self.dr.find_element_by_xpath('//*[@id="gmsfhm"]').send_keys(
sheet.col_values(2, 2, 3)[0])
self.dr.find_element_by_xpath(
'//*[@id="customForm"]/div[1]/div[2]/div/div[1]/div[2]/a').click()
time.sleep(2)
self.dr.find_element_by_xpath('//*[@id="personsType"]').clear()
self.dr.find_element_by_xpath('//*[@id="personsType"]').send_keys(
sheet.col_values(1, 8, 9)[0])
self.dr.find_element_by_xpath('//*[@id="credentials"]').clear()
self.dr.find_element_by_xpath('//*[@id="credentials"]').send_keys(
sheet.col_values(1, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="livingPlace"]').clear()
self.dr.find_element_by_xpath('//*[@id="livingPlace"]').send_keys(
sheet.col_values(1, 10, 11)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="isLimit"]')).select_by_value('1')
# js = "$('input[id=txtBeginDate]').attr('readonly','')"
# self.dr.execute_script(js)
self.dr.find_element_by_xpath('//*[@id="endtime"]').clear()
self.dr.find_element_by_xpath('//*[@id="endtime"]').send_keys(
sheet.col_values(1, 21, 22)[0])
self.dr.find_element_by_xpath('//*[@id="livingPlace"]').click()
self.dr.find_element_by_xpath('//*[@id="starttime"]').clear()
self.dr.find_element_by_xpath('//*[@id="starttime"]').send_keys(
sheet.col_values(1, 20, 21)[0])
self.dr.find_element_by_xpath('//*[@id="livingPlace"]').click()
Select(self.dr.find_element_by_xpath(
'//*[@id="isAttention"]')).select_by_value('1')
self.dr.find_element_by_xpath('//*[@id="recognitionInfo"]').clear()
self.dr.find_element_by_xpath('//*[@id="recognitionInfo"]').send_keys(
sheet.col_values(1, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="monitorReason"]').clear()
self.dr.find_element_by_xpath('//*[@id="monitorReason"]').send_keys(
sheet.col_values(1, 12, 13)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="isNotify"]')).select_by_value('1')
self.dr.find_element_by_xpath('//*[@id="processingScheme"]').clear()
self.dr.find_element_by_xpath('//*[@id="processingScheme"]').send_keys(
sheet.col_values(1, 13, 14)[0])
self.dr.find_element_by_xpath('//*[@id="note"]').clear()
self.dr.find_element_by_xpath('//*[@id="note"]').send_keys(
sheet.col_values(1, 14, 15)[0])
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').send_keys(
sheet.col_values(1, 15, 16)[0])
self.dr.find_element_by_xpath('//*[@id="supervName"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervName"]').send_keys(
sheet.col_values(1, 16, 17)[0])
self.dr.find_element_by_xpath('//*[@id="supervWx"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervWx"]').send_keys(
sheet.col_values(1, 17, 18)[0])
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').clear()
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').send_keys(
sheet.col_values(1, 18, 19)[0])
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').clear()
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').send_keys(
sheet.col_values(1, 19, 20)[0])
self.dr.find_element_by_xpath(saveBtn).click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(2)
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 test01_hangyechangsuo_add(self):
self.hangyechangsuo_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="localityName"]').click()
self.dr.find_element_by_xpath(
'//*[@id="dqtreeSelect_1_switch"]').click()
self.dr.find_element_by_xpath('//*[@id="dqtreeSelect_2_span"]').click()
self.dr.find_element_by_xpath('//*[@id="pcs"]').click()
self.dr.find_element_by_xpath(
'//*[@id="pcstreeSelect_1_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="pcstreeSelect_2_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="pcstreeSelect_9_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="pcstreeSelect_10_span"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="locatedPoliceAreaName"]').click()
self.dr.find_element_by_xpath(
'//*[@id="jqtreeSelect_1_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="jqtreeSelect_2_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="jqtreeSelect_3_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="jqtreeSelect_4_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="jqtreeSelect_5_switch"]').click()
time.sleep(1)
self.dr.find_element_by_xpath('//*[@id="jqtreeSelect_6_span"]').click()
time.sleep(1)
self.dr.find_element_by_xpath(
'//*[@id="policeAreaContactTel"]').send_keys('15874587458')
'''选择行业类型'''
self.dr.find_element_by_xpath('//*[@id="zprxm2"]').click()
self.dr.find_element_by_xpath(
'//*[@id="treeSelect2_52_switch"]').click()
time.sleep(2)
self.dr.find_element_by_xpath('//*[@id="treeSelect2_53_span"]').click()
time.sleep(1)
'''选择企业性质'''
Select(self.dr.find_element_by_xpath(
'//*[@id="character"]')).select_by_value('16')
'''输入企业注册名称'''
self.dr.find_element_by_xpath('//*[@id="registrationName"]').send_keys(
'精伦电子')
self.dr.find_element_by_xpath(
'//*[@id="actualBusinessName"]').send_keys('精伦电子股份有限公司')
self.dr.find_element_by_xpath('//*[@id="compEngName"]').send_keys(
'Routon Electronic Co., Ltd.')
self.dr.find_element_by_xpath(
'//*[@id="legalRepresentative"]').send_keys('张学阳')
self.dr.find_element_by_xpath(
'//*[@id="rigisteredCapital"]').send_keys('3000')
self.dr.find_element_by_xpath('//*[@id="openningDate"]').send_keys(
'2018-08-05')
Select(self.dr.find_element_by_xpath(
'//*[@id="businessStatus"]')).select_by_value('02')
self.dr.find_element_by_xpath('//*[@id="businessAddress"]').send_keys(
'江苏路101号')
'''点击保存'''
self.dr.find_element_by_xpath('//*[@id="saveIndus"]').click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(1)
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('管理防范-行业场所管理：新增功能正常')
def test01_zidingyi_add(self):
self.zidingyi_search()
self.dr.find_element_by_xpath(
'/html/body/div[3]/div[1]/div[2]/a[2]').click()
self.dr.switch_to.default_content()
time.sleep(2)
self.dr.switch_to.frame('iframeb')
add_value_cardid = sheet.col_values(1, 2, 3)[0]
self.dr.find_element_by_xpath('//*[@id="gmsfhm"]').send_keys(
add_value_cardid)
self.dr.find_element_by_xpath(
'//*[@id="customForm"]/div[1]/div[2]/div/div[1]/div[2]/a').click()
time.sleep(2)
self.dr.find_element_by_xpath('//*[@id="personsType"]').send_keys(
sheet.col_values(1, 8, 9)[0])
self.dr.find_element_by_xpath('//*[@id="credentials"]').send_keys(
sheet.col_values(1, 9, 10)[0])
self.dr.find_element_by_xpath('//*[@id="livingPlace"]').send_keys(
sheet.col_values(1, 10, 11)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="isLimit"]')).select_by_value('0')
# js = "$('input[id=txtBeginDate]').attr('readonly','')"
# self.dr.execute_script(js)
self.dr.find_element_by_xpath('//*[@id="endtime"]').send_keys(
sheet.col_values(1, 21, 22)[0])
self.dr.find_element_by_xpath('//*[@id="livingPlace"]').click()
self.dr.find_element_by_xpath('//*[@id="starttime"]').send_keys(
sheet.col_values(1, 20, 21)[0])
time.sleep(2)
self.dr.find_element_by_xpath('//*[@id="livingPlace"]').click()
Select(self.dr.find_element_by_xpath(
'//*[@id="isAttention"]')).select_by_value('0')
self.dr.find_element_by_xpath('//*[@id="recognitionInfo"]').send_keys(
sheet.col_values(1, 11, 12)[0])
self.dr.find_element_by_xpath('//*[@id="monitorReason"]').send_keys(
sheet.col_values(1, 12, 13)[0])
Select(self.dr.find_element_by_xpath(
'//*[@id="isNotify"]')).select_by_value('0')
self.dr.find_element_by_xpath('//*[@id="processingScheme"]').send_keys(
sheet.col_values(1, 13, 14)[0])
self.dr.find_element_by_xpath('//*[@id="note"]').send_keys(
sheet.col_values(1, 14, 15)[0])
self.dr.find_element_by_xpath('//*[@id="supervIdcardNo"]').send_keys(
sheet.col_values(1, 15, 16)[0])
self.dr.find_element_by_xpath('//*[@id="supervName"]').send_keys(
sheet.col_values(1, 16, 17)[0])
self.dr.find_element_by_xpath('//*[@id="supervWx"]').send_keys(
sheet.col_values(1, 17, 18)[0])
self.dr.find_element_by_xpath('//*[@id="supervBeWx"]').send_keys(
sheet.col_values(1, 18, 19)[0])
self.dr.find_element_by_xpath('//*[@id="reportCycle"]').send_keys(
sheet.col_values(1, 19, 20)[0])
self.dr.find_element_by_xpath(saveBtn).click()
self.dr.switch_to.default_content()
self.dr.switch_to.frame('iframeb')
time.sleep(2)
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('人口管理-自定义人员：新增功能正常')
