def test_Login(self):
# # Step1: 打开登录页
# BasePage()
# Step2: 初始化登录Page
login_page = LoginPage()
# Step3: 输入用户名
login_page.set_username("yradmin")
# Step4: 输入密码
login_page.set_password("a12345")
# Step5: 单击登录按钮
login_page.click_login()
login_page.driver.maximize_window()
time.sleep(43200)
login_page.driver.close()
def test_Login(self):
datas = ExcelReader(self.excel).data
for d in datas:
with self.subTest(data=d):
login_page = LoginPage()
driver = login_page.driver
# Step3: 输入用户名
login_page.set_admin("yradmin")
# Step4: 输入密码
login_page.set_password("a12345")
time.sleep(6)
# Step5: 单击登录按钮
login_page.click_login()
login_page.click_jkbgl()
login_page.click_ckzjkb()
time.sleep(1)
driver.switch_to_frame("contentIframe")
login_page.click_new()
time.sleep(1)
login_page.click_bidProduct()
# 选择产品
login_page.click_jjyay() # 季季赢按月
# login_page.click_jjydq() #季季赢到期
login_page.click_loanuse()
login_page.click_loanuseli()
login_page.set_title(d['title'])
login_page.set_loanBorrowershowname(d['title'])
login_page.set_bidcode(d['title'])
login_page.set_totalAmount("1000000")
login_page.set_termValue("12")
login_page.set_biddlimit("365")
login_page.set_interestRate("10")
login_page.set_raiseRate("0")
login_page.set_shouxufei("0")
login_page.set_choose()
WebDriverWait(driver, 10).until(
EC.presence_of_element_located(
(By.XPATH, "//html/body/div/div/div/div[2]/iframe")))
a = driver.find_element_by_xpath(
"//html/body/div/div/div/div[2]/iframe")
driver.switch_to_frame(a)
login_page.set_loanuser("张效伟")
# login_page.set_loanuser("18301306330")
login_page.click_search()
time.sleep(3)
login_page.click_searchok()
time.sleep(1)
driver.switch_to_default_content()
driver.switch_to_frame("contentIframe")
# login_page.click_type()
# # 正常标、爆款标、推荐标
# login_page.click_zcbiao()
time.sleep(1)
login_page.click_save()
time.sleep(2)
al = driver.switch_to_alert()
al.accept()
def test_Login(self):
datas = ExcelReader(self.excel).data
for d in datas:
with self.subTest(data=d):
login_page = LoginPage()
driver = login_page.driver
amount = 10000
# Step3: 输入用户名
login_page.set_admin("yradmin")
# Step4: 输入密码
login_page.set_password("a12345")
time.sleep(6)
# Step5: 单击登录按钮
login_page.click_login()
login_page.click_jkbgl()
login_page.click_ckzjkb()
time.sleep(1)
driver.switch_to_frame("contentIframe")
login_page.click_new()
time.sleep(1)
login_page.click_bidProduct()
# 选择产品
login_page.click_yyyay() # 月月赢按月
# login_page.click_nnydq () # 年年赢到期
login_page.click_loanuse()
login_page.click_loanuseli()
login_page.set_title(d['title'])
login_page.set_loanBorrowershowname(d['title'])
login_page.set_bidcode(d['title'])
login_page.set_totalAmount(amount)
login_page.set_termValue("3")
login_page.set_biddlimit("365")
login_page.set_interestRate("10")
login_page.set_raiseRate("0")
login_page.set_shouxufei("0")
login_page.set_choose()
WebDriverWait(driver, 10).until(
EC.presence_of_element_located(
(By.XPATH, "//html/body/div/div/div/div[2]/iframe")))
a = driver.find_element_by_xpath(
"//html/body/div/div/div/div[2]/iframe")
driver.switch_to_frame(a)
login_page.set_loanuser("transfer")
# login_page.set_loanuser("18301306330")
login_page.click_search()
time.sleep(3)
login_page.click_searchok()
time.sleep(1)
driver.switch_to_default_content()
driver.switch_to_frame("contentIframe")
# login_page.click_type()
# # 正常标、爆款标、推荐标
# login_page.click_zcbiao()
time.sleep(1)
login_page.click_save()
time.sleep(2)
al = driver.switch_to_alert()
al.accept()
# 返回列表上架
driver.switch_to_default_content()
login_page.click_ckzjkb()
driver.switch_to_frame("contentIframe")
login_page.set_mingcheng(d['title'])
login_page.click_sousuo()
login_page.click_shangjia()
time.sleep(1)
driver.find_element_by_xpath(
"//html/body/div/div/div/div[3]/input[1]").click()
# driver.close ()
connection = Db().get_connection()
cursor = Db().get_cursor()
fname = DATA_PATH + '/yueyueying.xlsx'
bk = xlrd.open_workbook(fname)
try:
sh = bk.sheet_by_name("Sheet1")
except:
print
"no sheet in %s named Sheet1" % fname
# 获取第一行第一列数据
cell_value = sh.cell_value(1, 0)
print("表格", cell_value)
# 通过cursor创建游标
cursor.execute("SELECT * from bidd_info where title=%s",
(d['title'], ))
# 提交SQL
connection.commit()
t = cursor.fetchall()
print(t)
bidname = t[0]['TITLE']
print(bidname)
cursor = con.cursor
cursor.execute("SELECT code from bidd_info where title=%s",
(bidname, ))
# 提交SQL
connection.commit()
t = cursor.fetchall()
# a=t['tel']
a = t[0]['code']
#登录前台投资
driver.get(
'http://192.168.1.249:9901/hkjf/index.do?method=getIndexPage'
)
WebDriverWait(driver, 10).until(
EC.presence_of_element_located((By.ID, 'login')))
driver.find_element_by_id('login').send_keys('13301307172')
time.sleep(1)
e1 = driver.find_element_by_xpath(".//*[@id='txt2']")
action = ActionChains(driver)
action.move_to_element(e1).click().send_keys(
"2971055a690ad019e9fc08a9971080ccfd6a8b588c69acc28383a12d9cfdcb135a60550a4df643b9967c5fab90ce4eb8e3970c2c093fefe299662ac44e868763d281e8708ab625528d55c6a777b2700bcb9daf7e7e0c6805ffd13760d4ac0120d6f43c2dc05fc38fcff485eedd8859d79200ddb7a9a606b8548fa1d8def1dacc"
).perform()
driver.find_element_by_xpath(
".//*[@id='logindiv']/div/div[2]").submit()
# address=("http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code=ed791706-92f7-4435-b6f6-aa944ed87f4c")
ad1 = "http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code="
ad2 = a
add = ad1 + ad2
driver.get(add)
time.sleep(1)
# driver.find_element_by_id ("projectCode").send_keys (d['title'])
driver.find_element_by_id("amount").send_keys(amount) #投资金额
driver.find_element_by_link_text("立即投资").click()
time.sleep(3)
driver.find_element_by_class_name("dialogBtn").click()
# 后台登录
driver.get(
"http://192.168.1.249:9901/hkjf/loginAdmin.do?method=tologin"
)
login_page.set_admin("yradmin")
# Step4: 输入密码
login_page.set_password("a12345")
time.sleep(6)
# Step5: 单击登录按钮
login_page.click_login()
login_page.click_jkbgl()
time.sleep(0.5)
#审核标的
driver.find_element_by_link_text("待审核的借款标").click()
driver.switch_to_frame("contentIframe")
time.sleep(0.5)
driver.find_element_by_name("title").send_keys(d['title'])
driver.find_element_by_link_text("查询").click()
driver.find_element_by_link_text("审核").click()
driver.find_element_by_id("content").send_keys("满标审核通过！")
driver.find_element_by_link_text("通过").click()
driver.switch_to_default_content()
#放款
driver.find_element_by_xpath(
".//*[@id='left']/div/ul/li[7]/div/span[1]").click()
time.sleep(0.5)
driver.find_element_by_link_text("待放款的借款标").click()
driver.switch_to_frame("contentIframe")
time.sleep(0.5)
driver.find_element_by_name("title").send_keys(d['title'])
driver.find_element_by_link_text('查询').click()
driver.find_element_by_link_text("放款").click()
time.sleep(0.8)
driver.find_element_by_xpath(
"//html/body/div/div/div/div[3]/input[1]").click()
driver.close()
def test_Login(self):
datas = ExcelReader (self.excel).data
for d in datas:
with self.subTest (data=d):
login_page = LoginPage ()
driver=login_page.driver
# Step3: 输入用户名
login_page.set_admin ("yradmin")
# Step4: 输入密码
login_page.set_password ("a12345")
time.sleep (6)
# Step5: 单击登录按钮
login_page.click_login ()
login_page.click_jkbgl()
login_page.click_ckzjkb()
time.sleep (1)
driver.switch_to_frame("contentIframe")
login_page.click_new()
time.sleep (1)
login_page.click_bidProduct()
# 选择产品
login_page.click_tyb() #体验标
login_page.click_loanuse()
login_page.click_loanuseli()
login_page.set_title(d['title'])
login_page.set_loanBorrowershowname(d['title'])
login_page.set_bidcode(d['title'])
login_page.set_totalAmount("10000")
login_page.set_termValue("12")
login_page.set_biddlimit("365")
login_page.set_interestRate("10")
login_page.set_raiseRate("0")
login_page.set_shouxufei("0")
login_page.click_type()
# 是否是新手标
# driver.find_element_by_xpath (".//*[@id='prodetail']/div[1]/table/tbody/tr[22]/td/span[1]/div[1]/input").send_keys (Keys.SPACE)
# 选择借款人
login_page.set_choose()
WebDriverWait (driver, 10).until (EC.presence_of_element_located ((By.XPATH, "//html/body/div/div/div/div[2]/iframe")))
a = driver.find_element_by_xpath ("//html/body/div/div/div/div[2]/iframe")
driver.switch_to_frame (a)
login_page.set_loanuser("张效伟")
# login_page.set_loanuser("18301306330")
login_page.click_search()
time.sleep(3)
login_page.click_searchok()
time.sleep(1)
driver.switch_to_default_content ()
driver.switch_to_frame ("contentIframe")
# login_page.click_type()
# # 正常标、爆款标、推荐标
# login_page.click_zcbiao()
time.sleep(1)
login_page.click_save()
time.sleep(2)
al = driver.switch_to_alert ()
al.accept ()
# 返回列表上架
driver.switch_to_default_content ()
login_page.click_ckzjkb()
driver.switch_to_frame ("contentIframe")
login_page.set_mingcheng(d['title'])
login_page.click_sousuo()
login_page.click_shangjia()
time.sleep(1)
driver.find_element_by_xpath ("//html/body/div/div/div/div[3]/input[1]").click ()
driver.close()