| | |
| | | throw ex; |
| | | } |
| | | } |
| | | public static DataTable GetSystemLog(string ip) |
| | | public static DataTable GetSystemLog(string ip,string type) |
| | | { |
| | | DataTable dt = new DataTable(); |
| | | try |
| | | { |
| | | return System_Dal.GetSystemLog(ip); |
| | | return System_Dal.GetSystemLog(ip, type); |
| | | |
| | | } |
| | | catch (Exception ex) |
| | |
| | | } |
| | | } |
| | | |
| | | 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]; |
| | | } |
| | | } |
| | |
| | | { |
| | | Console.WriteLine($"发生错误:{ex}"); |
| | | } |
| | | dataGridView1.DataSource = System_Bll.GetSystemLog(FrmLogin.LocalIP); |
| | | dataGridView1.DataSource = System_Bll.GetSystemLog(FrmLogin.LocalIP, "称重"); |
| | | macBox.Text = GetMacByNetworkInterface(); |
| | | } |
| | | private void ReceiveSerialData() |
| | |
| | | } |
| | | } |
| | | } |
| | | dataGridView1.DataSource = System_Bll.GetSystemLog(FrmLogin.LocalIP); |
| | | dataGridView1.DataSource = System_Bll.GetSystemLog(FrmLogin.LocalIP, "称重"); |
| | | Refresh(); |
| | | } |
| | | |
| | |
| | | { |
| | | Console.WriteLine($"发生错误:{ex}"); |
| | | } |
| | | dataGridView1.DataSource = System_Bll.GetSystemLog(FrmLogin.LocalIP); |
| | | dataGridView1.DataSource = System_Bll.GetSystemLog(FrmLogin.LocalIP, "称重"); |
| | | macBox.Text = GetMacByNetworkInterface(); |
| | | |
| | | } |
| | |
| | | } |
| | | } |
| | | } |
| | | dataGridView1.DataSource = System_Bll.GetSystemLog(FrmLogin.LocalIP); |
| | | dataGridView1.DataSource = System_Bll.GetSystemLog(FrmLogin.LocalIP, "称重"); |
| | | Refresh(); |
| | | } |
| | | |