QueryBase.cs 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Linq;
  5. using System.Text;
  6. using Ant.Data;
  7. using Ant.Frame;
  8. using System.Collections;
  9. namespace Ant.ORM
  10. {
  11. /// <summary>
  12. /// 实体基类
  13. /// </summary>
  14. [Serializable]
  15. public abstract class QueryBase<T>
  16. {
  17. private int _TimeStamp = 0;
  18. private string _WhereSql = string.Empty;
  19. /// <summary>
  20. ///
  21. /// </summary>
  22. public DataAccess SQLDB { get; set; }
  23. /// <summary>
  24. /// 关联对象的处理方式,比如:{Company:},{}
  25. /// </summary>
  26. protected Hashtable Rules = new Hashtable();
  27. protected QueryBase()
  28. {
  29. }
  30. //public abstract void AcceptChanges();
  31. /// <summary>
  32. /// 获得各个属性的值
  33. /// </summary>
  34. /// <param name="level">获得子对象数据的层次</param>
  35. public abstract void GetDetail(int level);
  36. /// <summary>
  37. /// 获取单个实体
  38. /// </summary>
  39. /// <param name="db"></param>
  40. /// <param name="showfield">显示字段</param>
  41. /// <returns></returns>
  42. public abstract ResponseModel GetEntity(RequestModel enty);
  43. /// <summary>
  44. /// 通过DataReader返回List集合
  45. /// </summary>
  46. /// <returns></returns>
  47. public abstract ResponseModel GetDr2EnList(RequestModel enty);
  48. /// <summary>
  49. ///
  50. /// </summary>
  51. /// <param name="db">数据库对象</param>
  52. /// <returns></returns>
  53. public abstract ResponseModel GetDt2EnList(RequestModel enty);
  54. /// <summary>
  55. /// 查询获取DataTable
  56. /// </summary>
  57. /// <param name="showfield"></param>
  58. /// <returns></returns>
  59. public abstract ResponseModel GetDtList(RequestModel enty);
  60. /// <summary>
  61. /// 由DataReader转DataTable
  62. /// </summary>
  63. /// <param name="enty"></param>
  64. /// <returns></returns>
  65. public abstract ResponseModel GetDr2DtList(RequestModel enty);
  66. /// <summary>
  67. /// 查询分页返回实体
  68. /// </summary>
  69. /// <param name="startNum">起始</param>
  70. /// <param name="pageSize">记录数</param>
  71. /// <returns></returns>
  72. public abstract ResponseModel GetPageRecordList(RequestModel enty);
  73. /// <summary>
  74. /// 查询分页返回DataTable
  75. /// </summary>
  76. /// <param name="startNum"></param>
  77. /// <param name="pageSize"></param>
  78. /// <returns></returns>
  79. public abstract ResponseModel GetPageRecordDt(RequestModel enty);
  80. /// <summary>
  81. /// 时间戳
  82. /// </summary>
  83. internal long TimeStamp
  84. {
  85. get { return this._TimeStamp; }
  86. }
  87. /// <summary>
  88. /// 模块
  89. /// </summary>
  90. public abstract string ModuleName { get; }
  91. /// <summary>
  92. /// 排序
  93. /// </summary>
  94. public abstract string OrderBy { get; set; }
  95. /// <summary>
  96. /// 通过json字符串给实体类赋值
  97. /// </summary>
  98. /// <param name="JsonString"></param>
  99. public virtual void SetValueByJson(string JsonString)
  100. {
  101. }
  102. private EntityPersistType persistType;
  103. /// <summary>
  104. /// 操作类型
  105. /// </summary>
  106. public EntityPersistType PersistType
  107. {
  108. get { return persistType; }
  109. set { persistType = value; }
  110. }
  111. public bool _isbug=false;
  112. /// <summary>
  113. /// 是否Dbug
  114. /// </summary>
  115. public bool IsBug
  116. {
  117. get { return _isbug; }
  118. set { _isbug = value; }
  119. }
  120. /// <summary>
  121. /// 查询条件
  122. /// </summary>
  123. public string WhereSql
  124. {
  125. get
  126. {
  127. return this._WhereSql;
  128. }
  129. set
  130. {
  131. value = value.Trim().ToLower();
  132. if (value.StartsWith("where"))
  133. {
  134. value = value.Substring(5, value.Length - 5);
  135. }
  136. this._WhereSql = value;
  137. }
  138. }
  139. }
  140. }