//构建报表列
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
//部门
var department = header.AddChild("DEPTNAME", new Kingdee.BOS.LocaleValue("部门"));
department.ColIndex = 0;
department.Width = 200;
//业务员
var salesman = header.AddChild("SALERNAME", new Kingdee.BOS.LocaleValue("业务员"));
salesman.ColIndex = 1;
//线索数量
var clueNumber = header.AddChild("CLUENUMBER", new Kingdee.BOS.LocaleValue("线索数量"));
clueNumber.ColIndex = 2;
//转化商机数量
var oppNumber = header.AddChild("OPPNUMBER", new Kingdee.BOS.LocaleValue("转化商机数量"));
oppNumber.ColIndex = 3;
//转化率
var conversionRate = header.AddChild("RATE1", new Kingdee.BOS.LocaleValue("转化率"));
conversionRate.ColIndex = 4;
return(header);
}
//设置报表列名
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
int width = 100;
ListHeader headChild = header.AddChild("费用项目", new LocaleValue("费用项目"));
headChild.Width = width;
headChild.Mergeable = false;
headChild.Visible = true;
//循环添加部门
ListHeader[] listHeader = new ListHeader[depCol.Count];
for (int i = 0; i < depCol.Count; i++)
{
//部门
string depName = Convert.ToString(depCol[i]["FDepName"]);
listHeader[i] = header.AddChild(depName, new LocaleValue(depName), SqlStorageType.SqlDecimal);
listHeader[i].Width = width;
listHeader[i].Mergeable = false;
listHeader[i].Visible = true;
}
ListHeader headChildEnd = header.AddChild("合计", new LocaleValue("合计"), SqlStorageType.SqlDecimal);
headChildEnd.Width = width;
headChildEnd.Mergeable = false;
headChildEnd.Visible = true;
return(header);
}
//构建报表列
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
//部门
var department = header.AddChild("department", new Kingdee.BOS.LocaleValue("部门"));
department.ColIndex = 0;
//业务员
var salesman = header.AddChild("saler", new Kingdee.BOS.LocaleValue("业务员"));
salesman.ColIndex = 1;
//线索数量
var clueNumber = header.AddChild("cluenumber", new Kingdee.BOS.LocaleValue("线索数量"));
clueNumber.ColIndex = 2;
//转化商机数量
var oppNumber = header.AddChild("oppnumber", new Kingdee.BOS.LocaleValue("转化商机数量"));
oppNumber.ColIndex = 3;
//转化率
var conversionRate = header.AddChild("rate", new Kingdee.BOS.LocaleValue("转化率"));
conversionRate.ColIndex = 4;
return(header);
}
//构建报表列
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
//销售部门
var department = header.AddChild("DEPTNAME", new Kingdee.BOS.LocaleValue("销售部门"));
department.ColIndex = 0;
//销售员
var salesman = header.AddChild("SALERNAME", new Kingdee.BOS.LocaleValue("销售员"));
salesman.ColIndex = 1;
//指标
var quota = header.AddChild("TOTALQUOTA", new Kingdee.BOS.LocaleValue("指标"));
quota.ColIndex = 2;
//完成金额
var amount = header.AddChild("TOTALAMOUNT", new Kingdee.BOS.LocaleValue("完成金额"));
amount.ColIndex = 3;
//完成占比
var rate = header.AddChild("COMPLETERATE", new Kingdee.BOS.LocaleValue("完成占比"));
rate.ColIndex = 4;
return(header);
}
//构建报表列
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
//设置列的key值，字段名，标题，数据类型
var FMATERIALNUMBER = header.AddChild();
FMATERIALNUMBER.Key = "FMATERIALNUMBER";
FMATERIALNUMBER.FieldName = "FMATERIALNUMBER";
FMATERIALNUMBER.Caption = new LocaleValue("物料号", this.Context.UserLocale.LCID);
FMATERIALNUMBER.ColType = SqlStorageType.Sqlnvarchar;
var FLOTNUMBER = header.AddChild();
FLOTNUMBER.Key = "FLOTNUMBER";
FLOTNUMBER.FieldName = "FLOTNUMBER";
FLOTNUMBER.Caption = new LocaleValue("批号", this.Context.UserLocale.LCID);
FLOTNUMBER.ColType = SqlStorageType.Sqlnvarchar;
var FBASEQTY = header.AddChild();
FBASEQTY.Key = "FBASEQTY";
FBASEQTY.FieldName = "FBASEQTY";
FBASEQTY.Caption = new LocaleValue("库存量", this.Context.UserLocale.LCID);
FBASEQTY.ColType = SqlStorageType.SqlDecimal;
var FDAYS = header.AddChild();
FDAYS.Key = "FDAYS";
FDAYS.FieldName = "FDAYS";
FDAYS.Caption = new LocaleValue("天数", this.Context.UserLocale.LCID);
FDAYS.ColType = SqlStorageType.SqlInt;
return(header);
}
//public override void Initialize()
//{
// base.Initialize();
// DecimalControlField field = new DecimalControlField
// {
// ByDecimalControlFieldName = "FJNUnitEnzyme",
// DecimalControlFieldName = "FSECPRECISION"
// };
// base.ReportProperty.DecimalControlFieldList.Add(field);
// DecimalControlField field2 = new DecimalControlField
// {
// ByDecimalControlFieldName = "FJNTonProperty",
// DecimalControlFieldName = "FSECPRECISION"
// };
// base.ReportProperty.DecimalControlFieldList.Add(field2);
//}
public override Kingdee.BOS.Core.Report.ReportHeader GetReportHeaders(Kingdee.BOS.Core.Report.IRptParams filter)
{
ReportHeader reportHeader = base.GetReportHeaders(filter);
reportHeader.AddChild("FJNUnitEnzyme", new LocaleValue("单位酶活量", base.Context.UserLocale.LCID));
reportHeader.AddChild("FJNTonProperty", new LocaleValue("标吨", base.Context.UserLocale.LCID));
return(reportHeader);
}
private static ReportHeader GetHeaderByProvince()
{
ReportHeader header = new ReportHeader();
header.AddChild("provinceName", new LocaleValue("省份"));
header.AddChild("oppCount", new LocaleValue("数量"), SqlStorageType.SqlInt);
return(header);
}
/// <summary>
/// 设置表头
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader reportHeader = base.GetReportHeaders(filter);
reportHeader.AddChild("F_JN_YDL_AllocUseDeptID_EXT", new LocaleValue("使用部门", base.Context.UserLocale.LCID));
reportHeader.AddChild("F_JN_YDL_AllocUseDeptNumber_EXT", new LocaleValue("使用部门编码", base.Context.UserLocale.LCID));
return(reportHeader);
}
private static ReportHeader GetHeaderByRegion()
{
ReportHeader header = new ReportHeader();
header.AddChild("regionName", new LocaleValue("区域"));
header.AddChild("oppCount", new LocaleValue("数量"), SqlStorageType.SqlInt);
return(header);
}
private static ReportHeader GetHeaderByIndustry()
{
ReportHeader header = new ReportHeader();
header.AddChild("industryName", new LocaleValue("产业"));
header.AddChild("oppCount", new LocaleValue("数量"), SqlStorageType.SqlInt);
return(header);
}
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="filter"></param>
/// <returns></returns>
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
var material = header.AddChild("FMATERIALID", new LocaleValue("物料"));
material.ColIndex = 0;
var qty = header.AddChild("FQTY", new LocaleValue("数量"), SqlStorageType.SqlDecimal);
qty.ColIndex = 1;
var unit = header.AddChild("FUNITNAME", new LocaleValue("单位"));
unit.ColIndex = 2;
var taxprice = header.AddChild("FTAXPRICE", new LocaleValue("含税价"), SqlStorageType.SqlDecimal);
taxprice.ColIndex = 3;
var amount = header.AddChild("FALLAMOUNT", new LocaleValue("价税合计"), SqlStorageType.SqlDecimal);
amount.ColIndex = 4;
var taxRate = header.AddChild("FTAXRATE", new LocaleValue("税率"), SqlStorageType.SqlDecimal);
taxRate.ColIndex = 5;
var billNo = header.AddChild("FBillNo", new LocaleValue("单据编号"));
billNo.ColIndex = 6;
var date = header.AddChild("FDATE", new LocaleValue("日期"));
date.ColIndex = 7;
var price = header.AddChild("FPRICE", new LocaleValue("未税单价"));
price.ColIndex = 8;
return(header);
}
/// <summary>
/// 设置报表列
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
var billNo = header.AddChild("FBillNo", new LocaleValue("单据编号"));
billNo.ColIndex = 0;
var date = header.AddChild("FDATE", new LocaleValue("日期"));
date.ColIndex = 1;
return(header);
}
public override ReportHeader GetReportHeaders(IRptParams filter)
{
// TODO:
ReportHeader header = new ReportHeader();
header.AddChild("FFORMID", new LocaleValue(Kingdee.BOS.Resource.ResManager.LoadKDString("表单ID", "002460030014674", Kingdee.BOS.Resource.SubSystemType.BOS), this.Context.UserLocale.LCID));
header.AddChild("FSCHEMENAME", new LocaleValue(Kingdee.BOS.Resource.ResManager.LoadKDString("过滤方案名称", "002460030014677", Kingdee.BOS.Resource.SubSystemType.BOS), this.Context.UserLocale.LCID));
header.AddChild("FISDEFAULT", new LocaleValue(Kingdee.BOS.Resource.ResManager.LoadKDString("是否缺省", "002460030014680", Kingdee.BOS.Resource.SubSystemType.BOS), this.Context.UserLocale.LCID));
header.AddChild("FSEQ", new LocaleValue(Kingdee.BOS.Resource.ResManager.LoadKDString("序号", "002460030014683", Kingdee.BOS.Resource.SubSystemType.BOS), this.Context.UserLocale.LCID), SqlStorageType.SqlInt);
return(header);
}
public override Kingdee.BOS.Core.Report.ReportHeader GetReportHeaders(Kingdee.BOS.Core.Report.IRptParams filter)
{
ReportHeader header = base.GetReportHeaders(filter);
header.AddChild("FAuditDate", new LocaleValue("审核日期"), SqlStorageType.SqlSmalldatetime, true);
return(header);
}
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
header.IsHyperlink = true;
header.AddChild("FAHUOSTOCK", new LocaleValue("发货仓库", this.Context.UserLocale.LCID));
header.AddChild("RUKUSTOCK", new LocaleValue("入库仓库", this.Context.UserLocale.LCID));
header.AddChild("MATERIAL", new LocaleValue("产品编码", this.Context.UserLocale.LCID));
header.AddChild("OLDNUMBER", new LocaleValue("旧编码", this.Context.UserLocale.LCID));
header.AddChild("NAME", new LocaleValue("产品名称", this.Context.UserLocale.LCID));
header.AddChild("FHYMING", new LocaleValue("韩语名", this.Context.UserLocale.LCID));
header.AddChild("PRICE", new LocaleValue("单价", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
header.AddChild("BILLNO", new LocaleValue("单据编号", this.Context.UserLocale.LCID));
header.AddChild("FDATE", new LocaleValue("日期", this.Context.UserLocale.LCID));
header.AddChild("ONTHEWAYNO", new LocaleValue("在途数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
return(header);
}
/// <summary>
/// 构建出报表列
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
/// <remarks>
/// // 如下代码，演示如何设置同一分组的分组头字段合并
/// // 需配合Initialize事件，设置分组依据字段(PrimaryKeyFieldName)
/// ReportHeader header = new ReportHeader();
/// header.Mergeable = true;
/// int width = 80;
/// ListHeader headChild1 = header.AddChild("FBILLNO", new LocaleValue("应付单号"));
/// headChild1.Width = width;
/// headChild1.Mergeable = true;
///
/// ListHeader headChild2 = header.AddChild("FPURMAN", new LocaleValue("采购员"));
/// headChild2.Width = width;
/// headChild2.Mergeable = true;
/// </remarks>
//事件 6:设置账表列头字段信息
public override ReportHeader GetReportHeaders(IRptParams filter)
{
//FID,FEntryId,编号,状态,物料,数量,单位,单位精度,单价,价税合计
ReportHeader header = new ReportHeader();
var status = header.AddChild("FDocumentStatus", new LocaleValue("状态"));
status.ColIndex = 0;
var billNo = header.AddChild("FBillNo", new LocaleValue("单据编号"));
billNo.ColIndex = 1;
billNo.IsHyperlink = true;//支持超链接
var material = header.AddChild("FMaterialName", new LocaleValue("物料"));
material.ColIndex = 2;
var qty = header.AddChild("FQty", new LocaleValue("数量"), SqlStorageType.SqlDecimal); //SqlStorageType.SqlDecimal 是精度控制 在初始化中已经进行了定义
qty.ColIndex = 3;
var unit = header.AddChild("FUnitName", new LocaleValue("单位"));
unit.ColIndex = 4;
var price = header.AddChild("FTAXPRICE", new LocaleValue("含税价"), SqlStorageType.SqlDecimal);
price.ColIndex = 5;
var amount = header.AddChild("FALLAMOUNT", new LocaleValue("价税合计"), SqlStorageType.SqlDecimal);
amount.ColIndex = 6;
return(header);
}
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
header.IsHyperlink = true;
header.AddChild("MATERIAL", new LocaleValue("产品编码", this.Context.UserLocale.LCID));
header.AddChild("OLDNUMBER", new LocaleValue("旧编码", this.Context.UserLocale.LCID));
header.AddChild("NAME", new LocaleValue("产品名称", this.Context.UserLocale.LCID));
header.AddChild("FHYMING", new LocaleValue("韩语名", this.Context.UserLocale.LCID));
header.AddChild("PRICE", new LocaleValue("单价", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
header.AddChild("FQTY", new LocaleValue("入库数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
header.AddChild("KUCUNQTY", new LocaleValue("库存数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
header.AddChild("BILLTYPE", new LocaleValue("单据类型", this.Context.UserLocale.LCID));
header.AddChild("BILLNO", new LocaleValue("单据编号", this.Context.UserLocale.LCID));
header.AddChild("FDATE", new LocaleValue("日期", this.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);
}
/// <summary>
/// 设置报表列
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public override ReportHeader GetReportHeaders(IRptParams filter)
{
// FID, FEntryId, 编号、状态、物料、数量、单位、单位精度、单价、价税合计
ReportHeader header = new ReportHeader();
// 编号
var dateHeader = header.AddChild("FDate", new LocaleValue("日期"));
dateHeader.ColIndex = 0;
var status = header.AddChild("FDocumentStatus", new LocaleValue("状态"));
status.ColIndex = 1;
var billNo = header.AddChild("FBillNo", new LocaleValue("单据编号"));
billNo.ColIndex = 2;
billNo.IsHyperlink = true; // 支持超链接
var material = header.AddChild("FMaterialName", new LocaleValue("物料"));
material.ColIndex = 3;
var qty = header.AddChild("FQty", new LocaleValue("数量"), SqlStorageType.SqlDecimal);
qty.ColIndex = 4;
var unit = header.AddChild("FUnitName", new LocaleValue("单位"));
unit.ColIndex = 5;
var price = header.AddChild("FTAXPRICE", new LocaleValue("含税价"), SqlStorageType.SqlDecimal);
price.ColIndex = 6;
var amount = header.AddChild("FALLAMOUNT", new LocaleValue("价税合计"), SqlStorageType.SqlDecimal);
amount.ColIndex = 7;
//add 2 columns
var taxRate = header.AddChild("FTAXRATE", new LocaleValue("税率"), SqlStorageType.SqlDecimal);
taxRate.ColIndex = 8;
var discount = header.AddChild("FDISCOUNTRATE", new LocaleValue("折扣率"), SqlStorageType.SqlDecimal);
discount.ColIndex = 9;
return(header);
}
public override ReportHeader GetReportHeaders(IRptParams filter)
{
// FID, FEntryId, 编号、状态、物料、数量、单位、单位精度、单价、价税合计
ReportHeader header = base.GetReportHeaders(filter);
// 编号
var dateHeader = header.AddChild("FDate", new LocaleValue("日期"));
dateHeader.ColIndex = 0;
var status = header.AddChild("FDocumentStatus", new LocaleValue("状态"));
status.ColIndex = 7;
var billNo = header.AddChild("FBillNo", new LocaleValue("单据编号"));
billNo.ColIndex = 1;
billNo.IsHyperlink = true; // 支持超链接
var material = header.AddChild("FMaterialName", new LocaleValue("物料"));
material.ColIndex = 2;
var qty = header.AddChild("FQty", new LocaleValue("数量"), SqlStorageType.SqlDecimal);
return(header);
}
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);
}
//sp.fseq, SP.FMATERIALID,kk.fqty,kk.fjitqty
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
header.AddChild("FSEQ", new LocaleValue("序号", this.Context.UserLocale.LCID));
header.AddChild("Fmaterialid", new LocaleValue("物料代码", this.Context.UserLocale.LCID));
header.AddChild("Fshortname", new LocaleValue("物料名称", this.Context.UserLocale.LCID));
header.AddChild("FPACKQTY", new LocaleValue("包装数量", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
header.AddChild("FPACKERQTY", new LocaleValue("装箱数", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
header.AddChild("FQTY", new LocaleValue("报货数", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
header.AddChild("FJITQTY", new LocaleValue("昨日剩货数", this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
return(header);
}
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
header.Mergeable = true;
header.AddChild("customerNo", new LocaleValue("客户代码"));
header.AddChild("customerName", new LocaleValue("客户名称"));
header.AddChild("oppTotalCount", new LocaleValue("总商机数量"), SqlStorageType.SqlInt);
header.AddChild("oppWinBillCount", new LocaleValue("赢单数量"), SqlStorageType.SqlInt);
header.AddChild("oppLostBillCount", new LocaleValue("输单数量"), SqlStorageType.SqlInt);
header.AddChild("oppUnfinishedCount", new LocaleValue("未完成数量"), SqlStorageType.SqlInt);
header.AddChild("oppWinBillIncome", new LocaleValue("赢单金额"), SqlStorageType.SqlDecimal);
header.AddChild("oppTotalIncome", new LocaleValue("预计收入"), SqlStorageType.SqlDecimal);
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)
{
ReportHeader header = new ReportHeader();
//商机编号
header.AddChild("oppbillno", new Kingdee.BOS.LocaleValue("商机编号")).ColIndex = 0;
//商机名称
header.AddChild("oppbillname", new Kingdee.BOS.LocaleValue("商机名称")).ColIndex = 1;
//客户编号
header.AddChild("customerid", new Kingdee.BOS.LocaleValue("客户编号")).ColIndex = 2;
//客户名称
header.AddChild("customername", new Kingdee.BOS.LocaleValue("客户名称")).ColIndex = 3;
//商机创建日期
var createDate = header.AddChild("createdate", new Kingdee.BOS.LocaleValue("商机创建日期"));
createDate.ColIndex = 4;
createDate.Width = 200;
//商机负责人
header.AddChild("saler", new Kingdee.BOS.LocaleValue("商机负责人")).ColIndex = 5;
// 负责人所属部门
header.AddChild("DEPTNAME", new Kingdee.BOS.LocaleValue("负责人所属部门")).ColIndex = 6;
//修改时间
var modifyDate = header.AddChild("modifydate", new Kingdee.BOS.LocaleValue("修改时间"));
modifyDate.ColIndex = 7;
modifyDate.Width = 200;
//修改人
header.AddChild("modifiername", new Kingdee.BOS.LocaleValue("修改人")).ColIndex = 8;
return(header);
}
//构建报表列
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = new ReportHeader();
//销售部门
var department = header.AddChild("DEPTNAME", new Kingdee.BOS.LocaleValue("销售部门"));
department.ColIndex = 0;
//销售员
var salesman = header.AddChild("SALERNAME", new Kingdee.BOS.LocaleValue("销售员"));
salesman.ColIndex = 1;
//合同编号
var billNo = header.AddChild("FBILLNO", new Kingdee.BOS.LocaleValue("合同编号"));
billNo.ColIndex = 2;
//合同金额
var totalAmount = header.AddChild("SUMAMOUNT", new Kingdee.BOS.LocaleValue("合同金额"));
totalAmount.ColIndex = 3;
//项目号
var proNo = header.AddChild("F_PEJK_PRONO", new Kingdee.BOS.LocaleValue("项目号"));
proNo.ColIndex = 4;
//分配金额
var amount = header.AddChild("FPAMOUNT", new Kingdee.BOS.LocaleValue("分配金额"));
amount.ColIndex = 5;
//分配比例
var rate = header.AddChild("RATIO", new Kingdee.BOS.LocaleValue("分配比例"));
rate.ColIndex = 6;
return(header);
}
/// <summary>
/// 动态添加列
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public override Kingdee.BOS.Core.Report.ReportHeader GetReportHeaders(IRptParams filter)
{
//FMATERIALID ,sum(FREALQTY) as FREALQTY,FSTOCKID,FUNITID
ReportHeader header = new ReportHeader();
//物料编码
header.AddChild("FNUMBER", new LocaleValue("物料编码"), SqlStorageType.Sqlnvarchar);
var itemName = header.AddChild("fFNAME", new LocaleValue("单位名称"), SqlStorageType.Sqlvarchar);
itemName.Width = 100;
header.AddChild("eFNAME", new LocaleValue("仓库名称"), SqlStorageType.Sqlvarchar);
header.AddChild("FREALQTY", new LocaleValue("总数"), SqlStorageType.SqlDecimal);
header.AddChild("ApprovedQty", new LocaleValue("已审核数量"), SqlStorageType.SqlDecimal);
header.AddChild("NotApprovedQty", new LocaleValue("未审核数量"), SqlStorageType.SqlDecimal);
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();
DynamicObject cutomerfiler = filter.FilterParameter.CustomFilter;
String year = null;//年份
if (cutomerfiler["F_SXINSUN_YEAR"] != null)
{
year = Convert.ToInt32(cutomerfiler["F_SXINSUN_YEAR"]).ToString();
}
if (cutomerfiler["F_PAEZ_DEPT"] != null)
{
DynamicObjectCollection cols = (DynamicObjectCollection)cutomerfiler["F_PAEZ_DEPT"];
foreach (DynamicObject dept in cols)
{
String deptnumber = Convert.ToString(((DynamicObject)dept["F_PAEZ_DEPT"])["Number"]);
}
}
if (cutomerfiler["F_PAEZ_MulBaseSaler"] != null)
{
DynamicObjectCollection cols = (DynamicObjectCollection)cutomerfiler["F_PAEZ_MulBaseSaler"];
foreach (DynamicObject onesale in cols)
{
String salenumber = Convert.ToString(((DynamicObject)onesale["F_PAEZ_MulBaseSaler"])["Number"]);
}
}
if (Convert.ToBoolean(cutomerfiler["F_PAEZ_ShowDetail"]) == false)
{
// 编号
var deptname = header.AddChild("deptnumber", new LocaleValue("部门编码"));
var deptnumber = header.AddChild("deptname", new LocaleValue("部门"));
//var empnumber = header.AddChild("empnumber", new LocaleValue("员工编码"));
// var empname = header.AddChild("empname", new LocaleValue("员工"));
var yue1 = header.AddChild("yue1", new LocaleValue("1月份"));
//billNo.IsHyperlink = true; // 支持超链接
var yue2 = header.AddChild("yue2", new LocaleValue("2月份"));
var yue3 = header.AddChild("yue3", new LocaleValue("3月份"));
var yue4 = header.AddChild("yue4", new LocaleValue("4月份"));
var yue5 = header.AddChild("yue5", new LocaleValue("5月份"));
var yue6 = header.AddChild("yue6", new LocaleValue("6月份"));
var yue7 = header.AddChild("yue7", new LocaleValue("7月份"));
var yue8 = header.AddChild("yue8", new LocaleValue("8月份"));
var yue9 = header.AddChild("yue9", new LocaleValue("9月份"));
var yue10 = header.AddChild("yue10", new LocaleValue("10月份"));
var yue11 = header.AddChild("yue11", new LocaleValue("11月份"));
var yue12 = header.AddChild("yue12", new LocaleValue("12月份"));
var zoji = header.AddChild("zoji", new LocaleValue("总计"));
}
//var zoji = header.AddChild("gzzj", new LocaleValue("总计"));
// sum(dlzb) dlzb,sum(dlwqqk) dlwqqk,sum(gzzj) gzzj,sum(gzzb) gzzb,sum(gzzbwqqk) gzzbwqqk,sum(gzhud) gzhud
else
{
var deptname = header.AddChild("deptnumber", new LocaleValue("部门编码"));
var deptnumber = header.AddChild("deptname", new LocaleValue("部门"));
var empnumber = header.AddChild("empnumber", new LocaleValue("员工编码"));
var empname = header.AddChild("empname", new LocaleValue("员工"));
var yue1 = header.AddChild("yue1", new LocaleValue("1月份"));
//billNo.IsHyperlink = true; // 支持超链接
var yue2 = header.AddChild("yue2", new LocaleValue("2月份"));
var yue3 = header.AddChild("yue3", new LocaleValue("3月份"));
var yue4 = header.AddChild("yue4", new LocaleValue("4月份"));
var yue5 = header.AddChild("yue5", new LocaleValue("5月份"));
var yue6 = header.AddChild("yue6", new LocaleValue("6月份"));
var yue7 = header.AddChild("yue7", new LocaleValue("7月份"));
var yue8 = header.AddChild("yue8", new LocaleValue("8月份"));
var yue9 = header.AddChild("yue9", new LocaleValue("9月份"));
var yue10 = header.AddChild("yue10", new LocaleValue("10月份"));
var yue11 = header.AddChild("yue11", new LocaleValue("11月份"));
var yue12 = header.AddChild("yue12", new LocaleValue("12月份"));
var zoji = header.AddChild("zoji", new LocaleValue("总计"));
var dlzb = header.AddChild("dlzb", new LocaleValue("登录指标"));
var dlwqqk = header.AddChild("dlwqqk", new LocaleValue("完成情况"));
var gzzj = header.AddChild("gzzj", new LocaleValue("总计跟踪"));
var gzzb = header.AddChild("gzzb", new LocaleValue("跟踪指标"));
var gzzbwqqk = header.AddChild("gzzbwqqk", new LocaleValue("完成情况"));
var gzhud = header.AddChild("gzhud", new LocaleValue("跟踪更新"));
}
return(header);
}
