From 1fb26abe4014191db2195de1670cf3adb4fc4314 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期四, 10 十月 2024 16:07:47 +0800
Subject: [PATCH] 撕莫尔质量报表全部增加 项目号,是否量产.事业部过滤条件

---
 WebTM/views/质量管理/质量报表/QC_PPMReport.html                                 |  109 ++
 WebTM/WebTM.csproj.user                                                 |    2 
 WebTM/views/质量管理/质量报表/QC_PerformanceScrapLedger.html                    |  280 ++----
 WebTM/views/质量管理/质量报表/QC_MoistureContentDataLedger.html                 |  269 ++----
 WebTM/views/车间管理/工序出站汇报单/Cj_StationOutBill.html                         |    3 
 WebTM/views/质量管理/质量月度目标单/QC_MonthTarGetBill.html                        |   15 
 WebTM/views/质量管理/质量报表/QC_BadProductsReport.html                         |  291 +----
 WebTM/views/质量管理/质量报表/QC_ErrManagerLedgerReport_SourceOfTheProblem.html |  107 ++
 WebTM/views/质量管理/质量报表/QC_SkillExamMonthSumReport.html                   |  107 ++
 WebTM/views/质量管理/质量报表/QC_ErrManagerLedgerReport_EquipTop3Issue.html     |  100 ++
 WebTM/views/质量管理/质量报表/QC_ErrManagerLedgerReport_Issue.html              |  105 ++
 WebTM/views/质量管理/质量报表/QC_ErrManagerLedgerReport_Source.html             |  105 ++
 WebTM/views/质量管理/质量报表/Sc_StationOutBil_HProc.html                       |  146 ++
 WebTM/views/质量管理/质量报表/QC_QualityStatisticsDailyReport.html              |  250 +---
 WebTM/views/生产管理/报工台工序/不良采集/Sc_QualityReportStepBill_New.html           |    6 
 WebTM/views/质量管理/质量报表/QC_QualityMonthSumReport.html                     |  108 ++
 WebTM/views/质量管理/质量报表/QC_RegistrationForTestingReport.html              |  254 ++---
 WebTM/layuiadmin/Scripts/webConfig.js                                   |    4 
 WebTM/views/质量管理/质量报表/QC_ErrManagerLedgerReport.html                    |  282 +----
 19 files changed, 1,345 insertions(+), 1,198 deletions(-)

diff --git a/WebTM/WebTM.csproj.user b/WebTM/WebTM.csproj.user
index ee77abe..005e8c8 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>C:\Users\86130\Desktop\鏅轰簯杩堟�漒MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
+    <NameOfLastUsedPublishProfile>D:\鏅轰簯杩堟�漒MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
     <ProjectView>ProjectFiles</ProjectView>
     <LastActiveSolutionConfig>Release|Any CPU</LastActiveSolutionConfig>
     <UseIISExpress>true</UseIISExpress>
diff --git a/WebTM/layuiadmin/Scripts/webConfig.js b/WebTM/layuiadmin/Scripts/webConfig.js
index b49cf09..bf7e891 100644
--- a/WebTM/layuiadmin/Scripts/webConfig.js
+++ b/WebTM/layuiadmin/Scripts/webConfig.js
@@ -3,11 +3,11 @@
     //var WEBURL = "http://192.168.16.80:8011/";          //鍔炲叕瀹ゆ湇鍔″櫒
     //var WEBURL = "http://localhost:8081/SWEAPI/";       //ch鏈湴*/
     //var WEBURL = "http://61.164.86.218:8099/ABAPI/";
-    var WEBURL = "http://localhost/API/";             //棰滄檽鍐涙湰鍦伴厤缃�
+  /*  var WEBURL = "http://localhost/API/";             //棰滄檽鍐涙湰鍦伴厤缃�*/
     //var WEBURL = "http://localhost:8082/LuBaoAPI/";    //鏉ㄤ箰鏈湴閰嶇疆
     //var WEBURL = "http://localhost:8082/API/";    //鏉滆春鏈湴閰嶇疆
     /*var WEBURL = "http://localhost/API/";*/    //娼樻禉娓告湰鍦伴厤缃�  
-    //var WEBURL = "http://localhost:8082/API/";    //寮犵憺骞挎湰鍦伴厤缃�
+    var WEBURL = "http://localhost:8082/API/";    //寮犵憺骞挎湰鍦伴厤缃�
     //var WEBURL = "http://localhost:81/API/"    //缈佹稕娑涙湰鍦伴厤缃�
     //var WEBURL = "http://47.96.97.237/API/";          //鏅轰簯鏈嶅姟鍣�
     //var WEBURL = "http://localhost:8082/LuBaoAPI/";   //浣欐�濇澃鏈湴閰嶇疆
diff --git "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/\344\270\215\350\211\257\351\207\207\351\233\206/Sc_QualityReportStepBill_New.html" "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/\344\270\215\350\211\257\351\207\207\351\233\206/Sc_QualityReportStepBill_New.html"
index 5d69f6b..21a9ece 100644
--- "a/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/\344\270\215\350\211\257\351\207\207\351\233\206/Sc_QualityReportStepBill_New.html"
+++ "b/WebTM/views/\347\224\237\344\272\247\347\256\241\347\220\206/\346\212\245\345\267\245\345\217\260\345\267\245\345\272\217/\344\270\215\350\211\257\351\207\207\351\233\206/Sc_QualityReportStepBill_New.html"
@@ -231,9 +231,9 @@
                     <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-InsertLine"><i class="layui-icon layui-icon-form"></i>鎻掑叆涓�琛�</button>
+                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-InsertLine"><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="btn-Up"><i class="layui-icon layui-icon-form"></i>涓婄Щ</button>
+                            <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Up"><i class="layui-icon layui-icon-form"></i>涓婄Щ</button>
                             <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Under"><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>
@@ -414,7 +414,7 @@
             //#region 瀛愯〃1锛氬ご宸ュ叿鏍忔寜閽Е鍙戜簨浠�
             table.on('toolbar(mainTable)', function (obj) {
                 var checkStatus = table.checkStatus('mainTable')
-                    , data = checkStatus.data;;
+                    , data = checkStatus.data;
 
                 //鏂板琛岃〃鏍兼暟鎹�
                 var NewRow = {
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_BadProductsReport.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_BadProductsReport.html"
index 8ef66db..bda0ffd 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_BadProductsReport.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_BadProductsReport.html"
@@ -49,130 +49,39 @@
                                     <div class="layui-input-block">
                                         <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate" style="width:190px;">
                                     </div>
-                                </div>
-                                <div class="layui-inline">
-                                    <label class="layui-form-label">鐗╂枡浠g爜</label>
-                                    <div class="layui-input-block">
-                                        <input type="text" class="layui-input ForFilteringSchemes" name="HMaterNumber" id="HMaterNumber" style="width:215px;">
-                                    </div>
-                                </div>
+                                </div>                              
                                 <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
                                     <div class="layui-inline">
-                                        <label class="layui-form-label">瑙勬牸鍨嬪彿</label>
-                                        <div class="layui-input-block">
-                                            <input type="text" class="layui-input ForFilteringSchemes" name="HMaterModel" id="HMaterModel" style="width:215px;">
+                                        <label class="layui-form-label" style="width: 85px;">鏄惁閲忎骇</label>
+                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
+                                            <select name="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                                <option value="">璇烽�夋嫨</option>
+                                                <option value="1">閲忎骇</option>
+                                                <option value="0">闈為噺浜�</option>
+                                            </select>
                                         </div>
                                     </div>
                                     <div class="layui-inline">
-                                        <label class="layui-form-label">鍙戠幇宸ュ簭</label>
-                                        <div class="layui-input-block">
-                                            <input type="text" class="layui-input ForFilteringSchemes" name="HProcessName" id="HProcessName" style="width:190px;">
+                                        <label class="layui-form-label" style="width: 85px;">椤圭洰鍙�</label>
+                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
+                                            <select name="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                            </select>
                                         </div>
                                     </div>
                                     <div class="layui-inline">
-                                        <label class="layui-form-label">澶勭疆鏂瑰紡</label>
-                                        <div class="layui-input-block">
-                                            <input type="text" class="layui-input ForFilteringSchemes" name="HDealingType" id="HDealingType" style="width:190px;">
-                                        </div>
-                                    </div>
-                                    <div class="layui-inline">
-                                        <label class="layui-form-label">鐧昏浜�</label>
-                                        <div class="layui-input-block">
-                                            <input type="text" class="layui-input ForFilteringSchemes" name="HSendManName" id="HSendManName" style="width:100px;">
+                                        <label class="layui-form-label" style="width: 85px;">浜嬩笟閮�</label>
+                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
+                                            <select name="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                            </select>
                                         </div>
                                     </div>
                                     <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                         <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">閲嶇疆</button>
-                                </div>
-                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
-                                    <div class="layui-row" style="margin-top:10px;margin-left:5%;">
-
-                                    </div>
-                                    <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px ">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
-                                        </div>
-                                    </div>
-                                    <div class="layui-row" style=" margin-top: 10px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
-                                        </div>
-                                    </div>
-
-                                    <div class="layui-row" style=" margin-top: 10px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
-                                        </div>
-                                    </div>
-                                </div>
+                                </div>                               
                             </div>
                         </div>
                         <div class="layui-tab layui-tab-card">
@@ -288,6 +197,8 @@
             //鏍规嵁鏃ユ湡闂撮殧璁剧疆寮�濮嬫椂闂翠笌缁撴潫鏃堕棿
             $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
             $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
+            Get_HProject(); //鑾峰彇椤圭洰鍙�
+            GetGy_Division();//鑾峰彇浜嬩笟閮�
             //鏌ヨ
             get_FastQuery();
         }
@@ -394,95 +305,17 @@
         function get_FastQuery() {
             var HBeginDate = $("#HBeginDate").val();
             var HEndDate = $("#HEndDate").val();
-            var HMaterNumber = $("#HMaterNumber").val();
-            var HMaterModel = $("#HMaterModel").val();
-            var HProcessName = $("#HProcessName").val();
-            var HDealingType = $("#HDealingType").val();
-            var HSendManName = $("#HSendManName").val();
+            var HProject = $("#HProject").val();//椤圭洰鍙�
+            var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+            var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
 
-            var ColName = $("#ColName").val();//澶嶉�夋
-            var Comparator = $("#Comparator").val()
-            var ColContent = $("#ColContent").val();
-            var ColName1 = $("#ColName1").val();//澶嶉�夋
-            var Comparator1 = $("#Comparator1").val()
-            var ColContent1 = $("#ColContent1").val();
-            var ColName2 = $("#ColName2").val();//澶嶉�夋
-            var Comparator2 = $("#Comparator2").val()
-            var ColContent2 = $("#ColContent2").val();
-
-            if (ColName != 0 && Comparator != 0) {
-                var com = "";
-                switch (Comparator) {
-                    case "7":
-                        com = "like''%" + ColContent + "%''";
-                        break;
-                    case "8":
-                        com = "like''%" + ColContent + "''";
-                        break;
-                    case "9":
-                        com = "like''" + ColContent + "%''";
-                        break;
-                    case "10":
-                        com = "not like''%" + ColContent + "%''";
-                        break;
-                    default:
-                        com = "" + Comparator + "''" + ColContent + "''";
-                        break;
-                }
-                sWhere += " and " + ColName + " " + com;
-            }
-            if (ColName1 != 0 && Comparator1 != 0) {
-                var com1 = "";
-                switch (Comparator1) {
-                    case "7":
-                        com1 = "like''%" + ColContent1 + "%''";
-                        break;
-                    case "8":
-                        com1 = "like''%" + ColContent1 + "''";
-                        break;
-                    case "9":
-                        com1 = "like''" + ColContent1 + "%''";
-                        break;
-                    case "10":
-                        com1 = "not like''%" + ColContent1 + "%''";
-                        break;
-                    default:
-                        com1 = "" + Comparator1 + "''" + ColContent1 + "''";
-                        break;
-                }
-                sWhere += " and " + ColName1 + " " + com1;
-            }
-            if (ColName2 != 0 && Comparator2 != 0) {
-                var com2 = "";
-                switch (Comparator2) {
-                    case "7":
-                        com2 = "like''%" + ColContent2 + "%''";
-                        break;
-                    case "8":
-                        com2 = "like''%" + ColContent2 + "''";
-                        break;
-                    case "9":
-                        com2 = "like''" + ColContent2 + "%''";
-                        break;
-                    case "10":
-                        com2 = "not like''%" + ColContent2 + "%''";
-                        break;
-                    default:
-                        com2 = "" + Comparator2 + "''" + ColContent2 + "''";
-                        break;
-                }
-                sWhere += " and " + ColName2 + " " + com2;
-            }
-
+           
             sWhere = {
                 HBeginDate: HBeginDate
                 , HEndDate: HEndDate
-                , HMaterNumber: HMaterNumber
-                , HMaterModel: HMaterModel
-                , HProcessName: HProcessName
-                , HDealingType: HDealingType
-                , HSendManName: HSendManName
-                , HCustomize: sWhere
+                , HProject: HProject
+                , HBatchWork: HBatchWork
+                , HDivisionName: HDivisionName
             }
             set_InitGrid();
             get_Display(JSON.stringify(sWhere));
@@ -493,25 +326,65 @@
             var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
             $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //寮�濮嬫棩鏈�
             $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));  //缁撴潫鏃ユ湡
-            $("#HMaterNumber").val("");
-            $("#HMaterModel").val("");
-            $("#HProcessName").val("");
-            $("#HDealingType").val("");
-            $("#HSendManName").val("");
-            $("#ColContent1").val("");
-            $("#ColName1").val("0");
-            $("#Comparator1").val("0");
-            $("#ColContent2").val("");
-            $("#ColName2").val("0");
-            $("#Comparator2").val("0");
-            $("#ColContent").val("");
-            $("#ColName").val("0");
-            $("#Comparator").val("0");
+            $("#HProject").val("");
+            $("#HBatchWork").val("");
+            $("#HDivisionName").val("");          
             form.render('select');
 
             sWhere = "";
         }
 
+        //#region 鑾峰彇椤圭洰鍙�
+        function Get_HProject() {
+            //鑾峰彇椤圭洰鍙�
+            var HProjectList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HProject").append(HProjectList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
+        //#region 鑾峰彇浜嬩笟閮�
+        function GetGy_Division() {
+            //鑾峰彇浜嬩笟閮�
+            var HDivisionList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HDivisionName").append(HDivisionList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
+
         //闅愯棌鍒楄缃�
         function get_HideColumn() {
             var colName = "";
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport.html"
index ca90ccd..dbf9ad8 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport.html"
@@ -60,121 +60,37 @@
                                 </div>
                                 <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
                                     <div class="layui-inline">
-                                        <label class="layui-form-label">瑙勬牸鍨嬪彿</label>
-                                        <div class="layui-input-block">
-                                            <input type="text" class="layui-input ForFilteringSchemes" name="HMaterModel" id="HMaterModel" style="width:215px;">
+                                        <label class="layui-form-label" style="width: 85px;">鏄惁閲忎骇</label>
+                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
+                                            <select name="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                                <option value="">璇烽�夋嫨</option>
+                                                <option value="1">閲忎骇</option>
+                                                <option value="0">闈為噺浜�</option>
+                                            </select>
                                         </div>
                                     </div>
                                     <div class="layui-inline">
-                                        <label class="layui-form-label">鐢熶骇璧勬簮</label>
-                                        <div class="layui-input-block">
-                                            <input type="text" class="layui-input ForFilteringSchemes" name="HSourceName" id="HSourceName" style="width:190px;">
+                                        <label class="layui-form-label" style="width: 85px;">椤圭洰鍙�</label>
+                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
+                                            <select name="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                            </select>
                                         </div>
                                     </div>
                                     <div class="layui-inline">
-                                        <label class="layui-form-label">闂鏉ユ簮</label>
-                                        <div class="layui-input-block">
-                                            <input type="text" class="layui-input ForFilteringSchemes" name="HProSource" id="HProSource" style="width:190px;">
-                                        </div>
-                                    </div>
-                                    <div class="layui-inline">
-                                        <label class="layui-form-label">鐝</label>
-                                        <div class="layui-input-block">
-                                            <input type="text" class="layui-input ForFilteringSchemes" name="HShiftsName" id="HShiftsName" style="width:128px;">
+                                        <label class="layui-form-label" style="width: 85px;">浜嬩笟閮�</label>
+                                        <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
+                                            <select name="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                            </select>
                                         </div>
                                     </div>
                                     <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                         <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">閲嶇疆</button>
-                                </div>
-                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
-                                    <div class="layui-row" style="margin-top:10px;margin-left:5%;">
 
-                                    </div>
-                                    <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px ">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
-                                        </div>
-                                    </div>
-                                    <div class="layui-row" style=" margin-top: 10px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
-                                        </div>
-                                    </div>
-
-                                    <div class="layui-row" style=" margin-top: 10px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
-                                            </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
-                                        </div>
-                                    </div>
-                                </div>
+                                </div>                          
                             </div>
                         </div>
                         <div class="layui-tab layui-tab-card">
@@ -291,6 +207,8 @@
             $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
             $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
             DeptName();
+            Get_HProject(); //鑾峰彇椤圭洰鍙�
+            GetGy_Division();//鑾峰彇浜嬩笟閮�
             //鏌ヨ
             get_FastQuery();
         }
@@ -420,99 +338,24 @@
             });
         }
 
+
         // 蹇�熻繃婊�
         function get_FastQuery() {
             var HBeginDate = $("#HBeginDate").val();
             var HEndDate = $("#HEndDate").val();
-            var HDeptID = $("#HDeptName").val();
-            var HMaterModel = $("#HMaterModel").val();
-            var HSourceName = $("#HSourceName").val();
-            var HProSource = $("#HProSource").val();
-            var HShiftsName = $("#HShiftsName").val();
+            var HDeptID = $("#HDeptName").val();           
 
-            var ColName = $("#ColName").val();//澶嶉�夋
-            var Comparator = $("#Comparator").val()
-            var ColContent = $("#ColContent").val();
-            var ColName1 = $("#ColName1").val();//澶嶉�夋
-            var Comparator1 = $("#Comparator1").val()
-            var ColContent1 = $("#ColContent1").val();
-            var ColName2 = $("#ColName2").val();//澶嶉�夋
-            var Comparator2 = $("#Comparator2").val()
-            var ColContent2 = $("#ColContent2").val();
-
-            if (ColName != 0 && Comparator != 0) {
-                var com = "";
-                switch (Comparator) {
-                    case "7":
-                        com = "like''%" + ColContent + "%''";
-                        break;
-                    case "8":
-                        com = "like''%" + ColContent + "''";
-                        break;
-                    case "9":
-                        com = "like''" + ColContent + "%''";
-                        break;
-                    case "10":
-                        com = "not like''%" + ColContent + "%''";
-                        break;
-                    default:
-                        com = "" + Comparator + "''" + ColContent + "''";
-                        break;
-                }
-                sWhere += " and " + ColName + " " + com;
-            }
-            if (ColName1 != 0 && Comparator1 != 0) {
-                var com1 = "";
-                switch (Comparator1) {
-                    case "7":
-                        com1 = "like''%" + ColContent1 + "%''";
-                        break;
-                    case "8":
-                        com1 = "like''%" + ColContent1 + "''";
-                        break;
-                    case "9":
-                        com1 = "like''" + ColContent1 + "%''";
-                        break;
-                    case "10":
-                        com1 = "not like''%" + ColContent1 + "%''";
-                        break;
-                    default:
-                        com1 = "" + Comparator1 + "''" + ColContent1 + "''";
-                        break;
-                }
-                sWhere += " and " + ColName1 + " " + com1;
-            }
-            if (ColName2 != 0 && Comparator2 != 0) {
-                var com2 = "";
-                switch (Comparator2) {
-                    case "7":
-                        com2 = "like''%" + ColContent2 + "%''";
-                        break;
-                    case "8":
-                        com2 = "like''%" + ColContent2 + "''";
-                        break;
-                    case "9":
-                        com2 = "like''" + ColContent2 + "%''";
-                        break;
-                    case "10":
-                        com2 = "not like''%" + ColContent2 + "%''";
-                        break;
-                    default:
-                        com2 = "" + Comparator2 + "''" + ColContent2 + "''";
-                        break;
-                }
-                sWhere += " and " + ColName2 + " " + com2;
-            }
-
+            var HProject = $("#HProject").val();//椤圭洰鍙�
+            var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+            var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+          
             sWhere = {
                 HBeginDate: HBeginDate
                 , HEndDate: HEndDate
                 , HDeptID: HDeptID
-                , HMaterModel: HMaterModel
-                , HSourceName: HSourceName
-                , HProSource: HProSource
-                , HShiftsName: HShiftsName
-                , HCustomize: sWhere
+                , HProject: HProject
+                , HBatchWork: HBatchWork
+                , HDivisionName: HDivisionName
             }
             set_InitGrid();
             get_Display(JSON.stringify(sWhere));
@@ -524,24 +367,65 @@
             $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //寮�濮嬫棩鏈�
             $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));  //缁撴潫鏃ユ湡
             $("#HDeptName").val("0");
-            $("#HMaterModel").val("");
-            $("#HSourceName").val("");
-            $("#HProSource").val("");
-            $("#HShiftsName").val("");
-            $("#ColContent1").val("");
-            $("#ColName1").val("0");
-            $("#Comparator1").val("0");
-            $("#ColContent2").val("");
-            $("#ColName2").val("0");
-            $("#Comparator2").val("0");
-            $("#ColContent").val("");
-            $("#ColName").val("0");
-            $("#Comparator").val("0");
+            $("#HProject").val("");
+            $("#HBatchWork").val("");
+            $("#HDivisionName").val("");          
             form.render('select');
 
             sWhere = "";
         }
 
+
+        //#region 鑾峰彇椤圭洰鍙�
+        function Get_HProject() {
+            //鑾峰彇椤圭洰鍙�
+            var HProjectList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HProject").append(HProjectList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
+        //#region 鑾峰彇浜嬩笟閮�
+        function GetGy_Division() {
+            //鑾峰彇浜嬩笟閮�
+            var HDivisionList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HDivisionName").append(HDivisionList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
         //闅愯棌鍒楄缃�
         function get_HideColumn() {
             var colName = "";
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_EquipTop3Issue.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_EquipTop3Issue.html"
index d1a1503..a3861be 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_EquipTop3Issue.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_EquipTop3Issue.html"
@@ -41,12 +41,38 @@
                                             <!--鍔ㄦ�佹覆鏌撳勾浠�-->
                                         </select>
                                     </div>
-                                </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: 85px;">
                                         <select name="HMonth" id="HMonth" lay-verify="HMonth">
                                             <!--鍔ㄦ�佹覆鏌撴湀浠�-->
+                                        </select>
+                                    </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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                            <option value="">璇烽�夋嫨</option>
+                                            <option value="1">閲忎骇</option>
+                                            <option value="0">闈為噺浜�</option>
+                                        </select>
+                                    </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
                                         </select>
                                     </div>
                                 </div>
@@ -379,6 +405,8 @@
             function set_ClearBill() {
                 Year();
                 Month();
+                Get_HProject(); //鑾峰彇椤圭洰鍙�
+                GetGy_Division();//鑾峰彇浜嬩笟閮�
                 //鍒濆鍖栬〃鏍�
                 set_InitGrid();
                 //鍔犺浇鏁版嵁鍒扮綉鏍�
@@ -428,15 +456,13 @@
             }
 
             //鍔犺浇缃戞牸
-            function get_Display(DateYear) {
-                var HYear = $("#HYear").val();
-                var HMonth = $("#HMonth").val();
+            function get_Display(sWhere) {
                 var wait = layer.load();//閬僵
                 $.ajax({
                     url: GetWEBURL() + '/QC_CustomerAppealReport/QC_ErrManagerLedgerReport_EquipTop3Issue',
                     type: "GET",
                     async: false,
-                    data: { "HYear": HYear, "HMonth": HMonth, "user": sessionStorage["HUserName"] },
+                    data: { "sWhere": sWhere,"user": sessionStorage["HUserName"] },
                     success: function (data1) {
                         var col = [];
                         if (data1.count == 1) {
@@ -492,7 +518,19 @@
 
             //蹇�熻繃婊�
             function get_FastQuery() {
-                get_Display(sWhere);
+                var HYear = $("#HYear").val();
+                var HMonth = $("#HMonth").val();
+                var HProject = $("#HProject").val();//椤圭洰鍙�
+                var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+                var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+                sWhere = {
+                    HYear: HYear
+                    , HMonth: HMonth
+                    , HProject: HProject
+                    , HBatchWork: HBatchWork
+                    , HDivisionName: HDivisionName
+                }
+                get_Display(JSON.stringify(sWhere));
                 //璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
                 sWhere = "";
                 set_Graphics();
@@ -510,6 +548,56 @@
                 get_FastQuery();
             }
 
+            //#region 鑾峰彇椤圭洰鍙�
+            function Get_HProject() {
+                //鑾峰彇椤圭洰鍙�
+                var HProjectList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HProject").append(HProjectList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
+            //#region 鑾峰彇浜嬩笟閮�
+            function GetGy_Division() {
+                //鑾峰彇浜嬩笟閮�
+                var HDivisionList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HDivisionName").append(HDivisionList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
             //闅愯棌鍒楄缃�
             function get_HideColumn() {
                 var colName = "";
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_Issue.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_Issue.html"
index b70b0b9..8c4e893 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_Issue.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_Issue.html"
@@ -41,12 +41,38 @@
                                             <!--鍔ㄦ�佹覆鏌撳勾浠�-->
                                         </select>
                                     </div>
-                                </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: 85px;">
                                         <select name="HMonth" id="HMonth" lay-verify="HMonth">
                                             <!--鍔ㄦ�佹覆鏌撴湀浠�-->
+                                        </select>
+                                    </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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                            <option value="">璇烽�夋嫨</option>
+                                            <option value="1">閲忎骇</option>
+                                            <option value="0">闈為噺浜�</option>
+                                        </select>
+                                    </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
                                         </select>
                                     </div>
                                 </div>
@@ -379,6 +405,8 @@
             function set_ClearBill() {
                 Year();
                 Month();
+                Get_HProject(); //鑾峰彇椤圭洰鍙�
+                GetGy_Division();//鑾峰彇浜嬩笟閮�
                 //鍒濆鍖栬〃鏍�
                 set_InitGrid();
                 //鍔犺浇鏁版嵁鍒扮綉鏍�
@@ -428,15 +456,13 @@
             }
 
             //鍔犺浇缃戞牸
-            function get_Display(DateYear) {
-                var HYear = $("#HYear").val();
-                var HMonth = $("#HMonth").val();
+            function get_Display(sWhere) {
                 var wait = layer.load();//閬僵
                 $.ajax({
                     url: GetWEBURL() + '/QC_CustomerAppealReport/QC_ErrManagerLedgerReport_Issue',
                     type: "GET",
                     async: false,
-                    data: { "HYear": HYear, "HMonth": HMonth, "user": sessionStorage["HUserName"] },
+                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                     success: function (data1) {
                         var col = [];
                         if (data1.count == 1) {
@@ -492,7 +518,19 @@
 
             //蹇�熻繃婊�
             function get_FastQuery() {
-                get_Display(sWhere);
+                var HYear = $("#HYear").val();
+                var HMonth = $("#HMonth").val();
+                var HProject = $("#HProject").val();//椤圭洰鍙�
+                var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+                var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+                sWhere = {
+                    HYear: HYear
+                    , HMonth: HMonth
+                    , HProject: HProject
+                    , HBatchWork: HBatchWork
+                    , HDivisionName: HDivisionName
+                }
+                get_Display(JSON.stringify(sWhere));
                 //璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
                 sWhere = "";
                 set_Graphics();
@@ -503,13 +541,66 @@
                 var yyyy = new Date().getFullYear();
                 $("#HYear").val(yyyy);
                 var mm = new Date().getMonth() + 1;
-                $("#HMonth").val(mm)
+                $("#HMonth").val(mm);
+                $("#HProject").val("");
+                $("#HBatchWork").val("");
+                $("#HDivisionName").val("");
                 form.render('select');
 
                 sWhere = "";
                 get_FastQuery();
             }
 
+            //#region 鑾峰彇椤圭洰鍙�
+            function Get_HProject() {
+                //鑾峰彇椤圭洰鍙�
+                var HProjectList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HProject").append(HProjectList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
+            //#region 鑾峰彇浜嬩笟閮�
+            function GetGy_Division() {
+                //鑾峰彇浜嬩笟閮�
+                var HDivisionList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HDivisionName").append(HDivisionList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
             //闅愯棌鍒楄缃�
             function get_HideColumn() {
                 var colName = "";
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_Source.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_Source.html"
index 03c7387..2874e8f 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_Source.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_Source.html"
@@ -41,12 +41,38 @@
                                             <!--鍔ㄦ�佹覆鏌撳勾浠�-->
                                         </select>
                                     </div>
-                                </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: 85px;">
                                         <select name="HMonth" id="HMonth" lay-verify="HMonth">
                                             <!--鍔ㄦ�佹覆鏌撴湀浠�-->
+                                        </select>
+                                    </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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                            <option value="">璇烽�夋嫨</option>
+                                            <option value="1">閲忎骇</option>
+                                            <option value="0">闈為噺浜�</option>
+                                        </select>
+                                    </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
                                         </select>
                                     </div>
                                 </div>
@@ -378,7 +404,9 @@
             //鍒濆鍖栫晫闈�
             function set_ClearBill() {
                 Year();
-                Month();               
+                Month();
+                Get_HProject(); //鑾峰彇椤圭洰鍙�
+                GetGy_Division();//鑾峰彇浜嬩笟閮�
                 //鍒濆鍖栬〃鏍�
                 set_InitGrid();
                 //鍔犺浇鏁版嵁鍒扮綉鏍�
@@ -428,15 +456,13 @@
             }
 
             //鍔犺浇缃戞牸
-            function get_Display(DateYear) {
-                var HYear = $("#HYear").val();
-                var HMonth = $("#HMonth").val();
+            function get_Display(sWhere) {             
                 var wait = layer.load();//閬僵
                 $.ajax({
                     url: GetWEBURL() + '/QC_CustomerAppealReport/QC_ErrManagerLedgerReport_Source',
                     type: "GET",
                     async: false,
-                    data: { "HYear": HYear, "HMonth": HMonth, "user": sessionStorage["HUserName"] },
+                    data: { "sWhere": sWhere,"user": sessionStorage["HUserName"] },
                     success: function (data1) {
                         var col = [];
                         if (data1.count == 1) {
@@ -492,7 +518,19 @@
 
             //蹇�熻繃婊�
             function get_FastQuery() {
-                get_Display(sWhere);
+                var HYear = $("#HYear").val();
+                var HMonth = $("#HMonth").val();
+                var HProject = $("#HProject").val();//椤圭洰鍙�
+                var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+                var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+                sWhere = {
+                    HYear: HYear
+                    , HMonth: HMonth
+                    , HProject: HProject
+                    , HBatchWork: HBatchWork
+                    , HDivisionName: HDivisionName
+                }
+                get_Display(JSON.stringify(sWhere));
                 //璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
                 sWhere = "";
                 set_Graphics();
@@ -504,12 +542,65 @@
                 $("#HYear").val(yyyy);
                 var mm = new Date().getMonth() + 1;
                 $("#HMonth").val(mm)
+                $("#HProject").val("");
+                $("#HBatchWork").val("");
+                $("#HDivisionName").val("");
                 form.render('select');
 
                 sWhere = "";
                 get_FastQuery();
             }
 
+            //#region 鑾峰彇椤圭洰鍙�
+            function Get_HProject() {
+                //鑾峰彇椤圭洰鍙�
+                var HProjectList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HProject").append(HProjectList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
+            //#region 鑾峰彇浜嬩笟閮�
+            function GetGy_Division() {
+                //鑾峰彇浜嬩笟閮�
+                var HDivisionList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HDivisionName").append(HDivisionList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+        //#endregion
+
             //闅愯棌鍒楄缃�
             function get_HideColumn() {
                 var colName = "";
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_SourceOfTheProblem.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_SourceOfTheProblem.html"
index f7dfbe8..2cf8e39 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_SourceOfTheProblem.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_ErrManagerLedgerReport_SourceOfTheProblem.html"
@@ -41,12 +41,38 @@
                                             <!--鍔ㄦ�佹覆鏌撳勾浠�-->
                                         </select>
                                     </div>
-                                </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: 85px;">
                                         <select name="HMonth" id="HMonth" lay-verify="HMonth">
                                             <!--鍔ㄦ�佹覆鏌撴湀浠�-->
+                                        </select>
+                                    </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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                            <option value="">璇烽�夋嫨</option>
+                                            <option value="1">閲忎骇</option>
+                                            <option value="0">闈為噺浜�</option>
+                                        </select>
+                                    </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
                                         </select>
                                     </div>
                                 </div>
@@ -378,7 +404,9 @@
             //鍒濆鍖栫晫闈�
             function set_ClearBill() {
                 Year();
-                Month();               
+                Month();
+                Get_HProject(); //鑾峰彇椤圭洰鍙�
+                GetGy_Division();//鑾峰彇浜嬩笟閮�
                 //鍒濆鍖栬〃鏍�
                 set_InitGrid();
                 //鍔犺浇鏁版嵁鍒扮綉鏍�
@@ -428,15 +456,13 @@
             }
 
             //鍔犺浇缃戞牸
-            function get_Display(DateYear) {
-                var HYear = $("#HYear").val();
-                var HMonth = $("#HMonth").val();
+            function get_Display(sWhere) {               
                 var wait = layer.load();//閬僵
                 $.ajax({
                     url: GetWEBURL() + '/QC_CustomerAppealReport/QC_ErrManagerLedgerReport_SourceOfTheProblem',
                     type: "GET",
                     async: false,
-                    data: { "HYear": HYear, "HMonth": HMonth, "user": sessionStorage["HUserName"] },
+                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                     success: function (data1) {
                         var col = [];
                         if (data1.count == 1) {
@@ -492,7 +518,19 @@
 
             //蹇�熻繃婊�
             function get_FastQuery() {
-                get_Display(sWhere);
+                var HYear = $("#HYear").val();
+                var HMonth = $("#HMonth").val();
+                var HProject = $("#HProject").val();//椤圭洰鍙�
+                var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+                var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+                sWhere = {
+                    HYear: HYear
+                    , HMonth: HMonth
+                    , HProject: HProject
+                    , HBatchWork: HBatchWork
+                    , HDivisionName: HDivisionName
+                }
+                get_Display(JSON.stringify(sWhere));
                 //璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
                 sWhere = "";
                 set_Graphics();
@@ -503,13 +541,66 @@
                 var yyyy = new Date().getFullYear();
                 $("#HYear").val(yyyy);
                 var mm = new Date().getMonth() + 1;
-                $("#HMonth").val(mm)
+                $("#HMonth").val(mm);
+                $("#HProject").val("");
+                $("#HBatchWork").val("");
+                $("#HDivisionName").val("");
                 form.render('select');
 
                 sWhere = "";
                 get_FastQuery();
             }
 
+            //#region 鑾峰彇椤圭洰鍙�
+            function Get_HProject() {
+                //鑾峰彇椤圭洰鍙�
+                var HProjectList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HProject").append(HProjectList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
+            //#region 鑾峰彇浜嬩笟閮�
+            function GetGy_Division() {
+                //鑾峰彇浜嬩笟閮�
+                var HDivisionList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HDivisionName").append(HDivisionList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
             //闅愯棌鍒楄缃�
             function get_HideColumn() {
                 var colName = "";
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_MoistureContentDataLedger.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_MoistureContentDataLedger.html"
index d65a979..6ec70e8 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_MoistureContentDataLedger.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_MoistureContentDataLedger.html"
@@ -67,93 +67,34 @@
                                     <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">閲嶇疆</button>
-                                <!--<div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
-                                    <div class="layui-row" style="margin-top:10px;margin-left:5%;">
-
-                                    </div>
-                                    <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px ">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
+                                <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
+                                    <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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                                <option value="">璇烽�夋嫨</option>
+                                                <option value="1">閲忎骇</option>
+                                                <option value="0">闈為噺浜�</option>
                                             </select>
                                         </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
-                                        </div>
                                     </div>
-                                    <div class="layui-row" style=" margin-top: 10px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
+                                    <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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
                                             </select>
                                         </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
-                                        </div>
                                     </div>
-
-                                    <div class="layui-row" style=" margin-top: 10px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
+                                    <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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
                                             </select>
                                         </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
-                                        </div>
                                     </div>
-                                </div>-->
+                                </div>
                             </div>
                         </div>
                         <div class="layui-tab layui-tab-card">
@@ -243,7 +184,8 @@
         function set_ClearBill() {
             $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
             $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
-            //set_InitGrid();
+            Get_HProject(); //鑾峰彇椤圭洰鍙�
+            GetGy_Division();//鑾峰彇浜嬩笟閮�
             //鏌ヨ
             get_FastQuery();
         }
@@ -290,14 +232,10 @@
                 , toolbar: '#toolbarDemo1'
                 , height: 'full-50'
                 , page: true
-                //, cellMinWidth: 'auto'
                 , totalRow: true
                 , limit: 500
                 , data:[]
-                , limits: [50, 500, 5000, 20000]
-                //, done: function (res, curr, count) {
-                //    soulTable.render(this);
-                //}
+                , limits: [50, 500, 5000, 20000]               
                 , cols: [columns]
             };
             table.render(option);
@@ -355,10 +293,7 @@
                                 , totalRow: true
                                 , limit: 500
                                 , data: data1.data
-                                , limits: [50, 500, 5000, 20000]
-                                //, done: function (res, curr, count) {
-                                //    soulTable.render(this);
-                                //}
+                                , limits: [50, 500, 5000, 20000]                               
                                 , cols: [col]
                             };
                         } else {
@@ -370,11 +305,6 @@
 
                         //鍒锋柊琛ㄦ牸鏁版嵁
                         DisPlay_HideColumn();
-
-                        //if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
-                        //    ColFilter();
-                        //}
-
                         layer.close(ajaxLoad);
                     } else {
                         layer.close(ajaxLoad);
@@ -393,87 +323,18 @@
             var HEndDate = $("#HEndDate").val();
             var HResult = $("#HResult").val();
             var HSourceID = $("#HSourceID").val();
-
-            var ColName = $("#ColName").val();//澶嶉�夋
-            var Comparator = $("#Comparator").val()
-            var ColContent = $("#ColContent").val();
-            var ColName1 = $("#ColName1").val();//澶嶉�夋
-            var Comparator1 = $("#Comparator1").val()
-            var ColContent1 = $("#ColContent1").val();
-            var ColName2 = $("#ColName2").val();//澶嶉�夋
-            var Comparator2 = $("#Comparator2").val()
-            var ColContent2 = $("#ColContent2").val();
-
-            if (ColName != 0 && Comparator != 0) {
-                var com = "";
-                switch (Comparator) {
-                    case "7":
-                        com = "like'%" + ColContent + "%'";
-                        break;
-                    case "8":
-                        com = "like'%" + ColContent + "'";
-                        break;
-                    case "9":
-                        com = "like'" + ColContent + "%'";
-                        break;
-                    case "10":
-                        com = "not like'%" + ColContent + "%'";
-                        break;
-                    default:
-                        com = "" + Comparator + "'" + ColContent + "'";
-                        break;
-                }
-                sWhere += " and " + ColName + " " + com;
-            }
-            if (ColName1 != 0 && Comparator1 != 0) {
-                var com1 = "";
-                switch (Comparator1) {
-                    case "7":
-                        com1 = "like'%" + ColContent1 + "%'";
-                        break;
-                    case "8":
-                        com1 = "like'%" + ColContent1 + "'";
-                        break;
-                    case "9":
-                        com1 = "like'" + ColContent1 + "%'";
-                        break;
-                    case "10":
-                        com1 = "not like'%" + ColContent1 + "%'";
-                        break;
-                    default:
-                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
-                        break;
-                }
-                sWhere += " and " + ColName1 + " " + com1;
-            }
-            if (ColName2 != 0 && Comparator2 != 0) {
-                var com2 = "";
-                switch (Comparator2) {
-                    case "7":
-                        com2 = "like'%" + ColContent2 + "%'";
-                        break;
-                    case "8":
-                        com2 = "like'%" + ColContent2 + "'";
-                        break;
-                    case "9":
-                        com2 = "like'" + ColContent2 + "%'";
-                        break;
-                    case "10":
-                        com2 = "not like'%" + ColContent2 + "%'";
-                        break;
-                    default:
-                        com2 = "" + Comparator2 + "'" + ColContent2 + "'";
-                        break;
-                }
-                sWhere += " and " + ColName2 + " " + com2;
-            }
-
-
+            var HProject = $("#HProject").val();//椤圭洰鍙�
+            var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+            var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+        
             sWhere = {
                 HBeginDate: HBeginDate
                 ,HEndDate: HEndDate
                 , HResult: HResult
                 , HSourceID: HSourceID
+                , HProject: HProject
+                , HBatchWork: HBatchWork
+                , HDivisionName: HDivisionName
             }
             //set_InitGrid();
             get_Display(JSON.stringify(sWhere));
@@ -481,23 +342,69 @@
         }
 
         function set_ClearQuery() {
-            $("#HICMOBillNo").val("");
-            $("#HBardCode").val("");
-            $("#HProcExchBillNo").val("");
-            $("#ColContent1").val("");
-            $("#ColName1").val("0");
-            $("#Comparator1").val("0");
-            $("#ColContent2").val("");
-            $("#ColName2").val("0");
-            $("#Comparator2").val("0");
-            $("#ColContent").val("");
-            $("#ColName").val("0");
-            $("#Comparator").val("0");
+            $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
+            $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
+            $("#HResult").val("");
+            $("#HSourceID").val("");
+            $("#HProject").val("");
+            $("#HBatchWork").val("");
+            $("#HDivisionName").val("");           
             form.render('select');
 
             sWhere = "";
         }
 
+        //#region 鑾峰彇椤圭洰鍙�
+        function Get_HProject() {
+            //鑾峰彇椤圭洰鍙�
+            var HProjectList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HProject").append(HProjectList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
+        //#region 鑾峰彇浜嬩笟閮�
+        function GetGy_Division() {
+            //鑾峰彇浜嬩笟閮�
+            var HDivisionList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HDivisionName").append(HDivisionList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
+
         //闅愯棌鍒楄缃�
         function get_HideColumn() {
             var colName = "";
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_PPMReport.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_PPMReport.html"
index 6887eaf..505b035 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_PPMReport.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_PPMReport.html"
@@ -59,6 +59,32 @@
                                         </select>
                                     </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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                            <option value="">璇烽�夋嫨</option>
+                                            <option value="1">閲忎骇</option>
+                                            <option value="0">闈為噺浜�</option>
+                                        </select>
+                                    </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </div>
+                                </div>
                                 <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                     <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                 </button>
@@ -131,6 +157,8 @@
                 //set_StockOrg();
                 //鍒濆鍖栬〃鍗曟椂闂�
                 set_InitDate();
+                Get_HProject(); //鑾峰彇椤圭洰鍙�
+                GetGy_Division();//鑾峰彇浜嬩笟閮�
                 //鍒濆鍖栬〃鏍�
                 set_InitGrid();
 
@@ -456,8 +484,23 @@
 
             //蹇�熸煡璇�
             function get_FastQuery() {
-                sDate = $("#HDate").val();                  //鏃ユ湡
-                get_Display(sWhere);
+                //鏂囨湰妗嗕负绌烘椂锛屾竻绌哄搴擨D
+                if ($("#HDeptName").val() == '') {
+                    $("#HDeptID").val("0");
+                }
+                var HDeptID = $("#HDeptID").val()
+                var HYear = $("#HDate").val(); //鏃ユ湡
+                var HProject = $("#HProject").val();//椤圭洰鍙�
+                var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+                var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+                sWhere = {
+                    HYear: HYear
+                    , HDeptID: HDeptID
+                    , HProject: HProject
+                    , HBatchWork: HBatchWork
+                    , HDivisionName: HDivisionName
+                }
+                get_Display(JSON.stringify(sWhere));
                 //鍔犺浇鏌辩姸鍥�
                 set_Graphics();
             }
@@ -466,19 +509,13 @@
 
             //#region 鍒楄〃鍒锋柊
             function get_Display(sWhere) {
-                var HDate = sDate;          //鏃ユ湡
-                //鏂囨湰妗嗕负绌烘椂锛屾竻绌哄搴擨D
-                if ($("#HDeptName").val() == '') {
-                    $("#HDeptID").val("0");
-                }
-                var HDeptID = $("#HDeptID").val()
-
+              
                 var ajaxLoad = layer.load();
                 $.ajax({
                     type: "GET",
                     url: GetWEBURL() + '/QC_QualityReportsController/GetQC_PPMReport_Json',
                     async: false,    //async鐢ㄤ簬鎺у埗锛坒alse锛夊悓姝ュ拰锛坱rue锛夊紓姝ワ紝榛樿鐨勬槸true锛屽嵆璇锋眰榛樿鐨勬槸寮傛璇锋眰
-                    data: { "HYear": HDate, "HDeptID": HDeptID },
+                    data: { "sWhere": sWhere},
                     success: function (data1) {
                         if (data1.count == 1) {
                             var data = [];
@@ -840,9 +877,58 @@
             ////#endregion
             //#endregion
 
-        });
+            //#region 鑾峰彇椤圭洰鍙�
+            function Get_HProject() {
+                //鑾峰彇椤圭洰鍙�
+                var HProjectList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HProject").append(HProjectList);
+                            form.render('select');
 
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
+            //#region 鑾峰彇浜嬩笟閮�
+            function GetGy_Division() {
+                //鑾峰彇浜嬩笟閮�
+                var HDivisionList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HDivisionName").append(HDivisionList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
         //#endregion
+        });      
+        //#endregion
+       
         //浠ヤ笂鏄痩ayui妯″潡
 
         //鍙屽嚮杩斿洖鍩虹璧勬枡鏁版嵁    琛ㄥご
@@ -851,6 +937,7 @@
             $("#HDeptName").val(obj[0].閮ㄩ棬鍚嶇О);
             $("#HDeptID").val(obj[0].HItemID);
         }
+
     </script>
 
 </body>
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_PerformanceScrapLedger.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_PerformanceScrapLedger.html"
index b0fcb87..3577d42 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_PerformanceScrapLedger.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_PerformanceScrapLedger.html"
@@ -25,12 +25,7 @@
                 <div class="layui-card-body" style="padding: 1px;">
                     <form class="layui-form" action="" lay-filter="component-form-group">
                         <div class="layui-collapse">
-                            <div class="layui-colla-item">
-                                <div class="layui-colla-title layui-inline">
-                                    <div class="layui-inline">
-                                        <span>鏇村</span>
-                                    </div>
-                                </div>
+                            <div class="layui-colla-item">                                
                                 <div class="layui-inline">
                                     <label class="layui-form-label">寮�濮嬫棩鏈�</label>
                                     <div class="layui-input-block">
@@ -63,93 +58,34 @@
                                     <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">閲嶇疆</button>
-                                <!--<div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
-        <div class="layui-row" style="margin-top:10px;margin-left:5%;">
-
-        </div>
-        <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px ">
-            <div class="layui-inline">
-                <label class="layui-form-label">杩囨护</label>
-                <div class="layui-input-block">
-                    <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
-                    </select>
-                </div>
-            </div>
-            <div class="layui-inline">
-                <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
-                    <option value="0" selected="selected"></option>
-                    <option value="=">=</option>
-                    <option value=">=">>=</option>
-                    <option value=">">></option>
-                    <option value="<="><=</option>
-                    <option value="<"><</option>
-                    <option value="<>"><></option>
-                    <option value="7">鍖呭惈</option>
-                    <option value="8">宸﹀寘鍚�</option>
-                    <option value="9">鍙冲寘鍚�</option>
-                    <option value="10">涓嶅寘鍚�</option>
-                </select>
-            </div>
-            <div class="layui-inline">
-                <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
-            </div>
-        </div>
-        <div class="layui-row" style=" margin-top: 10px;">
-            <div class="layui-inline">
-                <label class="layui-form-label">杩囨护</label>
-                <div class="layui-input-block">
-                    <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
-                    </select>
-                </div>
-            </div>
-            <div class="layui-inline">
-                <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
-                    <option value="0" selected="selected"></option>
-                    <option value="=">=</option>
-                    <option value=">=">>=</option>
-                    <option value=">">></option>
-                    <option value="<="><=</option>
-                    <option value="<"><</option>
-                    <option value="<>"><></option>
-                    <option value="7">鍖呭惈</option>
-                    <option value="8">宸﹀寘鍚�</option>
-                    <option value="9">鍙冲寘鍚�</option>
-                    <option value="10">涓嶅寘鍚�</option>
-                </select>
-            </div>
-            <div class="layui-inline">
-                <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
-            </div>
-        </div>
-
-        <div class="layui-row" style=" margin-top: 10px;">
-            <div class="layui-inline">
-                <label class="layui-form-label">杩囨护</label>
-                <div class="layui-input-block">
-                    <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
-                    </select>
-                </div>
-            </div>
-            <div class="layui-inline">
-                <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
-                    <option value="0" selected="selected"></option>
-                    <option value="=">=</option>
-                    <option value=">=">>=</option>
-                    <option value=">">></option>
-                    <option value="<="><=</option>
-                    <option value="<"><</option>
-                    <option value="<>"><></option>
-                    <option value="7">鍖呭惈</option>
-                    <option value="8">宸﹀寘鍚�</option>
-                    <option value="9">鍙冲寘鍚�</option>
-                    <option value="10">涓嶅寘鍚�</option>
-                </select>
-            </div>
-            <div class="layui-inline">
-                <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
-            </div>
-        </div>
-    </div>-->
+                                <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
+                                    <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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                                <option value="">璇烽�夋嫨</option>
+                                                <option value="1">閲忎骇</option>
+                                                <option value="0">闈為噺浜�</option>
+                                            </select>
+                                        </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                            </select>
+                                        </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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                            </select>
+                                        </div>
+                                    </div>
+                                </div>
                             </div>
                         </div>
                         <div class="layui-tab layui-tab-card">
@@ -239,7 +175,8 @@
         function set_ClearBill() {
             $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
             $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
-            //set_InitGrid();
+            Get_HProject(); //鑾峰彇椤圭洰鍙�
+            GetGy_Division();//鑾峰彇浜嬩笟閮�
             //鏌ヨ
             get_FastQuery();
         }
@@ -303,7 +240,6 @@
 
         // 鏌ヨ
         function get_Display(sWhere) {
-
             var ajaxLoad = layer.load();
             $.ajax({
                 url: GetWEBURL() + '/QC_CustomerAppealReport/QC_PerformanceScrapLedger',
@@ -391,111 +327,87 @@
             var HEndDate = $("#HEndDate").val();
             var HMaterID = $("#HMaterID").val();
             var HBatchNo = $("#HBatchNo").val();
-
-            var ColName = $("#ColName").val();//澶嶉�夋
-            var Comparator = $("#Comparator").val()
-            var ColContent = $("#ColContent").val();
-            var ColName1 = $("#ColName1").val();//澶嶉�夋
-            var Comparator1 = $("#Comparator1").val()
-            var ColContent1 = $("#ColContent1").val();
-            var ColName2 = $("#ColName2").val();//澶嶉�夋
-            var Comparator2 = $("#Comparator2").val()
-            var ColContent2 = $("#ColContent2").val();
-
-            if (ColName != 0 && Comparator != 0) {
-                var com = "";
-                switch (Comparator) {
-                    case "7":
-                        com = "like'%" + ColContent + "%'";
-                        break;
-                    case "8":
-                        com = "like'%" + ColContent + "'";
-                        break;
-                    case "9":
-                        com = "like'" + ColContent + "%'";
-                        break;
-                    case "10":
-                        com = "not like'%" + ColContent + "%'";
-                        break;
-                    default:
-                        com = "" + Comparator + "'" + ColContent + "'";
-                        break;
-                }
-                sWhere += " and " + ColName + " " + com;
-            }
-            if (ColName1 != 0 && Comparator1 != 0) {
-                var com1 = "";
-                switch (Comparator1) {
-                    case "7":
-                        com1 = "like'%" + ColContent1 + "%'";
-                        break;
-                    case "8":
-                        com1 = "like'%" + ColContent1 + "'";
-                        break;
-                    case "9":
-                        com1 = "like'" + ColContent1 + "%'";
-                        break;
-                    case "10":
-                        com1 = "not like'%" + ColContent1 + "%'";
-                        break;
-                    default:
-                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
-                        break;
-                }
-                sWhere += " and " + ColName1 + " " + com1;
-            }
-            if (ColName2 != 0 && Comparator2 != 0) {
-                var com2 = "";
-                switch (Comparator2) {
-                    case "7":
-                        com2 = "like'%" + ColContent2 + "%'";
-                        break;
-                    case "8":
-                        com2 = "like'%" + ColContent2 + "'";
-                        break;
-                    case "9":
-                        com2 = "like'" + ColContent2 + "%'";
-                        break;
-                    case "10":
-                        com2 = "not like'%" + ColContent2 + "%'";
-                        break;
-                    default:
-                        com2 = "" + Comparator2 + "'" + ColContent2 + "'";
-                        break;
-                }
-                sWhere += " and " + ColName2 + " " + com2;
-            }
-
-
+            var HProject = $("#HProject").val();//椤圭洰鍙�
+            var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+            var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+          
             sWhere = {
                 HBeginDate: HBeginDate
                 ,HEndDate: HEndDate
                 , HMaterID: HMaterID
                 , HBatchNo: HBatchNo
+                , HProject: HProject
+                , HBatchWork: HBatchWork
+                , HDivisionName: HDivisionName
             }
-            //set_InitGrid();
             get_Display(JSON.stringify(sWhere));
             sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
         }
 
         function set_ClearQuery() {
-            $("#HICMOBillNo").val("");
-            $("#HBardCode").val("");
-            $("#HProcExchBillNo").val("");
-            $("#ColContent1").val("");
-            $("#ColName1").val("0");
-            $("#Comparator1").val("0");
-            $("#ColContent2").val("");
-            $("#ColName2").val("0");
-            $("#Comparator2").val("0");
-            $("#ColContent").val("");
-            $("#ColName").val("0");
-            $("#Comparator").val("0");
+            $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
+            $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
+            $("#HMaterID").val("0");
+            $("#HBatchNo").val("");
+            $("#HProject").val("");
+            $("#HBatchWork").val("");
+            $("#HDivisionName").val("");          
             form.render('select');
 
             sWhere = "";
         }
 
+        //#region 鑾峰彇椤圭洰鍙�
+        function Get_HProject() {
+            //鑾峰彇椤圭洰鍙�
+            var HProjectList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HProject").append(HProjectList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
+        //#region 鑾峰彇浜嬩笟閮�
+        function GetGy_Division() {
+            //鑾峰彇浜嬩笟閮�
+            var HDivisionList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HDivisionName").append(HDivisionList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
+
         //闅愯棌鍒楄缃�
         function get_HideColumn() {
             var colName = "";
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityMonthSumReport.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityMonthSumReport.html"
index 8c64471..17f2bcf 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityMonthSumReport.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityMonthSumReport.html"
@@ -59,6 +59,32 @@
                                         </select>
                                     </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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                            <option value="">璇烽�夋嫨</option>
+                                            <option value="1">閲忎骇</option>
+                                            <option value="0">闈為噺浜�</option>
+                                        </select>
+                                    </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </div>
+                                </div>
                                 <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                     <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                 </button>
@@ -131,6 +157,8 @@
                 //set_StockOrg();
                 //鍒濆鍖栬〃鍗曟椂闂�
                 set_InitDate();
+                Get_HProject(); //鑾峰彇椤圭洰鍙�
+                GetGy_Division();//鑾峰彇浜嬩笟閮�
                 //鍒濆鍖栬〃鏍�
                 set_InitGrid();
 
@@ -456,8 +484,23 @@
 
             //蹇�熸煡璇�
             function get_FastQuery() {
-                sDate = $("#HDate").val();                  //鏃ユ湡
-                get_Display(sWhere);
+                //鏂囨湰妗嗕负绌烘椂锛屾竻绌哄搴擨D
+                if ($("#HDeptName").val() == '') {
+                    $("#HDeptID").val("0");
+                }
+                var HDeptID = $("#HDeptID").val()
+                var HYear = $("#HDate").val(); //鏃ユ湡
+                var HProject = $("#HProject").val();//椤圭洰鍙�
+                var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+                var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+                sWhere = {
+                    HYear: HYear
+                    , HDeptID: HDeptID
+                    , HProject: HProject
+                    , HBatchWork: HBatchWork
+                    , HDivisionName: HDivisionName
+                }
+                get_Display(JSON.stringify(sWhere));
                 //鍔犺浇鏌辩姸鍥�
                 set_Graphics();
             }
@@ -465,20 +508,13 @@
             //#endregion
 
             //#region 鍒楄〃鍒锋柊
-            function get_Display(sWhere) {
-                var HDate = sDate;          //鏃ユ湡
-                //鏂囨湰妗嗕负绌烘椂锛屾竻绌哄搴擨D
-                if ($("#HDeptName").val() == '') {
-                    $("#HDeptID").val("0");
-                }
-                var HDeptID = $("#HDeptID").val()
-
+            function get_Display(sWhere) {               
                 var ajaxLoad = layer.load();
                 $.ajax({
                     type: "GET",
                     url: GetWEBURL() + '/QC_QualityReportsController/GetQC_QualityMonthSumReport_Json',
                     async: false,    //async鐢ㄤ簬鎺у埗锛坒alse锛夊悓姝ュ拰锛坱rue锛夊紓姝ワ紝榛樿鐨勬槸true锛屽嵆璇锋眰榛樿鐨勬槸寮傛璇锋眰
-                    data: { "HYear": HDate, "HDeptID": HDeptID },
+                    data: { "sWhere": sWhere },
                     success: function (data1) {
                         if (data1.count == 1) {
                             var data = [];
@@ -800,6 +836,56 @@
             ////#endregion
             //#endregion
 
+            //#region 鑾峰彇椤圭洰鍙�
+            function Get_HProject() {
+                //鑾峰彇椤圭洰鍙�
+                var HProjectList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HProject").append(HProjectList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
+            //#region 鑾峰彇浜嬩笟閮�
+            function GetGy_Division() {
+                //鑾峰彇浜嬩笟閮�
+                var HDivisionList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HDivisionName").append(HDivisionList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
         });
 
         //#endregion
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityStatisticsDailyReport.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityStatisticsDailyReport.html"
index 7aa6726..4606c0d 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityStatisticsDailyReport.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityStatisticsDailyReport.html"
@@ -26,11 +26,7 @@
                     <form class="layui-form" action="" lay-filter="component-form-group">
                         <div class="layui-collapse">
                             <div class="layui-colla-item">
-                                <div class="layui-colla-title layui-inline">
-                                    <div class="layui-inline">
-                                        <span>鏇村</span>
-                                    </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: 85px;">
@@ -65,7 +61,7 @@
                                             <!--鍔ㄦ�佹覆鏌撳勾浠�-->
                                         </select>
                                     </div>
-                                </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: 125px;">
@@ -78,90 +74,31 @@
                                     <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">閲嶇疆</button>
-                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
-                                    <div class="layui-row" style="margin-top:10px;margin-left:5%;">
-
-                                    </div>
-                                    <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px ">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
+                                <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
+                                    <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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                                <option value="">璇烽�夋嫨</option>
+                                                <option value="1">閲忎骇</option>
+                                                <option value="0">闈為噺浜�</option>
                                             </select>
                                         </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
-                                        </div>
                                     </div>
-                                    <div class="layui-row" style=" margin-top: 10px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
+                                    <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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
                                             </select>
                                         </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
-                                        </div>
                                     </div>
-
-                                    <div class="layui-row" style=" margin-top: 10px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
+                                    <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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
                                             </select>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
                                         </div>
                                     </div>
                                 </div>
@@ -250,7 +187,8 @@
             Year();
             DeptName();
             Organ();
-            //set_InitGrid();
+            Get_HProject(); //鑾峰彇椤圭洰鍙�
+            GetGy_Division();//鑾峰彇浜嬩笟閮�
             //鏌ヨ
             get_FastQuery();
         }
@@ -397,87 +335,17 @@
             var HMonth = $("#HMonth").val();
             var HDeptName = $("#HDeptName").val();
             var HOrgID = $("#HOrgID").val();
-
-            var ColName = $("#ColName").val();//澶嶉�夋
-            var Comparator = $("#Comparator").val()
-            var ColContent = $("#ColContent").val();
-            var ColName1 = $("#ColName1").val();//澶嶉�夋
-            var Comparator1 = $("#Comparator1").val()
-            var ColContent1 = $("#ColContent1").val();
-            var ColName2 = $("#ColName2").val();//澶嶉�夋
-            var Comparator2 = $("#Comparator2").val()
-            var ColContent2 = $("#ColContent2").val();
-
-            if (ColName != 0 && Comparator != 0) {
-                var com = "";
-                switch (Comparator) {
-                    case "7":
-                        com = "like'%" + ColContent + "%'";
-                        break;
-                    case "8":
-                        com = "like'%" + ColContent + "'";
-                        break;
-                    case "9":
-                        com = "like'" + ColContent + "%'";
-                        break;
-                    case "10":
-                        com = "not like'%" + ColContent + "%'";
-                        break;
-                    default:
-                        com = "" + Comparator + "'" + ColContent + "'";
-                        break;
-                }
-                sWhere += " and " + ColName + " " + com;
-            }
-            if (ColName1 != 0 && Comparator1 != 0) {
-                var com1 = "";
-                switch (Comparator1) {
-                    case "7":
-                        com1 = "like'%" + ColContent1 + "%'";
-                        break;
-                    case "8":
-                        com1 = "like'%" + ColContent1 + "'";
-                        break;
-                    case "9":
-                        com1 = "like'" + ColContent1 + "%'";
-                        break;
-                    case "10":
-                        com1 = "not like'%" + ColContent1 + "%'";
-                        break;
-                    default:
-                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
-                        break;
-                }
-                sWhere += " and " + ColName1 + " " + com1;
-            }
-            if (ColName2 != 0 && Comparator2 != 0) {
-                var com2 = "";
-                switch (Comparator2) {
-                    case "7":
-                        com2 = "like'%" + ColContent2 + "%'";
-                        break;
-                    case "8":
-                        com2 = "like'%" + ColContent2 + "'";
-                        break;
-                    case "9":
-                        com2 = "like'" + ColContent2 + "%'";
-                        break;
-                    case "10":
-                        com2 = "not like'%" + ColContent2 + "%'";
-                        break;
-                    default:
-                        com2 = "" + Comparator2 + "'" + ColContent2 + "'";
-                        break;
-                }
-                sWhere += " and " + ColName2 + " " + com2;
-            }
-         
-
+            var HProject = $("#HProject").val();//椤圭洰鍙�
+            var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+            var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
             sWhere = {
                 HYear: HYear
                 , HMonth: HMonth
                 , HDeptName: HDeptName
                 , HOrgID: HOrgID
+                , HProject: HProject
+                , HBatchWork: HBatchWork
+                , HDivisionName: HDivisionName
             }
             set_InitGrid();
             get_Display(JSON.stringify(sWhere));
@@ -488,15 +356,9 @@
             $("#HICMOBillNo").val("");
             $("#HBardCode").val("");
             $("#HProcExchBillNo").val("");
-            $("#ColContent1").val("");
-            $("#ColName1").val("0");
-            $("#Comparator1").val("0");
-            $("#ColContent2").val("");
-            $("#ColName2").val("0");
-            $("#Comparator2").val("0");
-            $("#ColContent").val("");
-            $("#ColName").val("0");
-            $("#Comparator").val("0");
+            $("#HProject").val("");
+            $("#HBatchWork").val("0");
+            $("#HDivisionName").val("0");           
             form.render('select');
 
             sWhere = "";
@@ -636,6 +498,56 @@
         }
         //#endregion
 
+        //#region 鑾峰彇椤圭洰鍙�
+        function Get_HProject() {
+            //鑾峰彇椤圭洰鍙�
+            var HProjectList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HProject").append(HProjectList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
+        //#region 鑾峰彇浜嬩笟閮�
+        function GetGy_Division() {
+            //鑾峰彇浜嬩笟閮�
+            var HDivisionList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HDivisionName").append(HDivisionList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
         //浠ヤ笂鏄痩ayui妯″潡
     });
 
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_RegistrationForTestingReport.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_RegistrationForTestingReport.html"
index 4de6512..d17a999 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_RegistrationForTestingReport.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_RegistrationForTestingReport.html"
@@ -63,93 +63,34 @@
                                     <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">閲嶇疆</button>
-                                <!--<div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
-                                    <div class="layui-row" style="margin-top:10px;margin-left:5%;">
-
-                                    </div>
-                                    <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px ">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
+                                <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
+                                    <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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                                <option value="">璇烽�夋嫨</option>
+                                                <option value="1">閲忎骇</option>
+                                                <option value="0">闈為噺浜�</option>
                                             </select>
                                         </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
-                                        </div>
                                     </div>
-                                    <div class="layui-row" style=" margin-top: 10px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
+                                    <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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
                                             </select>
                                         </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
-                                        </div>
                                     </div>
-
-                                    <div class="layui-row" style=" margin-top: 10px;">
-                                        <div class="layui-inline">
-                                            <label class="layui-form-label">杩囨护</label>
-                                            <div class="layui-input-block">
-                                                <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
-                                                </select>
-                                            </div>
-                                        </div>
-                                        <div class="layui-inline">
-                                            <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
-                                                <option value="0" selected="selected"></option>
-                                                <option value="=">=</option>
-                                                <option value=">=">>=</option>
-                                                <option value=">">></option>
-                                                <option value="<="><=</option>
-                                                <option value="<"><</option>
-                                                <option value="<>"><></option>
-                                                <option value="7">鍖呭惈</option>
-                                                <option value="8">宸﹀寘鍚�</option>
-                                                <option value="9">鍙冲寘鍚�</option>
-                                                <option value="10">涓嶅寘鍚�</option>
+                                    <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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                                <!--鍔ㄦ�佹覆鏌撶粍缁�-->
                                             </select>
                                         </div>
-                                        <div class="layui-inline">
-                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
-                                        </div>
                                     </div>
-                                </div>-->
+                                </div>
                             </div>
                         </div>
                         <div class="layui-tab layui-tab-card">
@@ -239,7 +180,8 @@
         function set_ClearBill() {
             $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
             $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
-            //set_InitGrid();
+            Get_HProject(); //鑾峰彇椤圭洰鍙�
+            GetGy_Division();//鑾峰彇浜嬩笟閮�
             //鏌ヨ
             get_FastQuery();
         }
@@ -398,110 +340,88 @@
             var HMaterID = $("#HMaterID").val();
             var HBatchNo = $("#HBatchNo").val();
 
-            var ColName = $("#ColName").val();//澶嶉�夋
-            var Comparator = $("#Comparator").val()
-            var ColContent = $("#ColContent").val();
-            var ColName1 = $("#ColName1").val();//澶嶉�夋
-            var Comparator1 = $("#Comparator1").val()
-            var ColContent1 = $("#ColContent1").val();
-            var ColName2 = $("#ColName2").val();//澶嶉�夋
-            var Comparator2 = $("#Comparator2").val()
-            var ColContent2 = $("#ColContent2").val();
-
-            if (ColName != 0 && Comparator != 0) {
-                var com = "";
-                switch (Comparator) {
-                    case "7":
-                        com = "like'%" + ColContent + "%'";
-                        break;
-                    case "8":
-                        com = "like'%" + ColContent + "'";
-                        break;
-                    case "9":
-                        com = "like'" + ColContent + "%'";
-                        break;
-                    case "10":
-                        com = "not like'%" + ColContent + "%'";
-                        break;
-                    default:
-                        com = "" + Comparator + "'" + ColContent + "'";
-                        break;
-                }
-                sWhere += " and " + ColName + " " + com;
-            }
-            if (ColName1 != 0 && Comparator1 != 0) {
-                var com1 = "";
-                switch (Comparator1) {
-                    case "7":
-                        com1 = "like'%" + ColContent1 + "%'";
-                        break;
-                    case "8":
-                        com1 = "like'%" + ColContent1 + "'";
-                        break;
-                    case "9":
-                        com1 = "like'" + ColContent1 + "%'";
-                        break;
-                    case "10":
-                        com1 = "not like'%" + ColContent1 + "%'";
-                        break;
-                    default:
-                        com1 = "" + Comparator1 + "'" + ColContent1 + "'";
-                        break;
-                }
-                sWhere += " and " + ColName1 + " " + com1;
-            }
-            if (ColName2 != 0 && Comparator2 != 0) {
-                var com2 = "";
-                switch (Comparator2) {
-                    case "7":
-                        com2 = "like'%" + ColContent2 + "%'";
-                        break;
-                    case "8":
-                        com2 = "like'%" + ColContent2 + "'";
-                        break;
-                    case "9":
-                        com2 = "like'" + ColContent2 + "%'";
-                        break;
-                    case "10":
-                        com2 = "not like'%" + ColContent2 + "%'";
-                        break;
-                    default:
-                        com2 = "" + Comparator2 + "'" + ColContent2 + "'";
-                        break;
-                }
-                sWhere += " and " + ColName2 + " " + com2;
-            }
-
-
+            var HProject = $("#HProject").val();//椤圭洰鍙�
+            var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+            var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+        
             sWhere = {
                 HBeginDate: HBeginDate
                 ,HEndDate: HEndDate
                 , HMaterID: HMaterID
                 , HBatchNo: HBatchNo
+                , HProject: HProject
+                , HBatchWork: HBatchWork
+                , HDivisionName: HDivisionName
             }
-            //set_InitGrid();
             get_Display(JSON.stringify(sWhere));
             sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
         }
 
         function set_ClearQuery() {
-            $("#HICMOBillNo").val("");
-            $("#HBardCode").val("");
-            $("#HProcExchBillNo").val("");
-            $("#ColContent1").val("");
-            $("#ColName1").val("0");
-            $("#Comparator1").val("0");
-            $("#ColContent2").val("");
-            $("#ColName2").val("0");
-            $("#Comparator2").val("0");
-            $("#ColContent").val("");
-            $("#ColName").val("0");
-            $("#Comparator").val("0");
+            $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
+            $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
+            $("#HMaterID").val("0");
+            $("#HBatchNo").val("");
+            $("#HProject").val("");
+            $("#HBatchWork").val("");
+            $("#HDivisionName").val("");
             form.render('select');
 
             sWhere = "";
         }
 
+
+        //#region 鑾峰彇椤圭洰鍙�
+        function Get_HProject() {
+            //鑾峰彇椤圭洰鍙�
+            var HProjectList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HProject").append(HProjectList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
+        //#region 鑾峰彇浜嬩笟閮�
+        function GetGy_Division() {
+            //鑾峰彇浜嬩笟閮�
+            var HDivisionList = '<option value="" style="color:red;" selected></option>';
+            $.ajax({
+                type: "get",
+                url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                async: false,
+                data: { "HOrgID": sessionStorage["OrganizationID"] },
+                success: function (result) {
+                    if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                        var data = result.data;
+                        for (var i = 0; i < data.length; i++) {
+                            HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                        }
+                        $("#HDivisionName").append(HDivisionList);
+                        form.render('select');
+
+                    }
+                    layer.closeAll("loading");
+                }
+            })
+        }
+        //#endregion
+
+
         //闅愯棌鍒楄缃�
         function get_HideColumn() {
             var colName = "";
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_SkillExamMonthSumReport.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_SkillExamMonthSumReport.html"
index 3df14e2..406801b 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_SkillExamMonthSumReport.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_SkillExamMonthSumReport.html"
@@ -51,7 +51,32 @@
                                         </button>
                                     </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="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                            <option value="">璇烽�夋嫨</option>
+                                            <option value="1">閲忎骇</option>
+                                            <option value="0">闈為噺浜�</option>
+                                        </select>
+                                    </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </div>
+                                </div>
                                 <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                     <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                 </button>
@@ -124,6 +149,8 @@
                 //set_StockOrg();
                 //鍒濆鍖栬〃鍗曟椂闂�
                 set_InitDate();
+                Get_HProject(); //鑾峰彇椤圭洰鍙�
+                GetGy_Division();//鑾峰彇浜嬩笟閮�
                 //鍒濆鍖栬〃鏍�
                 set_InitGrid();
 
@@ -449,8 +476,23 @@
 
             //蹇�熸煡璇�
             function get_FastQuery() {
-                sDate = $("#HDate").val();                  //鏃ユ湡
-                get_Display(sWhere);
+                 //鏂囨湰妗嗕负绌烘椂锛屾竻绌哄搴擨D
+                if ($("#HDeptName").val() == '') {
+                    $("#HDeptID").val("0");
+                }
+                var HDeptID = $("#HDeptID").val()
+                var HYear = $("#HDate").val(); //鏃ユ湡
+                var HProject = $("#HProject").val();//椤圭洰鍙�
+                var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
+                var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
+                sWhere = {
+                    HYear: HYear
+                    ,HDeptID: HDeptID
+                    , HProject: HProject
+                    , HBatchWork: HBatchWork
+                    , HDivisionName: HDivisionName
+                }
+                get_Display(JSON.stringify(sWhere));
                 //鍔犺浇鏌辩姸鍥�
                 set_Graphics();
             }
@@ -459,19 +501,12 @@
 
             //#region 鍒楄〃鍒锋柊
             function get_Display(sWhere) {
-                var HDate = sDate;          //鏃ユ湡
-                //鏂囨湰妗嗕负绌烘椂锛屾竻绌哄搴擨D
-                if ($("#HDeptName").val() == '') {
-                    $("#HDeptID").val("0");
-                }
-                var HDeptID = $("#HDeptID").val()
-
                 var ajaxLoad = layer.load();
                 $.ajax({
                     type: "GET",
                     url: GetWEBURL() + '/QC_QualityReportsController/GetQC_SkillExamMonthSumReport_Json',
                     async: false,    //async鐢ㄤ簬鎺у埗锛坒alse锛夊悓姝ュ拰锛坱rue锛夊紓姝ワ紝榛樿鐨勬槸true锛屽嵆璇锋眰榛樿鐨勬槸寮傛璇锋眰
-                    data: { "HYear": HDate, "HDeptID": HDeptID },
+                    data: { "sWhere": sWhere},
                     success: function (data1) {
                         if (data1.count == 1) {
                             var data = [];
@@ -806,6 +841,56 @@
             ////#endregion
             //#endregion
 
+            //#region 鑾峰彇椤圭洰鍙�
+            function Get_HProject() {
+                //鑾峰彇椤圭洰鍙�
+                var HProjectList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HProject").append(HProjectList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
+            //#region 鑾峰彇浜嬩笟閮�
+            function GetGy_Division() {
+                //鑾峰彇浜嬩笟閮�
+                var HDivisionList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_Gy_Division",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HDivisionList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HDivisionName").append(HDivisionList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+            //#endregion
+
         });
 
         //#endregion
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/Sc_StationOutBil_HProc.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/Sc_StationOutBil_HProc.html"
index f08b48a..778deaf 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/Sc_StationOutBil_HProc.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/Sc_StationOutBil_HProc.html"
@@ -61,6 +61,14 @@
                                     </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
+                                            <!--鍔ㄦ�佹覆鏌撶粍缁�-->
+                                        </select>
+                                    </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="HDivisionName" id="HDivisionName" class=" ForFilteringSchemes" lay-verify="HDivisionName">
@@ -69,24 +77,46 @@
                                     </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="HMaterName" id="HMaterName">
-                                    </div>
-                                </div>
-                                <div class="layui-inline">
-                                    <label class="layui-form-label" style="width: 85px;">宸ュ簭鍚嶇О</label>
-                                    <div class="layui-input-block">
-                                        <input type="text" class="layui-input" lay-verify="HProcName" name="HProcName" id="HProcName" value="" style="background-color: #efefef4d; width: 65%; display: inline-block;" readonly>
-                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHProc" id="btnHProc" style="padding: 0 10px;float: right;margin-right: 3px;">
-                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
-                                        </button>
+                                    <label class="layui-form-label" style="width: 85px;">鏄惁閲忎骇</label>
+                                    <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
+                                        <select name="HBatchWork" id="HBatchWork" lay-verify="HBatchWork">
+                                            <option value="">璇烽�夋嫨</option>
+                                            <option value="1">閲忎骇</option>
+                                            <option value="0">闈為噺浜�</option>
+                                        </select>
                                     </div>
                                 </div>
                                 <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                     <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">閲嶇疆</button>                                
+                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button>
+                                <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;">
+                                    <div class="layui-inline">
+                                        <label class="layui-form-label">閮ㄩ棬</label>
+                                        <div class="layui-input-block">
+                                            <input type="text" class="layui-input" name="HDeptName" id="HDeptName" lay-verify="HDeptName" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
+                                            <input type="hidden" class="layui-input" name="HDeptID" lay-verify="HDeptID" id="HDeptID" value="0">
+                                            <button type="button" lay-submit="" class="layui-btn" lay-filter="btnHDept" style="width:20px;">
+                                                <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" style="width: 85px;">鐗╂枡鍚嶇О</label>
+                                        <div class="layui-input-block" style="margin-left: 120px;">
+                                            <input type="text" class="layui-input" name="HMaterName" id="HMaterName">
+                                        </div>
+                                    </div>
+                                    <div class="layui-inline">
+                                        <label class="layui-form-label" style="width: 85px;">宸ュ簭鍚嶇О</label>
+                                        <div class="layui-input-block">
+                                            <input type="text" class="layui-input" lay-verify="HProcName" name="HProcName" id="HProcName" value="" style="background-color: #efefef4d; width: 65%; display: inline-block;" readonly>
+                                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHProc" id="btnHProc" style="padding: 0 10px;float: right;margin-right: 3px;">
+                                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
+                                            </button>
+                                        </div>
+                                    </div>
+                                </div>
                             </div>
                         </div>
                         <div>
@@ -176,6 +206,38 @@
             form.on('submit(btnReSearch)', function (data) {
                 set_ClearQuery();
             });
+            //#region 閫夋嫨閮ㄩ棬鎸夐挳
+            form.on('submit(btnHDept)', function () {
+                layer.open({
+                    type: 2
+                    , skin: "layui-layer-rim"   //鍔犱笂杈规
+                    , title: "閮ㄩ棬鍒楄〃"         //鏍囬
+                    , closeBtn: 1               //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡
+                    , shift: 2                  //寮瑰嚭鍔ㄧ敾
+                    , area: ["90%", "90%"]      //绐椾綋澶у皬
+                    , maxmin: true              //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀�
+                    , content: ['../../鍩虹璧勬枡/鍏敤鍩虹璧勬枡/Gy_DepartmentList.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("璇烽�夋嫨涓�鏉℃暟鎹�");
+                        }
+                        $("#HDeptName").val(checkStatus.data[0].閮ㄩ棬鍚嶇О);
+                        $("#HDeptID").val(checkStatus.data[0].HItemID);
+                        layer.close(index); //鍏抽棴寮圭獥  瀹冭幏鍙栫殑濮嬬粓鏄渶鏂板脊鍑虹殑鏌愪釜灞傦紝鍊兼槸鐢眑ayer鍐呴儴鍔ㄦ�侀�掑璁$畻鐨�
+                    }
+                    , btn2: function (index, layero) { }
+                    , end: function () {
+                        //鍒锋柊鍒楄〃
+                        get_FastQuery();
+                    }
+                })
+            });
+            //#endregion
             //#endregion
 
             //#region 鐐瑰嚮琛岄�変腑楂樹寒
@@ -203,6 +265,7 @@
             // 鍒濆鍖栫晫闈�
             function set_ClearBill() {
                 Year(); //鍒濆鍖栧勾
+                Get_HProject(); //鑾峰彇椤圭洰鍙�
                 GetGy_Division();//鑾峰彇浜嬩笟閮�
                 set_InitGrid(); //鍒濆鍖栬〃鏍�
                 get_FastQuery();
@@ -261,6 +324,31 @@
                 })
             }
             //#endregion
+
+            //#region 鑾峰彇椤圭洰鍙�
+            function Get_HProject() {
+                //鑾峰彇椤圭洰鍙�
+                var HProjectList = '<option value="" style="color:red;" selected></option>';
+                $.ajax({
+                    type: "get",
+                    url: GetWEBURL() + "/Gy_Material/Get_HProject",
+                    async: false,
+                    data: { "HOrgID": sessionStorage["OrganizationID"] },
+                    success: function (result) {
+                        if (result.count == 1) { // 璇存槑楠岃瘉鎴愬姛浜嗭紝
+                            var data = result.data;
+                            for (var i = 0; i < data.length; i++) {
+                                HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
+                            }
+                            $("#HProject").append(HProjectList);
+                            form.render('select');
+
+                        }
+                        layer.closeAll("loading");
+                    }
+                })
+            }
+        //#endregion
 
             //鏌ヨ
             function get_Display(sWhere) {
@@ -342,16 +430,23 @@
             function get_FastQuery() {
                 var HYear = $("#HYear").val();
                 var HMonth = $("#HMonth").val();
+                var HProject = $("#HProject").val();//椤圭洰鍙�
+                var HBatchWork = $("#HBatchWork").val();//鏄惁閲忎骇
                 var HDivisionName = $("#HDivisionName").val();//浜嬩笟閮�
                 var HProcName = $("#HProcName").val();
-                var HMaterName = $("#HMaterName").val();             
-                             
+                var HMaterName = $("#HMaterName").val();
+                var HDeptID = $("#HDeptID").val();
+              
+
                 sWhere = {
                     HYear: HYear
                     , HMonth: HMonth
                     , HDivisionName: HDivisionName
                     , HProcName: HProcName
                     , HMaterName: HMaterName
+                    , HProject: HProject
+                    , HBatchWork: HBatchWork
+                    , HDeptID: HDeptID
                 }
                 get_Display(JSON.stringify(sWhere));
                 //鍔犺浇鏌辩姸鍥�
@@ -367,7 +462,8 @@
                 $("#HProcName").val("");
                 $("#HMaterName").val("");
                 $("#HDivisionName").val("");
-                $("#btnSearch").click();               
+                $("#HProject").val("");
+                $("#HBatchWork").val("");            
                 form.render('select');
 
                 sWhere = "";
@@ -427,6 +523,7 @@
                 var HBadCount = [];//涓嶈壇鏁伴噺
                 var HBackWorkQty = [];//杩斿伐鏁�
                 var FistPass = [];//涓�娆″悎鏍�
+                var HProcTarGetVal = [];//鍚勫伐搴忕洰鏍囧��
                 var Pass = [];//鍚堟牸
                 var HTitle = "鍚勫伐搴忚秼鍔垮浘";//鍥惧舰鏍囬
                 if (option.data.length > 0) {                 
@@ -442,7 +539,7 @@
                         HBackWorkQty.push(option.data[i].杩斿伐鏁�);
                         FistPass.push((option.data[i].涓�娆″悎鏍肩巼 == null ? '0.00%' : option.data[i].涓�娆″悎鏍肩巼 ).replace('%', ''));
                         Pass.push((option.data[i].鍚堟牸鐜� == null ? '0.00%' : option.data[i].鍚堟牸鐜�).replace('%', ''))
-
+                        HProcTarGetVal.push(option.data[i].鍚勫伐搴忕洰鏍囧��);
                     }
                 }
                 option_ZZT = {
@@ -472,7 +569,7 @@
 
                     },
                     legend: {
-                        data: ['鐢熶骇鎬绘暟', '鑹搧鏁�', '涓嶈壇鏁�','杩斿伐鏁�','涓�娆″悎鏍肩巼','鍚堟牸鐜�'],
+                        data: ['鐢熶骇鎬绘暟', '鑹搧鏁�', '涓嶈壇鏁�', '杩斿伐鏁�', '涓�娆″悎鏍肩巼', '鍚堟牸鐜�','鍚勫伐搴忕洰鏍囧��'],
                         top: 'bottom',  // 灏嗗浘渚嬫斁缃湪鍥捐〃鐨勪笅鏂�
                         left: 'center'  // 鎴栬�� 'right'锛屾牴鎹渶瑕佽皟鏁存按骞充綅缃�
                     },                   
@@ -641,6 +738,19 @@
                             lineStyle: {
                                 color: '#1E90FF' // 璁剧疆鎶樼嚎鍥捐摑鑹�
                             }
+                        },
+                        {
+                            name: '鍚勫伐搴忕洰鏍囧��',
+                            type: 'line',
+                            yAxisIndex: 1, // 浣跨敤绗簩涓� yAxis 鏄剧ず鐧惧垎姣�
+                            data: HProcTarGetVal,
+                            label: {
+                                show: true,
+                                formatter: '{c}%'
+                            },
+                            lineStyle: {
+                                color: '#FF0000' // 璁剧疆鎶樼嚎鍥捐摑鑹�
+                            }
                         }
                     ]
                 };
diff --git "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\234\210\345\272\246\347\233\256\346\240\207\345\215\225/QC_MonthTarGetBill.html" "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\234\210\345\272\246\347\233\256\346\240\207\345\215\225/QC_MonthTarGetBill.html"
index 2b3e7bf..5e47fd2 100644
--- "a/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\234\210\345\272\246\347\233\256\346\240\207\345\215\225/QC_MonthTarGetBill.html"
+++ "b/WebTM/views/\350\264\250\351\207\217\347\256\241\347\220\206/\350\264\250\351\207\217\346\234\210\345\272\246\347\233\256\346\240\207\345\215\225/QC_MonthTarGetBill.html"
@@ -92,19 +92,19 @@
                                         <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="HProcTrapTarGetVal" id="HProcTrapTarGetVal" autocomplete="off" value="0" >
+                                                <input class="layui-input" name="HProcTrapTarGetVal" id="HProcTrapTarGetVal" autocomplete="off" value="0">
                                             </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="HProcKPITarGetVal" id="HProcKPITarGetVal" autocomplete="off" value="0" >
+                                                <input class="layui-input" name="HProcKPITarGetVal" id="HProcKPITarGetVal" autocomplete="off" value="0">
                                             </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="HProcOmitTarGetVal" id="HProcOmitTarGetVal" autocomplete="off" value="0" >
+                                                <input class="layui-input" name="HProcOmitTarGetVal" id="HProcOmitTarGetVal" autocomplete="off" value="0">
                                             </div>
                                         </div>
                                     </div>
@@ -115,6 +115,14 @@
                                                 <input class="layui-input" name="HProcPPMTarGetVal" id="HProcPPMTarGetVal" autocomplete="off" value="0">
                                             </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="HProcTarGetVal" id="HProcTarGetVal" autocomplete="off" value="0">
+                                            </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">
@@ -560,6 +568,7 @@
                             , "HProcKPITarGetVal": tableMain["鍒剁▼缁╂晥鐩爣鍊�"]
                             , "HProcOmitTarGetVal": tableMain["鍒剁▼璐ㄩ噺闂ㄩ�冮�镐笂闄愬��"]
                             , "HProcPPMTarGetVal": tableMain["PPM鐩爣鍊�"]
+                            , "HProcTarGetVal": tableMain["鍚勫伐搴忕洰鏍囧��"]
                             , "HDeptName": tableMain["閮ㄩ棬鍚嶇О"]// 璁剧疆鈥滈儴闂ㄢ�濆悕绉板瓧娈电殑鍊笺��
                         });
                         //缁勭粐鐨勫�糎OrgID鍙樺寲锛岄噸鏂版覆鏌�
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 5431b90..3de0a9c 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"
@@ -526,7 +526,7 @@
                                         <div class="layui-col-xs4 layui-inline">
                                             <label class="layui-form-label">涓嶈壇鏁伴噺</label>
                                             <div class="layui-input-inline">
-                                                <input type="text" class="layui-input" value="0" name="" id="">
+                                                <input type="text" class="layui-input" value="0" name="HBadCount" id="HBadCount">
                                             </div>
                                         </div>
                                       
@@ -903,6 +903,7 @@
                                 "HProcNo": data.HProcNo,
                                 "HQty": data.HQty,
                                 "HWasterQty": data.HWasterQty,
+                                "HBadCount": data.HBadCount,
                                 "HWorkTimes": data.HWorkTimes,
                                 "HGroupID": data.HGroupID,
                                 "HGroupName": data.HGroupName,

--
Gitblit v1.9.1