Geen omschrijving

T_Call_CallRecords.cs 7.0KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. namespace CallCenterApi.BLL
  8. {
  9. /// <summary>
  10. /// 通话记录表
  11. /// </summary>
  12. public partial class T_Call_CallRecords
  13. {
  14. private readonly DAL.T_Call_CallRecords dal = new DAL.T_Call_CallRecords();
  15. public T_Call_CallRecords()
  16. { }
  17. #region BasicMethod
  18. /// <summary>
  19. /// 得到最大ID
  20. /// </summary>
  21. public int GetMaxId()
  22. {
  23. return dal.GetMaxId();
  24. }
  25. /// <summary>
  26. /// 是否存在该记录
  27. /// </summary>
  28. public bool Exists(int CallRecordsId)
  29. {
  30. return dal.Exists(CallRecordsId);
  31. }
  32. /// <summary>
  33. /// 增加一条数据
  34. /// </summary>
  35. public int Add(Model.T_Call_CallRecords model)
  36. {
  37. return dal.Add(model);
  38. }
  39. /// <summary>
  40. /// 更新一条数据
  41. /// </summary>
  42. public bool Update(Model.T_Call_CallRecords model)
  43. {
  44. return dal.Update(model);
  45. }
  46. /// <summary>
  47. /// 删除一条数据
  48. /// </summary>
  49. public bool Delete(int CallRecordsId)
  50. {
  51. return dal.Delete(CallRecordsId);
  52. }
  53. /// <summary>
  54. /// 删除一条数据
  55. /// </summary>
  56. public bool DeleteList(string CallRecordsIdlist)
  57. {
  58. return dal.DeleteList(CallRecordsIdlist);
  59. }
  60. /// <summary>
  61. /// 得到一个对象实体
  62. /// </summary>
  63. public Model.T_Call_CallRecords GetModel(int CallRecordsId)
  64. {
  65. return dal.GetModel(CallRecordsId);
  66. }
  67. /// <summary>
  68. /// 得到一个对象实体
  69. /// </summary>
  70. public Model.T_Call_CallRecords GetModel(string CallId)
  71. {
  72. return dal.GetModel(CallId);
  73. }
  74. /// <summary>
  75. /// 获得数据列表
  76. /// </summary>
  77. public DataSet GetList(string strWhere)
  78. {
  79. return dal.GetList(strWhere);
  80. }
  81. /// <summary>
  82. /// 获得前几行数据
  83. /// </summary>
  84. public DataSet GetList(int Top, string strWhere, string filedOrder)
  85. {
  86. return dal.GetList(Top, strWhere, filedOrder);
  87. }
  88. /// <summary>
  89. /// 获得数据列表
  90. /// </summary>
  91. public List<Model.T_Call_CallRecords> GetModelList(string strWhere)
  92. {
  93. DataSet ds = dal.GetList(strWhere);
  94. return DataTableToList(ds.Tables[0]);
  95. }
  96. /// <summary>
  97. /// 获得数据列表
  98. /// </summary>
  99. public List<Model.T_Call_CallRecords> DataTableToList(DataTable dt)
  100. {
  101. List<Model.T_Call_CallRecords> modelList = new List<Model.T_Call_CallRecords>();
  102. int rowsCount = dt.Rows.Count;
  103. if (rowsCount > 0)
  104. {
  105. Model.T_Call_CallRecords model;
  106. for (int n = 0; n < rowsCount; n++)
  107. {
  108. model = dal.DataRowToModel(dt.Rows[n]);
  109. if (model != null)
  110. {
  111. modelList.Add(model);
  112. }
  113. }
  114. }
  115. return modelList;
  116. }
  117. /// <summary>
  118. /// 获得数据列表
  119. /// </summary>
  120. public DataSet GetAllList()
  121. {
  122. return GetList("");
  123. }
  124. /// <summary>
  125. /// 分页获取数据列表
  126. /// </summary>
  127. public int GetRecordCount(string strWhere)
  128. {
  129. return dal.GetRecordCount(strWhere);
  130. }
  131. /// <summary>
  132. /// 获取数据TalkLongTime统计
  133. /// </summary>
  134. public int GetRecordTalkLongTimeSum(string strWhere)
  135. {
  136. return dal.GetRecordTalkLongTimeSum(strWhere);
  137. }
  138. /// <summary>
  139. /// 分页获取数据列表
  140. /// </summary>
  141. public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
  142. {
  143. return dal.GetListByPage(strWhere, orderby, startIndex, endIndex);
  144. }
  145. #endregion BasicMethod
  146. #region ExtensionMethod
  147. #endregion ExtensionMethod
  148. #region 更新来电振铃电话记录信息
  149. /// <summary>
  150. /// 更新来电振铃电话记录信息
  151. /// </summary>
  152. public bool UpdateCallInRingTelRecord(Model.T_Call_CallRecords model)
  153. {
  154. return dal.UpdateCallInRingTelRecord(model);
  155. }
  156. #endregion
  157. #region 更新来电摘机电话记录信息
  158. /// <summary>
  159. /// 更新来电摘机电话记录信息
  160. /// </summary>
  161. public bool UpdateCallInAnswerTelRecord(Model.T_Call_CallRecords model)
  162. {
  163. return dal.UpdateCallInAnswerTelRecord(model);
  164. }
  165. #endregion
  166. #region 更新来电挂断电话记录信息
  167. /// <summary>
  168. /// 更新来电挂断电话记录信息
  169. /// </summary>
  170. public bool UpdateCallInHookTelRecord(string callId)
  171. {
  172. return dal.UpdateCallInHookTelRecord(callId);
  173. }
  174. #endregion
  175. #region 更新来电录音记录信息
  176. /// <summary>
  177. /// 更新来电录音记录信息
  178. /// </summary>
  179. public bool UpdateCallInPathTelRecord(Model.T_Call_CallRecords model)
  180. {
  181. return dal.UpdateCallInPathTelRecord(model);
  182. }
  183. #endregion
  184. #region 根据来电号码获取电话记录
  185. /// <summary>
  186. /// 根据来电号码获取电话记录
  187. /// </summary>
  188. public Model.T_Call_CallRecords GetModelByTelphone(string CallNumber)
  189. {
  190. return dal.GetModelByTelphone(CallNumber);
  191. }
  192. #endregion
  193. #region 根据CallId获取电话记录
  194. /// <summary>
  195. /// 根据CallId获取电话记录
  196. /// </summary>
  197. public Model.T_Call_CallRecords GetModelByCallId(string CallId)
  198. {
  199. return dal.GetModelByCallId(CallId);
  200. }
  201. /// <summary>
  202. /// 根据CallId获取电话记录
  203. /// </summary>
  204. public Model.T_Call_CallRecords GetModelByRecordId(string CallId)
  205. {
  206. return dal.GetModelByRecordId(CallId);
  207. }
  208. #endregion
  209. #region 更新来电处理状态信息
  210. /// <summary>
  211. /// 更新来电处理状态信息
  212. /// </summary>
  213. public bool UpdateCallInRecordDealType(string callid, int type)
  214. {
  215. return dal.UpdateCallInRecordDealType(callid, type);
  216. }
  217. #endregion
  218. #region 导出通话记录
  219. /// <summary>
  220. /// 导出通话记录
  221. /// </summary>
  222. /// <param name="strWhere"></param>
  223. /// <returns></returns>
  224. public DataSet GetListExpt(string strWhere)
  225. {
  226. return dal.GetListExpt(strWhere);
  227. }
  228. #endregion
  229. }
  230. }