周口郸城医院 DanChengCallCenter_API

sf_bingrenqk.cs 3.7KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157
  1. 
  2. using System;
  3. using System.Data;
  4. using System.Collections.Generic;
  5. using CallCenterApi.Model;
  6. namespace CallCenterApi.BLL
  7. {
  8. /// <summary>
  9. /// SF_BINGRENQK
  10. /// </summary>
  11. public partial class SF_BINGRENQK
  12. {
  13. private readonly CallCenterApi.DAL.SF_BINGRENQK dal=new CallCenterApi.DAL.SF_BINGRENQK();
  14. public SF_BINGRENQK()
  15. {}
  16. #region BasicMethod
  17. /// <summary>
  18. /// 增加一条数据
  19. /// </summary>
  20. public bool Add(CallCenterApi.Model.SF_BINGRENQK model)
  21. {
  22. return dal.Add(model);
  23. }
  24. /// <summary>
  25. /// 增加数据
  26. /// </summary>
  27. public int AddAll(List<CallCenterApi.Model.SF_BINGRENQK> modellist)
  28. {
  29. return dal.AddAll(modellist);
  30. }
  31. /// <summary>
  32. /// 更新一条数据
  33. /// </summary>
  34. public bool Update(CallCenterApi.Model.SF_BINGRENQK model)
  35. {
  36. return dal.Update(model);
  37. }
  38. /// <summary>
  39. /// 删除一条数据
  40. /// </summary>
  41. public bool Delete()
  42. {
  43. //该表无主键信息,请自定义主键/条件字段
  44. return dal.Delete();
  45. }
  46. /// <summary>
  47. /// 得到一个对象实体
  48. /// </summary>
  49. public CallCenterApi.Model.SF_BINGRENQK GetModel(string id)
  50. {
  51. //该表无主键信息,请自定义主键/条件字段
  52. return dal.GetModel(id);
  53. }
  54. /// <summary>
  55. /// 获得数据列表
  56. /// </summary>
  57. public DataSet GetList(string strWhere)
  58. {
  59. return dal.GetList(strWhere);
  60. }
  61. /// <summary>
  62. /// 获得前几行数据
  63. /// </summary>
  64. public DataSet GetList(int Top,string strWhere,string filedOrder)
  65. {
  66. return dal.GetList(Top,strWhere,filedOrder);
  67. }
  68. /// <summary>
  69. /// 获得数据列表
  70. /// </summary>
  71. public List<CallCenterApi.Model.SF_BINGRENQK> GetModelList(string strWhere)
  72. {
  73. DataSet ds = dal.GetList(strWhere);
  74. return DataTableToList(ds.Tables[0]);
  75. }
  76. /// <summary>
  77. /// 获得数据列表
  78. /// </summary>
  79. public List<CallCenterApi.Model.SF_BINGRENQK> DataTableToList(DataTable dt)
  80. {
  81. List<CallCenterApi.Model.SF_BINGRENQK> modelList = new List<CallCenterApi.Model.SF_BINGRENQK>();
  82. int rowsCount = dt.Rows.Count;
  83. if (rowsCount > 0)
  84. {
  85. CallCenterApi.Model.SF_BINGRENQK model;
  86. for (int n = 0; n < rowsCount; n++)
  87. {
  88. model = dal.DataRowToModel(dt.Rows[n]);
  89. if (model != null)
  90. {
  91. modelList.Add(model);
  92. }
  93. }
  94. }
  95. return modelList;
  96. }
  97. /// <summary>
  98. /// 获得数据列表
  99. /// </summary>
  100. public DataSet GetAllList()
  101. {
  102. return GetList("");
  103. }
  104. /// <summary>
  105. /// 分页获取数据列表
  106. /// </summary>
  107. public int GetRecordCount(string strWhere)
  108. {
  109. return dal.GetRecordCount(strWhere);
  110. }
  111. /// <summary>
  112. /// 分页获取数据列表
  113. /// </summary>
  114. public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
  115. {
  116. return dal.GetListByPage( strWhere, orderby, startIndex, endIndex);
  117. }
  118. /// <summary>
  119. /// 分页获取数据列表
  120. /// </summary>
  121. //public DataSet GetList(int PageSize,int PageIndex,string strWhere)
  122. //{
  123. //return dal.GetList(PageSize,PageIndex,strWhere);
  124. //}
  125. #endregion BasicMethod
  126. #region ExtensionMethod
  127. public int GetMaxCount()
  128. {
  129. return dal.GetMaxCount();
  130. }
  131. public DataTable GetALLListByPage(string strWhere, string orderby, int startIndex, int endIndex, out int count)
  132. {
  133. return dal.GetALLListByPage(strWhere, orderby, startIndex, endIndex,out count);
  134. }
  135. public DataTable GetALLListById(string strWhere, string orderby, int startIndex, int endIndex)
  136. {
  137. return dal.GetALLListById(strWhere, orderby, startIndex, endIndex);
  138. }
  139. #endregion ExtensionMethod
  140. }
  141. }