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.
112 lines
4.5 KiB
112 lines
4.5 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 FrmBrowseApplyLog : Form
|
|
{
|
|
private static FrmBrowseApplyLog _formInstance;
|
|
|
|
public static FrmBrowseApplyLog FormInstance
|
|
{
|
|
get
|
|
|
|
{
|
|
if (_formInstance == null)
|
|
{
|
|
_formInstance = new FrmBrowseApplyLog();
|
|
isFirstShow = false;
|
|
}
|
|
return _formInstance;
|
|
}
|
|
set { _formInstance = value; }
|
|
}
|
|
DBOperator dbo =CStaticClass.dbo;
|
|
static bool isFirstShow = false;//20130117
|
|
public FrmBrowseApplyLog()
|
|
{
|
|
InitializeComponent();
|
|
this.dateTimePicker1.Value = DateTime.Today;
|
|
this.dateTimePicker2.Value = DateTime.Today;
|
|
_formInstance = this;
|
|
}
|
|
|
|
private void btQuery_Click(object sender, EventArgs e)
|
|
{
|
|
try
|
|
{
|
|
string searchstr = string.Empty;
|
|
|
|
if (this.comboBox_SearchKind.Text.Trim().Length != 0 && this.textBox_SearchKeyWord.Text.Trim().Length != 0)
|
|
{
|
|
searchstr = string.Format(" And {0} like '%{1}%'", comboBox_SearchKind.Text.Trim(), textBox_SearchKeyWord.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_IO_CONTROL_APPLY_WCS WHERE (申请时间 >= '{0}') AND (申请时间 <= '{1}' {2}) and 仓库编号 like '%{3}%' order by 申请时间 ", dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss"), dateTimePicker2.Value.AddDays(1).ToString("yyyy-MM-dd HH:mm:ss"), searchstr, CStaticClass.UserArea);
|
|
|
|
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 IO_CONTROL_APPLY_WCS");
|
|
}
|
|
|
|
private void FrmBrowseApplyLog_Load(object sender, EventArgs e)
|
|
{
|
|
if (isFirstShow == false)
|
|
{
|
|
try
|
|
{
|
|
DataView dvs = dbo.ExceSQL("Select name from syscolumns Where ID=OBJECT_ID('V_IO_CONTROL_APPLY_WCS') ORDER BY colorder").Tables[0].DefaultView;
|
|
//cbstartposition select COLUMN_NAME FROM user_col_comments WHERE TABLE_NAME='V_IO_CONTROL_APPLY_WCS'
|
|
// oracle 版本 YB2
|
|
//DataView dvs = dbo.ExceSQL("select COLUMN_NAME FROM user_col_comments WHERE TABLE_NAME='V_IO_CONTROL_APPLY_WCS'").Tables[0].DefaultView;
|
|
comboBox_SearchKind.ValueMember = "name";
|
|
comboBox_SearchKind.DisplayMember = "name";
|
|
comboBox_SearchKind.DataSource = dvs;
|
|
comboBox_SearchKind.SelectedIndex = -1;
|
|
|
|
//int savedays = 60;
|
|
//string sql = string.Format("Delete from IO_CONTROL_APPLY_WCS where CREATE_TIME ='-' or ABS(datediff(day,CREATE_TIME,getdate()))>{0}", savedays);
|
|
//dbo.ExceSQL(sql);
|
|
////sql = string.Format("Delete from T_Base_Device_Error_Log where ABS(datediff(day,F_DateTime,getdate()))>{0}", CStaticClass.SaveDays);
|
|
////dbo.ExceSQL(sql);
|
|
isFirstShow = true;
|
|
//int b = 0;
|
|
//int a = 8 / b;
|
|
}
|
|
catch(Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
}
|
|
}
|