public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)

{

base.BuilderReportSqlAndTempTable(filter, tableName);

DynamicObject customFil = filter.FilterParameter.CustomFilter;

string dtBegin = customFil["Frq"] == null ? "" : customFil["Frq"].ToString();

string dtMTONO = customFil["FMTONO"] == null ? "" : customFil["FMTONO"].ToString();

DynamicObject Fkh = customFil["Fkh"] as DynamicObject;

string dtkh = Fkh == null ? "" : Convert.ToString(Fkh["NAME"]);

string[] CustTempTableNames;

IDBService dbSevice = ServiceHelper.GetService<IDBService>();

CustTempTableNames = dbSevice.CreateTemporaryTableName(this.Context, 3);

StringBuilder sb = new StringBuilder();

string cSql = @"/*dialect*/

create table {0}

(

FXSDDBH varchar(1000),

FMTONO1 varchar(50),

Fddms int,

Fwlbm varchar(1000),

Fddrq date ,

FKHMC varchar(50),

Fylwcsj Date,Fylwczt varchar(10),

Fyjwcsj Date,Fyjwczt varchar(10),

Fhzwcsj Date,Fhzwczt varchar(10),

Frk numeric(32,2),

Fck numeric(32,2),

Fth numeric(32,5),

Fwc numeric(32,2)

)

sb.AppendFormat(cSql, CustTempTableNames[0]);

cSql = @"declare @dtBegin date='{0}',@dtMTONO varchar(50)='{1}',@dtkh varchar(50)='{2}'

select FBILLNO FXSDDBH,

FMTONO FMTONO1,

FQTY Fddms,

FMATERIALID Fwlbm,

fdate Fddrq ,

FCUSTID FKHMC,

'2020-3-27' Fylwcsj,1 Fylwczt,

'2020-3-27' Fyjwcsj,1 Fyjwczt,

'2020-3-27' Fhzwcsj,1 Fhzwczt,

1 Frk,1 Fck,1 Fth,1 Fwc

into{2}

FROM T_SAL_ORDER DD

LEFT JOIN T_SAL_ORDERENTRY DD1 ON DD.FID=DD1.FID

WHERE FMTONO like '%@dtMTONO%' and FDATE=@dtBegin and FCUSTID=@dtkh

sb.AppendFormat(cSql, dtBegin, dtMTONO, dtkh, CustTempTableNames[1]);

cSql = @"insert into {1}(

FXSDDBH,

FMTONO1,

Fddms ,

Fwlbm ,

Fddrq ,

FKHMC ,

Fylwcsj ,Fylwczt ,

Fyjwcsj ,Fyjwczt ,

Fhzwcsj ,Fhzwczt ,

Frk ,

Fck ,

Fth ,

Fwc )

select FXSDDBH,

FMTONO1,

Fddms ,

Fwlbm ,

Fddrq ,

FKHMC ,

Fylwcsj ,Fylwczt ,

Fyjwcsj ,Fyjwczt ,

Fhzwcsj ,Fhzwczt ,

Frk ,

Fck ,

Fth ,

Fwc

FROM T_SAL_ORDER DD

LEFT JOIN T_SAL_ORDERENTRY DD1 ON DD.FID=DD1.FID

WHERE FMTONO like '%@dtMTONO%' and FDATE=@dtBegin and FCUSTID=@dtkh

sb.AppendFormat(cSql, CustTempTableNames[1], CustTempTableNames[0]);

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

}

public override ReportTitles GetReportTitles(IRptParams filter)

{

var result = base.GetReportTitles(filter);

DynamicObject dyFilter = filter.FilterParameter.CustomFilter;

if (dyFilter != null)

{

if (result == null)

{

result = new ReportTitles();

}

result.AddTitle("Frq", Convert.ToString(dyFilter["Frq"]));

result.AddTitle("FMTONO", Convert.ToString(dyFilter["FMTONO"]));

result.AddTitle("Fkh", Convert.ToString(dyFilter["Fkh"]));

}

return result;

}

产品问题简单报表开发条件框过滤。提示：查询出现异常。关键字 'FROM' 附近有语法错误。

产品问题 简单报表开发条件框过滤。提示：查询出现异常。关键字 'FROM' 附近有语法错误。

恭喜您！

产品问题
简单报表开发条件框过滤。提示：查询出现异常。关键字 'FROM' 附近有语法错误。

产品问题简单报表开发条件框过滤。提示：查询出现异常。关键字 'FROM' 附近有语法错误。