You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
104 lines
4.0 KiB
104 lines
4.0 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel;
|
|
using System.Data;
|
|
using System.Drawing;
|
|
using System.Text;
|
|
using System.Windows.Forms;
|
|
|
|
using DBFactory;
|
|
namespace wcfControlMonitorClient
|
|
{
|
|
/// <summary>
|
|
/// Creator:Richard.liu
|
|
/// 设备故障查询
|
|
/// </summary>
|
|
public partial class FrmDeviceErrorLog : Form
|
|
{
|
|
private static FrmDeviceErrorLog _formInstance;
|
|
|
|
public static FrmDeviceErrorLog FormInstance
|
|
{
|
|
get
|
|
|
|
{
|
|
if (_formInstance == null)
|
|
{
|
|
_formInstance = new FrmDeviceErrorLog();
|
|
isFirstShow = false;
|
|
}
|
|
return _formInstance;
|
|
}
|
|
set { _formInstance = value; }
|
|
}
|
|
DBOperator dbo = CStaticClass.dbo;
|
|
static bool isFirstShow = false;//20130117
|
|
public FrmDeviceErrorLog()
|
|
{
|
|
InitializeComponent();
|
|
this.dateTimePickerBegin.Value = DateTime.Today;
|
|
this.dateTimePickerEnd.Value = DateTime.Today;
|
|
_formInstance = this;//20101028
|
|
}
|
|
|
|
private void btQuery_Click(object sender, EventArgs e)
|
|
{
|
|
try
|
|
{
|
|
string searchstr = string.Empty;
|
|
|
|
if (this.cbField.Text.Trim().Length != 0 && this.tbContent.Text.Trim().Length != 0)
|
|
{
|
|
searchstr = string.Format(" And {0} like '%{1}%'", cbField.Text.Trim(), tbContent.Text.Trim());
|
|
}
|
|
|
|
//string sql = "SELECT * FROM V_manage_task_bak WHERE (开始时间 >= '" + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + "') AND (开始时间 <= '" + dateTimePicker2.Value.AddDays(1).ToString("yyyy-MM-dd HH:mm:ss") + "')";
|
|
string sql = string.Format("SELECT * FROM V_Device_Error_log WHERE (发生时间 >= '{0}') AND (发生时间 <= '{1}' {2})", dateTimePickerBegin.Value.ToString("yyyy-MM-dd HH:mm:ss"), dateTimePickerEnd.Value.AddDays(1).ToString("yyyy-MM-dd HH:mm:ss"), searchstr);
|
|
|
|
DataView dv = dbo.ExceSQL(sql).Tables[0].DefaultView;
|
|
|
|
this.dataGridView1.DataSource = dv;
|
|
this.labelCounts.Text = string.Format("共{0}行", dv.Count);
|
|
}
|
|
catch(Exception ex )
|
|
{
|
|
MessageBox.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
}
|
|
}
|
|
|
|
private void btNullQuery_Click(object sender, EventArgs e)
|
|
{
|
|
if (MessageBox.Show("您确认要清空数据库内记录的所有设备的历史报警吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
dbo.ExceSQL("delete from T_Base_Device_Error_Log");
|
|
}
|
|
|
|
private void FrmDeviceErrorLog_Load(object sender, EventArgs e)
|
|
{
|
|
if (isFirstShow==false)
|
|
{
|
|
try
|
|
{
|
|
DataView dvs = dbo.ExceSQL("Select name from syscolumns Where ID=OBJECT_ID('V_Device_Error_log') ORDER BY colorder").Tables[0].DefaultView;
|
|
//cbstartposition
|
|
cbField.ValueMember = "name";
|
|
cbField.DisplayMember = "name";
|
|
cbField.DataSource = dvs;
|
|
cbField.SelectedIndex = -1;
|
|
////string sql = string.Format("Delete from T_Manage_Task_BAK where FBEGTIME ='-' or ABS(datediff(day,FBEGTIME,getdate()))>{0}", CStaticClass.SaveDays);
|
|
////dbo.ExceSQL(sql);
|
|
//string sql = string.Format("Delete from T_Base_Device_Error_Log where ABS(datediff(day,CONVERT(varchar(19), F_DateTime),getdate()))>{0}", WcfControlMonitorLib.CStaticClass.SaveDays);
|
|
//dbo.ExceSQL(sql);
|
|
isFirstShow = true;
|
|
}
|
|
catch(Exception ex )
|
|
{
|
|
throw ex;
|
|
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|