def test_06_get_ajid(self):
"""从页面url获取ajid，并保存到文件中"""
ajid = GetAjidFromUrl(self.driver).getajidfromurl(1)
sa = SaveResultToFile()
sa.writefile('ajid', ajid) # 获取页面ajid并写入文件
result = sa.readfile('ajid')
self.assertIsNotNone(result) # 断言ajid是否存入成功
def test_01_check_xtzt_ajid(self):
"""根据ajid查询当前案件状态是否正确(n_tbxtzt=102)"""
db = DataBase('ga')
savedata = SaveResultToFile()
ajid = savedata.readfile('平台案件编号')
sql = "SELECT n_tbxtzt FROM db_yw.t_tb_ajxx WHERE c_id LIKE '%s'" % (
ajid)
xtzt = db.getdata(sql, 0)[1]
logger.info("查询到的协同状态：%s" % xtzt)
self.assertEqual(102, xtzt) # 断言协同状态是否转换成功
def test_03_assert_result_zf(self):
"""验证政法端协同状态是否变成104"""
# 连接数据库
db = DataBase('zf')
savedata = SaveResultToFile()
ajid = savedata.readfile('平台案件编号') # 从文件中读取ajid
sql = "SELECT n_tbxtzt FROM db_yw.t_tb_ajxx WHERE c_id LIKE '%s'" % (
ajid)
xtzt = db.getdata(sql, 0)[1]
logger.info("查询到的协同状态：%s" % xtzt)
self.assertEqual(104, xtzt)
def test_03_tb_addtbaj(self):
"""点击选择案件，进入提案器"""
choosepeople = AddAJ(self.driver)
choosepeople.add_tb_aj() # 点击添加案件按钮
iframe2 = self.driver.find_elements_by_tag_name("iframe")[0]
self.driver.switch_to.frame(iframe2)
logger.info("开始选择案件和嫌疑人")
cp = ChoosePeople(self.driver) # 开始选择案件
xyrxm = cp.find_avaibale_tbaj() # 调用查找嫌疑人的方法
self.assertIsNotNone(xyrxm) # 断言是否找到嫌疑人方法的返回结果
savedata = SaveResultToFile()
savedata.writefile('嫌疑人姓名', xyrxm) # 保存嫌疑人姓名在文件中
def test_03_ycjy_addaj(self):
"""点击选择案件，选择在押人员"""
add = AddAJ(self.driver)
add.add_ycjy_aj() # 点击添加案件按钮
iframe2 = self.driver.find_elements_by_tag_name("iframe")[0]
self.driver.switch_to.frame(iframe2)
logger.info("开始选择案件和嫌疑人")
cp = ChoosePeople(self.driver) # 开始选择案件
xyrxm = cp.find_zyry() # 调用查找案件的方法
self.assertIsNotNone(xyrxm) # 断言嫌疑人是否找到
savedata = SaveResultToFile()
savedata.writefile('嫌疑人姓名', xyrxm) # 写入文件
def test_03_find_tb_ajmc(self):
"""查看当前嫌疑人是否能查到"""
aj = SearchAJ(self.driver)
savedata = SaveResultToFile()
xyrxm = savedata.readfile('嫌疑人姓名') # 读取之前延长羁押的嫌疑人姓名
self.assertIsNotNone(xyrxm) # 断言嫌疑人姓名是否为空
aj.search_ycjy(xyrxm) # 用该嫌疑人姓名查询
po = ElemnetExist(self.driver) # 实例化页面通用方法，判断登陆后的页面是否有某个元素
xyrxminlist = po.is_table_data_exist('jqGridf754c-table',
2) # 获取当前列表中该列的值
self.assertEqual(xyrxminlist, xyrxm) # 断言嫌疑人是否有值
ajzt = po.is_table_data_exist('jqGridf754c-table', 8)
self.assertEqual(ajzt, '待接收')
def test_07_set_qzzt(self):
"""设置签章状态为1，通过ajid查询数据库，设置n_yqz=1"""
# 设置签章状态的sql
ajid = SaveResultToFile().readfile('ajid')
sql = "update db_jz.t_jzgl_wj set n_yqz =1 WHERE c_ywid='%s' and c_store_path is not null" % (ajid)
# 链接数据库执行sql
db = DataBase("ga") # 链接数据库，选择ga端，数据库信息在ini文件中读取
db.exe_update(sql) # 执行sql
sele_sql = "SELECT n_yqz from db_jz.t_jzgl_wj WHERE c_ywid='%s' and c_store_path is not null" % (ajid)
result = db.getdata(sele_sql, 0)[1] # 判断是否查询到该ajid的签章状态
self.assertEqual(1, result) # 断言是否执行sql成功
def test_02_change_file_name(self):
"""修改pdf文件名称"""
rn = ReplaceFileContent()
savedata = SaveResultToFile()
xyrxm = savedata.readfile('嫌疑人姓名')
rn.rename_pdf(106, xyrxm) # 修改pdf名称的方法，把嫌疑人姓名拼接到pdf文件名上
def test_01_get_xyrxm(self):
"""获取嫌疑人姓名,并生成pdf文件名称"""
savedata = SaveResultToFile()
ajid = savedata.readfile('平台案件关联编号')
sql_ajcm = "SELECT xyr.c_xyrxm FROM db_yw.t_jc_gaxyr xyr WHERE c_id_ajxx='%s'" % (
ajid) # 通过sql查询ajmc
db = DataBase("ga")
xyrxm = db.getdata(sql_ajcm, 0)[1] # 执行sql
savedata.writefile('嫌疑人姓名', xyrxm)
savedata.writefile('处理结果', 1) # 添加106流程的处理结果,用来做替换
savedata.writefile('文件显示名称', "\批准逮捕决定书" + '(' + xyrxm + ')' +
'.pdf') # 添加106流程的处理结果,用来做替换
savedata.writefile('文件路径', "\ws" + "\批准逮捕决定书" + '(' + xyrxm + ')' +
'.pdf') # 添加106流程的处理结果,用来做替换
def test_09_tb_save_all_data(self):
"""保存所有数据到logs/record.txt中，至此公安端页面操作结束"""
savedata = SaveResultToFile()
ajid = savedata.readfile('ajid')
xyrxm = savedata.readfile('嫌疑人姓名')
self.assertIsNotNone(ajid) # 断言是否读取到ajid
savedata.clearfile() # 清除之前的测试数据
savedata.writefile('嫌疑人姓名', xyrxm)
db = DataBase("ga") # 链接数据库，选择ga端，数据库信息在ini文件中读取
sql_ajcm = "SELECT ajxx.c_ajmc FROM db_yw.t_tb_ajxx ajxx WHERE c_id='%s'" % (ajid) # 通过sql查询ajmc
ajmc = db.getdata(sql_ajcm, 0)[1] # 执行sql
savedata.writefile('案件名称', ajmc)
savedata.writefile('平台案件编号', ajid)
sql_jcajid = "SELECT ajxx.c_jcajid FROM db_yw.t_tb_ajxx ajxx WHERE c_id='%s'" % (ajid)
jcajid = db.getdata(sql_jcajid, 0)[1] # 执行sql
savedata.writefile('平台案件关联编号', jcajid)
sql_jsdw = "SELECT corp.c_alias alise_js FROM db_yw.t_tb_ajxx ajxx JOIN db_uim.t_aty_corp corp " \
"ON ajxx.c_jcyjsdw = corp.c_id WHERE ajxx.c_id = '%s'" % (ajid)
jsdw = db.getdata(sql_jsdw, 0)[1] # 执行sql
savedata.writefile('接收单位编号', jsdw)
sql_fsdw = "SELECT corp.c_alias alise_fs FROM db_yw.t_tb_ajxx ajxx JOIN " \
"db_uim.t_aty_corp corp ON ajxx.c_gajysdw = corp.c_id WHERE ajxx.c_id = '%s'" % (ajid)
fsdw = db.getdata(sql_fsdw, 0)[1]
savedata.writefile('发送单位编号', fsdw)
def test_06_get_ajid(self):
"""从页面url获取ajid，并保存到文件中"""
ajid = GetAjidFromUrl(self.driver).getajidfromurl(1)
sa = SaveResultToFile()
sa.writefile('ajid', ajid) # 获取页面ajid并写入文件
