郑许地铁

T_Fax_SentFax.cs 6.2KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195
  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_SentFax
  9. public partial class T_Fax_SentFax
  10. {
  11. private readonly DAL.T_Fax_SentFax dal = new DAL.T_Fax_SentFax();
  12. public T_Fax_SentFax()
  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 void Add(Model.T_Fax_SentFax model)
  26. {
  27. dal.Add(model);
  28. }
  29. /// <summary>
  30. /// 重新发送
  31. /// </summary>
  32. /// <param name="arrFaxID">发送的ID</param>
  33. /// <returns></returns>
  34. public int ReSend(string arrFaxID)
  35. {
  36. return dal.ReSend(arrFaxID);
  37. }
  38. /// <summary>
  39. /// 更新一条数据
  40. /// </summary>
  41. public bool Update(Model.T_Fax_SentFax model)
  42. {
  43. return dal.Update(model);
  44. }
  45. /// <summary>
  46. /// 更新一条数据
  47. /// </summary>
  48. public int UpdateWebFilePath(Model.T_Fax_SentFax model)
  49. {
  50. return dal.UpdateWebFilePath(model);
  51. }
  52. /// <summary>
  53. /// 删除一条数据
  54. /// </summary>
  55. public bool Delete(int FaxID)
  56. {
  57. return dal.Delete(FaxID);
  58. }
  59. /// <summary>
  60. /// 批量删除一批数据
  61. /// </summary>
  62. public bool DeleteList(string FaxIDlist)
  63. {
  64. return dal.DeleteList(FaxIDlist);
  65. }
  66. /// <summary>
  67. /// 得到一个对象实体
  68. /// </summary>
  69. public Model.T_Fax_SentFax GetModel(int FaxID)
  70. {
  71. return dal.GetModel(FaxID);
  72. }
  73. /// <summary>
  74. /// 获得数据列表
  75. /// </summary>
  76. public DataSet GetList(string strWhere)
  77. {
  78. return dal.GetList(strWhere);
  79. }
  80. /// <summary>
  81. /// 获得前几行数据
  82. /// </summary>
  83. public DataSet GetList(int Top, string strWhere, string filedOrder)
  84. {
  85. return dal.GetList(Top, strWhere, filedOrder);
  86. }
  87. /// <summary>
  88. /// 获得数据列表
  89. /// </summary>
  90. public List<Model.T_Fax_SentFax> GetModelList(string strWhere)
  91. {
  92. DataSet ds = dal.GetList(strWhere);
  93. return DataTableToList(ds.Tables[0]);
  94. }
  95. /// <summary>
  96. /// 获得数据列表
  97. /// </summary>
  98. public List<Model.T_Fax_SentFax> DataTableToList(DataTable dt)
  99. {
  100. List<Model.T_Fax_SentFax> modelList = new List<Model.T_Fax_SentFax>();
  101. int rowsCount = dt.Rows.Count;
  102. if (rowsCount > 0)
  103. {
  104. Model.T_Fax_SentFax model;
  105. for (int n = 0; n < rowsCount; n++)
  106. {
  107. model = new Model.T_Fax_SentFax();
  108. if (dt.Rows[n]["FaxID"].ToString() != "")
  109. {
  110. model.FaxID = int.Parse(dt.Rows[n]["FaxID"].ToString());
  111. }
  112. if (dt.Rows[n]["SendTime"].ToString() != "")
  113. {
  114. model.SendTime = DateTime.Parse(dt.Rows[n]["SendTime"].ToString());
  115. }
  116. if (dt.Rows[n]["LastSentTime"].ToString() != "")
  117. {
  118. model.LastSentTime = DateTime.Parse(dt.Rows[n]["LastSentTime"].ToString());
  119. }
  120. if (dt.Rows[n]["CurSentCount"].ToString() != "")
  121. {
  122. model.CurSentCount = int.Parse(dt.Rows[n]["CurSentCount"].ToString());
  123. }
  124. if (dt.Rows[n]["MaxSendCount"].ToString() != "")
  125. {
  126. model.MaxSendCount = int.Parse(dt.Rows[n]["MaxSendCount"].ToString());
  127. }
  128. model.Info = dt.Rows[n]["Info"].ToString();
  129. if (dt.Rows[n]["FileState"].ToString() != "")
  130. {
  131. model.FileState = int.Parse(dt.Rows[n]["FileState"].ToString());
  132. }
  133. if (dt.Rows[n]["State"].ToString() != "")
  134. {
  135. model.State = int.Parse(dt.Rows[n]["State"].ToString());
  136. }
  137. if (dt.Rows[n]["F_UserID"].ToString() != "")
  138. {
  139. model.F_UserID = int.Parse(dt.Rows[n]["F_UserID"].ToString());
  140. }
  141. if (dt.Rows[n]["F_CustomerID"].ToString() != "")
  142. {
  143. model.F_CustomerID = int.Parse(dt.Rows[n]["F_CustomerID"].ToString());
  144. }
  145. model.F_Name = dt.Rows[n]["F_Name"].ToString();
  146. model.TelNum = dt.Rows[n]["TelNum"].ToString();
  147. model.F_FaxCode = dt.Rows[n]["F_FaxCode"].ToString();
  148. model.WebFilePath = dt.Rows[n]["WebFilePath"].ToString();
  149. model.FileName = dt.Rows[n]["FileName"].ToString();
  150. model.FilePath = dt.Rows[n]["FilePath"].ToString();
  151. model.TifFilePath = dt.Rows[n]["TifFilePath"].ToString();
  152. if (dt.Rows[n]["FileSize"].ToString() != "")
  153. {
  154. model.FileSize = int.Parse(dt.Rows[n]["FileSize"].ToString());
  155. }
  156. model.FileType = dt.Rows[n]["FileType"].ToString();
  157. model.Remark = dt.Rows[n]["Remark"].ToString();
  158. if (dt.Rows[n]["CommitTime"].ToString() != "")
  159. {
  160. model.CommitTime = DateTime.Parse(dt.Rows[n]["CommitTime"].ToString());
  161. }
  162. modelList.Add(model);
  163. }
  164. }
  165. return modelList;
  166. }
  167. /// <summary>
  168. /// 获得数据列表
  169. /// </summary>
  170. public DataSet GetAllList()
  171. {
  172. return GetList("");
  173. }
  174. #endregion
  175. }
  176. }