MES-WEB-LayUI.git

			@@ -60,26 +60,46 @@
			<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-inline">
			<div class="layui-inline">
			<span>å¶ä»æ¡ä»¶></span>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">å®¢æ·</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HCusID" id="HCusID" 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="HDeptID" id="HDeptID" style="width:190px;">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">ä¸»ç®¡</label>
			<label class="layui-form-label">ç©æä»£ç </label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HMangerID" id="HMangerID" style="width:190px;">
			<input type="text" class="layui-input" name="MaterialCode" id="MaterialCode" style="width:190px;">
			</div>
			</div>
			<!--<hr />-->
			<div class="layui-inline">
			<label class="layui-form-label">ç©æåç§°</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="MaterialName" id="MaterialName" 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="SpecificationModel" id="SpecificationModel" 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="HSourceBillNo" id="HSourceBillNo" 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="Warehouse" id="Warehouse" 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="Hmaker" id="Hmaker" style="width:190px;">
			</div>
			</div>
			</div>
			@@ -93,6 +113,10 @@
			<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>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit"><i class="layui-icon layui-icon-radio"></i>å®¡æ ¸</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit"><i class="layui-icon layui-icon-circle"></i>åå®¡æ ¸</button>
			<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>
			</div>
			</script>
			</form>
			@@ -110,6 +134,8 @@
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			}).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {

			//#region å¬å±åé
			var $ = layui.$
			, admin = layui.admin
			, layer = layui.layer
			@@ -123,111 +149,27 @@
			var sWhere = "";
			var option = [];

			//åå§åçé¢
			set_ClearBill();

			//#endregion

			//#region éç½®æé®
			//#region è¿å¥é¡µé¢å³å è½½

			//åå§åçé¢
			set_ClearBill();
			//#endregion

			//#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç

			// éç½®æé®
			form.on('submit(btnReSearch)', function (data) {
			//æ¸ç©ºè¿æ»¤æ¡ä»¶
			set_ClearQuery();
			});
			//#endregion

			//#region æ¥è¯¢æé®
			// æ¥è¯¢æé®
			form.on('submit(btnSearch)', function (data) {
			get_FastQuery(table, option);
			get_FastQuery();
			});
			//#endregion

			//#region åå§åçé¢
			function set_ClearBill() {
			//åå§åè¡¨æ ¼
			set_InitGrid();
			//æ¥è¯¢
			get_Display(sWhere);
			}
			//#endregion
			//#region åå§åè¡¨æ ¼æ¹æ³
			$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
			$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
			function set_InitGrid() {
			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, height: 'full-50'
			, page: true
			, cellMinWidth: 90
			, cols: [[
			{ type: 'checkbox', fixed: 'left' }
			,{ field: 'hmainid', title: 'hmainid', sort: true, hide: true }
			,{ field: 'åæ®å·', title: 'åæ®å·', hide: true }
			, { field: 'æ¥æ', title: 'æ¥æ', width: 160 }
			, { field: 'åæ®å·', title: 'åæ®å·', width: 160 }
			, { field: 'çº¢èåæ è®°', title: 'çº¢èåæ è®°', width: 160 }
			, { field: 'HCusID', title: 'HCusID', width: 160, hide: true }
			, { field: 'å®¢æ·', title: 'å®¢æ·', width: 200 }
			, { field: 'hsecmanagerid', title: 'hsecmanagerid', width: 200, hide: true }
			, { field: 'éªæ¶å', title: 'éªæ¶å', width: 200 }
			, { field: 'hkeeperid', title: 'hkeeperid', width: 200, hide: true }
			, { field: 'ä¿ç®¡å', title: 'ä¿ç®¡å', width: 200 }
			, { field: 'HDeptID', title: 'HDeptID', width: 200, hide: true }
			, { field: 'é¨é¨', title: 'é¨é¨', width: 160 }
			, { field: 'ä»åº', title: 'ä»åº', width: 160 }
			, { field: 'hsubid', title: 'hsubid', width: 160, hide: true }
			, { field: 'hmaterid', title: 'hmaterid', width: 200, hide: true }
			, { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ', width: 200 }
			, { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 200 }
			, { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 200 }
			, { field: 'æ¹æ¬¡', title: 'æ¹æ¬¡', width: 200 }
			, { field: 'hunitid', title: 'hunitid', width: 200, hide: true }
			, { field: 'è®¡éåä½', title: 'è®¡éåä½', width: 200 }
			, { field: 'åºæ¶æ°é', title: 'åºæ¶æ°é', width: 115 }
			, { field: 'å®æ¶æ°é', title: 'å®æ¶æ°é', width: 115 }
			, { field: 'åºåºæ°é', title: 'åºåºæ°é', width: 200 }
			, { field: 'åä»·', title: 'åä»·', width: 200 }
			, { field: 'éé¢', title: 'éé¢', width: 115 }
			, { field: 'hwhid', title: 'hwhid', width: 200, hide: true }
			, { field: 'æ¶æä»åºä»£ç ', title: 'æ¶æä»åºä»£ç ', width: 200 }
			, { field: 'æ¶æä»åº', title: 'æ¶æä»åº', width: 200 }
			, { field: 'è¡¨ä½å¤æ³¨', title: 'è¡¨ä½å¤æ³¨', width: 200 }
			, { 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>" }

			]]
			};
			}
			//è¿å¥é¡µé¢æ¾ç¤ºçç¼ååè¡¨
			function get_Display(sWhere) {
			var ajaxLoad = layer.load();
			$.ajax({
			url: GetWEBURL() + '/Kf_OtherInBill/GetOtherInBill',
			type: "GET",
			data: { "sWhere": sWhere },
			success: function (data1) {
			if (data1.count == 1) {
			option.data = data1.data;
			table.render(option);
			layer.close(ajaxLoad);
			} else {
			layer.close(ajaxLoad);
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.close(ajaxLoad);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			//å¤´å·¥å·æ äºä»¶
			table.on('toolbar(mainTable)', function (obj) {
			var checkStatus = table.checkStatus(obj.config.id);
			@@ -326,15 +268,113 @@
			};
			});

			//#endregion

			//#region å¿«éè¿æ»¤
			function get_FastQuery(table, option) {
			//#region æ¤é¡µé¢ææçæ¹æ³

			// åå§åçé¢
			function set_ClearBill() {
			//åå§åè¡¨æ ¼
			set_InitGrid();
			//æ¥è¯¢
			get_Display(sWhere);
			//åå§åæ¥æ
			$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
			$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
			}

			// åå§åè¡¨æ ¼æ¹æ³
			function set_InitGrid() {
			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, height: 'full-50'
			, page: true
			, cellMinWidth: 90
			, cols: [[
			{ type: 'checkbox', fixed: 'left' }
			,{ field: 'hmainid', title: 'hmainid', sort: true, hide: true }
			,{ field: 'åæ®å·', title: 'åæ®å·', hide: true }
			, { field: 'æ¥æ', title: 'æ¥æ', width: 160 }
			, { field: 'åæ®å·', title: 'åæ®å·', width: 160 }
			, { field: 'çº¢èåæ è®°', title: 'çº¢èåæ è®°', width: 160 }
			, { field: 'HCusID', title: 'HCusID', width: 160, hide: true }
			, { field: 'å®¢æ·', title: 'å®¢æ·', width: 200 }
			, { field: 'hsecmanagerid', title: 'hsecmanagerid', width: 200, hide: true }
			, { field: 'éªæ¶å', title: 'éªæ¶å', width: 200 }
			, { field: 'hkeeperid', title: 'hkeeperid', width: 200, hide: true }
			, { field: 'ä¿ç®¡å', title: 'ä¿ç®¡å', width: 200 }
			, { field: 'HDeptID', title: 'HDeptID', width: 200, hide: true }
			, { field: 'é¨é¨', title: 'é¨é¨', width: 160 }
			, { field: 'ä»åº', title: 'ä»åº', width: 160 }
			, { field: 'hsubid', title: 'hsubid', width: 160, hide: true }
			, { field: 'hmaterid', title: 'hmaterid', width: 200, hide: true }
			, { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ', width: 200 }
			, { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 200 }
			, { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 200 }
			, { field: 'æ¹æ¬¡', title: 'æ¹æ¬¡', width: 200 }
			, { field: 'hunitid', title: 'hunitid', width: 200, hide: true }
			, { field: 'è®¡éåä½', title: 'è®¡éåä½', width: 200 }
			, { field: 'åºæ¶æ°é', title: 'åºæ¶æ°é', width: 115 }
			, { field: 'å®æ¶æ°é', title: 'å®æ¶æ°é', width: 115 }
			, { field: 'åºåºæ°é', title: 'åºåºæ°é', width: 200 }
			, { field: 'åä»·', title: 'åä»·', width: 200 }
			, { field: 'éé¢', title: 'éé¢', width: 115 }
			, { field: 'hwhid', title: 'hwhid', width: 200, hide: true }
			, { field: 'æ¶æä»åºä»£ç ', title: 'æ¶æä»åºä»£ç ', width: 200 }
			, { field: 'æ¶æä»åº', title: 'æ¶æä»åº', width: 200 }
			, { field: 'è¡¨ä½å¤æ³¨', title: 'è¡¨ä½å¤æ³¨', width: 200 }
			, { 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>" }

			]]
			};
			}

			//è¿å¥é¡µé¢æ¾ç¤ºçç¼ååè¡¨
			function get_Display(sWhere) {
			var ajaxLoad = layer.load();
			$.ajax({
			url: GetWEBURL() + '/Kf_OtherInBill/GetOtherInBill',
			type: "GET",
			data: { "sWhere": sWhere },
			success: function (data1) {
			if (data1.count == 1) {
			option.data = data1.data;
			table.render(option);
			layer.close(ajaxLoad);
			} else {
			layer.close(ajaxLoad);
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.close(ajaxLoad);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}

			// å¿«éè¿æ»¤
			function get_FastQuery() {
			var HDate = $("#HBeginDate").val();//å¼å§æ¥æ
			var HDate1 = $("#HEndDate").val();//ç»ææ¥æ
			var HBillNo = $("#HBillNo").val();//åæ®å·
			var HCusID = $("#HCusID").val();
			var HDeptID = $("#HDeptID").val();
			var HMangerID = $("#HMangerID").val();
			var HDeptID = $("#HDeptID").val();//é¨é¨
			var MaterialCode = $("#MaterialCode").val();//ç©æä»£ç
			var MaterialName = $("#MaterialName").val();//ç©æåç§°
			var SpecificationModel = $("#SpecificationModel").val();//è§æ ¼åå·
			var HSourceBillNo = $("#HSourceBillNo").val();//æºååå·
			var Warehouse = $("#Warehouse").val();//ä»åº
			var Hmaker = $("#Hmaker").val();//å¶åäºº

			if (HDate) {
			sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'";
			}
			@@ -344,36 +384,51 @@
			if (HBillNo) {
			sWhere += " and åæ®å· like '%" + HBillNo + "%'";
			}
			if (HCusID) {
			sWhere += " and å®¢æ· like '%" + HCusID + "%'";
			}
			if (HDeptID) {
			sWhere += " and é¨é¨ like '%" + HDeptID + "%'";
			}
			if (HMangerID) {
			sWhere += " and ä¸»ç®¡ like '%" + HMangerID + "%'";
			if (MaterialCode) {
			sWhere += " and ç©æä»£ç like '%" + MaterialCode + "%'";
			}
			if (MaterialName) {
			sWhere += " and ç©æåç§° like '%" + MaterialName + "%'";
			}
			if (SpecificationModel) {
			sWhere += " and è§æ ¼åå· like '%" + SpecificationModel + "%'";
			}
			if (HSourceBillNo) {
			sWhere += " and æºååå· like '%" + HSourceBillNo + "%'";
			}
			if (Warehouse) {
			sWhere += " and åè´§ä»åº like '%" + Warehouse + "%'";
			}
			if (Hmaker) {
			sWhere += " and å¶åäºº like '%" + Hmaker + "%'";
			}

			get_Display(sWhere);
			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}
			//#endregion
			//#region éç½®è¿æ»¤æ¡ä»¶
			// éç½®è¿æ»¤æ¡ä»¶
			function set_ClearQuery() {
			$("#HDate").val("");//å¼å§æ¥æ
			$("#HDate1").val("");//ç»ææ¥æ
			$("#HBillNo").val("");//
			$("#HCusID").val("");
			$("#HDeptID").val("");
			$("#HMangerID").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("");//åæ®å·
			$("#HDeptID").val();//é¨é¨
			$("#MaterialCode").val();//ç©æä»£ç
			$("#MaterialName").val();//ç©æåç§°
			$("#SpecificationModel").val();//è§æ ¼åå·
			$("#HSourceBillNo").val();//æºååå·
			$("#Warehouse").val();//ä»åº
			$("#Hmaker").val();//å¶åäºº
			sWhere = "";
			}
			//#endregion

			//#region å·æ°
			// å·æ°
			function get_Refresh() {
			set_ClearQuery();
			get_Display(sWhere);
			}

			//#endregion