简单账表： 实体类型ORMAR_AgingA中不存在名为BeginDate的属性，
xiguan
1410次浏览
编辑于2018年05月16日 23:28:57
在应收账款账龄分析表上添加一个“立账类型”的字段，去应收单上的“立账类型”，提示：查询出现异常。Kingdee.BOS.Orm.Exceptions.ORMDesignException: 实体类型ORMAR_AgingA中不存在名为BeginDate的属性，
请高手帮忙解答一下，感激！
public class Class1 : ARDetailReportService
{
private string []reporttemptablename;
public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
{
IDBService dbservice = Kingdee.BOS.App.ServiceHelper.GetService();
reporttemptablename = dbservice.CreateTemporaryTableName(this.Context,1);
string strtable = reporttemptablename[0];
base.BuilderReportSqlAndTempTable(filter, strtable);
StringBuilder sb = new StringBuilder();
string sql = "select t1.fbillno,t2.FSETACCOUNTTYPE into{0} "+
" from {1} t1"+
"left join t_AR_receivable t2"+
"on t1.fbillno = t2.fbillno";
sb.AppendFormat(sql, tableName, strtable);
DBUtils.Execute(this.Context, sb.ToString());
}
public override void CloseReport()
{
if (reporttemptablename==null)
{
return;
}
IDBService dbService = Kingdee.BOS.App.ServiceHelper.GetService();
dbService.DeleteTemporaryTableName(this.Context, reporttemptablename);
base.CloseReport();
}
}
}
请高手帮忙解答一下，感激！
public class Class1 : ARDetailReportService
{
private string []reporttemptablename;
public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
{
IDBService dbservice = Kingdee.BOS.App.ServiceHelper.GetService
reporttemptablename = dbservice.CreateTemporaryTableName(this.Context,1);
string strtable = reporttemptablename[0];
base.BuilderReportSqlAndTempTable(filter, strtable);
StringBuilder sb = new StringBuilder();
string sql = "select t1.fbillno,t2.FSETACCOUNTTYPE into{0} "+
" from {1} t1"+
"left join t_AR_receivable t2"+
"on t1.fbillno = t2.fbillno";
sb.AppendFormat(sql, tableName, strtable);
DBUtils.Execute(this.Context, sb.ToString());
}
public override void CloseReport()
{
if (reporttemptablename==null)
{
return;
}
IDBService dbService = Kingdee.BOS.App.ServiceHelper.GetService
dbService.DeleteTemporaryTableName(this.Context, reporttemptablename);
base.CloseReport();
}
}
}
推荐阅读