| | |
| | | <label class="layui-form-label" style="width: 85px;">å¤å®ç»æ</label> |
| | | <div class="layui-input-block" style="margin-left: 120px; width: 85px;"> |
| | | <select name="HResult" id="HResult" lay-verify="HResult"> |
| | | <option value="åæ ¼">åæ ¼</option> |
| | | <option value="ä¸åæ ¼">ä¸åæ ¼</option> |
| | | <option value="-1">å
¨é¨</option> |
| | | <option value="1">åæ ¼</option> |
| | | <option value="0">ä¸åæ ¼</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | |
| | | , soulTable = layui.soulTable |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "QC_QualityStatisticsDailyReport"; |
| | | var HModName = "QC_MoistureContentDataLedger"; |
| | | var titleData = ["HInterID", "HEntryID", "HBadReasonID", "HSourceInterID", "HSourceEntryID"];//å表ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | |
| | | //#endregion |
| | |
| | | |
| | | var columns = []; |
| | | columns.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计' }); |
| | | columns.push({ field: 'æ¥æ', title: 'æ¥æ', sort: true, width: 90}); |
| | | columns.push({ field: 'æ¥æ', title: 'æ¥æ', sort: true, width: 180}); |
| | | columns.push({ field: 'æºå°å·', title: 'æºå°å·', sort: true, width: 110 }); |
| | | columns.push({ field: 'åæ ·éé', title: 'åæ ·éé', sort: true, width: 110 }); |
| | | columns.push({ field: 'æµéç»æ', title: 'æµéç»æ', sort: true, totalRow: true, width: 110}); |
| | | columns.push({ field: 'å¤å®ç»æ', title: 'å¤å®ç»æ', sort: true, totalRow: true, width: 110}); |
| | | columns.push({ field: 'æ£æµäºº', title: 'æ£æµäºº', sort: true, totalRow: true, width: 110}); |
| | | columns.push({ field: '夿³¨', title: '夿³¨', sort: true, totalRow: true, width: 110}); |
| | | columns.push({ field: 'åæ ·éé', title: 'åæ ·éé', sort: true, totalRow: true, width: 110 }); |
| | | columns.push({ field: 'æµéç»æ', title: 'æµéç»æ', sort: true, width: 110}); |
| | | columns.push({ field: 'å¤å®ç»æ', title: 'å¤å®ç»æ', sort: true, width: 110}); |
| | | columns.push({ field: 'æ£æµäºº', title: 'æ£æµäºº', sort: true, width: 110}); |
| | | columns.push({ field: '夿³¨', title: '夿³¨', sort: true, width: 110}); |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo1' |
| | |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | |
| | | option.data=data1.data |
| | | if (data1.list.length > 0) { |
| | | 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', totalRowText: 'å计è¡' }); |
| | | 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 { |
| | | switch (data[i].Type) { |
| | | //int |
| | | case 'DateTime': |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 }); |
| | | break; |
| | | case 'long': |
| | | case 'Int32': |
| | | case 'Int64': |
| | | case 'double': |
| | | case 'Decimal': |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 140, totalRow: true }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 }); |
| | | } |
| | | } |
| | | } |
| | | |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo1' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , totalRow: true |
| | | , limit: 500 |
| | | , data: data1.data |
| | | , limits: [50, 500, 5000, 20000] |
| | | //, done: function (res, curr, count) { |
| | | // soulTable.render(this); |
| | | //} |
| | | , cols: [col] |
| | | }; |
| | | } else { |
| | | set_InitGrid(); |
| | | option.data = data1.data |
| | | } |
| | | |
| | | table.render(option); |
| | | |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | |
| | | , HResult: HResult |
| | | , HSourceID: HSourceID |
| | | } |
| | | set_InitGrid(); |
| | | //set_InitGrid(); |
| | | get_Display(JSON.stringify(sWhere)); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |