from admin.dboper import *


# 查询所有研究领域
def loadAllResearchArea ():
    sql = "select * from ResearchArea"
    results = mySQL_Query(sql)
    return results


# 查询所有研究领域(前台)
def loadAllResearchArea_Show ():
    sql = "select * from ResearchArea"
    results = mySQL_Query(sql)
    return results



# 查询研究领域信息
def loadResearchAreaInfo ():
    sql = "Select * From ResearchArea "  # where ResearchAreastatus=1
    results = mySQL_Query(sql)
    return results


# 根据研究领域编号查询研究领域信息
def loadResearchAreaInfoByID (RAid):
    sql = "Select * From ResearchArea where RAID=" + RAid
    results = mySQL_Query(sql)
    return results


# 添加一个研究领域
# RAID, RANameCN, RANameEN, RAIntroCN, RAIntroEN, RAOrder, RAStatus
def add_ResearchAreaInfo (data):
    sql = "insert into ResearchArea values (NULL, '%s', '%s', '%s', '%s', %s, %s) " % (
    data[0], data[1], data[2], data[3], data[4], data[5])
    i, msg = mySQL_Execute(sql)
    return i, msg


# 更新一个研究领域
# TID,AuthorID, TName, TUniversityName, TCollegeName, TImage, TTitle, Email, ResearchArea, MainWeb, GoogleWeb, TIntro, TIsShow, TOrder, TStatus
def update_ResearchArea (data):
    sql = "update ResearchArea set RANameCN='%s', RANameEN='%s', RAIntroCN='%s', RAIntroEN='%s', RAOrder=%s, RAStatus=%s  where RAID=%s" % (
    data[0], data[1], data[2], data[3], data[4], data[5], data[6])
    i, msg = mySQL_Execute(sql)
    return i, msg


# 查询一个研究领域
def loadResearchAreaByID (RAid):
    sql = "select * from ResearchArea where RAID=%s" % RAid
    results = mySQL_Query(sql)
    if len(results) > 0: results = results[0]
    return results


# 删除一个研究领域
def del_ResearchArea (RAid):
    sql = "delete from ResearchArea where RAID =%s" % RAid
    i, msg = mySQL_Execute(sql)
    return i, msg