123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175 |
- using LeaRun.Application.Entity.WaterWellManage;
- using LeaRun.Data;
- using LeaRun.Util;
- using LeaRun.Util.WebControl;
- using System;
- using System.Collections.Generic;
- using System.Configuration;
- using System.Data;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace LeaRun.Application.Service.WaterWellManage
- {
- public class DeviceInfoService
- {
- SqlHelper sqlHelper = new SqlHelper("WaterWellDb");
- #region 获取子节点
- // 获取子节点
- public List<DeviceInfoEntity> GetMenuList(string manufacturerCode)
- {
- try
- {
- var sql = "select * from WaterWellBase where ManufacturerCode='" + manufacturerCode + "'";
- DataTable dataTable = sqlHelper.ExecuteDataTable(sql, CommandType.Text, null);
- //DataTable 封装成实体集合
- List<DeviceInfoEntity> modelList = DataHelper.DataTableToT<DeviceInfoEntity>(dataTable);
- return modelList;
- }
- catch (Exception)
- {
- throw;
- }
- }
- #endregion
- #region 获取无父元素列表
- /// <summary>
- /// 获取无父元素列表
- /// </summary>
- /// <param name="showcheck"></param>
- /// <returns></returns>
- public List<TreeEntity> GetTreeList(bool showcheck)
- {
- var treeList = new List<TreeEntity>();
- var deviceInfoData = GetMenuList();
- if (deviceInfoData != null && deviceInfoData.ToList().Count > 0)
- {
- foreach (DeviceInfoEntity item in deviceInfoData)
- {
- TreeEntity tree = new TreeEntity();
- tree.id = "dev" + item.WaterWellId.ToString();
- tree.text = item.WaterWellName;
- tree.value = "dev" + item.WaterWellId;
- tree.isexpand = false;
- tree.complete = true;
- tree.hasChildren = false;
- tree.parentId = "0";
- tree.showcheck = showcheck;
- tree.checkstate = 1;
- tree.isexpand = true;
- treeList.Add(tree);
- }
- }
- return treeList;
- }
- #endregion
- #region 无父元素方法
- // 无父元素
- public List<DeviceInfoEntity> GetMenuList()
- {
- try
- {
- var sql = "select * from WaterWellBase ";
- DataTable dataTable = sqlHelper.ExecuteDataTable(sql, CommandType.Text, null);
- //DataTable 封装成实体集合
- List<DeviceInfoEntity> modelList = DataHelper.DataTableToT<DeviceInfoEntity>(dataTable);
- return modelList;
- }
- catch (Exception)
- {
- throw;
- }
- }
- #endregion
- #region 测点名称模糊查询
- /// <summary>
- /// 测点名称查询
- /// </summary>
- /// <param name="name"></param>
- /// <returns></returns>
- public string SearchWaterWellLikeName(string name)
- {
- StringBuilder sb = new StringBuilder(" select WaterWellName from WaterWellBase where WaterWellName like ");
- sb.Append("'%" + name + "%'");
- DataTable dt = sqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, null);
- if (dt.Rows.Count > 0)
- {
- StringBuilder sbResult = new StringBuilder("[");
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- sbResult.Append("\"" + dt.Rows[i]["WaterWellName"].ToString().Trim() + "\"");
- if (i < dt.Rows.Count - 1)
- {
- sbResult.Append(",");
- }
- }
- sbResult.Append("]");
- return sbResult.ToString();
- }
- return "[]"; ;
- }
- #endregion
- #region 测点名称查询
- /// <summary>
- /// 测点名称查询
- /// </summary>
- /// <param name="name"></param>
- /// <returns></returns>
- public string SearchWaterWellName()
- {
- StringBuilder sb = new StringBuilder(" select WaterWellId, WaterWellName from WaterWellBase ");
- DataTable dt = sqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, null);
- if (dt.Rows.Count > 0)
- {
- StringBuilder sbResult = new StringBuilder("[");
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- sbResult.Append("{\"WaterWellName\" : \"" + dt.Rows[i]["WaterWellName"].ToString().Trim() + "\", \"WaterWellId\":\"" + dt.Rows[i]["WaterWellId"] + "\"}");
- if (i < dt.Rows.Count - 1)
- {
- sbResult.Append(",");
- }
- }
- sbResult.Append("]");
- return sbResult.ToString();
- }
- return "[]";
- }
- #endregion
- #region 获取所有测点
- /// <summary>
- /// 获取所有测点
- /// </summary>
- /// <returns></returns>
- public List<DeviceInfoEntity> GetAllDevice()
- {
- string sql = "select WaterWellId, WaterWellName from WaterWellBase";
- try
- {
- DataTable dt = sqlHelper.ExecuteDataTable(sql, CommandType.Text, null);
- return DataHelper.DataTableToT<DeviceInfoEntity>(dt);
- }
- catch (Exception)
- {
- throw;
- }
- }
- #endregion
- }
- }
|