using ClientLib;
using ClientLib.CommonService;
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Views.Grid.ViewInfo;
using DevExpress.XtraReports.UI;
using PublicLib;
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 HANMI_J_SALE
{
    public partial class OutputPerHourList : PublicLib.CommonMDI
    {
        private string m_YYMM;

        public OutputPerHourList()
        {
            InitializeComponent();


            dateEdit_SDATE.DateTime = DateTime.MinValue;
            dateEdit_FDATE.DateTime = DateTime.Now;



            this.Shown += (sender, e) =>
            {
                searchProc();
            };

            buttonEdit_RoutingNM.ButtonClick += (sender, e) =>
            {
                selectRoutingProc();
            };

            simpleButton_Search.Click += (sender, e) =>
            {
                searchProc();
            };

            simpleButton_Text_Clear.Click += (sender, e) =>
            {
                buttonEdit_RoutingNM.Text = "";
                labelControl_RoutingCD.Text = "";
            };

        }

        public override void searchProc()
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;

                SerializedSqlParam[] aParam = new SerializedSqlParam[] {
                ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),
                ClientClass.CreateSqlParameter("ITEM_CD", SqlDbType.NVarChar, labelControl_RoutingCD.Text),
                ClientClass.CreateSqlParameter("SDATE", SqlDbType.NVarChar, dateEdit_SDATE.DateTime.ToString("yyyy.MM.dd")),
                ClientClass.CreateSqlParameter("FDATE", SqlDbType.NVarChar, dateEdit_FDATE.DateTime.ToString("yyyy.MM.dd"))
                };
                ResultData result = ClientClass.GetData("U3GetOutputPerHour", aParam);
                if (result.isError)
                {
                    throw new Exception(result.ResultValue);
                }


                gridControl_Main.DataSource = result.DataList.Tables[0];
                gridControl_WPH.DataSource = result.DataList.Tables[1];

                result.DataList.Tables[0].AcceptChanges();
                result.DataList.Tables[1].AcceptChanges();

                //m_Group_View = new DataView(result.DataList.Tables[1]);
                //m_Code_Type = new DataView(result.DataList.Tables[2]);
                //m_Code_View = new DataView(result.DataList.Tables[3]);

                this.Cursor = Cursors.Arrow;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Arrow;
                MessageBox.Show(ex.Message);
            }
        }

        public override void printProc()
        {
        }

        private void selectRoutingProc()
        {
            SelectRoutingForm form = new SelectRoutingForm(labelControl_RoutingCD.Text);
            if (form.ShowDialog() != DialogResult.Yes)
            {
                return;
            }
            buttonEdit_RoutingNM.Text = form.m_ITEM_NM;
            labelControl_RoutingCD.Text = form.m_ITEM_CD;
        }

        public override void excelProc()
        {
            //this.ExportExcelGrid(gridControl_Main);
        }

        private void panelControl4_Paint(object sender, PaintEventArgs e)
        {
        }
    }
}