from admin.dboper import *


# 查询资助方信息
def loadSponsorList ():
    sql = "Select * From SponsorInfo"
    results = mySQL_Query(sql)
    return results


# 添加一个资助方信息
def add_SPUnit (Unit):
    # 中文名称, 英文名称, 菜单链接, 父级菜单, 排序
    sql = "insert into SponsorInfo values (NULL, '%s', '%s', '%s', %d, %d) " % (
    Unit[0], Unit[1], Unit[2], int(Unit[3]), int(Unit[4]))
    results = mySQL_Execute(sql)
    return results


# 删除一个资助方信息
def del_SPUnit (Unitid):
    sql = "delete from SponsorInfo where SponsorID =%s" % Unitid
    results = mySQL_Execute(sql)
    return results


# 更新一个资助方信息
def edit_SPUnit (Unit):
    # Unit = [SponsorID, SponsorNameCN, SponsorNameEN, SponsorImage, SOrder, SStatus]
    SponsorID = Unit[0]
    SponsorNameCN = Unit[1]
    SponsorNameEN = Unit[2]
    SponsorImage = Unit[3]
    SOrder = Unit[4]
    SStatus = Unit[5]
    sql = "update SponsorInfo set SponsorNameCN='%s',SponsorNameEN='%s',SponsorImage='%s',SOrder='%s',SStatus='%s' where SponsorID='%s'" % (
    SponsorNameCN, SponsorNameEN, SponsorImage, SOrder, SStatus, SponsorID)
    results = mySQL_Execute(sql)
    return results


# 加载一个资助方信息
def loadSPUnitbyID (Unitid):
    sql = "select *  from SponsorInfo where SponsorID=%s;" % Unitid
    # print("sql:", sql)
    results = mySQL_Query(sql)
    return results