XTZHBLLService.cs 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185
  1. using PMS.Interface.SysManager;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Text;
  6. using PMS.EntityModels.SysManager;
  7. using PMS.DBService.SysManager;
  8. using QWPlatform.IService;
  9. using System.Data;
  10. using QWPlatform.SystemLibrary.Utils;
  11. namespace PMS.BusinessService.SysManager
  12. {
  13. public class XTZHBLLService : IXTZHModel
  14. {
  15. private XTZHDBService XTZHDBService = DataServiceBase.Instance<XTZHDBService>();
  16. /// <summary>
  17. /// 系统账户查找
  18. /// </summary>
  19. /// <param name="iD"></param>
  20. /// <returns></returns>
  21. public DataTable GetSystemUserInfo(int ID)
  22. {
  23. return XTZHDBService.GetSystemUserInfo(ID);
  24. }
  25. /// <summary>
  26. /// 人员信息的查询
  27. /// </summary>
  28. /// <param name="zh"></param>
  29. public string SelectPersonInfo(string zh)
  30. {
  31. var dt = XTZHDBService.SelectPersonInfo(zh);
  32. if (dt.Rows.Count == 0)
  33. {
  34. return "";
  35. }
  36. else
  37. {
  38. return Strings.ObjectToJson(XTZHDBService.SelectPersonInfo(zh), true);
  39. }
  40. }
  41. /// <summary>
  42. /// 获取系统账户姓名
  43. /// </summary>
  44. /// <param name="XM"></param>
  45. /// <returns></returns>
  46. public string UserNameCheck(string XM)
  47. {
  48. return XTZHDBService.UserNameCheck(XM);
  49. }
  50. /// <summary>
  51. /// 系统账户重置密码
  52. /// </summary>
  53. /// <param name="id"></param>
  54. /// <param name="pwd"></param>
  55. public void XGMm(int id, string pwd)
  56. {
  57. XTZHDBService.XGMm(id,pwd);
  58. }
  59. /// <summary>
  60. ///删除系统账户
  61. /// </summary>
  62. /// <param name="id"></param>
  63. public void XtZHDel(int id)
  64. {
  65. XTZHDBService.XtZHDel(id);
  66. }
  67. /// <summary>
  68. /// 更新用户访问渠道项目权限
  69. /// </summary>
  70. /// <param name="id"></param>
  71. /// <param name="authorize">1是,0否</param>
  72. public bool UpdataAuthorize(int id, int authorize)
  73. {
  74. return XTZHDBService.UpdataAuthorize(id, authorize);
  75. }
  76. /// <summary>
  77. /// 系统账户得新增修改
  78. /// </summary>
  79. /// <param name="xtzhModel">系统账户实体</param>
  80. /// <param name="editType">编辑类型</param>
  81. /// <returns></returns>
  82. public string XtZHEdit(XTZHModel xtzhModel, int editType)
  83. {
  84. if (xtzhModel.MM==null)
  85. {
  86. xtzhModel.MM = "1";
  87. }
  88. return XTZHDBService.XtZHEdit(xtzhModel, editType);
  89. }
  90. /// <summary>
  91. /// 获取账户渠道信息
  92. /// </summary>
  93. /// <returns></returns>
  94. public string XtZHGs()
  95. {
  96. DataTable dt = XTZHDBService.XtZHGs();
  97. // dt.Rows.Remove(dt.Rows[0]);
  98. return Strings.ObjectToJson(dt, true);
  99. }
  100. /// <summary>
  101. /// 获取系统账户类型
  102. /// </summary>
  103. /// <returns></returns>
  104. public string XtZHLx()
  105. {
  106. DataTable dt = XTZHDBService.XtZHLx();
  107. dt.Rows.Remove(dt.Rows[2]);
  108. return Strings.ObjectToJson(dt, true);
  109. }
  110. /// <summary>
  111. /// 获取公司下的人员
  112. /// </summary>
  113. /// <param name="gSID"></param>
  114. /// <returns></returns>
  115. public string XtZHRY(string gSID)
  116. {
  117. DataTable dt = XTZHDBService.XtZHRY(gSID);
  118. // dt.Rows.Remove(dt.Rows[0]);
  119. return Strings.ObjectToJson(dt, true);
  120. }
  121. /// <summary>
  122. /// 系统账户得查询
  123. /// </summary>
  124. /// <param name="search"></param>
  125. /// <param name="page"></param>
  126. /// <param name="rows"></param>
  127. /// <returns></returns>
  128. public string XtZHSelect(string search, int page, int rows)
  129. {
  130. int defaultrow = 20;
  131. int start_number = GetStartNumber(page,rows, defaultrow);
  132. int end_number = GetEndNumber(page,rows,defaultrow);
  133. return XTZHDBService.XtZHSelect(search, start_number, end_number);
  134. }
  135. /// <summary>
  136. /// 得到结束行数
  137. /// </summary>
  138. /// <param name="page"></param>
  139. /// <param name="rows"></param>
  140. /// <returns></returns>
  141. private int GetEndNumber(int page, int rows,int defaultrow)
  142. {
  143. try
  144. {
  145. int _pageNum = page == 0 ? 1 : page;
  146. int _pagerows = rows == 0 ? defaultrow : rows;
  147. return (_pageNum * _pagerows);
  148. }
  149. catch (Exception)
  150. {
  151. return 0;
  152. }
  153. }
  154. /// <summary>
  155. /// 开始行数
  156. /// </summary>
  157. /// <param name="page"></param>
  158. /// <param name="rows"></param>
  159. /// <returns></returns>
  160. private int GetStartNumber(int page, int rows, int defaultrow)
  161. {
  162. try
  163. {
  164. int _pageNum = page == 0 ? 1 : page;
  165. int _pagerows = rows == 0 ? defaultrow : rows;
  166. return ((_pageNum - 1) * _pagerows + 1);
  167. }
  168. catch (Exception)
  169. {
  170. return 0;
  171. }
  172. }
  173. }
  174. }