def GetProductInfo(self):
SQL = r'select distinct class from dfr_productline'
result = []
if g_DB.Execute(SQL):
res = g_DB.fetchAll()
if res:
for data in res:
for key in data:
result.append(data[key])
g_Log.LogInfo('获取产品信息成功')
else:
g_Log.LogError('获取产品信息失败')
g_Log.LogDebug('SQL语句:' + SQL)
g_Log.LogDebug('失败原因:' + g_DB.error)
return result
def GetProductFamilyInfo(self, ProductType):
SQL = r'select productFamily from dfr_productline where Class="' + ProductType + '"'
result = []
if g_DB.Execute(SQL):
res = g_DB.fetchAll()
if res:
for data in res:
for key in data:
result.append(data[key])
g_Log.LogInfo('从数据库获取产品族信息成功')
else:
g_Log.LogError('从数据库获取产品族信息失败')
g_Log.LogDebug('SQL语句:' + SQL)
return result