MES-WEB-LayUI.git

			@@ -17,6 +17,7 @@
			<script src="../../../layuiadmin/Scripts/webConfig.js"></script>
			<script src="../../../layuiadmin/PubCustom.js"></script>
			<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
			<script src="../../../layuiadmin/soulTable.slim.js"></script>

			<style type="text/css">
			input.layui-input.layui-unselect {
			@@ -32,11 +33,11 @@
			<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-colla-title layui-inline">
			<div class="layui-inline">
			<span>æ´å¤</span>
			</div>
			</div>-->
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">åæ®å·</label>
			<div class="layui-input-block">
			@@ -55,18 +56,54 @@
			<input type="date" class="layui-input" id="HEndDate" 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" name="HStockOrgName" id="HStockOrgName" style="width:190px;">
			</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 class="layui-colla-content">
			<div class="layui-colla-content">
			<div class="layui-inline">
			<div class="layui-inline">
			<span>å¶ä»æ¡ä»¶></span>
			</div>
			</div>

			</div>-->
			<div class="layui-inline">
			<label class="layui-form-label">é¨é¨ä¿¡æ¯</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HDept" id="HDept" 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" name="HMaterNumber" id="HMaterNumber" 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" name="HModelNumber" id="HModelNumber" 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" name="HWhName" id="HWhName" 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" name="HSupName" id="HSupName" style="width:190px;">
			</div>
			</div>
			</div>
			</div>
			</div>
			<table class="" id="mainTable" lay-filter="mainTable"></table>
			@@ -76,6 +113,8 @@
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view"><i class="layui-icon layui-icon-tips"></i>é¢è§</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>æå°</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-audit"><i class="layui-icon layui-icon-repeat"></i>å®¡æ ¸</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Faudit"><i class="layui-icon layui-icon-refresh"></i>åå®¡æ ¸</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></i>å é¤</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button>
			@@ -95,7 +134,7 @@
			base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			}).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {
			}).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], function () {
			var $ = layui.$
			, admin = layui.admin
			, layer = layui.layer
			@@ -105,6 +144,7 @@
			, laypage = layui.laypage
			, laydate = layui.laydate
			, util = layui.util
			, soulTable = layui.soulTable
			//æ¥è¯¢æ¡ä»¶
			var sWhere = "";
			var option = [];
			@@ -145,77 +185,81 @@
			, height: 'full-50'
			, page: true
			, cellMinWidth: 90
			, limits: [50, 500, 1000, 5000, 10000]
			, limits: [50, 500, 5000, 20000]
			, limit: 50
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			, cols: [[
			{ type: 'checkbox', fixed: 'left' }
			, { field: 'hmainid', title: 'åæ®ID', hide: true }
			, { field: 'æ¥æ', title: 'æ¥æ', width: 125, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>" }
			, { field: 'åæ®å·', title: 'åæ®å·', width: 195 }
			, { field: 'åæ®ç±»å', title: 'åæ®ç±»å', width: 110 }
			, { field: 'å¨å·ä»åºä»£ç ', title: 'å¨å·ä»åºä»£ç ', width: 125 }
			, { field: 'å¨å·ä»åº', title: 'å¨å·ä»åº', width: 125 }
			, { field: 'HSecManagerID', title: 'HSecManagerID', width: 200, hide: true }
			, { field: 'é¢æäººä»£ç ', title: 'é¢æäººä»£ç ', width: 180 }
			, { field: 'é¢æäºº', title: 'é¢æäºº', width: 125 }
			, { field: 'HKeeperID', title: 'HKeeperID', width: 200, hide: true }
			, { field: 'åæäººä»£ç ', title: 'åæäººä»£ç ', width: 180 }
			, { field: 'åæäºº', title: 'åæäºº', width: 125 }
			, { field: 'HDeptID', title: 'HDeptID', width: 200, hide: true }
			, { field: 'é¨é¨ä»£ç ', title: 'é¨é¨ä»£ç ', width: 115 }
			, { field: 'é¨é¨', title: 'é¨é¨', width: 125 }
			, { field: 'æè¦', title: 'æè¦', width: 125 }
			, { field: 'è¡¨å¤´å¤æ³¨', title: 'è¡¨å¤´å¤æ³¨', width: 125 }
			, { field: 'åé¨åæ®å·', title: 'åé¨åæ®å·', width: 115 }
			, { field: 'hsubid', title: 'hsubid', width: 200, hide: true }
			, { field: 'HMaterID', title: 'HMaterID', width: 200, hide: true }
			, { field: 'æ¨¡å·ä»£ç ', title: 'å¨å·ä»£ç ', width: 125 }
			, { field: 'æ¨¡å·åç§°', title: 'å¨å·åç§°', width: 125 }
			, { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 125 }
			, { field: 'Hunitid', title: 'Hunitid', width: 200, hide: true }
			//, { field: 'è®¡éåä½ä»£ç ', title: 'è®¡éåä½ä»£ç ', width: 125 }
			//, { field: 'è®¡éåä½', title: 'è®¡éåä½', width: 125 }
			, { field: 'è°æ¨ç±»å', title: 'è°æ¨ç±»å', width: 100 }
			, { field: 'è°å¥ç»ç»', title: 'è°å¥ç»ç»', width: 125 }
			, { field: 'è°åºç»ç»', title: 'è°åºç»ç»', width: 125 }
			, { field: 'HWHID', title: 'HWHID', width: 200, hide: true }
			, { field: 'è°å¥ä»åºä»£ç ', title: 'è°å¥ä»åºä»£ç ', width: 125 }
			, { field: 'è°å¥ä»åº', title: 'è°å¥ä»åº', width: 125 }
			, { field: 'HSPID', title: 'HSPID', width: 200, hide: true }
			, { field: 'è°å¥ä»ä½ä»£ç ', title: 'è°å¥ä»ä½ä»£ç ', width: 125, hide: true }
			, { field: 'è°å¥ä»ä½', title: 'è°å¥ä»ä½', width: 125, hide: true }
			, { field: 'HSCWHID', title: 'HSCWHID', width: 200, hide: true }
			, { field: 'è°åºä»åºä»£ç ', title: 'è°åºä»åºä»£ç ', width: 125 }
			, { field: 'è°åºä»åº', title: 'è°åºä»åº', width: 125 }
			, { field: 'HSCSPID', title: 'HSCSPID', width: 200, hide: true }
			, { field: 'è°åºä»ä½ä»£ç ', title: 'è°åºä»ä½ä»£ç ', width: 125, hide: true }
			, { field: 'è°åºä»ä½', title: 'è°åºä»ä½', width: 125, hide: true }
			, { field: 'åºåæ°é', title: 'åºåæ°é', width: 125 }
			, { field: 'å®åæ°é', title: 'å®åæ°é', width: 125 }
			, { field: 'åä»·', title: 'åä»·', width: 125 }
			, { field: 'éé¢', title: 'éé¢', width: 125 }
			, { field: 'è®¾è®¡å¯¿å½', title: 'è®¾è®¡å¯¿å½', width: 125 }
			, { field: 'ç´¯ç§¯ä½¿ç¨å¯¿å½', title: 'ç´¯ç§¯ä½¿ç¨å¯¿å½', width: 125 }
			, { field: 'å©ä½å¯¿å½', title: 'å©ä½å¯¿å½', width: 125 }
			, { field: 'å³èæ°é', title: 'å³èæ°é', width: 125 }
			, { field: 'è¡¨ä½å¤æ³¨', title: 'è¡¨ä½å¤æ³¨', width: 125 }
			, { field: 'çº¢èåæ è®°', title: 'çº¢èåæ è®°', width: 125 }
			, { field: 'å¶åäºº', title: 'å¶åäºº', width: 125 }
			, { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ', width: 200, templet: "<div>{{d.å¶åæ¥æ ==null ?'':layui.util.toDateString(d.å¶åæ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" }
			, { field: 'å®¡æ ¸äºº', title: 'å®¡æ ¸äºº', width: 125 }
			, { field: 'å®¡æ ¸æ¥æ', title: 'å®¡æ ¸æ¥æ', width: 200, templet: "<div>{{d.å®¡æ ¸æ¥æ ==null ? '':layui.util.toDateString(d.å®¡æ ¸æ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" }
			, { field: 'ä¿®æ¹äºº', title: 'ä¿®æ¹äºº', width: 125 }
			, { field: 'ä¿®æ¹æ¥æ', title: 'ä¿®æ¹æ¥æ', width: 200, templet: "<div>{{d.ä¿®æ¹æ¥æ ==null ?'':layui.util.toDateString(d.ä¿®æ¹æ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" }
			, { field: 'å³éäºº', title: 'å³éäºº', width: 125 }
			, { field: 'å³éæ¥æ', title: 'å³éæ¥æ', width: 200, templet: "<div>{{d.å³éæ¥æ ==null ?'':layui.util.toDateString(d.å³éæ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" }
			, { field: 'ä½åºäºº', title: 'ä½åºäºº', width: 125 }
			, { field: 'ä½åºæ¥æ', title: 'ä½åºæ¥æ', width: 200, templet: "<div>{{d.ä½åºæ¥æ ==null ?'':layui.util.toDateString(d.ä½åºæ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" }
			, { field: 'è¡å³éäºº', title: 'è¡å³éäºº', width: 125 }
			, { field: 'å³éç±»å', title: 'å³éç±»å', width: 125 }
			, { field: 'æºåä¸»åç ', title: 'æºåä¸»åç ', width: 200, hide: true }
			, { field: 'æºåååç ', title: 'æºåååç ', width: 200, hide: true }
			, { field: 'æºååå·', title: 'æºååå·', width: 125 }
			, { field: 'æºåç±»å', title: 'æºåç±»å', width: 125 }
			, { field: 'hmainid', title: 'åæ®ID', hide: true, sort: true }
			, { field: 'æ¥æ', title: 'æ¥æ', width: 125, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd}}</div>", sort: true }
			, { field: 'åæ®å·', title: 'åæ®å·', width: 195, sort: true }
			, { field: 'åæ®ç±»å', title: 'åæ®ç±»å', width: 110, sort: true }
			, { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ', width: 110, sort: true }
			, { field: 'å¨å·ä»åºä»£ç ', title: 'å¨å·ä»åºä»£ç ', width: 125, sort: true }
			, { field: 'å¨å·ä»åº', title: 'å¨å·ä»åº', width: 125, sort: true }
			, { field: 'HSecManagerID', title: 'HSecManagerID', width: 200, hide: true, sort: true }
			, { field: 'é¢æäººä»£ç ', title: 'é¢æäººä»£ç ', width: 180, sort: true }
			, { field: 'é¢æäºº', title: 'é¢æäºº', width: 125, sort: true }
			, { field: 'HKeeperID', title: 'HKeeperID', width: 200, hide: true, sort: true }
			, { field: 'åæäººä»£ç ', title: 'åæäººä»£ç ', width: 180, sort: true }
			, { field: 'åæäºº', title: 'åæäºº', width: 125, sort: true }
			, { field: 'HDeptID', title: 'HDeptID', width: 200, hide: true, sort: true }
			, { field: 'é¨é¨ä»£ç ', title: 'é¨é¨ä»£ç ', width: 115, sort: true }
			, { field: 'é¨é¨', title: 'é¨é¨', width: 125, sort: true }
			, { field: 'æè¦', title: 'æè¦', width: 125, sort: true }
			, { field: 'è¡¨å¤´å¤æ³¨', title: 'è¡¨å¤´å¤æ³¨', width: 125, sort: true }
			, { field: 'åé¨åæ®å·', title: 'åé¨åæ®å·', width: 115, sort: true }
			, { field: 'hsubid', title: 'hsubid', width: 200, hide: true, sort: true }
			, { field: 'HMaterID', title: 'HMaterID', width: 200, hide: true, sort: true }
			, { field: 'æ¨¡å·ä»£ç ', title: 'å¨å·ä»£ç ', width: 125, sort: true }
			, { field: 'æ¨¡å·åç§°', title: 'å¨å·åç§°', width: 125, sort: true }
			, { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 125, sort: true }
			, { field: 'Hunitid', title: 'Hunitid', width: 200, hide: true, sort: true }
			//, { field: 'è®¡éåä½ä»£ç ', title: 'è®¡éåä½ä»£ç ', width: 125 , sort: true}
			//, { field: 'è®¡éåä½', title: 'è®¡éåä½', width: 125 , sort: true}
			, { field: 'è°æ¨ç±»å', title: 'è°æ¨ç±»å', width: 100, sort: true }
			, { field: 'è°å¥ç»ç»', title: 'è°å¥ç»ç»', width: 125, sort: true }
			, { field: 'è°åºç»ç»', title: 'è°åºç»ç»', width: 125, sort: true }
			, { field: 'HWHID', title: 'HWHID', width: 200, hide: true, sort: true }
			, { field: 'è°å¥ä»åºä»£ç ', title: 'è°å¥ä»åºä»£ç ', width: 125, sort: true }
			, { field: 'è°å¥ä»åº', title: 'è°å¥ä»åº', width: 125, sort: true }
			, { field: 'HSPID', title: 'HSPID', width: 200, hide: true, sort: true }
			, { field: 'è°å¥ä»ä½ä»£ç ', title: 'è°å¥ä»ä½ä»£ç ', width: 125, hide: true, sort: true }
			, { field: 'è°å¥ä»ä½', title: 'è°å¥ä»ä½', width: 125, hide: true, sort: true }
			, { field: 'HSCWHID', title: 'HSCWHID', width: 200, hide: true, sort: true }
			, { field: 'è°åºä»åºä»£ç ', title: 'è°åºä»åºä»£ç ', width: 125, sort: true }
			, { field: 'è°åºä»åº', title: 'è°åºä»åº', width: 125, sort: true }
			, { field: 'HSCSPID', title: 'HSCSPID', width: 200, hide: true, sort: true }
			, { field: 'è°åºä»ä½ä»£ç ', title: 'è°åºä»ä½ä»£ç ', width: 125, hide: true, sort: true }
			, { field: 'è°åºä»ä½', title: 'è°åºä»ä½', width: 125, hide: true, sort: true }
			, { field: 'åºåæ°é', title: 'åºåæ°é', width: 125, sort: true }
			, { field: 'å®åæ°é', title: 'å®åæ°é', width: 125, sort: true }
			, { field: 'åä»·', title: 'åä»·', width: 125, sort: true }
			, { field: 'éé¢', title: 'éé¢', width: 125, sort: true }
			, { field: 'è®¾è®¡å¯¿å½', title: 'è®¾è®¡å¯¿å½', width: 125, sort: true }
			, { field: 'ç´¯ç§¯ä½¿ç¨å¯¿å½', title: 'ç´¯ç§¯ä½¿ç¨å¯¿å½', width: 125, sort: true }
			, { field: 'å©ä½å¯¿å½', title: 'å©ä½å¯¿å½', width: 125, sort: true }
			, { field: 'å³èæ°é', title: 'å³èæ°é', width: 125, sort: true }
			, { field: 'è¡¨ä½å¤æ³¨', title: 'è¡¨ä½å¤æ³¨', width: 125, sort: true }
			, { field: 'çº¢èåæ è®°', title: 'çº¢èåæ è®°', width: 125, sort: true }
			, { field: 'å¶åäºº', title: 'å¶åäºº', width: 125, sort: true }
			, { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ', width: 200, templet: "<div>{{d.å¶åæ¥æ ==null ?'':layui.util.toDateString(d.å¶åæ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>", sort: true }
			, { field: 'å®¡æ ¸äºº', title: 'å®¡æ ¸äºº', width: 125, sort: true }
			, { field: 'å®¡æ ¸æ¥æ', title: 'å®¡æ ¸æ¥æ', width: 200, templet: "<div>{{d.å®¡æ ¸æ¥æ ==null ? '':layui.util.toDateString(d.å®¡æ ¸æ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>", sort: true }
			, { field: 'ä¿®æ¹äºº', title: 'ä¿®æ¹äºº', width: 125, sort: true }
			, { field: 'ä¿®æ¹æ¥æ', title: 'ä¿®æ¹æ¥æ', width: 200, templet: "<div>{{d.ä¿®æ¹æ¥æ ==null ?'':layui.util.toDateString(d.ä¿®æ¹æ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>", sort: true }
			, { field: 'å³éäºº', title: 'å³éäºº', width: 125, sort: true }
			, { field: 'å³éæ¥æ', title: 'å³éæ¥æ', width: 200, templet: "<div>{{d.å³éæ¥æ ==null ?'':layui.util.toDateString(d.å³éæ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>", sort: true }
			, { field: 'ä½åºäºº', title: 'ä½åºäºº', width: 125, sort: true }
			, { field: 'ä½åºæ¥æ', title: 'ä½åºæ¥æ', width: 200, templet: "<div>{{d.ä½åºæ¥æ ==null ?'':layui.util.toDateString(d.ä½åºæ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>", sort: true }
			, { field: 'è¡å³éäºº', title: 'è¡å³éäºº', width: 125, sort: true }
			, { field: 'å³éç±»å', title: 'å³éç±»å', width: 125, sort: true }
			, { field: 'æºåä¸»åç ', title: 'æºåä¸»åç ', width: 200, hide: true, sort: true }
			, { field: 'æºåååç ', title: 'æºåååç ', width: 200, hide: true, sort: true }
			, { field: 'æºååå·', title: 'æºååå·', width: 125, sort: true }
			, { field: 'æºåç±»å', title: 'æºåç±»å', width: 125, sort: true }
			]]
			};
			}
			@@ -334,6 +378,12 @@
			break;
			case 'btn-print': get_PrintReport();
			break;
			//å®¡æ ¸
			case 'btn-audit': get_Audit();
			break;
			//åå®¡æ ¸
			case 'btn-Faudit': get_FAudit();
			break;
			//å·æ°
			case 'get_Refresh': get_Refresh();
			break;
			@@ -383,30 +433,129 @@
			layer.msg('è¯·éæ©ä¸è¡æ°æ®æå°ï¼');
			}
			}


			//å®¡æ ¸
			function get_Audit() {
			var checkStatus = table.checkStatus('mainTable')
			, data = checkStatus.data;
			if (checkStatus.data.length === 1) {
			var InterID = data[0].hmainid.toString();
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "Sc_MouldMoveStockStepOutBill/AuditMouldMoveStockStepOutBill", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
			data: { "HInterID": InterID, "user": sessionStorage["HUserName"], "flag": 1 },
			success: function (result) {
			if (result.count == 1) {
			layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
			var index = layer.getFrameIndex(window.name);
			//å³éå½åframe
			layer.close(index);
			//ä¿®æ¹ä¸ºååå·æ°çé¢
			window.location.reload();
			});

			} else {
			layer.alert(result.code + result.Message, { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			else {
			layer.msg('è¯·éæ©ä¸è¡æ°æ®ï¼');
			}
			}

			//åå®¡æ ¸
			function get_FAudit() {
			var checkStatus = table.checkStatus('mainTable')
			, data = checkStatus.data;
			if (checkStatus.data.length === 1) {
			var InterID = data[0].hmainid.toString();
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "Sc_MouldMoveStockStepOutBill/AuditMouldMoveStockStepOutBill", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
			data: { "HInterID": InterID, "user": sessionStorage["HUserName"], "flag": 2 },
			success: function (result) {
			if (result.count == 1) {
			layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
			var index = layer.getFrameIndex(window.name);
			//å³éå½åframe
			layer.close(index);
			//ä¿®æ¹ä¸ºååå·æ°çé¢
			window.location.reload();
			});

			} else {
			layer.alert(result.code + result.Message, { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			else {
			layer.msg('è¯·éæ©ä¸è¡æ°æ®ï¼');
			}
			}


			//#region å¿«éè¿æ»¤
			function get_FastQuery(table, option) {
			var HDate = $("#HBeginDate").val();//å¼å§æ¥æ
			var HDate1 = $("#HEndDate").val();//ç»ææ¥æ
			var HBillNo = $("#HBillNo").val();//åæ®å·
			if (HDate) {
			sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'";
			var HBeginDate = $("#HBeginDate").val();//å¼å§æ¥æ
			var HEndDate = $("#HEndDate").val();//ç»ææ¥æ
			var HStockOrgName = $("#HStockOrgName").val(); //ç»ç»
			var HBillNo = $("#HBillNo").val(); //åæ®å·
			var HDept = $("#HDept").val(); //é¨é¨ä¿¡æ¯
			var HMaterNumber = $("#HMaterNumber").val(); //ç©æä»£ç
			var HModelNumber = $("#HModelNumber").val(); //å¨å·ä»£ç
			var HWhName = $("#HWhName").val(); //ä»åºåç§°
			//var HSupName = $("#HSupName").val(); //å¾æ¥åä½

			if (HBeginDate) {
			sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HBeginDate + "'";
			}
			if (HDate1) {
			sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HDate1 + "'";
			if (HEndDate) {
			sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HEndDate + "'";
			}
			if (HStockOrgName) {
			sWhere += " and è°å¥ç»ç» like '%" + HStockOrgName + "%' or è°åºç»ç» like '%" + HStockOrgName+"%'";
			}
			if (HBillNo) {
			sWhere += " and åæ®å· like '%" + HBillNo + "%'";
			}
			if (HDept) {
			sWhere += " and é¨é¨ like '%" + HDept + "%'";
			}
			if (HMaterNumber) {
			sWhere += " and ç©æä»£ç like '%" + HMaterNumber + "%'";
			}
			if (HModelNumber) {
			sWhere += " and æ¨¡å·ä»£ç like '%" + HModelNumber + "%'";
			}
			if (HWhName) {
			sWhere += " and è°åºä»åº like '%" + HWhName + "%' or è°å¥ä»åº like '%" + HWhName +"%'";
			}
			//if (HSupName) {
			// sWhere += " and å¾æ¥åä½ like '%" + HSupName + "%'";
			//}
			get_Display(sWhere);
			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}
			//#endregion

			//#region éç½®è¿æ»¤æ¡ä»¶
			function set_ClearQuery() {
			$("#HDate").val("");//å¼å§æ¥æ
			$("#HDate1").val("");//ç»ææ¥æ
			$("#HBillNo").val("");//åæ®å·
			$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
			$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
			$("#HBillNo").val("");
			$("#HDept").val("");
			$("#HMaterNumber").val("");
			$("#HModelNumber").val("");
			$("#HWhName").val("");
			$("#HSupName").val("");
			$("#HStockOrgName").val("");
			sWhere = "";
			get_Display(sWhere);
			}