报错：查询出现异常。System.InvalidOperationException: MakeGenericType on non-generic type

import clr

clr.AddReference("System")

clr.AddReference("Kingdee.BOS")

clr.AddReference("Kingdee.BOS.Core")

clr.AddReference("Kingdee.BOS.DataEntity")

clr.AddReference("Kingdee.BOS.App")

clr.AddReference("Kingdee.BOS.App.Core")

clr.AddReference("Kingdee.BOS.Contracts")

clr.AddReference("Kingdee.BOS.ServiceHelper")

clr.AddReference("Kingdee.K3.SCM.App.Stock.Report")

from Kingdee.BOS import*

from Kingdee.BOS.Contracts import*

from Kingdee.BOS.Contracts.Report import*

from Kingdee.BOS.Core import *

from Kingdee.BOS.Core.Metadata import *

from Kingdee.BOS.Core.Report import*

from Kingdee.BOS.Core.SqlBuilder import*

from Kingdee.BOS.App.Data import*

from Kingdee.BOS.Orm.DataEntity import*

from Kingdee.BOS.App.Core import*

from System import*

from System.ComponentModel import*

from System.Collections.Generic import*

from System.Text import*

from System.Threading.Tasks import*

from Kingdee.BOS.ServiceHelper import *

from Kingdee.K3.SCM.App.Stock.Report import *

TempTableName=list[str]();

def BuilderReportSqlAndTempTable(filte,tableName):

global TempTableName;

dbservice = DBService();

TempTableName = dbservice.CreateTemporaryTableName(this.Context, 1);

strTable = TempTableName[0];

super().BuilderReportSqlAndTempTable(filte, strTable);

dyFilter = filte.FilterParameter.CustomFilter;

FZTDAY = 36500;

strSql = ("""

/*dialect*/select t1.*,isnull(t.F_ZT_Qty,0) F_ZT_Qty,isnull(t.F_ZT_DAY,0) as F_ZT_DAY,ISNULL(t.F_ZTDD_Qty,0) F_ZTDD_Qty

into {0} from {1} t1

left join

(select

a.FPURCHASEORGID FPURCHASEORGID,

b.FMATERIALID FMATERIALID,

MAX(DATEDIFF(day,a.FAPPROVEDATE,GETDATE())) F_ZT_DAY,

SUM(ISNULL(c.FREMAINSTOCKINQTY,0)) F_ZT_Qty,

count(c.FREMAINSTOCKINQTY) F_ZTDD_Qty from

t_PUR_POOrder a

inner join T_PUR_POORDERENTRY b on a.FID=b.FID

inner join T_PUR_POORDERENTRY_R c on b.FENTRYID=c.FENTRYID

where 1=1

and a.FDOCUMENTSTATUS='C'

and DATEDIFF(day,a.FAPPROVEDATE,GETDATE())<{2}

and c.FREMAINSTOCKINQTY>0

group by a.FPURCHASEORGID,b.FMATERIALID) t

on t1.FSTOCKORGID = t.FPURCHASEORGID and t1.FMaterialId=t.FMATERIALID

""").format(tableName, strTable, FZTDAY);

DBUtils.Execute(this.Context, strSql);

def CloseReport():

global TempTableName;

if (len(TempTableName) == 0):

return;

dbservice = DBService();

dbservice.DeleteTemporaryTableName(this.Context, TempTableName);

super().CloseReport();

下面是c#代码，#代码能正常使用

using Kingdee.BOS;

using Kingdee.BOS.App.Data;

using Kingdee.BOS.Contracts;

using Kingdee.BOS.Core.Report;

using System.ComponentModel;

using System.Text;

using Kingdee.K3.SCM.App.Stock.Report;

using Kingdee.BOS.Orm.DataEntity;

using System;

namespace HW_KCYJBB_CG

{

[Description("库存预警扩展")]

public class KCYJBB_CG : WarnSafeStockRpt

{

private string[] TempTableName;

public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)

{

//创建临时表用于保存自己的数据

IDBService dbservice = Kingdee.BOS.App.ServiceHelper.GetService<IDBService>();

TempTableName = dbservice.CreateTemporaryTableName(this.Context, 1);

string strTable = TempTableName[0];

//调用基类方法，获取初步的查询结果

base.BuilderReportSqlAndTempTable(filter, strTable);

// 获取快捷过滤页面中自定义字段值

DynamicObject dyFilter = filter.FilterParameter.CustomFilter;

// 在途天数赋值

int FZTDAY = 36500;

string FZTDAY_STR = dyFilter["FZTDAY"].ToString();

if (!"0".Equals(FZTDAY_STR))

{

FZTDAY = Convert.ToInt32(FZTDAY_STR);

}

//对初步的查询结果处理，然后回填到默认的存放查询结果到临时表

StringBuilder sb = new StringBuilder();

string strSql = @"/*dialect*/select t1.*,isnull(t.F_ZT_Qty,0) F_ZT_Qty,isnull(t.F_ZT_DAY,0) as F_ZT_DAY,ISNULL(t.F_ZTDD_Qty,0) F_ZTDD_Qty

into {0} from {1} t1

left join

(select

a.FPURCHASEORGID FPURCHASEORGID,

b.FMATERIALID FMATERIALID,

MAX(DATEDIFF(day,a.FAPPROVEDATE,GETDATE())) F_ZT_DAY,

SUM(ISNULL(c.FREMAINSTOCKINQTY,0)) F_ZT_Qty,

count(c.FREMAINSTOCKINQTY) F_ZTDD_Qty from

t_PUR_POOrder a

inner join T_PUR_POORDERENTRY b on a.FID=b.FID

inner join T_PUR_POORDERENTRY_R c on b.FENTRYID=c.FENTRYID

where 1=1

and a.FDOCUMENTSTATUS='C'

and DATEDIFF(day,a.FAPPROVEDATE,GETDATE())<{2}

and c.FREMAINSTOCKINQTY>0

group by a.FPURCHASEORGID,b.FMATERIALID) t

on t1.FSTOCKORGID = t.FPURCHASEORGID and t1.FMaterialId=t.FMATERIALID";

sb.AppendFormat(strSql, tableName, strTable, FZTDAY);

DBUtils.Execute(this.Context, sb.ToString());

}

public override void CloseReport()

{

//删除临时表

if (TempTableName == null || TempTableName.Length == 0)

{

return;

}

IDBService dbservice = Kingdee.BOS.App.ServiceHelper.GetService<IDBService>();

dbservice.DeleteTemporaryTableName(this.Context, TempTableName);

base.CloseReport();

}

}

}

产品问题python插件，库存预警报表扩展，报错查询出现异常。System.InvalidOperationException:

100 产品问题 python插件，库存预警报表扩展，报错查询出现异常。System.InvalidOperationException:

恭喜您！

产品问题
python插件，库存预警报表扩展，报错查询出现异常。System.InvalidOperationException: