自己做的一个分页账表。挂上之后报错

using Kingdee.BOS;

using Kingdee.BOS.App.Data;

using Kingdee.BOS.Contracts;

using Kingdee.BOS.Contracts.Report;

using Kingdee.BOS.Core.Metadata;

using Kingdee.BOS.Core.Report;

using Kingdee.BOS.Core.SqlBuilder;

using Kingdee.BOS.Orm.DataEntity;

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Text;

namespace Kingdee.BOS.TesetPoOrderTable

{

[Description("原材料进货明细表")]

public class FYPOOrderDetailt : SysReportBaseService

{

//初始化

public override void Initialize()

{

//初始化

base.Initialize();

// 简单账表类型：普通、树形、分页

ReportProperty.ReportType = ReportType.REPORTTYPE_MOVE;

//是否分组汇总

ReportProperty.IsGroupSummary = true;

//引用设计器列

ReportProperty.IsUIDesignerColumns = false;

}

/// <summary>

/// 分页报表必须实现的方法，此方法用于为报表提供分页依据。

/// </summary>

/// <param name="filter"></param>

/// <returns></returns>

[Obsolete]

#pragma warning disable CS0809 // 过时成员重写未过时成员

public override DataTable GetList(IRptParams filter)

#pragma warning restore CS0809 // 过时成员重写未过时成员

{

DataTable dt;

DynamicObject customFilter = filter.FilterParameter.CustomFilter;

string sSQL = string.Format(@"/*dialect*/select FNAME as Orgname from T_ORG_ORGANIZATIONS a inner join T_ORG_ORGANIZATIONS_L b

on a.FORGID = b.FORGID and b.FLOCALEID = 2052 where a.FORGID in ({0})", Convert.ToString(customFilter["F_PAEZ_OrgId"]));

dt = DBUtils.ExecuteDataSet(this.Context, sSQL).Tables[0];

return dt;

}

//获取过滤条件信息(构造单据标题)

public override ReportTitles GetReportTitles(IRptParams filter)

{

ReportTitles reportTitles = new ReportTitles();

DynamicObject customFilter = filter.FilterParameter.CustomFilter;

if (customFilter != null)

{

//通过customFilter，把单据全部读取出来，组织传过来是内部ID

string multiOrgnNameValues = this.GetMultiOrgnNameValues(customFilter["F_PAEZ_OrgId"].ToString());

string starValue = (customFilter["FOrderStartDate"] == null) ? string.Empty : Convert.ToDateTime(customFilter["FOrderStartDate"]).ToString("yyyy-MM-dd");

string endValues = (customFilter["FOrderEndDate"] == null) ? string.Empty : Convert.ToDateTime(customFilter["FOrderEndDate"]).ToString("yyyy-MM-dd");

string baseDataNameValue = this.GetBaseDataNameValue(customFilter["F_PAEZ_WLID"] as DynamicObjectCollection);

string baseDataNameValue1 = this.GetBaseDataNameValue(customFilter["F_PAEZ_WLID1"] as DynamicObjectCollection);

string baseDataNameValue2 = this.GetBaseDataNameValue(customFilter["F_PAEZ_CKID"] as DynamicObjectCollection);

string baseDataNameValue3 = this.GetBaseDataNameValue(customFilter["F_PAEZ_CKID1"] as DynamicObjectCollection);

string baseDataNameValue4 = this.GetBaseDataNameValue(customFilter["F_PAEZ_SuppId"] as DynamicObjectCollection);

string baseDataNameValue5 = this.GetBaseDataNameValue(customFilter["F_PAEZ_SuppId1"] as DynamicObjectCollection);

reportTitles.AddTitle("F_PAEZ_Org", multiOrgnNameValues);

reportTitles.AddTitle("F_PAEZ_StarDate", starValue);

reportTitles.AddTitle("F_PAEZ_EndDate", endValues);

reportTitles.AddTitle("F_PAEZ_WLName", baseDataNameValue +"-"+ baseDataNameValue1);

reportTitles.AddTitle("F_PAEZ_CK", baseDataNameValue2 + "-" + baseDataNameValue3);

reportTitles.AddTitle("F_PAEZ_GYS", baseDataNameValue4 + "-" + baseDataNameValue5);

}

return reportTitles;

}

//获取组织名称

private string GetMultiOrgnNameValues(string orgIdStrings)

{

//把传过来的ID，改成文本，放在报表表头

List<string> list = new List<string>();

string result = string.Empty;

if (orgIdStrings.Trim().Length > 0)

{

IQueryService service = Kingdee.BOS.Contracts.ServiceFactory.GetService<IQueryService>(base.Context);

QueryBuilderParemeter para = new QueryBuilderParemeter

{

FormId = "ORG_Organizations",

SelectItems = SelectorItemInfo.CreateItems("FNAME"),

FilterClauseWihtKey = string.Format(" FORGID IN ({0}) AND FLOCALEID={1}", orgIdStrings, base.Context.UserLocale.LCID)

};

DynamicObjectCollection dynamicObjectCollection = service.GetDynamicObjectCollection(base.Context, para, null);

foreach (DynamicObject current in dynamicObjectCollection)

{

list.Add(current["FNAME"].ToString());

}

if (list.Count > 0)

{

result = string.Join(",", list.ToArray());

}

return result;

}

//基础资料名称

private string GetBaseDataNameValue(DynamicObjectCollection dyobj)

{

string name = "";

foreach (DynamicObject dynbj in dyobj)

{

if (dynbj != null || !dynbj.DynamicObjectType.Properties.Contains("Name"))

{

DynamicObject dynbj2 = (DynamicObject)dynbj[2];

name = name + ",'" + dynbj2["Name"].ToString() + "'";

}

if (name.Length > 0)

{

name = name.Substring(1, name.Length - 1);

}

return name;

}

//设置单据列

public override ReportHeader GetReportHeaders(IRptParams filter)

{

ReportHeader header = new ReportHeader();

// 编号

header.AddChild("FOrgName", new LocaleValue("组织", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);

header.AddChild("FDATE", new LocaleValue("业务日期", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);

header.AddChild("FSRCBILLNO", new LocaleValue("源单编号", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);

header.AddChild("FBILLNO", new LocaleValue("订单编号", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);

header.AddChild("FUnitName", new LocaleValue("供应商", this.Context.UserLocale.LCID), SqlStorageType.SqlDatetime);

header.AddChild("FCkname", new LocaleValue("仓库", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);

header.AddChild("FNUMBER", new LocaleValue("物料编码", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);

header.AddChild("FMaterialName", new LocaleValue("物料名称", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);

header.AddChild("FSPECIFICATION", new LocaleValue("规格型号", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);

header.AddChild("FJjname", new LocaleValue("计价单位", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);

header.AddChild("FTAXPRICE", new LocaleValue("含税单价", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);

header.AddChild("FPRICEUNITQTY", new LocaleValue("计价数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);

header.AddChild("FALLAMOUNT", new LocaleValue("价税合计", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);

header.AddChild("F_PAEZ_TEXT", new LocaleValue("订单跟踪号", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);

header.AddChild("FNOTE", new LocaleValue("备注", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);

return header;

}

//创建临时报表

public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)

{

DataRow dr = this.CacheDataList[filter.CurrentPosition];

string Filter = GetFilterWhere(filter);

string seqFld = string.Format(base.KSQL_SEQ, OrderColumn(filter));

// 取数SQL

string sql = string.Format(@"/*dialect*/

select FOrgName,FDATE,FSRCBILLNO,FBILLNO,FUnitName,FCkname,FNUMBER,FMaterialName,FSPECIFICATION,FJjname,FTAXPRICE,FPRICEUNITQTY,FALLAMOUNT,F_PAEZ_TEXT,FNOTE,

{0} into {1} from

(

SELECT i.fname as FOrgName,

a.FDATE,

FBILLNO,

FSRCBILLNO,

c.fname as FUnitName,

d.Fname as FCkname,

e.FNUMBER,

f.fname as FMaterialName,

FSPECIFICATION,

h.fname as FJjname,

ISNULL(FTAXPRICE,4) as FTAXPRICE,

FPRICEUNITQTY,

FALLAMOUNT,

b.F_PAEZ_TEXT,

b.FNOTE

FROM t_STK_InStock a

inner join T_STK_INSTOCKENTRY b on (a.fid=b.fid)

inner join T_BD_SUPPLIER_L c on (a.FSUPPLIERID=c.FSUPPLIERID)

inner join T_BD_STOCK_L d on (b.FSTOCKID=d.FSTOCKID)

inner join T_BD_MATERIAL e on (b.FMATERIALID=e.FMATERIALID)

inner join T_BD_MATERIAL_l f on (e.FMATERIALID=f.FMATERIALID)

inner join T_STK_INSTOCKENTRY_F g on (b.FENTRYID=g.FENTRYID)

inner join T_BD_UNIT_l h on (g.FPRICEUNITID=h.funitid)

inner join T_ORG_Organizations_l i on (a.FPURCHASEORGID=i.forgid)

) t1 {2} AND FOrgname='{3}'

seqFld,

tableName

, Filter

, dr["Orgname"].ToString()

);

DBUtils.ExecuteDynamicObject(this.Context, sql);

}

////获取过滤条件

private string GetFilterWhere(IRptParams filter)

{

DynamicObject customFilter = filter.FilterParameter.CustomFilter;

StringBuilder strwhere = new StringBuilder();

strwhere.AppendLine("Where 1=1 ");

//组织

string org = string.IsNullOrWhiteSpace(customFilter["F_PAEZ_OrgId"].ToString())

? " " : string.Format(" AND FOrgName IN ({0}) ", Convert.ToString(customFilter["F_PAEZ_OrgId"]));

strwhere.AppendLine(org);

//日期

string startValue = (customFilter["FOrderStartDate"] == null) ? string.Empty : Convert.ToDateTime(customFilter["FOrderStartDate"]).ToString("yyyy-MM-dd");

string endValue = (customFilter["FOrderEndDate"] == null) ? string.Empty : Convert.ToDateTime(customFilter["FOrderEndDate"]).ToString("yyyy-MM-dd");

strwhere.AppendLine(string.Format(" AND FDate>='{0}' and FDate<='{1}' ", startValue, endValue));

//物料

string baseDataNameValue = this.GetBaseDataNameValue(customFilter["F_PAEZ_WLID"] as DynamicObjectCollection);

string baseDataNameValue1 = this.GetBaseDataNameValue(customFilter["F_PAEZ_WLID1"] as DynamicObjectCollection);

string MaterailName = string.IsNullOrWhiteSpace(baseDataNameValue)

? " " : string.Format(" AND FMaterialName>= '{0}' and AND FMaterialName<='{1}' ", baseDataNameValue, baseDataNameValue1);

strwhere.AppendLine(MaterailName);

//仓库

string baseDataNameValue2 = this.GetBaseDataNameValue(customFilter["F_PAEZ_CKID"] as DynamicObjectCollection);

string baseDataNameValue3 = this.GetBaseDataNameValue(customFilter["F_PAEZ_CKID1"] as DynamicObjectCollection);

string CKName = string.IsNullOrWhiteSpace(baseDataNameValue)

? " " : string.Format(" AND CKName>= '{0}' and AND CKName<='{1}' ", baseDataNameValue2, baseDataNameValue3);

strwhere.AppendLine(CKName);

//供应商

string baseSuppName = this.GetBaseDataNameValue(customFilter["F_PAEZ_SuppId"] as DynamicObjectCollection);

string baseSuppName1 = this.GetBaseDataNameValue(customFilter["F_PAEZ_SuppId1"] as DynamicObjectCollection);

string SuppName = string.IsNullOrWhiteSpace(baseSuppName)

? " " : string.Format(" AND SuppName>= '{0}' and AND SuppName<='{1}' ", baseSuppName, baseSuppName1);

strwhere.AppendLine(SuppName);

string text2 = string.IsNullOrWhiteSpace(filter.FilterParameter.FilterString) ? " " : " AND " + filter.FilterParameter.FilterString.Replace("{ts", "").Replace("}", "");

strwhere.AppendLine(text2);

return strwhere.ToString();

}

/// 设置汇总列信息

public override List<SummaryField> GetSummaryColumnInfo(IRptParams filter)

{

var result = base.GetSummaryColumnInfo(filter);

result.Add(new SummaryField("FPRICEUNITQTY", Kingdee.BOS.Core.Enums.BOSEnums.Enu_SummaryType.SUM));

result.Add(new SummaryField("FALLAMOUNT", Kingdee.BOS.Core.Enums.BOSEnums.Enu_SummaryType.SUM));

return result;

}

///排序语句

private string OrderColumn(IRptParams filter)

{

string datasort = Convert.ToString(filter.FilterParameter.SortString);//排序

string OrderBy;

if (datasort != "")

{

OrderBy = " " + datasort + " ";

}

else

{

OrderBy = " FDate ";

}

return OrderBy;

}

产品问题未将对象引用到对象的实例，帮忙看看哪里有问题，多谢

产品问题 未将对象引用到对象的实例，帮忙看看哪里有问题，多谢

恭喜您！

产品问题
未将对象引用到对象的实例，帮忙看看哪里有问题，多谢

产品问题未将对象引用到对象的实例，帮忙看看哪里有问题，多谢