ExcelConfig.cs 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121
  1. using System.Collections.Generic;
  2. using System.Drawing;
  3. namespace WMS.Util
  4. {
  5. /// <summary>
  6. /// 描 述:Excel导入导出设置
  7. /// </summary>
  8. public class ExcelConfig
  9. {
  10. /// <summary>
  11. /// 文件名
  12. /// </summary>
  13. public string FileName { get; set; }
  14. /// <summary>
  15. /// 标题
  16. /// </summary>
  17. public string Title { get; set; }
  18. /// <summary>
  19. /// 前景色
  20. /// </summary>
  21. public Color ForeColor { get; set; }
  22. /// <summary>
  23. /// 背景色
  24. /// </summary>
  25. public Color Background { get; set; }
  26. private short _titlepoint;
  27. /// <summary>
  28. /// 标题字号
  29. /// </summary>
  30. public short TitlePoint
  31. {
  32. get
  33. {
  34. if (_titlepoint == 0)
  35. {
  36. return 20;
  37. }
  38. else
  39. {
  40. return _titlepoint;
  41. }
  42. }
  43. set { _titlepoint = value; }
  44. }
  45. private short _headpoint;
  46. /// <summary>
  47. /// 列头字号
  48. /// </summary>
  49. public short HeadPoint
  50. {
  51. get
  52. {
  53. if (_headpoint == 0)
  54. {
  55. return 10;
  56. }
  57. else
  58. {
  59. return _headpoint;
  60. }
  61. }
  62. set { _headpoint = value; }
  63. }
  64. /// <summary>
  65. /// 标题高度
  66. /// </summary>
  67. public short TitleHeight { get; set; }
  68. /// <summary>
  69. /// 列标题高度
  70. /// </summary>
  71. public short HeadHeight { get; set; }
  72. private string _titlefont;
  73. /// <summary>
  74. /// 标题字体
  75. /// </summary>
  76. public string TitleFont
  77. {
  78. get
  79. {
  80. if (_titlefont == null)
  81. {
  82. return "微软雅黑";
  83. }
  84. else
  85. {
  86. return _titlefont;
  87. }
  88. }
  89. set { _titlefont = value; }
  90. }
  91. private string _headfont;
  92. /// <summary>
  93. /// 列头字体
  94. /// </summary>
  95. public string HeadFont
  96. {
  97. get
  98. {
  99. if (_headfont == null)
  100. {
  101. return "微软雅黑";
  102. }
  103. else
  104. {
  105. return _headfont;
  106. }
  107. }
  108. set { _headfont = value; }
  109. }
  110. /// <summary>
  111. /// 是否按内容长度来适应表格宽度
  112. /// </summary>
  113. public bool IsAllSizeColumn { get; set; }
  114. /// <summary>
  115. /// 列设置
  116. /// </summary>
  117. public List<ColumnModel> ColumnEntity { get; set; }
  118. }
  119. }