NBDXSY/LeaRun.Application/LeaRun.Application.Service/WaterWellManage/DeviceInfoService.cs

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
    }
}