<!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/layui/lay/modules/util.js"></script>
|
<script src="../../../layuiadmin/Scripts/json2.js"></script>
|
<script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
|
<script src="../../../layuiadmin/Scripts/webConfig2.js"></script>
|
<script src="../../../layuiadmin/zgqCustom/zgqCustom.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">
|
<div class="layui-collapse">
|
<div class="layui-colla-item">
|
<div class="layui-colla-title layui-inline">
|
<div class="layui-inline">
|
<span>更多</span>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label">组托时间</label>
|
<div class="layui-input-block">
|
<input type="date" class="layui-input" id="组托时间">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label">组托单号</label>
|
<div class="layui-input-block">
|
<input type="text" class="layui-input" name="组托单号" id="组托单号">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label">包装单唯一条码</label>
|
<div class="layui-input-block">
|
<input type="text" class="layui-input" name="包装单唯一条码" id="包装单唯一条码" style="margin-top: 10px;">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">组织</label>
|
<div class="layui-input-block" style="margin-left: 120px; width: 185px;">
|
<select name="HOrgID" id="HOrgID" lay-verify="HOrgID" class="ForFilteringSchemes">
|
<!--动态渲染组织-->
|
</select>
|
</div>
|
</div>
|
<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
|
</button>
|
<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
|
|
<div class="layui-colla-content">
|
<div class="layui-inline">
|
<div class="layui-inline">
|
<span></span>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label">包装单号</label>
|
<div class="layui-input-block">
|
<input type="text" class="layui-input" name="包装单号" id="包装单号">
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label">扫码人</label>
|
<div class="layui-input-block">
|
<input type="text" class="layui-input" name="扫码人" id="扫码人">
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
<table class="" id="mainTable" lay-filter="mainTable"></table>
|
<script type="text/html" id="toolbarDemo">
|
<div class="layui-btn-container">
|
<!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>-->
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
|
|
</div>
|
</script>
|
</form>
|
</div>
|
</div>
|
</div>
|
</div>
|
|
<script type="text/html" id="toolBar">
|
<a class="layui-btn layui-btn-xs" lay-event="del" style="background-color: red;">删除</a>
|
</script>
|
<script>
|
layui.config({
|
base: '../../../layuiadmin/' //静态资源所在路径
|
}).extend({
|
index: 'lib/index', //主入口模块
|
}).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','util'], function () {
|
var $ = layui.$
|
, admin = layui.admin
|
, layer = layui.layer
|
, table = layui.table
|
, form = layui.form
|
, element = layui.element
|
, laypage = layui.laypage
|
, laydate = layui.laydate
|
, util = layui.util
|
|
var sWhere = "";
|
|
//初始化界面
|
set_ClearBill();
|
|
//#endregion
|
|
//#region 初始化界面
|
function set_ClearBill() {
|
$("#组托时间").val(Format(new Date(), "yyyy-MM-dd"));
|
|
Organ();
|
|
//初始化表格
|
set_InitGrid();
|
|
//查询
|
get_FastQuery(1);
|
|
|
}
|
//#endregion
|
|
//#region 初始化表格方法
|
function set_InitGrid() {
|
option = {
|
elem: '#mainTable'
|
//, toolbar: '#toolbarDemo', sort: true, hide: true
|
//, height: 'full-50'
|
, cellMinWidth: 90
|
, page: true
|
, limit: 50
|
, limits: [50, 500, 5000, 20000]
|
, cols: [[
|
{ field: '缓存表ID', title: '缓存表ID', sort: true }
|
, { field: '包装单号', title: '包装单号', width: 140, sort: true }
|
, { field: '包装单唯一条码', title: '包装单唯一条码', width: 170, sort: true }
|
, { field: '包装单类型', title: '包装单类型', width: 105, sort: true, hide: true }
|
, { field: '扫码人', title: '扫码人', sort: true }
|
, {
|
field: '扫码时间', title: '组托时间', width: 105, sort: true, templet: function (d) {
|
if (d.扫码时间 == null) {
|
return "";
|
}
|
return util.toDateString(d.扫码时间, "yyyy-MM-dd");
|
}
|
}
|
, { field: '组托单ID', title: '组托单ID', sort: true }
|
, { field: '组托单号', title: '组托单号', width: 155, sort: true }
|
, { field: '组托单类型', title: '组托单类型', width: 105, sort: true }
|
, { toolbar: '#toolBar', width: 65, fixed: 'right' }
|
]]
|
};
|
|
option.data = [];
|
table.render(option);
|
|
|
}
|
//#endregion
|
|
//获取组织
|
function Organ() {
|
//获取登录页组织列
|
$.ajax({
|
type: "get",
|
async: false,
|
url: GetWEBURlLanguage() + "/Web/GetOrganizations",
|
success: function (result) {
|
var Organization = "";
|
if (result.count == 1) { // 说明验证成功了，
|
var data = result.data;
|
for (var i = 0; i < data.length; i++) {
|
Organization += '<option style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>';
|
}
|
$("#HOrgID").append(Organization);
|
$("#HOrgID").val(sessionStorage["OrganizationID"])
|
form.render('select');
|
}
|
layer.closeAll("loading");
|
}
|
|
})
|
}
|
|
//#region 快速过滤
|
function get_FastQuery() {
|
var 组托时间 = $("#组托时间").val();//进站时间
|
var 包装单唯一条码 = $("#包装单唯一条码").val();//包装单唯一条码
|
var 包装单号 = $("#包装单号").val();//包装单号
|
var 组托单号 = $("#组托单号").val();//组托单号
|
var 扫码人 = $("#扫码人").val();//扫码人
|
if (组托时间) {
|
sWhere += " and CONVERT(varchar(100),扫码时间, 23) = '" + 组托时间 + "'";
|
}
|
if (包装单唯一条码) {
|
sWhere += " and 包装单唯一条码 like '%" + 包装单唯一条码 + "%'";
|
}
|
if (包装单号) {
|
sWhere += " and 包装单号 like '%" + 包装单号 + "%'";
|
}
|
if (组托单号) {
|
sWhere += " and 组托单号 like '%" + 组托单号 + "%'";
|
}
|
if (扫码人) {
|
sWhere += " and 扫码人 like '%" + 扫码人 + "%'";
|
}
|
|
sWhere += getOrgIDByUser();//用户关联组织查询过滤
|
|
get_Display(sWhere);
|
sWhere = "";//调用接口后清空sWhere缓存
|
}
|
//#endregion
|
|
//#region 查询
|
function get_Display(sWhere) {
|
var ajaxLoad = layer.load();
|
$.ajax({
|
url: GetWEBURL() + '/GroupOrderBill/CacheList',
|
type: "GET",
|
data: { "sWhere": sWhere },
|
success: function (data1) {
|
if (data1.count == 1) {
|
var data = [];
|
var col = [];
|
var totalArray = [];
|
//给空的数组赋值
|
for (var key in data1.list) {
|
data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
|
}
|
//在列表左边添加勾选框
|
col.push({ type: 'checkbox', fixed: 'left' });
|
for (var i = 0; i < data.length; i++) {
|
if ($.inArray(data[i].name, titleData) > -1) {
|
col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
|
} else if ($.inArray(data[i].name, totalArray) > -1) { //计算列
|
col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, totalRow: true, width: 120 });
|
} else {
|
switch (data[i].Type) {
|
//int
|
case 'DateTime':
|
col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
|
break;
|
case 'long':
|
case 'Int32':
|
case 'Int64':
|
case 'double':
|
case 'Decimal':
|
col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 120, totalRow: true });
|
break;
|
default:
|
col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 200 });
|
}
|
}
|
}
|
|
//动态显示列名
|
option = {
|
elem: '#mainTable'
|
/* , toolbar: '#toolbarDemo'*/
|
, cols: [col]
|
, data: data1.data
|
, height: 'full-80'
|
, page: true
|
, limits: [50, 500, 5000, 20000]
|
, limit: 50
|
, totalRow: true
|
, cellMinWidth: 90
|
|
}
|
layer.close(ajaxLoad);
|
} else {
|
layer.close(ajaxLoad);
|
layer.alert(data1.code + data1.Message, { icon: 5 });
|
}
|
}, error: function () {
|
layer.close(ajaxLoad);
|
layer.alert("接口请求失败!", { icon: 5 });
|
}
|
});
|
}
|
//#endregion
|
|
|
|
//监听表格中行工具事件
|
table.on('tool(mainTable)', function (obj) { //注：tool 是工具条事件名，test 是 table 原始容器的属性 lay-filter="对应的值"
|
var data = obj.data //获得当前行数据
|
, layEvent = obj.event; //获得 lay-event 对应的值
|
if (layEvent === 'detail') {
|
layer.msg('查看操作');
|
} else if (layEvent === 'del') {
|
layer.confirm('真的删除行么', function (index) {
|
$.ajax({
|
url: GetWEBURL() + '/GroupOrderBill/DelCacheList',
|
type: "GET",
|
data: { "sHitemID": obj.data.缓存表ID },
|
success: function (data) {
|
if (data.count == 1) {
|
layer.close(index);
|
obj.del(); //删除对应行（tr）的DOM结构
|
layer.msg('删除成功');
|
} else {
|
layer.alert(data.code + data.msg, { icon: 5 });
|
}
|
}, error: function () {
|
layer.msg("接口请求失败!", {
|
icon: 5, btn: ['确认'], time: 100000, offset: 't',
|
skin: 'layui-layer-lan', title: "温馨提示"
|
});
|
}
|
});
|
});
|
} else if (layEvent === 'edit') {
|
layer.msg('编辑操作');
|
}
|
});
|
|
|
|
//重置按钮
|
form.on('submit(btnReSearch)', function (data) {
|
$("#组托时间").val("");//进站时间
|
$("#包装单唯一条码").val("");//包装单唯一条码
|
$("#包装单号").val("");//包装单号
|
$("#组托单号").val("");//组托单号
|
$("#扫码人").val("");//扫码人
|
$("#HOrgID").val(sessionStorage["OrganizationID"]);
|
$("#btnSearch").click();
|
});
|
|
//查询按钮
|
form.on('submit(btnSearch)', function (data) {//选择仓位
|
get_FastQuery();
|
});
|
|
|
//#region 根据用户获取用户关联组织的过滤条件
|
function getOrgIDByUser() {
|
var res = "";
|
$.ajax({
|
type: "GET",
|
async: false,
|
url: GetWEBURlLanguage() + "/Xt_User/getOrgIDListByUser", //方法所在页面和方法名 传参 组织必须是列表头部查询的组织 不能使用用户默认
|
data: { "UserID": sessionStorage["Czybm"], "UserName": sessionStorage["HUserName"], HOrgID: $("#HOrgID").val() },
|
success: function (result) {
|
if (result.count == 1) {
|
if (result.data[0].sWhere == "1") {
|
res = " and HSTOCKORGID = '" + $("#HOrgID").val() + "'";
|
} else {
|
res = result.data[0].sWhere;
|
}
|
}
|
}, error: function (err) {
|
res = " and 1 = 0";
|
layer.alert("接口请求失败!", { icon: 5 });
|
}
|
});
|
return res;
|
}
|
//#endregion
|
|
|
//以上是layui模块
|
});
|
|
|
|
|
</script>
|
|
</body>
|
</html>
|
