AlarmHisService.cs 745 B

1234567891011121314151617181920212223242526272829
  1. using LeaRun.Application.Code;
  2. using LeaRun.Application.Entity.NBManage;
  3. using LeaRun.Data;
  4. using System;
  5. using System.Collections.Generic;
  6. using System.Data;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Threading.Tasks;
  10. namespace LeaRun.Application.Service.NBManage
  11. {
  12. public class AlarmHisService
  13. {
  14. SqlHelper sqlHelper = new SqlHelper("NBDB");
  15. /// <summary>
  16. /// 查询所有的报警类型
  17. /// </summary>
  18. /// <returns></returns>
  19. public DataTable GetAllAlermTypes()
  20. {
  21. string selSql = "SELECT * FROM dbo.RMRS_AlarmType";
  22. DataTable dtResult = sqlHelper.ExecuteDataTable(selSql,CommandType.Text,null);
  23. return dtResult;
  24. }
  25. }
  26. }