1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
·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];
                //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)
        {
        }
    }
}
X