From e6c63d0a1cef8ae364e220b2b6128b8bbda44aa9 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期六, 14 九月 2024 15:56:59 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-LayUI

---
 WebTM/WebTM.csproj.user                         |    2 
 WebTM/views/车间管理/工序出站汇报单/Cj_StationOutBill.html |   18 +-
 WebTM/views/基础资料/工资基础资料/Gy_Group.html           |   13 ++
 WebTM/views/计划管理/Excel/Gy_Group_Excel.html      |  234 +++++++++++++++++++++++++++++++++++++++
 WebTM/views/生产管理/生产任务单/Sc_ICMOBillList.html     |   33 ++++-
 WebTM/WebTM.csproj                              |    1 
 6 files changed, 283 insertions(+), 18 deletions(-)

diff --git a/WebTM/WebTM.csproj b/WebTM/WebTM.csproj
index 7bd2a62..c6d253b 100644
--- a/WebTM/WebTM.csproj
+++ b/WebTM/WebTM.csproj
@@ -437,6 +437,7 @@
     <Content Include="views\绯荤粺绠$悊\鐢ㄦ埛绠$悊\Gy_UserDeptList.html" />
     <Content Include="views\绯荤粺绠$悊\澶氱骇瀹℃壒\瀹℃壒杩涘害\Xt_CheckFlowProgressList.html" />
     <Content Include="views\绯荤粺绠$悊\鐢ㄦ埛绠$悊\Xt_UserRightQuery.html" />
+    <Content Include="views\璁″垝绠$悊\Excel\Gy_Group_Excel.html" />
     <Content Include="views\璁″垝绠$悊\宸ヨ壓璺嚎\Pay_ProcPriceTypeChangeReport.html" />
     <Content Include="views\璁惧绠$悊\Sb_Add_EquipRepairSignBillList.html" />
     <Content Include="views\璁惧绠$悊\Sb_EquipRepairSignBillList_PDA.html" />
diff --git a/WebTM/WebTM.csproj.user b/WebTM/WebTM.csproj.user
index e39639b..9f5f7b5 100644
--- a/WebTM/WebTM.csproj.user
+++ b/WebTM/WebTM.csproj.user
@@ -1,7 +1,7 @@
 锘�<?xml version="1.0" encoding="utf-8"?>
 <Project ToolsVersion="12.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
   <PropertyGroup>
-    <NameOfLastUsedPublishProfile>D:\鏅轰簯杩堟�漒MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
+    <NameOfLastUsedPublishProfile>D:\vs\椤圭洰浠g爜\MES-WEB-TM\MESWMS-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
     <ProjectView>ProjectFiles</ProjectView>
     <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig>
     <UseIISExpress>true</UseIISExpress>
diff --git "a/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\345\267\245\350\265\204\345\237\272\347\241\200\350\265\204\346\226\231/Gy_Group.html" "b/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\345\267\245\350\265\204\345\237\272\347\241\200\350\265\204\346\226\231/Gy_Group.html"
index 2b64daf..eedff85 100644
--- "a/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\345\267\245\350\265\204\345\237\272\347\241\200\350\265\204\346\226\231/Gy_Group.html"
+++ "b/WebTM/views/\345\237\272\347\241\200\350\265\204\346\226\231/\345\267\245\350\265\204\345\237\272\347\241\200\350\265\204\346\226\231/Gy_Group.html"
@@ -151,6 +151,7 @@
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew"><i class="layui-icon layui-icon-file-b"></i>鏂板</button>
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>缂栬緫</button>
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>鍒犻櫎</button>
+                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel"><i class="layui-icon layui-icon-delete"></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-Audit"><i class="layui-icon layui-icon-radio"></i>瀹℃牳</button>
                                 <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit"><i class="layui-icon layui-icon-circle"></i>鍙嶅鏍�</button>
@@ -241,6 +242,7 @@
                         break;
                     //瀵煎叆
                     case 'set_SouceExcel': set_SouceExcel();
+                        break;
                     //瀹℃牳鎸夐挳
                     case 'btn-Audit':
                         set_CheckBill(0);
@@ -360,6 +362,17 @@
             }
             //#endregion
 
+            //瀵煎叆
+            function set_SouceExcel() {
+                layer.open({
+                    type: 2
+                    , area: ['100%', '100%']
+                    , title: '鐢熶骇鐝粍瀵煎叆'
+                    , shift: 0//寮瑰嚭鍔ㄧ敾
+                    , content: '../../璁″垝绠$悊/Excel/Gy_Group_Excel.html?OperationType=dao&HSouceBillType='
+                })
+            }
+
             //鏂囦欢涓婁紶
             upload.render({
                 elem: '#UpLoad',
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\344\273\273\345\212\241\345\215\225/Sc_ICMOBillList.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\344\273\273\345\212\241\345\215\225/Sc_ICMOBillList.html"
index 70fd14d..fb3f905 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\344\273\273\345\212\241\345\215\225/Sc_ICMOBillList.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\347\224\237\344\272\247\344\273\273\345\212\241\345\215\225/Sc_ICMOBillList.html"
@@ -32,9 +32,9 @@
                                 </div>
                                 <div class="layui-row">
                                     <div class="layui-inline">
-                                        <label class="layui-form-label">瑙勬牸鍨嬪彿</label>
+                                        <label class="layui-form-label">鐗╂枡缂栫爜</label>
                                         <div class="layui-input-block">
-                                            <input type="text" class="layui-input ForFilteringSchemes" name="HModel" id="HModel">
+                                            <input type="text" class="layui-input ForFilteringSchemes" name="HMaterName" id="HMaterName">
                                         </div>
                                     </div>
                                     <div class="layui-inline">
@@ -76,9 +76,9 @@
                                 </div>
                                 <div class="layui-row">
                                     <div class="layui-inline">
-                                        <label class="layui-form-label">鐗╂枡缂栫爜</label>
+                                        <label class="layui-form-label">瑙勬牸鍨嬪彿</label>
                                         <div class="layui-input-block">
-                                            <input type="text" class="layui-input ForFilteringSchemes" name="HMaterName" id="HMaterName">
+                                            <input type="text" class="layui-input ForFilteringSchemes" name="HModel" id="HModel">
                                         </div>
                                     </div>
                                     <div class="layui-inline">
@@ -100,14 +100,15 @@
                                         <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                     </button>
                                     <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px;display:none;">閲嶇疆</button>
+
+
                                     <div class="layui-inline">
-                                        <label class="layui-form-label" style="width: 85px;">缁勭粐</label>
-                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
-                                            <select name="HOrgID" id="HOrgID" lay-verify="HOrgID">
-                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
-                                            </select>
+                                        <label class="layui-form-label">閿�鍞鍗�</label>
+                                        <div class="layui-input-block">
+                                            <input type="text" class="layui-input ForFilteringSchemes" name="HSeOrderBillNo" id="HSeOrderBillNo">
                                         </div>
                                     </div>
+
                                     <!--鏄剧ず褰撳墠杩囨护鏂规-->
                                     <div class="layui-inline" style="margin-left:5px;">
                                         <div style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393" id="HFilterScheme_Now"></div>
@@ -129,6 +130,16 @@
                                                 <input type="text" class="layui-input ForFilteringSchemes" name="HERPID" id="HERPID">
                                             </div>
                                         </div>
+
+                                        <div class="layui-inline">
+                                            <label class="layui-form-label" style="width: 85px;">缁勭粐</label>
+                                            <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
+                                                <select name="HOrgID" id="HOrgID" lay-verify="HOrgID">
+                                                    <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                                </select>
+                                            </div>
+                                        </div>
+
                                     </div>
                                     <div class="layui-row" style="margin-top:5px">
                                         <div class="layui-inline">
@@ -1027,6 +1038,7 @@
                 var WorkCenter = $("#WorkCenter").val();//鍗曟嵁鍙�
                 var HMaterName = $("#HMaterName").val();//鍗曟嵁鍙�
                 var HErpID = $("#HERPID").val();//鍞竴鏍囪瘑
+                var HSeOrderBillNo = $("#HSeOrderBillNo").val(); //閿�鍞鍗�
                 var HDeptName = $("#HDeptName").val();//鍗曟嵁鍙�
                 var HStatus = $("#HStatus").val();//鍗曟嵁鍙�
                 var HBillType = $("#HBillType").val();//鍗曟嵁绫诲瀷
@@ -1137,6 +1149,9 @@
                 if (HOrderProcNO) {
                     sWhere += " and 璁㈠崟璺熻釜鍙� like '%" + HOrderProcNO + "%'";
                 }
+                if (HSeOrderBillNo) {
+                    sWhere += " and 閿�鍞鍗曞彿 like '%" + HSeOrderBillNo + "%'";
+                }
                 if (WorkCenter) {
                     sWhere += " and 鍗曟嵁鍙� like '%" + WorkCenter + "%'";
                 }
diff --git "a/WebTM/views/\350\256\241\345\210\222\347\256\241\347\220\206/Excel/Gy_Group_Excel.html" "b/WebTM/views/\350\256\241\345\210\222\347\256\241\347\220\206/Excel/Gy_Group_Excel.html"
new file mode 100644
index 0000000..35b3cbb
--- /dev/null
+++ "b/WebTM/views/\350\256\241\345\210\222\347\256\241\347\220\206/Excel/Gy_Group_Excel.html"
@@ -0,0 +1,234 @@
+锘�<!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/zgqCustom/zgqCustom.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>
+</head>
+<body>
+    <div class="layui-fluid" style="padding: 0;">
+        <div class="layui-card" style="padding: 2px;background-color: #efefef;">
+            <div class="layui-card-body" style="padding: 1px;">
+                <form class="layui-form" action="" lay-filter="formData" style="background-color:white;">
+                    <div style="padding: 10px; ">
+                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">瀵煎叆鏁版嵁</button>
+                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">閫�鍑�</button>
+                        <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">鏂囦欢涓婁紶</button>
+                    </div>
+                    <div class="layui-tab" lay-filter="tab-POStockInBill">
+                        <div class="layui-tab-content">
+                            <!--鍩烘湰淇℃伅-->
+                            <div class="layui-tab-item layui-show">
+                                <div class="layui-form-item" style="padding-top: 10px;">
+
+                                </div>
+                            </div>
+                        </div>
+                    </div>
+
+                    <table class="" id="mainTable" lay-filter="mainTable"></table>
+                    <script type="text/html" id="toolbarDemo">
+                        <div class="layui-btn-container">
+                        </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' //涓诲叆鍙fā鍧�
+    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'upload'], function () {
+        //#region 鍏敤鍙橀噺
+        var $ = layui.$
+            , admin = layui.admin
+            , layer = layui.layer
+            , table = layui.table
+            , form = layui.form
+            , element = layui.element
+            , laypage = layui.laypage
+            , laydate = layui.laydate
+            , util = layui.util
+            , tree = layui.tree
+            , util = layui.util
+            , upload = layui.upload
+
+
+        var option = [];
+        //#endregion
+
+        //#region 杩涘叆椤甸潰鍗冲姞杞�
+
+        //鍒濆鍖栫晫闈�
+        set_ClearBill();
+
+
+        //#endregion
+
+        //#region 瑙﹀彂浜嬩欢锛氬寘鎷琭orm.on(){}鏍煎紡鐨勬墍鏈夌偣鍑讳簨浠躲�侀�夋嫨浜嬩欢绛�
+
+        //鏂囦欢涓婁紶
+        upload.render({
+            elem: '#UpLoad',
+            url: GetWEBURL() + '/Gy_Process/Gy_Process_Excel',
+            contentType: 'application/json',
+            exts: 'xls|xlsx', //鍏佽涓婁紶鐨勭被鍨�
+            done: function (data1) {
+                if (data1.count == 1) {
+                    option.data = data1.data;
+                    table.render(option);
+                } else {
+                    layer.alert(data1.code + data1.Message, { icon: 5 });
+                }
+            },
+            error: function (err) {
+                debugger
+                layer.alert('瀵煎叆鍑虹幇寮傚父', { icon: 2 });
+            }
+        });
+
+        //琛屽唴浜嬩欢
+        table.on('tool(mainTable)', function (obj) {
+            set_GridDelete(obj);   //琛屽唴鍒犻櫎
+        });
+
+        //瀵煎叆  淇濆瓨鏁版嵁
+        form.on('submit(btnSave)', function (data) {
+            if (table.cache["mainTable"] != null) {
+                set_AddNew(data);
+            }
+            else {
+                layer.msg("鏃犳暟鎹�,璇峰厛瀵煎叆鏁版嵁!");
+            }
+        })
+
+        //閫�鍑�
+        form.on('submit(Cancel)', function () {
+            Pub_Close(1);
+        })
+
+
+        //#endregion
+
+        //#region 姝ら〉闈㈡墍鏈夌殑鏂规硶
+
+        //#region 鍒濆鍖栫晫闈�
+        function set_ClearBill() {
+            //鍒濆鍖栬〃鏍�
+            set_InitGrid();
+        }
+        //#endregion
+
+
+        //鍒濆鍖栬〃鏍�
+        function set_InitGrid() {
+            option = {
+                elem: '#mainTable'
+                , toolbar: '#toolbarDemo'
+                , height: 'full-120'
+                , page: true
+                , cellMinWidth: 90
+                , limit: 50
+                , limits: [50, 500, 5000, 20000]
+                , loading: false
+                , cols: [[
+                    { type: 'checkbox', fixed: 'left' }
+                    , { field: 'HOrgID', title: 'HOrgID', width: 120, hide: true }
+                    , { field: '缁勭粐浠g爜', title: '缁勭粐浠g爜', width: 120 }
+                    , { field: '缁勭粐鍚嶇О', title: '缁勭粐鍚嶇О', width: 120 }
+                    , { field: '鐝粍浠g爜', title: '鐝粍浠g爜', width: 120 }
+                    , { field: '鐝粍', title: '鐝粍', width: 120 }
+                    , { field: 'HDeptID', title: 'HDeptID', width: 120, hide: true }
+                    , { field: '閮ㄩ棬浠g爜', title: '閮ㄩ棬浠g爜', width: 120, hide: true }
+                    , { field: '鎵�灞為儴闂�', title: '鎵�灞為儴闂�', width: 120 }
+                    , { field: '鐝粍鎬讳汉鏁�', title: '鐝粍鎬讳汉鏁�', width: 120}
+                    , { field: '宸ュ簭浠g爜', title: '宸ュ簭浠g爜', width: 120, hide: true }
+                    , { field: '宸ュ簭', title: '宸ュ簭', width: 120 }
+                    , { field: '澶囨敞', title: '澶囨敞', width: 120 }
+                ]]
+            };
+
+            //娓叉煋椤甸潰
+            table.render(option);
+            //DisPlay_HideColumn();
+        }
+
+        //琛屽唴鍒犻櫎
+        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 {
+                        var oldData = option.data;
+                        oldData.splice(obj.tr.data('index'), 1)
+                        option.data = oldData;//灏嗘暟鎹粦瀹氬埌data涓�
+                        table.render(option);
+                        layer.close(index);
+                    }
+                });
+            }
+        }
+
+        //瀵煎叆(淇濆瓨)
+        function set_AddNew(data) {
+            var num = [];
+            for (var i = 0; i < option.data.length; i++) {
+                if (option.data[i] != "") {
+                    num.push(option.data[i])
+                }
+            }
+
+            var sSubStr = JSON.stringify(num);
+            var sMainSub = sSubStr + '&鍜�' + sessionStorage["HUserName"];
+            var index = layer.load();
+
+            $.ajax({
+                type: "POST",
+                url: GetWEBURL() + "/Gy_Process/Gy_Process_btnSave",
+                async: true,
+                data: { "sMainSub": sMainSub },
+                dataType: "json",
+                success: function (data) {
+                    if (data.count == 1) {
+                        layer.close(index);
+                        layer.msg(data.Message);
+                        option.data = null;
+                        table.cache["mainTable"] = null;
+                        table.render(option);
+                    }
+                    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: "娓╅Θ鎻愮ず" });
+                }
+            });
+        }
+
+        //#endregion
+
+    });
+
+</script>
\ No newline at end of file
diff --git "a/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\345\267\245\345\272\217\345\207\272\347\253\231\346\261\207\346\212\245\345\215\225/Cj_StationOutBill.html" "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\345\267\245\345\272\217\345\207\272\347\253\231\346\261\207\346\212\245\345\215\225/Cj_StationOutBill.html"
index f5dbab8..375f088 100644
--- "a/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\345\267\245\345\272\217\345\207\272\347\253\231\346\261\207\346\212\245\345\215\225/Cj_StationOutBill.html"
+++ "b/WebTM/views/\350\275\246\351\227\264\347\256\241\347\220\206/\345\267\245\345\272\217\345\207\272\347\253\231\346\261\207\346\212\245\345\215\225/Cj_StationOutBill.html"
@@ -355,9 +355,16 @@
                                     </div>
                                     <div class="layui-row">
                                         <div class="layui-col-xs4 layui-inline">
-                                            <label class="layui-form-label" >妯″叿鍨嬪彿</label>
-                                            <div class="layui-input-block" >
+                                            <label class="layui-form-label">妯″叿鍨嬪彿</label>
+                                            <div class="layui-input-block">
                                                 <input type="text" class="layui-input" name="HModel" id="HModel" value="" style="width: 190px;" readonly>
+                                            </div>
+                                        </div>
+
+                                        <div class="layui-col-xs8 layui-inline">
+                                            <label class="layui-form-label">澶囨敞</label>
+                                            <div class="layui-input-block">
+                                                <input class="layui-input" name="HRemark" id="HRemark" autocomplete="off" style=" width: 75%;">
                                             </div>
                                         </div>
                                     </div>
@@ -522,12 +529,7 @@
                                                 <input type="text" class="layui-input" value="0" name="" id="">
                                             </div>
                                         </div>
-                                        <div class="layui-col-xs8 layui-inline">
-                                            <label class="layui-form-label">澶囨敞</label>
-                                            <div class="layui-input-block">
-                                                <input class="layui-input" name="HRemark" id="HRemark" autocomplete="off" style=" width: 75%;">
-                                            </div>
-                                        </div>
+                                      
                                     </div>
                                 </div>
                             </div>

--
Gitblit v1.9.1