1371410
新手一名，遇到问题，困扰了一天了，帮忙看看是什么问题啊 直接上code html:
<table class="ui selectable celled table segment" id="tbEventMessage">
<thead>
<tr>
<th>Event ID</th>
<th>Precursor Id</th>
<th>DataItem Id</th>
<th>Zone Number</th>
<th>Condition Id</th>
<th>SubCondition Id</th>
<th>State</th>
<th>Active Time</th>
<th>Event Time</th>
<th>Severity</th>
<th>Threshold</th>
<th>Message</th>
</tr>
</thead>
<tbody>
</tbody>
<tfoot class="full-witdh">
<tr>
<th colspan="3">
<a class="ui right labeled icon button" href="/eventMessages/create">
<i class="user icon"></i>Add eventMessage
</a>
</th>
</tr>
</tfoot>
</table>
Javascript:
var messageTable = $('#tbEventMessage').DataTable({
ajax:{
url: "/eventMessages",
type: "get",
dataSrc: ""
},
columns : [
{data: 'EventID'},
{data: 'PrecursorId'},
{data: 'DataItemId'},
{data: 'ZoneNumber'},
{data: 'ConditionId'},
{data: 'SubConditionId'},
{data: 'State'},
{data: 'ActiveTime', render: function(data){
return data.replace(/T/, ' ').replace(/\..+/, '');
}
},
{data: 'EventTime', render: function(data){
return data.replace(/T/, ' ').replace(/\..+/, '');
}
},
{data: 'Severity'},
{data: 'Threshold'},
{data: 'Message'}
],
createdRow: function(row, data, index) {
var severity = data['Severity'];
if (severity >= 700) {
$('td',row).css('background-color', "crimson");
}else if(severity >= 400){
$('td',row).css('background-color', "#FA8072");
}else if (severity >= 100){
$('td',row).css('background-color', "coral");
}else{
$('td',row).css('background-color', "#4FC08D");
}
}
});
setTimeout(refresh, 1000);
function refresh() {
//ajax
messageTable.ajax.reload();
setTimeout(refresh, 1000);
}
model:
const sql = require('mssql');
var config = {
user: 'sa',
password: 'porta',
server: 'CN10LT099',
database: 'ClairAlarm',
pool: {
max: 10,
min: 0,
idleTimeoutMillis: 30000
}
};
module.exports = {
closeConnection: function closeConnection() {
sql.close();
},
getEventMessages: function getEventMessages(limit) {
//console.log(limit);
return new sql.ConnectionPool(config).connect().then(pool => {
// Query
return pool.request()
.input('recordlimit', sql.Int, parseInt(limit))
.execute('ReadEventMessage')
}).then(result => {
//pool.close();
return result.recordset;
}).catch(err => {
//pool.close();
console.trace(err);
});
}
};
eventMessages.js
var express = require('express');
var router = express.Router();
var EventMessageModel = require('../models/eventMessages');
var checkLogin = require('../middlewares/check.js').checkLogin;
// GET /eventMessages
router.get('/', function(req, res, next) {
EventMessageModel.getEventMessages(20)
.then(function(eventMessages) {
//console.dir(eventMessages);
//res.end(JSON.stringify(eventMessages));
res.json(eventMessages);
});
//.catch(next);
});
module.exports = router;