| New file |
| | |
| | | <!DOCTYPE html> |
| | | <html> |
| | | <head> |
| | | <meta 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/zgqCustom/zgqCustom.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/soulTable.slim.js"></script> |
| | | <script src="../../../layuiadmin/SetColumn.js"></script> |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid"> |
| | | <div class="layui-col-md12"> |
| | | <div class="layui-card" style="padding: 1px"> |
| | | <div class="layui-card-body" style="padding: 1px;"> |
| | | <form class="layui-form" action="" lay-filter="component-form-group"> |
| | | <div class="layui-collapse"> |
| | | <div class="layui-colla-item"> |
| | | <div class="layui-colla-title 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="date" class="layui-input" id="HDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">åæ¥ç¶æ</label> |
| | | <div class="layui-input-block" style="margin-left: 125px;width:55%;"> |
| | | <select name="HRelationQty" lay-filter="aihao" id="HRelationQty"> |
| | | <option value="1" selected="selected">å
¨é¨</option> |
| | | <option value="2">已忥</option> |
| | | <option value="3">æªåæ¥</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style=" margin-top: 10px; margin-left: 80px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | | <option value="10">ä¸å
å«</option> |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> |
| | | </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"> |
| | | <div class="layui-inline"> |
| | | <span>å
¶ä»æ¡ä»¶></span> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ä»»å¡åå·</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HWorkBillNo" id="HWorkBillNo"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">åæ®å·</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HBillNo" id="HBillNo"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">å·¥åºæµè½¬å¡å·</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-InSync" id="btn-InSync"><i class="layui-icon layui-icon-ok-circle"></i>忥</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_InSync_Batch" id="btn_InSync_Batch"><i class="layui-icon layui-icon-ok-circle"></i>æ¹é忥</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Exit" id="btn-Exit">éåº</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <script> |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate', 'soulTable'], function () { |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | | , layer = layui.layer |
| | | , table = layui.table |
| | | , form = layui.form |
| | | , element = layui.element |
| | | , laypage = layui.laypage |
| | | , laydate = layui.laydate |
| | | , util = layui.util |
| | | , soulTable = layui.soulTable |
| | | //å
¬ç¨åé |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "Cj_StationOutBillSync" |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | | //#region ç¹å»è¡éä¸é«äº® |
| | | table.on('row(mainTable)', function (obj) { |
| | | //éä¸è¡æ¹åé¢è² |
| | | var flag = !obj.tr.find(':checkbox:first').prop('checked'); |
| | | obj.tr.find(':checkbox').prop('checked', flag); |
| | | if (flag) { |
| | | obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //设置å¤éæ¡é䏿 ·å¼ |
| | | $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è² |
| | | } else { |
| | | obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡é䏿 ·å¼ |
| | | $(obj.tr.selector).attr({ "style": "background:" });//åæ¶å½åtré¢è² |
| | | } |
| | | //mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æID䏿£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤é䏿ªé䏿 ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è² |
| | | layui.each(table.cache.mainTable, function (i, l) { |
| | | if (obj.tr.index() == l.LAY_TABLE_INDEX) { |
| | | l.LAY_CHECKED = flag; |
| | | } |
| | | }); |
| | | }) |
| | | //#endregion |
| | | //ç产订ååè½¦æ¹æ³ |
| | | $('#HWorkBillNo').on('keydown', function (event) { |
| | | var HWorkBillNo = $('#HWorkBillNo').val(); |
| | | if (event.keyCode == 13) { |
| | | if (!HWorkBillNo) { |
| | | layer.msg("ä»»å¡åå·ä¸è½ä¸ºç©ºï¼") |
| | | return; |
| | | } |
| | | $("#btnSearch").click(); |
| | | } |
| | | }); |
| | | //åæ®å·åè½¦æ¹æ³ |
| | | $('#HBillNo').on('keydown', function (event) { |
| | | var HBillNo = $('#HBillNo').val(); |
| | | if (event.keyCode == 13) { |
| | | if (!HBillNo) { |
| | | layer.msg("åæ®å·ä¸è½ä¸ºç©ºï¼") |
| | | return; |
| | | } |
| | | $("#btnSearch").click(); |
| | | } |
| | | }); |
| | | //å·¥åºæµè½¬å¡åè½¦æ¹æ³ |
| | | $('#HProcExchBillNo').on('keydown', function (event) { |
| | | var HProcExchBillNo = $('#HProcExchBillNo').val(); |
| | | if (event.keyCode == 13) { |
| | | if (!HProcExchBillNo) { |
| | | layer.msg("å·¥åºæµè½¬å¡å·ä¸è½ä¸ºç©ºï¼") |
| | | return; |
| | | } |
| | | $("#btnSearch").click(); |
| | | } |
| | | }); |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , totalRow: true |
| | | , cellMinWidth: 90 |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | , cols: [[ |
| | | |
| | | ]] |
| | | , text: { |
| | | none: 'æ æ°æ®ï¼' |
| | | } |
| | | }; |
| | | set_ClearQuery(); |
| | | get_FastQuery(); |
| | | } |
| | | |
| | | |
| | | |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //忥 |
| | | case 'btn-InSync': get_InSync(); |
| | | break; |
| | | //æ¹é忥 |
| | | case 'btn_InSync_Batch': get_InSync_Batch(); |
| | | break; |
| | | //å设置 |
| | | case 'btn_HideColumn': get_HideColumnNoPage(HModName, sessionStorage["HUserName"], option, get_FastQuery); |
| | | break; |
| | | //éåº |
| | | case 'btn-Exit': get_Exit(); |
| | | break; |
| | | }; |
| | | }); |
| | | |
| | | //#endregion |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HWorkBillNo").val(""); |
| | | $("#HBillNo").val(""); |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HProcExchBillNo").val(""); |
| | | $("#HRelationQty").val("1"); |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | | form.render("select"); |
| | | } |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HWorkBillNo = $("#HWorkBillNo").val(); |
| | | var HBillNo = $("#HBillNo").val(); |
| | | var HProcExchBillNo = $("#HProcExchBillNo").val(); |
| | | var HRelationQty = $("#HRelationQty").val(); |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | | var ColContent = $("#ColContent").val(); |
| | | switch (HRelationQty) { |
| | | case "1": |
| | | sWhere += ""; |
| | | break; |
| | | case "2": |
| | | sWhere += " and åæ¥ç¶æ = '已忥'"; |
| | | break; |
| | | case "3": |
| | | sWhere += " and åæ¥ç¶æ = ''"; |
| | | break; |
| | | } |
| | | if (ColName != 0 && Comparator != 0) { |
| | | var com = ""; |
| | | switch (Comparator) { |
| | | case "7": |
| | | com = "like'%" + ColContent + "%'"; |
| | | break; |
| | | case "8": |
| | | com = "like'%" + ColContent + "'"; |
| | | break; |
| | | case "9": |
| | | com = "like'" + ColContent + "%'"; |
| | | break; |
| | | case "10": |
| | | com = "not like'%" + ColContent + "%'"; |
| | | break; |
| | | default: |
| | | com = "" + Comparator + "'" + ColContent + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName + " " + com; |
| | | } |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),åºç«æ¶é´, 23) = '" + HDate + "'"; |
| | | } |
| | | if (HWorkBillNo) { |
| | | sWhere += " and ä»»å¡å like '%" + HWorkBillNo + "%'"; |
| | | } |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | } |
| | | if (HProcExchBillNo) { |
| | | sWhere += " and å·¥åºæµè½¬å¡å· like '%" + HProcExchBillNo + "%'"; |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(sWhere) { |
| | | var wait = layer.load(); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Cj_StationOutBill/get_Display', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "HBillSubType": "3791" }, |
| | | success: function (data1) { |
| | | if (data1.count == 0) { |
| | | option.data = []; |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } else { |
| | | var data = []; |
| | | var col = []; |
| | | var titleData = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) { |
| | | data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); |
| | | } |
| | | //å¨å表左边添å å¾éæ¡ |
| | | col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计' }); |
| | | for (var i = 0; i < data.length; i++) { |
| | | // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') { |
| | | if ($.inArray(data[i].name, titleData) > -1) { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | | //int |
| | | case 'DateTime': |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 }); |
| | | break; |
| | | default: |
| | | if (data[i].name == 'æ°é' || data[i].name == 'åºç«æ°é' || data[i].name == 'æ¥åºæ°é' || data[i].name == 'åæ ·æ°é' || data[i].name == 'å·¥æ¶') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 200, totalRow: true }); |
| | | } else { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 200 }); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | option.cols = [col]; |
| | | option.data = data1.data; |
| | | //å设置 |
| | | DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option); |
| | | } |
| | | table.render(option); |
| | | layer.close(wait); |
| | | if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { |
| | | ColFilter(); |
| | | } |
| | | }, error: function () { |
| | | layer.close(wait); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //æ¹é忥 |
| | | function get_InSync_Batch() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | if (checkStatus.data.length > 0) { |
| | | var InterID = ''; |
| | | var BillNo = ''; |
| | | for (var i = 0; i < data.length; i++) { |
| | | InterID=(data[i].hmainid.toString()); |
| | | BillNo=(data[i].åæ®å·.toString()); |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Cj_StationOutBill/set_SaveStationOutBill_CLD_Json", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: true, |
| | | data: { "HInterID": InterID, "HBillNo": BillNo, "HMaker": sessionStorage["HUserName"] }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | | layer.msg(data.Message, { time: 1 * 1000, icon: 1 }, function () { |
| | | var index = parent.layer.getFrameIndex(window.name); //å
å¾å°å½åiframeå±çç´¢å¼ |
| | | parent.layer.close(index); //åæ§è¡å
³é           |
| | | }); |
| | | } |
| | | else { |
| | | layer.alert(data.Message, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.alert(err.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | } |
| | | else { |
| | | layer.msg('è¯·éæ©è³å°ä¸è¡æ°æ®ï¼'); |
| | | } |
| | | } |
| | | //忥 |
| | | function get_InSync() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | if (checkStatus.data.length === 1) { |
| | | var InterID = data[0].hmainid.toString(); |
| | | var BillNo = data[0].åæ®å·.toString(); |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Cj_StationOutBill/set_SaveStationOutBill_CLD_Json", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: true, |
| | | data: { "HInterID": InterID, "HBillNo": BillNo, "HMaker": sessionStorage["HUserName"] }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | | layer.msg(data.Message, { time: 1 * 1000, icon: 1 }, function () { |
| | | var index = parent.layer.getFrameIndex(window.name); //å
å¾å°å½åiframeå±çç´¢å¼ |
| | | parent.layer.close(index); //åæ§è¡å
³é           |
| | | }); |
| | | } |
| | | else { |
| | | layer.alert(data.Message, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.alert(err.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | else { |
| | | layer.msg('è¯·éæ©ä¸è¡æ°æ®åæ¥ï¼'); |
| | | } |
| | | } |
| | | |
| | | //#region ç¹å»è¡éä¸é«äº® |
| | | table.on('row(mainTablemainTable)', function (obj) { |
| | | //éä¸è¡æ¹åé¢è² |
| | | var flag = !obj.tr.find(':checkbox:first').prop('checked'); |
| | | obj.tr.find(':checkbox').prop('checked', flag); |
| | | if (flag) { |
| | | obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //设置å¤éæ¡é䏿 ·å¼ |
| | | $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è² |
| | | } else { |
| | | obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡é䏿 ·å¼ |
| | | $(obj.tr.selector).attr({ "style": "background:" });//åæ¶å½åtré¢è² |
| | | } |
| | | //mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æID䏿£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤é䏿ªé䏿 ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è² |
| | | layui.each(table.cache.mainTable, function (i, l) { |
| | | if (obj.tr.index() == l.LAY_TABLE_INDEX) { |
| | | l.LAY_CHECKED = flag; |
| | | } |
| | | }); |
| | | }) |
| | | //#endregion |
| | | //åææ¾ç¤ºä¸ææ¡ |
| | | function ColFilter() { |
| | | var Organization = '<option value="0" selected="selected" ></option>'; |
| | | for (var i = 1; i < option.cols[0].length; i++) { |
| | | if (option.cols[0][i].hide != true) { |
| | | Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>'; |
| | | } |
| | | } |
| | | $("#ColName").empty(); |
| | | $("#ColName").append(Organization); |
| | | form.render('select'); |
| | | } |
| | | //éåº |
| | | function get_Exit() { |
| | | Pub_Close(2); |
| | | } |
| | | |
| | | //以䏿¯layui模å |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | </script> |
| | | </body> |
| | | </html> |