<!DOCTYPE html>
|
<html>
|
<head>
|
<meta 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.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
|
<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
|
<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
|
<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
|
<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>
|
<!--<style>
|
.main-btn { /*头部主按钮*/
|
padding: 0 2px; /*调整按钮左右空隙大小*/
|
height: 30px;
|
line-height: 30px;
|
}
|
|
.btn-title {
|
font-size: 16px;
|
}
|
/* 防止下拉框的下拉列表被隐藏---必须设置--- */
|
.layui-table-cell {
|
overflow: visible !important;
|
}
|
/* 使得下拉框与单元格刚好合适 */
|
td .layui-form-select {
|
margin-top: -10px;
|
margin-left: -15px;
|
margin-right: -15px;
|
}
|
|
.layui-form-item .layui-inline {
|
margin-top: 5px;
|
margin-bottom: 5px;
|
margin-right: 0px;
|
}
|
|
.layui-form-label {
|
width: 25%;
|
}
|
</style>-->
|
|
</head>
|
<body>
|
<div class="layui-fluid" style="padding: 0;">
|
<div class="layui-card" style="padding: 2px;background-color: #efefef;">
|
<div class="layui-card-body" style="padding: 1px;">
|
<form class="layui-form" action="" lay-filter="formData" style="background-color:white;">
|
<div style="padding: 2px; ">
|
<!--<button type="button" id="btnSearch" style="margin-left: 0px" class="layui-btn layui-btn-normal" lay-submit="" lay-filter="btnSearch" >预览</button>
|
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">新增</button>
|
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">修改</button>-->
|
|
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">保存</button>
|
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnEdit" id="btnEdit">退出</button>
|
<!--<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="set_CheckBill" id="set_CheckBill">审核</button>
|
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="set_AbandonCheck" id="set_AbandonCheck">反审核</button>
|
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="set_CloseBill" id="set_CloseBill">关闭</button>
|
<button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="set_CancelCloseBill" id="set_CancelCloseBill">反关闭</button>-->
|
</div>
|
<div class="layui-tab" lay-filter="tab-POStockInBill">
|
<ul class="layui-tab-title" lay-filter="tab-all">
|
<li lay-id="1" style="padding:1px;" class="layui-this">基本信息</li>
|
<li lay-id="2" style="padding:1px;">其他信息</li>
|
</ul>
|
<div class="layui-tab-content">
|
<!--基本信息-->
|
<div class="layui-tab-item layui-show">
|
<div class="layui-form-item" style="padding-top: 10px;">
|
<div class="layui-row">
|
<div class="layui-inline" style="width:500px;">
|
<label class="layui-form-label" style="width: 85px;">单据号<label style="color:red"> * </label></label>
|
<div class="layui-input-block" style="margin-left: 120px; width: 180px;">
|
<input type="text" class="layui-input" name="HBillNo" lay-verify="HBillNo" id="HBillNo" style="background-color:#efefef4d;" readonly>
|
<input type="hidden" name="HInterID" id="HInterID" lay-verify="HInterID">
|
</div>
|
</div>
|
<div class="layui-inline" style="width:500px;">
|
<label class="layui-form-label" style="width: 85px;">日期<label style="color:red"> * </label></label>
|
<div class="layui-input-block" style="margin-left: 120px; width:180px;">
|
<input type="date" class="layui-input" lay-verify="HDate" name="HDate" id="HDate" style="padding-left: 80px;">
|
</div>
|
</div>
|
<div class="layui-inline" style="width:500px;">
|
<label class="layui-form-label" style="width: 85px;">内部单据号</label>
|
<div class="layui-input-block" style="margin-left: 120px; width: 180px;">
|
<input type="text" class="layui-input" lay-verify="HInnerBillNo" name="HInnerBillNo" id="HInnerBillNo">
|
</div>
|
</div>
|
</div>
|
<div class="layui-row">
|
<div class="layui-inline" style="width:500px;">
|
<label class="layui-form-label" style="width: 85px;padding: 9px 18px;">班组<label style="color:red"> * </label></label>
|
<div class="layui-input-block" style="margin-left: 77px; width: 270px;">
|
<input type="text" class="layui-input" lay-verify="HGroupName" name="HGroupName" id="HGroupName" style="background-color: #efefef4d; width: 180px; display: inline-block;" readonly>
|
<input type="hidden" name="HGroupID" id="HGroupID" lay-verify="HGroupID" value="0">
|
<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchHGroup" id="btnSearchHGroup" style="padding: 0 10px;float: right;margin-right: 3px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
|
</button>
|
</div>
|
</div>
|
<div class="layui-inline" style="width:500px;">
|
<label class="layui-form-label" style="width: 85px;padding: 9px 18px;">部门<label style="color:red"> * </label></label>
|
<div class="layui-input-block" style="margin-left: 77px; width: 270px;">
|
<input type="text" class="layui-input" lay-verify="HDeptName" name="HDeptName" id="HDeptName" style="background-color: #efefef4d; width: 180px; display: inline-block;" readonly>
|
<input type="hidden" name="HDeptID" id="HDeptID" lay-verify="HDeptID" value="0">
|
<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchHDept" id="btnSearchHDept" style="padding: 0 10px;float: right;margin-right: 3px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
|
</button>
|
</div>
|
</div>
|
</div>
|
<div class="layui-row">
|
<div class="layui-inline" style="width:1000px;">
|
<label class="layui-form-label" style="width: 85px;">摘要</label>
|
<div class="layui-input-block" style="margin-left: 120px; width: 685px;">
|
<input type="text" class="layui-input" lay-verify="HExplanation" name="HExplanation" id="HExplanation">
|
</div>
|
</div>
|
</div>
|
<div class="layui-row">
|
<div class="layui-inline" style="width:1500px;">
|
<label class="layui-form-label" style="width: 85px;">备注</label>
|
<div class="layui-input-block" style="margin-left: 120px; width: 800px;">
|
<input type="text" class="layui-input" lay-verify="HRemark" name="HRemark" id="HRemark" style="width:1185px;">
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
<!--其他信息-->
|
<div class="layui-tab-item">
|
<div class="layui-form-item">
|
<div class="layui-row">
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">制单人</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HMaker" id="HMaker" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">修改人</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HUpdater" id="HUpdater" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">审核人</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HChecker" id="HChecker" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
|
</div>
|
<div class="layui-row">
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">制单日期</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HMakerDate" id="HMakerDate" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">修改日期</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HUpdaterDate" id="HUpdaterDate" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">审核日期</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HCheckerDate" id="HCheckerDate" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
</div>
|
<div class="layui-row">
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">关闭人</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HCloseMan" id="HCloseMan" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">作废人</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HDeleteMan" id="HDeleteMan" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">退回人</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HBacker" id="HBacker" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
</div>
|
<div class="layui-row">
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">关闭日期</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HCloseManDate" id="HCloseManDate" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">作废日期</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HDeleteManDate" id="HDeleteManDate" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">退回日期</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HBackerDate" id="HBackerDate" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
</div>
|
<div class="layui-row">
|
<div class="layui-inline">
|
<label class="layui-form-label" style="width: 85px;">退回原因</label>
|
<div class="layui-input-block" style="margin-left: 120px;">
|
<input type="text" class="layui-input" name="HBackRemark" id="HBackRemark" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
<table class="layui-hide" 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-AddLine"><i class="layui-icon layui-icon-form"></i>增加一行</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-CopyLine"><i class="layui-icon layui-icon-form"></i>复制一行</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
|
<!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn_up"><i class="layui-icon layui-icon-form"></i>上一行</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn_under"><i class="layui-icon layui-icon-form"></i>下一行</button>-->
|
</div>
|
</script>
|
</form>
|
</div>
|
</div>
|
</div>
|
<!--子表：删除-->
|
<script type="text/html" id="barDemo">
|
<!--<a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a>-->
|
<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
|
</script>
|
<script>
|
|
layui.config({
|
base: '../../../layuiadmin/' //静态资源所在路径
|
}).extend({
|
index: 'lib/index' //主入口模块
|
}).use(['index', 'form', 'laydate', 'table', 'element'], function () {
|
//#region 公共变量
|
var $ = layui.$
|
, admin = layui.admin
|
, layer = layui.layer
|
, table = layui.table
|
, form = layui.form
|
, element = layui.element
|
, laydate = layui.laydate;
|
|
//模块名
|
var HModName = "Pay_DuSubsidyItemBill_KS";
|
//表格渲染参数
|
var option = {}; //子表渲染参数
|
//获取参数
|
var params = getUrlVars();
|
var OperationType = params[params[0]]; //从参数中获取 数据类型 1添加 保存 2复制 3 编辑
|
var linterid = params[params[1]]; //从参数中获取 单据内码
|
|
//#endregion
|
|
//#region 进入页面即加载
|
//#region 判断是否登录 未登录则跳到登录页
|
if (sessionStorage.login != "login") {
|
layer.confirm("登录失效，请重新登录！", {
|
icon: 4, skin: 'layui-layer-lan', title: "温馨提示", closeBtn: 0, btn: ['重新登录']
|
}, function () { window.location.href = "../../user/login.html"; });
|
}
|
//#endregion
|
|
//#region 判断并设置操作类型、页面初始化
|
if (OperationType == null || OperationType == 1) { //新增
|
OperationType = 1;
|
//生成并设置主表的内码和单据号
|
createBillNo();
|
|
//初始化制单人和制单时间
|
$("#HMaker").val(sessionStorage["HUserName"]);
|
$("#HMakerDate").val(Format(new Date(), "yyyy-MM-dd"));
|
|
//初始化日期
|
$("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
|
//初始化项目阶段表
|
get_InitGrid();
|
}
|
//#endregion
|
|
//#region 初始化表格
|
DisPlay_HideColumn();
|
//#endregion
|
|
//#endregion
|
|
//#region 触发事件：包括form.on(){}格式的所有点击事件、选择事件等
|
//#region 弹窗选择触发事件
|
//#region 选择部门按钮
|
form.on('submit(btnSearchHDept)', function () {
|
get_checkSearchHDept();
|
});
|
//#endregion
|
|
//#region 选择班组按钮
|
form.on('submit(btnSearchHGroup)', function () {
|
get_checkSearchHGroup();
|
});
|
//#endregion
|
//#endregion
|
|
//#region 操作按钮触发事件
|
//#region 保存提交
|
form.on('submit(btnSave)', function (data) {//提交
|
if (AllowLoadData(data)) {
|
set_AddNew(data);
|
}
|
});
|
//#endregion
|
|
//#region 退出
|
form.on('submit(btnEdit)', function (data) {
|
if (params[1] != null) {
|
Pub_Close(1);
|
} else if (params[1] == null) {
|
Pub_Close(2);
|
}
|
});
|
//#endregion
|
//#endregion
|
|
//#region 复选框 选中/取消 触发事件
|
//#endregion
|
|
//#region 子表：头工具栏事件
|
table.on('toolbar(mainTable)', function (obj) {
|
var checkStatus = table.checkStatus('mainTable')
|
, data = checkStatus.data;
|
|
//新增行表格数据
|
var NewRow =
|
{
|
"RowID": (table.cache["mainTable"].length + 1) * 10
|
, "HEmpID": "0"
|
, "HEmpNumber": ""
|
, "HEmpName": ""
|
, "HQty": "0"
|
, "HPrice": "0"
|
, "HRemark": ""
|
};
|
|
var col = option.cols[0];
|
for (var i = 8; i < col.length - 2; i++) {
|
var field = col[i].field;
|
NewRow[field] = "0";
|
}
|
|
|
switch (obj.event) {
|
case 'btn-AddLine':
|
table.cache["mainTable"].push(NewRow);
|
option.data = table.cache["mainTable"];
|
table.render(option);
|
break;
|
case 'btn-CopyLine':
|
var copydata = JSON.stringify(data);
|
if (data.length <= 0) {
|
layer.msg("请选择需要复制的一行！");
|
}
|
else if (data.length > 1) {
|
layer.msg("只能选择复制一行！");
|
}
|
else {
|
var copydata2 = copydata.substring(1, copydata.length);//去除首行字符'['
|
var copyrow = copydata2.substring(0, copydata2.length - 1);//去除末尾字符']'
|
table.cache["mainTable"].push(JSON.parse(copyrow));//将复制的行强转成json追加到表格上
|
option.data = table.cache["mainTable"];//将数据绑定到data上
|
option.data[option.data.length - 1]["RowID"] = (option.data.length) * 10
|
table.render(option);//将数据渲染到表格上
|
}
|
break;
|
//列设置
|
case 'set_HideColumn':
|
get_HideColumn();
|
break;
|
//上一行
|
case 'btn_up':
|
btn_up(data);
|
break;
|
//下一行
|
case 'btn_under':
|
btn_under(data);
|
break;
|
}
|
});
|
//#endregion
|
|
//#region 子表：行内事件
|
table.on('tool(mainTable)', function (obj) {
|
set_GridDelete(obj); //行内删除
|
set_GridCellCheck(obj); //行内快捷键筛选
|
});
|
//#endregion
|
|
//#region 子表：单元格编辑监听
|
table.on('edit(mainTable)', function (obj) {
|
//// 单元格编辑之前的值
|
//var oldText = $(this).prev().text();
|
//var value = obj.value //得到修改后的值
|
// , data = obj.data //得到所在行所有键值
|
// , field = obj.field; //得到字段
|
////正则表达式-校验非负浮点数
|
//var ref = /^\d+(\.\d+)?$/;
|
|
//switch (field) {
|
// case "HQty": //数量
|
// if (!ref.test(value)) { //若输入值格式不正确，则变回原来的值
|
// obj.update({
|
// HQty: oldText
|
// });
|
// layer.msg("数量：数据错误，请输入非负小数")
|
// } else {
|
// var HQty = value; //数量
|
// var HPrice = data.HPrice; //工价
|
|
// obj.update({
|
// HMoney: HQty * HPrice //金额= 数量*工价
|
// });
|
// }
|
// break;
|
// case "HPrice": //工价
|
// if (!ref.test(value)) { //若输入值格式不正确，则变回原来的值
|
// obj.update({
|
// HPrice: oldText
|
// });
|
// layer.msg("单价：数据错误，请输入非负小数")
|
// } else {
|
// var HQty = data.HQty; //数量
|
// var HPrice = value; //工价
|
|
// obj.update({
|
// HMoney: HQty * HPrice //金额= 数量*工价
|
// });
|
// }
|
// break;
|
// default:
|
//}
|
})
|
//#endregion
|
|
|
//
|
form.on('submit(Cancel)', function () {
|
//sessionStorage["SourceFlag"] = false;
|
parent.location.href = "../../../views/index.html"
|
//window.close();//关闭当前页
|
})
|
|
|
|
|
//#region 监听提交
|
form.verify({
|
numberOrEmpty: function (value, item) {
|
|
// if (value != '') {
|
if (!/^\d+$/.test(value)) {
|
return '不能为空或数字或者0';
|
}
|
//}
|
}
|
});
|
//#endregion
|
|
|
|
//#endregion
|
|
//#region 此页面所有的方法
|
//#region 获取参数
|
function getUrlVars() {
|
var vars = [], hash;
|
var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
|
for (var i = 0; i < hashes.length; i++) {
|
hash = hashes[i].split('=');
|
vars.push(hash[0]);
|
vars[hash[0]] = hash[1];
|
}
|
return vars;
|
}
|
//#endregion
|
|
//#region 生成单据号
|
function createBillNo() {
|
$.ajax({
|
url: GetWEBURL() + "/Web/GetMAXNum",
|
type: "GET",
|
data: { "HBillType": '2233' },
|
success: function (d) {
|
//console.log(d.data);
|
$("#HInterID").val(d.data[0].HInterID);
|
$("#HBillNo").val(d.data[0].HBillNo);
|
$("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
|
}
|
});
|
}
|
//#endregion
|
|
//#region 获取表格初始化列数据
|
function getColumnList() {
|
var columnList = [];
|
var ajaxLoad = layer.load();
|
$.ajax({
|
url: GetWEBURL() + "/Pay_DuSubsidyItemBill_KS/getInitGrid_KS",
|
type: "GET",
|
async: false,
|
data: {},
|
success: function (data1) {
|
if (data1.count == 1) {
|
var data = [];
|
var col = [];
|
//给空的数组data赋值，整理后端传递的列数据
|
for (var key in data1.list) {
|
data.push({ "id": data1.list[key].field, "name": data1.list[key].title, "Type": data1.list[key].dataType });
|
}
|
|
//为空数组col添加列数据
|
for (var i = 0; i < data.length; i++) {
|
col.push({ field: data[i].id, title: data[i].name, edit: 'text', totalRow: true});
|
}
|
columnList = col;
|
|
layer.close(ajaxLoad);
|
} else {
|
layer.close(ajaxLoad);
|
layer.alert(data1.code + data1.Message, { icon: 5 });
|
}
|
}, error: function () {
|
layer.close(ajaxLoad);
|
layer.alert("接口请求失败!", { icon: 5 });
|
}
|
})
|
|
return columnList;
|
}
|
|
//#endregion
|
//#region 子表初始化
|
function get_InitGrid() {
|
option = {
|
elem: '#mainTable'
|
, toolbar: '#toolbarDemo'
|
, cellMinWidth: 120
|
, height: 400
|
, totalRow: true
|
}
|
|
//设置表格的列
|
var columnList = getColumnList();
|
var col = [
|
{ type: 'checkbox', totalRowText: '合计行' }
|
, { type: 'numbers', title: '序号', style: 'background-color: #f9f9f9;' }
|
, { field: 'RowID', title: '行号', hide: true, style: 'background-color: #f9f9f9;' } //行标识，用于下一行、上一行识别所在行
|
, { field: 'HEmpID', title: '职员ID', hide: true, style: 'background-color: #f9f9f9;' }
|
, { field: 'HEmpNumber', title: '职员代码', edit: 'text', event: "HEmpNumber" } //f7
|
, { field: 'HEmpName', title: '职员名称', style: 'background-color: #f9f9f9;' }
|
, { field: 'HQty', title: '数量', hide: true, style: 'background-color: #f9f9f9;' } //f7
|
, { field: 'HPrice', title: '单价', hide: true, style: 'background-color: #f9f9f9;' } //f7
|
];
|
for (var i = 0; i < columnList.length; i++) {
|
col.push(columnList[i]);
|
}
|
col.push({ field: 'HRemark', title: '备注', edit: 'text' });
|
col.push({ fixed: 'right', title: '操作', toolbar: '#barDemo' });
|
//设置初始行数据
|
var rowdata = [
|
{
|
"RowID": 10
|
, "HEmpID": "0"
|
, "HEmpNumber": ""
|
, "HEmpName": ""
|
, "HQty": "0"
|
, "HPrice": "0"
|
, "HRemark": ""
|
}
|
];
|
for (var i = 8; i < col.length-2; i++) {
|
var field = col[i].field;
|
rowdata[0][field] = "0";
|
}
|
option.cols = [col];
|
option.data = rowdata;
|
|
|
table.render(option);
|
}
|
//#endregion
|
|
//#region 部门选择页面
|
function get_checkSearchHDept() {
|
//打开部门小窗体
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: "部门列表" //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["90%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: ["../../基础资料/公用基础资料/Gy_DepartmentList.html", "yes"]
|
, btn: ["确定", "取消"]
|
, btn1: function (index, laero) {
|
//按钮一 的回调
|
var iframeWindow = window["layui-layer-iframe" + index];//获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//获取选中的数据
|
|
if (checkStatus.data.length != 1) {
|
return layer.msg("请选择一条数据");
|
}
|
|
$("#HDeptID").val(checkStatus.data[0].HItemID);//内码
|
$("#HDeptName").val(checkStatus.data[0].部门名称);//名称
|
layer.close(index);//关闭弹窗
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
//#endregion
|
|
//#region 班组选择页面
|
function get_checkSearchHGroup() {
|
//打开班组小窗体
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: "班组列表" //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["90%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: ["../../../views/基础资料/工资基础资料/Gy_Group.html?Type=HGroupID", "yes"]
|
, btn: ["确定", "取消"]
|
, btn1: function (index, laero) {
|
//按钮一 的回调
|
var iframeWindow = window["layui-layer-iframe" + index];//获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//获取选中的数据
|
|
if (checkStatus.data.length != 1) {
|
return layer.msg("请选择一条数据");
|
}
|
|
$("#HGroupID").val(checkStatus.data[0].HItemID);//班组内码
|
$("#HGroupName").val(checkStatus.data[0].班组名称);//班组名称
|
$("#HDeptID").val(checkStatus.data[0].HDeptID);//部门代码
|
$("#HDeptName").val(checkStatus.data[0].部门名称);//部门名称
|
//根据班组内码获取子表数据
|
layer.confirm(
|
'是否确定覆盖子表原数据？'
|
, {
|
btn: ['确定', '取消'] //可以无限个按钮
|
}, function (index, layero) { //按钮1回调函数
|
var HGroupID = $("#HGroupID").val();
|
getEmp_BasedGroupID(HGroupID);
|
layer.close(index);
|
}, function (index) { //按钮2回调函数
|
|
});
|
|
|
layer.close(index);//关闭弹窗
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
//#endregion
|
|
//#region 处理保存数据
|
function saveDataDeal() {
|
//获取子表数据
|
var tableSub = [];
|
var data = [];
|
for (var i = 0; i < table.cache["mainTable"].length; i++) {
|
if (table.cache["mainTable"][i] != "") {
|
table.cache["mainTable"][i].LAY_TABLE_INDEX = i;
|
tableSub.push(table.cache["mainTable"][i])
|
}
|
}
|
|
for (var i = 0; i < tableSub.length; i++) {
|
|
var col = option.cols[0];
|
for (var j = 8; j < col.length - 2; j++) {
|
var field = col[j].field;
|
var title = col[j].title;
|
if (tableSub[i][field] != "" && tableSub[i][field] != "0") {
|
var NewRow =
|
{
|
"RowID": tableSub[i]["RowID"]
|
, "HEmpID": tableSub[i]["HEmpID"]
|
, "HEmpNumber": tableSub[i]["HEmpNumber"]
|
, "HEmpName": tableSub[i]["HEmpName"]
|
, "HQty": tableSub[i]["HQty"]
|
, "HPrice": tableSub[i]["HPrice"]
|
, "HRemark": tableSub[i]["HRemark"]
|
};
|
NewRow["HDuSubsidyItemID"] = field;
|
NewRow["HDuSubsidyItemNumber"] = "";
|
NewRow["HDuSubsidyItemName"] = title;
|
NewRow["HMoney"] = tableSub[i][field];
|
data.push(NewRow);
|
}
|
}
|
}
|
return data;
|
}
|
//#endregion
|
//#region 保存HMaker
|
function set_AddNew(data) {
|
//若为编辑-保存，则更新修改人和修改时间
|
if (OperationType == 3) {
|
data.field.HUpdater = sessionStorage["HUserName"];
|
data.field.HUpdaterDate = Format(new Date(), "yyyy-MM-dd");
|
$("#HUpdater").val(sessionStorage["HUserName"]);
|
$("#HUpdaterDate").val(Format(new Date(), "yyyy-MM-dd"));
|
}
|
|
//获取表头数据
|
var tableMain = data.field;
|
//获取子表数据
|
var tableSub = saveDataDeal();
|
//获取表头数据并序列化
|
var sMainStr = JSON.stringify(tableMain); //主表数据
|
//子表数据序列化
|
var sSubStr = JSON.stringify(tableSub);
|
|
//拼接序列化的数据
|
var sMainSub = sMainStr + ';' + sSubStr + ';' + OperationType + ";" + sessionStorage["HUserName"];
|
|
var index = layer.load();
|
$.ajax({
|
type: "POST",
|
url: GetWEBURL() + "/Pay_DuSubsidyItemBill/AddDuSubsidyItemBill",
|
async: true,
|
data: { "sMainSub": sMainSub },
|
dataType: "json",
|
success: function (data) {
|
if (data.count == 1) {
|
$('#btnSave').addClass("layui-btn-disabled").attr("disabled", true);
|
layer.close(index);
|
layer.msg("提交成功");
|
}
|
else {
|
layer.close(index);
|
layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
}
|
},
|
error: function (err) {
|
layer.close(index);
|
layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
}
|
});
|
}
|
//#endregion
|
|
//#region 数据校验
|
function AllowLoadData(data) {
|
//#region 表头数据检验
|
if ($("#HBillNo").val() == "") {
|
layer.msg("单据号不能为空!");
|
return false;
|
}
|
if ($("#HDate").val() == "") {
|
layer.msg("日期不能为空!");
|
return false;
|
}
|
if ($("#HGroupID").val() == "0") {
|
layer.msg("班组未选择!");
|
return false;
|
}
|
if ($("#HDeptID").val() == "0") {
|
layer.msg("部门未选择!");
|
return false;
|
}
|
//#endregion
|
|
//#region 子表数据检验
|
var temp; //记录需要检验的属性的值，用于检验
|
var ref = /^\d+(\.\d+)?$/; //判断是否是非负浮点数
|
var ref1 = /^\d+$/; //判断是否是非负整数
|
var value1 = []; //子表需要进行浮点数验证的属性清单
|
var value1_ = []; ////子表需要进行浮点数验证的属性清单对应的列名清单
|
var value2 = []; //子表需要整数检验的属性清单
|
var value2_ = []; //子表需要整数检验的属性清单对应的列名清单
|
var value3 = ["HEmpID"]; //子表需要进行非空检验的属性清单
|
var value3_ = ["职员"]; //子表需要进行非空检验的属性清单对应的列名清单
|
//设置需要进行非负浮点数检验的字段列表
|
for (var i = 8; i < option.cols[0].length-2; i++) {
|
temp = option.cols[0][i].field;
|
value1.push(temp);
|
temp = option.cols[0][i].title;
|
value1_.push(temp);
|
}
|
//对子表遍历校验
|
for (var i = 0; i < option.data.length; i++) {
|
if (option.data[i] != "") {
|
//非空检验
|
for (var j = 0; j < value3.length; j++) {
|
temp = option.data[i][value3[j]] + "";
|
if (temp == "0") {
|
layer.msg("第" + (i + 1) + "行:" + value3_[j] + "未选择!");
|
return false;
|
}
|
}
|
//扣补项目非全空验证
|
var isNullFlag = 0;
|
for (var j = 8; j < option.cols[0].length - 2; j++) {
|
var field = option.cols[0][j].field + "";
|
temp = option.data[i][field] + "";
|
if (temp != "" && temp != "0") {
|
isNullFlag = 1;
|
}
|
}
|
if (isNullFlag == 0) {
|
layer.msg("第" + (i + 1) + "行:扣补项目不能全为空(0)!");
|
}
|
|
//浮点数检验
|
for (var j = 0; j < value1.length; j++) {
|
temp = option.data[i][value1[j]] + "";
|
if (!ref.test(temp) && temp != "") {
|
layer.msg("第" + (i + 1) + "行:" + value1_[j] + "请输入正确非负数字!");
|
return false;
|
}
|
}
|
}
|
}
|
//#endregion
|
|
//#region 子表关键字段重复检验
|
var num = [];
|
for (var i = 0; i < option.data.length; i++) {
|
temp = option.data[i]["HEmpID"];
|
if ($.inArray(temp, num) != -1) {
|
layer.msg("第" + (i + 1) + "行：职员重复，请重新选择！");
|
return false;
|
}
|
num.push(temp);
|
}
|
//#endregion
|
return true;
|
}
|
//#endregion
|
|
//#region 子表表头工具栏事件：上一行
|
function btn_up(data) {
|
if (data.length != 1) {
|
layer.msg("请选择一行数据！");
|
} else if (option.data[0]["RowID"] == data[0]["RowID"]) {
|
layer.msg("首行数据无法移动！");
|
} else {
|
var tables = [];
|
for (var i = 0; i < option.data.length; i++) {
|
if (option.data[i]["RowID"] == data[0]["RowID"]) {
|
tables.push(option.data[i - 1]);
|
data[0].LAY_CHECKED = true;
|
option.data[i - 1] = data[0];
|
option.data[i] = tables[0];
|
|
var tempRowID = option.data[i - 1]["RowID"];
|
option.data[i - 1]["RowID"] = option.data[i]["RowID"];
|
option.data[i]["RowID"] = tempRowID;
|
|
table.render(option);
|
break;
|
}
|
}
|
}
|
}
|
//#endregion
|
|
//#region 子表表头工具栏：下一行
|
function btn_under(data) {
|
if (data.length != 1) {
|
layer.msg("请选择一行数据！");
|
} else if (option.data[option.data.length - 1]["RowID"] == data[0]["RowID"]) {
|
layer.msg("末行数据无法移动！");
|
} else {
|
var tables = [];
|
for (var i = 0; i < option.data.length; i++) {
|
if (option.data[i]["RowID"] == data[0]["RowID"]) {
|
tables.push(option.data[i + 1]);
|
data[0].LAY_CHECKED = true;
|
option.data[i + 1] = data[0];
|
option.data[i] = tables[0];
|
|
var tempRowID = option.data[i + 1]["RowID"];
|
option.data[i + 1]["RowID"] = option.data[i]["RowID"];
|
option.data[i]["RowID"] = tempRowID;
|
table.render(option);
|
break;
|
}
|
}
|
}
|
}
|
//#endregion
|
|
//#region 子表：删除指定行
|
function set_GridDelete(obj) {
|
var data = obj.data;
|
var rowIndex = $(obj.tr).attr("data-index");
|
if (obj.event === 'del') {
|
layer.confirm('真的删除行吗？', function (index) {
|
console.log("索引为:" + rowIndex);
|
if (rowIndex === '0') {
|
layer.msg('首行无法删除！！！');
|
} else {
|
var oldData = table.cache["mainTable"];
|
oldData.splice(obj.tr.data('index'), 1)
|
option.data = oldData;//将数据绑定到data上
|
table.render(option);
|
layer.close(index);
|
}
|
});
|
}
|
}
|
//#endregion
|
|
//#region 子表：快捷键(F7)打开弹窗
|
function set_GridCellCheck(obj) {
|
//#region F7触发事件
|
$(document).off('keydown', ".layui-table-edit").on('keydown', '.layui-table-edit', function (e) {
|
if (event.key == "F7") {
|
//职员
|
if (obj.event == "HEmpNumber") {
|
//打开员工列表小窗体
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: "员工列表" //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["90%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: ["../../基础资料/公用基础资料/Gy_EmployeeList.html?", "yes"]
|
, btn: ["确定", "取消"]
|
, btn1: function (index, laero) {
|
//按钮一 的回调
|
var iframeWindow = window["layui-layer-iframe" + index];//获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//获取选中的数据
|
|
if (checkStatus.data.length != 1) {
|
return layer.msg("请选择一条数据");
|
}
|
//更新表格缓存的数据
|
obj.update({
|
"HEmpID": checkStatus.data[0].HItemID
|
, "HEmpNumber": checkStatus.data[0].职员代码
|
, "HEmpName": checkStatus.data[0].职员名称
|
})
|
layer.close(index);//关闭弹窗
|
}
|
})
|
}
|
obj.event = "";
|
return false;
|
}
|
})
|
//#endregion
|
}
|
//#endregion
|
|
//#region 隐藏列设置
|
function get_HideColumn() {
|
var colName = "";
|
var contentUrl = "";
|
for (var i = 1; i < option.cols[0].length - 1; i++) {
|
colName += option.cols[0][i]["title"] + ",";
|
}
|
var urlStr = window.document.location.pathname;//获取文件路径
|
var urlLen = urlStr.split('/');
|
for (var i = 0; i < urlLen.length - 4; i++) {
|
contentUrl += "../";
|
}
|
colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI 进行编码
|
|
contentUrl += '基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName;
|
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: "隐藏列设置" //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["50%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: [contentUrl, "yes"]
|
, btn: ["确定", "取消"]
|
, btn1: function (index, laero) {
|
//刷新表格数据
|
DisPlay_HideColumn();
|
//更新表格缓存的数据
|
layer.close(index);//关闭弹窗
|
}
|
})
|
}
|
//#endregion
|
//#region 显示列数据
|
function DisPlay_HideColumn() {
|
$.ajax({
|
url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
|
type: "GET",
|
data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
|
async: false,
|
success: function (data1) {
|
if (data1.data.length != 0) {
|
var dataCol = [];//数据库查询出的列数据
|
var titleData = ["行号", "职员ID","数量","单价"];//不需要显示的字段 可扩展
|
|
dataCol = data1.data[0].HGridString.split(',');
|
|
for (var i = 0; i < option.cols[0].length - 2; i++) {
|
var dataCols = dataCol[i].split('|');
|
//隐藏列
|
if (dataCols[1] == 1) {
|
option.cols[0][i + 1]["hide"] = true;
|
}
|
//设置列宽
|
if (dataCols[3] > 0) {
|
option.cols[0][i + 1]["width"] = dataCols[3];
|
}
|
//设置内容字体大小
|
if (data1.data[0].HFontSize != 0) {
|
option.cols[0][i + 1]["style"] += "font-size:" + data1.data[0].HFontSize + "px;";
|
} else {
|
option.cols[0][i + 1]["style"] += "font-size:100%";
|
}
|
//设置列宽
|
//if (data1.data[0].HColumnWidth != 0) {
|
// option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
|
//} else {
|
// option.cols[0][i + 1]["width"] = "";
|
//}
|
//显示列
|
if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
|
option.cols[0][i + 1]["hide"] = false;
|
}
|
//字体所在位置(左 居中 右)
|
switch (dataCols[2]) {
|
case "L":
|
option.cols[0][i + 1]["align"] = "left";
|
break;
|
case "M":
|
option.cols[0][i + 1]["align"] = "center";
|
break;
|
case "R":
|
option.cols[0][i + 1]["align"] = "right";
|
break;
|
}
|
}
|
|
//取消冻结列
|
for (var i = 1; i < option.cols[0].length - 1; i++) {
|
if (option.cols[0][i]["fixed"] != null) {
|
option.cols[0][i]["fixed"] = null;
|
}
|
else {
|
break;
|
}
|
}
|
//冻结列
|
if (data1.data[0].HFixCols != 0) {
|
for (var i = 0; i < data1.data[0].HFixCols; i++) {
|
if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
|
data1.data[0].HFixCols += 1;
|
}
|
option.cols[0][i + 1]["fixed"] = "left";
|
}
|
}
|
table.render(option);
|
} else {
|
table.render(option);
|
}
|
}, error: function () {
|
layer.alert("接口请求失败!", { icon: 5 });
|
}
|
})
|
}
|
//#endregion
|
|
//#region 根据班组带出子表职员列表
|
function getEmp_BasedGroupID(HGroupID) {
|
var index = layer.load();
|
$.ajax({
|
type: "Get",
|
url: GetWEBURL() + "/Pay_GroupBalBill/getEmpListBasedGroupID",
|
async: false,
|
data: { "HGroupID": HGroupID },
|
success: function (res) {
|
if (res.count == 1) {
|
var sub2Data = [];
|
var sub2DataSource = res.data;
|
for (var i = 0; i < sub2DataSource.length; i++) {
|
var NewRow =
|
{
|
"RowID": (sub2Data.length + 1) * 10
|
, "HEmpID": "0"
|
, "HEmpNumber": ""
|
, "HEmpName": ""
|
, "HQty": "0"
|
, "HPrice": "0"
|
, "HRemark": ""
|
};
|
col = option.cols[0];
|
for (var j = 8; j < col.length - 2; j++) {
|
var field = col[j].field;
|
NewRow[field] = "0";
|
}
|
NewRow.HEmpID = sub2DataSource[i]["HItemID"];
|
NewRow.HEmpNumber = sub2DataSource[i]["HNumber"];
|
NewRow.HEmpName = sub2DataSource[i]["HName"];
|
sub2Data.push(NewRow);
|
}
|
option.data = sub2Data;
|
table.render(option);
|
layer.msg("加载成功");
|
layer.close(index);
|
}
|
else {
|
layer.msg(res.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
layer.close(index);
|
}
|
},
|
error: function (err) {
|
layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
layer.close(index);
|
}
|
});
|
}
|
//#endregion
|
//#endregion
|
|
|
|
|
});
|
|
|
</script>
|
</body>
|
</html>
|
