<!DOCTYPE html>
|
<html>
|
<head>
|
<meta charset="utf-8" />
|
<title>供应商报价单编辑</title>
|
<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
|
<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
|
<script src="../../../layuiadmin/layui/layui.js"></script>
|
<script src="../../../layuiadmin/Scripts/json2.js"></script>
|
<script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
|
<script src="../../../layuiadmin/Scripts/webConfig.js"></script>
|
<script src="../../../layuiadmin/PubCustom.js"></script>
|
<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
|
<script src="../../../layuiadmin/PageTitle.js"></script>
|
<style>
|
.main-btn { /*头部主按钮*/
|
padding: 0 2px; /*调整按钮左右空隙大小*/
|
height: 30px;
|
line-height: 30px;
|
}
|
|
.btn-title {
|
font-size: 16px;
|
}
|
/* 防止下拉框的下拉列表被隐藏---必须设置--- */
|
.layui-table-cell {
|
overflow: visible !important;
|
}
|
/* 使得下拉框与单元格刚好合适 */
|
td .layui-form-select {
|
margin-top: -10px;
|
margin-left: -15px;
|
margin-right: -15px;
|
}
|
|
.layui-form-item .layui-inline {
|
margin-top: 5px;
|
margin-bottom: 5px;
|
margin-right: 0px;
|
}
|
|
.layui-form-label {
|
width: 25%;
|
}
|
</style>
|
</head>
|
<body>
|
<div class="layui-fluid" style="padding: 0;">
|
<div class="layui-card" style="padding: 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="btnSave" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="btnSave">保存</button>
|
<button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Cancel">退出</button>
|
</div>
|
</div>
|
<div class="layui-tab" lay-filter="tab-POStockInBill">
|
<ul class="layui-tab-title" lay-filter="tab-all">
|
<li lay-id="1" style="padding:1px;" class="layui-this">基本信息</li>
|
<li lay-id="2" style="padding:1px;">其他信息</li>
|
</ul>
|
<div class="layui-tab-content">
|
<!--基本信息-->
|
<div class="layui-tab-item layui-show">
|
<div class="layui-form-item" style="padding-top: 10px;">
|
<div class="layui-row">
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-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>
|
<div class="layui-input-inline">
|
<input type="text" class="layui-input" name="HSupName" id="HSupName" onmouseover="this.title=this.value" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;" readonly>
|
<input type="hidden" name="HSupID" id="HSupID" value="0">
|
<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchSup" id="btnSearchSup" 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="date" class="layui-input" name="HDate" id="HDate">
|
</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" class="layui-input" name="HQuoteEmp" id="HQuoteEmp" style="">
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">报价部门</label>
|
<div class="layui-input-inline">
|
<input type="text" class="layui-input" name="HQuoteDept" id="HQuoteDept" style="">
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">币别</label>
|
<div class="layui-input-inline">
|
<input type="text" class="layui-input" name="HCurName" id="HCurName" onmouseover="this.title=this.value" style="float: left; width: 150px; background-color: #efefef4d; display: inline-block;" readonly>
|
<input type="hidden" name="HCurID" id="HCurID" value="0">
|
<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearchCur" id="btnSearchCur" 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" class="layui-input" name="HPayConditionID" id="HPayConditionID" style="background-color:#efefef4d;" value="0" readonly>
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">生效日期</label>
|
<div class="layui-input-inline">
|
<input type="date" class="layui-input" name="HBeginDate" id="HBeginDate">
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline">
|
<label class="layui-form-label">失效日期</label>
|
<div class="layui-input-inline">
|
<input type="date" class="layui-input" name="HEndDate" id="HEndDate">
|
</div>
|
</div>
|
</div>
|
<div class="layui-row">
|
<div class="layui-col-xs6 layui-inline">
|
<label class="layui-form-label" style="width:12.5%">备注</label>
|
<div class="layui-input-inline">
|
<input type="text" class="layui-input" name="HRemark" id="HRemark" style="width:500px;">
|
</div>
|
</div>
|
<div class="layui-col-xs6 layui-inline">
|
<label class="layui-form-label" style="width:12.5%">摘要</label>
|
<div class="layui-input-inline">
|
<input type="text" class="layui-input" name="HExplanation" id="HExplanation" style="width:500px;">
|
</div>
|
</div>
|
<div class="layui-col-xs4 layui-inline" style="display:none">
|
<label class="layui-form-label">源单信息</label>
|
<div class="layui-input-inline">
|
<input type="hidden" name="HMainSourceBillType" id="HMainSourceBillType" value="0">
|
<input type="hidden" name="HMainSourceInterID" id="HMainSourceInterID" value="0">
|
<input type="hidden" name="HMainSourceEntryID" id="HMainSourceEntryID" value="0">
|
<input type="hidden" name="HMainSourceBillNo" id="HMainSourceBillNo" value="">
|
</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="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="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>
|
</form>
|
</div>
|
</div>
|
</div>
|
</body>
|
</html>
|
<script type="text/html" id="barDemo">
|
<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
|
</script>
|
<script>
|
layui.config({
|
base: '../../../layuiadmin/' //静态资源所在路径
|
}).extend({
|
index: 'lib/index' //主入口模块
|
}).use(['index', 'form', 'laydate', 'table', 'element'], function () {
|
//#region 公共变量
|
|
var $ = layui.$
|
, admin = layui.admin
|
, layer = layui.layer
|
, table = layui.table
|
, form = layui.form
|
, laydate = layui.laydate
|
, element = layui.element;
|
var option;
|
|
//#endregion
|
|
//#region 进入页面即加载
|
|
//#region 【动态获取模块名称】
|
var HModuleType = "1507";
|
//通过单据类型，从数据库动态获取单据模块命名,引用js文件 PageTitle.js
|
var HPageTitle = get_PageTitle(HModuleType) == "" ? $("h1").html() : get_PageTitle(HModuleType);
|
$("h1").html('<b>' + HPageTitle + '</b>');
|
//#endregion
|
|
//初始化界面
|
set_ClearBill();
|
|
var params = get_UrlVars();
|
if (typeof (params[params[0]]) == "undefined") {
|
var OperationType = 1;//操作类型
|
} else {
|
var OperationType = params[params[0]];//操作类型
|
var linterid = params[params[1]];//源单id
|
var HEntryID = params[params[2]];//源单子id
|
var HIeID = params[params[3]]; //源单id + 源单子id
|
}
|
|
//供应商报价单新增
|
if (OperationType == 1) {
|
$.ajax({
|
url: GetWEBURL() + "/Web/GetMAXNum",
|
type: "GET",
|
data: { "HBillType": '1121' },
|
success: function (d) {
|
//$("#HInterID").val(d.data[0].HInterID);
|
$("#HBillNo").val(d.data[0].HBillNo);
|
$("#HMakeDate").val(Format(new Date(), "yyyy-MM-dd hh:mm:ss"));
|
$("#HMaker").val(sessionStorage["HUserName"]);
|
}
|
});
|
//初始化界面
|
set_ClearBill();
|
} else if (OperationType == 3) {
|
//初始化界面
|
set_ClearBill();
|
RoadBillMain(linterid);
|
}
|
|
//#endregion
|
|
//#region 触发事件：包括form.on(){}格式的所有点击事件、选择事件等
|
|
//头工具栏事件
|
table.on('toolbar(mainTable)', function (obj) {
|
var checkStatus = table.checkStatus('mainTable')
|
, data = checkStatus.data;
|
//新增行表格数据
|
var NewRow = {
|
"HMaterID": 0, "HMaterNumber": "", "HMaterName": "", "HMaterModel": "", "HUnitID": 0, "HUnitNumber": "",
|
"HUnitName": "", "HQty": 0, "HPrice": 0, "HMoney": 0, "HTaxPrice": 0, "HTaxRate": 0, "HTaxMoney": 0,
|
"HlineTotal": 0, "HlineTotalBB": 0, "HDate": new Date(), "HBagType": "", "HCarryType": "", "HAddress": "", "HRemark": ""
|
};
|
|
switch (obj.event) {
|
case 'btn-AddLine':
|
table.cache["mainTable"].push(NewRow);
|
option.data = table.cache["mainTable"];
|
table.render(option);
|
break;
|
case 'btn-CopyLine':
|
var copydata = JSON.stringify(data);
|
if (data.length <= 0) {
|
layer.msg("请选择需要复制的一行！");
|
}
|
else if (data.length > 1) {
|
layer.msg("只能选择复制一行！");
|
}
|
else {
|
var copydata2 = copydata.substring(1, copydata.length);//去除首行字符'['
|
var copyrow = copydata2.substring(0, copydata2.length - 1);//去除末尾字符']'
|
table.cache["mainTable"].push(JSON.parse(copyrow));//将复制的行强转成json追加到表格上
|
option.data = table.cache["mainTable"];//将数据绑定到data上
|
table.render(option);//将数据渲染到表格上
|
}
|
break;
|
|
//库存查询
|
case 'get_Inventory': get_Inventory();
|
break;
|
//出入库记录查询
|
case 'get_InOutSum': get_InOutSum();
|
break;
|
}
|
});
|
|
//行内事件
|
table.on('tool(mainTable)', function (obj) {
|
var data = obj.data;
|
var rowIndex = $(obj.tr).attr("data-index");
|
if (obj.event === 'del') {
|
layer.confirm('真的删除行吗？', function (index) {
|
if (rowIndex === '0') {
|
layer.msg('首行无法删除！！！');
|
} else {
|
obj.del();
|
option.data = table.cache["mainTable"];//将数据绑定到data上
|
layer.close(index);
|
}
|
});
|
}
|
|
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();
|
}
|
});
|
}
|
|
if (obj.event == 'inputHQty' || obj.event == 'inputHPrice' || obj.event == 'inputHMoney' || obj.event == 'inputHTaxPrice' || obj.event == 'inputHTaxRate' || obj.event == 'inputHTaxMoney' || obj.event == 'inputHlineTotal' || obj.event == 'inputHlineTotalBB') {
|
$(obj.tr).find(".layui-table-edit").keyup(function () {
|
var $input = $(this), val = $input.val();
|
if (!val) val = "0";
|
$input.val(val.replace(/[^\d*\.?\d*]/g, ''));
|
});
|
}
|
|
//#region [ 表体F7事件 ]
|
$(document).off('keydown', ".layui-table-edit").on('keydown', '.layui-table-edit', function (e) {
|
if (event.key == "F7") {
|
if (obj.event == 'HMaterID') {
|
layer.open({
|
type: 2,
|
skin: 'layui-layer-rim', //加上边框
|
title: '产品列表',
|
closeBtn: 1,
|
shift: 2,
|
area: ['90%', '90%'],
|
maxmin: true,
|
content: ['../../../views/Baseset/基础资料/Gy_MaterialList.html', 'yes'],
|
btn: ['确定', '取消']
|
, btn1: function (index, layero) {
|
//按钮【按钮一】的回调
|
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];
|
|
layer.close(layer.index);
|
}
|
, btn2: function (index, layero) {
|
},
|
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).toFixed(4)); //税额=金额*税率
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
var HTaxPrice = Number((HPrice * (1 + HTaxRate)).toFixed(4)); //含税单价=单价*(1+税率)
|
//数字精度
|
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.HNumber
|
, "物料名称": OptionData.HName
|
, "规格型号": OptionData.HModel
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.HUnitName
|
, "HTaxRate": HTaxRate * 100
|
, HQty: HQty //更新HQty字段，HQty
|
, HPrice: HPrice //更新HPrice字段，HPrice
|
, HMoney: HMoney //更新HMoney字段，HMoney
|
, HTaxMoney: HTaxMoney //更新HTaxMoney字段，HTaxMoney
|
, HlineTotal: HlineTotal //更新HlineTotal字段，HlineTotal
|
, HTaxPrice, HTaxPrice //更新HTaxPrice字段，HTaxPrice
|
})
|
}
|
});
|
} else if (typeof (OptionData.HItemID) != "undefined") {
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.HNumber
|
, "物料名称": OptionData.HName
|
, "规格型号": OptionData.HModel
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.HUnitName
|
})
|
}
|
}
|
});
|
}
|
if (obj.event == 'HUnitID') {
|
layer.open({
|
type: 2,
|
skin: 'layui-layer-rim', //加上边框
|
title: '计量单位列表',
|
closeBtn: 1,
|
shift: 2,
|
area: ['90%', '90%'],
|
maxmin: true,
|
content: ['../../../views/Baseset/基础资料/Gy_UnitList.html', 'yes'],
|
btn: ['确定', '取消']
|
, btn1: function (index, layero) {
|
//按钮【按钮一】的回调
|
var iframeWindow = window['layui-layer-iframe' + index];
|
var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');
|
if (checkStatus.data.length === 0) {
|
return layer.msg('请选择数据');
|
}
|
obj.update({
|
HUnitID: checkStatus.data[0].HItemID
|
, HUnitNumber: checkStatus.data[0].HNumber
|
, HUnitName: checkStatus.data[0].HName
|
});
|
|
layer.close(layer.index);
|
}
|
, btn2: function (index, layero) {
|
},
|
end: function () {
|
|
}
|
});
|
}
|
|
obj.event = "";
|
return false;
|
}
|
})
|
//#endregion
|
//双击
|
$('.layui-table-box tbody td[data-field="HMaterNumber"]').off('dblclick').on('dblclick', function () {
|
layer.open({
|
type: 2,
|
skin: 'layui-layer-rim', //加上边框
|
title: '产品列表',
|
closeBtn: 1,
|
shift: 2,
|
area: ['90%', '90%'],
|
maxmin: true,
|
content: ['../../../views/Baseset/基础资料/Gy_MaterialList.html', 'yes'],
|
btn: ['确定', '取消']
|
, btn1: function (index, layero) {
|
//按钮【按钮一】的回调
|
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];
|
|
layer.close(layer.index);
|
}
|
, btn2: function (index, layero) {
|
},
|
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).toFixed(4)); //税额=金额*税率
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
var HTaxPrice = Number((HPrice * (1 + HTaxRate)).toFixed(4)); //含税单价=单价*(1+税率)
|
//数字精度
|
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.HNumber
|
, "物料名称": OptionData.HName
|
, "规格型号": OptionData.HModel
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.HUnitName
|
, "HTaxRate": HTaxRate * 100
|
, HQty: HQty //更新HQty字段，HQty
|
, HPrice: HPrice //更新HPrice字段，HPrice
|
, HMoney: HMoney //更新HMoney字段，HMoney
|
, HTaxMoney: HTaxMoney //更新HTaxMoney字段，HTaxMoney
|
, HlineTotal: HlineTotal //更新HlineTotal字段，HlineTotal
|
, HTaxPrice, HTaxPrice //更新HTaxPrice字段，HTaxPrice
|
})
|
}
|
});
|
} else if (typeof (OptionData.HItemID) != "undefined"){
|
obj.update({ //更新表格数据
|
"HMaterID": OptionData.HItemID //设置HItemID的值为“HBillNo”字段的值HItemID`的值
|
, "物料代码": OptionData.HNumber
|
, "物料名称": OptionData.HName
|
, "规格型号": OptionData.HModel
|
, "HUnitID": OptionData.HUnitID
|
, "计量单位": OptionData.HUnitName
|
})
|
}
|
}
|
});
|
});
|
|
});
|
|
table.on('edit(mainTable)', function (obj) { //注：edit是固定事件名，test是table原始容器的属性 lay-filter="对应的值"
|
var value = obj.value //得到修改后的值
|
, data = obj.data //得到所在行所有键值
|
, field = obj.field; //得到字段
|
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 ref = /^\d+(\.\d+)?$/; //非负数正则表达式
|
var temp = ""; //定义一个空字符串变量 temp
|
// 单元格编辑之前的值
|
var oldText = $(this).prev().text();
|
switch (field) {
|
case "HQty": //数量
|
//数据格式校验
|
temp = value + ""; //修改后的值 转为字符串 赋值给 变量temp
|
if (!ref.test(temp) || temp == 0) { //使用表达式来判断字符串是否为0 // 定义的正则表达式ref（用于匹配非负数的字符串表示，但注意它不会匹配单独的0作为有效输入，因为.\d+部分是可选的，且前面没有允许0作为整数部分的单独情况）来测试temp字符串
|
//恢复数据到编辑前
|
obj.update({ //使用obj.update方法更新表格中某一行的数据
|
HQty: oldText //将hqty字段恢复到保存单元格的值
|
});
|
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(); //汇率
|
//var HlineTotalBB = Number(((HMoney + HTaxMoney) * HExRate).toFixed(4)); //本位币价税合计=(税额+金额)*汇率
|
//数字精度
|
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 //更新HQty字段，其值来自变量HQty
|
, HPrice: HPrice //更新HPrice字段，其值来自变量HPrice
|
, HMoney: HMoney //更新HMoney字段，其值来自变量HMoney
|
, HTaxMoney: HTaxMoney //更新HTaxMoney字段，HTaxMoney
|
, HlineTotal: HlineTotal //更新HlineTotal字段，其值来自变量HlineTotal
|
/*, HlineTotalBB: HlineTotalBB //更新HlineTotalBB字段，其值来自变量HlineTotalBB*/
|
});
|
table.render(option)
|
break;
|
case "HPrice": //单价
|
//数据格式校验
|
temp = value + ""; //修改后的值 转为字符串 赋值给 变量temp
|
// ref很可能是一个正则表达式对象，用于匹配特定的字符串模式。ref.test(temp)会检查变量temp（即转换后的单价字符串）是否符合ref定义的模式。如果test方法返回false
|
if (!ref.test(temp)) { //检查单价字符串是否符合预期的格式
|
//恢复数据到编辑前
|
obj.update({ //更新表格某一行数据
|
HPrice: oldText //将hprice字段恢复到保存前的值
|
});
|
table.render(option);
|
layer.msg("单价请输入数字!"); //请输入单价的数值
|
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 HTaxPrice = Number((HPrice * (1 + HTaxRate)).toFixed(4)); //含税单价=单价*(1+税率)
|
//var HExRate = $("#HExRate").val(); //汇率
|
//var HlineTotalBB = Number(((HMoney + HTaxMoney) * HExRate).toFixed(4)); //本位币价税合计=(税额+金额)*汇率
|
//数字精度
|
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(HPrice.toFixed(HPriceDec));
|
//同步更新表格和缓存对应的值
|
obj.update({ //更新表格数据 方法是该对象提供的一个方法，用于更新其内部状态或与之关联的数据源
|
HQty: HQty //更新HQty字段，HQty
|
, HPrice: HPrice //更新HPrice字段，HPrice
|
, HMoney: HMoney //更新HMoney字段，HMoney
|
, HTaxMoney: HTaxMoney //更新HTaxMoney字段，HTaxMoney
|
, HlineTotal: HlineTotal //更新HlineTotal字段，HlineTotal
|
, HTaxPrice: HTaxPrice //更新HTaxPrice字段，HTaxPrice
|
/*, HlineTotalBB: HlineTotalBB //更新HlineTotalBB字段，其值来自变量HlineTotalBB*/
|
});
|
table.render(option)
|
break;
|
case "HTaxRate": //税率
|
//数据格式校验
|
temp = value + ""; //修改后的值 转为字符串 赋值给 变量temp
|
if (!ref.test(temp)) { //判断税率字符串是否符合预期格式
|
//恢复数据到编辑前
|
obj.update({ //更新表格某一行数据
|
HTaxRate: oldText // 将字段HTaxRate的数据恢复到更新之前的数据
|
});
|
table.render(option);
|
layer.msg("税率请输入数字!"); //提示请输入税率的数值
|
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 HTaxPrice = Number((HPrice * (1 + HTaxRate)).toFixed(4)); //含税单价=单价*(1+税率)
|
var HlineTotal = HMoney + HTaxMoney; //价税合计=金额+税额
|
//var HExRate = $("#HExRate").val(); //汇率
|
//var HlineTotalBB = Number(((HMoney + HTaxMoney) * HExRate).toFixed(4)); //本位币价税合计=(税额+金额)*汇率
|
//数字精度
|
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(HPrice.toFixed(HPriceDec));
|
//同步更新表格和缓存对应的值
|
obj.update({ //更新表格数据
|
HTaxRate: HTaxRate * 100
|
, HQty: HQty
|
, HPrice: HPrice
|
, HMoney: HMoney
|
, HTaxMoney: HTaxMoney
|
, HTaxPrice: HTaxPrice
|
, HlineTotal: HlineTotal
|
});
|
table.render(option)
|
break;
|
case "HTaxPrice": //含税单价
|
//数据格式校验
|
temp = value + ""; //修改后的值 转为字符串 赋值给 变量temp
|
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));
|
HMoney = Number(HMoney.toFixed(HMoneyDec));
|
HTaxMoney = Number(HTaxMoney.toFixed(HMoneyDec));
|
HlineTotal = Number(HlineTotal.toFixed(HMoneyDec));
|
HTaxPrice = Number(HPrice.toFixed(HPriceDec));
|
//同步更新表格和缓存对应的值
|
obj.update({ //更新表格数据 方法是该对象提供的一个方法，用于更新其内部状态或与之关联的数据源
|
HQty: HQty //更新HQty字段，HQty
|
, HPrice: HPrice //更新HPrice字段，HPrice
|
, HMoney: HMoney //更新HMoney字段，HMoney
|
, HTaxMoney: HTaxMoney //更新HTaxMoney字段，HTaxMoney
|
, HlineTotal: HlineTotal //更新HlineTotal字段，HlineTotal
|
, HTaxPrice:HTaxPrice //更新HTaxPrice字段，HTaxPrice
|
});
|
table.render(option)
|
break;
|
default:
|
}
|
});
|
|
//保存提交
|
form.on('submit(btnSave)', function (data) {//提交
|
var sSubStr = table.cache['mainTable'];
|
if (AllowLoadData(sSubStr)) {
|
set_AddNew(data);
|
}
|
});
|
|
//退出
|
form.on('submit(Cancel)', function (data) {
|
if (OperationType != "") {
|
Pub_Close(1);
|
}
|
});
|
|
//打印
|
form.on('submit(btn_print)', function (data) {
|
get_print(data);
|
});
|
|
//#region [表头放大镜]
|
//选择供应商弹窗
|
form.on('submit(btnSearchSup)', function () {
|
layer.open({
|
type: 2
|
, area: ['80%', '80%']
|
, title: '供应商列表'
|
, shade: 0.6 //遮罩透明度
|
//, maxmin: true //允许全屏最小化
|
, anim: 0 //0-6的动画形式，-1不开启
|
, content: ['../../基础资料/采购基础资料/Gy_Supplier.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('请选择数据');
|
}
|
$("#HSupName").val(checkStatus.data[0].供应商名称);
|
$("#HSupID").val(checkStatus.data[0].HItemID);
|
layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) {
|
//按钮【按钮二】的回调
|
//return false 开启该代码可禁止点击该按钮关闭
|
},
|
end: function () {
|
|
},
|
success: function (layero, index) {
|
|
}
|
})
|
});
|
|
//选择币别弹窗
|
form.on('submit(btnSearchCur)', function () {
|
layer.open({
|
type: 2
|
, area: ['80%', '80%']
|
, title: '币别列表'
|
, shade: 0.6 //遮罩透明度
|
//, maxmin: true //允许全屏最小化
|
, anim: 0 //0-6的动画形式，-1不开启
|
, 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);
|
layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
|
}
|
, btn2: function (index, layero) {
|
//按钮【按钮二】的回调
|
//return false 开启该代码可禁止点击该按钮关闭
|
},
|
end: function () {
|
|
},
|
success: function (layero, index) {
|
|
}
|
})
|
});
|
//#endregion
|
|
//#region 此页面所有的方法
|
// 初始化界面
|
function set_ClearBill() {
|
$("#HDate").val(Format(new Date(new Date()), "yyyy-MM-dd"));//日期
|
$("#HBeginDate").val(Format(new Date(new Date()), "yyyy-MM-dd"));//生效日期
|
$("#HEndDate").val(Format(new Date(new Date()), "yyyy-MM-dd"));//失效日期
|
//初始化表格
|
set_InitGrid();
|
}
|
|
//初始化表格
|
function set_InitGrid() {
|
//表头
|
columns = [ //表头
|
{ type: 'checkbox', totalRowText: '合计行' }
|
, { type: 'numbers', title: '序号', totalRow: true }
|
, { field: 'HMaterID', title: '物料ID', hide: true }
|
, { field: 'HMaterNumber', title: '物料代码', edit: 'text', event: "HMaterID", width: 165 }
|
, { field: 'HMaterName', title: '物料名称', width: 220 }
|
, { field: 'HMaterModel', title: '规格型号', width: 165 }
|
, { field: 'HUnitID', title: '单位ID', hide: true }
|
, { field: 'HUnitNumber', title: '单位代码', edit: 'text', event: "HUnitID", width: 165 }
|
, { field: 'HUnitName', title: '单位名称', width: 165 }
|
, { field: 'HQty', title: '数量', edit: 'text', event: 'inputHQty', width: 90, totalRow: true }
|
, { field: 'HPrice', title: '单价', edit: 'text', event: 'inputHPrice', width:90 }
|
, { field: 'HMoney', title: '金额', event: 'inputHMoney', width: 90, totalRow: true }
|
, { field: 'HTaxPrice', title: '含税单价', edit: 'text', event: 'inputHTaxPrice', width:90 }
|
, { field: 'HTaxRate', title: '税率%', edit: 'text', event: 'inputHTaxRate', width:90 }
|
, { field: 'HTaxMoney', title: '税额', edit: 'text', event: 'inputHTaxMoney', width:90 }
|
, { field: 'HlineTotal', title: '价税合计', edit: 'text', event: 'inputHlineTotal', width:90 }
|
, { field: 'HlineTotalBB', title: '本位币价税合计', edit: 'text', event: 'inputHlineTotalBB', width:125 }
|
, { field: 'HDate', title: '预计交货日期', width: 120, templet: "<div>{{d.HDate ==null ?'':layui.util.toDateString(d.HDate, 'yyyy-MM-dd')}}</div>", event: 'HDate' }
|
, { field: 'HBagType', title: '包装方式', edit: 'text', width: 120 }
|
, { field: 'HCarryType', title: '运输方式', edit: 'text', width: 120 }
|
, { field: 'HAddress', title: '交货地点', edit: 'text', width: 120 }
|
, { field: 'HRemark', title: '备注', edit: 'text' }
|
, { fixed: 'right', title: '操作', toolbar: '#barDemo', width: 65 }
|
];
|
option = {
|
id: 'mainTable'
|
, elem: '#mainTable'
|
, toolbar: '#toolbarDemo'
|
, page: false
|
, totalRow: true
|
, cellMinWidth: 120
|
, height: 400
|
, cols: [columns]
|
, limit: Number.MAX_VALUE//默认显示全部
|
, done: function (res, curr, count) {
|
option.data = res.data;
|
//去掉下拉框失焦事件否则在下拉框里输入值
|
$('.layui-form-select').find('input').unbind("blur");
|
//表格重载回显下拉框里的数据
|
$('tr').each(function (e) {
|
var $cr = $(this);
|
var dataIndex = $cr.attr("data-index");
|
});
|
}
|
, done: function (res, curr, count) {
|
|
}
|
};
|
option.data = [{
|
"HMaterID": 0, "HMaterNumber": "", "HMaterName": "", "HMaterModel": "", "HUnitID": 0, "HUnitNumber": "",
|
"HUnitName": "", "HQty": 0, "HPrice": 0, "HMoney": 0, "HTaxPrice": 0, "HTaxRate": 0, "HTaxMoney": 0,
|
"HlineTotal": 0, "HlineTotalBB": 0, "HDate": new Date(), "HBagType": "", "HCarryType": "", "HAddress": "", "HRemark": ""
|
}];
|
table.render(option);
|
|
}
|
|
|
//非空验证
|
function AllowLoadData(sSubStr) {
|
//删除子表数据时 会占用数组的位置,需要重新排一下顺序
|
var sSubTable = [];
|
for (var i = 0; i < sSubStr.length; i++) {
|
if (sSubStr[i] != "") {
|
sSubStr[i].LAY_TABLE_INDEX = i;
|
sSubTable.push(sSubStr[i])
|
}
|
}
|
|
var Result = true;
|
|
for (var i = 0; i < sSubTable.length; i++) {
|
if (sSubTable[i].HMaterID == 0) {
|
layer.msg("明细记录第" + (i + 1) + "行,物料信息不能为空!", { icon: 5, btn: ['确认'], time: 5000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
return Result = false;
|
}
|
if (sSubTable[i].HUnitID == 0) {
|
layer.msg("明细记录第" + (i + 1) + "行,计量单位信息不能为空!", { icon: 5, btn: ['确认'], time: 5000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
return Result = false;
|
}
|
}
|
|
return Result
|
}
|
|
//保存HMaker
|
function set_AddNew(data) {
|
var num_1 = [];
|
for (var i = 0; i < table.cache["mainTable"].length; i++) {
|
if (table.cache["mainTable"][i] != "") {
|
table.cache["mainTable"][i].LAY_TABLE_INDEX = i;
|
num_1.push(table.cache["mainTable"][i])
|
}
|
}
|
var sMainStr = JSON.stringify(data.field);
|
var sSubStr = JSON.stringify(num_1);
|
var sMainSub = sMainStr + ';' + sSubStr + ';' + OperationType + ";" + sessionStorage["HUserName"];
|
var index = layer.load();
|
$.ajax({
|
type: "POST",
|
url: GetWEBURL() + "/Sup_QuotePriceBill/SaveQuotePriceBill",
|
async: true,
|
data: { "msg": sMainSub },
|
dataType: "json",
|
success: function (data) {
|
if (data.count == 1) {
|
$('#btnSave').addClass("layui-btn-disabled").attr("disabled", true);
|
layer.close(index);
|
layer.msg("提交成功");
|
}
|
else {
|
layer.close(index);
|
layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
}
|
},
|
error: function (err) {
|
layer.close(index);
|
layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
|
}
|
});
|
}
|
|
//#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
|
|
//编辑 页面赋值
|
function RoadBillMain(linterid)//加载表头
|
{
|
var sWhere = " and hmainid=" + linterid;
|
$.ajax({
|
url: GetWEBURL() + "/Sup_QuotePriceBill/Sup_QuotePriceBillList",
|
type: "GET",
|
async: false,
|
data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
|
success: function (result) {
|
if (result.count == 1) {
|
var data = result.data;
|
//主表
|
$("#HBillNo").val(data[0]["单据号"]);
|
$("#HInterID").val(data[0]["hmainid"]);
|
$("#HSupName").val(data[0]["供应商名称"]);
|
$("#HSupID").val(data[0]["HSupID"]);
|
$("#HQuoteEmp").val(data[0]["报价人"]);
|
$("#HQuoteDept").val(data[0]["报价部门"]);
|
$("#HCurName").val(data[0]["币别"]);
|
$("#HCurID").val(data[0]["HCurID"]);
|
$("#HPayConditionID").val(data[0]["HPayConditionID"]);
|
$("#HBeginDate").val(Format(new Date(data[0]["生效日期"]), "yyyy-MM-dd"));
|
$("#HEndDate").val(Format(new Date(data[0]["失效日期"]), "yyyy-MM-dd"));
|
$("#HExplanation").val(data[0]["摘要"]);
|
$("#HRemark").val(data[0]["表头备注"]);
|
|
var rowdata = [];
|
for (var i = 0; i < result.data.length; i++) {
|
//子表 赋值
|
rowdata.push({
|
"HMaterID": data[i]["HMaterID"], "HMaterNumber": data[i]["物料代码"], "HMaterName": data[i]["物料名称"], "HMaterModel": data[i]["规格型号"], "HUnitID": data[i]["HUnitID"], "HUnitNumber": data[i]["单位代码"],
|
"HUnitName": data[i]["单位"], "HQty": data[i]["数量"], "HPrice": data[i]["单价"], "HMoney": data[i]["金额"], "HTaxPrice": data[i]["含税单价"], "HTaxRate": data[i]["税率"], "HTaxMoney": data[i]["税额"], "HlineTotal": data[i]["价税合计"], "HlineTotalBB": data[i]["本位币价税合计"], "HDate": data[i]["预计交货日期"], "HBagType": data[i]["包装方式"], "HCarryType": data[i]["运输方式"], "HAddress": data[i]["交货地点"], "HRemark": data[i]["表体备注"]
|
});
|
}
|
option.data = rowdata;
|
table.render(option);
|
form.render('select');
|
} else {
|
layer.msg(result.code + result.Message, { icon: 5 });
|
}
|
}
|
})
|
}
|
|
//打印
|
function get_print(data) {
|
|
}
|
|
function get_UrlVars() {
|
var vars = [], hash;
|
var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
|
for (var i = 0; i < hashes.length; i++) {
|
hash = hashes[i].split('=');
|
vars.push(hash[0]);
|
vars[hash[0]] = hash[1];
|
}
|
return vars;
|
}
|
|
//#endregion
|
})
|
</script>
|
