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.
90 lines
3.7 KiB
90 lines
3.7 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 FrmBrowseAotoTaskLog : Form
|
|
{
|
|
private static FrmBrowseAotoTaskLog _formInstance;
|
|
|
|
public static FrmBrowseAotoTaskLog FormInstance
|
|
{
|
|
get
|
|
|
|
{
|
|
if (_formInstance == null)
|
|
{
|
|
_formInstance = new FrmBrowseAotoTaskLog();
|
|
}
|
|
return _formInstance;
|
|
}
|
|
set { _formInstance = value; }
|
|
}
|
|
DBOperator dbo = CStaticClass.dbo;
|
|
public FrmBrowseAotoTaskLog()
|
|
{
|
|
InitializeComponent();
|
|
this.dateTimePicker1.Value = DateTime.Today;
|
|
this.dateTimePicker2.Value = DateTime.Today;
|
|
_formInstance = this;
|
|
}
|
|
|
|
private void btQuery_Click(object sender, EventArgs e)
|
|
{
|
|
//string sql = "SELECT * FROM T_Manage_Task_BAK WHERE (FBEGTIME >= '" + dateTimePicker1.Text + " 00:00:00') AND (FBEGTIME <= '" + dateTimePicker2.Text + " 23:59:59')";
|
|
StringBuilder sql = new StringBuilder();
|
|
sql.Append(" SELECT TOP(1000) ");
|
|
sql.Append(" dbo.T_Manage_Task_BAK.FPALLETBARCODE AS 条码 ");
|
|
sql.Append(" , dbo.T_Manage_Task_BAK.FID AS 调度任务索引 ");
|
|
sql.Append(" , dbo.T_Base_Manage_Task_Kind.F_TaskKindName AS 任务类型 ");
|
|
sql.Append(" , dbo.T_ITEMTASKTYPE.FNAME AS 作业类型 ");
|
|
sql.Append(" , dbo.T_Manage_Task_BAK.FSTARTDEVICE AS 起点 ");
|
|
sql.Append(" , dbo.T_Manage_Task_BAK.FSTARTCELL AS 起点货位 ");
|
|
sql.Append(" , dbo.T_Manage_Task_BAK.FENDDEVICE AS 终点 ");
|
|
sql.Append(" , dbo.T_Manage_Task_BAK.FENDCELL AS 终点货位 ");
|
|
sql.Append(" , dbo.T_Manage_Task_BAK.FBEGTIME AS 开始时间 ");
|
|
sql.Append(" , dbo.T_Manage_Task_BAK.FERRORCODE AS 故障信息 ");
|
|
sql.Append(" , dbo.T_Manage_Task_BAK.FTASKLEVEL AS 任务优先级 ");
|
|
sql.Append(" , dbo.T_Manage_Task_BAK.FLevelTime AS 订单需求时间 ");
|
|
sql.Append(" , dbo.T_Manage_Task_BAK.FIntoStepOK AS 任务拆分状态 ");
|
|
sql.Append(" ");
|
|
sql.Append(" ,WMS_TASKTYPE as 顺序任务级 ");
|
|
sql.Append(" FROM dbo.T_Manage_Task_BAK ");
|
|
sql.Append(" INNER JOIN dbo.T_Base_Manage_Task_Kind ON dbo.T_Manage_Task_BAK.F_ManageTaskKindIndex = dbo.T_Base_Manage_Task_Kind.F_TaskKindIndex ");
|
|
sql.Append(" INNER JOIN dbo.T_ITEMTASKTYPE ON dbo.T_Manage_Task_BAK.FCONTROLTASKTYPE = dbo.T_ITEMTASKTYPE.FCODE ");
|
|
sql.Append(" WHERE FBEGTIME >= '" + dateTimePicker1.Text + " 00:00:00' AND FBEGTIME <= '" + dateTimePicker2.Text + " 23:59:59' ");
|
|
|
|
sql.Append(" ORDER BY 开始时间 desc ");
|
|
DataView dv = dbo.ExceSQL(sql.ToString()).Tables[0].DefaultView;
|
|
this.dataGridView1.DataSource = dv;
|
|
|
|
|
|
}
|
|
|
|
private void btNullQuery_Click(object sender, EventArgs e)
|
|
{
|
|
if (MessageBox.Show("您确认要清空数据库内记录的所有调度自动任务吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
dbo.ExceSQL("delete from T_Manage_Task_BAK");
|
|
}
|
|
|
|
private void FrmBrowseAotoTaskLog_FormClosing(object sender, FormClosingEventArgs e)
|
|
{
|
|
_formInstance = null;
|
|
}
|
|
|
|
|
|
}
|
|
}
|