暂无描述

T_Bus_Feedback.cs 5.9KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220
  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_Feedback
  11. {
  12. private readonly CallCenterApi.DAL.T_Bus_Feedback dal=new CallCenterApi.DAL.T_Bus_Feedback();
  13. public T_Bus_Feedback()
  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(int F_FeedBackId)
  27. {
  28. return dal.Exists(F_FeedBackId);
  29. }
  30. /// <summary>
  31. /// 根据条件查询存在多少记录
  32. /// </summary>
  33. public int GetCountByCondition(string strWhere)
  34. {
  35. return dal.GetCountByCondition(strWhere);
  36. }
  37. /// <summary>
  38. /// 增加一条数据
  39. /// </summary>
  40. public int Add(CallCenterApi.Model.T_Bus_Feedback model)
  41. {
  42. return dal.Add(model);
  43. }
  44. /// <summary>
  45. /// 更新一条数据
  46. /// </summary>
  47. public bool Update(CallCenterApi.Model.T_Bus_Feedback model)
  48. {
  49. return dal.Update(model);
  50. }
  51. /// <summary>
  52. /// 删除一条数据
  53. /// </summary>
  54. public bool Delete(int F_FeedBackId)
  55. {
  56. return dal.Delete(F_FeedBackId);
  57. }
  58. /// <summary>
  59. /// 删除一条数据
  60. /// </summary>
  61. public bool DeleteList(string F_FeedBackIdlist )
  62. {
  63. return dal.DeleteList(F_FeedBackIdlist );
  64. }
  65. /// <summary>
  66. /// 得到一个对象实体
  67. /// </summary>
  68. public CallCenterApi.Model.T_Bus_Feedback GetModel(int F_FeedBackId)
  69. {
  70. return dal.GetModel(F_FeedBackId);
  71. }
  72. /// <summary>
  73. /// 得到一个对象实体,从缓存中
  74. /// </summary>
  75. //public CallCenterApi.Model.T_Bus_Feedback GetModelByCache(int F_FeedBackId)
  76. //{
  77. // string CacheKey = "T_Bus_FeedbackModel-" + F_FeedBackId;
  78. // object objModel = SZRX.Common.DataCache.GetCache(CacheKey);
  79. // if (objModel == null)
  80. // {
  81. // try
  82. // {
  83. // objModel = dal.GetModel(F_FeedBackId);
  84. // if (objModel != null)
  85. // {
  86. // int ModelCache = SZRX.Common.ConfigHelper.GetConfigInt("ModelCache");
  87. // SZRX.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);
  88. // }
  89. // }
  90. // catch{}
  91. // }
  92. // return (CallCenterApi.Model.T_Bus_Feedback)objModel;
  93. //}
  94. /// <summary>
  95. /// 获得数据列表
  96. /// </summary>
  97. public DataSet GetList(string strWhere)
  98. {
  99. return dal.GetList(strWhere);
  100. }
  101. /// <summary>
  102. /// 获得前几行数据
  103. /// </summary>
  104. public DataSet GetList(int Top,string strWhere,string filedOrder)
  105. {
  106. return dal.GetList(Top,strWhere,filedOrder);
  107. }
  108. /// <summary>
  109. /// 获得数据列表
  110. /// </summary>
  111. public List<CallCenterApi.Model.T_Bus_Feedback> GetModelList(string strWhere)
  112. {
  113. DataSet ds = dal.GetList(strWhere);
  114. return DataTableToList(ds.Tables[0]);
  115. }
  116. /// <summary>
  117. /// 获得数据列表
  118. /// </summary>
  119. public List<CallCenterApi.Model.T_Bus_Feedback> DataTableToList(DataTable dt)
  120. {
  121. List<CallCenterApi.Model.T_Bus_Feedback> modelList = new List<CallCenterApi.Model.T_Bus_Feedback>();
  122. int rowsCount = dt.Rows.Count;
  123. if (rowsCount > 0)
  124. {
  125. CallCenterApi.Model.T_Bus_Feedback model;
  126. for (int n = 0; n < rowsCount; n++)
  127. {
  128. model = new CallCenterApi.Model.T_Bus_Feedback();
  129. if(dt.Rows[n]["F_FeedBackId"]!=null && dt.Rows[n]["F_FeedBackId"].ToString()!="")
  130. {
  131. model.F_FeedBackId=int.Parse(dt.Rows[n]["F_FeedBackId"].ToString());
  132. }
  133. if(dt.Rows[n]["F_AssignedId"]!=null && dt.Rows[n]["F_AssignedId"].ToString()!="")
  134. {
  135. model.F_AssignedId=int.Parse(dt.Rows[n]["F_AssignedId"].ToString());
  136. }
  137. if(dt.Rows[n]["F_WorkOrderId"]!=null && dt.Rows[n]["F_WorkOrderId"].ToString()!="")
  138. {
  139. model.F_WorkOrderId=dt.Rows[n]["F_WorkOrderId"].ToString();
  140. }
  141. if(dt.Rows[n]["F_FlowId"]!=null && dt.Rows[n]["F_FlowId"].ToString()!="")
  142. {
  143. model.F_FlowId=int.Parse(dt.Rows[n]["F_FlowId"].ToString());
  144. }
  145. if(dt.Rows[n]["F_Result"]!=null && dt.Rows[n]["F_Result"].ToString()!="")
  146. {
  147. model.F_Result=dt.Rows[n]["F_Result"].ToString();
  148. }
  149. if(dt.Rows[n]["F_IsFile"]!=null && dt.Rows[n]["F_IsFile"].ToString()!="")
  150. {
  151. if((dt.Rows[n]["F_IsFile"].ToString()=="1")||(dt.Rows[n]["F_IsFile"].ToString().ToLower()=="true"))
  152. {
  153. model.F_IsFile=true;
  154. }
  155. else
  156. {
  157. model.F_IsFile=false;
  158. }
  159. }
  160. if(dt.Rows[n]["F_BackDate"]!=null && dt.Rows[n]["F_BackDate"].ToString()!="")
  161. {
  162. model.F_BackDate=DateTime.Parse(dt.Rows[n]["F_BackDate"].ToString());
  163. }
  164. if(dt.Rows[n]["F_Satisfaction"]!=null && dt.Rows[n]["F_Satisfaction"].ToString()!="")
  165. {
  166. model.F_Satisfaction=int.Parse(dt.Rows[n]["F_Satisfaction"].ToString());
  167. }
  168. if(dt.Rows[n]["F_UnSatisfactReason"]!=null && dt.Rows[n]["F_UnSatisfactReason"].ToString()!="")
  169. {
  170. model.F_UnSatisfactReason=dt.Rows[n]["F_UnSatisfactReason"].ToString();
  171. }
  172. if(dt.Rows[n]["F_BackUserName"]!=null && dt.Rows[n]["F_BackUserName"].ToString()!="")
  173. {
  174. model.F_BackUserName=dt.Rows[n]["F_BackUserName"].ToString();
  175. }
  176. modelList.Add(model);
  177. }
  178. }
  179. return modelList;
  180. }
  181. /// <summary>
  182. /// 获得数据列表
  183. /// </summary>
  184. public DataSet GetAllList()
  185. {
  186. return GetList("");
  187. }
  188. /// <summary>
  189. /// 分页获取数据列表
  190. /// </summary>
  191. //public DataSet GetList(int PageSize,int PageIndex,string strWhere)
  192. //{
  193. //return dal.GetList(PageSize,PageIndex,strWhere);
  194. //}
  195. /// <summary>
  196. /// 根据条件判断是否存在该记录
  197. /// </summary>
  198. public bool ExistsByCondition(string strWhere)
  199. {
  200. return dal.ExistsByCondition(strWhere);
  201. }
  202. #endregion Method
  203. }
  204. }