| | |
| | | } |
| | | } |
| | | |
| | | public static DataTable GetSystemLog(string ip) |
| | | public static DataTable GetSystemLog(string ip ,string type) |
| | | { |
| | | DataTable dt = new DataTable(); |
| | | try |
| | | { |
| | | using (Sam_DBEntities db = new Sam_DBEntities()) |
| | | { |
| | | var sql = @"SELECT top 35 LogMessage,CreateTime FROM Base_Log where type='称重' and LocalIP= '" + ip+ "' ORDER BY CreateTime DESC "; |
| | | var sql = @"SELECT top 35 LogMessage,CreateTime FROM Base_Log where type='" + type + "' and LocalIP= '" + ip+ "' ORDER BY CreateTime DESC "; |
| | | dt = SqlHelper.ExecuteDataset(db.Database.Connection.ConnectionString, CommandType.Text, sql).Tables[0]; |
| | | } |
| | | } |