CommandParameter.cs 5.8 KB

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