| WebTM/WebTM.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/计划管理/工艺路线/Gy_RoutingBillList.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/车间管理/委外工序发出单/Cj_StationEntrustInBillSync.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/车间管理/委外工序接收单/Cj_StationEntrustOutBillSync.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/车间管理/工序出站汇报单/Cj_StationOutBillSync.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebTM/WebTM.csproj
@@ -888,6 +888,8 @@ <Content Include="views\设å¤ç®¡ç\设å¤å¼æºå\Sb_EquipBeginBillList.html" /> <Content Include="views\è´¨é管ç\å·¡æ£è®°å½å\MES_QC_PatrolProcCheckOtherBill_PDA.html" /> <Content Include="views\车é´ç®¡ç\å¯å¨ç¹æ£å\Sc_WorkDotCheckBillList_Day.html" /> <Content Include="views\车é´ç®¡ç\å§å¤å·¥åºååºå\Cj_StationEntrustInBillSync.html" /> <Content Include="views\车é´ç®¡ç\å§å¤å·¥åºæ¥æ¶å\Cj_StationEntrustOutBillSync.html" /> <Content Include="views\车é´ç®¡ç\å§å¤å·¥åºæ¥æ¶å\Sc_ProcessExchangeIssueBillList_PDA.html" /> <Content Include="views\车é´ç®¡ç\å·¥åºåºç«æ±æ¥å\Cj_StationOutBill_Sup.html" /> <Content Include="views\车é´ç®¡ç\å·¥åºåºç«æ±æ¥å\Cj_StationOutBillSync.html" /> WebTM/views/¼Æ»®¹ÜÀí/¹¤ÒÕ·Ïß/Gy_RoutingBillList.html
@@ -1639,7 +1639,13 @@ </div> `, success: function (layero, index) { $("#startTime").val(Format(new Date(), "yyyy-MM-dd")); $("#endTime").val(Format(new Date(2100, 12, 31), "yyyy-MM-dd")); // è·åå½åæ¥æ const currentDate = new Date(); // å建æ°æ¥æ对象ï¼é¿å ä¿®æ¹åæ¥æï¼ const after30Days = new Date(currentDate); // 设置æ¥æ为å½åæ¥æ + 30天 after30Days.setDate(currentDate.getDate() + 30); $("#endTime").val(Format(after30Days, "yyyy-MM-dd")); // ç¡®å®æé®ç¹å»äºä»¶ $('#confirmTime').on('click', function () { var startTime = $('#startTime').val(); WebTM/views/³µ¼ä¹ÜÀí/ίÍ⹤Ðò·¢³öµ¥/Cj_StationEntrustInBillSync.html
New file @@ -0,0 +1,562 @@ <!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" >å ¨é¨</option> <option value="2">å·²åæ¥</option> <option value="3">æªåæ¥</option> <option value="4" selected="selected">åæ¥å¤±è´¥</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" style="" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></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_StationEntrustInBillSync" var syncMessage = []//åæ¥æ¥éä¿¡æ¯ //åå§åè¡¨æ ¼ 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; //导åºexcel case 'get_export': get_Export(); 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("4"); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render("select"); } //å¿«éè¿æ»¤ function get_FastQuery() { var HDate = $("#HDate").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; case "4": 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 + "%'"; } sWhere += getDeptIDByUser();//ç¨æ·å ³èé¨é¨è¿æ»¤ get_Display(sWhere); sWhere = "";//è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å } //å è½½ç½æ ¼ function get_Display(sWhere) { var wait = layer.load(); $.ajax({ url: GetWEBURL() + '/Cj_StationEntrustInBill/list', type: "GET", data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]}, 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 = ''; syncMessage = []; for (var i = 0; i < data.length; i++) { InterID=(data[i].hmainid.toString()); BillNo=(data[i].åæ®å·.toString()); $.ajax({ type: "GET", url: GetWEBURL() + "/Cj_StationEntrustInBill/set_SaveStationOutBill_CLD_Json", //æ¹æ³æå¨é¡µé¢åæ¹æ³å async: true, data: { "HInterID": InterID, "HBillNo": BillNo, "HMaker": sessionStorage["HUserName"] }, dataType: "json", success: function (data1) { if (data1.count == 1) { // 说æéªè¯æåäºï¼ layer.msg(data1.Message, { time: 1 * 1000, icon: 1 }, function () { var index = parent.layer.getFrameIndex(window.name); //å å¾å°å½åiframeå±çç´¢å¼ parent.layer.close(index); //åæ§è¡å ³é           }); } else { let errMessage = []; errMessage.push(data1.Message); syncMessage.push(errMessage); layer.alert(data1.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_StationEntrustInBill/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 导åºExecel function get_Export() { var data = option.data; data.forEach((item) => { for (let itemobj in item) { if (item[itemobj] == null) { item[itemobj] = ""; } if (item[itemobj].length > 0) { // å设å段å为field item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 item[itemobj] = item[itemobj].toString().replace(/,/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 } } }); table.exportFile('mainTable', data, "xls"); } //#endregion //#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 //åææ¾ç¤ºä¸ææ¡ 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); } //#region æ ¹æ®ç¨æ·è·åç¨æ·å ³èé¨é¨çè¿æ»¤æ¡ä»¶ function getDeptIDByUser() { var res = ""; $.ajax({ type: "GET", async: false, url: GetWEBURL() + "/Xt_User/UserDeptlistPlaylist", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "HUserID": sessionStorage["Czybm"] }, success: function (result) { if (result.count == 1) { if (result.data.length > 0) { for (let item of result.data) { res += item.HItemID.toString() + "," } res = res.slice(0, -1); res = ` and HDeptID in (${res})` } } }, error: function (err) { res = " and 1 = 0"; layer.alert(get_MessageError("[0000-1-002]æ¥å£è¯·æ±å¤±è´¥!", sessionStorage["HTranSlate"]), { icon: 5 }); } }); return res; } //#endregion //以ä¸æ¯layui模å }); </script> </body> </html> WebTM/views/³µ¼ä¹ÜÀí/ίÍ⹤Ðò½ÓÊÕµ¥/Cj_StationEntrustOutBillSync.html
New file @@ -0,0 +1,564 @@ <!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" >å ¨é¨</option> <option value="2">å·²åæ¥</option> <option value="3">æªåæ¥</option> <option value="4" selected="selected">åæ¥å¤±è´¥</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" style="" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></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_StationEntrustOutBillSync" var syncMessage = []//åæ¥æ¥éä¿¡æ¯ //åå§åè¡¨æ ¼ 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; //导åºexcel case 'get_export': get_Export(); 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("4"); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); form.render("select"); } //å¿«éè¿æ»¤ function get_FastQuery() { var HDate = $("#HDate").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; case "4": 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 + "%'"; } sWhere += getDeptIDByUser();//ç¨æ·å ³èé¨é¨è¿æ»¤ get_Display(sWhere); sWhere = "";//è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å } //å è½½ç½æ ¼ function get_Display(sWhere) { var wait = layer.load(); $.ajax({ url: GetWEBURL() + '/Cj_StationEntrustOutBill/list', type: "GET", data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]}, 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 = ''; syncMessage = []; 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 (data1) { if (data1.count == 1) { // 说æéªè¯æåäºï¼ layer.msg(data1.Message, { time: 1 * 1000, icon: 1 }, function () { var index = parent.layer.getFrameIndex(window.name); //å å¾å°å½åiframeå±çç´¢å¼ parent.layer.close(index); //åæ§è¡å ³é           }); } else { let errMessage = []; errMessage.push(data1.Message); syncMessage.push(errMessage); layer.alert(data1.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 导åºExecel function get_Export() { var data = option.data; data.forEach((item) => { for (let itemobj in item) { if (item[itemobj] == null) { item[itemobj] = ""; } if (item[itemobj].length > 0) { // å设å段å为field item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 item[itemobj] = item[itemobj].toString().replace(/,/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 } } }); table.exportFile('mainTable', data, "xls"); } //#endregion //#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 //åææ¾ç¤ºä¸ææ¡ 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); } //#region æ ¹æ®ç¨æ·è·åç¨æ·å ³èé¨é¨çè¿æ»¤æ¡ä»¶ function getDeptIDByUser() { var res = ""; $.ajax({ type: "GET", async: false, url: GetWEBURL() + "/Xt_User/UserDeptlistPlaylist", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "HUserID": sessionStorage["Czybm"] }, success: function (result) { if (result.count == 1) { if (result.data.length > 0) { for (let item of result.data) { res += item.HItemID.toString() + "," } res = res.slice(0, -1); res = ` and HDeptID in (${res})` } } }, error: function (err) { res = " and 1 = 0"; layer.alert(get_MessageError("[0000-1-002]æ¥å£è¯·æ±å¤±è´¥!", sessionStorage["HTranSlate"]), { icon: 5 }); } }); return res; } //#endregion //以ä¸æ¯layui模å }); </script> </body> </html> WebTM/views/³µ¼ä¹ÜÀí/¹¤Ðò³öÕ¾»ã±¨µ¥/Cj_StationOutBillSync.html
@@ -107,7 +107,7 @@ <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" style="" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导åºé误信æ¯</button> <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></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> @@ -247,7 +247,7 @@ break; //导åºexcel case 'get_export': table.exportFile(['é误信æ¯'], syncMessage, 'xls'); get_Export(); break; //éåº case 'btn-Exit': get_Exit(); @@ -466,8 +466,41 @@ } } //#region 导åºExecel function get_Export() { var ModRightNameCheck = "Cj_StationOutBillList_ExportExcel"; var data = option.data; //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, success: function (result) { if (result.count == 1) { data.forEach((item) => { for (let itemobj in item) { if (item[itemobj] == null) { item[itemobj] = ""; } if (item[itemobj].length > 0) { // å设å段å为field item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 item[itemobj] = item[itemobj].toString().replace(/,/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 } } }); table.exportFile('mainTable', data, "xls"); } else { layer.alert(get_MessageError("[å½å模å没æ导åºæé]å½å模å没æ导åºæé!", sessionStorage["HTranSlate"]), { icon: 5 }); } }, error: function () { layer.alert(get_MessageError("[0000-1-002]æ¥å£è¯·æ±å¤±è´¥!", sessionStorage["HTranSlate"]), { icon: 5 }); } }); } //#endregion //#region ç¹å»è¡éä¸é«äº® table.on('row(mainTablemainTable)', function (obj) { table.on('row(mainTable)', function (obj) { //éä¸è¡æ¹åé¢è² var flag = !obj.tr.find(':checkbox:first').prop('checked'); obj.tr.find(':checkbox').prop('checked', flag);
