简单帐表插件开发示例分享

1. public class DemoSysReport : SysReportBaseService
   

2. {
   

3. public override void Initialize()
   

4. {
   

5. // 支持分组汇总
   

6. this.ReportProperty.IsGroupSummary = true;
   

7. //this.ReportProperty.BillKeyFieldName = "FID";
   

8. this.ReportProperty.ReportName = new LocaleValue(Kingdee.BOS.Resource.ResManager.LoadKDString("销售分组汇总报表","002460030014686",Kingdee.BOS.Resource.SubSystemType.BOS), this.Context.UserLocale.LCID);
   

9. //this.ReportProperty.GroupSummaryInfoData.DefaultGroupbyString = "fwname";
   

10. this.ReportProperty.DecimalControlFieldList = new List<DecimalControlField>();
    

11. // 标示famount用famount_decimal做精度格式化
    

12. this.ReportProperty.DecimalControlFieldList.Add(new DecimalControlField() { ByDecimalControlFieldName = "famount", DecimalControlFieldName = "famount_decimal" });
    

13. }
    

14. 
    

15. public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
    

16. {
    

17. // 拼接sql
    

18. string sSQL = @"select b.fname as fwname,c.fcustid,d.fname as fcname,a.* ,f.famount,3 as famount_decimal,f.fprice, {0} into {1} from T_SAL_ORDERENTRY a 
    

19. left join T_BD_MATERIAL_L b on a.fmaterialid=b.fmaterialid and b.FLOCALEID=2052
    

20. left join T_SAL_ORDER c on a.fid=c.fid
    

21. left join T_BD_CUSTOMER_L d on c.fcustid=d.fcustid and d.FLOCALEID=2052 
    

22. left join T_SAL_ORDERENTRY_F f on a.fentryid=f.fentryid";
    

23. // 设置分页排序
    

24. KSQL_SEQ = string.Format(KSQL_SEQ, "a.FID asc");
    

25. sSQL = string.Format(sSQL, this.KSQL_SEQ, tableName);
    

26. 
    

27. DBUtils.Execute(this.Context, sSQL);
    

28. }
    

29. 
    

30. public override ReportTitles GetReportTitles(IRptParams filter)
    

31. {
    

32. ReportTitles titles = new ReportTitles();
    

33. // TODO：从filter中获取具体的固定过滤条件，设置到tilte中，用于报表条件展示
    

34. //titles.AddTitle("FText", "55555");
    

35. //titles.AddTitle("FLabel", "66666");
    

36. return titles;
    

37. }
    

38. /// <summary>
    

39. /// 设置汇总列信息
    

40. /// </summary>
    

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

42. /// <returns></returns>
    

43. public override List<Core.Report.SummaryField> GetSummaryColumnInfo(IRptParams filter)
    

44. {
    

45. List<Core.Report.SummaryField> summarys = new List<Core.Report.SummaryField>();
    

46. summarys.Add(new Core.Report.SummaryField("FQty", Core.Enums.BOSEnums.Enu_SummaryType.SUM));
    

47. // 单价求平均
    

48. summarys.Add(new Core.Report.SummaryField("fprice", Core.Enums.BOSEnums.Enu_SummaryType.AVERAGE));
    

49. // 金额汇总
    

50. summarys.Add(new Core.Report.SummaryField("famount", Core.Enums.BOSEnums.Enu_SummaryType.SUM));
    

51. return summarys;
    

52. }
    

53. /// <summary>
    

54. /// 构建动态列
    

55. /// </summary>
    

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

57. /// <returns></returns>
    

58. public override ReportHeader GetReportHeaders(IRptParams filter)
    

59. {
    

60. // TODO:fentryid,fid,fbaseunitqty,fmaterialid,fbomid,fqty
    

61. ReportHeader header = new ReportHeader();
    

62. header.AddChild("fwname", new LocaleValue(Kingdee.BOS.Resource.ResManager.LoadKDString("物料","002460030014689",Kingdee.BOS.Resource.SubSystemType.BOS), this.Context.UserLocale.LCID));
    

63. header.AddChild("fcustid", new LocaleValue(Kingdee.BOS.Resource.ResManager.LoadKDString("客户","002460030014692",Kingdee.BOS.Resource.SubSystemType.BOS), this.Context.UserLocale.LCID));
    

64. header.AddChild("FQty", new LocaleValue(Kingdee.BOS.Resource.ResManager.LoadKDString("数量","002460030014695",Kingdee.BOS.Resource.SubSystemType.BOS), this.Context.UserLocale.LCID),SqlStorageType.SqlDecimal);
    

65. header.AddChild("fprice", new LocaleValue(Kingdee.BOS.Resource.ResManager.LoadKDString("单价","002460030014698",Kingdee.BOS.Resource.SubSystemType.BOS), this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
    

66. header.AddChild("famount", new LocaleValue(Kingdee.BOS.Resource.ResManager.LoadKDString("金额","002460030014701",Kingdee.BOS.Resource.SubSystemType.BOS), this.Context.UserLocale.LCID), SqlStorageType.SqlDecimal);
    

67. return header;
    

68. }
    

69. }

复制代码

注释：loadkdstring是k/3cloud的多语言函数，会根据后面的编号从资源文件中获取到相应的翻译语言。一般项目中，没有多语言的，可以参考如下代码： new LocaleValue("销售分组汇总报表", this.Context.UserLocale.LCID);