郑许地铁

T_Call_MeetingItems.cs 8.6KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Data;
  6. namespace ZXDT.CallCenter.BLL
  7. {
  8. /// <summary>
  9. /// T_Call_MeetingItems
  10. /// </summary>
  11. public partial class T_Call_MeetingItems
  12. {
  13. private readonly ZXDT.CallCenter.DAL.T_Call_MeetingItems dal = new ZXDT.CallCenter.DAL.T_Call_MeetingItems();
  14. public T_Call_MeetingItems()
  15. { }
  16. #region Method
  17. /// <summary>
  18. /// 是否存在该记录
  19. /// </summary>
  20. public bool Exists(int F_MeetingItemId)
  21. {
  22. return dal.Exists(F_MeetingItemId);
  23. }
  24. /// <summary>
  25. /// 增加一条数据
  26. /// </summary>
  27. public int Add(ZXDT.CallCenter.Model.T_Call_MeetingItems model)
  28. {
  29. return dal.Add(model);
  30. }
  31. /// <summary>
  32. /// 更新一条数据
  33. /// </summary>
  34. public bool Update(ZXDT.CallCenter.Model.T_Call_MeetingItems model)
  35. {
  36. return dal.Update(model);
  37. }
  38. /// <summary>
  39. /// 更新一条数据
  40. /// </summary>
  41. public bool UpdateAddMemberByItemId(ZXDT.CallCenter.Model.T_Call_MeetingItems model)
  42. {
  43. return dal.UpdateAddMemberByItemId(model);
  44. }
  45. /// <summary>
  46. /// 更新一条数据
  47. /// </summary>
  48. public bool UpdateAddMemberByPhone(ZXDT.CallCenter.Model.T_Call_MeetingItems model)
  49. {
  50. return dal.UpdateAddMemberByPhone(model);
  51. }
  52. /// <summary>
  53. /// 更新一条数据
  54. /// </summary>
  55. public bool UpdateRemoveMemberByPhone(ZXDT.CallCenter.Model.T_Call_MeetingItems model)
  56. {
  57. return dal.UpdateRemoveMemberByPhone(model);
  58. }
  59. /// <summary>
  60. /// 更新一条数据
  61. /// </summary>
  62. public bool UpdateMuteMemberByPhone(ZXDT.CallCenter.Model.T_Call_MeetingItems model)
  63. {
  64. return dal.UpdateMuteMemberByPhone(model);
  65. }
  66. /// <summary>
  67. /// 更新一条数据
  68. /// </summary>
  69. public bool UpdateUnMuteMemberByPhone(ZXDT.CallCenter.Model.T_Call_MeetingItems model)
  70. {
  71. return dal.UpdateUnMuteMemberByPhone(model);
  72. }
  73. /// <summary>
  74. /// 删除一条数据
  75. /// </summary>
  76. public bool Delete(int F_MeetingItemId)
  77. {
  78. return dal.Delete(F_MeetingItemId);
  79. }
  80. /// <summary>
  81. /// 删除一条数据
  82. /// </summary>
  83. public bool DeleteList(string F_MeetingItemIdlist)
  84. {
  85. return dal.DeleteList(F_MeetingItemIdlist);
  86. }
  87. /// <summary>
  88. /// 得到一个对象实体
  89. /// </summary>
  90. public ZXDT.CallCenter.Model.T_Call_MeetingItems GetModel(int F_MeetingItemId)
  91. {
  92. return dal.GetModel(F_MeetingItemId);
  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<ZXDT.CallCenter.Model.T_Call_MeetingItems> 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<ZXDT.CallCenter.Model.T_Call_MeetingItems> DataTableToList(DataTable dt)
  120. {
  121. List<ZXDT.CallCenter.Model.T_Call_MeetingItems> modelList = new List<ZXDT.CallCenter.Model.T_Call_MeetingItems>();
  122. int rowsCount = dt.Rows.Count;
  123. if (rowsCount > 0)
  124. {
  125. ZXDT.CallCenter.Model.T_Call_MeetingItems model;
  126. for (int n = 0; n < rowsCount; n++)
  127. {
  128. model = new ZXDT.CallCenter.Model.T_Call_MeetingItems();
  129. if (dt.Rows[n]["F_MeetingItemId"] != null && dt.Rows[n]["F_MeetingItemId"].ToString() != "")
  130. {
  131. model.F_MeetingItemId = int.Parse(dt.Rows[n]["F_MeetingItemId"].ToString());
  132. }
  133. if (dt.Rows[n]["F_MeetingId"] != null && dt.Rows[n]["F_MeetingId"].ToString() != "")
  134. {
  135. model.F_MeetingId = int.Parse(dt.Rows[n]["F_MeetingId"].ToString());
  136. }
  137. if (dt.Rows[n]["F_Phone"] != null && dt.Rows[n]["F_Phone"].ToString() != "")
  138. {
  139. model.F_Phone = dt.Rows[n]["F_Phone"].ToString();
  140. }
  141. if (dt.Rows[n]["F_Name"] != null && dt.Rows[n]["F_Name"].ToString() != "")
  142. {
  143. model.F_Name = dt.Rows[n]["F_Name"].ToString();
  144. }
  145. if (dt.Rows[n]["F_UserId"] != null && dt.Rows[n]["F_UserId"].ToString() != "")
  146. {
  147. model.F_UserId = int.Parse(dt.Rows[n]["F_UserId"].ToString());
  148. }
  149. if (dt.Rows[n]["F_IsMain"] != null && dt.Rows[n]["F_IsMain"].ToString() != "")
  150. {
  151. model.F_IsMain = int.Parse(dt.Rows[n]["F_IsMain"].ToString());
  152. }
  153. if (dt.Rows[n]["F_State"] != null && dt.Rows[n]["F_State"].ToString() != "")
  154. {
  155. model.F_State = int.Parse(dt.Rows[n]["F_State"].ToString());
  156. }
  157. if (dt.Rows[n]["F_InTime"] != null && dt.Rows[n]["F_InTime"].ToString() != "")
  158. {
  159. model.F_InTime = DateTime.Parse(dt.Rows[n]["F_InTime"].ToString());
  160. }
  161. if (dt.Rows[n]["F_OutTime"] != null && dt.Rows[n]["F_OutTime"].ToString() != "")
  162. {
  163. model.F_OutTime = DateTime.Parse(dt.Rows[n]["F_OutTime"].ToString());
  164. }
  165. if (dt.Rows[n]["F_TiCount"] != null && dt.Rows[n]["F_TiCount"].ToString() != "")
  166. {
  167. model.F_TiCount = int.Parse(dt.Rows[n]["F_TiCount"].ToString());
  168. }
  169. if (dt.Rows[n]["F_JingCount"] != null && dt.Rows[n]["F_JingCount"].ToString() != "")
  170. {
  171. model.F_JingCount = int.Parse(dt.Rows[n]["F_JingCount"].ToString());
  172. }
  173. if (dt.Rows[n]["F_CreateTime"] != null && dt.Rows[n]["F_CreateTime"].ToString() != "")
  174. {
  175. model.F_CreateTime = DateTime.Parse(dt.Rows[n]["F_CreateTime"].ToString());
  176. }
  177. if (dt.Rows[n]["F_Remark"] != null && dt.Rows[n]["F_Remark"].ToString() != "")
  178. {
  179. model.F_Remark = dt.Rows[n]["F_Remark"].ToString();
  180. }
  181. if (dt.Rows[n]["F_Int1"] != null && dt.Rows[n]["F_Int1"].ToString() != "")
  182. {
  183. model.F_Int1 = int.Parse(dt.Rows[n]["F_Int1"].ToString());
  184. }
  185. if (dt.Rows[n]["F_DateTime1"] != null && dt.Rows[n]["F_DateTime1"].ToString() != "")
  186. {
  187. model.F_DateTime1 = DateTime.Parse(dt.Rows[n]["F_DateTime1"].ToString());
  188. }
  189. modelList.Add(model);
  190. }
  191. }
  192. return modelList;
  193. }
  194. /// <summary>
  195. /// 获得数据列表
  196. /// </summary>
  197. public DataSet GetAllList()
  198. {
  199. return GetList("");
  200. }
  201. /// <summary>
  202. /// 分页获取数据列表
  203. /// </summary>
  204. public int GetRecordCount(string strWhere)
  205. {
  206. return dal.GetRecordCount(strWhere);
  207. }
  208. /// <summary>
  209. /// 分页获取数据列表
  210. /// </summary>
  211. public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
  212. {
  213. return dal.GetListByPage(strWhere, orderby, startIndex, endIndex);
  214. }
  215. /// <summary>
  216. /// 分页获取数据列表
  217. /// </summary>
  218. //public DataSet GetList(int PageSize,int PageIndex,string strWhere)
  219. //{
  220. //return dal.GetList(PageSize,PageIndex,strWhere);
  221. //}
  222. #endregion Method
  223. }
  224. }