MES-WEB-LayUI.git

			@@ -1,15 +1,17 @@
			ï»¿<!DOCTYPE html>
			<html xmlns="http://www.w3.org/1999/xhtml">
			<head>
			<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
			<title>äº§çº¿ç»æååè¡¨</title>
			<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
			<title>äº§çº¿ç»æååè¡¨</title>
			<meta name="renderer" content="webkit">
			<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
			<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
			<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
			<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
			<script src="../../../layuiadmin/layui/layui.js"></script>

			<script src="../../../layuiadmin/PubCustom.js"></script>
			<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>

			</head>
			<body>
			<div class="layui-fluid">
			@@ -27,19 +29,19 @@
			<div class="layui-inline">
			<label class="layui-form-label">å¼å§æ¶é´</label>
			<div class="layui-input-block">
			<input type="date" class="layui-input" name="å¼å§æ¶é´" id="å¼å§æ¶é´">
			<input type="date" class="layui-input" name="HBeginDate" id="HBeginDate">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">ç»ææ¶é´</label>
			<div class="layui-input-block">
			<input type="date" class="layui-input" name="ç»ææ¶é´" id="ç»ææ¶é´">
			<input type="date" class="layui-input" name="HEndDate" id="HEndDate">
			</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="ç»æåå·" id="ç»æåå·">
			<input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;">
			</div>
			</div>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
			@@ -49,27 +51,9 @@

			<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>
			<label class="layui-form-label">ç»æåå·</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="å¶åäºº" id="å¶åäºº">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">ç»æåå¯ä¸æ¡ç </label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="ç»æåå¯ä¸æ¡ç " id="ç»æåå¯ä¸æ¡ç ">
			</div>
			</div>
			</div>
			<div class="layui-colla-content">
			<div class="layui-inline">
			<div class="layui-inline">
			<span>å¶ä»æ¡ä»¶></span>
			<input type="text" class="layui-input" name="ç»æåå·" id="ç»æåå·">
			</div>
			</div>
			<div class="layui-inline">
			@@ -84,21 +68,71 @@
			<input type="text" class="layui-input" name="åè£åå¯ä¸æ¡ç " id="åè£åå¯ä¸æ¡ç ">
			</div>
			</div>
			<!--<div class="layui-inline">
			<div class="layui-inline">
			<label class="layui-form-label">ç»æåå¯ä¸æ¡ç </label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="ç»æåå¯ä¸æ¡ç " id="ç»æåå¯ä¸æ¡ç ">
			</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>
			<div class="layui-input-block">
			<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="hmodel" id="hmodel">
			<input type="text" class="layui-input" name="SpecificationModel" id="SpecificationModel" style="width:190px;">
			</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="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>

			</div>
			</div>
			<table class="layui-form-item" id="mainTable" lay-filter="mainTable"></table>
			<script type="text/html" id="toolbarDemo">
			<div class="layui-btn-container layui-form-item">
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="Print" id="Print">
			<i class="layui-icon layui-icon-file"></i>æå°
			</button>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="Print" id="Print"><i class="layui-icon layui-icon-file"></i>æå° </button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add"><i class="layui-icon layui-icon-file-b"></i>æ°å¢</button>
			<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-Delete"><i class="layui-icon layui-icon-delete"></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>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button>
			</div>
			</script>
			</form>
			@@ -119,6 +153,9 @@
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			}).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {

			//#region å¬å±åé

			var $ = layui.$
			, admin = layui.admin
			, layer = layui.layer
			@@ -128,122 +165,27 @@
			, laypage = layui.laypage
			, laydate = layui.laydate
			, util = layui.util;
			//var sWhere = " äº§åä»£ç = 'BX0002'";
			var sWhere = "";
			var option = [];

			var option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, height: 'full-50'
			, page: true
			, cols: [[
			{ type: 'radio' }
			, { field: 'ç»æåç±»å', title: 'ç»æåç±»å', sort: true, hide: true }
			, { field: 'ç»æåä¸»ID', title: 'ç»æåä¸»ID', sort: true, hide: true }
			, { field: 'ç»æåå·', title: 'ç»æåå·', sort: true, width:155 }
			, { field: 'å¶åäºº', title: 'å¶åäºº', sort: true }
			, {
			field: 'å¶åæ¶é´', title: 'ç»ææ¶é´', sort: true, templet: function (d) {
			if (d.å¶åæ¶é´ == null) {
			return "";
			}
			return util.toDateString(d.å¶åæ¶é´, "yyyy-MM-dd");
			}
			}
			, { field: 'ç»æåå¯ä¸æ¡ç ', title: 'ç»æç ', sort: true }
			, { field: 'åè£åå·', title: 'åè£åå·', sort: true }
			, { field: 'åè£åç±»å', title: 'åè£åç±»å', hide: true }
			, { field: 'åè£åå¯ä¸æ¡ç ', title: 'åè£ç ', width: 165 }
			, { toolbar: '#toolBar', title: 'æä½', width: 115, fixed: 'right' }
			]]
			, text: {
			none: 'ææ ç¸å³æ°æ®ï¼'
			}
			};
			//#endregion

			option.data = [];
			table.render(option);
			//#region åå§åçé¢
			set_ClearBill();
			//#endregion


			//è¿å¥é¡µé¢æ¾ç¤ºçåè¡¨
			layer.load(3);
			$.ajax({
			url: GetWEBURL() + '/GroupOrderBill/List',
			type: "GET",
			data: { "sWhere": sWhere },
			success: function (data1) {
			if (data1.count == 1) {
			option.data = data1.data;
			table.render(option);
			layer.closeAll("loading");
			} else {
			layer.closeAll("loading");
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£å¤±æ!", { icon: 5 });
			}
			});
			//#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç

			//éç½®æé®
			form.on('submit(btnReSearch)', function (data) {
			$("#å¼å§æ¶é´").val("");
			$("#ç»ææ¶é´").val("");
			$("#ç»æåå·").val("");
			$("#å¶åäºº").val("");
			$("#ç»æåå¯ä¸æ¡ç ").val("");
			$("#åè£åå·").val("");
			$("#åè£åå¯ä¸æ¡ç ").val("");
			$("#btnSearch").click();
			//æ¸ç©ºè¿æ»¤æ¡ä»¶
			set_ClearQuery();
			});

			//æ¥è¯¢æé®
			form.on('submit(btnSearch)', function (data) {
			var å¼å§æ¶é´ = $("#å¼å§æ¶é´").val();
			var ç»ææ¶é´ = $("#ç»ææ¶é´").val();
			var ç»æåå· = $("#ç»æåå·").val();
			var å¶åäºº = $("#å¶åäºº").val();
			var ç»æåå¯ä¸æ¡ç = $("#ç»æåå¯ä¸æ¡ç ").val();
			var åè£åå· = $("#åè£åå·").val();
			var åè£åå¯ä¸æ¡ç = $("#åè£åå¯ä¸æ¡ç ").val();
			if (å¼å§æ¶é´) {
			sWhere += " and å¶åæ¶é´ > '" + å¼å§æ¶é´ + "'";
			}
			if (ç»ææ¶é´) {
			sWhere += " and å¶åæ¶é´ < '" + ç»ææ¶é´ + "'";
			}
			if (ç»æåå·) {
			sWhere += " and ç»æåå· like '%" + ç»æåå· + "%'";
			}
			if (å¶åäºº) {
			sWhere += " and å¶åäºº like '%" + å¶åäºº + "%'";
			}
			if (ç»æåå¯ä¸æ¡ç ) {
			sWhere += " and ç»æåå¯ä¸æ¡ç like '%" + ç»æåå¯ä¸æ¡ç + "%'";
			}
			if (åè£åå·) {
			sWhere += " and åè£åå· like '%" + åè£åå· + "%'";
			}
			if (åè£åå¯ä¸æ¡ç ) {
			sWhere += " and åè£åå¯ä¸æ¡ç like '%" + åè£åå¯ä¸æ¡ç + "%'";
			}
			$.ajax({
			url: GetWEBURL() + '/GroupOrderBill/List',
			type: "GET",
			data: { "sWhere": sWhere },
			success: function (data1) {
			if (data1.count == 1) {
			option.data = data1.data;
			table.render(option);
			//layer.alert("æ¥è¯¢æå", { icon: 1 });
			} else {
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£å¤±æ!", { icon: 5 });
			}
			});
			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			get_FastQuery();

			});
			//è·åéä¸è¡æ°æ®
			table.on('row(mainTable)', function (obj) {
			@@ -317,14 +259,173 @@
			}
			});

			//#endregion

			//#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: 'radio' }
			, { field: 'ç»æåç±»å', title: 'ç»æåç±»å', sort: true, hide: true }
			, { field: 'ç»æåä¸»ID', title: 'ç»æåä¸»ID', sort: true, hide: true }
			, { field: 'ç»æåå·', title: 'ç»æåå·', sort: true, width: 155 }
			, { field: 'å¶åäºº', title: 'å¶åäºº', sort: true }
			, {
			field: 'å¶åæ¶é´', title: 'ç»ææ¶é´', sort: true, templet: function (d) {
			if (d.å¶åæ¶é´ == null) {
			return "";
			}
			return util.toDateString(d.å¶åæ¶é´, "yyyy-MM-dd");
			}
			}
			, { field: 'ç»æåå¯ä¸æ¡ç ', title: 'ç»æç ', sort: true }
			, { field: 'åè£åå·', title: 'åè£åå·', sort: true }
			, { field: 'åè£åç±»å', title: 'åè£åç±»å', hide: true }
			, { field: 'åè£åå¯ä¸æ¡ç ', title: 'åè£ç ', width: 165 }
			, { toolbar: '#toolBar', title: 'æä½', width: 115, fixed: 'right' }
			]]
			, text: {
			none: 'ææ ç¸å³æ°æ®ï¼'
			}
			};
			}

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

			// å¿«éè¿æ»¤
			function get_FastQuery() {
			var HDate = $("#HBeginDate").val();//å¼å§æ¥æ
			var HDate1 = $("#HEndDate").val();//ç»ææ¥æ
			var HBillNo = $("#HBillNo").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();//å¶åäºº

			var ç»æåå· = $("#ç»æåå·").val();
			var ç»æåå¯ä¸æ¡ç = $("#ç»æåå¯ä¸æ¡ç ").val();
			var åè£åå· = $("#åè£åå·").val();
			var åè£åå¯ä¸æ¡ç = $("#åè£åå¯ä¸æ¡ç ").val();

			if (ç»æåå·) {
			sWhere += " and ç»æåå· like '%" + ç»æåå· + "%'";
			}

			if (ç»æåå¯ä¸æ¡ç ) {
			sWhere += " and ç»æåå¯ä¸æ¡ç like '%" + ç»æåå¯ä¸æ¡ç + "%'";
			}
			if (åè£åå·) {
			sWhere += " and åè£åå· like '%" + åè£åå· + "%'";
			}
			if (åè£åå¯ä¸æ¡ç ) {
			sWhere += " and åè£åå¯ä¸æ¡ç like '%" + åè£åå¯ä¸æ¡ç + "%'";
			}


			if (HDate) {
			sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'";
			}
			if (HDate1) {
			sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HDate1 + "'";
			}
			if (HBillNo) {
			sWhere += " and åæ®å· like '%" + HBillNo + "%'";
			}
			if (HDeptID) {
			sWhere += " and é¨é¨ like '%" + HDeptID + "%'";
			}
			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ç¼å
			}

			// éç½®è¿æ»¤æ¡ä»¶
			function set_ClearQuery() {
			$("#ç»æåå·").val("");
			$("#ç»æåå¯ä¸æ¡ç ").val("");
			$("#åè£åå·").val("");
			$("#åè£åå¯ä¸æ¡ç ").val("");
			$("#btnSearch").click();

			$("#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 = "";
			}

			function Print(data) {
			console.log("data=", data);
			}
			//#endregion
			//option.data = [];
			//table.render(option);
			//ä»¥ä¸æ¯layuiæ¨¡å
			});

			function Print(data) {
			console.log("data=", data);
			}


			</script>