鹤壁市长热线,前端git:http://192.168.1.222:3000/clq1010/CallCenter5.0WebUI.git 中的鹤壁12345分支

T_Bus_WorkCallRecord.cs 4.4KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156
  1. using System;
  2. using System.Data;
  3. using System.Collections.Generic;
  4. using CallCenterApi.Model;
  5. namespace CallCenterApi.BLL
  6. {
  7. /// <summary>
  8. /// 1
  9. /// </summary>
  10. public partial class T_Bus_WorkCallRecord
  11. {
  12. private readonly CallCenterApi.DAL.T_Bus_WorkCallRecord dal=new CallCenterApi.DAL.T_Bus_WorkCallRecord();
  13. public T_Bus_WorkCallRecord()
  14. {}
  15. #region Method
  16. /// <summary>
  17. /// 是否存在该记录
  18. /// </summary>
  19. public bool Exists(int F_CallRecordId,string F_WorkOrderId)
  20. {
  21. return dal.Exists(F_CallRecordId,F_WorkOrderId);
  22. }
  23. /// <summary>
  24. /// 增加一条数据
  25. /// </summary>
  26. public void Add(CallCenterApi.Model.T_Bus_WorkCallRecord model)
  27. {
  28. dal.Add(model);
  29. }
  30. /// <summary>
  31. /// 更新一条数据
  32. /// </summary>
  33. public bool Update(CallCenterApi.Model.T_Bus_WorkCallRecord model)
  34. {
  35. return dal.Update(model);
  36. }
  37. /// <summary>
  38. /// 删除一条数据
  39. /// </summary>
  40. public bool Delete(int F_CallRecordId,string F_WorkOrderId)
  41. {
  42. return dal.Delete(F_CallRecordId,F_WorkOrderId);
  43. }
  44. /// <summary>
  45. /// 得到一个对象实体
  46. /// </summary>
  47. public CallCenterApi.Model.T_Bus_WorkCallRecord GetModel(int F_CallRecordId,string F_WorkOrderId)
  48. {
  49. return dal.GetModel(F_CallRecordId,F_WorkOrderId);
  50. }
  51. /// <summary>
  52. /// 得到一个对象实体,从缓存中
  53. /// </summary>
  54. //public CallCenterApi.Model.T_Bus_WorkCallRecord GetModelByCache(int F_CallRecordId,string F_WorkOrderId)
  55. //{
  56. // string CacheKey = "T_Bus_WorkCallRecordModel-" + F_CallRecordId+F_WorkOrderId;
  57. // object objModel = SZRX.Common.DataCache.GetCache(CacheKey);
  58. // if (objModel == null)
  59. // {
  60. // try
  61. // {
  62. // objModel = dal.GetModel(F_CallRecordId,F_WorkOrderId);
  63. // if (objModel != null)
  64. // {
  65. // int ModelCache = SZRX.Common.ConfigHelper.GetConfigInt("ModelCache");
  66. // SZRX.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);
  67. // }
  68. // }
  69. // catch{}
  70. // }
  71. // return (CallCenterApi.Model.T_Bus_WorkCallRecord)objModel;
  72. //}
  73. /// <summary>
  74. /// 获得数据列表
  75. /// </summary>
  76. public DataSet GetList(string strWhere)
  77. {
  78. return dal.GetList(strWhere);
  79. }
  80. /// <summary>
  81. /// 获得前几行数据
  82. /// </summary>
  83. public DataSet GetList(int Top,string strWhere,string filedOrder)
  84. {
  85. return dal.GetList(Top,strWhere,filedOrder);
  86. }
  87. /// <summary>
  88. /// 获得数据列表
  89. /// </summary>
  90. public List<CallCenterApi.Model.T_Bus_WorkCallRecord> GetModelList(string strWhere)
  91. {
  92. DataSet ds = dal.GetList(strWhere);
  93. return DataTableToList(ds.Tables[0]);
  94. }
  95. /// <summary>
  96. /// 获得数据列表
  97. /// </summary>
  98. public List<CallCenterApi.Model.T_Bus_WorkCallRecord> DataTableToList(DataTable dt)
  99. {
  100. List<CallCenterApi.Model.T_Bus_WorkCallRecord> modelList = new List<CallCenterApi.Model.T_Bus_WorkCallRecord>();
  101. int rowsCount = dt.Rows.Count;
  102. if (rowsCount > 0)
  103. {
  104. CallCenterApi.Model.T_Bus_WorkCallRecord model;
  105. for (int n = 0; n < rowsCount; n++)
  106. {
  107. model = new CallCenterApi.Model.T_Bus_WorkCallRecord();
  108. if (dt.Rows[n]["F_CallRecordId"] != null && dt.Rows[n]["F_CallRecordId"].ToString() != "")
  109. {
  110. model.F_CallRecordId = int.Parse(dt.Rows[n]["F_CallRecordId"].ToString());
  111. }
  112. if (dt.Rows[n]["F_WorkOrderId"] != null && dt.Rows[n]["F_WorkOrderId"].ToString() != "")
  113. {
  114. model.F_WorkOrderId = dt.Rows[n]["F_WorkOrderId"].ToString();
  115. }
  116. if (dt.Rows[n]["Type"] != null && dt.Rows[n]["Type"].ToString() != "")
  117. {
  118. model.Type = int.Parse(dt.Rows[n]["Type"].ToString());
  119. }
  120. modelList.Add(model);
  121. }
  122. }
  123. return modelList;
  124. }
  125. /// <summary>
  126. /// 获得数据列表
  127. /// </summary>
  128. public DataSet GetAllList()
  129. {
  130. return GetList("");
  131. }
  132. /// <summary>
  133. /// 分页获取数据列表
  134. /// </summary>
  135. //public DataSet GetList(int PageSize,int PageIndex,string strWhere)
  136. //{
  137. //return dal.GetList(PageSize,PageIndex,strWhere);
  138. //}
  139. #endregion Method
  140. }
  141. }