def getchname(chid):
cmsconn=db.getcmsconn()
sql="select qd_name from tdwl_cms_qd t where t.qd_id="+str(chid)
c=cmsconn.cursor()
c.execute(sql)
res = c.fetchone()
c.close()
cmsconn.close()
return res[0]
def getchannelname(channelid):
if channelid=='-1':
return "推荐页"
cmsconn=db.getcmsconn()
sql="select name from tdwl_cms_channel where id="+str(channelid)
c = cmsconn.cursor()
c.execute(sql)
res = c.fetchone()
c.close()
cmsconn.close()
print type(res)
if res==None:
return "-"
else:
return res[0]
def gettitle(itemid):
cmsconn=db.getcmsconn()
sql="select title from tdwl_cms_item where item_id="+str(itemid)
c = cmsconn.cursor()
c.execute(sql)
res = c.fetchone()
if not res :
sql="select title from tdwl_cms_nokia_item where item_id="+str(itemid)
c.execute(sql)
res= c.fetchone()
c.close()
cmsconn.close()
if not res:
res=["无标题 itemid:"+str(itemid)]
return res[0]
