using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace M423project
{
    public partial class FormWarning : Form
    {
        private List<WarningConfigure> _listAll = new List<WarningConfigure>();
        private List<WarningConfigure> _listTemp;

        public FormWarning()
        {
            InitializeComponent();
            grid.AutoGenerateColumns = false;

            BindCombobox();
        }

        private void BindCombobox()
        {
            WarningData warningData = new WarningData();
            _listAll.Add(new WarningConfigure { Val = 0, Content = "全部" });
            _listAll.AddRange(warningData.GetWarningType(null));
            cboType.DisplayMember = "Content";
            cboType.ValueMember = "Val";
            cboType.Items.AddRange(_listAll.ToArray());
            cboType.SelectedItem = _listAll[0];
        }

        private void btnQuery_Click(object sender, EventArgs e)
        {
            if ((dtBegin.Value.Date - dtEnd.Value.Date).Days > 0)
            {
                MessageBox.Show("开始时间不得大于结束时间");
                return;
            }
            StringBuilder sb = new StringBuilder();
            sb.AppendFormat(@"SELECT warnConfigure.Content Type,warn.Time,warn.ClearTime FROM Warning warn LEFT JOIN WarningConfigure 
                            warnConfigure ON warn.Type=warnConfigure.Val 
                            WHERE warn.Time BETWEEN '{0}' AND '{1}'", dtBegin.Value.ToString("yyyy-MM-dd 00:00:00"), dtEnd.Value.ToString("yyyy-MM-dd 23:59:59"));
            WarningConfigure selected = cboType.SelectedItem as WarningConfigure;
            if (selected != null && selected.Val != 0)
            {
                sb.AppendFormat(@" AND Type={0}", selected.Val);
            }
            sb.AppendFormat(" order by warn.Time");
            DataTable dt = CommonUtil.mainForm.DetectData.Query(sb.ToString());
            grid.DataSource = dt;
            grid.Columns["Time"].DefaultCellStyle.Format = "yyyy-MM-dd  HH:mm:ss";
            grid.Columns["ClearTime"].DefaultCellStyle.Format = "yyyy-MM-dd  HH:mm:ss";
        }

        private void cboType_TextUpdate(object sender, EventArgs e)
        {
            cboType.Items.Clear();
            _listTemp = new List<WarningConfigure>();
            if (cboType.Text == "")
            {
                cboType.Items.AddRange(_listAll.ToArray());
                return;
            }
            foreach (var item in _listAll)
            {
                if (item.Content.Contains(cboType.Text))
                {
                    _listTemp.Add(item);
                }
            }
            cboType.Items.AddRange(_listTemp.ToArray());
            cboType.SelectionStart = cboType.Text.Length;
            Cursor = Cursors.Default;
            cboType.DroppedDown = true;
        }
    }
}