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) { } } }