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;
        }


    }
}