public void Search(object sender, EventArgs e)
{
try
{
string fromDATE;
string fromTO;
WorkOrderService service = new WorkOrderService();
dgvWorkRecordList.DataSource = null;
if (dtpFROM.Checked)
{
fromDATE = dtpFROM.Value.ToString("yyyy-MM-dd");
}
else
{
fromDATE = string.Empty;
}
if (dtpTO.Checked)
{
fromTO = dtpTO.Value.ToString("yyyy-MM-dd");
}
else
{
fromTO = string.Empty;
}
dgvWorkRecordList.DataSource = service.SearchWORKORDER(cboDATEtype.Text, fromDATE, fromTO, cboSTATE.Text);
}
catch (Exception err)
{
_logging = new LoggingUtility(this.Name, Level.Info, 30);
}
}
private void GetWorkMOVEInfo()
{
WorkOrderService service = new WorkOrderService();
dgvMOVEList.DataSource = null;
dgvMOVEList.DataSource = service.GetWorkMOVEInfo();
}
private void GetWorkOrderInfo()
{
WorkOrderService service = new WorkOrderService();
dgvWorkRecordList.DataSource = null;
dgvWorkRecordList.DataSource = service.GetWorkOrderInfo();
}
private void GetOrderInfo()
{
WorkOrderService service = new WorkOrderService();
dgvCustomerOrder.DataSource = null;
dgvCustomerOrder.DataSource = service.OrderList();
}
private void btnMOVE_Click(object sender, EventArgs e)
{
try
{
dgvMOVEList.EndEdit();
string state = dgvWorkRecordList.CurrentRow.Cells[8].Value.ToString();
if (state == "작업완료")
{
StringBuilder sb = new StringBuilder();
int cnt = 0;
//품목 선택후 List를 전달
foreach (DataGridViewRow item in dgvWorkRecordList.Rows)
{
if (Convert.ToBoolean(item.Cells[0].Value))
{
sb.Append(item.Cells[23].Value.ToString() + "@");
cnt++;
}
}
if (sb.Length < 1)
{
MessageBox.Show("실적등록할 항목을 선택하여 주십시오.");
return;
}
sb.Remove(sb.Length - 1, 1);
if (MessageBox.Show($"총 {cnt}개의 항목을 실적등록 하시겠습니까?", "실적등록", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
WorkOrderService service = new WorkOrderService();
Message msg = service.WorkMOVE(sb.ToString());
if (msg.IsSuccess)
{
MessageBox.Show(msg.ResultMessage);
GetWorkOrderInfo();
GetWorkMOVEInfo();
}
else
{
MessageBox.Show(msg.ResultMessage);
return;
}
}
}
else
{
MessageBox.Show("작업완료 상태만 실적등록이 가능합니다.");
return;
}
}
catch (Exception err)
{
_logging = new LoggingUtility(this.Name, Level.Info, 30);
}
}
public void Search(object sender, EventArgs e)
{
if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this)
{
try
{
WorkOrderService service = new WorkOrderService();
dgvList.DataSource = null;
dgvList.DataSource = service.SearchMOVELIST((cboWHouse.SelectedValue == null) ? "" : cboWHouse.SelectedValue.ToString(), cboType.Text, txtITEM_CODE.Text);
}
catch (Exception err)
{
_logging = new LoggingUtility(this.Name, Level.Info, 30);
}
}
}
private void btnWorkCancel_Click(object sender, EventArgs e)
{
//수정 시 여러개의 체크박스를 선택하는것을 막음
dgvCustomerOrder.EndEdit();
//string sb = string.Empty;
int cnt = 0;
//체크가 되었는지 확인
foreach (DataGridViewRow item in dgvCustomerOrder.Rows)
{
if (Convert.ToBoolean(item.Cells[0].Value))
{
cnt++;
}
}
if (cnt == 1) //하나일 경우 PopUp창 띄움
{
OrderState_VO vo = new OrderState_VO();
vo.SALES_WORK_ORDER_ID = dgvCustomerOrder.CurrentRow.Cells[8].Value.ToString();
vo.WO_QTY_OUT = Convert.ToInt32(dgvCustomerOrder.CurrentRow.Cells[6].Value);
vo.ITEM_CODE = dgvCustomerOrder.CurrentRow.Cells[1].Value.ToString();
vo.FAC_CODE = dgvCustomerOrder.CurrentRow.Cells[4].Value.ToString();
if (MessageBox.Show("작업완료 하시겠습니까?", "제품이동", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
WorkOrderService service = new WorkOrderService();
Message msg = service.OrderMoveFac(vo);
if (msg.IsSuccess)
{
MessageBox.Show(msg.ResultMessage);
GetOrderInfo();
}
else
{
MessageBox.Show(msg.ResultMessage);
return;
}
}
}
else
{
MessageBox.Show("하나의 항목씩만 가능합니다.");
return;
}
}
public void Search(object sender, EventArgs e)
{
try
{
if (dtpFrom.Value > dtpTo.Value)
{
MessageBox.Show("시작일이 종료일 보다 클 수 없습니다.");
return;
}
string fromDATE = dtpFrom.Value.ToString("yyyy-MM-dd");
string fromTO = dtpTo.Value.ToString("yyyy-MM-dd");
WorkOrderService service = new WorkOrderService();
dgvCustomerOrder.DataSource = null;
dgvCustomerOrder.DataSource = service.SearchOrderState(fromDATE, fromTO, txtITEM_CODE.Text);
}
catch (Exception err)
{
_logging = new LoggingUtility(this.Name, Level.Info, 30);
}
}
private void btnFinalWork_Click(object sender, EventArgs e)
{
try
{
//수정 시 여러개의 체크박스를 선택하는것을 막음
dgvMOVEList.EndEdit();
//string sb = string.Empty;
int cnt = 0;
//체크가 되었는지 확인
foreach (DataGridViewRow item in dgvMOVEList.Rows)
{
if (Convert.ToBoolean(item.Cells[0].Value))
{
cnt++;
}
}
if (cnt == 1) //하나일 경우 PopUp창 띄움
{
INSTACK_VO vo = new INSTACK_VO();
vo.SALES_WORK_ORDER_ID = dgvMOVEList.CurrentRow.Cells[8].Value.ToString();
vo.INS_QTY = Convert.ToInt32(dgvMOVEList.CurrentRow.Cells[6].Value);
vo.ITEM_CODE = dgvMOVEList.CurrentRow.Cells[1].Value.ToString();
if (MessageBox.Show("공정이동 하시겠습니까?", "공정이동", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (dgvMOVEList.CurrentRow.Cells[4].Value.ToString() == "OS")
{
vo.INS_WRHS = "OS";
WorkOrderService service = new WorkOrderService();
Message msg = service.InsertMoveUpdate(vo);
if (msg.IsSuccess)
{
MessageBox.Show(msg.ResultMessage);
GetWorkMOVEInfo();
}
else
{
MessageBox.Show(msg.ResultMessage);
return;
}
}
else
{
vo.INS_WRHS = "H_01";
WorkOrderService service = new WorkOrderService();
Message msg = service.InsertMoveUpdate(vo);
if (msg.IsSuccess)
{
MessageBox.Show(msg.ResultMessage);
GetWorkMOVEInfo();
}
else
{
MessageBox.Show(msg.ResultMessage);
return;
}
}
}
}
else
{
MessageBox.Show("하나의 항목씩만 공정이동 가능");
return;
}
}
catch (Exception err)
{
_logging = new LoggingUtility(this.Name, Level.Info, 30);
}
}
