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;
using System.IO;

namespace AGVSystem
{
    public partial class frmchangefind : Form
    {
        private ClsDBConn_sql db = new ClsDBConn_sql();
        private System.Data.DataSet ds = new System.Data.DataSet();
        public frmchangefind(string str )
        {
            InitializeComponent();
            this.Text = str;
            //if (str != "异常报警日志")
            //{
            label4.Visible = false;
            cmb_gz.Visible = false;
            //}
            this.WindowState = FormWindowState.Maximized;
            dateTimePicker2.Value = DateTime.Now;
            dateTimePicker1.Value = DateTime.Now.AddHours(-1);
        }

        private void frmfind_Load(object sender, EventArgs e)
        {
            ds = db.connDt("select CONVERT( VARCHAR(10),id) +' . '+ line_name as info from Assembly_Line order by id");
            if (ds.Tables.Count > 0)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    cmb_linelist.Items.Add("");
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        cmb_linelist.Items.Add(dr[0].ToString());
                    }
                }
            }
            ds.Tables.Clear();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            string strsql = "";
            strsql = "SELECT [Start_time] as 充电时间, '* '+convert (nvarchar(10),agvinfo.id) +' / '+convert (nvarchar(10),AgvInfo.Internal_ID) as '设备编号' " +
                     ", Assembly_Line.Line_name as 所属线体 ,[Location_ID] as 充电位置,time_long as 充电时长, [Unit] as 单位 " +
                     " FROM  [Change_Log] , AgvInfo ,  Assembly_Line " +
                     " where [Change_Log].Agv_ID =   AgvInfo.ID and  " +
                     " AgvInfo.Assembly_Line = Assembly_Line.ID and " +
                     " [Start_time] between '" + dateTimePicker1.Value + "' and '" + dateTimePicker2.Value + "'  ";
            if (cmb_linelist.Text != "")
                strsql = strsql + "  and Assembly_Line.id=   " + cmb_linelist.Text.Split('.')[0];
            if (cmb_agv.Text != "")
                strsql = strsql + "  and AgvInfo.Internal_ID= " + cmb_agv.Text;
            strsql = strsql + " order by Assembly_Line.ID , 充电时间";
            ds.Tables.Clear();
            ds = db.connDt(strsql);
            dataGridView1.DataSource = ds.Tables[0];
            dataGridView1.Columns[0].DefaultCellStyle.Format = "yyyy-MM-dd  HH:mm:ss";
            //dataGridView1.Columns[0].Width = 200;
            //dataGridView1.Columns[3].Width = 200;
            //if (this.Text == "异常报警日志")
            //{
            //    dataGridView1.Columns[4].DefaultCellStyle.Format = "yyyy-MM-dd  HH:mm:ss";
            //    dataGridView1.Columns[4].Width = 200;
            //}
            if (ds.Tables[0].Rows.Count > 0)
            {
                strsql = "SELECT  agvinfo.id  as '设备编号', COUNT(*) as 充电次数" +
                     " FROM  [Change_Log] , AgvInfo ,  Assembly_Line " +
                     " where [Change_Log].Agv_ID =   AgvInfo.ID and  " +
                     " AgvInfo.Assembly_Line = Assembly_Line.ID and " +
                     " [Start_time] between '" + dateTimePicker1.Value + "' and '" + dateTimePicker2.Value + "'  ";
                if (cmb_linelist.Text != "")
                    strsql = strsql + "  and Assembly_Line.id=   " + cmb_linelist.Text.Split('.')[0];
                if (cmb_agv.Text != "")
                    strsql = strsql + "  and AgvInfo.Internal_ID= " + cmb_agv.Text;
                strsql = strsql + " group by agvinfo.id ";
                strsql = strsql + " order by agvinfo.id";
                
                DataSet ds1 = db.connDt(strsql);
                List<string> xData2 = new List<string>() { };
                List<int> yData2 = new List<int>() { };

                foreach (DataRow dr in ds1.Tables[0].Rows)
                {
                    xData2.Add(  dr[0].ToString()+"号");
                    yData2.Add(Convert.ToInt16(dr[1].ToString()));
                }

                //chart1.Series[0]["PieLabelStyle"] = "Outside";//将文字移到外侧
                //chart1.Series[0]["PieLineColor"] = "Black";//绘制黑色的连线。
                chart1.Series[0].Points.DataBindXY(xData2, yData2);
            }

        }

        private void cmb_linelist_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cmb_linelist.Text != "")
            {
                ds = db.connDt("select Internal_ID from AgvInfo where [Assembly_Line] =" + cmb_linelist.Text.Split('.')[0] + " order by Internal_ID");
                if (ds.Tables.Count > 0)
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        cmb_agv.Items.Clear();
                        cmb_agv.Items.Add("");
                        foreach (DataRow dr in ds.Tables[0].Rows)
                        {
                            cmb_agv.Items.Add(dr[0].ToString());
                        }
                    }
                }
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (dataGridView1.RowCount>0)
                SaveAs();
        }

        private void SaveAs() //另存新档按钮   导出成Excel
        {

            SaveFileDialog saveFileDialog = new SaveFileDialog();

            saveFileDialog.Filter = "Execl files (*.xls)|*.xls";

            saveFileDialog.FilterIndex = 0;

            saveFileDialog.RestoreDirectory = true;

            saveFileDialog.CreatePrompt = true;

            saveFileDialog.Title = "Export Excel File To";


            saveFileDialog.ShowDialog();


            Stream myStream;
            try
            {
                myStream = saveFileDialog.OpenFile();
            }
            catch
            {
                return;
            }
            //StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));

            StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));

            string str = "";

            try
            {

                //写标题

                for (int i = 0; i < dataGridView1.ColumnCount; i++)
                {

                    if (i > 0)
                    {

                        str += "\t";

                    }

                    str += dataGridView1.Columns[i].HeaderText;

                }


                sw.WriteLine(str);



                //写内容

                for (int j = 0; j < dataGridView1.Rows.Count; j++)
                {

                    string tempStr = "";

                    for (int k = 0; k < dataGridView1.Columns.Count; k++)
                    {

                        if (k > 0)
                        {

                            tempStr += "\t";

                        }

                        tempStr += dataGridView1.Rows[j].Cells[k].Value.ToString();

                    }



                    sw.WriteLine(tempStr);

                }

                sw.Close();

                myStream.Close();

            }

            catch (Exception e)
            {

                MessageBox.Show(e.ToString());

            }

            finally
            {

                sw.Close();

                myStream.Close();

            }

        }

        private void dataGridView1_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e)
        {
            e.Row.HeaderCell.Value = string.Format("{0}", e.Row.Index + 1);
        }





    }
}