public Message InsertMoveUpdate(INSTACK_VO vo)
{
Message message = new Message();
try
{
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);
update WORKORDER set WO_WORK_STATE = '공정이동' where SALES_Work_Order_ID = @SALES_WORK_ORDER_ID and ITEM_CODE = @ITEM_CODE;
insert into INSTACK(INS_QTY, INS_TYP, INS_WRHS, ITEM_CODE, SALES_WORK_ORDER_ID) values(@INS_QTY, '입고', 'H_01', @ITEM_CODE, @SALES_WORK_ORDER_ID);";
cmd.Parameters.AddWithValue("@INS_QTY", vo.INS_QTY);
cmd.Parameters.AddWithValue("@INS_WRHS", vo.INS_WRHS);
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";
}
if (result == "S02")
{
message.IsSuccess = true;
message.ResultMessage = "완료 되었습니다.";
}
else if (result == "S0")
{
message.IsSuccess = true;
message.ResultMessage = "실패하였습니다.";
}
}
}
catch (Exception err)
{
string str = err.Message;
}
return(message);
}
public Message InsertMoveUpdate(INSTACK_VO vo)
{
WorkOrderDAC dac = new WorkOrderDAC();
return(dac.InsertMoveUpdate(vo));
}
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);
}
}
