
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
using ClientLib;
using ClientLib.CommonService;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.Grid.ViewInfo;
using PublicLib;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Net;
using System.Text;
using System.Windows.Forms;
using System.Xml;
namespace HANMI_SALE
{
partial class WorkManagerPopup : XtraForm
{
private string m_ORDER_NO;
private int m_LN_SEQ;
public WorkManagerPopup()
{
InitializeComponent();
this.Icon = ConstClass._MAIN.Icon;
m_ORDER_NO = "";
m_LN_SEQ = 0;
DataView out_gbn = new DataView(ConstClass._DATA);
out_gbn.RowFilter = "CATE_CD = 'D' and GRP_CD = 'D01'";
UtilClass.SetLookup(lookUpEdit_OUT_GBN, out_gbn, "NO_CD", "NO_CD_NM", true);
DataView out_car_no = new DataView(ConstClass._DATA);
out_car_no.RowFilter = "CATE_CD = 'D' and GRP_CD = 'D02'";
UtilClass.SetLookup(lookUpEdit_OUT_CAR_NO, out_car_no, "NO_CD", "NO_CD_NM", true);
DataView in_user = new DataView(ConstClass._DATA);
in_user.RowFilter = "CATE_CD = 'L' and GRP_CD = 'L01'";
UtilClass.SetLookup(lookUpEdit_IN_USR_ID, in_user, "NO_CD", "NO_CD_NM", true);
DataView work_user = new DataView(ConstClass._DATA);
work_user.RowFilter = "CATE_CD = 'L' and GRP_CD = 'L02'";
UtilClass.SetLookup(lookUpEdit_WORK_USR_ID, work_user, "NO_CD", "NO_CD_NM", true);
DataView out_user = new DataView(ConstClass._DATA);
out_user.RowFilter = "CATE_CD = 'D' and GRP_CD = 'D04'";
UtilClass.SetLookup(lookUpEdit_OUT_USR_ID, in_user, "NO_CD", "NO_CD_NM", true);
simpleButton_BACK.Click += (sender, e) =>
{
if (this.ActiveControl is TextBoxMaskBox)
{
SendKeys.Send("{BACKSPACE}");
}
};
simpleButton_POINT.Click += (sender, e) =>
{
if (this.ActiveControl is TextBoxMaskBox)
{
SendKeys.Send(".");
}
};
simpleButton_DASH.Click += (sender, e) =>
{
if (this.ActiveControl is TextBoxMaskBox)
{
SendKeys.Send("-");
}
};
lookUpEdit_OUT_GBN.EditValueChanged += (sender, e) =>
{
if (UtilClass.isEqual(lookUpEdit_OUT_GBN.EditValue, "01"))
{
lookUpEdit_OUT_CAR_NO.Enabled = true;
lookUpEdit_OUT_USR_ID.Enabled = true;
textEdit_OUT_DRV_NO.Enabled = false;
textEdit_OUT_TEL_NO.Enabled = false;
textEdit_OUT_GISA.Enabled = false;
}
else
{
lookUpEdit_OUT_CAR_NO.Enabled = false;
lookUpEdit_OUT_USR_ID.Enabled = false;
textEdit_OUT_DRV_NO.Enabled = true;
textEdit_OUT_TEL_NO.Enabled = true;
textEdit_OUT_GISA.Enabled = true;
}
};
simpleButton_INPUT_OK.Click += (sender, e) =>
{
if (checkEdit_IN_ING_YN.Checked && !checkEdit_IN_FIN_YN.Checked)
{
if (XtraMessageBox.Show("입고진행 처리를 하시겠습니까?", "확인", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
saveInputIngProc("M");
this.DialogResult = DialogResult.Yes;
this.Close();
}
}
else if (!checkEdit_IN_ING_YN.Checked && checkEdit_IN_FIN_YN.Checked)
{
XtraMessageBox.Show("입고 진행후 작업하시기 바랍니다.");
return;
}
else if (checkEdit_IN_ING_YN.Checked && checkEdit_IN_FIN_YN.Checked)
{
if (XtraMessageBox.Show("입고확인 처리를 하시겠습니까?", "확인", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
saveInputProc("M");
this.DialogResult = DialogResult.Yes;
this.Close();
}
}
else
{
this.DialogResult = DialogResult.Yes;
this.Close();
}
};
simpleButton_INPUT_CANCEL.Click += (sender, e) =>
{
if (checkEdit_IN_ING_YN.Checked && !checkEdit_IN_FIN_YN.Checked)
{
if (XtraMessageBox.Show("입고진행 처리를 취소하시겠습니까?", "취소", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
saveInputIngProc("C");
this.DialogResult = DialogResult.Yes;
this.Close();
}
}
else if (checkEdit_IN_ING_YN.Checked && checkEdit_IN_FIN_YN.Checked)
{
if (XtraMessageBox.Show("입고확인 처리를 하시겠습니까?", "취소", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
saveInputProc("C");
this.DialogResult = DialogResult.Yes;
this.Close();
}
}
};
simpleButton_OUT_OK.Click += (sender, e) =>
{
if (XtraMessageBox.Show("출고확인 처리를 하시겠습니까?", "확인", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
checkEdit_OUT_YN.Checked = true;
saveOutputProc("M");
this.DialogResult = DialogResult.Yes;
this.Close();
}
};
simpleButton_OUT_CANCEL.Click += (sender, e) =>
{
if (XtraMessageBox.Show("출고취소 처리를 하시겠습니까?", "확인", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
checkEdit_OUT_YN.Checked = false;
saveOutputProc("C");
this.DialogResult = DialogResult.Yes;
this.Close();
}
};
simpleButton_WORK_OK.Click += (sender, e) =>
{
if (XtraMessageBox.Show("작업진행 처리를 하시겠습니까?", "확인", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
saveWorkExecuteProc("M");
this.DialogResult = DialogResult.Yes;
this.Close();
}
};
simpleButton_WORK_CANCEL.Click += (sender, e) =>
{
if (XtraMessageBox.Show("작업진행 취소 처리를 하시겠습니까?", "취소", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
saveWorkExecuteProc("C");
this.DialogResult = DialogResult.Yes;
this.Close();
}
};
simpleButton_WORK_STA_INPUT.Click += (sender, e) =>
{
if (UtilClass.isNull(textEdit_WORK_STA_DATE.Text))
{
textEdit_WORK_STA_DATE.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
}
else
{
textEdit_WORK_STA_DATE.Text = "";
}
};
simpleButton_WORK_FIN_INPUT.Click += (sender, e) =>
{
if (UtilClass.isNull(textEdit_WORK_FIN_DATE.Text))
{
textEdit_WORK_FIN_DATE.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
}
else
{
textEdit_WORK_FIN_DATE.Text = "";
}
};
simpleButton_0.Click += number_Click;
simpleButton_1.Click += number_Click;
simpleButton_2.Click += number_Click;
simpleButton_3.Click += number_Click;
simpleButton_4.Click += number_Click;
simpleButton_5.Click += number_Click;
simpleButton_6.Click += number_Click;
simpleButton_7.Click += number_Click;
simpleButton_8.Click += number_Click;
simpleButton_9.Click += number_Click;
simpleButton_PRINT.Click += (sender, e) =>
{
printProc();
};
gridView_Main.FocusedRowChanged += (sender, e) =>
{
DataRow row = gridView_Main.GetFocusedDataRow();
if (row == null)
{
return;
}
m_LN_SEQ = UtilClass.toInt(row["LN_SEQ"]);
textEdit_LN_SEQ.Text = UtilClass.toInt(row["LN_SEQ"]).ToString("00");
textEdit_ITEM_CD.Text = UtilClass.toStr(row["ITEM_CD"]);
textEdit_ITEM_NM.Text = UtilClass.toStr(row["ITEM_NM"]);
textEdit_ORDER_NORM.Text = UtilClass.toStr(row["ORDER_NORM"]);
textEdit_MACH_NM.EditValue = UtilClass.toStr(row["MACH_NM"]);
textEdit_ORDER_UNIT_NM.EditValue = UtilClass.toStr(row["ORDER_UNIT_NM"]);
textEdit_ORDER_QTY.Text = UtilClass.toInt(row["ORDER_QTY"]).ToString("n0");
textEdit_FIN_QTY.Text = UtilClass.toInt(row["FIN_QTY"]).ToString("n0");
textEdit_ORDER_ADD_QTY.Text = UtilClass.toInt(row["ORDER_ADD_QTY"]).ToString("n0");
textEdit_LN_RMK.Text = UtilClass.toStr(row["LN_RMK"]);
textEdit_WORK_STA_DATE.Text = UtilClass.toStr(row["WORK_STA_DATE"]);
textEdit_WORK_FIN_DATE.Text = UtilClass.toStr(row["WORK_FIN_DATE"]);
textEdit_WORK_QTY.Text = UtilClass.toInt(row["FIN_QTY"]).ToString("n0");
if (UtilClass.isNull(row["WORK_USR_ID"]))
{
lookUpEdit_WORK_USR_ID.EditValue = "01";
}
else
{
lookUpEdit_WORK_USR_ID.EditValue = UtilClass.toStr(row["WORK_USR_ID"]);
}
};
simpleButton_CLOSE.Click += (sender, e) =>
{
this.DialogResult = DialogResult.Yes;
this.Close();
};
this.Shown += (sender, e) =>
{
if (!checkEdit_IN_ING_YN.Checked)
{
simpleButton_INPUT_CANCEL.Enabled = false;
panelControl_WORK.Enabled = false;
panelControl_WORK_BUTTON.Enabled = false;
panelControl_OUT.Enabled = false;
}
else if (checkEdit_IN_ING_YN.Checked && !checkEdit_IN_FIN_YN.Checked)
{
simpleButton_INPUT_CANCEL.Enabled = true;
panelControl_WORK.Enabled = false;
panelControl_WORK_BUTTON.Enabled = false;
panelControl_OUT.Enabled = false;
}
if (checkEdit_IN_ING_YN.Checked && checkEdit_IN_FIN_YN.Checked)
{
simpleButton_INPUT_OK.Enabled = false;
simpleButton_INPUT_CANCEL.Enabled = true;
panelControl_WORK.Enabled = true;
panelControl_WORK_BUTTON.Enabled = true;
panelControl_OUT.Enabled = true;
}
};
}
private void saveInputIngProc(string mode)
{
try
{
this.Cursor = Cursors.WaitCursor;
SerializedSqlParam[] aParam = new SerializedSqlParam[]
{
ClientClass.CreateSqlParameter("MODE", SqlDbType.NVarChar, mode),
ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),
ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, m_ORDER_NO),
ClientClass.CreateSqlParameter("IN_ING_YN", SqlDbType.NVarChar, checkEdit_IN_ING_YN.Checked ? 'Y':'N'),
ClientClass.CreateSqlParameter("IN_USR_ID", SqlDbType.NVarChar, lookUpEdit_IN_USR_ID.EditValue),
ClientClass.CreateSqlParameter("REG_ID", SqlDbType.NVarChar, ConstClass._USR_ID)
};
ResultData resultData = ClientClass.SetData("SaveWorkInputIng", aParam);
if (resultData.isError)
{
throw new Exception(resultData.ResultValue);
}
this.Cursor = Cursors.Arrow;
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
XtraMessageBox.Show(ex.Message);
}
}
private void saveInputProc(string mode)
{
try
{
this.Cursor = Cursors.WaitCursor;
SerializedSqlParam[] aParam = new SerializedSqlParam[]
{
ClientClass.CreateSqlParameter("MODE", SqlDbType.NVarChar, mode),
ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),
ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, m_ORDER_NO),
ClientClass.CreateSqlParameter("IN_ING_YN", SqlDbType.NVarChar, checkEdit_IN_ING_YN.Checked ? 'Y':'N'),
ClientClass.CreateSqlParameter("IN_FIN_YN", SqlDbType.NVarChar, checkEdit_IN_FIN_YN.Checked ? 'Y':'N'),
ClientClass.CreateSqlParameter("IN_USR_ID", SqlDbType.NVarChar, lookUpEdit_IN_USR_ID.EditValue),
ClientClass.CreateSqlParameter("REG_ID", SqlDbType.NVarChar, ConstClass._USR_ID)
};
ResultData resultData = ClientClass.SetData("SaveWorkInput", aParam);
if (resultData.isError)
{
throw new Exception(resultData.ResultValue);
}
this.Cursor = Cursors.Arrow;
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
XtraMessageBox.Show(ex.Message);
}
}
private void saveOutputProc(string mode)
{
try
{
this.Cursor = Cursors.WaitCursor;
SerializedSqlParam[] aParam = new SerializedSqlParam[]
{
ClientClass.CreateSqlParameter("MODE", SqlDbType.NVarChar, mode),
ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),
ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, m_ORDER_NO),
ClientClass.CreateSqlParameter("OUT_YN", SqlDbType.NVarChar, checkEdit_OUT_YN.Checked ? 'Y':'N'),
ClientClass.CreateSqlParameter("OUT_GBN", SqlDbType.NVarChar, lookUpEdit_OUT_GBN.EditValue),
ClientClass.CreateSqlParameter("OUT_CAR_NO", SqlDbType.NVarChar, lookUpEdit_OUT_CAR_NO.EditValue),
ClientClass.CreateSqlParameter("OUT_USR_ID", SqlDbType.NVarChar, lookUpEdit_OUT_USR_ID.EditValue),
ClientClass.CreateSqlParameter("OUT_DRV_NO", SqlDbType.NVarChar, textEdit_OUT_DRV_NO.Text),
ClientClass.CreateSqlParameter("OUT_TEL_NO", SqlDbType.NVarChar, textEdit_OUT_TEL_NO.Text),
ClientClass.CreateSqlParameter("OUT_GISA", SqlDbType.NVarChar, textEdit_OUT_GISA.Text),
ClientClass.CreateSqlParameter("REG_ID", SqlDbType.NVarChar, ConstClass._USR_ID)
};
ResultData resultData = ClientClass.SetData("SaveWorkOutput", aParam);
if (resultData.isError)
{
throw new Exception(resultData.ResultValue);
}
this.Cursor = Cursors.Arrow;
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
XtraMessageBox.Show(ex.Message);
}
}
private void saveWorkExecuteProc(string mode)
{
try
{
this.Cursor = Cursors.WaitCursor;
SerializedSqlParam[] aParam = new SerializedSqlParam[]
{
ClientClass.CreateSqlParameter("MODE", SqlDbType.NVarChar, mode),
ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),
ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, m_ORDER_NO),
ClientClass.CreateSqlParameter("LN_SEQ", SqlDbType.NVarChar, m_LN_SEQ),
ClientClass.CreateSqlParameter("FIN_YN", SqlDbType.NVarChar, UtilClass.isNull(textEdit_WORK_FIN_DATE.Text) ? 'N':'Y'),
ClientClass.CreateSqlParameter("FIN_QTY", SqlDbType.Int, UtilClass.toInt(textEdit_WORK_QTY.Text)),
ClientClass.CreateSqlParameter("WORK_USR_ID", SqlDbType.NVarChar, lookUpEdit_WORK_USR_ID.EditValue),
ClientClass.CreateSqlParameter("WORK_STA_DATE", SqlDbType.NVarChar, textEdit_WORK_STA_DATE.Text),
ClientClass.CreateSqlParameter("WORK_FIN_DATE", SqlDbType.NVarChar, textEdit_WORK_FIN_DATE.Text),
ClientClass.CreateSqlParameter("REG_ID", SqlDbType.NVarChar, ConstClass._USR_ID)
};
ResultData resultData = ClientClass.SetData("SaveWorkExecute", aParam);
if (resultData.isError)
{
throw new Exception(resultData.ResultValue);
}
this.Cursor = Cursors.Arrow;
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
XtraMessageBox.Show(ex.Message);
}
}
public string initProc(string order_no)
{
string result = "";
try
{
SerializedSqlParam[] aParam = new SerializedSqlParam[]
{
ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),
ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, order_no)
};
ResultData resultData = ClientClass.GetData("GetOrderManagerPopup", aParam);
if (resultData.isError)
{
throw new Exception(resultData.ResultValue);
}
if (resultData.DataList.Tables[0].Rows.Count > 0)
{
DataRow row = resultData.DataList.Tables[0].Rows[0];
m_ORDER_NO = UtilClass.toStr(row["ORDER_NO"]);
textEdit_ORDER_DATE.Text = UtilClass.toStr(row["ORDER_DATE"]);
textEdit_ORDER_SEQ.Text = UtilClass.toInt(row["ORDER_SEQ"]).ToString("0000");
textEdit_CUST_NM.Text = UtilClass.toStr(row["CUST_NM"]);
textEdit_CUST_CD.Text = UtilClass.toStr(row["CUST_CD"]);
textEdit_FILE_NM.Text = UtilClass.toStr(row["FILE_NM"]);
textEdit_PRINT_POS.Text = UtilClass.toStr(row["PRINT_POS"]);
textEdit_OUT_POS.Text = UtilClass.toStr(row["OUT_POS"]);
textEdit_INPUT_DATE.Text = UtilClass.toStr(row["INPUT_DATE"]);
textEdit_TEL_NO.Text = UtilClass.toStr(row["TEL_NO"]);
textEdit_OWNER_TEL_NO.Text = UtilClass.toStr(row["OWNER_TEL_NO"]);
textEdit_MGR_TEL_NO.Text = UtilClass.toStr(row["MGR_TEL_NO"]);
textEdit_INPUT_TIME.Text = UtilClass.toStr(row["INPUT_TIME"]);
checkEdit_IN_ING_YN.Checked = UtilClass.isEqual(row["IN_ING_YN"], "Y");
checkEdit_IN_FIN_YN.Checked = UtilClass.isEqual(row["IN_FIN_YN"], "Y");
if (UtilClass.isNull(row["IN_USR_ID"]))
{
lookUpEdit_IN_USR_ID.EditValue = "01";
}
else
{
lookUpEdit_IN_USR_ID.EditValue = UtilClass.toStr(row["IN_USR_ID"]);
}
textEdit_IN_DATE.Text = UtilClass.toStr(row["IN_DATE"]);
textEdit_IN_TIME.Text = UtilClass.toStr(row["IN_TIME"]);
checkEdit_OUT_YN.Checked = UtilClass.isEqual(row["OUT_YN"], "Y");
if (!UtilClass.isNull(row["OUT_GBN"]))
{
lookUpEdit_OUT_GBN.EditValue = UtilClass.toStr(row["OUT_GBN"]);
}
else
{
lookUpEdit_OUT_GBN.EditValue = "01";
}
if (!UtilClass.isNull(row["OUT_CAR_NO"]))
{
lookUpEdit_OUT_CAR_NO.EditValue = UtilClass.toStr(row["OUT_CAR_NO"]);
}
else
{
lookUpEdit_OUT_CAR_NO.EditValue = "01";
}
if (UtilClass.isNull(row["OUT_USR_ID"]))
{
lookUpEdit_OUT_USR_ID.EditValue = "01";
}
else
{
lookUpEdit_OUT_USR_ID.EditValue = UtilClass.toStr(row["OUT_USR_ID"]);
}
textEdit_OUT_DRV_NO.Text = UtilClass.toStr(row["OUT_DRV_NO"]);
textEdit_OUT_TEL_NO.Text = UtilClass.toStr(row["OUT_TEL_NO"]);
textEdit_OUT_GISA.Text = UtilClass.toStr(row["OUT_GISA"]);
textEdit_OUT_DATE.Text = UtilClass.toStr(row["OUT_DATE"]);
textEdit_OUT_TIME.Text = UtilClass.toStr(row["OUT_TIME"]);
}
gridControl_Main.DataSource = resultData.DataList.Tables[1];
}
catch (Exception ex)
{
result = ex.Message;
}
return result;
}
private void number_Click(object sender, EventArgs e)
{
if (this.ActiveControl is TextBoxMaskBox)
{
SendKeys.Send((sender as SimpleButton).Text);
}
}
private void printProc()
{
DataTable data = gridControl_Main.DataSource as DataTable;
WorkOrderReport report = new WorkOrderReport();
report.SetData(data,
m_ORDER_NO,
textEdit_ORDER_DATE.Text,
textEdit_ORDER_SEQ.Text,
textEdit_CUST_NM.Text,
textEdit_FILE_NM.Text,
textEdit_PRINT_POS.Text,
textEdit_OUT_POS.Text
);
}
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
{
if (keyData == (Keys.P | Keys.Alt))
{
printProc();
return true;
}
else if (keyData == (Keys.X | Keys.Alt))
{
simpleButton_CLOSE.PerformClick();
return true;
}
return base.ProcessCmdKey(ref msg, keyData);
}
}
}
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571·using ClientLib;using ClientLib.CommonService;using DevExpress.XtraEditors;using DevExpress.XtraGrid.Views.Grid.ViewInfo;using PublicLib;using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Net;using System.Text;using System.Windows.Forms;using System.Xml;namespace HANMI_SALE{partial class WorkManagerPopup : XtraForm{private string m_ORDER_NO;private int m_LN_SEQ;public WorkManagerPopup(){InitializeComponent();this.Icon = ConstClass._MAIN.Icon;m_ORDER_NO = "";m_LN_SEQ = 0;DataView out_gbn = new DataView(ConstClass._DATA);out_gbn.RowFilter = "CATE_CD = 'D' and GRP_CD = 'D01'";UtilClass.SetLookup(lookUpEdit_OUT_GBN, out_gbn, "NO_CD", "NO_CD_NM", true);DataView out_car_no = new DataView(ConstClass._DATA);out_car_no.RowFilter = "CATE_CD = 'D' and GRP_CD = 'D02'";UtilClass.SetLookup(lookUpEdit_OUT_CAR_NO, out_car_no, "NO_CD", "NO_CD_NM", true);DataView in_user = new DataView(ConstClass._DATA);in_user.RowFilter = "CATE_CD = 'L' and GRP_CD = 'L01'";UtilClass.SetLookup(lookUpEdit_IN_USR_ID, in_user, "NO_CD", "NO_CD_NM", true);DataView work_user = new DataView(ConstClass._DATA);work_user.RowFilter = "CATE_CD = 'L' and GRP_CD = 'L02'";UtilClass.SetLookup(lookUpEdit_WORK_USR_ID, work_user, "NO_CD", "NO_CD_NM", true);DataView out_user = new DataView(ConstClass._DATA);out_user.RowFilter = "CATE_CD = 'D' and GRP_CD = 'D04'";UtilClass.SetLookup(lookUpEdit_OUT_USR_ID, in_user, "NO_CD", "NO_CD_NM", true);simpleButton_BACK.Click += (sender, e) =>{if (this.ActiveControl is TextBoxMaskBox){SendKeys.Send("{BACKSPACE}");}};simpleButton_POINT.Click += (sender, e) =>{if (this.ActiveControl is TextBoxMaskBox){SendKeys.Send(".");}};simpleButton_DASH.Click += (sender, e) =>{if (this.ActiveControl is TextBoxMaskBox){SendKeys.Send("-");}};lookUpEdit_OUT_GBN.EditValueChanged += (sender, e) =>{if (UtilClass.isEqual(lookUpEdit_OUT_GBN.EditValue, "01")){lookUpEdit_OUT_CAR_NO.Enabled = true;lookUpEdit_OUT_USR_ID.Enabled = true;textEdit_OUT_DRV_NO.Enabled = false;textEdit_OUT_TEL_NO.Enabled = false;textEdit_OUT_GISA.Enabled = false;}else{lookUpEdit_OUT_CAR_NO.Enabled = false;lookUpEdit_OUT_USR_ID.Enabled = false;textEdit_OUT_DRV_NO.Enabled = true;textEdit_OUT_TEL_NO.Enabled = true;textEdit_OUT_GISA.Enabled = true;}};simpleButton_INPUT_OK.Click += (sender, e) =>{if (checkEdit_IN_ING_YN.Checked && !checkEdit_IN_FIN_YN.Checked){if (XtraMessageBox.Show("입고진행 처리를 하시겠습니까?", "확인", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes){saveInputIngProc("M");this.DialogResult = DialogResult.Yes;this.Close();}}else if (!checkEdit_IN_ING_YN.Checked && checkEdit_IN_FIN_YN.Checked){XtraMessageBox.Show("입고 진행후 작업하시기 바랍니다.");return;}else if (checkEdit_IN_ING_YN.Checked && checkEdit_IN_FIN_YN.Checked){if (XtraMessageBox.Show("입고확인 처리를 하시겠습니까?", "확인", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes){saveInputProc("M");this.DialogResult = DialogResult.Yes;this.Close();}}else{this.DialogResult = DialogResult.Yes;this.Close();}};simpleButton_INPUT_CANCEL.Click += (sender, e) =>{if (checkEdit_IN_ING_YN.Checked && !checkEdit_IN_FIN_YN.Checked){if (XtraMessageBox.Show("입고진행 처리를 취소하시겠습니까?", "취소", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes){saveInputIngProc("C");this.DialogResult = DialogResult.Yes;this.Close();}}else if (checkEdit_IN_ING_YN.Checked && checkEdit_IN_FIN_YN.Checked){if (XtraMessageBox.Show("입고확인 처리를 하시겠습니까?", "취소", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes){saveInputProc("C");this.DialogResult = DialogResult.Yes;this.Close();}}};simpleButton_OUT_OK.Click += (sender, e) =>{if (XtraMessageBox.Show("출고확인 처리를 하시겠습니까?", "확인", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes){checkEdit_OUT_YN.Checked = true;saveOutputProc("M");this.DialogResult = DialogResult.Yes;this.Close();}};simpleButton_OUT_CANCEL.Click += (sender, e) =>{if (XtraMessageBox.Show("출고취소 처리를 하시겠습니까?", "확인", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes){checkEdit_OUT_YN.Checked = false;saveOutputProc("C");this.DialogResult = DialogResult.Yes;this.Close();}};simpleButton_WORK_OK.Click += (sender, e) =>{if (XtraMessageBox.Show("작업진행 처리를 하시겠습니까?", "확인", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes){saveWorkExecuteProc("M");this.DialogResult = DialogResult.Yes;this.Close();}};simpleButton_WORK_CANCEL.Click += (sender, e) =>{if (XtraMessageBox.Show("작업진행 취소 처리를 하시겠습니까?", "취소", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes){saveWorkExecuteProc("C");this.DialogResult = DialogResult.Yes;this.Close();}};simpleButton_WORK_STA_INPUT.Click += (sender, e) =>{if (UtilClass.isNull(textEdit_WORK_STA_DATE.Text)){textEdit_WORK_STA_DATE.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");}else{textEdit_WORK_STA_DATE.Text = "";}};simpleButton_WORK_FIN_INPUT.Click += (sender, e) =>{if (UtilClass.isNull(textEdit_WORK_FIN_DATE.Text)){textEdit_WORK_FIN_DATE.Text = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");}else{textEdit_WORK_FIN_DATE.Text = "";}};simpleButton_0.Click += number_Click;simpleButton_1.Click += number_Click;simpleButton_2.Click += number_Click;simpleButton_3.Click += number_Click;simpleButton_4.Click += number_Click;simpleButton_5.Click += number_Click;simpleButton_6.Click += number_Click;simpleButton_7.Click += number_Click;simpleButton_8.Click += number_Click;simpleButton_9.Click += number_Click;simpleButton_PRINT.Click += (sender, e) =>{printProc();};gridView_Main.FocusedRowChanged += (sender, e) =>{DataRow row = gridView_Main.GetFocusedDataRow();if (row == null){return;}m_LN_SEQ = UtilClass.toInt(row["LN_SEQ"]);textEdit_LN_SEQ.Text = UtilClass.toInt(row["LN_SEQ"]).ToString("00");textEdit_ITEM_CD.Text = UtilClass.toStr(row["ITEM_CD"]);textEdit_ITEM_NM.Text = UtilClass.toStr(row["ITEM_NM"]);textEdit_ORDER_NORM.Text = UtilClass.toStr(row["ORDER_NORM"]);textEdit_MACH_NM.EditValue = UtilClass.toStr(row["MACH_NM"]);textEdit_ORDER_UNIT_NM.EditValue = UtilClass.toStr(row["ORDER_UNIT_NM"]);textEdit_ORDER_QTY.Text = UtilClass.toInt(row["ORDER_QTY"]).ToString("n0");textEdit_FIN_QTY.Text = UtilClass.toInt(row["FIN_QTY"]).ToString("n0");textEdit_ORDER_ADD_QTY.Text = UtilClass.toInt(row["ORDER_ADD_QTY"]).ToString("n0");textEdit_LN_RMK.Text = UtilClass.toStr(row["LN_RMK"]);textEdit_WORK_STA_DATE.Text = UtilClass.toStr(row["WORK_STA_DATE"]);textEdit_WORK_FIN_DATE.Text = UtilClass.toStr(row["WORK_FIN_DATE"]);textEdit_WORK_QTY.Text = UtilClass.toInt(row["FIN_QTY"]).ToString("n0");if (UtilClass.isNull(row["WORK_USR_ID"])){lookUpEdit_WORK_USR_ID.EditValue = "01";}else{lookUpEdit_WORK_USR_ID.EditValue = UtilClass.toStr(row["WORK_USR_ID"]);}};simpleButton_CLOSE.Click += (sender, e) =>{this.DialogResult = DialogResult.Yes;this.Close();};this.Shown += (sender, e) =>{if (!checkEdit_IN_ING_YN.Checked){simpleButton_INPUT_CANCEL.Enabled = false;panelControl_WORK.Enabled = false;panelControl_WORK_BUTTON.Enabled = false;panelControl_OUT.Enabled = false;}else if (checkEdit_IN_ING_YN.Checked && !checkEdit_IN_FIN_YN.Checked){simpleButton_INPUT_CANCEL.Enabled = true;panelControl_WORK.Enabled = false;panelControl_WORK_BUTTON.Enabled = false;panelControl_OUT.Enabled = false;}if (checkEdit_IN_ING_YN.Checked && checkEdit_IN_FIN_YN.Checked){simpleButton_INPUT_OK.Enabled = false;simpleButton_INPUT_CANCEL.Enabled = true;panelControl_WORK.Enabled = true;panelControl_WORK_BUTTON.Enabled = true;panelControl_OUT.Enabled = true;}};}private void saveInputIngProc(string mode){try{this.Cursor = Cursors.WaitCursor;SerializedSqlParam[] aParam = new SerializedSqlParam[]{ClientClass.CreateSqlParameter("MODE", SqlDbType.NVarChar, mode),ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, m_ORDER_NO),ClientClass.CreateSqlParameter("IN_ING_YN", SqlDbType.NVarChar, checkEdit_IN_ING_YN.Checked ? 'Y':'N'),ClientClass.CreateSqlParameter("IN_USR_ID", SqlDbType.NVarChar, lookUpEdit_IN_USR_ID.EditValue),ClientClass.CreateSqlParameter("REG_ID", SqlDbType.NVarChar, ConstClass._USR_ID)};ResultData resultData = ClientClass.SetData("SaveWorkInputIng", aParam);if (resultData.isError){throw new Exception(resultData.ResultValue);}this.Cursor = Cursors.Arrow;}catch (Exception ex){this.Cursor = Cursors.Arrow;XtraMessageBox.Show(ex.Message);}}private void saveInputProc(string mode){try{this.Cursor = Cursors.WaitCursor;SerializedSqlParam[] aParam = new SerializedSqlParam[]{ClientClass.CreateSqlParameter("MODE", SqlDbType.NVarChar, mode),ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, m_ORDER_NO),ClientClass.CreateSqlParameter("IN_ING_YN", SqlDbType.NVarChar, checkEdit_IN_ING_YN.Checked ? 'Y':'N'),ClientClass.CreateSqlParameter("IN_FIN_YN", SqlDbType.NVarChar, checkEdit_IN_FIN_YN.Checked ? 'Y':'N'),ClientClass.CreateSqlParameter("IN_USR_ID", SqlDbType.NVarChar, lookUpEdit_IN_USR_ID.EditValue),ClientClass.CreateSqlParameter("REG_ID", SqlDbType.NVarChar, ConstClass._USR_ID)};ResultData resultData = ClientClass.SetData("SaveWorkInput", aParam);if (resultData.isError){throw new Exception(resultData.ResultValue);}this.Cursor = Cursors.Arrow;}catch (Exception ex){this.Cursor = Cursors.Arrow;XtraMessageBox.Show(ex.Message);}}private void saveOutputProc(string mode){try{this.Cursor = Cursors.WaitCursor;SerializedSqlParam[] aParam = new SerializedSqlParam[]{ClientClass.CreateSqlParameter("MODE", SqlDbType.NVarChar, mode),ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, m_ORDER_NO),ClientClass.CreateSqlParameter("OUT_YN", SqlDbType.NVarChar, checkEdit_OUT_YN.Checked ? 'Y':'N'),ClientClass.CreateSqlParameter("OUT_GBN", SqlDbType.NVarChar, lookUpEdit_OUT_GBN.EditValue),ClientClass.CreateSqlParameter("OUT_CAR_NO", SqlDbType.NVarChar, lookUpEdit_OUT_CAR_NO.EditValue),ClientClass.CreateSqlParameter("OUT_USR_ID", SqlDbType.NVarChar, lookUpEdit_OUT_USR_ID.EditValue),ClientClass.CreateSqlParameter("OUT_DRV_NO", SqlDbType.NVarChar, textEdit_OUT_DRV_NO.Text),ClientClass.CreateSqlParameter("OUT_TEL_NO", SqlDbType.NVarChar, textEdit_OUT_TEL_NO.Text),ClientClass.CreateSqlParameter("OUT_GISA", SqlDbType.NVarChar, textEdit_OUT_GISA.Text),ClientClass.CreateSqlParameter("REG_ID", SqlDbType.NVarChar, ConstClass._USR_ID)};ResultData resultData = ClientClass.SetData("SaveWorkOutput", aParam);if (resultData.isError){throw new Exception(resultData.ResultValue);}this.Cursor = Cursors.Arrow;}catch (Exception ex){this.Cursor = Cursors.Arrow;XtraMessageBox.Show(ex.Message);}}private void saveWorkExecuteProc(string mode){try{this.Cursor = Cursors.WaitCursor;SerializedSqlParam[] aParam = new SerializedSqlParam[]{ClientClass.CreateSqlParameter("MODE", SqlDbType.NVarChar, mode),ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, m_ORDER_NO),ClientClass.CreateSqlParameter("LN_SEQ", SqlDbType.NVarChar, m_LN_SEQ),ClientClass.CreateSqlParameter("FIN_YN", SqlDbType.NVarChar, UtilClass.isNull(textEdit_WORK_FIN_DATE.Text) ? 'N':'Y'),ClientClass.CreateSqlParameter("FIN_QTY", SqlDbType.Int, UtilClass.toInt(textEdit_WORK_QTY.Text)),ClientClass.CreateSqlParameter("WORK_USR_ID", SqlDbType.NVarChar, lookUpEdit_WORK_USR_ID.EditValue),ClientClass.CreateSqlParameter("WORK_STA_DATE", SqlDbType.NVarChar, textEdit_WORK_STA_DATE.Text),ClientClass.CreateSqlParameter("WORK_FIN_DATE", SqlDbType.NVarChar, textEdit_WORK_FIN_DATE.Text),ClientClass.CreateSqlParameter("REG_ID", SqlDbType.NVarChar, ConstClass._USR_ID)};ResultData resultData = ClientClass.SetData("SaveWorkExecute", aParam);if (resultData.isError){throw new Exception(resultData.ResultValue);}this.Cursor = Cursors.Arrow;}catch (Exception ex){this.Cursor = Cursors.Arrow;XtraMessageBox.Show(ex.Message);}}public string initProc(string order_no){string result = "";try{SerializedSqlParam[] aParam = new SerializedSqlParam[]{ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, order_no)};ResultData resultData = ClientClass.GetData("GetOrderManagerPopup", aParam);if (resultData.isError){throw new Exception(resultData.ResultValue);}if (resultData.DataList.Tables[0].Rows.Count > 0){DataRow row = resultData.DataList.Tables[0].Rows[0];m_ORDER_NO = UtilClass.toStr(row["ORDER_NO"]);textEdit_ORDER_DATE.Text = UtilClass.toStr(row["ORDER_DATE"]);textEdit_ORDER_SEQ.Text = UtilClass.toInt(row["ORDER_SEQ"]).ToString("0000");textEdit_CUST_NM.Text = UtilClass.toStr(row["CUST_NM"]);textEdit_CUST_CD.Text = UtilClass.toStr(row["CUST_CD"]);textEdit_FILE_NM.Text = UtilClass.toStr(row["FILE_NM"]);textEdit_PRINT_POS.Text = UtilClass.toStr(row["PRINT_POS"]);textEdit_OUT_POS.Text = UtilClass.toStr(row["OUT_POS"]);textEdit_INPUT_DATE.Text = UtilClass.toStr(row["INPUT_DATE"]);textEdit_TEL_NO.Text = UtilClass.toStr(row["TEL_NO"]);textEdit_OWNER_TEL_NO.Text = UtilClass.toStr(row["OWNER_TEL_NO"]);textEdit_MGR_TEL_NO.Text = UtilClass.toStr(row["MGR_TEL_NO"]);textEdit_INPUT_TIME.Text = UtilClass.toStr(row["INPUT_TIME"]);checkEdit_IN_ING_YN.Checked = UtilClass.isEqual(row["IN_ING_YN"], "Y");checkEdit_IN_FIN_YN.Checked = UtilClass.isEqual(row["IN_FIN_YN"], "Y");if (UtilClass.isNull(row["IN_USR_ID"])){lookUpEdit_IN_USR_ID.EditValue = "01";}else{lookUpEdit_IN_USR_ID.EditValue = UtilClass.toStr(row["IN_USR_ID"]);}textEdit_IN_DATE.Text = UtilClass.toStr(row["IN_DATE"]);textEdit_IN_TIME.Text = UtilClass.toStr(row["IN_TIME"]);checkEdit_OUT_YN.Checked = UtilClass.isEqual(row["OUT_YN"], "Y");if (!UtilClass.isNull(row["OUT_GBN"])){lookUpEdit_OUT_GBN.EditValue = UtilClass.toStr(row["OUT_GBN"]);}else{lookUpEdit_OUT_GBN.EditValue = "01";}if (!UtilClass.isNull(row["OUT_CAR_NO"])){lookUpEdit_OUT_CAR_NO.EditValue = UtilClass.toStr(row["OUT_CAR_NO"]);}else{lookUpEdit_OUT_CAR_NO.EditValue = "01";}if (UtilClass.isNull(row["OUT_USR_ID"])){lookUpEdit_OUT_USR_ID.EditValue = "01";}else{lookUpEdit_OUT_USR_ID.EditValue = UtilClass.toStr(row["OUT_USR_ID"]);}textEdit_OUT_DRV_NO.Text = UtilClass.toStr(row["OUT_DRV_NO"]);textEdit_OUT_TEL_NO.Text = UtilClass.toStr(row["OUT_TEL_NO"]);textEdit_OUT_GISA.Text = UtilClass.toStr(row["OUT_GISA"]);textEdit_OUT_DATE.Text = UtilClass.toStr(row["OUT_DATE"]);textEdit_OUT_TIME.Text = UtilClass.toStr(row["OUT_TIME"]);}gridControl_Main.DataSource = resultData.DataList.Tables[1];}catch (Exception ex){result = ex.Message;}return result;}private void number_Click(object sender, EventArgs e){if (this.ActiveControl is TextBoxMaskBox){SendKeys.Send((sender as SimpleButton).Text);}}private void printProc(){DataTable data = gridControl_Main.DataSource as DataTable;WorkOrderReport report = new WorkOrderReport();report.SetData(data,m_ORDER_NO,textEdit_ORDER_DATE.Text,textEdit_ORDER_SEQ.Text,textEdit_CUST_NM.Text,textEdit_FILE_NM.Text,textEdit_PRINT_POS.Text,textEdit_OUT_POS.Text);}protected override bool ProcessCmdKey(ref Message msg, Keys keyData){if (keyData == (Keys.P | Keys.Alt)){printProc();return true;}else if (keyData == (Keys.X | Keys.Alt)){simpleButton_CLOSE.PerformClick();return true;}return base.ProcessCmdKey(ref msg, keyData);}}}