CommandParameter.cs 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166
  1. using System;
  2. using System.ComponentModel;
  3. using FastReport.Utils;
  4. using System.Drawing.Design;
  5. namespace FastReport.Data
  6. {
  7. /// <summary>
  8. /// This class represents a single parameter to use in the "select" command.
  9. /// </summary>
  10. public class CommandParameter : Base
  11. {
  12. private enum ParamValue { Uninitialized }
  13. #region Fields
  14. private int dataType;
  15. private int size;
  16. private string expression;
  17. private string defaultValue;
  18. private object value;
  19. private object lastValue;
  20. #endregion
  21. #region Properties
  22. /// <summary>
  23. /// Gets or sets the parameter's data type.
  24. /// </summary>
  25. [TypeConverter(typeof(FastReport.TypeConverters.ParameterDataTypeConverter))]
  26. [Category("Data")]
  27. [Editor("FastReport.TypeEditors.ParameterDataTypeEditor, FastReport", typeof(UITypeEditor))]
  28. public int DataType
  29. {
  30. get { return dataType; }
  31. set { dataType = value; }
  32. }
  33. /// <summary>
  34. /// Gets or sets the size of parameter's data.
  35. /// </summary>
  36. /// <remarks>
  37. /// This property is used if the <see cref="DataType"/> property is set to <b>String</b>.
  38. /// </remarks>
  39. [DefaultValue(0)]
  40. [Category("Data")]
  41. public int Size
  42. {
  43. get { return size; }
  44. set { size = value; }
  45. }
  46. /// <summary>
  47. /// Gets or sets an expression that returns the parameter's value.
  48. /// </summary>
  49. /// <remarks>
  50. /// If this property is not set, the <see cref="DefaultValue"/> property will be used
  51. /// to obtain a parameter's value.
  52. /// </remarks>
  53. [Category("Data")]
  54. [Editor("FastReport.TypeEditors.ExpressionEditor, FastReport", typeof(UITypeEditor))]
  55. public string Expression
  56. {
  57. get { return expression; }
  58. set { expression = value; }
  59. }
  60. /// <summary>
  61. /// Gets or sets a default value for this parameter.
  62. /// </summary>
  63. /// <remarks>
  64. /// This value is used when you designing a report. Also it is used when report is running
  65. /// in case if you don't provide a value for the <see cref="Expression"/> property.
  66. /// </remarks>
  67. public string DefaultValue
  68. {
  69. get { return defaultValue; }
  70. set
  71. {
  72. defaultValue = value;
  73. this.value = null;
  74. }
  75. }
  76. /// <summary>
  77. /// Gets or sets the parameter's value.
  78. /// </summary>
  79. [Browsable(false)]
  80. public object Value
  81. {
  82. get
  83. {
  84. if (!String.IsNullOrEmpty(Expression) && Report.IsRunning)
  85. value = Report.Calc(Expression);
  86. if (value == null)
  87. value = new Variant(DefaultValue);
  88. return value;
  89. }
  90. set { this.value = value; }
  91. }
  92. /// <summary>
  93. /// This property is not relevant to this class.
  94. /// </summary>
  95. [Browsable(false)]
  96. public new Restrictions Restrictions
  97. {
  98. get { return base.Restrictions; }
  99. set { base.Restrictions = value; }
  100. }
  101. internal Type GetUnderlyingDataType
  102. {
  103. get
  104. {
  105. if (Parent is TableDataSource && Parent.Parent is DataConnectionBase)
  106. return (Parent.Parent as DataConnectionBase).GetParameterType();
  107. return null;
  108. }
  109. }
  110. internal object LastValue
  111. {
  112. get { return lastValue; }
  113. set { lastValue = value; }
  114. }
  115. #endregion
  116. #region Public Methods
  117. /// <inheritdoc/>
  118. public override void Serialize(FRWriter writer)
  119. {
  120. CommandParameter c = writer.DiffObject as CommandParameter;
  121. base.Serialize(writer);
  122. if (DataType != c.DataType)
  123. writer.WriteInt("DataType", DataType);
  124. if (Size != c.Size)
  125. writer.WriteInt("Size", Size);
  126. if (Expression != c.Expression)
  127. writer.WriteStr("Expression", Expression);
  128. if (DefaultValue != c.DefaultValue)
  129. writer.WriteStr("DefaultValue", DefaultValue);
  130. }
  131. /// <inheritdoc/>
  132. public override string[] GetExpressions()
  133. {
  134. return new string[] { Expression };
  135. }
  136. internal void ResetLastValue()
  137. {
  138. LastValue = ParamValue.Uninitialized;
  139. }
  140. #endregion
  141. /// <summary>
  142. /// Initializes a new instance of the <see cref="CommandParameter"/> class with default settings.
  143. /// </summary>
  144. public CommandParameter()
  145. {
  146. Expression = "";
  147. DefaultValue = "";
  148. SetFlags(Flags.CanEdit | Flags.CanCopy, false);
  149. }
  150. }
  151. }