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('人口管理-自定义人员:新增功能正常')