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]