| | |
| | | <script src="../../../layuiadmin/layui/lay/modules/util.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/json2.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig2.js"></script> |
| | | |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid"> |
| | |
| | | <label class="layui-form-label">å
è£
åå¯ä¸æ¡ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="å
è£
åå¯ä¸æ¡ç " id="å
è£
åå¯ä¸æ¡ç " style="margin-top: 10px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ç»ç»</label> |
| | | <div class="layui-input-block" style="margin-left: 120px; width: 185px;"> |
| | | <select name="HOrgID" id="HOrgID" lay-verify="HOrgID" class="ForFilteringSchemes"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | |
| | | <div class="layui-btn-container"> |
| | | <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>é¢è§</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>å·æ°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm"><i class="layui-icon layui-icon-ok-circle"></i>确认</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back"><i class="layui-icon layui-icon-close-fill"></i>驳å</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详æ
</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></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> |
| | |
| | | , laypage = layui.laypage |
| | | , laydate = layui.laydate |
| | | , util = layui.util |
| | | //var sWhere = " 产å代ç = 'BX0002'"; |
| | | |
| | | var sWhere = ""; |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | var option = { |
| | | elem: '#mainTable' |
| | | //, toolbar: '#toolbarDemo', sort: true, hide: true |
| | | //, height: 'full-50' |
| | | , cellMinWidth: 90 |
| | | , page: true |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , cols: [[ |
| | | { field: 'ç¼å表ID', title: 'ç¼å表ID', sort: true } |
| | | , { field: 'å
è£
åå·', title: 'å
è£
åå·', width: 140, sort: true } |
| | | , { field: 'å
è£
åå¯ä¸æ¡ç ', title: 'å
è£
åå¯ä¸æ¡ç ', width: 170, sort: true } |
| | | , { field: 'å
è£
åç±»å', title: 'å
è£
åç±»å', width: 105, sort: true, hide: true } |
| | | , { field: 'æ«ç 人', title: 'æ«ç 人', sort: true } |
| | | , { |
| | | field: 'æ«ç æ¶é´', title: 'ç»ææ¶é´', width: 105, sort: true, templet: function (d) { |
| | | if (d.æ«ç æ¶é´ == null) { |
| | | return ""; |
| | | //#endregion |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | $("#ç»ææ¶é´").val(Format(new Date(), "yyyy-MM-dd")); |
| | | |
| | | Organ(); |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | |
| | | //æ¥è¯¢ |
| | | get_FastQuery(1); |
| | | |
| | | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region åå§åè¡¨æ ¼æ¹æ³ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | //, toolbar: '#toolbarDemo', sort: true, hide: true |
| | | //, height: 'full-50' |
| | | , cellMinWidth: 90 |
| | | , page: true |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , cols: [[ |
| | | { field: 'ç¼å表ID', title: 'ç¼å表ID', sort: true } |
| | | , { field: 'å
è£
åå·', title: 'å
è£
åå·', width: 140, sort: true } |
| | | , { field: 'å
è£
åå¯ä¸æ¡ç ', title: 'å
è£
åå¯ä¸æ¡ç ', width: 170, sort: true } |
| | | , { field: 'å
è£
åç±»å', title: 'å
è£
åç±»å', width: 105, sort: true, hide: true } |
| | | , { field: 'æ«ç 人', title: 'æ«ç 人', sort: true } |
| | | , { |
| | | field: 'æ«ç æ¶é´', title: 'ç»ææ¶é´', width: 105, sort: true, templet: function (d) { |
| | | if (d.æ«ç æ¶é´ == null) { |
| | | return ""; |
| | | } |
| | | return util.toDateString(d.æ«ç æ¶é´, "yyyy-MM-dd"); |
| | | } |
| | | return util.toDateString(d.æ«ç æ¶é´, "yyyy-MM-dd"); |
| | | } |
| | | } |
| | | , { field: 'ç»æåID', title: 'ç»æåID', sort: true } |
| | | , { field: 'ç»æåå·', title: 'ç»æåå·', width: 155, sort: true } |
| | | , { field: 'ç»æåç±»å', title: 'ç»æåç±»å', width: 105, sort: true } |
| | | , { toolbar: '#toolBar', width: 65, fixed: 'right' } |
| | | ]] |
| | | }; |
| | | , { field: 'ç»æåID', title: 'ç»æåID', sort: true } |
| | | , { field: 'ç»æåå·', title: 'ç»æåå·', width: 155, sort: true } |
| | | , { field: 'ç»æåç±»å', title: 'ç»æåç±»å', width: 105, sort: true } |
| | | , { toolbar: '#toolBar', width: 65, fixed: 'right' } |
| | | ]] |
| | | }; |
| | | |
| | | option.data = []; |
| | | table.render(option); |
| | | option.data = []; |
| | | table.render(option); |
| | | |
| | | |
| | | } |
| | | //#endregion |
| | | |
| | | //è·åç»ç» |
| | | function Organ() { |
| | | //è·åç»å½é¡µç»ç»å |
| | | $.ajax({ |
| | | type: "get", |
| | | async: false, |
| | | url: GetWEBURl() + "/Web/GetOrganizations", |
| | | success: function (result) { |
| | | var Organization = ""; |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | Organization += '<option style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>'; |
| | | } |
| | | $("#HOrgID").append(Organization); |
| | | $("#HOrgID").val(sessionStorage["OrganizationID"]) |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | |
| | | }) |
| | | } |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var ç»ææ¶é´ = $("#ç»ææ¶é´").val();//è¿ç«æ¶é´ |
| | | var å
è£
åå¯ä¸æ¡ç = $("#å
è£
åå¯ä¸æ¡ç ").val();//å
è£
åå¯ä¸æ¡ç |
| | | var å
è£
åå· = $("#å
è£
åå·").val();//å
è£
åå· |
| | | var ç»æåå· = $("#ç»æåå·").val();//ç»æåå· |
| | | var æ«ç 人 = $("#æ«ç 人").val();//æ«ç 人 |
| | | if (ç»ææ¶é´) { |
| | | sWhere += " and CONVERT(varchar(100),æ«ç æ¶é´, 23) = '" + ç»ææ¶é´ + "'"; |
| | | } |
| | | if (å
è£
åå¯ä¸æ¡ç ) { |
| | | sWhere += " and å
è£
åå¯ä¸æ¡ç like '%" + å
è£
åå¯ä¸æ¡ç + "%'"; |
| | | } |
| | | if (å
è£
åå·) { |
| | | sWhere += " and å
è£
åå· like '%" + å
è£
åå· + "%'"; |
| | | } |
| | | if (ç»æåå·) { |
| | | sWhere += " and ç»æåå· like '%" + ç»æåå· + "%'"; |
| | | } |
| | | if (æ«ç 人) { |
| | | sWhere += " and æ«ç 人 like '%" + æ«ç 人 + "%'"; |
| | | } |
| | | |
| | | sWhere += getOrgIDByUser();//ç¨æ·å
³èç»ç»æ¥è¯¢è¿æ»¤ |
| | | |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢ |
| | | function get_Display(sWhere) { |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/GroupOrderBill/CacheList', |
| | | 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 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | |
| | | |
| | | //çå¬è¡¨æ ¼ä¸è¡å·¥å
·äºä»¶ |
| | | table.on('tool(mainTable)', function (obj) { //注ï¼tool æ¯å·¥å
·æ¡äºä»¶åï¼test æ¯ table åå§å®¹å¨ç屿§ lay-filter="对åºçå¼" |
| | |
| | | } |
| | | }); |
| | | |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | layer.load(3); |
| | | $.ajax({ |
| | | //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", |
| | | url: GetWEBURL() + '/GroupOrderBill/CacheList', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (result) { |
| | | if (result.code == 1) { |
| | | option.data = result.data; |
| | | table.render(option); |
| | | layer.closeAll("loading"); |
| | | } else { |
| | | layer.closeAll("loading"); |
| | | layer.alert(result.code + result.msg, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.msg("æ¥å£è¯·æ±å¤±è´¥!", { |
| | | icon: 5, btn: ['确认'], time: 100000, offset: 't', |
| | | skin: 'layui-layer-lan', title: "温馨æç¤º" |
| | | }); |
| | | } |
| | | }); |
| | | |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | |
| | | $("#å
è£
åå·").val("");//å
è£
åå· |
| | | $("#ç»æåå·").val("");//ç»æåå· |
| | | $("#æ«ç 人").val("");//æ«ç 人 |
| | | $("#HOrgID").val(sessionStorage["OrganizationID"]); |
| | | $("#btnSearch").click(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½ |
| | | var ç»ææ¶é´ = $("#ç»ææ¶é´").val();//è¿ç«æ¶é´ |
| | | var å
è£
åå¯ä¸æ¡ç = $("#å
è£
åå¯ä¸æ¡ç ").val();//å
è£
åå¯ä¸æ¡ç |
| | | var å
è£
åå· = $("#å
è£
åå·").val();//å
è£
åå· |
| | | var ç»æåå· = $("#ç»æåå·").val();//ç»æåå· |
| | | var æ«ç 人 = $("#æ«ç 人").val();//æ«ç 人 |
| | | if (ç»ææ¶é´) { |
| | | sWhere += " and CONVERT(varchar(100),æ«ç æ¶é´, 23) = '" + ç»ææ¶é´ + "'"; |
| | | } |
| | | 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", |
| | | url: GetWEBURL() + '/GroupOrderBill/CacheList', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (result) { |
| | | if (result.code == 1) { |
| | | option.data = result.data; |
| | | table.render(option); |
| | | layer.alert("æ¥è¯¢æå", { icon: 1 }); |
| | | } else { |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£å¤±æ!", { icon: 5 }); |
| | | } |
| | | }); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | | |
| | | //laydate.render({ |
| | | // elem: '#HDate' |
| | | // , type: 'datetime' |
| | | // , trigger: 'click' |
| | | // , format:'yyyy-MM-dd HH:mm' |
| | | //}); |
| | | //#region æ ¹æ®ç¨æ·è·åç¨æ·å
³èç»ç»çè¿æ»¤æ¡ä»¶ |
| | | function getOrgIDByUser() { |
| | | var res = ""; |
| | | $.ajax({ |
| | | type: "GET", |
| | | async: false, |
| | | url: GetWEBURL() + "/Xt_User/getOrgIDListByUser", //æ¹æ³æå¨é¡µé¢åæ¹æ³å ä¼ å ç»ç»å¿
é¡»æ¯åè¡¨å¤´é¨æ¥è¯¢çç»ç» ä¸è½ä½¿ç¨ç¨æ·é»è®¤ |
| | | data: { "UserID": sessionStorage["Czybm"], "UserName": sessionStorage["HUserName"], HOrgID: $("#HOrgID").val() }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | if (result.data[0].sWhere == "1") { |
| | | res = " and HSTOCKORGID = '" + $("#HOrgID").val() + "'"; |
| | | } else { |
| | | res = result.data[0].sWhere; |
| | | } |
| | | } |
| | | }, error: function (err) { |
| | | res = " and 1 = 0"; |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | return res; |
| | | } |
| | | //#endregion |
| | | |
| | | |
| | | //以䏿¯layui模å |