郑许地铁

T_Fax_RecvFax.cs 5.4KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178
  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. //T_Fax_RecvFax
  9. public partial class T_Fax_RecvFax
  10. {
  11. private readonly DAL.T_Fax_RecvFax dal = new DAL.T_Fax_RecvFax();
  12. public T_Fax_RecvFax()
  13. { }
  14. #region Method
  15. /// <summary>
  16. /// 是否存在该记录
  17. /// </summary>
  18. public bool Exists(int FaxID)
  19. {
  20. return dal.Exists(FaxID);
  21. }
  22. /// <summary>
  23. /// 增加一条数据
  24. /// </summary>
  25. public int Add(Model.T_Fax_RecvFax model)
  26. {
  27. return dal.Add(model);
  28. }
  29. /// <summary>
  30. /// 更新一条数据
  31. /// </summary>
  32. public bool Update(Model.T_Fax_RecvFax model)
  33. {
  34. return dal.Update(model);
  35. }
  36. /// <summary>
  37. /// 更新查看状态
  38. /// </summary>
  39. /// <param name="FaxID"></param>
  40. /// <param name="State"></param>
  41. /// <returns></returns>
  42. public int UpdateState(int FaxID, int State)
  43. {
  44. return dal.UpdateState(FaxID, State);
  45. }
  46. /// <summary>
  47. /// 更新一条数据
  48. /// </summary>
  49. /// <param name="model"></param>
  50. /// <returns></returns>
  51. public int UpdateWebFilePath(Model.T_Fax_RecvFax model)
  52. {
  53. return dal.UpdateWebFilePath(model);
  54. }
  55. /// <summary>
  56. /// 删除一条数据
  57. /// </summary>
  58. public bool Delete(int FaxID)
  59. {
  60. return dal.Delete(FaxID);
  61. }
  62. /// <summary>
  63. /// 批量删除一批数据
  64. /// </summary>
  65. public bool DeleteList(string FaxIDlist)
  66. {
  67. return dal.DeleteList(FaxIDlist);
  68. }
  69. /// <summary>
  70. /// 得到一个对象实体
  71. /// </summary>
  72. public Model.T_Fax_RecvFax GetModel(int FaxID)
  73. {
  74. return dal.GetModel(FaxID);
  75. }
  76. /// <summary>
  77. /// 获得数据列表
  78. /// </summary>
  79. public DataSet GetList(string strWhere)
  80. {
  81. return dal.GetList(strWhere);
  82. }
  83. /// <summary>
  84. /// 获得前几行数据
  85. /// </summary>
  86. public DataSet GetList(int Top, string strWhere, string filedOrder)
  87. {
  88. return dal.GetList(Top, strWhere, filedOrder);
  89. }
  90. /// <summary>
  91. /// 获得数据列表
  92. /// </summary>
  93. public List<Model.T_Fax_RecvFax> GetModelList(string strWhere)
  94. {
  95. DataSet ds = dal.GetList(strWhere);
  96. return DataTableToList(ds.Tables[0]);
  97. }
  98. /// <summary>
  99. /// 获得数据列表
  100. /// </summary>
  101. public List<Model.T_Fax_RecvFax> DataTableToList(DataTable dt)
  102. {
  103. List<Model.T_Fax_RecvFax> modelList = new List<Model.T_Fax_RecvFax>();
  104. int rowsCount = dt.Rows.Count;
  105. if (rowsCount > 0)
  106. {
  107. Model.T_Fax_RecvFax model;
  108. for (int n = 0; n < rowsCount; n++)
  109. {
  110. model = new Model.T_Fax_RecvFax();
  111. if (dt.Rows[n]["FaxID"].ToString() != "")
  112. {
  113. model.FaxID = int.Parse(dt.Rows[n]["FaxID"].ToString());
  114. }
  115. if (dt.Rows[n]["FileState"].ToString() != "")
  116. {
  117. model.FileState = int.Parse(dt.Rows[n]["FileState"].ToString());
  118. }
  119. if (dt.Rows[n]["State"].ToString() != "")
  120. {
  121. model.State = int.Parse(dt.Rows[n]["State"].ToString());
  122. }
  123. if (dt.Rows[n]["F_UserID"].ToString() != "")
  124. {
  125. model.F_UserID = int.Parse(dt.Rows[n]["F_UserID"].ToString());
  126. }
  127. if (dt.Rows[n]["F_CustomerID"].ToString() != "")
  128. {
  129. model.F_CustomerID = int.Parse(dt.Rows[n]["F_CustomerID"].ToString());
  130. }
  131. model.F_Name = dt.Rows[n]["F_Name"].ToString();
  132. model.F_FaxCode = dt.Rows[n]["F_FaxCode"].ToString();
  133. model.TelNum = dt.Rows[n]["TelNum"].ToString();
  134. model.TifFilePath = dt.Rows[n]["TifFilePath"].ToString();
  135. model.FilePath = dt.Rows[n]["FilePath"].ToString();
  136. if (dt.Rows[n]["FileSize"].ToString() != "")
  137. {
  138. model.FileSize = int.Parse(dt.Rows[n]["FileSize"].ToString());
  139. }
  140. model.FileType = dt.Rows[n]["FileType"].ToString();
  141. model.Remark = dt.Rows[n]["Remark"].ToString();
  142. if (dt.Rows[n]["RecvTime"].ToString() != "")
  143. {
  144. model.RecvTime = DateTime.Parse(dt.Rows[n]["RecvTime"].ToString());
  145. }
  146. model.Info = dt.Rows[n]["Info"].ToString();
  147. modelList.Add(model);
  148. }
  149. }
  150. return modelList;
  151. }
  152. /// <summary>
  153. /// 获得数据列表
  154. /// </summary>
  155. public DataSet GetAllList()
  156. {
  157. return GetList("");
  158. }
  159. #endregion
  160. }
  161. }