TableColumn.cs 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Data;
  6. namespace Ant.ORM
  7. {
  8. public class TableColumn
  9. {
  10. public TableColumn()
  11. {
  12. }
  13. private Dictionary<string, DataFieldMetaData> _fieldMeteDatas = new Dictionary<string, DataFieldMetaData>();//主表列集合
  14. /// <summary>
  15. /// 列集合
  16. /// </summary>
  17. private Dictionary<string, DataFieldMetaData> FieldMeteDatas
  18. {
  19. get { return _fieldMeteDatas; }
  20. set { _fieldMeteDatas = value; }
  21. }
  22. public DataFieldMetaData ColumnMetaData
  23. {
  24. get;
  25. set;
  26. }
  27. /// <summary>
  28. /// 列名
  29. /// </summary>
  30. public string ColumnName
  31. {
  32. get
  33. {
  34. return ColumnMetaData.ColumnName;
  35. }
  36. }
  37. /// <summary>
  38. /// 重写列名
  39. /// </summary>
  40. public string OverColumnName { get; set; }
  41. /// <summary>
  42. /// 列的类型
  43. /// </summary>
  44. public DbType ColumnType
  45. {
  46. get
  47. {
  48. return ColumnMetaData.ColumnType;
  49. }
  50. }
  51. /// <summary>
  52. /// 操作符
  53. /// </summary>
  54. public Operator Operatstr
  55. {
  56. get;
  57. set;
  58. }
  59. /// <summary>
  60. /// 表名
  61. /// </summary>
  62. public string TableName
  63. {
  64. get;
  65. set;
  66. }
  67. /// <summary>
  68. /// 列的值
  69. /// </summary>
  70. public object ColumnValue
  71. {
  72. get
  73. {
  74. return ColumnMetaData.DefaultValue;
  75. }
  76. }
  77. public MetaData md;
  78. /// <summary>
  79. /// 获取表列
  80. /// </summary>
  81. /// <typeparam name="T"></typeparam>
  82. /// <param name="column"></param>
  83. /// <param name="obj"></param>
  84. /// <returns></returns>
  85. public TableColumn GetTableColumn<T>()
  86. {
  87. md.FiledMeta = MetaDataManager.GetMetaData(typeof(T));//获取实体的元数据
  88. return this;
  89. }
  90. /// <summary>
  91. /// 获取字段
  92. /// </summary>
  93. /// <param name="column"></param>
  94. /// <param name="obj"></param>
  95. /// <returns></returns>
  96. public TableColumn GetFieldColumn(string column, object obj)
  97. {
  98. //ColumnMetaData = md.FiledMeta.FieldMeteDatas[column];
  99. //TableName = md.FiledMeta.TableName;
  100. ColumnMetaData.DefaultValue = obj;
  101. return this;
  102. }
  103. /// <summary>
  104. /// 是否相等
  105. /// </summary>
  106. /// <param name="val"></param>
  107. /// <returns></returns>
  108. public TableColumn EqualTo(object val)
  109. {
  110. ColumnMetaData.DefaultValue = val;
  111. Operatstr = Operator.Equal;
  112. return this;
  113. }
  114. /// <summary>
  115. /// 大于
  116. /// </summary>
  117. /// <param name="val"></param>
  118. /// <returns></returns>
  119. public TableColumn Laguage(object val)
  120. {
  121. ColumnMetaData.DefaultValue = val;
  122. Operatstr = Operator.Larger;
  123. return this;
  124. }
  125. /// <summary>
  126. /// 大于等于
  127. /// </summary>
  128. /// <param name="val"></param>
  129. /// <returns></returns>
  130. public TableColumn LaguageEqual(object val)
  131. {
  132. ColumnMetaData.DefaultValue = val;
  133. Operatstr = Operator.EqualLarger;
  134. return this;
  135. }
  136. /// <summary>
  137. /// 小于
  138. /// </summary>
  139. /// <param name="val"></param>
  140. /// <returns></returns>
  141. public TableColumn Small(object val)
  142. {
  143. ColumnMetaData.DefaultValue = val;
  144. Operatstr = Operator.Smaller;
  145. return this;
  146. }
  147. /// <summary>
  148. /// 小于等于
  149. /// </summary>
  150. /// <param name="val"></param>
  151. /// <returns></returns>
  152. public TableColumn SmallEqual(object val)
  153. {
  154. ColumnMetaData.DefaultValue = val;
  155. Operatstr = Operator.EqualSmaller;
  156. return this;
  157. }
  158. /// <summary>
  159. /// In包含查询
  160. /// </summary>
  161. /// <param name="val"></param>
  162. /// <returns></returns>
  163. public TableColumn In(object val)
  164. {
  165. ColumnMetaData.DefaultValue = val;
  166. Operatstr = Operator.In;
  167. return this;
  168. }
  169. }
  170. }