SecController.cs 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219
  1. using Cksoft.Data;
  2. using Cksoft.Data.Repository;
  3. using DllEapDal;
  4. using DllEapEntity;
  5. using DllEapEntity.Dtos;
  6. using Microsoft.AspNetCore.Mvc;
  7. using System;
  8. using System.Collections.Generic;
  9. using System.Text;
  10. using System.Linq;
  11. using Cksoft.Unity;
  12. using Cksoft.Unity.Log4NetConfig;
  13. using Microsoft.AspNetCore.Authorization;
  14. namespace DllEapBll.Controllers
  15. {
  16. /// <summary>
  17. /// 标准参数管理
  18. /// </summary>
  19. [Authorize]
  20. [ApiController]
  21. [Route("eap/api/[controller]/[action]")]
  22. public class SecController : ControllerBase
  23. {
  24. /// <summary>
  25. /// 列表
  26. /// </summary>
  27. /// <param name="filter"></param>
  28. /// <param name="pageIndex"></param>
  29. /// <param name="pageSize"></param>
  30. /// <param name="sortField"></param>
  31. /// <param name="sortOrder"></param>
  32. /// <returns></returns>
  33. [HttpGet]
  34. public LayuiModel<Sec> Get(string filter, int pageIndex = 1, int pageSize = 10, string sortField = "ID", string sortOrder = "ascend")
  35. {
  36. if (sortOrder == "descend")
  37. {
  38. sortOrder = "desc";
  39. }
  40. else
  41. {
  42. sortOrder = "asc";
  43. }
  44. int start, end;
  45. start = (pageIndex - 1) * pageSize + 1;
  46. end = start + pageSize;
  47. using (IDatabase db = DbFactory.Base("eapslave"))
  48. {
  49. db.BeginTrans();
  50. var dal = new SecDal(db);
  51. // var total = dal.GetCount(filter);
  52. string errorinfo = string.Empty;
  53. var roles = dal.GetSecs(filter, ref errorinfo);
  54. var total = roles.Count();
  55. return new LayuiModel<Sec>
  56. {
  57. code = 1,
  58. count = total,
  59. data = roles,
  60. msg = ""
  61. };
  62. }
  63. }
  64. /// <summary>
  65. /// 分页列表
  66. /// </summary>
  67. /// <param name="filter"></param>
  68. /// <param name="pageIndex"></param>
  69. /// <param name="pageSize"></param>
  70. /// <param name="sortField"></param>
  71. /// <param name="sortOrder"></param>
  72. /// <returns></returns>
  73. [HttpGet]
  74. public LayuiModel<Sec> GetPaged(string filter, int pageIndex = 1, int pageSize = 10, string sortField = "ID", string sortOrder = "ascend")
  75. {
  76. if (sortOrder == "descend")
  77. {
  78. sortOrder = "desc";
  79. }
  80. else
  81. {
  82. sortOrder = "asc";
  83. }
  84. int start, end;
  85. start = (pageIndex - 1) * pageSize + 1;
  86. end = start + pageSize;
  87. using (IDatabase db = DbFactory.Base("eapslave"))
  88. {
  89. db.BeginTrans();
  90. var dal = new SecDal(db);
  91. // var total = dal.GetCount(filter);
  92. string errorinfo = string.Empty;
  93. var roles = dal.Get(start, pageSize, sortOrder, sortField, filter, errorinfo);
  94. var total = dal.GetCount(filter);
  95. return new LayuiModel<Sec>
  96. {
  97. code = 1,
  98. count = total,
  99. data = roles,
  100. msg = ""
  101. };
  102. }
  103. }
  104. /// <summary>
  105. /// 详情
  106. /// </summary>
  107. /// <param name="id"></param>
  108. /// <returns></returns>
  109. [HttpGet]
  110. public Sec GetSingle(int id)
  111. {
  112. using (IDatabase db = DbFactory.Base("eapslave"))
  113. {
  114. var dal = new SecDal(db);
  115. return dal.Get(id);
  116. }
  117. }
  118. /// <summary>
  119. /// 新增/修改
  120. /// </summary>
  121. /// <param name="programMst"></param>
  122. /// <returns></returns>
  123. [HttpPost]
  124. public EapResponse Add([FromBody] Sec programMst)
  125. {
  126. string usercode = Request.Headers["usercode"];
  127. using (IDatabase db = DbFactory.Base("eap"))
  128. {
  129. db.BeginTrans();
  130. var dal = new SecDal(db);
  131. string errorinfo = string.Empty;
  132. var response = new EapResponse() { Code = 1, Msg = string.Empty };
  133. int id = -1;
  134. if (programMst.ID == 0)
  135. {
  136. id = dal.Add(programMst, usercode, ref errorinfo);
  137. }
  138. else
  139. {
  140. id = dal.Update(programMst, usercode, ref errorinfo);
  141. }
  142. if (id < 0)
  143. {
  144. db.Rollback();
  145. response.Code = -1;
  146. response.Msg = errorinfo;
  147. }
  148. else
  149. {
  150. db.Commit();
  151. if (programMst.ID == 0)
  152. {
  153. LogHelper<Sec>.LogFatal("新增Sec-->" + Json.ToJson(programMst), "用户操作", usercode);
  154. }
  155. else
  156. LogHelper<Sec>.LogFatal("修改Sec-->" + Json.ToJson(programMst), "用户操作", usercode);
  157. }
  158. response.Id = id;
  159. return response;
  160. }
  161. }
  162. /// <summary>
  163. /// 删除
  164. /// </summary>
  165. /// <param name="id"></param>
  166. /// <returns></returns>
  167. [HttpPost]
  168. public EapResponse Delete([FromBody] int id)
  169. {
  170. IDatabase db = null;
  171. string errormsg = string.Empty;
  172. try
  173. {
  174. db = DbFactory.Base("eap");
  175. var dal = new SecDal(db);
  176. db.BeginTrans();
  177. var model = dal.Get(id);
  178. var res = dal.Delete(id, ref errormsg);
  179. if (res < 0)
  180. {
  181. db.Rollback();
  182. return new EapResponse()
  183. {
  184. Code = -1,
  185. Msg = errormsg
  186. };
  187. }
  188. db.Commit();
  189. LogHelper<Sec>.LogFatal("删除Sec-->:" + Json.ToJson(model), "用户操作", Request.Headers["usercode"]);
  190. return new EapResponse()
  191. {
  192. Code = 1,
  193. Msg = ""
  194. };
  195. }
  196. catch (Exception e)
  197. {
  198. errormsg = e.Message;
  199. return new EapResponse
  200. {
  201. Code = -1,
  202. Msg = errormsg
  203. };
  204. }
  205. finally
  206. {
  207. if (db != null)
  208. db.Close();
  209. }
  210. }
  211. }
  212. }