<!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">
|
.layui-form-item .layui-inline {
|
margin-right: 0;
|
}
|
|
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="set_SaveBill">保存</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>
|
</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;" readonly>
|
<input type="hidden" name="HInterID" id="HInterID" 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" readonly>
|
</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="HInnerBillNo" id="HInnerBillNo" autocomplete="off" style="background-color:#efefef4d;" readonly>
|
</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" style="">
|
<input type="text" name="HCusName" id="HCusName" class="layui-input" value="" style="float: left; width: 150px;">
|
<input type="hidden" name="HCusID" id="HCusID" class="layui-input" value="0" style="float: left; width: 150px;">
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="HCusList" 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 style="color:red"> * </label></label>
|
<div class="layui-input-inline">
|
<input type="text" name="HCurName" id="HCurName" class="layui-input" value="" style="float:left;width:150px;">
|
<input type="hidden" name="HCurID" id="HCurID" class="layui-input" value="0" style="float:left;width:150px;">
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="HCurList" 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" style="">汇率<label style="color:red"> * </label></label>
|
<div class="layui-input-inline">
|
<input class="layui-input" name="HExRate" id="HExRate" autocomplete="off" value="0" style="background-color:#efefef4d;" readonly>
|
</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="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 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 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="HContractName" id="HContractName" 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 class="layui-input" name="HAddress" id="HAddress" autocomplete="off">
|
</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="HSSName" id="HSSName" class="layui-input" value="" style="float:left;width:150px;">
|
<input type="hidden" name="HSSID" id="HSSID" class="layui-input" value="0" style="float:left;width:150px;">
|
<button type="button" lay-submit="" class="layui-btn" lay-filter="HSSList" style="width:40px;">
|
<i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
|
</button>
|
</div>
|
</div>
|
<div class="layui-inline">
|
<label class="layui-form-label">合同日期<label style="color:red"> * </label></label>
|
<div class="layui-input-block">
|
<input type="date" class="layui-input" lay-verify="HContractDate" name="HContractDate" id="HContractDate" style="width:190px;">
|
</div>
|
</div>
|
</div>
|
|
<div class="layui-row" style="margin-top:10px;">
|
<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">
|
<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="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 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>
|
<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="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 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-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="HDeleteDate" id="HDeleteDate" style="background-color:#efefef4d;" readonly>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
<div class="layui-tab" lay-filter="tab-POStockInBill">
|
<ul class="layui-tab-title" lay-filter="tab-all">
|
<li style="padding:1px;" class="layui-this">物料明细</li>
|
<li style="padding:1px;">采购计划</li>
|
</ul>
|
<div class="layui-tab-content">
|
<div class="layui-tab-item layui-show">
|
<!--采购合同详细-->
|
<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="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>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
|
</div>
|
</script>
|
<script type="text/html" id="xuhao">
|
{{d.LAY_TABLE_INDEX+1}}
|
</script>
|
</div>
|
<div class="layui-tab-item">
|
<!--付款计划列表-->
|
<table class="layui-hide" id="mainTable2" lay-filter="mainTable2"></table>
|
<script type="text/html" id="toolbarDemo2">
|
<div class="layui-btn-container">
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-AddLine2"><i class="layui-icon layui-icon-form"></i>增加一行</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-CopyLine2"><i class="layui-icon layui-icon-form"></i>复制一行</button>
|
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn2"><i class="layui-icon layui-icon-form"></i>列设置</button>
|
</div>
|
</script>
|
<script type="text/html" id="xuhao">
|
{{d.LAY_TABLE_INDEX+1}}
|
</script>
|
</div>
|
</div>
|
</div>
|
</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 type="text/html" id="barDemo2">
|
<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
|
</script>
|
<script>
|
//#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
|
, laydate = layui.laydate
|
, 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 HOrgIDBar = 0;
|
|
//#region 进入页面即加载
|
|
//判断是否登录 未登录则跳到登录页
|
get_LoginIs();
|
|
//#region 【动态获取模块名称】
|
var HModuleType = "1400";
|
//通过单据类型，从数据库动态获取单据模块命名,引用js文件 PageTitle.js
|
var HPageTitle = get_PageTitle(HModuleType) == "" ? $("h1").html() : get_PageTitle(HModuleType);
|
$("h1").html('<b>' + HPageTitle + '</b>');
|
//#endregion
|
|
//获取页面跳转参数
|
var params = get_UrlVars();
|
var OperationType = params[params[0]]; //从参数中获取 数据类型 1添加 保存 2复制 3 编辑
|
var linterid = params[params[1]]; //从参数中获取 单据内码
|
|
$("#HUSEORGID").val(sessionStorage["OrganizationID"]);
|
|
//判断是否新增
|
if (linterid == null || linterid == 0) {
|
//获取最大单据号 new
|
$("#HMaker").val(sessionStorage["HUserName"]);
|
$("#HInterID").val("0");
|
$("#HBillNo").val("");
|
$.ajax({
|
url: GetWEBURL() + "/Web/GetMAXNum",
|
type: "GET",
|
data: { "HBillType": '1400' },
|
success: function (d) {
|
//console.log(d.data);
|
$("#HBillNo").val(d.data[0].HBillNo);
|
$("#HDate").val(Format(new Date(), "yyyy-MM-dd"));
|
$("#HContractDate").val(Format(new Date(), "yyyy-MM-dd"));
|
$("#HInterID").val(d.data[0].HInterID);
|
}
|
});
|
//页面初始化加载
|
$("#HDeptID").val(sessionStorage["HDeptID"]);
|
$("#HDeptName").val(sessionStorage["HDept"]);
|
$("#HEmpName").val(sessionStorage["HUserName"]);
|
$("#HEmpID").val(sessionStorage["HEmpID"]);
|
|
//根据当前登录用户的部门 获取 主管
|
if ($("#HDeptID").val() != 0) {
|
$.ajax({
|
url: GetWEBURL() + "Gy_Department/list",
|
async: false,
|
type: "GET",
|
data: {
|
"sWhere": "and HItemID = '" + $("#HDeptID").val() + "'", "user": sessionStorage["HUserName"], "Organization": sessionStorage["Organization"]
|
},
|
success: function (result) {
|
$("#HManagerID").val(result.data[0].HEmpID);
|
$("#HManagerName").val(result.data[0].负责人);
|
}, error: function () {
|
layer.alert("发生错误!", { icon: 5 });
|
}
|
});
|
}
|
|
} else {//如果修改则走下面 new
|
$("#HInterID").val(linterid);
|
RoadBillMain(linterid);
|
}
|
//#endregion
|
|
var rowdata = [{
|
"HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "HWHID": 0, "HWHName": "", "数量": "", "HRemark": ""
|
, "HPrice": "", "HTaxPrice": "", "HMoney": "", "HDiscountRate": 1, "HRelTaxPrice": "", "HTaxRate": 1, "HTaxMoney": "", "HlineTotal": "", "HlineTotalBB": "", "HDate": Format(new Date, "yyyy- MM - dd"),
|
}];
|
var rowdata2 = [{
|
"HDate": Format(new Date, "yyyy-MM-dd"), "HMoney": "", "HCurID": 0, "HExRate": "", "货币名称": "",
|
}];
|
//#region 初始化界和头工具栏事件
|
set_InitGrid();
|
set_InitGrid2();
|
//物料明细头工具栏事件
|
table.on('toolbar(mainTable)', function (obj) {
|
var checkStatus = table.checkStatus('mainTable')
|
, data = checkStatus.data;
|
|
//新增行表格数据
|
var NewRow = {
|
"HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "数量": "", "HRemark": ""
|
, "HPrice": "", "HMoney": "", "HTaxRate": 1, "HTaxMoney": "", "HlineTotal": ""
|
};
|
switch (obj.event) {
|
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 'get_Inventory': get_Inventory();
|
break;
|
//出入库记录查询
|
case 'get_InOutSum': get_InOutSum();
|
break;
|
//列设置
|
//case 'set_hidecolumn':
|
// get_hidecolumn();
|
// break;
|
}
|
});
|
//付款计划头工具栏事件
|
table.on('toolbar(mainTable2)', function (obj) {
|
var checkStatus = table.checkStatus('mainTable2')
|
, data = checkStatus.data;
|
//新增行表格数据
|
var NewRow = {
|
"HDate": Format(new Date, "yyyy-MM-dd"), "HMoney": "", "HCurID": 0, "HExRate": "", "HRemark": "", "货币名称": ""
|
};
|
switch (obj.event) {
|
case 'btn-AddLine2':
|
table.cache["mainTable2"].push(NewRow);
|
option2.data = table.cache["mainTable2"];
|
|
table.render(option2);
|
//刷新复选框
|
//checkRefresh();
|
break;
|
case 'btn-CopyLine2':
|
var copyschemedata = JSON.stringify(data);
|
if (data.length <= 0) {
|
layer.msg("请选择需要复制的一行！");
|
}
|
else if (data.length > 1) {
|
layer.msg("只能选择复制一行！");
|
}
|
else {
|
var copyschemedata2 = copyschemedata.substring(1, copyschemedata.length);//去除首行字符'['
|
var copyschemerow = copyschemedata2.substring(0, copyschemedata2.length - 1);//去除末尾字符']'
|
table.cache["mainTable2"].push(JSON.parse(copyschemerow));//将复制的行强转成json追加到表格上
|
option2.data = table.cache["mainTable2"];//将数据绑定到data上
|
table.render(option2);//将数据渲染到表格上
|
//刷新复选框
|
//checkRefresh();
|
}
|
break;
|
//列设置
|
//case 'set_hidecolumn':
|
// get_hidecolumn();
|
// break;
|
}
|
});
|
//#endregion
|
//#region 触发事件：包括form.on(){}格式的所有点击事件、选择事件等
|
|
//退出按钮
|
form.on('submit(Exit)', function () {
|
Pub_Close(1);
|
})
|
|
//选择业务员按钮
|
form.on('submit(HEmpList)', function () {
|
get_checkEmp();
|
});
|
//选择客户按钮
|
form.on('submit(HCusList)', function () {
|
get_checkCus();
|
});
|
//选择结算按钮
|
form.on('submit(HSSList)', function () {
|
get_checkSS();
|
});
|
|
//选择币别按钮
|
form.on('submit(HCurList)', function () {
|
get_checkCur();
|
});
|
|
//选择部门按钮
|
form.on('submit(HDeptList)', function () {
|
get_checkDept();
|
});
|
|
//保存按钮
|
form.on('submit(set_SaveBill)', function (data) {
|
set_SaveBill(data);
|
});
|
|
//行内事件
|
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();
|
}
|
});
|
}
|
});
|
table.on('tool(mainTable2)', 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();
|
}
|
});
|
}
|
});
|
//#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 HTaxMoney = Number((HMoney * HTaxRate).toFixed(4)); //税额=金额*税率
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
var HExRate = $("#HExRate").val(); //汇率
|
//数字精度
|
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));
|
//同步更新表格和缓存对应的值
|
obj.update({
|
HQty: HQty
|
, HPrice: HPrice
|
, HMoney: HMoney
|
, HTaxMoney: HTaxMoney
|
, 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 HTaxMoney = Number((HMoney * HTaxRate).toFixed(4)); //税额=金额*税率
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
var HExRate = $("#HExRate").val(); //汇率
|
//数字精度
|
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));
|
//同步更新表格和缓存对应的值
|
obj.update({
|
HQty: HQty
|
, HPrice: HPrice
|
, HMoney: HMoney
|
, HTaxMoney: HTaxMoney
|
, HlineTotal: HlineTotal
|
});
|
table.render(option)
|
break;
|
case "HTaxRate": //数量
|
//数据格式校验
|
temp = value + "";
|
if (!ref.test(temp)) {
|
//恢复数据到编辑前
|
obj.update({
|
HTaxRate: oldText
|
});
|
|
layer.msg("税率请输入不小于0的数字!");
|
return;
|
}
|
|
|
//数据校验合格，重算记录
|
var HTaxRate = obj.data.HTaxRate * 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 HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
var HExRate = $("#HExRate").val(); //汇率
|
//数字精度
|
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));
|
//同步更新表格和缓存对应的值
|
obj.update({
|
HTaxRate: HTaxRate * 100
|
, HQty: HQty
|
, HPrice: HPrice
|
, HMoney: HMoney
|
, HTaxMoney: HTaxMoney
|
, HlineTotal: HlineTotal
|
});
|
break;
|
table.render(option);
|
default:
|
}
|
});
|
//#endregion
|
|
//#region 文本框监听
|
$(document).ready(function () {
|
//#region 汇率失焦事件
|
var oldHExRate = ""; //修改前的值
|
var newHExRate = ""; //修改后的值
|
$("#HExRate").on('focus', function (data) {
|
oldHExRate = $("#HExRate").val() * 1; //汇率文本框获取焦点时获取修改前的值
|
}).on('blur', function (data) {
|
newHExRate = $("#HExRate").val(); //汇率文本框失焦时获取修改后的值
|
|
//判断输入的汇率是否合法
|
var ref = /^\d+(\.\d+)?$/; //非负数正则表达式
|
if (!ref.test(newHExRate)) {
|
layer.msg("汇率请输入不小于0的数字!");
|
$("#HExRate").val(oldHExRate);
|
return false;
|
}
|
|
//输入的汇率合法，重算
|
var HExRate = newHExRate * 1; //汇率
|
$("#HExRate").val(HExRate);
|
|
for (var i = 0; i < option.data.length; i++) {
|
var HMoney = option.data[i].HMoney;
|
var HTaxMoney = option.data[i].HTaxMoney;
|
option.data[i].HlineTotalBB = (option.data[i].HMoney + option.data[i].HTaxMoney) * HExRate;
|
}
|
table.render(option);
|
|
});
|
//#endregion
|
});
|
//#endregion
|
|
//#region 本页面所有被调用的方法
|
|
//#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
|
|
//#region 时间转换
|
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('-');
|
}
|
//#endregion
|
//#region 初始化页签
|
function set_InitGrid() {
|
option = {
|
elem: '#mainTable'
|
, toolbar: '#toolbarDemo'
|
, totalRow: true
|
, limit: 500
|
, height: 500
|
, loading: false
|
, cols: [[ //子表
|
{ type: 'checkbox', fixed: 'left', totalRowText: '合计行', style: 'background-color:#efefef4d;' }
|
, { type: 'numbers', title: '序号', width: 100, style: 'background-color:#efefef4d;' }
|
, { 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: 'HQty', title: '数量', width: 100, edit: 'text', totalRow: true }
|
, { field: 'HPrice', title: '单价', width: 100, edit: 'text' }
|
, { field: 'HMoney', title: '金额', width: 100, totalRow: true, style: 'background-color:#efefef4d;' }
|
, { field: 'HTaxRate', title: '税率', width: 100, edit: 'text' }
|
, { field: 'HTaxMoney', title: '税额', width: 100, style: 'background-color:#efefef4d;' }
|
, { field: 'HlineTotal', title: '价税合计', width: 100, edit: 'text' }
|
, { field: 'HRemark', title: '备注', width: 100, edit: 'text' }
|
, { fixed: 'right', title: '操作', toolbar: '#barDemo', width: 70 }
|
]]
|
}
|
|
option.data = rowdata;
|
table.render(option);
|
}
|
function set_InitGrid2() {
|
option2 = {
|
elem: '#mainTable2'
|
, toolbar: '#toolbarDemo2'
|
, totalRow: true
|
, limit: 500
|
, height: 500
|
, loading: false
|
, cols: [[ //子表
|
{ type: 'checkbox', fixed: 'left', totalRowText: '合计行', style: 'background-color:#efefef4d;' }
|
, { type: 'numbers', title: '序号', width: 100, style: 'background-color:#efefef4d;' }
|
, { field: 'HCurID', title: '货币代码', width: 100, hide: true }
|
, { field: '货币名称', title: '货币名称', width: 100, edit: 'text', event: "HCurID" }//f7
|
, { field: 'HExRate', title: '汇率', width: 100, totalRow: true, style: 'background-color:#efefef4d;' }
|
, { field: 'HMoney', title: '金额', width: 100, edit: 'text', totalRow: true }
|
, { field: 'HDate', title: '到货日期', width: 120, event: 'HDate' }
|
, { field: 'HRemark', title: '备注', width: 100, edit: 'text' }
|
, { fixed: 'right', title: '操作', toolbar: '#barDemo2', width: 70 }
|
]]
|
}
|
|
option2.data = rowdata2;
|
table.render(option2);
|
}
|
//#endregion
|
//#region 加载表头
|
function RoadBillMain(linterid) {
|
//查询检验方案单是否存在
|
var ajaxLoad = layer.load();
|
$.ajax({
|
url: GetWEBURL() + "/Xs_ContractBill/cx",
|
type: "GET",
|
data: {
|
"HInterID": linterid
|
},
|
success: function (result) {
|
if (result.code == 1) { // 说明验证成功了，
|
var data = result.data;
|
allVal = result.data[0];
|
form.val("component-form-group",
|
{ //formTest 即 class="layui-form" 所在元素属性 lay-filter="" 对应的值
|
"HBillNo": data[0].单据号
|
, "HDate": formatDate(data[0].日期)
|
, "HSSDate": formatDate(data[0].结算日期)
|
//, "HInnerBillNo": data.内部单据号
|
, "HAddress": data[0].交货地点
|
, "HDeptName": data[0].部门
|
, "HDeptID": data[0].HDeptID
|
, "HCusID": data[0].HCusID
|
, "HCusName": data[0].客户
|
, "HEmpID": data[0].HEmpID
|
, "HEmpName": data[0].业务员
|
, "HCurID": data[0].HCurID
|
, "HCurName": data[0].币别
|
, "HExRate": data[0].汇率
|
, "HSSID": data[0].HSSID
|
, "HSSName": data[0].结算方式
|
, "HInnerBillNo": data[0].内部单据
|
, "HRemark": data[0].表头备注
|
, "HMaker": data[0].制单人
|
, "HChecker": data[0].审核人
|
, "HCloseMan": data[0].关闭人
|
, "HMakeDate": data[0].制单日期
|
, "HCheckDate": data[0].审核日期
|
, "HCloseDate": data[0].关闭日期
|
, "HUpDateDate": data[0].修改日期
|
, "HDeleteDate": data[0].作废日期
|
, "HContractDate": formatDate(data[0].合同日期)
|
, "HContractName": data[0].合同名称
|
});
|
|
|
//子表 1 赋值
|
var rowdata = [];
|
var obj = {};
|
for (var i = 0; i < data.length; i++) {
|
|
//利用对象id不能重复的特性去除子表重复值
|
if (!obj[data[i].hsubid]) {
|
obj[data[i].hsubid] = 1;
|
rowdata.push(
|
{
|
"HMaterID": data[i].HMaterID, "物料代码": data[i].物料代码, "物料名称": data[i].物料名称
|
, "规格型号": data[i].规格型号, "HUnitID": data[i].HUnitID
|
, "计量单位": data[i].计量单位, "HQty": data[i].数量, "HRemark": data[i].表体备注
|
, "HPrice": data[i].原币单价, "HMoney": data[i].原币金额, "HTaxRate": data[i].税率
|
, "HTaxMoney": data[i].原币金额 * data[i].税率 * 0.01, "HlineTotal": data[i].原币金额 + data[i].税额
|
}
|
)
|
}
|
|
|
}
|
option.data = rowdata;
|
table.render(option);
|
//子表2
|
var rowdata = [];
|
obj = {};
|
for (var i = 0; i < data.length; i++) {
|
//利用对象id不能重复的特性去除子表重复值
|
if (!obj[data[i].HSchemeID]) {
|
obj[data[i].HSchemeID] = 1;
|
rowdata.push(
|
{
|
"HCurID": data[i].HScCurID, "货币名称": data[i].计划币别, "HExRate": data[i].计划汇率
|
, "HMoney": data[i].计划金额, "HDate": data[i].付款日期, "HRemark": data[i].计划备注,
|
}
|
)
|
}
|
}
|
option2.data = rowdata;
|
table.render(option2);
|
|
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
|
|
//#region 保存方法
|
function set_SaveBill(data) {
|
|
if ($("#HCurID").val() == 0) {
|
layer.msg("请选择币别！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
return;
|
}
|
if ($("#HExRate").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 ($("#HDeptID").val() == 0) {
|
layer.msg("请选择采购部门！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
return;
|
}
|
if ($("#HCusID").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;
|
}
|
//物料明细
|
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])
|
}
|
}
|
//付款计划
|
var numScheme = [];
|
for (var i = 0; i < table.cache["mainTable2"].length; i++) {
|
if (table.cache["mainTable2"][i] != "") {
|
table.cache["mainTable2"][i].LAY_TABLE_INDEX = i;
|
numScheme.push(table.cache["mainTable2"][i])
|
}
|
}
|
var sMainStr = JSON.stringify(data.field);
|
var sSubStr = JSON.stringify(num);
|
var sSchemeStr = JSON.stringify(numScheme);
|
var sAllStr = JSON.stringify(allVal);
|
//var hentryid = linteridSub;//子表 排序id
|
var sMainSub = sMainStr + ';' + sSubStr + ';' + sSchemeStr + ';' + OperationType + ";" + sessionStorage["HUserName"] + ";" + sAllStr;
|
|
$.ajax({
|
type: "POST",
|
url: GetWEBURL() + "Xs_ContractBill/ContractBillEdit", //方法所在页面和方法名
|
async: true,
|
data: { "sMainSub": sMainSub },
|
dataType: "json",
|
success: function (data) {
|
if (data.count == 1) { // 说明验证成功了，
|
layer.msg(data.Message, { icon: 1 });
|
|
$('#add-btn').addClass("layui-btn-disabled").attr("disabled", true);
|
//保存后浏览
|
//ReRoadBillMain();
|
}
|
else {
|
layer.alert(data.Message, { icon: 5 });
|
}
|
layer.closeAll("loading");
|
},
|
error: function (err) {
|
layer.alert("错误:" + err, { icon: 5 });
|
console.log("Reason" + sMainStr);
|
}
|
});
|
}
|
//#endregion
|
|
//#region 行内事件
|
//行内快捷键筛选
|
function set_GridCellCheck(obj) {
|
$(document).off('keydown', ".layui-table-edit").on('keydown', '.layui-table-edit', function (e) {
|
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];
|
var TaxRate = getHTaxRateByHSupID();
|
|
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, "计量单位": "", "HWHID": 0, "HWHName": "", "数量": "", "HRemark": ""
|
, "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "1", "HRelTaxPrice": "0", "HTaxRate": "0", "HTaxMoney": "0", "HlineTotal": "0", "HlineTotalBB": "0", "HDate": Format(new Date, "yyyy- MM - dd")
|
};
|
|
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;
|
}
|
table.render(option);
|
}
|
layer.closeAll();
|
//layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) {
|
//按钮【按钮二】的回调
|
//return false 开启该代码可禁止点击该按钮关闭
|
},
|
end: function () {
|
//通过供应商id获取税率
|
var HSupID = $("#HCusID").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_Customer/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 HExRate = $("#HExRate").val(); //汇率
|
//数据校验合格，重算记录
|
var HQty = obj.data.HQty * 1; //数量
|
var HPrice = obj.data.HPrice * 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));
|
HMoney = Number(HMoney.toFixed(HMoneyDec));
|
HTaxMoney = Number(HTaxMoney.toFixed(HMoneyDec));
|
HlineTotal = Number(HlineTotal.toFixed(HMoneyDec));
|
|
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
|
, HTaxMoney: HTaxMoney //更新HTaxMoney字段，HTaxMoney
|
, HlineTotal: HlineTotal //更新HlineTotal字段，HlineTotal
|
})
|
}
|
});
|
} else if (typeof (OptionData.HItemID) != "undefined") {
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.物料代码
|
, "物料名称": OptionData.物料名称
|
, "规格型号": OptionData.规格型号
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.计量单位名称
|
})
|
}
|
|
}
|
});
|
}
|
//计量单位
|
if (obj.event == "HUnitID") {
|
layer.open({
|
type: 2
|
, skin: "layui-layer-rim" //加上边框
|
, title: "计量单位列表" //标题
|
, closeBtn: 1 //窗体右上角关闭 的 样式
|
, shift: 2 //弹出动画
|
, area: ["90%", "90%"] //窗体大小
|
, maxmin: true //设置最大最小按钮是否显示
|
, content: ['../../基础资料/公用基础资料/Gy_Unit.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("请选择一条数据");
|
}
|
OptionData = checkStatus.data[0];
|
//更新表格缓存的数据
|
obj.update({
|
"HUnitID": checkStatus.data[0].HItemID
|
, "计量单位": checkStatus.data[0].计量单位名称
|
})
|
layer.close(index);//关闭弹窗
|
}
|
, end: function () {
|
obj.update({
|
"HUnitID": OptionData.HItemID
|
, "计量单位": OptionData.计量单位名称
|
})
|
}
|
})
|
}
|
//货币
|
if (obj.event == "HCurID") {
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '币别列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/公用基础资料/Gy_Currency.html', '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('请选择数据');
|
}
|
OptionData = checkStatus.data[0];
|
obj.update({
|
"HCurID": checkStatus.data[0].HItemID
|
, "HExRate": checkStatus.data[0].汇率
|
, "货币名称": checkStatus.data[0].货币名称
|
})
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, end: function () {
|
obj.update({
|
"HCurID": OptionData.HItemID
|
, "HExRate": OptionData.汇率
|
, "货币名称": OptionData.货币名称
|
})
|
}
|
})
|
}
|
|
obj.event = "";
|
return false;
|
}
|
|
})
|
//双击
|
$('.layui-table-box tbody td[data-field="物料代码"]').off('dblclick').on('dblclick', function () {
|
//物料
|
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];
|
var TaxRate = getHTaxRateByHSupID();
|
|
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, "计量单位": "", "HWHID": 0, "HWHName": "", "数量": "", "HRemark": ""
|
, "HPrice": "0", "HTaxPrice": "0", "HMoney": "0", "HDiscountRate": "1", "HRelTaxPrice": "0", "HTaxRate": "0", "HTaxMoney": "0", "HlineTotal": "0", "HlineTotalBB": "0", "HDate": Format(new Date, "yyyy- MM - dd")
|
};
|
|
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;
|
}
|
table.render(option);
|
}
|
layer.closeAll();
|
//layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) {
|
//按钮【按钮二】的回调
|
//return false 开启该代码可禁止点击该按钮关闭
|
},
|
end: function () {
|
//通过供应商id获取税率
|
var HSupID = $("#HCusID").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_Customer/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 HExRate = $("#HExRate").val(); //汇率
|
//数据校验合格，重算记录
|
var HQty = obj.data.HQty * 1; //数量
|
var HPrice = obj.data.HPrice * 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));
|
HMoney = Number(HMoney.toFixed(HMoneyDec));
|
HTaxMoney = Number(HTaxMoney.toFixed(HMoneyDec));
|
HlineTotal = Number(HlineTotal.toFixed(HMoneyDec));
|
|
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
|
, HTaxMoney: HTaxMoney //更新HTaxMoney字段，HTaxMoney
|
, HlineTotal: HlineTotal //更新HlineTotal字段，HlineTotal
|
})
|
}
|
});
|
} else if (typeof (OptionData.HItemID) != "undefined"){
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.物料代码
|
, "物料名称": OptionData.物料名称
|
, "规格型号": OptionData.规格型号
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.计量单位名称
|
})
|
}
|
|
}
|
});
|
}
|
});
|
}
|
|
//#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
|
|
//行内删除
|
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();
|
option.data = table.cache["mainTable"];//将数据绑定到data上
|
table.reload(option);
|
option2.data = table.cache["mainTable2"];//将计划数据绑定到data上
|
table.reload(option2);
|
layer.close(index);
|
}
|
});
|
}
|
}
|
//采购员
|
function get_checkEmp() {
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '采购员列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/公用基础资料/Gy_EmployeeList.html?Type=HEmp', '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_checkCus() {
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '客户列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/销售基础资料/Gy_Customer.html?Type=HCus', '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('请选择数据');
|
}
|
$("#HCusName").val(checkStatus.data[0].客户名称);
|
$("#HCusID").val(checkStatus.data[0].HItemID);
|
|
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
//货币
|
function get_checkCur() {
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '币别列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/公用基础资料/Gy_Currency.html', '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('请选择数据');
|
}
|
$("#HCurName").val(checkStatus.data[0].货币名称);
|
$("#HCurID").val(checkStatus.data[0].HItemID);
|
$("#HExRate").val(checkStatus.data[0].汇率)
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
//采购部门
|
function get_checkDept() {
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '采购部门列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/公用基础资料/Gy_DepartmentList.html', '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);
|
$("#HManagerID").val(checkStatus.data[0].HEmpID);
|
$("#HManagerName").val(checkStatus.data[0].负责人);
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
//结算方式
|
function get_checkSS() {
|
layer.open({
|
type: 2//弹窗类型
|
, skin: 'layui-layer-rim' //加上边框
|
, area: ['90%', '90%']//大小
|
, title: '结算方式列表'//标题
|
, shift: 2//弹出动画
|
, content: ['../../基础资料/基础资料/Gy_SettleStyle.html', '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('请选择数据');
|
}
|
$("#HSSName").val(checkStatus.data[0].结算方式名称);
|
$("#HSSID").val(checkStatus.data[0].HItemID);
|
layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) { }
|
})
|
}
|
//#endregion
|
|
//#region 根据物料ID获取物料详细信息
|
function getMaterialByMaterID(HMaterID) {
|
var resultData = {};
|
$.ajax({
|
url: GetWEBURL() + "Xs_ContractBill/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 根据物料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 通过客户id获取税率
|
function getHTaxRateByHSupID() {
|
var HTaxRate;
|
//通过供应商id获取税率
|
var HSupID = $("#HCusID").val();
|
if (HSupID != 0) {
|
$.ajax({
|
url: GetWEBURL() + "/Gy_Customer/xg",
|
type: "GET",
|
async: false,
|
data: {
|
"HInterID": HSupID
|
},
|
success: function (d) {
|
HTaxRate = parseInt(d.data[0].增值税率);
|
}
|
});
|
} else {
|
HTaxRate = 0;
|
}
|
return HTaxRate;
|
}
|
//#endregion
|
|
//#region 保存后浏览方法
|
function ReRoadBillMain() {
|
location.replace('Add_Edit_Xs_POInStockBillList.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
|
|
//#endregion
|
|
|
//以上是layui模块
|
|
});
|
//#region 基础资料返回数据
|
function GetHEmpValue(obj) //返回采购员
|
{
|
$("#HEmpName").val(obj[0].职员名称);
|
$("#HEmpID").val(obj[0].HItemID);
|
}
|
|
function GetHDeptNameValue(obj) //返回采购部门
|
{
|
$("#HDeptName").val(obj[0].部门名称);
|
$("#HDeptID").val(obj[0].HItemID);
|
}
|
|
function GetHPSStyleNameValue(obj) //返回采购方式
|
{
|
$("#HPSStyleName").val(obj[0].采购方式名称);
|
$("#HPSStyleID").val(obj[0].HItemID);
|
}
|
|
function GetHCusNameValue(obj) //返回客户
|
{
|
$("#HCusName").val(obj[0].客户名称);
|
$("#HCusID").val(obj[0].HItemID);
|
}
|
|
|
function GetSettleStyleValue(obj) //返回结算方式
|
{
|
$("#HSSName").val(obj[0].结算方式名称);
|
$("#HSSID").val(obj[0].HItemID);
|
}
|
|
//双击返回计量单位
|
function GetUnitValue(data) {
|
OptionData = data
|
}
|
|
//双击返回物料
|
function GetGyMaterial(data) {
|
OptionData = data
|
}
|
//双击返回货币
|
function GetGyCurValue(data) {
|
OptionData = data
|
}
|
//#endregion
|
</script>
|
</body>
|
</html>
|
