MESWMS-LayUI.git

parent: 3461265c | 补丁 | 提交 | ignore whitespace

仲国强

2021-10-20 bab225bfa7804d1cde3270e772897b8e70cb5e58

列表自动渲染字段示例

1个文件已添加

3个文件已修改

	WebTM/WebTM.csproj	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/layuiadmin/PubCustom.js	41 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/layuiadmin/Scripts/webConfig.js	4 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/test/testRenderAutomationList.html	93 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 WebTM/WebTM.csproj

@@ -111,6 +111,7 @@
    <Content Include="views\PublicPage\Gy_Maintain.html" />
    <Content Include="views\PublicPage\Organizations.html" />
    <Content Include="views\ReportHtml.html" />
    <Content Include="views\test\testRenderAutomationList.html" />
    <Content Include="views\基础资料\公用基础资料\Add_Edit_Gy_Warehouse.html" />
    <Content Include="views\基础资料\公用基础资料\Add_Edit_Xt_ORGANIZATIONSList.html" />
    <Content Include="views\基础资料\公用基础资料\Add_Edit_Gy_Department.html" />

 WebTM/layuiadmin/PubCustom.js

@@ -240,4 +240,43 @@


//#region 折叠注释
//#endregion
//#endregion


/**
 *递入接口result返回list作为option的cols
 *by zgq
 *
 */
function Pub_backTableHead(result) {
    var resultTableHead = [];
    var cols_arr = [];
    for (var key in result.list) {
        resultTableHead.push({ "name": result.list[key].ColmName, "Type": result.list[key].ColmType });
    }
    //填充表格头数组
    var data = resultTableHead;
    cols_arr[0] = [];
    cols_arr[0][0] = { checkbox: true, fixed: true, totalRowText: '合计' };
    cols_arr[0][1] = { type: 'numbers', title: '序号' };
    for (var i = 0; i < data.length; i++) {
        if (data[i].name.indexOf("H") ? 0 : -1 ) {
            cols_arr[0][i + 2] = { field: data[i].name, title: data[i].name, align: 'center', hide: true };
        }
        else {
            switch (data[i].Type) {
                //int
                case 'Int32':
                    cols_arr[0][i + 2] = { field: data[i].name, title: data[i].name, align: 'center', totalRow: true, sort: true };
                    break;
                //Decimal
                case 'Decimal':
                    cols_arr[0][i + 2] = { field: data[i].name, title: data[i].name, align: 'center', totalRow: true, sort: true };
                    break;
                default:
                    cols_arr[0][i + 2] = { field: data[i].name, title: data[i].name, align: 'center', sort: true };
            }
        }
    }
    return cols_arr
}

 WebTM/layuiadmin/Scripts/webConfig.js

@@ -6,13 +6,13 @@
    //var WEBURL = "http://localhost:8080/API/";   //颜晓军本地配置
    //var WEBURL = "http://localhost:8082/lubao";   //颜晓军本地配置
    //var WEBURL = "http://localhost:8082/LuBaoAPI/";    //杨露本地配置
    var WEBURL = "http://localhost:8082/LuBaoAPI/";    //章紫柔本地配置
    //var WEBURL = "http://localhost:8082/LuBaoAPI/";    //章紫柔本地配置
    //var WEBURL = "http://10.1.4.155/API/";   //江丰客户NEW
    //var WEBURL = "http://47.96.97.237/API/";   //智云服务器
    //var WEBURL = "http://183.129.128.86:9090/API/";   //凯贝奈特客户服务器外网
    //var WEBURL = "http://192.168.1.253:8080/API/";   //凯贝奈特客户服务器内网
    //var WEBURL = "http://220.189.218.154:8092/API/";   //丸井四维尔服务器
    //var WEBURL = "http://localhost/API/";
    var WEBURL = "http://localhost/API/";
    return WEBURL
}


 WebTM/views/test/testRenderAutomationList.html

New file
@@ -0,0 +1,93 @@
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>测试自动渲染列表</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../layuiadmin/PubCustom.js"></script>

</head>
<body>
    <div class="layui-fluid">
        <div class="layui-col-md12">
            <div class="layui-card" style="padding: 1px">
                <div class="layui-card-body" style="padding: 1px;">
                    <form class="layui-form" action="" lay-filter="component-form-group">
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                    </form>
                </div>
            </div>
        </div>
    </div>
    <script>
        layui.config({
            base: '../../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index', //主入口模块
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {
            var $ = layui.$
                , layer = layui.layer
                , table = layui.table

            var option = [];
            var cols_arr = [];

            get_Display();

            //#region 查询
            function get_Display() {
                var wait = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Sc_MESReportFrom/ReportFromBillList2',
                    type: "GET",
                    data: { "sWhere": "" },
                    success: function (result) {
                        if (result.code == 1) {
                            cols_arr = Pub_backTableHead(result);
                            set_InitGrid(cols_arr);
                            option.data = result.data;
                            table.render(option);
                            layer.close(wait);
                        } else {
                            layer.close(wait);
                            layer.alert(result.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(wait);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
            //#endregion

            //#region 初始化表格方法
            function set_InitGrid(cols_arr) {
                option = {
                    elem: '#mainTable'
                    //, toolbar: '#toolbarDemo'
                    , height: 'full-50'
                    , page: true
                    , cellMinWidth: 90
                    , cols: cols_arr
                    , totalRow: true
                    , limit: 10
                    , limits: [10, 15, 20, 30, 40, 50, 100, 1000]
                };
            }
            //#endregion



        });
    </script>

</body>
</html>

			@@ -111,6 +111,7 @@
			<Content Include="views\PublicPage\Gy_Maintain.html" />
			<Content Include="views\PublicPage\Organizations.html" />
			<Content Include="views\ReportHtml.html" />
			<Content Include="views\test\testRenderAutomationList.html" />
			<Content Include="views\基础资料\公用基础资料\Add_Edit_Gy_Warehouse.html" />
			<Content Include="views\基础资料\公用基础资料\Add_Edit_Xt_ORGANIZATIONSList.html" />
			<Content Include="views\基础资料\公用基础资料\Add_Edit_Gy_Department.html" />

			@@ -240,4 +240,43 @@


			//#region 折叠注释
			//#endregion
			//#endregion


			/**
			*递入接口result返回list作为option的cols
			*by zgq
			*
			*/
			function Pub_backTableHead(result) {
			var resultTableHead = [];
			var cols_arr = [];
			for (var key in result.list) {
			resultTableHead.push({ "name": result.list[key].ColmName, "Type": result.list[key].ColmType });
			}
			//填充表格头数组
			var data = resultTableHead;
			cols_arr[0] = [];
			cols_arr[0][0] = { checkbox: true, fixed: true, totalRowText: '合计' };
			cols_arr[0][1] = { type: 'numbers', title: '序号' };
			for (var i = 0; i < data.length; i++) {
			if (data[i].name.indexOf("H") ? 0 : -1 ) {
			cols_arr[0][i + 2] = { field: data[i].name, title: data[i].name, align: 'center', hide: true };
			}
			else {
			switch (data[i].Type) {
			//int
			case 'Int32':
			cols_arr[0][i + 2] = { field: data[i].name, title: data[i].name, align: 'center', totalRow: true, sort: true };
			break;
			//Decimal
			case 'Decimal':
			cols_arr[0][i + 2] = { field: data[i].name, title: data[i].name, align: 'center', totalRow: true, sort: true };
			break;
			default:
			cols_arr[0][i + 2] = { field: data[i].name, title: data[i].name, align: 'center', sort: true };
			}
			}
			}
			return cols_arr
			}

			@@ -6,13 +6,13 @@
			//var WEBURL = "http://localhost:8080/API/"; //颜晓军本地配置
			//var WEBURL = "http://localhost:8082/lubao"; //颜晓军本地配置
			//var WEBURL = "http://localhost:8082/LuBaoAPI/"; //杨露本地配置
			var WEBURL = "http://localhost:8082/LuBaoAPI/"; //章紫柔本地配置
			//var WEBURL = "http://localhost:8082/LuBaoAPI/"; //章紫柔本地配置
			//var WEBURL = "http://10.1.4.155/API/"; //江丰客户NEW
			//var WEBURL = "http://47.96.97.237/API/"; //智云服务器
			//var WEBURL = "http://183.129.128.86:9090/API/"; //凯贝奈特客户服务器外网
			//var WEBURL = "http://192.168.1.253:8080/API/"; //凯贝奈特客户服务器内网
			//var WEBURL = "http://220.189.218.154:8092/API/"; //丸井四维尔服务器
			//var WEBURL = "http://localhost/API/";
			var WEBURL = "http://localhost/API/";
			return WEBURL
			}

New file
			@@ -0,0 +1,93 @@
			<!DOCTYPE html>
			<html xmlns="http://www.w3.org/1999/xhtml">
			<head>
			<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
			<title>测试自动渲染列表</title>
			<meta name="renderer" content="webkit">
			<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
			<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
			<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
			<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
			<script src="../../../layuiadmin/layui/layui.js"></script>
			<script src="../../../layuiadmin/Scripts/json2.js"></script>
			<script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
			<script src="../../../layuiadmin/Scripts/webConfig.js"></script>
			<script src="../../layuiadmin/PubCustom.js"></script>

			</head>
			<body>
			<div class="layui-fluid">
			<div class="layui-col-md12">
			<div class="layui-card" style="padding: 1px">
			<div class="layui-card-body" style="padding: 1px;">
			<form class="layui-form" action="" lay-filter="component-form-group">
			<table class="" id="mainTable" lay-filter="mainTable"></table>
			</form>
			</div>
			</div>
			</div>
			</div>
			<script>
			layui.config({
			base: '../../../layuiadmin/' //静态资源所在路径
			}).extend({
			index: 'lib/index', //主入口模块
			}).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {
			var $ = layui.$
			, layer = layui.layer
			, table = layui.table

			var option = [];
			var cols_arr = [];

			get_Display();

			//#region 查询
			function get_Display() {
			var wait = layer.load();
			$.ajax({
			url: GetWEBURL() + '/Sc_MESReportFrom/ReportFromBillList2',
			type: "GET",
			data: { "sWhere": "" },
			success: function (result) {
			if (result.code == 1) {
			cols_arr = Pub_backTableHead(result);
			set_InitGrid(cols_arr);
			option.data = result.data;
			table.render(option);
			layer.close(wait);
			} else {
			layer.close(wait);
			layer.alert(result.Message, { icon: 5 });
			}
			}, error: function () {
			layer.close(wait);
			layer.alert("接口请求失败!", { icon: 5 });
			}
			});
			}
			//#endregion

			//#region 初始化表格方法
			function set_InitGrid(cols_arr) {
			option = {
			elem: '#mainTable'
			//, toolbar: '#toolbarDemo'
			, height: 'full-50'
			, page: true
			, cellMinWidth: 90
			, cols: cols_arr
			, totalRow: true
			, limit: 10
			, limits: [10, 15, 20, 30, 40, 50, 100, 1000]
			};
			}
			//#endregion



			});
			</script>

			</body>
			</html>