| | |
| | | <div class="layui-colla-item"> |
| | | <div class="layui-colla-title layui-inline"> |
| | | <div class="layui-inline"> |
| | | <span></span> |
| | | <span>æ´å¤</span> |
| | | </div> |
| | | </div> |
| | | <!--<div class="layui-inline"> |
| | | <label class="layui-form-label">å¼å§æ¥æ</label> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">åºç«æ¶é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HDate"> |
| | | <input type="date" class="layui-input" id="åºç«æ¶é´"> |
| | | </div> |
| | | </div>--> |
| | | <!--<div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HDate1"> |
| | | </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="HOrderProcNO" id="HOrderProcNO"> |
| | | <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="WorkCenter" id="WorkCenter"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">æµè½¬å¡å·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo"> |
| | | <input type="text" class="layui-input" name="åæ®å·" id="åæ®å·"> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | |
| | | </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"> |
| | | <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="å·¥åºæµè½¬å¡å·" 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 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> |
| | | </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 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="è系人信æ¯" id="è系人信æ¯"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | $("#HOrderProcNO").val("");//订åè·è¸ªå· |
| | | $("#WorkCenter").val("");//å·¥ä½ä¸å¿ |
| | | $("#HProcExchBillNo").val("");//æµè½¬å¡å· |
| | | $("#åºç«æ¶é´").val("");//è¿ç«æ¶é´ |
| | | $("#ä»»å¡å").val("");//ä»»å¡å |
| | | $("#åæ®å·").val("");//åæ®å· |
| | | $("#å·¥åºæµè½¬å¡å·").val("");//å·¥åºæµè½¬å¡å· |
| | | $("#产ååç§°").val("");//产ååç§° |
| | | $("#ç产çç»").val("");//ç产çç» |
| | | $("#æä½å").val("");//æä½å |
| | | $("#客æ·ä¿¡æ¯").val("");//客æ·ä¿¡æ¯ |
| | | $("#è系人信æ¯").val("");//èç³»äººä¿¡æ¯ |
| | | $("#btnSearch").click(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½ |
| | | var HOrderProcNO = $("#HOrderProcNO").val();//订åè·è¸ªå· |
| | | var WorkCenter = $("#WorkCenter").val();//å·¥ä½ä¸å¿ |
| | | var HProcExchBillNo = $("#HProcExchBillNo").val();//æµè½¬å¡å· |
| | | if (HOrderProcNO) { |
| | | sWhere += " and ä»»å¡å like '%" + HOrderProcNO + "%'"; |
| | | var åºç«æ¶é´ = $("#åºç«æ¶é´").val();//è¿ç«æ¶é´ |
| | | var ä»»å¡å = $("#ä»»å¡å").val();//ä»»å¡å |
| | | var åæ®å· = $("#åæ®å·").val();//åæ®å· |
| | | var å·¥åºæµè½¬å¡å· = $("#å·¥åºæµè½¬å¡å·").val();//å·¥åºæµè½¬å¡å· |
| | | var 产ååç§° = $("#产ååç§°").val();//产ååç§° |
| | | var ç产çç» = $("#ç产çç»").val();//ç产çç» |
| | | var æä½å = $("#æä½å").val();//æä½å |
| | | var 客æ·ä¿¡æ¯ = $("#客æ·ä¿¡æ¯").val();//客æ·ä¿¡æ¯ |
| | | var èç³»äººä¿¡æ¯ = $("#è系人信æ¯").val();//èç³»äººä¿¡æ¯ |
| | | if (åºç«æ¶é´) { |
| | | sWhere += " and CONVERT(varchar(100),åºç«æ¶é´, 23) = '" + åºç«æ¶é´ + "'"; |
| | | } |
| | | if (WorkCenter) { |
| | | sWhere += " and åæ®å· like '%" + WorkCenter + "%'"; |
| | | if (ä»»å¡å) { |
| | | sWhere += " and ä»»å¡å like '%" + ä»»å¡å + "%'"; |
| | | } |
| | | if (HProcExchBillNo) { |
| | | sWhere += " and å·¥åºæµè½¬å¡å· like '%" + HProcExchBillNo + "%'"; |
| | | if (åæ®å·) { |
| | | sWhere += " and åæ®å· like '%" + åæ®å· + "%'"; |
| | | } |
| | | if (å·¥åºæµè½¬å¡å·) { |
| | | sWhere += " and å·¥åºæµè½¬å¡å· like '%" + å·¥åºæµè½¬å¡å· + "%'"; |
| | | } |
| | | if (产ååç§°) { |
| | | sWhere += " and 产ååç§° like '%" + 产ååç§° + "%'"; |
| | | } |
| | | if (ç产çç») { |
| | | sWhere += " and ç产çç» like '%" + ç产çç» + "%'"; |
| | | } |
| | | if (æä½å) { |
| | | sWhere += " and æä½å like '%" + æä½å + "%'"; |
| | | } |
| | | if (客æ·ä¿¡æ¯) { |
| | | sWhere += " and 客æ·ä¿¡æ¯ like '%" + 客æ·ä¿¡æ¯ + "%'"; |
| | | } |
| | | if (è系人信æ¯) { |
| | | sWhere += " and èç³»äººä¿¡æ¯ like '%" + èç³»äººä¿¡æ¯ + "%'"; |
| | | } |
| | | $.ajax({ |
| | | //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", |