暫無描述

T_Bus_WorkOrder.cs 5.8KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207
  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_WorkOrder
  11. {
  12. private readonly CallCenterApi.DAL.T_Bus_WorkOrder dal=new CallCenterApi.DAL.T_Bus_WorkOrder();
  13. public T_Bus_WorkOrder()
  14. {}
  15. #region Method
  16. /// <summary>
  17. /// 得到最大ID
  18. /// </summary>
  19. public int GetMaxId()
  20. {
  21. return dal.GetMaxId();
  22. }
  23. /// <summary>
  24. /// 是否存在该记录
  25. /// </summary>
  26. public bool Exists(string F_WorkOrderId)
  27. {
  28. return dal.Exists(F_WorkOrderId);
  29. }
  30. /// <summary>
  31. /// 增加一条数据
  32. /// </summary>
  33. public int Add(CallCenterApi.Model.T_Bus_WorkOrder model)
  34. {
  35. return dal.Add(model);
  36. }
  37. /// <summary>
  38. /// 更新一条数据
  39. /// </summary>
  40. public bool Update(CallCenterApi.Model.T_Bus_WorkOrder model)
  41. {
  42. return dal.Update(model);
  43. }
  44. /// <summary>
  45. /// 更新一条数据
  46. /// </summary>
  47. public bool UpdateWorkOrder(int F_Id, Dictionary<string, object> keyValues)
  48. {
  49. return dal.UpdateWorkOrder(F_Id, keyValues);
  50. }
  51. /// <summary>
  52. /// 更新一条数据
  53. /// </summary>
  54. public bool UpdateYS(CallCenterApi.Model.T_Bus_WorkOrder model)
  55. {
  56. return dal.UpdateYS(model);
  57. }
  58. /// <summary>
  59. /// 删除一条数据
  60. /// </summary>
  61. public bool Delete(int F_Id)
  62. {
  63. return dal.Delete(F_Id);
  64. }
  65. /// <summary>
  66. /// 删除一条数据
  67. /// </summary>
  68. public bool DeleteList(string F_Idlist)
  69. {
  70. return dal.DeleteList(F_Idlist);
  71. }
  72. /// <summary>
  73. /// 逻辑删除一条数据
  74. /// </summary>
  75. public bool DeleteLogicList(string F_WorkOrderIdlist)
  76. {
  77. return dal.DeleteLogicList(F_WorkOrderIdlist);
  78. }
  79. /// <summary>
  80. /// 得到一个对象实体
  81. /// </summary>
  82. public CallCenterApi.Model.T_Bus_WorkOrder GetModel(int F_Id)
  83. {
  84. return dal.GetModel(F_Id);
  85. }
  86. /// <summary>
  87. /// 得到一个对象实体
  88. /// </summary>
  89. public CallCenterApi.Model.T_Bus_WorkOrder GetModel(string F_WorkOrderId)
  90. {
  91. return dal.GetModel(F_WorkOrderId);
  92. }
  93. /// <summary>
  94. /// 获得数据列表
  95. /// </summary>
  96. public DataSet GetList(string strWhere)
  97. {
  98. return dal.GetList(strWhere);
  99. }
  100. /// <summary>
  101. /// 获得前几行数据
  102. /// </summary>
  103. public DataSet GetList(int Top, string strWhere, string filedOrder)
  104. {
  105. return dal.GetList(Top, strWhere, filedOrder);
  106. }
  107. /// <summary>
  108. /// 获得数据列表
  109. /// </summary>
  110. public List<CallCenterApi.Model.T_Bus_WorkOrder> GetModelList(int Top, string strWhere, string filedOrder)
  111. {
  112. DataSet ds = dal.GetList(Top, strWhere, filedOrder);
  113. return DataTableToList(ds.Tables[0]);
  114. }
  115. /// <summary>
  116. /// 获得数据列表
  117. /// </summary>
  118. public List<CallCenterApi.Model.T_Bus_WorkOrder> GetModelList(string strWhere)
  119. {
  120. DataSet ds = dal.GetList(strWhere);
  121. return DataTableToList(ds.Tables[0]);
  122. }
  123. /// <summary>
  124. /// 获得数据列表
  125. /// </summary>
  126. public List<CallCenterApi.Model.T_Bus_WorkOrder> DataTableToList(DataTable dt)
  127. {
  128. List<CallCenterApi.Model.T_Bus_WorkOrder> modelList = new List<CallCenterApi.Model.T_Bus_WorkOrder>();
  129. int rowsCount = dt.Rows.Count;
  130. if (rowsCount > 0)
  131. {
  132. CallCenterApi.Model.T_Bus_WorkOrder model;
  133. for (int n = 0; n < rowsCount; n++)
  134. {
  135. model = dal.DataRowToModel(dt.Rows[n]);
  136. if (model != null)
  137. {
  138. modelList.Add(model);
  139. }
  140. }
  141. }
  142. return modelList;
  143. }
  144. /// <summary>
  145. /// 获得数据列表
  146. /// </summary>
  147. public DataSet GetAllList()
  148. {
  149. return GetList("");
  150. }
  151. /// <summary>
  152. /// 分页获取数据列表
  153. /// </summary>
  154. public int GetRecordCount(string strWhere)
  155. {
  156. return dal.GetRecordCount(strWhere);
  157. }
  158. /// <summary>
  159. /// 分页获取数据列表
  160. /// </summary>
  161. public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
  162. {
  163. return dal.GetListByPage(strWhere, orderby, startIndex, endIndex);
  164. }
  165. /// <summary>
  166. /// 分页获取数据列表
  167. /// </summary>
  168. //public DataSet GetList(int PageSize,int PageIndex,string strWhere)
  169. //{
  170. //return dal.GetList(PageSize,PageIndex,strWhere);
  171. //}
  172. /// <summary>
  173. /// 根据坐席号获取新的工单号
  174. /// </summary>
  175. /// <param name="p_UserCode"></param>
  176. /// <returns></returns>
  177. public string GetNewWorkOrderID(int source,int sourcearea,string cratetime,string endtime)
  178. {
  179. return dal.GetNewWorkOrderID(source, sourcearea, cratetime, endtime);
  180. }
  181. // /// <summary>
  182. ///// 从视图得到一个对象实体
  183. ///// </summary>
  184. //public CallCenterApi.Model.T_Bus_WorkOrder GetModelFromView(string F_WorkOrderId)
  185. //{
  186. // return dal.GetModelFromView(F_WorkOrderId);
  187. //}
  188. #endregion Method
  189. }
  190. }