NBDXSY/LeaRun.Application/LeaRun.Application.Web/Areas/JiangSuWaterResource/Controllers/AreaAndDeviceController.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using LeaRun.Application.Busines.JiangSuWaterResource;
using LeaRun.Util.WebControl;
using LeaRun.Application.Entity.JiangSuWaterResource;
using LeaRun.Util;
using System.Data;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

namespace LeaRun.Application.Web.Areas.JiangSuWaterResource.Controllers
{
    public class AreaAndDeviceController : MvcControllerBase
    {
        AreaAndDeviceBLL bll = new AreaAndDeviceBLL();

        /// <summary>
        /// 区域列表
        /// </summary>
        /// <returns></returns>
        public ActionResult AreaIndex()
        {
            return View();
        }

        /// <summary>
        /// 区域Form
        /// </summary>
        /// <returns></returns>
        public ActionResult AreaForm()
        {
            return View();
        }

        /// <summary>
        /// 百度地图
        /// </summary>
        /// <returns></returns>
        public ActionResult BaiDuMap()
        {
            return View();
        }

        /// <summary>
        /// 测点列表
        /// </summary>
        /// <returns></returns>
        public ActionResult MeterList()
        {
            return View();
        }

        /// <summary>，
        /// 获取Grid表格数据
        /// </summary>
        /// <param name="pagination"></param>
        /// <param name="keyWord"></param>
        /// <returns></returns>
        public ActionResult GetAreaGridData(Pagination pagination, string keyWord)
        {
            var areas = bll.GetAreaListByPage(pagination, keyWord);

            var watch = CommonHelper.TimerStart();

            var JsonData = new
            {
                rows = areas,
                total = pagination.total,
                page = pagination.page,
                records = pagination.records,
                costtime = CommonHelper.TimerEnd(watch)
            };

            return Content(JsonData.ToJson());
        }


        /// <summary>
        /// 区域列表
        /// </summary>
        /// <returns></returns>
        public ActionResult GetAreaTreeJson(bool showcheck = false, int checkstate = 0)
        {
            var areas = bll.GetAreaList();

            var treeList = new List<TreeEntity>();

            foreach (var item in areas)
            {
                var tree = new TreeEntity();
                tree.id = item.id.ToString();
                tree.text = item.名称;
                tree.isexpand = true;
                tree.complete = true;
                tree.hasChildren = areas.Count(t => t.上级id == item.id) == 0 ? false : true;
                tree.parentId = item.上级id.ToString();
                tree.value = item.id.ToString();
                tree.showcheck = showcheck;
                tree.checkstate = checkstate;
                tree.img = "fa fa-institution";
                tree.Attribute = "areaLevel";//自定义属性
                tree.AttributeValue = item.级别id.ToString();//自定义属性值
                treeList.Add(tree);
            }
            return Content(treeList.TreeToJson("0"));
        }

        /// <summary>
        /// 测点列表
        /// </summary>
        /// <returns></returns>
        public ActionResult GetMeterTreeJson(bool showcheck = false, int checkstate = 0)
        {
            var areas = bll.GetAreaList();

            var treeList = new List<TreeEntity>();

            foreach (var item in areas)
            {
                var tree = new TreeEntity();
                tree.id = "GL-" + item.id.ToString();
                tree.text = item.名称;
                tree.isexpand = true;
                tree.complete = true;
                tree.hasChildren = true;
                tree.parentId = "GL-" + item.上级id.ToString();
                tree.value = item.id.ToString();
                tree.showcheck = showcheck;
                tree.checkstate = checkstate;
                tree.img = "fa fa-institution";
                tree.Attribute = "areaLevel";//自定义属性
                tree.AttributeValue = item.级别id.ToString();//自定义属性值
                treeList.Add(tree);
            }

            DataTable dtResult = bll.GetMeterList();

            for (int row = 0; row < dtResult.Rows.Count; row++)
            {
                var tree = new TreeEntity();
                tree.id = "CD-" + dtResult.Rows[row]["ID"].ToString();
                tree.text = dtResult.Rows[row]["名称"].ToString();
                tree.isexpand = true;
                tree.complete = true;
                tree.hasChildren = false;
                tree.parentId = "GL-" + dtResult.Rows[row]["管理ID"].ToString();
                tree.value = "CD-" + dtResult.Rows[row]["ID"].ToString();
                tree.showcheck = showcheck;
                tree.checkstate = checkstate;
                tree.img = "fa fa-gear";
                tree.Attribute = "areaLevel";//自定义属性
                tree.AttributeValue = "4";//自定义属性值
                treeList.Add(tree);
            }

            return Content(treeList.TreeToJson("GL-0"));
        }

        /// <summary>
        /// 保存区域
        /// </summary>
        /// <returns></returns>
        public ActionResult SaveAreaForm(string keyWord, string areaJson, string lng, string lat)
        {
            Area area = areaJson.ToObject<Area>();
            //新增区域
            if (string.IsNullOrEmpty(keyWord))
            {
                bll.SaveArea(area, lng, lat);
                return Success("保存成功！");
            }
            //更新区域
            else
            {
                return Success("保存成功！");
            }
        }

        /// <summary>
        /// 测点列表
        /// </summary>
        /// <param name="pagination">分页参数</param>
        /// <param name="managerId">管理ID</param>
        /// <param name="meterName">测点名称</param>
        /// <param name="yingshou">营收账号</param>
        /// <returns></returns>
        public ActionResult GetGridMeterList(Pagination pagination, string managerId = "", string meterName = "", string yingshou = "")
        {
            var data = bll.GetGridMeterList(pagination, managerId, meterName, yingshou);

            var watch = CommonHelper.TimerStart();

            var JsonData = new
            {
                rows = data,
                total = pagination.total,
                page = pagination.page,
                records = pagination.records,
                costtime = CommonHelper.TimerEnd(watch)
            };

            return Content(JsonData.ToJson());
        }

        /// <summary>
        /// 添加测点
        /// </summary>
        /// <returns></returns>
        public ActionResult MeterForm()
        {
            return View();
        }


        /// <summary>
        /// 获取组网方式
        /// </summary>
        /// <returns></returns>
        public ActionResult GetNetworks()
        {
            string zuWangXmlPaht = Config.GetValue("JS_ZuWang");
            zuWangXmlPaht = System.Web.HttpContext.Current.Server.MapPath(zuWangXmlPaht);
            DataTable dtZuWang = XmlHelper.XmlAnalysisArray(zuWangXmlPaht);
            if (dtZuWang != null)
            {
                var treeList = new List<TreeEntity>();
                for (int row = 0; row < dtZuWang.Rows.Count; row++)
                {
                    TreeEntity tree = new TreeEntity();
                    bool hasChildren = false;
                    tree.id = dtZuWang.Rows[row]["值"].ToString();
                    tree.text = dtZuWang.Rows[row]["名称"].ToString();
                    tree.value = dtZuWang.Rows[row]["值"].ToString();
                    tree.isexpand = true;
                    tree.complete = true;
                    tree.parentId = "0";
                    tree.hasChildren = hasChildren;
                    treeList.Add(tree);
                }
                return Content(treeList.TreeToJson());
            }
            return Content("");
        }

        /// <summary>
        /// type 0 （用户站 终端类型） 1 （通讯设备 设备协议） 2（传输设备 传输协议） 其他 全部查询
        /// </summary>
        /// <param name="types"></param>
        /// <returns></returns>
        public ActionResult GetTerminalTypes(string types)
        {
            DataTable dtReuslt = bll.GetTerminalTypes(types);
            if (dtReuslt != null)
            {
                var treeList = new List<TreeEntity>();
                for (int row = 0; row < dtReuslt.Rows.Count; row++)
                {
                    TreeEntity tree = new TreeEntity();
                    bool hasChildren = false;
                    tree.id = dtReuslt.Rows[row]["ID"].ToString();
                    tree.text = dtReuslt.Rows[row]["模板名称"].ToString();
                    tree.value = dtReuslt.Rows[row]["ID"].ToString();
                    tree.isexpand = true;
                    tree.complete = true;
                    tree.parentId = "0";
                    tree.hasChildren = hasChildren;
                    treeList.Add(tree);
                }
                return Content(treeList.TreeToJson());
            }
            return Content("");
        }

        /// <summary>
        /// 获取数据通道
        /// </summary>
        /// <returns></returns>
        public ActionResult GetDataChannele(string chanlName)
        {
            DataTable dtReuslt = bll.GetDataChannele(chanlName);
            if (dtReuslt != null)
            {
                var treeList = new List<TreeEntity>();
                for (int row = 0; row < dtReuslt.Rows.Count; row++)
                {
                    TreeEntity tree = new TreeEntity();
                    bool hasChildren = false;
                    tree.id = dtReuslt.Rows[row]["ID"].ToString();
                    tree.text = dtReuslt.Rows[row]["通道参数"].ToString();
                    tree.value = dtReuslt.Rows[row]["ID"].ToString();
                    tree.isexpand = true;
                    tree.complete = true;
                    tree.parentId = "0";
                    tree.hasChildren = hasChildren;
                    treeList.Add(tree);
                }
                return Content(treeList.TreeToJson());
            }
            return Content("");
        }

        /// <summary>
        /// 通道服务
        /// </summary>
        /// <returns></returns>
        public ActionResult ChanneleForm()
        {
            return View();
        }
    }
}