private ReportHeader ReportHeadersDeal(IRptParams filter)
{
int childCount = 0;
ReportHeader header = new ReportHeader();
header.AddChild("FDEPTORG", new LocaleValue(ResManager.LoadKDString("预算组织", "0032055000021891", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID));
header.AddChild("FYEAR", new LocaleValue(ResManager.LoadKDString("预算年度", "0032055000021893", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID));
header.AddChild("FPERIOD", new LocaleValue(ResManager.LoadKDString("预算期间", "0032055000021894", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID));
header.AddChild("FBUSINESSTYPE", new LocaleValue(ResManager.LoadKDString("预算业务类型", "0032055000021880", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID));
header.AddChild("FDATATYPE", new LocaleValue(ResManager.LoadKDString("项目数据类型", "0032055000021881", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID));
this.GetDimensionHeader(header);
if (this.filterParameter.IsStandardCurrency)
{
ListHeader header2 = header.AddChild();
childCount = header.GetChildCount();
header2.ColIndex = childCount + 1;
header2.Caption = new LocaleValue(ResManager.LoadKDString("原币", "0032055000022021", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID);
header2.AddChild("FCURRENCY", new LocaleValue(ResManager.LoadKDString("币别", "0032055000022022", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID));
header2.AddChild("FVALUE", new LocaleValue(ResManager.LoadKDString("预算数", "0032055000021888", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID), SqlStorageType.SqlDecimal, true);
ListHeader header3 = header.AddChild();
childCount = header.GetChildCount();
header3.ColIndex = childCount + 1;
header3.Caption = new LocaleValue(ResManager.LoadKDString("本位币", "0032055000022023", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID);
header3.AddChild("FBWBCURRENCY", new LocaleValue(ResManager.LoadKDString("币别", "0032055000022022", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID));
header3.AddChild("FBASEVALUE", new LocaleValue(ResManager.LoadKDString("预算数", "0032055000021888", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID), SqlStorageType.SqlDecimal, true);
}
else
{
header.AddChild("FCURRENCY", new LocaleValue(ResManager.LoadKDString("币别", "0032055000022022", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID));
header.AddChild("FVALUE", new LocaleValue(ResManager.LoadKDString("预算数", "0032055000021888", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID), SqlStorageType.SqlDecimal, true);
}
if (this.filterParameter.IsShowAdjustDetaildata)
{
header.AddChild("FADJUSTTYPE", new LocaleValue(ResManager.LoadKDString("数据类型", "0032055000022024", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID));
}
return(header);
}
private ReportHeader GetDimensionHeader(ReportHeader header)
{
ListHeader header2 = header.AddChild();
int childCount = header.GetChildCount();
header2.ColIndex = childCount + 1;
header2.Caption = new LocaleValue(ResManager.LoadKDString("预算维度", "0032055000021878", SubSystemType.FIN, new object[0]), base.Context.UserLocale.LCID);
foreach (KeyValuePair <int, DimensionInfo> pair in this.dicDimensionInfo)
{
if (pair.Value.IsShowField)
{
header2.AddChild(pair.Value.ShowFieldName, new LocaleValue(pair.Value.Name, base.Context.UserLocale.LCID));
}
}
return(header);
}
/// <summary>
/// 动态够造列
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public override ReportHeader GetReportHeaders(IRptParams filter)
{
Kingdee.BOS.Core.List.ListHeader ranking, mnumber, mname, model, group, cty, saler, custnumber, custname, dep;
ReportHeader header = new ReportHeader();
ranking = header.AddChild("FIDENTITYID", new LocaleValue("排名"), 0);
ranking.Width = 40;
switch (RankingOnNew)
{
case "COUNTRYMATERIAL":
mnumber = header.AddChild("FMNUMBER", new LocaleValue("物料编码"), 1);
mnumber.Width = 160;
mname = header.AddChild("FMNAME", new LocaleValue("物料名称"), 2);
mname.Width = 140;
model = header.AddChild("FModel", new LocaleValue("规格描述"), 3);
model.Width = 200;
group = header.AddChild("FGROUPNAME", new LocaleValue("物料分组"), 4);
group.Width = 140;
cty = header.AddChild("FCOUNTRYNAME", new LocaleValue("客户国家"), 5);
cty.Width = 60;
break;
case "SALERCUSTCOUNTRY":
saler = header.AddChild("FSALERNAME", new LocaleValue("业务员"), 1);
saler.Width = 60;
custnumber = header.AddChild("FCUSTNUMBER", new LocaleValue("客户代码"), 2);
custnumber.Width = 60;
custname = header.AddChild("FCUSTNAME", new LocaleValue("客户名称"), 3);
custname.Width = 120;
cty = header.AddChild("FCOUNTRYNAME", new LocaleValue("客户国家"), 4);
cty.Width = 60;
break;
case "MATERIALGROUP":
group = header.AddChild("FGROUPNAME", new LocaleValue("物料分组"), 1);
group.Width = 140;
break;
case "BD_CUSTOMER":
custnumber = header.AddChild("FCUSTNUMBER", new LocaleValue("客户代码"), 1);
custnumber.Width = 60;
custname = header.AddChild("FCUSTNAME", new LocaleValue("客户名称"), 2);
custname.Width = 120;
cty = header.AddChild("FCOUNTRYNAME", new LocaleValue("客户国家"), 3);
cty.Width = 60;
break;
case "SALER":
saler = header.AddChild("FSALERNAME", new LocaleValue("业务员"), 1);
saler.Width = 60;
break;
case "SALEDEPARTMENT":
dep = header.AddChild("FDEPNAME", new LocaleValue("销售部门"), 1);
dep.Width = 60;
break;
case "CUSTMATERIALGROUP":
custnumber = header.AddChild("FCUSTNUMBER", new LocaleValue("客户代码"), 1);
custnumber.Width = 60;
custname = header.AddChild("FCUSTNAME", new LocaleValue("客户名称"), 2);
custname.Width = 120;
group = header.AddChild("FGROUPNAME", new LocaleValue("物料分组"), 3);
group.Width = 140;
break;
case "SALERCUSTMATERIALGROUP":
saler = header.AddChild("FSALERNAME", new LocaleValue("业务员"), 1);
saler.Width = 60;
custnumber = header.AddChild("FCUSTNUMBER", new LocaleValue("客户代码"), 2);
custnumber.Width = 60;
custname = header.AddChild("FCUSTNAME", new LocaleValue("客户名称"), 3);
custname.Width = 120;
group = header.AddChild("FGROUPNAME", new LocaleValue("物料分组"), 4);
group.Width = 140;
break;
case "BD_MATERIAL":
mnumber = header.AddChild("FMNUMBER", new LocaleValue("物料编码"), 1);
mnumber.Width = 160;
mname = header.AddChild("FMNAME", new LocaleValue("物料名称"), 2);
mname.Width = 140;
model = header.AddChild("FModel", new LocaleValue("规格描述"), 3);
model.Width = 200;
group = header.AddChild("FGROUPNAME", new LocaleValue("物料分组"), 4);
group.Width = 140;
break;
case "SALERMATERIAL":
saler = header.AddChild("FSALERNAME", new LocaleValue("业务员"), 1);
saler.Width = 60;
mnumber = header.AddChild("FMNUMBER", new LocaleValue("物料编码"), 2);
mnumber.Width = 160;
mname = header.AddChild("FMNAME", new LocaleValue("物料名称"), 3);
mname.Width = 140;
model = header.AddChild("FModel", new LocaleValue("规格描述"), 4);
model.Width = 200;
group = header.AddChild("FGROUPNAME", new LocaleValue("物料分组"), 5);
group.Width = 140;
break;
case "SALEDEPMATERIAL":
dep = header.AddChild("FDEPNAME", new LocaleValue("销售部门"), 1);
dep.Width = 60;
mnumber = header.AddChild("FMNUMBER", new LocaleValue("物料编码"), 2);
mnumber.Width = 160;
mname = header.AddChild("FMNAME", new LocaleValue("物料名称"), 3);
mname.Width = 140;
model = header.AddChild("FModel", new LocaleValue("规格描述"), 4);
model.Width = 200;
group = header.AddChild("FGROUPNAME", new LocaleValue("物料分组"), 5);
group.Width = 140;
break;
case "CUSTMATERIAL":
custnumber = header.AddChild("FCUSTNUMBER", new LocaleValue("客户代码"), 1);
custnumber.Width = 60;
custname = header.AddChild("FCUSTNAME", new LocaleValue("客户名称"), 2);
custname.Width = 120;
mnumber = header.AddChild("FMNUMBER", new LocaleValue("物料编码"), 3);
mnumber.Width = 160;
mname = header.AddChild("FMNAME", new LocaleValue("物料名称"), 4);
mname.Width = 140;
model = header.AddChild("FModel", new LocaleValue("规格描述"), 5);
model.Width = 200;
group = header.AddChild("FGROUPNAME", new LocaleValue("物料分组"), 6);
group.Width = 140;
break;
case "CUSTOMERSALERMATERIAL":
custnumber = header.AddChild("FCUSTNUMBER", new LocaleValue("客户代码"), 1);
custnumber.Width = 60;
custname = header.AddChild("FCUSTNAME", new LocaleValue("客户名称"), 2);
custname.Width = 120;
saler = header.AddChild("FSALERNAME", new LocaleValue("业务员"), 3);
saler.Width = 60;
mnumber = header.AddChild("FMNUMBER", new LocaleValue("物料编码"), 4);
mnumber.Width = 160;
mname = header.AddChild("FMNAME", new LocaleValue("物料名称"), 5);
mname.Width = 140;
model = header.AddChild("FModel", new LocaleValue("规格描述"), 6);
model.Width = 200;
group = header.AddChild("FGROUPNAME", new LocaleValue("物料分组"), 7);
group.Width = 140;
break;
}
var qty = header.AddChild("FSalQty", new LocaleValue("销售数量"), SqlStorageType.SqlDecimal);
qty.ColIndex = header.GetChildCount() - 1;
qty.Width = 80;
var amt = header.AddChild("FAmount", new LocaleValue("销售金额"), SqlStorageType.SqlDecimal);
//amt.ColIndex = 22;
amt.Width = 90;
var price = header.AddChild("FPrice", new LocaleValue("平均单价"), SqlStorageType.SqlDecimal);
//price.ColIndex = 23;
price.Width = 60;
return(header);
}