
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_J_SALE
{
partial class SaleRegistrationPopup : XtraForm
{
private string m_ORDER_NO;
public bool m_Changed;
public SaleRegistrationPopup()
{
InitializeComponent();
this.Icon = ConstClass._MAIN.Icon;
m_Changed = false;
m_ORDER_NO = "";
dateEdit_DATE.DateTime = DateTime.Now;
buttonEdit_ORDER_SEQ.Text = "";
buttonEdit_DC.ButtonClick += (sender, e) =>
{
if (UtilClass.isNull(labelControl_CUST_CD.Text))
{
MessageBox.Show("거래선을 먼저 조회하여 선택하십시오.");
return;
}
SelectCustDCPopup form = new SelectCustDCPopup(labelControl_CUST_CD.Text, buttonEdit_CUST_NM.Text);
form.ShowDialog();
};
buttonEdit_CUST_NM.KeyPress += (sender, e) =>
{
if (e.KeyChar == '\r')
{
selectCustProc();
}
};
buttonEdit_CUST_NM.ButtonClick += (sender, e) =>
{
selectCustProc();
};
buttonEdit_ITEM_NM.ButtonClick += (sender, e) =>
{
SelectSalesItemForm form = new SelectSalesItemForm(buttonEdit_ITEM_NM.Text);
if (form.ShowDialog() == DialogResult.Yes)
{
buttonEdit_ITEM_NM.Text = form.m_ITEM_NM;
buttonEdit_ITEM_NM.Tag = form.m_UNIT_MY;
labelControl_ITEM_CD.Text = form.m_ITEM_CD;
labelControl_ITEM_CD.Tag = form.m_ROUT_CD;
textEdit_UNIT_WT.EditValue = form.m_UNIT_WT;
textEdit_AREA_WT.Focus();
}
else
{
buttonEdit_ITEM_NM.Text = "";
buttonEdit_ITEM_NM.Tag = 0;
labelControl_ITEM_CD.Text = "";
labelControl_ITEM_CD.Tag = "";
textEdit_UNIT_WT.Text = "";
}
};
buttonEdit_ITEM_NM.KeyPress += (sender, e) =>
{
if (e.KeyChar == '\r')
{
SelectSalesItemForm form = new SelectSalesItemForm(buttonEdit_ITEM_NM.Text);
if (form.ShowDialog() == DialogResult.Yes)
{
buttonEdit_ITEM_NM.Text = form.m_ITEM_NM;
labelControl_ITEM_CD.Text = form.m_ITEM_CD;
textEdit_UNIT_WT.EditValue = form.m_UNIT_WT;
textEdit_AREA_WT.Focus();
}
else
{
buttonEdit_ITEM_NM.Text = "";
labelControl_ITEM_CD.Text = "";
textEdit_UNIT_WT.Text = "";
}
}
};
buttonEdit_SPEC.ButtonClick += (sender, e) =>
{
if (UtilClass.isNull(labelControl_ITEM_CD.Text))
{
buttonEdit_ITEM_NM.Focus();
MessageBox.Show("품목을 선택하십시오.");
return;
}
SelectNormForm form = new SelectNormForm(labelControl_ITEM_CD.Text);
if (form.ShowDialog() == DialogResult.Yes)
{
buttonEdit_SPEC.Text = form.m_NORM;
textEdit_ORDER_QTY.Focus();
}
};
buttonEdit_SPEC.KeyPress += (sender, e) =>
{
if (e.KeyChar == '\r')
{
SelectNormForm form = new SelectNormForm(labelControl_ITEM_CD.Text);
if (form.ShowDialog() == DialogResult.Yes)
{
buttonEdit_SPEC.Text = form.m_NORM;
textEdit_ORDER_QTY.Focus();
}
}
};
buttonEdit_CUT_CNT.ButtonClick += (sender, e) =>
{
SelectCodePopup form = new SelectCodePopup("C", "C15", "절수");
if (form.ShowDialog() == DialogResult.Yes)
{
buttonEdit_CUT_CNT.Text = form.m_NO_CD_NM;
textEdit_REMARK.Focus();
}
};
textEdit_ORDER_QTY.EditValueChanged += (sender, e) =>
{
refreshCost();
};
buttonEdit_CURR_UNIT_MY.ButtonClick += (sender, e) =>
{
try
{
this.Cursor = Cursors.WaitCursor;
if (UtilClass.isNull(labelControl_ITEM_CD.Text))
{
throw new Exception("품목코드 없이 단가조회를 할 수 없습니다. 품목을 조회하여 선택하십시오.");
}
buttonEdit_CURR_UNIT_MY.Text = "";
SerializedSqlParam[] aParam = new SerializedSqlParam[]
{
ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),
ClientClass.CreateSqlParameter("ITEM_CD", SqlDbType.NVarChar, labelControl_ITEM_CD.Text)
};
ResultData resultData = ClientClass.GetData("GetItemUnitMy", aParam);
if (resultData.isError)
{
throw new Exception(resultData.ResultValue);
}
if (resultData.TableData.Rows.Count > 0)
{
buttonEdit_CURR_UNIT_MY.EditValue = resultData.TableData.Rows[0]["UNIT_MY"];
}
this.Cursor = Cursors.Arrow;
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
MessageBox.Show(ex.Message);
}
};
buttonEdit_CURR_UNIT_MY.ButtonClick += (sender, e) =>
{
buttonEdit_CURR_UNIT_MY.EditValue = UtilClass.toDouble(buttonEdit_ITEM_NM.Tag);
};
buttonEdit_CURR_UNIT_MY.EditValueChanged += (sender, e) =>
{
refreshCost();
};
buttonEdit_ORDER_SEQ.KeyPress += (sender, e) =>
{
if (!UtilClass.isNull(buttonEdit_ORDER_SEQ.Text))
{
searchProc(3);
}
};
buttonEdit_ORDER_SEQ.ButtonClick += (sender, e) =>
{
if (e.Button.Index == 0) // 기존정보 검색
{
OrderSeqPopup form = new OrderSeqPopup(dateEdit_DATE.DateTime);
if (form.ShowDialog() == DialogResult.Yes)
{
buttonEdit_ORDER_SEQ.Text = form.m_ORDER_SEQ;
dateEdit_DATE.DateTime = UtilClass.toDateTime(form.m_ORDER_DT);
searchProc(3);
}
}
else if (e.Button.Index == 1) // 높은 번호 검색
{
searchProc(1);
}
else // 낮은 번호 검색
{
searchProc(2);
}
};
buttonEdit_OUT_POS.KeyPress += (sender, e) =>
{
if (e.KeyChar == '\r')
{
if (UtilClass.isNull(buttonEdit_OUT_POS.Text))
{
if (!UtilClass.isNull(labelControl_CUST_CD.Text))
{
buttonEdit_OUT_POS.Text = buttonEdit_CUST_NM.Text;
}
}
}
};
buttonEdit_OUT_POS.ButtonClick += (sender, e) =>
{
SelectOutPosForm form = new SelectOutPosForm(labelControl_CUST_CD.Text, buttonEdit_CUST_NM.Text);
if (form.ShowDialog() == DialogResult.Yes)
{
buttonEdit_OUT_POS.Text = form.m_LOCATION_NM;
}
else
{
buttonEdit_OUT_POS.Text = "";
labelControl_OUT_POS.Text = "";
}
};
simpleButton_AreaEdit.Click += (sender, e) =>
{
SelectCodePopup form = new SelectCodePopup("C", "C17", "지역");
if (form.ShowDialog() == DialogResult.Yes)
{
UtilClass.SetLookup(lookUpEdit_OUT_AREA_CD, form.m_Data, "NO_CD", "NO_CD_NM", true);
lookUpEdit_OUT_AREA_CD.EditValue = form.m_NO_CD;
}
};
simpleButton_Clear.Click += (sender, e) =>
{
clearProc();
};
simpleButton_ItemAdd.Click += (sender, e) =>
{
itemAddProc();
};
simpleButton_ItemUpdate.Click += (sender, e) =>
{
itemUpdateProc();
};
simpleButton_ItemDelete.Click += (sender, e) =>
{
itemDeleteProc();
};
simpleButton_ItemClose.Click += (sender, e) =>
{
itemCloseProc();
};
simpleButton_CANCEL.Click += (sender, e) =>
{
searchProc(0);
};
simpleButton_INPUT.Click += (sender, e) =>
{
saveProc("I", "");
};
simpleButton_UPDATE.Click += (sender, e) =>
{
saveProc("M", buttonEdit_ORDER_SEQ.Text);
};
simpleButton_DELETE.Click += (sender, e) =>
{
deleteProc();
};
simpleButton_CLOSE.Click += (sender, e) =>
{
this.DialogResult = m_Changed ? DialogResult.Yes : DialogResult.Cancel;
this.Close();
};
gridView_Main.Click += (sender, e) =>
{
Point aPT = gridControl_Main.PointToClient(Control.MousePosition);
GridHitInfo aInfo = gridView_Main.CalcHitInfo(aPT);
if (aInfo.InRowCell)
{
dataBinding();
}
};
gridView_Main.FocusedRowChanged += (sender, e) =>
{
dataBinding();
};
this.Shown += (sender, e) =>
{
try
{
DataView c13 = new DataView(ConstClass._DATA);
c13.RowFilter = "CATE_CD = 'C' and GRP_CD = 'C13'";
UtilClass.SetLookup(lookUpEdit_PROC_CD, c13, "NO_CD", "NO_CD_NM", true);
DataView c11 = new DataView(ConstClass._DATA);
c11.RowFilter = "CATE_CD = 'C' and GRP_CD = 'C11'";
UtilClass.SetLookup(lookUpEdit_STOCK, c11, "NO_CD", "NO_CD_NM", true);
DataView c14 = new DataView(ConstClass._DATA);
c14.RowFilter = "CATE_CD = 'C' and GRP_CD = 'C14'";
UtilClass.SetLookup(lookUpEdit_UNIT_CD, c14, "NO_CD", "NO_CD_NM", true);
DataView c16 = new DataView(ConstClass._DATA);
c16.RowFilter = "CATE_CD = 'C' and GRP_CD = 'C16'";
UtilClass.SetLookup(lookUpEdit_SIGN_GUBUN_CD, c16, "NO_CD", "NO_CD_NM", true);
DataView c17 = new DataView(ConstClass._DATA);
c17.RowFilter = "CATE_CD = 'C' and GRP_CD = 'C17'";
UtilClass.SetLookup(lookUpEdit_OUT_AREA_CD, c17, "NO_CD", "NO_CD_NM", true);
if (UtilClass.isNull(buttonEdit_ORDER_SEQ.Text))
{
searchProc(0);
}
else
{
searchProc(3);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
MessageBox.Show(ex.Message);
}
};
}
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
{
if (keyData == (Keys.A | Keys.Alt))
{
searchProc(0);
return true;
}
else if (keyData == (Keys.I | Keys.Alt))
{
saveProc("I", "");
return true;
}
else if (keyData == (Keys.M | Keys.Alt))
{
saveProc("M", buttonEdit_ORDER_SEQ.Text);
return true;
}
else if (keyData == (Keys.D | Keys.Alt))
{
deleteProc();
return true;
}
else if (keyData == (Keys.X | Keys.Alt))
{
this.DialogResult = m_Changed ? DialogResult.Yes : DialogResult.Cancel;
this.Close();
return true;
}
else if (keyData == (Keys.F5))
{
itemAddProc();
return true;
}
else if (keyData == (Keys.F6))
{
itemUpdateProc();
return true;
}
else if (keyData == (Keys.F7))
{
itemDeleteProc();
return true;
}
else if (keyData == (Keys.F8))
{
itemCloseProc();
return true;
}
return base.ProcessCmdKey(ref msg, keyData);
}
public void setData(DateTime dt, string seq)
{
dateEdit_DATE.DateTime = dt;
buttonEdit_ORDER_SEQ.Text = seq;
}
private void itemAddProc()
{
try
{
if (UtilClass.isNull(labelControl_CUST_CD.Text))
{
buttonEdit_CUST_NM.Focus();
throw new Exception("거래선을 조회하여 선택하십시오.");
}
if (UtilClass.isNull(labelControl_ITEM_CD.Text))
{
buttonEdit_ITEM_NM.Focus();
throw new Exception("품목을 조회하여 선택하십시오.");
}
int r_no = 0, ln_seq = 0; ;
DataTable data = gridControl_Main.DataSource as DataTable;
for (int i = 0; i < data.Rows.Count; i++)
{
if (data.Rows[i].RowState == DataRowState.Deleted)
{
continue;
}
if (r_no < UtilClass.toInt(data.Rows[i]["R_NO"]))
{
r_no = UtilClass.toInt(data.Rows[i]["R_NO"]);
}
if (ln_seq < UtilClass.toInt(data.Rows[i]["LN_SEQ"]))
{
ln_seq = UtilClass.toInt(data.Rows[i]["LN_SEQ"]);
}
}
r_no++;
ln_seq++;
DataRow row = data.NewRow();
row["R_NO"] = r_no;
row["LN_SEQ"] = ln_seq;
row["ORDER_NO"] = "";
row["ITEM_CD"] = labelControl_ITEM_CD.Text;
row["ITEM_NM"] = buttonEdit_ITEM_NM.Text;
row["ROUT_CD"] = labelControl_ITEM_CD.Tag;
row["AREA_WT"] = textEdit_AREA_WT.Text;
row["ORDER_NORM"] = buttonEdit_SPEC.Text.Trim();
row["ORDER_QTY"] = UtilClass.toInt(textEdit_ORDER_QTY.EditValue);
row["UNIT_NM"] = lookUpEdit_UNIT_CD.Text;
row["DC_RATE"] = UtilClass.toDouble(textEdit_DC_RATE.EditValue);
row["CURR_UNIT_MY"] = UtilClass.toInt(buttonEdit_CURR_UNIT_MY.EditValue);
row["CURR_MY"] = UtilClass.toInt(textEdit_CURR_MY.EditValue);
row["VAT_MY"] = UtilClass.toInt(textEdit_VAT_MY.EditValue);
row["ORDER_MY"] = UtilClass.toInt(textEdit_ORDER_MY.EditValue);
row["REPLACE_YN"] = "";
row["LN_RMK"] = textEdit_REMARK.Text.Trim();
row["STOCK_NM"] = lookUpEdit_STOCK.Text;
row["ORDER_WT"] = UtilClass.toInt(textEdit_ORDER_QTY.EditValue) * UtilClass.toInt(textEdit_UNIT_WT.EditValue);
row["CUT_CNT"] = buttonEdit_CUT_CNT.Text;
row["SALES_GUBUN_NM"] = "";
row["PAPER_CUST_NM"] = "";
row["STOCK_CNT"] = 0;
row["ORDER_UNIT_CD"] = lookUpEdit_UNIT_CD.EditValue;
row["STOCK_CD"] = lookUpEdit_STOCK.EditValue;
row["SALES_GUBUN_CD"] = "";
row["PAPER_CUST_CD"] = "";
row["BILL_NO"] = "";
data.Rows.Add(row);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void itemUpdateProc()
{
DataRow row = gridView_Main.GetFocusedDataRow();
if (row == null)
{
return;
}
row["ITEM_CD"] = labelControl_ITEM_CD.Text;
row["ITEM_NM"] = buttonEdit_ITEM_NM.Text;
row["ROUT_CD"] = labelControl_ITEM_CD.Tag;
row["AREA_WT"] = textEdit_AREA_WT.Text;
row["ORDER_NORM"] = buttonEdit_SPEC.Text.Trim();
row["ORDER_QTY"] = UtilClass.toInt(textEdit_ORDER_QTY.EditValue);
row["UNIT_NM"] = lookUpEdit_UNIT_CD.Text;
row["DC_RATE"] = UtilClass.toDouble(textEdit_DC_RATE.EditValue);
row["CURR_UNIT_MY"] = UtilClass.toInt(buttonEdit_CURR_UNIT_MY.EditValue);
row["CURR_MY"] = UtilClass.toInt(textEdit_CURR_MY.EditValue);
row["VAT_MY"] = UtilClass.toInt(textEdit_VAT_MY.EditValue);
row["ORDER_MY"] = UtilClass.toInt(textEdit_ORDER_MY.EditValue);
row["REPLACE_YN"] = "";
row["LN_RMK"] = textEdit_REMARK.Text.Trim();
row["STOCK_NM"] = lookUpEdit_STOCK.Text;
row["ORDER_WT"] = UtilClass.toInt(textEdit_ORDER_QTY.EditValue) * UtilClass.toInt(textEdit_UNIT_WT.EditValue);
row["CUT_CNT"] = buttonEdit_CUT_CNT.Text;
row["SALES_GUBUN_NM"] = "";
row["PAPER_CUST_NM"] = "";
row["STOCK_CNT"] = 0;
row["ORDER_UNIT_CD"] = lookUpEdit_UNIT_CD.EditValue;
row["STOCK_CD"] = lookUpEdit_STOCK.EditValue;
row["SALES_GUBUN_CD"] = "";
row["PAPER_CUST_CD"] = "";
}
private void itemDeleteProc()
{
if (MessageBox.Show("선택하신 건 자료를 삭제하시겠습니까?", "삭제", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
gridView_Main.DeleteSelectedRows();
}
}
private void itemCloseProc()
{
buttonEdit_OUT_POS.Focus();
}
private void clearProc()
{
buttonEdit_ITEM_NM.Text = "";
buttonEdit_ITEM_NM.Tag = 0;
labelControl_ITEM_CD.Text = "";
labelControl_ITEM_CD.Tag = "";
textEdit_AREA_WT.Text = "";
buttonEdit_SPEC.Text = "";
textEdit_YearWT.Text = "";
textEdit_ORDER_QTY.Text = "0";
textEdit_UNIT_WT.Text = "0.0";
lookUpEdit_UNIT_CD.ItemIndex = 0;
buttonEdit_CUT_CNT.Text = "";
textEdit_REMARK.Text = "";
buttonEdit_STD_COST.Text = "";
textEdit_DC_RATE.Text = "0.0";
buttonEdit_CURR_UNIT_MY.Text = "0";
textEdit_CURR_MY.Text = "0";
textEdit_VAT_MY.Text = "0";
textEdit_ORDER_MY.Text = "0";
textEdit_BILL_NO.Text = "";
}
private void dataBinding()
{
DataRow row = gridView_Main.GetFocusedDataRow();
if (row == null)
{
clearProc();
return;
}
buttonEdit_ITEM_NM.Text = UtilClass.toStr(row["ITEM_NM"]);
buttonEdit_ITEM_NM.Tag = row["UNIT_MY"];
labelControl_ITEM_CD.Text = UtilClass.toStr(row["ITEM_CD"]);
labelControl_ITEM_CD.Tag = UtilClass.toStr(row["ROUT_CD"]);
textEdit_AREA_WT.Text = UtilClass.toStr(row["AREA_WT"]);
buttonEdit_SPEC.Text = UtilClass.toStr(row["ORDER_NORM"]);
textEdit_YearWT.Text = "";
textEdit_ORDER_QTY.EditValue = row["ORDER_QTY"];
textEdit_UNIT_WT.EditValue = row["UNIT_WT"];
lookUpEdit_UNIT_CD.EditValue = row["ORDER_UNIT_CD"];
buttonEdit_CUT_CNT.Text = UtilClass.toStr(row["CUT_CNT"]);
textEdit_REMARK.Text = UtilClass.toStr(row["LN_RMK"]);
buttonEdit_STD_COST.Text = "";
textEdit_DC_RATE.EditValue = row["DC_RATE"];
buttonEdit_CURR_UNIT_MY.EditValue = row["CURR_UNIT_MY"];
textEdit_CURR_MY.EditValue = row["CURR_MY"];
textEdit_VAT_MY.EditValue = row["VAT_MY"];
textEdit_ORDER_MY.EditValue = row["ORDER_MY"];
textEdit_BILL_NO.EditValue = UtilClass.toStr(row["BILL_NO"]);
}
private void refreshCost()
{
int qty = UtilClass.toInt(textEdit_ORDER_QTY.EditValue);
int unit_my = UtilClass.toInt(buttonEdit_CURR_UNIT_MY.EditValue);
buttonEdit_CURR_UNIT_MY.EditValue = unit_my;
textEdit_CURR_MY.EditValue = qty * unit_my;
textEdit_VAT_MY.EditValue = (qty * unit_my) * 0.1;
textEdit_ORDER_MY.EditValue = (qty * unit_my) + (qty * unit_my) * 0.1;
}
private void selectCustProc()
{
SelectCustomerForm form = new SelectCustomerForm(buttonEdit_CUST_NM.Text, DateTime.Now);
if (form.ShowDialog() != System.Windows.Forms.DialogResult.Yes)
{
return;
}
buttonEdit_CUST_NM.Text = form.m_CUST_NM;
labelControl_CUST_CD.Text = form.m_CUST_CD;
}
private void searchProc(int mode)
{
try
{
this.Cursor = Cursors.WaitCursor;
gridControl_Main.DataSource = null;
SerializedSqlParam[] aParam = new SerializedSqlParam[]
{
ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),
ClientClass.CreateSqlParameter("ORDER_DT", SqlDbType.NVarChar, dateEdit_DATE.DateTime.ToString("yyyy.MM.dd")),
ClientClass.CreateSqlParameter("ORDER_SEQ", SqlDbType.NVarChar, buttonEdit_ORDER_SEQ.Text),
ClientClass.CreateSqlParameter("MODE", SqlDbType.Int, mode)
};
ResultData resultData = ClientClass.GetData("GetSaleRegistrationPopup", aParam);
if (resultData.isError)
{
throw new Exception(resultData.ResultValue);
}
m_ORDER_NO = "";
if (resultData.DataList.Tables[0].Rows.Count > 0)
{
m_ORDER_NO = UtilClass.toStr(resultData.DataList.Tables[0].Rows[0]["ORDER_NO"]);
}
gridControl_Main.DataSource = resultData.DataList.Tables[0];
if (resultData.DataList.Tables[1].Rows.Count > 0)
{
buttonEdit_OUT_POS.Text = UtilClass.toStr(resultData.DataList.Tables[1].Rows[0]["OUT_POS"]);
lookUpEdit_SIGN_GUBUN_CD.EditValue = resultData.DataList.Tables[1].Rows[0]["SIGN_GUBUN_CD"];
lookUpEdit_OUT_AREA_CD.EditValue = resultData.DataList.Tables[1].Rows[0]["OUT_AREA_CD"];
buttonEdit_CUST_NM.Text = UtilClass.toStr(resultData.DataList.Tables[1].Rows[0]["CUST_NM"]);
labelControl_CUST_CD.Text = UtilClass.toStr(resultData.DataList.Tables[1].Rows[0]["CUST_CD"]);
}
else
{
lookUpEdit_SIGN_GUBUN_CD.ItemIndex = 1;
lookUpEdit_OUT_AREA_CD.ItemIndex = 0;
buttonEdit_OUT_POS.Text = "";
buttonEdit_CUST_NM.Text = "";
labelControl_CUST_CD.Text = "";
}
if (resultData.DataList.Tables[2].Rows.Count > 0)
{
buttonEdit_ORDER_SEQ.Text = UtilClass.toStr(resultData.DataList.Tables[2].Rows[0]["ORDER_SEQ"]);
}
else
{
buttonEdit_ORDER_SEQ.Text = "";
}
this.Cursor = Cursors.Arrow;
if (mode > 0 && resultData.DataList.Tables[0].Rows.Count < 1)
{
MessageBox.Show("해당 관리번호가 없습니다. 확인하시길 바랍니다.");
}
clearProc();
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
MessageBox.Show(ex.Message);
}
}
private void saveProc(string mode, string order_seq)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (UtilClass.isNull(labelControl_CUST_CD.Text))
{
buttonEdit_CUST_NM.Focus();
throw new Exception("거래선을 조회하여 선택하십시오.");
}
if (mode.Equals("M") && UtilClass.isNull(order_seq))
{
buttonEdit_ORDER_SEQ.Focus();
throw new Exception("수정할 관리번호가 없습니다.");
}
DataTable data = gridControl_Main.DataSource as DataTable;
DataTable aData = new DataTable();
aData.Columns.Add("LN_SEQ", typeof(int));
aData.Columns.Add("ITEM_CD", typeof(string));
aData.Columns.Add("ROUT_CD", typeof(string));
aData.Columns.Add("AREA_WT", typeof(string));
aData.Columns.Add("ORDER_NORM", typeof(string));
aData.Columns.Add("ORDER_QTY", typeof(int));
aData.Columns.Add("ORDER_UNIT_CD", typeof(string));
aData.Columns.Add("DC_RATE", typeof(double));
aData.Columns.Add("CURR_UNIT_MY", typeof(int));
aData.Columns.Add("CURR_MY", typeof(int));
aData.Columns.Add("VAT_MY", typeof(int));
aData.Columns.Add("ORDER_MY", typeof(int));
aData.Columns.Add("REPLACE_YN", typeof(string));
aData.Columns.Add("LN_RMK", typeof(string));
aData.Columns.Add("STOCK_CD", typeof(string));
aData.Columns.Add("ORDER_WT", typeof(double));
aData.Columns.Add("CUT_CNT", typeof(string));
aData.Columns.Add("SALES_GUBUN_CD", typeof(string));
aData.Columns.Add("PAPER_CUST_CD", typeof(string));
aData.Columns.Add("STOCK_CNT", typeof(string));
DataRow row;
for (int i = 0; i < data.Rows.Count; i++)
{
if (data.Rows[i].RowState == DataRowState.Deleted)
{
continue;
}
row = aData.NewRow();
row["LN_SEQ"] = data.Rows[i]["LN_SEQ"];
row["ITEM_CD"] = data.Rows[i]["ITEM_CD"];
row["ROUT_CD"] = data.Rows[i]["ROUT_CD"];
row["AREA_WT"] = data.Rows[i]["AREA_WT"];
row["ORDER_NORM"] = data.Rows[i]["ORDER_NORM"];
row["ORDER_QTY"] = data.Rows[i]["ORDER_QTY"];
row["ORDER_UNIT_CD"] = data.Rows[i]["ORDER_UNIT_CD"];
row["DC_RATE"] = data.Rows[i]["DC_RATE"];
row["CURR_UNIT_MY"] = data.Rows[i]["CURR_UNIT_MY"];
row["CURR_MY"] = data.Rows[i]["CURR_MY"];
row["VAT_MY"] = data.Rows[i]["VAT_MY"];
row["ORDER_MY"] = data.Rows[i]["ORDER_MY"];
row["REPLACE_YN"] = data.Rows[i]["REPLACE_YN"];
row["LN_RMK"] = data.Rows[i]["LN_RMK"];
row["STOCK_CD"] = data.Rows[i]["STOCK_CD"];
row["ORDER_WT"] = data.Rows[i]["ORDER_WT"];
row["CUT_CNT"] = data.Rows[i]["CUT_CNT"];
row["SALES_GUBUN_CD"] = data.Rows[i]["SALES_GUBUN_CD"];
row["PAPER_CUST_CD"] = data.Rows[i]["PAPER_CUST_CD"];
row["STOCK_CNT"] = data.Rows[i]["STOCK_CNT"];
aData.Rows.Add(row);
};
aData.TableName = "ADATA";
if (aData.Rows.Count < 1)
{
throw new Exception((mode.Equals("I") ? "등록" : "수정") + "할 정보가 없습니다.");
}
ResultData data1 = new ResultData();
data1.TableData = aData;
ResultData[] dataList = new ResultData[] { data1 };
string out_pos = UtilClass.toStr(buttonEdit_OUT_POS.Text);
if (out_pos.Equals(""))
{
out_pos = buttonEdit_CUST_NM.Text.Trim();
}
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("ORDER_DT", SqlDbType.NVarChar, dateEdit_DATE.DateTime.ToString("yyyy.MM.dd")),
ClientClass.CreateSqlParameter("ORDER_SEQ", SqlDbType.NVarChar, order_seq),
ClientClass.CreateSqlParameter("PROC_CD", SqlDbType.NVarChar, lookUpEdit_PROC_CD.EditValue),
ClientClass.CreateSqlParameter("CUST_CD", SqlDbType.NVarChar, labelControl_CUST_CD.Text),
ClientClass.CreateSqlParameter("OUT_POS", SqlDbType.NVarChar, out_pos),
ClientClass.CreateSqlParameter("SIGN_GUBUN_CD", SqlDbType.NVarChar, lookUpEdit_SIGN_GUBUN_CD.EditValue),
ClientClass.CreateSqlParameter("OUT_AREA_CD", SqlDbType.NVarChar, lookUpEdit_OUT_AREA_CD.EditValue),
ClientClass.CreateSqlParameter("REG_ID", SqlDbType.NVarChar, ConstClass._USR_ID),
ClientClass.CreateSqlParameter("RESULT_STR", SqlDbType.NVarChar, "", ParameterDirection.Output, 1000)
};
ResultData resultData = ClientClass.SetTableData("SaveSaleRegistrationPopup", dataList, aParam);
if (resultData.isError)
{
throw new Exception(resultData.ResultValue);
}
m_Changed = true;
data.AcceptChanges();
this.Cursor = Cursors.Arrow;
if (!UtilClass.isNull(resultData.ResultValue))
{
MessageBox.Show(resultData.ResultValue);
}
else
{
MessageBox.Show((UtilClass.isEqual(mode, "I") ? "등록" : "수정") + " 완료.");
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
MessageBox.Show(ex.Message);
}
}
private void deleteProc()
{
try
{
if (UtilClass.isNull(m_ORDER_NO))
{
throw new Exception("조회된 자료가 없습니다.");
}
if (MessageBox.Show("해당 매출 자료를 삭제하시겠습니까?", "삭제", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
this.Cursor = Cursors.WaitCursor;
SerializedSqlParam[] aParam = new SerializedSqlParam[]
{
ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),
ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, m_ORDER_NO)
};
ResultData resultData = ClientClass.SetData("DeleteSaleRegistrationPopup", aParam);
if (resultData.isError)
{
throw new Exception(resultData.ResultValue);
}
m_Changed = true;
this.Cursor = Cursors.Arrow;
m_ORDER_NO = "";
MessageBox.Show("삭제 완료");
searchProc(0);
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
MessageBox.Show(ex.Message);
}
}
}
}
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855·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_J_SALE{partial class SaleRegistrationPopup : XtraForm{private string m_ORDER_NO;public bool m_Changed;public SaleRegistrationPopup(){InitializeComponent();this.Icon = ConstClass._MAIN.Icon;m_Changed = false;m_ORDER_NO = "";dateEdit_DATE.DateTime = DateTime.Now;buttonEdit_ORDER_SEQ.Text = "";buttonEdit_DC.ButtonClick += (sender, e) =>{if (UtilClass.isNull(labelControl_CUST_CD.Text)){MessageBox.Show("거래선을 먼저 조회하여 선택하십시오.");return;}SelectCustDCPopup form = new SelectCustDCPopup(labelControl_CUST_CD.Text, buttonEdit_CUST_NM.Text);form.ShowDialog();};buttonEdit_CUST_NM.KeyPress += (sender, e) =>{if (e.KeyChar == '\r'){selectCustProc();}};buttonEdit_CUST_NM.ButtonClick += (sender, e) =>{selectCustProc();};buttonEdit_ITEM_NM.ButtonClick += (sender, e) =>{SelectSalesItemForm form = new SelectSalesItemForm(buttonEdit_ITEM_NM.Text);if (form.ShowDialog() == DialogResult.Yes){buttonEdit_ITEM_NM.Text = form.m_ITEM_NM;buttonEdit_ITEM_NM.Tag = form.m_UNIT_MY;labelControl_ITEM_CD.Text = form.m_ITEM_CD;labelControl_ITEM_CD.Tag = form.m_ROUT_CD;textEdit_UNIT_WT.EditValue = form.m_UNIT_WT;textEdit_AREA_WT.Focus();}else{buttonEdit_ITEM_NM.Text = "";buttonEdit_ITEM_NM.Tag = 0;labelControl_ITEM_CD.Text = "";labelControl_ITEM_CD.Tag = "";textEdit_UNIT_WT.Text = "";}};buttonEdit_ITEM_NM.KeyPress += (sender, e) =>{if (e.KeyChar == '\r'){SelectSalesItemForm form = new SelectSalesItemForm(buttonEdit_ITEM_NM.Text);if (form.ShowDialog() == DialogResult.Yes){buttonEdit_ITEM_NM.Text = form.m_ITEM_NM;labelControl_ITEM_CD.Text = form.m_ITEM_CD;textEdit_UNIT_WT.EditValue = form.m_UNIT_WT;textEdit_AREA_WT.Focus();}else{buttonEdit_ITEM_NM.Text = "";labelControl_ITEM_CD.Text = "";textEdit_UNIT_WT.Text = "";}}};buttonEdit_SPEC.ButtonClick += (sender, e) =>{if (UtilClass.isNull(labelControl_ITEM_CD.Text)){buttonEdit_ITEM_NM.Focus();MessageBox.Show("품목을 선택하십시오.");return;}SelectNormForm form = new SelectNormForm(labelControl_ITEM_CD.Text);if (form.ShowDialog() == DialogResult.Yes){buttonEdit_SPEC.Text = form.m_NORM;textEdit_ORDER_QTY.Focus();}};buttonEdit_SPEC.KeyPress += (sender, e) =>{if (e.KeyChar == '\r'){SelectNormForm form = new SelectNormForm(labelControl_ITEM_CD.Text);if (form.ShowDialog() == DialogResult.Yes){buttonEdit_SPEC.Text = form.m_NORM;textEdit_ORDER_QTY.Focus();}}};buttonEdit_CUT_CNT.ButtonClick += (sender, e) =>{SelectCodePopup form = new SelectCodePopup("C", "C15", "절수");if (form.ShowDialog() == DialogResult.Yes){buttonEdit_CUT_CNT.Text = form.m_NO_CD_NM;textEdit_REMARK.Focus();}};textEdit_ORDER_QTY.EditValueChanged += (sender, e) =>{refreshCost();};buttonEdit_CURR_UNIT_MY.ButtonClick += (sender, e) =>{try{this.Cursor = Cursors.WaitCursor;if (UtilClass.isNull(labelControl_ITEM_CD.Text)){throw new Exception("품목코드 없이 단가조회를 할 수 없습니다. 품목을 조회하여 선택하십시오.");}buttonEdit_CURR_UNIT_MY.Text = "";SerializedSqlParam[] aParam = new SerializedSqlParam[]{ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),ClientClass.CreateSqlParameter("ITEM_CD", SqlDbType.NVarChar, labelControl_ITEM_CD.Text)};ResultData resultData = ClientClass.GetData("GetItemUnitMy", aParam);if (resultData.isError){throw new Exception(resultData.ResultValue);}if (resultData.TableData.Rows.Count > 0){buttonEdit_CURR_UNIT_MY.EditValue = resultData.TableData.Rows[0]["UNIT_MY"];}this.Cursor = Cursors.Arrow;}catch (Exception ex){this.Cursor = Cursors.Arrow;MessageBox.Show(ex.Message);}};buttonEdit_CURR_UNIT_MY.ButtonClick += (sender, e) =>{buttonEdit_CURR_UNIT_MY.EditValue = UtilClass.toDouble(buttonEdit_ITEM_NM.Tag);};buttonEdit_CURR_UNIT_MY.EditValueChanged += (sender, e) =>{refreshCost();};buttonEdit_ORDER_SEQ.KeyPress += (sender, e) =>{if (!UtilClass.isNull(buttonEdit_ORDER_SEQ.Text)){searchProc(3);}};buttonEdit_ORDER_SEQ.ButtonClick += (sender, e) =>{if (e.Button.Index == 0) // 기존정보 검색{OrderSeqPopup form = new OrderSeqPopup(dateEdit_DATE.DateTime);if (form.ShowDialog() == DialogResult.Yes){buttonEdit_ORDER_SEQ.Text = form.m_ORDER_SEQ;dateEdit_DATE.DateTime = UtilClass.toDateTime(form.m_ORDER_DT);searchProc(3);}}else if (e.Button.Index == 1) // 높은 번호 검색{searchProc(1);}else // 낮은 번호 검색{searchProc(2);}};buttonEdit_OUT_POS.KeyPress += (sender, e) =>{if (e.KeyChar == '\r'){if (UtilClass.isNull(buttonEdit_OUT_POS.Text)){if (!UtilClass.isNull(labelControl_CUST_CD.Text)){buttonEdit_OUT_POS.Text = buttonEdit_CUST_NM.Text;}}}};buttonEdit_OUT_POS.ButtonClick += (sender, e) =>{SelectOutPosForm form = new SelectOutPosForm(labelControl_CUST_CD.Text, buttonEdit_CUST_NM.Text);if (form.ShowDialog() == DialogResult.Yes){buttonEdit_OUT_POS.Text = form.m_LOCATION_NM;}else{buttonEdit_OUT_POS.Text = "";labelControl_OUT_POS.Text = "";}};simpleButton_AreaEdit.Click += (sender, e) =>{SelectCodePopup form = new SelectCodePopup("C", "C17", "지역");if (form.ShowDialog() == DialogResult.Yes){UtilClass.SetLookup(lookUpEdit_OUT_AREA_CD, form.m_Data, "NO_CD", "NO_CD_NM", true);lookUpEdit_OUT_AREA_CD.EditValue = form.m_NO_CD;}};simpleButton_Clear.Click += (sender, e) =>{clearProc();};simpleButton_ItemAdd.Click += (sender, e) =>{itemAddProc();};simpleButton_ItemUpdate.Click += (sender, e) =>{itemUpdateProc();};simpleButton_ItemDelete.Click += (sender, e) =>{itemDeleteProc();};simpleButton_ItemClose.Click += (sender, e) =>{itemCloseProc();};simpleButton_CANCEL.Click += (sender, e) =>{searchProc(0);};simpleButton_INPUT.Click += (sender, e) =>{saveProc("I", "");};simpleButton_UPDATE.Click += (sender, e) =>{saveProc("M", buttonEdit_ORDER_SEQ.Text);};simpleButton_DELETE.Click += (sender, e) =>{deleteProc();};simpleButton_CLOSE.Click += (sender, e) =>{this.DialogResult = m_Changed ? DialogResult.Yes : DialogResult.Cancel;this.Close();};gridView_Main.Click += (sender, e) =>{Point aPT = gridControl_Main.PointToClient(Control.MousePosition);GridHitInfo aInfo = gridView_Main.CalcHitInfo(aPT);if (aInfo.InRowCell){dataBinding();}};gridView_Main.FocusedRowChanged += (sender, e) =>{dataBinding();};this.Shown += (sender, e) =>{try{DataView c13 = new DataView(ConstClass._DATA);c13.RowFilter = "CATE_CD = 'C' and GRP_CD = 'C13'";UtilClass.SetLookup(lookUpEdit_PROC_CD, c13, "NO_CD", "NO_CD_NM", true);DataView c11 = new DataView(ConstClass._DATA);c11.RowFilter = "CATE_CD = 'C' and GRP_CD = 'C11'";UtilClass.SetLookup(lookUpEdit_STOCK, c11, "NO_CD", "NO_CD_NM", true);DataView c14 = new DataView(ConstClass._DATA);c14.RowFilter = "CATE_CD = 'C' and GRP_CD = 'C14'";UtilClass.SetLookup(lookUpEdit_UNIT_CD, c14, "NO_CD", "NO_CD_NM", true);DataView c16 = new DataView(ConstClass._DATA);c16.RowFilter = "CATE_CD = 'C' and GRP_CD = 'C16'";UtilClass.SetLookup(lookUpEdit_SIGN_GUBUN_CD, c16, "NO_CD", "NO_CD_NM", true);DataView c17 = new DataView(ConstClass._DATA);c17.RowFilter = "CATE_CD = 'C' and GRP_CD = 'C17'";UtilClass.SetLookup(lookUpEdit_OUT_AREA_CD, c17, "NO_CD", "NO_CD_NM", true);if (UtilClass.isNull(buttonEdit_ORDER_SEQ.Text)){searchProc(0);}else{searchProc(3);}}catch (Exception ex){this.Cursor = Cursors.Arrow;MessageBox.Show(ex.Message);}};}protected override bool ProcessCmdKey(ref Message msg, Keys keyData){if (keyData == (Keys.A | Keys.Alt)){searchProc(0);return true;}else if (keyData == (Keys.I | Keys.Alt)){saveProc("I", "");return true;}else if (keyData == (Keys.M | Keys.Alt)){saveProc("M", buttonEdit_ORDER_SEQ.Text);return true;}else if (keyData == (Keys.D | Keys.Alt)){deleteProc();return true;}else if (keyData == (Keys.X | Keys.Alt)){this.DialogResult = m_Changed ? DialogResult.Yes : DialogResult.Cancel;this.Close();return true;}else if (keyData == (Keys.F5)){itemAddProc();return true;}else if (keyData == (Keys.F6)){itemUpdateProc();return true;}else if (keyData == (Keys.F7)){itemDeleteProc();return true;}else if (keyData == (Keys.F8)){itemCloseProc();return true;}return base.ProcessCmdKey(ref msg, keyData);}public void setData(DateTime dt, string seq){dateEdit_DATE.DateTime = dt;buttonEdit_ORDER_SEQ.Text = seq;}private void itemAddProc(){try{if (UtilClass.isNull(labelControl_CUST_CD.Text)){buttonEdit_CUST_NM.Focus();throw new Exception("거래선을 조회하여 선택하십시오.");}if (UtilClass.isNull(labelControl_ITEM_CD.Text)){buttonEdit_ITEM_NM.Focus();throw new Exception("품목을 조회하여 선택하십시오.");}int r_no = 0, ln_seq = 0; ;DataTable data = gridControl_Main.DataSource as DataTable;for (int i = 0; i < data.Rows.Count; i++){if (data.Rows[i].RowState == DataRowState.Deleted){continue;}if (r_no < UtilClass.toInt(data.Rows[i]["R_NO"])){r_no = UtilClass.toInt(data.Rows[i]["R_NO"]);}if (ln_seq < UtilClass.toInt(data.Rows[i]["LN_SEQ"])){ln_seq = UtilClass.toInt(data.Rows[i]["LN_SEQ"]);}}r_no++;ln_seq++;DataRow row = data.NewRow();row["R_NO"] = r_no;row["LN_SEQ"] = ln_seq;row["ORDER_NO"] = "";row["ITEM_CD"] = labelControl_ITEM_CD.Text;row["ITEM_NM"] = buttonEdit_ITEM_NM.Text;row["ROUT_CD"] = labelControl_ITEM_CD.Tag;row["AREA_WT"] = textEdit_AREA_WT.Text;row["ORDER_NORM"] = buttonEdit_SPEC.Text.Trim();row["ORDER_QTY"] = UtilClass.toInt(textEdit_ORDER_QTY.EditValue);row["UNIT_NM"] = lookUpEdit_UNIT_CD.Text;row["DC_RATE"] = UtilClass.toDouble(textEdit_DC_RATE.EditValue);row["CURR_UNIT_MY"] = UtilClass.toInt(buttonEdit_CURR_UNIT_MY.EditValue);row["CURR_MY"] = UtilClass.toInt(textEdit_CURR_MY.EditValue);row["VAT_MY"] = UtilClass.toInt(textEdit_VAT_MY.EditValue);row["ORDER_MY"] = UtilClass.toInt(textEdit_ORDER_MY.EditValue);row["REPLACE_YN"] = "";row["LN_RMK"] = textEdit_REMARK.Text.Trim();row["STOCK_NM"] = lookUpEdit_STOCK.Text;row["ORDER_WT"] = UtilClass.toInt(textEdit_ORDER_QTY.EditValue) * UtilClass.toInt(textEdit_UNIT_WT.EditValue);row["CUT_CNT"] = buttonEdit_CUT_CNT.Text;row["SALES_GUBUN_NM"] = "";row["PAPER_CUST_NM"] = "";row["STOCK_CNT"] = 0;row["ORDER_UNIT_CD"] = lookUpEdit_UNIT_CD.EditValue;row["STOCK_CD"] = lookUpEdit_STOCK.EditValue;row["SALES_GUBUN_CD"] = "";row["PAPER_CUST_CD"] = "";row["BILL_NO"] = "";data.Rows.Add(row);}catch (Exception ex){MessageBox.Show(ex.Message);}}private void itemUpdateProc(){DataRow row = gridView_Main.GetFocusedDataRow();if (row == null){return;}row["ITEM_CD"] = labelControl_ITEM_CD.Text;row["ITEM_NM"] = buttonEdit_ITEM_NM.Text;row["ROUT_CD"] = labelControl_ITEM_CD.Tag;row["AREA_WT"] = textEdit_AREA_WT.Text;row["ORDER_NORM"] = buttonEdit_SPEC.Text.Trim();row["ORDER_QTY"] = UtilClass.toInt(textEdit_ORDER_QTY.EditValue);row["UNIT_NM"] = lookUpEdit_UNIT_CD.Text;row["DC_RATE"] = UtilClass.toDouble(textEdit_DC_RATE.EditValue);row["CURR_UNIT_MY"] = UtilClass.toInt(buttonEdit_CURR_UNIT_MY.EditValue);row["CURR_MY"] = UtilClass.toInt(textEdit_CURR_MY.EditValue);row["VAT_MY"] = UtilClass.toInt(textEdit_VAT_MY.EditValue);row["ORDER_MY"] = UtilClass.toInt(textEdit_ORDER_MY.EditValue);row["REPLACE_YN"] = "";row["LN_RMK"] = textEdit_REMARK.Text.Trim();row["STOCK_NM"] = lookUpEdit_STOCK.Text;row["ORDER_WT"] = UtilClass.toInt(textEdit_ORDER_QTY.EditValue) * UtilClass.toInt(textEdit_UNIT_WT.EditValue);row["CUT_CNT"] = buttonEdit_CUT_CNT.Text;row["SALES_GUBUN_NM"] = "";row["PAPER_CUST_NM"] = "";row["STOCK_CNT"] = 0;row["ORDER_UNIT_CD"] = lookUpEdit_UNIT_CD.EditValue;row["STOCK_CD"] = lookUpEdit_STOCK.EditValue;row["SALES_GUBUN_CD"] = "";row["PAPER_CUST_CD"] = "";}private void itemDeleteProc(){if (MessageBox.Show("선택하신 건 자료를 삭제하시겠습니까?", "삭제", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes){gridView_Main.DeleteSelectedRows();}}private void itemCloseProc(){buttonEdit_OUT_POS.Focus();}private void clearProc(){buttonEdit_ITEM_NM.Text = "";buttonEdit_ITEM_NM.Tag = 0;labelControl_ITEM_CD.Text = "";labelControl_ITEM_CD.Tag = "";textEdit_AREA_WT.Text = "";buttonEdit_SPEC.Text = "";textEdit_YearWT.Text = "";textEdit_ORDER_QTY.Text = "0";textEdit_UNIT_WT.Text = "0.0";lookUpEdit_UNIT_CD.ItemIndex = 0;buttonEdit_CUT_CNT.Text = "";textEdit_REMARK.Text = "";buttonEdit_STD_COST.Text = "";textEdit_DC_RATE.Text = "0.0";buttonEdit_CURR_UNIT_MY.Text = "0";textEdit_CURR_MY.Text = "0";textEdit_VAT_MY.Text = "0";textEdit_ORDER_MY.Text = "0";textEdit_BILL_NO.Text = "";}private void dataBinding(){DataRow row = gridView_Main.GetFocusedDataRow();if (row == null){clearProc();return;}buttonEdit_ITEM_NM.Text = UtilClass.toStr(row["ITEM_NM"]);buttonEdit_ITEM_NM.Tag = row["UNIT_MY"];labelControl_ITEM_CD.Text = UtilClass.toStr(row["ITEM_CD"]);labelControl_ITEM_CD.Tag = UtilClass.toStr(row["ROUT_CD"]);textEdit_AREA_WT.Text = UtilClass.toStr(row["AREA_WT"]);buttonEdit_SPEC.Text = UtilClass.toStr(row["ORDER_NORM"]);textEdit_YearWT.Text = "";textEdit_ORDER_QTY.EditValue = row["ORDER_QTY"];textEdit_UNIT_WT.EditValue = row["UNIT_WT"];lookUpEdit_UNIT_CD.EditValue = row["ORDER_UNIT_CD"];buttonEdit_CUT_CNT.Text = UtilClass.toStr(row["CUT_CNT"]);textEdit_REMARK.Text = UtilClass.toStr(row["LN_RMK"]);buttonEdit_STD_COST.Text = "";textEdit_DC_RATE.EditValue = row["DC_RATE"];buttonEdit_CURR_UNIT_MY.EditValue = row["CURR_UNIT_MY"];textEdit_CURR_MY.EditValue = row["CURR_MY"];textEdit_VAT_MY.EditValue = row["VAT_MY"];textEdit_ORDER_MY.EditValue = row["ORDER_MY"];textEdit_BILL_NO.EditValue = UtilClass.toStr(row["BILL_NO"]);}private void refreshCost(){int qty = UtilClass.toInt(textEdit_ORDER_QTY.EditValue);int unit_my = UtilClass.toInt(buttonEdit_CURR_UNIT_MY.EditValue);buttonEdit_CURR_UNIT_MY.EditValue = unit_my;textEdit_CURR_MY.EditValue = qty * unit_my;textEdit_VAT_MY.EditValue = (qty * unit_my) * 0.1;textEdit_ORDER_MY.EditValue = (qty * unit_my) + (qty * unit_my) * 0.1;}private void selectCustProc(){SelectCustomerForm form = new SelectCustomerForm(buttonEdit_CUST_NM.Text, DateTime.Now);if (form.ShowDialog() != System.Windows.Forms.DialogResult.Yes){return;}buttonEdit_CUST_NM.Text = form.m_CUST_NM;labelControl_CUST_CD.Text = form.m_CUST_CD;}private void searchProc(int mode){try{this.Cursor = Cursors.WaitCursor;gridControl_Main.DataSource = null;SerializedSqlParam[] aParam = new SerializedSqlParam[]{ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),ClientClass.CreateSqlParameter("ORDER_DT", SqlDbType.NVarChar, dateEdit_DATE.DateTime.ToString("yyyy.MM.dd")),ClientClass.CreateSqlParameter("ORDER_SEQ", SqlDbType.NVarChar, buttonEdit_ORDER_SEQ.Text),ClientClass.CreateSqlParameter("MODE", SqlDbType.Int, mode)};ResultData resultData = ClientClass.GetData("GetSaleRegistrationPopup", aParam);if (resultData.isError){throw new Exception(resultData.ResultValue);}m_ORDER_NO = "";if (resultData.DataList.Tables[0].Rows.Count > 0){m_ORDER_NO = UtilClass.toStr(resultData.DataList.Tables[0].Rows[0]["ORDER_NO"]);}gridControl_Main.DataSource = resultData.DataList.Tables[0];if (resultData.DataList.Tables[1].Rows.Count > 0){buttonEdit_OUT_POS.Text = UtilClass.toStr(resultData.DataList.Tables[1].Rows[0]["OUT_POS"]);lookUpEdit_SIGN_GUBUN_CD.EditValue = resultData.DataList.Tables[1].Rows[0]["SIGN_GUBUN_CD"];lookUpEdit_OUT_AREA_CD.EditValue = resultData.DataList.Tables[1].Rows[0]["OUT_AREA_CD"];buttonEdit_CUST_NM.Text = UtilClass.toStr(resultData.DataList.Tables[1].Rows[0]["CUST_NM"]);labelControl_CUST_CD.Text = UtilClass.toStr(resultData.DataList.Tables[1].Rows[0]["CUST_CD"]);}else{lookUpEdit_SIGN_GUBUN_CD.ItemIndex = 1;lookUpEdit_OUT_AREA_CD.ItemIndex = 0;buttonEdit_OUT_POS.Text = "";buttonEdit_CUST_NM.Text = "";labelControl_CUST_CD.Text = "";}if (resultData.DataList.Tables[2].Rows.Count > 0){buttonEdit_ORDER_SEQ.Text = UtilClass.toStr(resultData.DataList.Tables[2].Rows[0]["ORDER_SEQ"]);}else{buttonEdit_ORDER_SEQ.Text = "";}this.Cursor = Cursors.Arrow;if (mode > 0 && resultData.DataList.Tables[0].Rows.Count < 1){MessageBox.Show("해당 관리번호가 없습니다. 확인하시길 바랍니다.");}clearProc();}catch (Exception ex){this.Cursor = Cursors.Arrow;MessageBox.Show(ex.Message);}}private void saveProc(string mode, string order_seq){try{this.Cursor = Cursors.WaitCursor;if (UtilClass.isNull(labelControl_CUST_CD.Text)){buttonEdit_CUST_NM.Focus();throw new Exception("거래선을 조회하여 선택하십시오.");}if (mode.Equals("M") && UtilClass.isNull(order_seq)){buttonEdit_ORDER_SEQ.Focus();throw new Exception("수정할 관리번호가 없습니다.");}DataTable data = gridControl_Main.DataSource as DataTable;DataTable aData = new DataTable();aData.Columns.Add("LN_SEQ", typeof(int));aData.Columns.Add("ITEM_CD", typeof(string));aData.Columns.Add("ROUT_CD", typeof(string));aData.Columns.Add("AREA_WT", typeof(string));aData.Columns.Add("ORDER_NORM", typeof(string));aData.Columns.Add("ORDER_QTY", typeof(int));aData.Columns.Add("ORDER_UNIT_CD", typeof(string));aData.Columns.Add("DC_RATE", typeof(double));aData.Columns.Add("CURR_UNIT_MY", typeof(int));aData.Columns.Add("CURR_MY", typeof(int));aData.Columns.Add("VAT_MY", typeof(int));aData.Columns.Add("ORDER_MY", typeof(int));aData.Columns.Add("REPLACE_YN", typeof(string));aData.Columns.Add("LN_RMK", typeof(string));aData.Columns.Add("STOCK_CD", typeof(string));aData.Columns.Add("ORDER_WT", typeof(double));aData.Columns.Add("CUT_CNT", typeof(string));aData.Columns.Add("SALES_GUBUN_CD", typeof(string));aData.Columns.Add("PAPER_CUST_CD", typeof(string));aData.Columns.Add("STOCK_CNT", typeof(string));DataRow row;for (int i = 0; i < data.Rows.Count; i++){if (data.Rows[i].RowState == DataRowState.Deleted){continue;}row = aData.NewRow();row["LN_SEQ"] = data.Rows[i]["LN_SEQ"];row["ITEM_CD"] = data.Rows[i]["ITEM_CD"];row["ROUT_CD"] = data.Rows[i]["ROUT_CD"];row["AREA_WT"] = data.Rows[i]["AREA_WT"];row["ORDER_NORM"] = data.Rows[i]["ORDER_NORM"];row["ORDER_QTY"] = data.Rows[i]["ORDER_QTY"];row["ORDER_UNIT_CD"] = data.Rows[i]["ORDER_UNIT_CD"];row["DC_RATE"] = data.Rows[i]["DC_RATE"];row["CURR_UNIT_MY"] = data.Rows[i]["CURR_UNIT_MY"];row["CURR_MY"] = data.Rows[i]["CURR_MY"];row["VAT_MY"] = data.Rows[i]["VAT_MY"];row["ORDER_MY"] = data.Rows[i]["ORDER_MY"];row["REPLACE_YN"] = data.Rows[i]["REPLACE_YN"];row["LN_RMK"] = data.Rows[i]["LN_RMK"];row["STOCK_CD"] = data.Rows[i]["STOCK_CD"];row["ORDER_WT"] = data.Rows[i]["ORDER_WT"];row["CUT_CNT"] = data.Rows[i]["CUT_CNT"];row["SALES_GUBUN_CD"] = data.Rows[i]["SALES_GUBUN_CD"];row["PAPER_CUST_CD"] = data.Rows[i]["PAPER_CUST_CD"];row["STOCK_CNT"] = data.Rows[i]["STOCK_CNT"];aData.Rows.Add(row);};aData.TableName = "ADATA";if (aData.Rows.Count < 1){throw new Exception((mode.Equals("I") ? "등록" : "수정") + "할 정보가 없습니다.");}ResultData data1 = new ResultData();data1.TableData = aData;ResultData[] dataList = new ResultData[] { data1 };string out_pos = UtilClass.toStr(buttonEdit_OUT_POS.Text);if (out_pos.Equals("")){out_pos = buttonEdit_CUST_NM.Text.Trim();}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("ORDER_DT", SqlDbType.NVarChar, dateEdit_DATE.DateTime.ToString("yyyy.MM.dd")),ClientClass.CreateSqlParameter("ORDER_SEQ", SqlDbType.NVarChar, order_seq),ClientClass.CreateSqlParameter("PROC_CD", SqlDbType.NVarChar, lookUpEdit_PROC_CD.EditValue),ClientClass.CreateSqlParameter("CUST_CD", SqlDbType.NVarChar, labelControl_CUST_CD.Text),ClientClass.CreateSqlParameter("OUT_POS", SqlDbType.NVarChar, out_pos),ClientClass.CreateSqlParameter("SIGN_GUBUN_CD", SqlDbType.NVarChar, lookUpEdit_SIGN_GUBUN_CD.EditValue),ClientClass.CreateSqlParameter("OUT_AREA_CD", SqlDbType.NVarChar, lookUpEdit_OUT_AREA_CD.EditValue),ClientClass.CreateSqlParameter("REG_ID", SqlDbType.NVarChar, ConstClass._USR_ID),ClientClass.CreateSqlParameter("RESULT_STR", SqlDbType.NVarChar, "", ParameterDirection.Output, 1000)};ResultData resultData = ClientClass.SetTableData("SaveSaleRegistrationPopup", dataList, aParam);if (resultData.isError){throw new Exception(resultData.ResultValue);}m_Changed = true;data.AcceptChanges();this.Cursor = Cursors.Arrow;if (!UtilClass.isNull(resultData.ResultValue)){MessageBox.Show(resultData.ResultValue);}else{MessageBox.Show((UtilClass.isEqual(mode, "I") ? "등록" : "수정") + " 완료.");}}catch (Exception ex){this.Cursor = Cursors.Arrow;MessageBox.Show(ex.Message);}}private void deleteProc(){try{if (UtilClass.isNull(m_ORDER_NO)){throw new Exception("조회된 자료가 없습니다.");}if (MessageBox.Show("해당 매출 자료를 삭제하시겠습니까?", "삭제", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes){return;}this.Cursor = Cursors.WaitCursor;SerializedSqlParam[] aParam = new SerializedSqlParam[]{ClientClass.CreateSqlParameter("COMP_CD", SqlDbType.NVarChar, ConstClass._COMP_CD),ClientClass.CreateSqlParameter("ORDER_NO", SqlDbType.NVarChar, m_ORDER_NO)};ResultData resultData = ClientClass.SetData("DeleteSaleRegistrationPopup", aParam);if (resultData.isError){throw new Exception(resultData.ResultValue);}m_Changed = true;this.Cursor = Cursors.Arrow;m_ORDER_NO = "";MessageBox.Show("삭제 완료");searchProc(0);}catch (Exception ex){this.Cursor = Cursors.Arrow;MessageBox.Show(ex.Message);}}}}