市长热线演示版

T_Call_WorkOrder.cs 4.6KB

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