人民医院API

T_Sys_WorkOffDays.cs 5.5KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. namespace RMYY_CallCenter_Api.Bll
  8. {
  9. /// <summary>
  10. /// 休息日表
  11. /// </summary>
  12. public partial class T_Sys_WorkOffDays
  13. {
  14. private readonly RMYY_CallCenter_Api.Dal.T_Sys_WorkOffDays dal = new RMYY_CallCenter_Api.Dal.T_Sys_WorkOffDays();
  15. public T_Sys_WorkOffDays()
  16. { }
  17. #region Method
  18. /// <summary>
  19. /// 增加一条数据
  20. /// </summary>
  21. public int Add(RMYY_CallCenter_Api.Model.T_Sys_WorkOffDays model)
  22. {
  23. return dal.Add(model);
  24. }
  25. /// <summary>
  26. /// 更新一条数据
  27. /// </summary>
  28. public bool Update(RMYY_CallCenter_Api.Model.T_Sys_WorkOffDays model)
  29. {
  30. return dal.Update(model);
  31. }
  32. public bool UpdateState(RMYY_CallCenter_Api.Model.T_Sys_WorkOffDays model)
  33. {
  34. return dal.UpdateState(model);
  35. }
  36. /// <summary>
  37. /// 删除一条数据
  38. /// </summary>
  39. public bool Delete(int F_OffID)
  40. {
  41. return dal.Delete(F_OffID);
  42. }
  43. public bool DeleteByDate(string date, string usercode, DateTime nowdate)
  44. {
  45. return dal.DeleteByDate(date, usercode,nowdate);
  46. }
  47. /// <summary>
  48. /// 删除一条数据
  49. /// </summary>
  50. public bool DeleteList(string F_OffIDlist)
  51. {
  52. return dal.DeleteList(F_OffIDlist);
  53. }
  54. /// <summary>
  55. /// 得到一个对象实体
  56. /// </summary>
  57. public RMYY_CallCenter_Api.Model.T_Sys_WorkOffDays GetModel(int F_OffID)
  58. {
  59. return dal.GetModel(F_OffID);
  60. }
  61. public RMYY_CallCenter_Api.Model.T_Sys_WorkOffDays GetModel(string date)
  62. {
  63. return dal.GetModel(date);
  64. }
  65. /// <summary>
  66. /// 获得数据列表
  67. /// </summary>
  68. public DataSet GetList(string strWhere)
  69. {
  70. return dal.GetList(strWhere);
  71. }
  72. /// <summary>
  73. /// 获得前几行数据
  74. /// </summary>
  75. public DataSet GetList(int Top, string strWhere, string filedOrder)
  76. {
  77. return dal.GetList(Top, strWhere, filedOrder);
  78. }
  79. /// <summary>
  80. /// 获得数据列表
  81. /// </summary>
  82. public List<RMYY_CallCenter_Api.Model.T_Sys_WorkOffDays> GetModelList(string strWhere)
  83. {
  84. DataSet ds = dal.GetList(strWhere);
  85. return DataTableToList(ds.Tables[0]);
  86. }
  87. /// <summary>
  88. /// 获得数据列表
  89. /// </summary>
  90. public List<RMYY_CallCenter_Api.Model.T_Sys_WorkOffDays> DataTableToList(DataTable dt)
  91. {
  92. List<RMYY_CallCenter_Api.Model.T_Sys_WorkOffDays> modelList = new List<RMYY_CallCenter_Api.Model.T_Sys_WorkOffDays>();
  93. int rowsCount = dt.Rows.Count;
  94. if (rowsCount > 0)
  95. {
  96. RMYY_CallCenter_Api.Model.T_Sys_WorkOffDays model;
  97. for (int n = 0; n < rowsCount; n++)
  98. {
  99. model = new RMYY_CallCenter_Api.Model.T_Sys_WorkOffDays();
  100. if (dt.Rows[n]["F_OffID"] != null && dt.Rows[n]["F_OffID"].ToString() != "")
  101. {
  102. model.F_OffID = int.Parse(dt.Rows[n]["F_OffID"].ToString());
  103. }
  104. if (dt.Rows[n]["F_OffDate"] != null && dt.Rows[n]["F_OffDate"].ToString() != "")
  105. {
  106. model.F_OffDate = DateTime.Parse(dt.Rows[n]["F_OffDate"].ToString());
  107. }
  108. if (dt.Rows[n]["F_OffState"] != null && dt.Rows[n]["F_OffState"].ToString() != "")
  109. {
  110. model.F_OffState = int.Parse(dt.Rows[n]["F_OffState"].ToString());
  111. }
  112. if (dt.Rows[n]["F_remark"] != null && dt.Rows[n]["F_remark"].ToString() != "")
  113. {
  114. model.F_remark = dt.Rows[n]["F_remark"].ToString();
  115. }
  116. if (dt.Rows[n]["F_CreateBy"] != null && dt.Rows[n]["F_CreateBy"].ToString() != "")
  117. {
  118. model.F_CreateBy = dt.Rows[n]["F_CreateBy"].ToString();
  119. }
  120. if (dt.Rows[n]["F_CreateOn"] != null && dt.Rows[n]["F_CreateOn"].ToString() != "")
  121. {
  122. model.F_CreateOn = DateTime.Parse(dt.Rows[n]["F_CreateOn"].ToString());
  123. }
  124. if (dt.Rows[n]["F_DeleteBy"] != null && dt.Rows[n]["F_DeleteBy"].ToString() != "")
  125. {
  126. model.F_DeleteBy = dt.Rows[n]["F_DeleteBy"].ToString();
  127. }
  128. if (dt.Rows[n]["F_DeleteOn"] != null && dt.Rows[n]["F_DeleteOn"].ToString() != "")
  129. {
  130. model.F_DeleteOn = DateTime.Parse(dt.Rows[n]["F_DeleteOn"].ToString());
  131. }
  132. modelList.Add(model);
  133. }
  134. }
  135. return modelList;
  136. }
  137. /// <summary>
  138. /// 获得数据列表
  139. /// </summary>
  140. public DataSet GetAllList()
  141. {
  142. return GetList("");
  143. }
  144. /// <summary>
  145. /// 分页获取数据列表
  146. /// </summary>
  147. public int GetRecordCount(string strWhere)
  148. {
  149. return dal.GetRecordCount(strWhere);
  150. }
  151. #endregion Method
  152. }
  153. }