def select_sp():
obj = deal_mysql("uspset.ini")
msg = '''select id,name from u_sp'''
results = obj.askdata(msg)
obj.Close()
headers = ["运营商名称"]
print(yate.start_response())
print(yate.include_header("首页运营"))
print(yate.start_form("op_guidepage_arrange.py"))
print(yate.start_table(tb_width="50%", tb_border="1px solid"))
print(yate.tb_header(headers))
for array in results:
print(yate.start_row())
print(yate.checked_radio_button('which_spid',[array[0],array[1]]))
print(yate.end_row())
print(yate.end_table())
print(yate.start_table(tb_width="50%", tb_border="1px solid"))
print(yate.start_row())
print(yate.end_form("确定"))
print(yate.end_row())
print(yate.end_table())
def ft_channels_edit_second():
start_response()
chid = get_formData('which_chid')
obj = deal_mysql()
msg = ("""SELECT ulv.channel_id,tvs.chname,ulv.gen_address
from ulv_genaddress as ulv inner join tvs_channel as tvs
on ulv.channel_id=tvs.chid and ulv.channel_id=%s""" % chid[0])
result = obj.askdata(msg)
info = result.pop(0)
headers = ["频道信息"]
print(yate.include_header("频道修改"))
print(yate.start_form("ft_channels_editDone.py"))
print(yate.start_table(tb_width="100%", tb_border="1px solid"))
print(yate.tb_header(headers))
print(yate.start_row())
print(yate.checked_radio_button('which_chid',[info[0],info[1]]))
print(yate.end_row())
print(yate.start_row())
print(yate.input_text("which_addr",info[2]))
print(yate.end_row())
print(yate.start_row())
print(yate.end_form("确定"))
print(yate.end_row())
print(yate.end_table())
obj.Close()
