SRM-LAYUI.git - Gitblit

			@@ -46,31 +46,31 @@
			<input type="text" class="layui-input" name="HBillNo" id="HBillNo">
			</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="HShortNumber" id="HShortNumber">
			</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="HNumber" id="HNumber">
			</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="HName" id="HName">
			</div>
			</div>
			<div class="layui-inline">
			</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">
			</div>
			</div>
			<div class="layui-inline">
			</div>-->
			<!--<div class="layui-inline">
			<label class="layui-form-label">关闭状态</label>
			<div class="layui-input-block">
			<select id="HClStatus" name="HClStatus" lay-filter="">
			@@ -79,19 +79,19 @@
			<option value="已关闭">已关闭</option>
			</select>
			</div>
			</div>
			<div class="layui-inline">
			</div>-->
			<!--<div class="layui-inline">
			<label class="layui-form-label">开始日期</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HDate1" id="HDate1">
			</div>
			</div>
			<div class="layui-inline">
			</div>-->
			<!--<div class="layui-inline">
			<label class="layui-form-label">结束日期</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HDate2" id="HDate2">
			</div>
			</div>
			</div>-->
			<div class="layui-inline">
			<label class="layui-form-label">交货时间</label>
			<div class="layui-input-block">
			@@ -108,14 +108,14 @@
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<!--<div class="layui-inline">
			<label class="layui-form-label">采购组织</label>
			<div class="layui-input-block">
			<select id="HPURCHASEORGID" name="HPURCHASEORGID" lay-filter="">
			</select>
			</div>
			</div>
			<div class="layui-inline">
			</div>-->
			<!--<div class="layui-inline">
			<label class="layui-form-label">是否已下推送货单</label>
			<div class="layui-input-block">
			<select id="HISGenerate" name="HISGenerate" lay-filter="">
			@@ -124,7 +124,7 @@
			<option value="否">否</option>
			</select>
			</div>
			</div>
			</div>-->
			<div class="layui-inline">
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="f_Query">
			<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
			@@ -636,32 +636,32 @@
			sqlWhere += " and 状态 like ^^%" + $("#HStatus").val() + "%^^";
			if ($("#HBillNo").val() != "")
			sqlWhere += " and 单据号 like ^^%" + $("#HBillNo").val() + "%^^";
			if ($("#HShortNumber").val() != "")
			sqlWhere += " and 物料编码 like ^^%" + $("#HShortNumber").val() + "%^^";
			//if ($("#HShortNumber").val() != "")
			// sqlWhere += " and 物料编码 like ^^%" + $("#HShortNumber").val() + "%^^";
			if ($("#HNumber").val() != "")
			sqlWhere += " and 物料代码 like ^^%" + $("#HNumber").val() + "%^^";
			if ($("#HName").val() != "")
			sqlWhere += " and 物料名称 like ^^%" + $("#HName").val() + "%^^";
			if ($("#HModel").val() != "")
			sqlWhere += " and 规格型号 like ^^%" + $("#HModel").val() + "%^^";
			if ($("#HClStatus").val() != "")
			sqlWhere += " and 关闭状态 like ^^%" + $("#HClStatus").val() + "%^^";
			//if ($("#HName").val() != "")
			// sqlWhere += " and 物料名称 like ^^%" + $("#HName").val() + "%^^";
			//if ($("#HModel").val() != "")
			// sqlWhere += " and 规格型号 like ^^%" + $("#HModel").val() + "%^^";
			//if ($("#HClStatus").val() != "")
			// sqlWhere += " and 关闭状态 like ^^%" + $("#HClStatus").val() + "%^^";
			//if ($("#HPURCHASEORGID").val() != "")
			// sqlWhere += " and 采购组织 like ^^%" + $("#HPURCHASEORGID").val() + "%^^";
			if ($("#HDate1").val() != "") {
			sqlWhere += " and 日期 >= ^^" + $("#HDate1").val() + "^^";
			}
			if ($("#HDate2").val() != "") {
			sqlWhere += " and 日期 <= ^^" + $("#HDate2").val() + "^^";
			}
			if ($("#HISGenerate").val() != "") {
			if ($("#HISGenerate").val() == "是") {
			sqlWhere += " and 未关联数量 <= 0";
			}
			else if ($("#HISGenerate").val() == "否") {
			sqlWhere += " and 未关联数量 > 0";
			}
			}
			//if ($("#HDate1").val() != "") {
			// sqlWhere += " and 日期 >= ^^" + $("#HDate1").val() + "^^";
			//}
			//if ($("#HDate2").val() != "") {
			// sqlWhere += " and 日期 <= ^^" + $("#HDate2").val() + "^^";
			//}
			//if ($("#HISGenerate").val() != "") {
			// if ($("#HISGenerate").val() == "是") {
			// sqlWhere += " and 未关联数量 <= 0";
			// }
			// else if ($("#HISGenerate").val() == "否") {
			// sqlWhere += " and 未关联数量 > 0";
			// }
			//}


			var Time = $("#Time").val();