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

namespace M423project
{
    public partial class FormDownTime : Form
    {
        public FormDownTime()
        {
            InitializeComponent();
            LoadInfo();
        }

        public void LoadInfo()
        {
            gridA.AutoGenerateColumns = false;
            gridB.AutoGenerateColumns = false;
            DateTime now = DateTime.Now;
            dtBegin.Value = now;
            dtEnd.Value = now;
            DownTimeData downTimeData = new DownTimeData();
            var list = downTimeData.GetEnumList(typeof(DownTimeType));
            list.Insert(0, new EnumEntity { Value = 0, Name = "全部", Description = "全部" });
            list.RemoveAt(list.Count - 1);
            cbType.DataSource = list;
            gridA.Columns["BeginTime"].DefaultCellStyle.Format="yyyy-MM-dd HH:mm:ss";
            gridA.Columns["EndTime"].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
            gridB.Columns["BeginTimeB"].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
            gridB.Columns["EndTimeB"].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
        }

        private void btnQuery_Click(object sender, EventArgs e)
        {
            DownTimeData downTimeData = new DownTimeData();
            DataTable dt = new DataTable();
            switch (tabControl1.SelectedIndex)
            {
                case 0:
                    dt = downTimeData.GetDownTimeList(((EnumEntity)cbType.SelectedValue).Value, dtBegin.Value, dtEnd.Value);
                    //if (dt.Rows.Count > 0)
                    //{
                    //    int totalSec = 0;
                    //    foreach (DataRow row in dt.Rows)
                    //    {
                    //        totalSec += Convert.ToInt32(row["TimeNeedSec"]);
                    //    }
                    //    dt.Rows.Add();
                    //    int rowCount = dt.Rows.Count;
                    //    dt.Rows[rowCount - 1]["Row"] = "合计";
                    //    dt.Rows[rowCount - 1]["TimeNeedSec"] = totalSec.ToString();
                    //    dt.Rows[rowCount - 1]["TimeNeedMin"] = (totalSec / 60.00).ToString();
                    //}
                    gridA.DataSource = dt;
                    break;

                case 1:
                    dt = downTimeData.GetDownTimeList((int)DownTimeType.NoAction, dtBegin.Value, dtEnd.Value);
                    gridB.DataSource = dt;
                    break;

            }

        }

        private void btnExport_Click(object sender, EventArgs e)
        {
            switch (tabControl1.SelectedIndex)
            {
                case 0:
                    DataGridViewToExcel(gridA);
                    break;

                case 1:
                    DataGridViewToExcel(gridB);
                    break;

            }

        }

        private void DataGridViewToExcel(DataGridView dgv)
        {
            SaveFileDialog dlg = new SaveFileDialog();
            dlg.Filter = "Execl files (*.csv)|*.csv";
            dlg.FilterIndex = 0;
            dlg.RestoreDirectory = true;
            dlg.CreatePrompt = true;
            dlg.Title = "导出到Excel文件";

            if (dlg.ShowDialog() == DialogResult.OK)
            {
                Stream myStream;
                myStream = dlg.OpenFile();
                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.UTF8);
                string columnTitle = "";
                try
                {

                    for (int i = 0; i < dgv.ColumnCount; i++)
                    {
                        if (i > 0)
                        {
                            columnTitle += ",";
                        }
                        columnTitle += dgv.Columns[i].HeaderText;
                    }
                    sw.WriteLine(columnTitle);


                    for (int j = 0; j < dgv.Rows.Count; j++)
                    {
                        string columnValue = "";
                        for (int k = 0; k < dgv.Columns.Count; k++)
                        {
                            if (k > 0)
                            {
                                columnValue += ",";
                            }
                            if (dgv.Rows[j].Cells[k].Value == null)
                                columnValue += "";
                            else
                                columnValue += dgv.Rows[j].Cells[k].Value.ToString().Trim();
                        }
                        sw.WriteLine(columnValue);
                    }
                    sw.Close();
                    myStream.Close();
                }
                catch (Exception e)
                {
                    MessageBox.Show(e.ToString());
                }
                finally
                {
                    sw.Close();
                    myStream.Close();
                }
            }
        }
    }
}