File name
Commit message
Commit date
File name
Commit message
Commit date
using ClientLib;
using ClientLib.CommonService2;
using DevExpress.XtraEditors;
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.Threading.Tasks;
using System.Windows.Forms;
namespace KHSCALE_TP
{
public partial class UcOrderList : Form
{
U3Database u3Database = new U3Database();
U3Config u3Config = new U3Config();
public string orderno;
public string lot;
public UcOrderList()
{
InitializeComponent();
u3Database.SetSqlServer();
DataView grpMach = new DataView(GetMachTable());
UtilClass.SetLookup(this.lookUpEdit_Mach, grpMach, "MACH_CD", "MACH_NM", true, true);
dateEdit_ORDER_DT.DateTime = DateTime.Now;
searchProc();
}
public void searchProc()
{
try
{
this.Cursor = Cursors.WaitCursor;
gridControl_Main.DataSource = null;
string sDate = this.dateEdit_ORDER_DT.DateTime.ToString("yyyy-MM-dd");
DataTable resultData = null;
resultData = u3Database.OpenSQL("select a.order_no, a.lot, a.resource_no, a.resource_name, a.date_sched_curr, a.demand_status_desc, a.operation, a.initial_name from T_KH_SAL_ORDER a where a.cost_center = '10' and a.date_sched_curr = '" + sDate + "' group by a.order_no, a.lot, a.resource_no, a.resource_name, a.date_sched_curr, a.demand_status_desc, a.operation, a.initial_name");
gridControl_Main.DataSource = resultData;
//FilterSub(toggleSwitch_END.IsOn);
this.Cursor = Cursors.Arrow;
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
MessageBox.Show(ex.Message);
}
}
private DataTable GetMachTable()
{
try
{
this.Cursor = Cursors.WaitCursor;
return u3Database.OpenSQL("select 'N' as SEL_FIELD, a.MACH_CD, a.MACH_NO, a.MACH_NM from dbo.T_STD_MACH a where a.COMP_CD = '" + ConstClass._COMP_CD + "' and isnull(a.DEL_YN,'N') = 'N' order by a.MACH_CD");
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
XtraMessageBox.Show(ex.Message);
}
return null;
}
private void simpleButton_Pre_Click(object sender, EventArgs e)
{
try
{
dateEdit_ORDER_DT.DateTime = dateEdit_ORDER_DT.DateTime.AddDays(-1);
searchProc();
}
catch (Exception ex)
{
}
}
private void simpleButton_Next_Click(object sender, EventArgs e)
{
try
{
dateEdit_ORDER_DT.DateTime = dateEdit_ORDER_DT.DateTime.AddDays(1);
searchProc();
}
catch (Exception ex)
{
}
}
private void lookUpEdit_Mach_EditValueChanged(object sender, EventArgs e)
{
searchProc();
}
private void simpleButton_Work_Click(object sender, EventArgs e)
{
DataRow row = gridView_Main.GetFocusedDataRow();
if (row != null)
{
orderno = UtilClass.toStr(row["ORDER_NO"]);
lot = UtilClass.toStr(row["LOT"]);
this.DialogResult = DialogResult.Yes;
this.Close();
}
}
private void gridView_Main_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
DataRow row = gridView_Main.GetFocusedDataRow();
if (row == null)
{
return;
}
try
{
//txt_partno.Text = row["resource_no"].ToString();
//txt_partnm.Text = row["resource_name"].ToString();
}
catch (Exception ex)
{
}
}
private void simpleButton_ReFresh_Click(object sender, EventArgs e)
{
searchProc();
}
private void toggleSwitch_END_Toggled(object sender, EventArgs e)
{
FilterSub(toggleSwitch_END.IsOn);
}
private void FilterSub(bool toggle)
{
try
{
if (toggle)
{
gridView_Main.ActiveFilterString = "";
}
else
{
gridView_Main.ActiveFilterString = "[demand_status_desc] != '완료'";
}
}
catch (Exception ex)
{
}
}
}
}