| | |
| | | <span>æ´å¤</span> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">å¼å¸¸åé¦ç±»å代ç </label> |
| | | <div class="layui-inline" style="width:400px"> |
| | | <label class="layui-form-label" style="white-space: nowrap;width:100px">å¼å¸¸åé¦ç±»å代ç </label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HNumber" id="HNumber"> |
| | | <input type="text" class="layui-input" name="HNumber" id="HNumber" style="width:200px"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">å¼å¸¸åé¦ç±»ååç§°</label> |
| | | <div class="layui-inline" style="width:400px"> |
| | | <label class="layui-form-label" style="white-space: nowrap;width:100px">å¼å¸¸åé¦ç±»ååç§°</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HName" id="HName"> |
| | | <input type="text" class="layui-input" name="HName" id="HName" style="width:200px"> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | |
| | | <input type="text" class="layui-input" 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> |
| | | </div> |
| | | </div> |
| | |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add" id="AddButton"><i class="layui-icon layui-icon-file-b"></i>æ°å¢</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit" id="EditButton"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete" id="DeleteButton"><i class="layui-icon layui-icon-delete"></i>å é¤</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel"><i class="layui-icon layui-icon-delete"></i>导å
¥</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="RefreshButton"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit" id="AuditButton"><i class="layui-icon layui-icon-radio"></i>å®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit" id="DeAuditButton"><i class="layui-icon layui-icon-circle"></i>åå®¡æ ¸</button> |
| | |
| | | break; |
| | | //å é¤ |
| | | case 'btn-Delete': set_DeleteBill(); |
| | | break; |
| | | //导å
¥ |
| | | case 'set_SouceExcel': set_SouceExcel(); |
| | | break; |
| | | //å·æ° |
| | | case 'get_Refresh': get_Refresh(); |
| | |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region |
| | | table.on('tool(mainTable)', function (obj){ |
| | | var data = obj.data; //æobjæ°æ®èµå¼ç» dataåé |
| | | |
| | | //åæ®å·è¶
龿¥ |
| | | //å¤æå¯¹è±¡äºä»¶æ¯å¦ä¸ºåæ®å· |
| | | if (obj.event == 'åæ®å·') { //æ£æ¥ obj.eventäºä»¶ æ¯å¦çäºå符串 'åæ®å·'ã妿çäºï¼åæ§è¡ifå¾ªç¯ |
| | | var linterid = data.hmainid.toString(); //声æåélinterid 为 data.hmainid æè¡¨ååæ®èµå¼ç»å£°æåélinterid |
| | | //if (AllowLoadData(sSubStr) != false) {//é空éªè¯ |
| | | layer.open({ //ä½¿ç¨ layerçopenæå¼å¼¹åº å± |
| | | type: 2 //表示弹åºå±çå
容æ¯ä¸ä¸ª iframe ç±»å为2 |
| | | , area: ['100%', '100%'] //å¼¹åºå±ç大尿¯ |
| | | , title: 'ç¼è¾å¼å¸¸åé¦ç±»å' //设置弹åºå±çååååé |
| | | , closeBtn: 1 //æ¾ç¤ºå
³éæé® |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | //设置 iframe ç URLï¼URL ä¸å
å«äºæ¥è¯¢åæ°ï¼æ¥è°ç¨æéè¦çå¼ |
| | | , content: '../åºç¡å»ºæ¨¡/Add_Edit_Gy_ErrMsgBackType.html?OperationType=3&linterid=' + linterid + '&HSouceBillType=' |
| | | , resize: false, //æ¯å¦å
è®¸ç¨æ·è°æ´å¼¹åºå¤§å° |
| | | end: function () { //å½å
³éæ¶è°ç¨ |
| | | get_FastQuery(table, option); //æ§è¡æ¥è¯¢ï¼è¡¨åéé¡¹ï¼ |
| | | } |
| | | , cancel: function () { //ç¹å»åæ¶æ¶ä½¿ç¨åè° |
| | | //$(".layui-btn").removeClass("layui-btn-disabled"); |
| | | } |
| | | }) |
| | | } |
| | | }); |
| | | |
| | | |
| | | //#endregion |
| | | //#region æ¤é¡µé¢æææ¹æ³ |
| | | // åå§åçé¢ |
| | | function set_ClearBill() { |
| | |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , limits: [50, 500, 5000, 50000] |
| | | , limits: [50, 500, 5000, 20000] |
| | | , limit: 50 |
| | | , cellMinWidth: 90 |
| | | |
| | |
| | | if (data1.count == 1) { |
| | | var data = []; |
| | | var col = []; |
| | | var totalArray = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) { |
| | | data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); |
| | |
| | | // 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 if ($.inArray(data[i].name, totalArray) > -1) { |
| | | col.push({ |
| | | field: data[i].id, title: data[i].name, align: 'center', sort: true, totalrow: true, width: 200 }) |
| | | } else if (data[i].id == 'åæ®å·') { |
| | | col.push({ |
| | | field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event:'åæ®å·' }) |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | |
| | | , data: data1.data |
| | | , height: 'full-80' |
| | | , page: true |
| | | , limits: [50, 500, 5000, 50000] |
| | | , limits: [50, 500, 5000, 20000] |
| | | , limit: 50 |
| | | , cellMinWidth: 90 |
| | | } |
| | |
| | | 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 = ""; |
| | |
| | | } |
| | | sWhere += " 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 (HNumber) { |
| | | sWhere += " and å¼å¸¸åé¦ç±»å代ç like '%" + HNumber + "%'"; |
| | | } |
| | |
| | | $("#btnSearch").click(); |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").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 = ""; |
| | |
| | | function get_Refresh() { |
| | | $("#btnSearch").trigger('click'); |
| | | } |
| | | //导å
¥ |
| | | function set_SouceExcel() { |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['100%', '100%'] |
| | | , title: 'å·¥åºèµæå¯¼å
¥' |
| | | , shift: 0//å¼¹åºå¨ç» |
| | | , content: './Gy_ErrMsgBackType_Excel.html?OperationType=dao&HSouceBillType=' |
| | | }) |
| | | } |
| | | |
| | | //æ°å¢ |
| | | function set_AddNew() { |
| | | layer.open({ |
| | |
| | | |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | //var titleData = ["åæ®ID", "HMouldID", "hsubid", "HManagerID", "æºå主å
ç ", "æºååå
ç "];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | var titleData = ["HItemID", "ç代ç  ", "ç¶çº§ID", "ç级", "æ«çº§æ å¿", "å©è®°ç ", "å建ç»ç»"]; |
| | | |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | |
| | | } |
| | | } |
| | | $("#ColName").empty(); |
| | | $("#ColName1").empty(); |
| | | $("#ColName1").append(Organization); |
| | | $("#ColName2").empty(); |
| | | $("#ColName2").append(Organization); |
| | | $("#ColName").append(Organization); |
| | | form.render('select'); |
| | | } |