From 81c6759dcee2dad7b63efdc87f660d4550d1572d Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期四, 30 十月 2025 09:49:58 +0800
Subject: [PATCH] excel导入送货物料信息
---
WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialHanding.html | 99 +++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 82 insertions(+), 17 deletions(-)
diff --git a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialHanding.html b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialHanding.html
index 4fa98d6..332f65c 100644
--- a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialHanding.html
+++ b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_MaterialHanding.html
@@ -95,6 +95,7 @@
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-logout"></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_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_MaterPackQtyExcel" id="btn_MaterPackQtyExcel"><i class="layui-icon layui-icon-file-b"></i>Excel瀵煎叆</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button>
</div>
</script>
@@ -163,6 +164,9 @@
case 'set_HideColumn':
get_HideColumn();
break;
+ //瀵煎叆
+ case 'btn_MaterPackQtyExcel': set_MaterPackQtyExcel();
+ break;
};
});
@@ -193,6 +197,9 @@
// 鏌ヨ
function get_Display(sWhere) {
var ajaxLoad = layer.load();
+ if (sessionStorage["HSupIDs"].length < 1000) {
+ sWhere += " and HSupID in (" + sessionStorage["HSupIDs"] + ")";
+ }
$.ajax({
url: GetWEBURL() + '/MaterialHandingController/GetMaterialHandingList',
type: "GET",
@@ -293,13 +300,13 @@
if (HMaterNumber) {
- sWhere += " and 鐗╂枡浠ｇ爜 = '" + HMaterNumber + "'";
+ sWhere += " and 鐗╂枡浠ｇ爜 like '%" + HMaterNumber + "%'";
}
if (HMaterName) {
- sWhere += " and 鐗╂枡鍚嶇О = '" + HMaterName + "'";
+ sWhere += " and 鐗╂枡鍚嶇О like '%" + HMaterName + "%'";
}
if (HModel) {
- sWhere += " and 瑙勬牸鍨嬪彿 = '" + HModel + "'";
+ sWhere += " and 瑙勬牸鍨嬪彿 like '%" + HModel + "%'";
}
if (IsUse!=0) {
sWhere += " and 鏄惁鍚敤 = '" + IsUse + "'";
@@ -415,6 +422,17 @@
function get_Refresh() {
set_ClearQuery();
get_Display(sWhere);
+ }
+
+ //瀵煎叆
+ function set_MaterPackQtyExcel() {
+ layer.open({
+ type: 2
+ , area: ['100%', '100%']
+ , title: '閫佽揣鐗╂枡淇℃伅瀵煎叆'
+ , shift: 0//寮瑰嚭鍔ㄧ敾
+ , content: './SRM_SupMaterPackBill_Excel.html?OperationType=dao&HSouceBillType='
+ })
}
function Format(datetime, fmt) {
@@ -619,27 +637,42 @@
, data = checkStatus.data;
if (checkStatus.data.length === 1) {
var InterID = data[0].HItemID.toString();
- //閫昏緫瀹℃牳鏂规硶
+ var HMaterID = data[0].鐗╂枡ID.toString();
+ var FirstID = sessionStorage["HSupIDs"];
+ var HSupID = FirstID.split(",")[0];
+ /* var HSupID = "672189";*/
+
+ // 鍏堟鏌ユ槸鍚﹀瓨鍦ㄥ鏉¤褰�
$.ajax({
type: "GET",
- url: GetWEBURL() + "/MaterialHandingController/OpenMaterial", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚�
- data: { "HInterID": InterID, "IsUse": num, "CurUserName": sessionStorage["HUserName"] },
+ url: GetWEBURL() + "/MaterialHandingController/CheckMaterialCount",
+ data: {
+ "HMaterID": HMaterID,
+ "HSupID": HSupID,
+ "HInterID": InterID
+ },
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
+ if (result.count > 0) {
+ // 瀛樺湪澶氭潯璁板綍锛屽脊鍑虹‘璁ゆ
+ layer.confirm('鍚屼竴渚涘簲鍟嗕笅鐨勮鐗╂枡瀛樺湪澶氭潯璁板綍锛屾槸鍚﹀皢鍏朵綑璁板綍璁剧疆涓烘湭鍚敤锛�', {
+ btn: ['纭畾', '鍙栨秷'],
+ title: "鍚敤纭"
+ }, function (index) {
+ //浼�1锛屼娇鐢╱pdate
layer.close(index);
- //淇敼涓哄姛鍚庡埛鏂扮晫闈�
- $("#btnSearch").trigger('click');
+ callForEnable(InterID, HMaterID, HSupID, 1, num);
+ }, function (index) {
+ //浼�0锛岀洿鎺ュ惎鐢�
+ layer.close(index);
+ //callForEnable(InterID, HMaterID, HSupID, 0, num);
});
-
} else {
- layer.alert(result.code + result.Message, { icon: 5 });
+ // 娌℃湁澶氭潯璁板綍锛岀洿鎺ュ惎鐢�
+ callForEnable(InterID, HMaterID, HSupID, 0, num);
}
- }, error: function () {
- layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ },
+ error: function () {
+ layer.alert("妫�鏌ヨ褰曟暟閲忓け璐�!", { icon: 5 });
}
});
}
@@ -648,7 +681,39 @@
}
}
+ function callForEnable(InterID, HMaterID, HSupID, disableOthers, num) {
+ $.ajax({
+ type: "GET",
+ url: GetWEBURL() + "/MaterialHandingController/OpenMaterial",
+ data: {
+ "HInterID": InterID,
+ "IsUse": num,
+ "CurUserName": sessionStorage["HUserName"],
+ "HMaterID": HMaterID,
+ "HSupID": HSupID,
+ "disableOthers": disableOthers
+ },
+ 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);
+ // 淇敼鎴愬姛鍚庡埛鏂扮晫闈�
+ $("#btnSearch").trigger('click');
+ });
+ } else {
+ layer.alert(result.Message, { icon: 5 });
+ }
+ },
+ error: function () {
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ });
+ }
//#endregion
+
function get_createBarCode() {
var checkStatus = table.checkStatus('mainTable')
--
Gitblit v1.9.1