public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
ListHeader header1 = header.AddChild();
ListHeader header2 = header.AddChild();
ListHeader header3 = header.AddChild();
header1.Caption = new LocaleValue("客户名称", this.Context.UserLocale.LCID);
header2.Caption = new LocaleValue("单据编码", this.Context.UserLocale.LCID);
header3.Caption = new LocaleValue("提货日期", this.Context.UserLocale.LCID);
// 编号
var seq = header1.AddChild("FSEQ", new LocaleValue("序号"));
seq.ColIndex = 0;
var materialId = header1.AddChild("FMATERIALID", new LocaleValue("物料编码"));
materialId.ColIndex = 1;
var name = header1.AddChild("FNAME", new LocaleValue("品名"));
name.ColIndex = 2;
var specifiCation = header2.AddChild("FSPECIFICATION", new LocaleValue("规格"), SqlStorageType.SqlDecimal);
specifiCation.ColIndex = 3;
//待定 装箱数
var packingQty = header2.AddChild("FPACKQTY ", new LocaleValue("装箱数"), SqlStorageType.SqlInt);
packingQty.ColIndex = 4;
var price = header2.AddChild("FTAXPRICE", new LocaleValue("含税单价"), SqlStorageType.SqlMoney);
price.ColIndex = 5;
var relQty = header2.AddChild("FREALQTY", new LocaleValue("实发数量"), SqlStorageType.SqlInt);
relQty.ColIndex = 6;
//待定 箱数
var packQty = header2.AddChild("FPACKERQTY", new LocaleValue("箱数"), SqlStorageType.SqlInt);
packQty.ColIndex = 7;
var produceDate = header3.AddChild("FPRODUCEDATE", new LocaleValue("生产日期"), SqlStorageType.SqlDatetime);
produceDate.ColIndex = 8;
//保质期
var expiryPeriod = header3.AddChild("FEXPPERIOD ", new LocaleValue("保质期"), SqlStorageType.SqlnText);
expiryPeriod.ColIndex = 9;
//结算金额（含税金额* 实发数量）
var amount = header3.AddChild("FALLAMOUNT", new LocaleValue("结算金额"), SqlStorageType.SqlMoney);
amount.ColIndex = 10;
return(header);
}
/// <summary>
/// 双表头
/// </summary>
/// <param name="headerName"></param>
/// <param name="fieldDrys"></param>
private void setField(string headerName, ref Dictionary <string, string> fieldDrys)
{
//合并表头
ListHeader lsHeader = header.AddChild();
lsHeader.Caption = new LocaleValue(headerName);
foreach (KeyValuePair <string, string> fieldDry in fieldDrys)
{
lsHeader.AddChild(fieldDry.Key, new LocaleValue(fieldDry.Value, this.Context.UserLocale.LCID));
}
fieldDrys.Clear();
}
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);
}
public override ReportHeader GetReportHeaders(IRptParams filter)
{
//int columnFilter = Convert.ToInt32(filter.FilterParameter.CustomFilter["F_TL_Combo"]);
ReportHeader header = new ReportHeader();
//header.AddChild("FNUM1", new LocaleValue("序号", this.Context.UserLocale.LCID));
header.AddChild("FNAME", new LocaleValue(ColumnShowFilter(filter), this.Context.UserLocale.LCID));
ListHeader header2 = header.AddChild();
header2.Caption = new LocaleValue("汇总", this.Context.UserLocale.LCID);
if ((columnFilter != 4) && (columnFilter != 5))
{
header2.AddChild("FSTOCKNUM", new LocaleValue("进货数量", this.Context.UserLocale.LCID), SqlStorageType.SqlInt);
header2.AddChild("FSALENUM", new LocaleValue("销售数量", this.Context.UserLocale.LCID), SqlStorageType.SqlInt);
header2.AddChild("FRETURNNUM", new LocaleValue("返货数量", this.Context.UserLocale.LCID), SqlStorageType.SqlInt);
}
header2.AddChild("FSTOCKQUOTA", new LocaleValue("进货额", this.Context.UserLocale.LCID), SqlStorageType.SqlMoney);
header2.AddChild("FSALEQUOTA", new LocaleValue("销售额", this.Context.UserLocale.LCID), SqlStorageType.SqlMoney);
header2.AddChild("FRETURNQUOTA", new LocaleValue("返货额", this.Context.UserLocale.LCID), SqlStorageType.SqlMoney);
header2.AddChild("FSALEPER", new LocaleValue("销售占比", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
header2.AddChild("FRETURNPER", new LocaleValue("返货率", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
ListHeader header3 = header.AddChild();
header3.Caption = new LocaleValue("去年同期", this.Context.UserLocale.LCID);
if ((columnFilter != 4) && (columnFilter != 5))
{
header3.AddChild("FSTOCKNUM_LAST", new LocaleValue("进货数量", this.Context.UserLocale.LCID), SqlStorageType.SqlInt);
header3.AddChild("FSALENUM_LAST", new LocaleValue("销售数量", this.Context.UserLocale.LCID), SqlStorageType.SqlInt);
header3.AddChild("FRETURNNUM_LAST", new LocaleValue("返货数量", this.Context.UserLocale.LCID), SqlStorageType.SqlInt);
}
header3.AddChild("FSTOCKQUOTA_LAST", new LocaleValue("进货额", this.Context.UserLocale.LCID), SqlStorageType.SqlMoney);
header3.AddChild("FSALEQUOTA_LAST", new LocaleValue("销售额", this.Context.UserLocale.LCID), SqlStorageType.SqlMoney);
header3.AddChild("FRETURNQUOTA_LAST", new LocaleValue("返货额", this.Context.UserLocale.LCID), SqlStorageType.SqlMoney);
header3.AddChild("FSALEPER_LAST", new LocaleValue("销售占比", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
header3.AddChild("FRETURNPER_LAST", new LocaleValue("返货率", this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
header.AddChild("FSALEQUOTAPER", new LocaleValue("销售额同比成长", this.Context.UserLocale.LCID));
return(header);
}
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
header.AddChild("FLINENAME", new LocaleValue("线路", this.Context.UserLocale.LCID));
header.AddChild("FDELIVIRYROUND", new LocaleValue("配送周期", this.Context.UserLocale.LCID), SqlStorageType.SqlInt);
header.AddChild("FCUSTOMER", new LocaleValue("未按配送周期客户", this.Context.UserLocale.LCID));
header.AddChild("BZPS", new LocaleValue("标准配送次数", this.Context.UserLocale.LCID));
header.AddChild("HJPSS", new LocaleValue("按标准配送次数", this.Context.UserLocale.LCID));
header.AddChild("WPSCS", new LocaleValue("未按标准配送次数", this.Context.UserLocale.LCID));
//header.AddChild("FWBZ", new LocaleValue("未按标准配送次数", this.Context.UserLocale.LCID));
//header.AddChild("FBL", new LocaleValue("比例%", this.Context.UserLocale.LCID));
ListHeader header1 = header.AddChild();
header1.Caption = new LocaleValue("配送周期", this.Context.UserLocale.LCID);
for (int i = 0; i < day.Count; i++)
{
header1.AddChild(string.Format("f{0}", i), new LocaleValue(day[i], this.Context.UserLocale.LCID), SqlStorageType.Sqlvarchar);
}
return(header);
}
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
int width = 80;
//序号列不需要自己去构建，采用系统标准的
//ListHeader headChild1 = header.AddChild("FSEQ", new LocaleValue("序号"));
//headChild1.Width = width;
//headChild1.Mergeable = false;
//headChild1.Visible = true;
ListHeader headChild2 = header.AddChild("FCUSTNUM", new LocaleValue("客户编码"));
headChild2.Width = width;
headChild2.Mergeable = false;
headChild2.Visible = true;
ListHeader headChild3 = header.AddChild("FCUSTNAME", new LocaleValue("客户名称"));
headChild3.Width = width;
headChild3.Mergeable = false;
headChild3.Visible = true;
ListHeader headChild4 = header.AddChild("FCUSTTYPE", new LocaleValue("客户类别"));
headChild4.Width = width;
headChild4.Mergeable = false;
headChild4.Visible = true;
ListHeader headChild5 = header.AddChild("FRECCONDITION", new LocaleValue("账期"));
headChild5.Width = width;
headChild5.Mergeable = false;
headChild5.Visible = true;
//循环加入日期列
ListHeader[] listHeader = new ListHeader[months];
for (int i = 0; i < months; i++)
{
DateTime yearAndMonth = beginDate.AddMonths(i);
//年-月 列
string columnName = string.Format("F{0}_{1}", yearAndMonth.Year, yearAndMonth.Month);
string title = string.Format("{0}年{1}月", yearAndMonth.Year, yearAndMonth.Month);
listHeader[i] = header.AddChild();
listHeader[i].Caption = new LocaleValue(title);
listHeader[i].Width = width * 3;
ListHeader headChild11 = listHeader[i].AddChild(string.Format("{0}_SO", columnName), new LocaleValue("接单"), SqlStorageType.SqlDecimal);
headChild11.Width = width;
headChild11.Mergeable = true;
ListHeader headChild12 = listHeader[i].AddChild(string.Format("{0}_Del", columnName), new LocaleValue("出货"), SqlStorageType.SqlDecimal);
headChild12.Width = width;
headChild12.Mergeable = true;
ListHeader headChild13 = listHeader[i].AddChild(string.Format("{0}_Rec", columnName), new LocaleValue("收汇"), SqlStorageType.SqlDecimal);
headChild13.Width = width;
headChild13.Mergeable = true;
}
ListHeader headChildEnd = header.AddChild();
headChildEnd.Caption = new LocaleValue("累计（$:万元）");
headChildEnd.Width = width * 3;
ListHeader headChildEnd11 = headChildEnd.AddChild("FTOTALSOAMT", new LocaleValue("接单"), SqlStorageType.SqlDecimal);
headChildEnd11.Width = width;
headChildEnd11.Mergeable = true;
ListHeader headChildEnd12 = headChildEnd.AddChild("FTOTALDELAMT", new LocaleValue("出货"), SqlStorageType.SqlDecimal);
headChildEnd12.Width = width;
headChildEnd12.Mergeable = true;
ListHeader headChildEnd13 = headChildEnd.AddChild("FTOTALRECAMT", new LocaleValue("收汇"), SqlStorageType.SqlDecimal);
headChildEnd13.Width = width;
headChildEnd13.Mergeable = true;
return(header);
}
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
header.Mergeable = true;
//ListHeader deptName = header.AddChild();
//deptName.Caption = new LocaleValue("销售部门");
//deptName.AddChild("deptName", new LocaleValue("销售部门"));
//deptName.Mergeable = true;
header.AddChild("deptName", new LocaleValue("销售部门"));
header.AddChild("empName", new LocaleValue("销售员"));
header.AddChild("rowTypeText", new LocaleValue("类型"));
header.AddChild("salesQuota", new LocaleValue("目标"), SqlStorageType.SqlInt);
header.AddChild("total", new LocaleValue("合计"), SqlStorageType.SqlInt);
ListHeader month_1 = header.AddChild();
month_1.Caption = new LocaleValue("1月");
month_1.AddChild("actual_1", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_1.AddChild("percent_1", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
ListHeader month_2 = header.AddChild();
month_2.Caption = new LocaleValue("2月");
month_2.AddChild("actual_2", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_2.AddChild("percent_2", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
ListHeader month_3 = header.AddChild();
month_3.Caption = new LocaleValue("3月");
month_3.AddChild("actual_3", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_3.AddChild("percent_3", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
ListHeader month_4 = header.AddChild();
month_4.Caption = new LocaleValue("4月");
month_4.AddChild("actual_4", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_4.AddChild("percent_4", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
ListHeader month_5 = header.AddChild();
month_5.Caption = new LocaleValue("5月");
month_5.AddChild("actual_5", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_5.AddChild("percent_5", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
ListHeader month_6 = header.AddChild();
month_6.Caption = new LocaleValue("6月");
month_6.AddChild("actual_6", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_6.AddChild("percent_6", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
ListHeader month_7 = header.AddChild();
month_7.Caption = new LocaleValue("7月");
month_7.AddChild("actual_7", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_7.AddChild("percent_7", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
ListHeader month_8 = header.AddChild();
month_8.Caption = new LocaleValue("8月");
month_8.AddChild("actual_8", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_8.AddChild("percent_8", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
ListHeader month_9 = header.AddChild();
month_9.Caption = new LocaleValue("9月");
month_9.AddChild("actual_9", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_9.AddChild("percent_9", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
ListHeader month_10 = header.AddChild();
month_10.Caption = new LocaleValue("10月");
month_10.AddChild("actual_10", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_10.AddChild("percent_10", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
ListHeader month_11 = header.AddChild();
month_11.Caption = new LocaleValue("11月");
month_11.AddChild("actual_11", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_11.AddChild("percent_11", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
ListHeader month_12 = header.AddChild();
month_12.Caption = new LocaleValue("12月");
month_12.AddChild("actual_12", new LocaleValue("实际"), SqlStorageType.SqlInt);
month_12.AddChild("percent_12", new LocaleValue("完成百分比"), SqlStorageType.Sqlvarchar);
return(header);
}