88 lines
3.0 KiB
C#
88 lines
3.0 KiB
C#
|
using DevExpress.XtraGrid.Views.Grid;
|
|||
|
|
using JJMediSys.cs;
|
|||
|
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.ComponentModel;
|
|||
|
|
using System.Data;
|
|||
|
|
using System.Drawing;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Text;
|
|||
|
|
using System.Threading.Tasks;
|
|||
|
|
using System.Windows.Forms;
|
|||
|
|
|
|||
|
|
namespace JJMediSys
|
|||
|
|
{
|
|||
|
|
public partial class EventLog : Form
|
|||
|
|
{
|
|||
|
|
public EventLog()
|
|||
|
|
{
|
|||
|
|
InitializeComponent();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
private void groupBox1_Enter(object sender, EventArgs e)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private void EventLog_Load(object sender, EventArgs e)
|
|||
|
|
{
|
|||
|
|
gridView1.OptionsBehavior.Editable = false;
|
|||
|
|
gridView1.OptionsView.ShowIndicator = false;// 显示最左边空白列
|
|||
|
|
// 禁用多选模式
|
|||
|
|
gridView1.OptionsSelection.MultiSelect = false;
|
|||
|
|
// 设置选择模式为“按行”
|
|||
|
|
gridView1.OptionsSelection.MultiSelectMode = GridMultiSelectMode.RowSelect;
|
|||
|
|
dateStart.DateTime = DateTime.Now.AddDays(-1);
|
|||
|
|
dateEnd.DateTime = DateTime.Now;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private void BSearch_Click(object sender, EventArgs e)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
DataTable dt = PublicStatic.EventMgr.ExcQuery($"select * from EVENTINFOLIST where date(Time) between '{dateStart.DateTime.Date.ToString("yyyy-MM-dd")}' and '{dateEnd.DateTime.Date.AddDays(1).ToString("yyyy-MM-dd")}'");
|
|||
|
|
BindingSource bindingSource = new BindingSource();
|
|||
|
|
bindingSource.DataSource = dt;
|
|||
|
|
gridControl1.DataSource = bindingSource;
|
|||
|
|
gridControl1.RefreshDataSource();
|
|||
|
|
gridView1.RefreshData();
|
|||
|
|
LabNote.Text = $"共检索到: {gridView1.DataRowCount} 条记录";
|
|||
|
|
return ;
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
MessageBox.Show(ex.Message);
|
|||
|
|
return ;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private void gridView1_SelectionChanged(object sender, DevExpress.Data.SelectionChangedEventArgs e)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
|
|||
|
|
{
|
|||
|
|
// 获取当前焦点行的数据对象
|
|||
|
|
object focusedRow = gridView1.GetFocusedRow();
|
|||
|
|
if (focusedRow != null)
|
|||
|
|
{
|
|||
|
|
DataRowView dataRowView = focusedRow as DataRowView;
|
|||
|
|
|
|||
|
|
if (dataRowView != null) {
|
|||
|
|
TextName.Text = dataRowView["Msg"].ToString();
|
|||
|
|
TextTime.Text = dataRowView["Time"].ToString();
|
|||
|
|
TextDetail.Text = dataRowView["Details"].ToString();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private async void BClearLogs_Click(object sender, EventArgs e)
|
|||
|
|
{
|
|||
|
|
await Task.Run(() => PublicStatic.EventMgr.ExcuteCmd($"delete from EVENTINFOLIST where date(Time)<'{DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd")}'"));
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|