| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç®±å·æ¡ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" id="BoxBarCode" 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" id="BarCode" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <!--<div class="layui-inline"> |
| | | <label class="layui-form-label">å¼å§æ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HDate" style="width:190px;"> |
| | |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HDate1" 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" id="HDepartName" style="width:190px;"> |
| | | </div> |
| | | </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-inline"> |
| | | <label class="layui-form-label">ç©æä»£ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" 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" id="HMaterName" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¶å人</label> |
| | | <div class="layui-input-block"> |
| | |
| | | resultTableHead = []; //æ¸
空表头åï¼é²æ¢é夿¸²æ |
| | | //åå§æ¥è¯¢ |
| | | //get_Display(sWhere); |
| | | $("#HDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 7), "yyyy-MM-dd")); |
| | | $("#HDate1").val(Format(new Date(new Date()), "yyyy-MM-dd")); |
| | | get_FastQuery(); |
| | | |
| | | } |
| | |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Sc_PackUnionBill/Get_PackUnionBillList', |
| | | type: "GET", |
| | | data: { "page": 1, "limit": 10, "sWhere": sWhere }, |
| | | data: { "page": 1, "limit": 50, "sWhere": sWhere, "user": sessionStorage["HUserName"] }, |
| | | datatype: "json", |
| | | success: function (data1) { |
| | | console.log(data1); |
| | | for (var key in data1.list) { |
| | | resultTableHead.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); |
| | | if (data1.count != 0) { |
| | | for (var key in data1.list) { |
| | | resultTableHead.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); |
| | | } |
| | | set_InitGrid(sWhere); |
| | | } |
| | | set_InitGrid(sWhere); |
| | | else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (err) { |
| | | layer.alert(err.Message, { icon: 5 }); |
| | | } |
| | |
| | | title: 'ç»æåå表', |
| | | cols: cols_arr, //å¡«å
è¡¨æ ¼å¤´æ°æ®, |
| | | id: 'mainTable', //è¡¨æ ¼id |
| | | where: { sWhere: sWhere }, //æ©å±åæ°,å¯ä»¥ä¼ æ°æ®å°åå° |
| | | where: { sWhere: sWhere, "user": sessionStorage["HUserName"] }, //æ©å±åæ°,å¯ä»¥ä¼ æ°æ®å°åå° |
| | | page: true, //å¼å¯å页 |
| | | totalRow: true, //å¼å¯å计 |
| | | limit: 10, //ä¸é¡µè½å¤æ¾ç¤ºçæå¤§æ°ç® |
| | | limits: [10, 20, 40, 60, 80, 100], //æ§å¶å¤å°è¡ä¸é¡µï¼é»è®¤äºæ¡ä¸é¡µï¼ |
| | | limit: 50, //ä¸é¡µè½å¤æ¾ç¤ºçæå¤§æ°ç® |
| | | limits: [50, 500, 5000, 20000], //æ§å¶å¤å°è¡ä¸é¡µï¼é»è®¤äºæ¡ä¸é¡µï¼ |
| | | method: 'get', //æäº¤æ¹å¼ |
| | | layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'], |
| | | response: { |
| | |
| | | var HDate = $("#HDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HDate1").val();//ç»ææ¥æ |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | var HDepartName = $("#HDepartName").val(); |
| | | var HMaterNumber = $("#HMaterNumber").val(); |
| | | var BoxBarCode = $("#BoxBarCode").val(); |
| | | var BarCode = $("#BarCode").val(); |
| | | var HMaterName = $("#HMaterName").val(); |
| | | var HMakerMan = $("#HMakerMan").val(); |
| | | |
| | |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | } |
| | | if (HDepartName) { |
| | | sWhere += " and é¨é¨ like '%" + HDepartName + "%'"; |
| | | if (BoxBarCode) { |
| | | sWhere += " and ç®±å·æ¡å½¢ç like '%" + BoxBarCode + "%'"; |
| | | } |
| | | if (HMaterNumber) { |
| | | sWhere += " and ç©æä»£ç like '%" + HMaterNumber + "%'"; |
| | | if (BarCode) { |
| | | sWhere += " and æ¡ç like '%" + BarCode + "%'"; |
| | | } |
| | | if (HMaterName) { |
| | | sWhere += " and ç©æåç§° like '%" + HMaterName + "%'"; |
| | |
| | | } |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 7), "yyyy-MM-dd")); |
| | | $("#HDate1").val(Format(new Date(new Date()), "yyyy-MM-dd")); |
| | | $("#HBillNo").val(""); |
| | | $("#HDepartName").val(""); |
| | | $("#HMaterNumber").val(""); |
| | | $("#BoxBarCode").val(""); |
| | | $("#BarCode").val(""); |
| | | $("#HMaterName").val(""); |
| | | $("#HMakerMan").val(""); |
| | | sWhere = " "; |