| WebTM/WebTM.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/index.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/车间管理/工序流转卡/MES_ColorRecordBillList.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/车间管理/工序流转卡/MES_SampleRecordBillList.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebTM/WebTM.csproj
@@ -272,6 +272,8 @@ <Content Include="views\车é´ç®¡ç\å·¥åºåºç«æ±æ¥å\Cj_StationOutBillSubList.html" /> <Content Include="views\车é´ç®¡ç\å·¥åºæµè½¬\MES_ColorRecordBill_PDA.html" /> <Content Include="views\车é´ç®¡ç\å·¥åºæµè½¬\MES_SampleRecordBill_PDA.html" /> <Content Include="views\车é´ç®¡ç\å·¥åºæµè½¬å¡\MES_ColorRecordBillList.html" /> <Content Include="views\车é´ç®¡ç\å·¥åºæµè½¬å¡\MES_SampleRecordBillList.html" /> <Content Include="views\车é´ç®¡ç\å·¥åºæµè½¬å¡\Sc_ProcessExchangeBillQuery_Mobile.html" /> <Content Include="views\车é´ç®¡ç\å·¥åºæµè½¬å¡\Sc_ProcessExchangeBillSubList.html" /> <Content Include="views\车é´ç®¡ç\å·¥åºæµè½¬å¡\Sc_ProcessExchangeBill_Change.html" /> WebTM/views/index.html
@@ -463,6 +463,8 @@ <dd><a lay-href="车é´ç®¡ç/å·¥åºæµè½¬å¡/Sc_ProcessExchangeBill.html">å·¥åºæµè½¬å¡</a></dd> <dd><a lay-href="车é´ç®¡ç/å·¥åºæµè½¬å¡/Sc_ProcessExchangeBillList.html">å·¥åºæµè½¬å¡ç»´æ¤</a></dd> <dd><a lay-href="车é´ç®¡ç/å·¥åºæµè½¬å¡/Sc_ProcessExchangeBillSubList.html">å·¥åºåæµè½¬å¡ç»´æ¤</a></dd> <dd><a lay-href="车é´ç®¡ç/å·¥åºæµè½¬å¡/MES_SampleRecordBillList.html">è¯æ ·è®°å½åå表</a></dd> <dd><a lay-href="车é´ç®¡ç/å·¥åºæµè½¬å¡/MES_ColorRecordBillList.html">对è²è®°å½åå表</a></dd> <dd><a lay-href="车é´ç®¡ç/å·¥åºæµè½¬å¡/Sc_ProcessExchangeIssueBillList.html">å·¥åºæµè½¬å¡ï¼ä¸è¾¾ï¼</a></dd> <dd><a lay-href="车é´ç®¡ç/å·¥åºæµè½¬å¡/Sc_ProcExchWorkBackBillList.html">å·¥åºè¿å·¥ç³è¯·å表</a></dd> <!--<dd><a lay-href="车é´ç®¡ç/å·¥åºæµè½¬å¡/Sc_ProcExchWorkBackBillEdit.html">å·¥åºè¿å·¥ç³è¯·</a></dd>--> WebTM/views/³µ¼ä¹ÜÀí/¹¤ÐòÁ÷ת¿¨/MES_ColorRecordBillList.html
New file @@ -0,0 +1,568 @@ <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; 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/Scripts/json2.js"></script> <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> <script src="../../../layuiadmin/Scripts/webConfig.js"></script> <script src="../../../layuiadmin/PubCustom.js"></script> <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> <style type="text/css"> input.layui-input.layui-unselect { padding-right: 0; } </style> </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-form layui-inline" style="position:relative;top:10px;"> <label class="layui-form-label">æ¥æ</label> <div class="layui-form-item layui-inline"> <div class="layui-inline"> <div class="layui-input-inline"> <input type="date" class="layui-input" id="HBeginDate" style="width:190px;" placeholder="yyyy-MM-dd"> </div> </div> </div> <div class="layui-form-item layui-inline"> <div class="layui-inline"> <label class="layui-form-label">-</label> <div class="layui-input-inline"> <input type="date" class="layui-input" id="HEndDate" style="width:190px;" placeholder="yyyy-MM-dd"> </div> </div> </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> <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" style="padding: 0px; margin-left: 6%;"> <div class="layui-row" style="margin-top:10px;"> <!--å ¶ä»æ¡ä»¶--> <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="HMaterNumber" id="HMaterNumber"> </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="HProductName" id="HProductName"> </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="HProductModel" id="HProductModel"> </div> </div> </div> <div class="layui-row" style="margin:10px 0px"> <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> </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="btnCheck"><i class="layui-icon layui-icon-form"></i>å®¡æ ¸</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btnAdutCheck"><i class="layui-icon layui-icon-form"></i>åå®¡æ ¸</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btnDel"><i class="layui-icon layui-icon-delete"></i>å é¤</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèå设置</button> </div> </script> </form> </div> </div> </div> </div> <script> layui.config({ base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ }).extend({ index: 'lib/index', //ä¸»å ¥å£æ¨¡å }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { //#region å ¬å ±åé 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 //æ¥è¯¢æ¡ä»¶ var sWhere = ""; var option = []; var HModName = "MES_SampleRecordBillList"; //#endregion //#region è¿å ¥é¡µé¢æ¢å è½½ //#region åå§åçé¢ set_ClearBill(); //#endregion //#region ç¹å»äºä»¶å æ¬on formäºä»¶ç //å¤´å·¥å ·æ äºä»¶ table.on('toolbar(mainTable)', function (obj) { switch (obj.event) { //å®¡æ ¸ case 'btnCheck': btnCheck(1); break; //åå®¡æ ¸ case 'btnAdutCheck': btnCheck(2); break; //å é¤ case 'btnDel': btnDel(); break; //éåº case 'btn-exit': Pub_Close(2); break; //éèå设置 case 'HideColumn': get_HideColumn(); break; }; }); //éç½®æé® form.on('submit(btnReSearch)', function (data) { set_ClearQuery(); }); //æ¥è¯¢æé® form.on('submit(btnSearch)', function (data) { get_FastQuery(); }); //è¡çå¬äºä»¶-åå» 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 //#region æ¤é¡µé¢ææçæ¹æ³ //åå§åçé¢ function set_ClearBill() { //åå§åæ¶é´ $("#HBeginDate").val(Format(new Date() - 1000 * 60 * 60 * 24 * 30, "yyyy-MM-dd")); $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); //å è½½æ°æ®å°ç½æ ¼ get_FastQuery(); DisPlay_HideColumn(); } //åææ¾ç¤ºä¸ææ¡ 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_Display(sWhere) { //å¨æå-ç¼åå表 $.ajax({ url: GetWEBURL() + "/ColorRecord/ColorRecordList", type: "GET", async: false, data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.count == 1) { var data = []; var col = []; //ç»ç©ºçæ°ç»èµå¼ 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' }); for (var i = 0; i < data.length; i++) { if ($.inArray(data[i].name, "") > -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: true }); break; default: col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true }); } } } option = { elem: '#mainTable' , toolbar: '#toolbarDemo' , cellMinWidth: 120 , page: true , limit: 50 , limits: [50, 500, 5000, 20000] , height: 'full-70' , totalRow: false //å¼å¯å计 , cols: [col] , data: data1.data }; table.render(option); } }, error: function (err) { layer.msg('é误' + err, { icon: 5, time: 20000 }, function () { //do something }); } }) } //å¿«éè¿æ»¤ function get_FastQuery() { var HBeginDate = $("#HBeginDate").val();//ä¸è¾¾æ¥æ å¼å§æ¥æ var HEndDate = $("#HEndDate").val();//ç»ææ¥æ var HMaterNumber = $("#HMaterNumber").val();//ç©æ代ç var HBillNo = $("#HBillNo").val(); //åæ®å· var HProductName = $("#HProductName").val();//产åå称 var HProductModel = $("#HProductModel").val();//产åè§æ ¼ if (HBeginDate != "" && HEndDate != "") { sWhere += " and æ¥æ between '" + HBeginDate + "' and '" + HEndDate + "' "; } if (HMaterNumber != "") { sWhere += " and ç©æ代ç ='" + HMaterNumber + "' "; } if (HBillNo != "") { sWhere += " and æå¼å¡å·='" + HBillNo + "' "; } if (HProductName != "") { sWhere += " and ç©æå称='" + HProductName + "' "; } if (HProductModel != "") { sWhere += " and è§æ ¼åå·='" + HProductModel + "' "; } //ä»»æå段æ¡ä»¶è¿æ»¤ æ¡ä»¶æå var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); //æ¼æ¥ä»»ä¸å段è¿æ»¤æ¥è¯¢æ¡ä»¶ var com = ""; if (ColName != 0 && Comparator != 0) { 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; } com = " and (" + ColName + " " + com + ")"; } sWhere += com; get_Display(sWhere); //è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å sWhere = ""; } //éç½®è¿æ»¤æ¡ä»¶ function set_ClearQuery() { //åå§åæ¶é´ $("#HBeginDate").val(Format(new Date() - 1000 * 60 * 60 * 24 * 30, "yyyy-MM-dd")); $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); $("#HMaterNumber").val(""); $("#HBillNo").val(""); $("#HProductName").val(""); $("#HProductModel").val(""); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); ColFilter(); sWhere = ""; } //å®¡æ ¸ [1 å®¡æ ¸ã2 åå®¡æ ¸] function btnCheck(num) { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (data.length == 1) { layer.confirm("确认è¦å®¡æ ¸å?", function (index) { var wait = layer.load(); var HInterID = data[0].hmainid; $.ajax({ url: GetWEBURL() + '/ColorRecord/CheckColorRecordBill', type: "GET", data: { "HInterID": HInterID, "Type": num, "user": sessionStorage["HUserName"] }, success: function (result) { if (result.count == 1) { get_FastQuery(); layer.msg(result.Message, { icon: 1 }); layer.close(wait); } else { layer.alert(result.code + result.Message, { icon: 5 }); layer.close(wait); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); layer.close(wait); } }); }) } else { layer.msg("请éæ©ä¸æ¡æ°æ®!"); } } //å é¤ function btnDel() { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (checkStatus.data.length === 1) { var hmainid = data[0].hmainid; layer.confirm("确认è¦å é¤åï¼å é¤åä¸è½æ¢å¤", { title: "å é¤ç¡®è®¤" }, function (index) { var wait = layer.load(); //é»è¾å é¤æ¹æ³ $.ajax({ url: GetWEBURL() + '/ColorRecord/DelColorRecordBill', type: "GET", data: { "lngBillKey": hmainid, "user": sessionStorage["HUserName"] }, success: function (result) { console.log('gouba' + result); if (result.count == 1) { layer.msg(result.Message, { icon: 1 }, function () { // å¾å°frameç´¢å¼ var index = layer.getFrameIndex(window.name); //å ³éå½åframe layer.close(wait); //ä¿®æ¹ä¸ºååå·æ°çé¢ get_FastQuery(); }); } else { layer.alert(result.code + result.Message, { icon: 5 }); layer.close(wait); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); layer.close(wait); } }); }) } else { layer.msg('请éæ©ä¸è¡æ°æ®å é¤ï¼'); } } //éèå设置 function get_HideColumn() { var colName = ""; for (var i = 1; i < option.cols[0].length; i++) { colName += option.cols[0][i]["title"] + ","; } colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç layer.open({ type: 2 , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ , title: "éèå设置" //æ é¢ , closeBtn: 1 //çªä½å³ä¸è§å ³é ç æ ·å¼ , shift: 2 //å¼¹åºå¨ç» , area: ["50%", "90%"] //çªä½å¤§å° , maxmin: true //设置æ大æå°æé®æ¯å¦æ¾ç¤º , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"] , btn: ["ç¡®å®", "åæ¶"] , btn1: function (index, laero) { //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); //æ´æ°è¡¨æ ¼ç¼åçæ°æ® layer.close(index);//å ³éå¼¹çª } }) } //æ¾ç¤ºåæ°æ® function DisPlay_HideColumn() { ColFilter(); $.ajax({ url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', type: "GET", data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.data.length != 0) { var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® var titleData = [];//ä¸éè¦æ¾ç¤ºçå段 å¯æ©å± dataCol = data1.data[0].HGridString.split(','); for (var i = 0; i < option.cols[0].length - 1; i++) { if (dataCol[i]) { var dataCols = dataCol[i].split('|'); } //éèå if (dataCols[1] == 1) { option.cols[0][i + 1]["hide"] = true; } //设置å 容åä½å¤§å° if (data1.data[0].HFontSize != 0) { option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; } else { option.cols[0][i + 1]["style"] = "font-size:100%"; } //设置å宽 if (dataCols[3] > 0) { option.cols[0][i + 1]["width"] = dataCols[3]; } //æ¾ç¤ºå if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { option.cols[0][i + 1]["hide"] = false; } //åä½æå¨ä½ç½®(å·¦ å± ä¸ å³) switch (dataCols[2]) { case "L": option.cols[0][i + 1]["align"] = "left"; break; case "M": option.cols[0][i + 1]["align"] = "center"; break; case "R": option.cols[0][i + 1]["align"] = "right"; break; } } //åæ¶å»ç»å for (var i = 1; i < option.cols[0].length - 1; i++) { if (option.cols[0][i]["fixed"] != null) { option.cols[0][i]["fixed"] = null; } else { break; } } //å»ç»å if (data1.data[0].HFixCols != 0) { for (var i = 0; i < data1.data[0].HFixCols; i++) { if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { data1.data[0].HFixCols += 1; } option.cols[0][i + 1]["fixed"] = "left"; } } table.render(option); } else { table.render(option); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }) } //#endregion }); </script> </body> </html> WebTM/views/³µ¼ä¹ÜÀí/¹¤ÐòÁ÷ת¿¨/MES_SampleRecordBillList.html
New file @@ -0,0 +1,568 @@ <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; 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/Scripts/json2.js"></script> <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> <script src="../../../layuiadmin/Scripts/webConfig.js"></script> <script src="../../../layuiadmin/PubCustom.js"></script> <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> <style type="text/css"> input.layui-input.layui-unselect { padding-right: 0; } </style> </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-form layui-inline" style="position:relative;top:10px;"> <label class="layui-form-label">æ¥æ</label> <div class="layui-form-item layui-inline"> <div class="layui-inline"> <div class="layui-input-inline"> <input type="date" class="layui-input" id="HBeginDate" style="width:190px;" placeholder="yyyy-MM-dd"> </div> </div> </div> <div class="layui-form-item layui-inline"> <div class="layui-inline"> <label class="layui-form-label">-</label> <div class="layui-input-inline"> <input type="date" class="layui-input" id="HEndDate" style="width:190px;" placeholder="yyyy-MM-dd"> </div> </div> </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> <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" style="padding: 0px; margin-left: 6%;"> <div class="layui-row" style="margin-top:10px;"> <!--å ¶ä»æ¡ä»¶--> <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="HMaterNumber" id="HMaterNumber"> </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="HProductName" id="HProductName"> </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="HProductModel" id="HProductModel"> </div> </div> </div> <div class="layui-row" style="margin:10px 0px"> <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> </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="btnCheck"><i class="layui-icon layui-icon-form"></i>å®¡æ ¸</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btnAdutCheck"><i class="layui-icon layui-icon-form"></i>åå®¡æ ¸</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btnDel"><i class="layui-icon layui-icon-delete"></i>å é¤</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèå设置</button> </div> </script> </form> </div> </div> </div> </div> <script> layui.config({ base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ }).extend({ index: 'lib/index', //ä¸»å ¥å£æ¨¡å }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { //#region å ¬å ±åé 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 //æ¥è¯¢æ¡ä»¶ var sWhere = ""; var option = []; var HModName = "MES_SampleRecordBillList"; //#endregion //#region è¿å ¥é¡µé¢æ¢å è½½ //#region åå§åçé¢ set_ClearBill(); //#endregion //#region ç¹å»äºä»¶å æ¬on formäºä»¶ç //å¤´å·¥å ·æ äºä»¶ table.on('toolbar(mainTable)', function (obj) { switch (obj.event) { //å®¡æ ¸ case 'btnCheck': btnCheck(1); break; //åå®¡æ ¸ case 'btnAdutCheck': btnCheck(2); break; //å é¤ case 'btnDel': btnDel(); break; //éåº case 'btn-exit': Pub_Close(2); break; //éèå设置 case 'HideColumn': get_HideColumn(); break; }; }); //éç½®æé® form.on('submit(btnReSearch)', function (data) { set_ClearQuery(); }); //æ¥è¯¢æé® form.on('submit(btnSearch)', function (data) { get_FastQuery(); }); //è¡çå¬äºä»¶-åå» 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 //#region æ¤é¡µé¢ææçæ¹æ³ //åå§åçé¢ function set_ClearBill() { //åå§åæ¶é´ $("#HBeginDate").val(Format(new Date() - 1000 * 60 * 60 * 24 * 30, "yyyy-MM-dd")); $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); //å è½½æ°æ®å°ç½æ ¼ get_FastQuery(); DisPlay_HideColumn(); } //åææ¾ç¤ºä¸ææ¡ 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_Display(sWhere) { //å¨æå-ç¼åå表 $.ajax({ url: GetWEBURL() + "/MES_SampleRecordBill_PDA/SampleRecordList", type: "GET", async: false, data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.count == 1) { var data = []; var col = []; //ç»ç©ºçæ°ç»èµå¼ 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' }); for (var i = 0; i < data.length; i++) { if ($.inArray(data[i].name, "") > -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: true }); break; default: col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true }); } } } option = { elem: '#mainTable' , toolbar: '#toolbarDemo' , cellMinWidth: 120 , page: true , limit: 50 , limits: [50, 500, 5000, 20000] , height: 'full-70' , totalRow: false //å¼å¯å计 , cols: [col] , data: data1.data }; table.render(option); } }, error: function (err) { layer.msg('é误' + err, { icon: 5, time: 20000 }, function () { //do something }); } }) } //å¿«éè¿æ»¤ function get_FastQuery() { var HBeginDate = $("#HBeginDate").val();//ä¸è¾¾æ¥æ å¼å§æ¥æ var HEndDate = $("#HEndDate").val();//ç»ææ¥æ var HMaterNumber = $("#HMaterNumber").val();//ç©æ代ç var HBillNo = $("#HBillNo").val(); //åæ®å· var HProductName = $("#HProductName").val();//产åå称 var HProductModel = $("#HProductModel").val();//产åè§æ ¼ if (HBeginDate != "" && HEndDate != "") { sWhere += " and æ¥æ between '" + HBeginDate + "' and '" + HEndDate + "' "; } if (HMaterNumber != "") { sWhere += " and ç©æ代ç ='" + HMaterNumber + "' "; } if (HBillNo != "") { sWhere += " and æå¼å¡å·='" + HBillNo + "' "; } if (HProductName != "") { sWhere += " and ç©æå称='" + HProductName + "' "; } if (HProductModel != "") { sWhere += " and è§æ ¼åå·='" + HProductModel + "' "; } //ä»»æå段æ¡ä»¶è¿æ»¤ æ¡ä»¶æå var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); //æ¼æ¥ä»»ä¸å段è¿æ»¤æ¥è¯¢æ¡ä»¶ var com = ""; if (ColName != 0 && Comparator != 0) { 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; } com = " and (" + ColName + " " + com + ")"; } sWhere += com; get_Display(sWhere); //è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å sWhere = ""; } //éç½®è¿æ»¤æ¡ä»¶ function set_ClearQuery() { //åå§åæ¶é´ $("#HBeginDate").val(Format(new Date() - 1000 * 60 * 60 * 24 * 30, "yyyy-MM-dd")); $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); $("#HMaterNumber").val(""); $("#HBillNo").val(""); $("#HProductName").val(""); $("#HProductModel").val(""); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); ColFilter(); sWhere = ""; } //å®¡æ ¸ [1 å®¡æ ¸ã2 åå®¡æ ¸] function btnCheck(num) { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (data.length == 1) { layer.confirm("确认è¦å®¡æ ¸å?", function (index) { var wait = layer.load(); var HInterID = data[0].hmainid; $.ajax({ url: GetWEBURL() + '/MES_SampleRecordBill_PDA/CheckSampleRecordBill', type: "GET", data: { "HInterID": HInterID, "Type": num, "user": sessionStorage["HUserName"] }, success: function (result) { if (result.count == 1) { get_FastQuery(); layer.msg(result.Message, { icon: 1 }); layer.close(wait); } else { layer.alert(result.code + result.Message, { icon: 5 }); layer.close(wait); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); layer.close(wait); } }); }) } else { layer.msg("请éæ©ä¸æ¡æ°æ®!"); } } //å é¤ function btnDel() { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (checkStatus.data.length === 1) { var hmainid = data[0].hmainid; layer.confirm("确认è¦å é¤åï¼å é¤åä¸è½æ¢å¤", { title: "å é¤ç¡®è®¤" }, function (index) { var wait = layer.load(); //é»è¾å é¤æ¹æ³ $.ajax({ url: GetWEBURL() + '/MES_SampleRecordBill_PDA/DelSampleRecordBill', type: "GET", data: { "lngBillKey": hmainid, "user": sessionStorage["HUserName"] }, success: function (result) { console.log('gouba' + result); if (result.count == 1) { layer.msg(result.Message, { icon: 1 }, function () { // å¾å°frameç´¢å¼ var index = layer.getFrameIndex(window.name); //å ³éå½åframe layer.close(wait); //ä¿®æ¹ä¸ºååå·æ°çé¢ get_FastQuery(); }); } else { layer.alert(result.code + result.Message, { icon: 5 }); layer.close(wait); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); layer.close(wait); } }); }) } else { layer.msg('请éæ©ä¸è¡æ°æ®å é¤ï¼'); } } //éèå设置 function get_HideColumn() { var colName = ""; for (var i = 1; i < option.cols[0].length; i++) { colName += option.cols[0][i]["title"] + ","; } colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç layer.open({ type: 2 , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ , title: "éèå设置" //æ é¢ , closeBtn: 1 //çªä½å³ä¸è§å ³é ç æ ·å¼ , shift: 2 //å¼¹åºå¨ç» , area: ["50%", "90%"] //çªä½å¤§å° , maxmin: true //设置æ大æå°æé®æ¯å¦æ¾ç¤º , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"] , btn: ["ç¡®å®", "åæ¶"] , btn1: function (index, laero) { //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); //æ´æ°è¡¨æ ¼ç¼åçæ°æ® layer.close(index);//å ³éå¼¹çª } }) } //æ¾ç¤ºåæ°æ® function DisPlay_HideColumn() { ColFilter(); $.ajax({ url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', type: "GET", data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.data.length != 0) { var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® var titleData = [];//ä¸éè¦æ¾ç¤ºçå段 å¯æ©å± dataCol = data1.data[0].HGridString.split(','); for (var i = 0; i < option.cols[0].length - 1; i++) { if (dataCol[i]) { var dataCols = dataCol[i].split('|'); } //éèå if (dataCols[1] == 1) { option.cols[0][i + 1]["hide"] = true; } //设置å 容åä½å¤§å° if (data1.data[0].HFontSize != 0) { option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; } else { option.cols[0][i + 1]["style"] = "font-size:100%"; } //设置å宽 if (dataCols[3] > 0) { option.cols[0][i + 1]["width"] = dataCols[3]; } //æ¾ç¤ºå if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { option.cols[0][i + 1]["hide"] = false; } //åä½æå¨ä½ç½®(å·¦ å± ä¸ å³) switch (dataCols[2]) { case "L": option.cols[0][i + 1]["align"] = "left"; break; case "M": option.cols[0][i + 1]["align"] = "center"; break; case "R": option.cols[0][i + 1]["align"] = "right"; break; } } //åæ¶å»ç»å for (var i = 1; i < option.cols[0].length - 1; i++) { if (option.cols[0][i]["fixed"] != null) { option.cols[0][i]["fixed"] = null; } else { break; } } //å»ç»å if (data1.data[0].HFixCols != 0) { for (var i = 0; i < data1.data[0].HFixCols; i++) { if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { data1.data[0].HFixCols += 1; } option.cols[0][i + 1]["fixed"] = "left"; } } table.render(option); } else { table.render(option); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }) } //#endregion }); </script> </body> </html>
