<!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/layui/layui.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>
|
<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
|
<script src="../../../layuiadmin/PageTitle.js"></script>
|
<style type="text/css">
|
/*begin 此样式用于消除行元素中布局宽度不够的问题*/
|
.layui-form-item .layui-inline {
|
margin-top: 5px;
|
margin-bottom: 5px;
|
margin-right: 0px;
|
}
|
/*end*/
|
|
html {
|
background-color: white;
|
color: white;
|
}
|
|
.layui-table-cell {
|
overflow: visible !important;
|
}
|
|
td .layui-form-select {
|
margin-top: -10px;
|
margin-left: -15px;
|
margin-right: -15px;
|
}
|
</style>
|
</head>
|
<body>
|
|
<div class="layui-fluid" style="padding: 0;">
|
<div class="layui-card" style="padding: 15px;">
|
<div class="layui-card-body" style="padding: 1px;">
|
<form class="layui-form" lay-filter="component-form-group" action="">
|
<div class="layui-card-header">
|
<div class="layui-btn-group">
|
<button type="button" id="add-btn" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Saver">保存</button>
|
<button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_CheckBill">审核</button>
|
<button type="button" id="print-btn" class="layui-btn layui-btn-normal layui-btn-radius layui-btn-disabled" lay-submit="" lay-filter="get_PrintReport" disabled>打印</button>
|
<button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Exit">退出</button>
|
</div>
|
</div>
|
<div class="layui-tab" lay-filter="tab-POStockInBill">
|
<h1 style="text-align: center; padding: 10px 0;"><b>采购入库单</b></h1>
|
<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>
|
<li lay-id="3" 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-col-xs4 layui-inline">
|
<label class="layui-form-label">单据号<label style="color:red"> * </label></label>
|
<div class="layui-input-inline">
|
<input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="background-color:#efefef4d;">
|
<input type="hidden" name="HInterID" id="HInterID" value="0">
|
<input type="hidden" name="HSTOCKORGID" id="HSTOCKORGID" lay-verify="HSTOCKORGID" value=0>
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">日期<label style="color:red"> * </label></label>
|
<div class="layui-input-inline">
|
<input class="layui-input" name="HDate" id="HDate" autocomplete="off" model="datetime" dateFormat="yyyy-MM-dd" placeholder="yyyy-MM-dd">
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">供应商<label style="color:red"> * </label></label>
|
<div class="layui-input-inline">
|
<input type="text" name="HSupName" id="HSupName" class="layui-input" value="" style="float:left;width:150px;">
|
<input type="hidden" name="HSupID" id="HSupID" class="layui-input" value=0 style="float:left;width:150px;">
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="HSupList" style="width:40px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
|
</button>
|
</div>
|
</div>
|
</div>
|
<div class="layui-row">
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">仓库<label style="color:red"> * </label></label>
|
<div class="layui-input-inline">
|
<input type="text" name="HWHName" id="HWHName" class="layui-input" value="" style="float:left;width:150px;">
|
<input type="hidden" name="HWHID" id="HWHID" class="layui-input" value=0 style="float:left;width:150px;">
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="HWHList" style="width:40px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
|
</button>
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">验收员</label>
|
<div class="layui-input-inline">
|
<input type="text" name="HSecManagerName" id="HSecManagerName" class="layui-input" value="" style="float:left;width:150px;">
|
<input type="hidden" name="HSecManagerID" id="HSecManagerID" class="layui-input" value="0" style="float:left;width:150px;">
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="HSecManagerList" style="width:40px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
|
</button>
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">保管员</label>
|
<div class="layui-input-inline">
|
<input type="text" name="HKeeperName" id="HKeeperName" class="layui-input" value="" style="float:left;width:150px;">
|
<input type="hidden" name="HKeeperID" id="HKeeperID" class="layui-input" value="0" style="float:left;width:150px;">
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="HKeeperList" style="width:40px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
|
</button>
|
</div>
|
</div>
|
</div>
|
<div class="layui-row">
|
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">业务员</label>
|
<div class="layui-input-inline">
|
<input type="text" name="HEmpName" id="HEmpName" class="layui-input" value="" style="float:left;width:150px;">
|
<input type="hidden" name="HEmpID" id="HEmpID" class="layui-input" value="0" style="float:left;width:150px;">
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="HEmpList" style="width:40px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
|
</button>
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">源单类型</label>
|
<div class="layui-input-inline">
|
<select name="HSourceBillType" id="HSourceBillType" lay-verify="HSourceBillType">
|
<!--动态渲染源单类型-->
|
</select>
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">选单号</label>
|
<div class="layui-input-inline">
|
<input type="text" name="HSourceBillNo" id="HSourceBillNo" class="layui-input" value="" style="float:left;width:150px;">
|
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="XDHList" id="XDHList" style="width:40px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
|
</button>
|
</div>
|
<!--<label class="layui-form-label">选单号</label>
|
<div class="layui-input-inline">
|
<input class="layui-input" name="Box2" id="Box2" autocomplete="off">
|
</div>-->
|
</div>
|
</div>
|
<div class="layui-row">
|
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">负责人</label>
|
<div class="layui-input-inline">
|
<input type="text" name="HManagerName" id="HManagerName" class="layui-input" value="" style="float:left;width:150px;">
|
<input type="hidden" name="HManagerID" id="HManagerID" class="layui-input" value=0 style="float:left;width:150px;">
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="HManagerList" style="width:40px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
|
</button>
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">项目编码</label>
|
<div class="layui-input-inline">
|
<input type="text" name="HProjectNumber" id="HProjectNumber" class="layui-input" value="" style="float: left; width: 150px; background-color: #efefef4d;" readonly>
|
<input type="hidden" name="HProjectID" id="HProjectID" class="layui-input" value="0" style="float: left; width: 150px; background-color: #efefef4d;">
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="btnHProjectID" style="width:40px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
|
</button>
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">项目名称</label>
|
<div class="layui-input-inline">
|
<input class="layui-input" name="HProjectName" id="HProjectName" style="background-color:#efefef4d;" readonly autocomplete="off">
|
</div>
|
</div>
|
|
</div>
|
<div class="layui-row">
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">部门<label style="color:red"> * </label></label>
|
<div class="layui-input-inline">
|
<input type="text" name="HDeptName" id="HDeptName" class="layui-input" value="" style="float:left;width:150px;">
|
<input type="hidden" name="HDeptID" id="HDeptID" class="layui-input" value=0 style="float:left;width:150px;">
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="HDeptList" style="width:40px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
|
</button>
|
</div>
|
</div>
|
|
</div>
|
<!--<div class="layui-row">
|
|
<div class="layui-col-xs7 layui-inline">
|
<label class="layui-form-label">摘要</label>
|
<div class="layui-input-block">
|
<input class="layui-input" name="HExplanation" id="HExplanation" autocomplete="off">
|
</div>
|
</div>
|
</div>-->
|
<div class="layui-row">
|
<div class="layui-col-xs7 layui-inline">
|
<label class="layui-form-label">备注</label>
|
<div class="layui-input-block">
|
<input class="layui-input" name="HRemark" id="HRemark" autocomplete="off">
|
</div>
|
</div>
|
|
</div>
|
</div>
|
</div>
|
|
<!--其他信息-->
|
<div class="layui-tab-item">
|
<div class="layui-form-item" style="padding-top: 10px;">
|
<div class="layui-row">
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">内部单据号</label>
|
<div class="layui-input-inline">
|
<input class="layui-input" name="HInnerBillNo" id="HInnerBillNo" autocomplete="off">
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline" style="margin-left: 135px;">
|
<label class="layui-form-label">发票编号</label>
|
<div class="layui-input-inline">
|
<input class="layui-input" name="HInvoiceBillNo" id="HInvoiceBillNo" autocomplete="off">
|
</div>
|
</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">
|
<!--动态渲染组织-->
|
</select>
|
</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="HChecker" id="HChecker" 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="HCloseMan" id="HCloseMan" 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="HMakeDate" id="HMakeDate" 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="HCheckDate" id="HCheckDate" 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="HCloseDate" id="HCloseDate" 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="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="HDeleteMan" id="HDeleteMan" 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="HUpDateDate" id="HUpDateDate" 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="HDeleteDate" id="HDeleteDate" 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="get_Inventory" id="get_Inventory"><i class="layui-icon layui-icon-form"></i>库存查询</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="get_InOutSum" id="get_InOutSum"><i class="layui-icon layui-icon-form"></i>出入库记录查询</button>
|
</div>
|
</script>
|
<script type="text/html" id="xuhao">
|
{{d.LAY_TABLE_INDEX+1}}
|
</script>
|
</form>
|
</div>
|
</div>
|
</div>
|
<script type="text/html" id="barDemo">
|
<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
|
</script>
|
<script>
|
//#region 文本框输入搜索相关数据-变量
|
var childPage = null; //获取子窗口对象，用于操作子窗口的变量和方法
|
var currRowIndex = 0; //用于定位子窗口当前选中的行
|
var childData = null; //用于获取子窗口返回的数据
|
//#endregion
|
|
//#region 折叠注释
|
//#endregion
|
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;
|
var sWhere = "";
|
var date = new Date();
|
var day = date.getDate();
|
var month = date.getMonth() + 1;
|
var year = date.getFullYear();
|
var shijian = year + "-" + month + "-" + day;
|
|
var allVal;
|
//#endregion
|
var HModName = "Add_Edit_Kf_POStockInBillList"
|
|
//#region 进入页面即加载
|
//判断是否登录 未登录则跳到登录页
|
get_LoginIs();
|
|
//#region 【动态获取模块名称】
|
var HModuleType = "1201";
|
//通过单据类型，从数据库动态获取单据模块命名,引用js文件 PageTitle.js
|
var HPageTitle = get_PageTitle(HModuleType) == "" ? $("h1").html() : get_PageTitle(HModuleType);
|
$("h1").html('<b>' + HPageTitle + '</b>');
|
//#endregion
|
|
Organ();//显示组织
|
//获取源单类型
|
HSourceBillType();
|
|
|
//获取页面跳转参数
|
var params = get_UrlVars();
|
if (typeof (params[params[0]]) == "undefined") {
|
OperationType = 1;//操作类型
|
} else {
|
var OperationType = params[params[0]];//操作类型
|
var linterid = params[params[1]];//源单id
|
var HSouceBillType = params[params[2]];//源单类型
|
}
|
|
|
|
//#region 获取最大单据号
|
function get_MAXNum() {
|
$("#HInterID").val("0");
|
$("#HBillNo").val("");
|
$.ajax({
|
url: GetWEBURL() + "/WEBSController/GetMaxBillNoAndID_Json",
|
type: "GET",
|
data: { "HBillType": '1201' },
|
success: function (d) {
|
$("#HBillNo").val(d.data[0].HBillNo);
|
$("#HInterID").val(d.data[0].HInterID);
|
}
|
});
|
}
|
//#endregion
|
|
// 初始化界
|
set_InitGrid();
|
|
//#region 判断操作类型并初始化界面
|
if (OperationType == 1) { //无源单新增
|
/* $("#HItemID").val(0);*/
|
|
//生成单据号和内码
|
get_MAXNum();
|
//初始化日期、创建人、创建时间
|
$("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
|
$("#HReceiveDate").val(Format(new Date(), "yyyy-MM-dd"));
|
$("#HMaker").val(sessionStorage["HUserName"]);
|
$("#HMakeDate").val(Format(new Date(), "yyyy-MM-dd hh:mm:ss"));
|
}
|
else if (OperationType == 3) { //编辑
|
//修改时主表ID
|
$("#HInterID").val(linterid);
|
$('#print-btn').prop('disabled', false).removeClass('layui-btn-disabled');
|
//编辑状态时，根据内码，获取信息并写入界面
|
RoadBillMain(linterid);
|
}
|
else if (OperationType == 4) { //下推
|
setInit_PushBill();
|
}
|
else {
|
layer.alert("未知操作类型！", { icon: 5 });
|
}
|
//#endregion
|
|
|
|
//#endregion
|
|
var rowdata = [{
|
"HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "HQtyMust": "0", "HQty": "", "HRemark": "",
|
"HPrice": "0", "HMoney": "0", "HOrderPrice": "0", "HWHID": 0, "收料仓库": "",
|
"HSPID": 0, "仓位名称": "", "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0,
|
"HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "",
|
"HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0,
|
"HTaxRate": 0, "HTaxPrice": 0, "HlineTotal": 0
|
}];
|
|
//头工具栏事件
|
table.on('toolbar(mainTable)', function (obj) {
|
var checkStatus = table.checkStatus('mainTable')
|
, data = checkStatus.data;
|
//新增行表格数据
|
var NewRow = {
|
"HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "HQtyMust": "0", "HQty": "0", "HRemark": "",
|
"HPrice": "0", "HMoney": "0", "HOrderPrice": "0", "HWHID": 0, "收料仓库": "",
|
"HSPID": 0, "仓位名称": "", "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0,
|
"HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "",
|
"HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0,
|
"HTaxRate": 0, "HTaxPrice": 0, "HlineTotal": 0
|
};
|
switch (obj.event) {
|
//库存查询
|
case 'get_Inventory': get_Inventory();
|
break;
|
//出入库记录查询
|
case 'get_InOutSum': get_InOutSum();
|
break;
|
case 'btn-AddLine':
|
table.cache["mainTable"].push(NewRow);
|
option.data = table.cache["mainTable"];
|
|
table.render(option);
|
//刷新复选框
|
//checkRefresh();
|
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上
|
table.render(option);//将数据渲染到表格上
|
//刷新复选框
|
//checkRefresh();
|
}
|
break;
|
//列设置
|
case 'set_HideColumn':
|
get_HideColumn();
|
break;
|
}
|
});
|
|
|
//#region 触发事件：包括form.on(){}格式的所有点击事件、选择事件等
|
|
//退出按钮
|
form.on('submit(Cancel)', function () {
|
Pub_Close(1);
|
})
|
|
//#region 按钮
|
form.on('submit(set_CheckBill)', function (data) {
|
set_CheckBill(0);
|
});
|
//#region 打印
|
form.on('submit(get_PrintReport)', function (data) {
|
get_PrintReport();
|
});
|
//#endregion
|
//选择业务员按钮
|
form.on('submit(HEmpList)', function () {
|
get_checkEmp();
|
});
|
//选择供应商按钮
|
form.on('submit(HSupList)', function () {
|
get_checkSup();
|
});
|
//选择工程项目
|
form.on('submit(btnHProjectID)', function () {
|
get_btnHProjectID();
|
});
|
|
//选择部门按钮
|
form.on('submit(HWHList)', function () {
|
get_checkWH();
|
});
|
//选择验收员按钮
|
form.on('submit(HSecManagerList)', function () {
|
get_checkSecManager();
|
});
|
//选择保管员按钮
|
form.on('submit(HKeeperList)', function () {
|
get_checkKeeper();
|
});
|
//选择部门按钮
|
form.on('submit(HDeptList)', function () {
|
get_checkDept();
|
});
|
|
//选择主管按钮
|
form.on('submit(HManagerList)', function () {
|
get_checkManager();
|
});
|
|
//行内事件
|
table.on('tool(mainTable)', function (obj) {
|
set_GridDelete(obj); //行内删除
|
set_GridCellCheck(obj); //行内快捷键筛选
|
|
var data = obj.data;
|
if (obj.event == 'HDate') {
|
var field = $(this).data('field');
|
laydate.render({
|
elem: this.firstChild
|
, show: true //直接显示
|
, closeStop: this
|
, done: function (nowDate) {
|
//时间选择完成，行数据更新
|
data[field] = nowDate;
|
obj.update(data);
|
//刷新复选框
|
//checkRefresh();
|
}
|
});
|
}
|
});
|
|
//#region 回车选择源单
|
$('#HSourceBillNo').on('keydown', function (event) {
|
var HSourceBillNo = $('#HSourceBillNo').val();//（源单单据号）
|
if (event.keyCode == 13) {
|
var ajaxLoad = layer.load();
|
var url;
|
//判断文本框是否有数据 new
|
if (HSourceBillNo == "") {
|
return;
|
}
|
if ($("#HSourceBillType").val() == "1102") {
|
//源单类型是采购订单
|
url = "/Cg_POOrderBill/PushList";
|
} else if ($("#HSourceBillType").val() == "1103") {
|
//源单类型是收料通知单
|
url = "/Cg_POInStockBill/PushList";
|
}
|
$.ajax({
|
url: GetWEBURL() + url,
|
type: "GET",
|
data: { "HBillNo": HSourceBillNo, "user": sessionStorage["HUserName"] },
|
success: function (result) {
|
if (result.code == 1) { // 说明验证成功了，
|
var checkStatus = result;
|
if ($("#HSourceBillType").val() == "1102") {
|
option.data = [];//清空子表
|
$("#HProjectName").val(checkStatus.data[0].项目名称);
|
$("#HProjectNumber").val(checkStatus.data[0].项目代码);
|
$("#HProjectID").val(checkStatus.data[0].HProjectID);
|
|
$("#HDeptID").val(checkStatus.data[0].HDeptID);
|
$("#HDeptName").val(checkStatus.data[0].部门);
|
$("#HWHID").val(checkStatus.data[0].HWHID);
|
$("#HWHName").val(checkStatus.data[0].仓库);
|
$("#HSupID").val(checkStatus.data[0].HSupID);
|
$("#HSupName").val(checkStatus.data[0].供应商);
|
$("#HEmpID").val(checkStatus.data[0].HEmpID);
|
$("#HEmpName").val(checkStatus.data[0].业务员);
|
$("#HManagerID").val(checkStatus.data[0].HManagerID);
|
$("#HManagerName").val(checkStatus.data[0].主管);
|
$("#HInvoiceBillNo").val(checkStatus.data[0].发票编号);
|
$("#HInnerBillNo").val(checkStatus.data[0].内部单据号);
|
|
var j = 0;
|
for (var i = 0; i < result.data.length; i++) {
|
var HNewQty = checkStatus.data[j].数量 - checkStatus.data[j].关联数量//数量
|
var HNewMoney = checkStatus.data[j].金额 - checkStatus.data[j].关联数量 * checkStatus.data[j].单价//减少关联数量的金额
|
var HNewTaxMoney = HNewMoney * checkStatus.data[j].税率 * 0.01
|
var HNewlineTotal = HNewMoney + HNewTaxMoney;
|
option.data.push({
|
"HMaterID": checkStatus.data[j].HMaterID, "物料代码": checkStatus.data[j].物料代码, "物料名称": checkStatus.data[j].物料名称, "规格型号": checkStatus.data[j].规格型号,
|
"HUnitID": checkStatus.data[j].HUnitID, "计量单位": checkStatus.data[j].计量单位, "HWHID": checkStatus.data[j].HWHIDSub, "收料仓库": checkStatus.data[j].仓库名称,
|
"HSPID": checkStatus.data[j].HSPID, "仓位名称": checkStatus.data[j].仓位名称, "HQtyMust": checkStatus.data[j].数量,
|
"HQty": HNewQty, "HPrice": checkStatus.data[j].单价, "HMoney": HNewMoney,"HOrderPrice": checkStatus.data[j].金额,
|
"HSourceBillNo": checkStatus.data[j].单据号, "HSourceBillType": checkStatus.data[j].HBillType, "HSourceInterID": checkStatus.data[j].hmainid, "HSourceEntryID": checkStatus.data[j].hsubid,
|
"HTaxRate": checkStatus.data[j].税率, "HTaxPrice": checkStatus.data[j].含税单价, "HlineTotal": HNewlineTotal
|
})
|
j++;
|
}
|
|
} else if ($("#HSourceBillType").val() == "1103") {
|
option.data = [];//清空子表
|
$("#HProjectName").val(checkStatus.data[0].项目名称);
|
$("#HProjectNumber").val(checkStatus.data[0].项目代码);
|
$("#HProjectID").val(checkStatus.data[0].HProjectID);
|
$("#HDeptID").val(checkStatus.data[0].HDeptID);
|
$("#HDeptName").val(checkStatus.data[0].部门);
|
$("#HWHID").val(checkStatus.data[0].主表仓库ID);
|
$("#HWHName").val(checkStatus.data[0].主表仓库);
|
$("#HSupID").val(checkStatus.data[0].HSupID);
|
$("#HSupName").val(checkStatus.data[0].供应商);
|
$("#HEmpID").val(checkStatus.data[0].HEmpID);
|
$("#HEmpName").val(checkStatus.data[0].业务员);
|
$("#HManagerID").val(checkStatus.data[0].HManagerID);
|
$("#HManagerName").val(checkStatus.data[0].主管);
|
$("#HInvoiceBillNo").val(checkStatus.data[0].发票编号);
|
$("#HInnerBillNo").val(checkStatus.data[0].内部单据号);
|
var j = 0;
|
for (var i = 0; i < result.data.length; i++) {
|
var HNewQty = checkStatus.data[j].数量 - checkStatus.data[j].关联数量//数量
|
var HNewMoney = checkStatus.data[j].金额 - checkStatus.data[j].关联数量 * checkStatus.data[j].单价//减少关联数量的金额
|
var HNewTaxMoney = HNewMoney * checkStatus.data[j].税率 * 0.01
|
var HNewlineTotal = HNewMoney + HNewTaxMoney;
|
option.data.push({
|
"HMaterID": checkStatus.data[j].HMaterID, "物料代码": checkStatus.data[j].物料代码, "物料名称": checkStatus.data[j].物料名称, "规格型号": checkStatus.data[j].规格型号,
|
"HUnitID": checkStatus.data[j].HUnitID, "计量单位": checkStatus.data[j].计量单位, "HQtyMust": checkStatus.data[j].数量, "HQty": checkStatus.data[j].数量 - checkStatus.data[j].关联数量, "HRemark": "",
|
"HPrice": checkStatus.data[j].单价, "HMoney": HNewMoney, "HOrderPrice": checkStatus.data[j].金额, "HWHID": checkStatus.data[j].HWHID, "收料仓库": checkStatus.data[j].收料仓库,
|
"HSPID": checkStatus.data[j].HSPID, "仓位名称": checkStatus.data[j].仓位名称, "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0,
|
"HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "",
|
"HSourceBillNo": checkStatus.data[j].单据号, "HSourceBillType": checkStatus.data[j].HBillType, "HSourceInterID": checkStatus.data[j].hmainid, "HSourceEntryID": checkStatus.data[j].hsubid,
|
"HTaxRate": checkStatus.data[j].税率, "HTaxPrice": checkStatus.data[j].含税单价, "HlineTotal": HNewlineTotal
|
})
|
j++;
|
}
|
}
|
table.render(option);
|
layer.close(ajaxLoad);
|
layer.msg("查询成功", { time: 1 * 1000, icon: 1 });
|
} else {
|
layer.alert(result.Message, { icon: 5, btn: ['退出'], time: 100000, offset: 't' });
|
layer.close(ajaxLoad);
|
}
|
}, error: function () {
|
layer.alert(result.Message + "发生错误!", { icon: 5 });
|
layer.close(ajaxLoad);
|
}
|
});
|
}
|
});
|
//#endregion
|
|
//#endregion
|
|
//#region 库存查询
|
function get_Inventory() {
|
var checkStatus = table.checkStatus('mainTable')
|
, data = checkStatus.data;
|
if (checkStatus.data.length === 1 && data[0].HMaterID != 0) {
|
var HMaterID = data[0].HMaterID.toString();
|
//弹窗方法
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '库存查询列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../仓存管理/条码报表/Kf_ICinventoryQueryReport.html?Type=1&HMaterID=' + HMaterID, 'yes']
|
, btn: ['取消']
|
, btn1: function (index, layero) {
|
layer.close(index);
|
}
|
})
|
}
|
else {
|
layer.msg('请选择一行有物料数据查询！');
|
}
|
}
|
//#endregion
|
//#region 出入库记录查询
|
function get_InOutSum() {
|
var checkStatus = table.checkStatus('mainTable')
|
, data = checkStatus.data;
|
if (checkStatus.data.length === 1 && data[0].HMaterID != 0) {
|
var HMaterID = data[0].HMaterID.toString();
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '出入库记录列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../仓存管理/条码报表/Kf_StockInOutSumQueryReport.html?Type=1&HMaterID=' + HMaterID, 'yes']
|
, btn: ['取消']
|
, btn1: function (index, layero) {
|
layer.close(index);
|
}
|
})
|
}
|
else {
|
layer.msg('请选择一行有物料数据查询！');
|
}
|
}
|
//#endregion
|
//#region 根据物料ID获取精度
|
function getDecByMaterID(HMaterID) {
|
var resultData = {};
|
$.ajax({ // 异步请求
|
url: GetWEBURL() + "Gy_Material/getDecByID", //请求地址
|
async: false, //是否开启异步
|
type: "GET", //请求类型
|
data: { //定义发送到服务器的数据
|
"HMaterID": HMaterID // 将hmaterid作为请求参数发送
|
},
|
success: function (result) { // 当请求成功时，执行这个函数
|
if (result.code == 1) { // 如果服务器返回的数据中的`code字段等于1，这可能表示审核操作成功执行
|
var data = result.data; //声明data变量，并将其赋值为result对象中的data属性
|
resultData = data[0]; //将data数组（或类数组对象）的第一个元素赋值给变量resultData
|
}
|
//else {
|
// layer.alert(result.Message, { icon: 5, btn: ['退出'], time: 100000, offset: 't' }); //result.msg对象，提示弹窗 类型为5， 按钮，和按钮的名称为退出 时间 为100秒，以及偏移量（`offset: 't'
|
//}
|
}, error: function () {
|
layer.alert("发生错误!", { icon: 5 }); //提示弹窗 发生错误 ，警示标志为5的
|
}
|
});
|
return resultData;
|
}
|
//#endregion
|
//#region 监听单元格编辑 单元格编辑后 变更
|
table.on('edit(mainTable)', function (obj) {
|
//数值格式校验工具
|
var ref = /^\d+(\.\d+)?$/; //非负数正则表达式
|
var temp = "";
|
var Dec = getDecByMaterID(obj.data.HMaterID) //获取精度
|
var HQtyDec = (Dec["HQtyDec"] == null || Dec["HQtyDec"] == 0) ? 4 : Dec["HQtyDec"]; //数量精度
|
var HPriceDec = (Dec["HPriceDec"] == null || Dec["HPriceDec"] == 0) ? 4 : Dec["HPriceDec"]; //单价精度
|
var HMoneyDec = (Dec["HMoneyDec"] == null || Dec["HMoneyDec"] == 0) ? 2 : Dec["HMoneyDec"]; //金额精度
|
// 单元格编辑之前的值
|
var oldText = $(this).prev().text();
|
var value = obj.value //得到修改后的值
|
, data = obj.data //得到所在行所有键值
|
, field = obj.field; //得到字段
|
|
switch (field) {
|
case "HQty": //数量
|
//数据格式校验
|
temp = value + "";
|
if (!ref.test(temp) || temp == 0) {
|
//恢复数据到编辑前
|
obj.update({
|
HQty: oldText
|
});
|
table.render(option);
|
|
layer.msg("数量请输入大于0的数字!");
|
return;
|
}
|
|
|
//数据校验合格，重算记录
|
var HQty = value * 1; //数量
|
var HPrice = obj.data.HPrice * 1; //单价
|
var HMoney = HQty * HPrice; //金额=数量*单价
|
var HTaxRate = obj.data.HTaxRate * 0.01; //税率
|
var HTaxPrice = HPrice * (1 + HTaxRate); //含税单价=单价*(1+税率)
|
var HTaxMoney = HMoney * HTaxRate; //税额=金额*税率
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
|
|
HQty = Number(HQty.toFixed(HQtyDec));
|
HPrice = Number(HPrice.toFixed(HPriceDec));
|
HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec));
|
HMoney = Number(HMoney.toFixed(HMoneyDec));
|
HlineTotal = Number(HlineTotal.toFixed(HMoneyDec));
|
|
//同步更新表格和缓存对应的值
|
obj.update({
|
HQty: HQty
|
, HPrice: HPrice
|
, HMoney: HMoney
|
, HTaxRate: HTaxRate * 100
|
, HTaxPrice: HTaxPrice
|
, HlineTotal: HlineTotal
|
});
|
table.render(option);
|
break;
|
case "HPrice": //单价
|
//数据格式校验
|
temp = value + "";
|
if (!ref.test(temp) || temp == 0) {
|
//恢复数据到编辑前
|
obj.update({
|
HPrice: oldText
|
});
|
table.render(option);
|
|
layer.msg("单价请输入大于0的数字!");
|
return;
|
}
|
|
//数据校验合格，重算记录
|
var HQty = obj.data.HQty * 1; //数量
|
var HPrice = value * 1;
|
var HMoney = HQty * HPrice; //金额=数量*单价
|
var HTaxRate = obj.data.HTaxRate * 0.01; //税率
|
var HTaxPrice = HPrice * (1 + HTaxRate); //含税单价=单价*(1+税率)
|
var HTaxMoney = HMoney * HTaxRate; //税额=金额*税率
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
|
//设置数据小数位数
|
|
HQty = Number(HQty.toFixed(HQtyDec));
|
HPrice = Number(HPrice.toFixed(HPriceDec));
|
HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec));
|
HMoney = Number(HMoney.toFixed(HMoneyDec));
|
HlineTotal = Number(HlineTotal.toFixed(HMoneyDec));
|
|
//同步更新表格和缓存对应的值
|
obj.update({
|
HQty: HQty
|
, HPrice: HPrice
|
, HMoney: HMoney
|
, HTaxRate: HTaxRate * 100
|
, HTaxPrice: HTaxPrice
|
, HlineTotal: HlineTotal
|
});
|
table.render(option)
|
break;
|
case "HMoney": //金额
|
//数据格式校验
|
temp = value + "";
|
if (!ref.test(temp) || temp == 0) {
|
//恢复数据到编辑前
|
obj.update({
|
HMoney: oldText
|
});
|
table.render(option);
|
|
layer.msg("金额请输入大于0的数字!");
|
return;
|
}
|
|
//数据校验合格，重算记录
|
var HQty = obj.data.HQty * 1; //数量
|
var HMoney = value * 1;
|
var HPrice = (HMoney / HQty); //单价=金额/数量
|
var HTaxRate = obj.data.HTaxRate * 0.01; //税率
|
var HTaxPrice = HPrice * (1 + HTaxRate); //含税单价=单价*(1+税率)
|
var HTaxMoney = HMoney * HTaxRate; //税额=金额*税率
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
|
|
HQty = Number(HQty.toFixed(HQtyDec));
|
HPrice = Number(HPrice.toFixed(HPriceDec));
|
HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec));
|
HMoney = Number(HMoney.toFixed(HMoneyDec));
|
HlineTotal = Number(HlineTotal.toFixed(HMoneyDec));
|
|
|
//同步更新表格和缓存对应的值
|
obj.update({
|
HQty: HQty
|
, HPrice: HPrice
|
, HTaxRate: HTaxRate * 100
|
, HTaxPrice: HTaxPrice
|
, HMoney: HMoney
|
, HlineTotal: HlineTotal
|
});
|
table.render(option);
|
break;
|
case "HTaxRate": //数量
|
//数据格式校验
|
temp = value + "";
|
if (!ref.test(temp)) {
|
//恢复数据到编辑前
|
obj.update({
|
HTaxRate: oldText
|
});
|
table.render(option);
|
|
layer.msg("税率请输入不小于0的数字!");
|
return;
|
}
|
|
|
//数据校验合格，重算记录
|
var HQty = obj.data.HQty * 1; //数量
|
var HPrice = obj.data.HPrice * 1; //单价
|
var HTaxRate = value * 0.01; //税率
|
/*var HDiscountRate = obj.data.HDiscountRate * 1; //折扣率*/
|
var HTaxPrice = HPrice * (1 + HTaxRate); //含税单价=单价*(1+税率)
|
/*var HRelTaxPrice = HTaxPrice * HDiscountRate; //实际含税单价=含税单价*折扣率*/
|
//折扣额 = 含税单价 * (1 - 折扣率) * 数量
|
var HMoney = HQty * HPrice; //金额=数量*单价
|
var HTaxMoney = HMoney * HTaxRate; //税额=金额*税率
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
|
//设置数据小数位数
|
|
HQty = Number(HQty.toFixed(HQtyDec));
|
HPrice = Number(HPrice.toFixed(HPriceDec));
|
HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec));
|
HMoney = Number(HMoney.toFixed(HMoneyDec));
|
HlineTotal = Number(HlineTotal.toFixed(HMoneyDec));
|
|
//同步更新表格和缓存对应的值
|
obj.update({
|
HQty: HQty
|
, HPrice: HPrice
|
, HTaxRate: HTaxRate * 100
|
, HTaxPrice: HTaxPrice
|
, HMoney: HMoney
|
, HlineTotal: HlineTotal
|
});
|
//table.render(option);
|
break;
|
case "HTaxPrice": //单价
|
//数据格式校验
|
temp = value + ""; //修改后的值 转为字符串 赋值给 变量temp
|
// ref很可能是一个正则表达式对象，用于匹配特定的字符串模式。ref.test(temp)会检查变量temp（即转换后的单价字符串）是否符合ref定义的模式。如果test方法返回false
|
if (!ref.test(temp)) { //检查单价字符串是否符合预期的格式
|
//恢复数据到编辑前
|
obj.update({ //更新表格某一行数据
|
HTaxPrice: oldText //将hprice字段恢复到保存前的值
|
});
|
table.render(option);
|
layer.msg("含税单价请输入数字!"); //请输入单价的数值
|
return;
|
}
|
|
//数据校验合格，重算记录
|
var HQty = obj.data.HQty * 1; //数量
|
var HTaxPrice = value * 1; //含税单价
|
var HTaxRate = obj.data.HTaxRate * 0.01; //税率
|
var HPrice = Number((HTaxPrice / (1 + HTaxRate)).toFixed(4)); //单价 = 含税单价/(1+税率)
|
var HMoney = HQty * HPrice; //金额=数量*单价
|
var HTaxMoney = Number((HMoney * HTaxRate).toFixed(4)); //税额=金额*税率
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
|
|
HQty = Number(HQty.toFixed(HQtyDec));
|
HPrice = Number(HPrice.toFixed(HPriceDec));
|
HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec));
|
HMoney = Number(HMoney.toFixed(HMoneyDec));
|
HlineTotal = Number(HlineTotal.toFixed(HMoneyDec));
|
//同步更新表格和缓存对应的值
|
obj.update({ //更新表格数据 方法是该对象提供的一个方法，用于更新其内部状态或与之关联的数据源
|
HQty: HQty //更新HQty字段，HQty
|
, HPrice: HPrice //更新HPrice字段，HPrice
|
, HMoney: HMoney //更新HMoney字段，HMoney
|
, HlineTotal: HlineTotal //更新HlineTotal字段，HlineTotal
|
, HTaxPrice, HTaxPrice //更新HTaxPrice字段，HTaxPrice
|
});
|
table.render(option)
|
break;
|
default:
|
}
|
});
|
//#endregion
|
//#endregion
|
//#endregion
|
|
|
//#region 本页面所有被调用的方法
|
|
//#region 打印
|
function get_PrintReport() {
|
layer.open({
|
type: 2
|
, area: ['50%', '50%']
|
, title: '打印模版选择'
|
, shade: 0.6 //遮罩透明度
|
, maxmin: false //允许全屏最小化
|
, anim: 0 //0-6的动画形式，-1不开启
|
, content: ['../../BaseSet/SRM_OpenTmpList.html?linterid=' + linterid.toString() + '&MyMsg=' + linterid.toString() + '&Type=HPOStockInBillByID', 'yes']
|
, resize: false
|
})
|
}
|
//#endregion
|
|
|
//#region 判断是否登录 未登录则跳到登录页
|
function get_LoginIs() {
|
if (sessionStorage.login != "login") {
|
layer.confirm("登录失效，请重新登录！", {
|
icon: 4, skin: 'layui-layer-lan', title: "温馨提示", closeBtn: 0, btn: ['重新登录']
|
}, function () { window.location.href = "../../user/login.html"; });
|
}
|
}
|
//#endregion
|
|
|
//获取组织
|
function Organ() {
|
//获取登录页组织列
|
$.ajax({
|
type: "get",
|
url: GetWEBURL() + "/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");
|
}
|
})
|
}
|
|
|
//日期格式化
|
function formatDate(date) {
|
var d = new Date(date),
|
month = '' + (d.getMonth() + 1),
|
day = '' + d.getDate(),
|
year = d.getFullYear();
|
|
if (month.length < 2) month = '0' + month;
|
if (day.length < 2) day = '0' + day;
|
|
return [year, month, day].join('-');
|
}
|
|
|
//子表
|
|
function set_InitGrid() {
|
option = {
|
elem: '#mainTable'
|
, toolbar: '#toolbarDemo'
|
, limit: 500
|
, height: 500
|
, loading: false
|
, totalRow: true
|
, cols: [[ //子表
|
{ type: 'checkbox', totalRowText: '合计行' }
|
, { type: 'numbers',field: '序号', title: '序号', width: 100 }
|
, { field: 'HSourceBillNo', title: '源单号', width: 100, hide: true }//源单号
|
, { field: 'HSourceBillType', title: '源单类型', width: 100, hide: true }//源单类型
|
, { field: 'HSourceInterID', title: '源单主内码', width: 100, hide: true }//源单主内码
|
, { field: 'HSourceEntryID', title: '源单子内码', width: 100, hide: true }//源单子内码
|
, { field: 'HMaterID', title: 'HMaterID', width: 100, hide: true }
|
, { field: '物料代码', title: '物料代码', width: 150, edit: 'text', event: "HMaterID" }//f7
|
, { field: '物料名称', title: '物料名称', width: 150, style: 'background-color:#efefef4d;' }
|
, { field: '规格型号', title: '规格型号', width: 100, style: 'background-color:#efefef4d;'}
|
, { field: 'HUnitID', title: 'HUnitID', width: 100, hide: true }
|
, { field: '计量单位', title: '计量单位', width: 100, edit: 'text', event: "HUnitID" }//f7
|
, { field: 'HQtyMust', title: '应收数量', width: 150, edit: 'text', totalRow: true}
|
, { field: 'HQty', title: '实收数量', width: 150, edit: 'text', totalRow: true}
|
, { field: 'HPrice', title: '单价', width: 100, edit: 'text' }
|
, { field: 'HMoney', title: '金额', width: 100, edit: 'text', totalRow: true }
|
, { field: 'HOrderPrice', title: '采购金额', width: 100, edit: 'text', totalRow: true}
|
, { field: 'HWHID', title: 'HWHID', width: 100, hide: true }
|
, { field: '收料仓库', title: '收料仓库', width: 100, edit: 'text', event: "HWHID" }//f7
|
, { field: 'HSPID', title: 'HSPID', width: 100, hide: true }
|
, { field: '仓位名称', title: '仓位名称', width: 100, edit: 'text', event: "HSPID" }//f7
|
, { field: 'HTaxRate', title: '税率', width: 100, edit: 'text' }
|
, { field: 'HTaxPrice', title: '含税单价', width: 100, edit: 'text' }
|
, { field: 'HlineTotal', title: '含税金额', width: 100, style: 'background-color:#efefef4d;' }
|
, { field: 'HBatchNo', title: '批次', width: 150, edit: 'text' }
|
, { field: 'HRemark', title: '备注', width: 100, edit: 'text' }
|
, { fixed: 'right', title: '操作', toolbar: '#barDemo', width: 70 }
|
]]
|
}
|
|
option.data = [];
|
table.render(option);
|
DisPlay_HideColumn();
|
|
}
|
|
//#region 加载表头
|
function RoadBillMain(linterid) {
|
//查询检验方案单是否存在
|
var ajaxLoad = layer.load();
|
$.ajax({
|
url: GetWEBURL() + "Kf_POStockInBill/cx",
|
type: "GET",
|
data: {
|
"HInterID": linterid
|
},
|
success: function (result) {
|
if (result.code == 1) { // 说明验证成功了，
|
var data = result.data[0];
|
allVal = result.data[0];
|
form.val("component-form-group", { //formTest 即 class="layui-form" 所在元素属性 lay-filter="" 对应的值
|
"HBillNo": data.单据号
|
, "HDate": formatDate(data.日期)
|
, "HInnerBillNo": data.内部单据号
|
, "HSupID": data.HSupID
|
, "HSupName": data.供应商
|
, "HEmpID": data.HEmpID
|
, "HEmpName": data.业务员
|
, "HWHID": data.主表仓库ID
|
, "HWHName": data.主表仓库
|
, "HSecManagerID": data.HSecManagerID
|
, "HSecManagerName": data.验收员
|
, "HKeeperID": data.HKeeperID
|
, "HKeeperName": data.保管员
|
, "HDeptName": data.部门
|
, "HDeptID": data.HDeptID
|
, "HSourceBillType": data.源单类型
|
, "HManagerID": data.HManagerID
|
, "HManagerName": data.负责人
|
, "HExRate": data.汇率
|
, "HProjectID": data.HProjectID
|
, "HProjectNumber": data.项目代码
|
, "HProjectName": data.项目名称
|
, "HInvoiceBillNo": data.发票编号
|
, "HExplanation ":data.摘要
|
//, "Box2": ""
|
, "HRemark": data.表头备注
|
, "HMaker": data.制单人
|
, "HChecker": data.审核人
|
, "HCloseMan": data.关闭人
|
, "HMakeDate": data.制单日期 == null ? "" : Pub_Format(data.制单日期, "yyyy-MM-dd hh:mm:ss")
|
, "HCheckDate": data.审核日期 == null ? "" : Pub_Format(data.审核日期, "yyyy-MM-dd hh:mm:ss")
|
, "HCloseDate": data.关闭日期 == null ? "" : Pub_Format(data.关闭日期, "yyyy-MM-dd hh:mm:ss")
|
, "HUpDateDate": data.修改日期 == null ? "" : Pub_Format(data.修改日期, "yyyy-MM-dd hh:mm:ss")
|
, "HDeleteDate": data.作废日期 == null ? "" : Pub_Format(data.作废日期, "yyyy-MM-dd hh:mm:ss")
|
|
});
|
//子表 赋值
|
subdata=result.data
|
var rowdata = [];
|
for (var i = 0; i < subdata.length; i++) {
|
rowdata.push(
|
{
|
"HMaterID": subdata[i].HMaterID, "物料代码": subdata[i].物料代码, "物料名称": subdata[i].物料名称, "规格型号": subdata[i].规格型号, "HUnitID": subdata[i].HUnitID, "计量单位": subdata[i].计量单位,
|
"HQtyMust": subdata[i].应收数量, "HQty": subdata[i].实收数量, "HRemark": subdata[i].表体备注, "HPrice": subdata[i].单价, "HMoney": subdata[i].金额, "HOrderPrice": subdata[i].采购金额, "HWHID": subdata[i].HWHID, "收料仓库": subdata[i].收料仓库, "HSPID": subdata[i].HSPID, "仓位名称": subdata[i].仓位名称,
|
"HBatchNo": subdata[i].批次,
|
"HSourceBillNo": subdata[i].源单单号, //源单号
|
"HSourceBillType": subdata[i].源单类型, //源单类型
|
"HSourceInterID": subdata[i].源单主内码, //源单主内码
|
"HSourceEntryID": subdata[i].源单子内码, //源单子内码
|
"HTaxRate": subdata[i].税率, "HTaxPrice": subdata[i].含税单价, "HlineTotal": subdata[i].含税金额
|
}
|
)
|
}
|
option.data = rowdata;
|
table.render(option);
|
form.render('select');
|
|
layer.close(ajaxLoad);
|
} else {
|
layer.close(ajaxLoad);
|
layer.alert(result.msg, { icon: 5, btn: ['退出'], time: 100000, offset: 't' });
|
}
|
}, error: function () {
|
layer.close(ajaxLoad);
|
layer.alert("发生错误!", { icon: 5 });
|
}
|
});
|
}
|
//#endregion
|
|
//退出
|
form.on('submit(Exit)', function (data) {
|
if (linterid == undefined) {
|
//关闭页签
|
Pub_Close(2);
|
}
|
else {
|
//关闭页签
|
Pub_Close(1);
|
}
|
});
|
|
//#region 保存按钮
|
form.on('submit(Saver)', function (data) {
|
//#region 判断源单状态
|
if (OperationType == 1 || OperationType == 4) {
|
|
if ($("#HSourceBillType").val() == "1102") {
|
for (var i = 0; i < option.data.length; i++) {
|
if (option.data[i] != []) {
|
var HSourceBillData = "";
|
var HSourceBillData = getPushSource_POOrderBillInit(option.data[i].HSourceInterID, option.data[i].HSourceEntryID); //获取源单数据
|
if (HSourceBillData != "none") {
|
if (HSourceBillData == null) {
|
if (option.data[i].HSourceInterID!=0) {
|
layer.alert("保存失败!第" + (i + 1) + "行：未查询到源单单据!", { icon: 5 });
|
return;
|
}
|
|
} else if (HSourceBillData.状态 != "已审核") {
|
var err = "保存失败!原因：第" + (i + 1) + "行-源单单据状态为“" + HSourceBillData.状态 + "”，不允许保存！";
|
layer.alert(err, { icon: 5 });
|
return;
|
} else if (HSourceBillData.行状态 == "已关闭") {
|
layer.alert("保存失败!第" + (i + 1) + "行：该行记录行状态为'已关闭'状态!", { icon: 5 });
|
return;
|
}
|
} else {
|
return;
|
}
|
}
|
}
|
}
|
else if ($("#HSourceBillType").val() == "1103") {
|
for (var i = 0; i < option.data.length; i++) {
|
if (option.data[i] != []) {
|
var HSourceBillData = "";
|
var HSourceBillData = getPushSource_POInStockBillInit(option.data[i].HSourceInterID, option.data[i].HSourceEntryID); //获取源单数据
|
if (HSourceBillData != "none") {
|
if (HSourceBillData == null) {
|
if (option.data[i].HSourceInterID != 0) {
|
layer.alert("保存失败!第" + (i + 1) + "行：未查询到源单单据!", { icon: 5 });
|
return;
|
}
|
} else if (HSourceBillData.状态 != "已审核") {
|
var err = "保存失败!原因：第" + (i + 1) + "行-源单单据状态为“" + HSourceBillData.状态 + "”，不允许保存！";
|
layer.alert(err, { icon: 5 });
|
return;
|
} else if (HSourceBillData.行状态 == "已关闭") {
|
layer.alert("保存失败!第" + (i + 1) + "行：该行记录行状态为'已关闭'状态!", { icon: 5 });
|
return;
|
}
|
} else {
|
return;
|
}
|
}
|
}
|
}
|
else {
|
return layer.msg('当前不支持该源单！！');
|
}
|
}
|
//#endregion
|
|
if (AllowLoadData(data)) {
|
set_SaveBill(data);
|
}
|
});
|
//#endregion
|
|
|
//#region 获取参数_传递的JSON格式参数
|
function getUrlVars_JSON() {
|
var datajson;
|
var str = window.location.search; //获取链接中传递的参数
|
var arr = str.substring(str.lastIndexOf("=")+1);
|
datajson = $.parseJSON(decodeURI(arr));
|
return datajson;
|
}
|
//#endregion
|
|
//#region 下推页面初始化
|
function setInit_PushBill() {
|
//生成单据号和内码
|
get_MAXNum();
|
|
//初始化日期、制单人、制单日期
|
$("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
|
$("#HReceiveDate").val(Format(new Date(), "yyyy-MM-dd"));
|
$("#HMaker").val(sessionStorage["HUserName"]);
|
$("#HMakeDate").val(Format(new Date(), "yyyy-MM-dd hh:mm:ss"));
|
|
//设置源单类型
|
$("#HSourceBillType").val(HSouceBillType);
|
|
//禁用组织选项
|
$("#HOrgID").attr("disabled", true);
|
|
|
|
if ($("#HSourceBillType").val() == "1102") {
|
//获取 销售订单
|
var data = getUrlVars_JSON().data;
|
var dataArray = [];
|
for (var i = 0; i < data.length; i++) {
|
var temp = getPushSource_POOrderBillInit(data[i].hmainid, data[i].hsubid);
|
if (temp != "none") {
|
dataArray.push(temp);
|
} else {
|
return;
|
}
|
}
|
|
form.val("component-form-group", { //formTest 即 class="layui-form" 所在元素属性 lay-filter="" 对应的值
|
"HMainSourceInterID": "0"
|
, "HMainSourceEntryID": "0"
|
, "HMainSourceBillNo": ""
|
, "HMainSourceBillType": $("#BillType").val()
|
|
, "HDeptID": dataArray[0].HDeptID
|
, "HDeptName": dataArray[0].部门
|
, "HManagerID": dataArray[0].HManagerID
|
, "HManagerName": dataArray[0].主管
|
, "HWHID": dataArray[0].HWHID
|
, "HWHName": dataArray[0].仓库
|
, "HEmpID": dataArray[0].HEmpID
|
, "HEmpName": dataArray[0].业务员
|
, "HSecManagerID": dataArray[0].HSecManagerID
|
, "HSecManagerName": dataArray[0].验收员
|
, "HKeeperID": dataArray[0].HKeeperID
|
, "HKeeperName": dataArray[0].保管员
|
, "HSupID": dataArray[0].HSupID
|
, "HSupName": dataArray[0].供应商
|
, "HCurID": dataArray[0].HCurID
|
, "HCurName": dataArray[0].币别
|
, "HExRate": dataArray[0].汇率
|
, "HSSID": dataArray[0].HSSID
|
, "HSSName": dataArray[0].结算方式
|
, "HPSStyleID": dataArray[0].HPSStyleID
|
, "HPSStyleName": dataArray[0].采购方式
|
, "HProjectID": dataArray[0].HProjectID
|
, "HProjectNumber": dataArray[0].项目代码
|
, "HProjectName": dataArray[0].项目名称
|
, "HInvoiceBillNo": dataArray[0].发票编号
|
, "HInnerBillNo": dataArray[0].内部单据号
|
});
|
|
//子表 赋值
|
var rowdata = [];
|
for (var i = 0; i < dataArray.length; i++) {
|
rowdata.push(
|
{
|
"HMaterID": dataArray[i].HMaterID
|
, "物料代码": dataArray[i].物料代码
|
, "物料名称": dataArray[i].物料名称
|
, "规格型号": dataArray[i].规格型号
|
, "HUnitID": dataArray[i].HUnitID
|
, "计量单位": dataArray[i].计量单位
|
, "HQty": dealDoubleToFixed(dataArray[i].数量, 1)
|
, "HPrice": dealDoubleToFixed(dataArray[i].单价, 3)
|
, "HTaxPrice": dealDoubleToFixed(dataArray[i].含税单价, 3)
|
, 'HDiscountRate': "0" //
|
, 'HRelTaxPrice': "0"
|
, "HTaxRate": dataArray[i].税率
|
, 'HTaxMoney': "0" //
|
, "HMoney": dealDoubleToFixed(dataArray[i].金额, 2)
|
, 'HMoneyBB': dealDoubleToFixed(dataArray[i].金额 * dataArray[0].汇率, 2)
|
, 'HlineTotal': dealDoubleToFixed(dataArray[i].价税合计, 2)
|
, 'HlineTotalBB': dealDoubleToFixed(dataArray[i].价税合计 * dataArray[0].汇率, 2)
|
, "HRemark": ""
|
, "HWHID": dataArray[i].HWHID
|
, "收料仓库": dataArray[i].收料仓库
|
, "HSPID": dataArray[i].HSPID
|
, "仓位名称": dataArray[i].仓位名称
|
// ，"HBatchNo": dataArray[i].批次
|
|
, "HSourceInterID": dataArray[i].hmainid
|
, "HSourceEntryID": dataArray[i].hsubid
|
, "HSourceBillNo": dataArray[i].单据号
|
, "HSourceBillType": dataArray[i].HBillType
|
, "HRelationQty": "0"
|
, "HRelationMoney": "0"
|
|
, 'HPOOrderInterID': "0"
|
, 'HPOOrderEntryID': "0"
|
, 'HPOOrderBillNo': ""
|
|
, 'HSeOrderTaxPrice': dealDoubleToFixed(dataArray[i].含税单价, 3)
|
, "HSeOrderInterID": dataArray[i].hmainid
|
, "HSeOrderEntryID": dataArray[i].hsubid
|
, "HSeOrderBillNo": dataArray[i].单据号
|
, "HTaxRate": 0
|
, "HTaxPrice": 0
|
, "HlineTotal": 0
|
}
|
);
|
}
|
option.data = rowdata;
|
table.render(option);
|
}
|
else if ($("#HSourceBillType").val() == "1103") {
|
//获取 收料通知单
|
var data = getUrlVars_JSON().data;
|
var dataArray = [];
|
for (var i = 0; i < data.length; i++) {
|
var temp = getPushSource_POInStockBillInit(data[i].hmainid, data[i].hsubid);
|
if (temp != "none") {
|
dataArray.push(temp);
|
} else {
|
return;
|
}
|
}
|
|
form.val("component-form-group", { //formTest 即 class="layui-form" 所在元素属性 lay-filter="" 对应的值
|
"HMainSourceInterID": "0"
|
, "HMainSourceEntryID": "0"
|
, "HMainSourceBillNo": ""
|
, "HMainSourceBillType": $("#BillType").val()
|
|
, "HDeptID": dataArray[0].HDeptID
|
, "HDeptName": dataArray[0].部门
|
, "HManagerID": dataArray[0].HManagerID
|
, "HManagerName": dataArray[0].主管
|
, "HEmpID": dataArray[0].HEmpID
|
, "HEmpName": dataArray[0].业务员
|
, "HSupID": dataArray[0].HSupID
|
, "HSupName": dataArray[0].供应商
|
, "HCurID": dataArray[0].HCurID
|
, "HCurName": dataArray[0].币别
|
, "HExRate": dataArray[0].汇率
|
, "HWHName": dataArray[0].主表仓库
|
, "HWHID": dataArray[0].主表仓库ID
|
, "HSSID": "0"
|
, "HSSName": ""
|
, "HProjectID": dataArray[0].HProjectID
|
, "HProjectNumber": dataArray[0].项目代码
|
, "HProjectName": dataArray[0].项目名称
|
, "HInvoiceBillNo": dataArray[0].发票编号
|
, "HInnerBillNo": dataArray[0].内部单据号
|
});
|
|
//子表 赋值
|
var rowdata = [];
|
|
for (var i = 0; i < dataArray.length; i++) {
|
rowdata.push(
|
{
|
"HMaterID": dataArray[i].HMaterID
|
, "物料代码": dataArray[i].物料代码
|
, "物料名称": dataArray[i].物料名称
|
, "规格型号": dataArray[i].规格型号
|
, "HUnitID": dataArray[i].HUnitID
|
, "计量单位": dataArray[i].计量单位
|
, "HQty": dealDoubleToFixed(dataArray[i].数量, 2)
|
, "HPrice": dealDoubleToFixed(dataArray[i].单价, 3)
|
, "HTaxPrice": dealDoubleToFixed(dataArray[i].含税单价, 3)
|
, "HQtyMust": dealDoubleToFixed(dataArray[i].数量, 2)
|
, "HOrderPrice": dealDoubleToFixed(dataArray[i].数量 * dataArray[i].单价, 2)
|
, 'HDiscountRate': "0" //
|
, 'HRelTaxPrice': "0"
|
, "HTaxRate": dataArray[i].税率
|
, 'HTaxMoney': "0" //
|
, "HMoney": dealDoubleToFixed(dataArray[i].数量 * dataArray[i].单价, 2)
|
, 'HMoneyBB': dealDoubleToFixed(dataArray[i].数量 * dataArray[i].单价 * dataArray[0].汇率, 2)
|
, 'HlineTotal': dealDoubleToFixed(dataArray[i].数量 * dataArray[i].含税单价, 2)
|
, 'HlineTotalBB': dealDoubleToFixed(dataArray[i].数量 * dataArray[i].含税单价 * dataArray[0].汇率, 2)
|
, "HRemark": ""
|
, "HWHID": dataArray[i].HWHID
|
, "收料仓库": dataArray[i].收料仓库
|
, "HSPID": dataArray[i].HSPID
|
, "仓位名称": dataArray[i].仓位名称
|
|
, "HSourceInterID": dataArray[i].hmainid
|
, "HSourceEntryID": dataArray[i].hsubid
|
, "HSourceBillNo": dataArray[i].单据号
|
, "HSourceBillType": dataArray[i].HBillType
|
, "HRelationQty": "0"
|
, "HRelationMoney": "0"
|
|
, 'HPOOrderInterID': "0"
|
, 'HPOOrderEntryID': "0"
|
, 'HPOOrderBillNo': ""
|
|
, 'HSeOrderTaxPrice': dealDoubleToFixed(dataArray[i].含税单价, 3)
|
, "HSeOrderInterID": dataArray[i].HSourceBillType == "1401" ? dataArray[i].HSourceInterID : "0"
|
, "HSeOrderEntryID": dataArray[i].HSourceBillType == "1401" ? dataArray[i].HSourceEntryID : "0"
|
, "HSeOrderBillNo": dataArray[i].HSourceBillType == "1401" ? dataArray[i].源单单号 : ""
|
}
|
);
|
}
|
option.data = rowdata;
|
table.render(option);
|
}
|
else
|
{
|
return layer.msg('当前不支持该源单下推！！');
|
}
|
}
|
|
//#endregion
|
//#region 保存方法
|
function set_SaveBill(data) {
|
//if ($("#HEmpName").val() == 0) {
|
// layer.msg("请选择业务员！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
// return;
|
//}
|
|
if ($("#HDeptName").val() == 0) {
|
layer.msg("请选择部门！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
return;
|
}
|
if ($("#HSPID").val() == 0) {
|
layer.msg("请选择供应商！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
return;
|
}
|
if ($("#HWHName").val() == 0) {
|
layer.msg("请选择仓库！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
return;
|
}
|
//if ($("#HKeeperID").val() == 0) {
|
// layer.msg("请选择保管员！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
// return;
|
//}
|
//if ($("#HSecManagerID").val() == 0) {
|
// layer.msg("请选择验收员！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
// return;
|
//}
|
|
|
var num = [];
|
for (var i = 0; i < table.cache["mainTable"].length; i++) {
|
if (table.cache["mainTable"][i] != "") {
|
table.cache["mainTable"][i].LAY_TABLE_INDEX = i;
|
num.push(table.cache["mainTable"][i])
|
}
|
}
|
|
checkDuplicateData(num);
|
const duplicateRows = checkDuplicateData(num);
|
if (duplicateRows.length > 0) {
|
let message = '表格中存在重复数据，重复行数为：';
|
|
for (let i = 0; i < duplicateRows.length; i++) {
|
const { row1, row2 } = duplicateRows[i];
|
message += `第${row1}行与第${row2}行相同`;
|
|
if (i !== duplicateRows.length - 1) {
|
message += '，';
|
}
|
}
|
|
message += '，请删除其中一行';
|
layer.alert(message);
|
}
|
|
|
var sMainStr = JSON.stringify(data.field);
|
var sSubStr = JSON.stringify(num);
|
var sAllStr = JSON.stringify(allVal);
|
//var hentryid = linteridSub;//子表 排序id
|
var sMainSub = sMainStr + ';' + sSubStr + ';' + OperationType + ";" + sessionStorage["HUserName"] + ";" + sAllStr;
|
|
$.ajax({
|
type: "POST",
|
url: GetWEBURL() + "Kf_POStockInBill/POStockInBillEdit", //方法所在页面和方法名
|
async: true,
|
data: { "sMainSub": sMainSub },
|
dataType: "json",
|
success: function (data) {
|
if (data.count == 1) { // 说明验证成功了，
|
layer.msg(data.Message, { icon: 1 });
|
if (data.Verify == "Y") //自动审核
|
{
|
$("#HInterID").val(data.HInterID);//获取提交成功返回的单据主ID
|
set_CheckBill(0); //审核
|
}
|
$('#add-btn').addClass("layui-btn-disabled").attr("disabled", true);
|
//保存后浏览
|
//ReRoadBillMain();
|
$('#print-btn').prop('disabled', false).removeClass('layui-btn-disabled');
|
}
|
else {
|
layer.alert(data.Message, { icon: 5 });
|
}
|
layer.closeAll("loading");
|
},
|
error: function (err) {
|
layer.alert("错误:" + err, { icon: 5 });
|
console.log("Reason" + sMainStr);
|
}
|
});
|
}
|
//#endregion
|
|
////#endregion
|
|
function get_checkEmp() {
|
var HOrgID = $("#HOrgID").val();
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '业务员列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/公用基础资料/Gy_EmployeeList.html?Type=HEmp&HOrgID=' + HOrgID, 'yes']
|
, btn: ['确定', '取消']
|
, btn1: function (index, layero) {//按钮【按钮一】的回调
|
var iframeWindow = window['layui-layer-iframe' + index] //获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
|
if (checkStatus.data.length === 0) {
|
return layer.msg('请选择数据');
|
}
|
$("#HEmpName").val(checkStatus.data[0].职员名称);
|
$("#HEmpID").val(checkStatus.data[0].HItemID);
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
function get_checkSup() {
|
var HOrgName = $('select[name="HOrgID"] option:selected').text();
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '供应商列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/采购基础资料/Gy_Supplier.html?Type=HSup&HOrgName=' + HOrgName, 'yes']
|
, btn: ['确定', '取消']
|
, btn1: function (index, layero) {//按钮【按钮一】的回调
|
var iframeWindow = window['layui-layer-iframe' + index] //获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
|
if (checkStatus.data.length === 0) {
|
return layer.msg('请选择数据');
|
}
|
$("#HSupName").val(checkStatus.data[0].供应商名称);
|
$("#HSupID").val(checkStatus.data[0].HItemID);
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
//工程项目
|
function get_btnHProjectID() {
|
var HOrgID = $("#HOrgID").val();
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '项目列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../项目管理/工程项目/PM_ProjectBillList.html?Type=2&HOrgID=' + HOrgID, 'yes']
|
, btn: ['确定', '取消']
|
, btn1: function (index, layero) {//按钮【按钮一】的回调
|
var iframeWindow = window['layui-layer-iframe' + index] //获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
|
if (checkStatus.data.length === 0) {
|
return layer.msg('请选择数据');
|
}
|
$("#HProjectName").val(checkStatus.data[0].项目名称);
|
$("#HProjectNumber").val(checkStatus.data[0].项目代码);
|
$("#HProjectID").val(checkStatus.data[0].HInterID);
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
function get_checkWH() {
|
var HOrgName = $('select[name="HOrgID"] option:selected').text();
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '仓库列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/公用基础资料/Gy_Warehouse.html?Type=HWH&HOrgName=' + HOrgName, 'yes']
|
, btn: ['确定', '取消']
|
, btn1: function (index, layero) {//按钮【按钮一】的回调
|
var iframeWindow = window['layui-layer-iframe' + index] //获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
|
if (checkStatus.data.length === 0) {
|
return layer.msg('请选择数据');
|
}
|
$("#HWHName").val(checkStatus.data[0].仓库名称);
|
$("#HWHID").val(checkStatus.data[0].HItemID);
|
|
if (option.data.length > 0) {
|
for (var i = 0; i < option.data.length; i++) {
|
if (option.data[i]["HWHID"] == 0) {
|
option.data[i]["HWHID"] = checkStatus.data[0].HItemID;
|
option.data[i]["收料仓库"] = checkStatus.data[0].仓库名称;
|
}
|
}
|
}
|
table.render(option);
|
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
function get_checkSecManager() {
|
var HOrgID = $("#HOrgID").val();
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '验收员列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/公用基础资料/Gy_EmployeeList.html?Type=HSecManager&HOrgID=' + HOrgID, 'yes']
|
, btn: ['确定', '取消']
|
, btn1: function (index, layero) {//按钮【按钮一】的回调
|
var iframeWindow = window['layui-layer-iframe' + index] //获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
|
if (checkStatus.data.length === 0) {
|
return layer.msg('请选择数据');
|
}
|
$("#HSecManagerName").val(checkStatus.data[0].职员名称);
|
$("#HSecManagerID").val(checkStatus.data[0].HItemID);
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
function get_checkKeeper() {
|
var HOrgID = $("#HOrgID").val();
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '保管员列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/公用基础资料/Gy_EmployeeList.html?Type=HKeeper&HOrgID=' + HOrgID, 'yes']
|
, btn: ['确定', '取消']
|
, btn1: function (index, layero) {//按钮【按钮一】的回调
|
var iframeWindow = window['layui-layer-iframe' + index] //获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
|
if (checkStatus.data.length === 0) {
|
return layer.msg('请选择数据');
|
}
|
$("#HKeeperName").val(checkStatus.data[0].职员名称);
|
$("#HKeeperID").val(checkStatus.data[0].HItemID);
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
function get_checkDept() {
|
var HOrgName = $('select[name="HOrgID"] option:selected').text();
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '部门列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/公用基础资料/Gy_DepartmentList.html?Type=2&HOrgName=' + HOrgName, 'yes']
|
, btn: ['确定', '取消']
|
, btn1: function (index, layero) {//按钮【按钮一】的回调
|
var iframeWindow = window['layui-layer-iframe' + index] //获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
|
if (checkStatus.data.length === 0) {
|
return layer.msg('请选择数据');
|
}
|
$("#HDeptName").val(checkStatus.data[0].部门名称);
|
$("#HDeptID").val(checkStatus.data[0].HItemID);
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
|
function get_checkManager() {
|
var HOrgID = $("#HOrgID").val();
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '负责人列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/公用基础资料/Gy_EmployeeList.html?Type=HWorker&HOrgID=' + HOrgID, 'yes']
|
, btn: ['确定', '取消']
|
, btn1: function (index, layero) {//按钮【按钮一】的回调
|
var iframeWindow = window['layui-layer-iframe' + index] //获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
|
if (checkStatus.data.length === 0) {
|
return layer.msg('请选择数据');
|
}
|
$("#HManagerName").val(checkStatus.data[0].职员名称);
|
$("#HManagerID").val(checkStatus.data[0].HItemID);
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
|
//#region 反审核/审核数据
|
function set_CheckBill(num) {
|
var InterID = $("#HInterID").val();
|
//逻辑审核方法
|
$.ajax({
|
type: "GET",
|
url: GetWEBURL() + "/Kf_POStockInBill/AuditKf_POStockInBill", //方法所在页面和方法名
|
data: { "HInterID": InterID, "IsAudit": num, "CurUserName": sessionStorage["HUserName"] },
|
success: function (result) {
|
if (result.count == 1) {
|
layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
|
// 得到frame索引
|
var index = layer.getFrameIndex(window.name);
|
//关闭当前frame
|
layer.close(index);
|
});
|
|
} else {
|
layer.alert(result.code + result.Message, { icon: 5 });
|
}
|
}, error: function () {
|
layer.alert("接口请求失败!", { icon: 5 });
|
}
|
});
|
}
|
//#endregion
|
|
//行内快捷键筛选
|
function set_GridCellCheck(obj) {
|
$(document).off('keydown', ".layui-table-edit").on('keydown', '.layui-table-edit', function (e) {
|
//#region 子表文本框输入后检索数据
|
if (event.key != "F7") {
|
var errKeys = ["ArrowUp", "ArrowDown", "ArrowLeft", "ArrowRight", "Enter"];
|
if (obj.event == "HMaterID") { //定位当前正在输入的文本框的列名
|
if ($.inArray(event.key, errKeys) == -1) { //如果按下的键位不是 方向键，则刷新弹窗中的数据
|
if (childPage == null) { //判断当前子窗口是否已经打开，若未打卡，则打开页面，并获取子窗口的对象
|
var offset = $(this).offset(); //获取触发事件的元素的位置，用于定位子窗口打开的位置
|
var innerHeight = window.innerHeight;
|
var top = offset.top + 0.05 * innerHeight;
|
var left = offset.left;
|
if (top + 0.05 * innerHeight + 0.3 * innerHeight > innerHeight) {
|
top = top - 0.3 * innerHeight - 0.05 * innerHeight;
|
}
|
layer.open({
|
type: 2 //弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['25%', '30%'] //大小
|
, shadeClose: true //点击遮罩时关闭弹窗
|
, offset: [top, left]
|
, title: false //不显示标题栏
|
//, title: '项目费用列表' //标题
|
, shift: 2 //弹出动画
|
, closeBtn: 0 //禁用关闭按钮
|
, content: ["../../基础资料/通用基础资料/Gy_CommonBaseData.html?OperationType=2", "yes"]
|
, success: function (layero, index) {
|
setTimeout(function () {
|
var value = $(e.currentTarget).val().replace("'", ""); //获取文本框最新值
|
currRowIndex = 0;
|
var tableView = "h_v_Gy_MaterialList";
|
var childSWhere = "select top(10) HItemID,物料代码,物料名称,规格型号,HUnitID,计量单位名称 from " + tableView + " where 1=1 and 组织名称 = '" + sessionStorage["Organization"] + "' and (物料代码 like '%" + value + "%' or 物料名称 like '%" + value + "%') order by 物料代码 desc";
|
childPage.getData(childSWhere, tableView);
|
}, 200);
|
}
|
, end: function () {
|
obj.event = "";
|
childPage = null;
|
currRowIndex = 0;
|
if (childData != null) {
|
OptionData = childData;
|
|
//通过供应商id获取税率
|
var HSupID = $("#HSupID").val();
|
if (HSupID != 0 && typeof (OptionData.HItemID) != "undefined") {
|
var Dec = getDecByMaterID(obj.data.HMaterID) //获取精度
|
var HQtyDec = (Dec["HQtyDec"] == null || Dec["HQtyDec"] == 0) ? 4 : Dec["HQtyDec"]; //数量精度
|
var HPriceDec = (Dec["HPriceDec"] == null || Dec["HPriceDec"] == 0) ? 4 : Dec["HPriceDec"]; //单价精度
|
var HMoneyDec = (Dec["HMoneyDec"] == null || Dec["HMoneyDec"] == 0) ? 2 : Dec["HMoneyDec"]; //金额精度
|
$.ajax({
|
url: GetWEBURL() + "/Gy_Supplier/xg",
|
//url: "http://localhost:12761/Gy_Supplier/xg",
|
type: "GET",
|
data: {
|
"HInterID": HSupID
|
},
|
success: function (d) {
|
var HTaxRate = parseInt(d.data[0].增值税率) * 0.01;
|
//数据校验合格，重算记录
|
var HQty = obj.data.HQty * 1; //数量
|
var HPrice = obj.data.HPrice * 1; //单价
|
var HMoney = HQty * HPrice; //金额=数量*单价
|
var HTaxMoney = Number((HMoney * HTaxRate)); //税额=金额*税率
|
var HTaxPrice = Number((HPrice * (1 + HTaxRate))); //含税单价=单价*(1+税率)
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
//数字精度
|
HQty = Number(HQty.toFixed(HQtyDec));
|
HPrice = Number(HPrice.toFixed(HPriceDec));
|
HMoney = Number(HMoney.toFixed(HMoneyDec));
|
HTaxMoney = Number(HTaxMoney.toFixed(HMoneyDec));
|
HlineTotal = Number(HlineTotal.toFixed(HMoneyDec));
|
HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec));
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.物料代码
|
, "物料名称": OptionData.物料名称
|
, "规格型号": OptionData.规格型号
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.计量单位名称
|
, "HTaxRate": HTaxRate * 100
|
, "HQty": HQty //更新HQty字段，HQty
|
, "HPrice": HPrice //更新HPrice字段，HPrice
|
, "HMoney": HMoney //更新HMoney字段，HMoney
|
, "HlineTotal": HlineTotal //更新HlineTotal字段，HlineTotal
|
, "HTaxPrice": HTaxPrice //更新HTaxPrice字段，HTaxPrice
|
})
|
}
|
});
|
} else if (typeof (OptionData.HItemID) != "undefined") {
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.物料代码
|
, "物料名称": OptionData.物料名称
|
, "规格型号": OptionData.规格型号
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.计量单位名称
|
})
|
}
|
|
OptionData = {};
|
|
childData = null;
|
}
|
}
|
});
|
} else {
|
setTimeout(function () {
|
var value = $(e.currentTarget).val().replace("'", ""); //获取文本框最新值
|
currRowIndex = 0;
|
var tableView = "h_v_Gy_MaterialList";
|
var childSWhere = "select top(10) HItemID,物料代码,物料名称,规格型号,HUnitID,计量单位名称 from " + tableView + " where 1=1 and 组织名称 = '" + sessionStorage["Organization"] + "' and (物料代码 like '%" + value + "%' or 物料名称 like '%" + value + "%') order by 物料代码 desc";
|
childPage.getData(childSWhere, tableView);
|
}, 200);
|
}
|
} else { //如果按下的键位是 方向键，则调整窗口中 选中行 的位置
|
if (event.key == "ArrowUp") {
|
currRowIndex--;
|
childPage.setSelectedRow(currRowIndex);
|
} else if (event.key == "ArrowDown") {
|
currRowIndex++;
|
childPage.setSelectedRow(currRowIndex);
|
} else if (event.key == "Enter") {
|
//手动失焦
|
var element = document.getElementById("HBillNo");
|
element.focus();
|
|
childPage.getSelectedData(currRowIndex);
|
|
if (childData != null) {
|
OptionData = childData;
|
|
//通过供应商id获取税率
|
var HSupID = $("#HSupID").val();
|
if (HSupID != 0 && typeof (OptionData.HItemID) != "undefined") {
|
var Dec = getDecByMaterID(obj.data.HMaterID) //获取精度
|
var HQtyDec = (Dec["HQtyDec"] == null || Dec["HQtyDec"] == 0) ? 4 : Dec["HQtyDec"]; //数量精度
|
var HPriceDec = (Dec["HPriceDec"] == null || Dec["HPriceDec"] == 0) ? 4 : Dec["HPriceDec"]; //单价精度
|
var HMoneyDec = (Dec["HMoneyDec"] == null || Dec["HMoneyDec"] == 0) ? 2 : Dec["HMoneyDec"]; //金额精度
|
$.ajax({
|
url: GetWEBURL() + "/Gy_Supplier/xg",
|
//url: "http://localhost:12761/Gy_Supplier/xg",
|
type: "GET",
|
data: {
|
"HInterID": HSupID
|
},
|
success: function (d) {
|
var HTaxRate = parseInt(d.data[0].增值税率) * 0.01;
|
//数据校验合格，重算记录
|
var HQty = obj.data.HQty * 1; //数量
|
var HPrice = obj.data.HPrice * 1; //单价
|
var HMoney = HQty * HPrice; //金额=数量*单价
|
var HTaxMoney = Number((HMoney * HTaxRate)); //税额=金额*税率
|
var HTaxPrice = Number((HPrice * (1 + HTaxRate))); //含税单价=单价*(1+税率)
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
//数字精度
|
HQty = Number(HQty.toFixed(HQtyDec));
|
HPrice = Number(HPrice.toFixed(HPriceDec));
|
HMoney = Number(HMoney.toFixed(HMoneyDec));
|
HTaxMoney = Number(HTaxMoney.toFixed(HMoneyDec));
|
HlineTotal = Number(HlineTotal.toFixed(HMoneyDec));
|
HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec));
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.物料代码
|
, "物料名称": OptionData.物料名称
|
, "规格型号": OptionData.规格型号
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.计量单位名称
|
, "HTaxRate": HTaxRate * 100
|
, "HQty": HQty //更新HQty字段，HQty
|
, "HPrice": HPrice //更新HPrice字段，HPrice
|
, "HMoney": HMoney //更新HMoney字段，HMoney
|
, "HlineTotal": HlineTotal //更新HlineTotal字段，HlineTotal
|
, "HTaxPrice": HTaxPrice //更新HTaxPrice字段，HTaxPrice
|
})
|
}
|
});
|
} else if (typeof (OptionData.HItemID) != "undefined") {
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.物料代码
|
, "物料名称": OptionData.物料名称
|
, "规格型号": OptionData.规格型号
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.计量单位名称
|
})
|
}
|
|
OptionData = {};
|
childData = null;
|
}
|
|
|
childPage = null;
|
currRowIndex = 0;
|
childData = null;
|
obj.event = "";
|
}
|
}
|
}
|
|
}
|
//#endregion
|
|
if (event.key == "F7") {
|
//物料
|
if (obj.event == "HMaterID") {
|
var HOrgID = $("#HOrgID").val();
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: "物料列表" //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["90%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: ['../../基础资料/公用基础资料/Gy_Material.html?openType=2&HOrgID=' + HOrgID, '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("请选择一条数据");
|
//}
|
|
OptionData = checkStatus.data[0];
|
if (checkStatus.data.length > 1) {
|
var rowIndex = $(obj.tr).attr("data-index") * 1;
|
for (var i = 0; i < checkStatus.data.length; i++) {
|
if (rowIndex + i >= option.data.length) {
|
var NewRow = {
|
"HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "HQtyMust": "0", "HQty": "", "HRemark": "",
|
"HPrice": "0", "HMoney": "0", "HOrderPrice": "0", "HWHID": 0, "收料仓库": "",
|
"HSPID": 0, "仓位名称": "", "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0,
|
"HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "",
|
"HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0,
|
"HTaxRate": 0, "HTaxPrice": 0, "HlineTotal": 0
|
};
|
|
table.cache["mainTable"].push(NewRow);
|
option.data = table.cache["mainTable"];
|
|
table.render(option);
|
}
|
|
|
|
var HMaterID = checkStatus.data[i].HItemID;
|
var resultData = getMaterialByMaterID(HMaterID);
|
option.data[rowIndex + i].HMaterID = resultData.HMaterID;
|
option.data[rowIndex + i].物料代码 = resultData.HMaterNumber;
|
option.data[rowIndex + i].物料名称 = resultData.HMaterName;
|
option.data[rowIndex + i].规格型号 = resultData.HMaterModel;
|
option.data[rowIndex + i].HUnitID = resultData.HUnitID;
|
option.data[rowIndex + i].计量单位 = resultData.HUnitName;
|
////更新表格缓存的数据
|
//obj.update({
|
// "HMaterID": checkStatus.data[0].HItemID
|
// , "物料代码": checkStatus.data[0].HNumber
|
// , "物料名称": checkStatus.data[0].HName
|
// , "规格型号": checkStatus.data[0].HModel
|
// , "HUnitID": checkStatus.data[0].HUnitID
|
// , "计量单位": checkStatus.data[0].HUnitName
|
//})
|
//layer.close(index);//关闭弹窗
|
}
|
table.render(option);
|
}
|
|
layer.closeAll();
|
//layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) {
|
//按钮【按钮二】的回调
|
//return false 开启该代码可禁止点击该按钮关闭
|
},
|
end: function () {
|
//通过供应商id获取税率
|
var HSupID = $("#HSupID").val();
|
if (HSupID != 0) {
|
$.ajax({
|
url: GetWEBURL() + "/Gy_Supplier/xg",
|
//url: "http://localhost:12761/Gy_Supplier/xg",
|
type: "GET",
|
data: {
|
"HInterID": HSupID
|
},
|
success: function (d) {
|
var HTaxRate = parseInt(d.data[0].增值税率) * 0.01;
|
//数据校验合格，重算记录
|
var HQty = obj.data.HQty * 1; //数量
|
var HPrice = obj.data.HPrice * 1; //单价
|
var HMoney = HQty * HPrice; //金额=数量*单价
|
var HTaxMoney = Number((HMoney * HTaxRate).toFixed(4)); //税额=金额*税率
|
var HTaxPrice = Number((HPrice * (1 + HTaxRate)).toFixed(4)); //含税单价=单价*(1+税率)
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.物料代码
|
, "物料名称": OptionData.物料名称
|
, "规格型号": OptionData.规格型号
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.计量单位名称
|
, "HTaxRate": HTaxRate * 100
|
, HQty: HQty //更新HQty字段，HQty
|
, HPrice: HPrice //更新HPrice字段，HPrice
|
, HMoney: HMoney //更新HMoney字段，HMoney
|
, HlineTotal: HlineTotal //更新HlineTotal字段，HlineTotal
|
, HTaxPrice, HTaxPrice //更新HTaxPrice字段，HTaxPrice
|
})
|
}
|
});
|
} else {
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.物料代码
|
, "物料名称": OptionData.物料名称
|
, "规格型号": OptionData.规格型号
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.计量单位名称
|
})
|
}
|
}
|
});
|
}
|
//计量单位
|
if (obj.event == "HUnitID") {
|
var HOrgName = $('select[name="HOrgID"] option:selected').text();
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: "计量单位列表" //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["90%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: ['../../基础资料/公用基础资料/Gy_Unit.html?Type=2&HOrgName=' + HOrgName, '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({
|
"计量单位": checkStatus.data[0].计量单位名称
|
, "HUnitID": checkStatus.data[0].HItemID
|
})
|
layer.close(index);//关闭弹窗
|
}
|
, end: function () {
|
obj.update({
|
"HUnitID": OptionData.HItemID
|
, "计量单位": OptionData.计量单位名称
|
})
|
}
|
})
|
}
|
//收料仓库
|
if (obj.event == "HWHID") {
|
var HOrgName = $('select[name="HOrgID"] option:selected').text();
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: "收料仓库列表" //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["90%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: ['../../基础资料/公用基础资料/Gy_Warehouse.html?type=Warehouse&HOrgName=' + HOrgName, '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("请选择一条数据");
|
}
|
OptionData = checkStatus.data[0];
|
//更新表格缓存的数据
|
obj.update({
|
"收料仓库": checkStatus.data[0].仓库名称
|
, "HWHID": checkStatus.data[0].HItemID
|
})
|
layer.close(index);//关闭弹窗
|
}
|
, end: function () {
|
obj.update({
|
"HWHID": OptionData.HItemID
|
, "收料仓库": OptionData.仓库名称
|
})
|
}
|
})
|
}
|
//仓位
|
if (obj.event == "HSPID") {
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: "仓位名称列表" //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["90%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: ['../../基础资料/公用基础资料/Gy_StockPlace_List.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({
|
"仓位名称": checkStatus.data[0].仓位名称
|
, "HSPID": checkStatus.data[0].HMainID
|
})
|
layer.close(index);//关闭弹窗
|
}
|
, end: function () {
|
obj.update({
|
"HSPID": OptionData.HMainID
|
, "仓位名称": OptionData.仓位名称
|
})
|
}
|
})
|
}
|
obj.event = "";
|
return false;
|
}
|
})
|
$('.layui-table-box tbody td[data-field="物料代码"]').off('dblclick').on('dblclick', function () {
|
var HOrgID = $("#HOrgID").val();
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: "物料列表" //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["90%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: ['../../基础资料/公用基础资料/Gy_Material.html?openType=2&HOrgID=' + HOrgID, 'yes']
|
, btn: ["确定", "取消"]
|
, btn1: function (index, laero) {
|
//按钮一 的回调
|
var iframeWindow = window["layui-layer-iframe" + index];//获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//获取选中的数据
|
var TaxRate = getHTaxRateByHSupID();
|
//if (checkStatus.data.length != 1) {
|
// return layer.msg("请选择一条数据");
|
//}
|
|
OptionData = checkStatus.data[0];
|
if (checkStatus.data.length > 1) {
|
var rowIndex = $(obj.tr).attr("data-index") * 1;
|
for (var i = 0; i < checkStatus.data.length; i++) {
|
if (rowIndex + i >= option.data.length) {
|
var NewRow = {
|
"HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "HQtyMust": "0", "HQty": "", "HRemark": "",
|
"HPrice": "0", "HMoney": "0", "HOrderPrice": "0", "HWHID": 0, "收料仓库": "",
|
"HSPID": 0, "仓位名称": "", "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0,
|
"HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "",
|
"HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0,
|
"HTaxRate": 0, "HTaxPrice": 0, "HlineTotal": 0
|
};
|
|
table.cache["mainTable"].push(NewRow);
|
option.data = table.cache["mainTable"];
|
|
table.render(option);
|
}
|
|
|
|
var HMaterID = checkStatus.data[i].HItemID;
|
var resultData = getMaterialByMaterID(HMaterID);
|
option.data[rowIndex + i].HMaterID = resultData.HMaterID;
|
option.data[rowIndex + i].物料代码 = resultData.HMaterNumber;
|
option.data[rowIndex + i].物料名称 = resultData.HMaterName;
|
option.data[rowIndex + i].规格型号 = resultData.HMaterModel;
|
option.data[rowIndex + i].HUnitID = resultData.HUnitID;
|
option.data[rowIndex + i].计量单位 = resultData.HUnitName;
|
option.data[rowIndex + i].HTaxRate = TaxRate;
|
////更新表格缓存的数据
|
//obj.update({
|
// "HMaterID": checkStatus.data[0].HItemID
|
// , "物料代码": checkStatus.data[0].HNumber
|
// , "物料名称": checkStatus.data[0].HName
|
// , "规格型号": checkStatus.data[0].HModel
|
// , "HUnitID": checkStatus.data[0].HUnitID
|
// , "计量单位": checkStatus.data[0].HUnitName
|
//})
|
//layer.close(index);//关闭弹窗
|
}
|
table.render(option);
|
}
|
|
layer.closeAll();
|
//layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) {
|
//按钮【按钮二】的回调
|
//return false 开启该代码可禁止点击该按钮关闭
|
},
|
end: function () {
|
//通过供应商id获取税率
|
var HSupID = $("#HSupID").val();
|
if (HSupID != 0 && typeof (OptionData.HItemID) != "undefined") {
|
var Dec = getDecByMaterID(obj.data.HMaterID) //获取精度
|
var HQtyDec = (Dec["HQtyDec"] == null || Dec["HQtyDec"] == 0) ? 4 : Dec["HQtyDec"]; //数量精度
|
var HPriceDec = (Dec["HPriceDec"] == null || Dec["HPriceDec"] == 0) ? 4 : Dec["HPriceDec"]; //单价精度
|
var HMoneyDec = (Dec["HMoneyDec"] == null || Dec["HMoneyDec"] == 0) ? 2 : Dec["HMoneyDec"]; //金额精度
|
$.ajax({
|
url: GetWEBURL() + "/Gy_Supplier/xg",
|
//url: "http://localhost:12761/Gy_Supplier/xg",
|
type: "GET",
|
data: {
|
"HInterID": HSupID
|
},
|
success: function (d) {
|
var HTaxRate = parseInt(d.data[0].增值税率) * 0.01;
|
//数据校验合格，重算记录
|
var HQty = obj.data.HQty * 1; //数量
|
var HPrice = obj.data.HPrice * 1; //单价
|
var HMoney = HQty * HPrice; //金额=数量*单价
|
var HTaxMoney = Number((HMoney * HTaxRate)); //税额=金额*税率
|
var HTaxPrice = Number((HPrice * (1 + HTaxRate))); //含税单价=单价*(1+税率)
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
//数字精度
|
HQty = Number(HQty.toFixed(HQtyDec));
|
HPrice = Number(HPrice.toFixed(HPriceDec));
|
HMoney = Number(HMoney.toFixed(HMoneyDec));
|
HTaxMoney = Number(HTaxMoney.toFixed(HMoneyDec));
|
HlineTotal = Number(HlineTotal.toFixed(HMoneyDec));
|
HTaxPrice = Number(HTaxPrice.toFixed(HPriceDec));
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.物料代码
|
, "物料名称": OptionData.物料名称
|
, "规格型号": OptionData.规格型号
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.计量单位名称
|
, "HTaxRate": HTaxRate * 100
|
, HQty: HQty //更新HQty字段，HQty
|
, HPrice: HPrice //更新HPrice字段，HPrice
|
, HMoney: HMoney //更新HMoney字段，HMoney
|
, HlineTotal: HlineTotal //更新HlineTotal字段，HlineTotal
|
, HTaxPrice, HTaxPrice //更新HTaxPrice字段，HTaxPrice
|
})
|
}
|
});
|
} else if (typeof (OptionData.HItemID) != "undefined"){
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.物料代码
|
, "物料名称": OptionData.物料名称
|
, "规格型号": OptionData.规格型号
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.计量单位名称
|
})
|
}
|
}
|
});
|
});
|
}
|
|
//行内事件
|
table.on('tool(mainTable)', function (obj) {
|
set_GridDelete(obj); //行内删除
|
set_GridCellCheck(obj); //行内快捷键筛选
|
|
});
|
|
//动态弹出页面
|
function getSupType() {
|
var type = $("#HSourceBillType").val();
|
switch (type) {
|
case '1102':
|
return { url: "../../采购管理/采购订单/Cg_POOrderBillList.html", name: "采购订单" };
|
break;
|
case '1103':
|
return { url: "../../采购管理/收料通知单/Cg_POInStockBillList.html", name: "收料通知单" };
|
break;
|
}
|
}
|
|
//表头信息选择单据弹窗
|
form.on('submit(XDHList)', function () {
|
var HOrgID = $("#HOrgID").val();
|
var url = "";
|
if ($("#HSourceBillType").val() == "1102") {
|
url = "../../采购管理/采购订单/Cg_POOrderBillList.html?openType=2&HOrgID=" + HOrgID;
|
} else if ($("#HSourceBillType").val() == "1103") {
|
url = "../../采购管理/收料通知单/Cg_POInStockBillList.html?openType=2&HOrgID=" + HOrgID;
|
}else{
|
return layer.msg('当前不支持该源单选择！！');
|
}
|
|
//页面层-自定义
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: '' + getSupType().name + '列表' //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["90%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: [url, "yes"]
|
, btn: ["确定", "取消"]
|
, btn1: function (index, laero) {
|
//按钮一 的回调
|
var iframeWindow = window["layui-layer-iframe" + index];//获取弹框页面
|
var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//获取选中的数据
|
|
if (checkStatus.data.length == 0) {
|
return layer.msg("请至少选择一条数据!");
|
}
|
var HSupID = $("#HSupID").val();//判断供应商
|
if (HSupID == 0 || HSupID == '') {
|
HSupID = checkStatus.data[0]["HSupID"];
|
}
|
//获取收料通知单代码
|
var ProcessNumber = [];
|
for (var i = 0; i < checkStatus.data.length; i++) {
|
if (checkStatus.data[i]["HSupID"] != HSupID) {
|
layer.msg("下推失败!已经选中的记录中存在不同供应商!");
|
layer.close(index);//关闭弹窗
|
return;
|
}
|
ProcessNumber.push(checkStatus.data[i]);
|
}
|
|
//获取当前位置所在行数
|
var NowNum = 0;
|
NowNum = option.data.length;
|
|
$("#HProjectName").val(checkStatus.data[0].项目名称);
|
$("#HProjectNumber").val(checkStatus.data[0].项目代码);
|
$("#HProjectID").val(checkStatus.data[0].HProjectID);
|
|
$("#HDeptID").val(checkStatus.data[0].HDeptID);
|
$("#HDeptName").val(checkStatus.data[0].部门);
|
//两边显示的字段不一样所以用判断去赋值
|
if ($("#HSourceBillType").val() == "1102") { //采购订单
|
$("#HWHID").val(checkStatus.data[0].HWHID);
|
$("#HWHName").val(checkStatus.data[0].仓库);
|
} else if ($("#HSourceBillType").val() == "1103") { //收货通知单
|
$("#HWHID").val(checkStatus.data[0].主表仓库ID);
|
$("#HWHName").val(checkStatus.data[0].主表仓库);
|
}
|
|
$("#HSupID").val(checkStatus.data[0].HSupID);
|
$("#HSupName").val(checkStatus.data[0].供应商);
|
$("#HEmpID").val(checkStatus.data[0].HEmpID);
|
$("#HEmpName").val(checkStatus.data[0].业务员);
|
$("#HManagerID").val(checkStatus.data[0].HManagerID);
|
$("#HManagerName").val(checkStatus.data[0].主管);
|
$("#HInvoiceBillNo").val(checkStatus.data[0].发票编号);
|
$("#HInnerBillNo").val(checkStatus.data[0].内部单据号);
|
if ($("#HSourceBillType").val() == "1102") {
|
|
var j = 0;
|
for (var i = 0; i < checkStatus.data.length; i++) {
|
var HNewQty = checkStatus.data[j].数量 - checkStatus.data[j].关联数量//数量
|
var HNewMoney = checkStatus.data[j].金额 - checkStatus.data[j].关联数量 * checkStatus.data[j].单价//减少关联数量的金额
|
var HNewTaxMoney = HNewMoney * checkStatus.data[j].税率 * 0.01
|
var HNewlineTotal = HNewMoney + HNewTaxMoney;
|
option.data.push({
|
"HMaterID": checkStatus.data[j].HMaterID, "物料代码": checkStatus.data[j].物料代码, "物料名称": checkStatus.data[j].物料名称, "规格型号": checkStatus.data[j].规格型号,
|
"HUnitID": checkStatus.data[j].HUnitID, "计量单位": checkStatus.data[j].计量单位, "HWHID": checkStatus.data[j].HWHIDSub, "收料仓库": checkStatus.data[j].仓库名称,
|
"HSPID": checkStatus.data[j].HSPID, "仓位名称": checkStatus.data[j].仓位名称, "HQtyMust": checkStatus.data[j].数量,
|
"HQty": HNewQty, "HPrice": checkStatus.data[j].单价, "HMoney": HNewMoney, "HOrderPrice": checkStatus.data[j].金额,
|
"HSourceBillNo": checkStatus.data[j].单据号, "HSourceBillType": checkStatus.data[j].HBillType, "HSourceInterID": checkStatus.data[j].hmainid, "HSourceEntryID": checkStatus.data[j].hsubid,
|
"HTaxRate": checkStatus.data[j].税率, "HTaxPrice": checkStatus.data[j].含税单价, "HlineTotal": HNewlineTotal
|
})
|
j++;
|
}
|
table.render(option);
|
layer.close(index);
|
} else if ($("#HSourceBillType").val() == "1103") {
|
|
var j = 0;
|
for (var i = 0; i < ProcessNumber.length; i++) {
|
var HNewQty = checkStatus.data[j].数量 - checkStatus.data[j].关联数量//数量
|
var HNewMoney = checkStatus.data[j].金额 - checkStatus.data[j].关联数量 * checkStatus.data[j].单价//减少关联数量的金额
|
var HNewTaxMoney = HNewMoney * checkStatus.data[j].税率 * 0.01
|
var HNewlineTotal = HNewMoney + HNewTaxMoney;
|
option.data.push({
|
"HMaterID": checkStatus.data[j].HMaterID, "物料代码": checkStatus.data[j].物料代码, "物料名称": checkStatus.data[j].物料名称, "规格型号": checkStatus.data[j].规格型号,
|
"HUnitID": checkStatus.data[j].HUnitID, "计量单位": checkStatus.data[j].计量单位, "HQtyMust": checkStatus.data[j].数量, "HQty": checkStatus.data[j].数量 - checkStatus.data[j].关联数量, "HRemark": "",
|
"HPrice": checkStatus.data[j].单价, "HMoney": HNewMoney, "HOrderPrice": checkStatus.data[j].金额, "HWHID": checkStatus.data[j].HWHID, "收料仓库": checkStatus.data[j].收料仓库,
|
"HSPID": checkStatus.data[j].HSPID, "仓位名称": checkStatus.data[j].仓位名称, "HBatchNo": "", "HPOOrderInterID": 0, "HPOOrderEntryID": 0,
|
"HPOOrderBillNo": "", "HSeOrderInterID": 0, "HSeOrderEntryID": 0, "HSeOrderBillNo": "",
|
"HSourceBillNo": checkStatus.data[j].单据号, "HSourceBillType": checkStatus.data[j].HBillType, "HSourceInterID": checkStatus.data[j].hmainid, "HSourceEntryID": checkStatus.data[j].hsubid,
|
"HTaxRate": checkStatus.data[j].税率, "HTaxPrice": checkStatus.data[j].含税单价, "HlineTotal": HNewlineTotal
|
})
|
j++;
|
}
|
table.render(option);
|
layer.close(index);//关闭弹窗
|
}
|
|
}
|
|
});
|
});
|
//判断所选着与表格是否有重复数据
|
function checkDuplicateData(data) {
|
const duplicates = [];
|
|
for (let i = 0; i < data.length; i++) {
|
const currentItem = data[i];
|
let isDuplicate = false;
|
|
for (let j = i + 1; j < data.length; j++) {
|
const compareItem = data[j];
|
|
if (currentItem.HSourceInterID === compareItem.HSourceInterID && currentItem.HSourceEntryID === compareItem.HSourceEntryID) {
|
isDuplicate = true;
|
duplicates.push({ row1: i + 1, row2: j + 1 }); // 记录重复数据所在行数
|
}
|
}
|
if (isDuplicate && !duplicates.some(item => item.row1 === i + 1)) {
|
duplicates.push({ row1: i + 1, row2: -1 }); // 记录重复数据所在行数，-1 表示未找到与当前行重复的行
|
}
|
}
|
return duplicates;
|
}
|
//行内删除
|
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 {
|
obj.del();//假删除
|
table.cache["mainTable"].splice(rowIndex, 1); //②彻底移除元素，从缓存里移除这一行
|
option.data = table.cache["mainTable"];//将数据绑定到data上
|
table.reload(option);
|
layer.close(index);
|
}
|
});
|
}
|
}
|
//#region 根据物料ID获取物料详细信息
|
function getMaterialByMaterID(HMaterID) {
|
var resultData = {};
|
$.ajax({
|
url: GetWEBURL() + "Kf_POStockInBill/getMaterialByMaterID",
|
async: false,
|
type: "GET",
|
data: {
|
"HMaterID": HMaterID
|
},
|
success: function (result) {
|
if (result.code == 1) {
|
var data = result.data;
|
resultData = data[0];
|
} else {
|
layer.alert(result.msg, { icon: 5, btn: ['退出'], time: 100000, offset: 't' });
|
}
|
}, error: function () {
|
layer.alert("发生错误!", { icon: 5 });
|
}
|
});
|
return resultData;
|
}
|
//#endregion
|
|
//#region 保存后浏览方法
|
function ReRoadBillMain() {
|
location.replace('Add_Edit_Kf_POStockInBillList.html?OperationType=4&linterid=' + linterid + '&HSouceBillType=');
|
//document.location.href('Add_Edit_Gy_Source.html ? OperationType = 4 & linterid=' + linterid + ' & HSouceBillType=');
|
$('#set_SaveBill').addClass("layui-btn-disabled").attr("disabled", true);//保存后加载数据时保存按钮禁用
|
}
|
//#endregion
|
|
//#region 获取源单类型
|
function HSourceBillType() {
|
var HName = '采购入库单';
|
//获取登录页组织列
|
$.ajax({
|
type: "get",
|
async: false,
|
data: { "HName": HName, "Num": 2 }, //0蓝单 1红单 2不分红蓝单
|
url: GetWEBURL() + "/Web/GetHSourceBillType",
|
success: function (result) {
|
var HSourceBillTypes = "";
|
if (result.count == 1) { // 说明验证成功了，
|
var data = result.data;
|
for (var i = 0; i < data.length; i++) {
|
HSourceBillTypes += '<option style="color:blue;" value="' + data[i].HSourceBillType + '">' + data[i].HSourceBillTypeName + '</option>';
|
}
|
$("#HSourceBillType").append(HSourceBillTypes);
|
form.render('select');
|
}
|
}
|
})
|
}
|
//#endregion
|
|
|
//#region 根据主内码与子内码获取源单采购订单数据
|
function getPushSource_POOrderBillInit(HSourceInterID, HSourceEntryID) {
|
var res = "none";
|
$.ajax({
|
url: GetWEBURL() + "/Cg_POOrderBill/loadCg_POOrderBill_Push",
|
async: false,
|
type: "GET",
|
data: {
|
"HInterID": HSourceInterID
|
, "HSubID": HSourceEntryID
|
},
|
success: function (result) {
|
if (result.code == 1) { // 说明验证成功了，
|
res = result.data[0];
|
} else {
|
res = result.data;
|
//layer.alert(result.msg, { icon: 5, btn: ['退出'], time: 100000, offset: 't' });
|
}
|
}, error: function (err) {
|
res = "none";
|
layer.alert("发生错误!"+err, { icon: 5 });
|
}
|
});
|
return res;
|
}
|
//#endregion
|
|
//#region 通过供应商id获取税率
|
function getHTaxRateByHSupID() {
|
var HTaxRate;
|
//通过供应商id获取税率
|
var HSupID = $("#HSupID").val();
|
if (HSupID != 0) {
|
$.ajax({
|
url: GetWEBURL() + "/Gy_Supplier/xg",
|
type: "GET",
|
async: false,
|
data: {
|
"HInterID": HSupID
|
},
|
success: function (d) {
|
HTaxRate = parseInt(d.data[0].增值税率);
|
}
|
});
|
} else {
|
HTaxRate = 0;
|
}
|
return HTaxRate;
|
}
|
//#endregion
|
|
//#region 根据主内码与子内码获取源单收料通知单数据
|
function getPushSource_POInStockBillInit(HSourceInterID, HSourceEntryID) {
|
var res = "none";
|
$.ajax({
|
url: GetWEBURL() + "/Cg_POInStockBill/loadCg_POInStockBill_Push",
|
async: false,
|
type: "GET",
|
data: {
|
"HInterID": HSourceInterID
|
, "HSubID": HSourceEntryID
|
},
|
success: function (result) {
|
if (result.code == 1) { // 说明验证成功了，
|
res = result.data[0];
|
} else {
|
res = result.data;
|
//layer.alert(result.msg, { icon: 5, btn: ['退出'], time: 100000, offset: 't' });
|
}
|
}, error: function (err) {
|
res = "none";
|
layer.alert("发生错误!" + err, { icon: 5 });
|
}
|
});
|
return res;
|
}
|
//#endregion
|
//#region 列设置
|
//隐藏列设置
|
function get_HideColumn() {
|
var colName = "";
|
for (var i = 1; i < option.cols[0].length - 1; i++) {
|
colName += option.cols[0][i]["field"] + ",";
|
}
|
var colTitleName = "";
|
for (var i = 1; i < option.cols[0].length - 1; i++) {
|
colTitleName += option.cols[0][i]["title"] + ",";
|
}
|
colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI 进行编码
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: "隐藏列设置" //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["50%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: ['../../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName + '&colTitleName = ' + colTitleName, "yes"]
|
, btn: ["确定", "取消"]
|
, btn1: function (index, laero) {
|
//刷新表格数据
|
DisPlay_HideColumn();
|
//更新表格缓存的数据
|
layer.close(index);//关闭弹窗
|
}
|
})
|
}
|
|
//显示列数据
|
function DisPlay_HideColumn() {
|
$.ajax({
|
url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
|
type: "GET",
|
async: false,
|
data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
|
success: function (data1) {
|
if (data1.data.length != 0) {
|
|
var dataCol = [];//数据库查询出的列数据
|
var titleData = [];//不需要显示的字段 可扩展
|
|
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 (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 (dataCols[3] > 0) {
|
option.cols[0][i + 1]["width"] = dataCols[3];
|
}
|
//显示列
|
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;
|
}
|
//设置表格title属性显示别名
|
if (dataCols[4] != null && dataCols[4] != "") {
|
option.cols[0][i + 1]["title"] = dataCols[4];
|
}
|
}
|
//取消冻结列
|
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 AllowLoadData(data) {
|
|
var ref = /^\d+(\.\d+)?$/; //非负数正则表达式
|
var temp = "";
|
|
//if ($("#HWHID").val() == 0) {
|
// layer.msg("请选择仓库！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
// return;
|
//}
|
//if ($("#HManagerID").val() == 0) {
|
// layer.msg("请选择负责人！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
// return;
|
//}
|
//if ($("#HEmpID").val() == 0) {
|
// layer.msg("请选择业务员！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
// return;
|
//}
|
//if ($("#HKeeperID").val() == 0) {
|
// layer.msg("请选择保管员！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
// return;
|
//}
|
//if ($("#HSecManagerID").val() == 0) {
|
// layer.msg("请选择验收员！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
// return;
|
//}
|
//if ($("#HDeptID").val() == 0) {
|
// layer.msg("请选择部门！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
// return;
|
//}
|
if ($("#HSupID").val() == 0) {
|
layer.msg("请选择供应商！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
return;
|
}
|
//if ($("#HPSStyleID").val() == 0) {
|
// layer.msg("请选择采购方式！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
// return;
|
//}
|
//if ($("#HSSID").val() == 0) {
|
// layer.msg("请选择结算方式！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
// return;
|
//}
|
//#region 子表 数据检验
|
for (var i = 0; i < option.data.length; i++) {
|
|
if (typeof option.data[i] !== 'object' || option.data[i] === null || Array.isArray(option.data[i])) {
|
continue; // 跳过非对象项（如空数组）
|
}
|
|
if (option.data[i]["HMaterID"] == "0") {
|
layer.msg("第" + (i + 1) + "行：物料未选择！");
|
return false;
|
}
|
|
if (option.data[i]["HUnitID"] == "0") {
|
layer.msg("第" + (i + 1) + "行：计量单位未选择！");
|
return false;
|
}
|
|
//实发数量格式校验
|
temp = option.data[i]["HQty"] + "";
|
if (temp == "0") {
|
layer.msg("第" + (i + 1) + "行：数量不能为0！");
|
return false;
|
} else if (!ref.test(temp)) {
|
layer.msg("第" + (i + 1) + "行：数量请输入大于0的数字！");
|
return false;
|
}
|
|
//单价格式校验
|
temp = option.data[i]["HPrice"] + "";
|
if (temp == "0") {
|
//layer.msg("第" + (i + 1) + "行：单价不能为0！");
|
//return false;
|
} else if (!ref.test(temp)) {
|
layer.msg("第" + (i + 1) + "行：单价请输入大于0的数字！");
|
return false;
|
}
|
|
//含税单价格式校验
|
temp = option.data[i]["HTaxPrice"] + "";
|
if (temp == "0") {
|
//layer.msg("第" + (i + 1) + "行：含税单价不能为0！");
|
//return false;
|
} else if (!ref.test(temp)) {
|
layer.msg("第" + (i + 1) + "行：含税单价请输入大于0的数字！");
|
return false;
|
}
|
|
//税率格式校验
|
temp = option.data[i]["HTaxRate"] + "";
|
if (!ref.test(temp)) {
|
layer.msg("第" + (i + 1) + "行：税率请输入不小于0的数字！");
|
return false;
|
}
|
|
//金额格式校验
|
temp = option.data[i]["HMoney"] + "";
|
if (temp == "0") {
|
//layer.msg("第" + (i + 1) + "行：金额不能为0！");
|
//return false;
|
} else if (!ref.test(temp)) {
|
layer.msg("第" + (i + 1) + "行：金额请输入大于0的数字！");
|
return false;
|
}
|
//收料仓库非空验证
|
if (option.data[i]["HWHID"] == "0") {
|
layer.msg("第" + (i + 1) + "行：收料仓库未选择！");
|
return false;
|
}
|
}
|
//#endregion
|
return true;
|
}
|
|
//endregion
|
|
//#endregion
|
|
|
//以上是layui模块
|
});
|
// 基础资料返回数据
|
function GetHEmpValue(obj) //返回业务员
|
{
|
$("#HEmpName").val(obj[0].职员名称);
|
$("#HEmpID").val(obj[0].HItemID);
|
}
|
|
function GetHSupNameValue(obj) //返回供应商
|
{
|
$("#HSupName").val(obj[0].供应商名称);
|
$("#HSupID").val(obj[0].HItemID);
|
}
|
|
function GetHWHValue(obj) //返回仓库
|
{
|
$("#HWHName").val(obj[0].仓库名称);
|
$("#HWHID").val(obj[0].HItemID);
|
|
if (option.data.length > 0) {
|
for (var i = 0; i < option.data.length; i++) {
|
if (option.data[i]["HWHID"] == 0 || option.data[i]["收料仓库"] == undefined) {
|
option.data[i]["HWHID"] = obj[0].HItemID;
|
option.data[i]["收料仓库"] = obj[0].仓库名称;
|
}
|
}
|
}
|
layui.table.render(option);
|
}
|
|
function GetHDeptNameValue(obj) //返回部门
|
{
|
$("#HDeptName").val(obj[0].部门名称);
|
$("#HDeptID").val(obj[0].HItemID);
|
}
|
|
//项目
|
function GetProjectBillValue(data) {
|
$("#HProjectName").val(data[0].项目名称);
|
$("#HProjectNumber").val(data[0].项目代码);
|
$("#HProjectID").val(data[0].HInterID);
|
}
|
|
function GetHSecManagerValue(obj) //返回验收员
|
{
|
$("#HSecManagerName").val(obj[0].职员名称);
|
$("#HSecManagerID").val(obj[0].HItemID);
|
}
|
|
function GetHKeeperValue(obj) //返回保管员
|
{
|
$("#HKeeperName").val(obj[0].职员名称);
|
$("#HKeeperID").val(obj[0].HItemID);
|
}
|
|
function GetHWorkerValue(obj) //返回负责人
|
{
|
$("#HManagerName").val(obj[0].职员名称);
|
$("#HManagerID").val(obj[0].HItemID);
|
}
|
|
//双击返回物料
|
function GetGyMaterial(data) {
|
OptionData = data
|
}
|
//双击返回计量单位
|
function GetUnitValue(data) {
|
OptionData = data[0]
|
}
|
|
//双击返回收料仓库
|
function GetGyWarehouse(data) {
|
OptionData = data[0]
|
}
|
|
|
//双击返回收料仓位
|
function GetGyStockPlace(data) {
|
OptionData = data
|
}
|
|
//#region 处理小数显示位数（data：需要处理的数据；num：数据的类型(如1:数量；2:金额；3:单价)）
|
function dealDoubleToFixed(data, num) {
|
//用于设置小数位数
|
var dotLength = 0;
|
|
if (num == 1) { //当数据为数量时，最多保留6位小数
|
//设置最多保留6位小数
|
dotLength = 6;
|
} else if (num == 2) { //当数据为金额时，最多保留2位小数
|
//设置最多保留2位小数
|
dotLength = 2;
|
} else if (num == 3) { //当数据为单价时，最多保留4位小数
|
//设置最多保留4位小数
|
dotLength = 4;
|
}
|
|
//判断是否存在小数点及其索引位置
|
data = data + "";
|
var index = data.indexOf(".");
|
|
//处理数据并返回
|
if (index < 0) {
|
return data * 1;
|
} else {
|
//获取小数位数
|
var length = data.length - index - 1;
|
if (length <= dotLength) {
|
return data * 1;
|
} else {
|
data = data * 1;
|
return data.toFixed(dotLength);
|
}
|
}
|
}
|
//#endregion
|
</script>
|
</body>
|
</html>
|
