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 Message OrderMoveFac(OrderState_VO vo)
{
List <WorkMOVE_VO> list = null;
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = @"insert into INSTACK(INS_QTY, INS_TYP, INS_WRHS, ITEM_CODE, SALES_WORK_ORDER_ID) values(@INS_QTY, '출고', @INS_WRHS, @ITEM_CODE, @SALES_WORK_ORDER_ID);
insert into INSTACK(INS_QTY, INS_TYP, INS_WRHS, ITEM_CODE, SALES_WORK_ORDER_ID) values(@INS_QTY, '입고', 'M_01', @ITEM_CODE, @SALES_WORK_ORDER_ID);
update WORKORDER set WO_WORK_STATE = '제품이동' where SALES_WORK_ORDER_ID = @SALES_WORK_ORDER_ID;";
cmd.Parameters.AddWithValue("@INS_QTY", vo.WO_QTY_OUT);
cmd.Parameters.AddWithValue("@INS_WRHS", vo.FAC_CODE);
cmd.Parameters.AddWithValue("@ITEM_CODE", vo.ITEM_CODE);
cmd.Parameters.AddWithValue("@SALES_WORK_ORDER_ID", vo.SALES_WORK_ORDER_ID);
cmd.Connection.Open();
int iResult = cmd.ExecuteNonQuery();
string result;
if (iResult > 0)
{
result = "S02";
}
else
{
result = "S00";
}
Message message = new Message();
if (result == "S02")
{
message.IsSuccess = true;
message.ResultMessage = "완료 되었습니다.";
}
else if (result == "S0")
{
message.IsSuccess = true;
message.ResultMessage = "실패하였습니다.";
}
return(message);
}
}
internal Message OrderMoveFac(OrderState_VO vo)
{
WorkOrderDAC dac = new WorkOrderDAC();
return(dac.OrderMoveFac(vo));
}