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); }