图片.png

前台

<div id="divShipmentLayout" class="easyui-layout layout easyui-fluid" data-options="fit:true">
    <div id="divWest" data-options="region:'west',split:true" style="padding: 20px; width:25%; height: 100%;" title="" class="panel-body panel-body-noheader layout-body">
        <div class="easyui-panel" style="padding: 5px; width: 100%;">
            <ul class="easyui-tree" id="tt"></ul>
        </div>
    </div>
    <div id="divContainer" data-options="region:'center',split:true" style="padding: 20px; overflow-x: auto; width: 75%; height: 100%;" title="" class="panel-body panel-body-noheader layout-body">
        <div id="tb" class="divTable">
            <div class="divRow">
                <table id="tablestyle">
                    <tr>
                        <td><label style="text-align:right;">名称</label></td>
                        <td><input id="txtBusiness" class="easyui-textbox long textbox-f" style="width:200px;" data-options="required:true,validType:{length:[0,40]}" type="text" value="" textboxname="Business"></td>
                        <td><a id="toolbar_Create_table_TemplateList" onclick="addsever()">创建</a></td>
                        <td><a id="toolbar_Delete_table_TemplateList" onclick="delet()">删除</a></td>
                        <td><a id="toolbar_Update_table_TemplateList" onclick="upadtename()">更新</a></td>
                    </tr>
                </table>
            </div>
        </div>
    </div>
</div>

<script type="text/javascript">
    //构造TreeJson数据
    function convert(rows) {
        function exists(rows, parentId) {
            for (var i = 0; i < rows.length; i++) {
                if (rows[i].id == parentId) return true;
            }
            return false;
        }
        var nodes = [];
        // get the top level nodes 一级
        for (var i = 0; i < rows.length; i++) {
            var row = rows[i];
            if (!exists(rows, row.parentId)) {
                nodes.push({
                    id: row.id,
                    text: row.name
                });
            }
        }
        var toDo = [];
        for (var i = 0; i < nodes.length; i++) {
            toDo.push(nodes[i]);
        }
        while (toDo.length) {
            var node = toDo.shift();    // the parent node
            // get the children nodes
            for (var i = 0; i < rows.length; i++) {
                var row = rows[i];

                if (row.parentId == node.id) {
                    var child = { id: row.id, text: row.name };
                    if (node.children) {
                        node.children.push(child);
                    } else {
                        node.children = [child];
                    }
                    toDo.push(child);
                }
            }
        }
        return nodes;
    }

    $('#toolbar_Create_table_TemplateList').linkbutton({
        iconCls: 'icon-add'
    });
    $('#toolbar_Delete_table_TemplateList').linkbutton({
        iconCls: 'icon-clear'
    });
    $('#toolbar_Update_table_TemplateList').linkbutton({
        iconCls: 'icon-edit'
    });

    var jondatatree;
    //初始化加载树形
    $(function () {
       //$("#divContent").remove();
        $.ajax({
            type: "POST",
            url: window.location.protocol +"//"+ window.location.host+"@resourceHost/@ViewContext.RouteData.Values["Area"].ToString()/@ViewContext.RouteData.Values["Controller"].ToString()/GetTreedata",
            dataType: "json",
            success: function (data) {
                jondatatree = data.Table;
                funtree(data.Table);
            },
            error: function (jqXHR) {
                alert("发生错误：" + jqXHR.status);
            }
        });
        $('#divShipmentLayout').layout('resize', {
            height:  $(window).height() - 232
        });
    });

    //异步刷新
    var quert = function teer ()
    {
        UpperCored = [];
        targetCored = [];
        $.ajax({
            type: "POST",
            url: window.location.protocol + "//" + window.location.host + "@resourceHost/@ViewContext.RouteData.Values["Area"].ToString()/@ViewContext.RouteData.Values["Controller"].ToString()/GetTreedata",
            dataType: "json",
            success: function (data) {
                jondatatree = data.Table;
                funtree(data.Table);
                console.log("loadData");
            }
        })
    }

    //树菜单绑定
    var targetCored = Array();
    var deptid;
    function funtree(data) {
        $('#tt').tree({
            dnd: true,
            animate: true,
            lines: true,
            data: data,
            loadFilter: function (data) {
                return convert(data);
            },
            onClick: function (node) {
                //单击添加
                ThisCored(node.id, node.text);
                targetCored = [];
                targetCored.push(UpperCored[0]);
                //$("#tt").tree("loadData", []); 重新加载
                fixed_appears(node);
                $('#txtBusiness').textbox('setValue', node.text);
                deptid = parseInt(node.id + 1);
            },
            onDragOver: function (target, source) {
                var nodes = $('#tt').tree('getData', target);//更改后的上级节点 target：被放置的目标节点元素。
                ThisCored(nodes.id, nodes.text);
                targetCored = [];
                targetCored.push(UpperCored[0]);
                ThisCored(source.id, source.text);
                console.log(nodes);//上级节点
                console.log(source); //source：被拖拽的源节点
            },
            onDrop: function (node) {
                var nodes = $('#tt').tree('getData', node);
                deptid = parseInt(nodes.id + 1);
                upadte("dnd");
            }
        });
    }

    //点击获取cored 三级节点
    var UpperCored = Array();
    var Name_tex;
    function ThisCored(id, text) {
        debugger;
        treeid = id;
        UpperCored = [];
        for (var i = 0; i < jondatatree.length; i++) {
            var index = i;
            if (jondatatree[index].id == id) {
                id = jondatatree[index].parentId;
                Name_tex = text;
                IE_indexOf(jondatatree[index].Upper_Dept);
                if (treeid == id) {
                    if (UpperCored.indexOf(jondatatree[index].Upper_Dept) == -1) {
                        UpperCored.push(jondatatree[index].Upper_Dept);
                    }
                }
                else {
                    if (UpperCored.indexOf(jondatatree[index].DEPT_CODE) == -1) {
                        UpperCored.push(jondatatree[index].DEPT_CODE);
                    }
                }
                i = -1;
            }
        }
    }

    function IE_indexOf(code) {
        var a = new Array(UpperCored);
        //for ie can't support indexof
        if (!Array.indexOf) {
            Array.prototype.indexOf = function (obj) {
                for (var i = 0; i < this.length; i++) {
                    if (this[i] == obj) {
                        return i;
                    }
                }
                return -1;
            }
        }
        var index_id = a.indexOf(code);
    }

    //删除
    function delet() {
        if (!treeonClick()) {
            $.ajax({
                type: "POST",
                url: window.location.protocol + "//" + window.location.host + "@resourceHost/@ViewContext.RouteData.Values["Area"].ToString()/@ViewContext.RouteData.Values["Controller"].ToString()/DeltDepartmentAndValue/" + UpperCored[0],
                traditional: true,
                success: function (data) {
                    if (data) {
                        quert();
                    }
                },
                error: function () {

                }
            });
        }

    }

    function addsever() {
        if (!treeonClick()) {
            if ($("#txtBusiness").val().toString() == "" || nmetext == $("#txtBusiness").val().toString()) {
                $.messager.alert('@Label.Alert', '存在相同数据', 'warning');
                return;
            }
            var Cored = targetCored;
            var upper_cored;
            var jsondate = {};
            jsondate.Name = $("#txtBusiness").val().toString();
            if (Cored.length == 1) {
                upper_cored = getRanNum();
                jsondate.Dept_Code = upper_cored;
            }
            else {
                upper_cored = Cored.toString();
                jsondate.Dept_Code = upper_cored + '-' + getRanNum();
            }
            jsondate.Upper_Dept = targetCored.toString();
            jsondate.Line_ID = parseInt(deptid);
            var data = [jsondate];
            $.ajax({
                type: "POST",
                url: window.location.protocol + "//" + window.location.host + "@resourceHost/@ViewContext.RouteData.Values["Area"].ToString()/@ViewContext.RouteData.Values["Controller"].ToString()/AddDepartmentAndValue",
                traditional: true,
                dataType: "JSON",
                data: { jsonStr: JSON.stringify(data) },
                success: function (data) {
                    if (data) {
                        quert();
                    }
                }
            });
        }
    }

    //修改  manual 手动  dnd拖动
    function upadte(type) {
        if (!treeonClick()) {
            //当前节点关系 TheCurrent
            var CurrentCored = Array();
            for (var i = 0; i < UpperCored.length; i++) {
                if (i + 1 != UpperCored.length) {
                    CurrentCored.push(UpperCored[i])
                }
                else { break; }
            }
            //改动后节点关系
            var VauleCored = Array();
            if (type == "dnd") {
                VauleCored.push(targetCored);
                VauleCored.push(deptid);
            }
            if (CurrentCored.toString() == VauleCored.toString()) {
                return;
            } else {
                $.ajax({
                    type: "POST",
                    url: window.location.protocol + "//" + window.location.host + "@resourceHost/@ViewContext.RouteData.Values["Area"].ToString()/@ViewContext.RouteData.Values["Controller"].ToString()/UpdateDepartmentAndValue",
                    traditional: true,
                    dataType: "JSON",
                    data: { CurrentCode: CurrentCored.toString(), ChangetCode: VauleCored.toString() },
                    success: function (data) {
                        if (data) {
                            quert();
                        }
                    }
                });

            }
        }
    }

    //修改框
    var X, Y, Nme_Code,nmetext;
    function fixed_appears(node) {
        X = node.target.offsetLeft+65;
        Y = node.target.offsetTop+110;
        nmetext = node.text;
        for (var i = 0; i < jondatatree.length; i++) {
            if (parseInt(node.id) == parseInt(jondatatree[i].id)) {
                Nme_Code = jondatatree[i].DEPT_CODE.toString();
            }
        }
    }

    //修改名称
    function upadtename() {
        if (!treeonClick()) {
            if ($("#txtBusiness").val().toString() == "" || nmetext == $("#txtBusiness").val().toString()) {
                $.messager.alert('@Label.Alert', '未做更改', 'warning');
                return;
            }
            $.ajax({
                type: "POST",
                url: window.location.protocol + "//" + window.location.host + "@resourceHost/@ViewContext.RouteData.Values["Area"].ToString()/@ViewContext.RouteData.Values["Controller"].ToString()/Updatename/" + Nme_Code + "/" + $("#txtBusiness").val().toString(),
                traditional: true,
                success: function (data) {
                    if (data) {
                        quert();
                    }
                }
            });
        }
    }

    function treeonClick() {
        var stuet = false;
        if (typeof (jondatatree) != "undefined") {
            stuet = UpperCored.length > 0 && targetCored.length > 0 ? false : true;
            if (stuet) {
                $.messager.alert('@Label.Alert', '@Message.SelectOneToOperation', 'warning');
            }
        }
        return stuet;
    }

    //节点Cored 生成规则
    function getRanNum() {
        var result = [];
        for (var i = 0; i < 3; i++) {
            var ranNum = Math.ceil(Math.random() * 25);
            result.push(String.fromCharCode(65 + ranNum));
        }
        var num = RndNum(2);
        return result.join('') + num;
    }

    function RndNum(n) {
        var rnd = "";
        for (var i = 0; i < n; i++)
            rnd += Math.floor(Math.random() * 10);
        return rnd;
    }

</script>
<style type="text/css">
    td {
        padding-right: 10px;
    }
</style>

后台Controllers：

using System.Collections.Generic;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using iROCK.Resource;
using iROCK.Foundation.Web;
using iROCK.Entity.Framework;
using iROCK.Interface.Framework;
using System.Globalization;
using System.Linq;
using Newtonsoft.Json;
using System.IO;
using Newtonsoft.Json.Linq;

namespace iROCK.Web.Areas.Framework.Controllers
{
    [Route(WebConst.ROUTE_TEMPLATE_WITH_AREA)]
    [Area(Const.WEB_AREA_FRAMEWORK)]

    public class DepartmentController : WebController
    {
        IDepartmentService m_DepartmentService;
        public DepartmentController(IDepartmentService departmentService, ILoggerFactory loggerFactory) : base(loggerFactory)
        {
            m_DepartmentService = departmentService;
        }

        //json序列化 用接收前台参数
        public class jsondata
        {
            public string Name { get; set; }               //名称
            public string Dept_Code { get; set; }      //当前 编码 Code    
            public string Upper_Dept { get; set; }     //上级编码  Code
            public int? Line_ID { get; set; }               //id
        }

        [HttpPost()]
        [HttpGet()]
        public JsonResult GetDepartments()
        {
            var Departments = m_DepartmentService.GetDepartments(Facility, Site, Language);
            return Json(Departments);
        }


        [HttpPost()]
        [HttpGet()]
        public JsonResult GetGroupName()
        {
            var Departments = m_DepartmentService.GetGroupName(Facility, Site, Language);
            return Json(Departments);
        }

        public IActionResult Index()
        {
            return View();
        }

        [HttpPost()]
        [HttpGet()]
        public string GetTreedata()
        {
            var Departments = m_DepartmentService.GetTreedata(Configuration["ConnectionStrings:DefaultConnection"], Facility, Site, Language);
            return Departments;//Json(Departments);
        }

        [HttpPost()]
        [HttpGet()]
        public bool AddDepartmentAndValue()
        {
            //获取前台json
            string jsondata = Request.Form["jsonStr"];
            var JsonArray = JArray.Parse(jsondata);
            var listArray = JsonArray.ToObject<List<jsondata>>();
            List<object> addlist = listArray.ConvertAll(s => (object)s);
            var Departments = m_DepartmentService.AddDepartmentAndValue(new Department(), addlist, UserID, Facility, Site);
            return Departments;
        }

        [HttpPost("{Dept_Code}")]
        [HttpGet("{Dept_Code}")]
        public bool DeltDepartmentAndValue(string Dept_Code)
        {
            var Departments = m_DepartmentService.DeltDepartmentAndValue(new Department(), Dept_Code, UserID, Facility, Site);
            return Departments;
        }


        [HttpPost()]
        [HttpGet()]
        public bool UpdateDepartmentAndValue()
        {
            //被拖拽的源节点
            string Currentjson = Request.Form["CurrentCode"];
            List<object> CurrentCode = new List<object>(Currentjson.Split(','));

            //目标节点 
            string Changetjson = Request.Form["ChangetCode"];
            List<object> ChangetCode = new List<object>(Changetjson.Split(','));
            var Departments = m_DepartmentService.UpdateDepartmentAndValue(new Department(), CurrentCode, ChangetCode, UserID, Facility, Site);
            return Departments;
        }

        [HttpPost("{Nme_Code}/{txtName}")]
        [HttpGet("{Nme_Code}/{txtName}")]
        public bool Updatename(string Nme_Code,string txtName)
        {
            var Departments = m_DepartmentService.Updatename(new Department(), Nme_Code, txtName, UserID, Facility, Site);
            return Departments;
        }

        public JsonResult GetBusinessType()
        {
            var Departments = m_DepartmentService.GetBusinessType(Facility, Site, Language);
            return Json(Departments);
        }
    }
}

接口实现层 Interface.Implementation

public static string GetTreedata(this IRepository<Department> departmentRepository, string connectString, string facility, string site, string language)
{
    //树形菜单绑定
    string str = $@"
    IF NOT OBJECT_ID(N'Tempdb..#T2') IS NULL
        DROP TABLE #T2;
    SELECT  R.id, DE.DEPT_CODE ,
            VA.MEANING AS name ,
            DE.UPPER_DEPT,
            R1.parentId,
            LINE_ID,
            ISNULL(DE.MODIFY_DATE,ISNULL(VA.MODIFY_DATE,ISNULL(R.MODIFY_DATE,ISNULL(R1.MODIFY_DATE,DE.CREATE_DATE)))) AS UP_DATE
    INTO #T2
    FROM    SY_S_DEPARTMENT DE
            INNER JOIN SY_S_GLOBAL_MULTIPLE_LANGUAGE_VALUE VA ON DE.DEPT_CODE = VA.LOOKUP_VALUE
            INNER JOIN ( SELECT ROW_NUMBER() OVER ( ORDER BY CREATE_DATE,DEPT_CODE ASC ) AS id ,
                                DEPT_CODE,MODIFY_DATE
                            FROM   SY_S_DEPARTMENT
                        ) AS R ON R.DEPT_CODE = DE.DEPT_CODE 
            LEFT JOIN ( SELECT ROW_NUMBER() OVER ( ORDER BY CREATE_DATE,DEPT_CODE ASC ) AS ParentId ,
                                DEPT_CODE,MODIFY_DATE
                            FROM   SY_S_DEPARTMENT
                        ) AS R1 ON R1.DEPT_CODE = DE.UPPER_DEPT
    WHERE   VA.LANGUAGE = '{language}' --'zh-cn'
            AND DE.FACILITY='{facility}'
            AND DE.SITE='{site}'; 
    WITH    menu ( id, name, DEPT_CODE, UPPER_DEPT, parentId,LINE_ID,UP_DATE, Level, px, px2 )
                AS ( SELECT   id ,
                            name ,
                            DEPT_CODE ,
                            UPPER_DEPT ,
                            parentId ,
                            LINE_ID,
                            UP_DATE,
                            0 AS Level ,
                            id px ,
                            CAST(id AS NVARCHAR(4000)) px2
                    FROM     #T2
                    WHERE    parentId IS NULL
                    UNION ALL
                    SELECT   A.id ,
                            A.name ,
                            A.DEPT_CODE ,
                            A.UPPER_DEPT ,
                            A.parentId ,
                            A.LINE_ID,
                            A.UP_DATE,
                            B.Level + 1 ,
                            B.px ,
                            B.px2 + LTRIM(A.id)
                    FROM     #T2 A
                            INNER JOIN menu B ON A.parentId = B.id
                    )
        SELECT  id ,
                name ,
                DEPT_CODE ,
                UPPER_DEPT ,
                CASE WHEN parentId IS NULL AND DEPT_CODE='DO' AND id=1 THEN 0
                        WHEN parentId IS NULL AND DEPT_CODE <>'DO'AND id<>1 THEN 1
                        ELSE parentId
                END AS parentId ,
                LINE_ID,
                Level ,
                px ,
                px2
        FROM    menu
        ORDER BY LINE_ID ASC,UP_DATE DESC;";
    DataSet ds = departmentRepository.ExecuteDataSet(connectString, str.ToString(), null);
    //转json
    string jsondata = string.Empty;
    if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
    {
        var json = ToDictionary(ds);//ToDictionaryList(ds.Tables[0]);
        jsondata = JsonConvert.SerializeObject(json);
    }
    return jsondata;
}

其它就只是增删查改