| | |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>é¦ä»¶æ£éªåå表</title> |
| | | <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"> |
| | |
| | | <label class="layui-form-label" style="width: 85px;">ç»ææ¥æ</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HDate2" id="HDate2"> |
| | | </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent"> |
| | | </div> |
| | | </div> <div class="layui-row" style="margin-top:5px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName1" id="ColName1" lay-filter="ColName1" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator1" id="Comparator1" lay-filter="Comparator1" 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="ColContent1" id="ColContent1"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin-top:5px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName2" id="ColName2" lay-filter="ColName2" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator2" id="Comparator2" lay-filter="Comparator2" 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="ColContent2" id="ColContent2"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | |
| | | //#region æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | if ($("#HProject").val() == 0) { |
| | | get_FastQuery(); |
| | | } else { |
| | | get_FastQuery(2); |
| | | } |
| | | }); |
| | | //#endregion |
| | | |
| | |
| | | $("#HDate2").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | //RoadHBillNo(sql); |
| | | //è·å项ç®å· |
| | | Get_HProject(); |
| | | //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ |
| | | get_DefaultModule(); |
| | | |
| | |
| | | , totalRow: true |
| | | //, cellMinWidth: 90 |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 50000] |
| | | , limits: [50, 500, 5000, 20000] |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | }; |
| | | } |
| | | //#endregion |
| | | //#endregion çå¬ç½æ ¼è¡¨ä½äºä»¶ |
| | | table.on('tool(mainTable)', function (obj) { |
| | | var data = obj.data; |
| | | |
| | | //åæ®å·è¶
龿¥ |
| | | if (obj.event == 'åæ®å·') { //æ£æ¥ obj.event æ¯å¦çäºå符串 'åæ®å·'ã妿çäºï¼åæ§è¡ifå¾ªç¯ |
| | | var linterid = data.hmainid.toString(); //声æåélinterid 为 data.hmainid |
| | | //if (AllowLoadData(sSubStr) != false) {//é空éªè¯ |
| | | layer.open({ //ä½¿ç¨ layerçopenæå¼å¼¹åº å± |
| | | type: 2 //表示弹åºå±çå
容æ¯ä¸ä¸ª iframe |
| | | , area: ['100%', '100%'] |
| | | , title: 'ç¼è¾' + HPageTitle //设置弹åºå±çååååé |
| | | , closeBtn: 1//æ¾ç¤ºå
³éæé® |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: '../车é´èªæ£å/QC_Add_Edit_WorkSelfCheckBill.html?OperationType=3&hID=' + linterid //设置 iframe ç URLï¼URL ä¸å
å«äºæ¥è¯¢åæ°ï¼æ¥è°ç¨æéè¦çå¼ |
| | | |
| | | , resize: false, //æ¯å¦å
è®¸ç¨æ·è°æ´å¼¹åºå¤§å° |
| | | end: function () { //å½å
³éæ¶è°ç¨ |
| | | get_FastQuery(table, option); |
| | | } |
| | | , cancel: function () { //ç¹å»åæ¶æ¶ä½¿ç¨åè° |
| | | //$(".layui-btn").removeClass("layui-btn-disabled"); |
| | | } |
| | | }) |
| | | } |
| | | }); |
| | | //#endregion |
| | | //#region æ¥è¯¢ |
| | | function RoadHBillNo(sqlWhere) { |
| | | var ajaxLoad = layer.load(); |
| | |
| | | data: { "sWhere": sqlWhere, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | |
| | | var totalArray = []; |
| | | var data = []; |
| | | var col = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | |
| | | for (var i = 0; i < data.length; i++) { |
| | | if ($.inArray(data[i].name, titleData) > -1) { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå |
| | | } else if ($.inArray(data[i].name, totalArray) > -1) { //计ç®å |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 }); |
| | | } else if (data[i].name == 'åæ®å·') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'åæ®å·' }); |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | |
| | | |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | function get_FastQuery(number) { |
| | | var sqlWhere = " and 1=1 "; |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HProject = $("#HProject").val();//项ç®å· |
| | | var HNumber = $("#HNumber").val();//ç©æç¼ç |
| | | var HName = $("#HName").val();//ç©æåç§° |
| | | var HModel = $("#HModel").val();//è§æ ¼åå· |
| | |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | | var ColContent = $("#ColContent").val(); |
| | | |
| | | var ColName1 = $("#ColName1").val();//å¤éæ¡ |
| | | var Comparator1 = $("#Comparator1").val() |
| | | var ColContent1 = $("#ColContent1").val(); |
| | | var ColName2 = $("#ColName2").val();//å¤éæ¡ |
| | | var Comparator2 = $("#Comparator2").val() |
| | | var ColContent2 = $("#ColContent2").val(); |
| | | |
| | | if (ColName != 0 && Comparator != 0) { |
| | | var com = ""; |
| | |
| | | } |
| | | sqlWhere += " and " + ColName + " " + com; |
| | | } |
| | | |
| | | if (ColName1 != 0 && Comparator1 != 0) { |
| | | var com1 = ""; |
| | | switch (Comparator1) { |
| | | case "7": |
| | | com1 = "like'%" + ColContent1 + "%'"; |
| | | break; |
| | | case "8": |
| | | com1 = "like'%" + ColContent1 + "'"; |
| | | break; |
| | | case "9": |
| | | com1 = "like'" + ColContent1 + "%'"; |
| | | break; |
| | | case "10": |
| | | com1 = "not like'%" + ColContent1 + "%'"; |
| | | break; |
| | | default: |
| | | com1 = "" + Comparator1 + "'" + ColContent1 + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName1 + " " + com1; |
| | | } |
| | | if (ColName2 != 0 && Comparator2 != 0) { |
| | | var com2 = ""; |
| | | switch (Comparator2) { |
| | | case "7": |
| | | com2 = "like'%" + ColContent2 + "%'"; |
| | | break; |
| | | case "8": |
| | | com2 = "like'%" + ColContent2 + "'"; |
| | | break; |
| | | case "9": |
| | | com2 = "like'" + ColContent2 + "%'"; |
| | | break; |
| | | case "10": |
| | | com2 = "not like'%" + ColContent2 + "%'"; |
| | | break; |
| | | default: |
| | | com2 = "" + Comparator + "'" + ColContent + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName2 + " " + com2; |
| | | } |
| | | if (HBillNo) |
| | | sqlWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | if (HNumber) |
| | |
| | | if (HDate2) { |
| | | sqlWhere += " and æ¥æ <= '" + HDate2 + "'"; |
| | | } |
| | | if (number==2) { |
| | | if (HProject) { |
| | | sqlWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | } |
| | | RoadHBillNo(sqlWhere); |
| | | } |
| | | //#endregion |
| | |
| | | //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | function set_ClearQuery() { |
| | | $("#HBillNo").val(""); |
| | | $("#HProject").val(""); |
| | | $("#HProNumber").val(""); |
| | | $("#HName").val(""); |
| | | $("#HReceiveEmp").val(""); |
| | | $("#HBillStatus").val(""); |
| | | |
| | | $("#HProject").val(""); |
| | | $("#HNumber").val(""); |
| | | $("#HModel").val(""); |
| | | $("#HName1").val(""); |
| | |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | | $("#ColContent2").val(""); |
| | | $("#ColName2").val("0"); |
| | | $("#Comparator2").val("0"); |
| | | $("#ColContent1").val(""); |
| | | $("#ColName1").val("0"); |
| | | $("#Comparator1").val("0"); |
| | | form.render('select'); |
| | | |
| | | sWhere = ""; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | |
| | | |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | //var titleData = ["åæ®ID", "HMouldID", "hsubid", "HManagerID", "æºå主å
ç ", "æºååå
ç "];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | |
| | | //ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | var titleData = ["hmainid", "hentryid", "HEntryID", "HSourceID", "HMaterID", "HFirstCheckEmp", "HQCCheckItemID", "HUnitID", "HSampleSchemeID", "HInspectinstruMentlD", "HShiftslD", "æ£æµå¼åºç¡èµæ", "ç®æ å¼åºç¡èµæ"]; |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option.cols[0].length - 1; i++) { |
| | |
| | | Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>'; |
| | | } |
| | | } |
| | | $("#ColName1").empty(); |
| | | $("#ColName1").append(Organization); |
| | | $("#ColName2").empty(); |
| | | $("#ColName2").append(Organization); |
| | | $("#ColName").empty(); |
| | | $("#ColName").append(Organization); |
| | | form.render('select'); |