From 82ba14eeb57b4e7ccc652afb0e700a89ce4e64f6 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期二, 25 二月 2025 11:21:39 +0800
Subject: [PATCH] 增加斯莫尔 性能检测散点图报表，修改送测登记数据台账报表
---
WebTM/views/系统管理/用户管理/Gy_UserCustomer.html | 411 ++++++++++++++++++++++++++++++++++-----------------------
1 files changed, 244 insertions(+), 167 deletions(-)
diff --git "a/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Gy_UserCustomer.html" "b/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Gy_UserCustomer.html"
index 90cd4b1..8632435 100644
--- "a/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Gy_UserCustomer.html"
+++ "b/WebTM/views/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Gy_UserCustomer.html"
@@ -43,6 +43,7 @@
<div class="layui-card-header">
<div class="layui-btn-group">
<button type="button" id="add-btn" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Saver">淇濆瓨</button>
+ <button type="button" id="set_Excel" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_Excel">Excel瀵煎叆</button>
<button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Exit">閫�鍑�</button>
</div>
</div>
@@ -138,13 +139,12 @@
TabRow = { "HCusID": 0, "HCustomerNumber": "", "HCustomerName": "" };
//#endregion
-
//#region 杩涘叆椤甸潰鏃㈠姞杞�
-
- //鍒濆鍖栬〃鏍�
+ //#region 鍒濆鍖栬〃鏍�
set_InitGrid();
+ //#endregion
- //鍒ゆ柇鎿嶄綔绫诲瀷
+ //#region 鍒ゆ柇鎿嶄綔绫诲瀷
if (OperationType == 1) {//鏃犳簮鏂板
//鏃犳簮鏂板
set_AddFNew();
@@ -156,29 +156,118 @@
layer.alert("鏈煡鎿嶄綔绫诲瀷锛�", { icon: 5 });
}
//#endregion
-
+ //#endregion
//#region 鐐瑰嚮浜嬩欢锛屽寘鎷琽n鍜宖orm浜嬩欢
- //澶村伐鍏锋爮
- table.on('toolbar(mainTable)', function (obj) {
- var checkStatus = table.checkStatus('mainTable')
- , data = checkStatus.data;;
- var AddRow = table.cache['mainTable'];
- var NewRow = TabRow;
- switch (obj.event) {
- //鏂板涓�琛�
- case 'btn-AddLine': btnAddLine(NewRow);
- break;
- //澶嶅埗涓�琛�
- case 'btn-CopyLine': btnCopyLine(data);
- break;
+ //#region 涓昏〃鎸夐挳瑙﹀彂浜嬩欢
+ //#region 淇濆瓨
+ form.on('submit(Saver)', function (data) {
+ if ($("#UserName").val() == "") {
+ layer.msg("鐢ㄦ埛涓嶈兘涓虹┖锛�");
+ return false;
+ }
+ var UserID = $("#UserID").val(); //鑾峰彇閫夋嫨鐨勭敤鎴风紪鐮�
+ //debugger;
+ var sSubStr = JSON.stringify(table.cache['mainTable']);
+ if (!AllowLoadData(sSubStr))//鏁版嵁楠岃瘉
+ {
+ return false;
+ }
+ var list = [];
+ for (var i = 0; i < JSON.parse(sSubStr).length; i++) {
+ list.push(JSON.parse(sSubStr)[i].HCustomerNumber)
+ }
+ if (isAllEqual(list)) {
+ //layer.msg("鏈夐噸澶嶇殑瀹㈡埛淇℃伅锛�");
+ return false;
+ }
+
+ var sMainSub = sSubStr + ';' + UserID + ';' + sessionStorage["HUserName"];
+ $.ajax(
+ {
+ type: "POST",
+ url: GetWEBURL() + "/Xt_User/SaveUserCustomer", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚�
+ async: true,
+ data: { "msg": sMainSub },
+ dataType: "json",
+ success: function (data) {
+ if (data.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+ layer.msg(data.Message, { time: 1 * 1000, icon: 1 }, function () {
+ $('#add-btn').addClass("layui-btn-disabled").attr("disabled", true);
+ var index = parent.layer.getFrameIndex(window.name); //鍏堝緱鍒板綋鍓峣frame灞傜殑绱㈠紩
+ parent.layer.close(index); //鍐嶆墽琛屽叧闂� 聽 聽 聽 聽 聽聽 聽聽聽 聽
+ });
+ }
+ else {
+
+ layer.alert(data.Message);
+ console.log("Reason" + sMainSub + "sub:" + JSON.stringify(layui.table.cache.mainTable));
+ }
+ layer.closeAll("loading");
+ },
+ error: function (err) {
+
+ layer.alert("閿欒:" + err);
+ console.log("Reason" + sMainStr);
+ }
+ });
+ });
+ //#endregion
+
+ //#region 鐐瑰嚮琛岄�変腑楂樹寒
+ table.on('row(mainTable)', function (obj) {
+ //閫変腑琛屾敼鍙橀鑹�
+ var flag = !obj.tr.find(':checkbox:first').prop('checked');
+ obj.tr.find(':checkbox').prop('checked', flag);
+ if (flag) {
+ obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //璁剧疆澶嶉�夋閫変腑鏍峰紡
+ $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//鏀瑰彉褰撳墠tr鑳屾櫙棰滆壊鍜屽瓧浣撻鑹�
+ } else {
+ obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//鍙栨秷澶嶉�夋閫変腑鏍峰紡
+ $(obj.tr.selector).attr({ "style": "background:" });//鍙栨秷褰撳墠tr棰滆壊
+ }
+ //mainTable 涓鸿〃鏍糏D 娉ㄦ剰姝ゅ濡傛灉ID涓嶆纭皢瀵艰嚧浣犲湪鐩戝惉澶嶉�夋鏃惰幏鍙栦笉鍒颁綘閫夋嫨鐨勬暟鎹紝鍓嶉潰鐨勫彧鏄坊鍔犳垨鍒犻櫎閫変腑鏈�変腑鏍峰紡浠ュ強璁剧疆鑳屾櫙鑹诧紝瀛椾綋棰滆壊
+ layui.each(table.cache.mainTable, function (i, l) {
+ if (obj.tr.index() == l.LAY_TABLE_INDEX) {
+ l.LAY_CHECKED = flag;
+ }
+ });
+ })
+
+ //#region excel瀵煎叆
+ form.on('submit(set_Excel)', function (data) {
+ set_Excel();
+ });
+ //#endregion
+
+ //#region 閫�鍑�
+ form.on('submit(Exit)', function (data) {
+ if (OperationType == 1) {
+ Pub_Close(closeType);//鐩存帴鏂板closeType鍊间负2锛屽垪琛ㄨ皟鏂板closeType鍊间粠鍒楄〃浼犻��
+ }
+ else if (OperationType == 3) {
+ Pub_Close(closeType);
+ }
+ else {
+ Pub_Close(2);
}
});
- //琛屽唴浜嬩欢
- table.on('tool(mainTable)', function (obj) {
- set_GridDelete(obj); //琛屽唴鍒犻櫎
- set_GridCellCheck(obj); //琛屽唴蹇嵎閿瓫閫�
+ //#endregion
+
+ //#region 蹇�熻繃婊�
+ form.on('submit(Search)', function () {
+ get_FastQuery();
});
- //鐢ㄦ埛淇℃伅寮圭獥
+ //#endregion
+
+ //#region 閲嶇疆杩囨护鏉′欢
+ form.on('submit(ReSet)', function () {
+ set_ClearQuery();
+ });
+ //#endregion
+ //#endregion
+
+ //#region 寮圭獥瑙﹀彂浜嬩欢
+ //#region 鐢ㄦ埛淇℃伅寮圭獥
form.on('submit(UserList)', function () {
//椤甸潰灞�-鑷畾涔�
layer.open({
@@ -233,8 +322,35 @@
}
});
});
+ //#endregion
+ //#endregion
- //琛ㄦ牸琛屽唴浜嬩欢蹇嵎閿瓫閫�
+ //#region 瀛愯〃瑙﹀彂浜嬩欢
+ //#region 澶村伐鍏锋爮
+ table.on('toolbar(mainTable)', function (obj) {
+ var checkStatus = table.checkStatus('mainTable')
+ , data = checkStatus.data;;
+ var AddRow = table.cache['mainTable'];
+ var NewRow = TabRow;
+ switch (obj.event) {
+ //鏂板涓�琛�
+ case 'btn-AddLine': btnAddLine(NewRow);
+ break;
+ //澶嶅埗涓�琛�
+ case 'btn-CopyLine': btnCopyLine(data);
+ break;
+ }
+ });
+ //#endregion
+
+ //#region 琛屽唴浜嬩欢
+ table.on('tool(mainTable)', function (obj) {
+ set_GridDelete(obj); //琛屽唴鍒犻櫎
+ set_GridCellCheck(obj); //琛屽唴蹇嵎閿瓫閫�
+ });
+ //#endregion
+
+ //#region 琛ㄦ牸琛屽唴浜嬩欢蹇嵎閿瓫閫�
function set_GridCellCheck(obj) {
$(document).off('keydown', ".layui-table-edit").on('keydown', '.layui-table-edit', function (e) {
if (event.key == "F7") {
@@ -257,32 +373,32 @@
//鎸夐挳銆愭寜閽竴銆戠殑鍥炶皟
var iframeWindow = window['layui-layer-iframe' + index] //鑾峰彇寮规椤甸潰
var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//鑾峰彇table鐨別lem:"#test"
- if (checkStatus.data.length === 0) {
- return layer.msg('璇烽�夋嫨鏁版嵁');
+ if (checkStatus.data.length != 1) {
+ return layer.msg('璇烽�夋嫨涓�琛屾暟鎹�');
}
//console.log(obj.data);
//鍚屾鏇存柊琛ㄦ牸鍜岀紦瀛樺搴旂殑鍊�
- //obj.update({
- // HCusID: checkStatus.data[0].HItemID,
- // HCustomerNumber: checkStatus.data[0].HNumber,
- // HCustomerName: checkStatus.data[0].HName
- //});
+ obj.update({
+ HCusID: checkStatus.data[0].HItemID,
+ HCustomerNumber: checkStatus.data[0].HNumber,
+ HCustomerName: checkStatus.data[0].HName
+ });
- 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 = { "HCusID": 0, "HCustomerNumber": "", "HCustomerName": "" };
- table.cache["mainTable"].push(NewRow);
- option.data = table.cache["mainTable"];
- table.render(option);
- }
+ //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 = { "HCusID": 0, "HCustomerNumber": "", "HCustomerName": "" };
+ // table.cache["mainTable"].push(NewRow);
+ // option.data = table.cache["mainTable"];
+ // table.render(option);
+ // }
- option.data[rowIndex + i].HCusID = checkStatus.data[i].HItemID;
- option.data[rowIndex + i].HCustomerNumber = checkStatus.data[i].HNumber;
- option.data[rowIndex + i].HCustomerName = checkStatus.data[i].HName;
- }
- table.render(option);
+ // option.data[rowIndex + i].HCusID = checkStatus.data[i].HItemID;
+ // option.data[rowIndex + i].HCustomerNumber = checkStatus.data[i].HNumber;
+ // option.data[rowIndex + i].HCustomerName = checkStatus.data[i].HName;
+ //}
+ //table.render(option);
@@ -303,83 +419,8 @@
}
})
}
-
- //淇濆瓨
- form.on('submit(Saver)', function (data) {
- if ($("#UserName").val() == "") {
- layer.msg("鐢ㄦ埛涓嶈兘涓虹┖锛�");
- return false;
- }
- var UserID = $("#UserID").val(); //鑾峰彇閫夋嫨鐨勭敤鎴风紪鐮�
- //debugger;
- var sSubStr = JSON.stringify(table.cache['mainTable']);
- if (!AllowLoadData(sSubStr))//鏁版嵁楠岃瘉
- {
- return false;
- }
- var list = [];
- for (var i = 0; i < JSON.parse(sSubStr).length; i++) {
- list.push(JSON.parse(sSubStr)[i].HCustomerNumber)
- }
- if (isAllEqual(list)) {
- layer.msg("鏈夐噸澶嶇殑瀹㈡埛淇℃伅锛�");
- return false;
- }
-
- var sMainSub = sSubStr + ';' + UserID + ';' + sessionStorage["HUserName"];
- $.ajax(
- {
- type: "POST",
- url: GetWEBURL() + "/Xt_User/SaveUserCustomer", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚�
- async: true,
- data: { "msg": sMainSub },
- dataType: "json",
- success: function (data) {
- if (data.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
- layer.msg(data.Message, { time: 1 * 1000, icon: 1 }, function () {
- $('#add-btn').addClass("layui-btn-disabled").attr("disabled", true);
- var index = parent.layer.getFrameIndex(window.name); //鍏堝緱鍒板綋鍓峣frame灞傜殑绱㈠紩
- parent.layer.close(index); //鍐嶆墽琛屽叧闂� 聽 聽 聽 聽 聽聽 聽聽聽 聽
- });
- }
- else {
-
- layer.alert(data.Message);
- console.log("Reason" + sMainSub + "sub:" + JSON.stringify(layui.table.cache.mainTable));
- }
- layer.closeAll("loading");
- },
- error: function (err) {
-
- layer.alert("閿欒:" + err);
- console.log("Reason" + sMainStr);
- }
- });
- });
-
- //閫�鍑�
- form.on('submit(Exit)', function (data) {
- if (OperationType == 1) {
- Pub_Close(closeType);//鐩存帴鏂板closeType鍊间负2锛屽垪琛ㄨ皟鏂板closeType鍊间粠鍒楄〃浼犻��
- }
- else if (OperationType == 3) {
- Pub_Close(closeType);
- }
- else {
- Pub_Close(2);
- }
- });
-
- //蹇�熻繃婊�
- form.on('submit(Search)', function () {
- get_FastQuery();
- });
-
- //閲嶇疆杩囨护鏉′欢
- form.on('submit(ReSet)', function () {
- set_ClearQuery();
- });
-
+ //#endregion
+ //#endregion
//#endregion
//#region 姝ら〉闈㈡墍鏈夋柟娉�
@@ -408,7 +449,12 @@
table.reload('mainTable', { data: [] });
layer.alert(data.Message);
}
-
+ if (HCusNumber == "" && HCusName == "") {
+ $('#add-btn').removeClass("layui-btn-disabled");
+ } else {
+ $('#add-btn').removeClass("layui-btn-disabled");
+ $('#add-btn').addClass("layui-btn-disabled").attr("disabled", true);
+ }
}
});
}
@@ -421,7 +467,23 @@
}
//#endregion
- //鍒濆鍖栬〃鏍�
+ //#region Excel瀵煎叆
+ function set_Excel() {
+ layer.open({
+ type: 2
+ , skin: 'layui-layer-rim' //鍔犱笂杈规
+ , area: ['100%', '100%']
+ , title: '鐢ㄦ埛鍏宠仈瀹㈡埛-瀵煎叆'
+ , shift: 0//寮瑰嚭鍔ㄧ敾
+ , content: '../../绯荤粺绠＄悊/鐢ㄦ埛绠＄悊/Gy_UserCustomer_ImportByExcel.html'
+ , end: function () {
+ //鍒锋柊椤甸潰,
+ }
+ })
+ }
+ //#endregion
+
+ //#region 鍒濆鍖栬〃鏍�
function set_InitGrid() {
columns = [
{ type: 'checkbox', fixed: 'left' }
@@ -444,64 +506,27 @@
}
};
}
- //鏃犳簮鍗曟柊澧�
+ //#endregion
+
+ //#region 鏃犳簮鍗曟柊澧�
function set_AddFNew() {
option.data = [TabRow];
table.render(option);
}
+ //#endregion
- //澧炲姞涓�琛�
- function btnAddLine(NewRow) {
- var tableBak = table.cache["mainTable"]; //鑾峰彇涔嬪墠缂栬緫杩囩殑琛ㄦ牸鏁版嵁
-
- buttonArr = [];//娓呯┖鏁扮粍
- for (var i = 0; i < tableBak.length; i++) {
- buttonArr.push(tableBak[i]); //灏嗕箣鍓嶇殑鏁版嵁瀛樺偍
- }
- buttonArr.push(NewRow); //鍦ㄥ熬閮ㄥ姞涓�琛�
- table.reload("mainTable", {
- data: buttonArr //灏嗘暟鎹噸鏂拌浇鍏ヨ〃鏍�
- })
- }
- //澶嶅埗涓�琛�
- function btnCopyLine(data) {
- 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);//灏嗘暟鎹覆鏌撳埌琛ㄦ牸涓�
- }
- }
- // 琛ㄦ牸琛屽唴浜嬩欢鍒犻櫎
- function set_GridDelete(obj) {
- var data = obj.data;
- var rowIndex = $(obj.tr).attr("data-index");
- if (obj.event === 'del') {
- layer.confirm('鐪熺殑鍒犻櫎琛屼箞', function (index) {
- var oldData = table.cache["mainTable"];
- oldData.splice(obj.tr.data('index'), 1);
- table.reload('mainTable', { data: oldData });
- layer.close(index);
- });
- }
- }
//#region 鍒ゆ柇鏁版嵁鏁扮粍涓殑鍊兼槸鍚︾浉鍚�
function isAllEqual(list) {
var s = list.join(",") + ",";
for (var i = 0; i < list.length; i++) {
if (s.replace(list[i] + ",", "").indexOf(list[i] + ",") > -1) {
+ layer.msg("绗�" + (i+1) + "琛岋細鏁版嵁閲嶅");
return true;
}
}
}
+ //#endregion
+
//#region 闈炵┖楠岃瘉
function AllowLoadData(sSubStr) { //闈炵┖楠岃瘉
var Result = true;
@@ -523,6 +548,58 @@
}
return Result;
}
+ //#endregion
+
+ //#region 澧炲姞涓�琛�
+ function btnAddLine(NewRow) {
+ var tableBak = table.cache["mainTable"]; //鑾峰彇涔嬪墠缂栬緫杩囩殑琛ㄦ牸鏁版嵁
+
+ buttonArr = [];//娓呯┖鏁扮粍
+ for (var i = 0; i < tableBak.length; i++) {
+ buttonArr.push(tableBak[i]); //灏嗕箣鍓嶇殑鏁版嵁瀛樺偍
+ }
+ buttonArr.push(NewRow); //鍦ㄥ熬閮ㄥ姞涓�琛�
+ table.reload("mainTable", {
+ data: buttonArr //灏嗘暟鎹噸鏂拌浇鍏ヨ〃鏍�
+ })
+ }
+ //#endregion
+
+ //#region 澶嶅埗涓�琛�
+ function btnCopyLine(data) {
+ 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);//灏嗘暟鎹覆鏌撳埌琛ㄦ牸涓�
+ }
+ }
+ //#endregion
+
+ //#region 琛ㄦ牸琛屽唴浜嬩欢鍒犻櫎
+ function set_GridDelete(obj) {
+ var data = obj.data;
+ var rowIndex = $(obj.tr).attr("data-index");
+ if (obj.event === 'del') {
+ layer.confirm('鐪熺殑鍒犻櫎琛屼箞', function (index) {
+ var oldData = table.cache["mainTable"];
+ oldData.splice(obj.tr.data('index'), 1);
+ table.reload('mainTable', { data: oldData });
+ layer.close(index);
+ });
+ }
+ }
+ //#endregion
+ //#endregion
+
});
</script>
--
Gitblit v1.9.1